function create_forum()
{
global $db, $lang;
static $forum_created = false;
static $forum_id = 0;
$cat_id = create_cat();
if (!$forum_created) {
// Identify the highest value of forum_id
$sql = 'SELECT MAX(forum_id) AS forum_id
FROM ' . FORUMS_TABLE;
$db->sql_return_on_error(true);
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$row) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$next_forum_id = $row['forum_id'] + 1;
// Identify the highest value of forum_order
$sql = 'SELECT MAX(forum_order) AS forum_order
FROM ' . FORUMS_TABLE;
$db->sql_return_on_error(true);
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$row) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$next_forum_order = $row['forum_order'] + 10;
$forum_permission = AUTH_ADMIN;
$sql = 'INSERT INTO ' . FORUMS_TABLE . " (forum_id, forum_type, parent_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments)\n\t\t\tVALUES ({$next_forum_id}, " . FORUM_POST . ", {$cat_id}, '" . $db->sql_escape($lang['New_forum_name']) . "', '', " . FORUM_LOCKED . ", {$next_forum_order}, 0, 0, 0, NULL, 0, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, 0)";
$db->sql_return_on_error(true);
$result = $db->sql_query($sql);
$db->sql_return_on_error(false);
if (!$result) {
throw_error("Couldn't update forums data!", __LINE__, __FILE__, $sql);
}
$forum_id = $next_forum_id;
$forum_created = true;
}
return $forum_id;
}
function create_forum()
{
global $db, $lang;
static $forum_created = FALSE;
static $forum_id = 0;
$cat_id = create_cat();
if (!$forum_created) {
// Höchten Wert von forum_id ermitteln
$sql = 'SELECT Max(forum_id) AS forum_id
FROM ' . FORUMS_TABLE;
$result = $db->sql_query($sql);
if (!$result) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$row) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$next_forum_id = $row['forum_id'] + 1;
// Höchten Wert von forum_order ermitteln
$sql = 'SELECT Max(forum_order) AS forum_order
FROM ' . FORUMS_TABLE . "\r\n\t\t\tWHERE cat_id = {$cat_id}";
$result = $db->sql_query($sql);
if (!$result) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$db->sql_freeresult($result);
if (!$row) {
throw_error("Couldn't get forum data!", __LINE__, __FILE__, $sql);
}
$next_forum_order = $row['forum_order'] + 10;
$forum_permission = AUTH_ADMIN;
$sql = 'INSERT INTO ' . FORUMS_TABLE . " (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments)\r\n\t\t\tVALUES ({$next_forum_id}, {$cat_id}, '" . $lang['New_forum_name'] . "', '', " . FORUM_LOCKED . ", {$next_forum_order}, 0, 0, 0, NULL, 0, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, {$forum_permission}, 0)";
$result = $db->sql_query($sql);
if (!$result) {
throw_error("Couldn't update forums data!", __LINE__, __FILE__, $sql);
}
$forum_id = $next_forum_id;
$forum_created = TRUE;
}
return $forum_id;
}
} else {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "EMPLOYEE_TYPE</td>\n\n\t\t\t\t<td><font color=\"green\"><b>OK</b></font></td>\n\n\t\t\t</tr>\n";
}
##################################
# create_cart #
##################################
if (!create_cart($db)) {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "CART</td>\n\n\t\t\t\t<td><font color=\"red\"><b>Failed:</b></font> " . $db->ErrorMsg() . "</td>\n\n\t\t\t</tr>\n";
$error_flag = true;
} else {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "CART</td>\n\n\t\t\t\t<td><font color=\"green\"><b>OK</b></font></td>\n\n\t\t\t</tr>\n";
}
##################################
# create_cat #
##################################
if (!create_cat($db)) {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "CAT</td>\n\n\t\t\t\t<td><font color=\"red\"><b>Failed:</b></font> " . $db->ErrorMsg() . "</td>\n\n\t\t\t</tr>\n";
$error_flag = true;
} else {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "CAT</td>\n\n\t\t\t\t<td><font color=\"green\"><b>OK</b></font></td>\n\n\t\t\t</tr>\n";
}
##################################
# create_orders #
##################################
if (!create_orders($db)) {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "ORDERS</td>\n\n\t\t\t\t<td><font color=\"red\"><b>Failed:</b></font> " . $db->ErrorMsg() . "</td>\n\n\t\t\t</tr>\n";
$error_flag = true;
} else {
echo "<tr>\n\n\t\t\t\t<td>CREATE TABLE IF NOT EXISTS " . PRFX . "ORDERS</td>\n\n\t\t\t\t<td><font color=\"green\"><b>OK</b></font></td>\n\n\t\t\t</tr>\n";
}
##################################
if (!$list_open) {
echo "<p class=\"gen\">" . $lang['Invalid_forums_found'] . ":</p>\n";
echo "<font class=\"gen\"><ul>\n";
$list_open = TRUE;
}
echo "<li>" . htmlspecialchars($row['forum_name']) . " (" . $row['forum_id'] . ")</li>\n";
$result_array[] = $row['forum_id'];
}
$db->sql_freeresult($result);
if ($list_open) {
echo "</ul></font>\n";
$list_open = FALSE;
}
if (count($result_array)) {
$record_list = implode(',', $result_array);
$new_cat = create_cat();
echo "<p class=\"gen\">" . sprintf($lang['Setting_category'], $lang['New_cat_name']) . " </p>\n";
$sql = "UPDATE " . FORUMS_TABLE . "\n\t\t\t\t\t\tSET cat_id = {$new_cat}\n\t\t\t\t\t\tWHERE forum_id IN ({$record_list})";
$result = $db->sql_query($sql);
if (!$result) {
throw_error("Couldn't update forum information!", __LINE__, __FILE__, $sql);
}
} else {
echo $lang['Nothing_to_do'];
}
// Check for posts without a text
echo "<p class=\"gen\"><b>" . $lang['Checking_posts_wo_text'] . "</b></p>\n";
$sql = "SELECT p.post_id, t.topic_id, t.topic_title, u.user_id, u.username\n\t\t\t\t\tFROM " . POSTS_TABLE . " p\n\t\t\t\t\t\tLEFT JOIN " . POSTS_TEXT_TABLE . " pt ON p.post_id = pt.post_id\n\t\t\t\t\t\tLEFT JOIN " . TOPICS_TABLE . " t ON p.topic_id = t.topic_id\n\t\t\t\t\t\tLEFT JOIN " . USERS_TABLE . " u ON p.poster_id = u.user_id\n\t\t\t\t\tWHERE pt.post_id IS NULL";
$result_array = array();
$result = $db->sql_query($sql);
if (!$result) {
