require "src/core.pl";
require "src/Misc.pl";
require "src/logger.pl";
+require "src/modules.pl";
+$bot_src_dir = "./src";
&loadConfig("files/blootbot.config");
+&loadDBModules();
+
my $dbname = $param{'DBName'};
my $query;
}
if ($param{'DBType'} =~ /mysql/i) {
- if (!scalar @ARGV) {
- print "hi there.\n\n";
-
- print "if you're running a new version of mysql (debian potato), run\n";
- print "this script with the '1' parameter while '0' for older versions\n";
- print "(debian slink).\n";
- exit 0;
- }
-
- my $mysqlversion;
- if ($ARGV[0] =~ /^\d+$/) {
- if ($ARGV[0] == 0) {
- $mysqlversion = 0;
- } elsif ($ARGV[0] == 1) {
- $mysqlversion = 1;
- } else {
- print "error: wrong integer?\n";
- }
- } else {
- print "error: wrong argument?\n";
- exit 1;
- }
print "Enter root information...\n";
# username.
print "Step 1: Adding user information.\n";
# open the db.
- &openDB();
+ &openDB("mysql", $adminuser, $adminpass);
# Step 2.
- if (!&sqlGet("user","user",$param{'mysqlUser'},"user")) {
- print " Adding user $param{'mysqlUser'} $dbname/user table...\n";
+ if (!&dbGet("user","user",$param{'SQLUser'},"user")) {
+ print " Adding user $param{'SQLUser'} $dbname/user table...\n";
$query = "INSERT INTO user VALUES ".
- "('localhost', '$param{'mysqlUser'}', ".
- "password('$param{'mysqlPass'}'), ";
+ "('localhost', '$param{'SQLUser'}', ".
+ "password('$param{'SQLPass'}'), ";
- if ($mysqlversion) {
- $query .= "'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N')";
- } else {
- $query .= "'Y','Y','Y','Y','N','N','N','N','N','N')";
- }
+ $query .= "'Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N')";
+### $query .= "'Y','Y','Y','Y','N','N','N','N','N','N')";
&dbRaw("create(user)", $query);
}
# Step 3. what's this for?
- if (!&sqlGet("db","db",$param{'mysqlUser'},"db")) {
+ if (!&dbGet("db","db",$param{'SQLUser'},"db")) {
print " Adding 'db' entry\n";
$query = "INSERT INTO db VALUES ".
"('localhost', '$dbname', ".
- "'$param{'mysqlUser'}', ";
+ "'$param{'SQLUser'}', ";
- if ($mysqlversion) {
- $query .= "'Y','Y','Y','Y','Y','N','N','N','N','N')";
- } else {
- $query .= "'Y','Y','Y','Y','Y','N')";
- }
+ $query .= "'Y','Y','Y','Y','Y','N','N','N','N','N')";
+### $query .= "'Y','Y','Y','Y','Y','N')";
&dbRaw("create(db)", $query);
}
# grant.
print " Granting user access to table.\n";
- $query = "GRANT SELECT,INSERT,UPDATE,DELETE ON $dbname TO $param{'mysqlUser'}";
- &dbRaw($query);
+ $query = "GRANT SELECT,INSERT,UPDATE,DELETE ON $dbname TO $param{'SQLUser'}";
+ &dbRaw("??", $query);
# flush.
print "Flushing privileges...\n";
&dbRaw("create(db $param{'DBName'})", $query);
} elsif ($param{'DBType'} =~ /pg|postgres/i) {
use Pg;
- &openDB();
+# &openDB();
print "FIXME\n";
}