NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^

[Statiic]

<div class="bbWrapper">so guys my 2st Query i learning so i think it is better <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" /><br /> <br /> 1º set indentity propety in this tables <br /> _RefObjCommon,_RefObjChar,_RefShop,_RefShopGroup,_RefShopItemGroup,_RefShopTab,_RefShopTabGroup.<br /> <br /> go Tools &gt; Options... &gt; Designers &gt; and Clean &quot;Prevent saving changes that require table re-creation&quot; .<br /> now<br /> _RefObjCommon &gt; Design &gt; right click ID Column Set a primary key &gt; Column Properties &gt; Indetity Spercification &gt; (Is Indetity) set &quot;Yes&quot; same with the others.<br /> <span style="color: #FF0000">NOW DO THE SAME WITH Tab_RefHive and Tab_RefNest BUT SET INDENTITY OFF </span><br /> ok now u can exec the querys without any errro<br /> <br /> <br /> <br /> <br /> NPC<br /> <br /> <div class="bbCodeBlock bbCodeBlock--screenLimited bbCodeBlock--code"> <div class="bbCodeBlock-title"> PHP: </div> <div class="bbCodeBlock-content" dir="ltr"> <pre class="bbCodeCode" dir="ltr" data-xf-init="ozzmodz-cbhj-code-block" data-lang="php"><code>DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @GAMEWORDID INT SET @CHARNAME = &#039;DW&#039; --U Char Name SET @NPCNAME = &#039;1&#039; --U NPC NAME SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1 SET @ADDNEW = &#039;NPC&#039; -- IF @ADDNEW = &#039;NPC&#039; BEGIN DECLARE @MAXLINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1 DECLARE @MAXCOMMONID 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,@MAXCOMMONID,&#039;NPC_&#039;+@NPCNAME,&#039;xxx&#039;,&#039;xxx&#039;,&#039;SN_NPC_&#039;+@NPCNAME,&#039;xxx&#039;,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,&#039;npc\npc\chinawoman_Noblegirl_event.bsr&#039;,&#039;xxx&#039;,&#039;xxx&#039;,&#039;xxx&#039;,&#039;xxx&#039;,@MAXLINK) 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 (@MAXLINK,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 @ShopID 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,@ShopID,&#039;STORE_&#039;+@NPCNAME,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;) SET IDENTITY_INSERT _RefShop OFF SET IDENTITY_INSERT _RefShopGroup ON DECLARE @ShopGroupID 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,@ShopGroupID,&#039;GROUP_STORE_&#039;+@NPCNAME,&#039;NPC_&#039;+@NPCNAME,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;) SET IDENTITY_INSERT _RefShopGroup OFF SET IDENTITY_INSERT _RefShopItemGroup ON DECLARE @ShopItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1 INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group) VALUES (1,@ShopItemID,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;,&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;) SET IDENTITY_INSERT _RefShopItemGroup OFF SET IDENTITY_INSERT _RefShopTab ON DECLARE @ShopTabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1 INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) VALUES (1,15,@ShopTabID,&#039;STORE_&#039;+@NPCNAME+&#039;_TAB1&#039;,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;,&#039;SN_TAB_WEAPON&#039;) SET IDENTITY_INSERT _RefShopTab OFF SET IDENTITY_INSERT _RefShopTabGroup ON DECLARE @ShopTabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) VALUES (1,15,@ShopTabGroupID,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;,&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;) SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopGroup VALUES (1,15,&#039;GROUP_STORE_&#039;+@NPCNAME,&#039;STORE_&#039;+@NPCNAME) INSERT INTO _RefMappingShopWithTab VALUES (1,15,&#039;STORE_&#039;+@NPCNAME,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;) DECLARE @TACTICSID INT SET @TACTICSID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10 INSERT INTO Tab_RefTactics VALUES (@TACTICSID,@MAXCOMMONID,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,&#039;NPC_&#039;+@NPCNAME) BEGIN DECLARE @HIVEID INT SET @HIVEID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 INSERT INTO Tab_RefHive VALUES (@HIVEID,0,0,0,0,0,0,@GAMEWORDID,2,&#039;NPC_&#039;+@NPCNAME) END BEGIN DECLARE @REGION VARCHAR (30) SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @NESTID INT SET @NESTID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 INSERT INTO Tab_RefNest VALUES (@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0) END PRINT &#039;add this line to characterdata_45000 @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 &#039;+@MAXCOMMONID+&#039; &#039;+@NPCNAME+&#039; xxx xxx &#039;+&#039;SN_NPC_&#039;+@NPCNAME+&#039; 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&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshop.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039; -1 xxx -1 xxx -1 xxx -1 xxx&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshopgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPGROUPID+&#039; &#039;+&#039;GROUP_STORE_&#039;+@NPCNAME+&#039; &#039;+&#039;NPC_&#039;+@NPCNAME+&#039; -1 xxx -1 xxx -1 xxx -1 xxx&#039; PRINT &#039;&#039; PRINT &#039;Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 &#039;+@SHOPITEMID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1 &#039;+&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshoptab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPTABID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_TAB1 &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1 SN_TAB_WEAPONS&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPTABGROUPID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1 &#039;+&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+&#039;GROUP_STORE_&#039;+@NPCNAME+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME PRINT &#039;&#039; PRINT &#039;Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+&#039;STORE_&#039;+@NPCNAME+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039; PRINT &#039;&#039; PRINT &#039;A New NPC Has ADD Succesfuly Restart U Server and Login in &#039;+@CHARNAME END</code></pre> </div> </div><br /> TAB<br /> <br /> <div class="bbCodeBlock bbCodeBlock--screenLimited bbCodeBlock--code"> <div class="bbCodeBlock-title"> PHP: </div> <div class="bbCodeBlock-content" dir="ltr"> <pre class="bbCodeCode" dir="ltr" data-xf-init="ozzmodz-cbhj-code-block" data-lang="php"><code>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 = &#039;TAB&#039; -- &#039;NPC&#039; to add a new npc, &#039;TAB&#039; for add a new Tab, &#039;GROUP&#039; for add a new group! SET @CHARNAME = &#039;[GM] STATIIC&#039; --U Char Name SET @NPCNAME = &#039;STATIIC&#039; --U NPC NAME SET @GROUPNUMBER = 1 SET @TABNUMBER = 4 SET @TABNAME = &#039;TEST&#039; -- IF @TABNUMBER = 2 SET @TABNEW = &#039;_TAB2&#039; IF @TABNUMBER = 3 SET @TABNEW = &#039;_TAB3&#039; IF @TABNUMBER = 4 SET @TABNEW = &#039;_TAB4&#039; IF @GROUPNUMBER = 1 SET @GROUPNEW = &#039;_GROUP1&#039; IF @GROUPNUMBER = 2 SET @GROUPNEW = &#039;_GROUP2&#039; IF @GROUPNUMBER = 3 SET @GROUPNEW = &#039;_GROUP3&#039; IF @GROUPNUMBER = 4 SET @GROUPNEW = &#039;_GROUP4&#039; IF @GROUPNUMBER = 5 SET @GROUPNEW = &#039;_GROUP5&#039; IF @GROUPNUMBER = 6 SET @GROUPNEW = &#039;_GROUP6&#039; IF @ADDNEW = &#039;TAB&#039; 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,&#039;STORE_&#039;+@NPCNAME+@TABNEW,&#039;STORE_&#039;+@NPCNAME+@GROUPNEW,&#039;SN_&#039;+@TABNAME) SET IDENTITY_INSERT _RefShopTab OFF PRINT &#039;&#039; PRINT &#039;New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;1 15 &#039;+@SHOPTABID+&#039; STORE_&#039;+@NPCNAME+@TABNEW+&#039; STORE_&#039;+@NPCNAME+@GROUPNEW+&#039; SN_TAB_&#039;+@TABNAME END</code></pre> </div> </div><br /> GROUP <br /> <br /> <div class="bbCodeBlock bbCodeBlock--screenLimited bbCodeBlock--code"> <div class="bbCodeBlock-title"> PHP: </div> <div class="bbCodeBlock-content" dir="ltr"> <pre class="bbCodeCode" dir="ltr" data-xf-init="ozzmodz-cbhj-code-block" data-lang="php"><code>DECLARE @CHARNAME VARCHAR (30) DECLARE @NPCNAME VARCHAR (30) DECLARE @ADDNEW VARCHAR (30) DECLARE @GROUPNUMBER VARCHAR (30) DECLARE @GROUPNEW VARCHAR (30) SET @CHARNAME = &#039;[GM] TIEKO&#039; --U Char Name SET @NPCNAME = &#039;STATIC&#039; --U NPC NAME SET @GROUPNUMBER = 2 SET @ADDNEW = &#039;GROUP&#039; -- IF @GROUPNUMBER = 2 SET @GROUPNEW = &#039;_GROUP2&#039; IF @GROUPNUMBER = 3 SET @GROUPNEW = &#039;_GROUP3&#039; IF @GROUPNUMBER = 4 SET @GROUPNEW = &#039;_GROUP4&#039; IF @GROUPNUMBER = 5 SET @GROUPNEW = &#039;_GROUP5&#039; IF @GROUPNUMBER = 6 SET @GROUPNEW = &#039;_GROUP6&#039; IF @ADDNEW = &#039;GROUP&#039; 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,&#039;STORE_&#039;+@NPCNAME+@GROUPNEW,&#039;SN_STORE_&#039;+@NPCNAME+@GROUPNEW) SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopWithTab VALUES (1,15,&#039;STORE_&#039;+@NPCNAME,&#039;STORE_&#039;+@NPCNAME+@GROUPNEW) PRINT &#039;&#039; PRINT &#039;New Group Added Succesfully &#039; PRINT &#039;add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;1 15 &#039;+@SHOPTABGROUPID+&#039; STORE_&#039;+@NPCNAME+@GROUPNEW+&#039; SN_STORE_&#039;+@NPCNAME+@GROUPNEW PRINT &#039;&#039; PRINT &#039;add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;1 15 STORE_&#039;+@NPCNAME+&#039; STORE_&#039;+@NPCNAME+@GROUPNEW END</code></pre> </div> </div><br /> All in one<br /> <div class="bbCodeSpoiler"> <button type="button" class="button bbCodeSpoiler-button" data-xf-click="toggle" data-xf-init="tooltip" title="Click to reveal or hide spoiler"><span class="button-text"> <span>Spoiler</span> </span></button> <div class="bbCodeSpoiler-content"> <div class="bbCodeBlock bbCodeBlock--spoiler"> <div class="bbCodeBlock-content"> <div class="bbCodeBlock bbCodeBlock--screenLimited bbCodeBlock--code"> <div class="bbCodeBlock-title"> PHP: </div> <div class="bbCodeBlock-content" dir="ltr"> <pre class="bbCodeCode" dir="ltr" data-xf-init="ozzmodz-cbhj-code-block" data-lang="php"><code> 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) DECLARE @GAMEWORDID INT SET @ADDNEW = &#039;NPC&#039; -- &#039;NPC&#039; to add a new npc, &#039;TAB&#039; for add a new Tab, &#039;GROUP&#039; for add a new group! SET @CHARNAME = &#039;[GM] STATIIC&#039; --U Char Name SET @NPCNAME = &#039;STATIIC&#039; --U NPC NAME SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1 SET @GROUPNUMBER = 1 SET @TABNUMBER = 2 SET @TABNAME = &#039;DRESS&#039; -- IF @ADDNEW = &#039;NPC&#039; BEGIN DECLARE @MAXLINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1 DECLARE @MAXCOMMONID 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,@MAXCOMMONID,&#039;NPC_&#039;+@NPCNAME,&#039;xxx&#039;,&#039;xxx&#039;,&#039;SN_NPC_&#039;+@NPCNAME,&#039;xxx&#039;,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,&#039;npc\npc\chinawoman_Noblegirl_event.bsr&#039;,&#039;xxx&#039;,&#039;xxx&#039;,&#039;xxx&#039;,&#039;xxx&#039;,@MAXLINK) 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 (@MAXLINK,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 @ShopID 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,@ShopID,&#039;STORE_&#039;+@NPCNAME,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;) SET IDENTITY_INSERT _RefShop OFF SET IDENTITY_INSERT _RefShopGroup ON DECLARE @ShopGroupID 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,@ShopGroupID,&#039;GROUP_STORE_&#039;+@NPCNAME,&#039;NPC_&#039;+@NPCNAME,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;,-1,&#039;xxx&#039;) SET IDENTITY_INSERT _RefShopGroup OFF SET IDENTITY_INSERT _RefShopItemGroup ON DECLARE @ShopItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1 INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group) VALUES (1,@ShopItemID,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;,&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;) SET IDENTITY_INSERT _RefShopItemGroup OFF SET IDENTITY_INSERT _RefShopTab ON DECLARE @ShopTabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1 INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) VALUES (1,15,@ShopTabID,&#039;STORE_&#039;+@NPCNAME+&#039;_TAB1&#039;,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;,&#039;SN_TAB_WEAPON&#039;) SET IDENTITY_INSERT _RefShopTab OFF SET IDENTITY_INSERT _RefShopTabGroup ON DECLARE @ShopTabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) VALUES (1,15,@ShopTabGroupID,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;,&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;) SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopGroup VALUES (1,15,&#039;GROUP_STORE_&#039;+@NPCNAME,&#039;STORE_&#039;+@NPCNAME) INSERT INTO _RefMappingShopWithTab VALUES (1,15,&#039;STORE_&#039;+@NPCNAME,&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039;) DECLARE @TACTICSID INT SET @TACTICSID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10 INSERT INTO Tab_RefTactics VALUES (@TACTICSID,@MAXCOMMONID,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,&#039;NPC_&#039;+@NPCNAME) DECLARE @HIVEID INT SET @HIVEID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1 INSERT INTO Tab_RefHive VALUES (@HIVEID,0,0,0,0,0,0,@GAMEWORDID,2,&#039;NPC_&#039;+@NPCNAME) DECLARE @REGION VARCHAR (30) SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @NESTID INT SET @NESTID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1 INSERT INTO Tab_RefNest VALUES (@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0) PRINT &#039;add this line to characterdata_45000 @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 &#039;+@MAXCOMMONID+&#039; &#039;+@NPCNAME+&#039; xxx xxx &#039;+&#039;SN_NPC_&#039;+@NPCNAME+&#039; 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&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshop.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039; -1 xxx -1 xxx -1 xxx -1 xxx&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshopgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPGROUPID+&#039; &#039;+&#039;GROUP_STORE_&#039;+@NPCNAME+&#039; &#039;+&#039;NPC_&#039;+@NPCNAME+&#039; -1 xxx -1 xxx -1 xxx -1 xxx&#039; PRINT &#039;&#039; PRINT &#039;Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 &#039;+@SHOPITEMID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1 &#039;+&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshoptab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPTABID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_TAB1 &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1 SN_TAB_WEAPONS&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+@SHOPTABGROUPID+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1 &#039;+&#039;SN_STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039; PRINT &#039;&#039; PRINT &#039;Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+&#039;GROUP_STORE_&#039;+@NPCNAME+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME PRINT &#039;&#039; PRINT &#039;Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;&#039; PRINT &#039;1 15 &#039;+&#039;STORE_&#039;+@NPCNAME+&#039; &#039;+&#039;STORE_&#039;+@NPCNAME+&#039;_GROUP1&#039; PRINT &#039;&#039; PRINT &#039;A New NPC Has ADD Succesfuly Restart U Server and Login in &#039;+@CHARNAME END IF @TABNUMBER = 2 SET @TABNEW = &#039;STORE_&#039;+@NPCNAME+&#039;_TAB2&#039; IF @TABNUMBER = 3 SET @TABNEW = &#039;STORE_&#039;+@NPCNAME+&#039;_TAB3&#039; IF @TABNUMBER = 4 SET @TABNEW = &#039;STORE_&#039;+@NPCNAME+&#039;_TAB4&#039; IF @GROUPNUMBER = 2 SET @GROUPNEW = &#039;_GROUP2&#039; IF @GROUPNUMBER = 3 SET @GROUPNEW = &#039;_GROUP3&#039; IF @GROUPNUMBER = 4 SET @GROUPNEW = &#039;_GROUP4&#039; IF @GROUPNUMBER = 5 SET @GROUPNEW = &#039;_GROUP5&#039; IF @GROUPNUMBER = 6 SET @GROUPNEW = &#039;_GROUP6&#039; IF @ADDNEW = &#039;GROUP&#039; BEGIN SET IDENTITY_INSERT _RefShopTabGroup ON SET @ShopTabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) VALUES (1,15,@ShopTabGroupID,&#039;STORE_&#039;+@NPCNAME+@GROUPNEW,&#039;SN_STORE_&#039;+@NPCNAME+@GROUPNEW) SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopWithTab VALUES (1,15,&#039;STORE_&#039;+@NPCNAME,&#039;STORE_&#039;+@NPCNAME+@GROUPNEW) PRINT &#039;&#039; PRINT &#039;New Group Added Succesfully &#039; PRINT &#039;add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;1 15 &#039;+@SHOPTABGROUPID+&#039; STORE_&#039;+@NPCNAME+@GROUPNEW+&#039; SN_STORE_&#039;+@NPCNAME+@GROUPNEW PRINT &#039;&#039; PRINT &#039;add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;1 15 STORE_&#039;+@NPCNAME+&#039; STORE_&#039;+@NPCNAME+@GROUPNEW END IF @ADDNEW = &#039;TAB&#039; BEGIN IF @GROUPNUMBER = 1 SET @GROUPNEW = &#039;_GROUP1&#039; SET IDENTITY_INSERT _RefShopTab ON SET @ShopTabID = (SELECT MAX (ID) FROM _RefShopTab)+1 INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) VALUES (1,15,@ShopTabID,@TABNEW,&#039;STORE_&#039;+@NPCNAME+@GROUPNEW,&#039;SN_&#039;+@TABNAME) SET IDENTITY_INSERT _RefShopTab OFF PRINT &#039;&#039; PRINT &#039;New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata&#039; PRINT &#039;1 15 &#039;+@SHOPTABID+&#039; STORE_&#039;+@NPCNAME+@TABNEW+&#039; STORE_&#039;+@NPCNAME+@GROUPNEW+&#039; SN_TAB_&#039;+@TABNAME END IF @TABNUMBER &gt; 4 BEGIN PRINT &#039;@TABNUMBER value does not exist. u must add 2 , 3 OR 4 Tabs Per NPC!&#039; END IF @GROUPNUMBER &gt; 8 BEGIN PRINT &#039;@GROUPNUMBER value does not exist. u must add 1 , 2 , 3 , 4 , 5 , 6 , 7 OR 8 Groups!&#039; END IF @ADDNEW = &#039;&#039; BEGIN PRINT &#039;@ADDNEW value does not exist. u must set values NPC , TAB , GROUP&#039; END /******************************* Best Query By Statiic don&#039;t Re-Release Under u Name*******************************/</code></pre> </div> </div></div> </div> </div> </div><br /> <br /> how to use<br /> for add a new npc only...<br /> fist go with u char to here u want add a new npc<br /> after exec<br /> SET @CHARNAME = &#039;[GM] Statiic&#039; --U Char Name<br /> SET @NPCNAME = &#039;STATIIC&#039; --U NPC NAME<br /> SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITY&#039;s = 1<br /> SET @ADDNEW = &#039;NPC&#039;<br /> <br /> <br /> a New Tab <br /> SET @GROUPNUMBER = 1 --The Group want add a new tab<br /> SET @TABNUMBER = 2 --Tab Number if u group already have 1 tab set 2 u must set 2,3,4!<br /> SET @TABNAME = &#039;DRESS&#039; --Tab Name<br /> SET @ADDNEW = &#039;TAB&#039;<br /> <br /> <br /> New Group<br /> SET @GROUPNUMBER = 2 -- SET 2 if u npc already have 1 group u must add 2-6 new groups<br /> SET @TABNAME = &#039;DRESS&#039;<br /> SET @ADDNEW = &#039;GROUP&#039;<br /> <br /> Print<br /> <div class="bbCodeSpoiler"> <button type="button" class="button bbCodeSpoiler-button" data-xf-click="toggle" data-xf-init="tooltip" title="Click to reveal or hide spoiler"><span class="button-text"> <span>Spoiler</span> </span></button> <div class="bbCodeSpoiler-content"> <div class="bbCodeBlock bbCodeBlock--spoiler"> <div class="bbCodeBlock-content">(1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> <br /> (1 row(s) affected)<br /> add this line to characterdata_45000 @ server_dep\silkroad\textdata<br /> <br /> 1 44681 STATIIC xxx xxx SN_NPC_STATIIC 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<br /> <br /> Add this line to refshop.txt @ server_dep\silkroad\textdata<br /> <br /> 1 15 3042 STORE_STATIIC -1 xxx -1 xxx -1 xxx -1 xxx<br /> <br /> Add this line to refshopgroup.txt @ server_dep\silkroad\textdata<br /> <br /> 1 15 3306 GROUP_STORE_STATIIC NPC_STATIIC -1 xxx -1 xxx -1 xxx -1 xxx<br /> <br /> Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata<br /> <br /> 1 84 STORE_STATIIC_GROUP1 SN_STORE_STATIIC_GROUP1<br /> <br /> Add this line to refshoptab.txt @ server_dep\silkroad\textdata<br /> <br /> 1 15 7631 STORE_STATIIC_TAB1 STORE_STATIIC_GROUP1 SN_TAB_WEAPONS<br /> <br /> Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata<br /> <br /> 1 15 3343 STORE_STATIIC_GROUP1 SN_STORE_STATIIC_GROUP1<br /> <br /> Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata<br /> <br /> 1 15 GROUP_STORE_STATIIC STORE_STATIIC<br /> <br /> Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata<br /> <br /> 1 15 STORE_STATIIC STORE_STATIIC_GROUP1<br /> <br /> A New NPC Has ADD Succesfuly Restart U Server and Login in [GM] Tieko</div> </div> </div> </div>Found a erro? post here thx!<br /> Query by me <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" /><br /> Have Fun! <img src="/data/assets/smilies/1000064768.gif" class="smilie" loading="lazy" alt=":laugh:" title="Laugh :laugh:" data-shortname=":laugh:" /></div>

 

