diff -r e3d7322305bf -r 5e1f1e916419 punbb/profile.php --- a/punbb/profile.php Sun Sep 02 11:00:57 2007 -0400 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,1628 +0,0 @@ -query('SELECT activate_string, activate_key FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch new password', __FILE__, __LINE__, $pun_db->error()); - list($new_password_hash, $new_password_key) = $pun_db->fetch_row($result); - - if ($key == '' || $key != $new_password_key) - message($lang_profile['Pass key bad'].' '.$pun_config['o_admin_email'].'.'); - else - { - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET password=\''.$new_password_hash.'\', activate_string=NULL, activate_key=NULL WHERE id='.$id) or error('Unable to update password', __FILE__, __LINE__, $pun_db->error()); - - message($lang_profile['Pass updated'], true); - } - } - - // Make sure we are allowed to change this users password - if ($pun_user['id'] != $id) - { - if ($pun_user['g_id'] < USER_LEVEL_MOD) // A regular user trying to change another users password? - message($lang_common['No permission']); - else if ($pun_user['g_id'] == USER_LEVEL_MOD) // A moderator trying to change a users password? - { - $result = $pun_db->query('SELECT group_id FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - if (!$pun_db->num_rows($result)) - message($lang_common['Bad request']); - - if ($pun_config['p_mod_edit_users'] == '0' || $pun_config['p_mod_change_passwords'] == '0' || $pun_db->result($result) < PUN_GUEST) - message($lang_common['No permission']); - } - } - - if (isset($_POST['form_sent'])) - { - $old_password = isset($_POST['req_old_password']) ? trim($_POST['req_old_password']) : ''; - $new_password1 = trim($_POST['req_new_password1']); - $new_password2 = trim($_POST['req_new_password2']); - - if ($new_password1 != $new_password2) - message($lang_prof_reg['Pass not match']); - if (strlen($new_password1) < 4) - message($lang_prof_reg['Pass too short']); - - $result = $pun_db->query('SELECT password, save_pass FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch password', __FILE__, __LINE__, $pun_db->error()); - list($db_password_hash, $save_pass) = $pun_db->fetch_row($result); - - $authorized = false; - - if (!empty($db_password_hash)) - { - $sha1_in_db = (strlen($db_password_hash) == 40) ? true : false; - $sha1_available = (function_exists('sha1') || function_exists('mhash')) ? true : false; - - $old_password_hash = pun_hash($old_password); // This could result in either an SHA-1 or an MD5 hash - - if (($sha1_in_db && $sha1_available && $db_password_hash == $old_password_hash) || - (!$sha1_in_db && $db_password_hash == md5($old_password)) || - $pun_user['g_id'] >= USER_LEVEL_MEMBER) - $authorized = true; - } - - if (!$authorized) - message($lang_profile['Wrong pass']); - - $new_password_hash = pun_hash($new_password1); - - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET password=\''.$new_password_hash.'\' WHERE id='.$id) or error('Unable to update password', __FILE__, __LINE__, $pun_db->error()); - - if ($pun_user['id'] == $id) - { - $expire = ($save_pass == '1') ? time() + 31536000 : 0; - pun_setcookie($pun_user['id'], $new_password_hash, $expire); - } - - pun_redirect('profile.php?section=essentials&id='.$id, $lang_profile['Pass updated redirect']); - } - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - $required_fields = array('req_old_password' => $lang_profile['Old pass'], 'req_new_password1' => $lang_profile['New pass'], 'req_new_password2' => $lang_profile['Confirm new pass']); - $focus_element = array('change_pass', (($pun_user['g_id'] < USER_LEVEL_MOD) ? 'req_old_password' : 'req_new_password1')); - require PUN_ROOT.'header.php'; - -?> -
-

-
-
-
- -
- -
- - - -
-
-
-
-

