GM Offander
05-08-2015, 12:19 AM
انا نزلتو علي منتدي اجنبي
بس بصراحة حبيت انزلو علي S4A
use [SRO_VT_SHARD]
------------------------go --------- [GM]0FF4ND3R
declare @UNIquecode varchar(129) = 'MOB_SD_ISIS' --------- Unique Code -------
declare @Charname varchar(64) = '[GM]0FF4ND3R'------------ char name ---------
declare @dwObjID int = ( select ID from _RefObjCommon where CodeName128 = @UNIquecode )
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 = @Charname
update _char set PosX = @PosX where CharName16 = @Charname
update _char set PosY = @PosY where CharName16 = @Charname
update _char set PosZ = @PosZ where CharName16 = @Charname
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
Credits to '0FF4ND3R' #ME -_-
يرات بس محديش يقلي منقول بس عشان انا الي عملو
بس بصراحة حبيت انزلو علي S4A
use [SRO_VT_SHARD]
------------------------go --------- [GM]0FF4ND3R
declare @UNIquecode varchar(129) = 'MOB_SD_ISIS' --------- Unique Code -------
declare @Charname varchar(64) = '[GM]0FF4ND3R'------------ char name ---------
declare @dwObjID int = ( select ID from _RefObjCommon where CodeName128 = @UNIquecode )
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 = @Charname
update _char set PosX = @PosX where CharName16 = @Charname
update _char set PosY = @PosY where CharName16 = @Charname
update _char set PosZ = @PosZ where CharName16 = @Charname
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
Credits to '0FF4ND3R' #ME -_-
يرات بس محديش يقلي منقول بس عشان انا الي عملو