الموقع العربي الاول للعبة Silkroad Online

To add a Tab
[SPOILER]

كود PHP:

use [SRO_VT_SHARD_INIT] DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @TABNAME VARCHAR (30) DECLARE @TABNUMBER VARCHAR (30) DECLARE @TABNEW VARCHAR (30) DECLARE @GROUPNUMBER VARCHAR (30) DECLARE @GROUPNEW VARCHAR (30) -- SET @ADDNEW = 'TAB' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group! SET @CHARNAME = 'LasT_Queen' --U Char Name SET @NPCNAME = 'STATIC' --U NPC NAME SET @GROUPNUMBER = 1 SET @TABNUMBER = 4 SET @TABNAME = 'Hat' -- IF @TABNUMBER = 2 SET @TABNEW = '_TAB2' IF @TABNUMBER = 3 SET @TABNEW = '_TAB3' IF @TABNUMBER = 4 SET @TABNEW = '_TAB4' IF @GROUPNUMBER = 1 SET @GROUPNEW = '_GROUP1' IF @GROUPNUMBER = 2 SET @GROUPNEW = '_GROUP2' IF @GROUPNUMBER = 3 SET @GROUPNEW = '_GROUP3' IF @GROUPNUMBER = 4 SET @GROUPNEW = '_GROUP4' IF @GROUPNUMBER = 5 SET @GROUPNEW = '_GROUP5' IF @GROUPNUMBER = 6 SET @GROUPNEW = '_GROUP6' IF @ADDNEW = 'TAB' BEGIN SET IDENTITY_INSERT _RefShopTab ON DECLARE @ShopTabID VARCHAR (30) SET @ShopTabID = (SELECT MAX (ID) FROM _RefShopTab)+1 INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+@TABNEW,'STORE_'+@NPCNAME+@GROUPNEW,'SN_'+@TABNAME) SET IDENTITY_INSERT _RefShopTab OFF PRINT '' PRINT 'New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata' PRINT '1 15 '+@SHOPTABID+' STORE_'+@NPCNAME+@TABNEW+' STORE_'+@NPCNAME+@GROUPNEW+' SN_TAB_'+@TABNAME END

[/SPOILER]

To add a Group[SPOILER]

كود PHP:

DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @GROUPNUMBER VARCHAR (30) DECLARE @GROUPNEW VARCHAR (30) SET @CHARNAME = 'LasT_Queen' --U Char Name SET @NPCNAME = 'STATIC' --U NPC NAME SET @GROUPNUMBER = 2 SET @ADDNEW = 'GROUP' -- IF @GROUPNUMBER = 2 SET @GROUPNEW = '_GROUP2' IF @GROUPNUMBER = 3 SET @GROUPNEW = '_GROUP3' IF @GROUPNUMBER = 4 SET @GROUPNEW = '_GROUP4' IF @GROUPNUMBER = 5 SET @GROUPNEW = '_GROUP5' IF @GROUPNUMBER = 6 SET @GROUPNEW = '_GROUP6' IF @ADDNEW = 'GROUP' BEGIN SET IDENTITY_INSERT _RefShopTabGroup ON DECLARE @ShopTabGroupID VARCHAR (30) SET @ShopTabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+@GROUPNEW,'SN_STORE_'+@NPCNAME+@GROUPNEW) SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+@GROUPNEW) PRINT '' PRINT 'New Group Added Succesfully ' PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata' PRINT '1 15 '+@SHOPTABGROUPID+' STORE_'+@NPCNAME+@GROUPNEW+' SN_STORE_'+@NPCNAME+@GROUPNEW PRINT '' PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata' PRINT '1 15 STORE_'+@NPCNAME+' STORE_'+@NPCNAME+@GROUPNEW END

[/SPOILER]