-<?php

-/**

-*

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-*/

-if (!empty($setmodules))

-{

- $filename = basename(__FILE__);

- $module['DB']['DB_BACKUP'] = ($auth->acl_get('a_backup')) ? $filename . "$SID&amp;mode=backup" : '';

-

- $file_uploads = @ini_get('file_uploads');

- if (!empty($file_uploads) && $file_uploads !== 0 && strtolower($file_uploads) != 'off' && $auth->acl_get('a_restore'))

- {

- $module['DB']['DB_RESTORE'] = "$filename$SID&amp;mode=restore";

- }

-

- return;

-}

-

-define('IN_PHPBB', 1);

-// Load default header

-$phpbb_root_path = '../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

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

-include($phpbb_root_path . 'includes/functions_compress.'.$phpEx);

-

-@set_time_limit(1200);

-

-

-// Get some vars

-$mode = (isset($_GET['mode'])) ? htmlspecialchars($_GET['mode']) : '';

-$action = (isset($_REQUEST['action'])) ? htmlspecialchars($_REQUEST['action']) : '';

-

-

-// --------------------

-// Begin program proper

-// --------------------

-switch($mode)

-{

- case 'backup':

- if (!$auth->acl_get('a_backup'))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

-

- $db_type = '';

- switch (SQL_LAYER)

- {

- case 'oracle':

- $db_type = 'Oracle';

- break;

- case 'odbc':

- $db_type = 'ODBC';

- break;

- case 'mssql':

- $db_type = 'MSSQL';

- break;

- }

-

- if ($db_type)

- {

- trigger_error($user->lang['Backups_not_supported']);

- }

-

- $additional_tables = (isset($_REQUEST['tables'])) ? htmlspecialchars($_REQUEST['tables']) : '';

- $backup_type = (isset($_REQUEST['type'])) ? intval($_REQUEST['type']) : false;

- $search = (!empty($_REQUEST['search'])) ? true : false;

- $store = (!empty($_REQUEST['store'])) ? true : false;

- $compress = (isset($_REQUEST['compress'])) ? htmlspecialchars($_REQUEST['compress']) : '';

-

- if (!isset($_POST['backupstart']) && !isset($_GET['backupstart']))

- {

- adm_page_header($user->lang['DB_BACKUP']);

-

-?>

-

-<h1><?php echo $user->lang['DB_BACKUP']; ?></h1>

-

-<p><?php echo $user->lang['Backup_explain']; ?></p>

-

-<form method="post" action="<?php echo "admin_database.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="2"><?php echo $user->lang['Backup_options']; ?></th>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['Backup_type']; ?>: </b></td>

- <td class="row2"><input type="radio" name="type" value="full" checked="checked" /> <?php echo $user->lang['Full_backup']; ?>&nbsp;&nbsp;<input type="radio" name="type" value="structure" /> <?php echo $user->lang['Structure_only']; ?>&nbsp;&nbsp;<input type="radio" name="type" value="data" /> <?php echo $user->lang['Data_only']; ?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['Additional_tables']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['Additional_tables_explain']; ?></span></td>

- <td class="row2"><input class="post" type="text" name="tables" maxlength="255" size="40" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['INC_SEARCH_INDEX']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['INC_SEARCH_INDEX_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="radio" name="search" value="1" checked="checked" /> <?php echo $user->lang['YES']; ?>&nbsp;&nbsp;<input type="radio" name="search" value="0" /> <?php echo $user->lang['NO']; ?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['DOWNLOAD_STORE']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['DOWNLOAD_STORE_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="radio" name="store" value="0" checked="checked" /> <?php echo $user->lang['EXPORT_DOWNLOAD']; ?>&nbsp;&nbsp;<input type="radio" name="store" value="1" /> <?php echo $user->lang['EXPORT_STORE']; ?></td>

- </tr>

-<?php

-

- if (@extension_loaded('zlib') || extension_loaded('bz2'))

- {

-

-?>

- <tr>

- <td class="row1"><b><?php echo $user->lang['Compress_file']; ?>: </b></td>

- <td class="row2"><input type="radio" name="compress" value="none" checked="checked" /> <?php echo $user->lang['NONE']; ?><?php

-

- if (extension_loaded('zlib'))

- {

-

-

-?>&nbsp;&nbsp;<input type="radio" name="compress" value="gzip" />.gz&nbsp;&nbsp;<input type="radio" name="compress" value="zip" />.zip<?php

-

- }

-

- if (extension_loaded('bz2'))

- {

-

-?>&nbsp;&nbsp;<input type="radio" name="compress" value="bzip" />.bz2<?php

-

- }

-

-?></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="cat" colspan="2" align="center"><input type="submit" name="backupstart" value="<?php echo $user->lang['Start_backup']; ?>" class="btnmain" /></td>

- </tr>

-</table></form>

-

-<?php

-

- break;

- }

- else if (!isset($_POST['startdownload']) && !isset($_GET['startdownload']))

- {

- $meta = "<meta http-equiv=\"refresh\" content=\"0;url=admin_database.$phpEx?mode=backup&amp;type=$backup_type&amp;tables=" . quotemeta($additional_tables) . "&amp;search=$search&amp;store=" . quotemeta($store_path) . "&amp;compress=$compress&amp;backupstart=1&amp;startdownload=1\">";

-

- $message = (empty($store_path)) ? $user->lang['Backup_download'] : $user->lang['Backup_writing'];

-

- adm_page_header($user->lang['DB_Backup'], $meta);

- page_message($user->lang['DB_Backup'], $message);

- adm_page_footer();

- }

-

- $tables = (SQL_LAYER != 'postgresql') ? mysql_get_tables() : pg_get_tables();

- @sort($tables);

-

- if (!empty($additional_tables))

- {

- $additional_tables = explode(',', $additional_tables);

-

- for($i = 0; $i < count($additional_tables); $i++)

- {

- $tables[] = trim($additional_tables[$i]);

- }

- unset($additional_tables);

- }

-

- // Enable output buffering

- @ob_start();

- @ob_implicit_flush(0);

-

- // Build the sql script file...

- echo "#\n";

- echo "# phpBB Backup Script\n";

- echo "# Dump of tables for $dbname\n";

- echo "#\n# DATE : " . gmdate("d-m-Y H:i:s", time()) . " GMT\n";

- echo "#\n";

-

- if (SQL_LAYER == 'postgresql')

- {

- echo "\n" . pg_get_sequences("\n", $backup_type);

- }

-

- for($i = 0; $i < count($tables); $i++)

- {

- $table_name = $tables[$i];

-

- if (SQL_LAYER != 'mysql4')

- {

- $table_def_function = "get_table_def_" . SQL_LAYER;

- $table_content_function = "get_table_content_" . SQL_LAYER;

- }

- else

- {

- $table_def_function = "get_table_def_mysql";

- $table_content_function = "get_table_content_mysql";

- }

-

- if ($backup_type != 'data')

- {

- echo "#\n# TABLE: " . $table_name . "\n#\n";

- echo $table_def_function($table_name, "\n") . "\n";

- }

-

- if ($backup_type != 'structure')

- {

- //

- // Skip search table data?

- //

- if ($search || (!$search && !preg_match('/search_word/', $table_name)))

- {

- $table_content_function($table_name, "output_table_content");

- }

- }

- }

-

- // Flush the buffer, send the file

- switch ($compress)

- {/*

- case 'gzip':

- $extension = 'sql.gz';

- $contents = gzencode(ob_get_contents());

- ob_end_clean();

- break;

-

- case 'zip':

- $extension = 'zip';

- $zip = new zipfile;

- $zip->add_file(ob_get_contents(), "phpbb_db_backup.sql", time());

- ob_end_clean();

- $contents = $zip->file();

- break;

-

- case 'bzip':

- $extension = 'bz2';

- $contents = bzcompress(ob_get_contents());

- ob_end_clean();

- break;*/

-

- default:

- $extension = 'sql';

- $contents = ob_get_contents();

- ob_end_clean();

- }

-

- add_log('admin', 'log_db_backup');

-

- if (empty($store_path))

- {

- header("Pragma: no-cache");

- header("Content-Type: text/x-delimtext; name=\"phpbb_db_backup.$extension\"");

- header("Content-disposition: attachment; filename=phpbb_db_backup.$extension");

-

- echo $contents;

- unset($contents);

- }

- else

- {

- if (!($fp = fopen('./../' . $store_path . "/phpbb_db_backup.$extension", 'wb')))

- {

- message_die(ERROR, 'Could not open backup file');

- }

-

- if (!fwrite($fp, $contents))

- {

- message_die(ERROR, 'Could not write backup file content');

- }

-

- fclose($fp);

- unset($contents);

-

- trigger_error($user->lang['Backup_success']);

- }

-

- exit;

- break;

-

- case 'restore':

- if (!$auth->acl_get('a_restore'))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

-

- if (isset($_POST['restorestart']))

- {

- // Handle the file upload ....

- // If no file was uploaded report an error...

- if (!empty($_POST['local']))

- {

- $file_tmpname = './../' . str_replace('\\\\', '/', $_POST['local']);

- $filename = substr($file_tmpname, strrpos($file_tmpname, '/'));

- }

- else

- {

- $filename = (!empty($_POST['backup_file']['name'])) ? $HTTP_POST_FILES['backup_file']['name'] : '';

- $file_tmpname = ($HTTP_POST_FILES['backup_file']['tmp_name'] != 'none') ? $HTTP_POST_FILES['backup_file']['tmp_name'] : '';

- }

-

- if ($file_tmpname == '' || $filename == '' || !file_exists($file_tmpname))

- {

- trigger_error($user->lang['Restore_Error_no_file']);

- }

-

- $ext = substr($filename, strrpos($filename, '.') + 1);

-

- if (!preg_match('/^(sql|gz|bz2)$/', $ext))

- {

- trigger_error($user->lang['Restore_Error_filename']);

- }

-

- if ((!extension_loaded('zlib') && $ext == 'gz') || (!extension_loaded('zip') && $ext == 'zip') || ($ext == 'bz2' && !extension_loaded('bz2')))

- {

- trigger_error($user->lang['Compress_unsupported']);

- }

-

- $sql_query = '';

- switch ($ext)

- {

- case 'gz':

- $fp = gzopen($file_tmpname, 'rb');

- while (!gzeof($fp))

- {

- $sql_query .= gzgets($fp, 100000);

- }

- gzclose($fp);

- break;

-

- case 'bz2':

- $sql_query = bzdecompress(fread(fopen($file_tmpname, 'rb'), filesize($file_tmpname)));

- break;

-

- case 'zip':

-

-

- default;

- $sql_query = fread(fopen($file_tmpname, 'r'), filesize($file_tmpname));

- }

-

- if ($sql_query != '')

- {

- // Strip out sql comments...

- remove_remarks($sql_query);

- $pieces = split_sql_file($sql_query, ';');

-

- $sql_count = count($pieces);

- for($i = 0; $i < $sql_count; $i++)

- {

- $sql = trim($pieces[$i]);

-

- if (!empty($sql) && $sql[0] != '#')

- {

- $db->sql_query($sql);

- }

- }

- }

-

- add_log('admin', 'log_db_restore');

-

- trigger_error($user->lang['Restore_success']);

- }

-

- //

- // Restore page

- //

- adm_page_header($user->lang['DB_RESTORE']);

-

-?>

-

-<h1><?php echo $user->lang['DB_RESTORE']; ?></h1>

-

-<p><?php echo $user->lang['Restore_explain']; ?></p>

-

-<form enctype="multipart/form-data" method="post" action="<?php echo "admin_database.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

- <th colspan="2"><?php echo $user->lang['Select_file']; ?></th>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['Upload_file']; ?>: <br /><span class="gensmall"><?php

-

- echo $user->lang['Supported_extensions'];

-

- $types = ': <u>sql</u>';

- if (extension_loaded('zlib'))

- {

- $types .= ', <u>sql.gz</u>';

- }

- if (extension_loaded('bz2'))

- {

- $types .= ', <u>bz2</u>';

- }

-

- echo $types;

-

-?></span></td>

- <td class="row2"><input type="file" name="backup_file" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['Local_backup_file']; ?>: <br /><span class="gensmall"><?php echo $user->lang['Local_backup_file_explain']; ?></span></td>

- <td class="row2"><input type="text" name="local" size="40" /></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input type="submit" name="restorestart" value="<?php echo $user->lang['Start_Restore']; ?>" class="btnmain" /></td>

- </tr>

-</table></form>

-

-<?php

-

- break;

-

- default:

- trigger_error($user->lang['No_admin']);

- exit;

-

-}

-

-adm_page_footer();

-

-// -----------------------------------------------

-// Begin Functions

-//

-

-//

-// Table defns (not from phpMyAdmin)

-//

-function mysql_get_tables()

-{

- global $db, $table_prefix;

-

- $tables = array();

-

- $result = mysql_list_tables($db->dbname, $db->db_connect_id);

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

- {

- do

- {

- if (preg_match('/^' . $table_prefix . '/', $row[0]))

- {

- $tables[] = $row[0];

- }

- }

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

- }

-

- return $tables;

-}

-

-//

-// The following functions are adapted from phpMyAdmin and upgrade_20.php

-//

-// This function is used for grabbing the sequences for postgres...

-//

-function pg_get_sequences($crlf, $backup_type)

-{

- global $db;

-

- $get_seq_sql = "SELECT relname FROM pg_class WHERE NOT relname ~ 'pg_.*'

- AND relkind = 'S' ORDER BY relname";

-

- $seq = $db->sql_query($get_seq_sql);

-

- if (!$num_seq = $db->sql_numrows($seq))

- {

-

- $return_val = "# No Sequences Found $crlf";

-

- }

- else

- {

- $return_val = "# Sequences $crlf";

- $i_seq = 0;

-

- while($i_seq < $num_seq)

- {

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

- $sequence = $row['relname'];

-

- $get_props_sql = "SELECT * FROM $sequence";

- $seq_props = $db->sql_query($get_props_sql);

-

- if ($db->sql_numrows($seq_props) > 0)

- {

- $row1 = $db->sql_fetchrow($seq_props);

-

- if ($backup_type == 'structure')

- {

- $row['last_value'] = 1;

- }

-

- $return_val .= "CREATE SEQUENCE $sequence start " . $row['last_value'] . ' increment ' . $row['increment_by'] . ' maxvalue ' . $row['max_value'] . ' minvalue ' . $row['min_value'] . ' cache ' . $row['cache_value'] . "; $crlf";

-

- } // End if numrows > 0

-

- if (($row['last_value'] > 1) && ($backup_type != 'structure'))

- {

- $return_val .= "SELECT NEXTVALE('$sequence'); $crlf";

- unset($row['last_value']);

- }

-

- $i_seq++;

-

- } // End while..

-

- } // End else...

-

- return $returnval;

-

-} // End function...

-

-//

-// The following functions will return the "CREATE TABLE syntax for the

-// varying DBMS's

-//

-// This function returns, will return the table def's for postgres...

-//

-function get_table_def_postgresql($table, $crlf)

-{

- global $db;

-

- $schema_create = "";

- //

- // Get a listing of the fields, with their associated types, etc.

- //

-

- $field_query = "SELECT a.attnum, a.attname AS field, t.typname as type, a.attlen AS length, a.atttypmod as lengthvar, a.attnotnull as notnull

- FROM pg_class c, pg_attribute a, pg_type t

- WHERE c.relname = '$table'

- AND a.attnum > 0

- AND a.attrelid = c.oid

- AND a.atttypid = t.oid

- ORDER BY a.attnum";

- $result = $db->sql_query($field_query);

-

- if (!$result)

- {

- message_die(GENERAL_ERROR, "Failed in get_table_def (show fields)", "", __LINE__, __FILE__, $field_query);

- } // end if..

-

- $schema_create .= "DROP TABLE $table;$crlf";

-

- //

- // Ok now we actually start building the SQL statements to restore the tables

- //

-

- $schema_create .= "CREATE TABLE $table($crlf";

-

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

- {

- //

- // Get the data from the table

- //

- $sql_get_default = "SELECT d.adsrc AS rowdefault

- FROM pg_attrdef d, pg_class c

- WHERE (c.relname = '$table')

- AND (c.oid = d.adrelid)

- AND d.adnum = " . $row['attnum'];

- $def_res = $db->sql_query($sql_get_default);

-

- if (!$def_res)

- {

- unset($row['rowdefault']);

- }

- else

- {

- $row['rowdefault'] = @pg_result($def_res, 0, 'rowdefault');

- }

-

- if ($row['type'] == 'bpchar')

- {

- // Internally stored as bpchar, but isn't accepted in a CREATE TABLE statement.

- $row['type'] = 'char';

- }

-

- $schema_create .= ' ' . $row['field'] . ' ' . $row['type'];

-

- if (eregi('char', $row['type']))

- {

- if ($row['lengthvar'] > 0)

- {

- $schema_create .= '(' . ($row['lengthvar'] -4) . ')';

- }

- }

-

- if (eregi('numeric', $row['type']))

- {

- $schema_create .= '(';

- $schema_create .= sprintf("%s,%s", (($row['lengthvar'] >> 16) & 0xffff), (($row['lengthvar'] - 4) & 0xffff));

- $schema_create .= ')';

- }

-

- if (!empty($row['rowdefault']))

- {

- $schema_create .= ' DEFAULT ' . $row['rowdefault'];

- }

-

- if ($row['notnull'] == 't')

- {

- $schema_create .= ' NOT NULL';

- }

-

- $schema_create .= ",$crlf";

-

- }

- //

- // Get the listing of primary keys.

- //

-

- $sql_pri_keys = "SELECT ic.relname AS index_name, bc.relname AS tab_name, ta.attname AS column_name, i.indisunique AS unique_key, i.indisprimary AS primary_key

- FROM pg_class bc, pg_class ic, pg_index i, pg_attribute ta, pg_attribute ia

- WHERE (bc.oid = i.indrelid)

- AND (ic.oid = i.indexrelid)

- AND (ia.attrelid = i.indexrelid)

- AND (ta.attrelid = bc.oid)

- AND (bc.relname = '$table')

- AND (ta.attrelid = i.indrelid)

- AND (ta.attnum = i.indkey[ia.attnum-1])

- ORDER BY index_name, tab_name, column_name ";

- $result = $db->sql_query($sql_pri_keys);

-

- if (!$result)

- {

- message_die(GENERAL_ERROR, "Failed in get_table_def (show fields)", "", __LINE__, __FILE__, $sql_pri_keys);

- }

-

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

- {

- if ($row['primary_key'] == 't')

- {

- if (!empty($primary_key))

- {

- $primary_key .= ', ';

- }

-

- $primary_key .= $row['column_name'];

- $primary_key_name = $row['index_name'];

-

- }

- else

- {

- //

- // We have to store this all this info because it is possible to have a multi-column key...

- // we can loop through it again and build the statement

- //

- $index_rows[$row['index_name']]['table'] = $table;

- $index_rows[$row['index_name']]['unique'] = ($row['unique_key'] == 't') ? ' UNIQUE ' : '';

- $index_rows[$row['index_name']]['column_names'] .= $row['column_name'] . ', ';

- }

- }

-

- if (!empty($index_rows))

- {

- while(list($idx_name, $props) = each($index_rows))

- {

- $props['column_names'] = ereg_replace(", $", "" , $props['column_names']);

- $index_create .= 'CREATE ' . $props['unique'] . " INDEX $idx_name ON $table (" . $props['column_names'] . ");$crlf";

- }

- }

-

- if (!empty($primary_key))

- {

- $schema_create .= " CONSTRAINT $primary_key_name PRIMARY KEY ($primary_key),$crlf";

- }

-

- //

- // Generate constraint clauses for CHECK constraints

- //

- $sql_checks = "SELECT rcname as index_name, rcsrc

- FROM pg_relcheck, pg_class bc

- WHERE rcrelid = bc.oid

- AND bc.relname = '$table'

- AND NOT EXISTS (

- SELECT *

- FROM pg_relcheck as c, pg_inherits as i

- WHERE i.inhrelid = pg_relcheck.rcrelid

- AND c.rcname = pg_relcheck.rcname

- AND c.rcsrc = pg_relcheck.rcsrc

- AND c.rcrelid = i.inhparent

- )";

- $result = $db->sql_query($sql_checks);

-

- if (!$result)

- {

- message_die(GENERAL_ERROR, "Failed in get_table_def (show fields)", "", __LINE__, __FILE__, $sql_checks);

- }

-

- //

- // Add the constraints to the sql file.

- //

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

- {

- $schema_create .= ' CONSTRAINT ' . $row['index_name'] . ' CHECK ' . $row['rcsrc'] . ",$crlf";

- }

-

- $schema_create = ereg_replace(',' . $crlf . '$', '', $schema_create);

- $index_create = ereg_replace(',' . $crlf . '$', '', $index_create);

-

- $schema_create .= "$crlf);$crlf";

-

- if (!empty($index_create))

- {

- $schema_create .= $index_create;

- }

-

- //

- // Ok now we've built all the sql return it to the calling function.

- //

- return (stripslashes($schema_create));

-

-}

-

-//

-// This function returns the "CREATE TABLE" syntax for mysql dbms...

-//

-function get_table_def_mysql($table, $crlf)

-{

- global $db;

-

- $schema_create = "";

- $field_query = "SHOW FIELDS FROM $table";

- $key_query = "SHOW KEYS FROM $table";

-

- // If the user has selected to drop existing tables when doing a restore.

- // Then we add the statement to drop the tables....

- $schema_create .= "DROP TABLE IF EXISTS $table;$crlf";

- $schema_create .= "CREATE TABLE $table($crlf";

-

- // Ok lets grab the fields...

- $result = $db->sql_query($field_query);

-

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

- {

- $schema_create .= ' ' . $row['Field'] . ' ' . $row['Type'];

-

- if (!empty($row['Default']))

- {

- $schema_create .= ' DEFAULT \'' . $row['Default'] . '\'';

- }

-

- if ($row['Null'] != "YES")

- {

- $schema_create .= ' NOT NULL';

- }

-

- if ($row['Extra'] != "")

- {

- $schema_create .= ' ' . $row['Extra'];

- }

-

- $schema_create .= ",$crlf";

- }

- //

- // Drop the last ',$crlf' off ;)

- //

- $schema_create = ereg_replace(',' . $crlf . '$', "", $schema_create);

-

- //

- // Get any Indexed fields from the database...

- //

- $result = $db->sql_query($key_query);

-

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

- {

- $kname = $row['Key_name'];

-

- if (($kname != 'PRIMARY') && ($row['Non_unique'] == 0))

- {

- $kname = "UNIQUE|$kname";

- }

-

- if (!is_array($index[$kname]))

- {

- $index[$kname] = array();

- }

-

- $index[$kname][] = $row['Column_name'];

- }

-

- foreach ($index as $x => $columns)

- {

- $schema_create .= ", $crlf";

-

- if ($x == 'PRIMARY')

- {

- $schema_create .= ' PRIMARY KEY (' . implode($columns, ', ') . ')';

- }

- elseif (substr($x,0,6) == 'UNIQUE')

- {

- $schema_create .= ' UNIQUE ' . substr($x,7) . ' (' . implode($columns, ', ') . ')';

- }

- else

- {

- $schema_create .= " KEY $x (" . implode($columns, ', ') . ')';

- }

- }

-

- $schema_create .= "$crlf);";

-

- if (get_magic_quotes_runtime())

- {

- return stripslashes($schema_create);

- }

- else

- {

- return $schema_create;

- }

-

-} // End get_table_def_mysql

-

-

-//

-// This fuction will return a tables create definition to be used as an sql

-// statement.

-//

-//

-// The following functions Get the data from the tables and format it as a

-// series of INSERT statements, for each different DBMS...

-// After every row a custom callback function $handler gets called.

-// $handler must accept one parameter ($sql_insert);

-//

-//

-// Here is the function for postgres...

-//

-function get_table_content_postgresql($table, $handler)

-{

- global $db;

-

- // Grab all of the data from current table.

- $result = $db->sql_query("SELECT * FROM $table");

-

- $i_num_fields = $db->sql_numfields($result);

-

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $aryType[] = $db->sql_fieldtype($i, $result);

- $aryName[] = $db->sql_fieldname($i, $result);

- }

-

- $iRec = 0;

-

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

- {

- unset($schema_vals);

- unset($schema_fields);

- unset($schema_insert);

-

- // Build the SQL statement to recreate the data.

- for($i = 0; $i < $i_num_fields; $i++)

- {

- $strVal = $row[$aryName[$i]];

- if (preg_match('#char|text|bool#i', $aryType[$i]))

- {

- $strQuote = "'";

- $strEmpty = "";

- $strVal = addslashes($strVal);

- }

- elseif (preg_match('#date|timestamp#i', $aryType[$i]))

- {

- if ($empty($strVal))

- {

- $strQuote = "";

- }

- else

- {

- $strQuote = "'";

- }

- }

- else

- {

- $strQuote = "";

- $strEmpty = "NULL";

- }

-

- if (empty($strVal) && $strVal != "0")

- {

- $strVal = $strEmpty;

- }

-

- $schema_vals .= " $strQuote$strVal$strQuote,";

- $schema_fields .= " $aryName[$i],";

- }

-

- $schema_vals = preg_replace('#,$#', '', $schema_vals);

- $schema_vals = preg_replace('#^ #', '', $schema_vals);

- $schema_fields = preg_replace('#,$#', '', $schema_fields);

- $schema_fields = preg_replace('#^ #', '', $schema_fields);

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $schema_insert = "INSERT INTO $table ($schema_fields) VALUES($schema_vals);";

-

- $handler(trim($schema_insert));

- }

-

- return(true);

-

-}// end function get_table_content_postgres...

-

-//

-// This function is for getting the data from a mysql table.

-//

-

-function get_table_content_mysql($table, $handler)

-{

- global $db;

-

- // Grab the data from the table.

- $result = $db->sql_query("SELECT * FROM $table");

-

- // Loop through the resulting rows and build the sql statement.

- $schema_insert = "";

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

- {

- $schema_insert = "\n#\n# Table Data for $table\n#\n";

-

- $handler($schema_insert);

-

- do

- {

- $table_list = '(';

- $num_fields = $db->sql_numfields($result);

- //

- // Grab the list of field names.

- //

- for ($j = 0; $j < $num_fields; $j++)

- {

- $table_list .= $db->sql_fieldname($j, $result) . ', ';

- }

- //

- // Get rid of the last comma

- //

- $table_list = preg_replace('#, $#', '', $table_list);

- $table_list .= ')';

- //

- // Start building the SQL statement.

- //

- $schema_insert = "INSERT INTO $table $table_list VALUES(";

- //

- // Loop through the rows and fill in data for each column

- //

- for ($j = 0; $j < $num_fields; $j++)

- {

- if (!isset($row[$j]))

- {

- //

- // If there is no data for the column set it to null.

- // There was a problem here with an extra space causing the

- // sql file not to reimport if the last column was null in

- // any table. Should be fixed now :) JLH

- //

- $schema_insert .= ' NULL,';

- }

- elseif ($row[$j] != '')

- {

- $schema_insert .= ' \'' . addslashes($row[$j]) . '\',';

- }

- else

- {

- $schema_insert .= '\'\',';

- }

- }

- //

- // Get rid of the the last comma.

- //

- $schema_insert = preg_replace('#,$#', '', $schema_insert);

- $schema_insert .= ');';

- //

- // Go ahead and send the insert statement to the handler function.

- //

- $handler(trim($schema_insert));

- }

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

- }

-

- return true;

-}

-

-function output_table_content($content)

-{

- global $tempfile;

-

- //fwrite($tempfile, $content . "\n");

- //$backup_sql .= $content . "\n";

- echo $content ."\n";

- return;

-}

-//

-// End Functions

-// -----------------------------------------------

-

-?> \ No newline at end of file

-<?php

-/**

-*

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-*/

-if (!empty($setmodules))

-{

- $filename = basename(__FILE__);

- $module['PERM']['PERMISSIONS'] = ($auth->acl_get('a_auth')) ? "$filename$SID&amp;mode=forum" : '';

- $module['PERM']['MODERATORS'] = ($auth->acl_get('a_authmods')) ? "$filename$SID&amp;mode=mod" : '';

- $module['PERM']['SUPER_MODERATORS'] = ($auth->acl_get('a_authmods')) ? "$filename$SID&amp;mode=supermod" : '';

- $module['PERM']['ADMINISTRATORS'] = ($auth->acl_get('a_authadmins')) ? "$filename$SID&amp;mode=admin" : '';

- $module['PERM']['USER_PERMS'] = ($auth->acl_get('a_authusers')) ? "$filename$SID&amp;mode=user" : '';

- $module['PERM']['GROUP_PERMS'] = ($auth->acl_get('a_authgroups')) ? "$filename$SID&amp;mode=group" : '';

-

- return;

-}

-

-define('IN_PHPBB', 1);

-// Include files

-$phpbb_root_path = '../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

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

-

-

-// Grab and set some basic parameters

-//

-// 'mode' determines what we're altering; administrators, users, deps, etc.

-// 'submit' is used to determine what we're doing ... special format

-$mode = (isset($_REQUEST['mode'])) ? htmlspecialchars($_REQUEST['mode']) : '';

-$submode = (isset($_REQUEST['submode'])) ? htmlspecialchars($_REQUEST['submode']) : '';

-$which_mode = (!empty($submode) && $submode != $mode) ? $submode : $mode;

-$submit = array_values(preg_grep('#^submit_(.*)$#i', array_keys($_REQUEST)));

-$submit = (sizeof($submit)) ? substr($submit[0], strpos($submit[0], '_') + 1) : '';

-

-

-// Submitted setting data

-//

-// 'auth_settings' contains the submitted option settings assigned to options, should be an

-// associative array with integer values

-$auth_settings = (isset($_POST['settings'])) ? $_POST['settings'] : '';

-

-

-// Forum, User or Group information

-//

-// 'ug_type' is either user or groups used mainly for forum/admin/mod permissions

-// 'ug_data' contains the list of usernames, user_id's or group_ids for the 'ug_type'

-// 'forum_id' contains the list of forums, 0 is used for "All forums", can be array or scalar

-$ug_type = (isset($_REQUEST['ug_type'])) ? htmlspecialchars($_REQUEST['ug_type']) : '';

-$ug_data = (isset($_POST['ug_data'])) ? $_POST['ug_data'] : '';

-

-if (isset($_REQUEST['f']))

-{

- $forum_id = (is_array($_REQUEST['f'])) ? $_REQUEST['f'] : intval($_REQUEST['f']);

-}

-

-if (!isset($forum_id[$which_mode]))

-{

- $forum_id[$which_mode][] = 0;

-}

-$sql_forum_id = implode(', ', array_map('intval', $forum_id[$which_mode]));

-

-// Generate list of forum id's

-$s_forum_id = '';

-foreach ($forum_id as $forum_submode => $forum_submode_ids)

-{

- foreach ($forum_submode_ids as $submode_forum_id)

- {

- $s_forum_id .= '<input type="hidden" name="f[' . $forum_submode . '][]" value="' . $submode_forum_id . '" />';

- }

-}

-unset($forum_submode_ids);

-unset($forum_submode);

-unset($submode_forum_id);

-

-

-// Instantiate a new auth admin object in readiness

-$auth_admin = new auth_admin();

-

-

-// What mode are we running? So we can output the correct title, explanation

-// and set the sql_option_mode/acl check

-switch ($mode)

-{

- case 'forum':

- $l_title = $user->lang['PERMISSIONS'];

- $l_title_explain = $user->lang['PERMISSIONS_EXPLAIN'];

- $which_acl = 'a_auth';

- $sql_option_mode = 'f';

- break;

-

- case 'mod':

- $l_title = $user->lang['MODERATORS'];

- $l_title_explain = $user->lang['MODERATORS_EXPLAIN'];

- $which_acl = 'a_authmods';

- $sql_option_mode = 'm';

- break;

-

- case 'supermod':

- $l_title = $user->lang['SUPER_MODERATORS'];

- $l_title_explain = $user->lang['SUPER_MODERATORS_EXPLAIN'];

- $which_acl = 'a_authmods';

- $sql_option_mode = 'm';

- break;

-

- case 'admin':

- $l_title = $user->lang['ADMINISTRATORS'];

- $l_title_explain = $user->lang['ADMINISTRATORS_EXPLAIN'];

- $which_acl = 'a_authadmins';

- $sql_option_mode = 'a';

- break;

-

- case 'user':

- $l_title = $user->lang['USER_PERMISSIONS'];

- $l_title_explain = $user->lang['USER_PERMISSIONS_EXPLAIN'];

- $which_acl = 'a_authusers';

- $sql_option_mode = 'u';

- break;

-

- case 'group':

- $l_title = $user->lang['GROUP_PERMISSIONS'];

- $l_title_explain = $user->lang['GROUP_PERMISSIONS_EXPLAIN'];

- $which_acl = 'a_authgroups';

- $sql_option_mode = 'u';

- break;

-

- case 'deps':

- $l_title = $user->lang['DEPENDENCIES'];

- $l_title_explain = $user->lang['DEPENDENCIES_EXPLAIN'];

- $which_acl = 'a_authdeps';

- break;

-}

-

-// Permission check

-if (!$auth->acl_get($which_acl))

-{

- trigger_error($user->lang['NO_ADMIN']);

-}

-

-// Are we setting deps? If we are we need to re-run the mode match above for the

-// relevant 'new' mode

-if (!empty($submode))

-{

- switch ($submode)

- {

- case 'forum':

- $l_title_explain = $user->lang['PERMISSIONS_EXPLAIN'];

- $which_acl = 'a_auth';

- $sql_option_mode = 'f';

- break;

-

- case 'mod':

- $l_title_explain = $user->lang['MODERATORS_EXPLAIN'];

- $which_acl = 'a_authmods';

- $sql_option_mode = 'm';

- break;

-

- case 'supermod':

- $l_title_explain = $user->lang['SUPER_MODERATORS_EXPLAIN'];

- $which_acl = 'a_authmods';

- $sql_option_mode = 'm';

- break;

- }

-

- // Permission check

- if (!$auth->acl_get($which_acl))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

-}

-

-

-// Does user want to update anything? Check here to find out

-// and act appropriately

-switch ($submit)

-{

- case 'update':

-

- if (sizeof($auth_settings))

- {

- // Admin wants subforums to inherit permissions ... so add these

- // forums to the list ... since inheritance is only available for

- // forum and moderator primary modes we deal with '$forum_id[$mode]'

- if (!empty($_POST['inherit']))

- {

- $forum_id[$mode] = array_merge($forum_id[$mode], array_map('intval', $_POST['inherit']));

- }

-

- // Update the permission set ... we loop through each auth setting array

- foreach ($auth_settings as $auth_submode => $auth_setting)

- {

- // Are any entries * ? If so we need to remove them since they

- // are options the user wishes to ignore

- if (in_array('*', $auth_setting))

- {

- $temp = array();

- foreach ($auth_setting as $option => $setting)

- {

- if ($setting != '*')

- {

- $temp[$option] = $setting;

- }

- }

- $auth_setting = $temp;

- }

-

- if (sizeof($auth_setting))

- {

- // Loop through all user/group ids

- foreach ($ug_data as $id)

- {

- $auth_admin->acl_set($ug_type, $forum_id[$auth_submode], intval($id), $auth_setting);

- }

- }

- }

-

-

- // Do we need to recache the moderator lists? We do if the mode

- // was mod or auth_settings['mod'] is a non-zero size array

- if ($mode == 'mod' || (isset($auth_settings['mod']) && sizeof($auth_settings['mod'])))

- {

- cache_moderators();

- }

-

- // Remove users who are now moderators or admins from everyones foes

- // list

- if ($mode == 'mod' || (isset($auth_settings['mod']) && sizeof($auth_settings['mod'])) || $mode == 'admin' || (isset($auth_settings['admin']) && sizeof($auth_settings['admin'])))

- {

- update_foes();

- }

-

- // Logging ... first grab user or groupnames ...

- $sql = ($ug_type == 'group') ? 'SELECT group_name as name, group_type FROM ' . GROUPS_TABLE . ' WHERE group_id' : 'SELECT username as name FROM ' . USERS_TABLE . ' WHERE user_id';

- $sql .= ' IN (' . implode(', ', array_map('intval', $ug_data)) . ')';

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

-

- $l_ug_list = '';

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

- {

- $l_ug_list .= (($l_ug_list != '') ? ', ' : '') . ((isset($row['group_type']) && $row['group_type'] == GROUP_SPECIAL) ? '<span class="blue">' . $user->lang['G_' . $row['name']] . '</span>' : $row['name']);

- }

- $db->sql_freeresult($result);

-

- foreach (array_keys($auth_settings) as $submode)

- {

- if (!in_array(0, $forum_id[$submode]))

- {

- // Grab the forum details if non-zero forum_id

- $sql = 'SELECT forum_name

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id IN ($sql_forum_id)";

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

-

- $l_forum_list = '';

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

- {

- $l_forum_list .= (($l_forum_list != '') ? ', ' : '') . $row['forum_name'];

- }

- $db->sql_freeresult($result);

-

- add_log('admin', 'LOG_ACL_' . strtoupper($submode) . '_ADD', $l_forum_list, $l_ug_list);

- }

- else

- {

- add_log('admin', 'LOG_ACL_' . strtoupper($submode) . '_ADD', $l_ug_list);

- }

- }

- unset($l_ug_list);

- }

- unset($auth_submode);

- unset($auth_setting);

-

- trigger_error($user->lang['AUTH_UPDATED']);

- break;

-

- case 'delete':

-

- $sql = "SELECT auth_option_id

- FROM " . ACL_OPTIONS_TABLE . "

- WHERE auth_option LIKE '{$sql_option_mode}_%'";

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

-

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

- {

- $option_id_ary = array();

- do

- {

- $option_id_ary[] = $row['auth_option_id'];

- }

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

-

- foreach ($ug_data as $id)

- {

- $auth_admin->acl_delete($ug_type, $forum_id[$mode], $id, $option_id_ary);

- }

- unset($option_id_ary);

- }

- $db->sql_freeresult($result);

-

-

- // Do we need to recache the moderator lists? We do if the mode

- // was mod or auth_settings['mod'] is a non-zero size array

- if ($mode == 'mod' || (isset($auth_settings['mod']) && sizeof($auth_settings['mod'])))

- {

- cache_moderators();

- }

-

-

- // Logging ... first grab user or groupnames ...

- $sql = ($ug_type == 'group') ? 'SELECT group_name as name, group_type FROM ' . GROUPS_TABLE . ' WHERE group_id' : 'SELECT username as name FROM ' . USERS_TABLE . ' WHERE user_id';

- $sql .= ' IN (' . implode(', ', array_map('intval', $ug_data)) . ')';

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

-

- $l_ug_list = '';

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

- {

- $l_ug_list .= (($l_ug_list != '') ? ', ' : '') . ((isset($row['group_type']) && $row['group_type'] == GROUP_SPECIAL) ? '<span class="blue">' . $user->lang['G_' . $row['name']] . '</span>' : $row['name']);

- }

- $db->sql_freeresult($result);

-

-

- // Grab the forum details if non-zero forum_id

- if (!in_array(0, $forum_id[$which_mode]))

- {

- $sql = 'SELECT forum_name

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id IN ($sql_forum_id)";

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

-

- $l_forum_list = '';

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

- {

- $l_forum_list .= (($l_forum_list != '') ? ', ' : '') . $row['forum_name'];

- }

- $db->sql_freeresult($result);

-

- add_log('admin', 'LOG_ACL_' . strtoupper($which_mode) . '_DEL', $l_forum_list, $l_ug_list);

- }

- else

- {

- add_log('admin', 'LOG_ACL_' . strtoupper($which_mode) . '_DEL', $l_ug_list);

- }

-

- trigger_error($user->lang['AUTH_UPDATED']);

- break;

-

- case 'presetsave':

-

- $holding_ary = array();

- foreach ($auth_settings[$which_mode] as $option => $setting)

- {

- switch ($setting)

- {

- case ACL_YES:

- $holding_ary['yes'][] = $option;

- break;

-

- case ACL_NO:

- $holding_ary['no'][] = $option;

- break;

-

- case ACL_UNSET:

- $holding_ary['unset'][] = $option;

- break;

- }

- }

- unset($option);

- unset($setting);

-

- $sql = array(

- 'preset_user_id'=> intval($user->data['user_id']),

- 'preset_type' => $sql_option_mode,

- 'preset_data' => $db->sql_escape(serialize($holding_ary))

- );

-

- if (!empty($_POST['presetname']))

- {

- $sql['preset_name'] = $db->sql_escape($_POST['presetname']);

- }

-

- if (!empty($_POST['presetname']) || $_POST['presetoption'] != -1)

- {

- $sql = ($_POST['presetoption'] == -1) ? 'INSERT INTO ' . ACL_PRESETS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql) : 'UPDATE ' . ACL_PRESETS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql) . ' WHERE preset_id =' . intval($_POST['presetoption']);

- $db->sql_query($sql);

-

- add_log('admin', 'LOG_ACL_PRESET_ADD', $sql['preset_name']);

- }