[safty0202]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> (1 row(s) affected)<br /> Msg 8106, Level 16, State 1, Line 30<br /> Table &#039;_RefObjChar&#039; does not have the identity property. Cannot perform SET operation.</div>

 

[Statiic]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> if u database dont have indenity do this in u tables<br /> <br /> <blockquote data-attributes="member: 1333382236" data-quote="Statiic" data-source="post: 6970660" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/goto/post?id=6970660" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-6970660">Statiic said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> _RefObjCommon &gt; Design &gt; right click ID Column Set a primary key &gt; Column Properties &gt; Indetity Spercification &gt; (Is Indetity) set &quot;Yes&quot; done. same with others tables like _RefObjChar And _RefObjItem<br /> <br /> when u use a db created in mssql 2008 r2 and the owner convert to sql 2005 primary key and indexes is removed automatic </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote>@edit<br /> tables to set Indetity Spercification <br /> _RefObjCommon,_RefObjChar,_RefShop,_RefShopGroup,_RefShopItemGroup,_RefShopTab,_RefShopTabGroup...</div>

 

[GiannyRockZ]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> If I try to change my Identify specifications,I get this error<br /> <script class="js-extraPhrases" type="application/json"> { "lightbox_close": "Close", "lightbox_next": "Next", "lightbox_previous": "Previous", "lightbox_error": "The requested content cannot be loaded. Please try again later.", "lightbox_start_slideshow": "Start slideshow", "lightbox_stop_slideshow": "Stop slideshow", "lightbox_full_screen": "Full screen", "lightbox_thumbnails": "Thumbnails", "lightbox_download": "Download", "lightbox_share": "Share", "lightbox_zoom": "Zoom", "lightbox_new_window": "New window", "lightbox_toggle_sidebar": "Toggle sidebar" } </script> <div class="bbImageWrapper lazyload js-lbImage" title="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" data-src="http://img7.imagebanana.com/img/5su3cd5n/err.png" data-lb-sidebar-href="" data-lb-caption-extra-html="" data-single-image="1"> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="http://img7.imagebanana.com/img/5su3cd5n/err.png" data-url="http://img7.imagebanana.com/img/5su3cd5n/err.png" class="bbImage lazyload" data-zoom-target="1" style="" alt="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" title="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" width="" height="" /> <noscript><img src="http://img7.imagebanana.com/img/5su3cd5n/err.png" data-url="http://img7.imagebanana.com/img/5su3cd5n/err.png" class="bbImage" data-zoom-target="1" style="" alt="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" title="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" width="" height="" /></noscript> </div><br /> <br /> Mkay, Found solution by myself.<br /> If anyone else got this error ,just untick that:<br /> <div class="bbImageWrapper lazyload js-lbImage" title="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" data-src="http://img6.imagebanana.com/img/37i6jcm1/solved.png" data-lb-sidebar-href="" data-lb-caption-extra-html="" data-single-image="1"> <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-src="http://img6.imagebanana.com/img/37i6jcm1/solved.png" data-url="http://img6.imagebanana.com/img/37i6jcm1/solved.png" class="bbImage lazyload" data-zoom-target="1" style="" alt="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" title="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" width="" height="" /> <noscript><img src="http://img6.imagebanana.com/img/37i6jcm1/solved.png" data-url="http://img6.imagebanana.com/img/37i6jcm1/solved.png" class="bbImage" data-zoom-target="1" style="" alt="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" title="Statiic - NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^ - RaGEZONE Forums" width="" height="" /></noscript> </div><br /> <br /> <b>Now my sro_client just closes after I start the game :/ Cant even come to loginscreen,just crashes at start</b><br /> <br /> the error must be in the media,because when I use the unedited media again,then I can start the client...</div>

 

