1 <?php

     2 /***********************************************************************

     3 

     4   Copyright (C) 2002-2005  Rickard Andersson (rickard@punbb.org)

     5 

     6   This file is part of PunBB.

     7 

     8   PunBB is free software; you can redistribute it and/or modify it

     9   under the terms of the GNU General Public License as published

    10   by the Free Software Foundation; either version 2 of the License,

    11   or (at your option) any later version.

    12 

    13   PunBB is distributed in the hope that it will be useful, but

    14   WITHOUT ANY WARRANTY; without even the implied warranty of

    15   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    16   GNU General Public License for more details.

    17 

    18   You should have received a copy of the GNU General Public License

    19   along with this program; if not, write to the Free Software

    20   Foundation, Inc., 59 Temple Place, Suite 330, Boston,

    21   MA  02111-1307  USA

    22 

    23 ************************************************************************/

    24 

    25 

    26 //define('PUN_ROOT', './');

    27 //require PUN_ROOT.'include/common.php';

    28 

    29 global $pun_db, $pun_user, $pun_config, $lang_common;

    30 

    31 $GLOBALS['id'] = 0;

    32 $id =& $GLOBALS['id'];

    33 

    34 $action = isset($_GET['action']) ? $_GET['action'] : null;

    35 $section = isset($_GET['section']) ? $_GET['section'] : null;

    36 $id = isset($_GET['id']) ? intval($_GET['id']) : 0;

    37 if ($id < 2)

    38 	message($lang_common['Bad request']);

    39 

    40 if ($pun_user['g_read_board'] == '0' && ($action != 'change_pass' || !isset($_GET['key'])))

    41 	message($lang_common['No view']);

    42 

    43 $GLOBALS['lang_profile'] = array();

    44 $lang_profile =& $GLOBALS['lang_profile'];

    45 

    46 // Load the profile.php/register.php language file

    47 require PUN_ROOT.'lang/'.$pun_user['language'].'/prof_reg.php';

    48 

    49 // Load the profile.php language file

    50 require PUN_ROOT.'lang/'.$pun_user['language'].'/profile.php';

    51 

    52 

    53 if ($action == 'change_pass')

    54 {

    55   // Can't do this, Enano's already got it

    56   message($lang_common['No permission'] . ' This is because this function is disabled in the Enano port, and Enano handles sessions and user management for PunBB.');

    57   

    58 	if (isset($_GET['key']))

    59 	{

    60 		// If the user is already logged in we shouldn't be here :)

    61 		if (!$pun_user['is_guest'])

    62 		{

    63 			header('Location: index.php');

    64 			exit;

    65 		}

    66 

    67 		$key = $_GET['key'];

    68 

    69 		$result = $pun_db->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());

    70 		list($new_password_hash, $new_password_key) = $pun_db->fetch_row($result);

    71 

    72 		if ($key == '' || $key != $new_password_key)

    73 			message($lang_profile['Pass key bad'].' <a href="mailto:'.$pun_config['o_admin_email'].'">'.$pun_config['o_admin_email'].'</a>.');

    74 		else

    75 		{

    76 			$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());

    77 

    78 			message($lang_profile['Pass updated'], true);

    79 		}

    80 	}

    81 

    82 	// Make sure we are allowed to change this users password

    83 	if ($pun_user['id'] != $id)

    84 	{

    85 		if ($pun_user['g_id'] < USER_LEVEL_MOD)	// A regular user trying to change another users password?

    86 			message($lang_common['No permission']);

    87 		else if ($pun_user['g_id'] == USER_LEVEL_MOD)	// A moderator trying to change a users password?

    88 		{

    89 			$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());

    90 			if (!$pun_db->num_rows($result))

    91 				message($lang_common['Bad request']);

    92 

    93 			if ($pun_config['p_mod_edit_users'] == '0' || $pun_config['p_mod_change_passwords'] == '0' || $pun_db->result($result) < PUN_GUEST)

    94 				message($lang_common['No permission']);

    95 		}

    96 	}

    97 

    98 	if (isset($_POST['form_sent']))

    99 	{

   100 		$old_password = isset($_POST['req_old_password']) ? trim($_POST['req_old_password']) : '';

   101 		$new_password1 = trim($_POST['req_new_password1']);

   102 		$new_password2 = trim($_POST['req_new_password2']);

   103 

   104 		if ($new_password1 != $new_password2)

   105 			message($lang_prof_reg['Pass not match']);

   106 		if (strlen($new_password1) < 4)

   107 			message($lang_prof_reg['Pass too short']);

   108 

   109 		$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());

   110 		list($db_password_hash, $save_pass) = $pun_db->fetch_row($result);

   111 

   112 		$authorized = false;

   113 

   114 		if (!empty($db_password_hash))

   115 		{

   116 			$sha1_in_db = (strlen($db_password_hash) == 40) ? true : false;

   117 			$sha1_available = (function_exists('sha1') || function_exists('mhash')) ? true : false;

   118 

   119 			$old_password_hash = pun_hash($old_password);	// This could result in either an SHA-1 or an MD5 hash

   120 

   121 			if (($sha1_in_db && $sha1_available && $db_password_hash == $old_password_hash) ||

   122 				(!$sha1_in_db && $db_password_hash == md5($old_password)) ||

   123 				$pun_user['g_id'] >= USER_LEVEL_MEMBER)

   124 				$authorized = true;

   125 		}

   126 

   127 		if (!$authorized)

   128 			message($lang_profile['Wrong pass']);

   129 

   130 		$new_password_hash = pun_hash($new_password1);

   131 

   132 		$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());

   133 

   134 		if ($pun_user['id'] == $id)

   135 		{

   136 			$expire = ($save_pass == '1') ? time() + 31536000 : 0;

   137 			pun_setcookie($pun_user['id'], $new_password_hash, $expire);

   138 		}

   139 

   140 		pun_redirect('profile.php?section=essentials&id='.$id, $lang_profile['Pass updated redirect']);

   141 	}

   142 

   143 	$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile'];

   144 	$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']);

   145 	$focus_element = array('change_pass', (($pun_user['g_id'] < USER_LEVEL_MOD) ? 'req_old_password' : 'req_new_password1'));

   146 	require PUN_ROOT.'header.php';

   147 

   148 ?>

   149 <div class="blockform">

   150 	<h2><span><?php echo $lang_profile['Change pass'] ?></span></h2>

   151 	<div class="box">

   152 		<form id="change_pass" method="post" action="<?php echo makeUrlNS('Special', 'Forum/Profile', 'action=change_pass&id=' . $id . '', true); ?>" onsubmit="return process_form(this)">

   153 			<div class="inform">

   154 				<input type="hidden" name="form_sent" value="1" />

   155 				<fieldset>

   156 					<legend><?php echo $lang_profile['Change pass legend'] ?></legend>

   157 					<div class="infldset">

   158 <?php if ($pun_user['g_id'] < USER_LEVEL_MOD): ?>						<label><strong><?php echo $lang_profile['Old pass'] ?></strong><br />

   159 						<input type="password" name="req_old_password" size="16" maxlength="16" /><br /></label>

   160 <?php endif; ?>						<label class="conl"><strong><?php echo $lang_profile['New pass'] ?></strong><br />

   161 						<input type="password" name="req_new_password1" size="16" maxlength="16" /><br /></label>

   162 						<label class="conl"><strong><?php echo $lang_profile['Confirm new pass'] ?></strong><br />

   163 						<input type="password" name="req_new_password2" size="16" maxlength="16" /><br /></label>

   164 						<div class="clearb"></div>

   165 					</div>

   166 				</fieldset>

   167 			</div>

   168 			<p><input type="submit" name="update" value="<?php echo $lang_common['Submit'] ?>" /><a href="javascript:history.go(-1)"><?php echo $lang_common['Go back'] ?></a></p>

   169 		</form>

   170 	</div>

   171 </div>

   172 <?php

   173 

   174 	require PUN_ROOT.'footer.php';

   175 }

   176 

   177 

   178 else if ($action == 'change_email')

   179 {

   180 	// Make sure we are allowed to change this users e-mail

   181 	if ($pun_user['id'] != $id)

   182 	{

   183 		if ($pun_user['g_id'] < USER_LEVEL_MOD)	// A regular user trying to change another users e-mail?

   184 			message($lang_common['No permission']);

   185 		else if ($pun_user['g_id'] == USER_LEVEL_MOD)	// A moderator trying to change a users e-mail?

   186 		{

   187 			$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());

   188 			if (!$pun_db->num_rows($result))

   189 				message($lang_common['Bad request']);

   190 

   191 			if ($pun_config['p_mod_edit_users'] == '0' || $pun_db->result($result) < PUN_GUEST)

   192 				message($lang_common['No permission']);

   193 		}

   194 	}

   195 

   196 	if (isset($_GET['key']))

   197 	{

   198 		$key = $_GET['key'];

   199 

   200 		$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());

   201 		list($new_email, $new_email_key) = $pun_db->fetch_row($result);

   202 

   203 		if ($key == '' || $key != $new_email_key)

   204 			message($lang_profile['E-mail key bad'].' <a href="mailto:'.$pun_config['o_admin_email'].'">'.$pun_config['o_admin_email'].'</a>.');

   205 		else

   206 		{

   207 			$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());

   208 

   209 			message($lang_profile['E-mail updated'], true);

   210 		}

   211 	}

   212 	else if (isset($_POST['form_sent']))

   213 	{

   214 		if (pun_hash($_POST['req_password']) !== $pun_user['password'])

   215 			message($lang_profile['Wrong pass']);

   216 

   217 		require PUN_ROOT.'include/email.php';

   218 

   219 		// Validate the email-address

   220 		$new_email = strtolower(trim($_POST['req_new_email']));

   221 		if (!is_valid_email($new_email))

   222 			message($lang_common['Invalid e-mail']);

   223 

   224 		// Check it it's a banned e-mail address

   225 		if (is_banned_email($new_email))

   226 		{

   227 			if ($pun_config['p_allow_banned_email'] == '0')

   228 				message($lang_prof_reg['Banned e-mail']);

   229 			else if ($pun_config['o_mailing_list'] != '')

   230 			{

   231 				$mail_subject = 'Alert - Banned e-mail detected';

   232 				$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)';

   233 

   234 				pun_mail($pun_config['o_mailing_list'], $mail_subject, $mail_message);

   235 			}

   236 		}

   237 

   238 		// Check if someone else already has registered with that e-mail address

   239 		$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());

   240 		if ($pun_db->num_rows($result))

   241 		{

   242 			if ($pun_config['p_allow_dupe_email'] == '0')

   243 				message($lang_prof_reg['Dupe e-mail']);

   244 			else if ($pun_config['o_mailing_list'] != '')

   245 			{

   246 				while ($cur_dupe = $pun_db->fetch_assoc($result))

   247 					$dupe_list[] = $cur_dupe['username'];

   248 

   249 				$mail_subject = 'Alert - Duplicate e-mail detected';

   250 				$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)';

   251 

   252 				pun_mail($pun_config['o_mailing_list'], $mail_subject, $mail_message);

   253 			}

   254 		}

   255 

   256 

   257 		$new_email_key = random_pass(8);

   258 

   259 		$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());

   260 

   261 		// Load the "activate e-mail" template

   262 		$mail_tpl = trim(file_get_contents(PUN_ROOT.'lang/'.$pun_user['language'].'/mail_templates/activate_email.tpl'));

   263 

   264 		// The first row contains the subject

   265 		$first_crlf = strpos($mail_tpl, "\n");

   266 		$mail_subject = trim(substr($mail_tpl, 8, $first_crlf-8));

   267 		$mail_message = trim(substr($mail_tpl, $first_crlf));

   268 

   269 		$mail_message = str_replace('<username>', $pun_user['username'], $mail_message);

   270 		$mail_message = str_replace('<base_url>', $pun_config['o_base_url'], $mail_message);

   271 		$mail_message = str_replace('<activation_url>', $pun_config['o_base_url'].'/profile.php?action=change_email&id='.$id.'&key='.$new_email_key, $mail_message);

   272 		$mail_message = str_replace('<board_mailer>', $pun_config['o_board_title'].' '.$lang_common['Mailer'], $mail_message);

   273 

   274 		pun_mail($new_email, $mail_subject, $mail_message);

   275 

   276 		message($lang_profile['Activate e-mail sent'].' <a href="mailto:'.$pun_config['o_admin_email'].'">'.$pun_config['o_admin_email'].'</a>.', true);

   277 	}

   278 

   279 	$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile'];

   280 	$required_fields = array('req_new_email' => $lang_profile['New e-mail'], 'req_password' => $lang_common['Password']);

   281 	$focus_element = array('change_email', 'req_new_email');

   282 	require PUN_ROOT.'header.php';

   283 

   284 ?>

   285 <div class="blockform">

   286 	<h2><span><?php echo $lang_profile['Change e-mail'] ?></span></h2>

   287 	<div class="box">

   288 		<form id="change_email" method="post" action="<?php echo makeUrlNS('Special', 'Forum/Profile', 'action=change_email&id=' . $id . '', true); ?>" id="change_email" onsubmit="return process_form(this)">

   289 			<div class="inform">

   290 				<fieldset>

   291 					<legend><?php echo $lang_profile['E-mail legend'] ?></legend>

   292 					<div class="infldset">

   293 						<input type="hidden" name="form_sent" value="1" />

   294 						<label><strong><?php echo $lang_profile['New e-mail'] ?></strong><br /><input type="text" name="req_new_email" size="50" maxlength="50" /><br /></label>

   295 						<label><strong><?php echo $lang_common['Password'] ?></strong><br /><input type="password" name="req_password" size="16" maxlength="16" /><br /></label>

   296 						<p><?php echo $lang_profile['E-mail instructions'] ?></p>

   297 					</div>

   298 				</fieldset>

   299 			</div>

   300 			<p><input type="submit" name="new_email" value="<?php echo $lang_common['Submit'] ?>" /><a href="javascript:history.go(-1)"><?php echo $lang_common['Go back'] ?></a></p>

   301 		</form>

   302 	</div>

   303 </div>

   304 <?php

   305 

   306 	require PUN_ROOT.'footer.php';

   307 }

   308 

   309 

   310 else if ($action == 'upload_avatar' || $action == 'upload_avatar2')

   311 {

   312 	if ($pun_config['o_avatars'] == '0')

   313 		message($lang_profile['Avatars disabled']);

   314 

   315 	if ($pun_user['id'] != $id && $pun_user['g_id'] < USER_LEVEL_MOD)

   316 		message($lang_common['No permission']);

   317 

   318 	if (isset($_POST['form_sent']))

   319 	{

   320 		if (!isset($_FILES['req_file']))

   321 			message($lang_profile['No file']);

   322 			

   323 		$uploaded_file = $_FILES['req_file'];

   324 

   325 		// Make sure the upload went smooth

   326 		if (isset($uploaded_file['error']))

   327 		{

   328 			switch ($uploaded_file['error'])

   329 			{

   330 				case 1:	// UPLOAD_ERR_INI_SIZE

   331 				case 2:	// UPLOAD_ERR_FORM_SIZE

   332 					message($lang_profile['Too large ini']);

   333 					break;

   334 

   335 				case 3:	// UPLOAD_ERR_PARTIAL

   336 					message($lang_profile['Partial upload']);

   337 					break;

   338 

   339 				case 4:	// UPLOAD_ERR_NO_FILE

   340 					message($lang_profile['No file']);

   341 					break;

   342 

   343 				case 6:	// UPLOAD_ERR_NO_TMP_DIR

   344 					message($lang_profile['No tmp directory']);

   345 					break;

   346 

   347 				default:

   348 					// No error occured, but was something actually uploaded?

   349 					if ($uploaded_file['size'] == 0)

   350 						message($lang_profile['No file']);

   351 					break;

   352 			}

   353 		}

   354 

   355 		if (is_uploaded_file($uploaded_file['tmp_name']))

   356 		{

   357 			$allowed_types = array('image/gif', 'image/jpeg', 'image/pjpeg', 'image/png', 'image/x-png');

   358 			if (!in_array($uploaded_file['type'], $allowed_types))

   359 				message($lang_profile['Bad type']);

   360 

   361 			// Make sure the file isn't too big

   362 			if ($uploaded_file['size'] > $pun_config['o_avatars_size'])

   363 				message($lang_profile['Too large'].' '.$pun_config['o_avatars_size'].' '.$lang_profile['bytes'].'.');

   364 

   365 			// Determine type

   366 			$extensions = null;

   367 			if ($uploaded_file['type'] == 'image/gif')

   368 				$extensions = array('.gif', '.jpg', '.png');

   369 			else if ($uploaded_file['type'] == 'image/jpeg' || $uploaded_file['type'] == 'image/pjpeg')

   370 				$extensions = array('.jpg', '.gif', '.png');

   371 			else

   372 				$extensions = array('.png', '.gif', '.jpg');

   373 

   374 			// Move the file to the avatar directory. We do this before checking the width/height to circumvent open_basedir restrictions.

   375 			if (!@move_uploaded_file($uploaded_file['tmp_name'], $pun_config['o_avatars_dir'].'/'.$id.'.tmp'))

   376 				message($lang_profile['Move failed'].' <a href="mailto:'.$pun_config['o_admin_email'].'">'.$pun_config['o_admin_email'].'</a>.');

   377 

   378 			// Now check the width/height

   379 			list($width, $height, $type,) = getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.tmp');

   380 			if (empty($width) || empty($height) || $width > $pun_config['o_avatars_width'] || $height > $pun_config['o_avatars_height'])

   381 			{

   382 				@unlink($pun_config['o_avatars_dir'].'/'.$id.'.tmp');

   383 				message($lang_profile['Too wide or high'].' '.$pun_config['o_avatars_width'].'x'.$pun_config['o_avatars_height'].' '.$lang_profile['pixels'].'.');

   384 			}

   385 			else if ($type == 1 && $uploaded_file['type'] != 'image/gif')	// Prevent dodgy uploads

   386 			{

   387 				@unlink($pun_config['o_avatars_dir'].'/'.$id.'.tmp');

   388 				message($lang_profile['Bad type']);

   389 			}			

   390 

   391 			// Delete any old avatars and put the new one in place

   392 			@unlink($pun_config['o_avatars_dir'].'/'.$id.$extensions[0]);

   393 			@unlink($pun_config['o_avatars_dir'].'/'.$id.$extensions[1]);

   394 			@unlink($pun_config['o_avatars_dir'].'/'.$id.$extensions[2]);

   395 			@rename($pun_config['o_avatars_dir'].'/'.$id.'.tmp', $pun_config['o_avatars_dir'].'/'.$id.$extensions[0]);

   396 			@chmod($pun_config['o_avatars_dir'].'/'.$id.$extensions[0], 0644);

   397 		}

   398 		else

   399 			message($lang_profile['Unknown failure']);

   400 

   401 		// Enable use_avatar (seems sane since the user just uploaded an avatar)

   402 		$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());

   403 

   404 		pun_redirect('profile.php?section=personality&id='.$id, $lang_profile['Avatar upload redirect']);

   405 	}

   406 

   407 	$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile'];

   408 	$required_fields = array('req_file' => $lang_profile['File']);

   409 	$focus_element = array('upload_avatar', 'req_file');

   410 	require PUN_ROOT.'header.php';

   411 

   412 ?>

   413 <div class="blockform">

   414 	<h2><span><?php echo $lang_profile['Upload avatar'] ?></span></h2>

   415 	<div class="box">

   416 		<form id="upload_avatar" method="post" enctype="multipart/form-data" action="<?php echo makeUrlNS('Special', 'Forum/Profile', 'action=upload_avatar2&id=' . $id . '', true); ?>" onsubmit="return process_form(this)">

   417 			<div class="inform">

   418 				<fieldset>

   419 					<legend><?php echo $lang_profile['Upload avatar legend'] ?></legend>

   420 					<div class="infldset">

   421 						<input type="hidden" name="form_sent" value="1" />

   422 						<input type="hidden" name="MAX_FILE_SIZE" value="<?php echo $pun_config['o_avatars_size'] ?>" />

   423 						<label><strong><?php echo $lang_profile['File'] ?></strong><br /><input name="req_file" type="file" size="40" /><br /></label>

   424 						<p><?php echo $lang_profile['Avatar desc'].' '.$pun_config['o_avatars_width'].' x '.$pun_config['o_avatars_height'].' '.$lang_profile['pixels'].' '.$lang_common['and'].' '.$pun_config['o_avatars_size'].' '.$lang_profile['bytes'].' ('.ceil($pun_config['o_avatars_size'] / 1024) ?> KB).</p>

   425 					</div>

   426 				</fieldset>

   427 			</div>

   428 			<p><input type="submit" name="upload" value="<?php echo $lang_profile['Upload'] ?>" /><a href="javascript:history.go(-1)"><?php echo $lang_common['Go back'] ?></a></p>

   429 		</form>

   430 	</div>

   431 </div>

   432 <?php

   433 

   434 	require PUN_ROOT.'footer.php';

   435 }

   436 

   437 

   438 else if ($action == 'delete_avatar')

   439 {

   440 	if ($pun_user['id'] != $id && $pun_user['g_id'] < USER_LEVEL_MOD)

   441 		message($lang_common['No permission']);

   442 

   443 	confirm_referrer('profile.php');

   444 

   445 	@unlink($pun_config['o_avatars_dir'].'/'.$id.'.jpg');

   446 	@unlink($pun_config['o_avatars_dir'].'/'.$id.'.png');

   447 	@unlink($pun_config['o_avatars_dir'].'/'.$id.'.gif');

   448 

   449 	// Disable use_avatar

   450 	$pun_db->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());

   451 

   452 	pun_redirect('profile.php?section=personality&id='.$id, $lang_profile['Avatar deleted redirect']);

   453 }

   454 

   455 

   456 else if (isset($_POST['update_group_membership']))

   457 {

   458 	if ($pun_user['g_id'] < USER_LEVEL_ADMIN)

   459 		message($lang_common['No permission']);

   460 

   461 	confirm_referrer('profile.php');

   462 

   463 	$new_group_id = intval($_POST['group_id']);

   464 

   465 	$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());

   466 

   467 	// If the user was a moderator or an administrator, we remove him/her from the moderator list in all forums as well

   468 	if ($new_group_id > PUN_MOD)

   469 	{

   470 		$result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error());

   471 

   472 		while ($cur_forum = $pun_db->fetch_assoc($result))

   473 		{

   474 			$cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array();

   475 

   476 			if (in_array($id, $cur_moderators))

   477 			{

   478 				$username = array_search($id, $cur_moderators);

   479 				unset($cur_moderators[$username]);

   480 				$cur_moderators = (!empty($cur_moderators)) ? '\''.$pun_db->escape(serialize($cur_moderators)).'\'' : 'NULL';

   481 

   482 				$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());

   483 			}

   484 		}

   485 	}

   486 

   487 	pun_redirect('profile.php?section=admin&id='.$id, $lang_profile['Group membership redirect']);

   488 }

   489 

   490 

   491 else if (isset($_POST['update_forums']))

   492 {

   493 	if ($pun_user['g_id'] < USER_LEVEL_ADMIN)

   494 		message($lang_common['No permission']);

   495 

   496 	confirm_referrer('profile.php');

   497 

   498 	// Get the username of the user we are processing

   499 	$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());

   500 	$username = $pun_db->result($result);

   501 

   502 	$moderator_in = (isset($_POST['moderator_in'])) ? array_keys($_POST['moderator_in']) : array();

   503 

   504 	// Loop through all forums

   505 	$result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error());

   506 

   507 	while ($cur_forum = $pun_db->fetch_assoc($result))

   508 	{

   509 		$cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array();

   510 		// If the user should have moderator access (and he/she doesn't already have it)

   511 		if (in_array($cur_forum['id'], $moderator_in) && !in_array($id, $cur_moderators))

   512 		{

   513 			$cur_moderators[$username] = $id;

   514 			ksort($cur_moderators);

   515 

   516 			$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());

   517 		}

   518 		// If the user shouldn't have moderator access (and he/she already has it)

   519 		else if (!in_array($cur_forum['id'], $moderator_in) && in_array($id, $cur_moderators))

   520 		{

   521 			unset($cur_moderators[$username]);

   522 			$cur_moderators = (!empty($cur_moderators)) ? '\''.$pun_db->escape(serialize($cur_moderators)).'\'' : 'NULL';

   523 

   524 			$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());

   525 		}

   526 	}

   527 

   528 	pun_redirect('profile.php?section=admin&id='.$id, $lang_profile['Update forums redirect']);

   529 }

   530 

   531 

   532 else if (isset($_POST['ban']))

   533 {

   534 	if ($pun_user['g_id'] < USER_LEVEL_MOD || ($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_ban_users'] == '0'))

   535 		message($lang_common['No permission']);

   536 

   537 	pun_redirect('admin_bans.php?add_ban='.$id, $lang_profile['Ban redirect']);

   538 }

   539 

   540 

   541 else if (isset($_POST['delete_user']) || isset($_POST['delete_user_comply']))

   542 {

   543 	if ($pun_user['g_id'] < USER_LEVEL_ADMIN)

   544 		message($lang_common['No permission']);

   545 

   546 	confirm_referrer('profile.php');

   547 

   548 	// Get the username and group of the user we are deleting

   549 	$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());

   550 	list($group_id, $username) = $pun_db->fetch_row($result);

   551 

   552 	if ($group_id == PUN_ADMIN)

   553 		message('Administrators cannot be deleted. In order to delete this user, you must first move him/her to a different user group.');

   554 

   555 	if (isset($_POST['delete_user_comply']))

   556 	{

   557 		// If the user is a moderator or an administrator, we remove him/her from the moderator list in all forums as well

   558 		if ($group_id < PUN_GUEST)

   559 		{

   560 			$result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error());

   561 

   562 			while ($cur_forum = $pun_db->fetch_assoc($result))

   563 			{

   564 				$cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array();

   565 

   566 				if (in_array($id, $cur_moderators))

   567 				{

   568 					unset($cur_moderators[$username]);

   569 					$cur_moderators = (!empty($cur_moderators)) ? '\''.$pun_db->escape(serialize($cur_moderators)).'\'' : 'NULL';

   570 

   571 					$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());

   572 				}

   573 			}

   574 		}

   575 

   576 		// Delete any subscriptions

   577 		$pun_db->query('DELETE FROM '.$pun_db->prefix.'subscriptions WHERE user_id='.$id) or error('Unable to delete subscriptions', __FILE__, __LINE__, $pun_db->error());

   578 

   579 		// Remove him/her from the online list (if they happen to be logged in)

   580 		$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());

   581 

   582 		// Should we delete all posts made by this user?

   583 		if (isset($_POST['delete_posts']))

   584 		{

   585 			require PUN_ROOT.'include/search_idx.php';

   586 			@set_time_limit(0);

   587 

   588 			// Find all posts made by this user

   589 			$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());

   590 			if ($pun_db->num_rows($result))

   591 			{

   592 				while ($cur_post = $pun_db->fetch_assoc($result))

   593 				{

   594 					// Determine whether this post is the "topic post" or not

   595 					$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());

   596 

   597 					if ($pun_db->result($result2) == $cur_post['id'])

   598 						delete_topic($cur_post['topic_id']);

   599 					else

   600 						delete_post($cur_post['id'], $cur_post['topic_id']);

   601 

   602 					update_forum($cur_post['forum_id']);

   603 				}

   604 			}

   605 		}

   606 		else

   607 			// Set all his/her posts to guest

   608 			$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());

   609 

   610 		// Delete the user

   611 		$pun_db->query('DELETE FROM '.$pun_db->prefix.'users WHERE id='.$id) or error('Unable to delete user', __FILE__, __LINE__, $pun_db->error());

   612 

   613 		pun_redirect('index.php', $lang_profile['User delete redirect']);

   614 	}

   615 

   616 	$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile'];

   617 	require PUN_ROOT.'header.php';

   618 

   619 ?>

   620 <div class="blockform">

   621 	<h2><span><?php echo $lang_profile['Confirm delete user'] ?></span></h2>

   622 	<div class="box">

   623 		<form id="confirm_del_user" method="post" action="<?php echo makeUrlNS('Special', 'Forum/Profile', 'id=' . $id . '', true); ?>">

   624 			<div class="inform">

   625 				<fieldset>

   626 					<legend><?php echo $lang_profile['Confirm delete legend'] ?></legend>

   627 					<div class="infldset">

   628 						<p><?php echo $lang_profile['Confirmation info'].' '.pun_htmlspecialchars($username).'.' ?></p>

   629 						<div class="rbox">

   630 							<label><input type="checkbox" name="delete_posts" value="1" checked="checked" /><?php echo $lang_profile['Delete posts'] ?><br /></label>

   631 						</div>

   632 						<p class="warntext"><strong><?php echo $lang_profile['Delete warning'] ?></strong></p>

   633 					</div>

   634 				</fieldset>

   635 			</div>

   636 			<p><input type="submit" name="delete_user_comply" value="<?php echo $lang_profile['Delete'] ?>" /><a href="javascript:history.go(-1)"><?php echo $lang_common['Go back'] ?></a></p>

   637 		</form>

   638 	</div>

   639 </div>

   640 <?php

   641 

   642 	require PUN_ROOT.'footer.php';

   643 }

   644 

   645 

   646 else if (isset($_POST['form_sent']))

   647 {

   648 	// Fetch the user group of the user we are editing

   649 	$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());

   650 	if (!$pun_db->num_rows($result))

   651 		message($lang_common['Bad request']);

   652 

   653 	$group_id = $pun_db->result($result);

   654 

   655 	if ($pun_user['id'] != $id &&

   656 		($pun_user['g_id'] < USER_LEVEL_MOD ||

   657 		($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_edit_users'] == '0') ||

   658 		($pun_user['g_id'] == USER_LEVEL_MOD && $group_id < PUN_GUEST)))

   659 		message($lang_common['No permission']);

   660 

   661 	if ($pun_user['g_id'] >= USER_LEVEL_MEMBER)

   662 		confirm_referrer('profile.php');

   663 

   664 	// Extract allowed elements from $_POST['form']

   665 	function extract_elements($allowed_elements)

   666 	{

   667 		$form = array();

   668 

   669 		while (list($key, $value) = @each($_POST['form']))

   670 		{

   671 		    if (in_array($key, $allowed_elements))

   672 		        $form[$key] = $value;

   673 		}

   674 

   675 		return $form;

   676 	}

   677 

   678 	$username_updated = false;

   679 

   680 	// Validate input depending on section

   681 	switch ($section)

   682 	{

   683 		case 'essentials':

   684 		{

   685 			$form = extract_elements(array('timezone', 'language'));

   686 

   687 			if ($pun_user['g_id'] >= USER_LEVEL_MEMBER)

   688 			{

   689 				$form['admin_note'] = trim($_POST['admin_note']);

   690 

   691 				// Are we allowed to change usernames?

   692         // In Enano, NO!

   693 				if ( false ) // ($pun_user['g_id'] == USER_LEVEL_ADMIN || ($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_rename_users'] == '1'))

   694 				{

   695 					$form['username'] = trim($_POST['req_username']);

   696 					$old_username = trim($_POST['old_username']);

   697 

   698 					if (strlen($form['username']) < 2)

   699 						message($lang_prof_reg['Username too short']);

   700 					else if (pun_strlen($form['username']) > 25)	// This usually doesn't happen since the form element only accepts 25 characters

   701 					    message($lang_common['Bad request']);

   702 					else if (!strcasecmp($form['username'], 'Guest') || !strcasecmp($form['username'], $lang_common['Guest']))

   703 						message($lang_prof_reg['Username guest']);

   704 					else if (preg_match('/[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/', $form['username']))

   705 						message($lang_prof_reg['Username IP']);

   706 					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']))

   707 						message($lang_prof_reg['Username BBCode']);

   708 

   709 					// Check that the username is not already registered

   710 					$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());

   711 					if ($pun_db->num_rows($result))

   712 						message($lang_profile['Dupe username']);

   713 

   714 					if ($form['username'] != $old_username)

   715 						$username_updated = true;

   716 				}

   717 

   718 				// We only allow administrators to update the post count

   719 				if ($pun_user['g_id'] == USER_LEVEL_ADMIN)

   720 					$form['num_posts'] = intval($_POST['num_posts']);

   721 			}

   722 

   723       /*

   724       // Don't update e-mail address in Enano

   725 			if ($pun_config['o_regs_verify'] == '0' || $pun_user['g_id'] >= USER_LEVEL_MEMBER)

   726 			{

   727 				require PUN_ROOT.'include/email.php';

   728 

   729 				// Validate the email-address

   730 				$form['email'] = strtolower(trim($_POST['req_email']));

   731 				if (!is_valid_email($form['email']))

   732 					message($lang_common['Invalid e-mail']);

   733 			}

   734       */

   735 

   736 			// Make sure we got a valid language string

   737 			if (isset($form['language']))

   738 			{

   739 				$form['language'] = preg_replace('#[\.\\\/]#', '', $form['language']);

   740 				if (!file_exists(PUN_ROOT.'lang/'.$form['language'].'/common.php'))

   741 						message($lang_common['Bad request']);

   742 			}

   743 

   744 			break;

   745 		}

   746 

   747 		case 'personal':

   748 		{

   749 			$form = extract_elements(array('realname', 'url', 'location'));

   750 

   751 			if ($pun_user['g_id'] == USER_LEVEL_ADMIN)

   752 				$form['title'] = trim($_POST['title']);

   753 			else if ($pun_user['g_set_title'] == '1')

   754 			{

   755 				$form['title'] = trim($_POST['title']);

   756 

   757 				if ($form['title'] != '')

   758 				{

   759 					// A list of words that the title may not contain

   760 					// If the language is English, there will be some duplicates, but it's not the end of the world

   761 					$forbidden = array('Member', 'Moderator', 'Administrator', 'Banned', 'Guest', $lang_common['Member'], $lang_common['Moderator'], $lang_common['Administrator'], $lang_common['Banned'], $lang_common['Guest']);

   762 

   763 					if (in_array($form['title'], $forbidden))

   764 						message($lang_profile['Forbidden title']);

   765 				}

   766 			}

   767 

   768 			// Add http:// if the URL doesn't contain it already

   769 			if ($form['url'] != '' && strpos(strtolower($form['url']), 'http://') !== 0)

   770 				$form['url'] = 'http://'.$form['url'];

   771 

   772 			break;

   773 		}

   774 

   775 		case 'messaging':

   776 		{

   777 			$form = extract_elements(array('jabber', 'icq', 'msn', 'aim', 'yahoo'));

   778 

   779 			// If the ICQ UIN contains anything other than digits it's invalid

   780 			if ($form['icq'] != '' && @preg_match('/[^0-9]/', $form['icq']))

   781 				message($lang_prof_reg['Bad ICQ']);

   782 

   783 			break;

   784 		}

   785 

   786 		case 'personality':

   787 		{

   788 			$form = extract_elements(array('use_avatar'));

   789 

   790 			// Clean up signature from POST

   791 			$form['signature'] = pun_linebreaks(trim($_POST['signature']));

   792 

   793 			// Validate signature

   794 			if (pun_strlen($form['signature']) > $pun_config['p_sig_length'])

   795 				message($lang_prof_reg['Sig too long'].' '.$pun_config['p_sig_length'].' '.$lang_prof_reg['characters'].'.');

   796 			else if (substr_count($form['signature'], "\n") > ($pun_config['p_sig_lines']-1))

   797 				message($lang_prof_reg['Sig too many lines'].' '.$pun_config['p_sig_lines'].' '.$lang_prof_reg['lines'].'.');

   798 			else if ($form['signature'] && $pun_config['p_sig_all_caps'] == '0' && strtoupper($form['signature']) == $form['signature'] && $pun_user['g_id'] < USER_LEVEL_MOD)

   799 				$form['signature'] = ucwords(strtolower($form['signature']));

   800 

   801 			// Validate BBCode syntax

   802 			if ($pun_config['p_sig_bbcode'] == '1' && strpos($form['signature'], '[') !== false && strpos($form['signature'], ']') !== false)

   803 			{

   804 				require PUN_ROOT.'include/parser.php';

   805 				$form['signature'] = preparse_bbcode($form['signature'], $foo, true);

   806 			}

   807 

   808 			if (!isset($form['use_avatar']) || $form['use_avatar'] != '1') $form['use_avatar'] = '0';

   809 

   810 			break;

   811 		}

   812 

   813 		case 'display':

   814 		{

   815 			$form = extract_elements(array('disp_topics', 'disp_posts', 'show_smilies', 'show_img', 'show_img_sig', 'show_avatars', 'show_sig', 'style'));

   816 

   817 			if ($form['disp_topics'] != '' && intval($form['disp_topics']) < 3) $form['disp_topics'] = 3;

   818 			if ($form['disp_topics'] != '' && intval($form['disp_topics']) > 75) $form['disp_topics'] = 75;

   819 			if ($form['disp_posts'] != '' && intval($form['disp_posts']) < 3) $form['disp_posts'] = 3;

   820 			if ($form['disp_posts'] != '' && intval($form['disp_posts']) > 75) $form['disp_posts'] = 75;

   821 

   822 			if (!isset($form['show_smilies']) || $form['show_smilies'] != '1') $form['show_smilies'] = '0';

   823 			if (!isset($form['show_img']) || $form['show_img'] != '1') $form['show_img'] = '0';

   824 			if (!isset($form['show_img_sig']) || $form['show_img_sig'] != '1') $form['show_img_sig'] = '0';

   825 			if (!isset($form['show_avatars']) || $form['show_avatars'] != '1') $form['show_avatars'] = '0';

   826 			if (!isset($form['show_sig']) || $form['show_sig'] != '1') $form['show_sig'] = '0';

   827 

   828 			break;

   829 		}

   830 

   831 		case 'privacy':

   832 		{

   833 			$form = extract_elements(array('email_setting', 'save_pass', 'notify_with_post'));

   834 

   835 			$form['email_setting'] = intval($form['email_setting']);

   836 			if ($form['email_setting'] < 0 && $form['email_setting'] > 2) $form['email_setting'] = 1;

   837 

   838 			if (!isset($form['save_pass']) || $form['save_pass'] != '1') $form['save_pass'] = '0';

   839 			if (!isset($form['notify_with_post']) || $form['notify_with_post'] != '1') $form['notify_with_post'] = '0';

   840 

   841 			// If the save_pass setting has changed, we need to set a new cookie with the appropriate expire date

   842 			if ($pun_user['id'] == $id && $form['save_pass'] != $pun_user['save_pass'])

   843 			{

   844 				$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());

   845 				pun_setcookie($id, $pun_db->result($result), ($form['save_pass'] == '1') ? time() + 31536000 : 0);

   846 			}

   847 

   848 			break;

   849 		}

   850 

   851 		default:

   852 			message($lang_common['Bad request']);

   853 	}

   854 

   855 

   856 	// Singlequotes around non-empty values and NULL for empty values

   857 	$temp = array();

   858 	while (list($key, $input) = @each($form))

   859 	{

   860 		$value = ($input !== '') ? '\''.$pun_db->escape($input).'\'' : 'NULL';

   861 

   862 		$temp[] = $key.'='.$value;

   863 	}

   864 

   865 	if (empty($temp))

   866 		message($lang_common['Bad request']);

   867 

   868 

   869 	$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());

   870 

   871 	// If we changed the username we have to update some stuff

   872 	if ($username_updated)

   873 	{

   874 		$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());

   875 		$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());

   876 		$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());

   877 		$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());

   878 		$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());

   879 

   880 		// If the user is a moderator or an administrator we have to update the moderator lists

   881 		$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());

   882 		$group_id = $pun_db->result($result);

   883 

   884 		if ($group_id < PUN_GUEST)

   885 		{

   886 			$result = $pun_db->query('SELECT id, moderators FROM '.$pun_db->prefix.'forums') or error('Unable to fetch forum list', __FILE__, __LINE__, $pun_db->error());

   887 

   888 			while ($cur_forum = $pun_db->fetch_assoc($result))

   889 			{

   890 				$cur_moderators = ($cur_forum['moderators'] != '') ? unserialize($cur_forum['moderators']) : array();

   891 

   892 				if (in_array($id, $cur_moderators))

   893 				{

   894 					unset($cur_moderators[$old_username]);

   895 					$cur_moderators[$form['username']] = $id;

   896 					ksort($cur_moderators);

   897 

   898 					$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());

   899 				}

   900 			}

   901 		}

   902 	}

   903 

   904 	pun_redirect('profile.php?section='.$section.'&id='.$id, $lang_profile['Profile redirect']);

   905 }

   906 

   907 

   908 $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());

   909 if (!$pun_db->num_rows($result))

   910 	message($lang_common['Bad request']);

   911 

   912 $user = $pun_db->fetch_assoc($result);

   913 

   914 $last_post = format_time($user['last_post']);

   915 

   916 if ($user['signature'] != '')

   917 {

   918 	require PUN_ROOT.'include/parser.php';

   919 	$parsed_signature = parse_signature($user['signature']);

   920 }

   921 

   922 

   923 // View or edit?

   924 if ($pun_user['id'] != $id &&

   925 	($pun_user['g_id'] > USER_LEVEL_MOD ||

   926 	($pun_user['g_id'] == USER_LEVEL_MOD && $pun_config['p_mod_edit_users'] == '0') ||

   927 	($pun_user['g_id'] == USER_LEVEL_MOD && $user['g_id'] < PUN_GUEST)))

   928 {

   929 	if ($user['email_setting'] == '0' && !$pun_user['is_guest'])

   930 		$email_field = '<a href="mailto:'.$user['email'].'">'.$user['email'].'</a>';

   931 	else if ($user['email_setting'] == '1' && !$pun_user['is_guest'])

   932 		$email_field = '<a href="misc.php?email='.$id.'">'.$lang_common['Send e-mail'].'</a>';

   933 	else

   934 		$email_field = $lang_profile['Private'];

   935 

   936 	$user_title_field = get_title($user);

   937 

   938 	if ($user['url'] != '')

   939 	{

   940 		$user['url'] = pun_htmlspecialchars($user['url']);

   941 

   942 		if ($pun_config['o_censoring'] == '1')

   943 			$user['url'] = censor_words($user['url']);

   944 

   945 		$url = '<a href="'.$user['url'].'">'.$user['url'].'</a>';

   946 	}

   947 	else

   948 		$url = $lang_profile['Unknown'];

   949 

   950 	if ($pun_config['o_avatars'] == '1')

   951 	{

   952 		if ($user['use_avatar'] == '1')

   953 		{

   954 			if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.gif'))

   955 				$avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/'.$id.'.gif" '.$img_size[3].' alt="" />';

   956 			else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.jpg'))

   957 				$avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/'.$id.'.jpg" '.$img_size[3].' alt="" />';

   958 			else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$id.'.png'))

   959 				$avatar_field = '<img src="'.$pun_config['o_avatars_dir'].'/'.$id.'.png" '.$img_size[3].' alt="" />';

   960 			else

   961 				$avatar_field = $lang_profile['No avatar'];

   962 		}

   963 		else

   964 			$avatar_field = $lang_profile['No avatar'];

   965 	}

   966 

   967 	$posts_field = '';

   968 	if ($pun_config['o_show_post_count'] == '1' || $pun_user['g_id'] >= USER_LEVEL_MEMBER)

   969 		$posts_field = $user['num_posts'];

   970 	if ($pun_user['g_search'] == '1')

   971 		$posts_field .= (($posts_field != '') ? ' - ' : '').'<a href="search.php?action=show_user&amp;user_id='.$id.'">'.$lang_profile['Show posts'].'</a>';

   972 

   973 	$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile'];

   974 	define('PUN_ALLOW_INDEX', 1);

   975 	require PUN_ROOT.'header.php';

   976 

   977 ?>

   978 <div id="viewprofile" class="block">

   979 	<h2><span><?php echo $lang_common['Profile'] ?></span></h2>

   980 	<div class="box">

   981 		<div class="fakeform">

   982 			<div class="inform">

   983 				<fieldset>

   984 				<legend><?php echo $lang_profile['Section personal'] ?></legend>

   985 					<div class="infldset">

   986 						<dl>

   987 							<dt><?php echo $lang_common['Username'] ?>: </dt>

   988 							<dd><?php echo pun_htmlspecialchars($user['username']) ?></dd>

   989 							<dt><?php echo $lang_common['Title'] ?>: </dt>

   990 							<dd><?php echo ($pun_config['o_censoring'] == '1') ? censor_words($user_title_field) : $user_title_field; ?></dd>

   991 							<dt><?php echo $lang_profile['Realname'] ?>: </dt>

   992 							<dd><?php echo ($user['realname'] !='') ? pun_htmlspecialchars(($pun_config['o_censoring'] == '1') ? censor_words($user['realname']) : $user['realname']) : $lang_profile['Unknown']; ?></dd>

   993 							<dt><?php echo $lang_profile['Location'] ?>: </dt>

   994 							<dd><?php echo ($user['location'] !='') ? pun_htmlspecialchars(($pun_config['o_censoring'] == '1') ? censor_words($user['location']) : $user['location']) : $lang_profile['Unknown']; ?></dd>

   995 							<dt><?php echo $lang_profile['Website'] ?>: </dt>

   996 							<dd><?php echo $url ?>&nbsp;</dd>

   997 							<dt><?php echo $lang_common['E-mail'] ?>: </dt>

   998 							<dd><?php echo $email_field ?></dd>

   999 						</dl>

  1000 						<div class="clearer"></div>

  1001 					</div>

  1002 				</fieldset>

  1003 			</div>

  1004 			<div class="inform">

  1005 				<fieldset>

  1006 				<legend><?php echo $lang_profile['Section messaging'] ?></legend>

  1007 					<div class="infldset">

  1008 						<dl>

  1009 							<dt><?php echo $lang_profile['Jabber'] ?>: </dt>

  1010 							<dd><?php echo ($user['jabber'] !='') ? pun_htmlspecialchars($user['jabber']) : $lang_profile['Unknown']; ?></dd>

  1011 							<dt><?php echo $lang_profile['ICQ'] ?>: </dt>

  1012 							<dd><?php echo ($user['icq'] !='') ? $user['icq'] : $lang_profile['Unknown']; ?></dd>

  1013 							<dt><?php echo $lang_profile['MSN'] ?>: </dt>

  1014 							<dd><?php echo ($user['msn'] !='') ? pun_htmlspecialchars(($pun_config['o_censoring'] == '1') ? censor_words($user['msn']) : $user['msn']) : $lang_profile['Unknown']; ?></dd>

  1015 							<dt><?php echo $lang_profile['AOL IM'] ?>: </dt>

  1016 							<dd><?php echo ($user['aim'] !='') ? pun_htmlspecialchars(($pun_config['o_censoring'] == '1') ? censor_words($user['aim']) : $user['aim']) : $lang_profile['Unknown']; ?></dd>

  1017 							<dt><?php echo $lang_profile['Yahoo'] ?>: </dt>

  1018 							<dd><?php echo ($user['yahoo'] !='') ? pun_htmlspecialchars(($pun_config['o_censoring'] == '1') ? censor_words($user['yahoo']) : $user['yahoo']) : $lang_profile['Unknown']; ?></dd>

  1019 						</dl>

  1020 						<div class="clearer"></div>

  1021 					</div>

  1022 				</fieldset>

  1023 			</div>

  1024 			<div class="inform">

  1025 				<fieldset>

  1026 				<legend><?php echo $lang_profile['Section personality'] ?></legend>

  1027 					<div class="infldset">

  1028 						<dl>

  1029 <?php if ($pun_config['o_avatars'] == '1'): ?>							<dt><?php echo $lang_profile['Avatar'] ?>: </dt>

  1030 							<dd><?php echo $avatar_field ?></dd>

  1031 <?php endif; ?>							<dt><?php echo $lang_profile['Signature'] ?>: </dt>

  1032 							<dd><div><?php echo isset($parsed_signature) ? $parsed_signature : $lang_profile['No sig']; ?></div></dd>

  1033 						</dl>

  1034 						<div class="clearer"></div>

  1035 					</div>

  1036 				</fieldset>

  1037 			</div>

  1038 			<div class="inform">

  1039 				<fieldset>

  1040 				<legend><?php echo $lang_profile['User activity'] ?></legend>

  1041 					<div class="infldset">

  1042 						<dl>

  1043 <?php if ($posts_field != ''): ?>							<dt><?php echo $lang_common['Posts'] ?>: </dt>

  1044 							<dd><?php echo $posts_field ?></dd>

  1045 <?php endif; ?>							<dt><?php echo $lang_common['Last post'] ?>: </dt>

  1046 							<dd><?php echo $last_post ?></dd>

  1047 							<dt><?php echo $lang_common['Registered'] ?>: </dt>

  1048 							<dd><?php echo format_time($user['registered'], true) ?></dd>

  1049 						</dl>

  1050 						<div class="clearer"></div>

  1051 					</div>

  1052 				</fieldset>

  1053 			</div>

  1054 		</div>

  1055 	</div>

  1056 </div>

  1057 

  1058 <?php

  1059 

  1060 	require PUN_ROOT.'footer.php';

  1061 }

  1062 else

  1063 {

  1064 	if (!$section || $section == 'essentials')

  1065 	{

  1066 		if ($pun_user['g_id'] >= USER_LEVEL_MEMBER)

  1067 		{

  1068 			if ( false ) // NO RENAMING IN ENANO // ($pun_user['g_id'] == USER_LEVEL_ADMIN || $pun_config['p_mod_rename_users'] == '1')

  1069 				$username_field = '<input type="hidden" name="old_username" value="'.pun_htmlspecialchars($user['username']).'" /><label><strong>'.$lang_common['Username'].'</strong><br /><input type="text" name="req_username" value="'.pun_htmlspecialchars($user['username']).'" size="25" maxlength="25" /><br /></label>'."\n";

  1070 			else

  1071 				$username_field = '<p>'.$lang_common['Username'].': '.pun_htmlspecialchars($user['username']).'</p>'."\n";

  1072 

  1073 			$email_field = '<label><strong>'.$lang_common['E-mail'].'</strong><br /><input type="text" name="req_email" value="'.$user['email'].'" size="40" maxlength="50" /><br /></label><p><a href="misc.php?email='.$id.'">'.$lang_common['Send e-mail'].'</a></p>'."\n";

  1074 		}

  1075 		else

  1076 		{

  1077 			$username_field = '<p>'.$lang_common['Username'].': '.pun_htmlspecialchars($user['username']).'</p>'."\n";

  1078 

  1079 			if ($pun_config['o_regs_verify'] == '1')

  1080 				$email_field = '<p>'.$lang_common['E-mail'].': '.$user['email'].'&nbsp;-&nbsp;<a href="profile.php?action=change_email&amp;id='.$id.'">'.$lang_profile['Change e-mail'].'</a></p>'."\n";

  1081 			else

  1082 				$email_field = '<label><strong>'.$lang_common['E-mail'].'</strong><br /><input type="text" name="req_email" value="'.$user['email'].'" size="40" maxlength="50" /><br /></label>'."\n";

  1083 		}

  1084 

  1085 		if ($pun_user['g_id'] == USER_LEVEL_ADMIN)

  1086     {

  1087 			$posts_field = '<label>'.$lang_common['Posts'].'<br /><input type="text" name="num_posts" value="'.$user['num_posts'].'" size="8" maxlength="8" /><br /></label><p><a href="search.php?action=show_user&amp;user_id='.$id.'">'.$lang_profile['Show posts'].'</a></p>'."\n";

  1088     }

  1089 		else if ($pun_config['o_show_post_count'] == '1' || $pun_user['g_id'] >= USER_LEVEL_MEMBER)

  1090     {

  1091 			$posts_field = '<p>'.$lang_common['Posts'].': '.$user['num_posts'].' - <a href="search.php?action=show_user&amp;user_id='.$id.'">'.$lang_profile['Show posts'].'</a></p>'."\n";

  1092     }

  1093 		else

  1094     {

  1095 			$posts_field = '<p><a href="search.php?action=show_user&amp;user_id='.$id.'">'.$lang_profile['Show posts'].'</a></p>'."\n";

  1096     }

  1097 

  1098 		$page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / '.$lang_common['Profile'];

  1099 		$GLOBALS['required_fields'] = array('req_username' => $lang_common['Username']);

  1100 		require PUN_ROOT.'header.php';

  1101 

  1102 		generate_profile_menu('essentials');

  1103 

  1104 ?>

  1105 	<div class="blockform">

  1106 		<h2><span><?php echo pun_htmlspecialchars($user['username']).' - '.$lang_profile['Section essentials'] ?></span></h2>

  1107 		<div class="box">

  1108 			<form id="profile1" method="post" action="<?php echo makeUrlNS('Special', 'Forum/Profile', 'section=essentials&id=' . $id . '', true); ?>" onsubmit="return process_form(this)">

  1109 				<div class="inform">

  1110 					<fieldset>

  1111 						<legend><?php echo $lang_profile['Username and pass legend'] ?></legend>

  1112 						<div class="infldset">

  1113 							<input type="hidden" name="form_sent" value="1" />

  1114 							<?php echo $username_field ?>

  1115 <?php /* if ($pun_user['id'] == $id || $pun_user['g_id'] == USER_LEVEL_ADMIN || ($user['g_id'] > PUN_MOD && $pun_config['p_mod_change_passwords'] == '1')): ?><p><a href="profile.php?action=change_pass&amp;id=<?php echo $id ?>"><?php echo $lang_profile['Change pass'] ?></a></p>

  1116 <?php endif;  */?>					</div>

  1117 					</fieldset>

  1118 				</div>

  1119 				<div class="inform">

  1120 					<fieldset>

  1121 						<legend><?php echo $lang_prof_reg['Localisation legend'] ?></legend>

  1122 						<div class="infldset">

  1123 							<label><?php echo $lang_prof_reg['Timezone'] ?>: <?php echo $lang_prof_reg['Timezone info'] ?>

  1124 							<br /><select name="form[timezone]">

  1125 								<option value="-12"<?php if ($user['timezone'] == -12) echo ' selected="selected"' ?>>-12</option>

  1126 								<option value="-11"<?php if ($user['timezone'] == -11) echo ' selected="selected"' ?>>-11</option>

  1127 								<option value="-10"<?php if ($user['timezone'] == -10) echo ' selected="selected"' ?>>-10</option>

  1128 								<option value="-9.5"<?php if ($user['timezone'] == -9.5) echo ' selected="selected"' ?>>-09.5</option>

  1129 								<option value="-9"<?php if ($user['timezone'] == -9) echo ' selected="selected"' ?>>-09</option>

  1130 								<option value="-8.5"<?php if ($user['timezone'] == -8.5) echo ' selected="selected"' ?>>-08.5</option>

  1131 								<option value="-8"<?php if ($user['timezone'] == -8) echo ' selected="selected"' ?>>-08 PST</option>

  1132 								<option value="-7"<?php if ($user['timezone'] == -7) echo ' selected="selected"' ?>>-07 MST</option>

  1133 								<option value="-6"<?php if ($user['timezone'] == -6) echo ' selected="selected"' ?>>-06 CST</option>

  1134 								<option value="-5"<?php if ($user['timezone'] == -5) echo ' selected="selected"' ?>>-05 EST</option>

  1135 								<option value="-4"<?php if ($user['timezone'] == -4) echo ' selected="selected"' ?>>-04 AST</option>