09-23-2003, 03:31 PM
|
#1 |
|
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 |
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
Threaded Mode
