حل للمشكلة دي فى RefNest

[Dev.Ri3o]

انت كاتب رقم غير مسموح , بى وقف Char فى المكان اللى انت عايزو واقفلو وبعدها استخدم ال Query ده بعدها Restart لل GameServer

USE [SRO_VT_SHARD]

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 Mob ]

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

[elgenis]

المشاركة الأصلية كتبت بواسطة Dev.Ri3o

انت كاتب رقم غير مسموح , بى وقف Char فى المكان اللى انت عايزو واقفلو وبعدها استخدم ال Query ده بعدها Restart لل GameServer

USE [SRO_VT_SHARD]

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 Mob ]

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

لما عملت الكيوري دا ظهرلى الايرور دا ...

[™_ramez_™]

المشاركة الأصلية كتبت بواسطة Dev.Ri3o

انت كاتب رقم غير مسموح , بى وقف Char فى المكان اللى انت عايزو واقفلو وبعدها استخدم ال Query ده بعدها Restart لل GameServer

USE [SRO_VT_SHARD]

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 Mob ]

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

طب مثلا انا دلوقتى غيرت مكان npc فى ال db عاوز اغيرو من الميديا بقى الاقى مسارة ازاى بيبقى موجود فى انهى تكست

[F77]

المشاركة الأصلية كتبت بواسطة ™_ramez_™

طب مثلا انا دلوقتى غيرت مكان npc فى ال db عاوز اغيرو من الميديا بقى الاقى مسارة ازاى بيبقى موجود فى انهى تكست

ال NPS
ملوش مسارات في الميديا
هو من الداتا بيس بس