*/

function purge()

{

$dir = opendir($this->cache_dir);

while (($entry = readdir($dir)) !== false)

{

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

$db->sql_freeresult($result);

// Create a temp table and populate it, destroy the existing one

$db->sql_query(preg_replace('#CREATE\s+TABLE\s+"?' . PROFILE_FIELDS_DATA_TABLE . '"?#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));

$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . '_temp SELECT * FROM ' . PROFILE_FIELDS_DATA_TABLE);

preg_match('#\((.*)\)#s', $row['sql'], $matches);

$new_table_cols = trim($matches[1]);

$column_list = array();

foreach ($old_table_cols as $declaration)

{

$entities = preg_split('#\s+#', trim($declaration));

$db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');

$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');

$db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');

break;

default:

*

* @param string $label1 the cvs file version/label from the original set of lines

* @param string $label2 the cvs file version/label from the new set of lines

* @param bool $get_conflicts if set to true only the number of conflicts is returned

* @param bool $merge_new if set to true the merged output will have the new file contents on a conflicting merge

*

* @return mixed the merged output

*/

{

global $user;

$label1 = (!empty($user->lang[$label1])) ? $user->lang[$label1] : $label1;

$label2 = (!empty($user->lang[$label2])) ? $user->lang[$label2] : $label2;

$lines = array();

{

if (!$merge_new)

{

}

else

{

'S_USER_PM_POPUP' => $user->optionget('popuppm'),

'S_USER_LANG' => $user->data['user_lang'],

'S_USER_BROWSER' => (isset($user->data['session_browser'])) ? $user->data['session_browser'] : $user->lang['UNKNOWN_BROWSER'],

'S_CONTENT_DIRECTION' => $user->lang['DIRECTION'],

'S_CONTENT_ENCODING' => $user->lang['ENCODING'],

'S_CONTENT_DIR_LEFT' => $user->lang['LEFT'],

$forum_ids[] = $row['forum_id'];

$topic_ids[] = $row['topic_id'];

}

$return['topics'] = sizeof($topic_ids);

trigger_error('NO_SUCH_SEARCH_MODULE');

}

$error = false;

$search = new $search_type($error);

{

$topic_ids[] = $row['topic_id'];

}

if (!sizeof($topic_ids))

{

foreach ($fieldnames as $fieldname)

{

{

$sql_ary['topic_' . $fieldname] = $row[$fieldname];

}

return 'GROUP_USERS_EXIST';

}

if (sizeof($add_id_ary))

{

// Insert the new users

case 'mysql':

case 'mysql4':

case 'mysqli':

case 'sqlite':

$sql = 'INSERT INTO ' . USER_GROUP_TABLE . " (user_id, group_id, group_leader, user_pending)

VALUES " . implode(', ', preg_replace('#^([0-9]+)$#', "(\\1, $group_id, $leader, $pending)", $add_id_ary));

group_set_user_default($group_id, $user_id_ary, $group_attributes);

}

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

{

$cache->destroy('_search_results_' . $row['search_key']);

}

}

// clear all searches that searched for the specified authors

{

$cache->destroy('_search_results_' . $row['search_key']);

}

}

$sql = 'DELETE

}

define('HEADER_INC', true);

$template->assign_vars(array(

'L_CHANGE' => $lang['CHANGE'],

'L_INSTALL_PANEL' => $lang['INSTALL_PANEL'],

'L_SELECT_LANG' => $lang['SELECT_LANG'],

'PAGE_TITLE' => $this->get_page_title(),

'S_CONTENT_DIRECTION' => $lang['DIRECTION'],

'S_CONTENT_ENCODING' => $lang['ENCODING'],

if (!empty($setmodules))

{

/* If phpBB is already installed we do not include this module

{

include_once($phpbb_root_path . 'config.' . $phpEx);

'CHECK_FILES' => 'Check files',

'CHECK_FILES_AGAIN' => 'Check files again',

'CHECK_FILES_UP_TO_DATE' => 'According to your database your version is up to date. You may want to proceed with the file check to make sure all files are really up to date with the latest phpBB version.',

'COLLECTED_INFORMATIONS' => 'Collected file informations',

'COLLECTED_INFORMATIONS_EXPLAIN'=> 'The list below shows informations about the files needing an update. Please read the information in front of every status block to see what they mean and what you may need to do to perform a successful update.',

'CURRENT_FILE' => 'Current original file',

'CURRENT_VERSION' => 'Current version',

'DESTINATION' => 'Destination file',

'DIFF_INLINE' => 'Inline',

'DIFF_RAW' => 'Raw unified diff',

'DIFF_SIDE_BY_SIDE' => 'Side by Side',

'DIFF_UNIFIED' => 'Unified diff',

'DOWNLOAD' => 'Download',

'DOWNLOAD_AS' => 'Download as',

'DOWNLOAD_UPDATE_METHOD' => 'Download modified files archive',

'DOWNLOAD_UPDATE_METHOD_EXPLAIN' => 'Once downloaded you should unpack the archive. You will find the modified files you need to upload to your phpBB root directory within it. Please upload the files to their respective locations then. After you have uploaded all files, please check the files again with the other button below.',

'FILE_ALREADY_UP_TO_DATE' => 'File is already up to date',

'FILES_CONFLICT' => 'Conflict files',

'FILES_CONFLICT_EXPLAIN' => 'The following files are modified and do not represent the original files from the old version. phpBB determined that these files create conflicts if they are tried to be merged. Please investigate the conflicts and try to manually resolve them or continue the update choosing the preferred merging method. If you resolve the conflicts manually check the files again after you modified the them. You are also able to choose between the preferred merge method for every file. The first one will result in a file where the conflicting lines from your old file will be lost, the other one will result in loosing the changes from the newer file.',

'FILES_MODIFIED' => 'Modified files',

'NEW_FILE' => 'New updated file',

'NO_AUTH_UPDATE' => 'Not authorized to update',

'NO_UPDATE_FILES_OUTDATED' => 'No valid update directory was found, please make sure you uploaded the relevant files.<br /><br />Your installation does <strong>not</strong> seem to be up to date. Updates are available for your version of phpBB %1$s, please visit <a href="http://www.phpbb.com/downloads.php" rel="external">http://www.phpbb.com/downloads.php</a> to obtain the correct package to update from Version %2$s to Version %3$s.',

'NO_UPDATE_FILES_UP_TO_DATE' => 'Your version is up to date. There is no need to run the update tool. If you want to make an integrity check on your files make sure you uploaded the correct update files.',

'NO_UPDATE_INFO' => 'Update file informations could not be found.',

'NO_VISIBLE_CHANGES' => 'No visible changes',

'NOTICE' => 'Notice',

'NUM_CONFLICTS' => 'Number of conflicts',

'SELECT_DIFF_MODE' => 'Select diff mode',

'SELECT_DOWNLOAD_FORMAT' => 'Select download archive format',

'SELECT_FTP_SETTINGS' => 'Select FTP Settings',

'STAGE_FILE_CHECK' => 'Check files',

'STAGE_UPDATE_DB' => 'Update database',

'STAGE_UPDATE_FILES' => 'Update files',

'STATUS_NOT_MODIFIED' => 'Not modified file',

'STATUS_UP_TO_DATE' => 'Already updated file',

'UPDATE_DATABASE' => 'Update database',

'UPDATE_FILES' => 'Update files',

'UPDATE_INSTALLATION' => 'Update phpBB Installation',

'UPDATE_INSTALLATION_EXPLAIN' => 'With this option, it is possible to update your phpBB installation to the latest version.<br />During the process all of your files will be checked for their integrity. You are able to review all differences and files before the update.<br /><br />The file update itself can be done in two different ways.</p><h2>Manual Update</h2><p>With this update you only download your personal set of changed files to make sure you do not loose your file modifications you may have done. After you downloaded this package you need to manually upload the files to their correct position under your phpBB root directory. Once done, you are able to do the file check stage again to see if you moved the files to their correct location. If everything is correctly updated you will be forwarded to the database updater.</p><h2>Automatic Update with FTP</h2><p>This method is similar to the first one but without the need to download the changed files and uploading them on your own. This will be done for you. In order to use this method you need to know your FTP login details since you will be asked for them. Once finished you will be redirected to the file check again to make sure everything got updated correctly. If so, you will be forwarded to the database updater.',

'UPDATE_METHOD' => 'Update method',

'UPDATE_METHOD_EXPLAIN' => 'You are now able to choose your preferred update method. Using the FTP Upload will present you with a form you need to enter your FTP account details into. With this method the files will be automatically moved to the new location and backups of the old files being created by appending .bak to the filename. If you choose to download the modified files you are able to unpack and upload them to their correct location manually later.',

'UPDATE_SUCCESS' => 'Update was successful',

'UPDATE_SUCCESS_EXPLAIN' => 'Successfully updated all files. The next step involves checking all files again to make sure the files got updated correctly.',

'UPLOAD_METHOD' => 'Upload method',

'VERSION_CHECK' => 'Version Check',

'VERSION_CHECK_EXPLAIN' => 'Checks to see if the version of phpBB you are currently running is up to date.',

'VERSION_NOT_UP_TO_DATE' => 'Your version of phpBB is not up to date. Please continue the update process.',

'VERSION_UP_TO_DATE' => 'Your installation is up to date, no updates are available for your version of phpBB. You may want to continue anyway to perform a file validity check.',

'VIEWING_FILE_CONTENTS' => 'Viewing file contents',

'VIEWING_FILE_DIFF' => 'Viewing file differences',

));

?> \ No newline at end of file