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) {