inc/admin/sqldumper/sqlite.php

   1 <?php
   2 /*
   3     This program is free software; you can redistribute it and/or modify
   4     it under the terms of the Revised BSD License.
   5
   6     This program is distributed in the hope that it will be useful,
   7     but WITHOUT ANY WARRANTY; without even the implied warranty of
   8     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   9     Revised BSD License for more details.
  10
  11     Copyright 2004-2019 iDB Support - https://idb.osdn.jp/support/category.php?act=view&id=1
  12     Copyright 2004-2019 Game Maker 2k - https://idb.osdn.jp/support/category.php?act=view&id=2
  13
  14     $FileInfo: sqlite.php - Last Update: 08/02/2019 SVN 905 - Author: cooldude2k $
  15 */
  16 $File3Name = basename($_SERVER['SCRIPT_NAME']);
  17 if ($File3Name=="sqlite.php"||$File3Name=="/sqlite.php") {
  18         require('index.php');
  19         exit(); }
  20
  21 if($_SESSION['UserGroup']==$Settings['GuestGroup']||$GroupInfo['HasAdminCP']=="no") {
  22 redirect("location",$rbasedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false));
  23 ob_clean(); header("Content-Type: text/plain; charset=".$Settings['charset']);
  24 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
  25 if($Settings['sqltype']!="sqlite"||$Settings['sqltype']!="sqlite3") {
  26 redirect("location",$rbasedir.url_maker($exfile['index'],$Settings['file_ext'],"act=view",$Settings['qstr'],$Settings['qsep'],$prexqstr['index'],$exqstr['index'],false));
  27 ob_clean(); header("Content-Type: text/plain; charset=".$Settings['charset']);
  28 gzip_page($Settings['use_gzip'],$GZipEncode['Type']); session_write_close(); die(); }
  29 if(!isset($_GET['outtype'])) { $_GET['outtype'] = "UTF-8"; }
  30 header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
  31 header("Cache-Control: private",false);
  32 header("Content-Description: File Transfer");
  33 if(!isset($_GET['comlevel'])) {
  34         $_GET['comlevel'] = -1; }
  35 if(!is_numeric($_GET['comlevel'])) {
  36         $_GET['comlevel'] = -1; }
  37 if($_GET['comlevel']>9||$_GET['comlevel']<-1) {
  38         $_GET['comlevel'] = -1; }
  39 if(!isset($_GET['compress'])) {
  40         $_GET['compress'] = "none"; }
  41 if($_GET['compress']=="gzip") {
  42         $_GET['compress'] = "gzencode"; }
  43 if($_GET['compress']=="bzip"||
  44         $_GET['compress']=="bzip2") {
  45         $_GET['compress'] = "bzcompress"; }
  46 if($_GET['compress']!="none"&&
  47         $_GET['compress']!="gzencode"&&
  48         $_GET['compress']!="gzcompress"&&
  49         $_GET['compress']!="gzdeflate"&&
  50         $_GET['compress']!="bzcompress") {
  51         $_GET['compress'] = "none"; }
  52 if(!extension_loaded("zlib")) {
  53 if($_GET['compress']=="gzencode"&&
  54         $_GET['compress']=="gzcompress"&&
  55         $_GET['compress']=="gzdeflate") {
  56         $_GET['compress'] = "none"; } }
  57 if(!extension_loaded("bz2")) {
  58 if($_GET['compress']=="bzcompress") {
  59         $_GET['compress'] = "none"; } }
  60 if($_GET['compress']=="bzcompress") {
  61 if($_GET['comlevel']>9||$_GET['comlevel']<0) {
  62         $_GET['comlevel'] = 4; } }
  63 $fname = null;
  64 if(isset($Settings['sqldb'])&&$Settings['sqldb']!="") {
  65 $fname = str_replace("_","", $Settings['sqldb'])."_"; }
  66 if($_GET['compress']=="none") {
  67 $fname .= str_replace("_","", $Settings['sqltable']).".sql"; }
  68 if($_GET['compress']=="gzencode") {
  69 $fname .= str_replace("_","", $Settings['sqltable']).".sql.gz"; }
  70 if($_GET['compress']=="gzcompress") {
  71 $fname .= str_replace("_","", $Settings['sqltable']).".sql.gz"; }
  72 if($_GET['compress']=="gzdeflate") {
  73 $fname .= str_replace("_","", $Settings['sqltable']).".sql.gz"; }
  74 if($_GET['compress']=="bzcompress") {
  75 $fname .= str_replace("_","", $Settings['sqltable']).".sql.bz2"; }
  76 header("Content-Disposition: attachment; filename=".$fname);
  77 header("Content-Type: application/octet-stream");
  78 header("Content-Transfer-Encoding: binary");
  79 if(!isset($AltSQLDumper)||$AltSQLDumper===null) {
  80         $SQLDumper = "SQL Dumper"; }
  81 if(isset($AltSQLDumper)&&$AltSQLDumper!==null) {
  82         $SQLDumper = $AltSQLDumper; }
  83 function GetAllRows($table) { $rene_j = 0; $trowout = null;
  84 global $SQLStat;
  85 $tresult = sql_query("SELECT * FROM \"".$table."\"",$SQLStat);
  86 while ($trow = sql_fetch_assoc($tresult)) {
  87 $trowout[$rene_j] = $trow;
  88 ++$rene_j; }
  89 sql_free_result($tresult);
  90 return $trowout; }
  91 $TablePreFix = $Settings['sqltable'];
  92 function add_prefix($tarray) {
  93 global $TablePreFix;
  94 return $TablePreFix.$tarray; }
  95 $TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "levels", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "themes", "topics", "wordfilter");
  96 $TableChCk = array_map("add_prefix",$TableChCk);
  97 if(!isset($_GET['outtype'])||$_GET['outtype']=="UTF-8") {
  98 header("Content-Type: text/plain; charset=UTF-8"); }
  99 if($_GET['outtype']=="latin1") {
 100 header("Content-Type: text/plain; charset=ISO-8859-15"); }
 101 if($_GET['outtype']=="latin15") {
 102 header("Content-Type: text/plain; charset=ISO-8859-15"); }
 103 $sli = 0; $slnum = count($TableChCk);
 104 while ($sli < $slnum) {
 105 /*
 106 $FullTable[$sli] = "CREATE TABLE \"".$TableChCk[$sli]."\" (\n";
 107 */
 108 $tabsta = sql_query("SELECT * FROM sqlite_master WHERE type=\"table\" and tbl_name=\"".$TableChCk[$sli]."\";",$SQLStat);
 109 $tabstats = sql_fetch_array($tabsta);
 110 $FullTable[$sli] = $tabstats['sql'].";\n";
 111 /*
 112 $zli = 0;
 113 $tabsta = sql_query("PRAGMA table_info(\"".$TableChCk[$sli]."\");",$SQLStat);
 114 while ($tabstats = sql_fetch_array($tabsta)) {
 115 var_dump($tabstats);
 116 if($zli>0) { $FullTable[$sli] .= ",\n"; }
 117 $SQLDefault = null; $PrimeKey = " ";
 118 if($tabstats['dflt_value']!==null) {
 119 $SQLDefault = " default '".$tabstats['dflt_value']."'"; }
 120 if($tabstats['dflt_value']===null) {
 121 $SQLDefault = ""; }
 122 if($tabstats['pk']=="1") {
 123 $PrimeKey = " PRIMARY KEY "; }
 124 $FullTable[$sli] .= "  \"".$tabstats['name']."\" ".$tabstats['type'].$PrimeKey."NOT NULL".$SQLDefault;
 125 ++$zli; }
 126 $FullTable[$sli] .= "\n);\n";
 127 */
 128 ++$sli; }
 129 $TableNames = $TableChCk;
 130 $num = count($TableNames); $melanie_p = 0;
 131 $sqldump = "-- ".$OrgName." ".$SQLDumper."\n";
 132 $sqldump .= "-- version ".$VerInfo['iDB_Ver_SVN']."\n";
 133 $sqldump .= "-- ".$iDBHome."support/\n";
 134 $sqldump .= "--\n";
 135 $sqldump .= "-- Generation Time: ".$usercurtime->format('F d, Y \a\t h:i A')."\n";
 136 $sqldump .= "-- SQLite Server version: ".sql_server_info($SQLStat)."\n";
 137 $sqldump .= "-- PHP Version: ".phpversion()."\n\n";
 138 $sqldump .= "--\n";
 139 $sqldump .= "-- Database: \"".$Settings['sqldb']."\"\n";
 140 $sqldump .= "--\n\n";
 141 $sqldump .= "-- --------------------------------------------------------\n\n";
 142 while ($melanie_p < $num) { $tnum = $num - 1;
 143 $trow = GetAllRows($TableNames[$melanie_p]);
 144 $numz = count($trow); $kazuki_p = 0;
 145 $sqldump .= "--\n";
 146 $sqldump .= "-- Table structure for table \"".$TableNames[$melanie_p]."\"\n";
 147 $sqldump .= "--\n\n";
 148 $sqldump .= $FullTable[$melanie_p]."\n";
 149 while ($kazuki_p < $numz) { $tnumz = $numz - 1;
 150 $srow = null; $srowvalue = null;
 151 $trownew = $trow[$kazuki_p];
 152 $trowname = array_keys($trownew);
 153 $nums = count($trownew); $il = 0;
 154 while ($il < $nums) { $tnums = $nums - 1;
 155 $trowrname = sql_escape_string($trowname[$il],$SQLStat);
 156 $trowrvalue = sql_escape_string($trownew[$trowrname],$SQLStat);
 157 if($_GET['outtype']=="UTF-8"&&$Settings['charset']!="UTF-8") {
 158 $trowrvalue = utf8_encode($trowrvalue); }
 159 $trowrvalue = str_replace( array("\n", "\r"), array('\n', '\r'), $trowrvalue);
 160 if($il===0) { $srow = "INSERT INTO \"".$TableNames[$melanie_p]."\" ("; }
 161 if($il<$tnums&&$il!=$tnums) { $srow .= "\"".$trowrname."\", "; }
 162 if($il==$tnums) { $srow .= "\"".$trowrname."\") VALUES"; }
 163 if($il===0) { $srowvalue = "("; }
 164 if(!is_numeric($trowrvalue)) { $trowrvalue = "'".$trowrvalue."'"; }
 165 if($il<$tnums) { $srowvalue .= $trowrvalue.", "; }
 166 if($il==$tnums) { $srowvalue .= $trowrvalue;
 167 if($kazuki_p<$tnumz) { $srowvalue .= ");"; }
 168 if($kazuki_p==$tnumz) { $srowvalue .= ");"; } }
 169 ++$il; }
 170 if($kazuki_p===0) {
 171 $sqldump .= "--\n";
 172 $sqldump .= "-- Dumping data for table \"".$TableNames[$melanie_p]."\"\n";
 173 $sqldump .= "--\n\n"; }
 174 $sqldump .= $srow."\n";
 175 $sqldump .= $srowvalue."\n";
 176 if($kazuki_p==$tnumz&&$melanie_p<$tnum) {
 177 $sqldump .= "\n-- --------------------------------------------------------\n"; }
 178 ++$kazuki_p; }
 179 if($numz===0) {
 180 $sqldump .= "--\n";
 181 $sqldump .= "-- Dumping data for table \"".$TableNames[$melanie_p]."\"\n";
 182 $sqldump .= "--\n\n";
 183 $sqldump .= "\n-- --------------------------------------------------------\n"; }
 184 $sqldump .= "\n";
 185 ++$melanie_p; }
 186 if($_GET['compress']=="none") { echo $sqldump; }
 187 if($_GET['compress']=="gzencode") { echo gzencode($sqldump,$_GET['comlevel']); }
 188 if($_GET['compress']=="gzcompress") { echo gzcompress($sqldump,$_GET['comlevel']); }
 189 if($_GET['compress']=="gzdeflate") { echo gzdeflate($sqldump,$_GET['comlevel']); }
 190 if($_GET['compress']=="bzcompress") { echo bzcompress($sqldump,$_GET['comlevel']); }
 191 fix_amp($Settings['use_gzip'],$GZipEncode['Type']);
 192 ?>