X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=setup%2Fsetup.pl;h=89393bd1fc1039e92cd98107d01e277e81b70e22;hb=06f647da80d499612d353da2866c9c3afd3267e2;hp=c9562aebdddd78b156671b58db35ae6c3d2177ab;hpb=cb81fea9939f349b36e3b5a0cdc0343a6b781da1;p=infobot.git

diff --git a/setup/setup.pl b/setup/setup.pl
index c9562ae..89393bd 100755
--- a/setup/setup.pl
+++ b/setup/setup.pl
@@ -18,78 +18,90 @@ $bot_src_dir = "src/";
 my $dbname = $param{'DBName'};
 my $query;
 
-if ($dbname eq "") {
-  print "error: appears that the config file was not loaded properly.\n";
-  exit 1;
+if ( $dbname eq "" ) {
+    print "error: appears that the config file was not loaded properly.\n";
+    exit 1;
 }
 
-if ($param{'DBType'} =~ /mysql/i) {
+if ( $param{'DBType'} =~ /mysql/i ) {
     use DBI;
 
     print "Enter root information...\n";
+
     # username.
     print "Username: ";
-    chop (my $adminuser = <STDIN>);
+    chop( my $adminuser = <STDIN> );
 
     # passwd.
     system "stty -echo";
     print "Password: ";
-    chop(my $adminpass = <STDIN>);
+    chop( my $adminpass = <STDIN> );
     print "\n";
     system "stty echo";
 
-    if ($adminuser eq "" or $adminpass eq "") {
-	&ERROR("error: adminuser || adminpass is NULL.");
-	exit 1;
+    if ( $adminuser eq "" or $adminpass eq "" ) {
+        &ERROR("error: adminuser || adminpass is NULL.");
+        exit 1;
     }
 
-    &sqlOpenDB("mysql", "mysql", $adminuser, $adminpass);
+    &sqlOpenDB( "mysql", "mysql", $adminuser, $adminpass );
 
     my $database_exists = 0;
-    foreach $database (&sqlRawReturn("SHOW DATABASES")) {
-	$database_exists++ if $database eq $param{DBName};
+    foreach $database ( &sqlRawReturn("SHOW DATABASES") ) {
+        $database_exists++ if $database eq $param{DBName};
     }
     if ($database_exists) {
-	&status("Database '$param{DBName}' already exists. Continuing...");
-    } else {
-	&status("Creating db ...");
-	&sqlRaw("create(database)", "CREATE DATABASE $param{DBName}");
+        &status("Database '$param{DBName}' already exists. Continuing...");
+    }
+    else {
+        &status("Creating db ...");
+        &sqlRaw( "create(database)", "CREATE DATABASE $param{DBName}" );
     }
 
     &status("--- Adding user information for user '$param{'SQLUser'}'");
 
-    if (!&sqlSelect("user", "user", { 'user' => &sqlQuote($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'}', ".
-		"password('$param{'SQLPass'}'), ";
+        $query =
+            "INSERT INTO user VALUES "
+          . "('localhost', '$param{'SQLUser'}', "
+          . "password('$param{'SQLPass'}'), ";
 
-	$query .= "'Y','Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N')";
+        $query .= "'Y','Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N')";
 
-	&sqlRaw("create(user)", $query);
-    } else {
-	&status("... user information already present.");
+        &sqlRaw( "create(user)", $query );
+    }
+    else {
+        &status("... user information already present.");
     }
 
-    if (!&sqlSelect("db", "db", { 'db' => &sqlQuote($param{'SQLUser'}) })) {
-	&status("--- Adding database information for database '$dbname'.");
+    if ( !&sqlSelect( "db", "db", { 'db' => &sqlQuote( $param{'SQLUser'} ) } ) )
+    {
+        &status("--- Adding database information for database '$dbname'.");
 
-	$query = "INSERT INTO db VALUES ".
-		"('localhost', '$dbname', ".
-		"'$param{'SQLUser'}', ";
+        $query =
+            "INSERT INTO db VALUES "
+          . "('localhost', '$dbname', "
+          . "'$param{'SQLUser'}', ";
 
-	$query .= "'Y','Y','Y','Y','Y','Y','Y','N','N','N')";
+        $query .= "'Y','Y','Y','Y','Y','Y','Y','N','N','N')";
 
-	&sqlRaw("create(db)", $query);
-    } else {
-	&status("... db info already present.");
+        &sqlRaw( "create(db)", $query );
+    }
+    else {
+        &status("... db info already present.");
     }
 
     # flush.
     &status("Flushing privileges...");
     $query = "FLUSH PRIVILEGES";
-    &sqlRaw("mysql(flush)", $query);
+    &sqlRaw( "mysql(flush)", $query );
 }
 
 &status("Done.");