PHP Sql_fetch_Row函数代码示例

    $total = count($admins);
    $found = $total;
    $ls = new WebblerListing($GLOBALS['I18N']->get('Administrators'));
    foreach ($admins as $adminid => $adminname) {
        $ls->addElement($adminname);
        #,PageUrl2("admin",$GLOBALS['I18N']->get('Show'),"id=".$adminid));
    }
    print $ls->display();
    return;
} else {
    if (!$find) {
        $result = Sql_query('SELECT count(*) FROM ' . $tables['admin']);
    } else {
        $result = Sql_query('SELECT count(*) FROM ' . $tables['admin'] . " where loginname like \"%{$find}%\" or email like \"%{$find}%\"");
    }
    $totalres = Sql_fetch_Row($result);
    $total = $totalres[0];
}
print '<p class="info">' . $total . ' ' . $GLOBALS['I18N']->get('Administrators');
print $find ? ' ' . $GLOBALS['I18N']->get('found') . '</p>' : '</p>';
$paging = '';
if ($total > MAX_USER_PP) {
    $paging = simplePaging("admins{$remember_find}", $start, $total, MAX_USER_PP, $GLOBALS['I18N']->get('Administrators'));
}
$limit = '';
if ($total > MAX_USER_PP) {
    if (isset($start) && $start) {
        $limit = "limit {$start}," . MAX_USER_PP;
    } else {
        $limit = 'limit 0,50';
        $start = 0;

function getUserConfig($item, $userid = 0)
{
    global $default_config, $tables, $domain, $website;
    $hasconf = Sql_Table_Exists($tables["config"]);
    $value = '';
    if ($hasconf) {
        $query = 'select value,editable from ' . $tables['config'] . ' where item = ?';
        $req = Sql_Query_Params($query, array($item));
        if (!Sql_Num_Rows($req)) {
            if (array_key_exists($item, $default_config)) {
                $value = $default_config[$item]['value'];
            }
        } else {
            $row = Sql_fetch_Row($req);
            $value = $row[0];
            if ($row[1] == 0) {
                $GLOBALS['noteditableconfig'][] = $item;
            }
        }
    }
    # if this is a subpage item, and no value was found get the global one
    if (!$value && strpos($item, ":") !== false) {
        list($a, $b) = explode(":", $item);
        $value = getUserConfig($a, $userid);
    }
    if ($userid) {
        $query = 'select uniqid, email from ' . $tables['user'] . ' where id = ?';
        $rs = Sql_Query_Params($query, array($userid));
        $user_req = Sql_Fetch_Row($rs);
        $uniqid = $user_req[0];
        $email = $user_req[1];
        # parse for placeholders
        # do some backwards compatibility:
        # hmm, reverted back to old system
        $url = getConfig("unsubscribeurl");
        $sep = strpos($url, '?') !== false ? '&' : '?';
        $value = str_ireplace('[UNSUBSCRIBEURL]', $url . $sep . 'uid=' . $uniqid, $value);
        $url = getConfig("confirmationurl");
        $sep = strpos($url, '?') !== false ? '&' : '?';
        $value = str_ireplace('[CONFIRMATIONURL]', $url . $sep . 'uid=' . $uniqid, $value);
        $url = getConfig("preferencesurl");
        $sep = strpos($url, '?') !== false ? '&' : '?';
        $value = str_ireplace('[PREFERENCESURL]', $url . $sep . 'uid=' . $uniqid, $value);
        $value = str_ireplace('[EMAIL]', $email, $value);
        $value = parsePlaceHolders($value, getUserAttributeValues($email));
    }
    $value = str_ireplace('[SUBSCRIBEURL]', getConfig("subscribeurl"), $value);
    $value = preg_replace('/\\[DOMAIN\\]/i', $domain, $value);
    #@ID Should be done only in one place. Combine getConfig and this one?
    $value = preg_replace('/\\[WEBSITE\\]/i', $website, $value);
    if ($value == "0") {
        $value = "false";
    } elseif ($value == "1") {
        $value = "true";
    }
    return $value;
}

                $subselect .= ' !confirmed ';
            } else {
                $subselect .= ' blacklisted';
            }
        } else {
            $searchdone = 0;
        }
        $listquery = "select {$tables['user']}.email,{$tables['user']}.id,{$findfield},{$tables['user']}.confirmed from " . $table_list . ' ' . $subselect;
        $count = Sql_query('SELECT count(*) FROM ' . $table_list . ' ' . $subselect);
        $unconfirmedcount = Sql_query('SELECT count(*) FROM ' . $table_list . ' where !confirmed');
    }
    $delete_message = '<br />' . $GLOBALS['I18N']->get('Delete will delete user and all listmemberships') . '<br />';
}
$totalres = Sql_fetch_Row($unconfirmedcount);
$totalunconfirmed = $totalres[0];
$totalres = Sql_fetch_Row($count);
$total = $totalres[0];
if ($start > $total) {
    $start = 0;
}
if (!empty($delete) && isSuperUser()) {
    # delete the index in delete
    $action_result = $GLOBALS['I18N']->get('deleting') . " {$delete} ..\n";
    deleteUser($delete);
    $action_result .= '..' . $GLOBALS['I18N']->get('Done') . '<br/><hr/>';
    $previous_search = '';
    if (!$find == '') {
        $previous_search = "&start={$start}&find={$find}&findby={$findby}";
    }
    $_SESSION['action_result'] = $action_result;
    Redirect("users{$previous_search}");

 if ($new || !$new && $_POST["overwrite"]) {
     # now check for attributes and list membership
     connectRemote();
     $useratt = array();
     $req = Sql_Query("select * from {$remote_tables["user_attribute"]},\n        {$remote_tables["attribute"]} where {$remote_tables["user_attribute"]}.attributeid =\n        {$remote_tables["attribute"]}.id and {$remote_tables["user_attribute"]}.userid = {$user['0']}");
     while ($att = Sql_Fetch_Array($req)) {
         $value = "";
         switch ($att["type"]) {
             case "select":
             case "radio":
                 $valreq = Sql_Fetch_Row_Query(sprintf('select name from %slistattr_%s where id = %d', $_POST["remote_prefix"], $att["tablename"], $att["value"]));
                 $value = $valreq[0];
                 break;
             case "checkboxgroup":
                 $valreq = Sql_Query(sprintf('select name from %slistattr_%s where id in (%s)', sql_escape($_POST["remote_prefix"]), $att["tablename"], $att["value"]));
                 while ($vals = Sql_fetch_Row($valreq)) {
                     $value .= $vals[0] . ',';
                 }
                 break;
         }
         $att["displayvalue"] = $value;
         array_push($useratt, $att);
     }
     $userlists = array();
     $userlists = array_merge($_POST["lists"], $userlists);
     if ($_POST["copyremotelists"]) {
         $req = Sql_Query("select * from {$remote_tables["listuser"]},\n          {$remote_tables["list"]} where {$remote_tables["listuser"]}.listid =\n          {$remote_tables["list"]}.id and {$remote_tables["listuser"]}.userid = {$user['0']}");
         while ($list = Sql_Fetch_Array($req)) {
             #  print $list["name"]."<br/>";
             array_push($userlists, $list);
         }