need help

07/18/2015 00:37 B13.#1
hey guys,
i need to know how to disable the blue reverse option -> (Move to Last Place where you died.)
at a certain areas
** like i made an lucky crit event and he lose and wont go town so i sent him but he uses the blue reverse to come back :mad: .. so removing that option from my event area will be great
thx all :handsdown:
and if it is can be done will it be database only or db + media ?
please explain it thx again :)
07/22/2015 13:18 B13.#2
4 days no one cares :confused: :confused:
07/22/2015 14:09 Dracula Untold#3
u can remore that option from reverse .. (i dont remember how)
and u can remove it from media as wel .
07/22/2015 14:38 Eslam Galull#4
i think its possible but idk how , otherwise you can use a agent filter and disabled using reverse in special region
07/22/2015 17:05 witchymoo#5
Well, if your goal is to prevent a player returning to place where he/she died during PVP... for example: Job PVP... then u can update some value in the _Char table when the char is killed. (by utilizing _AddLogChar, EventID = 20 (character died))

something like this:
Procedure: [SRO_VT_LOG].[dbo].[_AddLogChar]

Code:
IF (@EventID = 20) -- PVP (died)
BEGIN
	/* died on job */
	IF (@Desc LIKE '%Trader, Neutral, no freebattle team%'	-- Trader
		OR @Desc LIKE '%Hunter, Neutral, no freebattle team%'	-- Hunter
		OR @Desc LIKE '%Robber, Neutral, no freebattle team%'	-- Thief
	)
	BEGIN
		/* Reset died location to prevent returning using Reverse Return Scroll */
		UPDATE [_Char] SET DiedRegion = 0, DiedPosX = 0, DiedPosY = 0, DiedPosZ = 0, DiedWorldID = 1 WHERE CharID = @CharID
	END
	RETURN -1
END
When the player tried to use reverse return to teleport back to place where they died, they'll get something like this:

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

good luck
07/23/2015 01:10 B13.#6
Quote:
Originally Posted by witchymoo View Post
Well, if your goal is to prevent a player returning to place where he/she died during PVP... for example: Job PVP... then u can update some value in the _Char table when the char is killed. (by utilizing _AddLogChar, EventID = 20 (character died))

something like this:
Procedure: [SRO_VT_LOG].[dbo].[_AddLogChar]

Code:
IF (@EventID = 20) -- PVP (died)
BEGIN
	/* died on job */
	IF (@Desc LIKE '%Trader, Neutral, no freebattle team%'	-- Trader
		OR @Desc LIKE '%Hunter, Neutral, no freebattle team%'	-- Hunter
		OR @Desc LIKE '%Robber, Neutral, no freebattle team%'	-- Thief
	)
	BEGIN
		/* Reset died location to prevent returning using Reverse Return Scroll */
		UPDATE [_Char] SET DiedRegion = 0, DiedPosX = 0, DiedPosY = 0, DiedPosZ = 0, DiedWorldID = 1 WHERE CharID = @CharID
	END
	RETURN -1
END
When the player tried to use reverse return to teleport back to place where they died, they'll get something like this:

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

good luck
Sadly this didn't work not even for the Hunters,thiefs,Traders they still can go back where they died :/
Any idea ?...
i really appreciate your help guys
again what i want is to disable the blue reverse option not from all game !
but from certain area like
if some one died here
he can't use the blue reverse to come back !
07/24/2015 07:42 witchymoo#7
Quote:
Originally Posted by B13. View Post
Sadly this didn't work not even for the Hunters,thiefs,Traders they still can go back where they died :/
Any idea ?...
well, does your server write logs when character died? (check by killing the char, then see if there's new record in [SRO_VT_LOG].[dbo].[_LogEventChar] table) if it does, i don't know what you have in your server's [SRO_VT_LOG].[dbo].[_AddLogChar] procedure, perhaps some other functions already covers the EventID 20 (PVP died), if you have that kind of function, you should merge it. Definitely wouldn't want to check same EventID more than once in same procedure.
07/24/2015 11:49 B13.#8
should i added in the middle of those,
at the top at the IF list ?
*nothing else controls event id 20
*does it even matter where i add the code ?
**after a second thought what if a trader died on his way to other town wont that stop him from going back to the trade ? :S
-ihatemyself-
.thx for the help tho
07/24/2015 18:42 daryllrab8#9
Why not just teleport to another place? He won't be there if he use reverse died.
07/25/2015 00:25 witchymoo#10
not sure where you got that proc but pretty much creating massive resource-eating queries once your server went online with lots of players around. (no eventid filter? that ain't good)

but, anywho, you might wanna skip the SP stuff and just check, if any of PVP activities recorded in _LogEventChar table. go try kill each other and see if there's any new record in the table. As i mentioned in previous post.

And if it doesn't, what GS are you using? if you use Envangelion by chern0byl, you should set logging to "ON". So far i tried only his GS can disable _AddLogChar or _AddLogItem logging procedure :)
07/25/2015 02:38 B13.#11
thank you for your help guys,
i can't do it
i feel your answer will also remove that option from trades,hunters,thief (witchymoo)
sulotion
thx for your help all !

#Request2close#
07/25/2015 07:44 Nectix#12
#closed