-
-
-
-query('SELECT group_id FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - if (!$pun_db->num_rows($result)) - message($lang_common['Bad request']); - - if ($pun_config['p_mod_edit_users'] == '0' || $pun_db->result($result) < PUN_GUEST) - message($lang_common['No permission']); - } - } - - if (isset($_GET['key'])) - { - $key = $_GET['key']; - - $result = $pun_db->query('SELECT activate_string, activate_key FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch activation data', __FILE__, __LINE__, $pun_db->error()); - list($new_email, $new_email_key) = $pun_db->fetch_row($result); - - if ($key == '' || $key != $new_email_key) - message($lang_profile['E-mail key bad'].' '.$pun_config['o_admin_email'].'.'); - else - { - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET email=activate_string, activate_string=NULL, activate_key=NULL WHERE id='.$id) or error('Unable to update e-mail address', __FILE__, __LINE__, $pun_db->error()); - - message($lang_profile['E-mail updated'], true); - } - } - else if (isset($_POST['form_sent'])) - { - if (pun_hash($_POST['req_password']) !== $pun_user['password']) - message($lang_profile['Wrong pass']); - - require PUN_ROOT.'include/email.php'; - - // Validate the email-address - $new_email = strtolower(trim($_POST['req_new_email'])); - if (!is_valid_email($new_email)) - message($lang_common['Invalid e-mail']); - - // Check it it's a banned e-mail address - if (is_banned_email($new_email)) - { - if ($pun_config['p_allow_banned_email'] == '0') - message($lang_prof_reg['Banned e-mail']); - else if ($pun_config['o_mailing_list'] != '') - { - $mail_subject = 'Alert - Banned e-mail detected'; - $mail_message = 'User \''.$pun_user['username'].'\' changed to banned e-mail address: '.$new_email."\n\n".'User profile: '.$pun_config['o_base_url'].'/profile.php?id='.$id."\n\n".'-- '."\n".'Forum Mailer'."\n".'(Do not reply to this message)'; - - pun_mail($pun_config['o_mailing_list'], $mail_subject, $mail_message); - } - } - - // Check if someone else already has registered with that e-mail address - $result = $pun_db->query('SELECT id, username FROM '.$pun_db->prefix.'users WHERE email=\''.$pun_db->escape($new_email).'\'') or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - if ($pun_db->num_rows($result)) - { - if ($pun_config['p_allow_dupe_email'] == '0') - message($lang_prof_reg['Dupe e-mail']); - else if ($pun_config['o_mailing_list'] != '') - { - while ($cur_dupe = $pun_db->fetch_assoc($result)) - $dupe_list[] = $cur_dupe['username']; - - $mail_subject = 'Alert - Duplicate e-mail detected'; - $mail_message = 'User \''.$pun_user['username'].'\' changed to an e-mail address that also belongs to: '.implode(', ', $dupe_list)."\n\n".'User profile: '.$pun_config['o_base_url'].'/profile.php?id='.$id."\n\n".'-- '."\n".'Forum Mailer'."\n".'(Do not reply to this message)'; - - pun_mail($pun_config['o_mailing_list'], $mail_subject, $mail_message); - } - } - - - $new_email_key = random_pass(8); - - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET activate_string=\''.$pun_db->escape($new_email).'\', activate_key=\''.$new_email_key.'\' WHERE id='.$id) or error('Unable to update activation data', __FILE__, __LINE__, $pun_db->error()); - - // Load the "activate e-mail" template - $mail_tpl = trim(file_get_contents(PUN_ROOT.'lang/'.$pun_user['language'].'/mail_templates/activate_email.tpl')); - - // The first row contains the subject - $first_crlf = strpos($mail_tpl, "\n"); - $mail_subject = trim(substr($mail_tpl, 8, $first_crlf-8)); - $mail_message = trim(substr($mail_tpl, $first_crlf)); - - $mail_message = str_replace('', $pun_user['username'], $mail_message); - $mail_message = str_replace('', $pun_config['o_base_url'], $mail_message); - $mail_message = str_replace('', $pun_config['o_base_url'].'/profile.php?action=change_email&id='.$id.'&key='.$new_email_key, $mail_message); - $mail_message = str_replace('', $pun_config['o_board_title'].' '.$lang_common['Mailer'], $mail_message); - - pun_mail($new_email, $mail_subject, $mail_message); - - message($lang_profile['Activate e-mail sent'].' '.$pun_config['o_admin_email'].'.', true); - } - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - $required_fields = array('req_new_email' => $lang_profile['New e-mail'], 'req_password' => $lang_common['Password']); - $focus_element = array('change_email', 'req_new_email'); - require PUN_ROOT.'header.php'; - -?> -
-

-
-
-
-
- -
- - - -

-
-
-
-

-
-
-
- $pun_config['o_avatars_size']) - message($lang_profile['Too large'].' '.$pun_config['o_avatars_size'].' '.$lang_profile['bytes'].'.'); - - // Determine type - $extensions = null; - if ($uploaded_file['type'] == 'image/gif') - $extensions = array('.gif', '.jpg', '.png'); - else if ($uploaded_file['type'] == 'image/jpeg' || $uploaded_file['type'] == 'image/pjpeg') - $extensions = array('.jpg', '.gif', '.png'); - else - $extensions = array('.png', '.gif', '.jpg'); - - // Move the file to the avatar directory. We do this before checking the width/height to circumvent open_basedir restrictions. - if (!@move_uploaded_file($uploaded_file['tmp_name'], $pun_config['o_avatars_dir'].'/'.$id.'.tmp')) - message($lang_profile['Move failed'].' '.$pun_config['o_admin_email'].'.'); - - // Now check the width/height - list($width, $height, $type,) = getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.tmp'); - if (empty($width) || empty($height) || $width > $pun_config['o_avatars_width'] || $height > $pun_config['o_avatars_height']) - { - @unlink($pun_config['o_avatars_dir'].'/'.$id.'.tmp'); - message($lang_profile['Too wide or high'].' '.$pun_config['o_avatars_width'].'x'.$pun_config['o_avatars_height'].' '.$lang_profile['pixels'].'.'); - } - else if ($type == 1 && $uploaded_file['type'] != 'image/gif') // Prevent dodgy uploads - { - @unlink($pun_config['o_avatars_dir'].'/'.$id.'.tmp'); - message($lang_profile['Bad type']); - } - - // Delete any old avatars and put the new one in place - @unlink($pun_config['o_avatars_dir'].'/'.$id.$extensions[0]); - @unlink($pun_config['o_avatars_dir'].'/'.$id.$extensions[1]); - @unlink($pun_config['o_avatars_dir'].'/'.$id.$extensions[2]); - @rename($pun_config['o_avatars_dir'].'/'.$id.'.tmp', $pun_config['o_avatars_dir'].'/'.$id.$extensions[0]); - @chmod($pun_config['o_avatars_dir'].'/'.$id.$extensions[0], 0644); - } - else - message($lang_profile['Unknown failure']); - - // Enable use_avatar (seems sane since the user just uploaded an avatar) - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET use_avatar=1 WHERE id='.$id) or error('Unable to update avatar state', __FILE__, __LINE__, $pun_db->error()); - - pun_redirect('profile.php?section=personality&id='.$id, $lang_profile['Avatar upload redirect']); - } - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - $required_fields = array('req_file' => $lang_profile['File']); - $focus_element = array('upload_avatar', 'req_file'); - require PUN_ROOT.'header.php'; - -?> -
-

