[Neoon]

ودا ان بي سي جاهز لو عايز

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