[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