bug-1182: PHP Deprecated: Function mysql_list_tables()
authorMartin Gummi <martin.gummi@gmx.net>
Wed, 26 Jun 2013 19:44:05 +0000 (21:44 +0200)
committerMartin Gummi <martin.gummi@gmx.net>
Wed, 26 Jun 2013 19:44:05 +0000 (21:44 +0200)
www/sqldump.php

index 9476f6f..c537f85 100644 (file)
        header("content-type: text/plain");
 ?>
 # CAcert SQL Dump
-# version 0.0.2
+# version 0.0.3
 #
 # Generation Time: <?=date('r')?>
 #
 # Database: `cacert`
 #
 <?
-       $tables = mysql_list_tables('cacert');
+       $tables = mysql_query("SHOW TABLES");
        while(list($table_name) = mysql_fetch_array($tables))
        {
                echo "# --------------------------------------------------------\n\n";
                echo "#\n# Table structure for table `$table_name`\n#\n\n";
 
                echo "DROP TABLE IF EXISTS `$table_name`;\n";
-               $create = mysql_fetch_assoc(mysql_query("SHOW CREATE TABLE `cacert`.`$table_name`"));
+               $create = mysql_fetch_assoc(mysql_query("SHOW CREATE TABLE `$table_name`"));
                echo $create['Create Table'].";\n\n";
        }
 ?>