- break;

-

- case 'presetdel':

- if (!empty($_POST['presetoption']))

- {

- $sql = "SELECT preset_name

- FROM " . ACL_PRESETS_TABLE . "

- WHERE preset_id = " . intval($_POST['presetoption']);

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

-

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

- $db->sql_freeresult($result);

-

- $sql = "DELETE FROM " . ACL_PRESETS_TABLE . "

- WHERE preset_id = " . intval($_POST['presetoption']);

- $db->sql_query($sql);

-

- add_log('admin', 'LOG_ACL_PRESET_DEL', $row['preset_name']);

- unset($row);

- }

- break;

-}

-// End update

-

-

-// Output page header

-adm_page_header($l_title);

-

-

-// First potential form ... this is for selecting forums, users

-// or groups.

-if (in_array($mode, array('user', 'group', 'forum', 'mod')) && empty($submit))

-{

-

-?>

-

-<h1><?php echo $l_title; ?></h1>

-

-<p><?php echo $l_title_explain ?></p>

-

-<form method="post" action="<?php echo "admin_permissions.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

-<?php

-

- // Mode specific markup

- switch ($mode)

- {

- case 'forum':

- case 'mod':

-

-?>

- <tr>

- <th align="center"><?php echo $user->lang['LOOK_UP_FORUM']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center" valign="middle">&nbsp;<select name="f[<?php echo $mode; ?>][]" multiple="true" size="5"><?php

-

- echo make_forum_select(false, false, false);

-

-?></select>&nbsp;</td>

- </tr>

- <tr>

- <td class="cat" align="center"><input type="submit" name="submit_usergroups" value="<?php echo $user->lang['LOOK_UP_FORUM']; ?>" class="btnmain" />&nbsp; <input type="reset" value="<?php echo $user->lang['RESET']; ?>" class="btnlite" /><input type="hidden" name="ug_type" value="forum" /><input type="hidden" name="action" value="usergroups" /></td>

- </tr>

-<?php

-

- break;

-

- case 'user':

-

-?>

- <tr>

- <th align="center"><?php echo $user->lang['LOOK_UP_USER']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center">&nbsp;<textarea cols="40" rows="4" name="ug_data[]"></textarea>&nbsp;</td>

- </tr>

- <tr>

- <td class="cat" align="center"><input type="submit" name="submit_add_options" value="<?php echo $user->lang['SUBMIT']; ?>" class="btnmain" />&nbsp; <input type="reset" value="<?php echo $user->lang['RESET']; ?>" class="btnlite" />&nbsp; <input type="submit" value="<?php echo $user->lang['FIND_USERNAME']; ?>" class="btnlite" onclick="window.open('<?php echo "../memberlist.$phpEx$SID"; ?>&amp;mode=searchuser&amp;form=2&amp;field=entries', '_phpbbsearch', 'HEIGHT=500,resizable=yes,scrollbars=yes,WIDTH=740');return false;" /><input type="hidden" name="ug_type" value="user" /></td>

- </tr>

-<?php

-

- break;

-

- case 'group':

- // Generate list of groups

-

-?>

- <tr>

- <th align="center"><?php echo $user->lang['LOOK_UP_GROUP']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center" valign="middle">&nbsp;<select name="ug_data[]" multiple="true" size="5"><?php

-

- $sql = "SELECT group_id, group_name, group_type

- FROM " . GROUPS_TABLE . "

- ORDER BY group_type DESC";

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

-

- $group_options = '';

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

- {

- do

- {

- echo '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="blue"' : '') . ' value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

- }

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

- }

- $db->sql_freeresult($result);

-

-?></select>&nbsp;</td>

- </tr>

- <tr>

- <td class="cat" align="center"><input type="submit" name="submit_edit_options" value="<?php echo $user->lang['LOOK_UP_GROUP']; ?>" class="btnmain" />&nbsp; <input type="reset" value="<?php echo $user->lang['RESET']; ?>" class="btnlite" /><input type="hidden" name="ug_type" value="group" /></td>

- </tr>

-<?php

-

- break;

-

- }

-

-?>

-</table></form>

-

-<?php

-

-}

-// End user, group or forum selection

-

-

-// Second possible form, this lists the currently enabled

-// users/groups for the given mode

-if ((in_array($submit, array('usergroups', 'delete', 'cancel'))) || (!strstr($submit, 'options') && empty($submode) && in_array($mode, array('admin', 'supermod'))))

-{

-

-?>

-

-<h1><?php echo $l_title; ?></h1>

-

-<p><?php echo $l_title_explain; ?></p>

-

-<table width="100%" cellspacing="0" cellpadding="0" border="0">

- <tr>

- <td align="center"><h1><?php echo $user->lang['USERS']; ?></h1></td>

- <td align="center"><h1><?php echo $user->lang['USERGROUPS']; ?></h1></td>

- </tr>

- <tr>

-

- <td><form method="post" action="<?php echo "admin_permissions.$phpEx$SID&amp;mode=$mode"; ?>"><table width="90%" class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th><?php echo $user->lang['MANAGE_USERS']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center"><select style="width:280px" name="ug_data[]" multiple="multiple" size="5"><?php

-

- $sql = "SELECT DISTINCT u.user_id, u.username

- FROM " . USERS_TABLE . " u, " . ACL_USERS_TABLE . " a, " . ACL_OPTIONS_TABLE . " o

- WHERE o.auth_option LIKE '" . $sql_option_mode . "_%'

- AND a.auth_option_id = o.auth_option_id

- AND a.forum_id IN ($sql_forum_id)

- AND u.user_id = a.user_id

- ORDER BY u.username, u.user_regdate ASC";

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

-

- $users = '';

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

- {

- echo '<option value="' . $row['user_id'] . '">' . $row['username'] . '</option>';

- }

- $db->sql_freeresult($result);

-

-?></select></td>

- </tr>

- <tr>

- <td class="cat" align="center"><input class="btnlite" type="submit" name="submit_delete" value="<?php echo $user->lang['DELETE']; ?>" /> &nbsp; <input class="btnlite" type="submit" name="submit_edit_options" value="<?php echo $user->lang['SET_OPTIONS']; ?>" /><input type="hidden" name="ug_type" value="user" /><?php echo $s_forum_id; ?></td>

- </tr>

- </table></form></td>

-

- <td align="center"><form method="post" name="admingroups" action="<?php echo "admin_permissions.$phpEx$SID&amp;mode=$mode"; ?>"><table width="90%" class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th><?php echo $user->lang['MANAGE_GROUPS']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center"><select style="width:280px" name="ug_data[]" multiple="multiple" size="5"><?php

-

- $sql = "SELECT DISTINCT g.group_id, g.group_name, g.group_type

- FROM " . GROUPS_TABLE . " g, " . ACL_GROUPS_TABLE . " a, " . ACL_OPTIONS_TABLE . " o

- WHERE o.auth_option LIKE '" . $sql_option_mode . "_%'

- AND a.forum_id IN ($sql_forum_id)

- AND a.auth_option_id = o.auth_option_id

- AND g.group_id = a.group_id

- ORDER BY g.group_type DESC, g.group_name ASC";

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

-

- $groups = '';

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

- {

- echo '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="blue"' : '') . ' value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

- }

- $db->sql_freeresult($result);

-

-?></select></td>

- </tr>

- <tr>

- <td class="cat" align="center"><input class="btnlite" type="submit" name="submit_delete" value="<?php echo $user->lang['DELETE']; ?>" /> &nbsp; <input class="btnlite" type="submit" name="submit_edit_options" value="<?php echo $user->lang['SET_OPTIONS']; ?>" /><input type="hidden" name="ug_type" value="group" /><?php echo $s_forum_id; ?></td>

- </tr>

- </table></form></td>

-

- </tr>

- <tr>

-

- <td><form method="post" action="<?php echo "admin_permissions.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" width="90%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th><?php echo $user->lang['ADD_USERS']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center"><textarea cols="40" rows="4" name="ug_data[]"></textarea></td>

- </tr>

- <tr>

- <td class="cat" align="center"> <input type="submit" name="submit_add_options" value="<?php echo $user->lang['SUBMIT']; ?>" class="btnmain" />&nbsp; <input type="reset" value="<?php echo $user->lang['RESET']; ?>" class="btnlite" />&nbsp; <input type="submit" value="<?php echo $user->lang['FIND_USERNAME']; ?>" class="btnlite" onclick="window.open('<?php echo "../memberlist.$phpEx$SID"; ?>&amp;mode=searchuser&amp;form=2&amp;field=entries', '_phpbbsearch', 'HEIGHT=500,resizable=yes,scrollbars=yes,WIDTH=740');return false;" /><input type="hidden" name="ug_type" value="user" /><?php echo $s_forum_id; ?></td>

- </tr>

- </table></form></td>

-

- <td><form method="post" action="<?php echo "admin_permissions.$phpEx$SID&amp;mode=$mode"; ?>"><table width="90%" class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th><?php echo $user->lang['ADD_GROUPS']; ?></th>

- </tr>

- <tr>

- <td class="row1" align="center"><select name="ug_data[]" multiple="multiple" size="4"><?php

-

- $sql = "SELECT group_id, group_name, group_type

- FROM " . GROUPS_TABLE . "

- ORDER BY group_type DESC, group_name";

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

-

- $group_list = '';

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

- {

- echo '<option' . (($row['group_type'] == GROUP_SPECIAL) ? ' class="blue"' : '') . ' value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

- }

- $db->sql_freeresult($result);

-

-?></select></td>

- </tr>

- <tr>

- <td class="cat" align="center"> <input type="submit" name="submit_add_options" value="<?php echo $user->lang['SUBMIT']; ?>" class="btnmain" />&nbsp; <input type="reset" value="<?php echo $user->lang['RESET']; ?>" class="btnlite" /><input type="hidden" name="ug_type" value="group" /><?php echo $s_forum_id; ?></td>

- </tr>

- </table></form></td>

- </tr>

-</table>

-

-<?php

-

-}

-// End user and group acl selections

-

-

-

-

-

-

-// Third possible form, this is the major section of this script. It

-// handles the entry of permission options for all situations

-if (in_array($submit, array('add_options', 'edit_options', 'presetsave', 'presetdel', 'update')) || !empty($submode))

