admin as a,
reseller_props as r
where
a.admin_id = ? and
r.reseller_id = a.admin_id
SQL_QUERY;
$rs = exec_query($sql, $query, array($edit_id));
if ($rs->RecordCount() <= 0) {
header('Location: manage_users.php');
die;
}
return array($rs->fields['admin_name'], $rs->fields['fname'], $rs->fields['lname'], $rs->fields['firm'], $rs->fields['zip'], $rs->fields['city'], $rs->fields['country'], $rs->fields['email'], $rs->fields['phone'], $rs->fields['fax'], $rs->fields['street1'], $rs->fields['street2'], $rs->fields['max_dmn_cnt'], $rs->fields['current_dmn_cnt'], $rs->fields['max_sub_cnt'], $rs->fields['current_sub_cnt'], $rs->fields['max_als_cnt'], $rs->fields['current_als_cnt'], $rs->fields['max_mail_cnt'], $rs->fields['current_mail_cnt'], $rs->fields['max_ftp_cnt'], $rs->fields['current_ftp_cnt'], $rs->fields['max_sql_db_cnt'], $rs->fields['current_sql_db_cnt'], $rs->fields['max_sql_user_cnt'], $rs->fields['current_sql_user_cnt'], $rs->fields['max_traff_amnt'], $rs->fields['current_traff_amnt'], $rs->fields['max_disk_amnt'], $rs->fields['current_disk_amnt'], $rs->fields['customer_id'], $rs->fields['reseller_ips']);
}
/*
*
* static page messages.
*
*/
list($admin_name, $fname, $lname, $firm, $zip, $city, $country, $email, $phone, $fax, $street1, $street2, $max_dmn_cnt, $current_dmn_cnt, $max_sub_cnt, $current_sub_cnt, $max_als_cnt, $current_als_cnt, $max_mail_cnt, $current_mail_cnt, $max_ftp_cnt, $current_ftp_cnt, $max_sql_db_cnt, $current_sql_db_cnt, $max_sql_user_cnt, $current_sql_user_cnt, $max_traff_amnt, $current_traff_amnt, $max_disk_amnt, $current_disk_amnt, $customer_id, $rip_lst) = get_reseller_prop(&$sql);
$reseller_ips = get_servers_IPs($tpl, $sql, $rip_lst);
update_reseller($sql);
gen_admin_menu($tpl);
$tpl->assign(array('TR_EMPTY_OR_WORNG_DATA' => tr('Empty data or wrong field!'), 'TR_PASSWORD_NOT_MATCH' => tr('Password not match!'), 'TR_EDIT_RESELLER' => tr('Edit reseller'), 'TR_CORE_DATA' => tr('Core data'), 'TR_USERNAME' => tr('Username'), 'TR_PASSWORD' => tr('Password'), 'TR_PASSWORD_REPEAT' => tr('Password repeat'), 'TR_EMAIL' => tr('E-mail'), 'TR_UNLIMITED' => tr('unlimited'), 'TR_MAX_DOMAIN_COUNT' => tr('Max domain count'), 'TR_MAX_SUBDOMAIN_COUNT' => tr('Max subdomain count'), 'TR_MAX_ALIASES_COUNT' => tr('Max aliases count'), 'TR_MAX_MAIL_USERS_COUNT' => tr('Max mail users count'), 'TR_MAX_FTP_USERS_COUNT' => tr('Max FTP users count'), 'TR_MAX_SQLDB_COUNT' => tr('Max SQL databases count'), 'TR_MAX_SQL_USERS_COUNT' => tr('Max SQL users count'), 'TR_MAX_TRAFFIC_AMOUNT' => tr('Max traffic amount [MB]'), 'TR_MAX_DISK_AMOUNT' => tr('Max disk amount [MB]'), 'TR_PHP' => tr('PHP'), 'TR_PERL_CGI' => tr('CGI / Perl'), 'TR_JSP' => tr('JSP'), 'TR_SSI' => tr('SSI'), 'TR_FRONTPAGE_EXT' => tr('Fronpage extensions'), 'TR_BACKUP_RESTORE' => tr('Backup and restore'), 'TR_CUSTOM_ERROR_PAGES' => tr('Custom error pages'), 'TR_PROTECTED_AREAS' => tr('Protected areas'), 'TR_WEBMAIL' => tr('Webmail'), 'TR_DIR_LIST' => tr('Directory listing'), 'TR_APACHE_LOGFILES' => tr('Apache logfiles'), 'TR_AWSTATS' => tr('AwStats'), 'TR_LOGO_UPLOAD' => tr('Logo upload'), 'TR_YES' => tr('yes'), 'TR_NO' => tr('no'), 'TR_RESELLER_IPS' => tr('Reseller IPs'), 'TR_ADDITIONAL_DATA' => tr('Additional data'), 'TR_CUSTOMER_ID' => tr('Customer ID'), 'TR_FIRST_NAME' => tr('First name'), 'TR_LAST_NAME' => tr('Last name'), 'TR_COMPANY' => tr('Company'), 'TR_ZIP_POSTAL_CODE' => tr('Zip/Postal code'), 'TR_CITY' => tr('City'), 'TR_COUNTRY' => tr('Country'), 'TR_STREET_1' => tr('Street 1'), 'TR_STREET_2' => tr('Street 2'), 'TR_PHONE' => tr('Phone'), 'TR_FAX' => tr('Fax'), 'TR_PHONE' => tr('Phone'), 'TR_UPDATE' => tr('Update'), 'USERNAME' => $admin_name, 'EMAIL' => $email, 'MAX_DOMAIN_COUNT' => $max_dmn_cnt, 'MAX_SUBDOMAIN_COUNT' => $max_sub_cnt, 'MAX_ALIASES_COUNT' => $max_als_cnt, 'MAX_MAIL_USERS_COUNT' => $max_mail_cnt, 'MAX_FTP_USERS_COUNT' => $max_ftp_cnt, 'MAX_SQLDB_COUNT' => $max_sql_db_cnt, 'MAX_SQL_USERS_COUNT' => $max_sql_user_cnt, 'MAX_TRAFFIC_AMOUNT' => $max_traff_amnt, 'MAX_DISK_AMOUNT' => $max_disk_amnt, 'CUSTOMER_ID' => $customer_id, 'FIRST_NAME' => $fname, 'LAST_NAME' => $lname, 'FIRM' => $firm, 'ZIP' => $zip, 'CITY' => $city, 'COUNTRY' => $country, 'STREET_1' => $street1, 'STREET_2' => $street2, 'PHONE' => $phone, 'FAX' => $fax, 'EDIT_ID' => $edit_id, 'TR_UPDATE' => tr('Update')));
gen_page_message($tpl);
$tpl->parse('PAGE', 'page');
$tpl->prnt();
if (isset($cfg['DUMP_GUI_DEBUG'])) {
dump_gui_debug();
}
unset_messages();
/**
* Get reseller data
*
* For performance reason, the data are cached.
*
* Note: The template instance must always be passed as
* parameter of this function during the first call.
*
* @since r2561
* @param EasySCP_TemplateEngine $tpl reference to the template instance
* @return array reseller properties and additional data
*/
function &get_data($tpl = false)
{
static $rdata = array();
if (empty($rdata) && $tpl !== false) {
$sql = EasySCP_Registry::get('Db');
// Update action
if (isset($_POST['uaction']) && $_POST['uaction'] == 'update_reseller') {
// Get clean input data
$rdata = get_clean_input_data();
$query = "\n\t\t\t\tSELECT\n\t\t\t\t\t`admin_name`, `reseller_ips`\n\t\t\t\tFROM\n\t\t\t\t\t`admin`, `reseller_props`\n\t\t\t\tWHERE\n\t\t\t\t\t`admin_id` = ?\n\t\t\t";
$rs = exec_query($sql, $query, $rdata['edit_id']);
if ($rs->recordCount() <= 0) {
user_goto('manage_users.php');
}
$rdata['admin_name'] = $rs->fields['admin_name'];
$rdata['rip_lst'] = $rs->fields['reseller_ips'];
} else {
// Default action
// get clean reseller unique identifier
$edit_id = clean_input($_GET['edit_id'], true);
// Get reseller properties
$rdata = get_reseller_prop($edit_id);
$rdata['edit_id'] = $edit_id;
}
// Both cases
$rdata['reseller_ips'] = get_servers_IPs($tpl, $rdata['rip_lst']);
}
return $rdata;
}
