stats/alter_table.php

<?php

require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_dashboard_rw.class.php";
require_once "hostname.php";

$db_connection = new DBConnectionDashboard();
$db_handle = $db_connection->connect();

$query = "ALTER TABLE ".stats_table()." ADD (";

// Mail stats
$query .= "mail_7_number_posts smallint, mail_7_average_posts float, mail_7_number_subscribers smallint, mail_7_average_subscribers float, ";
$query .= "mail_30_number_posts smallint, mail_30_average_posts float, mail_30_number_subscribers smallint, mail_30_average_subscribers float, ";
$query .= "mail_180_number_posts smallint, mail_180_average_posts float, mail_180_number_subscribers smallint, mail_180_average_subscribers float)";


echo $query."<br>";

mysql_query($query,$db_handle) or die("Could not alter table: ".mysql_error());

$db_handle = null;
$db_connection = null;
?>