New certain point in Reverse Scroll

07/09/2012 22:41 Nefetis#1

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

[Only registered and activated users can see links. Click Here To Register...]

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 xxx -1 xxx -1 xxx

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

07/09/2012 23:29 PortalDark#2

#approved

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

07/09/2012 23:34 Over-Limit#3

Quote:

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
[Only registered and activated users can see links. Click Here To Register...]

07/12/2012 16:02 SunSoon#4

any one test it ?

07/13/2012 15:52 AndreyGun#5

yeah it work

12/20/2012 17:58 @$$#6

Working fine xD
thanks

12/21/2012 10:00 PlayPVP#7

Nice and keep sharing

04/26/2016 13:54 szkev95#8

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

04/26/2016 13:58 Nefetis#9

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

04/26/2016 14:58 B1Q#10

Quote:

Originally Posted by szkev95

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

wtf?

04/26/2016 16:13 szkev95#11

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?) @[Only registered and activated users can see links. Click Here To Register...] im not a big editer i try to start it now.. thats why i dont know how what where?!

04/26/2016 17:17 blapanda#12

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.)

04/28/2016 04:27 RichHunter#13

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'

04/29/2016 03:17 Dracula Untold#14

good job