How to find hackers in your server (The easiest ways)

[slayer1]

This is a great way to find hackers in your server. Typically a hacker will give themselves loads of gold right? Well to find any hacker in even large servers, all you need to do is one of these:

 

Method 1-The Manual Way

Navicat -> newproject_db -> t_inven00 ->

Right click on the column heading: a_count0 and select "Sort Decending", it will then display the highest values of gold in a players inventory at the top of the column. You can look in the same row under a_item_index0 to confirm it is gold (19) and you can decide whether or not that character is a hacker if he isnt a legit admin or GM (check character index and search for it in t_character). Then scroll to the right and do the same thing to check columns a_count1 a_count 2 a_count 3 and a_count4

 

Repeat these instructions for t_inven01 through t_inven09, and you will have just checked every character that has ever played on your server.

------------------------------------------

Method 2-The Automatic Way

Navicat -> right click newproject_db -> Console

This code will check every players inventory and reset any players gold to 0 if they have more that 10 billion (10kkk) gold in their inventory (or more than 10kkk of anything else for that matter, such as expb or pbi. Be sure you dont give yourself more than 10kkk or your own inventory will be emptied lol, but your admin you can get that right back anyway.

UPDATE t_inven00 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven01 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven02 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven03 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven04 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven05 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven06 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven07 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven08 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven09 SET a_count = 0 WHERE a_count > 10000000000;
UPDATE t_inven00 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven01 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven02 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven03 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven04 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven05 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven06 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven07 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven08 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven09 SET a_count = 0 WHERE a_count1 > 10000000000;
UPDATE t_inven00 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven01 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven02 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven03 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven04 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven05 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven06 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven07 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven08 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven09 SET a_count = 0 WHERE a_count2 > 10000000000;
UPDATE t_inven00 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven01 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven02 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven03 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven04 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven05 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven06 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven07 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven08 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven09 SET a_count = 0 WHERE a_count3 > 10000000000;
UPDATE t_inven00 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven01 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven02 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven03 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven04 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven05 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven06 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven07 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven08 SET a_count = 0 WHERE a_count4 > 10000000000;
UPDATE t_inven09 SET a_count = 0 WHERE a_count4 > 10000000000;



*************************************************

To those with the skill, you can use my basic ideas here to develop even better ways for yourself, such as php for your site to show a ranking for the player with the most gold, then if they are not GM everyone can clearly see who the hackers are.

[someone]

Here is a much shorter one(plus your has some problems for instance a_count does not exist)

DROP PROCEDURE IF EXISTS check_inventory;
CREATE PROCEDURE check_inventory()
BEGIN
-- init stuff
SET @i = 0;
SET @str_inven = "t_inven0";
SET @str_count = "a_count";
-- for every table
WHILE @i <= 9 DO
SET @t_inven = CONCAT(@str_inven, @i);
SET @j = 0;
-- for every columns
WHILE @j <= 4 DO
SET @a_count = CONCAT(@str_count, @j);
-- prepare statemets and execute it
SET @q = CONCAT("UPDATE ",@t_inven, " SET ", @a_count, " = 0 WHERE ", @a_count, " > 10000000000;");
PREPARE stmt FROM @q; EXECUTE stmt; DEALLOCATE PREPARE stmt;
SET @j = @j + 1;
END WHILE;
SET @i = @i + 1;
END WHILE;
END;

CALL check_inventory();

[slayer1]

Eh, the gold dupe exploit was patched. This is entirely unnecessary. Hackers do more then just dupe gold, for instance I gave myself full +75 items on World-Of-Dums. When the max grade was +43. You would be more interested in stopping players using bots such as mine to gain levels. Then worry about someone abusing a fixed exploit.
I realized they hack other things as well, here I was just trying out some new things, im barely 18 years old im still learning lol. My intention was exactly what happened here, I tried to encourage others to post their anti-hacking tactics so I can learn some new things. You see people tend to not like to help those who simply want others to do all the work, so I am showing that I am somebody who doesnt just leech off of others.

 

Besides it doesnt need to be a gold dupe, warmonger you gave yourself +75 items, wouldnt you need admin rights for that? Meaning you would have had to give yourself those rights, which you would likely use to give yourself gold as well.

 

I can stop bots very easily, by creating extremely powerful god mobs and placing them randomly throughout all the maps, I was thinking of adapting one of the Tower mobs and giving them a skill like Kamiras meteo, just amp up the power on a level 10 kamira meteo and giving it to the tower. I dont like this method because of player area attack skills, but if it comes down to that I will at least temporarily implement this if botting becomes a problem.

 

No I am not nearly as good as you guys, but hey give me some credit for trying

[Blackfire]

is it possible to make this delete from people's storekeeper also?