X-Git-Url: https://jfr.im/git/irc/unrealircd/unrealircd-webpanel.git/blobdiff_plain/b6540c8fd85cca3e4e5c4dd40d3568884b3dbc6b..ea90b321a4b3768028d841b307c362af97a5e6e1:/plugins/sql_auth/setup.php
diff --git a/plugins/sql_auth/setup.php b/plugins/sql_auth/setup.php
index 59600af..0908318 100644
--- a/plugins/sql_auth/setup.php
+++ b/plugins/sql_auth/setup.php
@@ -10,7 +10,7 @@ require_once "../../common.php";
-
+css/unrealircd-admin.css" rel="stylesheet">
@@ -22,9 +22,9 @@ require_once "../../common.php";
-
+
UnrealIRCd Panel
-
+img/favicon.ico">
@@ -54,7 +54,7 @@ if (!isset($_POST) || empty($_POST))
elseif (isset($_POST['createbtn']))
{
$conn = sqlnew();
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "users (
+ $conn->query("CREATE TABLE IF NOT EXISTS " . get_config("mysql::table_prefix") . "users (
user_id int AUTO_INCREMENT NOT NULL,
user_name VARCHAR(255) NOT NULL,
user_pass VARCHAR(255) NOT NULL,
@@ -70,7 +70,7 @@ elseif (isset($_POST['createbtn']))
* Patch for beta users
* This adds the email column to existing tables without it
*/
- $columns = $conn->query("SHOW COLUMNS FROM " . SQL_PREFIX . "users");
+ $columns = $conn->query("SHOW COLUMNS FROM " . get_config("mysql::table_prefix") . "users");
$column_names = array();
$c = $columns->fetchAll();
@@ -79,7 +79,7 @@ elseif (isset($_POST['createbtn']))
}
$column_exists = in_array("user_email", $column_names);
if (!$column_exists) {
- $conn->query("ALTER TABLE " . SQL_PREFIX . "users ADD COLUMN user_email varchar(255)");
+ $conn->query("ALTER TABLE " . get_config("mysql::table_prefix") . "users ADD COLUMN user_email varchar(255)");
}
/**
@@ -87,38 +87,38 @@ elseif (isset($_POST['createbtn']))
* This changes the size of the meta_value so we can store more
*/
- $conn->query("CREATE TABLE IF NOT EXISTS " . SQL_PREFIX . "user_meta (
+ $conn->query("CREATE TABLE IF NOT EXISTS " . get_config("mysql::table_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 (
+ $conn->query("CREATE TABLE IF NOT EXISTS " . get_config("mysql::table_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 (
+ $conn->query("CREATE TABLE IF NOT EXISTS " . get_config("mysql::table_prefix") . "fail2ban (
id int AUTO_INCREMENT NOT NULL,
ip VARCHAR(255) NOT NULL,
count VARCHAR(255),
PRIMARY KEY (id)
)");
$c = [];
- if (($columns = $conn->query("SHOW COLUMNS FROM ".SQL_PREFIX."user_meta")));
+ if (($columns = $conn->query("SHOW COLUMNS FROM ".get_config("mysql::table_prefix")."user_meta")));
$c = $columns->fetchAll();
if (!empty($c))
- $conn->query("ALTER TABLE `".SQL_PREFIX."user_meta` CHANGE `meta_value` `meta_value` VARCHAR(5000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
+ $conn->query("ALTER TABLE `".get_config("mysql::table_prefix")."user_meta` CHANGE `meta_value` `meta_value` VARCHAR(5000) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL");
new AuthSettings();
Message::Success("Congratulations, you're all ready to go!");
?>
- Take me home!
- ">Settings
+ ">Take me home!
+ ">Settings