X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=scripts%2Fmysql2txt.pl;h=b733e7625d7646d67bf3d5854522d93cbb8de775;hb=45e51047c2df703229843193e49fb9829489170f;hp=c73605a14b9e2792300c42ac679de2b94921d5a3;hpb=bb482ed34735d13cad2a02cf0f5cdc322b6b9f89;p=infobot.git

diff --git a/scripts/mysql2txt.pl b/scripts/mysql2txt.pl
index c73605a..b733e76 100755
--- a/scripts/mysql2txt.pl
+++ b/scripts/mysql2txt.pl
@@ -8,10 +8,10 @@ require "src/logger.pl";
 require "src/modules.pl";
 require "src/Misc.pl";
 require "src/Files.pl";
-$infobot_src_dir = "./src/";
+$bot_src_dir = "./src/";
 
 my $dbname = shift;
-if (!defined $dbname) {
+if ( !defined $dbname ) {
     print "Usage: $0 <db name>\n";
     print "Example: $0 factoids\n";
     exit 0;
@@ -21,27 +21,29 @@ if (!defined $dbname) {
 &loadConfig("files/infobot.config");
 &loadDBModules();
 
-&openDB();
+&openDB( $param{'DBName'}, $param{'SQLUser'}, $param{'SQLPass'} );
 
 # retrieve a list of db's from the server.
 my %db;
-foreach ($dbh->func('_ListTables')) {
+foreach ( $dbh->func('_ListTables') ) {
     $db{$_} = 1;
 }
 
 # factoid db.
-if (!exists $db{$dbname}) {
+if ( !exists $db{$dbname} ) {
     print "error: $dbname does not exist as a table.\n";
     exit 1;
 }
 
 my $query = "SELECT factoid_key,factoid_value from $param{'DBName'}.$dbname";
-my $sth = $dbh->prepare($query);
+my $sth   = $dbh->prepare($query);
 $sth->execute;
-while (my @row = $sth->fetchrow_array) {
-  print "$row[0] => $row[1]\n";
+while ( my @row = $sth->fetchrow_array ) {
+    print "$row[0] => $row[1]\n";
 }
 $sth->finish;
 
 print "Done.\n";
 &closeDB();
+
+# vim:ts=4:sw=4:expandtab:tw=80