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