Create the tables automatically on plugin-load

diff --git a/plugins/sql_auth/index.php b/plugins/sql_auth/index.php
index 906c991ff18e6fcfd06810ca6722503e44c3535d..a511a2dcd863ce91739e2ee9909bc83ca0f892a6 100644 (file)
--- a/plugins/sql_auth/index.php
+++ b/plugins/sql_auth/index.php
@@ -9,32 +9,7 @@ do_log($_POST);
 if (isset($_POST))
 {
     $p = $_POST;
-    if (isset($p['sql_setup']))
-    {
-        if ($p['sql_setup'] == "add_tables")
-        {
-            $conn = sqlnew();
-            $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "users (
-                user_id int AUTO_INCREMENT NOT NULL,
-                user_name VARCHAR(255) NOT NULL,
-                user_pass VARCHAR(255) NOT NULL,
-                
-                user_fname VARCHAR(255),
-                user_lname VARCHAR(255),
-                user_bio VARCHAR(255),
-                created VARCHAR(255),
-                PRIMARY KEY (user_id)
-            )");
-            $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "user_meta (
-                meta_id int AUTO_INCREMENT NOT NULL,
-                user_id int NOT NULL,
-                meta_key VARCHAR(255) NOT NULL,
-                meta_value VARCHAR(255),
-                PRIMARY KEY (meta_id)
-            )");
-            
-        }
-    }
+    
 }
 
 

diff --git a/plugins/sql_auth/sql_auth.php b/plugins/sql_auth/sql_auth.php
index b7dbd85a93ebd4b47675b6ba82bfee941daa36f6..6c9516d60d6aa7ed9dc3d5f1fd9ea9a93015a0bd 100644 (file)
--- a/plugins/sql_auth/sql_auth.php
+++ b/plugins/sql_auth/sql_auth.php
@@ -12,6 +12,7 @@ class sql_auth
 
        function __construct()
        {
+               self::create_tables();
                Hook::func(HOOKTYPE_NAVBAR, 'sql_auth::add_navbar');
                Hook::func(HOOKTYPE_PRE_HEADER, 'sql_auth::session_start');
 
@@ -59,4 +60,27 @@ class sql_auth
                }
        }
 
+       public static function create_tables()
+       {
+               $conn = sqlnew();
+               $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "users (
+                       user_id int AUTO_INCREMENT NOT NULL,
+                       user_name VARCHAR(255) NOT NULL,
+                       user_pass VARCHAR(255) NOT NULL,
+                       
+                       user_fname VARCHAR(255),
+                       user_lname VARCHAR(255),
+                       user_bio VARCHAR(255),
+                       created VARCHAR(255),
+                       PRIMARY KEY (user_id)
+               )");
+               $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "user_meta (
+                       meta_id int AUTO_INCREMENT NOT NULL,
+                       user_id int NOT NULL,
+                       meta_key VARCHAR(255) NOT NULL,
+                       meta_value VARCHAR(255),
+                       PRIMARY KEY (meta_id)
+               )");
+       }
+
 }
\ No newline at end of file