PHP admin_get_link_approval_queue示例

示例#1

文件： admin_link_approve.php 项目： richstokoe/BeehiveForum

        echo "    <tr>\n";
        echo "      <td>&nbsp;</td>\n";
        echo "    </tr>\n";
        echo "    <tr>\n";
        echo "      <td align=\"center\">", form_submit("approve", gettext("Approve")), "&nbsp;", form_submit("delete", gettext("Delete")), "&nbsp;", 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_error(gettext("Invalid link ID!"), 'admin_link_approve.php', 'post', array('cancel' => gettext("Cancel")), array('ret' => $ret), '_self', 'center');
    }
} else {
    html_draw_top(sprintf('title=%s', gettext("Admin - Link Approval Queue")), 'class=window_title');
    $link_approval_array = admin_get_link_approval_queue($page);
    echo "<h1>", gettext("Admin"), "<img src=\"", html_style_image('separator.png'), "\" alt=\"\" border=\"0\" />", gettext("Link Approval Queue"), "</h1>\n";
    if (sizeof($link_approval_array['link_array']) < 1) {
        html_display_warning_msg(gettext("No links are awaiting approval"), '86%', 'center');
    }
    echo "<br />\n";
    echo "<div align=\"center\">\n";
    echo "  <table cellpadding=\"0\" cellspacing=\"0\" width=\"86%\">\n";
    echo "    <tr>\n";
    echo "      <td align=\"left\">\n";
    echo "        <table class=\"box\" width=\"100%\">\n";
    echo "          <tr>\n";
    echo "            <td align=\"left\" class=\"posthead\">\n";
    echo "              <table class=\"posthead\" width=\"100%\">\n";
    echo "                 <tr>\n";
    echo "                   <td class=\"subhead\" align=\"left\" width=\"20\">&nbsp;</td>\n";

示例#2

文件： admin.inc.php 项目： richstokoe/BeehiveForum

function admin_get_link_approval_queue($page = 1)
{
    if (!($db = db::get())) {
        return false;
    }
    if (!is_numeric($page) || $page < 1) {
        $page = 0;
    }
    $offset = calculate_page_offset($page, 10);
    if (!($table_prefix = get_table_prefix())) {
        return false;
    }
    if (!session::check_perm(USER_PERM_LINKS_MODERATE, 0)) {
        return false;
    }
    $link_approval_array = array();
    $sql = "SELECT SQL_CALC_FOUND_ROWS LINKS_FOLDERS.NAME AS FOLDER_TITLE, ";
    $sql .= "LINKS.LID, LINKS.URI, LINKS.TITLE, LINKS.DESCRIPTION, USER.UID, ";
    $sql .= "USER.LOGON, USER.NICKNAME, UNIX_TIMESTAMP(LINKS.CREATED) AS CREATED ";
    $sql .= "FROM `{$table_prefix}LINKS` LINKS LEFT JOIN USER USER ON (USER.UID = LINKS.UID) ";
    $sql .= "LEFT JOIN `{$table_prefix}LINKS_FOLDERS` LINKS_FOLDERS ON (LINKS_FOLDERS.FID = LINKS.FID) ";
    $sql .= "WHERE LINKS.APPROVED IS NULL ";
    $sql .= "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($link_count) = $result_count->fetch_row();
    if ($result->num_rows == 0 && $link_count > 0 && $page > 1) {
        return admin_get_link_approval_queue($page - 1);
    }
    while ($link_array = $result->fetch_assoc()) {
        $link_approval_array[] = $link_array;
    }
    return array('link_count' => $link_count, 'link_array' => $link_approval_array);
}