™AnTaKa™
18-09-2014, 01:43 PM
السلام عليكم
النهاردة هشرحلوكم كيف تغير مكان Npc با Query
اعمل Cher ووقفوا في المكان الي انت عايزو
1_افتح SQL
2_New Query
USE [SRO_VT_SHARD]
----------------------------Made By AnTaKa----------------------------
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
SET @KINGEDITOR1 = 'NPC_RANGO' ----- Your Npc Name
SET @CHARNAME = 'test2' ----- Charactar name [ where you Want to set npc ]
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
مكان
test2>>>>>اسم Cher الا وقفتووووو
NPC_RANGO>>>>>Coda NPC
وبعدين دوس F5
#End
:popcom::popcom:
النهاردة هشرحلوكم كيف تغير مكان Npc با Query
اعمل Cher ووقفوا في المكان الي انت عايزو
1_افتح SQL
2_New Query
USE [SRO_VT_SHARD]
----------------------------Made By AnTaKa----------------------------
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
SET @KINGEDITOR1 = 'NPC_RANGO' ----- Your Npc Name
SET @CHARNAME = 'test2' ----- Charactar name [ where you Want to set npc ]
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
مكان
test2>>>>>اسم Cher الا وقفتووووو
NPC_RANGO>>>>>Coda NPC
وبعدين دوس F5
#End
:popcom::popcom: