New certain point in Reverse Scroll

[Nefetis]

Hello epvp. Today i will want to release how to add new certain point in Reverse.



1.In SRO_VT_SHARD base we must find the _RefOptionalTeleport Table and add new line.

Example of line
1 43 ?????? SN_ZONE_22004 26959 1030 80 512 1-1 1 0 0 -1 *** -1 *** -1 ***

43 - This must be Next Free ID in the table
SN_ZONE_22004 - This is the Name of Point. We can add new Name of Point in textdata_object.txt.
26959 1030 80 512 - This is the Cords of the new cetain point. Go to the certain point log of and use this query


Select LatestRegion,PosX,PosY,PosZ From _Char Where CharName16 = 'Nick of the char '

The result will be Cords.

0 0 - That's lvl Req. If you want a character on a specific level to be able to teleport only, then first zero is the minimal lvl and 2nd zero is the maximal lvl.
Example
Minimum lvl 76 maximum 90
76 90

Okay if we have new line added in sql then we must copy it to Media.pk2. To the refoptionalteleport.txt the location of file.
server_dep/silkroad/textdata/refoptionalteleport.txt

Regrads Nefetis

[PortalDark]

#approved

@topic
does the new point will appear on map auto or you must add it?

[Over-Limit]

Originally Posted by PortalDark

#approved

@topic
does the new point will appear on map auto or you must add it?

it will appear in the map... already in overlimit since ages

[SunSoon]

any one test it ?

[AndreyGun]

yeah it work

[@$$]

Working fine xD
thanks

[PlayPVP]

Nice and keep sharing

[szkev95]

Is this only works for GMs? or anyone can make this editing?

[Nefetis]

Only the administrator of server can make new location points in reverse scroll

[B1Q]

Originally Posted by szkev95

Is this only works for GMs? or anyone can make this editing?

wtf?

[szkev95]

i would request. in psrv gm removed these certain point from reverse, how could i add back that? its possible cuz players can use it but basiclly we not ( someoen said u need to replace media with smth, if u got it, could someone send me this file/media or edit it for me?) @ im not a big editer i try to start it now.. thats why i dont know how what where?!

[blapanda]

Uhm ... those 2016 posts are making no sense.

You, as someone who has the privileges to log in and edit database tables (be it an "admin" or just a "developer"), you, and only you, are able to add and remove those pointers.
First of all, lets say, a GM disabled it CLIENT-SIDED ONLY.
You, as a player, still have to figure out what the exact pointers where. String declaration, coordinates, level restriction (actually 1 - 140 will work) and so on.

If it has been disabled client AND server-sided, you have no chance reobtaining the possibility of additional return points.

(If this is your actual concern. If it's not, meh, then be more precise next time.)

[RichHunter]

With this Query you can do and will be easily

PHP Code:

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,LevelMin,LevelMax,Param1,Param1_Desc_128,Param2,Param2_Desc_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' 


[Dracula Untold]

good job