- $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)
- )");
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "auth_settings (
- id int AUTO_INCREMENT NOT NULL,
- setting_key VARCHAR(255) NOT NULL,
- setting_value VARCHAR(255),
- PRIMARY KEY (id)
- )");
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "fail2ban (
- id int AUTO_INCREMENT NOT NULL,
- ip VARCHAR(255) NOT NULL,
- count VARCHAR(255),
- PRIMARY KEY (id)
- )");
- new AuthSettings();
+ $stmt = $conn->query("SHOW TABLES LIKE '".get_config("mysql::table_prefix")."%'");
+ if ($stmt->rowCount() < 4)
+ {
+ header("Location: ".get_config("base_url")."plugins/sql_auth/setup.php");
+ die();
+ }