• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Query move your char to unique spot

Newbie Spellweaver
Joined
Jul 31, 2014
Messages
13
Reaction score
1
I think it will be useless for some one but it will help beginners
But it was helpful for me sometimes
this query move your char to unique spot

PHP:
use [SRO_VT_SHARD]
go      --------- [GM]0FF4ND3R
declare [USER=35009]UNI[/USER]quecode varchar(129) = 'MOB_SD_ISIS' --------- Unique Code ------- 
declare [USER=551894]Char[/USER]name varchar(64) = '[GM]0FF4ND3R'------------ char name ---------
declare @dwObjID int = ( select ID from _RefObjCommon where CodeName128 = [USER=35009]UNI[/USER]quecode )
declare @dwTacticsID int = (select dwTacticsID from Tab_RefTactics where dwObjID = @dwObjID )
declare @LatestRegion smallint = ( select TOP 1 nRegionDBID from tab_RefNest where dwTacticsID = @dwTacticsID )
declare @PosX real =( select TOP 1 fLocalPosX from tab_RefNest where dwTacticsID = @dwTacticsID )
declare @PosY real =( select TOP 1 fLocalPosY from tab_RefNest where dwTacticsID = @dwTacticsID )
declare @PosZ real =( select TOP 1 fLocalPosZ from tab_RefNest where dwTacticsID = @dwTacticsID )
update _char set LatestRegion = @LatestRegion  where CharName16 = [USER=551894]Char[/USER]name 
update _char set PosX = @PosX where CharName16 = [USER=551894]Char[/USER]name
update _char set PosY = @PosY where CharName16 = [USER=551894]Char[/USER]name
update _char set PosZ = @PosZ where CharName16 = [USER=551894]Char[/USER]name
print ''     
print 'Dont Forget to restart your Character and if the query didnt work close character and then execute it'
print 'By 0FF4ND4R'
I Dont Know if any one released it
but i made it by my self

PHP:
Credits to '0FF4ND3R'
 
Last edited:
Back
Top