Small update

[idb/iDB.git.git] / inc / admin / sqldumper / mysql.php

diff --git a/inc/admin/sqldumper/mysql.php b/inc/admin/sqldumper/mysql.php
index 2affcbb..6bca7bb 100644 (file)
--- a/inc/admin/sqldumper/mysql.php
+++ b/inc/admin/sqldumper/mysql.php
@@ -8,10 +8,10 @@
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     Revised BSD License for more details.
 
-    Copyright 2004-2012 iDB Support - http://idb.berlios.de/
-    Copyright 2004-2012 Game Maker 2k - http://gamemaker2k.org/
+    Copyright 2004-2022 iDB Support - https://idb.osdn.jp/support/category.php?act=view&id=1
+    Copyright 2004-2022 Game Maker 2k - https://idb.osdn.jp/support/category.php?act=view&id=2
 
-    $FileInfo: mysql.php - Last Update: 12/30/2011 SVN 781 - Author: cooldude2k $
+    $FileInfo: mysql.php - Last Update: 4/9/2022 SVN 959 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="mysql.php"||$File3Name=="/mysql.php") {
@@ -80,7 +80,7 @@ if(!isset($AltSQLDumper)||$AltSQLDumper===null) {
        $SQLDumper = "SQL Dumper"; }
 if(isset($AltSQLDumper)&&$AltSQLDumper!==null) {
        $SQLDumper = $AltSQLDumper; }
-function GetAllRows($table) { $rene_j = 0; $trowout = null;
+function GetAllRows($table) { $rene_j = 0; $trowout = array();
 global $SQLStat;
 $tresult = sql_query("SELECT * FROM \"".$table."\"",$SQLStat);
 while ($trow = sql_fetch_assoc($tresult)) {
@@ -92,7 +92,7 @@ $TablePreFix = $Settings['sqltable'];
 function add_prefix($tarray) {
 global $TablePreFix;
 return $TablePreFix.$tarray; }
-$TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "themes", "topics", "wordfilter");
+$TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "levels", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "themes", "topics", "wordfilter");
 $TableChCk = array_map("add_prefix",$TableChCk);
 if(!isset($_GET['outtype'])||$_GET['outtype']=="UTF-8") {
 header("Content-Type: text/plain; charset=UTF-8"); }
@@ -106,7 +106,7 @@ if (!$result) {
 echo "DB Error, could not list tables\n";
 echo 'MySQL Error: ' . sql_error($SQLStat);
 exit; }
-$DropTable = null; $CreateTable = null; $TableNames = null; $l = 0;
+$DropTable = null; $CreateTable = null; $TableNames = array(null); $l = 0;
 while ($row = sql_fetch_row($result)) { 
 if(in_array($row[0],$TableChCk)) {
 $TableNames[$l] = $row[0];
@@ -152,13 +152,13 @@ if (!$result2) {
 sql_free_result($result2);
 sql_free_result($tabsta);
 ++$l; } $tableout = null;
-$num = count($TableNames); $renee_s = 0;
+$num = count($TableNames); $melanie_p = 0;
 $sqldump = "-- ".$OrgName." ".$SQLDumper."\n";
 $sqldump .= "-- version ".$VerInfo['iDB_Ver_SVN']."\n";
 $sqldump .= "-- ".$iDBHome."support/\n";
 $sqldump .= "--\n";
 $sqldump .= "-- Host: ".$Settings['sqlhost']."\n";
-$sqldump .= "-- Generation Time: ".GMTimeGet('F d, Y \a\t h:i A',$_SESSION['UserTimeZone'],0,$_SESSION['UserDST'])."\n";
+$sqldump .= "-- Generation Time: ".$usercurtime->format('F d, Y \a\t h:i A')."\n";
 $sqldump .= "-- Server version: ".sql_server_info($SQLStat)."\n";
 $sqldump .= "-- PHP Version: ".phpversion()."\n\n";
 $sqldump .= "SET SESSION SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO';\n\n";
@@ -166,13 +166,13 @@ $sqldump .= "--\n";
 $sqldump .= "-- Database: \"".$Settings['sqldb']."\"\n";
 $sqldump .= "--\n\n";
 $sqldump .= "-- --------------------------------------------------------\n\n";
-while ($renee_s < $num) { $tnum = $num - 1;
-$trow = GetAllRows($TableNames[$renee_s]);
+while ($melanie_p < $num) { $tnum = $num - 1;
+$trow = GetAllRows($TableNames[$melanie_p]);
 $numz = count($trow); $kazuki_p = 0;
 $sqldump .= "--\n";
-$sqldump .= "-- Table structure for table \"".$TableNames[$renee_s]."\"\n";
+$sqldump .= "-- Table structure for table \"".$TableNames[$melanie_p]."\"\n";
 $sqldump .= "--\n\n";
-$sqldump .= $FullTable[$renee_s]."\n";
+$sqldump .= $FullTable[$melanie_p]."\n";
 while ($kazuki_p < $numz) { $tnumz = $numz - 1;
 $srow = null; $srowvalue = null;
 $trownew = $trow[$kazuki_p];
@@ -185,7 +185,7 @@ if($_GET['outtype']=="UTF-8"&&$Settings['charset']!="UTF-8") {
 $trowrvalue = utf8_encode($trowrvalue); }
 $trowrvalue = str_replace( array("\n", "\r"), array('\n', '\r'), $trowrvalue);
 /*if($kazuki_p===0) {*/
-if($il===0) { $srow = "INSERT INTO \"".$TableNames[$renee_s]."\" ("; }
+if($il===0) { $srow = "INSERT INTO \"".$TableNames[$melanie_p]."\" ("; }
 if($il<$tnums&&$il!=$tnums) { $srow .= "\"".$trowrname."\", "; }
 if($il==$tnums) { $srow .= "\"".$trowrname."\") VALUES"; } /*}*/
 if($il===0) { $srowvalue = "("; }
@@ -197,20 +197,20 @@ if($il==$tnums) { $srowvalue .= $trowrvalue;
 ++$il; }
 if($kazuki_p===0) {
 $sqldump .= "--\n";
-$sqldump .= "-- Dumping data for table \"".$TableNames[$renee_s]."\"\n";
+$sqldump .= "-- Dumping data for table \"".$TableNames[$melanie_p]."\"\n";
 $sqldump .= "--\n\n"; }
 $sqldump .= $srow."\n"; /*}*/
 $sqldump .= $srowvalue."\n";
-if($kazuki_p==$tnumz&&$renee_s<$tnum) {
+if($kazuki_p==$tnumz&&$melanie_p<$tnum) {
 $sqldump .= "\n-- --------------------------------------------------------\n"; }
 ++$kazuki_p; }
 if($numz===0) {
 $sqldump .= "--\n";
-$sqldump .= "-- Dumping data for table \"".$TableNames[$renee_s]."\"\n";
+$sqldump .= "-- Dumping data for table \"".$TableNames[$melanie_p]."\"\n";
 $sqldump .= "--\n\n";
 $sqldump .= "\n-- --------------------------------------------------------\n"; }
 $sqldump .= "\n";
-++$renee_s; }
+++$melanie_p; }
 if($_GET['compress']=="none") { echo $sqldump; }
 if($_GET['compress']=="gzencode") { echo gzencode($sqldump,$_GET['comlevel']); }
 if($_GET['compress']=="gzcompress") { echo gzcompress($sqldump,$_GET['comlevel']); }