}
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;
}
