Message System / Level Up / Item Destroy

[B1QB0SS]

Np about Guild master only , but we need reward be items and silk . there's no problem
btw i want your Skype...

okay i'll make reward items and silk

i'll send you my skype in PM

if you want to reward silk immediately use SRO_VT_ACCOUNT.CGI.CGI_WebPurchaseSilk to do so

greetz

i know : btw thanks

 

[lemoniscool]

so ... if you knew about this why was it a problem to reward silk then if you had the guild master being rewarded with items

 

[Madelyn]

if [USER=1333420483]event[/USER]ID = '22' and [USER=1333359883]data[/USER]2 = '110'declare [USER=551894]Char[/USER]Name16 varchar(64) = (Select CharName16 From SRO_VT_SHARD.._Char Where CharID = [USER=551894]Char[/USER]ID)
     begin
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [USER=551894]Char[/USER]Name16,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [USER=551894]Char[/USER]Name16,'ITEM_COS_P_CAT_SCROLL',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [USER=551894]Char[/USER]Name16,'ITEM_COS_P_FLUTE_WHITE_SMALL',1,1

This worng and not sure, why? Ok if you get a character 109 and pass to 110 with 1% EXP, and die like 10 times u get 109 again.. Do a bucle and the user will have premium and pets forever

 

[lemoniscool]

if [USER=1333420483]event[/USER]ID = '22' and [USER=1333359883]data[/USER]2 = '110'declare [USER=551894]Char[/USER]Name16 varchar(64) = (Select CharName16 From SRO_VT_SHARD.._Char Where CharID = [USER=551894]Char[/USER]ID)
     begin
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [USER=551894]Char[/USER]Name16,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [USER=551894]Char[/USER]Name16,'ITEM_COS_P_CAT_SCROLL',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN [USER=551894]Char[/USER]Name16,'ITEM_COS_P_FLUTE_WHITE_SMALL',1,1

This worng and not sure, why? Ok if you get a character 109 and pass to 110 with 1% EXP, and die like 10 times u get 109 again.. Do a bucle and the user will have premium and pets forever

well create a table with charid and a boolean stating if he got the reward already or not and check it in there ... no big deal ^^

 

[B1QB0SS]

well create a table with charid and a boolean stating if he got the reward already or not and check it in there ... no big deal ^^

exactly

if @[I][B][URL="http://forum.ragezone.com/members/1333420483.html"]event[/URL][/B][/I]ID = '22' and @[I][B][URL="http://forum.ragezone.com/members/1333359883.html"]data[/URL][/B][/I]2 = '110'declare @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16 varchar(64) = (Select CharName16 From SRO_VT_SHARD.._Char Where CharID = @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]ID)
     begin
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16,'ITEM_COS_P_CAT_SCROLL',1,1
      exec SRO_VT_SHARD.._ADD_ITEM_EXTERN @[I][B][URL="http://forum.ragezone.com/members/551894.html"]Char[/URL][/B][/I]Name16,'ITEM_COS_P_FLUTE_WHITE_SMALL',1,1

This worng and not sure, why? Ok if you get a character 109 and pass to 110 with 1% EXP, and die like 10 times u get 109 again.. Do a bucle and the user will have premium and pets forever

i'll create table to save CharID