';
	}

	// unexpected mode, someone is trying to circumvent the password!  we'll fix 'em ;-)
	else
	{
		// they'll now end up at the password screen instead of whatever they were trying
		$mode = 'install';
		$get_password = true;
	}
}

// get post variables; we trust post variables ;-)
else
{
	$mode = ( !empty($HTTP_POST_VARS['mode']) ) ? stripslashes(trim($HTTP_POST_VARS['mode'])) : '';

	$password = ( !empty($HTTP_POST_VARS['password']) ) ? stripslashes($HTTP_POST_VARS['password']) : '';
	$install_file = ( !empty($HTTP_POST_VARS['install_file']) ) ? stripslashes(trim($HTTP_POST_VARS['install_file'])) : '';
	$install_path = ( !empty($HTTP_POST_VARS['install_path']) ) ? stripslashes(trim($HTTP_POST_VARS['install_path'])) : '';

	// 0.0.11 preview mode
	$preview = (isset($HTTP_POST_VARS['preview'])) ? true : false;
}


// make sure mode is valid; if not then set to default mode and get pw
if (($mode != 'history') && ($mode != 'settings') && ($mode != 'install') &&
	($mode != 'display_file') && ($mode != 'download_file') &&
	($mode != 'display_backup') && ($mode != 'download_backup') &&
	($mode != 'SQL_view') && ($mode != 'SQL_execute') &&
	($mode != 'update') && ($mode != 'process') && ($mode != 'post_process') && ($mode != 'diy_process') &&
	($mode != 'history_details') && ($mode != 'del_files') && ($mode != 'del_record') && ($mode != 'restore_backups') && ($mode != 'install_lang') && ($mode != 'install_themes') && ($mode != 'uninstall'))
{
	$mode = 'install';
	$get_password = true;
}



//
// if they are trying to get to the first page, check the pw; after that assume they are validated
//
$pass_message = '';
if ((($mode == 'install') || ($mode == 'settings') || ($mode == 'history') ||
	($mode == 'display_file') || ($mode == 'display_backup')) && (!$get_password))
{
	// compare passwords and send them back to the password screen if they fail
	if (md5($password) !== get_em_pw())
	{
		$get_password = true;
		$pass_message = '' . $lang['EM_err_pw_fail'] . '
';
	}
}


//
// if they are downloading or displaying a file or backup then we need to get setup
//

// downloading a file or a backup from the completed processing screen
if (($mode == 'download_file') || ($mode == 'download_backup'))
{
	// they clicked a form button; we need to figure out which one so we know what file they are looking for
	$num_files = ( isset($HTTP_POST_VARS['mod_count'])) ? intval($HTTP_POST_VARS['mod_count']) : 0;

	// loop through all the submit buttons to see which one was pressed
///////////////////////////////////
///////////////////////////////////
/////////////////////////////////// possible error.... should start at 0? was a 1 before
///////////////////////////////////
///////////////////////////////////
	for( $i=0; $i<=$num_files; $i++ )
	{
		$var_name = 'submitfile' . $i;

		// if this is the button that was pressed then we are all set!  get the file name
		if (isset($HTTP_POST_VARS[$var_name]))
		{
			$file = (isset($HTTP_POST_VARS['file'.$i])) ? stripslashes($HTTP_POST_VARS['file'.$i]) : '';
			break;
		}
	}

	// we'll need to look at the path and filename so split things up
	$split = explode('/', $file);

	// if a file, then make sure we have the filename correct
	if ($mode == 'download_file')
	{
		// by default the filename sent will match the one in the MOD script
		$process_file = (substr($file, 0, 9) == '../../../') ? substr($file, 9) : '';
		$orig_file = $process_file;

		// handle the special cases of a template file to download; only subSilver will appear in the MOD script
		if (($split[3] == 'templates') && ($split[4] != 'subSilver'))
		{
			$process_file = str_replace( $split[4], 'subSilver', $process_file);
		}

		// handle the special cases of a language file to download; only english will appear in the MOD script
		else if (($split[3] == 'language') && ($split[4] != 'lang_english'))
		{
			$process_file = str_replace( $split[4], 'lang_english', $process_file);
		}
	}

	// if a backup then we can assume the filename is valid
	else
	{
		$orig_file = $file;
		$process_file = (substr($file, 0, 9) == '../../../') ? substr($file, 9) : '';
		$process_file = $phpbb_root_path . $process_file;
	}


	// if there is no file to process then we are in trouble!
	if ($process_file == '')
	{
		message_die(GENERAL_ERROR, $lang['EM_err_no_process_file']);
	}

	// set up the redirects so we will download a file, the contents of which we will echo out
	header('Content-Type: text/x-delimtext; name="' . $split[count($split)-1] . '"');
	header('Content-disposition: attachment; filename="' . $split[count($split)-1] . '"');
}

