There are two problems with this.
1st. _Char is updated to slowly. This means, the character could already have moved to the Jangan bridge, however _Char will say he's still in town.
Why? Because SQL would simply die if every position change would be directly updated at the DB. There is AT LEAST a 45 sec delay up to 120 sec day between the position update. The only way you can trigger the GS to write it to the table is by world reloading... meaning, by teleportation or login.
This means, that if you really want to have a anti cheat, you need to find their REAL position.. not their position 2 minutes ago.
I can simply go outside of the map, with a jobsuit.. wait there 5 minutes. Then go into town, spawn a transport pet, get items quickly and drop them. Then get the thief char which was waiting outside and go n pick the items quickly.
=> No cheat detection.
The only real way of overcoming that problem is by doing it like I have.
I've got 6 bot chars ingame, which teleport to every theif who picks items. If the bot spawns inside a safezone, he assslaps the cheaters directly. No questions asked.
If you want to make it better, check the hardwareid of the trader.. check the IP of both. Check how may past goods the thief has been able to take from the trader and check how many successfull trades ahve been made. Check the friendlist and check their chatlog count. Check if certain words were used. Check if the jobname has been changed a lot recently. Check if their passwords are the same. Check if their registration email is similiar.
There are tons of things that you can use to make a REAL anti cheat.. The stuff that your doing is simple bullshit.
However, I'll help ya.
DECLARE @IsBattlefield BIT;
SELECT @IsBattlefield = isBattlefield
FROM SRO_VT_SHARD.._RefRegion R
JOIN SRO_VT_SHARD.._Char CH
ON R.wRegionID = CH.LatestRegion
WHERE CH.CharID = @CharID
IF @isBattlefield = 1
-- Code to to w/e you want with the cheater.
Soz for typing mistakes. Forum sucks for writing.
Keep in mind, people will RAGE at you because of false bans. This is a VERY VERY VERY unreliable way of doing a anti cheat system. Keep that in mind.
