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() { $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 } } }