From 10539a81bf31b48970d7244ac872b3ee694ed71e Mon Sep 17 00:00:00 2001
From: Kazuki Przyborowski <kazuki.przyborowski@gmail.com>
Date: Tue, 15 Dec 2009 07:52:08 +0000
Subject: [PATCH] Small change to SQLite Dumper.

git-svn-id: svn://svn.code.sf.net/p/intdb/svn/trunk@407 2b68903e-0b30-0410-9a39-a2e4f3c5be39
---
 inc/admin/sqldumper/sqlite.php | 12 ++++++++++--
 inc/versioninfo.php            |  6 +++---
 2 files changed, 13 insertions(+), 5 deletions(-)

diff --git a/inc/admin/sqldumper/sqlite.php b/inc/admin/sqldumper/sqlite.php
index 7b03dea..ea6995f 100644
--- a/inc/admin/sqldumper/sqlite.php
+++ b/inc/admin/sqldumper/sqlite.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: sqlite.php - Last Update: 12/14/2009 SVN 406 - Author: cooldude2k $
+    $FileInfo: sqlite.php - Last Update: 12/15/2009 SVN 407 - Author: cooldude2k $
 */
 $File3Name = basename($_SERVER['SCRIPT_NAME']);
 if ($File3Name=="sqlite.php"||$File3Name=="/sqlite.php") {
@@ -57,10 +57,17 @@ if($_GET['outtype']=="latin15") {
 header("Content-Type: text/plain; charset=ISO-8859-15"); }
 $sli = 0; $slnum = count($TableChCk);
 while ($sli < $slnum) {
+/*
 $FullTable[$sli] = "CREATE TABLE \"".$TableChCk[$sli]."\" (\n";
-$tabsta = sql_query("PRAGMA table_info(\"".$TableChCk[$sli]."\");",$SQLStat);
+*/
+$tabsta = sql_query("SELECT * FROM sqlite_master WHERE type=\"table\" and tbl_name=\"".$TableChCk[$sli]."\";",$SQLStat);
+$tabstats = sql_fetch_array($tabsta);
+$FullTable[$sli] = $tabstats['sql'];
+/*
 $zli = 0;
+$tabsta = sql_query("PRAGMA table_info(\"".$TableChCk[$sli]."\");",$SQLStat);
 while ($tabstats = sql_fetch_array($tabsta)) {
+var_dump($tabstats);
 if($zli>0) { $FullTable[$sli] .= ",\n"; }
 $SQLDefault = null; $PrimeKey = " ";
 if($tabstats['dflt_value']!==null) {
@@ -72,6 +79,7 @@ $PrimeKey = " PRIMARY KEY "; }
 $FullTable[$sli] .= "  \"".$tabstats['name']."\" ".$tabstats['type'].$PrimeKey."NOT NULL".$SQLDefault;
 ++$zli; }
 $FullTable[$sli] .= "\n);\n";
+*/
 ++$sli; }
 $TableNames = $TableChCk;
 $num = count($TableNames); $renee_s = 0;
diff --git a/inc/versioninfo.php b/inc/versioninfo.php
index f64dad8..6bac3c9 100644
--- a/inc/versioninfo.php
+++ b/inc/versioninfo.php
@@ -11,7 +11,7 @@
     Copyright 2004-2009 iDB Support - http://idb.berlios.de/
     Copyright 2004-2009 Game Maker 2k - http://gamemaker2k.org/
 
-    $FileInfo: versioninfo.php - Last Update: 12/14/2009 SVN 406 - Author: cooldude2k $
+    $FileInfo: versioninfo.php - Last Update: 12/15/2009 SVN 407 - 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] = 3; $VER1[2] = 4; $VERFull[1] = $VER1[0].".".$VER1[1].".".$VER1[2];
-$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 406; $RName = "iDB"; $SFName = "IntDB";
-$SVNDay[0] = 12; $SVNDay[1] = 14; $SVNDay[2] = 2009; $SVNDay[3] = $SVNDay[0]."/".$SVNDay[1]."/".$SVNDay[2];
+$VER2[0] = "Alpha"; $VER2[1] = "Al"; $VER2[2] = "SVN"; $SubVerN = 407; $RName = "iDB"; $SFName = "IntDB";
+$SVNDay[0] = 12; $SVNDay[1] = 15; $SVNDay[2] = 2009; $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