Please help with my admin_users.php

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
junks2001
Registered User
Posts: 16
Joined: Sun Sep 12, 2004 8:04 am

Please help with my admin_users.php

Post by junks2001 »

I really need some help. I don't know php programming wise and I can't figure this out.

I'm getting an error on admin_users.php on line 2243. This occured after installing country flags mod. I placed this question in that thread but they said it doesn't appear anything is wrong on line 2243, and "it must be something before that".

Code: Select all

<?php

/***************************************************************************

 *                              admin_users.php

 *                            -------------------

 *   begin                : Saturday, Feb 13, 2001

 *   copyright            : (C) 2001 The phpBB Group

 *   email                : support@phpbb.com

 *

 *   $Id: admin_users.php,v 1.57.2.31 2005/12/20 20:42:28 grahamje Exp $

 *

 *

 ***************************************************************************/



/***************************************************************************

 *

 *   This program is free software; you can redistribute it and/or modify

 *   it under the terms of the GNU General Public License as published by

 *   the Free Software Foundation; either version 2 of the License, or

 *   (at your option) any later version.

 *

 ***************************************************************************/



define('IN_PHPBB', 1);



if( !empty($setmodules) )

{

	$filename = basename(__FILE__);

	$module['Users']['Manage'] = $filename;



	return;

}



$phpbb_root_path = './../';

require($phpbb_root_path . 'extension.inc');

require('./pagestart.' . $phpEx);

require($phpbb_root_path . 'includes/bbcode.'.$phpEx);

require($phpbb_root_path . 'includes/functions_post.'.$phpEx);

require($phpbb_root_path . 'includes/functions_selects.'.$phpEx);

require($phpbb_root_path . 'includes/functions_validate.'.$phpEx);



$html_entities_match = array('#<#', '#>#');

$html_entities_replace = array('<', '>');

// Phoogle Map

$parens = array("(",")");

// End Phoogle Map



//

// Set mode

//

if( isset( $HTTP_POST_VARS['mode'] ) || isset( $HTTP_GET_VARS['mode'] ) )

