Arcade Anti-Cheater Mod

Board: 3.x

Purpose:
If your board is a scripting/coding board you probably have cheaters using your arcade. They are people that use memoryhacks/colorbots, and believe me, people do cheat. This hack is to clean up scores. Before, if you wanted to remove a score, you had to create your own mysql query and even though the score was removed the highscore still showed up as belonging to them. This process has been fixed by this hack.

Functionaliy:
- Remove all scores from a user
- Remove a users highscores
- Fix the titleholders/highscores

Screenshot: http://www.elitecoders.org/ftp/ronin...rcadeadmin.jpg
Code: Attatched
No Edits Required PHP script: Attatched

Instructions: Perform the following edits, OR upload the attatched PHP file in place of your own arcadeadmin.php.

#-------------------------------------------------------------------------------#
Find In arcadeadmin.php
#-------------------------------------------------------------------------------#

	print_form_header('arcadeadmin', 'pruneinvalid');
	print_table_header("Remove All Invalid Scores");
	print_description_row("This action will remove all invalid score records from the database. Invalid records are created during automated score pruning, or if a session is terminated prematurely.");
	print_submit_row("Remove All Invalid Scores", 0);

#-------------------------------------------------------------------------------#
Add Below
#-------------------------------------------------------------------------------#

// ARCADE HACK BY RONIN	
	print_form_header('arcadeadmin', 'prunebyuser');
	print_table_header("Remove User Scores");
	print_description_row("This action will remove a users scores from the database.");
	print_input_row("Enter the userid here", 'userid');
	print_yes_no_row("Remove highscores only? (as opposed to all scores)", 'high', 0);
	print_submit_row("Remove User Scores", 0);
	
	print_form_header('arcadeadmin', 'fixhighscores');
	print_table_header("Fix High Scores");
	print_description_row("This action will update the highscore listings and awards with the actual highscore information for each game");
	print_submit_row("Update Highscores", 0);
// ARCADE HACK BY RONIN

#-------------------------------------------------------------------------------#
Find in arcadeadmin.php
#-------------------------------------------------------------------------------#

// ###################### INVALID RECORD PRUNING #######################
if ($_POST['do'] == "prunenoscore") {
	if ($_POST['confirmation']=="YES") {
		$DB_site->query("DELETE FROM " . TABLE_PREFIX . "gamesessions WHERE sessiontype=1");
	}

	define('CP_REDIRECT', 'arcadeadmin.php?do=scores');
	print_stop_message('arcade_cp_settingssaved');
}

#-------------------------------------------------------------------------------#
Add Below
#-------------------------------------------------------------------------------#

// ###################### PRUNE BY USER #######################
if ($_POST['do'] == "prunebyuser") {
	$userid=$_POST['userid'];
	$high=$_POST['high'];
	
 if ($high) {
	$query = "	SELECT gamename, MAX(score) AS score
				FROM gamesessions
				WHERE valid=1
				GROUP BY gamename	";
	$myquery = $DB_site->query($query);
	while($row = $DB_site->fetch_array($myquery)) {
		$delete = "DELETE FROM gamesessions WHERE gamename = '".$row['gamename']."' && userid ='".$userid."' && score = ".$row['score'];
		$DB_site->query($delete);
	}
	define('CP_REDIRECT', 'arcadeadmin.php?do=scores');
	print_stop_message('arcade_cp_settingssaved');
 } else {
	$DB_site->query("DELETE FROM " . TABLE_PREFIX . "gamesessions WHERE userid=".$userid);
	define('CP_REDIRECT', 'arcadeadmin.php?do=scores');
	print_stop_message('arcade_cp_settingssaved');
 }
}
// ###################### FIX HIGHSCORES #######################
if ($_POST['do'] == "fixhighscores") {
	$query = "	SELECT gamename, MAX(score) AS score
				FROM gamesessions
				WHERE valid=1
				GROUP BY gamename	";
	$myquery = $DB_site->query($query);
	while($row = $DB_site->fetch_array($myquery)) {
		$user = 	"SELECT userid
					FROM gamesessions
					WHERE valid=1 AND score='".$row['score']."' AND gamename='".$row['gamename']."'";
		$userquery = $DB_site->query($user);
		while($useid = $DB_site->fetch_array($userquery)) {
			$update = 	"UPDATE games
					SET `highscore`='".$row['score']."', `highscorerid`='".$useid['userid']."'
					WHERE shortname='".$row['gamename']."'";
			$DB_site->query($update);
		}
	}
	define('CP_REDIRECT', 'arcadeadmin.php?do=scores');
	print_stop_message('arcade_cp_settingssaved');
}

[Littlebit]

That was it, I spaced. Thank you! It works just great

[gwhooooey]

Can't you just click the red X next to someone's score that you want to remove? :-\

[pmay68]

i get this error

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT gamename, MAX(score) AS score
FROM gamesessions
WHERE valid=1
GROUP BY gamename
mysql error: Table 'datbase.gamesessions' doesn't exist

mysql error number: 1146

Date: Monday 19th of July 2004 06:11:11 PM
Script: http://adventurersunited.com/forums/...rcadeadmin.php
Referer: http://adventurersunited.com/forums/....php?do=scores
Username: lieutan
IP Address: 66.76.222.164

any suggestions

[grief]

Very nice this will definately come in handy

[Ron1n]

Originally Posted by gwhooooey

Can't you just click the red X next to someone's score that you want to remove? :-\

I made this mod for myself, because some user on my board won over 40 games using a memory hack. I didnt want to delete every score by hand, so I made it so that you could remove all scores by a user. I then decided that in the future it might be nice to be able to just remove high scores and not all scores. I made this for www.elitecoders.org and www.mpcforum.de. We are cheater forums, so we have a lot of cheaters we must deal with. This tool makes it very easy.

Invalid SQL: SELECT gamename, MAX(score) AS score
FROM gamesessions
WHERE valid=1
GROUP BY gamename
mysql error: Table 'datbase.gamesessions' doesn't exist

Please log into your PHP MyAdmin and see if there is a gamesessions table. If there is, copy down the prefix (the prefix should be something like vb_). if the prefix is not similar to your boards standard prefix it wont find the right table, if it is similar and you still have problems, then ill talk with you on MSN to help you fix this.

[Renat_]

Installed and working fine. Thank you Ronin!

[Renat_]

Is this any way to stop one Registered member from paying arcade?

[Datenpapst]

Originally Posted by Renat_

Is this any way to stop one Registered member from paying arcade?

Whats the sence in cheating in the Arcade?

[RichieBoy67]

It's a great hack but is there anyway to actually stop people from cheating??

[Datenpapst]

Originally Posted by RichieBoy67

It's a great hack but is there anyway to actually stop people from cheating??

hmm dont think so.