User administration

Only the administrator may modify the user tables.

"; die(); } ?> "; } elseif ($action=='deleteuser') { // delete a record $sql = "DELETE FROM users WHERE user_id=$id"; $result = mysql_query($sql); echo "Record deleted!

"; } if ($action == 'edituser') { if ($id) { echo "

Edit user record:

"; } else { echo "

Add user record:

"; } echo "

"; if ($id) { // editing so select a record $sql = "SELECT * FROM users WHERE user_id=$id"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $id = $myrow["user_id"]; $user = $myrow["username"]; $nick = $myrow["nickname"]; $first = $myrow["first_name"]; $last = $myrow["last_name"]; $status = $myrow["status"]; echo ""; } else { $status='active'; } ?> Username:
Nickname:
Password:
First name:
Last name:
Status:
Return to user list

", $PHP_SELF); } else { //Not editing user info echo "

List of users:

"; $result = mysql_db_query(DATABASE, "SELECT * FROM users"); while ($myrow = mysql_fetch_array($result)) { printf("%s [%s] (%s %s) \n", $PHP_SELF, $myrow["user_id"], $myrow["nickname"], $myrow["username"], $myrow["first_name"], $myrow["last_name"]); printf("(DELETE)
", $PHP_SELF, $myrow["user_id"]); } printf("

Add new user

", $PHP_SELF); } ?>

Return to Nomice Main