<?php
include 'functions.php';
validatecookie();
include("database.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Matt's March Madness</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Language" content="en-us" />
<meta name="author" content="Matt Felser" />
<style type="text/css" media="all">@import "../images/style.css";</style>
</head>
<body>
<div class="content">
<div id="top">
<div class="rightlinks">| <a href="http://sourceforge.net/projects/mmm"><span class="info">Copyright © 2007-2008 Matt Felser </span></a></div>
</div>
<div id="header">
<div class="info">
<h1>Matt's March Madness</h1>
<h2>Site Administration</h2>
</div>
</div>
<div id="subheader">
<div id="menu">
<ul>
<li><a href="../admin/">ADMIN AREA</a></li>
</ul>
</div>
</div>
<div id="main">
<div class="full">
<h2>Install Status</h2>
<?php
function parse_mysql_dump($url,$db){
$file_content = file($url);
$sql = "";
foreach($file_content as $sql_line)
{
if(trim($sql_line) != "" && strpos($sql_line, "--") === false && strpos($sql_line, "# ") === false)
{
$sql .= $sql_line;
}
if( strpos(trim($sql_line),";") == true )
{
//echo $sql."<br><br>";
mysql_query($sql,$db) or die(mysql_error());
$sql ="";
}
}
}
// Indentify version of mmm, then load the appropriate .sql files
$overwriteDb = false;
if(isset($_POST['overwrite_db'])) {
$overwriteDb = true;
}
if( !overwriteDb )
{
$findDbVersQuery = "SHOW COLUMNS FROM `meta` WHERE `field`='db_version'";
$version = mysql_query($findDbVersQuery,$db) or die(mysql_error());
$version = mysql_fetch_array($version);
if( count($version) > 0 )
{
$findDbVersQuery = "SELECT `db_version` FROM `meta`";
$version = mysql_query($findDbVersQuery,$db) or die(mysql_error());
$version = mysql_fetch_array($version);
$db_version = "ver ".$version['db_version'];
}
else
{
$db_version = $mmm_vers;
}
}
$tablesExist = false;
$new1_3 = false;
$update1_5 = false;
$update1_5_1 = false;
$new1_5_1 = false;
if( $db_version == NULL )
{
if( $overwriteDb )
{
echo "Detected mmm version 1.0.3 ... installing fresh 1.5.1 database";
$new1_5_1 = true;
}
else
{
echo "Detected mmm version 1.0.3 ... uprading to 1.5.1 database";
$update1_5 = true;
$update1_5_1 = true;
}
}
else if( $db_version == "ver 1.0.3" )
{
if( $overwriteDb )
{
echo "Detected mmm version 1.0.3 ... installing fresh 1.5.1 database";
$new1_5_1 = true;
}
else
{
echo "Detected mmm version 1.0.3 ... uprading to 1.5.1 database";
$update1_5 = true;
$update1_5_1 = true;
}
}
else if( $db_version == "ver 1.5" )
{
if( $overwriteDb )
{
echo "Detected mmm version 1.5 ... installing fresh 1.5.1 database";
$new1_5_1 = true;
}
else
{
echo "Detected mmm version 1.5 ... upgrading to 1.5.1 database";
$update1_5_1 = true;
}
}
else if( $db_version == "ver 1.5.1" )
{
if( $overwriteDb )
{
echo "Detected mmm version 1.5.1 ... installing fresh 1.5.1 database";
$new1_5_1 = true;
}
else
{
echo "Detected mmm version 1.5.1 ... not updating database because the existing one should be fine";
}
}
if( $new1_3 )
{
parse_mysql_dump("structure.sql",$db);
}
if( $update1_5 )
{
parse_mysql_dump("convert_1_0_3_to_1_5_structure.sql",$db);
}
if( $update1_5_1 )
{
parse_mysql_dump("convert_1_5_to_1_5_1_structure.sql",$db);
}
if( $new1_5_1 )
{
parse_mysql_dump("structure_1_5_1.sql",$db);
}
if(isset($_POST['mail'])) {
$mail = 1;
}
else {
$mail = 0;
}
$_POST['title'] = str_replace("'","''",$_POST['title']);
$_POST['subtitle'] = str_replace("'","''",$_POST['subtitle']);
$meta = "INSERT INTO `meta` (`title`,`subtitle`,`cost`,`cut`,`cutType`,`name`,`email`,`sweet16`,`closed`,`rules`,`mail`,`region1`,`region2`,`region3`,`region4`,`db_version`) VALUES ('$_POST[title]','$_POST[subtitle]','$_POST[cost]','$_POST[cut]','$_POST[cutType]','$_POST[name]','$_POST[email]',0,0,'<p>No additional rules have been set.</p>','$mail','$_POST[region1name]','$_POST[region2name]','$_POST[region3name]','$_POST[region4name]','1.5.1')";
mysql_query($meta,$db) or die(mysql_error());
$pwq = "INSERT INTO `passwords` (`label`,`value`) VALUES ('admin_password','".md5($_POST[password])."') ON DUPLICATE KEY UPDATE value = '".md5($_POST[password])."'";
mysql_query($pwq,$db) or die(mysql_error());
mysql_query("DELETE FROM `scoring` WHERE type='main'",$db) or die(mysql_error());
$main_scoring = "INSERT INTO `scoring` (`seed`, `1`, `2`, `3`, `4`, `5`, `6`, `type`) VALUES ";
for( $i=1; $i < 17; $i++ )
{
$row = "('".$i."',";
for( $j=1; $j < 6; $j++ )
{
$row .= "'".$_POST[$i."-".$j."_scoring"]."',";
}
$row .= "'".$_POST[$i."-".$j."_scoring"]."','main')";
if( $i < 16 )
{
$row .= ",";
}
$main_scoring .= $row;
}
mysql_query($main_scoring,$db) or die(mysql_error());
// Update the scoring_info table for scoring type main
mysql_query("DELETE FROM `scoring_info` WHERE type='main'",$db) or die(mysql_error()) or die(mysql_error());
$scoring = mysql_query("SELECT seed,`1`,`2`,`3`,`4`,`5`,`6` FROM `scoring` WHERE `type` = 'main' ORDER BY `seed`",$db) or die(mysql_error());
$table_text = "<table border='1' align='center'><tr><td colspan='8'>Value of a win by a seed in a particular round</td></tr><tr><td>Seed #</td><td>R1</td><td>R2</td><td>R3</td><td>R4</td><td>R5</td><td>R6</td></tr>";
while ($row = mysql_fetch_assoc($scoring))
{
$table_text .= "<tr><td>".$row['seed']."</td>";
for( $i=1; $i < 7; $i++ )
{
$table_text .= "<td>".$row[$i]."</td>";
}
$table_text .= "</tr>";
}
$table_text .= "</table>";
mysql_query("INSERT INTO `scoring_info` (`type`,`display_name`, `description`) VALUES ('main','Actual','".addslashes($table_text)."')") or die(mysql_error());
echo "<br>If no errors appear above, installation is complete!";
?>
</div>
</div>
</div>
</body>
</html>