}
*/
}
//
// common page data.
//
global $cfg;
$theme_color = $cfg['USER_INITIAL_THEME'];
$tpl->assign(array('TR_CLIENT_DOMAIN_STATISTICS_PAGE_TITLE' => tr('VHCS - Client/Domain Statistics'), 'THEME_COLOR_PATH' => "../themes/{$theme_color}", 'THEME_CHARSET' => tr('encoding'), 'TID' => $_SESSION['layout_id'], 'VHCS_LICENSE' => $cfg['VHCS_LICENSE'], 'ISP_LOGO' => get_logo($_SESSION['user_id'])));
//
// dynamic page data.
//
$current_month = date("m", time());
$current_year = date("Y", time());
list($current_month, $current_year) = gen_page_post_data($tpl, $current_month, $current_year);
gen_dmn_traff_list($tpl, $sql, $current_month, $current_year, $_SESSION['user_id']);
//
// static page messages.
//
gen_client_menu($tpl);
gen_logged_from($tpl);
check_permissions($tpl);
$tpl->assign(array('TR_DOMAIN_STATISTICS' => tr('Domain statistics'), 'TR_MONTH' => tr('Month'), 'TR_YEAR' => tr('Year'), 'TR_SHOW' => tr('Show'), 'TR_DATE' => tr('Date'), 'TR_WEB_TRAFF' => tr('WEB'), 'TR_FTP_TRAFF' => tr('FTP'), 'TR_SMTP_TRAFF' => tr('SMTP'), 'TR_POP_TRAFF' => tr('POP/IMAP'), 'TR_SUM' => tr('Sum'), 'TR_ALL' => tr('Total')));
gen_page_message($tpl);
$tpl->parse('PAGE', 'page');
$tpl->prnt();
if (isset($cfg['DUMP_GUI_DEBUG'])) {
dump_gui_debug();
}
unset_messages();
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*
* @link http://www.easyscp.net
* @author EasySCP Team
*/
require '../../include/easyscp-lib.php';
check_login(__FILE__);
$cfg = EasySCP_Registry::get('Config');
$tpl = EasySCP_TemplateEngine::getInstance();
$template = 'client/sql_database_add.tpl';
// dynamic page data
check_sql_permissions($sql, $_SESSION['user_id']);
gen_page_post_data($tpl);
add_sql_database($sql, $_SESSION['user_id']);
// static page messages
gen_logged_from($tpl);
check_permissions($tpl);
$tpl->assign(array('TR_PAGE_TITLE' => tr('EasySCP - Client/Add SQL Database'), 'TR_ADD_DATABASE' => tr('Add SQL database'), 'TR_DB_NAME' => tr('Database name'), 'TR_USE_DMN_ID' => tr('Use numeric ID'), 'TR_START_ID_POS' => tr('Before the name'), 'TR_END_ID_POS' => tr('After the name'), 'TR_ADD' => tr('Add')));
gen_client_mainmenu($tpl, 'client/main_menu_manage_sql.tpl');
gen_client_menu($tpl, 'client/menu_manage_sql.tpl');
gen_page_message($tpl);
if ($cfg->DUMP_GUI_DEBUG) {
dump_gui_debug($tpl);
}
$tpl->display($template);
// page functions
/**
* @param EasySCP_TemplateEngine $tpl
$tpl->assign('ID', $db_user_id);
}
//
// common page data.
//
if (isset($_SESSION['sql_support']) && $_SESSION['sql_support'] == "no") {
header("Location: index.php");
}
global $cfg;
$theme_color = $cfg['USER_INITIAL_THEME'];
$tpl->assign(array('TR_CLIENT_SQL_EXECUTE_QUERY_PAGE_TITLE' => tr('VHCS - Client/Execute SQL Query'), 'THEME_COLOR_PATH' => "../themes/{$theme_color}", 'THEME_CHARSET' => tr('encoding'), 'TID' => $_SESSION['layout_id'], 'VHCS_LICENSE' => $cfg['VHCS_LICENSE'], 'ISP_LOGO' => get_logo($_SESSION['user_id'])));
//
// dynamic page data.
//
check_usr_sql_perms($sql, $db_user_id);
gen_page_post_data($tpl, $sql, $db_user_id);
execute_sql_query($tpl, $sql, $_SESSION['user_id'], $db_user_id);
//
// static page messages.
//
gen_client_menu($tpl);
gen_logged_from($tpl);
check_permissions($tpl);
$tpl->assign(array('TR_EXECUTE_SQL_QUERY' => tr('Execute SQL query'), 'TR_USER_NAME' => tr('User name'), 'TR_SQL_QUERY' => tr('SQL query'), 'TR_QUERY_STATUS' => tr('Query status'), 'TR_QUERY_RESULT' => tr('Query result'), 'TR_EXECUTE' => tr('Execute')));
gen_page_message($tpl);
$tpl->parse('PAGE', 'page');
$tpl->prnt();
if (isset($cfg['DUMP_GUI_DEBUG'])) {
dump_gui_debug();
}
unset_messages();
}
//
// common page data.
//
if (isset($_SESSION['sql_support']) && $_SESSION['sql_support'] == "no") {
header("Location: index.php");
}
global $cfg;
$theme_color = $cfg['USER_INITIAL_THEME'];
$tpl->assign(array('TR_CLIENT_SQL_ADD_USER_PAGE_TITLE' => tr('VHCS - Client/Add SQL User'), 'THEME_COLOR_PATH' => "../themes/{$theme_color}", 'THEME_CHARSET' => tr('encoding'), 'TID' => $_SESSION['layout_id'], 'VHCS_LICENSE' => $cfg['VHCS_LICENSE'], 'ISP_LOGO' => get_logo($_SESSION['user_id'])));
//
// dynamic page data.
//
$sqluser_available = gen_sql_user_list($sql, $tpl, $_SESSION['user_id'], $db_id);
check_sql_permissions($tpl, $sql, $_SESSION['user_id'], $db_id, $sqluser_available);
gen_page_post_data($tpl, $db_id);
add_sql_user($sql, $_SESSION['user_id'], $db_id);
//
// static page messages.
//
gen_client_menu($tpl);
gen_logged_from($tpl);
check_permissions($tpl);
$tpl->assign(array('TR_ADD_SQL_USER' => tr('Add SQL user'), 'TR_USER_NAME' => tr('SQL user name'), 'TR_USE_DMN_ID' => tr('Use numeric ID'), 'TR_START_ID_POS' => tr('In front the name'), 'TR_END_ID_POS' => tr('Behind the name'), 'TR_ADD' => tr('Add'), 'TR_CANCEL' => tr('Cancel'), 'TR_ADD_EXIST' => tr('Add existing user'), 'TR_PASS' => tr('Password'), 'TR_PASS_REP' => tr('Password repeat'), 'TR_SQL_USER_NAME' => tr('Existing SQL users')));
gen_page_message($tpl);
$tpl->parse('PAGE', 'page');
$tpl->prnt();
if (isset($cfg['DUMP_GUI_DEBUG'])) {
dump_gui_debug();
}
unset_messages();
