need help

[B13.]

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 .. so removing that option from my event area will be great
thx all
and if it is can be done will it be database only or db + media ?
please explain it thx again

[B13.]

4 days no one cares

[Dracula Untold]

u can remore that option from reverse .. (i dont remember how)
and u can remove it from media as wel .

[Eslam Galull]

i think its possible but idk how , otherwise you can use a agent filter and disabled using reverse in special region

[witchymoo]

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]

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:



good luck

[B13.]

Originally Posted by witchymoo

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]

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:



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

 Spoiler

he can't use the blue reverse to come back !

[witchymoo]

Originally Posted by B13.

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.

[B13.]

should i added in the middle of those,
at the top at the IF list ?

 Spoiler

*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

[daryllrab8]

Why not just teleport to another place? He won't be there if he use reverse died.

[witchymoo]

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

[B13.]

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

 Spoiler

Find another GA to give dc [/ban] to this mother f****r when he comes back

thx for your help all !

#Request2close#

[Nectix]

#closed