# 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 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;
}
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'}', ".
$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', ".
$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.");
}
# flush.
&status("Flushing privileges...");
$query = "FLUSH PRIVILEGES";
- &dbRaw("mysql(flush)", $query);
+ &sqlRaw("mysql(flush)", $query);
}
&status("Done.");
-&closeDB();
+&sqlCloseDB();