[GenSec]

Originally Posted by Lionel

Now that we have the games rated, what would be nice is a top rated list and a most popular (most played)

No problem

Find in arcade.php

	// Selects all games from the database

Add below:

if ($_GET['show'] == "best")
{
                define('BESTRATED', 'true');
 // Selects rating
$result_allgames = $DB_site->query("
SELECT * FROM " . TABLE_PREFIX . "games  AS g 
WHERE g.votetotal>3 ORDER BY votetotal DESC
");
} else {

Find:

		$gamecount = $DB_site->num_rows($result_allgames);

Add before:

}

Now link to the page http://www.yourdomain/forum/arcade.php?show=best and you have list of games wiht rating >3