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 () { echo "\n
\n"; echo "" . _("Manage Users") . "
\n"; echo "

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

\n"; echo "\n"; echo "
"; show_users(); } // show_manage_users() /*! @function show_user_form @discussion shows the user form */ function show_user_form ($username, $fullname, $email, $access, $type, $error) { require(conf('prefix').'/templates/userform.inc'); } // show_user_form() /* * 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() /* * clear_catalog_stats() * * Use this to clear the stats for the entire Ampache server. * */ function clear_catalog_stats() { $dbh = dbh(); $sql = "DELETE FROM object_count"; $result = mysql_query($sql, $dbh); $sql = "UPDATE song SET played = 'false'"; $result = mysql_query($sql, $dbh); } // clear_catalog_stats /* * check_user_form * */ function check_user_form ($username, $fullname, $email, $pass1, $pass2, $type) { global $dbh; $sql = "SELECT * FROM user WHERE username='$username'"; $db_result = mysql_query($sql, $dbh); if ( mysql_num_rows($db_result) ) { return "That username is already taken, please choose another."; } if ( $type == 'new_user' ) { if ( empty($username) ) { return "Please fill in a username."; } elseif ( ($pass1 != $pass2) || (empty($pass1) || empty($pass2)) ) { return "Sorry, your passwords do no match."; } } elseif ( empty($fullname) ) { return "Please fill in a full name."; } elseif ( empty($email) ) { return "Please fill in an email address."; } elseif ( ($pass1 != $pass2) || (empty($pass1) || empty($pass2)) ) { if ( $type == 'new_user' ) { return "Sorry, your passwords do no match."; } } return false; } // check_user_form() /* * 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() ?>