TOP 100 Downloads

[insert_php]

include_once(‘wp-load.php’ );

$compteur = 1;
$servername = “psxrenzukoken2.mysql.db”;
$username = “psxrenzukoken2”;
$password = “NK222favicon”;
$dbname = “psxrenzukoken2”;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

$sql = “SELECT * FROM wp_postmeta, wp_posts WHERE post_id = ID AND meta_key=’__wpdm_download_count’ ORDER BY CAST(meta_value as SIGNED) DESC LIMIT 0,100”;
$result = $conn->query($sql);

if ($result->num_rows > 0) {

// debut du tableau

echo ‘

‘.”\n”;

// première ligne on affiche les titres prénom et surnom dans 2 colonnes

echo ‘

‘;

echo ‘

‘;

echo ‘

‘;

echo ‘

‘;

echo ‘

‘.”\n”;

while($row = $result->fetch_assoc()) {
echo ‘

‘;

echo ‘

‘;

echo ‘

‘;

echo ‘

‘;

echo ‘

‘.”\n”;
$compteur = $compteur + 1;
}

echo ‘

Top	Nom du jeu	Nombre de téléchargements
‘.$compteur.’	‘.$row[“post_title”].’	‘.$row[“meta_value”].’

‘.”\n”;

}

$conn->close();

[/insert_php]