Cheated Highscores

AetherGoth · 09-23-2003, 03:31 PM

How about adding a field for each song whose value is the maximum score possible. Then you can just make a little PHP script that is scheduled to run every hour or so with the following:

$songres = mysql_query("SELECT maxscore, songname FROM songs");

while (($songrow = mysql_fetch_assoc($songres) !== false)
{
$songname = $songrow['songname'];
$maxscore = $songrow['maxscore'];
mysql_query("DELETE FROM scores WHERE songname = '$songname' AND score > '$maxscore'");
}

mysql_free_result($songres);

That'll at least stop the *obvious* cheaters.

**Synthlight** · 09-23-2003, 03:40 PM

Skilled eh?

pm me if you are interested in helping with some PHP code dealing with MySQL

Cheers,

Synthlight

09-23-2003, 03:31 PM	#1
AetherGoth FFR Player Join Date: Jul 2003 Posts: 12	Cheated Highscores How about adding a field for each song whose value is the maximum score possible. Then you can just make a little PHP script that is scheduled to run every hour or so with the following: $songres = mysql_query("SELECT maxscore, songname FROM songs"); while (($songrow = mysql_fetch_assoc($songres) !== false) { $songname = $songrow['songname']; $maxscore = $songrow['maxscore']; mysql_query("DELETE FROM scores WHERE songname = '$songname' AND score > '$maxscore'"); } mysql_free_result($songres); That'll at least stop the obvious cheaters. __________________ I sang of leaves, of leaves of gold, and leaves of gold there grew. Of wind I sang, a wind there came, and in the branches blew. Beyond the sun, beyond the moon, the foam was on the sea, And by the strand of Ilmarin there grew a golden tree. - Tolkien

09-23-2003, 03:40 PM	#2
Synthlight Administrator Founder, System Administrator Join Date: Nov 2002 Location: United States of America Age: 52 Posts: 3,057	Skilled eh? pm me if you are interested in helping with some PHP code dealing with MySQL Cheers, Synthlight

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)