مشكله بعداضافه npc جديد

[محمد_احمد]

كل ما اضيف new npc الجيم يخرج

[Dangers SrO]

تم الموافقه
/*****/
اتاكد من الLine الانتا حطتها في الMedia

[MarOz]

اشتغل بي الكوير دة

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) DECLARE @GAMEWORDID INT SET @ADDNEW = 'NPC' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group! SET @CHARNAME = 'Zenger' --U Char Name SET @NPCNAME = 'Seller' --U NPC NAME SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1 SET @GROUPNUMBER = 2 SET @TABNUMBER = 3 SET @TABNAME = 'SPECIAL' -- IMPORTANY WRITE IT -- SET @GROUPNEW = 'RARE' --IMPORTANT WRITE IT -- -- IF @ADDNEW = 'NPC' 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,'NPC_'+@NPCNAME,'xxx','xxx','SN_NPC_'+@NPCNAME,'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,'mob\jupiter\fanaticism2.bsr','xxx','xxx','xxx','xxx',@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,'STORE_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') 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,'GROUP_STORE_'+@NPCNAME,'NPC_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx') 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,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1') 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,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_WEAPON') 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,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1') SET IDENTITY_INSERT _RefShopTabGroup OFF INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_'+@NPCNAME,'STORE_'+@NPCNAME) INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+'_GROUP1') 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,'NPC_'+@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,'NPC_'+@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 'add this line to characterdata_45000 @ server_dep\silkroad\textdata' PRINT '' PRINT '1 '+@MAXCOMMONID+' '+'NPC_'+@NPCNAME+' xxx xxx '+'SN_NPC_'+@NPCNAME+' 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 '+@SHOPID+' '+'STORE_'+@NPCNAME+' -1 xxx -1 xxx -1 xxx -1 xxx' PRINT '' PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 15 '+@SHOPGROUPID+' '+'GROUP_STORE_'+@NPCNAME+' '+'NPC_'+@NPCNAME+' -1 xxx -1 xxx -1 xxx -1 xxx' PRINT '' PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 '+@SHOPITEMID+' '+'STORE_'+@NPCNAME+'_GROUP1 '+'SN_STORE_'+@NPCNAME+'_GROUP1' PRINT '' PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 15 '+@SHOPTABID+' '+'STORE_'+@NPCNAME+'_TAB1 '+'STORE_'+@NPCNAME+'_GROUP1 SN_TAB_WEAPONS' PRINT '' PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 15 '+@SHOPTABGROUPID+' '+'STORE_'+@NPCNAME+'_GROUP1 '+'SN_STORE_'+@NPCNAME+'_GROUP1' PRINT '' PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 15 '+'GROUP_STORE_'+@NPCNAME+' '+'STORE_'+@NPCNAME PRINT '' PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 15 '+'STORE_'+@NPCNAME+' '+'STORE_'+@NPCNAME+'_GROUP1' PRINT '' PRINT 'Add this line to textuisystem.txt @ server_dep\silkroad\textdata' PRINT '' PRINT '1 SN_STORE_NPCNAME_GROUP1 ?? ???? ??/?? 0 0 0 0 0 0 '+@GROUPNEW PRINT '' PRINT '1 SN_TAB_WEAPONS ?? 0 0 0 0 0 0 '+@TABNAME+' 0 0 0 0 0 0' PRINT '' PRINT 'Add this line to textdata_object @ server_dep\silkroad\textdata' PRINT '' PRINT '1 '+'SN_NPC_'+@NPCNAME+' '+@NPCNAME PRINT '' PRINT '' PRINT '---------- Best Edits By Midget1337 + ™_Muslim_™ Dont Realise it Under your Name On S4A ----------' END

[محمد_احمد]

الLine تمام

نفس المشكله برده عند استخدام هذا الكوير

[MarOz]

في line مش صح في Media راجع علي Line

[محمد_احمد]

اضيف Media Line كلاتى

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

[Dangers SrO]

الline دا معناها انك بضيف بprnamg Vsro NPC
استخدم الQuery احسن

[محمد_احمد]

منا جربت الطريقتان و نفس المشكله لا اعرف لماذا

هل هذه الطريقه صحيحها ؟

