Change NPC Place

Page 2 of 2

01/19/2015 21:04 Little Messi#16

Quote:

Originally Posted by Crue*

so you've to do it manually

okay, thanks alot. i will try to do it manually
can u tell me the way to do it ?!
cuz i couldn't do it like that other guy said.

01/19/2015 21:38 WickedNite.#17

Quote:

Originally Posted by Little Messi

okay, thanks alot. i will try to do it manually
can u tell me the way to do it ?!
cuz i couldn't do it like that other guy said.

Get RefObjCommon ID, use it in tabreftactics as dwobjID then get the dwtacticsID and search for it in refnest

01/19/2015 22:42 MissinGDeaTh#18

Quote:

Originally Posted by TheWickedNite

Get RefObjCommon ID, use it in tabreftactics as dwobjID then get the dwtacticsID and search for it in refnest

so i will search for dwtacticsID in refnest and change pos ?

01/19/2015 22:53 PlantiX#19

Quote:

Originally Posted by MissinGDeaTh

so i will search for dwtacticsID in refnest and change pos ?

YES

01/19/2015 23:04 MissinGDeaTh#20

Quote:

Originally Posted by PlantiX

YES

changed pos , but when i login client crashs :/
is there's any media modification ?

01/19/2015 23:59 Exo#21

PHP Code:


			
USE SRO_VT_SHARD
DECLARE      @RefID int,
                  @Cord_X int,
                  @Cord_Y int,
                  @Cord_Z int,
                  @Region int

SELECT @Cord_X = PosX,
       @Cord_Y = PosY,
       @Cord_Z = PosZ,
       @Region = LatestRegion
       
       FROM _Char WHERE CharName16 = 'xExorcist'

SELECT       @RefID = R.dwTacticsID
FROM   Tab_RefTactics R
JOIN    _RefObjCommon O
ON           O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'NPC_CODE_HERE'

UPDATE TAB_RefNest 
SET fLocalPosX    = @CORD_X,
      fLocalPosY    = @CORD_Y,
      fLocalPosZ    = @CORD_Z,
      nRegionDBID = @Region
WHERE dwTacticsID = @RefID

01/20/2015 00:03 MissinGDeaTh#22

Quote:

Originally Posted by xExorcist

PHP Code:

USE SRO_VT_SHARD DECLARE @RefID int, @Cord_X int, @Cord_Y int, @Cord_Z int, @Region int SELECT @Cord_X = PosX, @Cord_Y = PosY, @Cord_Z = PosZ, @Region = LatestRegion FROM _Char WHERE CharName16 = 'xExorcist' SELECT @RefID = R.dwTacticsID FROM Tab_RefTactics R JOIN _RefObjCommon O ON O.ID = R.dwObjID WHERE O.CodeName128 LIKE 'NPC_CODE_HERE' UPDATE TAB_RefNest SET fLocalPosX = @CORD_X, fLocalPosY = @CORD_Y, fLocalPosZ = @CORD_Z, nRegionDBID = @Region WHERE dwTacticsID = @RefID

thanks alot , it worked <3

01/20/2015 02:17 Exo#23

Quote:

Originally Posted by MissinGDeaTh

thanks alot , it worked <3

It's called LA DI DAA hehehe

#case-closed

Page 2 of 2