sqlfile("schema.drop", $sql);
echo "<b>Setting Up Defaults...</b><br><br>";
sqlfile("default", $sql);
if (isset($_REQUEST['example'])) {
echo "<b>Setting Up Examples...</b><br><br>";
sqlfile("example", $sql);
}
} else {
if ($_REQUEST['insttype'] == "upgrade") {
echo "<b>Experimental Upgrade... Expect to See Errors</b><br>";
echo "Doesn't mean it hasn't worked if you see already exists/duplicate errors<br><br>";
echo "<b style=\"color: red;\">Basically ignore errors: 1050, 1060, 1068 and 1054</b><br><br>";
echo "<b>Importing New Schema (sans drop tables)</b><br><br>";
sqlfile("schema", $sql);
echo "<br><br><b>Doing Schema Upgrade</b><br><br>";
sqlfile("schema.upgrade", $sql);
echo "<br><br>";
} else {
echo "<b>Error: Incorrect or Unknown Installation Type!</b><br><br>";
}
}
if (isset($_REQUEST['tracker'])) {
echo "<b>Enabling Usage Tracker</b><br><br>";
$q = "INSERT INTO fnconfig(fnc_var,fnc_val) VALUES(\"freenats.tracker\",\"1\")";
mysqli_query($sql, $q);
}
echo "<br><br>";
echo "<b>CONGRATULATIONS!!</b><br><br>";
echo "Setup should now be complete. If you saw errors etc above please see the <a href=http://www.purplepixie.org/freenats/>";
echo "project homepage</a> for help.<br><br>";
echo "<b>RENAME THIS FILE "firstrun.php" TO SOMETHING ELSE LIKE "firstrun-.php" TO STOP OTHERS RUNNING IT</b>";
sqlfile("schema.drop");
echo "<b>Setting Up Defaults...</b><br><br>";
sqlfile("default");
if (isset($_REQUEST['example'])) {
echo "<b>Setting Up Examples...</b><br><br>";
sqlfile("example");
}
} else {
if ($_REQUEST['insttype'] == "upgrade") {
echo "<b>Experimental Upgrade... Expect to See Errors</b><br>";
echo "Doesn't mean it hasn't worked if you see already exists/duplicate errors<br><br>";
echo "<b style=\"color: red;\">Basically ignore errors: 1050, 1060, 1068 and 1054</b><br><br>";
echo "<b>Importing New Schema (sans drop tables)</b><br><br>";
sqlfile("schema");
echo "<br><br><b>Doing Schema Upgrade</b><br><br>";
sqlfile("schema.upgrade");
echo "<br><br>";
} else {
echo "<b>Error: Incorrect or Unknown Installation Type!</b><br><br>";
}
}
if (isset($_REQUEST['tracker'])) {
echo "<b>Enabling Usage Tracker</b><br><br>";
$q = "INSERT INTO fnconfig(fnc_var,fnc_val) VALUES(\"freenats.tracker\",\"1\")";
mysql_query($q);
}
echo "<br><br>";
echo "<b>CONGRATULATIONS!!</b><br><br>";
echo "Setup should now be complete. If you saw errors etc above please see the <a href=http://www.purplepixie.org/freenats/>";
echo "project homepage</a> for help.<br><br>";
echo "<b>RENAME THIS FILE "firstrun.php" TO SOMETHING ELSE LIKE "firstrun-.php" TO STOP OTHERS RUNNING IT</b>";