function createDb($connection)
{
//Drop all tables
$sql1 = 'DROP TABLE IF EXISTS story;';
$sql2 = 'DROP TABLE IF EXISTS tasks;';
$sql3 = 'DROP TABLE IF EXISTS comments;';
$sql4 = 'DROP TABLE IF EXISTS history;';
$sql5 = 'DROP TABLE IF EXISTS epics;';
$sql6 = 'DROP TABLE IF EXISTS labels;';
$sql7 = 'DROP TABLE IF EXISTS attachments;';
$connection->query($sql1);
$connection->query($sql2);
$connection->query($sql3);
$connection->query($sql4);
$connection->query($sql5);
$connection->query($sql6);
$connection->query($sql7);
//Create tables
createTableStory($connection);
createTableTasks($connection);
createTableComments($connection);
createTableHistory($connection);
createTableEpics($connection);
createTableLabels($connection);
createTableAttachments($connection);
return true;
}
function createTables($user, $password, $server, $DBname)
{
$dbh = mysql_connect($server, $user, $password) or die('WebChess cannot connect to the database.
Please check the database settings you provided.<br>');
mysql_select_db($DBname);
//$logMsg .= "Probing for table games..\n";
echo "Probing for table games..<br>";
if (!tableExists("games")) {
//$logMsg .= "Creating table games..\n";
echo "Creating table games..<br>";
$result = createTableGames();
showMessage($result);
} else {
showProbingMessage(true);
}
//$logMsg .= "Probing for table history..\n";
echo "Probing for table history..<br>";
if (!tableExists("history")) {
//$logMsg .= "Creating table history..\n";
echo "Creating table history..<br>";
$result = createTableHistory();
showMessage($result);
} else {
showProbingMessage(true);
}
//$logMsg .= "Probing for table messages..\n";
echo "Probing for table messages..<br>";
if (!tableExists("messages")) {
//$logMsg .= "Creating table messages..\n";
echo "Creating table messages..<br>";
$result = createTableMessages();
showMessage($result);
} else {
showProbingMessage(true);
}
//$logMsg .= "Probing for table pieces..\n";
echo "Probing for table pieces..<br>";
if (!tableExists("pieces")) {
//$logMsg .= "Creating table pieces..\n";
echo "Creating table pieces..<br>";
$result = createTablePieces();
showMessage($result);
} else {
showProbingMessage(true);
}
// ToDo: consider checking for fields named "pCol" and "pRow" in "pieces" table (n8chessnet) or updating to pCol and pRow
//$logMsg .= "Probing for table players..\n";
echo "Probing for table players..<br>";
if (!tableExists("players")) {
//$logMsg .= "Creating table players..\n";
echo "Creating table players..<br>";
$result = createTablePlayers();
showMessage($result);
} else {
//$logMsg .= "Table players exists. Checking if table players has field lastAccess..\n";
echo "Table players exists. Checking if table players has the lastAccess field..<br>";
// Check if field "lastAccess" exists..
if (!tablePlayersHasLastAccessField()) {
// if false: update by calling addLastAccessFieldToPlayersTable()
//$logMsg .= "Adding lastAccess field..\n";
echo "Adding lastAccess field..<br>";
addLastAccessFieldToPlayersTable();
} else {
echo "Field lastAccess exists. Nothing done.<br>";
}
}
//$logMsg .= "Probing for table preferences..\n";
echo "Probing for table preferences..<br>";
if (!tableExists("preferences")) {
//$logMsg .= "Creating table preferences..\n";
echo "Creating table preferences..<br>";
$result = createTablePreferences();
showMessage($result);
} else {
showProbingMessage(true);
}
//$logMsg .= "Probing for table communication..\n";
echo "Probing for table communication..<br>";
if (!tableExists("communication")) {
//$logMsg .= "Creating table communication..\n";
echo "Creating table communication..<br>";
$result = createTableCommunication();
showMessage($result);
//$logMsg .= "Inserting message to communication table..\n";
echo "Inserting message to communication table....<br>";
$result = insertSampleFieldIntoCommunications();
if ($result == 1) {
echo "message inserted correctly.";
} else {
echo "<b>ERROR</b>! The field message was not inserted correctly!";
}
} else {
showProbingMessage(true);
}
//ToDo: Make logfile work properly.
//Without the proper permision, php won't be able to write any file.
//In many free web hosting providers it won't be possible to allow proper
//write permision, so it is not advisable to use this. It is needed a workaround.
//Following code comented until this workaround is found.
//echo ereg_replace("\n","<br />",$logMsg);
//writeLogFile($logMsg);
mysql_query("quit");
}
