الموقع العربي الاول للعبة Silkroad Online

Query Change Npce Place :)

اقتباس:

USE [SRO_VT_SHARD]
----------------------------Made By Candy----------------------------
DECLARE @LEGENDKNIGHT1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)

SET @LEGENDKNIGHT1 = 'NPC_Candy' ----- Your Npc Name
SET @CHARNAME = 'Candy' ----- Charactar name [ where you Want to set npc ]

Declare @LK1 int SET @LK1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @LEGENDKNIGHT1)
Declare @LK2 int SET @LK2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @LK1)
Declare @LK3 int SET @LK3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @LK2)

Declare @LKpos1 int SET @LKpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
Declare @LKpos2 int SET @LKpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
Declare @LKpos3 int SET @LKpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
Declare @LKpos4 int SET @LKpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)

UPDATE Tab_RefNest
SET nregiondbid = @lkpos1,
flocalposx = @lkpos2,
flocalposy = @lkpos3,
flocalposz = @lkpos4
WHERE dwnestid = @lk3 and dwtacticsid = @lk2