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 $db; $isAdmin = $db->isAdmin($_SESSION['user_id']); if ($isAdmin) { $game_home = $db->getGameHome($_REQUEST['home_id']); } else { $game_home = $db->getUserGameHome($_SESSION['user_id'], $_GET['home_id']); } if (!$game_home and !$isAdmin) { return; } $home_dbs = $modDb->getMysqlDBsbyHomeId($game_home['home_id']); if (empty($home_dbs)) { return; } $db_id = $_REQUEST['db_id']; $mysql_db = $modDb->getMysqlHomeDBbyId($game_home['home_id'], $db_id); if (!$mysql_db) { return; } $command = 'mysqldump --host=' . $mysql_db['mysql_ip'] . ' --port=' . $mysql_db['mysql_port'] . ' --user='******'db_user'] . ' --password='******'db_passwd'] . ' ' . $mysql_db['db_name']; 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) { $dump = $remote->exec($command, $output); } } else { $dump = system($command); } header("Content-Type: text/plain"); header('Content-Disposition: attachment; filename="backup-' . $mysql_db['db_name'] . '-' . date("d-m-Y") . '.sql"'); echo $dump; }
function exec_ogp_module() { global $db; echo "<h2>" . get_lang('game_monitor') . "</h2>"; $refresh = new refreshed(100000); set_time_limit(0); $stats_servers_online = 0; $stats_servers = 0; $stats_players = 0; $stats_maxplayers = 0; $isAdmin = $db->isAdmin($_SESSION['user_id']); if ($isAdmin) { $server_homes = $db->getIpPorts(); } else { $server_homes = $db->getIpPortsForUser($_SESSION['user_id']); } if ($server_homes === FALSE) { // If there are no games, then there can not be any mods either. print_failure(get_lang('no_game_homes_assigned')); if ($isAdmin) { echo "<p><a href='?m=user_games&p=assign&user_id={$_SESSION['user_id']}'>" . get_lang('assign_game_homes') . "</a></p>"; } return; } if (empty($_GET['home_id-mod_id-ip-port'])) { unset($_GET['home_id-mod_id-ip-port']); } if (empty($_GET['home_id'])) { unset($_GET['home_id']); } if ($_GET['home_cfg_id'] == get_lang('game_type')) { unset($_GET['home_cfg_id']); } create_home_selector_game_type($_GET['m'], $_GET['p'], $server_homes); if (!isset($_GET['home_id-mod_id-ip-port']) and !isset($_GET['home_id']) and !isset($_GET['home_cfg_id'])) { create_home_selector_address($_GET['m'], $_GET['p'], $server_homes); $show_all = TRUE; } else { create_home_selector_address($_GET['m'], $_GET['p'], $server_homes); create_home_selector($_GET['m'], $_GET['p'], "show_all"); $show_all = FALSE; } require "protocol/lgsl/lgsl_protocol.php"; ?> <form> <b><?php print_lang('search'); ?> :</b> <input type="text" id="search"> </form> <?php $info = $db->getUser($_SESSION['users_login']); $chk_expire = $info['user_expires']; $exptime = read_expire($chk_expire); $time_to_expire = str_replace('hr', 'hours', $exptime); if ($exptime != "X") { ?> <span style="color:black;font-weight:bold;"> <center> <?php echo print_lang('account_expiration'); ?> : <span style="color:green;"><?php echo date("l, F jS, Y, H:i:s", $chk_expire) . " ( " . $time_to_expire . ")"; ?> </span> </center> </span> <?php } ?> <table id="servermonitor" class="tablesorter"> <thead> <tr> <th style="width:16px;background-position: center;"></th> <th style="width:16px;background-position: center;"></th> <th><?php print_lang('server_name'); ?> </th> <th><?php print_lang('address'); ?> </th> <th><?php print_lang('owner'); ?> </th> <th> <?php print_lang('operations'); ?> <img style="border:0;height:15px;" id="action-stop" src="images/stop.png"/> <img style="border:0;height:15px;" id="action-restart" src="images/restart.png"/> <img style="border:0;height:15px;" id="action-start" src="images/start.png"/> </th> </tr> </thead> <tbody> <?php foreach ($server_homes as $server_home) { $stats_servers++; //Unset variables. if (isset($_GET['home_id-mod_id-ip-port'])) { $pieces = explode("-", $_GET['home_id-mod_id-ip-port']); $post_home_id = $pieces[0]; $post_mod_id = $pieces[1]; $post_ip = $pieces[2]; $post_port = $pieces[3]; } if ($show_all or isset($_GET['home_id']) and $_GET['home_id'] == $server_home['home_id'] or isset($_GET['home_id-mod_id-ip-port']) and $server_home['home_id'] == $post_home_id and $server_home['mod_id'] == $post_mod_id and $post_ip == $server_home['ip'] and $post_port == $server_home['port'] or isset($_GET['home_cfg_id']) and $_GET['home_cfg_id'] == $server_home['home_cfg_id']) { unset($map, $trclass, $first, $second, $onlineT, $ts3opt, $offlineT, $halfT, $ministart, $player_list, $groupsus, $name, $mod_name, $SrvCtrl, $lite_fm, $manager, $user, $pos, $ftp, $addonsmanager, $ctrlChkBoxes); //End if ($isAdmin) { $server_home['access_rights'] = "ufpet"; } else { $home_info = $db->getUserGameHome($_SESSION['user_id'], $server_home['home_id']); $server_home['access_rights'] = $home_info['access_rights']; } $litefm_installed = $db->isModuleInstalled('litefm'); $ftp_installed = $db->isModuleInstalled('ftp'); $addonsmanager_installed = $db->isModuleInstalled('addonsmanager'); $mysql_installed = $db->isModuleInstalled('mysql'); if ($server_home['mod_name'] == "none" or $server_home['mod_name'] == "None") { $mod_name = ""; } elseif ($server_home['mod_name'] != $server_home['game_name']) { $mod_name = " ( " . $server_home['mod_name'] . " )"; } $get_size = "<table align='left' class='monitorbutton' ><tr>" . "<td align='middle' class='size' id='" . $server_home["home_id"] . "'>" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/file_size.png' title='" . get_lang('get_size') . "'/>\n<br /><span style='font-weight:bold;'>" . get_lang('get_size') . "</span></td></tr></table>"; $manager = "<a href='?m=user_games&p=edit&home_id=" . $server_home['home_id'] . "'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/edit.png' title='" . get_lang('edit') . "'/>\n<br />" . get_lang('edit') . "\n</td></tr></table></a>"; // Only show the filemanager link when the litefm is installed. if (preg_match("/f/", $server_home['access_rights']) > 0 && $litefm_installed) { $lite_fm = "<a href='?m=litefm&home_id=" . $server_home['home_id'] . "'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/txt.png' title='" . get_lang('file_manager') . "'/>\n<br />" . get_lang('file_manager') . "\n</td></tr></table></a>"; } if (preg_match("/t/", $server_home['access_rights']) > 0 && $ftp_installed) { $ftp = "<a href='?m=ftp&home_id=" . $server_home['home_id'] . "'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/ftp.png' title='" . get_lang('ftp') . "'/>\n<br>" . get_lang('ftp') . "\n</td></tr></table></a>"; } if ($addonsmanager_installed) { $addons = $db->resultQuery("SELECT DISTINCT addon_id FROM OGP_DB_PREFIXaddons NATURAL JOIN OGP_DB_PREFIXconfig_homes WHERE home_cfg_id=" . $server_home['home_cfg_id']); $addons_qty = count($addons); if ($addons and $addons_qty >= 1) { $addonsmanager = "<a href='?m=addonsmanager&p=user_addons&home_id=" . $server_home['home_id'] . "&ip=" . $server_home['ip'] . "&port=" . $server_home['port'] . "'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='modules/administration/images/addons_manager.png' title='" . get_lang('addons') . "'/>\n<br />" . get_lang('addons') . "\n<b style='font-size:0.9em' >(" . $addons_qty . ")</td></tr></table></a>"; } } if ($mysql_installed) { $mysql_dbs = $db->resultQuery("SELECT db_id FROM OGP_DB_PREFIXmysql_databases WHERE enabled=1 AND home_id=" . $server_home['home_id']); if (!empty($mysql_dbs)) { $mysql = "<a href='?m=mysql&p=user_db&home_id=" . $server_home['home_id'] . "'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='modules/administration/images/mysql_admin.png' title='" . get_lang('mysql_databases') . "'/>\n<br />" . get_lang('mysql_databases') . "\n</td></tr></table></a>\n"; } } $mod_result = $db->getHomeMods($server_home['home_id']); if ($mod_result === FALSE) { print_failure(get_lang('fail_no_mods')); if ($isAdmin) { $manager .= "<a href='?m=user_games&p=edit&home_id=" . $server_home['home_id'] . "'>" . get_lang('configure_mods') . "</a>"; } continue; } $server_xml = read_server_config(SERVER_CONFIG_LOCATION . "/" . $server_home['home_cfg_file']); $master_server_home_id = $db->getMasterServer($server_home['remote_server_id'], $server_home['home_cfg_id']); if ($master_server_home_id != FALSE) { if (!$db->getGameHomeWithoutMods($master_server_home_id)) { $db->setMasterServer("remove", $master_server_home_id, $server_home['home_cfg_id'], $server_home['remote_server_id']); $master_server_home_id = FALSE; } } if ($server_xml) { if (preg_match("/u/", $server_home['access_rights']) > 0) { // In case game is compatible with steam we offer a way to use steam with the updates. if ($server_xml->installer == "steamcmd") { if ($master_server_home_id != FALSE and $master_server_home_id != $server_home['home_id']) { $manager .= "<form name='steam_master_" . $server_home['home_id'] . "_" . $server_home['mod_id'] . "_" . str_replace(".", "", $server_home['ip']) . "_" . $server_home['port'] . "' action='?m=gamemanager&p=update&home_id=" . $server_home['home_id'] . "&mod_id=" . $server_home['mod_id'] . "&update=update' method='POST' >\n" . "<table align='left' class='monitorbutton' >\n" . "<tr><td align='middle' onclick='document.steam_master_" . $server_home['home_id'] . "_" . $server_home['mod_id'] . "_" . str_replace(".", "", $server_home['ip']) . "_" . $server_home['port'] . ".submit()' ><img style='border:0;height:40px;vertical-align:middle;' src='images/master.png' />" . "<br /><span style='font-weight:bold;'>" . get_lang('update_from_local_master_server') . "</span><input id='master" . $server_home['home_id'] . "' type='hidden' name='master_server_home_id' value='" . $master_server_home_id . "' /></td></tr>\n</table>\n</form>"; } $manager .= "<form name='steam_" . $server_home['home_id'] . "_" . $server_home['mod_id'] . "_" . str_replace(".", "", $server_home['ip']) . "_" . $server_home['port'] . "' action='?m=gamemanager&p=update&home_id=" . $server_home['home_id'] . "&mod_id=" . $server_home['mod_id'] . "&update=update' method='POST' >\n" . "<table align='left' class='monitorbutton' >\n" . "<tr><td align='middle' onclick='document.steam_" . $server_home['home_id'] . "_" . $server_home['mod_id'] . "_" . str_replace(".", "", $server_home['ip']) . "_" . $server_home['port'] . ".submit()' ><img style='border:0;height:40px;vertical-align:middle;' src='images/steam.png' />" . "<br /><span style='font-weight:bold;'>" . get_lang('install_update_steam') . "</span></td></tr>\n</table>\n</form>"; } else { $manager .= "<a href='?m=gamemanager&p=update_manual&home_id=" . $server_home['home_id'] . "&mod_id=" . $server_home['mod_id'] . "&update=update'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/install.png' title='" . get_lang('install_update_manual') . "'/>\n<br>" . get_lang('install_update_manual') . "\n</td></td></table></a>"; $sync_name = get_sync_name($server_xml); $sync_list = @file("modules/gamemanager/rsync.list", FILE_IGNORE_NEW_LINES); $master_server_home_id = $db->getMasterServer($server_home['remote_server_id'], $server_home['home_cfg_id']); if (in_array($sync_name, $sync_list) or $master_server_home_id != FALSE and $master_server_home_id != $server_home['home_id']) { $manager .= "<a href='?m=gamemanager&p=rsync_install&home_id=" . $server_home['home_id'] . "&mod_id=" . $server_home['mod_id'] . "&update=update'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/rsync.png' title='" . get_lang('rsync_install') . "'/>\n<br />" . get_lang('rsync_install') . "\n</td></td></table></a>"; } } } } if ($isAdmin) { if ($server_xml->control_protocol == 'rcon' or $server_xml->control_protocol == 'lcon' or $server_xml->control_protocol == 'rcon2' or @$server_xml->gameq_query_name == 'minecraft') { $manager .= "<form name='rcon_preset" . $server_home['home_id'] . "' action='home.php?m=gamemanager&p=rcon_presets&home_id=" . $server_home['home_id'] . "&mod_id=" . $server_home['mod_id'] . "' method='POST'>\n" . "<table align='left' class='monitorbutton' >\n" . "<tr>\n" . "<td align='middle' onclick='document.rcon_preset" . $server_home['home_id'] . ".submit()' ><img style='border:0;height:40px;vertical-align:middle;' src='images/rcon_preset.png' /><br /><span style='font-weight:bold;'>" . get_lang('rcon_presets') . "</span></td>\n" . "</tr>\n" . "</table>\n" . "</form>"; } } $xml_installer = $server_xml->installer; // If query name does not exist use mod key instead. if ($server_xml->protocol == "gameq") { $query_name = $server_xml->gameq_query_name; } elseif ($server_xml->protocol == "lgsl") { $query_name = $server_xml->lgsl_query_name; } elseif ($server_xml->mods->mod['key'] == "none" or $server_xml->mods->mod['key'] == "None") { $query_name = "none"; } else { $query_name = $server_xml->mods->mod['key']; } if ($server_xml->mods->mod['key'] == "none" or $server_xml->mods->mod['key'] == "None") { $mod = "none"; } else { $mod = $server_xml->mods->mod['key']; } //----------+ getting the lgsl image icon $icon_paths = array("images/icons/{$mod}.png", "images/icons/{$query_name}.png", "protocol/lgsl/other/icon_unknown.gif"); $icon_path = get_first_existing_file($icon_paths); //Properties for all servers if (isset($post_home_id) && $post_home_id == $server_home['home_id'] or isset($_GET['home_id']) && $_GET['home_id'] == $server_home['home_id']) { $trclass = " expandme"; } $groupusers = $db->getGroupUsersByHomeId($server_home['home_id']); if ($groupusers) { $groupsus = "<b>" . get_lang('group_users') . "</b><br>"; foreach ($groupusers as $groupu) { $groupsus .= $groupu['users_login'] . "<br>"; } } else { $groupsus = ""; } $view_log = "<a href='?m=gamemanager&p=log&home_id-mod_id-ip-port=" . $server_home['home_id'] . "-" . $server_home['mod_id'] . "-" . $server_home['ip'] . "-" . $server_home['port'] . "'>\n" . "<table align='left' class='monitorbutton' ><tr><td align='middle' >" . "<img style='border:0;height:40px;vertical-align:middle;' src='images/log.png' title='" . get_lang('view_log') . "'/>\n<br>" . get_lang('view_log') . "\n</td></tr></table></a>"; $btns = $view_log . @$ftp . @$lite_fm . @$addonsmanager; //End $remote = new OGPRemoteLibrary($server_home['agent_ip'], $server_home['agent_port'], $server_home['encryption_key'], $server_home['timeout']); $host_stat = $remote->status_chk(); if ($host_stat === 1) { if ($server_home['use_nat'] == 1) { $query_ip = $server_home['agent_ip']; } else { $query_ip = $server_home['ip']; } $address = $query_ip . ":" . $server_home['port']; $screen_running = $remote->is_screen_running(OGP_SCREEN_TYPE_HOME, $server_home['home_id']) === 1; $update_in_progress = $remote->is_screen_running(OGP_SCREEN_TYPE_UPDATE, $server_home['home_id']) === 1; if ($screen_running) { // Check if the screen running the server is running. $status = "online"; $order = 1; if ($server_xml->protocol == "lgsl") { $get_q_and_s = lgsl_port_conversion((string) $query_name, $server_home['port'], "", ""); //Connection port $c_port = $get_q_and_s['0']; //query port $q_port = $get_q_and_s['1']; //software port $s_port = $get_q_and_s['2']; $address = "<a href='" . lgsl_software_link($query_name, $query_ip, $c_port, $q_port, $s_port) . "'>" . $query_ip . ":" . $server_home['port'] . "</a>"; } if ($server_xml->protocol == "teamspeak3") { $address = "<a href='ts3server://" . $query_ip . ":" . $server_home['port'] . "'>" . $query_ip . ":" . $server_home['port'] . "</a>"; } if ($server_xml->protocol == "gameq" and $server_xml->installer == 'steamcmd') { $address = "<a href='steam://connect/" . $query_ip . ":" . $server_home['port'] . "'>" . $query_ip . ":" . $server_home['port'] . "</a>"; } $pos = $refresh->add("home.php?m=gamemanager&p=ref_servermonitor&type=cleared&server_home=" . $server_home['home_id'] . "&ip=" . $server_home['ip'] . "&port=" . $server_home['port']); if ($server_xml->protocol == "teamspeak3") { require 'protocol/TeamSpeak3/functions.php'; } $startup_file_exists = $remote->rfile_exists("startups/" . $server_home['ip'] . "-" . $server_home['port']) === 1; $ctrlChkBoxes .= '<div id="server_icon" class="action-stop' . $server_home['home_id'] . '" > <div> <input id="action-stop" class="action-stop' . $server_home['home_id'] . '" name="action-' . $server_home['home_id'] . '" value="stop-' . $server_home['home_id'] . '-' . $server_home['mod_id'] . '-' . $server_home['ip'] . '-' . $server_home['port'] . '" type="radio"><img style="border:0;height:15px;" src="images/stop.png"/></div><div> ' . get_lang('stop_server') . '</div></div>'; if ($startup_file_exists) { $ctrlChkBoxes .= '<div id="server_icon" class="action-restart' . $server_home['home_id'] . '" > <div> <input id="action-restart" class="action-restart' . $server_home['home_id'] . '" name="action-' . $server_home['home_id'] . '" value="restart-' . $server_home['home_id'] . '-' . $server_home['mod_id'] . '-' . $server_home['ip'] . '-' . $server_home['port'] . '" type="radio"><img style="border:0;height:15px;" src="images/restart.png"/></div><div> ' . get_lang('restart_server') . '</div></div>'; } $stats_servers_online++; } else { $status = "offline"; if ($db->getLastParam($server_home['home_id']) != FALSE) { if ($update_in_progress) { $ctrlChkBoxes .= '<div id="server_icon" class="action-start' . $server_home['home_id'] . '" > ' . get_lang('update_in_progress') . '</div>'; } else { $ctrlChkBoxes .= '<div id="server_icon" class="action-start' . $server_home['home_id'] . '" > <div> <input id="action-start" class="action-start' . $server_home['home_id'] . '" name="action-' . $server_home['home_id'] . '" value="start-' . $server_home['home_id'] . '-' . $server_home['mod_id'] . '-' . $server_home['ip'] . '-' . $server_home['port'] . '" type="radio"><img style="border:0;height:15px;" src="images/start.png"/></div><div> ' . get_lang('start_server') . '</div></div>'; } } $order = 3; ob_start(); require 'modules/gamemanager/mini_start.php'; $ministart = ob_get_contents(); ob_end_clean(); if ($update_in_progress) { $offlineT = '<div id="server_icon" class="action-start' . $server_home['home_id'] . '" > ' . get_lang('update_in_progress') . '</div>'; } else { $offlineT = $ministart; } } } else { $status = "offline"; $order = 3; $address = "<span style='color:darkred;font-weight:bold;'>Agent Offline</span>"; } $user = $db->getUserById($server_home['user_id_main']); // Template @($first = "<tr class='maintr{$trclass}'>"); $first .= "<td class='collapsible'><span class='hidden'>{$order}</span><a></a>" . "<img src='images/{$status}.png' />" . "</td>"; $first .= "<td>" . "<span class='hidden'>{$mod}</span><img src='{$icon_path}' />" . "</td>"; $first .= "<td class='collapsible'><a></a><b>" . $server_home['home_name'] . "</b>{$mod_name}</td>"; $first .= "<td>" . $address . "</td>"; $first .= "<td>" . $user['users_login'] . "</td>"; $first .= "<td style='width:328px;padding:0px;'>{$ctrlChkBoxes}</td>"; $first .= "</tr>"; $second = "<tr class='expand-child'>"; @($second .= "<td colspan='4'>" . $refresh->getdiv($pos, "width:100%;") . "{$offlineT}</td>"); $second .= "<td width='80'>{$groupsus}</td>"; @($second .= "<td>{$btns}{$manager}<br>{$mysql}<br>{$get_size}<br>{$ts3opt}</td>"); $second .= "</tr>"; //Echo them all echo "{$first}{$second}"; } } echo "</tbody>"; echo "<tfoot style='border:1px solid grey;'>\n\t\t\t<tr>\n\t\t\t <td colspan='6' >\n\t\t\t\t<div class='bloc' >\n\t\t\t\t<img src='images/magnifglass.png' /> " . get_lang('statistics') . ": {$stats_servers_online}/{$stats_servers} " . get_lang('servers') . "\n</div>\n\t\t\t\t<div class='right bloc' >\n\t\t\t\t <label>" . get_lang('execute_selected_server_operations') . "</label>\n\t\t\t\t <input id='execute_operations' type='submit' value='" . get_lang('execute_operations') . "' >\n\n\t\t\t\t</div>\n\t\t\t </td>\n\t\t\t</tr>\n\t\t </tfoot>"; echo "</table>"; ?> <script type="text/javascript"> $(document).ready(function() { <?php echo $refresh->build("8000"); ?> $('input#search').quicksearch('table#servermonitor tbody tr.maintr'); $("#servermonitor") .collapsible("td.collapsible", {collapse: true}) .tablesorter({sortList: [[0,0], [1,0]] , widgets: ['zebra','repeatHeaders']}) ; } ); $("div#server_icon").click(function(){ var id = $(this).attr('class'); if($("input[type=radio]."+id).attr('checked') == 'checked') { $("input[type=radio]."+id).prop('checked', false); } else { $("input[type=radio]."+id).prop('checked', true); } }); $('.size').click(function(){ var $id = $(this).attr('id'); $.get( "home.php?m=user_games&type=cleared&p=get_size&home_id="+$id, function( data ) { $('#'+$id+".size").text( data ); $('#'+$id+".size").css("font-size", "16pt"); }); }); $('#execute_operations').click(function(){ var addpost = {}; $('input[type=radio]:checked').each(function( ){ var name = $(this).attr('name'); var value = $(this).val(); addpost[ name ] = value; }); $('.right.bloc').html('<img src="images/loading.gif" />'); $.ajax({ type: "POST", url: "home.php?m=gamemanager&p=game_monitor", data: addpost, complete: function(){ document.location.reload(); } }); }); $('img#action-stop').click(function(){ $('input[type=radio]#action-stop').each(function( ){ if( this.checked ) { $(this).attr('checked', false); } else { $(this).attr('checked', true); } }); }); $('img#action-restart').click(function(){ $('input[type=radio]#action-restart').each(function( ){ if( this.checked ) { $(this).attr('checked', false); } else { $(this).attr('checked', true); } }); }); $('img#action-start').click(function(){ $('input[type=radio]#action-start').each(function( ){ if( this.checked ) { $(this).attr('checked', false); } else { $(this).attr('checked', true); } }); }); </script> <?php }
function exec_ogp_module() { global $db; global $view; echo "<h2>" . get_lang('add_new_game_home') . "</h2>"; echo "<p><a href='?m=user_games'><< " . get_lang('back_to_game_servers') . "</a></p>"; $remote_servers = $db->getRemoteServers(); if ($remote_servers === FALSE) { echo "<p class='note'>" . get_lang('no_remote_servers_configured') . "</p>\n\t\t\t <p><a href='?m=server'>" . get_lang('add_remote_server') . "</a></p>"; return; } $game_cfgs = $db->getGameCfgs(); $users = $db->getUserList(); if ($game_cfgs === FALSE) { echo "<p class='note'>" . get_lang('no_game_configurations_found') . " <a href='?m=config_games'>" . get_lang('game_configurations') . "</a></p>"; return; } echo "<p> <span class='note'>" . get_lang('note') . ":</span> " . get_lang('add_mods_note') . "</p>"; $selections = array("allow_updates" => "u", "allow_file_management" => "f", "allow_parameter_usage" => "p", "allow_extra_params" => "e", "allow_ftp" => "t", "allow_custom_fields" => "c"); if (isset($_REQUEST['add_game_home'])) { $rserver_id = $_POST['rserver_id']; $home_cfg_id = $_POST['home_cfg_id']; $web_user_id = trim($_POST['web_user_id']); $control_password = genRandomString(8); $access_rights = ""; $ftp = FALSE; foreach ($selections as $selection => $flag) { if (isset($_REQUEST[$selection])) { $access_rights .= $flag; if ($flag == "t") { $ftp = TRUE; } } } if (empty($web_user_id)) { print_failure(get_lang('game_path_empty')); } else { foreach ($game_cfgs as $row) { if ($row['home_cfg_id'] == $home_cfg_id) { $server_name = $row['game_name']; } } foreach ($remote_servers as $server) { if ($server['remote_server_id'] == $rserver_id) { $ogp_user = $server['ogp_user']; } } foreach ($users as $user) { if ($user['user_id'] == $web_user_id) { $web_user = $user['users_login']; } } $ftppassword = genRandomString(8); $game_path = "/home/" . $ogp_user . "/OGP_User_Files/"; if (($new_home_id = $db->addGameHome($rserver_id, $web_user_id, $home_cfg_id, clean_path($game_path), $server_name, $control_password, $ftppassword)) !== FALSE) { $db->assignHomeTo("user", $web_user_id, $new_home_id, $access_rights); if ($ftp) { $home_info = $db->getGameHomeWithoutMods($new_home_id); require_once 'includes/lib_remote.php'; $remote = new OGPRemoteLibrary($home_info['agent_ip'], $home_info['agent_port'], $home_info['encryption_key']); $host_stat = $remote->status_chk(); if ($host_stat === 1) { $remote->ftp_mgr("useradd", $home_info['home_id'], $home_info['ftp_password'], $home_info['home_path']); } $db->changeFtpStatus('enabled', $new_home_id); } print_success(get_lang('game_home_added')); $db->logger(get_lang('game_home_added') . " ({$server_name})"); $view->refresh("?m=user_games&p=edit&home_id={$new_home_id}"); } else { print_failure(get_lang_f("failed_to_add_home_to_db", $db->getError())); } } } // View form to add more servers. if (!isset($_POST['rserver_id'])) { echo "<form action='?m=user_games&p=add' method='post'>"; echo "<table class='center'>"; echo "<tr><td class='right'>" . get_lang('game_server') . "</td><td class='left'><select onchange=" . '"this.form.submit()"' . " name='rserver_id'>\n"; echo "<option>" . get_lang('select_remote_server') . "</option>\n"; foreach ($remote_servers as $server) { echo "<option value='" . $server['remote_server_id'] . "'>" . $server['remote_server_name'] . " (" . $server['agent_ip'] . ")</option>\n"; } echo "</select>\n"; echo "</form>"; echo "</td></tr></table>"; } else { if (isset($_POST['rserver_id'])) { $rhost_id = $_POST['rserver_id']; } $remote_server = $db->getRemoteServer($rhost_id); require_once 'includes/lib_remote.php'; $remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']); $host_stat = $remote->status_chk(); if ($host_stat === 1) { $os = $remote->what_os(); } else { print_failure(get_lang_f("caution_agent_offline_can_not_get_os_and_arch_showing_servers_for_all_platforms")); $os = "Unknown OS"; } echo "<form action='?m=user_games&p=add' method='post'>"; echo "<table class='center'>"; echo "<tr><td class='right'>" . get_lang('game_type') . "</td><td class='left'> <select name='home_cfg_id'>\n"; // 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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $row['game_name'] . "</option>\n"; } } } elseif (preg_match("/Linux/", $os)) { foreach ($game_cfgs as $row) { if (preg_match("/linux32/", $row['game_key'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $row['game_name'] . "</option>\n"; } } } elseif ($os == "Unknown OS") { foreach ($game_cfgs as $row) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $row['game_name']; if (preg_match("/64/", $row['game_key'])) { echo " (64 bit)"; } echo "</option>\n"; } } echo "</select>\n</td></tr>"; // Select user echo "<tr><td class='right'>" . get_lang('login') . ":</td>\n\t\t\t<td class='left'><select name='web_user_id'>"; $users = $db->getUserList(); foreach ($users as $user) { // Only users and admins can be assigned homes... not subusers if (is_null($user['users_parent'])) { echo "<option value='" . $user['user_id'] . "'>" . $user['users_login'] . "</option>\n"; } } echo "</select>\n</td></tr>"; // Select permisions echo "<tr><td class='right'>" . get_lang('access_rights') . ":</td>\n\t\t\t<td class='left'>"; foreach ($selections as $selection => $flag) { echo create_selection($selection, $flag); } echo "</td></tr>"; // Assign home echo "<tr><td align='center' colspan='2'>\n\t\t\t <input type='hidden' name='rserver_id' value='" . $rhost_id . "' />" . "<input type='submit' name='add_game_home' value='" . get_lang('add_game_home') . "' /></td></tr></table>"; echo "</form>"; } }
function exec_ogp_module() { global $db; global $view; $home_id = isset($_REQUEST['home_id']) ? $_REQUEST['home_id'] : ""; $mod_id = isset($_REQUEST['mod_id']) ? $_REQUEST['mod_id'] : ""; $isAdmin = $db->isAdmin($_SESSION['user_id']); if ($isAdmin) { $home_info = $db->getGameHome($home_id); } else { $home_info = $db->getUserGameHome($_SESSION['user_id'], $home_id); } if ($home_info === FALSE || preg_match("/u/", $home_info['access_rights']) != 1) { print_failure(get_lang('no_rights')); echo "<table class='center'><tr><td><a href='?m=gamemanager&p=game_monitor&home_id=" . $home_info['home_id'] . "'><< " . get_lang('back') . "</a></td></tr></table>"; return; } $game_type = $home_info['game_key']; echo "<h2>Updating game server <em>" . $home_info['home_name'] . "</em></h2>"; $server_xml = read_server_config(SERVER_CONFIG_LOCATION . "/" . $home_info['home_cfg_file']); if ($server_xml->installer != "steamcmd") { print_failure(get_lang('xml_steam_error')); return; } $remote = new OGPRemoteLibrary($home_info['agent_ip'], $home_info['agent_port'], $home_info['encryption_key']); $host_stat = $remote->status_chk(); if ($remote->is_screen_running(OGP_SCREEN_TYPE_HOME, $home_id) == 1) { print_failure(get_lang('server_running_cant_update')); return; } $log_txt = ''; $update_active = $remote->get_log(OGP_SCREEN_TYPE_UPDATE, $home_id, clean_path($home_info['home_path']), $log_txt); $modkey = $home_info['mods'][$mod_id]['mod_key']; $mod_xml = xml_get_mod($server_xml, $modkey); if (!$mod_xml) { print_failure(get_lang_f('mod_key_not_found_from_xml', $modkey)); return; } if ($update_active === 0) { print_failure(get_lang('agent_offline')); echo "<meta http-equiv='refresh' content='5'>"; return; } else { if ($_REQUEST['update'] == 'update' && $update_active != 1) { $installer_name = $modkey; if (isset($mod_xml->installer_name)) { $installer_name = $mod_xml->installer_name; } $mod_cfg_id = $home_info['mod_cfg_id']; $game_mod_precmd = $db->resultQuery("SELECT DISTINCT precmd FROM OGP_DB_PREFIXgame_mods WHERE mod_id='{$mod_id}'"); if ($game_mod_precmd[0]['precmd'] === NULL or empty($game_mod_precmd[0]['precmd'])) { $config_mod_precmd = $db->resultQuery("SELECT DISTINCT def_precmd FROM OGP_DB_PREFIXconfig_mods WHERE mod_cfg_id='{$mod_cfg_id}'"); if ($config_mod_precmd[0]['def_precmd'] === NULL or empty($config_mod_precmd[0]['def_precmd'])) { $precmd = ""; } else { $precmd = $config_mod_precmd[0]['def_precmd']; } } else { $precmd = $game_mod_precmd[0]['precmd']; } $game_mod_postcmd = $db->resultQuery("SELECT DISTINCT postcmd FROM OGP_DB_PREFIXgame_mods WHERE mod_id='{$mod_id}'"); if ($game_mod_postcmd[0]['postcmd'] === NULL or empty($game_mod_postcmd[0]['postcmd'])) { $config_mod_postcmd = $db->resultQuery("SELECT DISTINCT def_postcmd FROM OGP_DB_PREFIXconfig_mods WHERE mod_cfg_id='{$mod_cfg_id}'"); if ($config_mod_postcmd[0]['def_postcmd'] === NULL or empty($config_mod_postcmd[0]['def_postcmd'])) { $postcmd = ""; } else { $postcmd = $config_mod_postcmd[0]['def_postcmd']; } } else { $postcmd = $game_mod_postcmd[0]['postcmd']; } $exec_folder_path = clean_path($home_info['home_path'] . "/" . $server_xml->exe_location); $exec_path = clean_path($exec_folder_path . "/" . $server_xml->server_exec_name); if (isset($_REQUEST['master_server_home_id'])) { $ms_home_id = $_REQUEST['master_server_home_id']; $ms_info = $db->getGameHome($ms_home_id); $steam_out = $remote->masterServerUpdate($home_id, $home_info['home_path'], $ms_home_id, $ms_info['home_path'], $exec_folder_path, $exec_path, $precmd, $postcmd); } else { if (preg_match("/win32/", $server_xml->game_key) or preg_match("/win64/", $server_xml->game_key)) { $cfg_os = "windows"; } elseif (preg_match("/linux/", $server_xml->game_key)) { $cfg_os = "linux"; } $settings = $db->getSettings(); // Some games like L4D2 require anonymous login if ($mod_xml->installer_login) { $login = $mod_xml->installer_login; $pass = ''; } else { $login = $settings['steam_user']; $pass = $settings['steam_pass']; } $modname = ($installer_name == '90' and !preg_match("/(cstrike|valve)/", $modkey)) ? $modkey : ''; $betaname = isset($mod_xml->betaname) ? $mod_xml->betaname : ''; $betapwd = isset($mod_xml->betapwd) ? $mod_xml->betapwd : ''; $steam_out = $remote->steam_cmd($home_id, $home_info['home_path'], $installer_name, $modname, $betaname, $betapwd, $login, $pass, $settings['steam_guard'], $exec_folder_path, $exec_path, $precmd, $postcmd, $cfg_os); } if ($steam_out === 0) { print_failure(get_lang('failed_to_start_steam_update')); return; } else { if ($steam_out === 1) { print_success(get_lang('update_started')); } else { if ($host_stat === 0) { print_failure(get_lang('agent_offline')); $view->refresh("?m=gamemanager&p=update&update=refresh&home_id={$home_id}&mod_id={$mod_id}", 5); return; } echo "Installing Steam... wait."; $steamcmdtrue = isset($_REQUEST['steamcmd']) ? "&steamcmd=true" : ""; $view->refresh("?m=gamemanager&p=update&update=update&home_id={$home_id}&mod_id={$mod_id}{$steamcmdtrue}", 5); return; } } } else { if (isset($_POST['stop_update_x'])) { $stop_update = sprintf("screen -S OGP_UPDATE_%09d -X quit", $home_id); $remote->exec("{$stop_update}"); } $update_complete = false; if ($update_active == 1) { echo "<p class='note'>" . get_lang('update_in_progress') . "</p>\n"; echo "<form method=POST><input type='image' name='stop_update' onsubmit='submit-form();' src='modules/administration/images/remove.gif'>" . get_lang('stop_update') . "</input></form>"; } else { echo "<meta http-equiv='refresh' content='60'>"; print_success(get_lang('update_completed')); echo "<table class='center'><tr><td><a href='?m=gamemanager&p=game_monitor&home_id=" . $home_info['home_id'] . "'><< " . get_lang('back') . "</a></td></tr></table>"; $update_complete = true; } if (empty($log_txt)) { $log_txt = get_lang('not_available'); } echo "<pre>" . $log_txt . "</pre>\n"; if ($update_complete) { return; } } } echo "<p><a href=\"?m=gamemanager&p=update&update=refresh&home_id={$home_id}&mod_id={$mod_id}\">"; echo get_lang('refresh_steam_status') . "</a></p>"; $view->refresh("?m=gamemanager&p=update&update=refresh&home_id={$home_id}&mod_id={$mod_id}", 5); return; }
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() { global $db, $settings; $isAdmin = $db->isAdmin($_SESSION['user_id']); $OnlineServers = ""; $OnlineServersTitle = ""; if (isset($settings['welcome_title']) && $settings['welcome_title'] == "1") { if (isset($settings['welcome_title_message']) && !empty($settings['welcome_title_message'])) { echo "<div>" . $settings['welcome_title_message'] . "</div>"; } } $OnlineServersTitle .= get_lang('online_servers'); $player_list = ""; if ($isAdmin) { $server_homes = $db->getIpPorts(); } else { $OnlineServersTitle = "Open Game Panel"; $OnlineServers .= "<p>" . get_lang("welcome_text") . "</p><br><b>" . get_lang('online_servers') . ":</b><br><br>"; $server_homes = $db->getIpPortsForUser($_SESSION['user_id']); } require_once "includes/refreshed.php"; $refresh = new refreshed(); if (!$server_homes) { $OnlineServers .= "<p class='failure'>" . get_lang('no_games_to_monitor') . "</p>"; if ($isAdmin) { //$OnlineServers .= "<p class='note'>".get_lang('add_games_in'). //" <a href='?m=user_games&p=add'>".get_lang('game_servers')."</a></p>"; $OnlineServers .= "<p class='note'>" . get_lang_f("add_games_in", "<a href='?m=user_games&p=add'>" . get_lang('game_servers') . "</a>") . "</p>"; } } else { if (isset($settings['old_dashboard_behavior']) and $settings['old_dashboard_behavior'] == 1) { $serverslist = $refresh->add("home.php?m=dashboard&p=query_ref&show=servers&type=cleared"); $playerslist = $refresh->add("home.php?m=dashboard&p=query_ref&show=players&type=cleared"); $OnlineServers .= $refresh->getdiv($serverslist); $player_list .= $refresh->getdiv($playerslist); } else { $player_list = ""; $stats_servers = 0; $stats_servers_online = 0; $stats_players = 0; $stats_maxplayers = 0; $onlinePlayers = ""; $OnlineServers .= "<table style='width:100%;' class='online_servers'>"; require_once "protocol/lgsl/lgsl_protocol.php"; foreach ($server_homes as $server_home) { $remote_server_id = $server_home['remote_server_id']; $rserver = $db->getRemoteServerById($remote_server_id); // Count the number of servers. $stats_servers++; // Remember to clear the old value here. $message = ""; $remote = new OGPRemoteLibrary($server_home['agent_ip'], $server_home['agent_port'], $server_home['encryption_key']); $host_stat = $remote->status_chk(); if ($host_stat === 1) { // Check if the screen running the server is running. $screen_running = $remote->is_screen_running(OGP_SCREEN_TYPE_HOME, $server_home['home_id']) === 1; $server_xml = read_server_config(SERVER_CONFIG_LOCATION . "/" . $server_home['home_cfg_file']); if ($screen_running) { // Check if the screen running the server is running. if ($server_home['use_nat'] == 1) { $ip = $server_home['agent_ip']; } else { $ip = $server_home['ip']; } $port = $server_home['port']; $get_q_and_s = lgsl_port_conversion((string) $server_xml->lgsl_query_name, $port, "", ""); //Connection port $c_port = $get_q_and_s['0']; //query port $q_port = $get_q_and_s['1']; //software port $s_port = $get_q_and_s['2']; if ($server_xml->protocol == "lgsl") { $address = "<a href='" . lgsl_software_link($server_xml->lgsl_query_name, $ip, $c_port, $q_port, $s_port) . "'>" . $ip . ":" . $port . "</a>"; } if ($server_xml->protocol == "teamspeak3") { $address = "<a href='ts3server://{$ip}:{$port}'>{$ip}:{$port}</a>"; } elseif ($server_xml->protocol == "gameq" and $server_xml->installer == "steam") { $address = "<a href='steam://connect/{$ip}:{$port}'>{$ip}:{$port}</a>"; } elseif ($server_xml->protocol == "gameq" or !isset($server_xml->protocol)) { $address = "{$ip}:{$port}"; } $OnlineServers .= "<tr><td><div class='name' ><a href='?m=gamemanager&p=game_monitor&home_id-mod_id-ip-port=" . $server_home['home_id'] . "-" . $server_home['mod_id'] . "-" . $server_home['ip'] . "-" . $server_home['port'] . "' ><img style='border:0;height:12px;' src='images/magnifglass.png'/>" . $server_home['home_name'] . "</a></div> | "; $OnlineServers .= "<div id='gamelink' >{$address}</div>"; $OnlineServers .= "</td></tr>"; $stats_servers_online++; } } unset($map, $player_list, $status, $ip, $port, $players, $playersmax, $name, $map, $mod, $xml_mod, $qport, $address, $maplocation); } $OnlineServers .= "</table>"; $OnlineServers .= "<center>" . get_lang('statistics') . ":<br>{$stats_servers_online}/{$stats_servers} " . get_lang('online_servers') . "</center>"; } } ?> <div style="margin-top:20px;"> <?php //$title[$id] = "The Title"; //$content[$id] = "Content of the Widget"; $title = array(); $content = array(); $href = array(); // Game Monitor $title[1] = get_lang('game_monitor'); $content[1] = '<img src="themes/' . $settings['theme'] . '/images/icons/game_monitor.png" style="width:48px;float:right;margin:0 0 0 8px" />' . get_lang('dashboard_game_monitor_text'); $href[1] = 'home.php?m=gamemanager&p=game_monitor'; // Online Server $title[2] = $OnlineServersTitle; $content[2] = $OnlineServers; $href[2] = null; // Currently Online $title[3] = get_lang('currently_online'); $content[3] = $player_list; $href[3] = null; // FTP $title[4] = get_lang('ftp'); $content[4] = '<img src="themes/' . $settings['theme'] . '/images/icons/folder.png" style="width:48px;float:right;margin:0 0 0 8px" />' . get_lang('dashboard_ftp_text'); $href[4] = 'home.php?m=ftp'; // Support $title[5] = get_lang('support'); $content[5] = '<img src="themes/' . $settings['theme'] . '/images/icons/support.png" style="width:48px;float:right;margin:0 0 0 8px" />' . get_lang('dashboard_support_text'); $href[5] = 'http://www.opengamepanel.org/forum'; $columns = array(); $columns[1]['column_id'] = 1; $columns[2]['column_id'] = 2; $columns[3]['column_id'] = 3; foreach ($columns as $column) { echo '<div class="column '; if ($column['column_id'] == 1) { echo 'one_fourth'; } else { if ($column['column_id'] == 2) { echo 'one_two'; } else { if ($column['column_id'] == 3) { echo 'one_fourth'; } } } echo '" id="column' . $column['column_id'] . '" >'; $items = $db->resultQuery("SELECT * FROM OGP_DB_PREFIXwidgets_users WHERE column_id='" . $column['column_id'] . "' AND user_id='" . $_SESSION['user_id'] . "' ORDER BY sort_no"); if ($items) { foreach ($items as $widget) { if ((!isset($settings['old_dashboard_behavior']) or $settings['old_dashboard_behavior'] == 0) and $widget['widget_id'] == "3") { continue; } echo ' <div class="dragbox bloc rounded" id="item' . $widget['widget_id'] . '"> <h4><span class="configure"></span>'; if (!is_null($title[$widget['widget_id']])) { echo $title[$widget['widget_id']]; } echo '</h4> <div class="dragbox-content" '; if (!is_null($href[$widget['widget_id']])) { echo "onclick=\"location.href='" . $href[$widget['widget_id']] . "'\" style=\"cursor:pointer;"; if ($widget['collapsed'] == 1) { echo 'display:none;'; } echo '"'; } elseif ($widget['collapsed'] == 1) { echo 'style="display:none;"'; } echo '>'; if (!is_null($content[$widget['widget_id']])) { echo $content[$widget['widget_id']]; } echo ' </div> </div>'; unset($widget); } } echo '</div>'; } if ($isAdmin and $db->isModuleInstalled('status')) { echo "<h0>Server Status</h0><br>"; $servers = $db->getRemoteServers(); echo "<div style='float:left;width:40%;' >\n\t\t\t <div class='bloc rounded' >\n\t\t\t <h4>Select remote server</h4>\n\t\t\t <div>\n\t\t\t\t<br>\n\t\t\t\t<center>\n\t\t\t <form action='' method='GET'>\n\t\t\t <input type='hidden' name='m' value='" . $_GET['m'] . "'/>\n\t\t\t <input type='hidden' name='p' value='" . $_GET['p'] . "'/>\n\t\t\t <select name='remote_server_id' onchange=" . '"this.form.submit()"' . ">\n"; foreach ($servers as $server_row) { if (!empty($server_row['remote_server_id']) and !isset($_GET['remote_server_id']) or !empty($server_row['remote_server_id']) and empty($_GET['remote_server_id'])) { $_GET['remote_server_id'] = $server_row['remote_server_id']; } if (isset($_GET['remote_server_id']) and $_GET['remote_server_id'] == $server_row['remote_server_id']) { $rhost_id = $_GET['remote_server_id']; $remote_server = $db->getRemoteServer($rhost_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) { $checked = "selected='selected'"; } else { $checked = ''; $_GET['remote_server_id'] = 'webhost'; } } else { $checked = ''; } echo "<option value='" . $server_row['remote_server_id'] . "' {$checked} >" . $server_row['remote_server_name'] . "</option>\n"; } if (function_exists('exec')) { $checked = (isset($_GET['remote_server_id']) and $_GET['remote_server_id'] == 'webhost') ? "selected='selected'" : ""; echo "<option value='webhost' {$checked} >Webhost Status</option>"; } echo "\t</select>\n\t\t\t </form>\n\t\t\t\t</center>\n\t\t\t\t<br><br>\n\t\t\t </div>\n\t\t\t </div>\n\t\t\t </div>\n"; if (isset($_GET['remote_server_id']) and $_GET['remote_server_id'] == "webhost") { unset($_GET['remote_server_id']); } if (isset($_GET['remote_server_id']) && !empty($_GET['remote_server_id'])) { $remote_server = "&remote_server_id=" . $_GET['remote_server_id']; } else { $remote_server = ""; } if ($isAdmin and $db->isModuleInstalled('status') and (isset($_GET['remote_server_id']) or function_exists('exec'))) { $status = $refresh->add("home.php?m=status&type=cleared" . $remote_server); echo $refresh->getdiv($status); } } ?> <script type="text/javascript"> var userAgent = navigator.userAgent.toLowerCase(), browser = '', version = 0; $.browser.chrome = /chrome/.test(navigator.userAgent.toLowerCase()); // Is this a version of IE? if ($.browser.msie) { userAgent = $.browser.version; userAgent = userAgent.substring(0,userAgent.indexOf('.')); version = userAgent; browser = "Internet Explorer"; } // Is this a version of Chrome? if ($.browser.chrome) { userAgent = userAgent.substring(userAgent.indexOf('chrome/') + 7); userAgent = userAgent.substring(0,userAgent.indexOf('.')); version = userAgent; // If it is chrome then jQuery thinks it's safari so we have to tell it it isn't $.browser.safari = false; browser = "Chrome"; } // Is this a version of Safari? if ($.browser.safari) { userAgent = userAgent.substring(userAgent.indexOf('safari/') + 7); userAgent = userAgent.substring(0,userAgent.indexOf('.')); version = userAgent; browser = "Safari"; } // Is this a version of Mozilla? if ($.browser.mozilla) { //Is it Firefox? if (navigator.userAgent.toLowerCase().indexOf('firefox') != -1) { userAgent = userAgent.substring(userAgent.indexOf('firefox/') + 8); userAgent = userAgent.substring(0,userAgent.indexOf('.')); version = userAgent; browser = "Firefox" } // If not then it must be another Mozilla else { browser = "Mozilla (not Firefox)" } } // Is this a version of Opera? if ($.browser.opera) { userAgent = userAgent.substring(userAgent.indexOf('version/') + 8); userAgent = userAgent.substring(0,userAgent.indexOf('.')); version = userAgent; browser = "Opera"; } // Now you have two variables, browser and version // which have the right info $(document).ready( function(){ $('.dragbox') .each(function(){ $(this).hover(function(){ $(this).find('h4').addClass('collapse'); }, function(){ $(this).find('h4').removeClass('collapse'); }) .find('h4').hover(function(){ $(this).find('.configure').css('visibility', 'visible'); }, function(){ $(this).find('.configure').css('visibility', 'hidden'); }) .click(function(){ $(this).siblings('.dragbox-content').toggle(); //Save state on change of collapse state of panel updateWidgetData(); }) .end() .find('.configure').css('visibility', 'hidden'); }); $('.column').sortable({ connectWith: '.column', handle: 'h4', cursor: 'move', placeholder: 'placeholder', forcePlaceholderSize: true, opacity: 0.4, start: function(event, ui){ //Firefox, Safari/Chrome fire click event after drag is complete, fix for that if(browser == "Firefox" || browser == "Mozilla (not Firefox)" || browser == "Safari") $(ui.item).find('.dragbox-content').toggle(); }, stop: function(){ updateWidgetData(); } }) .disableSelection(); } ); function updateWidgetData(){ var items=[]; $('.column').each(function(){ var columnId=$(this).attr('id'); $('.dragbox', this).each(function(i){ var collapsed=0; if($(this).find('.dragbox-content').css('display')=="none") collapsed=1; //Create Item object for current panel var item={ id: $(this).attr('id'), collapsed: collapsed, order : i, column: columnId }; //Push item object into items array items.push(item); }); }); //Assign items array to sortorder JSON variable var sortorder={ items: items }; //Pass sortorder variable to server using ajax to save state $.post('home.php?m=dashboard&p=updateWidgets', 'data='+$.toJSON(sortorder), function(response){ if(response.indexOf("success") < 0){ $("#console").html('<h0><div class="Failed">Failed to save you\'r operation! Please contact OGP...</div></h0>').hide().fadeIn(1000); } }); } $(document).ready(function(){ <?php echo $refresh->build("20000"); ?> }); </script> <?php }
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() { $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"); } } } } } }
function exec_ogp_module() { global $view; global $db; echo "<h2>" . get_lang('add_new_remote_host') . "</h2>"; echo "<p>" . get_lang('note_remote_host') . "</p>"; require_once "includes/form_table_class.php"; $ft = new FormTable(); $ft->start_form("?m=server&p=add"); $ft->start_table(); $ft->add_field('string', 'remote_host', ""); $ft->add_field('string', 'remote_host_port', "12679"); $ft->add_field('string', 'remote_host_name', ""); $ft->add_field('string', 'remote_host_user_name', ""); $ft->add_field('string', 'remote_host_ftp_ip', ""); $ft->add_field('string', 'remote_host_ftp_port', "21"); $ft->add_field('string', 'remote_encryption_key', ""); $ft->add_field('string', 'timeout', "2"); $ft->add_field('on_off', 'use_nat', "0"); $ft->end_table(); $ft->add_button('submit', 'add_remote_host', get_lang('add_remote_host')); $ft->end_form(); $servers = $db->getRemoteServers(); if ($servers === FALSE) { return; } $tr = 0; ?> <table id="servermonitor" class="tablesorter remote"> <thead> <tr> <th colspan="4" ><?php print_lang('configured_remote_hosts'); ?> </th> </tr> </thead> <tbody> <?php foreach ($servers as $server_row) { #generate jQuery code $jqboobles["{$server_row['remote_server_id']}"] = '$("#tonus-' . $server_row['remote_server_id'] . '").tooltip({ delay: 0, showURL: false, bodyHandler: function() { return $("<img/>").attr("src", this.src); } });'; #check to see if the remote daeomns are up status_chk is found in lib_remote.php $remote = new OGPRemoteLibrary($server_row['agent_ip'], $server_row['agent_port'], $server_row['encryption_key']); $host_stat = $remote->status_chk(); $buttons = "<a href='?m=server&p=edit&rhost_id=" . $server_row['remote_server_id'] . "&delete'>[" . get_lang('delete') . "]</a>\n" . "<a href='?m=server&p=edit&rhost_id=" . $server_row['remote_server_id'] . "&edit'>[" . get_lang('edit') . "]</a>\n"; $tittle = "<b>ID#:</b> <b style='color:red;'>" . $server_row['remote_server_id'] . "</b></td>\n\t\t\t\t\t<td class='collapsible' ><b>" . get_lang('server_name') . ":</b> " . $server_row['remote_server_name'] . "</td>\n\t\t\t\t\t<td class='collapsible' ><b>" . get_lang('agent_status') . ":</b> "; $booble = ""; if ($host_stat === 0) { $tittle .= "<span class='failure'>" . get_lang('offline') . "</span> "; } elseif ($host_stat === 1) { $os = $remote->what_os(); $buttons .= "<a href='?m=server&p=log&rhost_id=" . $server_row['remote_server_id'] . "'>[" . get_lang('view_log') . "]</a>\n"; $tittle .= "<span class='success'>" . get_lang('online') . "</span>"; $booble .= "<img id='tonus-{$server_row['remote_server_id']}' src='includes/api.php?remote_server={$server_row['remote_server_id']}&mon_stats' height='20' />"; } elseif ($host_stat === -1) { $tittle .= "<span class='failure'>" . get_lang('encryption_key_mismatch') . "</span>\n"; } else { $tittle .= "<span class='failure'>" . get_lang('unknown_error') . ": {$host_stat}</span>\n"; } $tittle .= "</td><td>{$buttons}</td>"; $ftp_ip = empty($server_row['ftp_ip']) ? $server_row['agent_ip'] : $server_row['ftp_ip']; $data = "<tr class='expand-child' >\n\t\t\t\t <td>{$booble}</td><td>\n\t\t\t\t\t<b>" . get_lang('ogp_user') . ":</b> " . $server_row['ogp_user'] . "<br />\n\t\t\t\t\t<b>" . get_lang('agent_ip_port') . ":</b> " . $server_row['agent_ip'] . ":" . $server_row['agent_port'] . "<br />\n\t\t\t\t\t<b>" . get_lang('remote_host_ftp_ip') . ":</b> " . $ftp_ip . "<br />\n\t\t\t\t\t<b>" . get_lang('remote_host_ftp_port') . ":</b> " . $server_row['ftp_port'] . "<br />\n\t\t\t\t\t<b>" . get_lang('timeout') . ":</b> " . $server_row['timeout'] . " " . get_lang('seconds') . "<br />\n\t\t\t\t\t<b>" . get_lang('encryption_key') . ":</b> " . $server_row['encryption_key'] . "<br />\n\t\t\t\t </td>\n\t\t\t\t <td><b>" . get_lang('ips') . ": </b><br>"; // Next we print the IP addresses and one empty field. $remote_server_ips = $db->getRemoteServerIPs($server_row['remote_server_id']); if (empty($remote_server_ips)) { $data .= "<span class='failure'>" . get_lang('no_ip_for_remote_host') . "</span>"; } else { foreach ($remote_server_ips as $ip_row) { $data .= $ip_row['ip'] . "<br>"; } } $data .= "</td><td>"; if ($host_stat === 1) { $data .= "<b>OS:</b> " . @$os . "<br>"; if (preg_match("/Linux/", $os)) { $data .= "<b>" . get_lang('ufw') . ":</b>"; if (isset($_GET['ch_ufw_status']) and $server_row['remote_server_id'] == $_GET['rhost_id']) { $rhost_id = $_GET['rhost_id']; $ch_ufw_status = $_GET['ch_ufw_status']; $db->query("UPDATE `OGP_DB_PREFIXremote_servers`\n\t\t\t\t\t\t\t\tSET ufw_status = '{$ch_ufw_status}'\n\t\t\t\t\t\t\t\tWHERE remote_server_id = '{$rhost_id}'"); if ($ch_ufw_status == "enable") { $remote->sudo_exec("ufw allow " . $server_row['agent_port']); //OGP agent port $remote->sudo_exec("ufw allow " . $server_row['ftp_port']); //FTP port $remote->sudo_exec("ufw allow 80"); //Apache (web server) port $remote->sudo_exec("ufw allow 22"); //SSH (putty) port $remote->sudo_exec("ufw allow 25"); //SMTP (mail) port $remote->sudo_exec("ufw allow proto tcp to any port 40000:65000"); //unknow range of ports needed by the OGP agent $remote->sudo_exec("echo y | ufw {$ch_ufw_status}"); } else { $remote->sudo_exec("ufw {$ch_ufw_status}"); } } if (!$db->query("SELECT ufw_status FROM `OGP_DB_PREFIXremote_servers`")) { $status = "disable"; } else { $status = $db->resultQuery("SELECT ufw_status \n\t\t\t\t\t\t\t\t\t\t FROM `OGP_DB_PREFIXremote_servers` \n\t\t\t\t\t\t\t\t\t\t WHERE remote_server_id = '" . $server_row['remote_server_id'] . "'"); $status = $status[0]['ufw_status']; if (empty($status)) { $status = "disable"; } } $data .= "<br />"; if ($status == "enable") { $data .= "<b>" . get_lang('status') . "</b> " . get_lang('on') . "<br />\n\t\t\t\t\t\t\t <a href='?m=server&rhost_id=" . $server_row['remote_server_id'] . "&ch_ufw_status=disable'>[" . get_lang('stop_firewall') . "]</a>\n"; } elseif ($status == "disable") { $data .= "<b>" . get_lang('status') . "</b> " . get_lang('off') . "<br />\n\t\t\t\t\t\t\t <a href='?m=server&rhost_id=" . $server_row['remote_server_id'] . "&ch_ufw_status=enable'>[" . get_lang('start_firewall') . "]</a>\n"; } $data .= "<br />"; } } $data .= "</td></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"> $(function() { <?php foreach ($jqboobles as $jqbooble) { echo "{$jqbooble}\n"; } ?> }); </script> <script type="text/javascript"> $(document).ready(function(){ $("#servermonitor") .collapsible("td.collapsible", {collapse: true}) .tablesorter({sortList: [[0,0], [1,0]] , widgets: ['zebra','repeatHeaders']}); }); </script> <?php }
function exec_ogp_module() { include 'includes/lib_remote.php'; global $db; global $view; if (isset($_POST['add_ftp_user'])) { $server_row = $db->getRemoteServer($_POST['remote_server_id']); $remote = new OGPRemoteLibrary($server_row['agent_ip'], $server_row['agent_port'], $server_row['encryption_key']); $post_ftp_login = trim($_POST['ftp_login']); $host_stat = $remote->status_chk(); $ftp_accounts_list = $remote->ftp_mgr("list"); $ftp_accounts = explode("\n", $ftp_accounts_list); $user_exists = FALSE; 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 ($user_exists === TRUE) { print_failure(get_lang('ftp_account_already_exists')); } else { $remote->ftp_mgr("useradd", $post_ftp_login, $_POST['ftp_password'], $_POST['full_path']); } } if (isset($_POST['del_ftp_user_y'])) { $server_row = $db->getRemoteServer($_POST['remote_server_id']); $remote = new OGPRemoteLibrary($server_row['agent_ip'], $server_row['agent_port'], $server_row['encryption_key']); $remote->ftp_mgr("userdel", $_POST['ftp_login']); $home_info = $db->getHomeByFtpLogin($server_row['remote_server_id'], $_POST['ftp_login']); $db->changeFtpStatus('disabled', $home_info['home_id']); } if (isset($_POST['edit_ftp_user'])) { $server_row = $db->getRemoteServer($_POST['remote_server_id']); $remote = new OGPRemoteLibrary($server_row['agent_ip'], $server_row['agent_port'], $server_row['encryption_key']); $settings = ""; foreach ($_POST as $key => $value) { if ($key != "edit_ftp_user" and $key != "ftp_login" and $key != "remote_server_id") { $account_settings .= "{$key}\t{$value}\n"; } } $remote->ftp_mgr("usermod", $_POST['ftp_login'], $account_settings); } ?> <style type="text/css"> .collapsible { width: 6px; } .collapsible a.collapsed { margin: 2px; display: block; width: 15px; height: 15px; background: url(images/tablesorter_expand.png) no-repeat 3px 3px; outline: 0; } .collapsible a.expanded { margin: 2px; display: block; width: 15px; height: 15px; background: url(images/tablesorter_expand.png) no-repeat -24px 3px; outline: 0; } </style> <script type="text/javascript" src="js/jquery-1.7.1.min.js"></script> <script type="text/javascript" src="js/jquery.tablesorter.mod.js"></script> <script type="text/javascript" src="js/jquery.tablesorter.collapsible.js"></script> <script type="text/javascript"> $(document).ready( function (){ $(".tablesorter").collapsible("td.collapsible", {collapse: true}) .tablesorter({ // set default sort column sortList: [[4,0]], // don't sort by first column headers: {0: {sorter: false}} // set the widgets being used - zebra stripping , widgets: ['zebra'] , onRenderHeader: function (){ this.wrapInner("<span></span>"); } , debug: false }); } ); </script> <?php echo "<h2>" . get_lang('pure-ftpd_admin') . "</h2>"; $servers = $db->getRemoteServers(); echo "<tr><td colspan='3' >\n\t\t<form method=POST >\n\t\t<table class='center' style='width:100%' ><tr>\n\t\t<td>" . get_lang('remote_server') . " <select style='width:250px' name='remote_server_id' >"; foreach ($servers as $server_row) { echo "<option value='" . $server_row['remote_server_id'] . "' >" . $server_row['remote_server_name'] . " (" . $server_row['agent_ip'] . ":" . $server_row['agent_port'] . ")</option>"; } echo "</select>\n\t\t\t</td>\n\t\t\t<td>" . get_lang('login') . "<input type=text name='ftp_login' /></td>\n\t\t\t<td>" . get_lang('password') . "<input type=text name='ftp_password' /></td>\n\t\t\t<td>" . get_lang('full_path') . "<input type=text name='full_path' /></td>\n\t\t </tr>\n\t\t <tr>\n\t\t\t<td colspan=4 ><input style='width:100%;' type=submit name='add_ftp_user' value='" . get_lang('add_ftp_account') . "' /></td>\n\t\t </tr>\n\t\t </table>\n\t\t </form>\n\t\t </td></tr>"; ?> <table id="servermonitor" class="tablesorter"> <thead> <tr> <th></th><th><?php print_lang('remote_server'); ?> </th><th><?php print_lang('login'); ?> </th><th><?php print_lang('server_name'); ?> </th><th><?php print_lang('full_path'); ?> </th> </tr> </thead> <tbody> <?php foreach ($servers as $server_row) { $remote = new OGPRemoteLibrary($server_row['agent_ip'], $server_row['agent_port'], $server_row['encryption_key']); $host_stat = $remote->status_chk(); $status = ($host_stat === 0 or $host_stat === -1) ? "<span class='failure'>" . get_lang('offline') . "</span>" : "<span class='success'>" . get_lang('online') . "</span>"; if ($host_stat === 1) { $ftp_accounts_list = $remote->ftp_mgr("list"); $ftp_accounts = explode("\n", $ftp_accounts_list); foreach ($ftp_accounts as $ftp_account) { if (!empty($ftp_account)) { list($ftp_login, $ftp_path) = explode("\t", $ftp_account); $ftp_login = trim($ftp_login); $home_info = $db->getHomeByFtpLogin($server_row['remote_server_id'], $ftp_login); $expandme = (isset($_POST['ftp_login']) and $ftp_login == $_POST['ftp_login'] and (isset($_POST['remote_server_id']) and $home_info['remote_server_id'] == $_POST['remote_server_id'])) ? "expandme" : ""; $home_name = isset($home_info['home_name']) ? $home_info['home_name'] : $ftp_path; echo "<tr class='maintr {$expandme}'><td class='collapsible' ></td><td>" . $server_row['remote_server_name'] . " (" . $server_row['agent_ip'] . ")</td><td><b class='failure' >{$ftp_login}</td><td>{$home_name}</td><td>{$ftp_path}</td></tr>\n\t\t\t\t\t\t <tr class='expand-child' ><td colspan='4' >\n\t\t\t\t\t\t <form method=POST >\n\t\t\t\t\t\t <table>"; $account_details = $remote->ftp_mgr("show", $ftp_login); $ftp_account_detail_list = explode("\n", $account_details); foreach ($ftp_account_detail_list as $detail_line) { if (!empty($detail_line)) { list($key, $value) = explode(" : ", $detail_line); $key = trim($key); $value = trim($value); $blacklist = array("Login", "Password", "UID", "GID", "ftp_user_id", "username", "username_prefix", "password", "sys_userid", "sys_groupid", "sys_perm_user", "sys_perm_group", "sys_perm_other", "server_id", "parent_domain_id", "uid", "gid"); if (in_array($key, $blacklist)) { continue; } $value_parts = explode(" ", $value); $value = $value_parts[0]; @($advert = $value_parts[1]); if ($key == "Allowed local IPs" or $key == "ul_ratio" or count($ftp_account_detail_list) == 4 and $key == "Directory") { echo "</table>\n</td><td>\n<table>\n"; } if ($key == "Directory") { $value = str_replace("/./", "", $value); } if ($key == "Username") { $readOnly = true; } echo "<tr><td>{$key}</td><td>\n\t\t\t\t\t\t\t\t\t <input type=text name='{$key}' value='{$value}' "; if (isset($readOnly) && $readOnly) { echo "readonly "; } echo "/>\n\t\t\t\t\t\t\t\t </td><td>{$advert}</td></tr>\n"; unset($readOnly); } } echo "<tr>\n\t\t\t\t\t\t\t<td colspan='2' >\n\t\t\t\t\t\t\t <center>\n\t\t\t\t\t\t\t <input type=hidden name='remote_server_id' value='" . $server_row['remote_server_id'] . "'/>\n\t\t\t\t\t\t\t <input type=hidden name='ftp_login' value='{$ftp_login}'/>\n\t\t\t\t\t\t\t <input type=submit name='edit_ftp_user' value='" . get_lang('change_account_details') . "' />\n\t\t\t\t\t\t\t </center>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t <input type='image' name='del_ftp_user' onsubmit='submit-form();' src='modules/administration/images/remove.gif'>" . get_lang('remove_account') . "</input>\n\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t </tr>\n\t\t\t\t\t\t </table>\n\t\t\t\t\t\t </form>\n\t\t\t\t\t\t </td>\n\t\t\t\t\t\t</tr>"; } } } } echo "</tbody>"; echo "</table>\n"; }
function exec_ogp_module() { global $db, $view; if (isset($_GET['rserver_id']) and $_GET['rserver_id'] != "") { $remote_server_ips = $db->getRemoteServerIPs($_GET['rserver_id']); if (!empty($remote_server_ips)) { if (isset($_GET['ip_id']) and $_GET['ip_id'] != "") { $ip = $db->getIpById($_GET['ip_id']); echo "<h2>" . get_lang_f('assign_new_ports_range_for_ip', $ip) . "</h2>"; if (isset($_POST['assign_range'])) { if ($_POST['home_cfg_id'] != "0") { $cfg_info = $db->getGameCfg($_POST['home_cfg_id']); } else { $cfg_info['game_name'] = get_lang('unspecified_game_types'); } $retval = $db->addPortsRange($_POST['ip_id'], $_POST['home_cfg_id'], $_POST['start_port'], $_POST['end_port'], $_POST['port_increment']); if ($retval === 1) { print_failure(get_lang('invalid_values')); } elseif ($retval === 2) { print_failure(get_lang('ports_in_range_already_arranged')); } elseif ($retval) { print_success(get_lang_f('ports_range_added_successfull_for', $cfg_info['game_name'])); } else { print_failure(get_lang_f('ports_range_already_configured_for', $cfg_info['game_name'])); } $view->refresh('?m=server&p=arrange_ports&rserver_id=' . $_GET['rserver_id'] . '&ip_id=' . $_GET['ip_id'], 3); } $game_homes = $db->getIpPorts($_GET['ip_id']); $game_cfgs = $db->getGameCfgs(); // require_once 'includes/lib_remote.php'; $rhost_id = $_GET['rserver_id']; $remote_server = $db->getRemoteServer($rhost_id); require_once 'includes/lib_remote.php'; $remote = new OGPRemoteLibrary($remote_server['agent_ip'], $remote_server['agent_port'], $remote_server['encryption_key']); $host_stat = $remote->status_chk(); if ($host_stat === 1) { $os = $remote->what_os(); } else { print_failure(get_lang_f("caution_agent_offline_can_not_get_os_and_arch_showing_servers_for_all_platforms")); $os = "Unknown OS"; } echo "<form method='POST' action=''>\n\n\t\t\t\t\t <input type='hidden' name='ip_id' value='" . $_GET['ip_id'] . "' />\n\n\t\t\t\t\t <table>\n\n\t\t\t\t\t <tr>\n\n\t\t\t\t\t <td>\n\n\t\t\t\t\t <select name='home_cfg_id'>\n\n\t\t\t\t\t <option style='background:black;color:white;' value='0'>" . get_lang('unspecified_game_types') . "</option>\n"; echo "<b>" . get_lang('assign_range_to_game_type') . ":</b>"; // 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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $row['game_name'] . "</option>\n"; } } } elseif (preg_match("/Linux/", $os)) { foreach ($game_cfgs as $row) { if (preg_match("/linux32/", $row['game_key'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $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'])) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $row['game_name'] . "</option>\n"; } } } elseif ($os == "Unknown OS") { foreach ($game_cfgs as $row) { echo "<option value='" . $row['home_cfg_id'] . "'>" . $row['game_name']; if (preg_match("/64/", $row['game_key'])) { echo " (64 bit)"; } echo "</option>\n"; } } echo "</select>\n\n\t\t\t\t\t </td>\n\n\t\t\t\t\t <td>\n" . get_lang('start_port') . "<input type='text' id='start_port' name='start_port' class='add' size='8' />\n\n\t\t\t\t\t </td>\n\n\t\t\t\t\t <td>\n" . get_lang('end_port') . "<input type='text' id='end_port' name='end_port' class='add' size='8' />\n\n\t\t\t\t\t </td>\n\n\t\t\t\t\t <td>\n\n\t\t\t\t\t " . get_lang('port_increment') . "<input type='text' id='port_increment' name='port_increment' class='add' value='1' size='2' />\n\n\t\t\t\t\t </td>\n\n\t\t\t\t\t <td>\n\n\t\t\t\t\t " . get_lang('total_assignable_ports') . "\t<span id='total_assignable_ports' class='add'></span>\n\n\t\t\t\t\t </td>\n\n\t\t\t\t\t <td>\n" . "<input type='submit' name='assign_range' value='" . get_lang('assign_range') . "' />\n\n\t\t\t\t\t </td>\n \n\t\t\t\t\t </tr>\n \n\t\t\t\t\t </table>\n\n\t\t\t\t\t </form>\n"; echo "<h2>" . get_lang_f('assigned_port_ranges_for_ip', $ip) . "</h2>"; // if (isset($_POST['delete_range'])) { if ($db->delPortsRange($_POST['range_id'])) { print_success(get_lang('ports_range_deleted_successfull')); } else { print_failure(get_lang('failed_to_delete_ports_range')); } $view->refresh('?m=server&p=arrange_ports&rserver_id=' . $_GET['rserver_id'] . '&ip_id=' . $_GET['ip_id'], 3); } if (isset($_POST['edit_range'])) { if ($_POST['home_cfg_id'] != "0") { $cfg_info = $db->getGameCfg($_POST['home_cfg_id']); } else { $cfg_info['game_name'] = get_lang('unspecified_game_types'); } $retval = $db->editPortsRange($_POST['range_id'], $_POST['ip_id'], $_POST['start_port'], $_POST['end_port'], $_POST['port_increment']); if ($retval === 1) { print_failure(get_lang('invalid_values')); } elseif ($retval === 2) { print_failure(get_lang('ports_in_range_already_arranged')); } elseif ($retval) { print_success(get_lang_f('ports_range_edited_successfull_for', $cfg_info['game_name'])); } else { print_failure(get_lang_f('ports_range_already_configured_for', $cfg_info['game_name'])); } $view->refresh('?m=server&p=arrange_ports&rserver_id=' . $_GET['rserver_id'] . '&ip_id=' . $_GET['ip_id'], 3); } $ranges = $db->getPortsRange($_GET['ip_id']); if (!empty($ranges)) { echo "<table>\n"; foreach ($ranges as $range) { if ($range['home_cfg_id'] != "0") { $cfg_info = $db->getGameCfg($range['home_cfg_id']); } else { $cfg_info['game_name'] = get_lang('unspecified_game_types'); } $available_ports_amount = intval(($range['end_port'] - $range['start_port']) / $range['port_increment'] + 1); $usable_range_ports = array(); for ($port = $range['start_port']; $port >= $range['start_port'] and $port <= $range['end_port']; $port += $range['port_increment']) { $usable_range_ports[] = $port; } $used_ports = array(); if (!empty($game_homes)) { foreach ($game_homes as $game_home) { $used_ports[] = $game_home['port']; } } if (!empty($used_ports)) { foreach ($used_ports as $used_port) { if (in_array($used_port, $usable_range_ports)) { $available_ports_amount--; } } } echo "<form method='POST' action=''>\n\n\t\t\t\t\t\t\t <input type='hidden' name='range_id' value='" . $range['range_id'] . "' />\n\n\t\t\t\t\t\t\t <input type='hidden' name='ip_id' value='" . $range['ip_id'] . "' />\n\n\t\t\t\t\t\t\t <input type='hidden' name='home_cfg_id' value='" . $range['home_cfg_id'] . "' />\n\n\t\t\t\t\t\t\t <tr>\n\n\t\t\t\t\t\t\t <td>\n" . $cfg_info['game_name'] . "</td>\n\n\t\t\t\t\t\t\t <td>\n" . get_lang('start_port') . "<input type='text' id='start_port' name='start_port' value='" . $range['start_port'] . "' size='8' />\n\n\t\t\t\t\t\t\t </td>\n\n\t\t\t\t\t\t\t <td>\n" . get_lang('end_port') . "<input type='text' id='end_port' name='end_port' value='" . $range['end_port'] . "' size='8' />\n\n\t\t\t\t\t\t\t </td>\n\n\t\t\t\t\t\t\t <td>\n" . get_lang('port_increment') . "<input type='text' id='port_increment' name='port_increment' value='" . $range['port_increment'] . "' value='1' size='2' />\n\n\t\t\t\t\t\t\t </td>\n\n\t\t\t\t\t\t\t <td>\n" . get_lang('available_range_ports') . "\t<span id='available_range_ports'>" . $available_ports_amount . "</span>\n\n\t\t\t\t\t\t\t </td>\n\n\t\t\t\t\t\t\t <td>\n\n\t\t\t\t\t\t\t\t<input type='submit' name='edit_range' value='" . get_lang('edit_range') . "' />\n\n\t\t\t\t\t\t\t\t<input type='submit' name='delete_range' value='" . get_lang('delete_range') . "' />\n\n\t\t\t\t\t\t\t </td>\n \n\t\t\t\t\t\t\t </tr>\n \n\t\t\t\t\t\t </form>\n"; } echo "</table>\n"; } echo "<h2>" . get_lang_f('assigned_ports_for_ip', $ip) . "</h2>"; if (!empty($game_homes)) { echo "<table class='center'>"; echo "<tr><th>" . get_lang('home_id') . "</th><th>" . get_lang('home_path') . "</th><th>" . get_lang('game_type') . "</th><th>" . get_lang('server_name') . "</th><th>" . get_lang('port') . "</th></tr>"; foreach ($game_homes as $game_home) { echo "<tr><td>" . $game_home['home_id'] . "</td><td>" . $game_home['home_path'] . "</td><td>" . $game_home['game_name'] . "</td><td>" . $game_home['home_name'] . "</td><td>" . $game_home['port'] . "</td></tr>"; } echo "</table>"; } } } else { echo "There are no IPs assigned to the selected remote server."; return; } echo create_back_button('server', 'edit&rhost_id=' . $_GET['rserver_id'] . '&edit'); } ?> <script type="text/javascript"> $(document).ready(function(){ $("input[type=text]").each(function(){ $(this).numeric(); }); $('input#start_port.add').on('input', function() { $('input#end_port.add').val( Number($(this).val()) ); $('span#total_assignable_ports.add').html( parseInt( ( Number( $('input#end_port.add').val() ) - Number( $(this).val() ) ) / Number( $('input#port_increment.add').val() ) ) + 1 ); }); $('input#end_port.add').on('input', function() { $('span#total_assignable_ports.add').html( parseInt( ( Number( $(this).val() ) - Number( $('input#start_port.add').val() ) ) / Number( $('input#port_increment.add').val() ) ) + 1 ); }); $('input#port_increment.add').on('input', function() { $('span#total_assignable_ports.add').html( parseInt( ( Number( $('input#end_port.add').val() ) - Number( $('input#start_port.add').val() ) ) / Number( $(this).val() ) ) + 1 ); }); }); </script> <?php }
function exec_ogp_module() { global $db, $OnlineServers; $isAdmin = $db->isAdmin($_SESSION['user_id']); $panel_settings = $db->getSettings(); $settings = $db->getSettings(); $OnlineServers = ""; $OnlineServersTitle = ""; require_once 'includes/lib_remote.php'; if ($isAdmin) { $server_homes = $db->getIpPorts(); } else { $server_homes = $db->getIpPortsForUser($_SESSION['user_id']); } $player_list = ""; if (!$server_homes) { $OnlineServers .= ""; } else { $stats_servers = 0; $stats_servers_online = 0; $stats_players = 0; $stats_maxplayers = 0; $onlinePlayers = ""; $OnlineServers .= "<table style='width:100%;' class='online_servers'>"; foreach ($server_homes as $server_home) { $remote_server_id = $server_home['remote_server_id']; $rserver = $db->getRemoteServerById($remote_server_id); // Count the number of servers. $stats_servers++; // Remember to clear the old value here. $message = ""; $remote = new OGPRemoteLibrary($server_home['agent_ip'], $server_home['agent_port'], $server_home['encryption_key']); $host_stat = $remote->status_chk(); if ($host_stat === 1) { // Check if the screen running the server is running. $screen_running = $remote->is_screen_running(OGP_SCREEN_TYPE_HOME, $server_home['home_id']) === 1; $server_xml = read_server_config(SERVER_CONFIG_LOCATION . "/" . $server_home['home_cfg_file']); $id = strlen($server_home['home_name']) > 15 ? "id='scrolldown'" : ""; if ($screen_running) { // Check if the screen running the server is running. if ($server_xml->protocol == "gameq") { require 'protocol/GameQ/GameQMonitor.php'; } else { if ($server_xml->protocol == "lgsl") { require 'protocol/lgsl/LGSLMonitor.php'; } else { if ($server_xml->protocol == "teamspeak3") { require 'protocol/TeamSpeak3/TS3Monitor.php'; } else { // This is here because some servers are not supported by LGSL/GameQ or // because we do not have proper support for them yet. // With properly supported games this should not needed. // (In a perfect world no one would need an insurance.) $status = "half"; if ($server_home['use_nat'] == 1) { $ip = $server_home['agent_ip']; } else { $ip = $server_home['ip']; } $port = $server_home['port']; $player_list = ""; } } } if ($status == "online") { $OnlineServers .= "<tr><td><div {$id} class='name' ><a href='?m=gamemanager&p=game_monitor&home_id-mod_id-ip-port=" . $server_home['home_id'] . "-" . $server_home['mod_id'] . "-" . $server_home['ip'] . "-" . $server_home['port'] . "' ><img style='border:0;height:12px;' src='images/magnifglass.png'/>" . $server_home['home_name'] . "</a></div>"; $OnlineServers .= "<div><div style='font-size:8pt;' >[" . $players . '/' . $playersmax . "]</div> " . $map . '</div>'; $OnlineServers .= "<div id='gamelink' >{$address}</div>"; $OnlineServers .= "</td></tr>"; if ($players >= 1) { $onlinePlayers .= print_player_list($playersList, $players, $playersmax, $server_home['game_name']); } $stats_servers_online++; } elseif ($status == "half") { $OnlineServers .= "<tr><td><div {$id} class='name' ><a href='?m=gamemanager&p=game_monitor&home_id-mod_id-ip-port=" . $server_home['home_id'] . "-" . $server_home['mod_id'] . "-" . $server_home['ip'] . "-" . $server_home['port'] . "' ><img style='border:0;height:12px;' src='images/magnifglass.png'/>" . $server_home['home_name'] . "</a></div>"; $OnlineServers .= "<div><div style='font-size:8pt;' ></div> </div>"; $OnlineServers .= "<div id='gamelink' >{$ip}:{$port}</div>"; $OnlineServers .= "</td></tr>"; $stats_servers_online++; } } } unset($map, $player_list, $status, $ip, $port, $players, $playersmax, $name, $map, $mod, $xml_mod, $qport, $address, $maplocation); } $OnlineServers .= "</table>"; $OnlineServers .= "<center>" . get_lang('statistics') . ":<br>{$stats_servers_online}/{$stats_servers} \n\t\t" . get_lang('servers') . "<br>{$stats_players}/{$stats_maxplayers} " . get_lang('players') . "</center>"; } if ($_GET['show'] == "servers") { echo $OnlineServers; } if ($_GET['show'] == "players") { echo $onlinePlayers; } }
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; $isAdmin = $db->isAdmin($_SESSION['user_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; } echo "<h2>" . get_lang_f('mysql_dbs_for', $game_home['home_name']) . "</h2>"; $home_dbs = $modDb->getMysqlDBsbyHomeId($game_home['home_id']); if (empty($home_dbs)) { print_failure(get_lang_f('there_are_no_databases_assigned_for', $game_home['home_name'])); return; } $db_array["0"] = get_lang('select_db'); foreach ($home_dbs as $home_db) { $db_array["{$home_db['db_id']}"] = $home_db['db_name']; } $ft = new FormTable(); $ft->start_form(''); $ft->start_table(); $ft->add_custom_field('select_db', create_drop_box_from_array($db_array, "db_id", isset($_REQUEST['db_id']) ? $_REQUEST['db_id'] : "0", false)); $ft->end_table(); $ft->end_form(); $database_exists = FALSE; $server_online = FALSE; if (isset($_REQUEST['db_id']) and $_REQUEST['db_id'] != "0") { $db_id = $_REQUEST['db_id']; $mysql_db = $modDb->getMysqlHomeDBbyId($game_home['home_id'], $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) { $user_db = $remote->exec('mysqlshow --user='******'db_user'] . ' --password='******'db_passwd'] . ' ' . $mysql_db['db_name']); if ($user_db != "") { $database_exists = TRUE; } $server_online = TRUE; } } } else { @($link = mysql_connect($mysql_db['mysql_ip'] . ':' . $mysql_db['mysql_port'], $mysql_db['db_user'], $mysql_db['db_passwd'])); if ($link !== FALSE) { $server_online = TRUE; if (mysql_select_db($mysql_db['db_name'], $link) !== FALSE) { $databases = mysql_query("SHOW TABLES;"); $user_db = "Database: " . $mysql_db['db_name'] . "\nTables:\n"; while ($table = mysql_fetch_array($databases)) { $user_db .= $table[0] . "\n"; } $database_exists = TRUE; } } } if (isset($_POST['restore'])) { $command = 'mysql --host=' . $mysql_db['mysql_ip'] . ' --port=' . $mysql_db['mysql_port'] . ' --user='******'db_user'] . ' --password='******'db_passwd'] . ' ' . $mysql_db['db_name'] . ' < ' . $_FILES["file"]["tmp_name"]; if ($mysql_db['remote_server_id'] != "0") { $remote->exec($command, $output); } else { system($command); } $view->refresh('?m=mysql&p=user_db&home_id=' . $game_home['home_id'] . '&db_id=' . $db_id, 0); } if ($server_online and $database_exists) { echo "<table class='database' ><tr><td>\n<div class='dragbox bloc rounded' ><h4>" . get_lang('db_info') . "</h4>\n" . "<table class='database_info' ><tr>" . "<td><b>" . get_lang('mysql_ip') . " :</b></td><td>" . $mysql_db['mysql_ip'] . "</td></tr>\n" . "<td><b>" . get_lang('mysql_port') . " :</b></td><td>" . $mysql_db['mysql_port'] . "</td></tr>\n" . "<td><b>" . get_lang('db_name') . " :</b></td><td>" . $mysql_db['db_name'] . "</td></tr>\n" . "<td><b>" . get_lang('db_user') . " :</b></td><td>" . $mysql_db['db_user'] . "</td></tr>\n" . "<td><b>" . get_lang('db_passwd') . " :</b></td><td>" . $mysql_db['db_passwd'] . "</td></tr>\n" . "<td><b>" . get_lang('privilegies') . " :</b></td><td>" . $mysql_db['privilegies_str'] . "</td></tr></table></div>\n" . "<td><div class='dragbox bloc rounded' style='background:black;' ><h4>" . get_lang('db_tables') . "</h4>" . "<pre><xmp>" . $user_db . "</xmp></pre></div></td></tr></table>"; echo "<h2>" . get_lang('db_backup') . "</h2>"; ?> <table class='administration-table'> <tr> <td> <form method="POST" action="?m=mysql&p=get_dump&home_id=<?php echo $game_home['home_id']; ?> &db_id=<?php echo $db_id; ?> &type=cleared" > <button name="download"><?php print_lang('download_db_backup'); ?> </button> </form> <br> <form method="POST" action="?m=mysql&p=user_db&home_id=<?php echo $game_home['home_id']; ?> &db_id=<?php echo $db_id; ?> " enctype="multipart/form-data"> <label for="file"><?php print_lang('sql_file'); ?> :</label> <input type="file" name="file" id="file" /> <button name="restore"><?php print_lang('restore_db_backup'); ?> </button> </form> </td> </tr> </table> <?php } } }