If you mean the dimensional gate itself, then _Refobjcommon columns (RegionID,posx,posy,posz) will help you to reset them to the original place.
Here is a query that may help you
Quote:
begin transaction
DECLARE @GATECODE VARCHAR(MAX) = 'GATE_CODE', /* USUALLY IT IS SOMETHING LIKE STORE_TEMPLE OR SMTH SIMILAR TO this, im not sure.*/
@CHARNAME VARCHAR(MAX),
@REGION INT,
@POSX INT,
@POSY INT,
@POSZ INT
Select @CHARNAME = 'YOUR CHAR NAME HERE' /* type your char name here where you will move the teleporter to his location */
SET @REGION = (SELECT LATESTREGION FROM _CHAR WHERE CHARNAME16 LIKE @CHARNAME)
SET @POSX = (SELECT POSX FROM _CHAR WHERE CHARNAME16 LIKE @CHARNAME)
SET @POSY = (SELECT POSY FROM _CHAR WHERE CHARNAME16 LIKE @CHARNAME)
SET @POSZ = (SELECT POSZ FROM _CHAR WHERE CHARNAME16 LIKE @CHARNAME)
UPDATE _refobjcommon set OffsetX = @posx,Offsety = @posy,Offsetz = @posz,RegionID = @Region
where codename128 like @GateCode
if @@ERROR != 0
rollback transaction
else
commit transaction
|
