[VSRO]Starter Items

[ffflashgamerrr]

Hey guys,
i just wanna know how can i change in VSRO files the starter items?
for example:
Standart Starter Items are 2x Exp Helper and 20x Return Scrolls.
I wanna change it to SP and Gold and avatar etc.

i hope anyone can help me

[xBongosx]

In dbo._ADD_ITEM_EXTERN

[ffflashgamerrr]

in my database there is no dbo._ADD_ITEM_EXTERN
must i create it?

[18andLife]

you can add the starter items in _AddNewChar

[IceAmStiel]

"_ADD_ITEM_EXTERN" is a Stored Procedure of SRO_VT_SHARD, you can use it within the SP of _AddNewChar to add like you stated a Dress as a startup item e.g.

PHP Code:

exec _ADD_ITEM_EXTERN Caipi,'ITEM_EVENT_AVATAR_M_CH_WEDDING_HAT',1,1 


Caipi = Char Nickname
ITEM_EVENT_AVATAR_M_CH_WEDDING_HAT = Spawncode
1 = Quantity e.g. 50 for like 50 Potions
1 = +value e.g. for an Item use '12' and it'll appear as +12 in your inventory

[ffflashgamerrr]

hm i didnt have _AddNewChar
maybe i must create it?
or its another table?

[JENZO]

Originally Posted by ffflashgamerrr

hm i didnt have _AddNewChar
maybe i must create it?
or its another table?

u must have this Tab,if u didnt have it ur database Is incorrect and use another one...

[penelopee]

He dont know where the table is -.-"

Go MSSQL -> Shard DB -> Programmability -> Saved Procedures -> dbo._AddNewChar

Just use you brain, before you post.

[ffflashgamerrr]

thx penelopee and IceAmStiel i very thanksfull about your post.
i added now some items and it works fine,
but i have one question
how can i add Skillpoints and Gold to starter items?

[IceAmStiel]

Well simply sth like..

PHP Code:

UPDATE _Char SET RemainSkillPoint = 100000 WHERE CharName16 = @CharName
UPDATE _Char SET RemainGold = 100000 WHERE CharName16 = @CharName 


also @ _AddNewChar

[ffflashgamerrr]

thanks again it works fine =)

[ffflashgamerrr]

how can i add silks to starter items?

[EstComplex2]

and skill point :S

[bajica]

How to add avatar depending on created chars gender?

[InPanic~Honey]

Originally Posted by ffflashgamerrr

how can i add silks to starter items?

add this to dbo._AddNewChar

IF not exists (SELECT 1 FROM SRO_VT_ACCOUNT.dbo.SK_Silk WHERE JID = @UserJID)
	BEGIN
		-- Query by InPanic Kev
		declare @startsilk int 
		set @startsilk = '100000' -- Enter Silk Amount There :D
		INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk SELECT @UserJID, @startsilk, 0, 0
	END