[nukertube]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> good relese <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin :D" data-smilie="8"data-shortname=":D" /></div>

 

[3d2000]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> Nice one <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin :D" data-smilie="8"data-shortname=":D" />D thanks</div>

 

[liphon]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> Msg 8106, Level 16, State 1, Line 23<br /> Table &#039;_RefObjCommon&#039; does not have the identity property. Cannot perform SET operation.<br /> <br /> any idea ?</div>

 

[Kira]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> Very Nice Work My teacher <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" /><br /> <br /> But i am very sad , Coz i just finished all my NPC &quot; but i like ur share &quot; will some ppl <img src="/data/assets/smilies/thumbsup.gif" class="smilie" loading="lazy" alt=":thumbup:" title="Cooler Thumbs Up :thumbup:" data-shortname=":thumbup:" /></div>

 

[kingahmed69]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> useful thank you</div>

 

[atossuper]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> Very useful , keep going guys with your perfect release that make our life more easier and save our time and a lot mistakes<br /> <br /> <b>Problem found when try to execute the sql query</b><br /> Msg 208, Level 16, State 1, Line 11<br /> Invalid object name &#039;_RefObjChar&#039;.<br /> <br /> #Fixed by editing first line into the Query <br /> USE [SRO_VT_SHARD_INIT]<br /> ==============================<br /> <b>Another problem </b><br /> after done first query with media edit, got a msg <br /> <b>&quot;CharID dont differ with link from RefObjChr</b></div>

 

