CREATE TABLE IF NOT EXISTS `wp_mochi_scores` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `when` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `gameid` text COLLATE utf8_unicode_ci NOT NULL,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `score` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

<?php
 
// your secret key
$key="f26ebddd6fcfb796ac1841bcc57af057";
 
// initializing an empty string - not strictly necessary
$string = "";
 
// ordering the associative POST array by keys
ksort($_POST);
 
// loop scanning through all POST array
foreach($_POST as $varname => $varvalue){
     // if the key is not "signature" then append key and url encoded values to the string
     if($varname!="signature"){
          $string.=$varname."=".rawurlencode($varvalue)."&";
     }
}
 
// removing the last character (a "&"")
$string = substr($string,0,strlen($string)-1);
 
// appeding the secret key to the string
$string.= $key;
 
// comparing the md5 encryption of the string with the "signature" variable
if(md5($string)==$_POST[signature]){
     // requiring the relative path to your wp-config.php file
     // according to your wp installation, this path may change
     // but in most cases it will work this way
     require("../../../wp-config.php");
     // connecting to wp database
     $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
     // selecting the proper database
     $db = mysql_select_db($link,DB_NAME);
     // inserting the game tag, the score and the player name
     $result = mysql_query("insert into ".$table_prefix."mochi_scores (gameid,name,score) values('$_POST[gameID]','$_POST[name]','$_POST[score]')");
}
 
?>

<?php
/*
Plugin Name: Mochi lastscores
Plugin URI: http://www.emanueleferonato.com/
Description: Displays last scores submitted in your MochiAds Arcade
Author: Emanuele Feronato
Version: 1.0
Author URI: http://www.emanueleferonato.com/
*/
 
function mochi_lastscores_widget() {
     global $wpdb;
     echo"<li><h2>LATEST SCORES</h2>";
     // selecting the latest 10 scores
     $query = "select * from ".$wpdb->prefix."mochi_scores order by id desc limit 0,10";
     // saving scores inside an array called "scores"
     $scores = $wpdb->get_results($query,ARRAY_A);
     if($scores){
          echo "<ul>";
          // scanning all scores
          foreach($scores as $score){
               // looking for the entry in my mochi game table with the same game tag as the one I saved
               $query = "select * from ".$wpdb->prefix."mochi where game_tag = \"$score[gameid]\"";
               // saving the entry in an array called "game"
               $game = $wpdb->get_results($query,ARRAY_A);
               // if the entry has a blog_id...
               if($game[0][blog_id]){
                    // selecting the post in the wp post table with the same id as the game found in the mochi games table
                    $query = "select * from ".$wpdb->prefix."posts where ID = ".$game[0][blog_id];
                    // saving the entry in a variable called "post"
                    $post = $wpdb->get_results($query,ARRAY_A);
                    // printing the entry in the theme
                    echo "<li><span class = \"turnwhite\">$score[name]</span> just scored <span class = \"turnwhite\">$score[score]</span> on <a href = \"".$post[0][guid]."\">".$game[0][name]."</a></li>";
               }
          }
          echo "</ul>";
     }
     echo "</li>";
}
 
function init_mochi_lastscores(){
     register_sidebar_widget("Mochi Last Scores", "mochi_lastscores_widget");     
}
 
add_action("plugins_loaded", "init_mochi_lastscores");
 
?>