// writing to screen, get set up
else if (($mode == 'display_file') || ($mode == 'display_backup'))
{
	// get the file name
	$file = (isset($HTTP_GET_VARS['file'])) ? stripslashes($HTTP_GET_VARS['file']) : '';
	$split = explode('/', $file);

	// if a file, then make sure we have the filename correct
	if ($mode == 'display_file')
	{
		// by default the filename sent will match the one in the MOD script
		$process_file = (substr($file, 0, 9) == '../../../') ? substr($file, 9) : '';
		$orig_file = $process_file;

		// handle the special cases of a template file to display; only subSilver will appear in the MOD script
		if (($split[3] == 'templates') && ($split[4] != 'subSilver'))
		{
			$process_file = str_replace( $split[4], 'subSilver', $process_file);
		}

		// handle the special cases of a language file to display; only english will appear in the MOD script
		else if (($split[3] == 'language') && ($split[4] != 'lang_english'))
		{
			$process_file = str_replace( $split[4], 'lang_english', $process_file);
		}
	}

	// if a backup then we can assume the filename is valid
	else
	{
		$orig_file = $file;
		$process_file = (substr($file, 0, 9) == '../../../') ? substr($file, 9) : '';
		$process_file = $phpbb_root_path . $process_file;
	}

	// if there is no file to process then we are in trouble!
	if ( $process_file == '')
	{
		message_die(GENERAL_ERROR, $lang['EM_err_no_process_file']);
	}
}



//
// Show the page header (if we aren't doing the display modes)
//
if (($mode != 'display_file') && ($mode != 'download_file') && ($mode != 'display_backup') && ($mode != 'download_backup'))
{
	$template->set_filenames(array(
		'mod_header' => 'admin/mod_header.tpl')
	);

	$template->assign_vars(array(
		'L_TITLE' => $lang['EM_Title'],
		'L_EM_VERSION' => EASYMOD_VER)
	);

	$template->pparse('mod_header');
}





//
// password authentication page
//
if ($get_password)
{
	// load the password page template
	$template->set_filenames(array(
		"body" => "admin/mod_login.tpl")
	);


	$template->assign_vars(array(
		'S_ACTION' => append_sid('admin_easymod.' . $phpEx),
		'L_ACCESS_WARNING' => $lang['EM_access_warning'],
		'L_MESSAGE' => $pass_message,
		'L_PASSWORD_TITLE' => $lang['EM_password_title'],
		'L_PASSWORD' => $lang['EM_password'],
		'L_ACCESS_EM' => $lang['EM_access_EM'],

		'MODE' => $mode)
	);
}


//
// display the settings page
//
else if ($mode == 'settings')
{
	// load the settings page template
	$template->set_filenames(array(
		"body" => "admin/mod_settings.tpl")
	);

	$command_file = get_em_settings('6E7574747A79.72756C657321', '', $password);

	$select_read =  'read_method == 'server') ? ' selected=selected' : ''). '>' . $lang['EM_read_server'] . '';

	$select_write =  'write_method == 'server') ? ' selected=selected' : ''). '>' . $lang['EM_write_server'] . '' . "\n";
	$select_write .= 'write_method == 'ftpb') ? ' selected=selected' : ''). '>' . $lang['EM_write_ftp'] . '' . "\n";
	$select_write .= 'write_method == 'local') ? ' selected=selected' : ''). '>' . $lang['EM_write_download'] . '' . "\n";
	$select_write .= '' . (($command_file->write_method == 'screen') ? ' selected=selected' : ''). '' . $lang['EM_write_screen'] . '' . "\n";

	$select_move =  'move_method == 'copy') ? ' selected=selected' : ''). '>' . $lang['EM_move_copy'] . '' . "\n";
	$select_move .= 'move_method == 'ftpa') ? ' selected=selected' : ''). '>' . $lang['EM_move_ftp'] . '' . "\n";
	$select_move .= 'move_method == 'exec') ? ' selected=selected' : ''). '>' . $lang['EM_move_exec'] . '' . "\n";
	$select_move .= 'move_method == 'ftpm') ? ' selected=selected' : ''). '>' . $lang['EM_move_manual'] . '' . "\n";

	$template->assign_vars(array(
		'S_ACTION' => append_sid('admin_easymod.' . $phpEx),
		'L_SETTINGS' => $lang['EM_settings'],
		'L_DESC' => $lang['EM_settings_desc'],

		'L_PW_TITLE' => $lang['EM_password_title'],
		'L_PW_DESC' => $lang['EM_settings_pw'],
		'L_PW_SET' => $lang['EM_password_set'],
		'L_PW_CONFIRM' => $lang['EM_password_confirm'],
		'L_EM_VERSION' => $lang['EM_easymod_version'],
		'L_EMV_DESC' => $lang['EM_emv_description'],

		'L_FILE_TITLE' => $lang['EM_file_title'],
		'L_FILE_DESC' => $lang['EM_file_desc'],
		'L_FILE_READ' => $lang['EM_file_reading'],
		'L_FILE_WRITE' => $lang['EM_file_writing'],
		'L_FILE_MOVE' => $lang['EM_file_moving'],

		'L_FTP_TITLE' => $lang['EM_ftp_title'],
		'L_FTP_DESC' => $lang['EM_ftp_desc'],
		'L_FTP_DIR' => $lang['EM_ftp_dir'],
		'L_FTP_USER' => $lang['EM_ftp_user'],
		'L_FTP_PASS' => $lang['EM_ftp_pass'],
		'L_FTP_HOST' => $lang['EM_ftp_host'],
		'L_FTP_PORT' => $lang['EM_ftp_port'],
		'L_FTP_DEBUG' => $lang['EM_ftp_debug'],
		'L_FTP_DEBUG_WARN' => $lang['EM_ftp_debug_not'],
		'L_FTP_EXT' => $lang['EM_ftp_use_ext'],
		'L_FTP_EXT_WARN' => $lang['EM_ftp_ext_not'],
		'L_FTP_CACHE' => $lang['EM_ftp_cache'],
		'L_SUPPLY_CHANGE' => $lang['EM_supply_on_change'],
		'L_YES' => $lang['EM_yes'],
		'L_NO' => $lang['EM_no'],
		'L_SUBMIT' => $lang['EM_settings_update'],

		'EM_PASS' => htmlspecialchars($password),
		'EM_VERSION' => get_em_version(),

		'SELECT_READ' => $select_read,
		'SELECT_WRITE' => $select_write,
		'SELECT_MOVE' => $select_move,

		'FTP_USER' => $command_file->ftp_user,
		'FTP_PASS' => '', // don't send FTP password to page, is unsecure $command_file->ftp_pass,
		'FTP_PATH' => $command_file->ftp_path,
		'FTP_HOST' => $command_file->ftp_host,
		'FTP_PORT' => $command_file->ftp_port,
		'FTP_EXT' => ($command_file->ftp_type == 'ext') ? 'checked="checked"' : '',
		'FTP_FSOCK' => ($command_file->ftp_type == 'fsock') ? 'checked="checked"' : '',
		'FTP_CACHE_YES' => ($command_file->ftp_cache) ? 'checked="checked"' : '',
		'FTP_CACHE_NO' => (!$command_file->ftp_cache) ? 'checked="checked"' : '',

		'U_HELP' => append_sid('admin_easymod.' . $phpEx . '?mode=help'),
		'L_HELP' => $lang['EM_more_info'],

		'MODE' => 'update')
	);
}


