Baghdad Down

[Youssef joo]

ظبط التلبورت انتا مش عملو كامل وضيف ريفرس بالكوارى ده

DECLARE [MENTION=3898309]charname[/MENTION] VARCHAR (max) = 'Xemia' /**CharName**/
DECLARE [MENTION=287308]Min[/MENTION]lvl VARCHAR (max) = '2' /**Minimum Level which can use the teleport**/
DECLARE [MENTION=301174]maXl[/MENTION]vl VARCHAR (max) = '3' /**Maximum Level which can use the teleport**/
DECLARE @SN_ZONE VARCHAR (max) = 'SN_ZONE_25018_1' /**Zone Name (u can add it in textdata_object) example.**/



DECLARE [MENTION=1184112]region[/MENTION] VARCHAR (max) = (Select LatestRegion From _Char Where CharName16 = [MENTION=3898309]charname[/MENTION])
DECLARE @X VARCHAR (max) = (Select PosX From _Char Where CharName16 = [MENTION=3898309]charname[/MENTION])
DECLARE @Y VARCHAR (max) = (Select PosY From _Char Where CharName16 = [MENTION=3898309]charname[/MENTION])
DECLARE @Z VARCHAR (max) = (Select PosZ From _Char Where CharName16 = [MENTION=3898309]charname[/MENTION])
DECLARE [MENTION=329636]maxid[/MENTION] VARCHAR (max) = (SELECT MAX (ID) FROM _RefOptionalTeleport)+1
Insert INTO _RefOptionalTeleport (Service,ID,ObjName128,ZoneName128,RegionID,Pos_X, Pos_Y,Pos_Z,WorldID,RegionIDGroup,MapPoint,LevelMi n,LevelMax,Param1,Param1_Desc_128,Param2,Param2_De sc_128,Param3,Param3_Desc_128)
Values(1 [MENTION=329636]maxid[/MENTION],'??????',@SN_ZONE [MENTION=1184112]region[/MENTION],@X,@Y,@Z,1,1,1 [MENTION=287308]Min[/MENTION]lvl [MENTION=301174]maXl[/MENTION]vl,-1,'xxx',-1,'xxx',-1,'xxx')

print 'ADD THAT LINE IN media.pk2->Server_dep->silkroad->textdata->refoptionalteleport.txt'
Print '1 ' [MENTION=329636]maxid[/MENTION]+' ?????? '+@SN_ZONE+' ' [MENTION=1184112]region[/MENTION]+' '+@X+' '+@Y+' '+@Z+' 1 1 1'+' ' [MENTION=287308]Min[/MENTION]lvl+' ' [MENTION=301174]maXl[/MENTION]vl+' -1 xxx -1 xxx -1 xxx'