Beispiel #1
0
     $fn = $_POST['fn'];
     $ln = $_POST['ln'];
     $pos = $_POST['pos'];
     if ($id == 'add') {
         mysql_query("INSERT INTO " . $db_prefix . "members\n                            (firstName, lastName, position)\n                            VALUES ('{$fn}', '{$ln}', '{$pos}')", $con);
         $id = mysql_insert_id($con);
         $add = true;
     } else {
         mysql_query("UPDATE " . $db_prefix . "members\n                            SET firstName='{$fn}', lastName='{$ln}', position='{$pos}'\n                            WHERE id={$id}", $con);
     }
     $result = mysql_query("SELECT * FROM " . $db_prefix . "members WHERE id={$id}", $con);
     while ($row = mysql_fetch_array($result)) {
         if ($add) {
             echo "<li id=\"mem{$id}\">";
         }
         formatMember($row);
         if ($add) {
             echo "</li>";
         }
     }
     break;
 case 'memdel':
     mysql_query("DELETE FROM " . $db_prefix . "members WHERE id={$id}");
     echo "<i>User Removed</i>";
     break;
 case 'memmove':
     $id1 = $_POST['id1'];
     $id2 = $_POST['id2'];
     mysql_query("UPDATE " . $db_prefix . "members\n                            SET id=1000\n                            WHERE id={$id1}", $con);
     // If this breaks, then we are amazing
     mysql_query("UPDATE " . $db_prefix . "members\n                            SET id={$id1}\n                            WHERE id={$id2}", $con);
function memList()
{
    global $con;
    global $db_prefix;
    sqlcon();
    $result = mysql_query("SELECT * FROM " . $db_prefix . "members WHERE position!='' ORDER BY id", $con);
    $prevID = '';
    $rowArray;
    $i = 0;
    while ($row = mysql_fetch_array($result)) {
        $rowArray[$i] = $row;
        $i++;
    }
    for ($j = 0; $j < $i; $j++) {
        $ID = $rowArray[$j]['id'];
        $nextID = $rowArray[$j + 1]['id'];
        echo "<li id=\"mem{$ID}\">";
        if ($prevID) {
            echo "<a href=\"javascript:void()\" onClick=\"ajax('type=memmove&id1={$prevID}&id2={$ID}', 'memlist', false)\" style=\"text-decoration: none;\">↑</a>";
        } else {
            echo "↑";
        }
        if ($nextID) {
            echo "<a href=\"javascript:void()\" onClick=\"ajax('type=memmove&id1={$ID}&id2={$nextID}', 'memlist', false)\" style=\"text-decoration: none;\">↓</a>";
        } else {
            echo "↓";
        }
        echo " ";
        formatMember($rowArray[$j]);
        echo "</li>\n";
        $prevID = $ID;
    }
    $result = mysql_query("SELECT * FROM " . $db_prefix . "members WHERE position='' ORDER BY lastName", $con);
    while ($row = mysql_fetch_array($result)) {
        echo "<li id=\"mem" . $row['id'] . "\">";
        formatMember($row);
        echo "</li>\n";
    }
}