WordPress.org
Get WordPress

Make WordPress Core


Ignore:
Timestamp:
06/01/2003 08:06:11 AM (22 years ago)
Author:
saxmatt
Message:

ezSQL update.

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/wp-admin/b2team.php

    r84 r127  
    4545        $sql="UPDATE $tableusers SET user_level=user_level-1 WHERE ID = $id";
    4646    }
    47     $result = mysql_query($sql) or die("Couldn't change $id's level.");
     47    $result = $wpdb->query($sql);
    4848
    4949    header('Location: b2team.php');
    … …  
    6363
    6464    $user_data = get_userdata($id);
    65     $usertodelete_level = $user_data[13];
     65    $usertodelete_level = $user_data->user_level;
    6666
    6767    if ($user_level <= $usertodelete_level)
    6868        die('Can&#8217;t delete an user whose level is higher than yours.');
    6969
    70     $sql="DELETE FROM $tableusers WHERE ID = $id";
    71     $result = mysql_query($sql) or die("Couldn&#8217;t delete user #$id.");
    72 
    73     $sql="DELETE FROM $tableposts WHERE post_author = $id";
    74     $result = mysql_query($sql) or die("Couldn&#8217;t delete user #$id&#8217;s posts.");
     70    $sql = "DELETE FROM $tableusers WHERE ID = $id";
     71    $result = $wpdb->query($sql) or die("Couldn&#8217;t delete user #$id.");
     72
     73    $sql = "DELETE FROM $tableposts WHERE post_author = $id";
     74    $result = $wpdb->query($sql) or die("Couldn&#8217;t delete user #$id&#8217;s posts.");
    7575
    7676    header('Location: b2team.php');
    … …  
    9292    <table cellpadding="5" cellspacing="0">
    9393    <tr>
    94     <td class="tabletoprow">ID</td>
    95     <td class="tabletoprow">Nickname</td>
    96     <td class="tabletoprow">Name</td>
    97     <td class="tabletoprow">E-mail</td>
    98     <td class="tabletoprow">URL</td>
    99     <td class="tabletoprow">Level</td>
     94    <th>ID</th>
     95    <th>Nickname</th>
     96    <th>Name</th>
     97    <th>E-mail</th>
     98    <th>URL</th>
     99    <th>Level</th>
    100100    <?php if ($user_level > 3) { ?>
    101     <td class="tabletoprow">Login</td>
     101    <th>Login</th>
    102102    <?php } ?>
    103103    </tr>
    104104    <?php
    105     $request = "SELECT * FROM $tableusers WHERE user_level>0 ORDER BY ID";
    106     $result = mysql_query($request);
    107     while($row = mysql_fetch_object($result)) {
    108         $user_data = get_userdata2($row->ID);
    109         echo "<tr>\n<!--".$user_data["user_login"]."-->\n";
    110         $email = $user_data["user_email"];
    111         $url = $user_data["user_url"];
    112         $bg1 = ($user_data["user_login"] == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#dddddd\"";
    113         $bg2 = ($user_data["user_login"] == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#eeeeee\"";
    114         echo "<td $bg1>".$user_data["ID"]."</td>\n";
    115         echo "<td $bg2><b><a href=\"javascript:profile(".$user_data["ID"].")\">".$user_data["user_nickname"]."</a></b></td>\n";
    116         echo "<td $bg1>".$user_data["user_firstname"]."&nbsp;".$user_data["user_lastname"]."</td>\n";
     105    $users = $wpdb->get_results("SELECT ID FROM $tableusers WHERE user_level>0 ORDER BY ID");
     106    foreach ($users as $user) {
     107        $user_data = get_userdata($user->ID);
     108        echo "<tr>\n<!--".$user_data->user_login."-->\n";
     109        $email = $user_data->user_email;
     110        $url = $user_data->user_url;
     111        $bg1 = ($user_data->user_login == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#dddddd\"";
     112        $bg2 = ($user_data->user_login == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#eeeeee\"";
     113        echo "<td $bg1>".$user_data->ID."</td>\n";
     114        echo "<td $bg2><b><a href=\"javascript:profile(".$user_data->ID.")\">".$user_data->user_nickname."</a></b></td>\n";
     115        echo "<td $bg1>".$user_data->user_firstname."&nbsp;".$user_data->user_lastname."</td>\n";
    117116        echo "<td $bg2>&nbsp;<a href=\"mailto:$email\" title=\"e-mail: $email\"><img src='../b2-img/email.gif' border=\"0\" alt=\"e-mail: $email\" /></a>&nbsp;</td>";
    118117        echo "<td $bg1>&nbsp;";
    119         if (($user_data["user_url"] != "http://") and ($user_data["user_url"] != ""))
     118        if (($user_data->user_url != "http://") and ($user_data->user_url != ""))
    120119            echo "<a href=\"$url\" target=\"_blank\" title=\"website: $url\"><img src=\"../b2-img/url.gif\" border=\"0\" alt=\"website: $url\" /></a>&nbsp;";
    121120        echo "</td>\n";
    122         echo "<td $bg2>".$user_data["user_level"];
    123         if (($user_level >= 2) and ($user_level > ($user_data["user_level"] + 1)))
    124             echo " <a href=\"b2team.php?action=promote&id=".$user_data["ID"]."&prom=up\">+</a> ";
    125         if (($user_level >= 2) and ($user_level > $user_data["user_level"]) and ($user_data["user_level"] > 0))
    126             echo " <a href=\"b2team.php?action=promote&id=".$user_data["ID"]."&prom=down\">-</a> ";
     121        echo "<td $bg2>".$user_data->user_level;
     122        if (($user_level >= 2) and ($user_level > ($user_data->user_level + 1)))
     123            echo " <a href=\"b2team.php?action=promote&id=".$user_data->ID."&prom=up\">+</a> ";
     124        if (($user_level >= 2) and ($user_level > $user_data->user_level) and ($user_data->user_level > 0))
     125            echo " <a href=\"b2team.php?action=promote&id=".$user_data->ID."&prom=down\">-</a> ";
    127126        echo "</td>\n";
    128127        if ($user_level > 3) {
    129             echo "<td $bg1>".$user_data["user_login"]."</td>\n";
     128            echo "<td $bg1>".$user_data->user_login."</td>\n";
    130129        }
    131130        echo "</tr>\n";
    … …  
    139138
    140139<?php
    141     $request = " SELECT * FROM $tableusers WHERE user_level=0 ORDER BY ID";
    142     $result = mysql_query($request);
    143     if (mysql_num_rows($result)) {
     140    $users = $wpdb->get_results("SELECT * FROM $tableusers WHERE user_level=0 ORDER BY ID");
     141    if ($users) {
    144142?>
    145143<div class="wrap">
    … …  
    147145    <table cellpadding="5" cellspacing="0">
    148146    <tr>
    149     <td class="tabletoprow">ID</td>
    150     <td class="tabletoprow">Nickname</td>
    151     <td class="tabletoprow">Name</td>
    152     <td class="tabletoprow">E-mail</td>
    153     <td class="tabletoprow">URL</td>
    154     <td class="tabletoprow">Level</td>
     147    <td>ID</td>
     148    <td>Nickname</td>
     149    <td>Name</td>
     150    <td>E-mail</td>
     151    <td>URL</td>
     152    <td>Level</td>
    155153    <?php if ($user_level > 3) { ?>
    156     <td class="tabletoprow">Login</td>
     154    <td>Login</td>
    157155    <?php } ?>
    158156    </tr>
    159157    <?php
    160     while($row = mysql_fetch_object($result)) {
    161         $user_data = get_userdata2($row->ID);
    162         echo "<tr>\n<!--".$user_data["user_login"]."-->\n";
    163         $email = $user_data["user_email"];
    164         $url = $user_data["user_url"];
    165         $bg1 = ($user_data["user_login"] == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#dddddd\"";
    166         $bg2 = ($user_data["user_login"] == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#eeeeee\"";
    167         echo "<td $bg1>".$user_data["ID"]."</td>\n";
    168         echo "<td $bg2><b><a href=\"javascript:profile(".$user_data["ID"].")\">".$user_data["user_nickname"]."</a></b></td>\n";
    169         echo "<td $bg1>".$user_data["user_firstname"]."&nbsp;".$user_data["user_lastname"]."</td>\n";
     158    foreach ($users as $user) {
     159        $user_data = get_userdata($user->ID);
     160        echo "<tr>\n<!--".$user_data->user_login."-->\n";
     161        $email = $user_data->user_email;
     162        $url = $user_data->user_url;
     163        $bg1 = ($user_data->user_login == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#dddddd\"";
     164        $bg2 = ($user_data->user_login == $user_login) ? "style=\"background-image: url('../b2-img/b2button.gif');\"" : "bgcolor=\"#eeeeee\"";
     165        echo "<td $bg1>".$user_data->ID."</td>\n";
     166        echo "<td $bg2><b><a href=\"javascript:profile(".$user_data->ID.")\">".$user_data->user_nickname."</a></b></td>\n";
     167        echo "<td $bg1>".$user_data->user_firstname."&nbsp;".$user_data->user_lastname."</td>\n";
    170168        echo "<td $bg1>&nbsp;<a href=\"mailto:".antispambot($email)."\" title=\"e-mail: ".antispambot($email)."\"><img src=\"../b2-img/email.gif\" border=\"0\" alt=\"e-mail: ".antispambot($email)."\" /></a>&nbsp;</td>";
    171169        echo "<td $bg2>&nbsp;";
    172         if (($user_data["user_url"] != "http://") and ($user_data["user_url"] != ""))
     170        if (($user_data->user_url != "http://") and ($user_data->user_url != ""))
    173171            echo "<a href=\"$url\" target=\"_blank\" title=\"website: $url\"><img src=\"../b2-img/url.gif\" border=\"0\" alt=\"website: $url\" /></a>&nbsp;";
    174172        echo "</td>\n";
    175         echo "<td $bg1>".$user_data["user_level"];
     173        echo "<td $bg1>".$user_data->user_level;
    176174        if ($user_level >= 2)
    177             echo " <a href=\"b2team.php?action=promote&id=".$user_data["ID"]."&prom=up\">+</a> ";
     175            echo " <a href=\"b2team.php?action=promote&id=".$user_data->ID."&prom=up\">+</a> ";
    178176        if ($user_level >= 3)
    179             echo " <a href=\"b2team.php?action=delete&id=".$user_data["ID"]."\" style=\"color:red;font-weight:bold;\">X</a> ";
     177            echo " <a href=\"b2team.php?action=delete&id=".$user_data->ID."\" style=\"color:red;font-weight:bold;\">X</a> ";
    180178        echo "</td>\n";
    181179        if ($user_level > 3) {
    182             echo "<td $bg2>".$user_data["user_login"]."</td>\n";
     180            echo "<td $bg2>".$user_data->user_login."</td>\n";
    183181        }
    184182        echo "</tr>\n";
Note: See TracChangeset for help on using the changeset viewer.