//
// update the EM settings; they already filled out the settings page and hit submit
//
else if ($mode == 'update')
{
	// password settings
	$em_pass = (isset($HTTP_POST_VARS['em_pass'])) ? stripslashes($HTTP_POST_VARS['em_pass']) : '';
	$em_pass_confirm = (isset($HTTP_POST_VARS['em_pass_confirm'])) ? stripslashes($HTTP_POST_VARS['em_pass_confirm']) : '';
	$em_version = (isset($HTTP_POST_VARS['em_version'])) ? stripslashes($HTTP_POST_VARS['em_version']) : '';

	// file access settings
	$read = (isset($HTTP_POST_VARS['sel_read'])) ? stripslashes($HTTP_POST_VARS['sel_read']) : '';
	$write = (isset($HTTP_POST_VARS['sel_write'])) ? stripslashes($HTTP_POST_VARS['sel_write']) : '';
	$move = (isset($HTTP_POST_VARS['sel_move'])) ? stripslashes($HTTP_POST_VARS['sel_move']) : '';

	// ftp settings
	$ftp_user = (isset($HTTP_POST_VARS['ftp_user'])) ? stripslashes($HTTP_POST_VARS['ftp_user']) : '';
	$ftp_pass = (isset($HTTP_POST_VARS['ftp_pass'])) ? stripslashes($HTTP_POST_VARS['ftp_pass']) : '';
	$ftp_host = (isset($HTTP_POST_VARS['ftp_host'])) ? stripslashes($HTTP_POST_VARS['ftp_host']) : '';
	$ftp_port = (isset($HTTP_POST_VARS['ftp_port'])) ? intval($HTTP_POST_VARS['ftp_port']) : 0;
	$ftp_debug = (isset($HTTP_POST_VARS['ftp_debug'])) ? intval($HTTP_POST_VARS['ftp_debug']) : false;
	$ftp_type = (isset($HTTP_POST_VARS['ftp_type'])) ? stripslashes($HTTP_POST_VARS['ftp_type']) : 'fsock';
	$ftp_cache = (isset($HTTP_POST_VARS['ftp_cache'])) ? intval($HTTP_POST_VARS['ftp_cache']) : 0;
	$ftp_dir = (isset($HTTP_POST_VARS['ftp_dir'])) ? stripslashes($HTTP_POST_VARS['ftp_dir']) : '/';
	$ftp_dir == ( $ftp_dir == '') ? '/' : $ftp_dir;

	// confirm passwords match and update pw if needed
	if ($em_pass === $em_pass_confirm)
	{
		// update the password; starting with 0.0.11 store as MD5 hash
		em_db_update('EM_password', md5($em_pass));
		$pass_msg = (empty($em_pass)) ? $lang['EM_pass_disabled'] : $lang['EM_pass_updated'];
		$force_ftp_pass = true;
	}
	// the confirm is empty so they are not trying to update the pw, so don't
	else if (empty($em_pass_confirm))
	{
		$pass_msg = $lang['EM_pass_not_updated'];
		$force_ftp_pass = false;
	}
	// passwords do not match so throw an error
	else if ($em_pass !== $em_pass_confirm)
	{
		message_die(GENERAL_ERROR, $lang['EM_err_set_pw']);
	}

	// update the settings
	em_db_update('EM_read', str_replace("'", "''", $read));
	em_db_update('EM_write', str_replace("'", "''", $write));
	em_db_update('EM_move', str_replace("'", "''", $move));
	em_db_update('EM_ftp_dir', str_replace("'", "''", $ftp_dir));
	em_db_update('EM_ftp_user', str_replace("'", "''", $ftp_user));

	if ( $force_ftp_pass || !empty($ftp_pass) )
	{
		// If they are updating the EM password, but they haven't supplied the FTP password, then
		// we need the old EM password to decrypt the FTP password so it can be encrypted again
		if( empty($ftp_pass) )
		{
			$ftp_pass = crypt_ftp_pass(EM_DECRYPT, $board_config['EM_ftp_pass'], $password);
		}
		em_db_update('EM_ftp_pass', str_replace("'", "''", crypt_ftp_pass(EM_ENCRYPT, $ftp_pass, $em_pass)));
	}

	em_db_update('EM_ftp_host', str_replace("'", "''", $ftp_host));
	em_db_update('EM_ftp_port', $ftp_port);
	em_db_update('EM_ftp_type', str_replace("'", "''", $ftp_type));
	em_db_update('EM_ftp_cache', $ftp_cache);
	em_db_update('EM_version', str_replace("'", "''", $em_version));

	// Test the FTP connection?
	if( $write == 'ftpb' || $move == 'ftpa' )
	{
		$command_file = get_em_settings('6E7574747A79.72756C657321', '', $password);
		$test_report = '';
		$test_result = capture_test_ftp($ftp_user, $ftp_pass, $ftp_dir, $ftp_host, $ftp_port, $ftp_debug, $ftp_type, $ftp_cache, $test_report);
		$test_report = '
' . $test_report . '
';
	}
	else
	{
		$test_report = '';
	}

	message_die(GENERAL_MESSAGE, '
' . $lang['EM_settings_success'] . " $pass_msg

$test_report");
}

//
// history
//
else if ($mode == 'history')
{
	$filter_option = isset($HTTP_POST_VARS['filter_option']) ? stripslashes(trim($HTTP_POST_VARS['filter_option'])) : '';

	// load the history page template
	$template->set_filenames(array(
		"body" => "admin/mod_history.tpl")
	);

	// Build the select options for the 'Filter By File' field.
	// First get distinct file names from DB, they include path relative to phpBB directory.
	// ...we will later build the $distinct_files array based on the basename of files.
	$sql = 'SELECT DISTINCT mod_processed_file FROM ' . EASYMOD_PROCESSED_FILES_TABLE;
	if( !($result = $db->sql_query($sql)) )
	{
	   message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
	}
	$distinct_rows = $db->sql_fetchrowset($result);
	$distinct_count = count($distinct_rows);

	$distinct_files = array();
	for( $i = 0; $i < $distinct_count; $i++ )
	{
		$basename = basename($distinct_rows[$i]['mod_processed_file']);
		if( !in_array($basename, $distinct_files) )
		{
			$distinct_files[] = $basename;
		}
	}
	sort($distinct_files);
	$filter_select_options = '' . htmlspecialchars($lang['EM_All_mods']) . '';
	for( $i = 0; $i < count($distinct_files); $i++ )
	{
		$selected = $distinct_files[$i] == $filter_option ? ' selected="selected"' : '';
		$filter_select_options .= '' . htmlspecialchars($distinct_files[$i]) . '';
	}

	// Build the list of mod_ids matching the selected processed file
	if( !empty($filter_option) )
	{
		$sql = "SELECT mod_id FROM " . EASYMOD_PROCESSED_FILES_TABLE . "
			WHERE mod_processed_file LIKE '%" . str_replace("'", "''", $filter_option) . "%'
			ORDER BY mod_id";

		if( !($result = $db->sql_query($sql)) )
		{
		   message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
		}

		$mod_id_list = array();
		while( $row = $db->sql_fetchrow($result) )
		{
			$mod_id_list[] = $row['mod_id'];
		}
		if( count($mod_id_list) <= 0 )
		{
			$mod_id_list[] = -1;
		}
		$filter_by_mod_id_list = 'WHERE mod_id IN (' . implode(',', $mod_id_list) . ')';
		$history_status = $lang['EM_Filtered'];
	}
	else
	{
		$filter_by_mod_id_list = '';
		$history_status = $lang['EM_Unfiltered'];
	}

	// finally, get the list of matching MODs
	$sql = "SELECT *
		FROM " . EASYMOD_TABLE . "
		$filter_by_mod_id_list
		ORDER BY mod_id DESC";
	if( !$result = $db->sql_query($sql) )
	{
	   message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
	}

	$total_mods = 0;
	while( $row = $db->sql_fetchrow($result) )
	{
		$row_class = ( !($total_mods % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
		$template->assign_block_vars('install', array(
			'ROW_CLASS' => $row_class,
			'INSTALL_DATE' => create_date($board_config['default_dateformat'], $row['mod_process_date'], $board_config['board_timezone']),
			'TITLE' => $row['mod_title'],
			'VERSION' => $row['mod_version'],
			'AUTHOR' => $row['mod_author_handle'],
			'URL' => $row['mod_author_url'],
			'PHPBB_VER' => $row['mod_phpBB_version'],

			'S_ACTION' => append_sid('admin_easymod.' . $phpEx),
			'S_HIDDEN_FIELDS' => '',

/////////////////
///////////////// blah, what about schema name?
/////////////////
			'THEMES' => $row['mod_processed_themes'],
			'LANGS' => $row['mod_processed_langs'])
		);
		$total_mods++;
	}
	if ( $total_mods == 0 )
	{
		$template->assign_block_vars('no_install', array());
	}

	$template->assign_vars(array(
		'L_INSTALLED' => $lang['EM_Installed'],
		'L_INSTALLED_DESC' => $lang['EM_installed_desc'],
		'L_INSTALL_DATE' => $lang['EM_install_date'],
		'L_MOD_NAME' => $lang['EM_Mod'],
		'L_FILE' => $lang['EM_File'],
		'L_VERSION' => $lang['EM_Version'],
		'L_AUTHOR' => $lang['EM_Author'],
		'L_DESCRIPTION' => $lang['EM_Description'],
		'L_DATE' => $lang['EM_Process_Date'],
		'L_PHPBB_VER' => $lang['EM_phpBB_version'],
		'L_THEMES' => $lang['EM_Themes'],
		'L_LANGUAGES' => $lang['EM_Languages'],
		'L_NONE_INSTALLED' => ( empty($filter_by_mod_id_list) ? $lang['EM_none_installed'] : $lang['EM_none_found'] ),
		'S_DETAILS' => $lang['EM_details'],
		'L_FILTER' => $lang['EM_Filter'],
		'L_FILTER_BY_FILE' => $lang['EM_Filter_by_file'],
		'S_FILTER_OPTIONS' => $filter_select_options,
		'L_HISTORY_STATUS' => $history_status,
		'L_TOTAL_MODS' => $lang['EM_Total_mods'],
		'S_TOTAL_MODS' => $total_mods,
		'S_HIDDEN_FIELDS' => '',
		'S_ACTION' => append_sid('admin_easymod.' . $phpEx))
	);
}

//
// history details
//
else if ( $mode == 'history_details' || (isset($HTTP_POST_VARS['cancel']) && in_array($mode, array('post_process', 'del_files', 'del_record', 'restore_backups', 'install_lang', 'install_themes', 'uninstall'))) )
{
	// get the mod id
	if ( isset($HTTP_POST_VARS['mod_id']) )
	{
		$mod_id = intval($HTTP_POST_VARS['mod_id']);
	}
	else
	{
		message_die(GENERAL_ERROR, $lang['EM_No_mod_selected']);
	}

	// load the template
	$template->set_filenames(array(
		"body" => "admin/mod_history_details.tpl")
	);

	$template->assign_vars(array(
		'L_MOD_DATA' => $lang['EM_Mod_Data'],
		'L_MOD_TITLE' => $lang['EM_Mod_Title'],
		'L_MOD_DESCRIPTION' => $lang['EM_Description'],
		'L_AUTHOR' => $lang['EM_Author'],
		'L_INSTALL_DATE' => $lang['EM_install_date'],
		'L_PHPBB_VER' => $lang['EM_phpBB_version'],
		'L_THEMES' => $lang['EM_Proc_Themes'],
		'L_LANGUAGES' => $lang['EM_Proc_Languages'],
		'L_FILES' => $lang['EM_Files'],
		'L_DB_ALTS' => $lang['EM_db_alt'],
		'L_ADDED' => $lang['EM_tables_added'],
		'L_ALTERED' => $lang['EM_tables_altered'],
		'L_INSERTED' => $lang['EM_rows_added'],
		
		'L_BACK_TO_HISTORY' => $lang['EM_back_to_history'],
		'L_DELETE_FILES' => $lang['EM_del_files'],
		'L_DELETE_RECORD' => $lang['EN_del_record'],
		'L_INSTALL_LANG' => $lang['EM_install_new_lang'],
		'L_INSTALL_THEMES' => $lang['EM_install_new_themes'],
		'L_RESTORE_BACKUPS' => $lang['EM_restore_backups'],
		'L_UNISTALL' => $lang['EM_uninstall'],
		'L_GO' => $lang['Go'],
			
		'S_ACTION' => append_sid('admin_easymod.' . $phpEx),
		'S_HIDDEN_FIELDS' => '')
	);

	$sql = "SELECT * FROM " . EASYMOD_TABLE . "
		WHERE mod_id = $mod_id
		LIMIT 0, 1";

	if( !$result = $db->sql_query($sql) )
	{
	   message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
	}

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

	// file
	$file = explode('/', $row['mod_file']);

	if ( file_exists('./mods/' . $row['mod_file']) )
	{
		$temp_url = $phpbb_root_path . 'admin/mods/' . $row['mod_file'];
		$mod_file = '' . htmlspecialchars($file[1]) . '';

		// Let's hide coming soon features until fully implemented
		//$template->assign_block_vars('switch_install_file', array());
	}
	else
	{
		$mod_file = $file[1];
	}

	// see what files are there so we can work with them
	if ( file_exists('./mods/' . $file[0] . '/processed/') || file_exists('./mods/' . $file[0]. '/backups/') )
	{
		// Let's hide coming soon features until fully implemented
		//$template->assign_block_vars('switch_files', array());
	}
	// see if backups are there so we can give them the option to restore them
	if ( file_exists('./mods/' . $file[0]. '/backups/') )
	{
		$template->assign_block_vars('switch_backups', array());
	}

	// build the list of processed files for the current MOD
	$sql = "SELECT mod_processed_file FROM " . EASYMOD_PROCESSED_FILES_TABLE . "
		WHERE mod_id = $mod_id
		ORDER BY mod_processed_file";
	if( !($result = $db->sql_query($sql)) )
	{
	   message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
	}
	$epf_rows = $db->sql_fetchrowset($result);
	$epf_count = count($epf_rows);
	$epf_list = '';
	for( $i = 0; $i < $epf_count; $i++ )
	{
		$epf_list .= '
' . htmlspecialchars($epf_rows[$i]['mod_processed_file']);
	}

	$template->assign_vars(array(
		'TITLE' => $row['mod_title'],
		'VERSION' => $row['mod_version'],
		'MOD_FILE' => $mod_file,
		'DESCRIPTION' => $row['mod_description'],
		'AUTHOR' => $row['mod_author_handle'],
		'EMAIL' => $row['mod_author_email'],
		'REAL_NAME' => $row['mod_author_name'],
		'URL' => $row['mod_author_url'],
		'DATE' => create_date($board_config['default_dateformat'], $row['mod_process_date'], $board_config['board_timezone']),
		'PHPBB_VERSION' => $row['mod_phpBB_version'],
		'THEMES' => $row['mod_processed_themes'],
		'LANGUAGES' => $row['mod_processed_langs'],
		'FILES' => $row['mod_files_edited'],
		'FILE_LIST' => $epf_list,
		'ADDED' => $row['mod_tables_added'],
		'ALTERED' => $row['mod_tables_altered'],
		'INSERTED' => $row['mod_rows_inserted'])
	);

}

//
// delete MOD files
//
else if ( $mode == 'del_files' )
{
	// display which folders to delete, either
	// processed, backups, or the complete folder
	message_die(GENERAL_MESSAGE, $lang['Coming_soon']);

}

//
// delete MOD record
//
else if ( $mode == 'del_record' )
{
	// display confirm and delete sql entry

	// get the mod id
	if ( isset($HTTP_POST_VARS['mod_id']) )
	{
		$mod_id = intval($HTTP_POST_VARS['mod_id']);
	}
	else
	{
		message_die(GENERAL_ERROR, $lang['EM_No_mod_selected']);
	}

	// Should we display the confirm box?
	if( !isset($HTTP_POST_VARS['confirm']) )
	{
		$s_hidden_fields = ''.
							''.
							'';
		$template->set_filenames(array(
			'body' => 'confirm_body.tpl')
		);
		$template->assign_vars(array(
			'L_INDEX'			=> '',	// Not really necessary here
			'MESSAGE_TITLE'		=> $lang['EN_del_record'],
			'MESSAGE_TEXT'		=> $lang['EM_are_you_sure'],
			'L_YES'				=> $lang['Yes'],
			'L_NO'				=> $lang['No'],
			'S_CONFIRM_ACTION'	=> append_sid('admin_easymod.' . $phpEx),
			'S_HIDDEN_FIELDS'	=> $s_hidden_fields)
		);
	}
	else
	{
		// ok, let's do it!
		$sql = "SELECT * FROM " . EASYMOD_TABLE . "
			WHERE mod_id = $mod_id";
		if( !($result = $db->sql_query($sql)) || !($row = $db->sql_fetchrow($result)) )
		{
			message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
		}
		$mod_file = $phpbb_root_path . 'admin/mods/' . $row['mod_file'];
		$mod_folder = dirname($mod_file).'/';

		$sql = "DELETE FROM " . EASYMOD_TABLE . "
			WHERE mod_id = $mod_id";
		if( !$db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, $lang['EM_err_delete_em_info'], '', __LINE__, __FILE__, $sql);
		}

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

';
		if( @file_exists($mod_file) )
		{
			$message .= '
' . $lang['EM_warning_deldir'] . '

' . htmlspecialchars($mod_folder) . '


';
		}
		$message .= '';
		$message .= '';
		$message .= '
';
		message_die(GENERAL_MESSAGE, $message);
	}

}

//
// Restore Backups
//
else if ( $mode == 'restore_backups' && !isset($HTTP_POST_VARS['confirm']) )
{
	// display confirm and move the backups into place

	// get the mod id
	if ( isset($HTTP_POST_VARS['mod_id']) )
	{
		$mod_id = intval($HTTP_POST_VARS['mod_id']);
	}
	else
	{
		message_die(GENERAL_ERROR, $lang['EM_No_mod_selected']);
	}

	// Read MOD information from DB...
	$sql = "SELECT * FROM " . EASYMOD_TABLE . "
		WHERE mod_id = $mod_id";
	if( !($result = $db->sql_query($sql)) || !($mod_row = $db->sql_fetchrow($result)) )
	{
		message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
	}
	$sql = "SELECT mod_processed_file FROM " . EASYMOD_PROCESSED_FILES_TABLE . "
		WHERE mod_id = $mod_id
		ORDER BY mod_processed_file";
	if( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, $lang['EM_err_em_info'], '', __LINE__, __FILE__, $sql);
	}
	$epf_rows = $db->sql_fetchrowset($result);
	$epf_count = count($epf_rows);

	// build the command array for the restore backups job
	$mod_file = './mods/' . $mod_row['mod_file'];
	$mod_folder = dirname($mod_file).'/';
	$command_ary = array();
	for( $i = 0; $i < $epf_count; $i++ )
	{
		$mod_processed_file = $epf_rows[$i]['mod_processed_file'];
		$command_ary[] = array('backups/' . $mod_processed_file . '.txt', '../../../' . $mod_processed_file);
	}

	if( ($num_command_steps = count($command_ary)) <= 0 )
	{
		message_die(GENERAL_ERROR, $lang['EM_err_no_step']);
	}

	// ok, let's build the NEW post_process stuff, then display the confirm dialog box!
	$mode = 'post_process';

	$hidden_vars_ary = array(
		'mod_id'			=> $mod_id,
		'password'			=> htmlspecialchars($password),
		'mode'				=> $mode,
		'install_path'		=> dirname($mod_file).'/',
		'install_file'		=> basename($mod_file),
		'themes'			=> $mod_row['mod_processed_themes'],
		'languages'			=> $mod_row['mod_processed_langs'],
		'files'				=> $mod_row['mod_files_edited'],
		'num_proc'			=> $mod_row['mod_files_edited'],
		'num_unproc'		=> 0
	);

	$s_hidden_fields = '';
	for( $i=0; $i < $num_command_steps; $i++ )
	{
		$command_line = 'copy ' . $command_ary[$i][0] . ' ' . $command_ary[$i][1];
		$s_hidden_fields .= '\n";
	}
	$s_hidden_fields .= '\n";

	foreach( $hidden_vars_ary as $key => $val )
	{
		$s_hidden_fields .= '\n";
	}

	$template->set_filenames(array(
		'body' => 'confirm_body.tpl')
	);

	$message = '' . $lang['EM_restore_backups'] . ":

\n";
	for( $i=0; $i < $num_command_steps; $i++ )
	{
		$from = $mod_folder.$command_ary[$i][0];
		$to = ((substr($command_ary[$i][1], 0, 9) == '../../../') ? substr($command_ary[$i][1], 9) : $command_ary[$i][1]);
		$message .= 'COPY ' . htmlspecialchars($from) . ' TO ' . htmlspecialchars($to) . "
\n";
	}
	$message .= '

' . $lang['EM_are_you_sure'];

	$template->assign_vars(array(
		'L_INDEX'			=> '',	// Not really necessary here
		'MESSAGE_TITLE'		=> $lang['EM_restore_backups'],
		'MESSAGE_TEXT'		=> $message,
		'L_YES'				=> $lang['Yes'],
		'L_NO'				=> $lang['No'],
		'S_CONFIRM_ACTION'	=> append_sid('admin_easymod.' . $phpEx),
		'S_HIDDEN_FIELDS'	=> $s_hidden_fields)
	);

}

//
// Install MOD on new Languages
//
else if ( $mode == 'install_lang' )
{
	// list which languages so user can choose and go through install process
	message_die(GENERAL_ERROR, $lang['Coming_soon']);

}

//
// Install MOD on new themes
//
else if ( $mode == 'install_themes' )
{
	// list which themes so user can choose and go through install process
	message_die(GENERAL_ERROR, $lang['Coming_soon']);

}

//
// uninstall the mod
//
else if ( $mode == 'uninstall' )
{
	message_die(GENERAL_MESSAGE, $lang['Coming_soon']);
}

//
// display install MOD page
//
else if ( $mode == 'install')
{
	// load the install page template
	$template->set_filenames(array(
		'body' => 'admin/mod_install.tpl')
	);

	$template->assign_vars(array(
		'L_EM_INTRO' => $lang['EM_Intro'],

		'L_UNPROCESSED' => $lang['EM_Unprocessed'],
		'L_UNPROCESSED_DESC' => sprintf($lang['EM_unprocessed_mods'], HOW_TO_INSTALL_MODS_URL),

		'L_MOD' => $lang['EM_Mod'],
		'L_AUTHOR' => $lang['EM_Author'],
		'L_SUPPORT' => $lang['EM_support_thread'],
		'L_DESCRIPTION' => $lang['EM_Description'],
		'L_EMC' => $lang['EM_EMC'],
		'L_PROCESS' => $lang['EM_process'],
		'L_PREVIEW' => $lang['EM_preview'],
		'L_ALL_PROCESSED' => $lang['EM_All_Processed'],

		'S_ACTION' => append_sid('admin_easymod.' . $phpEx),
		'EM_PASS' => htmlspecialchars($password))
	);



	$phpbb_version = get_phpbb_version();
	if ($phpbb_version == '')
	{
		message_die(GENERAL_ERROR, $lang['EM_err_phpbb_ver']);
	}

	// parse the "mods" directory, looking for newly extracted mods, or mod updates
	$top_handle = opendir('./mods');
	$i = 0;
	while (false !== ($dir = readdir($top_handle)))
	{
		// only want the subdirectories (but not . and ..)
		if ( (is_dir('./mods/' . $dir) ) && ($dir != '.') && ($dir != '..'))
		{
			$path = './mods/' . $dir;
			$dir_handle = opendir($path);
			// loop through the subdirs, looking for mod files
			while (false !== ($file = readdir($dir_handle)))
			{
				$file_path =  $path . '/' . $file;
				// make sure it is not a dir, and that it ends with .txt or .mod
				if ( !is_dir( $file_path) && ( (eregi(".txt$", $file_path)) || (eregi(".mod$", $file_path))))
				{
					$mod_title = '';
					$mod_author_handle = '';
					$mod_author_email = '';
					$mod_author_name = '';
					$mod_author_url = '';
					$mod_description = '';
					$mod_version = '';
					$compliant = false;

					$is_mod = get_mod_properties($file_path, $mod_title, $mod_author_handle, $mod_author_email, $mod_author_name, $mod_author_url, $mod_description, $mod_version, $compliant);

					// if it is a MOD and has not been processed yet then add it to the list
					if (($is_mod) && ( is_unprocessed( $db, $mod_title, $mod_version, $phpbb_version)))
					{
						$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
						$template->assign_block_vars('unprocessed', array(
							'ROW_CLASS' => $row_class,
							'MOD_TITLE' => $mod_title,
							'MOD_AUTHOR' => $mod_author_handle,
							'MOD_URL' => $mod_author_url,
							'MOD_VERSION' => $mod_version,
							'MOD_DESC' => $mod_description,
							'MOD_EMC' => ($compliant) ? '' : $lang['No'],
							'MOD_PATH' => $path . '/',
							'MOD_FILE' => $file,
							'MOD_FILE_URL' => $path . '/' . $file)
						);
						$i++;
					}
				}
			}
		}
	}

	// didn't find any MODs we can process
	if ( $i == 0 )
	{
		$template->assign_block_vars('no_unprocessed', array());
	}
}


//
// preview the changes EM will be making to files
//
else if ($preview)
{
	$files = array();
	check_file_scope($install_path . $install_file, $phpbb_root_path . $script_path);
	$f_mod_script = fopen($install_path . $install_file, 'r');
	while (!feof($f_mod_script))
	{
		$buffer = fgets($f_mod_script, 4096);

		// if the line starts with #, this is either a comment or an action command

		// after obtaining the command, skip any comments until we reach the command body
		if (($buffer[0] == '#') && ($in_header))
		{
			// do nothing until we are out of the command header!!
		}

		// not in a header so this comment is either a random comment or start of a command header
		else if ($buffer[0] == '#')
		{
			// if we find [ and ] and OPEN on this line, then we can be reasonably sure we've got an OPEN command
			if ((strstr($buffer, '[')) && (strstr($buffer, ']')) && (strstr($buffer, 'OPEN')))
			{
				// get us past any remaining # lines
				$buffer = fgets($f_mod_script, 4096);
				while ($buffer[0] == '#')
				{
					if ( feof($f_mod_script))
					{
						break;
					}
					$buffer = fgets($f_mod_script, 4096);
				}

				// loop until we get a filename (a non-whitespace line) or the next # line
				while (!feof($f_mod_script))
				{
					// got a line with some text not starting with #, so we're calling this a filename ;)
					if ((strlen(trim($buffer)) > 0) && ($buffer[0] != '#'))
					{
						$files[] = trim($buffer);
						break;
					}

					// we found a # so get us out of here
					else if ($buffer[0] == '#')
					{
						break;
					}

					$buffer = fgets($f_mod_script, 4096);
				}

				// if we hit eof, then get us out of here
				if (feof($f_mod_script))
				{
					break;
				}
			}
		}

		// not a comment or command so this is the body of the command
		else
		{
			$in_header = false;
		}
	}
	fclose($f_mod_script);


	// Show the preview page
	$template->set_filenames(array(
		'body' => 'admin/mod_preview.tpl')
	);

	$template->assign_vars(array(
		'L_HEADER' => $lang['EM_preview_mode'],
		'L_PREVIEW_DESC' => $lang['EM_preview_desc'],
		'L_FILENAME' => $lang['EM_preview_filename'],
		'L_VIEW' => $lang['EM_preview_view'])
	);


	// load in the filename and link info
	for ($i=0; $iassign_block_vars('files', array(
			'NAME' => $files[$i],
			'URL' => $link)
		);
	}

	// if there are no files to be modified, then display the message
	if ( count($files) == 0)
	{
		$template->assign_block_vars('nofiles', array(
			'L_NO_FILES' => $lang['EM_preview_nofile'])
		);
	}
}


//
// download or display a backup of the core phpBB file
//
else if (($mode == 'display_backup') || ($mode == 'download_backup'))
{
	// open the core file
	check_file_scope($process_file, $phpbb_root_path . $script_path, true);
	if (!$read_file = fopen($process_file, 'r'))
	{
		// gotta echo out the message since message_die is not an option
		echo sprintf( $lang['EM_err_backup_open'], $process_file) . "\n";
		exit;
	}

	// write out the lines
	while (!feof($read_file))
	{
		$newline = fgets($read_file, 4096);
		if ($mode == 'download_backup')
		{
			echo $newline;
		}
		else
		{
			echo htmlspecialchars($newline);
		}
	}
	fclose($read_file);

	// finish the PRE formatting tag
	if ($mode == 'display_backup')
	{
		echo "

' . htmlspecialchars(substr($file_list[$file]->afile[$i], 4));
						}

						// special case: the very last line of the file, end the bolding
						else if ($i == ($preview_count-1))
						{
							echo htmlspecialchars(substr($file_list[$file]->afile[$i], 4));
						}

						// a middle line of the preview display, just print the line
						else
						{
							echo htmlspecialchars(substr($file_list[$file]->afile[$i], 4));
						}

						$preview_display = true;
					}

					// first line following a preview display line, end the bolding and then carry on
					else if ($preview_display)
					{
						echo '

' . htmlspecialchars($file_list[$file]->afile[$i]);
						$preview_display = false;
					}

					// normal line
					else
					{
						echo htmlspecialchars($file_list[$file]->afile[$i]);
					}
				}
			}

			// finish the html tag
			if ($mode == 'display_file')
			{
				echo "