function get_table_content($db, $table, $handler)
{
$result = mysql_db_query($db, "SELECT * FROM {$table}") or mysql_die();
$i = 0;
while ($row = mysql_fetch_row($result)) {
$table_list = "(";
for ($j = 0; $j < mysql_num_fields($result); $j++) {
$table_list .= mysql_field_name($result, $j) . ",";
}
$table_list = substr($table_list, 0, -2);
$table_list .= ")";
if (isset($GLOBALS["showcolumns"])) {
$schema_insert = "INSERT INTO {$table} {$table_list} VALUES (";
} else {
$schema_insert = "INSERT INTO {$table} VALUES (";
}
for ($j = 0; $j < mysql_num_fields($result); $j++) {
if (!isset($row[$j])) {
$schema_insert .= " NULL,";
} elseif ($row[$j] != "") {
$schema_insert .= " '" . addslashes($row[$j]) . "',";
} else {
$schema_insert .= " '',";
}
}
$schema_insert = ereg_replace(",\$", "", $schema_insert);
$schema_insert .= ")";
$handler(trim($schema_insert));
$i++;
}
return true;
}
function SyncDBContent($db_host = "", $db_name = "", $db_user = "", $db_user = "")
{
$this->db_name = $db_name;
$this->db_link = @mysql_connect($db_host, $db_user, $db_pass) or mysql_die();
mysql_select_db($this->db_name) or mysql_die();
$this->db_tables = $this->get_tablenames();
}
/**
* Insert datas from one table to another one
*
* @param string the original insert statement
*
* @global string the database name
* @global string the original table name
* @global string the target database and table names
* @global string the sql query used to copy the data
*/
function my_handler($sql_insert = '')
{
global $db, $table, $target;
global $sql_insert_data;
$sql_insert = eregi_replace('INSERT INTO (`?)' . $table . '(`?)', 'INSERT INTO ' . $target, $sql_insert);
$result = mysql_query($sql_insert) or mysql_die('', $sql_insert);
$sql_insert_data .= $sql_insert . ';' . "\n";
}
if (!empty($lastname_per)) {
// Look if contact is in table
$columns = "*";
$tables = "contact";
$where = "conid='{$id}'";
if (!$db->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) {
mysql_die($db);
} else {
// If contact in table
if ($db->next_record()) {
if ($db->f("user") == $auth->auth["uname"] || $perm->have_perm("admin")) {
// Insert new contact person
$tables = "persons";
$set = "conid_per='{$id}',salutation_per='{$salutation_per}',firstname_per='{$firstname_per}',lastname_per='{$lastname_per}',grad_per='{$grad_per}',position_per='{$position_per}',phone_per='{$phone_per}',fax_per='{$fax_per}',email_per='{$email_per}',homepage_per='{$homepage_per}',comment_per='{$comment_per}',status_per='A',modification_per=NOW(),creation_per=NOW()";
if (!$db->query("INSERT {$tables} SET {$set}")) {
mysql_die($db);
}
// Select and show new/updated contact with contact persons
conbyconid($db, $id);
perbyconid($db, $id);
if ($ml_notify) {
$msg = "insert contact person \"{$firstname_per} {$lastname_per}\" of contact (ID: {$id}) by " . $auth->auth["uname"] . ".";
mailuser("admin", "insert contact person", $msg);
}
} else {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
}
// If contact is not in table
} else {
$be->box_full($t->translate("Error"), $t->translate("Contact") . " (ID: {$id}) " . $t->translate("does not exist") . ".");
}
<?php
/* $Id: tbl_select.php,v 1.17 2001/08/29 12:00:07 loic1 Exp $ */
/**
* Gets some core libraries
*/
require './grab_globals.inc.php';
require './lib.inc.php';
/**
* Not selection yet required -> displays the selection form
*/
if (!isset($param) || $param[0] == '') {
include './header.inc.php';
$result = @mysql_list_fields($db, $table);
if (!$result) {
mysql_die('', 'mysql_list_fields(' . $db . ', ' . $table . ')');
} else {
// Gets the list and number of fields
$fields_count = mysql_num_fields($result);
for ($i = 0; $i < $fields_count; $i++) {
$fields_list[] = mysql_field_name($result, $i);
$fields_type[] = mysql_field_type($result, $i);
$fields_len[] = mysql_field_len($result, $i);
}
?>
<form method="post" action="tbl_select.php">
<input type="hidden" name="server" value="<?php
echo $server;
?>
" />
<input type="hidden" name="lang" value="<?php
$sql_query .= "\n" . 'ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD INDEX (' . $index . ')';
$result = mysql_query('ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD INDEX (' . $index . ')') or mysql_die();
}
}
// end if
// Builds the uniques statements and updates the table
$unique = '';
if (isset($field_unique)) {
for ($i = 0; $i < count($field_unique); $i++) {
$j = $field_unique[$i];
$unique .= backquote($field_name[$j]) . ', ';
}
// end for
$unique = ereg_replace(', $', '', $unique);
if (!empty($unique)) {
$sql_query .= "\n" . 'ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD UNIQUE (' . $unique . ')';
$result = mysql_query('ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD UNIQUE (' . $unique . ')') or mysql_die();
}
}
// end if
// Go back to table properties
$message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenAltered;
include './tbl_properties.php';
exit;
} else {
$action = 'tbl_addfield.php';
include './tbl_properties.inc.php';
// Diplays the footer
echo "\n";
include './footer.inc.php';
}
function dbn($string)
{
global $database_link;
mysql_query($string, $database_link) or mysql_die($string);
}
/** Runs '$query' and returns the first (arbitrarily) found row.
*/
function GetRowByQuery($query)
{
$QueryResult = mysql_query($query) or mysql_die($query);
$Result = mysql_fetch_array($QueryResult);
return $Result;
}
// Adds table type (2 May 2001 - Robbat2)
if (!empty($tbl_type) && $tbl_type != 'Default') {
$sql_query .= ' TYPE = ' . $tbl_type;
}
if (MYSQL_INT_VERSION >= 32300 && !empty($comment)) {
$sql_query .= ' comment = \'' . sql_addslashes($comment) . '\'';
}
// Executes the query
$result = mysql_query($sql_query) or mysql_die();
$message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenCreated;
include './tbl_properties.php';
exit;
} else {
if (isset($num_fields)) {
$num_fields = intval($num_fields);
}
// No table name
if (!isset($table) || trim($table) == '') {
mysql_die($strTableEmpty);
} else {
if (empty($num_fields) || !is_int($num_fields)) {
mysql_die($strFieldsEmpty);
} else {
$action = 'tbl_create.php';
include './tbl_properties.inc.php';
// Diplays the footer
echo "\n";
include './footer.inc.php';
}
}
}
function get_table_def($db, $table, $crlf)
{
$schema_create = "";
//$schema_create .= "DROP TABLE IF EXISTS $table;$crlf";
$schema_create .= "CREATE TABLE {$table} ({$crlf}";
$result = mysql_db_query($db, "SHOW FIELDS FROM {$table}") or mysql_die();
while ($row = mysqli_fetch_array($result)) {
$schema_create .= " {$row['Field']} {$row['Type']}";
if (isset($row["Default"]) && (!empty($row["Default"]) || $row["Default"] == "0")) {
$schema_create .= " DEFAULT '{$row['Default']}'";
}
if ($row["Null"] != "YES") {
$schema_create .= " NOT NULL";
}
if ($row["Extra"] != "") {
$schema_create .= " {$row['Extra']}";
}
$schema_create .= ",{$crlf}";
}
$schema_create = ereg_replace("," . $crlf . "\$", "", $schema_create);
$result = mysql_db_query($db, "SHOW KEYS FROM {$table}") or mysql_die();
while ($row = mysqli_fetch_array($result)) {
$kname = $row['Key_name'];
if ($kname != "PRIMARY" && $row['Non_unique'] == 0) {
$kname = "UNIQUE|{$kname}";
}
if (!isset($index[$kname])) {
$index[$kname] = array();
}
$index[$kname][] = $row['Column_name'];
}
while (list($x, $columns) = @each($index)) {
$schema_create .= ",{$crlf}";
if ($x == "PRIMARY") {
$schema_create .= " PRIMARY KEY (" . implode($columns, ", ") . ")";
} elseif (substr($x, 0, 6) == "UNIQUE") {
$schema_create .= " UNIQUE " . substr($x, 7) . " (" . implode($columns, ", ") . ")";
} else {
$schema_create .= " KEY {$x} (" . implode($columns, ", ") . ")";
}
}
$schema_create .= "{$crlf})";
return stripslashes($schema_create);
}
function showRelated($foreign_table = false, $opts = false)
{
if (is_array($opts)) {
extract($opts);
}
if ($foreign_table) {
$sql = " SELECT * FROM {$foreign_table} WHERE {$this->_indexField} = {$this->id} ";
$result = mysql_db_query($this->_db, $sql) or mysql_die($sql);
if ($debug) {
echo "<hr><pre> {$sql} </pre><hr>";
}
if ($get_result) {
return $result;
}
// It would be nice to use the object here, and be able to customize with the $this->summary_link function.
if (class_exists($foreign_table)) {
while ($row = mysql_fetch_array($result)) {
$object = new $table($row[0]);
$object->summary_link();
}
} else {
// get the title field
$sql = "";
}
}
}
public function exists($id = '')
{
$idf = $this->_idField;
if ($id === '') {
$id = $this->getId();
}
// bail if a lookup would obviously fail
if (!$this->hasId()) {
return false;
}
$sql = "SELECT `{$this->_idField}` FROM `{$this->_table}` WHERE `{$this->_idField}` = '{$id}'";
$foundit = false;
if ($res = mysql_db_query($this->_db, $sql) or mysql_die($sql)) {
if (mysql_num_rows($res) == 1) {
$found_id = mysql_result($res, 0, 0);
if ($found_id == $id) {
$foundit = true;
}
}
mysql_free_result($res);
}
return $foundit;
}
if ($num_dbs) {
$true_dblist = array();
for ($i = 0; $i < $num_dbs; $i++) {
$dblink = @mysql_select_db($dblist[$i]);
if ($dblink) {
$true_dblist[] = $dblist[$i];
}
// end if
}
// end for
unset($dblist);
$dblist = $true_dblist;
unset($true_dblist);
$num_dbs = count($dblist);
} else {
$dbs = mysql_list_dbs() or mysql_die('', 'mysql_list_dbs()', FALSE, FALSE);
$num_dbs = @mysql_num_rows($dbs);
$real_num_dbs = 0;
for ($i = 0; $i < $num_dbs; $i++) {
$db_name_tmp = mysql_dbname($dbs, $i);
//echo $db_name_tmp."<br>";
if ($db_name_tmp != "test") {
$dblink = @mysql_select_db($db_name_tmp);
if ($dblink) {
$dblist[] = $db_name_tmp;
$real_num_dbs++;
}
}
}
// end for
$num_dbs = $real_num_dbs;
function get_table_content($src_table, $dest_table, $crlf, $escape, &$stream = null)
{
$out = '';
$table_list = '';
$result = mysql_query("SELECT * FROM {$src_table}") or mysql_die();
$i = 0;
$block_size = 100;
while ($row = mysql_fetch_row($result)) {
if (empty($table_list)) {
$table_list = "(";
for ($j = 0; $j < mysql_num_fields($result); $j++) {
$table_list .= $escape . mysql_field_name($result, $j) . $escape . ", ";
}
$table_list = substr($table_list, 0, -2);
$table_list .= ")";
}
if ($i % $block_size == 0) {
$schema_insert = ';' . $crlf . 'INSERT INTO ' . $escape . $dest_table . $escape . ' ' . $table_list . ' VALUES' . $crlf . '(';
} else {
$schema_insert = ",{$crlf}(";
}
for ($j = 0; $j < mysql_num_fields($result); $j++) {
if (!isset($row[$j])) {
$schema_insert .= " NULL,";
} elseif ($row[$j] != "") {
$schema_insert .= " '" . mysql_real_escape_string($row[$j]) . "',";
} else {
$schema_insert .= " '',";
}
}
$schema_insert = ereg_replace(",\$", "", $schema_insert);
$schema_insert .= ")";
if (!empty($stream)) {
fputs($stream, $schema_insert);
} else {
$out .= $schema_insert;
}
$i++;
}
if (!empty($stream)) {
return true;
}
return $out . ';' . $crlf;
}
/**
* Outputs the content of a table in CSV format
*
* Last revision 14 July 2001: Patch for limiting dump size from
* vinay@sanisoft.com & girish@sanisoft.com
*
* @param string the database name
* @param string the table name
* @param integer the offset on this table
* @param integer the last row to get
* @param string the field separator character
* @param string the optionnal "enclosed by" character
* @param string the handler (function) to call. It must accept one
* parameter ($sql_insert)
*
* @global string whether to obtain an excel compatible csv format or a
* simple csv one
*
* @return boolean always true
*/
function get_table_csv($db, $table, $limit_from = 0, $limit_to = 0, $sep, $enc_by, $esc_by, $handler)
{
global $what;
// Handles the "separator" and the optionnal "enclosed by" characters
if (empty($sep) || $what == 'excel') {
$sep = ';';
} else {
if (get_magic_quotes_gpc()) {
$sep = stripslashes($sep);
}
$sep = str_replace('\\t', "\t", $sep);
}
if (empty($enc_by) || $what == 'excel') {
$enc_by = '"';
} else {
if (get_magic_quotes_gpc()) {
$enc_by = stripslashes($enc_by);
}
$enc_by = str_replace('"', '"', $enc_by);
}
if (empty($esc_by) || $what == 'excel') {
// double the "enclosed by" character
$esc_by = $enc_by;
} else {
if (get_magic_quotes_gpc()) {
$esc_by = stripslashes($esc_by);
}
}
// Defines the offsets to use
if ($limit_from > 0) {
$limit_from--;
} else {
$limit_from = 0;
}
if ($limit_to > 0 && $limit_from >= 0) {
$add_query = " LIMIT {$limit_from}, {$limit_to}";
} else {
$add_query = '';
}
// Gets the data from the database
$local_query = 'SELECT * FROM ' . backquote($db) . '.' . backquote($table) . $add_query;
$result = mysql_query($local_query) or mysql_die('', $local_query);
// Format the data
$i = 0;
while ($row = mysql_fetch_row($result)) {
@set_time_limit(60);
$schema_insert = '';
$fields_cnt = mysql_num_fields($result);
for ($j = 0; $j < $fields_cnt; $j++) {
if (!isset($row[$j])) {
$schema_insert .= 'NULL';
} else {
if ($row[$j] != '') {
// loic1 : always enclose fields
if ($what == 'excel') {
$row[$j] = ereg_replace("\r(\n)?", "\n", $row[$j]);
}
$schema_insert .= $enc_by . str_replace($enc_by, $esc_by . $enc_by, $row[$j]) . $enc_by;
} else {
$schema_insert .= '';
}
}
if ($j < $fields_cnt - 1) {
$schema_insert .= $sep;
}
}
// end for
$handler(trim($schema_insert));
++$i;
}
// end while
return TRUE;
}
// this case)
if ($is_delete && eregi('^DELETE( .+)?( FROM (.+))$', $sql_query, $parts) && !eregi(' WHERE ', $parts[3])) {
$OPresult = @mysql_query('SELECT COUNT(*) as count' . $parts[2]);
if ($OPresult) {
$num_rows = mysql_result($OPresult, 0, 'count');
} else {
$num_rows = 0;
}
}
// Executes the query
$result = @mysql_query($full_sql_query);
// Displays an error message if required and stop parsing the script
if (mysql_error()) {
$error = mysql_error();
include './header.inc.php';
mysql_die($error, $full_sql_query);
}
// Gets the number of rows affected/returned
if (!$is_affected) {
$num_rows = @mysql_num_rows($result);
} else {
if (!isset($num_rows)) {
$num_rows = @mysql_affected_rows();
}
}
// Counts the total number of rows for the same 'SELECT' query without the
// 'LIMIT' clause that may have been programatically added
if (empty($sql_limit_to_append)) {
$SelectNumRows = $num_rows;
} else {
if ($is_select) {
<?php
/* $Id: tbl_rename.php,v 1.7 2001/08/22 20:42:51 loic1 Exp $ */
/**
* Gets some core libraries
*/
require './grab_globals.inc.php';
require './lib.inc.php';
/**
* A new name has been submitted -> do the work
*/
if (isset($new_name) && trim($new_name) != '') {
$old_name = $table;
$table = $new_name;
include './header.inc.php';
mysql_select_db($db);
$local_query = 'ALTER TABLE ' . backquote($old_name) . ' RENAME ' . backquote($new_name);
$result = mysql_query($local_query) or mysql_die('', $local_query);
$message = sprintf($strRenameTableOK, $old_name, $table);
$reload = 'true';
} else {
include './header.inc.php';
mysql_die($strTableEmpty);
}
/**
* Back to the calling script
*/
require './tbl_properties.php';
#delta bomb
#clear all shields on all ships before we start.
db("select s.ship_id from {$db_name}_ships s, {$db_name}_users u where s.location = '{$user['location']}' && u.login_id\t!= 1 && s.ship_id > 1 && s.login_id = u.login_id && u.turns_run > '{$turns_safe}'");
while ($target_ship = dbr(1)) {
dbn("update {$db_name}_ships set shields = 0 where ship_id = '{$target_ship['ship_id']}'");
}
$target_ship = "";
$bomb_damage = 5000;
}
if ($star['event_random'] == 2) {
$bomb_damage *= 3;
}
$ship_counter = 0;
$dam_victim = array();
$destroyed_ships = 0;
$lastresort = mysql_query("select s.fighters,s.shields,s.ship_id,s.metal,s.fuel,s.location,s.login_id,s.class_name,s.ship_name,s.point_value,u.login_name from {$db_name}_ships s,{$db_name}_users u where s.location = '{$user['location']}' && s.ship_id > '1' && s.login_id >'1' && s.login_id = u.login_id && u.turns_run >= '{$turns_safe}'") or mysql_die("Bombs are messed up.");
$elim = 0;
#loop through players to damage.
while ($target_ship = mysql_fetch_array($lastresort)) {
#db("select login_name,login_id,ship_id from ${db_name}_users where login_id = '$target_ship[login_id]'");
#$target = dbr();
$ship_counter++;
$temp121 = 0;
$temp121 = damage_ship($bomb_damage, 0, 0, $user, $target_ship, $target_ship);
#Used to limit messages sent, so each player only gets 1 message.
$dam_victim[$target_ship['login_id']] .= "\n<br /><b class='b1'>{$target_ship['ship_name']}</b> ({$target_ship['class_name']})";
if ($temp121 > 0) {
$dam_victim[$target_ship['login_id']] .= $st[1085];
$elim++;
}
}
if (!empty($db)) {
$db_start = $db;
}
// loic1: lib.inc.php will be loaded by header.inc.php
//require('./lib.inc.php');
require './header.inc.php';
/**
* Get the list and number of available databases.
* Skipped if no server selected: in this case no database should be displayed
* before the user choose among available ones at the welcome screen.
*/
if ($server > 0) {
//<
// Get the valid databases list
$num_dbs = count($dblist);
$dbs = @mysql_list_dbs() or mysql_die('', 'mysql_list_dbs()');
while ($a_db = mysql_fetch_object($dbs)) {
if (!$num_dbs) {
$dblist[] = $a_db->Database;
//<
} else {
$true_dblist[$a_db->Database] = '';
//<
}
}
if ($num_dbs && empty($true_dblist)) {
$dblist = array();
} else {
if ($num_dbs) {
for ($i = 0; $i < $num_dbs; $i++) {
if (isset($true_dblist[$dblist[$i]])) {
$rs_usr = mysql_query($local_query, $stdlink) or mysql_die('', $local_query, FALSE);
$result_usr = mysql_fetch_array($rs_usr);
$create = $result_usr['Create_priv'] == 'Y';
$db_to_create = '';
// Does user have Create priv on a inexistant db?
// if yes, show him in the dialog the first inexistant db name that we
// find, in most cases it's probably the one he just dropped :)
// (Note: we only get here after a browser reload, I don't know why)
if (!$create) {
$userlink = @mysql_connect($cfgServer['host'] . $server_port . $server_socket, $cfgServer['user'], $cfgServer['password']);
if ($userlink == FALSE) {
$local_query = 'mysql_connect(' . $cfgServer['host'] . $server_port . $server_socket . ', ' . $cfgServer['user'] . ', ' . $cfgServer['password'] . ')';
mysql_die('', $local_query, FALSE, FALSE);
}
$local_query = 'SELECT Db FROM mysql.db WHERE User = \'' . sql_addslashes($cfgServer['user']) . '\'';
$rs_usr = mysql_query($local_query, $stdlink) or mysql_die('', $local_query, FALSE);
while ($row = mysql_fetch_array($rs_usr)) {
if (!mysql_select_db($row['Db'], $userlink)) {
$db_to_create = $row['Db'];
$create = TRUE;
break;
}
}
}
// The user is allowed to create a db '
if ($create) {
echo "\n";
?>
<!-- db creation form -->
<tr>
<td valign="baseline"><img src="images/item.gif" width="7" height="7" alt="item" /></td>
function db_m($string)
{
global $db_maint_func_query, $database_link;
$db_maint_func_query = mysql_query($string, $database_link) or mysql_die($string);
}
$set = "category='{$new_category}'";
$where = "type='{$type}' AND category='{$category}'";
if (!$dbcat->query("UPDATE {$tables} SET {$set} WHERE {$where}")) {
mysql_die($dbcat);
} else {
$bx->box_full($t->translate("Administration"), $t->translate("Category") . " {$category} " . $t->translate("has been renamed to") . " {$new_category}");
}
}
break;
case "del":
if ($dbcat->num_rows() < 1) {
$be->box_full($t->translate("Error"), $t->translate("Category") . " {$category} " . $t->translate("does not exist"));
} else {
$where = "type='{$type}' AND category='{$category}'";
if (!$dbcat->query("DELETE FROM {$tables} WHERE {$where}")) {
mysql_die($dbcat);
} else {
$bx->box_full($t->translate("Administration"), $t->translate("Category") . " {$category} " . $t->translate("has been deleted"));
}
}
break;
default:
}
}
} else {
$be->box_full($t->translate("Error"), $t->translate("Parameter missing"));
}
} else {
$be->box_full($t->translate("Error"), $t->translate("Access denied"));
}
?>
/**
* Checks whether the current user is a super-user or not
*
* @return boolean true as soon as the current user is super-user, no return
* else
*
* @access private
*/
function check_rights()
{
$result = @mysql_query('USE mysql');
if (mysql_error()) {
mysql_die($GLOBALS['strNoRights']);
}
return true;
}
$show_comment = '';
}
}
// 2. Get table keys and retains them
$local_query = 'SHOW KEYS FROM ' . backquote($table);
$result = mysql_query($local_query) or mysql_die('', $local_query);
$primary = '';
while ($row = mysql_fetch_array($result)) {
$ret_keys[] = $row;
if ($row['Key_name'] == 'PRIMARY') {
$primary .= $row['Column_name'] . ', ';
}
}
// 3. Get fields
$local_query = 'SHOW FIELDS FROM ' . backquote($table);
$result = mysql_query($local_query) or mysql_die('', $local_query);
/**
* Displays the table structure ('show table' works correct since 3.23.03)
*/
?>
<!-- TABLE INFORMATIONS -->
<table border="<?php
echo $cfgBorder;
?>
">
<tr>
<th><?php
echo ucfirst($strField);
// Move uploaded logo to logo directory
if (!empty($logo_name)) {
$to = $sys_logo_dir . $db->f("entid") . "ent_" . basename($logo_name);
if (!copy($logo, $to)) {
$be->box_full($t->translate("Error"), $t->translate("Unable to copy logofile to logo directory"));
}
if (!chmod($to, 0666)) {
$be->box_full($t->translate("Error"), $t->translate("Unable to change logofile mode"));
}
}
// Insert new counters
$dbcnt = new DB_SourceBiz();
$tables = "counter";
$set = "entid=" . $db->f("entid");
if (!$dbcnt->query("INSERT {$tables} SET {$set}")) {
mysql_die($dbcnt);
} else {
// Select and show new enterprise with counters
entbyentid($db, $db->f("entid"));
if ($ml_notify) {
$msg = "insert enterprise {$name} by " . $auth->auth["uname"] . ".";
mailuser("admin", "insert enterprise", $msg);
}
}
}
}
}
}
} else {
$be->box_full($t->translate("Error"), $t->translate("No Short Profile specified"));
}
<?php
/* $Id: db_create.php,v 1.8 2001/08/22 20:42:51 loic1 Exp $ */
/**
* Gets some core libraries
*/
require './grab_globals.inc.php';
require './header.inc.php';
/**
* Executes the db creation sql query
*/
$local_query = 'CREATE DATABASE ' . backquote($db);
$result = mysql_query('CREATE DATABASE ' . backquote($db)) or mysql_die('', $local_query, FALSE);
/**
* Displays the result and moves back to the calling page
*/
$message = $strDatabase . ' ' . htmlspecialchars($db) . ' ' . $strHasBeenCreated;
require './db_details.php';
<?php
header("Content-type: text/xml");
print "<?xml version='1.0' encoding=\"ISO-8859-1\" ?>\r\n<main>\n";
$login_id = $_GET['login_id'];
$game = $_GET['game'];
if ($login_id && $login_id != 'undefined' && $game) {
include "games/config.dat.php";
include "includes/{$game}" . "_vars.inc.php";
$midx = $GAME_VARS['uv_size_x_width'] / 2;
$midy = $GAME_VARS['uv_size_y_height'] / 2;
$database_link = @mysql_connect(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD) or write_to_error_log("No connection to the Database could be created.<p />The following error was reported:<br /><b>" . mysql_error() . "</b>");
mysql_select_db(DATABASE, $database_link) or mysql_die("");
$resultat = mysql_query("select explored_sys, location from {$game}" . "_users where login_id={$login_id}");
$user = mysql_fetch_array($resultat);
$etoiles = explode(',', $user['explored_sys']);
foreach ($etoiles as $etoile) {
$resultat2 = mysql_query("select * from {$game}" . "_stars where star_id={$etoile}");
$origine = mysql_fetch_array($resultat2);
for ($i = 1; $i <= 7; $i++) {
$type_lien = '';
if ($origine['link_' . $i]) {
// lien normal
$resultat3 = mysql_query("select * from {$game}" . "_stars where star_id=" . $origine['link_' . $i]);
$destination = mysql_fetch_array($resultat3);
$type_lien = "normal";
} elseif ($i == 7 && $origine['wormhole']) {
// lien wormhole
$resultat3 = mysql_query("select * from {$game}" . "_stars where star_id=" . $origine['wormhole']);
$destination = mysql_fetch_array($resultat3);
if ($origine['star_id'] == $destination['wormhole']) {
$valuelist = ereg_replace(', $', '', $valuelist);
$query = 'INSERT INTO ' . backquote($table) . ' (' . $fieldlist . ') VALUES (' . $valuelist . ')';
$message = $strInsertedRows . ' ';
}
// end row insertion
/**
* Executes the sql query and get the result, then move back to the calling
* page
*/
mysql_select_db($db);
$sql_query = $query;
$result = mysql_query($query);
if (!$result) {
$error = mysql_error();
include './header.inc.php';
mysql_die($error);
} else {
if (file_exists('./' . $goto)) {
if ($goto == 'db_details.php' && !empty($table)) {
unset($table);
}
include './header.inc.php';
if (@mysql_affected_rows()) {
$message .= @mysql_affected_rows();
} else {
$message = $strModifications;
}
include './' . ereg_replace('\\.\\.*', '.', $goto);
} else {
//header('Location: ' . $cfgPmaAbsoluteUri . $goto);
}
}
}
if (!isset($reload) && eregi('^(DROP|CREATE)[[:space:]]+(IF EXISTS[[:space:]]+)?(TABLE|DATABASE)[[:space:]]+(.+)', $a_sql_query)) {
$reload = 'true';
}
}
// end for
}
}
// end else if
}
// end if
/**
* Go back to the calling script
*/
require './header.inc.php';
if (isset($my_die)) {
mysql_die('', $my_die);
}
// Be nice with bandwidth...
if ($sql_file != 'none' && $pieces_count > 10) {
$sql_query = '';
unset($sql_query_cpy);
$message = "{$strSuccess} :<br />{$strTheContent} ({$pieces_count} {$strInstructions}) ";
} else {
$message = $strSuccess;
}
if (!isset($goto) || $goto != 'db_details.php' && $goto != 'tbl_properties.php') {
$goto = 'db_details.php';
}
require './' . $goto;
