USE [SRO_VT_SHARD]
GO
DECLARE [USER=551894]Char[/USER]NAME VARCHAR (30)
DECLARE [USER=806871]NPC[/USER]NAME VARCHAR (30)
DECLARE [USER=1333458221]Add[/USER]NEW VARCHAR (30)
DECLARE @TABNAME VARCHAR (30)
DECLARE @TABNUMBER VARCHAR (30)
DECLARE @TABNEW VARCHAR (30)
DECLARE [USER=762167]Group[/USER]NUMBER VARCHAR (30)
DECLARE [USER=762167]Group[/USER]NEW VARCHAR (30)
DECLARE [USER=21783]Game[/USER]WORDID INT
SET [USER=1333458221]Add[/USER]NEW = 'NPC' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group!
SET [USER=551894]Char[/USER]NAME = 'MeTaD' --U Char Name
SET [USER=806871]NPC[/USER]NAME = 'MeTaD NPC' --U NPC NAME
SET [USER=21783]Game[/USER]WORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1
SET [USER=762167]Group[/USER]NUMBER = 1
SET @TABNUMBER = 2
SET @TABNAME = 'Items'
--
IF [USER=1333458221]Add[/USER]NEW = 'NPC' BEGIN
DECLARE [USER=447213]Max[/USER]LINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1
DECLARE [USER=1333395255]Maxcom[/USER]MONID VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjCommon)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country
,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius
,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1 [USER=1333395255]Maxcom[/USER]MONID,'NPC_' [USER=806871]NPC[/USER]NAME,'xxx','xxx','SN_NPC_' [USER=806871]NPC[/USER]NAME,'xxx',0,1,1,2,2,0,5000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'npc\npc\chinawoman_Noblegirl_event.bsr','xxx','xxx','xxx','xxx' [USER=447213]Max[/USER]LINK)
SET IDENTITY_INSERT _RefObjCommon OFF
SET IDENTITY_INSERT _RefObjChar ON
INSERT INTO _RefObjChar (ID,Lvl,CharGender,MaxHP,MaxMP,ResistFrozen,ResistFrostbite,ResistBurn,ResistEShock,ResistPoison,ResistZombie,ResistSleep,ResistRoot,ResistSlow,ResistFear
,ResistMyopia,ResistBlood,ResistStone,ResistDark,ResistStun,ResistDisea,ResistChaos,ResistCsePD,ResistCseMD,ResistCseSTR,ResistCseINT,ResistCseHP,ResistCseMP,Resist24,ResistBomb,Resist26
,Resist27,Resist28,Resist29,Resist30,Resist31,Resist32,InventorySize,CanStore_TID1,CanStore_TID2,CanStore_TID3,CanStore_TID4,CanBeVehicle,CanControl,DamagePortion,MaxPassenger,AssocTactics,PD,MD,PAR,MAR,ER,BR,HR,CHR
,ExpToGive,CreepType,Knockdown,KO_RecoverTime,DefaultSkill_1,DefaultSkill_2,DefaultSkill_3,DefaultSkill_4,DefaultSkill_5,DefaultSkill_6,DefaultSkill_7,DefaultSkill_8,DefaultSkill_9,DefaultSkill_10,TextureType,Except_1
,Except_2,Except_3,Except_4,Except_5,Except_6,Except_7,Except_8,Except_9,Except_10,Link) VALUES
[USER=447213]Max[/USER]LINK,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,336860180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
SET IDENTITY_INSERT _RefObjChar OFF
SET IDENTITY_INSERT _RefShop ON
DECLARE [USER=373843]shop[/USER]ID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShop)+1
INSERT INTO _RefShop (Service,Country,ID,CodeName128,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15 [USER=373843]shop[/USER]ID,'STORE_' [USER=806871]NPC[/USER]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShop OFF
SET IDENTITY_INSERT _RefShopGroup ON
DECLARE [USER=373843]shop[/USER]GroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopGroup)+1
INSERT INTO _RefShopGroup (Service,Country,ID,CodeName128,RefNPCCodeName,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15 [USER=373843]shop[/USER]GroupID,'GROUP_STORE_' [USER=806871]NPC[/USER]NAME,'NPC_' [USER=806871]NPC[/USER]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShopGroup OFF
SET IDENTITY_INSERT _RefShopItemGroup ON
DECLARE [USER=373843]shop[/USER]ItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group)
VALUES (1 [USER=373843]shop[/USER]ItemID,'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1','SN_STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopItemGroup OFF
SET IDENTITY_INSERT _RefShopTab ON
DECLARE [USER=373843]shop[/USER]TabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15 [USER=373843]shop[/USER]TabID,'STORE_' [USER=806871]NPC[/USER]NAME+'_TAB1','STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1','SN_TAB_WEAPON')
SET IDENTITY_INSERT _RefShopTab OFF
SET IDENTITY_INSERT _RefShopTabGroup ON
DECLARE [USER=373843]shop[/USER]TabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15 [USER=373843]shop[/USER]TabGroupID,'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1','SN_STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_' [USER=806871]NPC[/USER]NAME,'STORE_' [USER=806871]NPC[/USER]NAME)
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_' [USER=806871]NPC[/USER]NAME,'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1')
DECLARE [USER=441621]Tactic[/USER]SID INT SET [USER=441621]Tactic[/USER]SID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10
INSERT INTO Tab_RefTactics VALUES
[USER=441621]Tactic[/USER]SID [USER=1333395255]Maxcom[/USER]MONID,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'NPC_' [USER=806871]NPC[/USER]NAME)
DECLARE [USER=614210]Hive[/USER]ID INT SET [USER=614210]Hive[/USER]ID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
INSERT INTO Tab_RefHive VALUES
[USER=614210]Hive[/USER]ID,0,0,0,0,0,0 [USER=21783]Game[/USER]WORDID,2,'NPC_' [USER=806871]NPC[/USER]NAME)
DECLARE [USER=527330]region[/USER] VARCHAR (30) SET [USER=527330]region[/USER] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = [USER=551894]Char[/USER]NAME)
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = [USER=551894]Char[/USER]NAME)
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = [USER=551894]Char[/USER]NAME)
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = [USER=551894]Char[/USER]NAME)
DECLARE [USER=1333422837]Nesti[/USER]D INT SET [USER=1333422837]Nesti[/USER]D = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
INSERT INTO Tab_RefNest VALUES
[USER=1333422837]Nesti[/USER]D [USER=614210]Hive[/USER]ID [USER=441621]Tactic[/USER]SID [USER=527330]region[/USER],@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0)
PRINT 'add this line to characterdata_45000 @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 ' [USER=1333395255]Maxcom[/USER]MONID+' NPC_' [USER=806871]NPC[/USER]NAME+' xxx xxx '+'SN_NPC_' [USER=806871]NPC[/USER]NAME+' xxx 0 1 1 2 2 0 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 npc\npc\chinawoman_Noblegirl_event.bsr xxx xxx xxx xxx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 336860180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
PRINT ''
PRINT 'Add this line to refshop.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [USER=373843]shop[/USER]ID+' '+'STORE_' [USER=806871]NPC[/USER]NAME+' -1 xxx -1 xxx -1 xxx -1 xxx'
PRINT ''
PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [USER=373843]shop[/USER]GROUPID+' '+'GROUP_STORE_' [USER=806871]NPC[/USER]NAME+' '+'NPC_' [USER=806871]NPC[/USER]NAME+' -1 xxx -1 xxx -1 xxx -1 xxx'
PRINT ''
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 ' [USER=373843]shop[/USER]ITEMID+' '+'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1 '+'SN_STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [USER=373843]shop[/USER]TABID+' '+'STORE_' [USER=806871]NPC[/USER]NAME+'_TAB1 '+'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1 SN_TAB_WEAPONS'
PRINT ''
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [USER=373843]shop[/USER]TABGROUPID+' '+'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1 '+'SN_STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+'GROUP_STORE_' [USER=806871]NPC[/USER]NAME+' '+'STORE_' [USER=806871]NPC[/USER]NAME
PRINT ''
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+'STORE_' [USER=806871]NPC[/USER]NAME+' '+'STORE_' [USER=806871]NPC[/USER]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to textdata_object @ server_dep\silkroad\textdata'
PRINT ''
print '1 SN_NPC_' [USER=806871]NPC[/USER]NAME+' ' [USER=806871]NPC[/USER]NAME
print ''
PRINT 'A New NPC Has ADD Succesfuly Restart U Server and Login in ' [USER=551894]Char[/USER]NAME
END
IF @TABNUMBER = 2 SET @TABNEW = 'STORE_' [USER=806871]NPC[/USER]NAME+'_TAB2'
IF @TABNUMBER = 3 SET @TABNEW = 'STORE_' [USER=806871]NPC[/USER]NAME+'_TAB3'
IF @TABNUMBER = 4 SET @TABNEW = 'STORE_' [USER=806871]NPC[/USER]NAME+'_TAB4'
IF [USER=762167]Group[/USER]NUMBER = 2 SET [USER=762167]Group[/USER]NEW = '_GROUP2'
IF [USER=762167]Group[/USER]NUMBER = 3 SET [USER=762167]Group[/USER]NEW = '_GROUP3'
IF [USER=762167]Group[/USER]NUMBER = 4 SET [USER=762167]Group[/USER]NEW = '_GROUP4'
IF [USER=762167]Group[/USER]NUMBER = 5 SET [USER=762167]Group[/USER]NEW = '_GROUP5'
IF [USER=762167]Group[/USER]NUMBER = 6 SET [USER=762167]Group[/USER]NEW = '_GROUP6'
IF [USER=1333458221]Add[/USER]NEW = 'GROUP' BEGIN
SET IDENTITY_INSERT _RefShopTabGroup ON
SET [USER=373843]shop[/USER]TabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15 [USER=373843]shop[/USER]TabGroupID,'STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW,'SN_STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW)
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_' [USER=806871]NPC[/USER]NAME,'STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW)
PRINT ''
PRINT 'New Group Added Succesfully '
PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT '1 15 ' [USER=373843]shop[/USER]TABGROUPID+' STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW+' SN_STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW
PRINT ''
PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT '1 15 STORE_' [USER=806871]NPC[/USER]NAME+' STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW
END
IF [USER=1333458221]Add[/USER]NEW = 'TAB' BEGIN
IF [USER=762167]Group[/USER]NUMBER = 1 SET [USER=762167]Group[/USER]NEW = '_GROUP1'
SET IDENTITY_INSERT _RefShopTab ON
SET [USER=373843]shop[/USER]TabID = (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15 [USER=373843]shop[/USER]TabID,@TABNEW,'STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW,'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 ' [USER=373843]shop[/USER]TABID+' STORE_' [USER=806871]NPC[/USER]NAME+@TABNEW+' STORE_' [USER=806871]NPC[/USER]NAME [USER=762167]Group[/USER]NEW+' SN_TAB_'+@TABNAME
END
IF @TABNUMBER > 4 BEGIN
PRINT '@TABNUMBER value does not exist. u must add 2 , 3 OR 4 Tabs Per NPC!'
END
IF [USER=762167]Group[/USER]NUMBER > 8 BEGIN
PRINT [USER=762167]Group[/USER]NUMBER value does not exist. u must add 1 , 2 , 3 , 4 , 5 , 6 , 7 OR 8 Groups!'
END
IF [USER=1333458221]Add[/USER]NEW = '' BEGIN
PRINT [USER=1333458221]Add[/USER]NEW value does not exist. u must set values NPC , TAB , GROUP'
END
/******************************* Best Query By Statiic don't Re-Release Under u Name*******************************/