} if ($output['status'] == STAT_PENDING) { $output['pending'] = true; } elseif ($output['status'] == STAT_EDIT) { $output['need_edit'] = true; } elseif ($output['status'] == STAT_APPROVED) { $output['approved'] = true; } $query = "SELECT a.`email`,UNIX_TIMESTAMP(a.`last_activity`) as `last_activity`,a.`status`,a.`skin`,b.`m_name` as `membership` FROM `" . USER_ACCOUNTS_TABLE . "` a,`{$dbtable_prefix}memberships` b WHERE a.`membership`=b.`m_value` AND a.`" . USER_ACCOUNT_ID . "`={$uid}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } $account = mysql_fetch_assoc($res); $account['last_activity'] = strftime($config['datetime_format'], $account['last_activity'] + $config['time_offset']); $account['status'] = vector2options($accepted_astats, $account['status']); $account['skin'] = dbtable2options("`{$dbtable_prefix}modules` a,`{$dbtable_prefix}site_options3` b", 'a.`module_code`', 'b.`config_value`', 'b.`config_value`', $account['skin'], "a.`module_code`=b.`fk_module_code` AND a.`module_type`=" . MODULE_SKIN . " AND b.`config_option`='skin_name'"); $query = "SELECT UNIX_TIMESTAMP(`paid_until`) as `paid_until` FROM `{$dbtable_prefix}payments` WHERE `fk_user_id`={$uid} AND `is_subscr`=1 AND `is_active`=1"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $account['paid_until'] = mysql_result($res, 0, 0); if ($account['paid_until'] == 0) { $account['paid_until'] = 'FOREVER'; } else { $account['paid_until'] = strftime($config['datetime_format'], $account['paid_until'] + $config['time_offset']); } } else { $account['paid_until'] = '-'; } $query = "SELECT DISTINCT `ip` FROM `{$dbtable_prefix}site_log` WHERE `fk_user_id`=" . $output['fk_user_id'] . " OR `user`='" . $output['_user'] . "'";
Etano =============================================================================== File: admin/site_skins_addedit.php $Revision$ Software by: DateMill (http://www.datemill.com) Copyright by: DateMill (http://www.datemill.com) Support at: http://www.datemill.com/forum ******************************************************************************* * See the "docs/licenses/etano.txt" file for license. * ******************************************************************************/ require_once '../includes/common.inc.php'; require_once '../includes/admin_functions.inc.php'; require_once '../includes/tables/site_skins.inc.php'; allow_dept(DEPT_ADMIN); $tpl = new phemplate('skin/', 'remove_nonjs'); $site_skins = $site_skins_default['defaults']; if (isset($_SESSION['topass']['input'])) { $site_skins = $_SESSION['topass']['input']; } elseif (!empty($_GET['module_code'])) { $module_code = sanitize_and_format($_GET['module_code'], TYPE_STRING, $__field2format[FIELD_TEXTFIELD]); $site_skins = get_site_option(array(), $module_code); $site_skins = sanitize_and_format($site_skins, TYPE_STRING, $__field2format[TEXT_DB2EDIT]); $site_skins['fk_module_code'] = $module_code; } $site_skins['fk_locale_id'] = dbtable2options("`{$dbtable_prefix}locales`", '`locale_id`', '`locale_name`', '`locale_name`', $site_skins['fk_locale_id']); $tpl->set_file('content', 'site_skins_addedit.html'); $tpl->set_var('site_skins', $site_skins); $tpl->process('content', 'content'); $tplvars['title'] = 'Site Skins'; $tplvars['page'] = 'site_skins_addedit'; include 'frame.php';
$tpl = new phemplate('skin/', 'remove_nonjs'); $subscriptions_auto = $subscriptions_auto_default['defaults']; if (isset($_SESSION['topass']['input'])) { $subscriptions_auto = $_SESSION['topass']['input']; } elseif (!empty($_GET['asubscr_id'])) { $asubscr_id = (int) $_GET['asubscr_id']; $query = "SELECT * FROM `{$dbtable_prefix}subscriptions_auto` WHERE `asubscr_id`={$asubscr_id}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $subscriptions_auto = mysql_fetch_assoc($res); $subscriptions_auto = sanitize_and_format($subscriptions_auto, TYPE_STRING, $__field2format[TEXT_DB2EDIT]); } } $subscriptions_auto['fk_subscr_id'] = dbtable2options("`{$dbtable_prefix}subscriptions`", '`subscr_id`', '`subscr_name`', '`subscr_id`', $subscriptions_auto['fk_subscr_id']); if (empty($subscriptions_auto['dbfield'])) { $subscriptions_auto['to_members_1'] = 'checked="checked"'; } else { $subscriptions_auto['to_members_2'] = 'checked="checked"'; } $dbfields = array(); foreach ($_pfields as $pfield_id => $pfield) { if (get_class($pfield) == 'field_select') { $dbfields[$pfield['dbfield']] = $pfield->config['label'] . ' (' . $pfield->config['dbfield'] . ')'; } } if (!empty($subscriptions_auto['dbfield'])) { $accepted_values = array(); foreach ($_pfields as $pfield_id => $pfield) { if ($pfield->config['dbfield'] == $subscriptions_auto['dbfield']) {
$output['search'] = sanitize_and_format_gpc($_REQUEST, 'search', TYPE_STRING, $__field2format[FIELD_TEXTFIELD], ''); $query = "SELECT `results` FROM `{$dbtable_prefix}site_searches` WHERE `search_md5`='" . $output['search'] . "' AND `search_type`=" . SEARCH_USER; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $results = mysql_result($res, 0, 0); $output['uids'] = explode(',', $results); } } elseif (!empty($_REQUEST['uids'])) { $output['uids'] = sanitize_and_format($_REQUEST['uids'], TYPE_INT, 0, array()); } $output['return2'] = sanitize_and_format_gpc($_GET, 'return', TYPE_STRING, $__field2format[FIELD_TEXTFIELD], ''); $output['return'] = rawurlencode($output['return2']); if (!empty($output['uids'])) { $output['m_value'] = dbtable2options("`{$dbtable_prefix}memberships`", '`m_value`', '`m_name`', '`m_value`', 4, '`m_value`<>1'); $output['users'] = ''; if (count($output['uids']) < 10) { $query = "SELECT `" . USER_ACCOUNT_ID . "` as `user_id`,`" . USER_ACCOUNT_USER . "` as `user` FROM `" . USER_ACCOUNTS_TABLE . "` WHERE `" . USER_ACCOUNT_ID . "` IN ('" . join("','", $output['uids']) . "')"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } while ($rsrow = mysql_fetch_assoc($res)) { $output['users'] .= '<a href="profile.php?uid=' . $rsrow['user_id'] . '">' . $rsrow['user'] . '</a>, '; } $output['users'] = substr($output['users'], 0, -2); } else { $output['users'] = 'Selected members'; } $output['uids'] = join('|', $output['uids']); } else {
$output = $_SESSION['topass']['input']; } elseif (!empty($_GET['rate_id'])) { $rate_id = (int) $_GET['rate_id']; $query = "SELECT * FROM `{$dbtable_prefix}rate_limiter` WHERE `rate_id`={$rate_id}"; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $output = mysql_fetch_assoc($res); } $output['error_message'] = ''; $query = "SELECT `lang_value` FROM `{$dbtable_prefix}lang_strings` WHERE `skin`='" . get_default_skin_code() . "' AND `fk_lk_id`=" . $output['fk_lk_id_error_message']; if (!($res = @mysql_query($query))) { trigger_error(mysql_error(), E_USER_ERROR); } if (mysql_num_rows($res)) { $output['error_message'] = mysql_result($res, 0, 0); } $output = sanitize_and_format($output, TYPE_STRING, $__field2format[TEXT_DB2EDIT]); } $output['m_value'] = dbtable2options("`{$dbtable_prefix}memberships`", '`m_value`', '`m_name`', '`m_value`', $output['m_value']); $output['level_code'] = dbtable2options("`{$dbtable_prefix}access_levels`", '`level_code`', '`level_code`', '`level_id`', $output['level_code']); $output['punishment'] = vector2options($accepted_punishments, $output['punishment']); $output['default_skin'] = get_default_skin_name(); $tpl->set_file('content', 'rate_limiter_addedit.html'); $tpl->set_var('output', $output); $tpl->process('content', 'content'); $tplvars['title'] = 'Limits Management'; $tplvars['page'] = 'rate_limiter_addedit'; $tplvars['css'] = 'rate_limiter_addedit.css'; include 'frame.php';
$temp[$new_field->allowed_search_types[$i]] = $accepted_fieldtype['search'][$new_field->allowed_search_types[$i]]; } // keep $search_type because it is refered from $field->edit_admin() $search_type = !empty($output['search_type']) ? $output['search_type'] : $new_field->allowed_search_types[0]; $output['search_type'] = vector2options($temp, $output['search_type']); // we initialize the search field so we can ask for its admin config in search mode. $search_field = null; if (class_exists($search_type)) { $search_field = new $search_type(array(), true); } if (!empty($search_field)) { $output['custom_config_search'] = $search_field->edit_admin(); } } $output['fieldtype_text'] = $accepted_fieldtype['direct'][$output['field_type']]; $output['searchable'] = !empty($output['searchable']) ? 'checked="checked"' : ''; $output['for_basic'] = !empty($output['for_basic']) ? 'checked="checked"' : ''; $output['at_registration'] = !empty($output['at_registration']) ? 'checked="checked"' : ''; $output['required'] = !empty($output['required']) ? 'checked="checked"' : ''; $output['fk_pcat_id'] = dbtable2options("`{$dbtable_prefix}profile_categories` a LEFT JOIN `{$dbtable_prefix}lang_strings` b ON (a.`fk_lk_id_pcat`=b.`fk_lk_id` AND b.`skin`='{$default_skin_code}')", 'a.`pcat_id`', 'b.`lang_value`', 'a.`pcat_id`', $output['fk_pcat_id']); $output['editable'] = !empty($output['editable']) ? 'checked="checked"' : ''; $output['visible'] = !empty($output['visible']) ? 'checked="checked"' : ''; $output['custom_config_direct'] = $new_field->edit_admin(); $output['default_skin'] = get_default_skin_name(); $tpl->set_file('content', 'profile_fields_addedit.html'); $tpl->set_var('output', $output); $tpl->process('content', 'content', TPL_OPTIONAL); $tplvars['title'] = 'Profile Fields Management'; $tplvars['css'] = 'profile_fields_addedit.css'; $tplvars['page'] = 'profile_fields_addedit'; include 'frame.php';
function edit_admin() { global $dbtable_prefix, $default_skin_code, $output, $__field2format, $search_type; $myreturn = ''; if (!$this->is_search) { $output['def_country'] = !empty($output['def_country']) ? $output['def_country'] : 0; $myreturn .= '<div class="clear"> <label>Default Country:</label> <select id="def_country" name="def_country"><option value="0">Any</option>' . dbtable2options("`{$dbtable_prefix}loc_countries`", '`country_id`', '`country`', '`country`', $output['def_country']) . '</select> </div>'; } return $myreturn; }