3 require_once "../../common.php";
4 require_once "../../header.php";
6 if (!isset($_POST) || empty($_POST))
11 In order to
use SQL Auth
, the relevant SQL tables must be created
.<br
>
12 If, for some reason
, that
's not what you want, please remove <code>"sql_auth"</code> from the plugins option in your webpanel configuration.<br><br>
13 Thanks for using SQL Auth plugin!<br><br>
16 <button id="createbtn" name="createbtn" class="btn btn-primary" type="submit">Create the tables!</button>
20 elseif (isset($_POST['createbtn
']))
23 $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "users (
24 user_id int AUTO_INCREMENT NOT NULL,
25 user_name VARCHAR(255) NOT NULL,
26 user_pass VARCHAR(255) NOT NULL,
27 user_email VARCHAR(255),
28 user_fname VARCHAR(255),
29 user_lname VARCHAR(255),
30 user_bio VARCHAR(255),
36 * Patch for beta users
37 * This adds the email column to existing tables without it
39 $columns = $conn->query("SHOW COLUMNS FROM " . SQL_PREFIX . "users");
40 $column_names = array();
41 $c = $columns->fetchAll();
43 foreach($c as $column) {
44 $column_names[] = $column['Field
'];
46 $column_exists = in_array("user_email", $column_names);
47 if (!$column_exists) {
48 $conn->query("ALTER TABLE " . SQL_PREFIX . "users ADD COLUMN user_email varchar(255)");
52 * Another patch for beta users
53 * This changes the size of the meta_value so we can store more
56 $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "user_meta (
57 meta_id int AUTO_INCREMENT NOT NULL,
59 meta_key VARCHAR(255) NOT NULL,
60 meta_value VARCHAR(255),
63 $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "auth_settings (
64 id int AUTO_INCREMENT NOT NULL,
65 setting_key VARCHAR(255) NOT NULL,
66 setting_value VARCHAR(255),
69 $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "fail2ban (
70 id int AUTO_INCREMENT NOT NULL,
71 ip VARCHAR(255) NOT NULL,
76 if (($columns = $conn->query("SHOW COLUMNS FROM ".SQL_PREFIX."user_meta")));
77 $c = $columns->fetchAll();
79 $conn->query("ALTER TABLE `".SQL_PREFIX."user_meta` CHANGE `meta_value` `meta_value` VARCHAR(5000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
84 Message::Success("Congratulations, you're all ready to go
!");
86 <a class="btn btn
-primary
" href="<?php
echo BASE_URL
; ?>">Take me home!</a>
87 <a class="btn btn
-warning
" href="<?php
echo BASE_URL
."settings"; ?>">Settings</a>
90 require_once "../../footer
.php
";