foreach ($newfiles as $file) {
$db->query("INSERT INTO permissions (name) VALUES('{$file}')");
}
$orphans = array_filter(array_diff($perm_files, $allfiles));
foreach ($orphans as $orphan) {
$db->query("DELETE FROM permissions WHERE name = '{$orphan}'");
}
$group_query = implode(",", $group_queries);
$permission_table = $db->query("SELECT *,\n\t\t\t\t\t\t\t\t{$group_query}\n\t\t\t\t\t\t\t\tFROM permissions p\n\t\t\t\t\t\t\t\tORDER BY name ASC\n\t\t\t\t\t\t\t\t");
$groups = $db->query("SELECT ug.*, count(u.id) user_count FROM `user_groups` ug\nLEFT JOIN users u ON u.group_id = ug.group_id\nGROUP BY ug.group_id");
$users = $db->query("SELECT u.*, count(l.id) listings FROM users u\nLEFT JOIN listings l ON u.id = l.user_id\nGROUP BY u.id");
while ($user = $db->fetchNextObject($users)) {
$group_users[$user->group_id][] = objectToArray($user);
}
$emailTemplates = $db->query("SELECT * FROM email_templates");
$settings = reloadSettings();
$stylesheets = array("css/validationEngine.jquery.css");
$scripts = array("js/jquery.validationEngine.js", "js/jquery.validationEngine-en.js");
$title = "Administration";
include "head.php";
?>
<div id="content">
<div style="overflow:visible;position:relative;width:1000px;height:120px;">
<span class="header-explode" style="margin-right:20px;">Administration</span>
</div>
<div class="side-nav floatleft">
<ul class="first">
<li><a href="#overview">Admin Overview</a></li>
</ul>
<ul>
require_once $sourcedir . '/Security.php';
require_once $sourcedir . '/Subs-Portal.php';
// Using an pre-PHP 5.1 version?
if (@version_compare(PHP_VERSION, '5.1') == -1) {
require_once $sourcedir . '/Subs-Compat.php';
}
// If $maintenance is set specifically to 2, then we're upgrading or something.
if (!empty($maintenance) && $maintenance == 2) {
db_fatal_error();
}
// Create a variable to store some SMF specific functions in.
$smcFunc = array();
// Initate the database connection and define some database functions to use.
loadDatabase();
// Load the settings from the settings table, and perform operations like optimizing.
reloadSettings();
// Clean the request variables, add slashes, etc.
cleanRequest();
$context = array();
// Seed the random generator.
if (empty($modSettings['rand_seed']) || mt_rand(1, 250) == 69) {
smf_seed_generator();
}
// Before we get carried away, are we doing a scheduled task? If so save CPU cycles by jumping out!
if (isset($_GET['scheduled'])) {
require_once $sourcedir . '/ScheduledTasks.php';
AutoTask();
}
// Check if compressed output is enabled, supported, and not already being done.
if (!empty($modSettings['enableCompressedOutput']) && !headers_sent()) {
// If zlib is being used, turn off output compression.
function udb_authenticate()
{
global $HTTP_COOKIE_VARS, $USER_DATA, $UDB_DB_LINK_ID, $UDB_DB_NAME_PREFIX, $CONFIG;
global $HTTP_SERVER_VARS, $HTTP_X_FORWARDED_FOR, $HTTP_PROXY_USER, $REMOTE_ADDR;
global $password, $username, $pwseed, $settings, $ID_MEMBER, $realname, $txt, $user_info, $user_settings;
$pwseed = SMF_PASSWD_SEED;
session_start();
reloadSettings();
LoadUserSettings();
// For error checking
$CONFIG['TABLE_USERS'] = '**ERROR**';
// get first 50 chars
$HTTP_USER_AGENT = substr($HTTP_SERVER_VARS['HTTP_USER_AGENT'], 0, 50);
$REMOTE_ADDR = substr($HTTP_SERVER_VARS['REMOTE_ADDR'], 0, 50);
/* If the user is a guest, initialize all the critial user settings */
if (!$ID_MEMBER) {
$USER_DATA = cpgGetUserData(SMF_GUEST_GROUP, array(SMF_GUEST_GROUP), SMF_GUEST_GROUP);
define('USER_ID', 0);
define('USER_NAME', 'Anonymous');
define('USER_GROUP_SET', '(' . SMF_GUEST_GROUP . ')');
define('USER_IS_ADMIN', 0);
define('USER_CAN_SEND_ECARDS', (int) $USER_DATA['can_send_ecards']);
define('USER_CAN_RATE_PICTURES', (int) $USER_DATA['can_rate_pictures']);
define('USER_CAN_POST_COMMENTS', (int) $USER_DATA['can_post_comments']);
define('USER_CAN_UPLOAD_PICTURES', (int) $USER_DATA['can_upload_pictures']);
define('USER_CAN_CREATE_ALBUMS', 0);
define('USER_UPLOAD_FORM', (int) $USER_DATA['upload_form_config']);
define('CUSTOMIZE_UPLOAD_FORM', (int) $USER_DATA['custom_user_upload']);
define('NUM_FILE_BOXES', (int) $USER_DATA['num_file_upload']);
define('NUM_URI_BOXES', (int) $USER_DATA['num_URI_upload']);
} else {
if ($user_settings['ID_GROUP']) {
$cm_group_id = $user_settings['ID_GROUP'];
} else {
if ($user_settings['ID_POST_GROUP'] && defined('USE_POST_GROUPS')) {
$cm_group_id = $user_settings['ID_POST_GROUP'];
} else {
$cm_group_id = SMF_MEMBERS_GROUP;
}
}
// Retrieve group information
$USER_DATA = cpgGetUserData($cm_group_id, $user_info['groups'], SMF_GUEST_GROUP);
$USER_DATA['has_admin_access'] = $user_info['is_admin'];
$USER_DATA['can_see_all_albums'] = $USER_DATA['has_admin_access'] | in_array(SMF_GMOD_GROUP, $user_info['groups']);
define('USER_ID', $ID_MEMBER);
define('USER_NAME', $user_info['name']);
define('SMF_USER_NAME', $user_info['username']);
define('USER_GROUP', $USER_DATA['group_name']);
define('USER_GROUP_SET', '(' . implode(",", $USER_DATA['groups']) . ')');
define('USER_IS_ADMIN', $user_info['is_admin']);
define('USER_CAN_SEND_ECARDS', (int) $USER_DATA['can_send_ecards']);
define('USER_CAN_RATE_PICTURES', (int) $USER_DATA['can_rate_pictures']);
define('USER_CAN_POST_COMMENTS', (int) $USER_DATA['can_post_comments']);
define('USER_CAN_UPLOAD_PICTURES', (int) $USER_DATA['can_upload_pictures']);
define('USER_CAN_CREATE_ALBUMS', (int) $USER_DATA['can_create_albums']);
define('USER_UPLOAD_FORM', (int) $USER_DATA['upload_form_config']);
define('CUSTOMIZE_UPLOAD_FORM', (int) $USER_DATA['custom_user_upload']);
define('NUM_FILE_BOXES', (int) $USER_DATA['num_file_upload']);
define('NUM_URI_BOXES', (int) $USER_DATA['num_URI_upload']);
}
}