-{

-

- // Did the user specify any users or groups?

- if (empty($ug_data))

- {

- $l_message = ($ug_type == 'user') ? 'NO_USER' : 'NO_GROUP';

- trigger_error($user->lang[$l_message]);

- }

-

-

- $forum_list = '';

- // Grab the forum details if non-zero forum_id

- if (!in_array(0, $forum_id[$which_mode]))

- {

- $sql = 'SELECT forum_id, forum_name, parent_id

- FROM ' . FORUMS_TABLE . "

- WHERE forum_id IN ($sql_forum_id)";

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

-

- if (!($row = $db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_FORUM']);

- }

-

- // If we have more than one forum we want a list of all their names

- // so loop through all results. We don't need all the data though

- // since cascading/inheritance is only applicable if a single forum

- // was selected

- $forum_data = $row;

-

- do

- {

- $forum_list .= (($forum_list != '') ? ', ' : '') . '<b>' . $row['forum_name'] . '</b>';

- }

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

- $db->sql_freeresult($result);

- }

-

-

- // Grab relevant user or group information

- $ug_ids = $l_ug_list = $ug_hidden = $l_no_error = '';

- switch ($ug_type)

- {

- case 'user':

- // If we've just come from the usergroup form then user will actually

- // be a username rather than a user_id, so act appropriately

- $l_no_error = $user->lang['NO_USER'];

- $sql = 'SELECT user_id AS id, username AS name

- FROM ' . USERS_TABLE . '

- WHERE ';

-

- if ($submit == 'add_options')

- {

- $_ug_data = explode("\r\n", $ug_data[0]);

-

- $_u_sql = '';

- foreach ($_ug_data as $_u_name)

- {

- $_u_sql .= (($_u_sql) ? ', ' : '') . "'" . $db->sql_escape($_u_name) . "'";

- }

- $sql .= ' username IN (' . $_u_sql . ')';

- }

- else

- {

- $sql .= ' user_id ' . ((is_array($ug_data)) ? 'IN (' . implode(', ', $ug_data) . ')' : '= ' . $ug_data);

- }

-

- break;

-

- case 'group':

- $l_no_error = $user->lang['NO_GROUP'];

- $sql = 'SELECT group_id AS id, group_name AS name, group_type

- FROM ' . GROUPS_TABLE . '

- WHERE group_id';

- $sql .= (is_array($ug_data)) ? ' IN (' . implode(', ', $ug_data) . ')' : ' = ' . $ug_data;

- break;

- }

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

-

- if (!$row = $db->sql_fetchrow($result))

- {

- trigger_error($l_no_error);

- }

- unset($l_no_error);

-

- // Store the user_ids and names for later use

- do

- {

- $l_ug_list .= (($l_ug_list != '') ? ', ' : '') . ((isset($row['group_type']) && $row['group_type'] == GROUP_SPECIAL) ? '<b class="blue">' . $user->lang['G_' . $row['name']] : '<b>' . $row['name']) . '</b>';

- $ug_ids .= (($ug_ids != '') ? ', ' : '') . $row['id'];

- $ug_hidden .= '<input type="hidden" name="ug_data[]" value="' . $row['id'] . '" />';

- }

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

- $db->sql_freeresult($result);

-

-

- // Grab the list of options ... if we're in deps mode we want all options,

- // else we skip the master options

- $sql_founder = ($user->data['user_type'] == USER_FOUNDER) ? ' AND founder_only <> 1' : '';

- $sql_limit_option = ($mode == 'deps') ? '' : "AND auth_option <> '" . $sql_option_mode . "_'";

- $sql = "SELECT auth_option_id, auth_option

- FROM " . ACL_OPTIONS_TABLE . "

- WHERE auth_option LIKE '" . $sql_option_mode . "_%'

- $sql_limit_option

- $sql_founder";

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

-

- $auth_options = array();

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

- {

- $auth_options[] = $row;

- }

- $db->sql_freeresult($result);

-

- unset($sql_limit_option);

-

-

- // Now we'll build a list of preset options ...

- $preset_options = $preset_js = $preset_update_options = '';

- $holding = array();

- $holding['allow'] = $holding['deny'] = $holding['inherit'] = '';

-

- // Do we have a parent forum? If so offer option to inherit from that

- if ($forum_data['parent_id'] != 0)

- {

- switch ($ug_type)

- {

- case 'group':

- $sql = "SELECT o.auth_option, a.auth_setting FROM " . ACL_GROUPS_TABLE . " a, " . ACL_OPTIONS_TABLE . " o WHERE o.auth_option LIKE '" . $sql_option_mode . "_%' AND a.auth_option_id = o.auth_option_id AND a.forum_id = " . $forum_data['parent_id'] . " AND a.group_id IN ($ug_ids)";

- break;

-

- case 'user':

- $sql = "SELECT o.auth_option, a.auth_setting FROM " . ACL_USERS_TABLE . " a, " . ACL_OPTIONS_TABLE . " o WHERE o.auth_option LIKE '" . $sql_option_mode . "_%' AND a.auth_option_id = o.auth_option_id AND a.forum_id = " . $forum_data['parent_id'] . " AND a.user_id IN ($ug_ids)";

- break;

- }

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

-

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

- {

- do

- {

- switch ($row['auth_setting'])

- {

- case ACL_YES:

- $holding['allow'] .= $row['auth_option'] . ', ';

- break;

-

- case ACL_NO:

- $holding['deny'] .= $row['auth_option'] . ', ';

- break;

-

- case ACL_UNSET:

- $holding['inherit'] .= $row['auth_option'] . ', ';

- break;

- }

- }

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

-

- $preset_options .= '<option value="preset_0">' . $user->lang['INHERIT_PARENT'] . '</option>';

- $preset_js .= "\tpresets['preset_0'] = new Array();" . "\n";

- $preset_js .= "\tpresets['preset_0'] = new preset_obj('" . $holding['allow'] . "', '" . $holding['deny'] . "', '" . $holding['inherit'] . "');\n";

- }

- $db->sql_freeresult($result);

- }

-

- // Look for custom presets

- $sql = "SELECT preset_id, preset_name, preset_data

- FROM " . ACL_PRESETS_TABLE . "

- WHERE preset_type = '" . (($mode == 'deps') ? 'f' : $sql_option_mode) . "'

- ORDER BY preset_id ASC";

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

-

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

- {

- do

- {

- $preset_update_options .= '<option value="' . $row['preset_id'] . '">' . $row['preset_name'] . '</option>';

- $preset_options .= '<option value="preset_' . $row['preset_id'] . '">' . $row['preset_name'] . '</option>';

-

- $preset_data = unserialize(stripslashes($row['preset_data']));

-

- foreach ($preset_data as $preset_type => $preset_type_ary)

- {

- $holding[$preset_type] = '';

- foreach ($preset_type_ary as $preset_option)

- {

- $holding[$preset_type] .= "$preset_option, ";

- }

- }

-

- $preset_js .= "\tpresets['preset_" . $row['preset_id'] . "'] = new Array();" . "\n";

- $preset_js .= "\tpresets['preset_" . $row['preset_id'] . "'] = new preset_obj('" . $holding['yes'] . "', '" . $holding['no'] . "', '" . $holding['inherit'] . "');\n";

- }

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

- }

- $db->sql_freeresult($result);

-

- unset($holding);

-

-

- // If we aren't looking @ deps then we try and grab existing sessions for

- // the given forum and user/group

- if (!is_array($auth_settings) || empty($auth_settings[$which_mode]))

- {

- if ($which_mode == $mode)

- {

- switch ($ug_type)

- {

- case 'group':

- $sql_table = ACL_GROUPS_TABLE . ' a ';

- $sql_join = 'a.group_id';

- break;

-

- case 'user':

- $sql_table = ACL_USERS_TABLE . ' a ';

- $sql_join = 'a.user_id';

- break;

- }

-

- $sql = "SELECT o.auth_option, MIN(a.auth_setting) AS min_auth_setting

- FROM $sql_table, " . ACL_OPTIONS_TABLE . " o

- WHERE o.auth_option LIKE '" . $sql_option_mode . "_%'

- AND a.auth_option_id = o.auth_option_id

- AND a.forum_id IN ($sql_forum_id)

- AND $sql_join IN ($ug_ids)

- GROUP BY o.auth_option";

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

-

- $auth_settings[$which_mode] = array();

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

- {

- $auth_settings[$which_mode][$row['auth_option']] = $row['min_auth_setting'];

- }

- $db->sql_freeresult($result);

- }

- else

- {

- // We're looking at a view ... so we'll set all options to unset

- // We could be a little more clever here but the "safe side" looks

- // better right now

- $auth_settings[$which_mode] = array();

- foreach ($auth_options as $option)

- {

- $auth_settings[$which_mode][$option['auth_option']] = '*';

- }

- unset($option);

- }

- }

-

- $view_options = '';

- // Should we display a dropdown for views?

- if (in_array($mode, array('admin', 'supermod', 'mod')))

- {

- $view_options .= '<option value="">' . $user->lang['SELECT_VIEW'] . '</option>';

- $view_ary = array(

- 'admin' => array('admin' => 'a_', 'forum' => 'a_auth', 'supermod' => 'a_authmods', 'mod' => 'a_authmods'),

- 'supermod' => array('supermod' => 'a_authmods', 'mod' => 'a_authmods', 'forum' => 'a_auth'),

- 'mod' => array('mod' => 'a_authmods', 'forum' => 'a_auth')

- );

-

- foreach ($view_ary[$mode] as $which_submode => $which_acl)

- {

- if ($auth->acl_get($which_acl))

- {

- $view_options .= '<option value="' . $which_submode . '"' . (($which_submode == $which_mode) ? ' selected="selected"' : '') . '>' . $user->lang['ACL_VIEW_' . strtoupper($which_submode)] . '</option>';

- }

-

- }

- unset($view_ary);

- }

-

- $settings_hidden = '';

- // Output original settings ... needed when we jump views

- foreach ($auth_settings as $auth_submode => $auth_submode_settings)

- {

- if ($auth_submode != $which_mode)

- {

- foreach ($auth_submode_settings as $submode_option => $submode_setting)

- {

- $settings_hidden .= ($submode_setting != '*') ? '<input type="hidden" name="settings[' . $auth_submode . '][' . $submode_option . ']" value="' . $submode_setting . '" />' : '';

- }

- }

- }

- unset($auth_submode);

- unset($auth_submode_settings);

- unset($auth_submode_option);

- unset($auth_submode_setting);

-

-?>

-

-<script language="Javascript" type="text/javascript">

-<!--

-

- var presets = new Array();

-<?php

-

- echo $preset_js;

-

-?>

-

- function preset_obj(yes, no, unset)

- {

- this.yes = yes;

- this.no = no;

- this.unset = unset;

- }

-

- function use_preset(option)

- {

- if (option)

- {

- document.acl.set.selectedIndex = 0;

- for (i = 0; i < document.acl.length; i++)

- {

- var elem = document.acl.elements[i];

- if (elem.name.indexOf('settings') == 0)

- {

- switch (option)

- {

- case 'all_yes':

- if (elem.value == <?php echo ACL_YES; ?>)

- elem.checked = true;

- break;

-

- case 'all_no':

- if (elem.value == <?php echo ACL_NO; ?>)

- elem.checked = true;

- break;

-

- case 'all_unset':

- if (elem.value == <?php echo ACL_UNSET; ?>)

- elem.checked = true;

- break;

-

- case 'all_ignore':

- if (elem.value == '*')

- elem.checked = true;

- break;

-

- default:

- option_start = elem.name.search(/\[(\w+?)\]$/);

- option_name = elem.name.substr(option_start + 1, elem.name.length - option_start - 2);

-

- if (presets[option].yes.indexOf(option_name + ',') != -1 && elem.value == <?php echo ACL_YES; ?>)

- elem.checked = true;

- else if (presets[option].no.indexOf(option_name + ',') != -1 && elem.value == <?php echo ACL_NO; ?>)

- elem.checked = true;

- else if (presets[option].unset.indexOf(option_name + ',') != -1 && elem.value == <?php echo ACL_UNSET; ?>)

- elem.checked = true;

- break;

- }

- }

- }

- }

- }

-

- function marklist(match, status)

- {

- for (i = 0; i < document.acl.length; i++)

- {

- if (document.acl.elements[i].name.indexOf(match) == 0)

- document.acl.elements[i].checked = status;

- }

- }

-

- function open_win(url, width, height)

- {

- aclwin = window.open(url, '_phpbbacl', 'HEIGHT=' + height + ',resizable=yes, scrollbars=yes,WIDTH=' + width);

- if (window.focus)

- aclwin.focus();

- }

-//-->

-</script>

-

-<p><?php echo $user->lang['ACL_EXPLAIN']; ?></p>

-

-<h1><?php echo $l_title; ?></h1>

-

-<?php

-

- // Do we have a list of forums? If so, output them ... but only

- // if we're looking at the primary view or mode ... submodes

- // output their own list of forums as and where applicable so this

- // is unnecessary

- if ($forum_list != '' && $which_mode == $mode)

- {

- $l_selected_forums = (sizeof($forum_id[$which_mode]) == 1) ? 'SELECTED_FORUM' : 'SELECTED_FORUMS';

-

- echo '<p>' . $user->lang[$l_selected_forums] . ': ' . $forum_list . '</p>';

-

- unset($forum_list);

- unset($l_selected_forums);

- }

-

- // Now output the list of users or groups ... these will always exist

- $l_selected_users = ($ug_type == 'user') ? ((sizeof($ug_data) == 1) ? 'SELECTED_USER' : 'SELECTED_USERS') : ((sizeof($ug_data) == 1) ? 'SELECTED_GROUP' : 'SELECTED_GROUPS');

-

- echo '<p>' . $user->lang[$l_selected_users] . ': ' . $l_ug_list . '</p>';

-

- unset($l_selected_users);

- unset($ug_data);

-

-?>

-

-<p><?php echo $l_title_explain; ?></p>

-

-<?php

-

- if ($settings_hidden != '')

- {

-

-?>

-

-<h2 style="color:red"><?php echo $user->lang['WARNING']; ?></h2>

-

-<p><?php echo $user->lang['WARNING_EXPLAIN']; ?></p>

-

-<?php

-

- }

-

-?>

-

-<form method="post" name="acl" action="<?php echo "admin_permissions.$phpEx$SID&amp;mode=$mode&amp;submode=$submode"; ?>"><table cellspacing="2" cellpadding="0" border="0" align="center">

-<?php

-

- // This is the main listing of options

-

- // We output this for both deps and when update is requested where

- // deps exist

- if (($mode == 'admin' || $mode == 'supermod') && in_array($submode, array('forum', 'mod')))

- {

-

-?>

- <tr>

- <td colspan="2" align="right"><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0">

- <tr>

- <th colspan="2"><?php echo $user->lang['SELECT_FORUM']; ?></th>

- </tr>

- <tr>

- <td class="row1" width="150"><?php echo $user->lang['WILL_SET_OPTIONS']; ?>:</td>

- <td class="row2"><select name="f[<?php echo $which_mode; ?>][]" multiple="4"><?php

-

- echo make_forum_select($forum_id[$which_mode], false, true);

-

-?></select></td>

- </tr>

- </table><br /></td>

- </tr>

-<?php

-

- }

- // End deps output

-

-?>

- <tr>

- <td align="left"><?php

-

- if ($view_options != '')

- {

-

-?><select name="submode" onchange="if (this.options[this.selectedIndex].value != '') this.form.submit();"><?php echo $view_options; ?></select><?php

-

- }

-

-?></td>

- <td align="right"><?php echo $user->lang['PRESETS']; ?>: <select name="set" onchange="use_preset(this.options[this.selectedIndex].value);"><option class="sep"><?php echo $user->lang['SELECT'] . ' -&gt;'; ?></option><option value="all_yes"><?php echo $user->lang['ALL_YES']; ?></option><option value="all_no"><?php echo $user->lang['ALL_NO']; ?></option><option value="all_unset"><?php echo $user->lang['ALL_UNSET']; ?></option><?php

-

- $colspan = 4;

- if ($which_mode != $mode)

- {

- $colspan = 5;

- echo '<option value="all_ignore">' . $user->lang['ALL_IGNORE'] . '</option>';

- }

-

- // Output user preset options ... if any

- echo ($preset_options) ? '<option class="sep">' . $user->lang['USER_PRESETS'] . ' -&gt;' . '</option>' . $preset_options : '';

-

-?></select></td>

- </tr>

- <tr>

- <td colspan="2"><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th>&nbsp;<?php echo $user->lang['OPTION']; ?>&nbsp;</th>

- <th width="50">&nbsp;<?php echo $user->lang['YES']; ?>&nbsp;</th>

- <th width="50">&nbsp;<?php echo $user->lang['UNSET']; ?>&nbsp;</th>

- <th width="50">&nbsp;<?php echo $user->lang['NO']; ?>&nbsp;</th>

-<?php

-

- if ($which_mode != $mode)

- {

-

-?>

- <th width="50">&nbsp;<?php echo $user->lang['IGNORE']; ?>&nbsp;</th>

-<?php

-

- }

-

-?>

- </tr>

-<?php

-

- $row_class = 'row2';

- for ($i = 0; $i < sizeof($auth_options); $i++)

- {

- $row_class = ($row_class == 'row1') ? 'row2' : 'row1';

-

- // Try and output correct language strings, else output prettyfied auth_option

- $l_auth_option = (!empty($user->lang['acl_' . $auth_options[$i]['auth_option']])) ? $user->lang['acl_' . $auth_options[$i]['auth_option']] : ucfirst(preg_replace('#.*?_#', '', $auth_options[$i]['auth_option']));

- $s_auth_option = '[' . $which_mode . '][' . $auth_options[$i]['auth_option'] . ']';

-

-

- // Which option should we select?

- $selected_yes = (isset($auth_settings[$which_mode][$auth_options[$i]['auth_option']]) && $auth_settings[$which_mode][$auth_options[$i]['auth_option']] == ACL_YES) ? ' checked="checked"' : '';

- $selected_no = (isset($auth_settings[$which_mode][$auth_options[$i]['auth_option']]) && $auth_settings[$which_mode][$auth_options[$i]['auth_option']] == ACL_NO) ? ' checked="checked"' : '';

- $selected_unset = (!isset($auth_settings[$which_mode][$auth_options[$i]['auth_option']]) || $auth_settings[$which_mode][$auth_options[$i]['auth_option']] == ACL_UNSET) ? ' checked="checked"' : '';

-

-?>

- <tr>

- <td class="<?php echo $row_class; ?>" nowrap="nowrap"><?php echo $l_auth_option; ?>&nbsp;</td>

- <td class="<?php echo $row_class; ?>" align="center"><input type="radio" name="settings<?php echo $s_auth_option ;?>" value="<?php echo ACL_YES; ?>"<?php echo $selected_yes; ?> /></td>

- <td class="<?php echo $row_class; ?>" align="center"><input type="radio" name="settings<?php echo $s_auth_option ;?>" value="<?php echo ACL_UNSET; ?>"<?php echo $selected_unset; ?> /></td>

- <td class="<?php echo $row_class; ?>" align="center"><input type="radio" name="settings<?php echo $s_auth_option ;?>" value="<?php echo ACL_NO; ?>"<?php echo $selected_no; ?> /></td>

-<?php

-

- if ($which_mode != $mode)

- {

- $selected_ignore = (isset($auth_settings[$which_mode][$auth_options[$i]['auth_option']]) && $auth_settings[$which_mode][$auth_options[$i]['auth_option']] == '*') ? ' checked="checked"' : '';

-

-?>

- <td class="<?php echo $row_class; ?>" align="center"><input type="radio" name="settings<?php echo $s_auth_option ;?>" value="*"<?php echo $selected_ignore; ?> /></td>

-<?php

-

- }

-

-?>

- </tr>

-<?php

-

- }

-

-

- // If we're setting forum or moderator options and a single forum has

- // been selected then look to see if any subforums exist. If they do

- // give user the option of cascading permissions to them

- if (($mode == 'forum' || $mode == 'mod') && empty($submode) && sizeof($forum_id[$which_mode]) == 1)

- {

- $children = get_forum_branch($forum_id[$which_mode][0], 'children', 'descending', false);

-

- if (!empty($children))

- {

-

-?>

- <tr>

- <th colspan="<?php echo $colspan; ?>"><?php echo $user->lang['ACL_SUBFORUMS']; ?></th>

- </tr>

- <tr>

- <td class="row1" colspan="<?php echo $colspan; ?>"><table width="100%" cellspacing="1" cellpadding="0" border="0">

- <tr>

- <td class="gensmall" colspan="4" height="16" align="center"><?php echo $user->lang['ACL_SUBFORUMS_EXPLAIN']; ?></td>

- </tr>

-<?php

-

- foreach ($children as $row)

- {

-

-?>

- <tr>

- <td><input type="checkbox" name="inherit[]" value="<?php echo $row['forum_id']; ?>" /> <?php echo $row['forum_name']; ?></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td height="16" align="center"><a class="gensmall" href="javascript:marklist('inherit', true);"><?php echo $user->lang['MARK_ALL']; ?></a> :: <a href="javascript:marklist('inherit', false);" class="gensmall"><?php echo $user->lang['UNMARK_ALL']; ?></a></td>

- </tr>

- </table></td>

- </tr>

-<?php

-

- }

- }

-

- // Display event/cron radio buttons

- if ($auth->acl_gets('a_events', 'a_cron') && $mode != 'deps' && $submit != 'update')

- {

- $row_class = ($row_class == 'row1') ? 'row2' : 'row1';

-

-?>

- <!-- tr>

- <th colspan="<?php echo $colspan; ?>"><?php echo $user->lang['RUN_HOW']; ?></th>

- </tr>

- <tr>

- <td class="<?php echo $row_class; ?>" colspan="4" align="center"><input type="radio" name="runas" value="now" checked="checked" /> <?php echo $user->lang['RUN_AS_NOW']; ?><?php

-

- if ($auth->acl_get('a_events'))

- {

-

-?> &nbsp;<input type="radio" name="runas" value="evt" /> <?php

-

- echo $user->lang['RUN_AS_EVT'];

- }

-

- if ($auth->acl_get('a_cron'))

- {

-

-?> &nbsp;<input type="radio" name="runas" value="crn" /> <?php

-

- echo $user->lang['RUN_AS_CRN'];

-

- }

-

-?></td>

- </tr -->

-<?php

-

- }

-

-?>

- <tr>

- <td class="cat" colspan="<?php echo $colspan; ?>" align="center"><input class="btnmain" type="submit" name="submit_update" value="<?php echo $user->lang['UPDATE']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="submit" name="submit_cancel" value="<?php echo $user->lang['CANCEL']; ?>" /><input type="hidden" name="ug_type" value="<?php echo $ug_type; ?>" /><?php echo $ug_hidden; ?><?php

-

- // Output forum id data

- echo $s_forum_id;

-

- // Output settings generated from other views

- echo $settings_hidden;

- unset($settings_hidden);

-

-?></td>

- </tr>

- </table>

-

- <br clear="all" />

-

- <table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="4"><?php echo $user->lang['PRESETS']; ?></th>

- </tr>

- <tr>

- <td class="row1" colspan="4"><table width="100%" cellspacing="1" cellpadding="0" border="0">

- <tr>

- <td colspan="2" height="16"><span class="gensmall"><?php echo $user->lang['PRESETS_EXPLAIN']; ?></span></td>

- </tr>

- <tr>

- <td nowrap="nowrap"><?php echo $user->lang['SELECT_PRESET']; ?>: </td>

- <td><select name="presetoption"><option class="sep" value="-1"><?php echo $user->lang['SELECT'] . ' -&gt;'; ?></option><?php

-

- echo $preset_update_options;

-

- ?></select></td>

- </tr>

- <tr>

- <td nowrap="nowrap"><?php echo $user->lang['PRESET_NAME']; ?>: </td>

- <td><input type="text" name="presetname" maxlength="25" /> </td>

- </tr>

- </table></td>

- </tr>

- <tr>

- <td class="cat" colspan="4" align="center"><input class="btnlite" type="submit" name="submit_presetsave" value="<?php echo $user->lang['SAVE']; ?>" /> &nbsp;<input class="btnlite" type="submit" name="submit_presetdel" value="<?php echo $user->lang['DELETE']; ?>" /></td>

- </tr>

- </table></td>

- </tr>

-</table></form>

-

-<?php

-

-}

-

-// Output page footer

-adm_page_footer();

-

-// ---------

-// FUNCTIONS

-//

-function update_foes()

-{

- global $db, $auth;

-

- $perms = array();

- foreach ($auth->acl_get_list(false, array('a_', 'm_'), false) as $forum_id => $forum_ary)

- {

- foreach ($forum_ary as $auth_option => $user_ary)

- {

- $perms += $user_ary;

- }

- }

-

- if (sizeof($perms))

- {

- $sql = 'DELETE FROM ' . ZEBRA_TABLE . '

- WHERE zebra_id IN (' . implode(', ', $perms) . ')';

- $db->sql_query($sql);

- }

- unset($perms);

-}

-//

-// FUNCTIONS

-// ---------

-

-?> \ No newline at end of file

-<?php

-/**

-*

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-*/

-if (!empty($setmodules))

-{

- if (!$auth->acl_get('a_search'))

- {

- return;

- }

-

- $module['DB']['SEARCH_INDEX'] = basename(__FILE__) . $SID;

-

- return;

-}

-

-define('IN_PHPBB', 1);

-// Include files

-$phpbb_root_path = '../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

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

-include($phpbb_root_path . 'includes/message_parser.'.$phpEx);

-

-// Check permissions

-if (!$auth->acl_get('a_search'))

-{

- trigger_error($user->lang['NO_ADMIN']);

-}

-

-// Start indexing

-if (isset($_POST['start']) || isset($_GET['batchstart']))

-{

- $batchsize = 5000; // Process this many posts per batch

- $batchcount = request_var('batchcount', 1);

- $batchstart = request_var('batchstart', 0);

- $loopcount = 0;

-

- $fulltext = new fulltext_search();

-

- // Search re-indexing is tough on the server ... so we'll check the load

- // each loop and if we're on a 1min load of 3 or more we'll re-load the page

- // and try again. No idea how well this will work in practice so we'll see ...

- if (file_exists('/proc/loadavg'))

- {

- if ($load = @file('/proc/loadavg'))

- {

- list($load) = explode(' ', $load[0]);

-

- if ($load > 3)

- {

- redirect("adm/admin_search.$phpEx$SID&batchstart=$batchstart&batchcount=$batchcount", 3);

- }

- }

- }

-

- if (!$batchstart)

- {

- // Take board offline

- set_config('board_disable', 1);

-

- // Empty existing tables

- $db->sql_query("TRUNCATE " . SEARCH_TABLE);

- $db->sql_query("TRUNCATE " . SEARCH_WORD_TABLE);

- $db->sql_query("TRUNCATE " . SEARCH_MATCH_TABLE);

- }

-

- // Fetch a batch of posts_text entries

- $sql = "SELECT COUNT(*) AS total, MAX(post_id) AS max_post_id, MIN(post_id) AS min_post_id

- FROM " . POSTS_TABLE;

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

-

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

- $totalposts = $row['total'];

- $max_post_id = $row['max_post_id'];

-

- $batchstart = (!$batchstart) ? $row['min_post_id'] : $batchstart;

- $batchend = $batchstart + $batchsize;

-

- $db->sql_freeresult($result);

-

- $sql = "SELECT *

- FROM " . POSTS_TABLE . "

- WHERE post_id

- BETWEEN $batchstart

- AND $batchend";

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

-

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

- {

- do

- {

- $fulltext->add('admin', $row['post_id'], $row['post_text'], $row['post_subject']);

- }

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

- }

-

- $db->sql_freeresult($result);

-

- $batchcount++;

-

- if (($batchstart + $batchsize) < $max_post_id)

- {

- redirect("adm/admin_search.$phpEx$SID&batchstart=" . ($batchstart + $batchsize) . "&batchcount=$batchcount", 3);

- }

- else

- {

- set_config('board_disable', 0);

-

- // search tidy

- $fulltext->search_tidy();

-

- adm_page_header($user->lang['SEARCH_INDEX']);

-

-?>

-

-<h1><?php echo $user->lang['SEARCH_INDEX']; ?></h1>

-

-<p><?php echo $user->lang['SEARCH_INDEX_COMPLETE']; ?></p>

-

-<?php

-

- adm_page_footer();

-

- }

-

- exit;

-

-}

-else if (isset($_POST['cancel']))

-{

- set_config('board_disable', 0);

- adm_page_header($user->lang['SEARCH_INDEX']);

-

-?>

-

-<h1><?php echo $user->lang['SEARCH_INDEX']; ?></h1>

-

-<p><?php echo $user->lang['SEARCH_INDEX_CANCEL']; ?></p>

-

-<?php

-

- adm_page_footer();

-

-}

-else

-{

- adm_page_header($user->lang['SEARCH_INDEX']);

-

-?>

-

-<h1><?php echo $user->lang['SEARCH_INDEX']; ?></h1>

-

-<p><?php echo $user->lang['SEARCH_INDEX_EXPLAIN']; ?></p>

-

-<form method="post" action="<?php echo "admin_search.$phpEx$SID"; ?>"><table cellspacing="1" cellpadding="4" border="0" align="center" bgcolor="#98AAB1">

- <tr>

- <td class="cat" height="28" align="center">&nbsp;<input type="submit" name="start" value="<?php echo $user->lang['START']; ?>" class="btnmain" /> &nbsp; <input type="submit" name="cancel" value="<?php echo $user->lang['CANCEL']; ?>" class="btnmain" />&nbsp;</td>

- </tr>

-</table></form>

-

-<?php

-

- adm_page_footer();

-

-}

-

-?> \ No newline at end of file

-<?php

-/**

-*

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-*/

-

-// TODO

-// For M-3

-// BBCode support

-// Replace template/s, stylesheet, images, etc.

-// Previews of templates, imagesets, themes ... unified

-// Security review

-

-// BUGS

-// Editing template -> store in DB -> some kind of failure

-

-if (!empty($setmodules))

-{

- if (!$auth->acl_get('a_styles'))

- {

- return;

- }

-

- $filename = basename(__FILE__);

- $module['STYLE']['MANAGE_STYLE'] = "$filename$SID&amp;mode=style";

- $module['STYLE']['MANAGE_TEMPLATE'] = "$filename$SID&amp;mode=template";

- $module['STYLE']['MANAGE_THEME'] = "$filename$SID&amp;mode=theme";

- $module['STYLE']['MANAGE_IMAGESET'] = "$filename$SID&amp;mode=imageset";

-

- return;

-}

-

-define('IN_PHPBB', 1);

-// Include files

-$phpbb_root_path = '../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

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

-

-// Do we have styles admin permissions?

-if (!$auth->acl_get('a_styles'))

-{

- trigger_error($user->lang['NO_ADMIN']);

-}

-

-

-// Get some vars

-$update = (isset($_POST['update'])) ? true : false;

-$mode = (isset($_REQUEST['mode'])) ? htmlspecialchars($_REQUEST['mode']) : '';

-$id = (isset($_REQUEST['id'])) ? intval($_REQUEST['id']) : '';

-

-if (isset($_REQUEST['action']))

-{

- $action = htmlspecialchars($_REQUEST['action']);

-}

-else

-{

- $action = '';

- if (isset($_POST['add']))

- {

- $action = 'add';

- }

- else if (isset($_POST['preview']))

- {

- $action = 'preview';

- }

-}

-

-// Set some basic vars

-$error = $cfg = array();

-

-$safe_mode = (@ini_get('safe_mode') || @strtolower(ini_get('safe_mode')) == 'on') ? true : false;

-$file_uploads = (@ini_get('file_uploads') || strtolower(@ini_get('file_uploads')) == 'on') ? true : false;

-

-// Generate list of archive types inc. regexp | match

-$archive_types = '<u>.tar</u>';

-$archive_preg = '\.tar';

-foreach (array('tar.gz' => 'zlib', 'tar.bz2' => 'bz2', 'zip' => 'zlib') as $type => $module)

-{

- if (!@extension_loaded($module))

- {

- continue;

- }

- $archive_types .= ", <u>.$type</u>";

- $archive_preg .= '|\.' . preg_quote($type);

-}

-

-// --------------------

-// Start program proper

-// --------------------

-

-// Mode indepedent actions

-switch ($action)

-{

- case 'export':

- if ($id)

- {

- export($mode, $id);

- }

- break;

-

- case 'add':

- case 'install':

- case 'details':

- install($mode, $action, $id);

- break;

-

- case 'delete':

- if ($id)

- {

- remove($mode, $id);

- }

- break;

-}

-

-// Mode based actions

-switch ($mode)

-{

- // STYLES

- case 'style':

- switch ($action)

- {

- case 'activate':

- case 'deactivate':

- if ($id == $config['default_style'])

- {

- trigger_error($user->lang['DEACTIVATE_DEFAULT']);

- }

-

- $sql = 'UPDATE ' . STYLES_TABLE . '

- SET style_active = ' . (($action == 'activate') ? 1 : 0) . '

- WHERE style_id = ' . $id;

- $db->sql_query($sql);

-

- // Set style to default for any member using deactivated style

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET user_style = ' . $config['default_style'] . "

- WHERE user_style = $id";

- $db->sql_query($sql);

- break;

- }

-

- frontend('style', array('delete', 'export'));

- break;

-

-

- // TEMPLATES

- case 'template':

- $tpllist = array(

- 'misc' => array(

- 'confirm_body.html', 'faq_body.html', 'index_body.html', 'message_body.html', 'viewonline_body.html',

- ),

- 'includes' => array(

- 'overall_footer.html', 'overall_header.html', 'simple_footer.html', 'simple_header.html', 'searchbox.html', 'jumpbox.html',

- ),

- 'forum' => array(

- 'viewforum_body.html', 'viewforum_subforum.html',

- ),

- 'topic' => array(

- 'attachment.html', 'viewtopic_body.html', 'viewtopic_print.html',

- ),

- 'group' => array(

- 'gcp_body.html', 'gcp_pending_info.html', 'gcp_user_body.html',

- ),

- 'user' => array(

- 'ucp_agreement.html', 'ucp_footer.html', 'ucp_header.html', 'ucp_main.html', 'ucp_pm_body.html', 'ucp_pm_popup.html', 'ucp_pm_preview.html', 'ucp_pm_read.html', 'ucp_prefs.html', 'ucp_profile.html', 'ucp_register.html', 'ucp_remind.html',

- ),

- 'profile' => array(

- 'memberlist_body.html', 'memberlist_email.html', 'memberlist_im.html', 'memberlist_view.html',

- ),

- 'mod' => array(

- 'mcp_forum.html', 'mcp_foruminfo.html', 'mcp_front.html', 'mcp_header.html', 'mcp_jumpbox.html', 'mcp_move.html', 'mcp_post.html', 'mcp_queue.html', 'mcp_reports.html', 'mcp_topic.html', 'mcp_viewlogs.html', 'report_body.html',

- ),

- 'search' => array(

- 'search_body.html', 'search_results_posts.html', 'search_results_topics.html',

- ),

- 'posting' => array(

- 'posting_attach_body.html', 'posting_body.html', 'posting_poll_body.html', 'posting_preview.html', 'posting_smilies.html', 'posting_topic_review.html',

- ),

- 'login' => array(

- 'login_body.html', 'login_forum.html',

- ),

- 'custom' => array(),

- );

-

- // Lights, Camera ...

- switch ($action)

- {

- case 'edit':

- $tplcols = (isset($_POST['tplcols'])) ? max(20, intval($_POST['tplcols'])) : 80;

- $tplrows = (isset($_POST['tplrows'])) ? max(5, intval($_POST['tplrows'])) : 20;

- $tplname = (isset($_POST['tplname'])) ? htmlspecialchars($_POST['tplname']) : '';

- $tpldata = (!empty($_POST['tpldata'])) ? stripslashes($_POST['tpldata']) : ''; // NB : STRIPSLASHED!

-

- if ($id)

- {

- $sql = 'SELECT *

- FROM ' . STYLES_TPL_TABLE . "

- WHERE template_id = $id";

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

-

- if (!(extract($db->sql_fetchrow($result))))

- {

- trigger_error($user->lang['NO_TEMPLATE']);

- }

- $db->sql_freeresult($result);

-

- // User wants to submit data ...

- if ($update)

- {

- // Where is the template stored?

- if (!$template_storedb && is_writeable("{$phpbb_root_path}styles/$template_path/template/$tplname"))

- {

- if (!($fp = fopen("{$phpbb_root_path}styles/$template_path/template/$tplname", 'wb')))

- {

- trigger_error($user->lang['NO_TEMPLATE']);

- }

- $stylesheet = fwrite($fp, $tpldata);

- fclose($fp);

- }

- else

- {

- $db->sql_transaction('begin');

-

- if (!$template_storedb)

- {

- // We change the path to one relative to the root rather than the theme folder

- $sql = 'UPDATE ' . STYLES_TPL_TABLE . '

- SET template_storedb = 1

- WHERE template_id = ' . $id;

- $db->sql_query($sql);

-

- $filelist = filelist("{$phpbb_root_path}styles/$template_path/template");

- $filelist = array('/template' => $filelist['']);

- store_templates('insert', $id, $template_path, $filelist);

- }

-

- $sql = 'UPDATE ' . STYLES_TPLDATA_TABLE . "

- SET template_data = '" . $db->sql_escape($tpldata) . "', template_mtime = " . time() . "

- WHERE template_id = $id

- AND template_filename = '" . $db->sql_escape($tplname) . "'";

- $db->sql_query($sql);

-

- $db->sql_transaction('commit');

- }

-

- @unlink("{$phpbb_root_path}cache/tpl_{$template_name}_$tplname.$phpEx");

-

- $error[] = $user->lang['TEMPLATE_UPDATED'];

- add_log('admin', 'LOG_EDIT_TEMPLATE', $template_name, $tplname);

- }

-

- $test_ary = array();

- foreach ($tpllist as $category => $tpl_ary)

- {

- $test_ary = array_merge($test_ary, $tpl_ary);

- }

-

- if (!$template_storedb)

- {

- $dp = @opendir("{$phpbb_root_path}styles/$template_path/template");

- while ($file = readdir($dp))

- {

- if (!strstr($file, 'bbcode.') && strstr($file, '.html') && !in_array($file, $test_ary) && is_file("{$phpbb_root_path}styles/$template_path/template/$file"))

- {

- $tpllist['custom'][] = $file;

- }

- }

- closedir($dp);

- unset($matches);

- unset($test_ary);

-

- if ($tplname)

- {

- if (!($fp = fopen("{$phpbb_root_path}styles/$template_path/template/$tplname", 'r')))

- {

- trigger_error($user->lang['NO_TEMPLATE']);

- }

- $tpldata = fread($fp, filesize("{$phpbb_root_path}styles/$template_path/template/$tplname"));

- fclose($fp);

- }

-

- }

- else

- {

- $sql = 'SELECT *

- FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $id";

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

-

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

- {

- if (!strstr($row['template_filename'], 'bbcode.') && !in_array($row['template_filename'], $test_ary))

- {

- $tpllist['custom'][] = $row['template_filename'];

- }

-

- if ($row['template_filename'] == $tplname)

- {

- $tpldata = $row['template_data'];

- }

- }

- $db->sql_freeresult($result);

- }

-

- // List of included templates

- if ($tplname)

- {

- preg_match_all('#<!\-\- INCLUDE (.*?) \-\->#', $tpldata, $included_tpls);

- $included_tpls = $included_tpls[1];

- }

- }

- unset($test_ary);

-

- // Generate list of template options

- $tpl_options = '';

- ksort($tpllist);

- foreach ($tpllist as $category => $tpl_ary)

- {

- sort($tpl_ary);

- $tpl_options .= '<option class="sep">' . $category . '</option>';

-

- foreach ($tpl_ary as $tpl_file)

- {

- $selected = ($tpl_file == $tplname) ? ' selected="selected"' : '';

- $tpl_options .= '<option value="' . $tpl_file . '"' . $selected . '>' . (($category == 'custom') ? $tpl_file : $tpl_file) . '</option>';

- }

- }

-

- // Output page

- adm_page_header($user->lang['EDIT_TEMPLATE']);

-

-?>

-

-<h1><?php echo $user->lang['EDIT_TEMPLATE']; ?></h1>

-

-<p><?php echo $user->lang['EDIT_TEMPLATE_EXPLAIN']; ?></p>

-

-<p><?php echo $user->lang['SELECTED_TEMPLATE'] . ": <b>$template_name</b>"; ?></p>

-

-<form name="style" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;id=$template_id&amp;action=$action"; ?>"><table cellspacing="1" cellpadding="1" border="0" align="center">

- <tr>

- <td align="right"><?php echo $user->lang['SELECT_TEMPLATE']; ?>: <select name="tplname" onchange="if (this.options[this.selectedIndex].value != '') this.form.submit();"><?php echo $tpl_options; ?></select>&nbsp; <input class="btnlite" type="submit" value="<?php echo $user->lang['SELECT']; ?>" tabindex="100" /></td>

- </tr>

- <tr>

- <td><table class="bg" cellspacing="1" cellpadding="4" border="0">

- <tr>

- <td class="cat"><?php echo $user->lang['TEXT_COLUMNS']; ?>: <input class="post" type="text" name="tplcols" size="3" maxlength="3" value="<?php echo $tplcols; ?>" /> &nbsp;<?php echo $user->lang['TEXT_ROWS']; ?>: <input class="post" type="text" name="tplrows" size="3" maxlength="3" value="<?php echo $tplrows; ?>" />&nbsp; <input class="btnlite" type="submit" value="<?php echo $user->lang['UPDATE']; ?>" /></td>

- </tr>

-<?php

-

- if (sizeof($error))

- {

-

-?>

- <tr>

- <td class="row1" style="color:green" align="center"><?php echo implode('<br />', $error); ?></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <th><?php echo $user->lang['RAW_HTML']; ?></th>

- </tr>

- <tr>

- <td class="row2" align="center"><textarea class="post" style="font-family:'Courier New', monospace;font-size:9pt;line-height:125%;" cols="<?php echo $tplcols; ?>" rows="<?php echo $tplrows; ?>" name="tpldata"><?php echo htmlspecialchars($tpldata); ?></textarea></td>

- </tr>

- <tr>

- <td class="cat" align="center"><input class="btnlite" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

- </tr>

- </table></td>

- </tr>

-</table></form>

-

-<?php

-

- adm_page_footer();

- break;

-

- case 'cache':

- $source = (!empty($_GET['source'])) ? htmlspecialchars($_GET['source']) : '';

- $file_ary = (!empty($_POST['delete'])) ? array_map('htmlspecialchars', $_POST['delete']) : '';

-

- $sql = 'SELECT *

- FROM ' . STYLES_TPL_TABLE . "

- WHERE template_id = $id";

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

-

- if (!(extract($db->sql_fetchrow($result))))

- {

- trigger_error($user->lang['NO_TEMPLATE']);

- }

- $db->sql_freeresult($result);

-

- $cache_prefix = "tpl_$template_path";

-

- // User wants to delete one or more files ...

- if ($_POST['update'] && $file_ary)

- {

- foreach ($file_ary as $file)

- {

- $file = "{$phpbb_root_path}cache/{$cache_prefix}_$file.html.$phpEx";

- if (file_exists($file) && is_file($file))

- {

- @unlink($file);

- }

- }

- unset($file_ary);

-

- add_log('admin', 'LOG_CLEAR_TPLCACHE', $template_name);

- trigger_error($user->lang['TEMPLATE_CACHE_CLEARED']);

- }

-

- // Someone wants to see the cached source ... so we'll highlight it,

- // add line numbers and indent it appropriately. This could be nasty

- // on larger source files ...

- if ($source && file_exists("{$phpbb_root_path}cache/{$cache_prefix}_$source.html.$phpEx"))

- {

-

- adm_page_header($user->lang['TEMPLATE_CACHE']);

-

-?>

-

-<h1><?php echo $_GET['source']; ?></h1>

-

-<?php

-

- $marker = time();

- $code = implode("$marker", file("{$phpbb_root_path}cache/{$cache_prefix}_$source.html.$phpEx"));

-

- $conf = array('highlight.bg', 'highlight.comment', 'highlight.default', 'highlight.html', 'highlight.keyword', 'highlight.string');

- foreach ($conf as $ini_var)

- {

- @ini_set($ini_var, str_replace('highlight.', 'syntax', $ini_var));

- }

-

- ob_start();

- highlight_string($code);

- $code = ob_get_contents();

- ob_end_clean();

-

- $str_from = array('<font color="syntax', '</font>', '<code>', '</code>','[', ']', '.');

- $str_to = array('<span class="syntax', '</span>', '', '', '&#91;', '&#93;', '&#46;');

-

- if ($remove_tags)

- {

- $str_from[] = '<span class="syntaxdefault">&lt;?php&nbsp;</span>';

- $str_to[] = '';

- $str_from[] = '<span class="syntaxdefault">&lt;?php&nbsp;';

- $str_to[] = '<span class="syntaxdefault">';

- $str_from[] = '<span class="syntaxdefault">?&gt;</span>';

- $str_to[] = '';

- }

-

- $code = str_replace($str_from, $str_to, $code);

- $code = preg_replace('#^(<span class="[a-z_]+">)\n?(.*?)\n?(</span>)$#is', '\1\2\3', $code);

- $code = explode("$marker", $code);

-

-?>

-

-<table width="95%" cellspacing="0" cellpadding="0" border="0" align="center">

-<?php

-

- $i = $j = 1;

- $length = strlen(sizeof($code));

- $indent = str_repeat('&nbsp;', $length);

- foreach ($code as $key => $line)

- {

-

-?>

- <tr valign="top">

- <td class="sourcenum" align="right"><?php echo $i; ?>&nbsp;&nbsp;</td>

- <td class="source"><?php

-

- echo $indent . $line;

- $i++;

- if (strlen($i) > $j)

- {

- $indent = substr($indent, 0, -6);

- $j++;

- }

- unset($code[$key]);

-

-?></td>

- </tr>

-<?php

-

- }

-

-?>

-</table>

-

-<br clear="all" />

-

-<?php

-

- adm_page_footer();

- }

-

- if ($template_storedb)

- {

- $sql = 'SELECT template_filename, template_mtime

- FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $template_id";

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

-

- $filemtime = array();

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

- {

- $filemtime[$row['template_filename']] = $row['template_mtime'];

- }

- $db->sql_freeresult($result);

- }

-

- // Open the cache directory and grab a list of the relevant cached templates.

- // We also grab some other details such as when the compiled template was

- // created, when the original template was modified and the cached filesize

- if (!($dp = @opendir("{$phpbb_root_path}cache")))

- {

- trigger_error($user->lang['ERR_TPLCACHE_READ']);

- }

-

- $tplcache_ary = array();

- while ($file = readdir($dp))

- {

- if (is_file($phpbb_root_path . 'cache/' . $file) && strstr($file, $cache_prefix))

- {

- $filename = preg_replace('#^' . $cache_prefix . '_(.*?)\.html\.' . $phpEx . '$#i', '\1', $file);

- $tplcache_ary[$filename]['cache'] = filemtime("{$phpbb_root_path}cache/$file");

- $tplcache_ary[$filename]['size'] = filesize("{$phpbb_root_path}cache/$file");

- $tplcache_ary[$filename]['src'] = (!$template_storedb) ? filemtime("{$phpbb_root_path}styles/$template_path/template/$filename.html") : $filemtime[$filename . '.html'] ;

- }

- }

- closedir($dp);

-

- // Output the page

- adm_page_header($user->lang['TEMPLATE_CACHE']);

-

-?>

-

-<script language="Javascript" type="text/javascript">

-<!--

-function marklist(match, status)

-{

- len = eval('document.' + match + '.length');

- for (i = 0; i < len; i++)

- {

- eval('document.' + match + '.elements[i].checked = ' + status);

- }

-}

-

-function viewsource(url)

-{

- window.open(url, '_source', 'HEIGHT=550,resizable=yes,scrollbars=yes,WIDTH=750');

- return false;

-}

-

-//-->

-</script>

-

-<h1><?php echo $user->lang['TEMPLATE_CACHE']; ?></h1>

-

-<p><?php echo $user->lang['TEMPLATE_CACHE_EXPLAIN']; ?></p>

-

-<form name="tplcache" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=$action&amp;id=$template_id"; ?>"><table class="bg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th nowrap="nowrap"><?php echo $user->lang['CACHE_FILENAME']; ?></th>

- <th nowrap="nowrap"><?php echo $user->lang['CACHE_FILESIZE']; ?></th>

- <th nowrap="nowrap"><?php echo $user->lang['CACHE_CACHED']; ?></th>

- <th nowrap="nowrap"><?php echo $user->lang['CACHE_MODIFIED']; ?></th>

- <th width="1%"><?php echo $user->lang['MARK']; ?></th>

- </tr>

-<?php

-

- if (sizeof($tplcache_ary))

- {

- foreach ($tplcache_ary as $filename => $times_ary)

- {

- $row_class = ($row_class != 'row1') ? 'row1' : 'row2';

-

-?>

- <tr>

- <td class="<?php echo $row_class; ?>" nowrap="nowrap"><a href="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=$action&amp;id=$template_id&amp;source=$filename"; ?>" onclick="viewsource('<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=$action&amp;id=$template_id&amp;source=$filename"; ?>');return false"><?php echo $filename; ?></a></td>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap"><?php echo sprintf('%.1f KB', $times_ary['size'] / 1024); ?></td>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap"><?php echo $user->format_date($times_ary['cache']); ?></td>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap"><?php echo $user->format_date($times_ary['src']); ?></td>

- <td class="<?php echo $row_class; ?>" width="1%" align="center"><input type="checkbox" name="delete[]" value="<?php echo $filename; ?>" /></td>

- </tr>

-<?php

-

- }

- }

- else

- {

-

-?>

- <tr>

- <td class="row1" colspan="5" align="center"><?php echo $user->lang['NO_CACHED_TPL_FILES']; ?></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="cat" colspan="5" align="right"><input class="btnlite" type="submit" name="update" value="<?php echo $user->lang['DELETE_MARKED']; ?>" /></td>

- </tr>

-</table>

-

-<table width="95%" cellspacing="1" cellpadding="1" border="0" align="center">

- <tr>

- <td align="right"><b><span class="gensmall"><a href="javascript:marklist('tplcache', true);" class="gensmall"><?php echo $user->lang['MARK_ALL']; ?></a> :: <a href="javascript:marklist('tplcache', false);" class="gensmall"><?php echo $user->lang['UNMARK_ALL']; ?></a></span></b></td>

- </tr>

-</table></form>

-<?php

-

- adm_page_footer();

- break;

-

- case 'refresh':

- if ($id)

- {

- $sql = 'SELECT template_path, template_storedb

- FROM ' . STYLES_TPL_TABLE . "

- WHERE template_id = $id";

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

-

- if (!extract($db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_TEMPLATE']);

- }

- $db->sql_freeresult($result);

-

- if ($template_storedb && file_exists("{$phpbb_root_path}styles/$template_path/template/"))

- {

- $filelist = array('/' => array());

-

- $sql = 'SELECT template_filename, template_mtime

- FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $id";

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

-

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

- {

- if (@filemtime("{$phpbb_root_path}styles/$template_path/template/" . $row['template_filename']) > $row['template_mtime'])

- {

- $filelist['/'][] = $row['template_filename'];

- }

- }

- $db->sql_freeresult($result);

-

- store_templates('update', $id, $template_path, $filelist);

- unset($filelist);

- }

- }

- break;

- }

-

- // Front page

- frontend('template', array('cache', 'details', 'refresh', 'export', 'delete'));

- break;

-

-

- // THEMES

- case 'theme':

- switch ($action)

- {

- case 'edit':

- // General parameters

- $class = (isset($_POST['classname'])) ? htmlspecialchars($_POST['classname']) : '';

- $customclass = (!empty($_POST['customclass'])) ? htmlspecialchars($_POST['customclass']) : '';

-

- $txtcols = (isset($_POST['txtcols'])) ? max(20, intval($_POST['txtcols'])) : 76;

- $txtrows = (isset($_POST['txtrows'])) ? max(5, intval($_POST['txtrows'])) : 10;

- $showcss = (!empty($_POST['showcss'])) ? true : ((!empty($_POST['hidecss'])) ? false : ((!empty($_GET['showcss'])) ? true : false));

-

- // List of default classes, categorised

- $base_classes = array(

- 'text' => array(

- 'body', 'p', 'h1', 'h2', 'h3', '.tabletitle', '.cattitle', '.topictitle', '.topicauthor', '.topicdetails', '.postdetails', '.postbody', '.posthilit', '.postauthor', '.mainmenu', '.nav', '.genmed', '.gensmall', '.copyright',

- ),

- 'tables' => array(

- 'table', 'th', '.cat', '.catdiv', 'td', '.row1', '.row2', '.row3', '.spacer', 'hr',

- ),

- 'forms' => array(

- 'form', 'input', 'select', 'textarea', '.post', '.btnlite', '.btnmain', '.btnbbcode',

- ),

- 'bbcode' => array(

- '.b', '.u', '.i', '.color', '.size', '.code', '.quote', '.flash', '.syntaxbg', '.syntaxcomment', '.syntaxdefault', '.syntaxhtml', '.syntaxkeyword', '.syntaxstring',

- ),

- 'custom' => array(),

- );

-

- // We categorise the elements which comprise the css class so that we set

- // any appropriate additional data, e.g. sizes require the scale type to be set,

- // images require the relevant image be pulled and selected in the dropdown, etc.

- $match_elements = array(

- 'colors' => array('background-color', 'color',),

- 'sizes' => array('font-size', 'line-height',),

- 'images' => array('background-image',),

- 'repeat' => array('background-repeat',),

- 'other' => array('font-weight', 'font-family', 'font-style', 'text-decoration',),

- );

-

- // Used in an sprintf statement to generate appropriate output for rawcss mode

- $map_elements = array(

- 'colors' => '%s',

- 'sizes' => '%d%s',

- 'images' => 'url(\'./%s\')',

- 'repeat' => '%s',

- 'other' => '%s',

- );

-

- $s_hidden_fields = '';

-

- // Do we want to edit an existing theme?

- if ($id)

- {

- $sql = 'SELECT *

- FROM ' . STYLES_CSS_TABLE . "

- WHERE theme_id = $id";

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

-

- if (!(extract($db->sql_fetchrow($result))))

- {

- trigger_error($user->lang['NO_THEME']);

- }

- $db->sql_freeresult($result);

-

-

- // Where is the CSS stored?

- if (!$theme_storedb)

- {

- if (!($fp = fopen("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css", 'rb')))

- {

- trigger_error($user->lang['NO_THEME']);

- }

- $stylesheet = fread($fp, filesize("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css"));

- fclose($fp);

- }

- else

- {

- $stylesheet = &$theme_data;

- }

-

- // Pull out list of "custom" tags

- $class_used = $test_ary = array();

- if (preg_match_all('/^([a-z0-9\.:#>]+?)[ \t]*?\{.*?\}/msi', $stylesheet, $matches))

- {

- foreach ($base_classes as $category => $class_ary)

- {

- $test_ary = array_merge($test_ary, $class_ary);

- }

-

- foreach ($matches[1] as $value)

- {

- if (!in_array($value, $test_ary))

- {

- $base_classes['custom'][] = $value;

- }

- else

- {

- $class_used[] = $value;

- }

- }

- unset($matches);

- unset($test_ary);

- }

- }

-

- // Do we have a class set? If so, we need to extract and set the relevant data

- if (!empty($class))

- {

- // We must generate the relevant data ... what we need depends on whether

- // we are looking @ the rawcss or the simplified settings and whether we

- // have just selected a class. We must also cope with switching between

- // simple and rawcss mode

- $css_element = array();

- if (!empty($_POST['rawcss']) && (!empty($_POST['hidecss']) || !empty($_POST['preview']) || $update))

- {

- $css_element = trim(stripslashes(htmlspecialchars(preg_replace("#;[\r\n]*#s", "\n", $_POST['rawcss']))));

- $css_element = explode("\n", $css_element);

- }

- else if (($showcss && !empty($_POST['showcss'])) || !empty($_POST['preview']) || $update)

- {

- if (!empty($_POST['cssother']))

- {

- $css_element = explode(';', stripslashes(htmlspecialchars(trim($_POST['cssother']))));

- }

-

- foreach ($match_elements as $type => $match_ary)

- {

- foreach ($match_ary as $match)

- {

- $var = str_replace('-', '_', $match);

- if (!empty($_POST[$var]))

- {

- $css_element[] = str_replace('_', '-', $var) . ': ' . (($type == 'sizes') ? sprintf($map_elements[$type], stripslashes($_POST[$var]), $_POST[$var . '_units']) : sprintf($map_elements[$type], stripslashes($_POST[$var])));

- }

- }

- }

- }

- else if (preg_match('#^' . $class . '[ \t]*?\{(.*?)\}#ms', $stylesheet, $matches))

- {

- $css_element = explode(';', substr(trim($matches[1]), 0, -1));

- }

-

- $css_element = preg_replace('#^\s*(.*?)\s*$#', '\1', $css_element);

-

- // User wants to submit data ...

- if ($update || $customclass)

- {

- if ($update)

- {

- $updated_element = trim(implode('; ', $css_element)) . ';';

- if (preg_match('#^' . $class . '[ \t]*?\{(.*?)\}#ms', $stylesheet))

- {

- $stylesheet = preg_replace('#^(' . $class . '[ \t]*?\{).*?(\})#m', '\1 ' . $updated_element . ' \2', $stylesheet);

- }

- $error[] = $user->lang['THEME_UPDATED'];

- }

- else

- {

- // Check custom class name is valid

- if (!preg_match('/^[a-z0-9#:\.]+$/i', $customclass))

- {

- $error[] = $user->lang['THEME_ERR_CLASS_CHARS'];

- }

- else

- {

- $stylesheet .= "\n$customclass { }";

- $base_classes['custom'][] = $customclass;

- $error[] = $user->lang['THEME_CLASS_ADDED'];

- }

- }

-

- // Where is the CSS stored?

- if (!$storedb && is_writeable("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css"))

- {

- // Grab template data

- if (!($fp = fopen("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css", 'wb')))

- {

- trigger_error($user->lang['NO_THEME']);

- }

- $stylesheet = fwrite($fp, $stylesheet);

- fclose($fp);

- }

- else

- {

- // We change the path to one relative to the root rather than the theme folder

- $sql_ary = array(

- 'theme_storedb' => 1,

- 'theme_data' => str_replace('./', "styles/$theme_path/theme/", $stylesheet),

- );

- $sql = 'UPDATE ' . STYLES_CSS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

- WHERE theme_id = ' . $id;

- $db->sql_query($sql);

- }

-

- $cache->destroy('sql', STYLES_CSS_TABLE);

- add_log('admin', 'LOG_EDIT_THEME', $theme_name);

- }

-

- // I guess really this needs some basic examples, pulled from subSilver

- // to demonstrate the default classes. Other, custom classes can just use

- // the div/span and some text? This is gonna get nasty :(

- if (!empty($_POST['preview']))

- {

- // Temp, just to get this out of the way

- theme_preview($theme_path, $stylesheet, $class, $css_element);

- exit;

- }

-

- // Here we pull out the appropriate class entry then proceed to pull it apart,

- // setting appropriate variables to their respective values. We only match

- // certain css elements, the rest are "hidden" and can be accessed by exposing

- // the raw css

- if (!$showcss)

- {

- foreach ($match_elements as $type => $match_ary)

- {

- foreach ($match_ary as $match)

- {

- $var = str_replace('-', '_', $match);

- $$var = '';

-

- if (sizeof($css_element))

- {

- foreach ($css_element as $key => $element)

- {

- if (preg_match('#^' . preg_quote($match, '#') . ':[ \t]*?(.*?)$#', $element, $matches))

- {

- switch ($type)

- {

- case 'sizes':

- if (preg_match('#(.*?)(px|%|em|pt)#', $matches[1], $matches))

- {

- ${$var . '_units'} = trim($matches[2]);

- }

- $$var = trim($matches[1]);

- break;

-

- case 'images':

- if (preg_match('#url\(\'(.*?)\'\)#', $matches[1], $matches))

- {

- $$var = trim($matches[1]);

- $$var = str_replace('./', $theme_name . '/', $$var);

- }

- break;

-

- default:

- $$var = trim($matches[1]);

- }

-

- // Remove this element from array

- unset($css_element[$key]);

- break;

- }

- }

- }

- }

- }

-

- // Any remaining elements must be custom data so we save that

- // in a hidden field

- if (sizeof($css_element))

- {

- $s_hidden_fields .= '<input type="hidden" name="cssother" value="' . addslashes(implode('; ', $css_element)) . '" />';

- }

- }

- }

- // End of class element variable setting

-

- // Generate list of class options

- $class_options = '';

- foreach ($base_classes as $category => $class_ary)

- {

- $class_options .= '<option class="sep">' . $user->lang['CSS_CAT_' . strtoupper($category)] . '</option>';

- foreach ($class_ary as $class_name)

- {

- $used = (in_array($class_name, $class_used) || $category == 'custom') ? ' style="color:red"' : '';

- $selected = ($class_name == $class) ? ' selected="selected"' : '';

- $class_options .= '<option' . $used . ' value="' . $class_name . '"' . $selected . '>' . (($category == 'custom') ? $class_name : $user->lang['CSS_' . str_replace('.', '', strtoupper($class_name))]) . '</option>';

- }

- }

- unset($class_used);

-

- // Grab list of potential images for class backgrounds

- $imglist = filelist("{$phpbb_root_path}styles/$theme_path/theme");

-

- $bg_imglist = '';

- foreach ($imglist as $path => $img_ary)

- {

- foreach ($img_ary as $img)

- {

- $img = ((substr($path, 0, 1) == '/') ? substr($path, 1) : $path) . $img;

-

- $selected = (preg_match('#' . preg_quote($img) . '$#', $background_image)) ? ' selected="selected"' : '';

- $bg_imglist .= '<option value="' . htmlspecialchars($img) . '"' . $selected . '>' . $img . '</option>';

- }

- }

- $bg_imglist = '<option value=""' . (($edit_img == '') ? ' selected="selected"' : '') . '>' . $user->lang['NONE'] . '</option>' . $bg_imglist;

- unset($imglist);

-

- // Output the page

- adm_page_header($user->lang['EDIT_THEME']);

-

-?>

-

-<script language="javascript" type="text/javascript">

-<!--

-

-function swatch(field)

-{

- window.open('./swatch.<?php echo "$phpEx?form=style&name="; ?>' + field, '_swatch', 'HEIGHT=115,resizable=yes,scrollbars=no,WIDTH=636');

- return false;

-}

-

-function csspreview()

-{

- if (document.myvar == 'preview')

- {

- window.open('', '_preview', 'HEIGHT=400,resizable=yes,scrollbars=yes,WIDTH=500');

- document.forms['style'].target = '_preview';

- }

- else

- {

- document.forms['style'].target = '_self';

- }

- document.myvar='';

-

- return true;

-}

-

-//-->

-</script>

-

-<h1><?php echo $user->lang['EDIT_THEME']; ?></h1>

-

-<p><?php echo $user->lang['EDIT_THEME_EXPLAIN']; ?></p>

-

-<p><?php echo $user->lang['SELECTED_THEME'] . ": <b>$theme_name</b>"; ?></p>

-<?php

-

- if ($showcss)

- {

-

-?>

-

-<h3><?php echo $user->lang['SHOW_RAW_CSS_NOTE']; ?></h3>

-

-<p><?php echo $user->lang['SHOW_RAW_CSS_EXPLAIN']; ?></p>

-<?php

-

- }

-

-?>

-

-<form name="style" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=$action&amp;id=$id&amp;showcss=$showcss"; ?>" onsubmit="return csspreview()"><table width="95%" cellspacing="1" cellpadding="1" border="0" align="center">

- <tr>

- <td align="right"><?php echo $user->lang['SELECT_CLASS']; ?>: <select name="classname" onchange="if (this.options[this.selectedIndex].value != ''){ csspreview(); this.form.submit(); }"><?php echo $class_options; ?></select>&nbsp; <input class="btnlite" type="submit" value="<?php echo $user->lang['SELECT']; ?>" tabindex="100" /></td>

- </tr>

- <tr>

- <td><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center">

-<?php

-

- if ($showcss)

- {

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['RAW_CSS']; ?></th>

- </tr>

-<?php

-

- if (sizeof($error) && ($update || $customclass))

- {

- echo '<tr><td class="row1" colspan="2" align="center"><span class="gen" style="color:green" align="center">' . implode('<br />', $error) . '</span></td></tr>';

- }

-

-?>

- <tr>

- <td class="row2" colspan="2" align="center"><textarea class="post" style="font-family:'Courier New', monospace;font-size:10pt;line-height:125%;" name="rawcss" rows="<?php echo $txtrows; ?>" cols="<?php echo $txtcols; ?>"><?php echo (sizeof($css_element)) ? implode(";\n", $css_element) . ';' : ''; ?></textarea></td>

- </tr>

-

-<?php

-

- }

- else

- {

-

-?>

- <tr>

- <th><?php echo $user->lang['CSS_PARAMETER']; ?></th>

- <th><?php echo $user->lang['CSS_VALUE']; ?></th>

- </tr>

-<?php

-

- if (sizeof($error) && ($update || $customclass))

- {

- echo '<tr><td class="row1" colspan="2" align="center"><span class="gen" style="color:green" align="center">' . implode('<br />', $error) . '</span></td></tr>';

- }

-

-?>

- <tr>

- <td class="row3" colspan="2"><b><?php echo $user->lang['BACKGROUND']; ?></b></td>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['BACKGROUND_COLOUR']; ?>:</b> <br /><span class="gensmall"><?php echo $user->lang['COLOUR_EXPLAIN']; ?></span></td>

- <td class="row2"><table cellspacing="0" cellpadding="0" border="0"><tr><td><input class="post" type="text" name="background_color" value="<?php echo $background_color; ?>" size="8" maxlength="14" onchange="document.all.stylebgcolor.bgColor=this.form.background_color.value" /></td><td>&nbsp;</td><td bgcolor="<?php echo $background_color; ?>" id="stylebgcolor" style="border:solid 1px black;"><img src="../images/spacer.gif" width="45" height="15" alt="" /></td><td class="gensmall"> &nbsp; [ <a href="swatch.<?php echo $phpEx; ?>" onclick="swatch('background_color');return false" target="_swatch"><?php echo $user->lang['COLOUR_SWATCH']; ?></a> ]</td></tr></table></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['BACKGROUND_IMAGE']; ?>:</b></td>

- <td class="row2"><select name="background_image"><?php echo $bg_imglist ?></select></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['BACKGROUND_REPEAT']; ?>:</b></td>

- <td class="row2"><select name="background_repeat"><?php

-

- foreach (array('' => '------', 'none' => $user->lang['REPEAT_NO'], 'repeat-x' => $user->lang['REPEAT_X'], 'repeat-y' => $user->lang['REPEAT_Y'], 'both' => $user->lang['REPEAT_ALL']) as $cssvalue => $cssrepeat)

- {

- echo '<option value="' . $cssvalue . '"' . (($background_repeat == $cssvalue) ? ' selected="selected"' : '') . '>' . $cssrepeat . '</option>';

- }

-

-?></select></td>

- </tr>

-

-

- <tr>

- <td class="row3" colspan="2"><b><?php echo $user->lang['FOREGROUND']; ?></b></td>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['FONT_COLOUR']; ?>:</b> <br /><span class="gensmall"><?php echo $user->lang['COLOUR_EXPLAIN']; ?></span></td>

- <td class="row2"><table cellspacing="0" cellpadding="0" border="0"><tr><td><input class="post" type="text" name="color" value="<?php echo $color; ?>" size="8" maxlength="14" onchange="document.all.stylecolor.bgColor=this.form.color.value" /></td><td>&nbsp;</td><td bgcolor="<?php echo $color; ?>" id="stylecolor" style="border:solid 1px black;"><img src="../images/spacer.gif" width="45" height="15" alt="" /></td><td class="gensmall"> &nbsp; [ <a href="swatch.<?php echo $phpEx; ?>" onclick="swatch('color');return false" target="_swatch"><?php echo $user->lang['COLOUR_SWATCH']; ?></a> ]</td></tr></table></td>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['FONT_FACE']; ?>:</b> <br /><span class="gensmall"><?php echo $user->lang['FONT_FACE_EXPLAIN']; ?></span></td>

- <td class="row2"><input class="post" type="text" name="font_family" value="<?php echo $font_family; ?>" size="40" maxlength="255" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['FONT_SIZE']; ?>:</b></td>

- <td class="row2"><input class="post" type="text" name="font_size" value="<?php echo $font_size; ?>" size="3" maxlength="3" /> <select name="font_size_units"><?php

-

- foreach (array('pt', 'px', 'em', '%') as $units)

- {

- echo '<option value="' . $units . '"' . (($font_size_units == $units) ? ' selected="selected"' : '') . '>' . $units . '</option>';

- }

-

-?></select></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['BOLD']; ?>:</b></td>

- <td class="row2"><input type="radio" name="font_weight" value="bold"<?php echo (!empty($font_weight) && $font_weight == 'bold') ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['YES']; ?> &nbsp; <input type="radio" name="font_weight" value="normal"<?php echo (!empty($font_weight) && $font_weight == 'normal') ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['NO']; ?> &nbsp; <input type="radio" name="font_weight" value=""<?php echo (empty($font_weight)) ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['UNSET']; ?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['ITALIC']; ?>:</b></td>

- <td class="row2"><input type="radio" name="font_style" value="italic"<?php echo (!empty($font_style) && $font_style == 'italic') ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['YES']; ?> &nbsp; <input type="radio" name="font_style" value="normal"<?php echo (!empty($font_style) && $font_style == 'normal') ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['NO']; ?> &nbsp; <input type="radio" name="font_style" value=""<?php echo (empty($font_style)) ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['UNSET']; ?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['UNDERLINE']; ?>:</b></td>

- <td class="row2"><input type="radio" name="text_decoration" value="underline"<?php echo (!empty($text_decoration) && $text_decoration == 'underline') ? ' checked="checked"' : ''; ?> /> <?php echo $user->lang['YES']; ?> &nbsp; <input type="radio" name="text_decoration" value="none"<?php echo (!empty($text_decoration) && $text_decoration == 'none') ? ' checked="checked"' : ''; ?>/> <?php echo $user->lang['NO']; ?> &nbsp; <input type="radio" name="text_decoration" value=""<?php echo (empty($text_decoration)) ? ' checked="checked"' : ''; ?>/> <?php echo $user->lang['UNSET']; ?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['LINE_SPACING']; ?>:</b></td>

- <td class="row2"><input class="post" type="text" name="line_height" value="<?php echo $line_height; ?>" size="3" maxlength="3" /> <select name="line_height_units"><?php

-

- foreach (array('pt', 'px', 'em', '%') as $units)

- {

- echo '<option value="' . $units . '"' . (($line_height_units == $units) ? ' selected="selected"' : '') . '>' . $units . '</option>';

- }

-

-?></select></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>"; />&nbsp;&nbsp;<input class="btnlite" type="submit" name="preview" value="<?php echo $user->lang['PREVIEW']; ?>" onclick="document.myvar='preview';" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" />&nbsp;&nbsp;<?php

-

- echo ($showcss) ? '<input class="btnlite" type="submit" name="hidecss" value="' . $user->lang['HIDE_RAW_CSS'] . '" />' : '<input class="btnlite" type="submit" name="showcss" value="' . $user->lang['SHOW_RAW_CSS'] . '" />';

- echo $s_hidden_fields;

-

-?></td>

- </tr>

- </table></td>

- </tr>

-</table>

-

-<h1><?php echo $user->lang['CUSTOM_CLASS']; ?></h1>

-

-<p><?php echo $user->lang['CUSTOM_CLASS_EXPLAIN']; ?></p>

-

-<table width="95%" cellspacing="1" cellpadding="1" border="0" align="center">

- <tr>

- <td><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="2"><?php echo $user->lang['CUSTOM_CLASS']; ?></td>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['CSS_CLASS_NAME']; ?>:</b></td>

- <td class="row2"><input class="post" type="text" name="customclass" value="" maxlength="15" size="15" /></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="addclass" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

- </tr>

- </table>

-

- </td>

- </tr>

-</table></form>

-<?php

-

- adm_page_footer();

- break;

- }

-

- // Front page

- frontend('theme', array('details', 'refresh', 'export', 'delete'));

- break;

-

-

- // IMAGESETS

- case 'imageset':

- $imglist = array(

- 'buttons' => array(

- 'btn_post', 'btn_reply', 'btn_locked', 'btn_quote', 'btn_edit', 'btn_delete', 'btn_report', 'btn_post_pm', 'btn_reply_pm', 'btn_profile', 'btn_pm', 'btn_ip', 'btn_search', 'btn_email', 'btn_www', 'btn_icq', 'btn_aim', 'btn_yim', 'btn_msnm', 'btn_jabber', 'btn_online', 'btn_offline',

- ),

- 'icons' => array(

- 'icon_unapproved', 'icon_reported', 'icon_attach', 'icon_post', 'icon_post_new', 'icon_post_latest', 'icon_post_newest',),

- 'forums' => array(

- 'forum', 'forum_new', 'forum_locked', 'forum_link', 'sub_forum', 'sub_forum_new',),

- 'folders' => array(

- 'folder', 'folder_posted', 'folder_new', 'folder_new_posted', 'folder_hot', 'folder_hot_posted', 'folder_hot_new', 'folder_hot_new_posted', 'folder_locked', 'folder_locked_posted', 'folder_locked_new', 'folder_locked_new_posted', 'folder_sticky', 'folder_sticky_posted', 'folder_sticky_new', 'folder_sticky_new_posted', 'folder_announce', 'folder_announce_posted', 'folder_announce_new', 'folder_announce_new_posted',),

- 'polls' => array(

- 'poll_left', 'poll_center', 'poll_right',),

- );

-

- switch ($action)

- {

- case 'edit':

- $imgname = (!empty($_POST['imgname'])) ? htmlspecialchars($_POST['imgname']) : '';

- $imgpath = (isset($_POST['imgpath'])) ? htmlspecialchars($_POST['imgpath']) : '';

- $imgsize = (!empty($_POST['imgsize'])) ? true : false;

- $imgwidth = (isset($_POST['imgwidth'])) ? intval($_POST['imgwidth']) : '';

-

- if ($id)

- {

- $sql_select = ($imgname) ? ", $imgname" : '';

- $sql = "SELECT imageset_path, imageset_name, imageset_copyright$sql_select

- FROM " . STYLES_IMAGE_TABLE . "

- WHERE imageset_id = $id";

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

-

- if (!extract($db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_IMAGESET']);

- }

- $db->sql_freeresult($result);

-

- // Check to see whether the selected image exists in the table

- $valid_name = false;

- foreach ($imglist as $category => $img_ary)

- {

- if (in_array($imgname, $img_ary))

- {

- $valid_name = true;

- break;

- }

- }

-

- if (!$valid_name)

- {

- $error[] = $user->lang['NO_IMAGE'];

- }

-

- if ($update && $imgpath)

- {

- if (!sizeof($error))

- {

- // If imgwidth and imgheight are non-zero grab the actual size

- // from the image itself ... we ignore width settings for the poll center

- // image

- $imgwidth = $imgheight = '';

- if ($imgsize)

- {

- list($imgwidth, $imgheight) = getimagesize("{$phpbb_root_path}styles/$imageset_path/imageset/$imgpath");

- $imgwidth = ($imgname != 'poll_center') ? " width=\"$imgwidth\"" : '';

- $imgheight = " height=\"$imgheight\"";

- }

-

- $imgpath = '"styles/' . $imageset_path . '/imageset/' . preg_replace('#^(.*?)/(.*?)$#', '{LANG}/\2', $imgpath) . '" border="0"' . $imgwidth . $imgheight;

-

- $sql = 'UPDATE ' . STYLES_IMAGE_TABLE . "

- SET $imgname = '$imgpath'

- WHERE imageset_id = $id";

- $db->sql_query($sql);

-

- $cache->destroy('sql', STYLES_IMAGE_TABLE);

-

- add_log('admin', 'LOG_EDIT_IMAGESET', $imageset_name);

- $error[] = $user->lang['IMAGESET_UPDATED'];

-

- $$imgname = $imgpath;

- }

- }

-

- $test_ary = array();

- foreach ($imglist as $category => $img_ary)

- {

- foreach ($img_ary as $img)

- {

- if (!empty($$img))

- {

- $test_ary[] = preg_replace('#^"styles/' . $imageset_path . '/imageset/(\{LANG\}/)?(.*?)".*$#', '\2', $$img);

- }

- }

- }

- unset($test_ary);

- }

-

- // Generate list of image options

- $img_options = '';

- foreach ($imglist as $category => $img_ary)

- {

- $img_options .= (sizeof($img_ary)) ? '<option class="sep" value="">' . $user->lang['IMG_CAT_' . strtoupper($category)] . '</option>' : '';

- foreach ($img_ary as $img)

- {

- $selected = ($img == $imgname) ? ' selected="selected"' : '';

- $img_options .= '<option value="' . $img . '"' . $selected . '>' . (($category == 'custom') ? $img : $user->lang['IMG_' . strtoupper($img)]) . '</option>';

- }

- }

-

- // TODO

- // Check whether localised buttons exist in admins language first

- // Clean up this code

- $imglang = '';

- $imagesetlist = array('nolang' => array(), 'lang' => array());

- $dp = opendir("{$phpbb_root_path}styles/$imageset_path/imageset");

- while ($file = readdir($dp))

- {

- if (!is_file($file) && !is_link($file) && $file{0} != '.' && strtoupper($file) != 'CVS' && !sizeof($imagesetlist['lang']))

- {

- $dp2 = opendir("{$phpbb_root_path}styles/$imageset_path/imageset/$file");

- while ($file2 = readdir($dp2))

- {

- $imglang = $file;

- if (preg_match('#\.(gif|jpg|png)$#', $file2))

- {

- $imagesetlist['lang'][] = "$file/$file2";

- }

- }

- closedir($dp2);

- }

- else if (preg_match('#\.(gif|jpg|png)$#', $file))

- {

- $imagesetlist['nolang'][] = $file;

- }

- }

- closedir($dp);

-

- $imagesetlist_options = '';

- foreach ($imagesetlist as $type => $img_ary)

- {

- $imagesetlist_options .= ($type == 'lang') ? '<option class="sep" value="">' . $user->lang['LOCALISED_IMAGES'] . '</option>' : '<option class="sep" value="">' . $user->lang['GLOBAL_IMAGES'] . '</option>';

- foreach ($img_ary as $img)

- {

- $imgvalue = preg_replace('#^.*?/(.*?)$#', '\1', $img);

- $selected = (strstr($$imgname, $imgvalue)) ? ' selected="selected"' : '';

-

- $imagesetlist_options .= '<option value="' . htmlspecialchars($img) . '"' . $selected . '>' . $imgvalue . '</option>';

- }

- }

- $imagesetlist_options = '<option value=""' . (($edit_img == '') ? ' selected="selected"' : '') . '>' . $user->lang['NONE'] . '</option>' . $imagesetlist_options;

- unset($imagesetlist);

-

- $imgsize_no = $imgsize_yes = '';

- if ($imgsize || preg_match('# height="[0-9]+?#', $$imgname))

- {

- $imgsize_yes = ' checked="checked"';

- }

- else

- {

- $imgsize_no = ' checked="checked"';

- }

-

- adm_page_header($user->lang['EDIT_IMAGESET']);

-

-?>

-

-<script language="javascript" type="text/javascript" defer="defer">

-<!--

-

-function update_image(newimage)

-{

- document.newimg.src = (newimage) ? "<?php echo "{$phpbb_root_path}styles/$imageset_path/imageset/"; ?>" + newimage : "images/no_image.png";

-}

-//-->

-</script>

-

-<h1><?php echo $user->lang['EDIT_IMAGESET']; ?></h1>

-

-<p><?php echo $user->lang['EDIT_IMAGESET_EXPLAIN']; ?></p>

-

-<p><?php echo $user->lang['SELECTED_IMAGESET'] . ": <b>$imageset_name</b>"; ?></p>

-

-<form method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;id=$id&amp;action=$action"; ?>"><table width="95%" cellspacing="1" cellpadding="1" border="0" align="center">

- <tr>

- <td align="right"><?php echo $user->lang['SELECT_IMAGE']; ?>: <select name="imgname" onchange="this.form.submit(); "><?php echo $img_options; ?></select>&nbsp; <input class="btnlite" type="submit" value="<?php echo $user->lang['SELECT']; ?>" tabindex="100" /></td>

- </tr>

- <tr>

- <td><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="2"><?php echo $user->lang['EDIT_IMAGESET']; ?></th>

- </tr>

-<?php

-

- if (sizeof($error))

- {

-

-?>

- <tr>

- <td class="row1" colspan="2" align="center"><?php echo ($update) ? '<span style="color:green">' . implode('<br />', $error) . '</span>' : implode('<br />', $error); ?></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="row1" colspan="2" align="center"><table width="100%" cellspacing="2" cellpadding="2" border="0">

- <tr>

- <td width="50%" align="center"><img src="<?php

-

- echo (!empty($$imgname)) ? str_replace('"styles/', '../styles/', str_replace('{LANG}', $imglang, $$imgname)) : 'images/no_image.png';

-

-?>" /></td>

- <td width="50%" align="center"><img src="<?php

-

- echo (!empty($$imgname)) ? preg_replace('#(width|height)="[0-9]+?"#', '', str_replace('"styles/', '../styles/', str_replace('{LANG}', $imglang, $$imgname))) : 'images/no_image.png';

-

-?>" name="newimg" /></td>

- </tr>

- <tr>

- <td class="gensmall" align="center"><?php echo $user->lang['CURRENT_IMAGE']; ?></td>

- <td class="gensmall" align="center"><?php echo $user->lang['SELECTED_IMAGE']; ?></td>

- </tr>

- </table></td>

- </tr>

- <tr>

- <th width="40%"><?php echo $user->lang['IMAGE_PARAMETER']; ?></th>

- <th><?php echo $user->lang['IMAGE_VALUE']; ?></th>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['IMAGE']; ?>: </b></td>

- <td class="row2"><select name="imgpath" onchange="update_image(this.options[selectedIndex].value);"><?php echo $imagesetlist_options; ?></select></td>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['DIMENSIONS']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['DIMENSIONS_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="radio" name="imgsize" value="1"<?php echo $imgsize_yes; ?> /> <?php echo $user->lang['YES']; ?>&nbsp;&nbsp;<input type="radio" name="imgsize" value="0"<?php echo $imgsize_no; ?> /> <?php echo $user->lang['NO']; ?></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnmain" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

- </tr>

- </table></td>

- </tr>

-</table></form>

-

-<?php

-

- adm_page_footer();

- break;

- }

-

- // Front page

- frontend('imageset', array('details', 'delete', 'export'));

- break;

-}

-

-exit;

-

-

-// ---------

-// FUNCTIONS

-//

-function frontend($type, $options)

-{

- global $phpbb_root_path, $phpEx, $SID, $config, $db, $user, $mode;

-

- switch ($type)

- {

- case 'style':

- $sql_from = STYLES_TABLE;

- break;

- case 'template':

- $sql_from = STYLES_TPL_TABLE;

- break;

- case 'theme':

- $sql_from = STYLES_CSS_TABLE;

- break;

- case 'imageset':

- $sql_from = STYLES_IMAGE_TABLE;

- break;

- }

-

- $l_prefix = strtoupper($type);

- $thspan = ($type != 'style') ? sizeof($options) + 1: sizeof($options) + 2;

- $tdspan = ($type != 'style') ? $thspan + 2 : $thspan + 3;

-

- // Output list of themes

- adm_page_header($user->lang[$l_prefix . 'S']);

-

-?>

-<h1><?php echo $user->lang[$l_prefix . 'S']; ?></h1>

-

-<p><?php echo $user->lang[$l_prefix . 'S_EXPLAIN']; ?></p>

-

-<form name="style" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode"; ?>"><table class="bg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th nowrap="nowrap"><?php echo $user->lang[$l_prefix . '_NAME']; ?></th>

-<?php

-

- if ($type == 'style')

- {

-?>

- <th nowrap="nowrap"><?php echo $user->lang['STYLE_USED_BY']; ?></th>

-<?php

-

- }

-

-?>

- <th colspan="<?php echo $thspan; ?>" nowrap="nowrap"><?php echo $user->lang['OPTIONS']; ?></th>

- </tr>

- <tr>

- <td class="row3" colspan="<?php echo $tdspan; ?>"><b><?php echo $user->lang['INSTALLED_' . $l_prefix]; ?></b></td>

- </tr>

-<?php

-

- if ($type == 'style')

- {

- $sql = 'SELECT user_style, COUNT(user_style) AS style_count

- FROM ' . USERS_TABLE . '

- GROUP BY user_style';

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

-

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

- {

- $style_count[$row['user_style']] = $row['style_count'];

- }

- $db->sql_freeresult($result);

- }

-

- $sql = "SELECT *

- FROM $sql_from";

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

-

- $installed = array();

- $basis_options = '<option class="sep" value="">' . $user->lang['OPTIONAL_BASIS'] . '</option>';

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

- {

- $installed[] = $row[$type . '_name'];

- $basis_options .= '<option value="' . $row[$type . '_id'] . '">' . $row[$type . '_name'] . '</option>';

-

- $row_class = ($row_class != 'row1') ? 'row1' : 'row2';

-

- $tagstyle = ($type == 'style' && $row['style_id'] == $config['default_style']) ? '*' : '';

-

-?>

- <tr>

- <td class="<?php echo $row_class; ?>" width="100%"><a href="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=" . (($type == 'style') ? 'details' : 'edit') . "&amp;id=" . $row[$type . '_id']; ?>"><?php echo $row[$type . '_name']; ?></a> <?php echo $tagstyle; ?></td>

-<?php

-

- if ($type == 'style')

- {

- $stylevis = (!$row['style_active']) ? 'activate' : 'deactivate';

-

-?>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap"><?php echo (!empty($style_count[$row['style_id']])) ? $style_count[$row['style_id']] : '0'; ?></td>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap">&nbsp;<a href="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=$stylevis&amp;id=" . $row['style_id']; ?>"><?php echo $user->lang['STYLE_' . strtoupper($stylevis)]; ?></a>&nbsp;</td>

-<?php

-

- }

-

- foreach ($options as $option)

- {

-

-?>

- <td class="<?php echo $row_class; ?>" nowrap="nowrap">&nbsp;<a href="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=$option&amp;id=" . $row[$type . '_id']; ?>"><?php echo $user->lang[strtoupper($option)]; ?></a>&nbsp;</td>

-<?php

-

- }

-

-?>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap">&nbsp;<a href="<?php echo "{$phpbb_root_path}index.$phpEx$SID&amp;$type=" . $row[$type . '_id']; ?>" target="_preview"><?php echo $user->lang['PREVIEW']; ?></a>&nbsp;</td>

- </tr>

-<?php

-

- }

- $db->sql_freeresult($result);

-

-?>

- <tr>

- <td class="row3" colspan="<?php echo $tdspan; ?>"><b><?php echo $user->lang['UNINSTALLED_' . $l_prefix]; ?></b></td>

- </tr>

-<?php

-

- $new_ary = $cfg = array();

- $dp = opendir("{$phpbb_root_path}styles");

- while ($file = readdir($dp))

- {

- $subpath = ($type != 'style') ? "$type/" : '';

- if ($file{0} != '.' && file_exists("{$phpbb_root_path}styles/$file/$subpath$type.cfg"))

- {

- if ($cfg = file("{$phpbb_root_path}styles/$file/$subpath$type.cfg"))

- {

- $name = trim($cfg[0]);

- if (!in_array($name, $installed))

- {

- $new_ary[$i]['path'] = $file;

- $new_ary[$i]['name'] = $name;

- $i++;

- }

- }

- }

- }

- unset($installed);

- @closedir($dp);

-

- if (sizeof($new_ary))

- {

- foreach ($new_ary as $key => $cfg)

- {

- $row_class = ($row_class != 'row1') ? 'row1' : 'row2';

-

-?>

- <tr>

- <td class="<?php echo $row_class; ?>"><?php echo $cfg['name']; ?></td>

- <td class="<?php echo $row_class; ?>" colspan="<?php echo ($type != 'style') ? $thspan : $thspan + 1 ?>" align="center"><a href="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=install&amp;path=" . urlencode($cfg['path']); ?>"><?php echo $user->lang['INSTALL']; ?></a></td>

- </tr>

-<?php

-

- }

- }

- else

- {

-

-?>

- <tr>

- <td class="row1" colspan="<?php echo $tdspan; ?>" align="center"><?php echo $user->lang['NO_UNINSTALLED_' . $l_prefix]; ?></td>

- </tr>

-<?php

-

- }

- unset($new_ary);

-

-?>

- <tr>

- <td class="cat" colspan="<?php echo $tdspan; ?>" align="right"><?php echo $user->lang['CREATE_' . $l_prefix]; ?>: <input class="post" type="text" name="name" value="" maxlength="30" size="25" /> <?php echo $user->lang['FROM']; ?> <select name="basis"><?php echo $basis_options; ?></select> <input class="btnmain" type="submit" name="add" value="<?php echo $user->lang['SUBMIT']; ?>" /></td>

- </tr>

-</table></form>

-

-<?php

-

- adm_page_footer();

-

-}

-

-function remove($type, $id)

-{

- global $phpbb_root_path, $phpEx, $SID, $config, $db, $cache, $user, $mode, $action;

-

- $new_id = (!empty($_POST['newid'])) ? intval($_POST['newid']) : false;

- $deletefs = (!empty($_POST['deletefs'])) ? true : false;

- $update = (isset($_POST['update'])) ? true : false;

-

- switch ($type)

- {

- case 'style':

- $sql_from = STYLES_TABLE;

- $sql_select = 'style_name';

- break;

- case 'template':

- $sql_from = STYLES_TPL_TABLE;

- $sql_select = 'template_name, template_path, template_storedb';

- break;

- case 'theme':

- $sql_from = STYLES_CSS_TABLE;

- $sql_select = 'theme_name, theme_path, theme_storedb';

- break;

- case 'imageset':

- $sql_from = STYLES_IMAGE_TABLE;

- $sql_select = 'imageset_name, imageset_path';

- break;

- }

-

- $l_prefix = strtoupper($type);

-

- $sql = "SELECT $sql_select

- FROM $sql_from

- WHERE {$type}_id = $id";

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

-

- if (!extract($db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_' . $l_prefix]);

- }

-

- $path = ($type != 'style') ? ${$type . '_path'} : '';

- $storedb = (isset(${$type . '_storedb'})) ? ${$type . '_storedb'} : false;

-

- $sql = "SELECT {$type}_id, {$type}_name

- FROM $sql_from

- WHERE {$type}_id <> $id

- ORDER BY {$type}_id";

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

-

- $options = '';

- if (!($row = $db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['ONLY_' . $l_prefix]);

- }

-

- do

- {

- $options .= '<option value="' . $row[$type . '_id'] . '">' . $row[$type . '_name'] . '</option>';

- }

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

-

- if ($update)

- {

- $sql = "DELETE FROM $sql_from

- WHERE {$type}_id = $id";

- $db->sql_query($sql);

-

- $onfs = 0;

- if ($type == 'style')

- {

- $sql = 'UPDATE ' . USERS_TABLE . "

- SET user_style = $new_id

- WHERE user_style = $id";

- $db->sql_query($sql);

- }

- else

- {

- $sql = 'UPDATE ' . STYLES_TABLE . "

- SET {$type}_id = $new_id

- WHERE {$type}_id = $id";

- $db->sql_query($sql);

-

- if ($deletefs && is_writeable("{$phpbb_root_path}styles/$path/{$type}"))

- {

- $filelist = filelist("{$phpbb_root_path}styles/$path/{$type}", '', '*');

- krsort($filelist);

-

- foreach ($filelist as $subpath => $file_ary)

- {

- $subpath = "{$phpbb_root_path}styles/$path/{$type}$subpath";

- foreach ($file_ary as $file)

- {

-/* if (!@unlink("$subpath$file"))

- {

- $onfs = 1;

- }

-*/ }

-

-/* if (!@rmdir($subpath))

- {

- $onfs = 1;

- }

-*/ }

- }

- else

- {

- $onfs = (file_exists("{$phpbb_root_path}styles/$path/{$type}")) ? 1 : 0;

- }

- }

-

- $cache->destroy('sql', STYLES_TABLE);

-

- add_log('admin', 'LOG_DELETE_' . $l_prefix, ${$type . '_name'});

- $message = ($onfs) ? $l_prefix . '_DELETED_FS' : $l_prefix . '_DELETED';

- trigger_error($user->lang[$message]);

- }

-

- // Output list of themes

- adm_page_header($user->lang['DELETE_' . $l_prefix]);

-

-?>

-<h1><?php echo $user->lang['DELETE_' . $l_prefix]; ?></h1>

-

-<p><?php echo $user->lang['DELETE_' . $l_prefix . '_EXPLAIN']; ?></p>

-

-<form name="style" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$type&amp;action=delete&amp;id=$id"; ?>"><table class="bg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="2"><?php echo $user->lang['DELETE_' . $l_prefix]; ?></td>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_prefix . '_NAME']; ?>:</b></td>

- <td class="row2"><b><?php echo ${$type . '_name'}; ?></b></td>

- </tr>

-<?php

-

- if ($type != 'style' && !$storedb && is_writeable("{$phpbb_root_path}styles/$path/$type"))

- {

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['DELETE_FROM_FS']; ?>: </b></td>

- <td class="row2"><input type="radio" name="deletefs" value="1" /> <?php echo $user->lang['YES']; ?>&nbsp;&nbsp;<input type="radio" name="deletefs" value="0" checked="checked" /> <?php echo $user->lang['NO']; ?></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['REPLACE_' . $l_prefix]; ?>:</b><br /><span class="gensmall"><?php echo $user->lang['REPLACE_' . $l_prefix . '_EXPLAIN']; ?></span></td>

- <td class="row2"><select name="newid"><?php echo $options; ?></select></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['DELETE']; ?>"; />&nbsp;&nbsp;<input class="btnlite" type="submit" name="cancel" value="<?php echo $user->lang['CANCEL']; ?>"; /></td>

- </tr>

-</table></form>

-<?php

-

- adm_page_footer();

-

-}

-

-// Export style or style elements

-function export($mode, $id)

-{

- global $phpbb_root_path, $phpEx, $SID, $config, $db, $user;

-

- $update = (isset($_POST['update'])) ? true : false;

-

- $inc_template = (!empty($_POST['inc_template'])) ? true : false;

- $inc_theme = (!empty($_POST['inc_theme'])) ? true : false;

- $inc_imageset = (!empty($_POST['inc_imageset'])) ? true : false;

- $format = (isset($_POST['format'])) ? htmlspecialchars($_POST['format']) : '';

- $store = (!empty($_POST['store'])) ? true : false;

-

- switch ($mode)

- {

- case 'style':

- if ($update && $inc_template + $inc_theme + $inc_imageset < 1)

- {

- $error[] = $user->lang['STYLE_ERR_MORE_ELEMENTS'];

- }

-

- $style_id = &$id;

- $name = 'style_name';

-

- $sql_select = 's.style_id, s.style_name, s.style_copyright';

- $sql_select .= ($inc_template) ? ', t.*' : ', t.template_name';

- $sql_select .= ($inc_theme) ? ', c.*' : ', c.theme_name';

- $sql_select .= ($inc_imageset) ? ', i.*' : ', i.imageset_name';

- $sql_from = STYLES_TABLE . ' s, ' . STYLES_TPL_TABLE . ' t, ' . STYLES_CSS_TABLE . ' c, ' . STYLES_IMAGE_TABLE . ' i';

- $sql_where = "s.style_id = $id AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id";

-

- $l_prefix = 'STYLE';

- break;

-

- case 'template':

- $template_id = &$id;

- $name = 'template_name';

-

- $sql_select = '*';

- $sql_from = STYLES_TPL_TABLE;

- $sql_where = "template_id = $id";

-

- $l_prefix = 'TEMPLATE';

- break;

-

- case 'theme':

- $theme_id = &$id;

- $name = 'theme_name';

-

- $sql_select = '*';

- $sql_from = STYLES_CSS_TABLE;

- $sql_where = "theme_id = $id";

-

- $l_prefix = 'THEME';

- break;

-

- case 'imageset':

- $imageset_id = &$id;

- $name = 'imageset_name';

-

- $sql_select = '*';

- $sql_from = STYLES_IMAGE_TABLE;

- $sql_where = "imageset_id = $id";

-

- $l_prefix = 'IMAGESET';

- break;

- }

-

- // Lets do a merry dance ... either that or generate the archive

- if ($update && !sizeof($error))

- {

- $sql = "SELECT $sql_select

- FROM $sql_from

- WHERE $sql_where";

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

-

- if (!($style_row = ($db->sql_fetchrow($result))))

- {

- trigger_error($user->lang['NO_' . $l_prefix]);

- }

- $db->sql_freeresult($result);

-

- $var_ary = array('style_id', 'style_name', 'style_copyright', 'template_id', 'template_name', 'template_path', 'template_copyright', 'template_storedb', 'bbcode_bitfield', 'theme_id', 'theme_name', 'theme_path', 'theme_copyright', 'theme_storedb', 'theme_mtime', 'theme_data', 'imageset_id', 'imageset_name', 'imageset_path', 'imageset_copyright');

- foreach ($var_ary as $var)

- {

- $$var = (!empty($style_row[$var])) ? $style_row[$var] : '';

- unset($style_row[$var]);

- }

-

- $files = $data = array();

-

- if ($mode == 'style')

- {

- $style_cfg = addslashes($style_name) . "\n";

- $style_cfg .= addslashes($style_copyright) . "\n";

- $style_cfg .= addslashes($config['version']) . "\n";

- $style_cfg .= ((!$inc_template) ? addslashes($template_name) : '') . "\n";

- $style_cfg .= ((!$inc_theme) ? addslashes($theme_name) : '') . "\n";

- $style_cfg .= ((!$inc_imageset) ? addslashes($imageset_name) : '');

-

- $data[] = array(

- 'src' => $style_cfg,

- 'prefix' => 'style.cfg'

- );

- unset($style_cfg);

- }

-

- // Export template core code

- if ($mode == 'template' || $inc_template)

- {

- $template_cfg = addslashes($template_name) . "\n";

- $template_cfg .= addslashes($template_copyright) . "\n";

- $template_cfg .= addslashes($config['version']) . "\n";

- $template_cfg .= addslashes($bbcode_bitfield);

-

- $data[] = array(

- 'src' => $template_cfg,

- 'prefix' => 'template/template.cfg'

- );

-

- // This is potentially nasty memory-wise ...

- if (!$template_storedb)

- {

- $files[] = array(

- 'src' => "styles/$template_path/template/",

- 'prefix-' => "styles/$template_path/",

- 'prefix+' => false,

- 'exclude' => 'template.cfg'

- );

- }

- else

- {

- $sql = 'SELECT template_filename, template_data

- FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $template_id";

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

-

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

- {

- $data[] = array(

- 'src' => $row['template_data'],

- 'prefix' => 'template/' . $row['template_filename']

- );

- }

- $db->sql_freeresult($result);

- }

- unset($template_cfg);

- }

-

- // Export theme core code

- if ($mode == 'theme' || $inc_theme)

- {

- $theme_cfg = addslashes($theme_name) . "\n";

- $theme_cfg .= addslashes($theme_copyright) . "\n";

- $theme_cfg .= addslashes($config['version']);

-

- $files[] = array(

- 'src' => "styles/$theme_path/theme/",

- 'prefix-' => "styles/$theme_path/",

- 'prefix+' => false,

- 'exclude' => ($theme_storedb) ? 'stylesheet.css,theme.cfg' : 'theme.cfg'

- );

-

- $data[] = array(

- 'src' => $theme_cfg,

- 'prefix' => 'theme/theme.cfg'

- );

-

- if ($theme_storedb)

- {

- $data[] = array(

- 'src' => $theme_data,

- 'prefix' => 'theme/stylesheet.css'

- );

- }

- unset($theme_data);

- unset($theme_cfg);

- }

-

- // Export imageset core code

- if ($mode == 'imageset' || $inc_imageset)

- {

- $imageset_cfg = addslashes($imageset_name) . "\n";

- $imageset_cfg .= addslashes($imageset_copyright) . "\n";

- $imageset_cfg .= addslashes($config['version']) . "\n";

-

- foreach (array_keys($style_row) as $key)

- {

- $imageset_cfg .= $key . '||' . str_replace("styles/$imageset_path/imageset/", '{PATH}', $style_row[$key]) . "\n";

- unset($style_row[$key]);

- }

- $imageset_cfg = rtrim($imageset_cfg);

-

- $files[] = array(

- 'src' => "styles/$imageset_path/imageset/",

- 'prefix-' => "styles/$imageset_path/",

- 'prefix+' => false,

- 'exclude' => 'imageset.cfg'

- );

-

- $data[] = array(

- 'src' => trim($imageset_cfg),

- 'prefix' => 'imageset/imageset.cfg'

- );

- unset($imageset_cfg);

- }

-

- switch ($format)

- {

- case 'tar':

- $ext = 'tar';

- $mimetype = 'x-tar';

- $compress = 'compress_tar';

- break;

-

- case 'zip':

- if (!extension_loaded('zlib'))

- {

- trigger_error($user->lang['NO_SUPPORT_ZIP']);

- }

- $ext = 'zip';

- $mimetype = 'zip';

- $compress = 'compress_zip';

- break;

-

- case 'tar.gz':

- if (!extension_loaded('zlib'))

- {

- trigger_error($user->lang['NO_SUPPORT_GZ']);

- }

- $ext = 'tar.gz';

- $mimetype = 'x-gzip';

- $compress = 'compress_tar';

- break;

-

- case 'tar.bz2':

- if (!extension_loaded('bz2'))

- {

- trigger_error($user->lang['NO_SUPPORT_BZ2']);

- }

- $ext = 'tar.bz2';

- $mimetype = 'x-bzip2';

- $compress = 'compress_tar';

- break;

-

- default:

- $error[] = $user->lang[$l_prefix . '_ERR_ARCHIVE'];

- }

-

- if (!sizeof($error))

- {

- include($phpbb_root_path . 'includes/functions_compress.'.$phpEx);

-

- $path = str_replace(' ', '_', $$name);

-

- if (!($zip = new $compress('w', "{$phpbb_root_path}store/$path.$ext")))

- {

- trigger_error($user->lang['STORE_UNWRITEABLE']);

- }

-

- if ($files)

- {

- foreach ($files as $file_ary)

- {

- $zip->add_file($file_ary['src'], $file_ary['prefix-'], $file_ary['prefix+'], $file_ary['exclude']);

- }

- }

-

- if ($data)

- {

- foreach ($data as $data_ary)

- {

- $zip->add_data($data_ary['src'], $data_ary['prefix']);

- }

- }

-

- $zip->close();

-

- add_log('admin', 'LOG_EXPORT_' . $l_prefix, $$name);

-

- if (!$store)

- {

- header('Pragma: no-cache');

- header("Content-Type: application/$mimetype; name=\"$path.$ext\"");

- header("Content-disposition: attachment; filename=$path.$ext");

-

- $fp = fopen("{$phpbb_root_path}store/$path.$ext", 'rb');

- while ($buffer = fread($fp, 1024))

- {

- echo $buffer;

- }

- fclose($fp);

- @unlink("{$phpbb_root_path}store/$path.$ext");

- exit;

- }

-

- trigger_error(sprintf($user->lang[$l_prefix . '_EXPORTED'], "store/$path.$ext"));

- }

- }

- else

- {

- $sql = "SELECT {$mode}_id, {$mode}_name

- FROM " . (($mode == 'style') ? STYLES_TABLE : $sql_from) . "

- WHERE {$mode}_id = $id";

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

-

- if (!extract($db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_' . $l_prefix]);

- }

- $db->sql_freeresult($result);

- }

-

- // Output list

- adm_page_header($user->lang[$l_prefix . '_EXPORT']);

-

-?>

-<h1><?php echo $user->lang[$l_prefix . '_EXPORT']; ?></h1>

-

-<p><?php echo $user->lang[$l_prefix . '_EXPORT_EXPLAIN']; ?></p>

-

-<form name="style" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$mode&amp;action=export&amp;id=$id"; ?>"><table class="bg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

-<tr>

- <th colspan="2"><?php echo $user->lang[$l_prefix . '_EXPORT']; ?></td>

-</tr>

-<?php

-

- if (sizeof($error))

- {

-

-?>

-<tr>

- <td colspan="2" class="row3" align="center"><span style="color:red"><?php echo implode('<br />', $error); ?></span></td>

-</tr>

-<?php

-

- }

-

-?>

-<tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_prefix . '_NAME']; ?>:</b></td>

- <td class="row2"><b><?php echo ${$mode . '_name'}; ?></b></td>

-</tr>

-<?php

-

- if ($mode == 'style')

- {

-

-?>

-<tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['INCLUDE_TEMPLATE']; ?>:</b></td>

- <td class="row2"><input type="radio" name="inc_template" value="1" checked="checked" /> <?php echo $user->lang['YES']; ?> &nbsp;&nbsp;<input type="radio" name="inc_template" value="0" /> <?php echo $user->lang['NO']; ?> </td>

-</tr>

-<tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['INCLUDE_THEME']; ?>:</b></td>

- <td class="row2"><input type="radio" name="inc_theme" value="1" checked="checked" /> <?php echo $user->lang['YES']; ?> &nbsp;&nbsp;<input type="radio" name="inc_theme" value="0" /> <?php echo $user->lang['NO']; ?> </td>

-</tr>

-<tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['INCLUDE_IMAGESET']; ?>:</b></td>

- <td class="row2"><input type="radio" name="inc_imageset" value="1" checked="checked" /> <?php echo $user->lang['YES']; ?> &nbsp;&nbsp;<input type="radio" name="inc_imageset" value="0" /> <?php echo $user->lang['NO']; ?> </td>

-</tr>

-<?php

-

- }

-

-?>

-<tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['DOWNLOAD_STORE']; ?>:</b><br /><span class="gensmall"><?php echo $user->lang['DOWNLOAD_STORE_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="radio" name="store" value="1" checked="checked" /> <?php echo $user->lang['EXPORT_STORE']; ?> &nbsp;&nbsp;<input type="radio" name="store" value="0" /> <?php echo $user->lang['EXPORT_DOWNLOAD']; ?> </td>

-</tr>

-<tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['ARCHIVE_FORMAT']; ?>:</b></td>

- <td class="row2"><input type="radio" name="format" value="tar" /> .tar&nbsp;&nbsp;<?php

-

- $compress_types = array('tar.gz' => 'zlib', 'tar.bz2' => 'bz2', 'zip' => 'zlib');

-

- foreach ($compress_types as $type => $module)

- {

- if (!extension_loaded($module))

- {

- continue;

- }

- echo '<input type="radio" name="format" value="' . $type . '" /> .' . $type . '&nbsp;&nbsp;';

- }

-

-?></td>

-</tr>

-<tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>"; />&nbsp;&nbsp;<input class="btnlite" type="submit" name="cancel" value="<?php echo $user->lang['CANCEL']; ?>"; /></td>

-</tr>

-</table></form>

-<?php

-

- adm_page_footer();

-

-}

-

-function store_templates($mode, $id, $path, $filelist)

-{

- global $phpbb_root_path, $phpEx, $db;

-

- $includes = array();

- foreach ($filelist as $pathfile => $file_ary)

- {

- foreach ($file_ary as $file)

- {

- if (!($fp = fopen("{$phpbb_root_path}styles/$path$pathfile/$file", 'r')))

- {

- trigger_error("Could not open {$phpbb_root_path}styles/$path/$pathfile/$file");

- }

- $template_data = fread($fp, filesize("{$phpbb_root_path}styles/$path$pathfile/$file"));

- fclose($fp);

-

- if (preg_match_all('#<!-- INCLUDE (.*?\.html) -->#is', $template_data, $matches))

- {

- foreach ($matches[1] as $match)

- {

- $includes[trim($match)][] = $file;

- }

- }

- }

- }

-

- foreach ($filelist as $pathfile => $file_ary)

- {

- foreach ($file_ary as $file)

- {

- // Skip index.

- if (strpos($file, 'index.') === 0)

- {

- continue;

- }

-

- // We could do this using extended inserts ... but that could be one

- // heck of a lot of data ...

- $sql_ary = array(

- 'template_id' => $id,

- 'template_filename' => $file,

- 'template_included' => (!empty($includes[$file])) ? implode(':', $includes[$file]) . ':' : '',

- 'template_mtime' => filemtime("{$phpbb_root_path}styles/$path$pathfile/$file"),

- 'template_data' => implode('', file("{$phpbb_root_path}styles/$path$pathfile/$file")),

- );

-

- $sql = ($mode == 'insert') ? 'INSERT INTO ' . STYLES_TPLDATA_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary) : 'UPDATE ' . STYLES_TPLDATA_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary) . " WHERE template_id = $id AND template_filename = '" . $db->sql_escape($file) . "'";

- $db->sql_query($sql);

- }

- }

-}

-

-// Does what it says in the function title ... give it a src location, array of files

-// and destination

-function copy_files($src, $filelist, $dst)

-{

- global $phpbb_root_path;

-

- if (!(is_writable("{$phpbb_root_path}styles")))

- {

- return false;

- }

-

- umask(0);

- if (!file_exists("{$phpbb_root_path}styles/$dst"))

- {

- @mkdir("{$phpbb_root_path}styles/$dst", 0777);

- chmod("{$phpbb_root_path}styles/$dst", 0777);

- }

-

- @ksort($filelist);

- foreach ($filelist as $filepath => $file_ary)

- {

- $filepath = (substr($filepath, 0, 1) != '/') ? "/$filepath" : $filepath;

-

- if ($filepath && !file_exists("{$phpbb_root_path}styles/$dst$filepath"))

- {

- @mkdir("{$phpbb_root_path}styles/$dst$filepath", 0777);

- chmod("{$phpbb_root_path}styles/$dst$filepath", 0777);

- }

-

- foreach ($file_ary as $file)

- {

- if (!file_exists("{$phpbb_root_path}styles/$dst$filepath$file"))

- {

- @copy("$src$filepath$file", "{$phpbb_root_path}styles/$dst$filepath$file");

- @chmod("{$phpbb_root_path}styles/$dst$filepath$file", 0777);

- }

- }

- }

-}

-

-// You can guess what this does ... just give it a path

-function cleanup_folder($path)

-{

- $filelist = filelist($path, '', '*');

-

- krsort($filelist);

- foreach ($filelist as $filepath => $file_ary)

- {

- foreach ($file_ary as $file)

- {

- @unlink("$path$filepath$file");

- }

-

- if (file_exists("$path$filepath"))

- {

- @rmdir("$path$filepath");

- }

- }

- @rmdir("$path");

-}

-

-// Is this element installed? If not, grab its cfg details

-function test_installed($element, &$error, $root_path, $reqd_name, &$id, &$name, &$copyright)

-{

- global $db, $user;

-

- switch ($element)

- {

- case 'template':

- $sql_from = STYLES_TPL_TABLE;

- break;

- case 'theme':

- $sql_from = STYLES_CSS_TABLE;

- break;

- case 'imageset':

- $sql_from = STYLES_IMAGE_TABLE;

- break;

- }

-

- $l_element = strtoupper($element);

-

- $chk_name = ($reqd_name) ? $reqd_name : $name;

-

- $sql = "SELECT {$element}_id, {$element}_name

- FROM $sql_from

- WHERE {$element}_name = '" . $db->sql_escape($chk_name) . "'";

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

-

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

- {

- $name = $row[$element . '_name'];

- $id = $row[$element . '_id'];

- }

- else

- {

- if (!($cfg = @file("$root_path$element/$element.cfg")))

- {

- $error[] = sprintf($user->lang['REQUIRES_' . $l_element], $reqd_name);

- return false;

- }

-

- $name = trim($cfg[0]);

- $copyright = trim($cfg[1]);

- $id = 0;

- unset($cfg);

- }

- $db->sql_freeresult($result);

-}

-

-// Install an element, doing various checks as we go

-function install_element($type, &$error, $action, $root_path, &$id, $name, $copyright, $storedb = 0)

-{

- global $phpbb_root_path, $db, $user;

-

- switch ($type)

- {

- case 'template':

- $sql_from = STYLES_TPL_TABLE;

- break;

- case 'theme':

- $sql_from = STYLES_CSS_TABLE;

- break;

- case 'imageset':

- $sql_from = STYLES_IMAGE_TABLE;

- break;

- }

-

- $l_type = strtoupper($type);

- $path = str_replace(' ', '_', $name);

-

- if (empty($name))

- {

- $error[] = $user->lang[$l_type . '_ERR_STYLE_NAME'];

- }

-

- if (strlen($name) > 30)

- {

- $error[] = $user->lang[$l_type . '_ERR_NAME_LONG'];

- }

-

- if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $name))

- {

- $error[] = $user->lang[$l_type . '_ERR_NAME_CHARS'];

- }

-

- if (strlen($copyright) > 60)

- {

- $error[] = $user->lang[$l_type . '_ERR_COPY_LONG'];

- }

-

- $sql = "SELECT {$type}_name

- FROM $sql_from

- WHERE {$type}_name = '" . $db->sql_escape($name) . "'";

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

-

- if (extract($db->sql_fetchrow($result)))

- {

- $error[] = $user->lang[$l_type . '_ERR_NAME_EXIST'];

- }

- $db->sql_freeresult($result);

-

- if (sizeof($error))

- {

- return false;

- }

-

- if ($action != 'install')

- {

- @mkdir("{$phpbb_root_path}styles/$path", 0777);

- @chmod("{$phpbb_root_path}styles/$path", 0777);

- if ($root_path)

- {

- copy_files("$root_path$type", filelist("$root_path$type", '', '*'), "$path/$type");

- }

- }

-

- $sql_ary = array(

- $type . '_name' => $name,

- $type . '_copyright'=> $copyright,

- $type . '_path' => $path,

- );

- if ($type != 'imageset')

- {

- switch ($type)

- {

- case 'template':

- $sql_ary += array(

- $type . '_storedb' => (!is_writeable("{$phpbb_root_path}styles/$path/$type")) ? 1 : 0

- );

- break;

-

- case 'theme':

- $sql_ary += array(

- 'theme_storedb' => (!is_writeable("{$phpbb_root_path}styles/$path/theme/stylesheet.css")) ? 1 : $storedb,

- 'theme_data' => ($storedb) ? (($root_path) ? str_replace('./', "styles/$path/theme/", implode('', file("$root_path/$type/stylesheet.css"))) : '') : '',

- 'theme_mtime' => ($storedb) ? filemtime("{$phpbb_root_path}styles/$path/theme/stylesheet.css") : 0

- );

- break;

- }

- }

- else

- {

- $cfg = file("$root_path$type/imageset.cfg");

-

- for ($i = 3; $i < sizeof($cfg); $i++)

- {

- $tmp = explode('||', $cfg[$i]);

- $sql_ary[$tmp[0]] = str_replace('{PATH}', "styles/$path/imageset/", trim($tmp[1]));

- }

- unset($cfg);

- }

-

- $db->sql_transaction('begin');

-

- $sql = "INSERT INTO $sql_from

- " . $db->sql_build_array('INSERT', $sql_ary);

- $db->sql_query($sql);

-

- $id = $db->sql_nextid();

-

- if ($type == 'template' && $storedb)

- {

- $filelist = filelist("{$root_path}template", '', 'html');

- store_templates('insert', $id, $path, $filelist);

- }

-

- $db->sql_transaction('commit');

-

- $log = ($storedb) ? 'LOG_ADD_' . $l_type . '_FS' : 'LOG_ADD_' . $l_type . '_DB';

- add_log('admin', $log, $name);

-}

-

-function install_style($action, &$error, $name, $copyright, $active, $default, $root_path, &$template_id, &$template_name, &$template_copyright, &$theme_id, &$theme_name, &$theme_copyright, &$imageset_id, &$imageset_name, &$imageset_copyright)

-{

- global $config, $db, $user;

-

- $element_ary = array('template', 'theme', 'imageset');

-

- if (empty($name))

- {

- $error[] = $user->lang['STYLE_ERR_STYLE_NAME'];

- }

-

- if (strlen($name) > 30)

- {

- $error[] = $user->lang['STYLE_ERR_NAME_LONG'];

- }

-

- if (!preg_match('#^[a-z0-9_\-\+\. ]+$#i', $name))

- {

- $error[] = $user->lang['STYLE_ERR_NAME_CHARS'];

- }

-

- if (strlen($copyright) > 60)

- {

- $error[] = $user->lang['STYLE_ERR_COPY_LONG'];

- }

-

- $sql = 'SELECT style_name

- FROM ' . STYLES_TABLE . "

- WHERE style_name = '" . $db->sql_escape($name) . "'";

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

-

- if (extract($db->sql_fetchrow($result)))

- {

- $error[] = $user->lang['STYLE_ERR_NAME_EXIST'];

- }

- $db->sql_freeresult($result);

-

- foreach ($element_ary as $element)

- {

- // Zero id value ... need to install element ... run usual checks

- // and do the install if necessary

- if (!${$element . '_id'})

- {

- $error = install_element($element, $error, $action, $root_path, ${$element . '_id'}, ${$element . '_name'}, ${$element . '_copyright'});

- }

- }

-

- if (!$template_id || !$theme_id || !$imageset_id)

- {

- $error[] = $user->lang['STYLE_ERR_NO_IDS'];

- }

-

- if (sizeof($error))

- {

- return false;

- }

-

- $db->sql_transaction('begin');

-

- $sql_ary = array(

- 'style_name' => $name,

- 'style_copyright' => $copyright,

- 'style_active' => $active,

- 'template_id' => $template_id,

- 'theme_id' => $theme_id,

- 'imageset_id' => $imageset_id,

- );

-

- $sql = 'INSERT INTO ' . STYLES_TABLE . '

- ' . $db->sql_build_array('INSERT', $sql_ary);

- $db->sql_query($sql);

-

- $id = $db->sql_nextid();

-

- if ($default)

- {

- $sql = 'UPDATE ' . USERS_TABLE . "

- SET user_style = $id

- WHERE user_style = " . $config['default_style'];

- $db->sql_query($sql);

-

- set_config('default_style', $id);

- }

-

- $db->sql_transaction('commit');

-

- add_log('admin', 'LOG_ADD_STYLE', $name);

-}

-

-// Commented inline

-function install($type, $action, $id)

-{

- global $phpbb_root_path, $phpEx, $SID, $config, $db, $cache, $user;

- global $safe_mode, $file_uploads, $archive_preg;

-

- $install_path = (isset($_REQUEST['path'])) ? htmlspecialchars($_REQUEST['path']) : '';

- $update = (isset($_POST['update'])) ? true : false;

-

- $installcfg = $error = array();

- $template_storedb = $theme_storedb = $basis = false;

- $root_path = $tmp_path = $theme_data = $s_hidden_fields = '';

- $template_id = $template_name = $template_copyright =$theme_id = $theme_name = $theme_copyright = $imageset_id = $imageset_name = $imageset_copyright = '';

-

- $l_type = strtoupper($type);

- $l_prefix = ($action == 'add') ? 'ADD' : (($action == 'details') ? 'EDIT_DETAILS' : 'INSTALL');

-

- $element_ary = array('template' => STYLES_TPL_TABLE, 'theme' => STYLES_CSS_TABLE, 'imageset' => STYLES_IMAGE_TABLE);

- $phpbbversion = preg_replace('#^2\.([0-9]+?)\.([0-9]+?).*?$#', '\1.\2', $config['version']);

-

- switch ($type)

- {

- case 'style':

- $sql_from = STYLES_TABLE;

- break;

- case 'template':

- $sql_from = STYLES_TPL_TABLE;

- break;

- case 'theme':

- $sql_from = STYLES_CSS_TABLE;

- break;

- case 'imageset':

- $sql_from = STYLES_IMAGE_TABLE;

- break;

- }

-

- // Importing/uploading then check data and extract archive

- if (!empty($_FILES['upload_file']['name']) || !empty($_POST['import_file']))

- {

- if (!empty($_FILES['upload_file']['name']))

- {

- $realname = htmlspecialchars($_FILES['upload_file']['name']);

- $filename = htmlspecialchars($_FILES['upload_file']['tmp_name']);

-

- if (!is_uploaded_file($filename))

- {

- trigger_error("$filename was not uploaded");

- }

- }

- else

- {

- $realname = htmlspecialchars($_POST['import_file']);

- $filename = "{$phpbb_root_path}store/$realname";

- }

-

- if (!preg_match('#(' . $archive_preg . ')$#i', $realname, $match))

- {

- $error[] = sprintf($user->lang['UPLOAD_WRONG_TYPE'], $archive_types);

- }

- $path = preg_replace('#^(.*?)' . preg_quote($match[0]) . '$#', '\1', $realname);

-

- // Attempt to extract the files to a temporary directory in store

- $tmp_path = $phpbb_root_path . 'store/tmp_' . substr(uniqid(''), 0, 10) . '/';

- if (!@mkdir($tmp_path))

- {

- trigger_error("Cannot create $tmp_path", E_USER_ERROR);

- }

-

- include($phpbb_root_path . 'includes/functions_compress.'.$phpEx);

-

- switch ($match[0])

- {

- case '.zip':

- $zip = new compress_zip('r', $filename);

- break;

- default:

- $zip = new compress_tar('r', $filename, $match[0]);

- }

- $zip->extract($tmp_path);

- $zip->close();

-

- unset($cfg);

- }

-

- // Installing, importing/uploading then obtain the style cfg information

- if (($action == 'install' && $install_path) || (!empty($_FILES['upload_file']['name']) || !empty($_POST['import_file'])))

- {

- $root_path = ($action == 'install') ? "{$phpbb_root_path}styles/$install_path/" : "$tmp_path";

- $cfg_path = ($type == 'style') ? "$root_path$type.cfg" : "$root_path$type/$type.cfg";

-

- if (!($fp = @fopen($cfg_path, 'rb')))

- {

- $error[] = $user->lang[$l_type . '_ERR_NOT_' . $l_type];

- }

- else

- {

- $installcfg = explode("\n", fread($fp, filesize($cfg_path)));

- }

- fclose($fp);

- }

-

- // Installing, importing/uploading then grab the element info else grab the

- // submitted params ... stylecfg will be set if this is true (see above)

- if (sizeof($installcfg))

- {

- $name = trim($installcfg[0]);

- $copyright = trim($installcfg[1]);

- $version = preg_replace('#^2\.([0-9]+?)\.([0-9]+?).*?$#', '\1.\2', trim($installcfg[2]));

-

- switch ($type)

- {

- case 'style':

- $reqd_template = trim($installcfg[3]);

- $reqd_theme = trim($installcfg[4]);

- $reqd_imageset = trim($installcfg[5]);

-

- // Check to see if each element is already installed, if it is grab the id

- foreach ($element_ary as $element => $table)

- {

- ${$element . '_id'} = ${$element . '_name'} = ${$element . '_copyright'} = '';

-

- test_installed($element, $error, $root_path, ${'reqd_' . $element}, ${$element . '_id'}, ${$element . '_name'}, ${$element . '_copyright'});

- }

- break;

-

- case 'template':

- test_installed('template', $error, $root_path, false, $template_id, $template_name, $template_copyright);

- break;

-

- case 'theme':

- test_installed('theme', $error, $root_path, false, $theme_id, $theme_name, $theme_copyright);

- break;

-

- case 'imageset':

- test_installed('imageset', $error, $root_path, false, $imageset_id, $imageset_name, $imageset_copyright);

- break;

- }

-

- $s_hidden_fields = '<input type="hidden" name="path" value="' . $install_path . '" />';

- }

- else

- {

- // NOTE: Data here is stripslashed! Ensure it's escaped when entering the DB

- $name = (!empty($_POST['name'])) ? stripslashes(htmlspecialchars($_POST['name'])) : '';

- $copyright = (!empty($_POST['copyright'])) ? stripslashes(htmlspecialchars($_POST['copyright'])) : '';

-

- $template_id = (!empty($_POST['template_id'])) ? intval($_POST['template_id']) : 0;

- $theme_id = (!empty($_POST['theme_id'])) ? intval($_POST['theme_id']) : 0;

- $imageset_id = (!empty($_POST['imageset_id'])) ? intval($_POST['imageset_id']) : 0;

- $basis = (isset($_POST['basis'])) ? intval($_POST['basis']) : 0;

-

- // If we have a basis or we're editing we want some additional info ... else

- // we need nothing

- if ($basis || ($update && $action != 'add'))

- {

- switch ($type)

- {

- case 'style':

- $sql_select = ($action != 'details') ? 'style_name, template_id, theme_id, imageset_id' : 'style_name';

- break;

- case 'template':

- $sql_select = 'template_id, template_name, template_path, template_storedb';

- break;

- case 'theme':

- $sql_select = 'theme_id, theme_name, theme_path, theme_data, theme_storedb';

- break;

- case 'imageset':

- $sql_select = 'imageset_id, imageset_name, imageset_path';

- break;

- }

-

- $sql = "SELECT $sql_select

- FROM $sql_from

- WHERE {$type}_id = " . (($basis) ? $basis : $id);

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

-

- if (!extract($db->sql_fetchrow($result)))

- {

- $error[] = $user->lang['NO_' . $l_type];

- }

- $db->sql_freeresult($result);

-

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

- }

- }

-

- $storedb = (!empty($_POST['storedb'])) ? 1 : 0;

- $style_active = (isset($_POST['style_active'])) ? ((!empty($_POST['style_active'])) ? 1 : 0) : 1;

- $style_default = (isset($_POST['style_default'])) ? ((!empty($_POST['style_default'])) ? 1 : 0) : (($config['default_style'] == $id) ? 1 : 0);

-

- // User has submitted form and no errors have occured

- if ($update && !sizeof($error))

- {

- $sql_ary = array();

-

- // We're installing/uploading/importing

- if ($action == 'install')

- {

- switch ($type)

- {

- case 'style':

- install_style($action, $error, $name, $copyright, $style_active, $style_default, $root_path, $template_id, $template_name, $template_copyright, $theme_id, $theme_name, $theme_copyright, $imageset_id, $imageset_name, $imageset_copyright);

- break;

-

- case 'template':

- install_element('template', $error, $action, $root_path, $id, $name, $copyright);

- break;

-

- case 'theme':

- install_element('theme', $error, $action, $root_path, $id, $name, $copyright);

- break;

-

- case 'imageset':

- install_element('imageset', $error, $action, $root_path, $id, $name, $copyright);

- break;

- }

-

- if ($tmp_path)

- {

- cleanup_folder($tmp_path);

- }

-

- if (!sizeof($error))

- {

- $cache->destroy('sql', STYLES_TABLE);

-

- $message = ($storedb) ? '_ADDED_DB' : '_ADDED';

- trigger_error($user->lang[$l_type . $message]);

- }

- }

- else if ($action == 'add')

- {

- if ($type == 'style')

- {

- install_style($action, $error, $name, $copyright, $style_active, $style_default, $root_path, $template_id, $template_name, $template_copyright, $theme_id, $theme_name, $theme_copyright, $imageset_id, $imageset_name, $imageset_copyright);

- }

- else

- {

- // Create path if it doesn't exist

- $storedb = 1;

-

- umask(0);

- if (file_exists("{$phpbb_root_path}styles/$path") || @mkdir("{$phpbb_root_path}styles/$path", 0777))

- {

- if (@chmod("{$phpbb_root_path}styles/$path", 0777))

- {

- $storedb = 0;

- }

- }

-

- if ($basis && ($template_storedb || $theme_storedb))

- {

- $tmp_path = $phpbb_root_path . 'store/tmp_' . substr(uniqid(''), 0, 10) . '/';

- if (!@mkdir($tmp_path, 0777))

- {

- trigger_error("Cannot create $tmp_path", E_USER_ERROR);

- }

- @chmod($tmp_path, 0777);

-

- if (!@mkdir("$tmp_path$type", 0777))

- {

- trigger_error("Cannot create $tmp_path$type", E_USER_ERROR);

- }

- @chmod("$tmp_path$type", 0777);

-

- switch ($type)

- {

- case 'theme':

- copyfiles("{$phpbb_root_path}styles/$path/theme/", filelist("{$phpbb_root_path}styles/$path/theme/", '', '*'), "$tmp_path$type/");

-

- $fp = fopen("$tmp_path$type/stylesheet.css", 'wb');

- fwrite($fp, $theme_data);

- fclose($theme_data);

- break;

-

- case 'template':

- copyfiles("{$phpbb_root_path}styles/$path/$type/", filelist("{$phpbb_root_path}styles/$path/$type/", '', '*'), "$tmp_path$type/");

-

- $sql = 'SELECT template_filename, template_mtime, template_data

- FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $basis";

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

-

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

- {

- $fp = fopen("$tmp_path$type/" . $row['template_filename'], 'wb');

- fwrite($fp, $row['template_data']);

- fclose($fp);

- }

- $db->sql_freeresult($result);

- break;

- }

- }

-

- $root_path = ($tmp_path) ? $tmp_path : (($basis) ? $phpbb_root_path . 'styles/' . ${$type . '_path'} . '/' : '');

-

- install_element($type, $error, $action, $root_path, $id, $name, $copyright, $storedb);

- }

-

- if ($tmp_path)

- {

- cleanup_folder($tmp_path);

- }

-

- if (!sizeof($error))

- {

- $cache->destroy('sql', STYLES_TABLE);

-

- $message = ($storedb) ? '_ADDED_DB' : '_ADDED';

- trigger_error($user->lang["$l_type$message"]);

- }

- }

- else if ($action == 'details')

- {

- if ($type == 'style')

- {

- $sql_ary = array(

- 'template_id' => $template_id,

- 'theme_id' => $theme_id,

- 'imageset_id' => $imageset_id,

- 'style_active' => $style_active,

- );

- }

- else if ($type != 'imageset')

- {

- switch ($type)

- {

- case 'theme':

- if ($theme_storedb != $storedb)

- {

- $theme_data = implode('', file("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css"));

- if (!$storedb && !$safe_mode && is_writeable("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css"))

- {

- $storedb = 1;

- if ($fp = @fopen("{$phpbb_root_path}styles/$theme_path/$type/stylesheet.css", 'wb'))

- {

- $storedb = (@fwrite($fp, str_replace("styles/$theme_path/theme/", './', $theme_data))) ? 0 : 1;

- }

- fclose($fp);

- }

- $theme_data = str_replace('./', "styles/$theme_path/theme/", $theme_data);

-

- $sql_ary = array(

- 'theme_mtime' => ($storedb) ? filemtime("{$phpbb_root_path}styles/$theme_path/theme/stylesheet.css") : 0,

- 'theme_storedb' => $storedb,

- 'theme_data' => ($storedb) ? $theme_data : '',

- );

- }

- break;

-

- case 'template':

- if ($theme_storedb != $storedb)

- {

- $filelist = filelist("{$phpbb_root_path}styles/$template_path/template", '', 'html');

-

- if (!$storedb && !$safe_mode && is_writeable("{$phpbb_root_path}styles/$template_path/template"))

- {

- $sql = 'SELECT *

- FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $id";

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

-

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

- {

- if (!($fp = @fopen("{$phpbb_root_path}styles/$template_path/template/" . $row['template_filename'], 'wb')))

- {

- $storedb = 1;

- break;

- }

-

- fwrite($fp, $row['template_data']);

- fclose($fp);

- }

- $db->sql_freeresult($result);

-

- if (!$storedb)

- {

- $sql = 'DELETE FROM ' . STYLES_TPLDATA_TABLE . "

- WHERE template_id = $id";

- $db->sql_query($sql);

- }

- }

-

- $sql_ary = array(

- 'template_storedb' => $storedb,

- );

- }

- break;

- }

- }

-

- if ($type != 'imageset' && sizeof($sql_ary))

- {

- $sql = "UPDATE $sql_from

- SET " . $db->sql_build_array('UPDATE', $sql_ary) . "

- WHERE {$type}_id = $id";

- $db->sql_query($sql);

-

- if ($type == 'style' && $style_default)

- {

- set_config('default_style', $id);

- }

- }

-

- $cache->destroy('sql', STYLES_TABLE);

-

- add_log('admin', 'LOG_EDIT_' . $l_type, $name);

- trigger_error($user->lang[$l_type . '_EDITED']);

- }

- }

-

- // Something went wrong ... so we'll clean up any decompressed uploaded/imported archives.

- if ($tmp_path)

- {

- cleanup_folder($tmp_path);

- }

-

- // Either an error occured or the user has just entered the form

- if (!sizeof($error) && !$update && $id)

- {

- $sql = "SELECT *

- FROM $sql_from

- WHERE {$type}_id = $id";

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

-

- if (!extract($db->sql_fetchrow($result)))

- {

- trigger_error($user->lang['NO_' . $l_type]);

- }

- $db->sql_freeresult($result);

-

- $style_default = ($type == 'style' && $config['default_style'] == $id) ? 1 : 0;

- $storedb = (!empty(${$type . '_storedb'})) ? true : false; // Fudged because we use $storedb when submitting data

- }

-

- if ($type == 'style' && $action != 'install')

- {

- $style_options = array();

- foreach ($element_ary as $element => $table)

- {

- $sql = "SELECT {$element}_id, {$element}_name

- FROM $table

- ORDER BY {$element}_id ASC";

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

-

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

- {

- $selected = ($row[$element . '_id'] == ${$element . '_id'}) ? ' selected="selected"' : '';

- ${$element . '_options'} .= '<option value="' . $row[$element . '_id'] . '"' . $selected . '>' . $row[$element . '_name'] . '</option>';

- }

- $db->sql_freeresult($result);

- }

- }

-

- // Output the page

- adm_page_header($user->lang[$l_prefix . '_' . $l_type]);

-

-?>

-

-<h1><?php echo $user->lang[$l_prefix . '_' . $l_type]; ?></h1>

-

-<p><?php echo $user->lang[$l_prefix . '_' . $l_type . '_EXPLAIN']; ?></p>

-

-<form name="style" method="post" action="<?php echo "admin_styles.$phpEx$SID&amp;mode=$type&amp;action=$action&amp;id=$id"; ?>"<?php echo (!$safe_mode && $file_uploads && is_writeable("{$phpbb_root_path}styles")) ? ' enctype="multipart/form-data"' : ''; ?>><table class="bg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="2"><?php echo $user->lang[$l_prefix . '_' . $l_type]; ?></th>

- </tr>

-<?php

-

- if (sizeof($error))

- {

-

-?>

- <tr>

- <td colspan="2" class="row3" align="center"><span style="color:red"><?php echo implode('<br />', $error); ?></span></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_type . '_NAME']; ?>:</b></td>

- <td class="row2"><?php

- $style_name = 'subSilver2';

- $style_copyright = '(c) 2004 Tom Beddard';

- echo ($action == 'add') ? '<input class="post" type="text" name="name" maxlength="30" size="30" value="' . $name . '" />' : '<b>' . ${$type . '_name'} . '</b>';

-

-?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['COPYRIGHT']; ?>:</b></td>

- <td class="row2"><?php

-

- echo ($action == 'add') ? '<input class="post" type="text" name="copyright" maxlength="60" size="30" value="' . $copyright . '" />' : '<b>' . ${$type . '_copyright'} . '</b>';

-

-?></td>

- </tr>

-<?php

-

- if ($type == 'style' && !$basis)

- {

-

-?>

- <tr>

- <td class="row1"><b><?php echo $user->lang['STYLE_TEMPLATE']; ?>:</b></td>

- <td class="row2"><?php

-

- echo ($action == 'install') ? "<b>$template_name</b>" : '<select name="template_id">' . $template_options . '</select>';

-

-?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['STYLE_THEME']; ?>:</b></td>

- <td class="row2"><?php

-

- echo ($action == 'install') ? "<b>$theme_name</b>" : '<select name="theme_id">' . $theme_options . '</select>';

-

-?></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['STYLE_IMAGESET']; ?>:</b></td>

- <td class="row2"><?php

-

- echo ($action == 'install') ? "<b>$imageset_name</b>" : '<select name="imageset_id">' . $imageset_options . '</select>';

-

-?></td>

- </tr>

-<?php

-

- }

-

- if ($type == 'template' || $type == 'theme')

- {

- $storedb_no = (!$storedb) ? ' checked="checked"' : '';

- $storedb_yes = ($storedb) ? ' checked="checked"' : '';

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_type . '_LOCATION']; ?>:</b><br /><span class="gensmall"><?php echo $user->lang[$l_type . '_LOCATION_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="radio" name="storedb" value="0"<?php echo $storedb_no; ?> /> <?php echo $user->lang['STORE_FILESYSTEM']; ?>&nbsp;&nbsp;<input type="radio" name="storedb" value="1"<?php echo $storedb_yes; ?> /> <?php echo $user->lang['STORE_DATABASE']; ?></td>

- </tr>

-<?php

-

- }

-

- // Import, upload and basis options

- if ($action == 'add' && !$safe_mode && is_writeable("{$phpbb_root_path}styles"))

- {

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['OPTIONS']; ?></th>

- </tr>

-<?php

-

- if (!$basis)

- {

- $store_options = '';

- $dp = @opendir("{$phpbb_root_path}store");

- while ($file = readdir($dp))

- {

- if ($file{0} != '.' && preg_match('#(' . $archive_preg . ')$#i', $file))

- {

- $store_options .= "<option value=\"$file\">$file</option>";

- }

- }

- closedir($dp);

-

- $store_options = '<option value="">' . $user->lang['NO_IMPORT'] . '</option>' . $store_options;

-

- if ($file_uploads)

- {

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_type . '_UPLOAD_BASIS']; ?>:</b><br /><span class="gensmall"><?php echo $user->lang['ALLOWED_FILETYPES']; ?>: <?php echo $archive_types; ?></span></td>

- <td class="row2"><input class="post" type="file" name="upload_file" /><input type="hidden" name="MAX_FILE_SIZE" value="1048576" /></td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_type . '_IMPORT_BASIS']; ?>:</b></td>

- <td class="row2"><select name="import_file"><?php echo $store_options; ?></select></td>

- </tr>

-<?php

-

- }

- else if ($basis)

- {

-

-?>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang[$l_type . '_BASIS']; ?>: </b></td>

- <td class="row2"><b><?php echo ${$type . '_name'}; ?></b></td>

- </tr>

-<?php

-

- }

- }

-

- if ($type == 'style')

- {

- $active_yes = ($style_active) ? ' checked="checked"' : '';

- $active_no = (!$style_active) ? ' checked="checked"' : '';

- $style_default_yes = ($style_default) ? ' checked="checked"' : '';

- $style_default_no = (!$style_default) ? ' checked="checked"' : '';

-

-?>

- <tr>

- <th colspan="2">&nbsp;</th>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['STYLE_ACTIVE']; ?>:</b></td>

- <td class="row2"><input type="radio" name="style_active" value="1"<?php echo $active_yes; ?> /> <?php echo $user->lang['YES']; ?> &nbsp; <input type="radio" name="style_active" value="0"<?php echo $active_no; ?> /> <?php echo $user->lang['NO']; ?></td>

- </tr>

-<?php

-

- if ($id != $config['default_style'])

- {

-

-?>

- <tr>

- <td class="row1"><b><?php echo $user->lang['STYLE_DEFAULT']; ?>:</b></td>

- <td class="row2"><input type="radio" name="style_default" value="1"<?php echo $style_default_yes; ?> /> <?php echo $user->lang['YES']; ?> &nbsp; <input type="radio" name="style_default" value="0"<?php echo $style_default_no; ?> /> <?php echo $user->lang['NO']; ?></td>

- </tr>

-<?php

-

- }

- }

-

-?>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /><?php echo $s_hidden_fields; ?></td>

- </tr>

-</table></form>

-<?php

-

- adm_page_footer();

-

-}

-

-

-// Hopefully temporary

-function theme_preview(&$path, &$stylesheet, &$class, &$css_element)

-{

- global $config, $user;

-

-?>

-<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

-<html dir="<?php echo $user->lang['LTR']; ?>">

-<head>

-<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $user->lang['ENCODING']; ?>">

-<meta http-equiv="Content-Style-Type" content="text/css">

-<style type="text/css">

-<!--

-<?php

-

-

- $updated_element = implode('; ', $css_element) . ';';

-

- if (preg_match('#^' . $class . ' {(.*?)}#m', $stylesheet))

- {

- $stylesheet = preg_replace('#^(' . $class . ' {).*?(})#m', '\1 ' . $updated_element . ' \2', $stylesheet);

- }

-

- echo str_replace('styles/', '../styles/', str_replace('./', "styles/$path/theme/", $stylesheet));

-

-?>

-//-->

-</style>

-</head>

-<body>

-

-<table width="100%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr align="center" valign="middle">

- <td height="100" width="33%"><h1>h1</h1></td>

- <td height="100" width="33%"><h2>h2</h2></td>

- <td height="100" width="33%"><h3>h3</h3></td>

- </tr>

- <tr align="center">

- <td colspan="3" height="30"><a class="mainmenu" href="">mainmenu</a></td>

- </tr>

- <tr>

- <td colspan="3" height="50">&nbsp;</td>

- </tr>

-</table>

-

-<table width="95%" cellspacing="2" cellpadding="2" border="0" align="center">

- <tr>

- <td align="left" valign="bottom"><a class="titles" href="">titles</a>

- </tr>

-</table>

-

-<table width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <td class="nav" width="10" align="left" valign="middle"><a href="">navlink</a></td>

- </tr>

-</table>

-

-<table class="tablebg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th colspan="3">th</th>

- </tr>

- <tr>

- <td class="cat" width="40%"><span class="cattitle">cattitle / cat</span></td>

- <td class="catdiv" colspan="2">catdiv</td>

- </tr>

- <tr>

- <td class="row1" width="40%"><a class="topictitle" href="">topictitle / row1</a></td>

- <td class="row2"><span class="topicauthor">topicauthor / row2</span></td>

- <td class="row1"><span class="topicdetails">topicdetails / row1</span></td>

- </tr>

- <tr>

- <td class="row3" colspan="3">row3</td>

- </tr>

- <tr>

- <td class="spacer" colspan="3">spacer</td>

- </tr>

- <tr>

- <td class="row1"><span class="postauthor">postauthor / row1</span></td>

- <td class="row2"><span class="postdetails">postdetails / row2</span></td>

- <td class="row1"><span class="postbody">postbody / row1 <span class="posthilit">posthilit</span></span></td>

- </tr>

-</table>

-

-<br /><hr width="95%" />

-

-<table width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr align="center">

- <td><span class="gen">gen</span></td>

- <td><span class="genmed">genmed</span></td>

- <td><span class="gensmall">gensmall</span></td>

- </tr>

- <tr align="center">

- <td colspan="3"><span class="copyright">copyright <a href="">phpBB</a></span></td>

- </tr>

-</table>

-

-<hr width="95%" /><br />

-

-<form><table width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr align="center">

- <td><input class="btnmain" type="submit" value="input / btnmain" /></td>

- <td><input class="btnlite" type="submit" value="input / btnlite" /></td>

- <td><input class="btnbbcode" type="submit" value="input / btnbbcode" /></td>

- </tr>

- <tr align="center">

- <td colspan="3"><input class="post" type="text" value="input / post" /></td>

- </tr>

- <tr align="center">

- <td colspan="3"><select class="post"><option>select</option></select></td>

- </tr>

- <tr align="center">

- <td colspan="3"><textarea class="post">textarea / post</textarea></td>

- </tr>

-</table></form>

-

-<hr width="95%" /><br />

-

-<table class="tablebg" width="95%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <td class="row2" align="center"><span class="postbody">postbody / <b>bold</b> <i>italic</i> <u>underline</u></span></td>

- </tr>

- <tr>

- <td class="row2"><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center">

- <tr>

- <td class="quote"><b>A_N_Other wrote:</b><hr />quote</td>

- </tr>

- </table></td>

- </tr>

- <tr>

- <td class="row2"><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center">

- <tr>

- <td><b class="genmed">Code:</b></td>

- </tr>

- <tr>

- <td class="code">10 Print "hello"<br />20 Goto 10</td>

- </tr>

- </table></td>

- </tr>

- <tr>

- <td class="row2"><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center">

- <tr>

- <td><b class="genmed">PHP:</b></td>

- </tr>

- <tr>

- <td class="code"><span class="syntaxbg"><span class="syntaxcomment">// syntaxcomment</span><br /><span class="syntaxdefault">?&gt;</span><br />&lt;<span class="syntaxhtml">HTML</span>&gt;<br /><span class="syntaxdefault">&lt;?php</span><br /><span class="syntaxkeyword">echo </span> <span class="syntaxdefault">$this = </span><span class="syntaxstring">"HELLO"</span><span class="syntaxdefault">;</span></span></td>

- </tr>

- </table></td>

- </tr>

-</table>

-

-<br clear="all" />

-

-</body>

-</html>

-<?php

-

-}

-//

-// FUNCTIONS

-// ---------

-

-?> \ No newline at end of file

-<?php

-/**

-*

-* @package acp

-* @version $Id$

-* @copyright (c) 2005 phpBB Group

-* @license http://opensource.org/licenses/gpl-license.php GNU Public License

-*

-*/

-

-/**

-*/

-if (!empty($setmodules))

-{

- if (!$auth->acl_gets('a_user', 'a_useradd', 'a_userdel'))

- {

- return;

- }

-

- $module['USER']['MANAGE_USERS'] = basename(__FILE__) . $SID;

-

- return;

-}

-

-define('IN_PHPBB', 1);

-// Include files

-$phpbb_root_path = '../';

-$phpEx = substr(strrchr(__FILE__, '.'), 1);

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

-include($phpbb_root_path.'includes/functions_user.'.$phpEx);

-include($phpbb_root_path.'includes/functions_profile_fields.'.$phpEx);

-

-$user->add_lang(array('posting', 'ucp'));

-

-//

-// Get and set basic vars

-//

-$mode = request_var('mode', 'overview');

-$action = request_var('action', '');

-

-$username = request_var('username', '');

-$user_id = request_var('u', 0);

-$gid = request_var('g', 0);

-

-$start = request_var('start', 0);

-$ip = request_var('ip', '');

-$start = request_var('start', 0);

-$delete = request_var('delete', '');

-$deletetype = request_var('deletetype', '');

-$marked = request_var('mark', 0);

-$quicktools = request_var('quicktools', '');

-

-$st = request_var('st', 0);

-$sk = request_var('sk', 'a');

-$sd = request_var('sd', 'd');

-

-$submit = (isset($_POST['update'])) ? true : false;

-$confirm = (isset($_POST['confirm'])) ? true : false;

-$cancel = (isset($_POST['cancel'])) ? true : false;

-$preview = (isset($_POST['preview'])) ? true : false;

-$deletemark = (isset($_POST['delmarked'])) ? true : false;

-$deleteall = (isset($_POST['delall'])) ? true : false;

-

-$error = array();

-$colspan = 0;

-

-//

-// Whois output

-//

-if ($action == 'whois')

-{

- // Output relevant page

- adm_page_header($user->lang['WHOIS']);

-

- if ($ip && $domain = gethostbyaddr($ip))

- {

-?>

-

-<table class="bg" width="90%" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th>IP whois for <?php echo $domain; ?></th>

- </tr>

- <tr>

- <td class="row1"><?php

-

- if ($ipwhois = user_ipwhois($ip))

- {

- $ipwhois = preg_replace('#(\s+?)([\w\-\._\+]+?@[\w\-\.]+?)(\s+?)#s', '\1<a href="mailto:\2">\2</a>\3', $ipwhois);

- echo '<br /><pre align="left">' . trim($ipwhois) . '</pre>';

- }

-

-?></td>

- </tr>

-</table>

-

-<br clear="all" />

-

-<?php

-

- }

-

- adm_page_footer();

-}

-

-//

-// Obtain user information if appropriate

-//

-if ($username || $user_id)

-{

- $session_time = 0;

- $sql_where = ($user_id) ? "user_id = $user_id" : "username = '" . $db->sql_escape($username) . "'";

- if ($action == 'overview')

- {

- $sql = '

- SELECT

- u.*,

- s.session_time, s.session_page, s.session_ip

- FROM (' .

- USERS_TABLE . ' u

- LEFT JOIN ' . SESSIONS_TABLE . " s ON s.session_user_id = u.user_id)

- WHERE u.$sql_where

- ORDER BY s.session_time DESC";

- }

- else

- {

- $sql = 'SELECT * FROM ' . USERS_TABLE . " WHERE $sql_where";

- }

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

-

- if (!$userrow = $db->sql_fetchrow($result))

- {

- trigger_error($user->lang['NO_USER']);

- }

- $db->sql_freeresult($result);

-

- if ($userrow['session_time'] > $userrow['user_lastvisit'])

- {

- $userrow['user_lastvisit'] = $userrow['session_time'];

- $userrow['user_lastpage'] = $userrow['session_page'];

- }

-

- $user_password = '';

-}

-

-// Output page

-adm_page_header($user->lang['MANAGE']);

-

-

-//

-// Output forms

-//

-

-// Begin program

-if ($username || $user_id)

-{

- // Generate overall "header" for user admin

- $form_options = '';

- $forms_ary = array('overview' => 'OVERVIEW', 'feedback' => 'FEEDBACK', 'profile' => 'PROFILE', 'prefs' => 'PREFS', 'avatar' => 'AVATAR', 'sig' => 'SIG', 'groups' => 'GROUP', 'perm' => 'PERM', 'attach' => 'ATTACH');

-

- foreach ($forms_ary as $value => $lang)

- {

- $selected = ($mode == $value) ? ' selected="selected"' : '';

- $form_options .= '<option value="' . $value . '"' . $selected . '>' . $user->lang['USER_ADMIN_' . $lang] . '</option>';

- }

-

- // Make sure $user_id is available.

- $user_id = $userrow['user_id'];

-

- $pagination = '';

-

-?>

-

-<script language="javascript" type="text/javascript">

-<!--

-

-var form_name = 'admin';

-var text_name = 'signature';

-

-// Define the bbCode tags

-bbcode = new Array();

-bbtags = new Array('[b]','[/b]','[i]','[/i]','[u]','[/u]','[quote]','[/quote]','[code]','[/code]','[list]','[/list]','[list=]','[/list]','[img]','[/img]','[url]','[/url]');

-imageTag = false;

-

-// Helpline messages

-b_help = "<?php echo $user->lang['BBCODE_B_HELP']; ?>";

-i_help = "<?php echo $user->lang['BBCODE_I_HELP']; ?>";

-u_help = "<?php echo $user->lang['BBCODE_U_HELP']; ?>";

-q_help = "<?php echo $user->lang['BBCODE_Q_HELP']; ?>";

-c_help = "<?php echo $user->lang['BBCODE_C_HELP']; ?>";

-l_help = "<?php echo $user->lang['BBCODE_L_HELP']; ?>";

-o_help = "<?php echo $user->lang['BBCODE_O_HELP']; ?>";

-p_help = "<?php echo $user->lang['BBCODE_P_HELP']; ?>";

-w_help = "<?php echo $user->lang['BBCODE_W_HELP']; ?>";

-a_help = "<?php echo $user->lang['BBCODE_A_HELP']; ?>";

-s_help = "<?php echo $user->lang['BBCODE_S_HELP']; ?>";

-f_help = "<?php echo $user->lang['BBCODE_F_HELP']; ?>";

-e_help = "<?php echo $user->lang['BBCODE_E_HELP']; ?>";

-

-//-->

-</script>

-<script language="javascript" type="text/javascript" src="editor.js"></script>

-

-<h1><?php echo $user->lang['USER_ADMIN']; ?></h1>

-

-<p><?php echo $user->lang['USER_ADMIN_EXPLAIN']; ?></p>

-

-<form method="post" name="admin" action="<?php echo "admin_users.$phpEx$SID&amp;mode=$mode&amp;u=$user_id"; ?>"<?php echo ($file_uploads) ? ' enctype="multipart/form-data"' : ''; ?>><table width="100%" cellspacing="2" cellpadding="0" border="0" align="center">

- <tr>

- <td align="right"><?php echo $user->lang['SELECT_FORM']; ?>: <select name="mode" onchange="if (this.options[this.selectedIndex].value != '') this.form.submit();"><?php echo $form_options; ?></select></td>

- </tr>

- <tr>

- <td><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0">

-<?php

-

- if (sizeof($error))

- {

-

-?>

- <tr>

- <td class="row3" colspan="" align="center"><span class="error"><?php echo implode('<br />', $error); ?></span></td>

- </tr>

-<?php

-

- }

-

-

- switch ($mode)

- {

- case 'overview':

-

- if ($submit)

- {

- // You can't delete the founder

- if ($delete && $userrow['user_type'] != USER_FOUNDER)

- {

- if (!$auth->acl_get('a_userdel'))

- {

- trigger_error($user->lang['NO_ADMIN']);

- }

-

- if (!$cancel && !$confirm)

- {

- adm_page_confirm($user->lang['CONFIRM'], $user->lang['CONFIRM_OPERATION']);

- }

- else if (!$cancel)

- {

- user_delete($deletetype, $user_id);

-

- add_log('admin', 'LOG_USER_DELETED', $userrow['username']);

- trigger_error($user->lang['USER_DELETED']);

- }

- }

-

- // Handle quicktool actions

- if ($quicktools && $userrow['user_type'] != USER_FOUNDER)

- {

- switch ($quicktools)

- {

- case 'banuser':

- case 'banemail':

- case 'banip':

- $ban = array();

-

- switch ($quicktools)

- {

- case 'banuser':

- $ban[] = $userrow['username'];

- $reason = 'USER_ADMIN_BAN_NAME_REASON';

- $log = 'LOG_BAN_USERNAME_USER';

- break;

-

- case 'banemail':

- $ban[] = $userrow['user_email'];

- $reason = 'USER_ADMIN_BAN_EMAIL_REASON';

- $log = 'LOG_BAN_EMAIL_USER';

- break;

-

- case 'banip':

- $ban[] = $userrow['user_ip'];

-

- $sql = 'SELECT DISTINCT poster_ip

- FROM ' . POSTS_TABLE . "

- WHERE poster_id = $user_id";

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

-

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

- {

- $ban[] = $row['poster_ip'];

- }

- $db->sql_freeresult($result);

-

- $reason = 'USER_ADMIN_BAN_IP_REASON';

- $log = 'LOG_BAN_IP_USER';

- break;

- }

-

- user_ban(substr($quicktools, 3), $ban, 0, 0, 0, $user->lang[$reason]);

-

- add_log('user', $user_id, $log);

-

- trigger_error($user->lang['BAN_UPDATE_SUCESSFUL']);

-

- break;

-

- case 'reactivate':

-

- if ($config['email_enable'])

- {

- include_once($phpbb_root_path . 'includes/functions_messenger.'.$phpEx);

-

- $user_actkey = gen_rand_string(10);

- $key_len = 54 - (strlen($server_url));

- $key_len = ($key_len > 6) ? $key_len : 6;

- $user_actkey = substr($user_actkey, 0, $key_len);

-

- user_active_flip($user_id, $userrow['user_type'], $user_actkey, $userrow['username']);

-

- $messenger = new messenger();

-

- $messenger->template('user_welcome_inactive', $user_lang);

- $messenger->subject();

-

- $messenger->replyto($config['board_contact']);

- $messenger->to($userrow['user_email'], $userrow['username']);

-

- $messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);

- $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

- $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

- $messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

-

- $messenger->assign_vars(array(

- 'SITENAME' => $config['sitename'],

- 'WELCOME_MSG' => sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename']),

- 'USERNAME' => $username,

- 'PASSWORD' => $password_confirm,

- 'EMAIL_SIG' => str_replace('<br />', "\n", "-- \n" . $config['board_email_sig']),

-

- 'U_ACTIVATE' => generate_board_url() . "/ucp.$phpEx?mode=activate&u=$user_id&k=$user_actkey")

- );

-

- $messenger->send(NOTIFY_EMAIL);

- $messenger->save_queue();

-

- add_log('admin', 'LOG_USER_REACTIVATE', $userrow['username']);

- add_log('user', $user_id, 'LOG_USER_REACTIVATE_USER');

-

- trigger_error($user->lang['USER_ADMIN_REACTIVATE']);

- }

-

- break;

-

- case 'active':

-

- user_active_flip($user_id, $userrow['user_type'], false, $userrow['username']);

-

- $message = ($user_type == USER_NORMAL) ? 'USER_ADMIN_INACTIVE' : 'USER_ADMIN_ACTIVE';

- $log = ($user_type == USER_NORMAL) ? 'LOG_USER_INACTIVE' : 'LOG_USER_ACTIVE';

-

- add_log('admin', $log, $userrow['username']);

- add_log('user', $user_id, $log . '_USER');

-

- trigger_error($user->lang[$message]);

- break;

-

- case 'moveposts':

-

- if (!($new_forum_id = request_var('new_f', 0)))

- {

-

-?>

-

-<h1><?php echo $user->lang['USER_ADMIN']; ?></h1>

-

-<p><?php echo $user->lang['USER_ADMIN_EXPLAIN']; ?></p>

-

-<form method="post" action="<?php echo "admin_users.$phpEx$SID&amp;action=$action&amp;quicktools=moveposts&amp;u=$user_id"; ?>"><table class="bg" cellspacing="1" cellpadding="4" border="0" align="center">

- <tr>

- <th align="center"><?php echo $user->lang['USER_ADMIN_MOVE_POSTS']; ?></th>

- </tr>

- <tr>

- <td class="row2" align="center" valign="middle"><?php echo $user->lang['MOVE_POSTS_EXPLAIN']; ?><br /><br /><select name="new_f"><?php

-

- echo make_forum_select(false, false, false, true);

-

-?></select>&nbsp;</td>

- </tr>

- <tr>

- <td class="cat" align="center"><input type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" class="btnmain" /></td>

- </tr>

-</table>

-<?php

-

- adm_page_footer();

- }

- else

- {

- // Two stage?

- // Move topics comprising only posts from this user

- $topic_id_ary = array();

- $forum_id_ary = array($new_forum_id);

-

- $sql = 'SELECT topic_id, COUNT(post_id) AS total_posts

- FROM ' . POSTS_TABLE . "

- WHERE poster_id = $user_id

- AND forum_id <> $new_forum_id

- GROUP BY topic_id";

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

-

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

- {

- $topic_id_ary[$row['topic_id']] = $row['total_posts'];

- }

- $db->sql_freeresult($result);

-

- $sql = 'SELECT topic_id, forum_id, topic_title, topic_replies, topic_replies_real

- FROM ' . TOPICS_TABLE . '

- WHERE topic_id IN (' . implode(', ', array_keys($topic_id_ary)) . ')';

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

-

- $move_topic_ary = $move_post_ary = array();

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

- {

- if (max($row['topic_replies'], $row['topic_replies_real']) + 1 == $topic_id_ary[$row['topic_id']])

- {

- $move_topic_ary[] = $row['topic_id'];

- }

- else

- {

- $move_post_ary[$row['topic_id']]['title'] = $row['topic_title'];

- $move_post_ary[$row['topic_id']]['attach'] = ($row['attach']) ? 1 : 0;

- }

-

- $forum_id_ary[] = $row['forum_id'];

- }

- $db->sql_freeresult($result);

-

- // Entire topic comprises posts by this user, move these topics

- if (sizeof($move_topic_ary))

- {

- move_topics($move_topic_ary, $new_forum_id, false);

- }

-

- if (sizeof($move_post_ary))

- {

- // Create new topic

- // Update post_ids, report_ids, attachment_ids

- foreach ($move_post_ary as $topic_id => $post_ary)

- {

- // Create new topic

- $sql = 'INSERT INTO ' . TOPICS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

- 'topic_poster' => $user_id,

- 'topic_time' => time(),

- 'forum_id' => $new_forum_id,

- 'icon_id' => 0,

- 'topic_approved' => 1,

- 'topic_title' => $post_ary['title'],

- 'topic_first_poster_name' => $userrow['username'],

- 'topic_type' => POST_NORMAL,

- 'topic_time_limit' => 0,

- 'topic_attachment' => $post_ary['attach'],)

- );

- $db->sql_query($sql);

-

- $new_topic_id = $db->sql_nextid();

-

- // Move posts

- $sql = 'UPDATE ' . POSTS_TABLE . "

- SET forum_id = $new_forum_id, topic_id = $new_topic_id

- WHERE topic_id = $topic_id

- AND poster_id = $user_id";

- $db->sql_query($sql);

-

- if ($post_ary['attach'])

- {

- $sql = 'UPDATE ' . ATTACHMENTS_TABLE . "

- SET topic_id = $new_topic_id

- WHERE topic_id = $topic_id

- AND poster_id = $user_id";

- $db->sql_query($sql);

- }

-

- $new_topic_id_ary[] = $new_topic_id;

- }

- }

-

- $forum_id_ary = array_unique($forum_id_ary);

- $topic_id_ary = array_unique(array_merge($topic_id_ary, $new_topic_id_ary));

-

- sync('reported', 'topic_id', $topic_id_ary);

- sync('topic', 'topic_id', $topic_id_ary);

- sync('forum', 'forum_id', $forum_id_ary);

- }

-

- break;

- }

-

- $sql = 'SELECT forum_name

- FROM ' . TOPICS_TABLE . "

- WHERE topic_id = $new_forum_id";

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

-

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

- $db->sql_freeresult($result);

-

- add_log('admin', 'LOG_USER_MOVE_POSTS', $forum_info['forum_name'], $userrow['username']);

- add_log('user', $user_id, 'LOG_USER_MOVE_POSTS_USER', $forum_info['forum_name']);

-

- trigger_error($user->lang['USER_ADMIN_MOVE']);

- }

-

- // Handle registration info updates

- $var_ary = array(

- 'username' => (string) $userrow['username'],

- 'user_type' => (int) $userrow['user_founder'],

- 'user_email' => (string) $userrow['user_email'],

- 'email_confirm' => (string) '',

- 'user_password' => (string) '',

- 'password_confirm' => (string) '',

- 'user_warnings' => (int) $userrow['user_warnings'],

- );

-

- // Get the data from the form. Use data from the database if no info is provided

- foreach ($var_ary as $var => $default)

- {

- $data[$var] = request_var($var, $default);

- }

-

- // Validation data

- $var_ary = array(

- 'password_confirm' => array('string', true, $config['min_pass_chars'], $config['max_pass_chars']),

- 'user_password' => array('string', true, $config['min_pass_chars'], $config['max_pass_chars']),

- 'user_warnings' => array('num', 0, $config['max_warnings']),

- );

-

- // Check username if altered

- if ($data['username'] != $userrow['username'])

- {

- $var_ary += array(

- 'username' => array(

- array('string', false, $config['min_name_chars'], $config['max_name_chars']),

- array('username', $userrow['username'])),

- );

- }

-

- // Check email if altered

- if ($data['user_email'] != $userrow['user_email'])

- {

- $var_ary += array(

- 'user_email' => array(

- array('string', false, 6, 60),

- array('email', $userrow['user_email'])),

- 'email_confirm' => array('string', true, 6, 60)

- );

- }

-

- $error = validate_data($data, $var_ary);

-

- if ($data['user_password'] && $data['password_confirm'] != $data['user_password'])

- {

- $error[] = 'NEW_PASSWORD_ERROR';

- }

-

- if ($data['user_email'] != $userrow['user_email'] && $data['email_confirm'] != $data['user_email'])

- {

- $error[] = 'NEW_EMAIL_ERROR';

- }

-

- // Which updates do we need to do?

- $update_warning = ($user_warnings != $data['user_warnings']) ? true : false;

- $update_username = ($username != $data['username']) ? $data['username'] : false;

- $update_password = ($user_password != $data['user_password']) ? true : false;

-

- if (!sizeof($error))

- {

- $sql_ary = array(

- 'username' => $data['username'],

- // TODO: check if this user is allowed to change user_type

- 'user_type' => $data['user_founder'],

- 'user_email' => $data['user_email'],

- 'user_email_hash' => crc32(strtolower($data['user_email'])) . strlen($data['user_email']),

- 'user_warnings' => $data['user_warnings'],

- );

-

- if ($update_password)

- {

- $sql_ary += array(

- 'user_password' => md5($data['user_password']),

- 'user_passchg' => time(),

- );

- }

-

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

- WHERE user_id = ' . $user_id;

- $db->sql_query($sql);

-

- // TODO

- if ($update_warning)

- {

- }

-

- if ($update_username)

- {

- user_update_name($update_username, $userrow['username']);

- }

-

- trigger_error($user->lang['USER_OVERVIEW_UPDATED']);

- }

-

- // Replace "error" strings with their real, localised form

- $error = preg_replace('#^([A-Z_]+)$#e', "(!empty(\$user->lang['\\1'])) ? \$user->lang['\\1'] : '\\1'", $error);

- }

- $colspan = 2;

-

- $user_char_ary = array('.*' => 'USERNAME_CHARS_ANY', '[\w]+' => 'USERNAME_ALPHA_ONLY', '[\w_\+\. \-\[\]]+' => 'USERNAME_ALPHA_SPACERS');

- $quick_tool_ary = array('banuser' => 'BAN_USER', 'banemail' => 'BAN_EMAIL', 'banip' => 'BAN_IP', 'active' => (($user_type == USER_INACTIVE) ? 'ACTIVATE' : 'DEACTIVATE'), 'delsig' => 'DEL_SIG', 'delavatar' => 'DEL_AVATAR', 'moveposts' => 'MOVE_POSTS', 'delposts' => 'DEL_POSTS', 'delattach' => 'DEL_ATTACH');

- if ($config['email_enable'])

- {

- $quick_tool_ary['reactivate'] = 'FORCE';

- }

-

- $options = '<option class="sep" value="">' . $user->lang['SELECT_OPTION'] . '</option>';

- foreach ($quick_tool_ary as $value => $lang)

- {

- $options .= '<option value="' . $value . '">' . $user->lang['USER_ADMIN_' . $lang] . '</option>';

- }

-

- $user_founder_yes = ($userrow['user_type'] == USER_FOUNDER) ? ' checked="checked"' : '';

- $user_founder_no = ($userrow['user_type'] != USER_FOUNDER) ? ' checked="checked"' : (($user->data['user_type'] != USER_FOUNDER) ? ' disabled="disabled"' : '');

-

- foreach($error as $error_msg)

- {

-?>

- <tr>

- <td colspan="2"><?php echo $error_msg;?></td>

- </tr>

-<?php

- }

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['USER_ADMIN_OVERVIEW']; ?></th>

- </tr>

- <tr>

- <td class="row1" width="40%"><?php echo $user->lang['USERNAME']; ?>: <br /><span class="gensmall"><?php echo sprintf($user->lang[$user_char_ary[str_replace('\\\\', '\\', $config['allow_name_chars'])] . '_EXPLAIN'], $config['min_name_chars'], $config['max_name_chars']); ?></span></td>

- <td class="row2"><input class="post" type="text" name="username" value="<?php echo $userrow['username']; ?>" maxlength="60" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['REGISTERED']; ?>: </td>

- <td class="row2"><strong><?php echo $user->format_date($userrow['user_regdate']); ?></strong></td>

- </tr>

-<?php

-

- if ($userrow['user_ip'])

- {

-

-?>

- <tr>

- <td class="row1"><?php echo $user->lang['REGISTERED_IP']; ?>: </td>

- <td class="row2"><strong><?php echo "<a href=\"admin_users.$phpEx$SID&amp;action=$action&amp;u=$user_id&amp;ip=" . ((!$ip || $ip == 'ip') ? 'hostname' : 'ip') . '">' . (($ip == 'hostname') ? gethostbyaddr($user_ip) : $user_ip) . "</a> [ <a href=\"admin_users.$phpEx$SID&amp;action=whois&amp;ip=" . $userrow['user_ip'] . "\" onclick=\"window.open('admin_users.$phpEx$SID&amp;action=whois&amp;ip=" . $userrow['user_ip'] . "', 'HEIGHT=500,resizable=yes,scrollbars=yes,WIDTH=600');return false;\">" . $user->lang['WHOIS'] . '</a> ]'; ?></strong></td>

- </tr>

-<?php

-

- }

-?>

- <tr>

- <td class="row1" width="40%"><?php echo $user->lang['LAST_ACTIVE']; ?>: </td>

- <td class="row2"><strong><?php echo $user->format_date($userrow['user_lastvisit']); ?></strong></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['FOUNDER']; ?>: <br /><span class="gensmall"><?php echo $user->lang['FOUNDER_EXPLAIN']; ?></span></td>

- <td class="row2"><input type="radio" name="user_founder" value="1"<?php echo $user_founder_yes; ?> /><?php echo $user->lang['YES']; ?>&nbsp;<input type="radio" name="user_founder" value="0"<?php echo $user_founder_no; ?> /><?php echo $user->lang['NO']; ?></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['EMAIL']; ?>: </td>

- <td class="row2"><input class="post" type="text" name="user_email" value="<?php echo $userrow['user_email']; ?>" maxlength="60" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['CONFIRM_EMAIL']; ?>: <br /><span class="gensmall"><?php echo $user->lang['CONFIRM_EMAIL_EXPLAIN']; ?></span></td>

- <td class="row2"><input class="post" type="text" name="email_confirm" value="<?php echo $email_confirm; ?>" maxlength="60" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['NEW_PASSWORD']; ?>: <br /><span class="gensmall"><?php echo sprintf($user->lang['CHANGE_PASSWORD_EXPLAIN'], $config['min_pass_chars'], $config['max_pass_chars']) ?></span></td>

- <td class="row2"><input class="post" type="password" name="user_password" value="<?php echo ($submit) ? $user_password : ''; ?>" maxlength="60" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['CONFIRM_PASSWORD']; ?>: <br /><span class="gensmall"><?php echo $user->lang['CONFIRM_PASSWORD_EXPLAIN']; ?></span></td>

- <td class="row2"><input class="post" type="password" name="password_confirm" value="<?php echo ($submit) ? $user_password_confirm : ''; ?>" maxlength="60" /></td>

- </tr>

-<?php

-

- if ($userrow['user_type'] != USER_FOUNDER)

- {

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['USER_TOOLS']; ?></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['WARNINGS']; ?>: <br /><span class="gensmall"><?php echo $user->lang['WARNINGS_EXPLAIN']; ?></span></td>

- <td class="row2"><input class="post" type="text" name="warnings" size="2" maxlength="2" value="<?php echo $userrow['user_warnings']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['QUICK_TOOLS']; ?>: </td>

- <td class="row2"><select name="quicktools"><?php echo $options; ?></select></td>

- </tr>

- <tr>

- <td class="row1"><?php echo $user->lang['DELETE_USER']; ?>: <br /><span class="gensmall"><?php echo $user->lang['DELETE_USER_EXPLAIN']; ?></span></td>

- <td class="row2"><select name="deletetype"><option value="retain"><?php echo $user->lang['RETAIN_POSTS']; ?></option><option value="remove"><?php echo $user->lang['DELETE_POSTS']; ?></option></select> <input type="checkbox" name="delete" value="1" /> </td>

- </tr>

-<?php

-

- }

-

-?>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

- </tr>

-<?php

-

- break;

-

- case 'feedback':

-

- if ($submit)

- {

- if (($deletemark || $deleteall) && $auth->acl_get('a_clearlogs'))

- {

- $where_sql = '';

- if ($deletemark && $marked)

- {

- $sql_in = array();

- foreach ($marked as $mark)

- {

- $sql_in[] = $mark;

- }

- $where_sql = ' AND log_id IN (' . implode(', ', $sql_in) . ')';

- unset($sql_in);

- }

-

- $sql = 'DELETE FROM ' . LOG_TABLE . '

- WHERE log_type = ' . LOG_USERS . "

- $where_sql";

- $db->sql_query($sql);

-

- add_log('admin', 'LOG_USERS_CLEAR');

- trigger_error("");

- }

-

- if ($message = request_var('message', ''))

- {

- add_log('admin', 'LOG_USER_FEEDBACK', $username);

- add_log('user', $user_id, 'LOG_USER_GENERAL', $message);

-

- trigger_error($user->lang['USER_FEEDBACK_ADDED']);

- }

- }

-

- $colspan = 2;

-

- $limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 364 => $user->lang['1_YEAR']);

- $sort_by_text = array('a' => $user->lang['SORT_USERNAME'], 'b' => $user->lang['SORT_DATE'], 'c' => $user->lang['SORT_IP'], 'd' => $user->lang['SORT_ACTION']);

- $sort_by_sql = array('a' => 'l.user_id', 'b' => 'l.log_time', 'c' => 'l.log_ip', 'd' => 'l.log_operation');

-

- $s_limit_days = $s_sort_key = $s_sort_dir = '';

- gen_sort_selects($limit_days, $sort_by_text, $st, $sk, $sd, $s_limit_days, $s_sort_key, $s_sort_dir);

-

- // Define where and sort sql for use in displaying logs

- $sql_where = ($st) ? (time() - ($st * 86400)) : 0;

- $sql_sort = $sort_by_sql[$sk] . ' ' . (($sd == 'd') ? 'DESC' : 'ASC');

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['USER_ADMIN_FEEDBACK']; ?></th>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><?php echo $user->lang['DISPLAY_LOG']; ?>: &nbsp;<?php echo $s_limit_days; ?>&nbsp;<?php echo $user->lang['SORT_BY']; ?>: <?php echo $s_sort_key; ?> <?php echo $s_sort_dir; ?>&nbsp;<input class="btnlite" type="submit" value="<?php echo $user->lang['GO']; ?>" name="sort" /></td>

- </tr>

-<?php

-

- $log_data = array();

- $log_count = 0;

- view_log('user', $log_data, $log_count, $config['posts_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort);

-

- if ($log_count)

- {

- for($i = 0; $i < sizeof($log_data); $i++)

- {

- $row_class = ($row_class == 'row1') ? 'row2' : 'row1';

-

-?>

- <tr>

- <td class="<?php echo $row_class; ?>"><span class="gensmall">Report by: <b><?php echo $log_data[$i]['username']; ?></b> on <?php echo $user->format_date($log_data[$i]['time']); ?></span><hr /><?php echo $log_data[$i]['action']; ?></td>

- <td class="<?php echo $row_class; ?>" width="5%" align="center"><input type="checkbox" name="mark[]" value="<?php echo $log_data[$i]['id']; ?>" /></td>

- </tr>

-<?php

-

- }

- }

- else

- {

-

-?>

- <tr>

- <td class="row1" colspan="2" align="center">No reports exist for this user</td>

- </tr>

-<?php

-

- }

-

-

-?>

- <tr>

- <td class="cat" colspan="2" align="right"><?php

-

- if ($auth->acl_get('a_clearlogs'))

- {

-

-?><input class="btnlite" type="submit" name="delmarked" value="<?php echo $user->lang['DELETE_MARKED']; ?>" />&nbsp; <input class="btnlite" type="submit" name="delall" value="<?php echo $user->lang['DELETE_ALL']; ?>" /><?php

-

- }

-

-?>&nbsp;</td>

- </tr>

- </table></td>

- </tr>

- <tr>

- <td class="nav"><div style="float:left;"><?php echo on_page($log_count, $config['topics_per_page'], $start); ?></div><div style="float:right;"><b><a href="javascript:marklist('admin', true);"><?php echo $user->lang['MARK_ALL']; ?></a> :: <a href="javascript:marklist('admin', false);"><?php echo $user->lang['UNMARK_ALL']; ?></a></b>&nbsp;<br /><br /><?php

-

- echo generate_pagination("admin_users.$phpEx$SID&amp;action=$action&amp;u=$user_id&amp;st=$st&amp;sk=$sk&amp;sd=$sd", $log_count, $config['posts_per_page'], $start);

-

-?></div></td>

- </tr>

-</table>

-

-<script language="Javascript" type="text/javascript">

-<!--

-function marklist(match, status)

-{

- len = eval('document.' + match + '.length');

- for (i = 0; i < len; i++)

- {

- eval('document.' + match + '.elements[i].checked = ' + status);

- }

-}

-//-->

-</script>

-

-<h1><?php echo $user->lang['ADD_FEEDBACK']; ?></h1>

-

-<p><?php echo $user->lang['ADD_FEEDBACK_EXPLAIN']; ?></p>

-

-<table width="100%" cellspacing="2" cellpadding="0" border="0" align="center">

- <tr>

- <td><table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0">

- <tr>

- <th colspan="2"><?php echo $user->lang['USER_ADMIN_' . strtoupper($action)]; ?></th>

- </tr>

- <tr>

- <td class="row1" colspan="2" align="center"><textarea name="message" rows="10" cols="76"></textarea></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

- </tr>

-<?php

-

-

- break;

-

-

- case 'profile':

-

- if ($submit)

- {

- $var_ary = array(

- 'icq' => (string) '',

- 'aim' => (string) '',

- 'msn' => (string) '',

- 'yim' => (string) '',

- 'jabber' => (string) '',

- 'website' => (string) '',

- 'location' => (string) '',

- 'occupation' => (string) '',

- 'interests' => (string) '',

- 'bday_day' => 0,

- 'bday_month' => 0,

- 'bday_year' => 0,

- );

-

- foreach ($var_ary as $var => $default)

- {

- $data[$var] = request_var($var, $default);

- }

-

- $var_ary = array(

- 'icq' => array(

- array('string', true, 3, 15),

- array('match', true, '#^[0-9]+$#i')),

- 'aim' => array('string', true, 5, 255),

- 'msn' => array('string', true, 5, 255),

- 'jabber' => array(

- array('string', true, 5, 255),

- array('match', true, '#^[a-z0-9\.\-_\+]+?@(.*?\.)*?[a-z0-9\-_]+?\.[a-z]{2,4}(/.*)?$#i')),

- 'yim' => array('string', true, 5, 255),

- 'website' => array(

- array('string', true, 12, 255),

- array('match', true, '#^http[s]?://(.*?\.)*?[a-z0-9\-]+\.[a-z]{2,4}#i')),

- 'location' => array('string', true, 2, 255),

- 'occupation' => array('string', true, 2, 500),

- 'interests' => array('string', true, 2, 500),

- 'bday_day' => array('num', true, 1, 31),

- 'bday_month' => array('num', true, 1, 12),

- 'bday_year' => array('num', true, 1901, gmdate('Y', time())),

- );

-

- $error = validate_data($data, $var_ary);

-

- // validate custom profile fields

- // $cp->submit_cp_field('profile', $cp_data, $cp_error);

-

- if (!sizeof($error) && !sizeof($cp_error))

- {

- $sql_ary = array(

- 'user_icq' => $data['icq'],

- 'user_aim' => $data['aim'],

- 'user_msnm' => $data['msn'],

- 'user_yim' => $data['yim'],

- 'user_jabber' => $data['jabber'],

- 'user_website' => $data['website'],

- 'user_from' => $data['location'],

- 'user_occ' => $data['occupation'],

- 'user_interests'=> $data['interests'],

- 'user_birthday' => sprintf('%2d-%2d-%4d', $data['bday_day'], $data['bday_month'], $data['bday_year']),

- );

-

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

- WHERE user_id = $user_id";

- $db->sql_query($sql);

-

- /*

- // Update Custom Fields

- if (sizeof($cp_data))

- {

- $sql = 'UPDATE ' . PROFILE_DATA_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $cp_data) . "

- WHERE user_id = $user_id";

- $db->sql_query($sql);

-

- if (!$db->sql_affectedrows())

- {

- $cp_data['user_id'] = $user_id;

-

- $db->return_on_error = true;

-

- $sql = 'INSERT INTO ' . PROFILE_DATA_TABLE . ' ' . $db->sql_build_array('INSERT', $cp_data);

- $db->sql_query();

-

- $db->return_on_error = false;

- }

- }

- */

- trigger_error($user->lang['USER_PROFILE_UPDATED']);

- }

- }

-

- $colspan = 2;

-

- $cp = new custom_profile();

-

- $cp_data = $cp_error = array();

-

- if (!isset($userrow['bday_day']))

- {

- list($userrow['bday_day'], $userrow['bday_month'], $userrow['bday_year']) = explode('-', $userrow['user_birthday']);

- }

-

- $s_birthday_day_options = '<option value="0"' . ((!$bday_day) ? ' selected="selected"' : '') . '>--</option>';

- for ($i = 1; $i < 32; $i++)

- {

- $selected = ($i == $userrow['bday_day']) ? ' selected="selected"' : '';

- $s_birthday_day_options .= "<option value=\"$i\"$selected>$i</option>";

- }

-

- $s_birthday_month_options = '<option value="0"' . ((!$userrow['bday_month']) ? ' selected="selected"' : '') . '>--</option>';

- for ($i = 1; $i < 13; $i++)

- {

- $selected = ($i == $userrow['bday_month']) ? ' selected="selected"' : '';

- $s_birthday_month_options .= "<option value=\"$i\"$selected>$i</option>";

- }

- $s_birthday_year_options = '';

-

- $now = getdate();

- $s_birthday_year_options = '<option value="0"' . ((!$userrow['bday_year']) ? ' selected="selected"' : '') . '>--</option>';

- for ($i = $now['year'] - 100; $i < $now['year']; $i++)

- {

- $selected = ($i == $userrow['bday_year']) ? ' selected="selected"' : '';

- $s_birthday_year_options .= "<option value=\"$i\"$selected>$i</option>";

- }

- unset($now);

-

- // Get additional profile fields and assign them to the template block var 'profile_fields'

-// $user->get_profile_fields($user->data['user_id']);

-// $cp->generate_profile_fields('profile', $user->get_iso_lang_id(), $cp_error);

-

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['USER_ADMIN_SIG']; ?></th>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['UCP_ICQ']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="icq" size="30" maxlength="15" value="<?php echo $userrow['user_icq']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['UCP_AIM']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="aim" size="30" maxlength="255" value="<?php echo $userrow['user_aim']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['UCP_MSNM']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="msn" size="30" maxlength="255" value="<?php echo $userrow['user_msnm']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['UCP_YIM']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="yim" size="30" maxlength="255" value="<?php echo $userrow['user_yim']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['UCP_JABBER']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="jabber" size="30" maxlength="255" value="<?php echo $userrow['user_jabber']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['WEBSITE']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="website" size="30" maxlength="255" value="<?php echo $userrow['user_website']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['LOCATION']; ?>: </b></td>

- <td class="row2"><input class="post" type="text" name="location" size="30" maxlength="100" value="<?php echo $userrow['user_from']; ?>" /></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['OCCUPATION']; ?>: </b></td>

- <td class="row2"><textarea class="post" name="occupation" rows="3" cols="30"><?php echo $userrow['user_occ']; ?></textarea></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['INTERESTS']; ?>: </b></td>

- <td class="row2"><textarea class="post" name="interests" rows="3" cols="30"><?php echo $userrow['user_interests']; ?></textarea></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['BIRTHDAY']; ?>: </b><br /><span class="gensmall"><?php echo $user->lang['BIRTHDAY_EXPLAIN']; ?></span></td>

- <td class="row2"><span class="genmed"><?php echo $user->lang['DAY']; ?>:</span> <select name="bday_day"><?php echo $s_birthday_day_options; ?></select> <span class="genmed"><?php echo $user->lang['MONTH']; ?>:</span> <select name="bday_month"><?php echo $s_birthday_month_options; ?></select> <span class="genmed"><?php echo $user->lang['YEAR']; ?>:</span> <select name="bday_year"><?php echo $s_birthday_year_options; ?></select></td>

- </tr>

- <tr>

- <td class="cat" colspan="2" align="center"><input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['SUBMIT']; ?>" />&nbsp;&nbsp;<input class="btnlite" type="reset" value="<?php echo $user->lang['RESET']; ?>" /></td>

- </tr>

-<?php

-

- break;

-

-

- case 'prefs':

-

- if ($submit)

- {

- $var_ary = array(

- 'user_dateformat' => (string) $config['default_dateformat'],

- 'user_lang' => (string) $config['default_lang'],

- 'user_tz' => (float) $config['board_timezone'],

- 'user_style' => (int) $config['default_style'],

- 'user_dst' => (bool) $config['board_dst'],

- 'user_allow_viewemail' => false,

- 'user_allow_massemail' => true,

- 'user_allow_viewonline' => true,

- 'user_notify_type' => 0,

- 'user_notify_pm' => true,

- 'user_allow_pm' => true,

- 'user_notify' => false,

-

- 'sk' => (string) 't',

- 'sd' => (string) 'd',

- 'st' => 0,

-

- 'popuppm' => false,

- 'viewimg' => true,

- 'viewflash' => false,

- 'viewsmilies' => true,

- 'viewsigs' => true,

- 'viewavatars' => true,

- 'viewcensors' => false,

- 'bbcode' => true,

- 'html' => false,

- 'smilies' => true,

- 'attachsig' => true,

- );

-

- foreach ($var_ary as $var => $default)

- {

- $data[$var] = request_var($var, $default);

- }

-

- $var_ary = array(

- 'user_dateformat' => array('string', false, 3, 15),

- 'user_lang' => array('match', false, '#^[a-z_]{2,}$#i'),

- 'user_tz' => array('num', false, -13, 13),

-

- 'sk' => array('string', false, 1, 1),

- 'sd' => array('string', false, 1, 1),

- );

-

- $error = validate_data($data, $var_ary);

-

- // Set the popuppm option

- $option_ary = array('popuppm', 'viewimg', 'viewflash', 'viewsmilies', 'viewsigs', 'viewavatars', 'viewcensors', 'bbcode', 'html', 'smilies', 'attachsig');

-

- foreach ($option_ary as $option)

- {

- $user_options = $user->optionset($option, $$option, $user_options);

- }

-

- if (!sizeof($error))

- {

- $sql_ary = array(

- 'user_allow_pm' => $data['user_allow_pm'],

- 'user_allow_viewemail' => $data['user_allow_viewemail'],

- 'user_allow_massemail' => $data['user_allow_massemail'],

- 'user_allow_viewonline' => $data['user_allow_viewonline'],

- 'user_notify_type' => $data['user_notify_type'],

- 'user_notify_pm' => $data['user_notify_pm'],

- 'user_options' => $data['user_options'],

- 'user_notify' => $data['user_notify'],

- 'user_dst' => $data['user_dst'],

- 'user_dateformat' => $data['user_dateformat'],

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

- 'user_timezone' => $data['user_tz'],

- 'user_style' => $data['user_style'],

- 'user_sortby_type' => $data['sk'],

- 'user_sortby_dir' => $data['sd'],

- 'user_show_days' => $data['st'],

- );

-

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

- WHERE user_id = $user_id";

- $db->sql_query($sql);

-

- trigger_error($user->lang['USER_PREFS_UPDATED']);

- }

-

- $user_sortby_type = $sk;

- $user_sortby_dir = $sd;

- $user_show_days = $st;

- }

-

- $colspan = 2;

-

- $option_ary = array('user_allow_viewemail', 'user_allow_massemail', 'user_allow_pm', 'user_allow_viewonline', 'user_notify_pm', 'user_dst', 'user_notify');

-

- foreach ($option_ary as $option)

- {

- ${$option . '_yes'} = ($userrow[$option]) ? ' checked="checked"' : '';

- ${$option . '_no'} = (!$userrow[$option]) ? ' checked="checked"' : '';

- }

- unset($option_ary);

-

- $option_ary = array('popuppm', 'viewimg', 'viewflash', 'viewsmilies', 'viewsigs', 'viewavatars', 'viewcensors', 'bbcode', 'html', 'smilies', 'attachsig');

-

- foreach ($option_ary as $option)

- {

- ${$option . '_yes'} = ($user->optionget($userrow[$option], $user_options)) ? ' checked="checked"' : '';

- ${$option . '_no'} = (!$user->optionget($userrow[$option], $user_options)) ? ' checked="checked"' : '';

- }

-

- $notify_email = ($userrow['user_notify_type'] == NOTIFY_EMAIL) ? ' checked="checked"' : '';

- $notify_im = ($userrow['user_notify_type'] == NOTIFY_IM) ? ' checked="checked"' : '';

- $notify_both = ($userrow['user_notify_type'] == NOTIFY_BOTH) ? ' checked="checked"' : '';

-

- // Topic ordering display

- $limit_days = array(0 => $user->lang['ALL_TOPICS'], 0 => $user->lang['ALL_TOPICS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 364 => $user->lang['1_YEAR']);

-

- $sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 'r' => $user->lang['REPLIES'], 's' => $user->lang['SUBJECT'], 'v' => $user->lang['VIEWS']);

- $sort_by_sql = array('a' => 't.topic_first_poster_name', 't' => 't.topic_last_post_time', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

-

- $s_limit_days = $s_sort_key = $s_sort_dir = '';

- gen_sort_selects($limit_days, $sort_by_text, $userrow['user_show_days'], $userrow['user_sortby_type'], $userrow['user_sortby_dir'], $s_limit_days, $s_sort_key, $s_sort_dir);

-

-?>

- <tr>

- <th colspan="2"><?php echo $user->lang['USER_ADMIN_PREFS']; ?></th>

- </tr>

- <tr>

- <td class="row1" width="40%"><b><?php echo $user->lang['VIEW_IMAGES']; ?>:</b></td>

- <td class="row2"><input type="radio" name="viewimg" value="1"<?php echo $viewimg_yes; ?> /><span class="gen"><?php echo $user->lang['YES']; ?></span>&nbsp;&nbsp;<input type="radio" name="viewimg" value="0"<?php echo $viewimg_no; ?> /><span class="gen"><?php echo $user->lang['NO']; ?></span></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['VIEW_FLASH']; ?>:</b></td>

- <td class="row2"><input type="radio" name="viewflash" value="1"<?php echo $viewflash_yes; ?> /><span class="gen"><?php echo $user->lang['YES']; ?></span>&nbsp;&nbsp;<input type="radio" name="viewflash" value="0"<?php echo $viewflash_no; ?> /><span class="gen"><?php echo $user->lang['NO']; ?></span></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['VIEW_SMILIES']; ?>:</b></td>

- <td class="row2"><input type="radio" name="viewsmilies" value="1"<?php echo $viewsmilies_yes; ?> /><span class="gen"><?php echo $user->lang['YES']; ?></span>&nbsp;&nbsp;<input type="radio" name="viewsmilies" value="0"<?php echo $viewsmilies_no; ?> /><span class="gen"><?php echo $user->lang['NO']; ?></span></td>

- </tr>

- <tr>

- <td class="row1"><b><?php echo $user->lang['VIEW_SIGS']; ?>:</b></td>

- <td class="row2"><input type="radio" name="viewsigs" value="1"<?php echo $viewsigs_yes; ?> /><span class="gen"><?php echo $user->lang['YES']; ?></span>&nbsp;&nbsp;<input type="radio" name="viewsigs" value="0"<?php echo $viewsigs_no; ?> /><span class="gen"><?php echo $user->lang['NO']; ?></span></td>

- </tr>

- <tr>