<?
/* Copyright 2000 KMR Enterprises Scripted by TDavid @ http://www.tdscripts.com/ 
php-scripts.com Example #28 Purpose: to update a mySQL database with current ratings
This code is made available freely to modify as long as this COMPLETE header is not removed. If you decide to use this code then please put up a reciprocal link back to our site at http://www.tdscripts.com/ We cannot, and will not, be held liable for any use or misuse of the code contained herein. Any upload or execution of the code implies understanding and agreement of these terms of use.
*/ 

// mySQL data
$db = "databasename";
$admin = "your_mysql_username";
$adpass = "your_mysql_password";
$mysql_link = mysql_connect("localhost", $admin, $adpass);
mysql_select_db($db, $mysql_link);
function average2($filename) 
{
  global $average;
  $x = -1;
  if($file = fopen("$filename", "r"))
  {
     while(!feof($file))
    {
     $therate = fgetss($file, 255);
     $x++;
     $count = $count + $therate;
    }
  fclose($file);
  }
$average = ($count / $x);
return ($average);
}
/* create table named avg_tally before running this 
   script using your mySQL monitor

CREATE TABLE avg_tally
(
AVG_ID INT NOT NULL AUTO_INCREMENT,
average FLOAT,
filename CHAR(6),
meta_desc VARCHAR(150),
PRIMARY KEY(AVG_ID)
);
*/
// reset contents of mySQL table on each run
mysql_query("DELETE from avg_tally", $mysql_link);
$datapath = "/home/path/to/public_html/votedir/data";
chdir("$datapath");
$maindir = dir(".");
$maindir ->rewind();
  while($thefile=$maindir->read()) 
 {
   if(($thefile != ".") AND ($thefile != "..") AND ($thefile != "index.html"))
   {
     $myvalue = average2("$datapath/$thefile");
     $myvalue = sprintf("%.2f", $myvalue);
     $file = explode(".", $thefile);
     $phpfile = "http://www.yourdomain.com/votedir/" . $file[0] . ".php3";
     $meta = get_meta_tags($phpfile);
     $desc = $meta["description"];
       // generate the mySQL query
       $query = "INSERT into avg_tally VALUES (0, ";
       $query .= "'$myvalue', '$file[0]', '$desc')";
       mysql_query($query, $mysql_link);
    }
  }
$maindir->close();
print("Successfully updated rating table.");
?>