There is any disconnect script if agility stats are bigger then 32767?

[boomeey]

i've posted again, cuz' my previous thread was deleted, dunno' why :)

I need some help to set up the server. At Castle Siege there is a bug : you can register the official seal with agility over 32767 . no one can kill you.. so.. can someone help and tell me if there is a script for autodisconnect character if atribute agility is bigger then 32767 after 5 seconds?

excuse my bad english

[MentaL]

[Alin1337]

You can't DC players from PHP/HTML/MSSQL ...

Use MSSQL Query to fix 32k Chars.

[boomeey]

there are scripts wich D/C players if they are not moving in the game for a certain period of time (anti afk)

the script for fixing the stats over 32767 is doing another job. i'm interested to disconnect players who had status over 32767 so they cannot use that bug anymore.

[magicswe]

If you want this to block hackers, just do a sql job that bans players, if you want it to fix the agility just do a job for that
UPDATE Character
SET agility="yourvalue" WHERE agility="yourvalue+tomuch"

[boomeey]

If you want this to block hackers, just do a sql job that bans players, if you want it to fix the agility just do a job for that
UPDATE Character
SET agility="yourvalue" WHERE agility="yourvalue+tomuch"

i know this script magicswe, but that charracter with agility over 32767 must disconnect himself first to activate this agility fixer script.
the player can register the official seal, and after that sw char. is not fair. they can exploit this bug. i want to disconnect them imediatly.
10x for trying to help

can somebody help me with this issue?

[magicswe]

There's no way to make any SQL query to disconnect a player. You need 3rd party programs for that which i can't help you with sorry. Things like this is what you have to deal with when running a High exp reset server.

Sorry. In theory you would want a script that set connectstatus to 0 then a 3rd party app that scans the table and if it finds the value 0 it sends a DC query to the Gameserver or whatever. I know this for fact since we had that on deja mu i believe.. or was it oinkmu hmm

[genoxide]

+1 on all other people said.
A smart solution is to make a little snippet on the wz_connect proc that checks the agility row or wtv, if it's over a set value set it down to another set value.
Think about it GS->wz_dc->wz_conn->GSCS

[magicswe]

That is actually a good idea, since when you move to "Castle Siege" you connect to the GSCS. Nice idea +10 genoxide.

[boomeey]

+1 on all other people said.
A smart solution is to make a little snippet on the wz_connect proc that checks the agility row or wtv, if it's over a set value set it down to another set value.
Think about it GS->wz_dc->wz_conn->GSCS

this is a good ideea. but the players can add agility points when they are allready on GSCS

[genoxide]

What files are you using? i know that scfmt files (cracked or not) block this action.
Also if im not mistaken all this can be corrected from procedures, the one that runs after the player clicks the "+" symbol.
If you are using custom commands (/add) then you must correct them from there

[boomeey]

I am using server full S2 with client GMO

There is any possibility/method to disconnect an account/charracter from a script? (example: web page)

[magicswe]

I thought i told you, that it is not possible with a script.