+// -------------------------------------------------------------

+//

+// $Id$

+//

+// FILENAME : admin_database.php

+// STARTED : Thu May 31, 2001

+// COPYRIGHT : © 2003 phpBB Group

+// WWW : http://www.phpbb.com/

+// LICENCE : GPL vs2.0 [ see /docs/COPYING ]

+//

+// -------------------------------------------------------------

+ $module['DB']['DB_RESTORE'] = "$filenamex$SID&mode=restore";

+include($phpbb_root_path . 'functions_compress.'.$phpEx);

+

+// Get some vars

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

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

+

+

+// --------------------

+// --------------------

+ $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)

+ {

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

+<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">

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

+ <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>

+ <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>

+ <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>

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

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

+ {/*

+ break;*/

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

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

+ case 'approve':

+ approve_user($group_id, $mark_ary, false, $group_name);

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

+ case 'default':

+ set_default_group($group_id, $mark_ary, false, $group_name, $group_colour, $group_rank, false, false);

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

+

+ case 'delete':

+ case 'deleteusers':

+ case 'demote':

+ if ($error = remove_from_group($action, $group_id, $mark_ary, false, $group_name))

+ {

+ trigger_error($user->lang[$error]);

+ }

+

+ $message = ($action == 'demote') ? 'GROUP_MODS_DEMOTED' : (($action == 'deleteusers') ? 'GROUP_USERS_REMOVE' : 'GROUP_DELETED');

+ trigger_error($user->lang[$message]);

+ case 'addleaders':

+ case 'addusers':

+ if (!$name_ary)

+ {

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

+ }

+

+ // Add user/s to group

+ if ($error = add_to_group($action, $group_id, false, $name_ary, $group_colour, $group_rank, $group_avatar, $group_avatar_type))

+ {

+ trigger_error($user->lang[$error]);

+ }

+

+ $message = ($action == 'addleaders') ? 'GROUP_MODS_ADDED' : 'GROUP_USERS_ADDED';

+ trigger_error($user->lang[$message]);

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

+ </tr>

+ <tr>

+ <td class="cat" colspan="5" align="right">Select option: <select name="action"><option value="default">Default</option><option value="demote">Demote</option><option value="delete">Delete</option></select> <input class="btnmain" type="submit" name="update" value="<?php echo $user->lang['UPDATE']; ?>" />&nbsp;</td>

+ // Setting groupwide preferences

+ if ($update)

+ {

+ }

+ else

+ {

+ $user_lang = (!empty($_POST['user_lang'])) ? htmlspecialchars($_POST['user_lang']) : '';

+ $user_tz = (isset($_POST['user_tz'])) ? doubleval($_POST['user_tz']) : '';

+ $user_dst = (isset($_POST['user_dst'])) ? intval($_POST['user_dst']) : '';

+ }

+ adm_page_footer();

+ break;

+ default:

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

+exit;

+ $img = "$path$img";

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

+

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

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

+

+ if (isset($_REQUEST['u']))

+ $sql = 'UPDATE ' . POSTS_TABLE . '

+ SET poster_id = ' . ANONYMOUS . "

+ $sql = 'UPDATE ' . TOPICS_TABLE . '

+ SET topic_poster = ' . ANONYMOUS . "

+ $table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE);

+ foreach ($table_ary as $table)

+ {

+ $sql = "DELETE FROM $table

+ WHERE user_id = $user_id";

+ $db->sql_query($sql);

+ }

+ <td align="right"><b>Main</b> | <a href="admin_users.<?php echo $phpEx . $SID; ?>&amp;u=<?php echo $userdata['user_id']; ?>&amp;action=profile">Profile</a> | <a href="admin_users.<?php echo $phpEx . $SID; ?>&amp;u=<?php echo $userdata['user_id']; ?>&amp;action=pref">Preferences</a> | <a href="admin_users.<?php echo $phpEx . $SID; ?>&amp;u=<?php echo $userdata['user_id']; ?>&amp;action=avatar">Avatar</a> | <a href="admin_users.<?php echo $phpEx . $SID; ?>&amp;u=<?php echo $userdata['user_id']; ?>&amp;action=permissions">Permissions</a></td>

+ switch ($action)

+input.checkbox {

+ height: 16px;

+ width: 16px;

+}

+

+ $this->db_connect_id =($this->persistency) ? @ibase_pconnect($this->server, $this->user, $this->password, false, false, 3) : @ibase_connect($this->server, $this->user, $this->password, false, false, 3);

+ if (!$this->transaction && (strpos($query, 'INSERT') === 0 || strpos($query, 'UPDATE') === 0))

+ {

+ echo $query;

+ ibase_commit();

+ }

+

+ return (@ini_get('magic_quotes_sybase') || strtolower(@ini_get('magic_quotes_sybase')) == 'on') ? str_replace('\\\'', '\'', addslashes($msg)) : str_replace('\'', '\'\'', stripslashes($msg));

+ if (($this->query_result = @mysql_query($query, $this->db_connect_id)) === false)

+ $this->connect_string = '';

+// -------------------------------------------------------------

+//

+// $Id$

+//

+// FILENAME : functions.php

+// STARTED : Sat Feb 13, 2001

+// COPYRIGHT : © 2001,2003 phpBB Group

+// WWW : http://www.phpbb.com/

+// LICENCE : GPL vs2.0 [ see /docs/COPYING ]

+//

+// -------------------------------------------------------------

+// $page_string = '<a href="javascript:goto();">' . $user->lang['GOTO_PAGE'] . '</a> ' . $page_string;

+// $template->assign_var('PER_PAGE', $per_page);

+ // TODO

+ // Remove old valid sessions

+

+// -------------------------------------------------------------

+//

+// $Id$

+//

+// FILENAME : functions_admin.php

+// STARTED : Sat Feb 13, 2001

+// COPYRIGHT : © 2001,2003 phpBB Group

+// WWW : http://www.phpbb.com/

+// LICENCE : GPL vs2.0 [ see /docs/COPYING ]

+//

+// -------------------------------------------------------------

+ global $db, $cache;

+

+ $cache->destroy(MODERATOR_TABLE);

+ function SendPresence($type = NULL, $to = NULL, $status = NULL, $show = NULL, $priority = NULL)

+ {

+ $xml = '<presence';

+ $xml .= ($to) ? " to='$to'" : '';

+ $xml .= ($type) ? " type='$type'" : '';

+ $xml .= ($status || $show || $priority) ? ">\n" : " />\n";

+

+ $xml .= ($status) ? " <status>$status</status>\n" : '';

+ $xml .= ($show) ? " <show>$show</show>\n" : '';

+ $xml .= ($priority) ? " <priority>$priority</priority>\n" : '';

+

+ $xml .= ($status || $show || $priority) ? "</presence>\n" : '';

+

+ return ($this->SendPacket($xml)) ? TRUE : FALSE;

+ }

+

+ $user->setup(false);

+

+

+ return;

+ $filesys = str_replace('/','\\', $filename);

+ if (!($deleted = @unlink($filename)))

+ $max_width = 400;

+ $max_height = 200;

+ $tmp_path = $old_file = '';

+ passthru($config['img_imagick'] . 'convert' . ((defined('PHP_OS') && preg_match('#win#i', PHP_OS)) ? '.exe' : '') . ' -quality 85 -antialias -sample ' . $new_size[0] . 'x' . $new_size[1] . ' "' . str_replace('\\', '/', $source) . '" +profile "*" "' . str_replace('\\', '/', $new_file) . '"');

+// Call with: user_id_ary or username_ary set ... if both false entire group

+// will be set default

+// Call with: user_id_ary or username_ary set ... if both false entire group

+// will be approved

+ if (is_array($user_id_ary) || is_array($username_ary))

+ {

+ $sql_where = ($user_id_ary) ? 'user_id IN (' . implode(', ', $user_id_ary) . ')' : 'username IN (' . implode(', ', $username_ary) . ')';

+ $sql = 'SELECT user_id, username

+ FROM ' . USERS_TABLE . "

+ WHERE $sql_where";

+ }

+ else

+ {

+ $sql = 'SELECT u.user_id, u.username

+ FROM ' . USERS_TABLE . ' u, ' . USER_GROUP_TABLE . "

+ WHERE ug.group_id = $group_id

+ AND u.user_id = ug.user_id";

+ }

+ $user_id_ary[] = $row['user_id'];

+ $sql = 'UPDATE ' . USER_GROUP_TABLE . "

+ WHERE group_id = $group_id

+ AND user_id IN (" . implode(', ', $user_id_ary) . ')';

+// If user_id or username_ary are set users are deleted, else group is

+// removed. Setting action to demote true will demote leaders to users

+// (if appropriate), deleting leaders removes them from group as with

+// normal users

+function remove_from_group($type, $id, $user_id_ary, $username_ary, &$group_name)

+{

+ global $db;

+

+ // Delete or demote individuals if data exists, else delete group

+ if (is_array($user_id_ary) || is_array($username_ary))

+ {

+ $sql_where = ($user_id_ary) ? 'user_id IN (' . implode(', ', $user_id_ary) . ')' : 'username IN (' . implode(', ', $username_ary) . ')';

+

+ $sql = 'SELECT user_id, username

+ FROM ' . USERS_TABLE . "

+ WHERE $sql_where";

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

+

+ $usernames = array();

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

+ {

+ $username_ary[] = $row['username'];

+ $user_id_ary[] = $row['user_id'];

+ }

+ $db->sql_freeresult($result);

+

+ switch ($type)

+ {

+ case 'demote':

+ $sql = 'UPDATE ' . USER_GROUP_TABLE . "

+ SET group_leader = 0

+ WHERE $sql_where";

+ $db->sql_query($sql);

+ break;

+

+ default:

+ $sql = 'SELECT g.group_id, g.group_name, u.user_id

+ FROM ' . USER_GROUP_TABLE . ' ug, ' . GROUPS_TABLE . ' g

+ WHERE u.user_id IN ' . implode(', ', $user_id_ary) . "

+ AND ug.group_id <> $group_id

+ AND g.group_type = " . GROUP_SPECIAL . '

+ GROUP BY u.user_id';

+ break;

+ }

+ }

+ else

+ {

+ }

+

+ if (!function_exists('add_log'))

+ {

+ global $phpbb_root_path, $phpEx;

+ include($phpbb_root_path . 'includes/functions_admin.'.$phpEx);

+ }

+

+ $log = ($action == 'demote') ? 'LOG_GROUP_DEMOTED' : (($action == 'deleteusers') ? 'LOG_GROUP_REMOVE' : 'LOG_GROUP_DELETED');

+ add_log('admin', $log, $name, implode(', ', $username_ary));

+

+ return false;

+}

+

+ if (@file_exists('/proc/loadavg'))

+ if ($config['limit_load'] && $load = @file('/proc/loadavg'))

+ var $keyoptions = array('viewimg', 'notify', 'notify_pm', 'popup_pm', 'viewflash', 'viewsmilies', 'viewsigs', 'viewavatars', 'viewcensors', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmile', 'allowavatar', 'allow_pm', 'allow_email', 'allow_viewonline', 'allow_viewemail', 'allow_massemail');

+

+

+ // Start code for checking/setting option bit field for user table (if we go that way)

+ // TODO

+ // array_search begone

+ // set values, blah, everything else

+ function option_set($key, $value = false)

+ {

+ if (is_array($key))

+ {

+ if (is_array($value))

+ {

+ $return = array();

+ foreach ($key as $k)

+ {

+ $return[$key] = ($user->data['user_options'] & pow(2, array_search($key, $this->keyoptions))) ? true : false;

+ }

+ return $return;

+ }

+ else

+ {

+ $return = array();

+ foreach ($key as $k)

+ {

+ $return[$key] = ($user->data['user_options'] & pow(2, array_search($key, $this->keyoptions))) ? true : false;

+ }

+ return $return;

+ }

+ }

+ else

+ {

+ if ($value !== false)

+ {

+ }

+ else

+ {

+ return ($user->data['user_options'] & pow(2, array_search($key, $this->keyoptions))) ? true : false;

+ }

+ }

+ }

+// -------------------------------------------------------------

+//

+// $Id$

+//

+// FILENAME : admin_styles.php

+// STARTED : Thu Aug 7 2003

+// COPYRIGHT : © 2003 phpBB Group

+// WWW : http://www.phpbb.com/

+// LICENCE : GPL vs2.0 [ see /docs/COPYING ]

+//

+// -------------------------------------------------------------

+

+// TODO

+// Check birthday for date in past