VSRO GATE

03/14/2015 15:15 AqRa#1
VSRO SELKİS AND NEHITH GATE X Y Z Change i Need Help me :(
03/14/2015 20:00 Aaron*#2
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
03/14/2015 21:26 AqRa#3
Quote:
Originally Posted by Aeron* View Post
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
Bro No Have Gate RefObjcommon
03/14/2015 22:13 Aaron*#4
Just check textdata_object and search for the gate name and code, the code is usually STORE_BLABLABLA /* change this */ just do what im saying and you'll be able to reset it, otherwise you'll have to change ur db (lol)
03/16/2015 14:09 AqRa#5
Quote:
Originally Posted by Aeron* View Post
Just check textdata_object and search for the gate name and code, the code is usually STORE_BLABLABLA /* change this */ just do what im saying and you'll be able to reset it, otherwise you'll have to change ur db (lol)
Dont Have Anibus Gate Refcommon