topical media & game development

talk show tell print

game-php-score-vu-displayscore.php / php



  <?
  server = mysql_connect("localhost",  "USER", "PASS"); 
  mysql_select_db("DB", server);  
    
  //  session_start(); 
  //define('nextGenGaming', true ); 
  time=timee=time();
  datum = date("d-m-Y H:i");
  
          game=addslashes(_REQUEST['game']);
          level=addslashes(_REQUEST['level']);
   
           if(what=='top5'){
                    echo "Top 10 ever:\n";
              query = "SELECT name, score FROM highscores WHERE game='game' && level='level' ORDER by score ASC LIMIT 10";
              result = mysql_query(query) or die('Query failed: ' . mysql_error());         
              num_results = mysql_num_rows(result);           
              for(i = 0; i < num_results; i++)
              {
                   row = mysql_fetch_array(result);
                   echo "\t". row['score'] . " seconds". " \t\t\t " .row['name']."\n";
              }
              
              echo"\n";
              
                  timeout=time()-3600*24;
               echo "Top 10 today:\n";
              query = "SELECT name, score FROM highscores WHERE game='game' && level='level' && time>'timeout' ORDER by score ASC LIMIT 10";
              result = mysql_query(query) or die('Query failed: ' . mysql_error());         
              num_results = mysql_num_rows(result);           
              for(i = 0; i < num_results; i++)
              {
                   row = mysql_fetch_array(result);
                   echo "\t". row['score'] . " seconds". " \t\t\t " .row['name']."\n";
              }                
                  
          }
  ?>


(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.