Change NPC Place

Little Messi · 01/19/2015, 07:17

as title said, how can i change NPC Place
maybe a query by char name, or manually
some one can help me with it ?!

PlantiX · 01/19/2015, 09:22

1. Open _RefObjCommon, get the ID of the NPC.
2. Open _RefTactics -> paste the ID of the NPC and copy the Nest ID
3. Open RefNest -> change the coordinates

Done, gl

Crue* · 01/19/2015, 10:17

or just use that query

PHP Code:



declare @npcname varchar(128)
DECLARE @CHARNAME VARCHAR (64) 
set @npcname = 'CODENAMENPC'
SET @CHARNAME = 'test' -- Character name from _Char table to get mob position X Y Z 
DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) 
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) 
UPDATE Tab_RefNest set nRegionDBID = @REGION, fLocalPosX = @posx, fLocalPosY = @posy, fLocalPosZ = @posz where dwTacticsID = (select dwTacticsID from Tab_RefTactics where dwObjID = (select ID from _RefObjCommon where CodeName128 = @npcname ))

Little Messi · 01/19/2015, 17:54

Quote:

Originally Posted by Crue*

or just use that query

PHP Code:

declare @npcname varchar(128) DECLARE @CHARNAME VARCHAR (64) set @npcname = 'CODENAMENPC' SET @CHARNAME = 'test' -- Character name from _Char table to get mob position X Y Z DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME) DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME) UPDATE Tab_RefNest set nRegionDBID = @REGION, fLocalPosX = @posx, fLocalPosY = @posy, fLocalPosZ = @posz where dwTacticsID = (select dwTacticsID from Tab_RefTactics where dwObjID = (select ID from _RefObjCommon where CodeName128 = @npcname ))

that's the query result ..

WickedNite. · 01/19/2015, 17:56

Queries....just do it manually like PlantiX said.

Crue* · 01/19/2015, 18:02

Quote:

Originally Posted by Little Messi

that's the query result ..

change it from STORE to NPC

Quote:

Originally Posted by TheWickedNite

Queries....just do it manually like PlantiX said.

Queries always do most of the work

MissinGDeaTh · 01/19/2015, 18:41

Quote:

Originally Posted by Crue*

change it from STORE to NPC

Queries always do most of the work

same thing

Little Messi · 01/19/2015, 19:05

Quote:

Originally Posted by PlantiX

1. Open _RefObjCommon, get the ID of the NPC.
2. Open _RefTactics -> paste the ID of the NPC and copy the Nest ID
3. Open RefNest -> change the coordinates

Done, gl

i'm a little lost here, Paste the ID of NPC where exactly :S

Quote:

Originally Posted by MissinGDeaTh

same thing

Crue* · 01/19/2015, 20:17

are you sure that the codename in refobjcommon ?

Little Messi · 01/19/2015, 20:24

Quote:

Originally Posted by Crue*

are you sure that the codename in refobjcommon ?

i did searched for it and here's the result

Crue* · 01/19/2015, 20:33

Quote:

Originally Posted by Little Messi

i did searched for it and here's the result

so try this one,

PHP Code:



Declare @trcid as varchar (MAX) 
Declare @NPC as varchar (200) 
Declare @ref as varchar (250) 
Declare @x as varchar (250) 
Declare @y as varchar (250) 
Declare @z as varchar (250) 
Declare @region as varchar (250) 
Declare @app as varchar (250) 
Declare @char as varchar (MAX) 
 
Set @char = 'xxx'       
Set @NPC = 'NPC_LEGENDKNIGHT10'  
----------------------------------------------------------------------------------- 
Set @x = (Select PosX From _Char Where CharName16 = @char) 
Set @y = (Select PosY From _Char Where CharName16 = @char) 
Set @z = (Select PosZ From _Char Where CharName16 = @char) 
Set @region = (Select LatestRegion From _Char Where CharName16 = @char) 
Set @app = (Select AppointedTeleport From _Char Where CharName16 = @char) 
set @trcid = (Select dwTacticsID from Tab_RefTactics where dwObjID = (Select ID from _RefObjCommon where CodeName128 = @NPC )) 
UPDATE Tab_RefNest set fLocalPosX = @x , fLocalPosY = @y , fLocalPosZ = @z , nRegionDBID = @region ,wInitialDir = @app where dwTacticsID = @trcid

Little Messi · 01/19/2015, 20:42

Quote:

Originally Posted by Crue*

so try this one,

PHP Code:

Declare @trcid as varchar (MAX) Declare @NPC as varchar (200) Declare @ref as varchar (250) Declare @x as varchar (250) Declare @y as varchar (250) Declare @z as varchar (250) Declare @region as varchar (250) Declare @app as varchar (250) Declare @char as varchar (MAX) Set @char = 'xxx' Set @NPC = 'NPC_LEGENDKNIGHT10' ----------------------------------------------------------------------------------- Set @x = (Select PosX From _Char Where CharName16 = @char) Set @y = (Select PosY From _Char Where CharName16 = @char) Set @z = (Select PosZ From _Char Where CharName16 = @char) Set @region = (Select LatestRegion From _Char Where CharName16 = @char) Set @app = (Select AppointedTeleport From _Char Where CharName16 = @char) set @trcid = (Select dwTacticsID from Tab_RefTactics where dwObjID = (Select ID from _RefObjCommon where CodeName128 = @NPC )) UPDATE Tab_RefNest set fLocalPosX = @x , fLocalPosY = @y , fLocalPosZ = @z , nRegionDBID = @region ,wInitialDir = @app where dwTacticsID = @trcid

i rly appreciate that you are helping me, and am sorry for your waste of time. take a look at this :/

Crue* · 01/19/2015, 20:51

it was working before change the npc spot ?

Little Messi · 01/19/2015, 20:54

Quote:

Originally Posted by Crue*

it was working before change the npc spot ?

ye it was working, but don't worry about that i alrdy got a back up and i restore it, but query didn't worked yet :/

Crue* · 01/19/2015, 21:01

Quote:

Originally Posted by Little Messi

ye it was working, but don't worry about that i alrdy got a back up and i restore it, but query didn't worked yet :/

so you've to do it manually