* Rebranding from blootbot to infobot

[infobot.git] / setup / setup.pl

diff --git a/setup/setup.pl b/setup/setup.pl
index 177b2e24ba08bb3b55efafda5f3660b33b88be11..72ad985fc3361bd974cf4ad103a14a26852fa36e 100755 (executable)
--- a/setup/setup.pl
+++ b/setup/setup.pl
@@ -1,24 +1,25 @@
 #!/usr/bin/perl
-# setup_tables: setup MYSQL/PGSQL side of things for blootbot.
+# setup_tables: setup MYSQL/PGSQL side of things for infobot.
 # written by the xk.
 ###
 
-require "src/core.pl";
 require "src/logger.pl";
+require "src/core.pl";
 require "src/modules.pl";
 require "src/Misc.pl";
-require "src/interface.pl";
+require "src/CLI/Support.pl";
 
-$bot_src_dir = "./src/";
+$bot_src_dir = "src/";
+
+# read param stuff from infobot.config.
+&loadConfig("files/infobot.config");
 
-# read param stuff from blootbot.config.
-&loadConfig("files/blootbot.config");
 &loadDBModules();
 my $dbname = $param{'DBName'};
 my $query;
 
 if ($dbname eq "") {
-  print "error: appears that teh config file was not loaded properly.\n";
+  print "error: appears that the config file was not loaded properly.\n";
   exit 1;
 }
 
@@ -42,26 +43,23 @@ if ($param{'DBType'} =~ /mysql/i) {
        exit 1;
     }
 
-    &openDB("mysql", $adminuser, $adminpass);
+    &sqlOpenDB("mysql", "mysql", $adminuser, $adminpass);
 
     my $database_exists = 0;
-    foreach $database (&dbRawReturn("SHOW DATABASES")) {
+    foreach $database (&sqlRawReturn("SHOW DATABASES")) {
        $database_exists++ if $database eq $param{DBName};
     }
     if ($database_exists) {
-       &status("Hmm, database '$param{DBName}' already exists. Continuing...");
+       &status("Database '$param{DBName}' already exists. Continuing...");
     } else {
        &status("Creating db ...");
-       &dbRaw("create(database)", "CREATE DATABASE $param{DBName}");
+       &sqlRaw("create(database)", "CREATE DATABASE $param{DBName}");
     }
 
-    &status("Creating db ...");
-    &dbRaw("CREATE DATABASE $param{'DBName'}");
-
-    &status("--- Adding user information.");
+    &status("--- Adding user information for user '$param{'SQLUser'}'");
 
-    if (!&dbGet("user","user", "user=".&dbQuote($param{'SQLUser'}) ) ) {
-       &status("--- Adding user $param{'SQLUser'} $dbname/user table...");
+    if (!&sqlSelect("user", "user", { 'user' => &sqlQuote($param{'SQLUser'}) })) {
+       &status("--- Adding user '$param{'SQLUser'}' $dbname/user table...");
 
        $query = "INSERT INTO user VALUES ".
                "('localhost', '$param{'SQLUser'}', ".
@@ -69,13 +67,13 @@ if ($param{'DBType'} =~ /mysql/i) {
 
        $query .= "'Y','Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N')";
 
-       &dbRaw("create(user)", $query);
+       &sqlRaw("create(user)", $query);
     } else {
-       &status("... User information already present.");
+       &status("... user information already present.");
     }
 
-    if (!&dbGet("db","db","db=".&dbQuote($param{'SQLUser'}) ) ) {
-       &status("--- Adding 'db' stuff.");
+    if (!&sqlSelect("db", "db", { 'db' => &sqlQuote($param{'SQLUser'}) })) {
+       &status("--- Adding database information for database '$dbname'.");
 
        $query = "INSERT INTO db VALUES ".
                "('localhost', '$dbname', ".
@@ -83,7 +81,7 @@ if ($param{'DBType'} =~ /mysql/i) {
 
        $query .= "'Y','Y','Y','Y','Y','Y','Y','N','N','N')";
 
-       &dbRaw("create(db)", $query);
+       &sqlRaw("create(db)", $query);
     } else {
        &status("... db info already present.");
     }
@@ -91,9 +89,9 @@ if ($param{'DBType'} =~ /mysql/i) {
     # flush.
     &status("Flushing privileges...");
     $query = "FLUSH PRIVILEGES";
-    &dbRaw("mysql(flush)", $query);
+    &sqlRaw("mysql(flush)", $query);
 }
 
 &status("Done.");
 
-&closeDB();
+&sqlCloseDB();