-
-
-
-
- -
- - - -

KB).

-
-
-
-

-
-
-
-query('UPDATE '.$pun_db->prefix.'users SET use_avatar=0 WHERE id='.$id) or error('Unable to update avatar state', __FILE__, __LINE__, $pun_db->error()); - - pun_redirect('profile.php?section=personality&id='.$id, $lang_profile['Avatar deleted redirect']); -} - - -else if (isset($_POST['update_group_membership'])) -{ - if ($pun_user['g_id'] < USER_LEVEL_ADMIN) - message($lang_common['No permission']); - - confirm_referrer('profile.php'); - - $new_group_id = intval($_POST['group_id']); - - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET group_id='.$new_group_id.' WHERE id='.$id) or error('Unable to change user group', __FILE__, __LINE__, $pun_db->error()); - - // If the user was a moderator or an administrator, we remove him/her from the moderator list in all forums as well - if ($new_group_id > PUN_MOD) - { - $result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error()); - - while ($cur_forum = $pun_db->fetch_assoc($result)) - { - $cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array(); - - if (in_array($id, $cur_moderators)) - { - $username = array_search($id, $cur_moderators); - unset($cur_moderators[$username]); - $cur_moderators = (!empty($cur_moderators)) ? '\''.$pun_db->escape(serialize($cur_moderators)).'\'' : 'NULL'; - - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET moderators='.$cur_moderators.' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - } - } - } - - pun_redirect('profile.php?section=admin&id='.$id, $lang_profile['Group membership redirect']); -} - - -else if (isset($_POST['update_forums'])) -{ - if ($pun_user['g_id'] < USER_LEVEL_ADMIN) - message($lang_common['No permission']); - - confirm_referrer('profile.php'); - - // Get the username of the user we are processing - $result = $pun_db->query('SELECT eu.username FROM '.$pun_db->prefix.'users AS u LEFT JOIN '.table_prefix.'users AS eu ON eu.user_id=u.id WHERE u.id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - $username = $pun_db->result($result); - - $moderator_in = (isset($_POST['moderator_in'])) ? array_keys($_POST['moderator_in']) : array(); - - // Loop through all forums - $result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error()); - - while ($cur_forum = $pun_db->fetch_assoc($result)) - { - $cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array(); - // If the user should have moderator access (and he/she doesn't already have it) - if (in_array($cur_forum['id'], $moderator_in) && !in_array($id, $cur_moderators)) - { - $cur_moderators[$username] = $id; - ksort($cur_moderators); - - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET moderators=\''.$pun_db->escape(serialize($cur_moderators)).'\' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - } - // If the user shouldn't have moderator access (and he/she already has it) - else if (!in_array($cur_forum['id'], $moderator_in) && in_array($id, $cur_moderators)) - { - unset($cur_moderators[$username]); - $cur_moderators = (!empty($cur_moderators)) ? '\''.$pun_db->escape(serialize($cur_moderators)).'\'' : 'NULL'; - - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET moderators='.$cur_moderators.' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - } - } - - pun_redirect('profile.php?section=admin&id='.$id, $lang_profile['Update forums redirect']); -} - - -else if (isset($_POST['ban'])) -{ - if ($pun_user['g_id'] < USER_LEVEL_MOD || ($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_ban_users'] == '0')) - message($lang_common['No permission']); - - pun_redirect('admin_bans.php?add_ban='.$id, $lang_profile['Ban redirect']); -} - - -else if (isset($_POST['delete_user']) || isset($_POST['delete_user_comply'])) -{ - if ($pun_user['g_id'] < USER_LEVEL_ADMIN) - message($lang_common['No permission']); - - confirm_referrer('profile.php'); - - // Get the username and group of the user we are deleting - $result = $pun_db->query('SELECT group_id, username FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - list($group_id, $username) = $pun_db->fetch_row($result); - - if ($group_id == PUN_ADMIN) - message('Administrators cannot be deleted. In order to delete this user, you must first move him/her to a different user group.'); - - if (isset($_POST['delete_user_comply'])) - { - // If the user is a moderator or an administrator, we remove him/her from the moderator list in all forums as well - if ($group_id < PUN_GUEST) - { - $result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error()); - - while ($cur_forum = $pun_db->fetch_assoc($result)) - { - $cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array(); - - if (in_array($id, $cur_moderators)) - { - unset($cur_moderators[$username]); - $cur_moderators = (!empty($cur_moderators)) ? '\''.$pun_db->escape(serialize($cur_moderators)).'\'' : 'NULL'; - - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET moderators='.$cur_moderators.' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - } - } - } - - // Delete any subscriptions - $pun_db->query('DELETE FROM '.$pun_db->prefix.'subscriptions WHERE user_id='.$id) or error('Unable to delete subscriptions', __FILE__, __LINE__, $pun_db->error()); - - // Remove him/her from the online list (if they happen to be logged in) - $pun_db->query('DELETE FROM '.$pun_db->prefix.'online WHERE user_id='.$id) or error('Unable to remove user from online list', __FILE__, __LINE__, $pun_db->error()); - - // Should we delete all posts made by this user? - if (isset($_POST['delete_posts'])) - { - require PUN_ROOT.'include/search_idx.php'; - @set_time_limit(0); - - // Find all posts made by this user - $result = $pun_db->query('SELECT p.id, p.topic_id, t.forum_id FROM '.$pun_db->prefix.'posts AS p INNER JOIN '.$pun_db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$pun_db->prefix.'forums AS f ON f.id=t.forum_id WHERE p.poster_id='.$id) or error('Unable to fetch posts', __FILE__, __LINE__, $pun_db->error()); - if ($pun_db->num_rows($result)) - { - while ($cur_post = $pun_db->fetch_assoc($result)) - { - // Determine whether this post is the "topic post" or not - $result2 = $pun_db->query('SELECT id FROM '.$pun_db->prefix.'posts WHERE topic_id='.$cur_post['topic_id'].' ORDER BY posted LIMIT 1') or error('Unable to fetch post info', __FILE__, __LINE__, $pun_db->error()); - - if ($pun_db->result($result2) == $cur_post['id']) - delete_topic($cur_post['topic_id']); - else - delete_post($cur_post['id'], $cur_post['topic_id']); - - update_forum($cur_post['forum_id']); - } - } - } - else - // Set all his/her posts to guest - $pun_db->query('UPDATE '.$pun_db->prefix.'posts SET poster_id=1 WHERE poster_id='.$id) or error('Unable to update posts', __FILE__, __LINE__, $pun_db->error()); - - // Delete the user - $pun_db->query('DELETE FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to delete user', __FILE__, __LINE__, $pun_db->error()); - - pun_redirect('index.php', $lang_profile['User delete redirect']); - } - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - require PUN_ROOT.'header.php'; - -?> -
-

-
-
-
-
- -
-

-
- -
-

-
-
-
-

-
-
-
-query('SELECT group_id FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - if (!$pun_db->num_rows($result)) - message($lang_common['Bad request']); - - $group_id = $pun_db->result($result); - - if ($pun_user['id'] != $id && - ($pun_user['g_id'] < USER_LEVEL_MOD || - ($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_edit_users'] == '0') || - ($pun_user['g_id'] == USER_LEVEL_MOD && $group_id < PUN_GUEST))) - message($lang_common['No permission']); - - if ($pun_user['g_id'] >= USER_LEVEL_MEMBER) - confirm_referrer('profile.php'); - - // Extract allowed elements from $_POST['form'] - function extract_elements($allowed_elements) - { - $form = array(); - - while (list($key, $value) = @each($_POST['form'])) - { - if (in_array($key, $allowed_elements)) - $form[$key] = $value; - } - - return $form; - } - - $username_updated = false; - - // Validate input depending on section - switch ($section) - { - case 'essentials': - { - $form = extract_elements(array('timezone', 'language')); - - if ($pun_user['g_id'] >= USER_LEVEL_MEMBER) - { - $form['admin_note'] = trim($_POST['admin_note']); - - // Are we allowed to change usernames? - // In Enano, NO! - if ( false ) // ($pun_user['g_id'] == USER_LEVEL_ADMIN || ($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_rename_users'] == '1')) - { - $form['username'] = trim($_POST['req_username']); - $old_username = trim($_POST['old_username']); - - if (strlen($form['username']) < 2) - message($lang_prof_reg['Username too short']); - else if (pun_strlen($form['username']) > 25) // This usually doesn't happen since the form element only accepts 25 characters - message($lang_common['Bad request']); - else if (!strcasecmp($form['username'], 'Guest') || !strcasecmp($form['username'], $lang_common['Guest'])) - message($lang_prof_reg['Username guest']); - else if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $form['username'])) - message($lang_prof_reg['Username IP']); - else if (preg_match('#\[b\]|\[/b\]|\[u\]|\[/u\]|\[i\]|\[/i\]|\[color|\[/color\]|\[quote\]|\[quote=|\[/quote\]|\[code\]|\[/code\]|\[img\]|\[/img\]|\[url|\[/url\]|\[email|\[/email\]#i', $form['username'])) - message($lang_prof_reg['Username BBCode']); - - // Check that the username is not already registered - $result = $pun_db->query('SELECT 1 FROM '.table_prefix.'users WHERE username=\''.$pun_db->escape($form['username']).'\' AND user_id!='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - if ($pun_db->num_rows($result)) - message($lang_profile['Dupe username']); - - if ($form['username'] != $old_username) - $username_updated = true; - } - - // We only allow administrators to update the post count - if ($pun_user['g_id'] == USER_LEVEL_ADMIN) - $form['num_posts'] = intval($_POST['num_posts']); - } - - /* - // Don't update e-mail address in Enano - if ($pun_config['o_regs_verify'] == '0' || $pun_user['g_id'] >= USER_LEVEL_MEMBER) - { - require PUN_ROOT.'include/email.php'; - - // Validate the email-address - $form['email'] = strtolower(trim($_POST['req_email'])); - if (!is_valid_email($form['email'])) - message($lang_common['Invalid e-mail']); - } - */ - - // Make sure we got a valid language string - if (isset($form['language'])) - { - $form['language'] = preg_replace('#[\.\\\/]#', '', $form['language']); - if (!file_exists(PUN_ROOT.'lang/'.$form['language'].'/common.php')) - message($lang_common['Bad request']); - } - - break; - } - - case 'personal': - { - $form = extract_elements(array('realname', 'url', 'location')); - - if ($pun_user['g_id'] == USER_LEVEL_ADMIN) - $form['title'] = trim($_POST['title']); - else if ($pun_user['g_set_title'] == '1') - { - $form['title'] = trim($_POST['title']); - - if ($form['title'] != '') - { - // A list of words that the title may not contain - // If the language is English, there will be some duplicates, but it's not the end of the world - $forbidden = array('Member', 'Moderator', 'Administrator', 'Banned', 'Guest', $lang_common['Member'], $lang_common['Moderator'], $lang_common['Administrator'], $lang_common['Banned'], $lang_common['Guest']); - - if (in_array($form['title'], $forbidden)) - message($lang_profile['Forbidden title']); - } - } - - // Add http:// if the URL doesn't contain it already - if ($form['url'] != '' && strpos(strtolower($form['url']), 'http://') !== 0) - $form['url'] = 'http://'.$form['url']; - - break; - } - - case 'messaging': - { - $form = extract_elements(array('jabber', 'icq', 'msn', 'aim', 'yahoo')); - - // If the ICQ UIN contains anything other than digits it's invalid - if ($form['icq'] != '' && @preg_match('/[^0-9]/', $form['icq'])) - message($lang_prof_reg['Bad ICQ']); - - break; - } - - case 'personality': - { - $form = extract_elements(array('use_avatar')); - - // Clean up signature from POST - $form['signature'] = pun_linebreaks(trim($_POST['signature'])); - - // Validate signature - if (pun_strlen($form['signature']) > $pun_config['p_sig_length']) - message($lang_prof_reg['Sig too long'].' '.$pun_config['p_sig_length'].' '.$lang_prof_reg['characters'].'.'); - else if (substr_count($form['signature'], "\n") > ($pun_config['p_sig_lines']-1)) - message($lang_prof_reg['Sig too many lines'].' '.$pun_config['p_sig_lines'].' '.$lang_prof_reg['lines'].'.'); - else if ($form['signature'] && $pun_config['p_sig_all_caps'] == '0' && strtoupper($form['signature']) == $form['signature'] && $pun_user['g_id'] < USER_LEVEL_MOD) - $form['signature'] = ucwords(strtolower($form['signature'])); - - // Validate BBCode syntax - if ($pun_config['p_sig_bbcode'] == '1' && strpos($form['signature'], '[') !== false && strpos($form['signature'], ']') !== false) - { - require PUN_ROOT.'include/parser.php'; - $form['signature'] = preparse_bbcode($form['signature'], $foo, true); - } - - if (!isset($form['use_avatar']) || $form['use_avatar'] != '1') $form['use_avatar'] = '0'; - - break; - } - - case 'display': - { - $form = extract_elements(array('disp_topics', 'disp_posts', 'show_smilies', 'show_img', 'show_img_sig', 'show_avatars', 'show_sig', 'style')); - - if ($form['disp_topics'] != '' && intval($form['disp_topics']) < 3) $form['disp_topics'] = 3; - if ($form['disp_topics'] != '' && intval($form['disp_topics']) > 75) $form['disp_topics'] = 75; - if ($form['disp_posts'] != '' && intval($form['disp_posts']) < 3) $form['disp_posts'] = 3; - if ($form['disp_posts'] != '' && intval($form['disp_posts']) > 75) $form['disp_posts'] = 75; - - if (!isset($form['show_smilies']) || $form['show_smilies'] != '1') $form['show_smilies'] = '0'; - if (!isset($form['show_img']) || $form['show_img'] != '1') $form['show_img'] = '0'; - if (!isset($form['show_img_sig']) || $form['show_img_sig'] != '1') $form['show_img_sig'] = '0'; - if (!isset($form['show_avatars']) || $form['show_avatars'] != '1') $form['show_avatars'] = '0'; - if (!isset($form['show_sig']) || $form['show_sig'] != '1') $form['show_sig'] = '0'; - - break; - } - - case 'privacy': - { - $form = extract_elements(array('email_setting', 'save_pass', 'notify_with_post')); - - $form['email_setting'] = intval($form['email_setting']); - if ($form['email_setting'] < 0 && $form['email_setting'] > 2) $form['email_setting'] = 1; - - if (!isset($form['save_pass']) || $form['save_pass'] != '1') $form['save_pass'] = '0'; - if (!isset($form['notify_with_post']) || $form['notify_with_post'] != '1') $form['notify_with_post'] = '0'; - - // If the save_pass setting has changed, we need to set a new cookie with the appropriate expire date - if ($pun_user['id'] == $id && $form['save_pass'] != $pun_user['save_pass']) - { - $result = $pun_db->query('SELECT password FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch user password hash', __FILE__, __LINE__, $pun_db->error()); - pun_setcookie($id, $pun_db->result($result), ($form['save_pass'] == '1') ? time() + 31536000 : 0); - } - - break; - } - - default: - message($lang_common['Bad request']); - } - - - // Singlequotes around non-empty values and NULL for empty values - $temp = array(); - while (list($key, $input) = @each($form)) - { - $value = ($input !== '') ? '\''.$pun_db->escape($input).'\'' : 'NULL'; - - $temp[] = $key.'='.$value; - } - - if (empty($temp)) - message($lang_common['Bad request']); - - - $pun_db->query('UPDATE '.$pun_db->prefix.'users SET '.implode(',', $temp).' WHERE id='.$id) or error('Unable to update profile', __FILE__, __LINE__, $pun_db->error()); - - // If we changed the username we have to update some stuff - if ($username_updated) - { - $pun_db->query('UPDATE '.$pun_db->prefix.'posts SET poster=\''.$pun_db->escape($form['username']).'\' WHERE poster_id='.$id) or error('Unable to update posts', __FILE__, __LINE__, $pun_db->error()); - $pun_db->query('UPDATE '.$pun_db->prefix.'topics SET poster=\''.$pun_db->escape($form['username']).'\' WHERE poster=\''.$pun_db->escape($old_username).'\'') or error('Unable to update topics', __FILE__, __LINE__, $pun_db->error()); - $pun_db->query('UPDATE '.$pun_db->prefix.'topics SET last_poster=\''.$pun_db->escape($form['username']).'\' WHERE last_poster=\''.$pun_db->escape($old_username).'\'') or error('Unable to update topics', __FILE__, __LINE__, $pun_db->error()); - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET last_poster=\''.$pun_db->escape($form['username']).'\' WHERE last_poster=\''.$pun_db->escape($old_username).'\'') or error('Unable to update forums', __FILE__, __LINE__, $pun_db->error()); - $pun_db->query('UPDATE '.$pun_db->prefix.'online SET ident=\''.$pun_db->escape($form['username']).'\' WHERE ident=\''.$pun_db->escape($old_username).'\'') or error('Unable to update online list', __FILE__, __LINE__, $pun_db->error()); - - // If the user is a moderator or an administrator we have to update the moderator lists - $result = $pun_db->query('SELECT group_id FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - $group_id = $pun_db->result($result); - - if ($group_id < PUN_GUEST) - { - $result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error()); - - while ($cur_forum = $pun_db->fetch_assoc($result)) - { - $cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array(); - - if (in_array($id, $cur_moderators)) - { - unset($cur_moderators[$old_username]); - $cur_moderators[$form['username']] = $id; - ksort($cur_moderators); - - $pun_db->query('UPDATE '.$pun_db->prefix.'forums SET moderators=\''.$pun_db->escape(serialize($cur_moderators)).'\' WHERE id='.$cur_forum['id']) or error('Unable to update forum', __FILE__, __LINE__, $pun_db->error()); - } - } - } - } - - pun_redirect('profile.php?section='.$section.'&id='.$id, $lang_profile['Profile redirect']); -} - - -$result = $pun_db->query('SELECT eu.username, eu.email, u.title, eu.real_name AS realname, u.url, u.jabber, u.icq, u.msn, u.aim, u.yahoo, u.location, u.use_avatar, u.signature, u.disp_topics, u.disp_posts, u.email_setting, u.save_pass, u.notify_with_post, u.show_smilies, u.show_img, u.show_img_sig, u.show_avatars, u.show_sig, u.timezone, u.language, u.style, u.num_posts, u.last_post, u.registered, u.registration_ip, u.admin_note, g.g_id, g.g_user_title FROM '.$pun_db->prefix.'users AS u LEFT JOIN '.table_prefix.'users AS eu ON eu.user_id=u.id LEFT JOIN '.$pun_db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id='.$id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); -if (!$pun_db->num_rows($result)) - message($lang_common['Bad request']); - -$user = $pun_db->fetch_assoc($result); - -$last_post = format_time($user['last_post']); - -if ($user['signature'] != '') -{ - require PUN_ROOT.'include/parser.php'; - $parsed_signature = parse_signature($user['signature']); -} - - -// View or edit? -if ($pun_user['id'] != $id && - ($pun_user['g_id'] > USER_LEVEL_MOD || - ($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_edit_users'] == '0') || - ($pun_user['g_id'] == USER_LEVEL_MOD && $user['g_id'] < PUN_GUEST))) -{ - if ($user['email_setting'] == '0' && !$pun_user['is_guest']) - $email_field = ''.$user['email'].''; - else if ($user['email_setting'] == '1' && !$pun_user['is_guest']) - $email_field = ''.$lang_common['Send e-mail'].''; - else - $email_field = $lang_profile['Private']; - - $user_title_field = get_title($user); - - if ($user['url'] != '') - { - $user['url'] = pun_htmlspecialchars($user['url']); - - if ($pun_config['o_censoring'] == '1') - $user['url'] = censor_words($user['url']); - - $url = ''.$user['url'].''; - } - else - $url = $lang_profile['Unknown']; - - if ($pun_config['o_avatars'] == '1') - { - if ($user['use_avatar'] == '1') - { - if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.gif')) - $avatar_field = ''; - else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.jpg')) - $avatar_field = ''; - else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.png')) - $avatar_field = ''; - else - $avatar_field = $lang_profile['No avatar']; - } - else - $avatar_field = $lang_profile['No avatar']; - } - - $posts_field = ''; - if ($pun_config['o_show_post_count'] == '1' || $pun_user['g_id'] >= USER_LEVEL_MEMBER) - $posts_field = $user['num_posts']; - if ($pun_user['g_search'] == '1') - $posts_field .= (($posts_field != '') ? ' - ' : '').''.$lang_profile['Show posts'].''; - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - define('PUN_ALLOW_INDEX', 1); - require PUN_ROOT.'header.php'; - -?> -
-

