function exec_ogp_module()
{
global $view;
global $db;
#This will add a remote host to the list
if (isset($_REQUEST['add_remote_host'])) {
$rhost_ip = trim($_POST['remote_host']);
$rhost_name = trim($_POST['remote_host_name']);
$rhost_user_name = trim($_POST['remote_host_user_name']);
$rhost_port = trim($_POST['remote_host_port']);
$rhost_ftp_ip = trim($_POST['remote_host_ftp_ip']);
$rhost_ftp_port = trim($_POST['remote_host_ftp_port']);
$encryption_key = trim($_POST['remote_encryption_key']);
$timeout = trim($_POST['timeout']);
$use_nat = trim($_POST['use_nat']);
if (empty($rhost_ip)) {
print_failure(get_lang('enter_ip_host'));
$view->refresh("?m=server");
return;
}
if (empty($rhost_user_name)) {
print_failure(get_lang('enter_unix_user_name'));
$view->refresh("?m=server");
return;
}
if (!isPortValid($rhost_port)) {
print_failure(get_lang('enter_valid_ip'));
$view->refresh("?m=server");
return;
}
$rhost_id = $db->addRemoteServer($rhost_ip, $rhost_name, $rhost_user_name, $rhost_port, $rhost_ftp_ip, $rhost_ftp_port, $encryption_key, $timeout, $use_nat);
if (!$rhost_id) {
print_failure("" . get_lang('could_not_add_server') . " " . $rhost_ip . " " . get_lang('to_db') . "");
$view->refresh("?m=server");
return;
}
print_success("" . get_lang('added_server') . " {$rhost_ip} " . get_lang('with_port') . " {$rhost_port} " . get_lang('to_db_succesfully') . "");
require_once 'includes/lib_remote.php';
$remote = new OGPRemoteLibrary($rhost_ip, $rhost_port, $encryption_key);
$iplist = $remote->discover_ips();
if (empty($iplist)) {
print_failure("" . get_lang('unable_discover') . " " . $rhost_ip . ". " . get_lang('set_ip_manually') . "");
} else {
print_success("" . get_lang('found_ips') . " (" . implode(",", $iplist) . ") " . get_lang('for_remote_server') . "");
foreach ($iplist as $remote_ip) {
$remote_ip = trim($remote_ip);
if (empty($remote_ip)) {
continue;
}
if (!$db->addRemoteServerIp($rhost_id, $remote_ip)) {
print_failure("" . get_lang('failed_add_ip') . " (" . $remote_ip . ") " . get_lang('for_remote_server') . "");
}
}
}
$view->refresh("?m=server");
return;
}
}
function exec_ogp_module()
{
$modDb = new MySQLModuleDatabase();
require "includes/config.inc.php";
$modDb->connect($db_host, $db_user, $db_pass, $db_name, $table_prefix);
global $view, $db;
echo "<h2>" . get_lang('add_new_mysql_host') . "</h2>";
if (isset($_GET['add_mysql_server'])) {
foreach ($_GET as $name => $value) {
$get[$name] = trim($value);
}
if (empty($get['mysql_ip'])) {
print_failure(get_lang('enter_mysql_ip'));
}
if (!isPortValid($get['mysql_port'])) {
print_failure(get_lang('enter_valid_port'));
}
if (empty($get['mysql_root_passwd'])) {
print_failure(get_lang('enter_mysql_root_password'));
}
if (empty($get['mysql_name'])) {
print_failure(get_lang('enter_mysql_name'));
}
if ($get['privilegies'] == "custom") {
$priv = $get;
$privilegies_str = "";
unset($priv['m'], $priv['p'], $priv['remote_server_id'], $priv['mysql_ip'], $priv['mysql_port'], $priv['mysql_root_passwd'], $priv['mysql_name'], $priv['privilegies'], $priv['add_mysql_server']);
foreach ($priv as $name => $value) {
$privilegies_str .= str_replace("_", " ", $name) . ", ";
}
} else {
$privilegies_str = "ALL";
}
$privilegies_str = rtrim($privilegies_str, ', ');
$mysql_server_id = $modDb->addMysqlServer($get['remote_server_id'], $get['mysql_name'], $get['mysql_ip'], $get['mysql_port'], $get['mysql_root_passwd'], $privilegies_str);
if (!$mysql_server_id) {
print_failure(get_lang('could_not_add_mysql_server'));
$view->refresh("?m=mysql&p=mysql_admin");
return;
}
print_success(get_lang('server_added'));
$view->refresh("?m=mysql&p=mysql_admin");
return;
}
echo "<p>" . get_lang('note_mysql_host') . "</p>";
$servers = $db->getRemoteServers();
$conn_method[0] = get_lang('direct_connection');
foreach ($servers as $server_row) {
$id = $server_row['remote_server_id'];
$name = get_lang_f('connection_through_remote_server_named', $server_row['remote_server_name']);
$conn_method[$id] = $name;
}
require_once "includes/form_table_class.php";
$ft = new FormTable();
$ft->start_form("", "GET");
$ft->start_table();
$ft->add_field_hidden('m', 'mysql');
$ft->add_field_hidden('p', 'mysql_admin');
$ft->add_custom_field('connection_method', create_drop_box_from_array($conn_method, "remote_server_id", "0", false));
$ft->add_field('string', 'mysql_name', isset($_GET['mysql_name']) ? $_GET['mysql_name'] : "");
$ft->add_field('string', 'mysql_ip', isset($_GET['mysql_ip']) ? $_GET['mysql_ip'] : "localhost");
$ft->add_field('string', 'mysql_port', isset($_GET['mysql_port']) ? $_GET['mysql_port'] : "3306");
$ft->add_field('string', 'mysql_root_passwd', isset($_GET['mysql_root_passwd']) ? $_GET['mysql_root_passwd'] : "");
$ft->add_custom_field('privilegies', create_drop_box_from_array(array('all' => get_lang('all'), 'custom' => get_lang('custom')), "privilegies", isset($_GET['privilegies']) ? $_GET['privilegies'] : "all", false));
if (isset($_GET['privilegies']) and $_GET['privilegies'] == "custom") {
$ft->add_custom_field('alter', '<input type="checkbox" name="ALTER" checked="checked" >');
$ft->add_custom_field('create', '<input type="checkbox" name="CREATE" checked="checked" >');
$ft->add_custom_field('create_temporary_tables', '<input type="checkbox" name="CREATE TEMPORARY TABLES" checked="checked" >');
$ft->add_custom_field('delete', '<input type="checkbox" name="DELETE" checked="checked" >');
$ft->add_custom_field('drop', '<input type="checkbox" name="DROP" checked="checked" >');
$ft->add_custom_field('index', '<input type="checkbox" name="INDEX" checked="checked" >');
$ft->add_custom_field('insert', '<input type="checkbox" name="INSERT" checked="checked" >');
$ft->add_custom_field('lock_tables', '<input type="checkbox" name="LOCK TABLES" checked="checked" >');
$ft->add_custom_field('select', '<input type="checkbox" name="SELECT" checked="checked" >');
$ft->add_custom_field('update', '<input type="checkbox" name="UPDATE" checked="checked" >');
$ft->add_custom_field('grant_option', '<input type="checkbox" name="GRANT OPTION" checked="checked" >');
}
$ft->end_table();
$ft->add_button("submit", "add_mysql_server", get_lang('add_mysql_server'));
$ft->end_form();
$mysql_servers = $modDb->getMysqlServers();
if ($mysql_servers === FALSE) {
return;
}
$tr = 0;
?>
<table id="servermonitor" class="tablesorter remote">
<thead>
<tr>
<th colspan="4" ><?php
print_lang('configured_mysql_hosts');
?>
</th>
</tr>
</thead>
<tbody> <?php
foreach ($mysql_servers as $mysql_server) {
if ($mysql_server['remote_server_id'] != 0) {
$remote_server = $db->getRemoteServer($mysql_server['remote_server_id']);
$remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']);
$host_stat = $remote->status_chk();
if ($host_stat === 0) {
$server_status = "<span class='failure'>" . get_lang('offline') . "</span> ";
} elseif ($host_stat === 1) {
$server_status = "<span class='success'>" . get_lang('online') . "</span>";
$command = "mysql -h " . $mysql_server['mysql_ip'] . " -P " . $mysql_server['mysql_port'] . " -u root -p" . $mysql_server['mysql_root_passwd'] . ' -e exit; echo $?';
$test_mysql_conn = $remote->exec($command);
if ($test_mysql_conn == 0) {
$server_status .= " / <span class='success'>" . get_lang('mysql_online') . "</span>";
} else {
$server_status .= "/<span class='failure'>" . get_lang('mysql_offline') . "</span>";
}
} elseif ($host_stat === -1) {
$server_status = "<span class='failure'>" . get_lang('encryption_key_mismatch') . "</span>\n";
} else {
$server_status = "<span class='failure'>" . get_lang('unknown_error') . ": {$host_stat}</span>\n";
}
} else {
@($link = mysql_connect($mysql_server['mysql_ip'] . ':' . $mysql_server['mysql_port'], 'root', $mysql_server['mysql_root_passwd']));
if ($link === FALSE) {
$server_status = "<span class='failure'>" . get_lang('mysql_offline') . "</span>";
} else {
$server_status = "<span class='success'>" . get_lang('mysql_online') . "</span>";
mysql_close($link);
}
}
$databases = "";
$mysql_server_dbs = $modDb->getMysqlServerDBs($mysql_server['mysql_server_id']);
if (!empty($mysql_server_dbs)) {
foreach ($mysql_server_dbs as $mysql_db) {
$databases .= $mysql_db['db_name'] . "<a href='?m=mysql&p=edit&mysql_server_id=" . $mysql_server['mysql_server_id'] . "&assign=true&db_id=" . $mysql_db['db_id'] . "&edit_db_settings'>[" . get_lang('edit') . "]</a>\n" . "<a href='?m=mysql&p=edit&mysql_server_id=" . $mysql_server['mysql_server_id'] . "&assign=true&db_id=" . $mysql_db['db_id'] . "&remove_db'>[" . get_lang('remove') . "]</a>\n" . "<br>";
}
}
$conection_type = $mysql_server['remote_server_id'] == 0 ? get_lang('direct_connection') : get_lang_f('connection_through_remote_server_named', $remote_server['remote_server_name']);
$buttons = "<a href='?m=mysql&p=edit&mysql_server_id=" . $mysql_server['mysql_server_id'] . "&delete'>[" . get_lang('remove') . "]</a>\n" . "<a href='?m=mysql&p=edit&mysql_server_id=" . $mysql_server['mysql_server_id'] . "&edit'>[" . get_lang('edit') . "]</a>\n" . "<a href='?m=mysql&p=edit&mysql_server_id=" . $mysql_server['mysql_server_id'] . "&assign'>[" . get_lang('assign_db') . "]</a>\n";
$tittle = "<b>ID#:</b> <b style='color:red;'>" . $mysql_server['mysql_server_id'] . "</b></td>\n\t\t\t\t\t<td class='collapsible' ><b>" . get_lang('mysql_server_name') . ":</b> " . $mysql_server['mysql_name'] . "</td>\n\t\t\t\t\t<td class='collapsible' ><b>" . get_lang('server_status') . ":</b>{$server_status}</td>";
$data = "<tr class='expand-child' >\n\t\t\t\t <td>\n\t\t\t\t\t<b>" . get_lang('mysql_ip_port') . ":</b> " . $mysql_server['mysql_ip'] . ":" . $mysql_server['mysql_port'] . "<br />\n\t\t\t\t\t<b>" . get_lang('mysql_root_passwd') . ":</b> " . $mysql_server['mysql_root_passwd'] . "<br />\n\t\t\t\t\t<b>" . get_lang('connection_method') . ":</b> " . $conection_type . "<br />\n\t\t\t\t\t<b>" . get_lang('user_privilegies') . ":</b> " . $mysql_server['privilegies_str'] . "<br />\n\t\t\t\t </td>\n\t\t\t\t <td>\n\t\t\t\t <b>" . get_lang('current_dbs') . ":</b><br />" . $databases . "</td>\n\t\t\t\t <td>\n\t\t\t\t {$buttons}\n\t\t\t\t </td>\n\t\t\t\t </tr>";
// Template
$first = "<tr class='maintr'><td class='collapsible' >{$tittle}</td></tr>";
$second = $data;
//Echo them all
echo "{$first}{$second}";
}
echo "</tbody>";
echo "</table>\n";
?>
<script type="text/javascript">
$(document).ready(function(){
$("#servermonitor")
.collapsible("td.collapsible", {collapse: true})
.tablesorter({sortList: [[0,0], [1,0]] , widgets: ['zebra','repeatHeaders']});
});
</script>
<?php
unset($modDb);
}
function exec_ogp_module()
{
global $db;
$isAdmin = $db->isAdmin($_SESSION['user_id']);
$submit = isset($_REQUEST['submit']) ? $_REQUEST['submit'] : "";
$home_id = $_GET['home_id'];
$enabled_mods = $db->getHomeMods($home_id);
if ($isAdmin and isset($_POST['change_home_cfg_id'])) {
if (!empty($enabled_mods)) {
foreach ($enabled_mods as $enabled_rows) {
$db->delGameMod($enabled_rows['mod_id']);
}
}
$home_cfg_id = $game_home['home_cfg_id'];
$new_home_cfg_id = $_POST['home_cfg_id'];
if ($db->updateHomeCfgId($home_id, $new_home_cfg_id)) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('change_game_type') . ":old home_cfg_id:{$home_cfg_id}, new home_cfg_id:{$new_home_cfg_id}");
}
$enabled_mods = $db->getHomeMods($home_id);
}
if ($isAdmin) {
$game_home = $db->getGameHome($_GET['home_id']);
} else {
$game_home = $db->getUserGameHome($_SESSION['user_id'], $_GET['home_id']);
}
if (!$game_home and !$isAdmin) {
return;
}
$home_info = $db->getGameHomeWithoutMods($home_id);
$server_xml = read_server_config(SERVER_CONFIG_LOCATION . $home_info['home_cfg_file']);
include 'includes/lib_remote.php';
$remote = new OGPRemoteLibrary($home_info['agent_ip'], $home_info['agent_port'], $home_info['encryption_key']);
$ftp_installed = $db->isModuleInstalled('ftp');
$screen_running = $remote->is_screen_running(OGP_SCREEN_TYPE_HOME, $home_info['home_id']) === 1;
if ($isAdmin) {
$game_home['access_rights'] = "ufpet";
}
echo "<h2>" . get_lang('editing_home_called') . " \"" . $home_info['home_name'] . "\"</h2>";
if (isset($_REQUEST['change_name'])) {
$server_name = $_POST['server_name'];
if ($db->changeHomeName($home_id, $server_name) === TRUE) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('game_server_name') . ":{$server_name}");
} else {
print_failure("Name update failed.");
}
} elseif (isset($_REQUEST['change_control_password'])) {
$control_password = $_POST['control_password'];
if ($db->changeHomeControlPassword($home_id, $control_password) === TRUE) {
print_success(get_lang('control_password_updated_successfully'));
$db->logger(get_lang('control_password_updated_successfully') . " HOME ID:{$home_id} - " . get_lang('game_control_password') . ":{$control_password}");
} else {
print_failure(get_lang('control_password_update_failed'));
}
} elseif (isset($_REQUEST['change_ftp_login']) && preg_match("/t/", $game_home['access_rights']) > 0) {
// Is FTP Module Installed?
if ($ftp_installed) {
if ($db->IsFtpEnabled($home_id) or $isAdmin) {
$post_ftp_login = trim($_POST['ftp_login']);
$host_stat = $remote->status_chk();
$user_exists = FALSE;
$host_online = FALSE;
if ($host_stat === 1) {
$host_online = TRUE;
$ftp_accounts_list = $remote->ftp_mgr("list");
$ftp_accounts = explode("\n", $ftp_accounts_list);
foreach ($ftp_accounts as $ftp_account) {
if ($ftp_account != "") {
list($ftp_login, $ftp_path) = explode("\t", $ftp_account);
$ftp_login = trim($ftp_login);
if ($ftp_login == $post_ftp_login) {
$user_exists = TRUE;
break;
}
}
}
}
if ($host_online and !$user_exists) {
$old_login = isset($home_info['ftp_login']) ? $home_info['ftp_login'] : $home_id;
$change_login_delete_old = $remote->ftp_mgr("userdel", $old_login);
if ($change_login_delete_old !== 0) {
$change_login_add_new = $remote->ftp_mgr("useradd", $post_ftp_login, $home_info['ftp_password'], $home_info['home_path']);
}
if (isset($change_login_add_new) and $change_login_add_new !== 0) {
if ($db->changeFtpLogin($home_id, $post_ftp_login) === TRUE) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('server_ftp_login') . ":{$post_ftp_login}");
}
} else {
print_failure(get_lang('error_ocurred_on_remote_server') . " " . get_lang('ftp_login_can_not_be_changed'));
}
} else {
print_failure(get_lang('error_ocurred_on_remote_server') . " " . get_lang('ftp_login_can_not_be_changed'));
}
}
}
} elseif (isset($_REQUEST['change_ftp_password']) && preg_match("/t/", $game_home['access_rights']) > 0) {
// Is FTP Module Installed?
if ($ftp_installed) {
if ($db->IsFtpEnabled($home_id) or $isAdmin) {
$ftp_password = $_POST['ftp_password'];
$ftp_login = isset($home_info['ftp_login']) ? $home_info['ftp_login'] : $home_id;
$change_passwd_on_remote = $remote->ftp_mgr("passwd", $ftp_login, $ftp_password);
if ($change_passwd_on_remote !== 0) {
if ($db->changeFtpPassword($home_id, clean_path($ftp_password)) === TRUE) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('server_ftp_password') . ":{$ftp_password}");
}
} else {
print_failure(get_lang('error_ocurred_on_remote_server') . " " . get_lang('ftp_password_can_not_be_changed'));
}
}
}
} elseif (isset($_POST["force_mod_id"])) {
$force_mod_id = $_POST['force_mod_id'];
$ip_id = $_POST['ip_id'];
$port = $_POST['port'];
if ($db->forceModAtAddress($ip_id, $port, $force_mod_id)) {
print_success(get_lang('successfully_assigned_mod_to_address'));
$db->logger(get_lang('successfully_assigned_mod_to_address'));
} else {
print_failure("Failed to assign mod to address.");
}
} elseif ($isAdmin) {
if (isset($_REQUEST['create_ftp'])) {
$login = isset($home_info['ftp_login']) ? $home_info['ftp_login'] : $home_id;
$create_ftp = $remote->ftp_mgr("useradd", $login, $home_info['ftp_password'], $home_info['home_path']);
if ($create_ftp === 0) {
print_failure(get_lang('error_ocurred_on_remote_server') . " " . get_lang('ftp_can_not_be_switched_on'));
} else {
$db->changeFtpStatus('enabled', $home_id);
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('change_ftp_account_status') . ":enabled");
}
} else {
if (isset($_REQUEST['delete_ftp'])) {
$login = isset($home_info['ftp_login']) ? $home_info['ftp_login'] : $home_id;
$delete_ftp = $remote->ftp_mgr("userdel", $login);
if ($delete_ftp === 0) {
print_failure(get_lang('error_ocurred_on_remote_server') . " " . get_lang('ftp_can_not_be_switched_off'));
} else {
$db->changeFtpStatus('disabled', $home_id);
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('change_ftp_account_status') . ":disabled");
}
} else {
if (isset($_REQUEST['change_user_id_main'])) {
$user_id_main = $_POST['user_id_main'];
if (isset($_POST['deleteoldassigns'])) {
$db->unassignHomeFrom("user", $home_info['user_id_main'], $home_id);
$home_groups = $db->getGroupsForHome($home_info['home_id']);
if (isset($home_groups)) {
foreach ($home_groups as $home_group) {
$db->unassignHomeFrom("group", $home_group['group_id'], $home_id);
}
}
}
$old_home = $db->getUserGameHome($home_info['user_id_main'], $home_id);
if ($db->changeUserIdMain($home_id, clean_path($user_id_main)) === TRUE && $db->assignHomeTo("user", $user_id_main, $home_id, $old_home['access_rights']) === TRUE) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('change_user_id_main') . ":{$user_id_main}");
}
} else {
if (isset($_REQUEST['change_home'])) {
$home_path = $_POST['home_path'];
if ($db->changeHomePath($home_id, clean_path($home_path)) === TRUE) {
if ($ftp_installed) {
if ($db->IsFtpEnabled($home_id)) {
$login = isset($home_info['ftp_login']) ? $home_info['ftp_login'] : $home_id;
$delte_old_ftp_account = $remote->ftp_mgr("userdel", $login);
if ($delte_old_ftp_account !== 0) {
$create_new_ftp_account = $remote->ftp_mgr("useradd", $login, $home_info['ftp_password'], $home_path);
}
if (isset($create_new_ftp_account) and $create_new_ftp_account !== 0) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('home_path') . ":{$home_path}");
} else {
print_failure(get_lang('error_ocurred_on_remote_server') . " " . get_lang('ftp_login_can_not_be_changed'));
}
} else {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('home_path') . ":{$home_path}");
}
} else {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('home_path') . ":{$home_path}");
}
}
} else {
if (isset($_REQUEST['master_server'])) {
if (isset($_POST['add'])) {
$action = "add";
} else {
$action = "remove";
}
if ($db->setMasterServer($action, $home_id, $home_info['home_cfg_id'], $home_info['remote_server_id']) === TRUE) {
print_success(get_lang('successfully_changed_game_server'));
$db->logger(get_lang('successfully_changed_game_server') . " HOME ID:{$home_id} - " . get_lang('set_as_master_server') . ":{$action}");
}
}
}
}
}
}
if (isset($_REQUEST['add_mod'])) {
$mod_cfg_id = $_POST['mod_cfg_id'];
if ($db->addModToGameHome($home_id, $mod_cfg_id) === FALSE) {
print_failure(get_lang_f('failed_to_assing_mod_to_home', $mod_cfg_id));
} else {
print_success(get_lang_f('successfully_assigned_mod_to_home', $mod_cfg_id));
$db->logger(get_lang_f('successfully_assigned_mod_to_home', $mod_cfg_id) . " [HOME ID:{$home_id}]");
}
} else {
if ($submit == "delete_mod") {
$mod_id = $_GET['mod_id'];
if ($db->delGameMod($mod_id) === TRUE) {
print_success(get_lang('successfully_removed_mod'));
}
$db->logger(get_lang('successfully_removed_mod') . " [MOD ID:{$mod_id} HOME ID:{$home_id}]");
} else {
if (isset($_REQUEST['set_options'])) {
$maxplayers = 0 + @$_POST['maxplayers'];
$cliopts = $_POST['cliopts'];
$cpus = $_POST['cpus'];
$nice = $_POST['nice'];
$mod_cfg_id = $_POST['mod_cfg_id'];
$db->updateGameModParams($maxplayers, $cliopts, $cpus, $nice, $home_id, $mod_cfg_id);
print_success(get_lang("successfully_modified_mod"));
$db->logger(get_lang('successfully_modified_mod') . " [MOD CFG ID:{$mod_cfg_id} HOME ID:{$home_id}]");
echo "<meta http-equiv='refresh' content='2'>";
}
}
}
}
$home_info = $db->getGameHomeWithoutMods($home_id);
$custom_fileds_access_enabled = preg_match("/c/", $game_home['access_rights']) > 0 ? TRUE : FALSE;
echo "<p>";
echo "<a href='?m=gamemanager&p=game_monitor&home_id={$home_id}'><< " . get_lang('back_to_game_monitor') . "</a>";
if ($isAdmin) {
echo " ";
echo "<a href='?m=user_games'><< " . get_lang('back_to_game_servers') . "</a>";
$custom_fileds_access_enabled = TRUE;
}
if (isset($server_xml->custom_fields) and $custom_fileds_access_enabled) {
echo " <a href='?m=user_games&p=custom_fields&home_id=" . $home_id . "'>" . get_lang('go_to_custom_fields') . " >></a>";
}
echo "</p>";
echo "<table class='center'>";
if ($isAdmin) {
// Form to change game type
echo "<tr><td rowspan='2' class='right'>" . get_lang('game_type') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
$game_cfgs = $db->getGameCfgs();
$host_stat = $remote->status_chk();
if ($host_stat === 1) {
$os = $remote->what_os();
} else {
$os = "Unknown OS";
}
echo "<select name='home_cfg_id' >";
// Linux 64 bits + wine
if (preg_match("/Linux/", $os) and preg_match("/64/", $os) and preg_match("/wine/", $os)) {
foreach ($game_cfgs as $row) {
if (preg_match("/linux/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'];
if (preg_match("/64/", $row['game_key'])) {
echo " (64 bit)";
}
echo "</option>\n";
}
}
echo "<option style='background:black;color:white;' value=''>" . get_lang('wine_games') . ":</option>\n";
foreach ($game_cfgs as $row) {
if (preg_match("/win/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'];
if (preg_match("/64/", $row['game_key'])) {
echo " (64 bit)";
}
echo "</option>\n";
}
}
} elseif (preg_match("/Linux/", $os) and preg_match("/64/", $os)) {
foreach ($game_cfgs as $row) {
if (preg_match("/linux/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'];
if (preg_match("/64/", $row['game_key'])) {
echo " (64 bit)";
}
echo "</option>\n";
}
}
} elseif (preg_match("/Linux/", $os) and preg_match("/wine/", $os)) {
foreach ($game_cfgs as $row) {
if (preg_match("/linux32/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'] . "</option>\n";
}
}
echo "<option style='background:black;color:white;' value=''>" . get_lang('wine_games') . "</option>\n";
foreach ($game_cfgs as $row) {
if (preg_match("/win32/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'] . "</option>\n";
}
}
} elseif (preg_match("/Linux/", $os)) {
foreach ($game_cfgs as $row) {
if (preg_match("/linux32/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'] . "</option>\n";
}
}
} elseif (preg_match("/CYGWIN/", $os) and preg_match("/64/", $os)) {
foreach ($game_cfgs as $row) {
if (preg_match("/win/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'];
if (preg_match("/64/", $row['game_key'])) {
echo " (64 bit)";
}
echo "</option>\n";
}
}
} elseif (preg_match("/CYGWIN/", $os)) {
foreach ($game_cfgs as $row) {
if (preg_match("/win32/", $row['game_key'])) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'] . "</option>\n";
}
}
} elseif ($os == "Unknown OS") {
foreach ($game_cfgs as $row) {
$selected = $home_info['home_cfg_id'] == $row['home_cfg_id'] ? 'selected="selected"' : "";
echo "<option value='" . $row['home_cfg_id'] . "' {$selected}>" . $row['game_name'];
if (preg_match("/64/", $row['game_key'])) {
echo " (64 bit)";
}
echo "</option>\n";
}
}
echo "</select>\n</td></tr>";
echo "<tr><td class='left'><input type='submit' name='change_home_cfg_id' value='" . get_lang('change_game_type') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_game_type_info') . "</td></tr>";
// Form to edit main user.
echo "<tr><td rowspan='3' class='right'>" . get_lang('user_id_main') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo "<select name='user_id_main'>";
$user = $db->getUserById($home_info['user_id_main']);
echo "<option value='" . $home_info['user_id_main'] . "'>" . $user['users_login'] . "</option>\n";
$users = $db->getUserList();
foreach ($users as $user) {
// Only users and admins can be assigned homes... not subusers
if (is_null($user['users_parent'])) {
if ($home_info['user_id_main'] != $user['user_id']) {
echo "<option value='" . $user['user_id'] . "'>" . $user['users_login'] . "</option>\n";
}
}
}
echo "</select></td></tr>";
echo "<tr><td><input type='checkbox' name='deleteoldassigns' id='deleteoldassigns' /><label for='deleteoldassigns' >" . get_lang('Delete_old_user_assigned_homes') . "</label></td></tr>";
echo "<tr><td class='left'><input type='submit' name='change_user_id_main' value='" . get_lang('change_user_id_main') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_user_id_main_info') . "</td></tr>";
// Form to edit game path.
echo "<tr><td class='right'>" . get_lang('home_path') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo "<input type='text' size='30' name='home_path' value=" . $home_info['home_path'] . " />";
echo "<input type='submit' name='change_home' value='" . get_lang('change_home') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_home_info') . "</td></tr>";
}
// Form to edit game name
echo "<tr><td class='right'>" . get_lang('game_server_name') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo "<input type='text' size='30' name='server_name' value='" . $home_info['home_name'] . "' />";
echo "<input type=submit name='change_name' value='" . get_lang('change_name') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_name_info') . "</td></tr>";
// Form to edit control password
echo "<tr><td class='right'>" . get_lang('game_control_password') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo "<input type='text' size='30' name='control_password' value='" . $home_info['control_password'] . "' />";
echo "<input type='submit' name='change_control_password' value='" . get_lang('change_control_password') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_control_password_info') . "</td></tr>";
if (preg_match("/t/", $game_home['access_rights']) > 0 && $ftp_installed && $db->IsFtpEnabled($home_id)) {
// Form to edit control ftp login
$ftp_login = isset($home_info['ftp_login']) ? $home_info['ftp_login'] : $home_id;
echo "<tr><td class='right'>" . get_lang('server_ftp_login') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='text' size='30' name='ftp_login' value='" . $ftp_login . "' />";
echo "<input type='submit' name='change_ftp_login' value='" . get_lang('change_ftp_login') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_ftp_login_info') . "</td></tr>";
// Form to edit control ftp password
echo "<tr><td class='right'>" . get_lang('server_ftp_password') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='text' size='30' name='ftp_password' value='" . $home_info['ftp_password'] . "' />";
echo "<input type='submit' name='change_ftp_password' value='" . get_lang('change_ftp_password') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_ftp_password_info') . "</td></tr>";
}
if ($isAdmin && $ftp_installed) {
// Forms to enable/disable ftp account
echo "<tr>";
echo "<td class='right'>" . get_lang('change_ftp_account_status') . ":</td>";
echo "<td class='left'>";
if (!$db->IsFtpEnabled($home_id)) {
echo "<div style='display:block;float:left;' ><form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='submit' name='create_ftp' value='" . get_lang('ftp_on') . "' />";
echo "</form></div>";
} else {
echo "<div style='display:block;float:left;' ><form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='submit' name='delete_ftp' value='" . get_lang('ftp_off') . "' />";
echo "</form></div>";
}
echo "</td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('change_ftp_account_status_info') . "</td>";
echo "</tr>";
}
if ($isAdmin) {
$master_server_home_id = $db->getMasterServer($home_info['remote_server_id'], $home_info['home_cfg_id']);
if ($master_server_home_id != FALSE and $master_server_home_id == $home_id) {
$checked = 'checked ="checked"';
} else {
$checked = "";
}
// Form to enable/disable as master server for local update
echo "</tr><tr><td class='right'>" . get_lang('master_server_for_clon_update') . ":</td><td class='left'>";
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>";
echo "<input type='checkbox' name='add' {$checked} />";
echo "<input type='submit' name='master_server' value='" . get_lang('set_as_master_server') . "' />";
echo "</form></td></tr>";
echo "<tr><td colspan='2' class='info'>" . get_lang('set_as_master_server_for_local_clon_update') . " (" . get_lang_f('only_available_for', $server_xml->game_name, $home_info['remote_server_name']) . ")</td></tr>";
}
echo "</table>";
if ($isAdmin) {
$avail_ips = $db->getRemoteServerIPs($home_info['remote_server_id']);
$ip_array = array();
if (is_array($avail_ips) && !empty($avail_ips)) {
echo "<h3>" . get_lang('ips_and_ports') . "</h3>";
if (!$screen_running) {
if (isset($_REQUEST['set_ip'])) {
$ip_id = $_POST['ip'];
$ip_row = $db->resultQuery("SELECT ip FROM OGP_DB_PREFIXremote_server_ips WHERE ip_id=" . $ip_id);
$ip = $ip_row['0']['ip'];
$port = $_POST['port'];
$port = (int) trim($port);
$home_id = $_POST['home_id'];
if (!isPortValid($port)) {
print_failure(get_lang('port_range_error'));
} else {
if ($db->addGameIpPort($home_id, $ip_id, $port) === FALSE) {
print_failure(get_lang_f('ip_port_already_in_use', $ip, $port));
} else {
print_success(get_lang_f('successfully_assigned_ip_port_to_server_id', $ip, $port, $home_id));
$db->logger(get_lang_f('successfully_assigned_ip_port_to_server_id', $ip, $port, $home_id));
}
}
}
if (isset($_REQUEST["delete_ip"])) {
$del_ip = $_GET['ip'];
$del_port = $_GET['port'];
if ($db->delGameIpPort($home_id, $del_ip, $del_port)) {
print_success(get_lang('successfully_assigned_ip_port'));
$db->logger(get_lang('successfully_assigned_ip_port') . " [unassigned]");
} else {
print_failure("Failed to unassign ip:port.");
}
}
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>\n";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo get_lang('ip') . ":<select name='ip' onchange='this.form.submit();'>";
foreach ($avail_ips as $value) {
$selected = (isset($_POST['ip']) and $_POST['ip'] == $value['ip_id']) ? "selected='selected'" : "";
echo "<option value='" . $value['ip_id'] . "' {$selected} >" . $value['ip'] . "</option>\n";
}
echo "</select>";
$ip_id = isset($_POST['ip']) ? $_POST['ip'] : $avail_ips[0]['ip_id'];
$port = $db->getNextAvailablePort($ip_id, $home_info['home_cfg_id']);
echo " " . get_lang('port') . ":<input type='text' name='port' value='" . $port . "' size='6' />";
echo "<input type='submit' name='set_ip' value='" . get_lang('set_ip') . "' />";
echo "</form>";
$assigned = $db->getHomeIpPorts($home_id);
if (empty($assigned)) {
print_failure(get_lang('no_ip_ports_assigned'));
} else {
foreach ($assigned as $assigned_rows) {
$force_mod = "";
$align = "center";
if (!empty($enabled_mods) and count($enabled_mods) > 1) {
$force_mod .= "<td align='left'>\n" . "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>\n" . "<input type='hidden' name='ip_id' value=" . $assigned_rows['ip_id'] . " />" . "<input type='hidden' name='port' value=" . $assigned_rows['port'] . " />" . "<select name='force_mod_id' onchange='this.form.submit();'>" . "<option value='0' >" . get_lang('force_mod_on_this_address') . "</option>";
foreach ($enabled_mods as $mod) {
$selected = $mod['mod_id'] == $assigned_rows['force_mod_id'] ? "selected='selected'" : "";
$force_mod .= "<option value='" . $mod['mod_id'] . "' {$selected}>" . $mod['mod_name'] . "</option>";
}
$force_mod .= "</select>\n</form>\n</td>\n";
$align = "right";
}
echo "<table class='center'><tr><td align='{$align}'>" . $assigned_rows['ip'] . ":" . $assigned_rows['port'] . " <a href='?m=user_games&p=edit&home_id={$home_id}&delete_ip&ip=" . $assigned_rows['ip_id'] . "&port=" . $assigned_rows['port'] . "'>[ " . get_lang('delete') . " ]</a></td>\n" . $force_mod . "</tr>\n</table>\n";
}
}
} else {
print_failure(get_lang('server_is_running_change_addresses_not_available'));
}
} else {
print_failure(get_lang('no_ip_addresses_configured') . "<a href='?m=server'>" . get_lang('server_page') . "</a>.");
}
echo "<h3>" . get_lang('mods') . "</h3>";
echo "<p class='info'>" . get_lang('extra_cmd_line_info') . "</p>\n";
if (empty($enabled_mods)) {
print_failure(get_lang('note') . ":" . get_lang('note_no_mods'));
$cpu_count = $remote->cpu_count();
if ($cpu_count === -1) {
print_failure(get_lang('warning_agent_offline_defaulting_CPU_count_to_1'));
$cpu_count = 'NA';
} else {
// cpu numbering starts from 0 so lets remove the last cpu.
$cpu_count -= 1;
}
$game_mods = $db->getAvailableModsForGameHome($home_id);
foreach ($game_mods as $game_mod) {
if ($game_mod['mod_name'] == "none") {
$mod_cfg_id = $game_mod['mod_cfg_id'];
}
if ($game_mod['mod_name'] == "None") {
$mod_cfg_id = $game_mod['mod_cfg_id'];
}
}
if (isset($mod_cfg_id)) {
$db->addModToGameHome($home_id, $mod_cfg_id);
$maxplayers = $server_xml->max_user_amount ? $server_xml->max_user_amount : 0;
$db->updateGameModParams($maxplayers, '', 'NA', '0', $home_id, $mod_cfg_id);
echo "<meta http-equiv='refresh' content='0'>";
return;
} else {
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>\n";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo "<p>" . get_lang('available_mods') . ": <select name='mod_cfg_id'>\n";
foreach ($game_mods as $game_mod) {
echo "<option value='" . $game_mod['mod_cfg_id'] . "'>" . $game_mod['mod_name'] . "</option>\n";
}
echo "</select>\n";
echo "<input type='submit' name='add_mod' value='" . get_lang('add_mod') . "' /></p>";
echo "</form>";
}
} else {
$cpu_count = $remote->cpu_count();
if ($cpu_count === -1) {
print_failure(get_lang('warning_agent_offline_defaulting_CPU_count_to_1'));
$cpu_count = 'NA';
} else {
// cpu numbering starts from 0 so lets remove the last cpu.
$cpu_count -= 1;
}
echo "<table class='center'>\n";
echo "<tr><td></td><td><b>" . get_lang('mod_name') . "</b></td>";
if ($server_xml->max_user_amount) {
echo "<td><b>" . get_lang('max_players') . "</b></td>";
}
echo "<td><b>" . get_lang('extra_cmd_line_args') . "</b></td><td><b>" . get_lang('cpu_affinity') . "</b></td>";
echo "<td><b>" . get_lang('nice_level') . "</b></td><td></td></tr>\n";
foreach ($enabled_mods as $enabled_rows) {
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'><tr><td>\n" . "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n" . "<input type='hidden' name='mod_cfg_id' value=\"" . $enabled_rows['mod_cfg_id'] . "\" />\n" . "<a href='?m=user_games&p=edit&mod_id=" . $enabled_rows['mod_id'] . "&home_id={$home_id}&submit=delete_mod'>[ " . get_lang('remove_mod') . " ]</a><br>" . "<a href='?m=user_games&p=install_cmds&home_id={$home_id}&mod_id=" . $enabled_rows['mod_id'] . "'>" . get_lang('mod_install_cmds') . "</a></td>" . "<td>" . $enabled_rows['mod_name'] . "</td>";
if ($server_xml->max_user_amount) {
echo "<td>" . create_drop_box_from_array(range(0, $server_xml->max_user_amount), 'maxplayers', $enabled_rows['max_players'], true) . "</td>";
}
echo "<td><input type='text' name='cliopts' size='20' value=\"" . $enabled_rows['extra_params'] . "\" /></td>";
echo "<td>" . create_drop_box_from_array(array_merge(array('NA'), range(0, $cpu_count)), 'cpus', $enabled_rows['cpu_affinity']) . "</td>";
echo "<td>" . create_drop_box_from_array(array_merge(range(-19, 19)), 'nice', $enabled_rows['nice']) . "</td>";
echo "<td><input type='submit' name='set_options' value='" . get_lang('set_options') . "' /></td></tr></form>\n";
}
echo "</table>\n";
$game_mods = $db->getAvailableModsForGameHome($home_id);
foreach ($game_mods as $game_mod) {
if ($game_mod['mod_name'] == "none") {
$mods_available = 0;
} elseif ($game_mod['mod_name'] == "None") {
$mods_available = 0;
} else {
$mods_available = 1;
}
}
if ($mods_available == 1) {
echo "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>\n";
echo "<input type='hidden' name='home_id' value=\"{$home_id}\" />\n";
echo "<p>" . get_lang('available_mods') . ": <select name='mod_cfg_id'>\n";
foreach ($game_mods as $game_mod) {
echo "<option value='" . $game_mod['mod_cfg_id'] . "'>" . $game_mod['mod_name'] . "</option>\n";
}
echo "</select>\n";
echo "<input type='submit' name='add_mod' value='" . get_lang('add_mod') . "' /></p>";
echo "</form>";
}
}
} else {
$assigned = $db->getHomeIpPorts($home_id);
if (!empty($assigned) and !empty($enabled_mods) and count($enabled_mods) > 1) {
echo "<table class='center'>\n" . "<tr>\n" . "<td colspan='2' align='center'>" . "<h3>" . get_lang('switch_mods') . "</h3>" . "</td>\n" . "</tr>\n";
foreach ($assigned as $assigned_rows) {
$force_mod = "<tr>\n<td align='right' style='width:50%' >" . get_lang_f('switch_mod_for_address', $assigned_rows['ip'] . ":" . $assigned_rows['port']) . "</td>\n" . ($force_mod .= "<td align='left' style='width:50%' >\n" . "<form action='?m=user_games&p=edit&home_id=" . $home_id . "' method='post'>\n" . "<input type='hidden' name='ip_id' value=" . $assigned_rows['ip_id'] . " />" . "<input type='hidden' name='port' value=" . $assigned_rows['port'] . " />" . "<select name='force_mod_id' onchange='this.form.submit();'>");
foreach ($enabled_mods as $mod) {
$selected = $mod['mod_id'] == $assigned_rows['force_mod_id'] ? "selected='selected'" : "";
$force_mod .= "<option value='" . $mod['mod_id'] . "' {$selected}>" . $mod['mod_name'] . "</option>";
}
$force_mod .= "</select>\n</form>\n</td>\n</tr>\n";
}
echo $force_mod . "</table>\n";
}
}
}
function exec_ogp_module()
{
$modDb = new MySQLModuleDatabase();
require "includes/config.inc.php";
$modDb->connect($db_host, $db_user, $db_pass, $db_name, $table_prefix);
global $view, $db;
$mysql_server_id = @$_REQUEST['mysql_server_id'];
$mysql_server = $modDb->getMysqlServer($mysql_server_id);
if ($mysql_server['remote_server_id'] == "0") {
$server_homes = $db->getGameHomes();
} else {
$server_homes = $modDb->getGameHomesByRemoteServerId($mysql_server['remote_server_id']);
}
$homes_array[0] = get_lang('select_game_server');
foreach ($server_homes as $server_home) {
$homes_array["{$server_home['home_id']}"] = "(ID " . $server_home['home_id'] . ") " . $server_home['home_name'];
}
if ($mysql_server === FALSE) {
print_failure(get_lang_f('invalid_mysql_server_id', $mysql_server_id));
$view->refresh("?m=mysql&p=mysql_admin");
return;
}
if (isset($_REQUEST['add_db'])) {
$home_id = $_POST['home_id'];
$db_user = trim($_POST['db_user']);
$db_passwd = trim($_POST['db_passwd']);
$db_name = trim($_POST['db_name']);
$enabled = $_POST['enabled'];
if (empty($db_user)) {
print_failure(get_lang('enter_db_user'));
} elseif (empty($db_passwd)) {
print_failure(get_lang('enter_db_password'));
} elseif (empty($db_name)) {
print_failure(get_lang('enter_db_name'));
} elseif ($home_id == 0) {
print_failure(get_lang('select_game_server'));
} else {
$db_id = $modDb->addMysqlServerDB($mysql_server_id, $home_id, $db_user, $db_passwd, $db_name, $enabled);
if (!$db_id) {
print_failure(get_lang_f('there_is_another_db_named_or_user_named', $db_name, $db_user));
} else {
$mysql_db = $modDb->getMysqlDBbyId($db_id);
if (!$mysql_db) {
return;
}
if ($mysql_db['remote_server_id'] != "0") {
$remote_server = $db->getRemoteServer($mysql_db['remote_server_id']);
$remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']);
$host_stat = $remote->status_chk();
if ($host_stat === 1) {
$command = "mysql -h localhost -P " . $mysql_db['mysql_port'] . " -u root -p" . $mysql_db['mysql_root_passwd'] . ' -e exit; echo $?';
$test_mysql_conn = $remote->exec($command);
if ($test_mysql_conn == 0) {
$SQL = "CREATE DATABASE IF NOT EXISTS \\`" . $mysql_db['db_name'] . "\\`;" . "GRANT " . $mysql_db['privilegies_str'] . " ON \\`" . $mysql_db['db_name'] . "\\`.* TO '" . $mysql_db['db_user'] . "'@'localhost' IDENTIFIED BY '" . $mysql_db['db_passwd'] . "';" . "FLUSH PRIVILEGES;";
$command = "mysql --host=localhost --port=" . $mysql_db['mysql_port'] . " -uroot -p" . $mysql_db['mysql_root_passwd'] . " -e \"" . $SQL . "\"";
$result = $remote->exec($command);
}
}
} else {
@($link = mysql_connect($mysql_db['mysql_ip'] . ':' . $mysql_db['mysql_port'], $mysql_db['db_user'], $mysql_db['db_passwd']));
if ($link === FALSE) {
@($link = mysql_connect($mysql_db['mysql_ip'] . ':' . $mysql_db['mysql_port'], 'root', $mysql_db['mysql_root_passwd']));
if ($link !== FALSE) {
$queries = array("CREATE DATABASE IF NOT EXISTS `" . $mysql_db['db_name'] . "`;", "GRANT " . $mysql_db['privilegies_str'] . " ON `" . $mysql_db['db_name'] . "`.* TO '" . $mysql_db['db_user'] . "'@'" . $mysql_db['mysql_ip'] . "' IDENTIFIED BY '" . $mysql_db['db_passwd'] . "';", "FLUSH PRIVILEGES;");
foreach ($queries as $query) {
@($return = mysql_query($query));
if (!$return) {
break;
}
}
mysql_close($link);
}
}
}
print_success(get_lang_f('db_added_for_home_id', $_POST['home_id']));
}
}
$view->refresh("?m=mysql&p=mysql_admin&p=edit&mysql_server_id=" . $mysql_server_id . "&assign", 5);
} else {
if (isset($_REQUEST['remove_db'])) {
$db_id = $_REQUEST['db_id'];
$mysql_db = $modDb->getMysqlDBbyId($db_id);
if ($mysql_db['remote_server_id'] != "0") {
$remote_server = $db->getRemoteServer($mysql_db['remote_server_id']);
$remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']);
$host_stat = $remote->status_chk();
if ($host_stat === 1) {
$remote->exec('mysql --host=localhost --port=' . $mysql_db['mysql_port'] . ' -uroot -p' . $mysql_db['mysql_root_passwd'] . ' -e "DROP DATABASE ' . $mysql_db['db_name'] . ";DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_db['mysql_ip'] . "';\"");
}
} else {
@($link = mysql_connect($mysql_db['mysql_ip'] . ':' . $mysql_db['mysql_port'], 'root', $mysql_db['mysql_root_passwd']));
if ($link !== FALSE) {
$queries = array("DROP DATABASE " . $mysql_db['db_name'] . ";", "DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_db['mysql_ip'] . "';");
foreach ($queries as $query) {
@($return = mysql_query($query));
if (!$return) {
break;
}
}
mysql_close($link);
$modDb->connect($db_host, $db_user, $db_pass, $db_name, $table_prefix);
}
}
if ($modDb->removeMysqlServerDB($db_id) === FALSE) {
print_failure(get_lang('could_not_remove_db'));
} else {
print_success(get_lang_f('db_removed_successfully_from_mysql_server_named', $mysql_db['mysql_name']));
}
$view->refresh("?m=mysql&p=mysql_admin&p=edit&mysql_server_id=" . $mysql_server_id . "&assign");
} else {
if (isset($_POST['save_db_changes'])) {
$db_id = $_POST['db_id'];
$home_id = $_POST['home_id'];
$post_db_user = trim($_POST['db_user']);
$post_db_passwd = trim($_POST['db_passwd']);
$post_db_name = trim($_POST['db_name']);
$enabled = $_POST['enabled'];
if (empty($post_db_passwd)) {
print_failure(get_lang('enter_db_password'));
} elseif ($home_id == 0) {
print_failure(get_lang('select_game_server'));
} else {
$mysql_db = $modDb->getMysqlDBbyId($db_id);
if ($post_db_passwd != $mysql_db['db_passwd']) {
if ($mysql_db['remote_server_id'] != "0") {
$remote_server = $db->getRemoteServer($mysql_db['remote_server_id']);
$remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']);
$host_stat = $remote->status_chk();
if ($host_stat === 1) {
$SQL = "DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_server['mysql_ip'] . "';" . "GRANT " . $mysql_db['privilegies_str'] . " ON \\`" . $mysql_db['db_name'] . "\\`.* TO '" . $mysql_db['db_user'] . "'@'localhost' IDENTIFIED BY '" . $post_db_passwd . "';" . "FLUSH PRIVILEGES;";
$command = "mysql --host=localhost --port=" . $mysql_db['mysql_port'] . " -uroot -p" . $mysql_db['mysql_root_passwd'] . " -e \"" . $SQL . "\"";
$remote->exec($command);
}
} else {
@($link = mysql_connect($mysql_db['mysql_ip'] . ':' . $mysql_db['mysql_port'], 'root', $mysql_db['mysql_root_passwd']));
if ($link !== FALSE) {
$queries = array("DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_server['mysql_ip'] . "';", "GRANT " . $mysql_db['privilegies_str'] . " ON `" . $mysql_db['db_name'] . "`.* TO '" . $mysql_db['db_user'] . "'@'" . $mysql_db['mysql_ip'] . "' IDENTIFIED BY '" . $post_db_passwd . "';", "FLUSH PRIVILEGES;");
foreach ($queries as $query) {
@($return = mysql_query($query));
if (!$return) {
break;
}
}
mysql_close($link);
$modDb->connect($db_host, $db_user, $db_pass, $db_name, $table_prefix);
}
}
}
if ($enabled != $mysql_db['enabled']) {
if ($mysql_db['remote_server_id'] != "0") {
$remote_server = $db->getRemoteServer($mysql_db['remote_server_id']);
$remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']);
$host_stat = $remote->status_chk();
if ($host_stat === 1) {
if ($enabled == "0") {
$SQL = "DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_server['mysql_ip'] . "';" . "FLUSH PRIVILEGES;";
} else {
$SQL = "GRANT " . $mysql_db['privilegies_str'] . " ON \\`" . $mysql_db['db_name'] . "\\`.* TO '" . $mysql_db['db_user'] . "'@'localhost' IDENTIFIED BY '" . $post_db_passwd . "';" . "FLUSH PRIVILEGES;";
}
$command = "mysql --host=localhost --port=" . $mysql_db['mysql_port'] . " -uroot -p" . $mysql_db['mysql_root_passwd'] . " -e \"" . $SQL . "\"";
$remote->exec($command);
}
} else {
@($link = mysql_connect($mysql_db['mysql_ip'] . ':' . $mysql_db['mysql_port'], 'root', $mysql_db['mysql_root_passwd']));
if ($link !== FALSE) {
if ($enabled == "0") {
$queries = array("DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_server['mysql_ip'] . "';", "FLUSH PRIVILEGES;");
} else {
$queries = array("GRANT " . $mysql_db['privilegies_str'] . " ON `" . $mysql_db['db_name'] . "`.* TO '" . $mysql_db['db_user'] . "'@'" . $mysql_db['mysql_ip'] . "' IDENTIFIED BY '" . $post_db_passwd . "';", "FLUSH PRIVILEGES;");
}
foreach ($queries as $query) {
@($return = mysql_query($query));
if (!$return) {
break;
}
}
mysql_close($link);
$modDb->connect($db_host, $db_user, $db_pass, $db_name, $table_prefix);
}
}
}
if ($modDb->editMysqlServerDB($db_id, $home_id, $post_db_user, $post_db_passwd, $post_db_name, $enabled) === FALSE) {
print_failure(get_lang('could_not_be_changed'));
} else {
print_success(get_lang_f('db_changed_successfully', $post_db_name));
}
}
$view->refresh("?m=mysql&p=mysql_admin&p=edit&mysql_server_id=" . $mysql_server_id . "&assign");
} else {
if (isset($_REQUEST['delete'])) {
if (!isset($_REQUEST['y'])) {
echo "<p>" . get_lang_f('areyousure_remove_mysql_server', $mysql_server['mysql_name']) . "</p>\n <p><a href='?m=mysql&p=mysql_admin&p=edit&mysql_server_id=" . $mysql_server_id . "&delete&y=y'>" . get_lang('yes') . "</a> <a href='?m=mysql&p=mysql_admin'>" . get_lang('no') . "</a></p>";
return;
} else {
$mysql_dbs = $modDb->getMysqlServerDBs($mysql_server_id);
if (!empty($mysql_dbs)) {
foreach ($mysql_dbs as $mysql_db) {
if ($mysql_server['remote_server_id'] != "0") {
$remote_server = $db->getRemoteServer($mysql_server['remote_server_id']);
$remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']);
$host_stat = $remote->status_chk();
if ($host_stat === 1) {
$remote->exec('mysql --host=localhost --port=' . $mysql_server['mysql_port'] . ' -uroot -p' . $mysql_server['mysql_root_passwd'] . ' -e "DROP DATABASE ' . $mysql_db['db_name'] . ";DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_server['mysql_ip'] . "';\"");
}
} else {
@($link = mysql_connect($mysql_server['mysql_ip'] . ':' . $mysql_server['mysql_port'], 'root', $mysql_server['mysql_root_passwd']));
if ($link !== FALSE) {
$queries = array("DROP DATABASE " . $mysql_db['db_name'] . ";", "DROP USER '" . $mysql_db['db_user'] . "'@'" . $mysql_server['mysql_ip'] . "';");
foreach ($queries as $query) {
@($return = mysql_query($query));
if (!$return) {
break;
}
}
mysql_close($link);
}
}
}
}
if ($modDb->removeMysqlServer($mysql_server_id) === FALSE) {
print_failure(get_lang('error_while_remove'));
} else {
print_success(get_lang_f('mysql_server_removed', $mysql_server['mysql_name']));
}
}
$view->refresh("?m=mysql&p=mysql_admin");
return;
} else {
if (isset($_POST['save_settings'])) {
foreach ($_POST as $name => $value) {
$get[$name] = trim($value);
}
if (empty($get['mysql_ip'])) {
print_failure(get_lang('enter_mysql_ip'));
} elseif (!isPortValid($get['mysql_port'])) {
print_failure(get_lang('enter_valid_port'));
} elseif (empty($get['mysql_root_passwd'])) {
print_failure(get_lang('enter_mysql_root_password'));
} elseif (empty($get['mysql_name'])) {
print_failure(get_lang('enter_mysql_name'));
} elseif (!$modDb->editMysqlServer($mysql_server_id, $get['remote_server_id'], $get['mysql_name'], $get['mysql_ip'], $get['mysql_port'], $get['mysql_root_passwd'], $mysql_server['privilegies_str'])) {
print_failure(get_lang_f('unable_to_set_changes_to', $mysql_server['mysql_name']));
} else {
print_success(get_lang_f('mysql_server_settings_changed', $mysql_server['mysql_name']));
}
$view->refresh("?m=mysql&p=mysql_admin&p=edit&mysql_server_id=" . $mysql_server_id . "&edit", 5);
} elseif (isset($_GET['edit'])) {
echo "<h2>" . get_lang_f('editing_mysql_server', $mysql_server['mysql_name']) . "</h2>";
$mysql_server = $modDb->getMysqlServer($mysql_server_id);
$servers = $db->getRemoteServers();
$conn_method[0] = get_lang('direct_connection');
foreach ($servers as $server_row) {
$id = $server_row['remote_server_id'];
$name = get_lang_f('connection_through_remote_server_named', $server_row['remote_server_name']);
$conn_method[$id] = $name;
}
$ft = new FormTable();
$ft->start_form('?m=mysql&p=edit&mysql_server_id=' . $mysql_server_id . '&edit');
$ft->start_table();
$ft->add_custom_field('connection_method', create_drop_box_from_array($conn_method, "remote_server_id", $mysql_server['remote_server_id'], false));
$ft->add_field('string', 'mysql_name', $mysql_server['mysql_name']);
$ft->add_field('string', 'mysql_ip', $mysql_server['mysql_ip']);
$ft->add_field('string', 'mysql_port', $mysql_server['mysql_port']);
$ft->add_field('string', 'mysql_root_passwd', $mysql_server['mysql_root_passwd']);
$ft->end_table();
$ft->add_button("submit", "save_settings", get_lang('save_settings'));
$ft->end_form();
echo create_back_button('mysql', 'mysql_admin');
} elseif (isset($_GET['assign'])) {
echo "<h2>" . get_lang_f('mysql_dbs_for', $mysql_server['mysql_name']) . "</h2>";
$mysql_server_dbs = $modDb->getMysqlServerDBs($mysql_server['mysql_server_id']);
if (!empty($mysql_server_dbs)) {
echo "<h4>" . get_lang('edit_dbs') . "</h4>";
foreach ($mysql_server_dbs as $mysql_db) {
$home_info = $db->getGameHomeWithoutMods($mysql_db['home_id']);
$db_array["{$mysql_db['db_id']}"] = $mysql_db['db_name'] . " (" . $home_info['home_name'] . ")";
}
$ft = new FormTable();
$ft->start_form('', 'GET');
$ft->add_field_hidden('m', 'mysql');
$ft->add_field_hidden('p', 'edit');
$ft->add_field_hidden('mysql_server_id', $mysql_server_id);
$ft->add_field_hidden('assign', 'true');
$ft->start_table();
$ft->add_custom_field('select_db', create_drop_box_from_array($db_array, "db_id", isset($_GET['db_id']) ? $_GET['db_id'] : "", false));
$ft->end_table();
$ft->add_button('submit', 'edit_db_settings', get_lang('edit_db_settings'));
$ft->add_button('submit', 'remove_db', get_lang('remove_db'));
$ft->end_form();
if (isset($_GET['edit_db_settings'])) {
$mysql_db = $modDb->getMysqlDBbyId($_GET['db_id']);
$ft = new FormTable();
$ft->start_form('');
$ft->add_field_hidden('db_id', $mysql_db['db_id']);
$ft->start_table();
$ft->add_custom_field('game_server', create_drop_box_from_array($homes_array, "home_id", $mysql_db['home_id'], false));
$ft->add_field('string', 'db_user', $mysql_db['db_user'], "50", "readonly");
$ft->add_field('string', 'db_passwd', $mysql_db['db_passwd']);
$ft->add_field('string', 'db_name', $mysql_db['db_name'], "50", "readonly");
$ft->add_field('on_off', 'enabled', $mysql_db['enabled']);
$ft->end_table();
$ft->add_button('submit', 'save_db_changes', get_lang('save_db_changes'));
$ft->end_form();
}
}
echo "<h4>" . get_lang('add_db') . "</h4>";
$ft = new FormTable();
$ft->start_form('');
$ft->start_table();
$ft->add_custom_field('game_server', create_drop_box_from_array($homes_array, "home_id", "0", false));
$ft->add_field('string', 'db_user', '');
$ft->add_field('string', 'db_passwd', genRandomString('10'));
$ft->add_field('string', 'db_name', '');
$ft->add_field('on_off', 'enabled', '1');
$ft->end_table();
$ft->add_button('submit', 'add_db', get_lang('add_db'));
$ft->end_form();
echo create_back_button('mysql', 'mysql_admin');
} else {
print_failure("Invalid url.");
$view->refresh("?m=mysql&p=mysql_admin");
}
}
}
}
}
}
