npc جاهز

[MarOz]

انا عملتلو npc جاهز علشان فيي ناش مش بتعرف تعمل npc

Databasa

_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 Databasa

RefShop

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

Media And Databasa

RefShopGroup

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

Media And Databasa

RefShopTab

1 15 273 STORE_ITEM_D13_TAB1 STORE_ITEM_D13_GROUP1 SN_TAB_ITEM_D13CH

Media And Databasa

RefShopTabGroup


1 15 114 STORE_ITEM_D13_GROUP1 SN_ITEM_D13_GROUP1

Media And Databasa

_RefMappingShopGroup


1 15 GROUP_STORE_ITEM_D13 STORE_ITEM_D13



Media And Databasa

_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

[Hamza FiGo]

Approved

بس ظبط الموضوع يعني مثلا اسمها DataBase مش DataBesa ^^

وياريت لو صورة لمكان الــ NPC في جانجان

[mimolored]

thxxxx

[Xan]

يا ريت شرح اكتر

[Mando1995]

جميل أستمـــر :lighten:

[gameman]

missing chardata
عشان كدة هتعمل للناس مشكلة

[elfr3on2010]

مشكووووووووور