From a03e51c59e6071c99cb191a75a49f7c7db7dce68 Mon Sep 17 00:00:00 2001 From: Kazuki Przyborowski Date: Fri, 15 Oct 2010 02:57:22 +0000 Subject: [PATCH] Yet Another small update. :) git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@588 2b68903e-0b30-0410-9a39-a2e4f3c5be39 --- inc/admin/sqldumper/mysql.php | 5 ++--- inc/misc/sql/mysql.php | 4 ++-- inc/misc/sql/mysqli.php | 4 ++-- inc/versioninfo.php | 6 +++--- 4 files changed, 9 insertions(+), 10 deletions(-) diff --git a/inc/admin/sqldumper/mysql.php b/inc/admin/sqldumper/mysql.php index 00c7047..97305e3 100644 --- a/inc/admin/sqldumper/mysql.php +++ b/inc/admin/sqldumper/mysql.php @@ -11,7 +11,7 @@ Copyright 2004-2010 iDB Support - http://idb.berlios.de/ Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: mysql.php - Last Update: 06/07/2010 SVN 520 - Author: cooldude2k $ + $FileInfo: mysql.php - Last Update: 10/14/2010 SVN 588 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="mysql.php"||$File3Name=="/mysql.php") { @@ -158,8 +158,7 @@ $sqldump .= "-- Host: ".$Settings['sqlhost']."\n"; $sqldump .= "-- Generation Time: ".GMTimeGet('F d, Y \a\t h:i A',$_SESSION['UserTimeZone'],0,$_SESSION['UserDST'])."\n"; $sqldump .= "-- Server version: ".sql_server_info($SQLStat)."\n"; $sqldump .= "-- PHP Version: ".phpversion()."\n\n"; -$sqldump .= "SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\n"; -$sqldump .= "SET SESSION SQL_MODE='ANSI_QUOTES';\n\n"; +$sqldump .= "SET SESSION SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO';\n\n"; $sqldump .= "--\n"; $sqldump .= "-- Database: \"".$Settings['sqldb']."\"\n"; $sqldump .= "--\n\n"; diff --git a/inc/misc/sql/mysql.php b/inc/misc/sql/mysql.php index 7f20ea8..cd162ce 100644 --- a/inc/misc/sql/mysql.php +++ b/inc/misc/sql/mysql.php @@ -11,7 +11,7 @@ Copyright 2004-2009 iDB Support - http://idb.berlios.de/ Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: mysql.php - Last Update: 12/17/2009 SVN 417 - Author: cooldude2k $ + $FileInfo: mysql.php - Last Update: 10/14/2010 SVN 588 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="mysql.php"||$File3Name=="/mysql.php") { @@ -82,7 +82,7 @@ $dlink = mysql_select_db($database,$link); if ($dlink===false) { output_error("Can't use database ".$database.": ".sql_error(),E_USER_ERROR); return false; } } -$result = sql_query("SET SESSION SQL_MODE='ANSI_QUOTES';",$link); +$result = sql_query("SET SESSION SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO';",$link); if ($result===false) { output_error("SQL Error: ".sql_error(),E_USER_ERROR); return false; } diff --git a/inc/misc/sql/mysqli.php b/inc/misc/sql/mysqli.php index f307558..c75a619 100644 --- a/inc/misc/sql/mysqli.php +++ b/inc/misc/sql/mysqli.php @@ -11,7 +11,7 @@ Copyright 2004-2010 iDB Support - http://idb.berlios.de/ Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: mysqli.php - Last Update: 05/28/2010 SVN 503 - Author: cooldude2k $ + $FileInfo: mysqli.php - Last Update: 10/14/2010 SVN 588 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="mysqli.php"||$File3Name=="/mysqli.php") { @@ -84,7 +84,7 @@ $link = mysqli_connect($server,$username,$password,$database,$myport); } if ($link===false) { output_error("MySQLi Error ".mysqli_connect_errno().": ".mysqli_connect_error(),E_USER_ERROR); return false; } -$result = sql_query("SET SESSION SQL_MODE='ANSI_QUOTES';",$link); +$result = sql_query("SET SESSION SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO';",$link); if ($result===false) { output_error("SQL Error: ".sql_error(),E_USER_ERROR); return false; } diff --git a/inc/versioninfo.php b/inc/versioninfo.php index 2e93394..2086266 100644 --- a/inc/versioninfo.php +++ b/inc/versioninfo.php @@ -11,7 +11,7 @@ Copyright 2004-2010 iDB Support - http://idb.berlios.de/ Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/ - $FileInfo: versioninfo.php - Last Update: 10/12/2010 SVN 587 - Author: cooldude2k $ + $FileInfo: versioninfo.php - Last Update: 10/14/2010 SVN 588 - Author: cooldude2k $ */ $File3Name = basename($_SERVER['SCRIPT_NAME']); if ($File3Name=="versioninfo.php"||$File3Name=="/versioninfo.php") { @@ -27,8 +27,8 @@ function version_info($proname,$subver,$ver,$supver,$reltype,$svnver,$showsvn) { return $return_var; } // Version number and date stuff. :P $VER1[0] = 0; $VER1[1] = 4; $VER1[2] = 2; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2]; -$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 587; $RName = "iDB"; $SFName = "IntDB"; -$SVNDay[0] = 10; $SVNDay[1] = 12; $SVNDay[2] = 2010; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; +$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 588; $RName = "iDB"; $SFName = "IntDB"; +$SVNDay[0] = 10; $SVNDay[1] = 14; $SVNDay[2] = 2010; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2]; $VerInfo['iDB_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,false); $VerInfo['iDB_Ver_SVN'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[1],$SubVerN,true); $VerInfo['iDB_Full_Ver'] = version_info($RName,$VER1[0],$VER1[1],$VER1[2],$VER2[0],$SubVerN,false); -- 2.11.0