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"]; $email = $myrow["email"]; $notify_announcements = $myrow['notify_announcements']; $notify_closed_contributed = $myrow['notify_closed_contributed']; $notify_closed_any = $myrow['notify_closed_any']; $notify_created = $myrow['notify_created']; //$notify_when_eligible = $auth_user_info['notify_when_eligible']; echo ""; } ?> Username:
Nickname:
Password:
First name:
Last name:
Email addr:
Notification options:
name="notify_announcements"> Notify user of fantastic new functionality and other special announcements.
name="notify_closed_contributed"> Notify user when a story he contributed to is closed.
name="notify_closed_any"> Notify user when any story is closed.
name="notify_created"> Notify user when a new story is created.
Return to user list

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

List of users:

"; $result = mysql_query("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 Exquisite Main