1) _RefObjCommon 1 41845 NPC_Test xxx xxx SN_NPC_Test 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\khotanshop_smith.bsr xxx xxx xxx xxx 21425 2) _RefObjChar 21425 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 3) Tab_RefHive 1574 0 0 0 0 0 0 1 2 NPC E£?? 4) Tab_RefTactics 46061 41845 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_Test 5) Tab_RefNest 36831 1574 46061 25000 600 -106.789261 1430 0 0 0 0 0 0 1 0 1 0 6) _RefShop 1 15 2643 STORE_Test -1 xxx -1 xxx -1 xxx -1 xxx 7)_RefShopGroup 1 15 2815 GROUP_STORE_Test NPC_Test -1 xxx -1 xxx -1 xxx -1 xxx 8) _RefShopItemGroup 1 82 STORE_Test_GROUP1 SN_STORE_Test_GROUP1 9) _RefShoptab 1 15 6417 STORE_Test_TAB1 STORE_Test_GROUP1 SN_TAB_WEAPON 10)_RefShopTabGroup 1 15 2832 STORE_Test_GROUP1 SN_Test_STATIIC_GROUP1 11) _RefMappingShopGroup 1 15 GROUP_STORE_Test STORE_Test 12) RefMappingShopWithTab 1 15 STORE_Test STORE_Test_GROUP1 Media line characterdata_45000 1 41845 NPC_Test xxx xxx SN_NPC_Test 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\khotanshop_smith.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 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 textdata_object.txt 1 SN_NPC_Test Test

[MarOz]

انا عملتلك npc جاهز

Databesa

_RefObjCommon

1 44343 NPC_ITEM_D13 xxx xxx SN_NPC_ITEM_D13 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\arabia_armor.bsr xxx xxx xxx xxx 20917

_RefObjItem

20917 1 0 0 0 58 0 93 140 1473.4 1548.5 38 14 72 0 0 0 0 0 0 2881.4 3028.2 74.3 0 0 0 1222 1349 2607 2879 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 ITEM_EU_W_CLOTHES_20_SA_A_RARE 1 ITEM_EU_W_CLOTHES_20_SA_B_RARE 1 ITEM_EU_W_CLOTHES_20_SA_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_AR_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0 0

Media And Databesa

RefShop

1 15 98 STORE_ITEM_D13 -1 xxx -1 xxx -1 xxx -1 xxx

Media And Databesa

RefShopGroup

1 15 115 GROUP_STORE_ITEM_D13 NPC_ITEM_D13 -1 xxx -1 xxx -1 xxx -1 xxx

Media And Databesa

RefShopTab

1 15 273 STORE_ITEM_D13_TAB1 STORE_ITEM_D13_GROUP1 SN_TAB_ITEM_D13CH

Media And Databesa

RefShopTabGroup

1 15 114 STORE_ITEM_D13_GROUP1 SN_ITEM_D13_GROUP1

Media And Databesa

_RefMappingShopGroup

1 15 GROUP_STORE_ITEM_D13 STORE_ITEM_D13

Media And Databesa

_RefMappingShopWithTab

1 15 STORE_ITEM_D13 STORE_ITEM_D13_GROUP1

Tab_RefHive

1711 0 0 0 0 0 0 1 2 NPC_ITEM_D13

Tab_RefTactics

46268 44665 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_ITEM_D13

Tab_RefNest

17681 1711 46268 25000 980 -16.6172981 1488 0 0 0 0 0 0 1 0 1 0

مكان NPC في Jangan

و لو عاوز تنقلو

USE [SRO_VT_SHARD] DECLARE @KINGEDITOR1 VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) SET @KINGEDITOR1 = 'NPC_Arshivel' SET @CHARNAME = 'Mero' Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1) Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1) Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2) Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME) Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME) Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME) Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME) UPDATE Tab_RefNest SET nregiondbid = @ASpos1, flocalposx = @ASpos2, flocalposy = @ASpos3, flocalposz = @ASpos4 WHERE dwnestid = @AS3 and dwtacticsid = @AS2

اي استفسار انا في الخدمة

[محمد_احمد]

شكرآ جزيلآ لكن فى اى مسار فى Media ؟

[MarOz]

مسارات المديا

Media and databesa

RefShop

1 15 98 STORE_ITEM_D13 -1 xxx -1 xxx -1 xxx -1 xxx

Media And Databesa

RefShopGroup

1 15 115 GROUP_STORE_ITEM_D13 NPC_ITEM_D13 -1 xxx -1 xxx -1 xxx -1 xxx

Media And Databesa

RefShopTab

1 15 273 STORE_ITEM_D13_TAB1 STORE_ITEM_D13_GROUP1 SN_TAB_ITEM_D13CH

Media And Databesa

RefShopTabGroup

1 15 114 STORE_ITEM_D13_GROUP1 SN_ITEM_D13_GROUP1

Media And Databesa

_RefMappingShopGroup

1 15 GROUP_STORE_ITEM_D13 STORE_ITEM_D13

Media And Databesa

_RefMappingShopWithTab

1 15 STORE_ITEM_D13 STORE_ITEM_D13_GROUP1

[محمد_احمد]

اقصد

RefShop

كود:
1 15 98 STORE_ITEM_D13 -1 xxx -1 xxx -1 xxx -1
فى المديا يكون فى مثلآ characterdata_5000