Find out who is cheater

[Von Satan]

Maybe some people with good skills in SQL already know this, but for those not, I'll share a simple but helpful SQL query.

select C.characteridx from cabal_equipment_table E with(nolock) inner join cabal_character_table C with(nolock) on E.characteridx = C.characteridx where master.sys.fn_varbintohexstr(E.data) like '%00003503%' and C.reputation < 320000

- Red: The item you want to find on the character's equipment in reversed hex code.
- Blue: The reputation points filter.

This query searchs in the table cabal_equipment_table for a particular item code using the reputation's filter.
For example, you can easily find those who are equipped with a bracelet or earring of honor grade 7 and his real honor grade is not enough for wearing that item.

WARNING! by executing this query you can cause a very high cpu load.

I hope this help and sorry for my bad english.

[MentaL]

[phiber]

its a nice trick, i like people who think smart solutions, or in this case smart ways to fight again cheaters.

maibe, a triger for update, who make a insert on another table when some one have an item and this item have less honor than required, its an option.

;)

[oleg35]

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'master.sys.fn_varbintohexstr'.

[chumpywumpy]

Run the query in the gamedb not the master db as master contains no cabal info.

[oleg35]

Run the query in the gamedb not the master db as master contains no cabal info.

On master database error

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'cabal_equipment_table'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'cabal_character_table'.

On gamedb error

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'master.sys.fn_varbintohexstr'.

So i all posted right !

[maxgo1]

GAMEDB maybe not full

[chumpywumpy]

Ah, i see.

master.sys.fn_varbintohexstr

That is not valid for sql 2000. Change to:

master.dbo.fn_varbintohexstr

[Yamachi]

I was actually thinking of setting up a cron job to do something extremely similar to this. A better thing to do would be to also filter by level and online status. After the cron job has obtained a list of people using the bracelet/earring hack, it could then set their attack/mag.attack/defense to 1. Now, if someone's willing to decrypt packets, we could send a message to the server announcing the hackers publicly, then issue a kickout and block command if they refuse to stop. Just an idea :P

[Cath22]

I was actually thinking of setting up a cron job to do something extremely similar to this. A better thing to do would be to also filter by level and online status. After the cron job has obtained a list of people using the bracelet/earring hack, it could then set their attack/mag.attack/defense to 1. Now, if someone's willing to decrypt packets, we could send a message to the server announcing the hackers publicly, then issue a kickout and block command if they refuse to stop. Just an idea :P

any updates on this mr. yamachi

[Yamachi]

any updates on this mr. yamachi

Someone is currently helping me decrypt a few packets. I'm not sure when I'll have anything to release, as I'm quite busy with RL atm ( + I'm a lazy shit :P ).