Initially Silk Giving (The Easy Way)

[denise456]

HI friends come easy
we want to give up some code originally silk

INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own) VALUES (@UserJID, 500);

Type the amount of silk in 500 by

First, right click SRO_VT_SHARD-Programmability-Stored Procedures-_AddNewChar do modify our code and write the place shown in the picture are doing Execute

[MentaL]

[chinowyc]

This is for a new char?

[denise456]

Yes Bro

[lembo12]

this for new user not char !!

[mesoman]

not work 0silk

[Caipi]

If you try to insert an already existing JID it'll return an error since the table doesn't support dublicated keys - this will probably break the execution of the procedure and will end up in a mess.

You should check at first if the account already exists @ SK_Silk before inserting any rows.

[LogiN]

Easy and without much inquiry.

StoredProcedure [dbo].[_AddNewChar]
simply replaced.

INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,       
                LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID, HwanLevel)       
    VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,       
                GetDate(), 1, 1, 5000000000, 0, 1000000, 200,200, 1, 1, 1, 1, 0)

GetDate
5000000000 "GOLD"
1000000 "SkillPoints"

change it to what you want to give or simply place it on "0"

To give items in the inventory.

INSERT _CharNameList VALUES(@CharName, @NewCharID)        
      -- Example of some items.   
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1      
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1  
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',100,1
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',100,1    
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1 
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1      
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_HIT_SUPER_SCROLL',10,1 
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_EVATION_SUPER_SCROLL',10,1 
	exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL',10,1

Result


Good Luck!
LoGiN®

[antoha]

If(select count(*) from sk_silk = 0)
Begin
Insert into sk_silk(jid, silk_own) values (@UserJid, '500')
End else
begin
Update sk_silk set silk_own = silk_own + 500 where jid = @UserJid
End 

This should work better, change the 500 to the value of silk u wanna give.

Soz made a whoopsy with the if statment, replce it qith

If ((select count(*) from sk_silk where jid = @UserJid) = 0) 

[chinowyc]

Yes Bro

Thanks bro :) Exelent thx for shared.

[mesoman]

thx bro <33

[swo]

This could be placed with a scroll?

- - - Updated - - -

Easy and without much inquiry.

StoredProcedure [dbo].[_AddNewChar]
simply replaced.

INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,       
                LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID, HwanLevel)       
    VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,       
                GetDate(), 1, 1, 5000000000, 0, 1000000, 200,200, 1, 1, 1, 1, 0)

GetDate
5000000000 "GOLD"
1000000 "SkillPoints"

change it to what you want to give or simply place it on "0"

To give items in the inventory.

INSERT _CharNameList VALUES(@CharName, @NewCharID)        
      -- Example of some items.   
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1      
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1  
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',100,1
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',100,1    
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',5,1      
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_HIT_SUPER_SCROLL',10,1 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_EVATION_SUPER_SCROLL',10,1 
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL',10,1

Result


Good Luck!
LoGiN®

This could be placed with a scroll?