{

	$mode = ( isset( $HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];

	$mode = htmlspecialchars($mode);

}

else

{

	$mode = '';

}



//

// Phoogle Map

// Bring in phoogle class from includes/phoogle.php

	include($phpbb_root_path . 'includes/phpbb_phoogle_class.'.$phpEx);

// sql for map config

	$sql_map_config = "SELECT * 

					 FROM ". PHOOGLE_CONFIG_TABLE;

	if( !($result_map_config = $db->sql_query($sql_map_config)) )

	{

		message_die(GENERAL_ERROR, 'Could not query Map Config', '', __LINE__, __FILE__, $sql_map_config);

	}

	while ( $mapConfig = $db->sql_fetchrow($result_map_config) )

	{

			$api_key = $mapConfig['api_key'];

			$map_width = $mapConfig['profile_map_width'];

			$width_measure = $mapConfig['profile_width_measure'];

			$map_height = $mapConfig['profile_map_height'];

			$height_measure = $mapConfig['profile_height_measure'];

			$show_control = $mapConfig['show_control'];

			$show_type = $mapConfig['show_type'];

			$control_type = $mapConfig['control_type'];

			$show_scale = $mapConfig['show_scale'];

			$show_overview = $mapConfig['show_overview'];

			$init_zoom = $mapConfig['init_zoom'];

			$user_zoom = $mapConfig['user_zoom'];

			$map_center_c = $mapConfig['map_center'];

			$marker_folder = $mapConfig['marker_folder'];

			$target_folder = $mapConfig['target_folder'];

	}

/**************************************************************************************************************************************/

// sql for map markers	

	$sql_map_markers = "SELECT marker_id, marker_image, marker_width, marker_height 

											FROM ". PHOOGLE_MARKERS_TABLE;

	if( !($result_map_markers = $db->sql_query($sql_map_markers)) )

	{

		message_die(GENERAL_ERROR, 'Could not query Map Markers', '', __LINE__, __FILE__, $sql_map_markers);

	}

	while ( $mapMarker = $db->sql_fetchrow($result_map_markers) )

	{		

			$mid 							= $mapMarker['marker_id'];

			$marker[$mid]['id'] 			= $mapMarker['marker_id'];

			$marker[$mid]['image'] 			= $phpbb_root_path.$marker_folder.$mapMarker['marker_image'];

			$marker[$mid]['image_width'] 	= $mapMarker['marker_width'];

			$marker[$mid]['image_height'] 	= $mapMarker['marker_height'];

			$marker[$mid]['filename']		= $mapMarker['marker_image'];

	

	$template->assign_vars(array(

		"MARKER_".$mid 				=> $marker[$mid]['image'],

		"MARKER_".$mid."_WIDTH" 	=> $marker[$mid]['image_width'],

		"MARKER_".$mid."_HEIGHT" 	=> $marker[$mid]['image_height'],

		"MARKER_".$mid."_NAME" 		=> $marker[$mid]['filename']

	));		

	}

// End Phoogle Map

// Begin program

//

if ( $mode == 'edit' || $mode == 'save' && ( isset($HTTP_POST_VARS['username']) || isset($HTTP_GET_VARS[POST_USERS_URL]) || isset( $HTTP_POST_VARS[POST_USERS_URL]) ) )

{

	//

	// Ok, the profile has been modified and submitted, let's update

	//

	if ( ( $mode == 'save' && isset( $HTTP_POST_VARS['submit'] ) ) || isset( $HTTP_POST_VARS['avatargallery'] ) || isset( $HTTP_POST_VARS['submitavatar'] ) || isset( $HTTP_POST_VARS['cancelavatar'] ) )

	{

		$user_id = intval($HTTP_POST_VARS['id']);



		if (!($this_userdata = get_userdata($user_id)))

		{

			message_die(GENERAL_MESSAGE, $lang['No_user_id_specified'] );

		}



		if( $HTTP_POST_VARS['deleteuser'] && ( $userdata['user_id'] != $user_id ) )

		{

			$sql = "SELECT g.group_id 

				FROM " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g  

				WHERE ug.user_id = $user_id 

					AND g.group_id = ug.group_id 

					AND g.group_single_user = 1";

			if( !($result = $db->sql_query($sql)) )

			{

				message_die(GENERAL_ERROR, 'Could not obtain group information for this user', '', __LINE__, __FILE__, $sql);

			}



			$row = $db->sql_fetchrow($result);

			

			$sql = "UPDATE " . POSTS_TABLE . "

				SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . "' 

				WHERE poster_id = $user_id";

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not update posts for this user', '', __LINE__, __FILE__, $sql);

			}



			$sql = "UPDATE " . TOPICS_TABLE . "

				SET topic_poster = " . DELETED . " 

				WHERE topic_poster = $user_id";

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not update topics for this user', '', __LINE__, __FILE__, $sql);

			}

			

			$sql = "UPDATE " . VOTE_USERS_TABLE . "

				SET vote_user_id = " . DELETED . "

				WHERE vote_user_id = $user_id";

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not update votes for this user', '', __LINE__, __FILE__, $sql);

			}

			

			$sql = "SELECT group_id

				FROM " . GROUPS_TABLE . "

				WHERE group_moderator = $user_id";

			if( !($result = $db->sql_query($sql)) )

			{

				message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);

			}

			

			while ( $row_group = $db->sql_fetchrow($result) )

			{

				$group_moderator[] = $row_group['group_id'];

			}

			

			if ( count($group_moderator) )

			{

				$update_moderator_id = implode(', ', $group_moderator);

				

				$sql = "UPDATE " . GROUPS_TABLE . "

					SET group_moderator = " . $userdata['user_id'] . "

					WHERE group_moderator IN ($update_moderator_id)";

				if( !$db->sql_query($sql) )

				{

					message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);

				}

			}



			$sql = "DELETE FROM " . USERS_TABLE . "

				WHERE user_id = $user_id";

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete user', '', __LINE__, __FILE__, $sql);

			}



			$sql = "DELETE FROM " . USER_GROUP_TABLE . "

				WHERE user_id = $user_id";

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete user from user_group table', '', __LINE__, __FILE__, $sql);

			}



			$sql = "DELETE FROM " . GROUPS_TABLE . "

				WHERE group_id = " . $row['group_id'];

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);

			}



			$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "

				WHERE group_id = " . $row['group_id'];

			if( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);

			}



			$sql = "DELETE FROM " . TOPICS_WATCH_TABLE . "

				WHERE user_id = $user_id";

			if ( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete user from topic watch table', '', __LINE__, __FILE__, $sql);

			}

			

			$sql = "DELETE FROM " . BANLIST_TABLE . "

				WHERE ban_userid = $user_id";

			if ( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete user from banlist table', '', __LINE__, __FILE__, $sql);

			}



			$sql = "DELETE FROM " . SESSIONS_TABLE . "

				WHERE session_user_id = $user_id";

			if ( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete sessions for this user', '', __LINE__, __FILE__, $sql);

			}

			

			$sql = "DELETE FROM " . SESSIONS_KEYS_TABLE . "

				WHERE user_id = $user_id";

			if ( !$db->sql_query($sql) )

			{

				message_die(GENERAL_ERROR, 'Could not delete auto-login keys for this user', '', __LINE__, __FILE__, $sql);

			}



			$sql = "SELECT privmsgs_id

				FROM " . PRIVMSGS_TABLE . "

				WHERE privmsgs_from_userid = $user_id 

					OR privmsgs_to_userid = $user_id";

			if ( !($result = $db->sql_query($sql)) )

			{

				message_die(GENERAL_ERROR, 'Could not select all users private messages', '', __LINE__, __FILE__, $sql);

			}



			// This little bit of code directly from the private messaging section.

			while ( $row_privmsgs = $db->sql_fetchrow($result) )

			{

				$mark_list[] = $row_privmsgs['privmsgs_id'];

			}

			

			if ( count($mark_list) )

			{

				$delete_sql_id = implode(', ', $mark_list);

				

				$delete_text_sql = "DELETE FROM " . PRIVMSGS_TEXT_TABLE . "

					WHERE privmsgs_text_id IN ($delete_sql_id)";

				$delete_sql = "DELETE FROM " . PRIVMSGS_TABLE . "

					WHERE privmsgs_id IN ($delete_sql_id)";

				

				if ( !$db->sql_query($delete_sql) )

				{

					message_die(GENERAL_ERROR, 'Could not delete private message info', '', __LINE__, __FILE__, $delete_sql);

				}

				

				if ( !$db->sql_query($delete_text_sql) )

				{

					message_die(GENERAL_ERROR, 'Could not delete private message text', '', __LINE__, __FILE__, $delete_text_sql);

				}

			}



			$message = $lang['User_deleted'] . '<br /><br />' . sprintf($lang['Click_return_useradmin'], '<a href="' . append_sid("admin_users.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');



			message_die(GENERAL_MESSAGE, $message);

		}



		$username = ( !empty($HTTP_POST_VARS['username']) ) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';

		$email = ( !empty($HTTP_POST_VARS['email']) ) ? trim(strip_tags(htmlspecialchars( $HTTP_POST_VARS['email'] ) )) : '';



		$password = ( !empty($HTTP_POST_VARS['password']) ) ? trim(strip_tags(htmlspecialchars( $HTTP_POST_VARS['password'] ) )) : '';

		$password_confirm = ( !empty($HTTP_POST_VARS['password_confirm']) ) ? trim(strip_tags(htmlspecialchars( $HTTP_POST_VARS['password_confirm'] ) )) : '';



		$icq = ( !empty($HTTP_POST_VARS['icq']) ) ? trim(strip_tags( $HTTP_POST_VARS['icq'] ) ) : '';

		$aim = ( !empty($HTTP_POST_VARS['aim']) ) ? trim(strip_tags( $HTTP_POST_VARS['aim'] ) ) : '';

		$msn = ( !empty($HTTP_POST_VARS['msn']) ) ? trim(strip_tags( $HTTP_POST_VARS['msn'] ) ) : '';

		$yim = ( !empty($HTTP_POST_VARS['yim']) ) ? trim(strip_tags( $HTTP_POST_VARS['yim'] ) ) : '';



		$website = ( !empty($HTTP_POST_VARS['website']) ) ? trim(strip_tags( $HTTP_POST_VARS['website'] ) ) : '';

		$location = ( !empty($HTTP_POST_VARS['location']) ) ? trim(strip_tags( $HTTP_POST_VARS['location'] ) ) : '';

		$occupation = ( !empty($HTTP_POST_VARS['occupation']) ) ? trim(strip_tags( $HTTP_POST_VARS['occupation'] ) ) : '';

		$interests = ( !empty($HTTP_POST_VARS['interests']) ) ? trim(strip_tags( $HTTP_POST_VARS['interests'] ) ) : '';

		// Phoogle

		$map_center = ( !empty($HTTP_POST_VARS['map_center']) ) ? trim(strip_tags( $HTTP_POST_VARS['map_center'] ) ) : '';

		$phoogle_allow = ( !empty($HTTP_POST_VARS['phoogle_allow']) ) ? trim(strip_tags( $HTTP_POST_VARS['phoogle_allow'] ) ) : '';

		$show_me = ( !empty($HTTP_POST_VARS['show_me']) ) ? trim(strip_tags( $HTTP_POST_VARS['show_me'] ) ) : '';

		$phoocomm = ( !empty($HTTP_POST_VARS['phoocomm']) ) ? trim(str_replace( '<br />', "\n", $HTTP_POST_VARS['phoocomm'] ) ) : '';

		$phooicon = ( !empty($HTTP_POST_VARS['phooicon']) ) ? trim(str_replace( '<br />', "\n", $HTTP_POST_VARS['phooicon'] ) ) : '';

		// End Phoogle

		$signature = ( !empty($HTTP_POST_VARS['signature']) ) ? trim(str_replace('<br />', "\n", $HTTP_POST_VARS['signature'] ) ) : '';

$user_admin_notes = ( !empty($HTTP_POST_VARS['user_admin_notes']) ) ? trim(str_replace('<br />', "\n", $HTTP_POST_VARS['user_admin_notes'] ) ) : '';





		validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $map_center, $phoocomm);



		$viewemail = ( isset( $HTTP_POST_VARS['viewemail']) ) ? ( ( $HTTP_POST_VARS['viewemail'] ) ? TRUE : 0 ) : 0;

		$allowviewonline = ( isset( $HTTP_POST_VARS['hideonline']) ) ? ( ( $HTTP_POST_VARS['hideonline'] ) ? 0 : TRUE ) : TRUE;

		$notifyreply = ( isset( $HTTP_POST_VARS['notifyreply']) ) ? ( ( $HTTP_POST_VARS['notifyreply'] ) ? TRUE : 0 ) : 0;

		$notifypm = ( isset( $HTTP_POST_VARS['notifypm']) ) ? ( ( $HTTP_POST_VARS['notifypm'] ) ? TRUE : 0 ) : TRUE;

		$popuppm = ( isset( $HTTP_POST_VARS['popup_pm']) ) ? ( ( $HTTP_POST_VARS['popup_pm'] ) ? TRUE : 0 ) : TRUE;

		$attachsig = ( isset( $HTTP_POST_VARS['attachsig']) ) ? ( ( $HTTP_POST_VARS['attachsig'] ) ? TRUE : 0 ) : 0;



		$allowhtml = ( isset( $HTTP_POST_VARS['allowhtml']) ) ? intval( $HTTP_POST_VARS['allowhtml'] ) : $board_config['allow_html'];

		$allowbbcode = ( isset( $HTTP_POST_VARS['allowbbcode']) ) ? intval( $HTTP_POST_VARS['allowbbcode'] ) : $board_config['allow_bbcode'];

		$allowsmilies = ( isset( $HTTP_POST_VARS['allowsmilies']) ) ? intval( $HTTP_POST_VARS['allowsmilies'] ) : $board_config['allow_smilies'];



		$user_style = ( $HTTP_POST_VARS['style'] ) ? intval( $HTTP_POST_VARS['style'] ) : $board_config['default_style'];

		$user_lang = ( $HTTP_POST_VARS['language'] ) ? $HTTP_POST_VARS['language'] : $board_config['default_lang'];

		$user_timezone = ( isset( $HTTP_POST_VARS['timezone']) ) ? doubleval( $HTTP_POST_VARS['timezone'] ) : $board_config['board_timezone'];
		
		$user_flag = ( !empty($HTTP_POST_VARS['user_flag']) && $HTTP_POST_VARS['user_flag'] != 'blank.gif' ) ? htmlspecialchars($HTTP_POST_VARS['user_flag']) : '' ;	// Country/Location Flags

		$user_flag = ( !empty($HTTP_POST_VARS['user_flag']) && $HTTP_POST_VARS['user_flag'] != 'blank.gif' ) ? htmlspecialchars($HTTP_POST_VARS['user_flag']) : '' ;	// Country/Location Flags

		$user_template = ( $HTTP_POST_VARS['template'] ) ? $HTTP_POST_VARS['template'] : $board_config['board_template'];

		$user_dateformat = ( $HTTP_POST_VARS['dateformat'] ) ? trim( $HTTP_POST_VARS['dateformat'] ) : $board_config['default_dateformat'];

		$user_show_quickreply = ( isset( $HTTP_POST_VARS['show_quickreply'] ) ) ? intval( $HTTP_POST_VARS['show_quickreply'] ) : 1;

		$user_quickreply_mode = ( isset( $HTTP_POST_VARS['quickreply_mode'] ) ) ? ( ( $HTTP_POST_VARS['quickreply_mode'] ) ? TRUE : 0 ) : TRUE;

		$user_open_quickreply = ( isset( $HTTP_POST_VARS['open_quickreply'] ) ) ? ( ( $HTTP_POST_VARS['open_quickreply'] ) ? TRUE : 0 ) : TRUE;





		$user_avatar_local = ( isset( $HTTP_POST_VARS['avatarselect'] ) && !empty($HTTP_POST_VARS['submitavatar'] ) && $board_config['allow_avatar_local'] ) ? $HTTP_POST_VARS['avatarselect'] : ( ( isset( $HTTP_POST_VARS['avatarlocal'] )  ) ? $HTTP_POST_VARS['avatarlocal'] : '' );

		$user_avatar_category = ( isset($HTTP_POST_VARS['avatarcatname']) && $board_config['allow_avatar_local'] ) ? htmlspecialchars($HTTP_POST_VARS['avatarcatname']) : '' ;



		$user_avatar_remoteurl = ( !empty($HTTP_POST_VARS['avatarremoteurl']) ) ? trim( $HTTP_POST_VARS['avatarremoteurl'] ) : '';

		$user_avatar_url = ( !empty($HTTP_POST_VARS['avatarurl']) ) ? trim( $HTTP_POST_VARS['avatarurl'] ) : '';

		$user_avatar_loc = ( $HTTP_POST_FILES['avatar']['tmp_name'] != "none") ? $HTTP_POST_FILES['avatar']['tmp_name'] : '';

		$user_avatar_name = ( !empty($HTTP_POST_FILES['avatar']['name']) ) ? $HTTP_POST_FILES['avatar']['name'] : '';

		$user_avatar_size = ( !empty($HTTP_POST_FILES['avatar']['size']) ) ? $HTTP_POST_FILES['avatar']['size'] : 0;

		$user_avatar_filetype = ( !empty($HTTP_POST_FILES['avatar']['type']) ) ? $HTTP_POST_FILES['avatar']['type'] : '';



		$user_avatar = ( empty($user_avatar_loc) ) ? $this_userdata['user_avatar'] : '';

		$user_avatar_type = ( empty($user_avatar_loc) ) ? $this_userdata['user_avatar_type'] : '';		



		$user_status = ( !empty($HTTP_POST_VARS['user_status']) ) ? intval( $HTTP_POST_VARS['user_status'] ) : 0;

		$user_allowpm = ( !empty($HTTP_POST_VARS['user_allowpm']) ) ? intval( $HTTP_POST_VARS['user_allowpm'] ) : 0;

		$user_rank = ( !empty($HTTP_POST_VARS['user_rank']) ) ? intval( $HTTP_POST_VARS['user_rank'] ) : 0;

		$user_allowavatar = ( !empty($HTTP_POST_VARS['user_allowavatar']) ) ? intval( $HTTP_POST_VARS['user_allowavatar'] ) : 0;



		if( isset( $HTTP_POST_VARS['avatargallery'] ) || isset( $HTTP_POST_VARS['submitavatar'] ) || isset( $HTTP_POST_VARS['cancelavatar'] ) )

		{

			$username = stripslashes($username);

			$email = stripslashes($email);

			$password = '';

			$password_confirm = '';



			$icq = stripslashes($icq);

			$aim = htmlspecialchars(stripslashes($aim));

			$msn = htmlspecialchars(stripslashes($msn));

			$yim = htmlspecialchars(stripslashes($yim));



			$website = htmlspecialchars(stripslashes($website));

			$location = htmlspecialchars(stripslashes($location));

			$occupation = htmlspecialchars(stripslashes($occupation));

			$interests = htmlspecialchars(stripslashes($interests));

			$signature = htmlspecialchars(stripslashes($signature));

			// Phoogle Map

			$map_center = str_replace($parens, "", $map_center); // strip off '(' and ')'

			$phoogle_allow = intval($phoogle_allow);

			$show_me = intval($show_me);

			$map_center = htmlspecialchars(stripslashes($map_center));

			$phoocomm = htmlspecialchars(stripslashes($phoocomm));

			$phooicon = htmlspecialchars(stripslashes($phooicon));

			// End Phoogle Map

      $user_admin_notes = htmlspecialchars(stripslashes($user_admin_notes));





			$user_lang = stripslashes($user_lang);

			$user_dateformat = htmlspecialchars(stripslashes($user_dateformat));



			if ( !isset($HTTP_POST_VARS['cancelavatar'])) 

			{

				$user_avatar = $user_avatar_category . '/' . $user_avatar_local;

				$user_avatar_type = USER_AVATAR_GALLERY;

			}

		}

	}



	if( isset( $HTTP_POST_VARS['submit'] ) )

	{

		include($phpbb_root_path . 'includes/usercp_avatar.'.$phpEx);



		$error = FALSE;



		if (stripslashes($username) != $this_userdata['username'])

		{

			unset($rename_user);



			if ( stripslashes(strtolower($username)) != strtolower($this_userdata['username']) ) 

			{

				$result = validate_username($username);

				if ( $result['error'] )

				{

					$error = TRUE;

					$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $result['error_msg'];

				}

				else if ( strtolower(str_replace("\\'", "''", $username)) == strtolower($userdata['username']) )

				{

					$error = TRUE;

					$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Username_taken'];

				}

			}



			if (!$error)

			{

				$username_sql = "username = '" . str_replace("\\'", "''", $username) . "', ";

				$rename_user = $username; // Used for renaming usergroup

			}

		}



		$passwd_sql = '';

		if( !empty($password) && !empty($password_confirm) )

		{

			//

			// Awww, the user wants to change their password, isn't that cute..

			//

			if($password != $password_confirm)

			{

				$error = TRUE;

				$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Password_mismatch'];

			}

			else

			{

				$password = md5($password);

				$passwd_sql = "user_password = '$password', ";

			}

		}

		else if( $password && !$password_confirm )

		{

			$error = TRUE;

			$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Password_mismatch'];

		}

		else if( !$password && $password_confirm )

		{

			$error = TRUE;

			$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Password_mismatch'];

		}



		if ($signature != '')

		{

			$sig_length_check = preg_replace('/(\[.*?)(=.*?)\]/is', '\\1]', stripslashes($signature));

			if ( $allowhtml )

			{

				$sig_length_check = preg_replace('/(\<.*?)(=.*?)( .*?=.*?)?([ \/]?\>)/is', '\\1\\3\\4', $sig_length_check);

			}



			// Only create a new bbcode_uid when there was no uid yet.

			if ( $signature_bbcode_uid == '' )

			{

				$signature_bbcode_uid = ( $allowbbcode ) ? make_bbcode_uid() : '';

			}

			$signature = prepare_message($signature, $allowhtml, $allowbbcode, $allowsmilies, $signature_bbcode_uid);



			if ( strlen($sig_length_check) > $board_config['max_sig_chars'] )

			{ 

				$error = TRUE;

				$error_msg .=  ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Signature_too_long'];

			}

		}



		//

		// Avatar stuff

		//

		$avatar_sql = "";

		if( isset($HTTP_POST_VARS['avatardel']) )

		{

			if( $this_userdata['user_avatar_type'] == USER_AVATAR_UPLOAD && $this_userdata['user_avatar'] != "" )

			{

				if( @file_exists(@phpbb_realpath('./../' . $board_config['avatar_path'] . "/" . $this_userdata['user_avatar'])) )

				{

					@unlink('./../' . $board_config['avatar_path'] . "/" . $this_userdata['user_avatar']);

				}

			}

			$avatar_sql = ", user_avatar = '', user_avatar_type = " . USER_AVATAR_NONE;

		}

		else if( ( $user_avatar_loc != "" || !empty($user_avatar_url) ) && !$error )

		{

			//

			// Only allow one type of upload, either a

			// filename or a URL

			//

			if( !empty($user_avatar_loc) && !empty($user_avatar_url) )

			{

				$error = TRUE;

				if( isset($error_msg) )

				{

					$error_msg .= "<br />";

				}

				$error_msg .= $lang['Only_one_avatar'];

			}



			if( $user_avatar_loc != "" )

			{

				if( file_exists(@phpbb_realpath($user_avatar_loc)) && ereg(".jpg$|.gif$|.png$", $user_avatar_name) )

				{

					if( $user_avatar_size <= $board_config['avatar_filesize'] && $user_avatar_size > 0)

					{

						$error_type = false;



						//

						// Opera appends the image name after the type, not big, not clever!

						//

						preg_match("'image\/[x\-]*([a-z]+)'", $user_avatar_filetype, $user_avatar_filetype);

						$user_avatar_filetype = $user_avatar_filetype[1];



						switch( $user_avatar_filetype )

						{

							case "jpeg":

							case "pjpeg":

							case "jpg":

								$imgtype = '.jpg';

								break;

							case "gif":

								$imgtype = '.gif';

								break;

							case "png":

								$imgtype = '.png';

								break;

							default:

								$error = true;

								$error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_filetype'] : $lang['Avatar_filetype'];

								break;

						}



						if( !$error )

						{

							list($width, $height) = @getimagesize($user_avatar_loc);



							if( $width <= $board_config['avatar_max_width'] && $height <= $board_config['avatar_max_height'] )

							{

								$user_id = $this_userdata['user_id'];



								$avatar_filename = $user_id . $imgtype;



								if( $this_userdata['user_avatar_type'] == USER_AVATAR_UPLOAD && $this_userdata['user_avatar'] != "" )

								{

									if( @file_exists(@phpbb_realpath("./../" . $board_config['avatar_path'] . "/" . $this_userdata['user_avatar'])) )

									{

										@unlink("./../" . $board_config['avatar_path'] . "/". $this_userdata['user_avatar']);

									}

								}

								@copy($user_avatar_loc, "./../" . $board_config['avatar_path'] . "/$avatar_filename");



								$avatar_sql = ", user_avatar = '$avatar_filename', user_avatar_type = " . USER_AVATAR_UPLOAD;

							}

							else

							{

								$l_avatar_size = sprintf($lang['Avatar_imagesize'], $board_config['avatar_max_width'], $board_config['avatar_max_height']);



								$error = true;

								$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $l_avatar_size : $l_avatar_size;

							}

						}

					}

					else

					{

						$l_avatar_size = sprintf($lang['Avatar_filesize'], round($board_config['avatar_filesize'] / 1024));



						$error = true;

						$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $l_avatar_size : $l_avatar_size;

					}

				}

				else

				{

					$error = true;

					$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $lang['Avatar_filetype'] : $lang['Avatar_filetype'];

				}

			}

			else if( !empty($user_avatar_url) )

			{

				//

				// First check what port we should connect

				// to, look for a :[xxxx]/ or, if that doesn't

				// exist assume port 80 (http)

				//

				preg_match("/^(http:\/\/)?([\w\-\.]+)\:?([0-9]*)\/(.*)$/", $user_avatar_url, $url_ary);



				if( !empty($url_ary[4]) )

				{

					$port = (!empty($url_ary[3])) ? $url_ary[3] : 80;



					$fsock = @fsockopen($url_ary[2], $port, $errno, $errstr);

					if( $fsock )

					{

						$base_get = "/" . $url_ary[4];



						//

						// Uses HTTP 1.1, could use HTTP 1.0 ...

						//

						@fputs($fsock, "GET $base_get HTTP/1.1\r\n");

						@fputs($fsock, "HOST: " . $url_ary[2] . "\r\n");

						@fputs($fsock, "Connection: close\r\n\r\n");



						unset($avatar_data);

						while( !@feof($fsock) )

						{

							$avatar_data .= @fread($fsock, $board_config['avatar_filesize']);

						}

						@fclose($fsock);



						if( preg_match("/Content-Length\: ([0-9]+)[^\/ ][\s]+/i", $avatar_data, $file_data1) && preg_match("/Content-Type\: image\/[x\-]*([a-z]+)[\s]+/i", $avatar_data, $file_data2) )

						{

							$file_size = $file_data1[1]; 

							$file_type = $file_data2[1];



							switch( $file_type )

							{

								case "jpeg":

								case "pjpeg":

								case "jpg":

									$imgtype = '.jpg';

									break;

								case "gif":

									$imgtype = '.gif';

									break;

								case "png":

									$imgtype = '.png';

									break;

								default:

									$error = true;

									$error_msg = (!empty($error_msg)) ? $error_msg . "<br />" . $lang['Avatar_filetype'] : $lang['Avatar_filetype'];

									break;

							}



							if( !$error && $file_size > 0 && $file_size < $board_config['avatar_filesize'] )

							{

								$avatar_data = substr($avatar_data, strlen($avatar_data) - $file_size, $file_size);



								$tmp_filename = tempnam ("/tmp", $this_userdata['user_id'] . "-");

								$fptr = @fopen($tmp_filename, "wb");

								$bytes_written = @fwrite($fptr, $avatar_data, $file_size);

								@fclose($fptr);



								if( $bytes_written == $file_size )

								{

									list($width, $height) = @getimagesize($tmp_filename);



									if( $width <= $board_config['avatar_max_width'] && $height <= $board_config['avatar_max_height'] )

									{

										$user_id = $this_userdata['user_id'];



										$avatar_filename = $user_id . $imgtype;



										if( $this_userdata['user_avatar_type'] == USER_AVATAR_UPLOAD && $this_userdata['user_avatar'] != "")

										{

											if( file_exists(@phpbb_realpath("./../" . $board_config['avatar_path'] . "/" . $this_userdata['user_avatar'])) )

											{

												@unlink("./../" . $board_config['avatar_path'] . "/" . $this_userdata['user_avatar']);

											}

										}

										@copy($tmp_filename, "./../" . $board_config['avatar_path'] . "/$avatar_filename");

										@unlink($tmp_filename);



										$avatar_sql = ", user_avatar = '$avatar_filename', user_avatar_type = " . USER_AVATAR_UPLOAD;

									}

									else

									{

										$l_avatar_size = sprintf($lang['Avatar_imagesize'], $board_config['avatar_max_width'], $board_config['avatar_max_height']);



										$error = true;

										$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $l_avatar_size : $l_avatar_size;

									}

								}

								else

								{

									//

									// Error writing file

									//

									@unlink($tmp_filename);

									message_die(GENERAL_ERROR, "Could not write avatar file to local storage. Please contact the board administrator with this message", "", __LINE__, __FILE__);

								}

							}

						}

						else

						{

							//

							// No data

							//

							$error = true;

							$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $lang['File_no_data'] : $lang['File_no_data'];

						}

					}

					else

					{

						//

						// No connection

						//

						$error = true;

						$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $lang['No_connection_URL'] : $lang['No_connection_URL'];

					}

				}

				else

				{

					$error = true;

					$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $lang['Incomplete_URL'] : $lang['Incomplete_URL'];

				}

			}

			else if( !empty($user_avatar_name) )

			{

				$l_avatar_size = sprintf($lang['Avatar_filesize'], round($board_config['avatar_filesize'] / 1024));



				$error = true;

				$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $l_avatar_size : $l_avatar_size;

			}

		}

		else if( $user_avatar_remoteurl != "" && $avatar_sql == "" && !$error )

		{

			if( !preg_match("#^http:\/\/#i", $user_avatar_remoteurl) )

			{

				$user_avatar_remoteurl = "http://" . $user_avatar_remoteurl;

			}



			if( preg_match("#^(http:\/\/[a-z0-9\-]+?\.([a-z0-9\-]+\.)*[a-z]+\/.*?\.(gif|jpg|png)$)#is", $user_avatar_remoteurl) )

			{

				$avatar_sql = ", user_avatar = '" . str_replace("\'", "''", $user_avatar_remoteurl) . "', user_avatar_type = " . USER_AVATAR_REMOTE;

			}

			else

			{

				$error = true;

				$error_msg = ( !empty($error_msg) ) ? $error_msg . "<br />" . $lang['Wrong_remote_avatar_format'] : $lang['Wrong_remote_avatar_format'];

			}

		}

		else if( $user_avatar_local != "" && $avatar_sql == "" && !$error )

		{

			$avatar_sql = ", user_avatar = '" . str_replace("\'", "''", phpbb_ltrim(basename($user_avatar_category), "'") . '/' . phpbb_ltrim(basename($user_avatar_local), "'")) . "', user_avatar_type = " . USER_AVATAR_GALLERY;

		}

	

		//

		// Update entry in DB

		//

		if( !$error )

		{

			$sql = "UPDATE " . USERS_TABLE . "

				SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) . "', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_from_flag = '" . str_replace("\'", "''", $user_flag) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_admin_notes = '" . str_replace("\'", "''", $user_admin_notes) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "',  user_show_quickreply = $user_show_quickreply, user_quickreply_mode = $user_quickreply_mode, user_open_quickreply = $user_open_quickreply,user_active = $user_status, user_rank = $user_rank" . $avatar_sql . ", user_phoogle_map_center='" . str_replace($parens,"", $map_center) . "', user_phoogle_comment='" . str_replace("\'", "''", $phoocomm) . "', user_phoogle_icon='" . intval($phooicon) . "', user_phoogle_allow='" . intval($phoogle_allow) . "', user_phoogle_show_me='" . intval($show_me) . "'

				WHERE user_id = $user_id";



			if( $result = $db->sql_query($sql) )

			{

				if( isset($rename_user) )

				{

					$sql = "UPDATE " . GROUPS_TABLE . "

						SET group_name = '".str_replace("\'", "''", $rename_user)."'

						WHERE group_name = '".str_replace("'", "''", $this_userdata['username'] )."'";

					if( !$result = $db->sql_query($sql) )

					{

						message_die(GENERAL_ERROR, 'Could not rename users group', '', __LINE__, __FILE__, $sql);

					}

				}

				

				// Delete user session, to prevent the user navigating the forum (if logged in) when disabled

				if (!$user_status)

				{

					$sql = "DELETE FROM " . SESSIONS_TABLE . " 

						WHERE session_user_id = " . $user_id;



					if ( !$db->sql_query($sql) )

					{

						message_die(GENERAL_ERROR, 'Error removing user session', '', __LINE__, __FILE__, $sql);

					}

				}

				

				$message .= $lang['Admin_user_updated'];

			}

			else

			{

				$error = TRUE;

				$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Admin_user_fail'];

			}



			$message .= '<br /><br />' . sprintf($lang['Click_return_useradmin'], '<a href="' . append_sid("admin_users.$phpEx") . '">', '</a>') . '<br /><br />' . sprintf($lang['Click_return_admin_index'], '<a href="' . append_sid("index.$phpEx?pane=right") . '">', '</a>');



			message_die(GENERAL_MESSAGE, $message);

		}

		else

		{

			$template->set_filenames(array(

				'reg_header' => 'error_body.tpl')

			);



			$template->assign_vars(array(

				'ERROR_MESSAGE' => $error_msg)

			);



			$template->assign_var_from_handle('ERROR_BOX', 'reg_header');



			$username = htmlspecialchars(stripslashes($username));

			$email = stripslashes($email);

			$password = '';

			$password_confirm = '';



			$icq = stripslashes($icq);

			$aim = htmlspecialchars(str_replace('+', ' ', stripslashes($aim)));

			$msn = htmlspecialchars(stripslashes($msn));

			$yim = htmlspecialchars(stripslashes($yim));



			$website = htmlspecialchars(stripslashes($website));

			$location = htmlspecialchars(stripslashes($location));

			$user_flag = htmlspecialchars(stripslashes($user_flag));	// Country/Location Flags

			$occupation = htmlspecialchars(stripslashes($occupation));

			$interests = htmlspecialchars(stripslashes($interests));

			$signature = htmlspecialchars(stripslashes($signature));

			// Phoogle Map

			$map_center = str_replace($parens, "", $map_center); // strip off '(' and ')'

			$map_center = htmlspecialchars(stripslashes($map_center));

			$phoogle_allow = htmlspecialchars($phoogle_allow);

			$show_me = htmlspecialchars($show_me);

			$phoocomm = htmlspecialchars(stripslashes($phoocomm));

			$phooicon = htmlspecialchars(stripslashes($phooicon));

			// End Phoogle Map



			$user_lang = stripslashes($user_lang);

			$user_dateformat = htmlspecialchars(stripslashes($user_dateformat));

		}

	}

	else if( !isset( $HTTP_POST_VARS['submit'] ) && $mode != 'save' && !isset( $HTTP_POST_VARS['avatargallery'] ) && !isset( $HTTP_POST_VARS['submitavatar'] ) && !isset( $HTTP_POST_VARS['cancelavatar'] ) )

	{

		if( isset( $HTTP_GET_VARS[POST_USERS_URL]) || isset( $HTTP_POST_VARS[POST_USERS_URL]) )

		{

			$user_id = ( isset( $HTTP_POST_VARS[POST_USERS_URL]) ) ? intval( $HTTP_POST_VARS[POST_USERS_URL]) : intval( $HTTP_GET_VARS[POST_USERS_URL]);

			$this_userdata = get_userdata($user_id);

			if( !$this_userdata )

			{

				message_die(GENERAL_MESSAGE, $lang['No_user_id_specified'] );

			}

		}

		else

		{

			$this_userdata = get_userdata($HTTP_POST_VARS['username'], true);

			if( !$this_userdata )

			{

				message_die(GENERAL_MESSAGE, $lang['No_user_id_specified'] );

			}

		}



		//

		// Now parse and display it as a template

		//

		$user_id = $this_userdata['user_id'];

		$username = $this_userdata['username'];

		$email = $this_userdata['user_email'];

		$password = '';

		$password_confirm = '';



		$icq = $this_userdata['user_icq'];

		$aim = htmlspecialchars(str_replace('+', ' ', $this_userdata['user_aim'] ));

		$msn = htmlspecialchars($this_userdata['user_msnm']);

		$yim = htmlspecialchars($this_userdata['user_yim']);



		$website = htmlspecialchars($this_userdata['user_website']);

		$location = htmlspecialchars($this_userdata['user_from']);

		$user_flag = htmlspecialchars($this_userdata['user_from_flag']);	// Country/Location Flags

		$occupation = htmlspecialchars($this_userdata['user_occ']);

		$interests = htmlspecialchars($this_userdata['user_interests']);



		$signature = ($this_userdata['user_sig_bbcode_uid'] != '') ? preg_replace('#:' . $this_userdata['user_sig_bbcode_uid'] . '#si', '', $this_userdata['user_sig']) : $this_userdata['user_sig'];

		$signature = preg_replace($html_entities_match, $html_entities_replace, $signature);

		// Phoogle Map

		$map_center = htmlspecialchars($this_userdata['user_phoogle_map_center']);

		$phoogle_allow = htmlspecialchars($this_userdata['user_phoogle_allow']);

		$show_me = htmlspecialchars($this_userdata['user_phoogle_show_me']);

		$phoocomm = $this_userdata['user_phoogle_comment'];

		$phoocomm = htmlspecialchars($this_userdata['user_phoogle_comment']);

		$phoocomm = preg_replace($html_entities_match, $html_entities_replace, $phoocomm);

		$phooicon = htmlspecialchars($this_userdata['user_phoogle_icon']);

		// End Phoogle Map



		$viewemail = $this_userdata['user_viewemail'];

		$notifypm = $this_userdata['user_notify_pm'];

		$popuppm = $this_userdata['user_popup_pm'];

		$notifyreply = $this_userdata['user_notify'];

		$attachsig = $this_userdata['user_attachsig'];

		$allowhtml = $this_userdata['user_allowhtml'];

		$allowbbcode = $this_userdata['user_allowbbcode'];

		$allowsmilies = $this_userdata['user_allowsmile'];

		$allowviewonline = $this_userdata['user_allow_viewonline'];



		$user_avatar = $this_userdata['user_avatar'];

		$user_avatar_type = $this_userdata['user_avatar_type'];

		$user_style = $this_userdata['user_style'];

		$user_lang = $this_userdata['user_lang'];

		$user_timezone = $this_userdata['user_timezone'];

		$user_dateformat = htmlspecialchars($this_userdata['user_dateformat']);

		$user_show_quickreply = $this_userdata['user_show_quickreply'];

		$user_quickreply_mode = $this_userdata['user_quickreply_mode'];

		$user_open_quickreply = $this_userdata['user_open_quickreply'];



		

		$user_status = $this_userdata['user_active'];

		$user_allowavatar = $this_userdata['user_allowavatar'];

		$user_allowpm = $this_userdata['user_allow_pm'];

      $admin_notes = $this_userdata['user_admin_notes'];



		

		$COPPA = false;



		$html_status =  ($this_userdata['user_allowhtml'] ) ? $lang['HTML_is_ON'] : $lang['HTML_is_OFF'];

		$bbcode_status = ($this_userdata['user_allowbbcode'] ) ? $lang['BBCode_is_ON'] : $lang['BBCode_is_OFF'];

		$smilies_status = ($this_userdata['user_allowsmile'] ) ? $lang['Smilies_are_ON'] : $lang['Smilies_are_OFF'];

	}



	if( isset($HTTP_POST_VARS['avatargallery']) && !$error )

	{

		if( !$error )

		{

			$user_id = intval($HTTP_POST_VARS['id']);



			$template->set_filenames(array(

				"body" => "admin/user_avatar_gallery.tpl")

			);



			$dir = @opendir("../" . $board_config['avatar_gallery_path']);



			$avatar_images = array();

			while( $file = @readdir($dir) )

			{

				if( $file != "." && $file != ".." && !is_file(phpbb_realpath("./../" . $board_config['avatar_gallery_path'] . "/" . $file)) && !is_link(phpbb_realpath("./../" . $board_config['avatar_gallery_path'] . "/" . $file)) )

				{

					$sub_dir = @opendir("../" . $board_config['avatar_gallery_path'] . "/" . $file);



					$avatar_row_count = 0;

					$avatar_col_count = 0;



					while( $sub_file = @readdir($sub_dir) )

					{

						if( preg_match("/(\.gif$|\.png$|\.jpg)$/is", $sub_file) )

						{

							$avatar_images[$file][$avatar_row_count][$avatar_col_count] = $sub_file;



							$avatar_col_count++;

							if( $avatar_col_count == 5 )

							{

								$avatar_row_count++;

								$avatar_col_count = 0;

							}

						}

					}

				}

			}

	

			@closedir($dir);



			if( isset($HTTP_POST_VARS['avatarcategory']) )

			{

				$category = htmlspecialchars($HTTP_POST_VARS['avatarcategory']);

			}

			else

			{

				list($category, ) = each($avatar_images);

			}

			@reset($avatar_images);



			$s_categories = "";

			while( list($key) = each($avatar_images) )

			{

				$selected = ( $key == $category ) ? "selected=\"selected\"" : "";

				if( count($avatar_images[$key]) )

				{

					$s_categories .= '<option value="' . $key . '"' . $selected . '>' . ucfirst($key) . '</option>';

				}

			}



			$s_colspan = 0;

			for($i = 0; $i < count($avatar_images[$category]); $i++)

			{

				$template->assign_block_vars("avatar_row", array());



				$s_colspan = max($s_colspan, count($avatar_images[$category][$i]));



				for($j = 0; $j < count($avatar_images[$category][$i]); $j++)

				{

					$template->assign_block_vars("avatar_row.avatar_column", array(

						"AVATAR_IMAGE" => "../" . $board_config['avatar_gallery_path'] . '/' . $category . '/' . $avatar_images[$category][$i][$j])

					);



					$template->assign_block_vars("avatar_row.avatar_option_column", array(

						"S_OPTIONS_AVATAR" => $avatar_images[$category][$i][$j])

					);

				}

			}



			$coppa = ( ( !$HTTP_POST_VARS['coppa'] && !$HTTP_GET_VARS['coppa'] ) || $mode == "register") ? 0 : TRUE;



			$s_hidden_fields = '<input type="hidden" name="mode" value="edit" /><input type="hidden" name="agreed" value="true" /><input type="hidden" name="coppa" value="' . $coppa . '" /><input type="hidden" name="avatarcatname" value="' . $category . '" />';

			$s_hidden_fields .= '<input type="hidden" name="id" value="' . $user_id . '" />';



			$s_hidden_fields .= '<input type="hidden" name="username" value="' . str_replace("\"", """, $username) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="email" value="' . str_replace("\"", """, $email) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="icq" value="' . str_replace("\"", """, $icq) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="aim" value="' . str_replace("\"", """, $aim) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="msn" value="' . str_replace("\"", """, $msn) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="yim" value="' . str_replace("\"", """, $yim) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="website" value="' . str_replace("\"", """, $website) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="location" value="' . str_replace("\"", """, $location) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="user_flag" value="' . str_replace("\"", """, $user_flag) . '" />';	// Country/Location Flags

			$s_hidden_fields .= '<input type="hidden" name="occupation" value="' . str_replace("\"", """, $occupation) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="interests" value="' . str_replace("\"", """, $interests) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="signature" value="' . str_replace("\"", """, $signature) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="viewemail" value="' . $viewemail . '" />';

			$s_hidden_fields .= '<input type="hidden" name="notifypm" value="' . $notifypm . '" />';

			$s_hidden_fields .= '<input type="hidden" name="popup_pm" value="' . $popuppm . '" />';

			$s_hidden_fields .= '<input type="hidden" name="notifyreply" value="' . $notifyreply . '" />';

			$s_hidden_fields .= '<input type="hidden" name="attachsig" value="' . $attachsig . '" />';

			$s_hidden_fields .= '<input type="hidden" name="allowhtml" value="' . $allowhtml . '" />';

			$s_hidden_fields .= '<input type="hidden" name="allowbbcode" value="' . $allowbbcode . '" />';

			$s_hidden_fields .= '<input type="hidden" name="allowsmilies" value="' . $allowsmilies . '" />';

			$s_hidden_fields .= '<input type="hidden" name="hideonline" value="' . !$allowviewonline . '" />';

			$s_hidden_fields .= '<input type="hidden" name="style" value="' . $user_style . '" />'; 

			$s_hidden_fields .= '<input type="hidden" name="language" value="' . $user_lang . '" />';

			$s_hidden_fields .= '<input type="hidden" name="timezone" value="' . $user_timezone . '" />';

			$s_hidden_fields .= '<input type="hidden" name="dateformat" value="' . str_replace("\"", """, $user_dateformat) . '" />';

			$s_hidden_fields .= '<input type="hidden" name="show_quickreply" value="' . $user_show_quickreply . '" />';

			$s_hidden_fields .= '<input type="hidden" name="quickreply_mode" value="' . $user_quickreply_mode . '" />';

			$s_hidden_fields .= '<input type="hidden" name="open_quickreply" value="' . $user_quickreply_mode . '" />';





			$s_hidden_fields .= '<input type="hidden" name="user_status" value="' . $user_status . '" />';

			$s_hidden_fields .= '<input type="hidden" name="user_allowpm" value="' . $user_allowpm . '" />';

         $s_hidden_fields .= '<input type="hidden" name="user_admin_notes" value="' . $user_admin_notes . '" />';



			$s_hidden_fields .= '<input type="hidden" name="user_allowavatar" value="' . $user_allowavatar . '" />';

			$s_hidden_fields .= '<input type="hidden" name="user_rank" value="' . $user_rank . '" />';

			$s_hidden_fields .= '<input type="hidden" name="map_center" value="' . $map_center . '" />';

			$s_hidden_fields .= '<input type="hidden" name="phoogle_allow" value="' . $phoogle_allow . '" />';

			$s_hidden_fields .= '<input type="hidden" name="show_me" value="' . $show_me . '" />';

			$s_hidden_fields .= '<input type="hidden" name="phoocomm" value="' . $phoocomm . '" />';

			$s_hidden_fields .= '<input type="hidden" name="phooicon" value="' . $phooicon . '" />';



			$template->assign_vars(array(

				"L_USER_TITLE" => $lang['User_admin'],

				"L_USER_EXPLAIN" => $lang['User_admin_explain'],

				"L_AVATAR_GALLERY" => $lang['Avatar_gallery'], 

				"L_SELECT_AVATAR" => $lang['Select_avatar'], 

				"L_RETURN_PROFILE" => $lang['Return_profile'], 

				"L_CATEGORY" => $lang['Select_category'], 

				"L_GO" => $lang['Go'],



				"S_OPTIONS_CATEGORIES" => $s_categories, 

				"S_COLSPAN" => $s_colspan, 

				"S_PROFILE_ACTION" => append_sid("admin_users.$phpEx?mode=$mode"), 

				"S_HIDDEN_FIELDS" => $s_hidden_fields)

			);

		}

	}

	else

	{

		$s_hidden_fields = '<input type="hidden" name="mode" value="save" /><input type="hidden" name="agreed" value="true" /><input type="hidden" name="coppa" value="' . $coppa . '" />';

		$s_hidden_fields .= '<input type="hidden" name="id" value="' . $this_userdata['user_id'] . '" />';



		if( !empty($user_avatar_local) )

		{

			$s_hidden_fields .= '<input type="hidden" name="avatarlocal" value="' . $user_avatar_local . '" /><input type="hidden" name="avatarcatname" value="' . $user_avatar_category . '" />';

		}



		if( $user_avatar_type )

		{

			switch( $user_avatar_type )

			{

				case USER_AVATAR_UPLOAD:

					$avatar = '<img src="../' . $board_config['avatar_path'] . '/' . $user_avatar . '" alt="" />';

					break;

				case USER_AVATAR_REMOTE:

					$avatar = '<img src="' . $user_avatar . '" alt="" />';

					break;

				case USER_AVATAR_GALLERY:

					$avatar = '<img src="../' . $board_config['avatar_gallery_path'] . '/' . $user_avatar . '" alt="" />';

					break;

			}

		}

		else

		{

			$avatar = "";

		}



		$sql = "SELECT * FROM " . RANKS_TABLE . "

			WHERE rank_special = 1

			ORDER BY rank_title";

		if ( !($result = $db->sql_query($sql)) )

		{

			message_die(GENERAL_ERROR, 'Could not obtain ranks data', '', __LINE__, __FILE__, $sql);

		}



		$rank_select_box = '<option value="0">' . $lang['No_assigned_rank'] . '</option>';

		while( $row = $db->sql_fetchrow($result) )

		{

			$rank = $row['rank_title'];

			$rank_id = $row['rank_id'];

			

			$selected = ( $this_userdata['user_rank'] == $rank_id ) ? ' selected="selected"' : '';

			$rank_select_box .= '<option value="' . $rank_id . '"' . $selected . '>' . $rank . '</option>';

		}



		$template->set_filenames(array(

			"body" => "admin/user_edit_body.tpl")

		);

		

		//

		// Let's do an overall check for settings/versions which would prevent

		// us from doing file uploads....

		//

		$ini_val = ( phpversion() >= '4.0.0' ) ? 'ini_get' : 'get_cfg_var';

		$form_enctype = ( !@$ini_val('file_uploads')		// Country/Location Flags

		// Query to get the list of flags

		$sql = "SELECT *

			FROM " . FLAG_TABLE . "

			ORDER BY flag_name";

		if(!$flags_result = $db->sql_query($sql))

		{

			message_die(GENERAL_ERROR, "Couldn't obtain flags information.", "", __LINE__, __FILE__, $sql);

		}



		// Build the html select statement

		$flag_start_image = 'blank.gif';

		$flag_select = '<select name="user_flag" onChange="document.images[\'user_flag\'].src = \'../images/flags/\' + this.value;">';

		$flag_select .= '<option value="blank.gif">' . $lang['Select_country'] . '</option>';

		while ( $flag_row = $db->sql_fetchrow($flags_result) )

		{

			$flag_name = $flag_row['flag_name'];

			$flag_image = $flag_row['flag_image'];

			$selected = ( $user_flag == $flag_image ) ? ' selected="selected"' : '';

			$flag_select .= '&nbsp;&nbsp;&nbsp;<option value="' . $flag_image . '"' . $selected . '">' . $flag_name . '</option>';

			if ( isset( $user_flag) && ($user_flag == $flag_image))

			{

				$flag_start_image = $flag_image;

			}

		}

		$flag_select .= '</select>'; || phpversion() == '4.0.4pl1' || !$board_config['allow_avatar_upload'] || ( phpversion() < '4.0.3' && @$ini_val('open_basedir') != '' ) ) ? '' : 'enctype="multipart/form-data"';

		// Phoogle Map

		// Create a new map and show Zoom slider

	$userMap = new PhoogleMap();

	$userMap->setAPIKey("$api_key");

	$userMap->setWidth("$map_width");

	$userMap->setHeight("$map_height");

	$userMap->showControl = 'true'; 

	$userMap->controlType = 'small';

	$userMap->showType = 'true';

	$userMap->showScale = 'false'; 

	$userMap->showOverview = 'false'; 

	if(!empty($map_center))

	{

		$parens = array("(",")");

		$map_center = str_replace($parens, "", $map_center);

		$userMap->centerMap = "map.setCenter(new GLatLng($map_center), $user_zoom);";

	} else 

	{

		$parens = array("(",")");

		$map_center_c = str_replace($parens, "", $map_center_c);

		$userMap->centerMap = "map.setCenter(new GLatLng($map_center_c), $user_zoom);";

	}

		// End Phoogle Map



		$template->assign_vars(array(

			'USERNAME' => $username,

			'EMAIL' => $email,

			'YIM' => $yim,

			'ICQ' => $icq,

			'MSN' => $msn,

			'AIM' => $aim,

			'OCCUPATION' => $occupation,

			'INTERESTS' => $interests,

			'LOCATION' => $location,

			'L_FLAG' => $lang['Country_flag'],	// Country/Location Flags

			'FLAG_SELECT' => $flag_select,		// Country/Location Flags

			'FLAG_START' => $flag_start_image,	// Country/Location Flags

			'WEBSITE' => $website,

			'SIGNATURE' => str_replace('<br />', "\n", $signature),

			// Phoogle Map

			'API_KEY' => $api_key,

			'HEIGHT_MEASURE' => $height_measure,

			'MAP_CENTER' => str_replace($parens, "", $map_center),

			'MAP_HEIGHT' => $map_height,

			'MAP_WIDTH' => $map_width,

			'MARKER_10_CHECKED' => ($phooicon == '10') ? 'checked="checked"' : '',

			'MARKER_1_CHECKED' => ($phooicon == '1') ? 'checked="checked"' : '',

			'MARKER_2_CHECKED' => ($phooicon == '2') ? 'checked="checked"' : '',

			'MARKER_3_CHECKED' => ($phooicon == '3') ? 'checked="checked"' : '',

			'MARKER_4_CHECKED' => ($phooicon == '4') ? 'checked="checked"' : '',

			'MARKER_5_CHECKED' => ($phooicon == '5') ? 'checked="checked"' : '',

			'MARKER_6_CHECKED' => ($phooicon == '6') ? 'checked="checked"' : '',

			'MARKER_7_CHECKED' => ($phooicon == '7') ? 'checked="checked"' : '',

			'MARKER_8_CHECKED' => ($phooicon == '8') ? 'checked="checked"' : '',

			'MARKER_9_CHECKED' => ($phooicon == '9') ? 'checked="checked"' : '',

			'MARKER_FOLDER' => $phpbb_root_path.$marker_folder,

			'PHOOGLE_ALLOW_NO' => ( !$phoogle_allow ) ? 'checked="checked"' : '',

			'PHOOGLE_ALLOW_YES' => ( $phoogle_allow ) ? 'checked="checked"' : '',

			'PHOOGLE_COMMENT' => str_replace('<br />', "\n", $phoocomm),

			'PHOOGLE_ICON' => $phooicon,

	        'SHOW_ME_YES' => ( $show_me == 1 ) ? 'checked="checked"' : '',

          	'SHOW_ME_NO' => ( $show_me == 0 ) ? 'checked="checked"' : '',

          	'SHOW_CONFIRM_YES_DISPLAY' => ( $show_me == 1 ) ? 'block' : 'none',

          	'SHOW_CONFIRM_NO_DISPLAY' => ( $show_me == 0 ) ? 'block' : 'none',

			'TARGET_FOLDER' => $phpbb_root_path.$target_folder,

			'WIDTH_MEASURE' => $width_measure,

			

			"PHOOGLE_SCRIPT" => $userMap->printGoogleJS(),

			"PHOOGLE_MAP" => $userMap->showMap(),

			// End Phoogle Map

			'VIEW_EMAIL_YES' => ($viewemail) ? 'checked="checked"' : '',

			'VIEW_EMAIL_NO' => (!$viewemail) ? 'checked="checked"' : '',

			'HIDE_USER_YES' => (!$allowviewonline) ? 'checked="checked"' : '',

			'HIDE_USER_NO' => ($allowviewonline) ? 'checked="checked"' : '',

			'NOTIFY_PM_YES' => ($notifypm) ? 'checked="checked"' : '',

			'NOTIFY_PM_NO' => (!$notifypm) ? 'checked="checked"' : '',

			'POPUP_PM_YES' => ($popuppm) ? 'checked="checked"' : '',

			'POPUP_PM_NO' => (!$popuppm) ? 'checked="checked"' : '',

			'ALWAYS_ADD_SIGNATURE_YES' => ($attachsig) ? 'checked="checked"' : '',

			'ALWAYS_ADD_SIGNATURE_NO' => (!$attachsig) ? 'checked="checked"' : '',

			'NOTIFY_REPLY_YES' => ( $notifyreply ) ? 'checked="checked"' : '',

			'NOTIFY_REPLY_NO' => ( !$notifyreply ) ? 'checked="checked"' : '',

			'ALWAYS_ALLOW_BBCODE_YES' => ($allowbbcode) ? 'checked="checked"' : '',

			'ALWAYS_ALLOW_BBCODE_NO' => (!$allowbbcode) ? 'checked="checked"' : '',

			'ALWAYS_ALLOW_HTML_YES' => ($allowhtml) ? 'checked="checked"' : '',

			'ALWAYS_ALLOW_HTML_NO' => (!$allowhtml) ? 'checked="checked"' : '',

			'ALWAYS_ALLOW_SMILIES_YES' => ($allowsmilies) ? 'checked="checked"' : '',

			'ALWAYS_ALLOW_SMILIES_NO' => (!$allowsmilies) ? 'checked="checked"' : '',

			'AVATAR' => $avatar,

			'LANGUAGE_SELECT' => language_select($user_lang),

			'TIMEZONE_SELECT' => tz_select($user_timezone),

			'STYLE_SELECT' => style_select($user_style, 'style'),

			'DATE_FORMAT' => $user_dateformat,

			'QUICK_REPLY_SELECT' => quick_reply_select($user_show_quickreply, 'show_quickreply'),

			'QUICK_REPLY_MODE_BASIC' => ( $user_quickreply_mode==0 ) ? 'checked="checked"' : '',

			'QUICK_REPLY_MODE_ADVANCED' => ( $user_quickreply_mode!=0 ) ? 'checked="checked"' : '',

			'OPEN_QUICK_REPLY_YES' => ( $user_open_quickreply ) ? 'checked="checked"' : '',

			'OPEN_QUICK_REPLY_NO' => ( !$user_open_quickreply ) ? 'checked="checked"' : '',



			'ALLOW_PM_YES' => ($user_allowpm) ? 'checked="checked"' : '',

			'ALLOW_PM_NO' => (!$user_allowpm) ? 'checked="checked"' : '',

			'ALLOW_AVATAR_YES' => ($user_allowavatar) ? 'checked="checked"' : '',

			'ALLOW_AVATAR_NO' => (!$user_allowavatar) ? 'checked="checked"' : '',

			'USER_ACTIVE_YES' => ($user_status) ? 'checked="checked"' : '',

			'USER_ACTIVE_NO' => (!$user_status) ? 'checked="checked"' : '', 

			'RANK_SELECT_BOX' => $rank_select_box,

         'ADMIN_NOTES' => $admin_notes,

         'L_ADMIN_NOTES' =>  $lang['Admin_notes'],





			'L_USERNAME' => $lang['Username'],

			'L_USER_TITLE' => $lang['User_admin'],

			'L_USER_EXPLAIN' => $lang['User_admin_explain'],

			'L_NEW_PASSWORD' => $lang['New_password'], 

			'L_PASSWORD_IF_CHANGED' => $lang['password_if_changed'],

			'L_CONFIRM_PASSWORD' => $lang['Confirm_password'],

			'L_PASSWORD_CONFIRM_IF_CHANGED' => $lang['password_confirm_if_changed'],

			'L_SUBMIT' => $lang['Submit'],

			'L_RESET' => $lang['Reset'],

			'L_ICQ_NUMBER' => $lang['ICQ'],

			'L_MESSENGER' => $lang['MSNM'],

			'L_YAHOO' => $lang['YIM'],

			'L_WEBSITE' => $lang['Website'],

			'L_AIM' => $lang['AIM'],

			'L_LOCATION' => $lang['Location'],

			'L_OCCUPATION' => $lang['Occupation'],

			'L_BOARD_LANGUAGE' => $lang['Board_lang'],

			'L_BOARD_STYLE' => $lang['Board_style'],

			'L_TIMEZONE' => $lang['Timezone'],

			'L_DATE_FORMAT' => $lang['Date_format'],

			'L_DATE_FORMAT_EXPLAIN' => $lang['Date_format_explain'],

			'L_QUICK_REPLY_PANEL' => $lang['Quick_reply_panel'],

			'L_SHOW_QUICK_REPLY' => $lang['Show_quick_reply'],

			'L_QUICK_REPLY_MODE' => $lang['Quick_reply_mode'],

			'L_QUICK_REPLY_MODE_BASIC' => $lang['Quick_reply_mode_basic'],

			'L_QUICK_REPLY_MODE_ADVANCED' => $lang['Quick_reply_mode_advanced'],

			'L_OPEN_QUICK_REPLY' => $lang['Open_quick_reply'],



			'L_YES' => $lang['Yes'],

			'L_NO' => $lang['No'],

			'L_INTERESTS' => $lang['Interests'],

			'L_ALWAYS_ALLOW_SMILIES' => $lang['Always_smile'],

			'L_ALWAYS_ALLOW_BBCODE' => $lang['Always_bbcode'],

			'L_ALWAYS_ALLOW_HTML' => $lang['Always_html'],

			'L_HIDE_USER' => $lang['Hide_user'],

			'L_ALWAYS_ADD_SIGNATURE' => $lang['Always_add_sig'],

			

			'L_SPECIAL' => $lang['User_special'],

			'L_SPECIAL_EXPLAIN' => $lang['User_special_explain'],

			'L_USER_ACTIVE' => $lang['User_status'],

			'L_ALLOW_PM' => $lang['User_allowpm'],

			'L_ALLOW_AVATAR' => $lang['User_allowavatar'],

			

			'L_AVATAR_PANEL' => $lang['Avatar_panel'],

			'L_AVATAR_EXPLAIN' => $lang['Admin_avatar_explain'],

			'L_DELETE_AVATAR' => $lang['Delete_Image'],

			'L_CURRENT_IMAGE' => $lang['Current_Image'],

			'L_UPLOAD_AVATAR_FILE' => $lang['Upload_Avatar_file'],

			'L_UPLOAD_AVATAR_URL' => $lang['Upload_Avatar_URL'],

			'L_AVATAR_GALLERY' => $lang['Select_from_gallery'],

			'L_SHOW_GALLERY' => $lang['View_avatar_gallery'],

			'L_LINK_REMOTE_AVATAR' => $lang['Link_remote_Avatar'],



			'L_SIGNATURE' => $lang['Signature'],

			// Phoogle Map

			'L_PHOOGLE_ALLOW' => $lang['Phoogle_Allow'],

			'L_PHOOGLE_ALLOW_CONFIRM' => $lang['Phoogle_Allow_Confirm'],

			'L_PHOOGLE_CENTER' => $lang['Phoogle_Center'],

			'L_PHOOGLE_COMMENT' => $lang['Phoogle_Comment'],

			'L_PHOOGLE_COMMENT_EXPLAIN' => $lang['Phoogle_Comment_Explain'],

			'L_PHOOGLE_EXPLAIN' => $lang['Phoogle_Explain'],

			'L_PHOOGLE_GET' => $lang['Phoogle_Get'],

			'L_PHOOGLE_ICON' => $lang['Phoogle_Icon'],

			'L_PHOOGLE_PROFILE' => $lang['Phoogle_Profile'],

			'L_PHOOGLE_SHOW_CONFIRM_YES' => $lang['Phoogle_Show_Me_Confirm_Yes'],

			'L_PHOOGLE_SHOW_CONFIRM_NO' =>  $lang['Phoogle_Show_Me_Confirm_No'],

			'L_PHOOGLE_SHOW_ME' => $lang['Phoogle_Show_Me'],

			// End Phoogle Map

			'L_SIGNATURE_EXPLAIN' => sprintf($lang['Signature_explain'], $board_config['max_sig_chars'] ),

			'L_NOTIFY_ON_PRIVMSG' => $lang['Notify_on_privmsg'],

			'L_NOTIFY_ON_REPLY' => $lang['Always_notify'],

			'L_POPUP_ON_PRIVMSG' => $lang['Popup_on_privmsg'],

			'L_PREFERENCES' => $lang['Preferences'],

			'L_PUBLIC_VIEW_EMAIL' => $lang['Public_view_email'],

			'L_ITEMS_REQUIRED' => $lang['Items_required'],

			'L_REGISTRATION_INFO' => $lang['Registration_info'],

			'L_PROFILE_INFO' => $lang['Profile_info'],

			'L_PROFILE_INFO_NOTICE' => $lang['Profile_info_warn'],

			'L_EMAIL_ADDRESS' => $lang['Email_address'],

			'S_FORM_ENCTYPE' => $form_enctype,



			'HTML_STATUS' => $html_status,

			'BBCODE_STATUS' => sprintf($bbcode_status, '<a href="../' . append_sid("faq.$phpEx?mode=bbcode") . '" target="_phpbbcode">', '</a>'), 

			'SMILIES_STATUS' => $smilies_status,



			'L_DELETE_USER' => $lang['User_delete'],

			'L_DELETE_USER_EXPLAIN' => $lang['User_delete_explain'],

			'L_SELECT_RANK' => $lang['Rank_title'],



			'S_HIDDEN_FIELDS' => $s_hidden_fields,

			'S_PROFILE_ACTION' => append_sid("admin_users.$phpEx"))

		);



		if( file_exists(@phpbb_realpath('./../' . $board_config['avatar_path'])) && ($board_config['allow_avatar_upload'] == TRUE) )

		{

			if ( $form_enctype != '' )

			{

				$template->assign_block_vars('avatar_local_upload', array() );

			}

			$template->assign_block_vars('avatar_remote_upload', array() );

		}



		if( file_exists(@phpbb_realpath('./../' . $board_config['avatar_gallery_path'])) && ($board_config['allow_avatar_local'] == TRUE) )

		{

			$template->assign_block_vars('avatar_local_gallery', array() );

		}

		

		if( $board_config['allow_avatar_remote'] == TRUE )

		{

			$template->assign_block_vars('avatar_remote_link', array() );

		}

	}



	$template->pparse('body');

}

else

{

	//

	// Default user selection box

	//

	$template->set_filenames(array(

		'body' => 'admin/user_select_body.tpl')

	);



	$template->assign_vars(array(

		'L_USER_TITLE' => $lang['User_admin'],

		'L_USER_EXPLAIN' => $lang['User_admin_explain'],

		'L_USER_SELECT' => $lang['Select_a_User'],

		'L_LOOK_UP' => $lang['Look_up_user'],

		'L_FIND_USERNAME' => $lang['Find_username'],



		'U_SEARCH_USER' => append_sid("./../search.$phpEx?mode=searchuser"), 



		'S_USER_ACTION' => append_sid("admin_users.$phpEx"),

		'S_USER_SELECT' => $select_list)

	);

	$template->pparse('body');



}



include('./page_footer_admin.'.$phpEx);



?>
Could someone please take a look and see if something looks wrong or there's an error... please! :|

Thank you

User avatar
Jim_UK
Former Team Member
Posts: 18478
Joined: Tue Oct 12, 2004 5:36 pm
Location: Darwen N.West UK

Re: Please help with my admin_users.php

Post by Jim_UK »

The line in question is this one

Code: Select all

$sql = "SELECT *
and is part of the flags mod.

Check that line in the mod instructions and then if still a problem please go back to the country flags mod release topic as that is where the support must come from.

Jim
The truth is out there.
Unfortunately they will not let you anywhere near it!

Locked

Return to “2.0.x Support Forum”