{"id":21613,"date":"2017-11-27T12:21:47","date_gmt":"2017-11-27T11:21:47","guid":{"rendered":"http:\/\/www.psxrenzukoken.com\/nk2\/?page_id=21613"},"modified":"2019-07-12T13:23:19","modified_gmt":"2019-07-12T12:23:19","slug":"top-100","status":"publish","type":"page","link":"https:\/\/www.psxrenzukoken.com\/nk2\/top-100\/","title":{"rendered":"TOP 100 Downloads"},"content":{"rendered":"

[insert_php]<\/p>\n

include_once(‘wp-load.php’ );<\/p>\n

$compteur = 1;
\n$servername = “psxrenzukoken2.mysql.db”;
\n$username = “psxrenzukoken2”;
\n$password = “NK222favicon”;
\n$dbname = “psxrenzukoken2”;<\/p>\n

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

$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”;
\n$result = $conn->query($sql);<\/p>\n

if ($result->num_rows > 0) {<\/p>\n

\/\/ debut du tableau<\/p>\n

echo ‘<\/p>\n‘.”\\n”;<\/p>\n

\/\/ premi\u00e8re ligne on affiche les titres pr\u00e9nom et surnom dans 2 colonnes<\/p>\n

echo ‘<\/p>\n

‘;<\/p>\n

\techo ‘<\/p>\n

‘;<\/p>\n

\t\techo ‘<\/p>\n

Top <\/font><\/b><\/td>\n

‘;<\/p>\n

echo ‘<\/p>\n

Nom du jeu<\/font><\/b><\/td>\n

‘;<\/p>\n

echo ‘<\/p>\n

Nombre de t\u00e9l\u00e9chargements<\/font><\/b><\/td>\n

‘;<\/p>\n

echo ‘<\/tr>\n

‘.”\\n”;<\/p>\n

while($row = $result->fetch_assoc()) {
\n echo ‘<\/p>\n

‘.$compteur.’<\/td>\n

‘;<\/p>\n

echo ‘<\/p>\n

‘.$row[“post_title”].’<\/td>\n

‘;<\/p>\n

echo ‘<\/p>\n

‘.$row[“meta_value”].’<\/td>\n

‘;<\/p>\n

echo ‘<\/tr>\n

‘.”\\n”;
\n$compteur = $compteur + 1;
\n }<\/p>\n

echo ‘<\/table>\n

‘.”\\n”;<\/p>\n

}<\/p>\n

$conn->close();<\/p>\n

[\/insert_php]<\/p>\n","protected":false},"excerpt":{"rendered":"

[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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/pages\/21613"}],"collection":[{"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/comments?post=21613"}],"version-history":[{"count":85,"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/pages\/21613\/revisions"}],"predecessor-version":[{"id":64249,"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/pages\/21613\/revisions\/64249"}],"wp:attachment":[{"href":"https:\/\/www.psxrenzukoken.com\/nk2\/wp-json\/wp\/v2\/media?parent=21613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}