-
-
-
-
- -
-
-
:
-
-
:
-
-
:
-
-
:
-
-
:
-
 
-
:
-
-
-
-
-
-
-
-
- -
-
-
:
-
-
:
-
-
:
-
-
:
-
-
:
-
-
-
-
-
-
-
-
- -
-
-
:
-
-
:
-
-
-
-
-
-
-
-
- -
-
-
:
-
-
:
-
-
:
-
-
-
-
-
-
-
-
-
- -= USER_LEVEL_MEMBER) - { - if ( false ) // NO RENAMING IN ENANO // ($pun_user['g_id'] == USER_LEVEL_ADMIN || $pun_config['p_mod_rename_users'] == '1') - $username_field = ''."\n"; - else - $username_field = '

'.$lang_common['Username'].': '.pun_htmlspecialchars($user['username']).'

'."\n"; - - $email_field = '

'.$lang_common['Send e-mail'].'

'."\n"; - } - else - { - $username_field = '

'.$lang_common['Username'].': '.pun_htmlspecialchars($user['username']).'

'."\n"; - - if ($pun_config['o_regs_verify'] == '1') - $email_field = '

'.$lang_common['E-mail'].': '.$user['email'].' - '.$lang_profile['Change e-mail'].'

'."\n"; - else - $email_field = ''."\n"; - } - - if ($pun_user['g_id'] == USER_LEVEL_ADMIN) - { - $posts_field = '

'.$lang_profile['Show posts'].'

'."\n"; - } - else if ($pun_config['o_show_post_count'] == '1' || $pun_user['g_id'] >= USER_LEVEL_MEMBER) - { - $posts_field = '

'.$lang_common['Posts'].': '.$user['num_posts'].' - '.$lang_profile['Show posts'].'

'."\n"; - } - else - { - $posts_field = '

'.$lang_profile['Show posts'].'

'."\n"; - } - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - $GLOBALS['required_fields'] = array('req_username' => $lang_common['Username']); - require PUN_ROOT.'header.php'; - - generate_profile_menu('essentials'); - -?> -
-

-
-
-
-
- -
- - - PUN_MOD && $pun_config['p_mod_change_passwords'] == '1')): ?>

