echo " </table>\n"; echo " </td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td align=\"left\"> </td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td align=\"center\">", form_submit("updatelinksubmit", gettext("Save")), " ", form_submit("delete", gettext("Delete")), " ", form_submit("cancel", gettext("Cancel")), "</td>\n"; echo " </tr>\n"; echo " </table>\n"; echo " </form>\n"; echo "</div>\n"; html_draw_bottom(); } else { html_draw_top(array('title' => gettext('Admin - Edit Forum Links'), 'class' => 'window_title', 'main_css' => 'admin.css')); $forum_links_array = forum_links_get_links_by_page($page); echo "<h1>", gettext("Admin"), html_style_image('separator'), gettext("Edit Forum Links"), "</h1>\n"; if (isset($error_msg_array) && sizeof($error_msg_array) > 0) { html_display_error_array($error_msg_array, '86%', 'center'); } else { if (isset($_GET['added'])) { html_display_success_msg(gettext("Successfully added new forum link"), '86%', 'center'); } else { if (isset($_GET['edited'])) { html_display_success_msg(gettext("Successfully edited forum link"), '86%', 'center'); } else { if (isset($_GET['deleted'])) { html_display_success_msg(gettext("Successfully removed selected links"), '86%', 'center'); } else { if (isset($_GET['updated'])) { html_display_success_msg(gettext("Preferences were successfully updated."), '86%', 'center');
function forum_links_get_links_by_page($page = 1) { if (!($db = db::get())) { return false; } if (!is_numeric($page) || $page < 1) { $page = 1; } $offset = calculate_page_offset($page, 10); if (!($table_prefix = get_table_prefix())) { return false; } $forum_links_array = array(); $sql = "SELECT SQL_CALC_FOUND_ROWS LID, POS, URI, TITLE "; $sql .= "FROM `{$table_prefix}FORUM_LINKS` "; $sql .= "ORDER BY POS ASC LIMIT {$offset}, 10"; if (!($result = $db->query($sql))) { return false; } $sql = "SELECT FOUND_ROWS() AS ROW_COUNT"; if (!($result_count = $db->query($sql))) { return false; } list($forum_links_count) = $result_count->fetch_row(); if ($result->num_rows == 0 && $forum_links_count > 0 && $page > 1) { return forum_links_get_links_by_page($page - 1); } while ($forum_links_data = $result->fetch_assoc()) { if (!isset($forum_links_data['URI'])) { $forum_links_data['URI'] = ""; } if (!isset($forum_links_data['TITLE'])) { $forum_links_data['TITLE'] = "-"; } $forum_links_array[] = $forum_links_data; } return array('forum_links_array' => $forum_links_array, 'forum_links_count' => $forum_links_count); }