[™DesertStorm™]

 		 			 use [SRO_VT_SHARD] 

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 = 'DieEyes' --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