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
I Dont Know if any one released it
but i made it by my self
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'
but i made it by my self
PHP:
Credits to '0FF4ND3R'
Last edited: