[Release] Query Change NPC Location With Charname | Easy,Fast,Controlled

~~EdwardTeach+-~~ · 08/10/2016, 07:30

straightly go,
1. Open _RefObjCommon, get the Code of the NPC.
2. Open Character ingame and go where you need the new location of the NPC, and Logout,
3. Open New Query,

PHP Code:


			
USE [SRO_VT_SHARD]

/*哈野浅哈.*/

DECLARE @NPCODE VARCHAR (129)

DECLARE @CHARNAME VARCHAR (64)

DECLARE @Z_X_Y_LOCATION INT

-->

/*West = -32767

South = -16384

Earth = 0

North = +16384*/

SET @NPCODE = 'NPC_CodeName128' ----- Your Npc Name

SET @CHARNAME = 'CharName16' ----- Charactar name [ where you Want to set npc ]

SET @Z_X_Y_LOCATION = '-32767' -- West

Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @NPCODE)

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,

wInitialDir = @Z_X_Y_LOCATION

WHERE dwnestid = @AS3 and dwtacticsid = @AS2

X_Shadow · 08/10/2016, 20:54

Tnx

Cosmic Pulse · 08/11/2016, 20:56

thanks for sharing but it's a little bit old

~~EdwardTeach+-~~ · 08/11/2016, 22:27

Quote:

Originally Posted by Cosmic Pulse

thanks for sharing but it's a little bit old

well, if u check the query, a lil deeper, you 'll find it's modified

pvperz ll · 01/26/2018, 11:44

(0 row(s) affected)

iAmAndrew · 04/16/2019, 23:57

Quote:

Originally Posted by EdwardTeach+-

straightly go,
1. Open _RefObjCommon, get the Code of the NPC.
2. Open Character ingame and go where you need the new location of the NPC, and Logout,
3. Open New Query,

PHP Code:

USE [SRO_VT_SHARD] /*哈野浅哈.*/ DECLARE @NPCODE VARCHAR (129) DECLARE @CHARNAME VARCHAR (64) DECLARE @Z_X_Y_LOCATION INT --> /*West = -32767 South = -16384 Earth = 0 North = +16384*/ SET @NPCODE = 'NPC_CodeName128' ----- Your Npc Name SET @CHARNAME = 'CharName16' ----- Charactar name [ where you Want to set npc ] SET @Z_X_Y_LOCATION = '-32767' -- West Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @NPCODE) 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, wInitialDir = @Z_X_Y_LOCATION WHERE dwnestid = @AS3 and dwtacticsid = @AS2

hey mate, i have use that query and works perfect, but dont know why some npcs i use that query appear this error

'' Msg 512, Level 16, State 1, Line 16
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

(0 row(s) affected) ''

any sugestion ?

~~ServerSro~~ · 10/19/2019, 10:45

Quote:

Originally Posted by iAmAndrew

hey mate, i have use that query and works perfect, but dont know why some npcs i use that query appear this error

'' Msg 512, Level 16, State 1, Line 16
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

(0 row(s) affected) ''

any sugestion ?

contact