[AppleBery]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> lol its so awesome <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin :D" data-smilie="8"data-shortname=":D" /> thx!</div>

 

[Statiic]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> I did this just for me to use then you try to learn the structure of that query ^^</div>

 

[atossuper]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> <blockquote data-attributes="member: 1333382236" data-quote="Statiic" data-source="post: 7051014" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/goto/post?id=7051014" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-7051014">Statiic said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> I did this just for me to use then you try to learn the structure of that query ^^ </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> So its not a public Query Lol it has no sense if it will work only with you, not need to release it then!! Or at lease you can edit it for work on all database, better for me to do my query better than keep reading all your query and understand what all exactly!!<br /> I hope im not rude couse im not , just your comment pissed me off.<br /> P.S: &quot;Found a erro? post here thx!&quot; i did what you asked for !!</div>

 

[Statiic]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> lol its works but if u tables dont have Indetity Spercification u will get erros <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin :D" data-smilie="8"data-shortname=":D" /><br /> what a mean with this &quot; I did this just for me to use then you try to learn the structure of that query ^^&quot;<br /> 1º Me<br /> 2° RageZone <br /> lol <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin :D" data-smilie="8"data-shortname=":D" /></div>

 

[AppleBery]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> <blockquote data-attributes="member: 1333410715" data-quote="atossuper" data-source="post: 7051054" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/goto/post?id=7051054" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-7051054">atossuper said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> So its not a public Query Lol it has no sense if it will work only with you, not need to release it then!! Or at lease you can edit it for work on all database, better for me to do my query better than keep reading all your query and understand what all exactly!!<br /> I hope im not rude couse im not , just your comment pissed me off.<br /> P.S: &quot;Found a erro? post here thx!&quot; i did what you asked for !! </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> u can create u owns querys too..<br /> this works for me.</div>

 

[BryanSA]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> Very nice statiic <img src="/data/assets/smilies/thumbup1.gif" class="smilie" loading="lazy" alt=":thumbup1:" title="Thumbs up! :thumbup1:" data-shortname=":thumbup1:" /></div>

 

[liphon]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> A New NPC Has ADD Succesfuly Restart U Server and Login <br /> Thnak you Stattic</div>

 

[safty0202]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> the media lines is worng guys cuz the client keep crashing ! ?</div>

 

[elitebi]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> Thanks for the query<br /> <br /> How I can add more than 1 page each tab? it only shows 1 page per tab, how I can make it 3 pages?</div>

 

[GiannyRockZ]

<div class="bbWrapper"><b>Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^</b><br /> <br /> did this work for anyone?<br /> Because me and some friends tried it and none of us got it working,seems the media lines are wrong because if I change them in media my client crashes,if I use a normal media my client works until I go near the location of the npc,then i get a crash.....:/</div>