Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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