-
-
-
-
-
- -
- -read()) !== false) - { - if ($entry != '.' && $entry != '..' && is_dir(PUN_ROOT.'lang/'.$entry) && file_exists(PUN_ROOT.'lang/'.$entry.'/common.php')) - $languages[] = $entry; - } - $d->close(); - - // Only display the language selection box if there's more than one language available - if (count($languages) > 1) - { - natsort($languages); - -?> - - -
-
-
-
-
- -
-

: = USER_LEVEL_MEMBER) echo ' ('.pun_htmlspecialchars($user['registration_ip']).')'; ?>

-

:

- -= USER_LEVEL_MEMBER): ?> -
-
-
-

-
-
-
-'.$lang_common['Title'].'  ('.$lang_profile['Leave blank'].')

'."\n"; - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - require PUN_ROOT.'header.php'; - - generate_profile_menu('personal'); - -?> -
-

-
-
-
-
- -
- - - - - -
-
-
-

-
-
-
- -
-

-
-
-
-
- -
- - - - - - -
-
-
-

-
-
-
-'.$lang_profile['Change avatar'].''; - if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.gif')) - $avatar_format = 'gif'; - else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.jpg')) - $avatar_format = 'jpg'; - else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.png')) - $avatar_format = 'png'; - else - $avatar_field = ''.$lang_profile['Upload avatar'].''; - - // Display the delete avatar link? - if ($img_size) - $avatar_field .= '   '.$lang_profile['Delete avatar'].''; - - if ($user['signature'] != '') - $signature_preview = '

