ip); print("\t$host->name". "$ip". "id\">Delete\n"); } } else { print("\tYou don't have any hosts in your access list.\n"); } } // show_access_list() /* * show_manage_users * */ function show_manage_users () { show_box_top(_('Manage Users')); echo "

Use the following tools to manage the users that access your site.

\n"; echo "\n"; show_box_bottom(); show_users(); } // show_manage_users() /* * show_change_password * */ function show_change_password ($username) { $user = get_user($username); print("
"); print("

Changing User Password

\n"); print(""); print("\n"); print(""); print(""); print("\n"); print("\n"); print(""); print(""); print("\n"); print("
Enter password:
Enter password again:
\n"); print(""); print("
"); } // show_change_password /* * show_update_user_info * */ function show_update_user_info ($username) { $user = get_user($username); $user->offset_limit = abs($user->offset_limit); print("
"); print("

Changing User Information for $user->fullname

\n"); print(""); print("\n"); print(""); print(""); print("\n"); print("\n"); print(""); print(""); print("\n"); print("\n"); print(""); print(""); print("\n"); print("
Fullname:fullname\">
Email:email\">
View Limit:offset_limit\">
\n"); print(""); print("
"); } // show_update_user_info() /* * show_delete_stats * */ function show_delete_stats($username) { print("
"); print("
"); if ( $username == 'all') { print("

Delete Your Personal Statistics

\n"); } else { print("

Delete Your Personal Statistics

\n"); } print(""); print("
"); } // show_delete_stats() /* * get_user * */ function get_user_byid ($id) { $sql = "SELECT * FROM user WHERE id='$id'"; $db_result = mysql_query($sql, dbh()); return (mysql_fetch_object($db_result)); } // get_user_byid() function get_user ($username) { $sql = "SELECT * FROM user WHERE username='$username'"; $db_result = mysql_query($sql, dbh()); return (mysql_fetch_object($db_result)); } // get_user() /* * delete_user * */ function delete_user ($username) { // delete from the user table $sql = "DELETE FROM user WHERE username='$username'"; $db_result = mysql_query($sql, dbh()); // also delete playlists for user $sql = "DELETE FROM playlist WHERE username='$username'"; $db_result = mysql_query($sql, dbh()); delete_user_stats('all'); } // delete_user() /* * update_user * */ function update_user ($username, $fullname, $email, $access) { $dbh = libglue_param(libglue_param('dbh_name')); if(!$username || !$fullname || !$email || !$access) return 0; $sql = "UPDATE user ". "SET fullname='$fullname',". "email='$email',". "access='$access'". "WHERE username='$username'"; $db_result = mysql_query($sql, $dbh); if($db_result) return 1; else return 0; } // update_user() /* * update_user_info * * this for use by 'user' to update limited amounts of info * */ function update_user_info ($username, $fullname, $email,$offset) { $dbh = libglue_param(libglue_param('dbh_name')); $sql = "UPDATE user SET fullname='$fullname', email='$email', offset_limit='$offset' WHERE username='$username'"; $db_result = mysql_query($sql, $dbh); // Update current session (so the views are updated) $_SESSION['offset_limit'] = $offset; return ($db_result)?1:0; } // update_user_info() /* * set_user_password * */ function set_user_password ($username, $password1, $password2) { $dbh = libglue_param(libglue_param('dbh_name')); if($password1 !== $password2) return 0; $sql = "UPDATE user SET password=PASSWORD('$password1') WHERE username='$username' LIMIT 1"; $db_result = mysql_query($sql, $dbh); return ($db_result)?1:0; } // set_user_password() ?>