[VSRO]Starter Items

Page 1 of 2 1 2
12/18/2011 11:12 ffflashgamerrr#1
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
12/18/2011 11:25 xBongosx#2
In dbo._ADD_ITEM_EXTERN
12/18/2011 14:23 ffflashgamerrr#3
in my database there is no dbo._ADD_ITEM_EXTERN
must i create it?
12/18/2011 14:33 18andLife#4
you can add the starter items in _AddNewChar
12/18/2011 14:46 IceAmStiel#5
"_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
12/18/2011 14:49 ffflashgamerrr#6
hm i didnt have _AddNewChar
maybe i must create it?
or its another table?
12/18/2011 15:17 JENZO#7
Quote:
Originally Posted by ffflashgamerrr View Post
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...
12/18/2011 15:21 penelopee#8
He dont know where the table is -.-"

Quote:
Go MSSQL -> Shard DB -> Programmability -> Saved Procedures -> dbo._AddNewChar
Just use you brain, before you post.
12/18/2011 16:45 ffflashgamerrr#9
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?
12/18/2011 17:13 IceAmStiel#10
Well simply sth like..
PHP Code:
UPDATE _Char SET RemainSkillPoint = 100000 WHERE CharName16 = @CharName
UPDATE _Char SET RemainGold = 100000 WHERE CharName16 = @CharName 
also @ _AddNewChar
12/18/2011 18:27 ffflashgamerrr#11
thanks again it works fine =)
01/08/2012 22:10 ffflashgamerrr#12
how can i add silks to starter items?
01/10/2012 00:51 EstComplex2#13
and skill point :S
11/07/2013 21:43 bajica#14
How to add avatar depending on created chars gender?
11/16/2013 22:34 InPanic~Honey#15
Quote:
Originally Posted by ffflashgamerrr View Post
how can i add silks to starter items?
add this to dbo._AddNewChar

Code:
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
Page 1 of 2 1 2