'.$lang_profile['Sig preview'].'

'."\n\t\t\t\t\t".'
'."\n\t\t\t\t\t\t".'
'."\n\t\t\t\t\t\t".$parsed_signature."\n\t\t\t\t\t".'
'."\n"; - else - $signature_preview = '

'.$lang_profile['No sig'].'

'."\n"; - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile']; - require PUN_ROOT.'header.php'; - - generate_profile_menu('personality'); - - -?> -
-

-
-
-
-
-
- -
- alt="" /> -

-
- -
-

-
-
-
-
-
- -
-

-
- -
- - -
-
-
-

-
-
-
- -
-

-
-
-
-read()) !== false) - { - if (substr($entry, strlen($entry)-4) == '.css') - $styles[] = substr($entry, 0, strlen($entry)-4); - } - $d->close(); - - // Only display the style selection box if there's more than one style available - if (count($styles) == 1) - echo "\t\t\t".'
'."\n"; - else if (count($styles) > 1) - { - natsort($styles); - -?> -
-
- -
- -
-
-
- -
-
- -
-

-
- - - - - -
-
-
-
-
-
- -
- - -

-
-
-
-

-
-
-
- -
-

-
-
-
-
- -
- -

-
- - - -
-

-
- -
-

-
- -
-
-
-
-

-
-
-
- -
-

-
-
-
- -
- - -
-

-
-
-
- - -
- - -
- -
-
-
- - -
-    -
-
-
- -
-
- -
-

-query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.moderators FROM '.$pun_db->prefix.'categories AS c INNER JOIN '.$pun_db->prefix.'forums AS f ON c.id=f.cat_id WHERE f.redirect_url IS NULL ORDER BY c.disp_position, c.id, f.disp_position') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $pun_db->error()); - - $cur_category = 0; - while ($cur_forum = $pun_db->fetch_assoc($result)) - { - if ($cur_forum['cid'] != $cur_category) // A new category since last iteration? - { - if ($cur_category) - echo "\n\t\t\t\t\t\t\t\t".'
'; - - if ($cur_category != 0) - echo "\n\t\t\t\t\t\t\t".'
'."\n"; - - echo "\t\t\t\t\t\t\t".'
'."\n\t\t\t\t\t\t\t\t".'

'.$cur_forum['cat_name'].'

'."\n\t\t\t\t\t\t\t\t".'
'; - $cur_category = $cur_forum['cid']; - } - - $moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array(); - - echo "\n\t\t\t\t\t\t\t\t\t".''."\n"; - } - -?> -
-
-
-
- - - - - - - -
- -