function __construct()
{
- self::create_tables();
Hook::func(HOOKTYPE_PRE_HEADER, 'sql_auth::session_start');
Hook::func(HOOKTYPE_USER_LOOKUP, 'sql_auth::get_user');
Hook::func(HOOKTYPE_USERMETA_ADD, 'sql_auth::add_usermeta');
*/
public static function create_tables()
{
- $script = $_SERVER['SCRIPT_FILENAME'];
- if (str_ends_with($script,"setup.php"))
- return;
$conn = sqlnew();
- $stmt = $conn->query("SHOW TABLES LIKE '".get_config("mysql::table_prefix")."%'");
- if ($stmt->rowCount() < 4)
+ $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,
+ user_email VARCHAR(255),
+ user_fname VARCHAR(255),
+ user_lname VARCHAR(255),
+ user_bio VARCHAR(255),
+ created VARCHAR(255),
+ PRIMARY KEY (user_id)
+ )");
+
+ /**
+ * Patch for beta users
+ * This adds the email column to existing tables without it
+ */
+ $columns = $conn->query("SHOW COLUMNS FROM " . get_config("mysql::table_prefix") . "users");
+ $column_names = array();
+ $c = $columns->fetchAll();
+
+ foreach($c as $column) {
+ $column_names[] = $column['Field'];
+ }
+ $column_exists = in_array("user_email", $column_names);
+ if (!$column_exists) {
+ $conn->query("ALTER TABLE " . get_config("mysql::table_prefix") . "users ADD COLUMN user_email varchar(255)");
+ }
+
+ /**
+ * Another patch for beta users
+ * This changes the size of the meta_value so we can store more
+ */
+
+ $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 " . 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 " . 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 ".get_config("mysql::table_prefix")."user_meta")));
+ $c = $columns->fetchAll();
+ if (!empty($c))
+ $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();
+
+
+ /* make sure everything went well */
+ $tables = ["users", "user_meta", "fail2ban", "auth_settings"];
+ $errors = 0; // counter
+ $error_messages = "";
+ foreach($tables as $table)
{
- header("Location: ".get_config("base_url")."plugins/sql_auth/setup.php");
- die();
+ $prefix = get_config("sql::prefix");
+ $sql = "SHOW TABLES LIKE '$prefix%'"; // SQL query to check if table exists
+
+ $result = $conn->query($sql);
+ if ($result->rowCount())
+ { /* great! */ }
+
+ else {
+ $errors++;
+ strcat($error_messages,"Table '$prefix$table' was not created successfully.<br>");
+ }
}
+ if (!$errors)
+ {
+ if (defined('DEFAULT_USER')) // we've got a default account
+ {
+ $lkup = new PanelUser(DEFAULT_USER['username']);
+
+ if (!$lkup->id) // doesn't exist, add it with full privileges
+ {
+ $user = [];
+ $user['user_name'] = DEFAULT_USER['username'];
+ $user['user_pass'] = DEFAULT_USER['password'];
+ $user['err'] = "";
+ create_new_user($user);
+ }
+ $lkup = new PanelUser(DEFAULT_USER['username']);
+ if (!user_can($lkup, PERMISSION_MANAGE_USERS))
+ $lkup->add_permission(PERMISSION_MANAGE_USERS);
+ }
+ return true;
+ }
+ else
+ return false;
+
}
/* We convert $u with a full user as an object ;D*/
/* Get the base url */
$uri = $_SERVER['REQUEST_URI'];
$tok = split($uri, "/");
+$base_url = "";
for ($i=0; isset($tok[$i]); $i++)
{
- if ($tok[$i] == "settings" && $tok[$i + 1] == "install.php")
+ if ($tok[$i] == "settings" && strstr($tok[$i + 1], "install.php"))
{
- $base_url = "/";
if ($i)
{
for($j=0; $j < $i; $j++)
strcat($base_url,"/");
}
}
- define('BASE_URL', $base_url);
}
}
-echo highlight_string(json_encode($_GET, JSON_PRETTY_PRINT));
+if (!strlen($base_url))
+ $base_url = "/";
+define('BASE_URL', $base_url);
+
$writable = (is_writable("../config/")) ? true: false;
?>
<!DOCTYPE html>
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="HandheldFriendly" content="true">
-<link href="<?php echo get_config("base_url"); ?>css/unrealircd-admin.css" rel="stylesheet">
<!-- Latest compiled and minified CSS -->
<!-- Font Awesome icons -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.1/css/all.min.css">
-<script src="<?php echo get_config("base_url"); ?>js/unrealircd-admin.js"></script>
+<script src="../js/unrealircd-admin.js"></script>
<title>UnrealIRCd Panel</title>
<link rel="icon" type="image/x-icon" href="<?php echo get_config("base_url"); ?>img/favicon.ico">
<body role="document">
- <div class="container
"><div class="row"><img src="../img/unreal.jpg" width="35px" height="35px" style="margin-right: 15px"><h3>UnrealIRCd Admin Panel Configuration and Setup</h3></div></div>
+ <div class="container
mt-4"><div class="row justify-content-center"><img src="../img/unreal.jpg" width="35px" height="35px" style="margin-right: 15px"><h3>UnrealIRCd Admin Panel Configuration and Setup</h3></div></div>
<?php
if (file_exists("../config/config.php"))
{
- ?><br><div class="container">You're already configured!
+ ?><br><div class="container"><?php Message::Fail("You're already configured!"); ?>
<br>
<a class="text-center btn btn-primary" href="<?php echo BASE_URL; ?>">Take me home!</a>
</div>
<?php
return;
}
- elseif (isset($_GET) && !empty($_GET))
+ elseif (isset($_POST) && !empty($_POST))
{
+ ?><br><div class="container"><?php
+ $opts = (object)$_POST;
/* pre-load the appropriate auth plugin */
- $opts = (object)$_GET;
$auth_method = (isset($opts->auth_method)) ? $opts->auth_method : NULL;
+ $auth_method_name = NULL;
+ switch($auth_method)
+ {
+ case "sql_auth":
+ $auth_method_name = "SQLAuth";
+ break;
+ case "file_auth":
+ $auth_method_name = "FileAuth";
+ break;
+ }
if ($auth_method)
- new Plugin($auth_method);
+ $am = new Plugin($auth_method);
else
- die(json_encode(["error" => "Invalid params"]));
+ {
+ Message::Fail("Invalid parameters");
+ return;
+ }
+ if ($am->error)
+ {
+ Message::Fail("Couldn't load plugin \"$auth_method\": $am->error");
+ return;
+ }
-
+ /* Assume we have a example config available and copy from that so we leave all the comments n things in there
+ * If we're setting up it's unlikely anyone would have swooped in already and deleted the example config.
+ * Throw an error if not
+ */
+ if (!file_exists("../config/config.php.sample"))
+ {
+ Message::Fail("Could not get sample configuration. We need it to work with.");
+ return;
+ }
+ else {
+ $conf = file_get_contents("../config/config.php.sample");
+ $conf = str_replace('$config["base_url"] = \'/unrealircd-webpanel/\'', '$config["base_url"] = \''.BASE_URL.'\'', $conf);
+ $conf = str_replace('$config["unrealircd"]["rpc_user"] = \'adminpanel\'', '$config["unrealircd"]["rpc_user"] = \''.$opts->rpc_user.'\'', $conf);
+ $conf = str_replace('$config["unrealircd"]["rpc_password"] = \'securepassword\'', '$config["unrealircd"]["rpc_password"] = \''.$opts->rpc_password.'\'', $conf);
+ $conf = str_replace('$config["unrealircd"]["host"] = \'127.0.0.1\'', '$config["unrealircd"]["host"] = \''.$opts->rpc_iphost.'\'', $conf);
+ $conf = str_replace('$config["unrealircd"]["port"] = \'8600\'', '$config["unrealircd"]["port"] = \''.$opts->rpc_port.'\'', $conf);
+ if (isset($opts->rpc_ssl))
+ $conf = str_replace('$config["unrealircd"]["tls_verify_cert"] = false', '$config["unrealircd"]["port"] = true', $conf);
+
+ $conf = str_replace("//\"$auth_method\"", "\"$auth_method\"", $conf); // enable our auth method
+
+ if ($auth_method == "sql_auth")
+ {
+ $conf = str_replace('//$config["mysql"]["host"] = "127.0.0.1"', '$config["mysql"]["host"] = "'.$opts->sql_iphost.'"', $conf);
+ $conf = str_replace('//$config["mysql"]["database"] = "unrealircdwebpanel"', '$config["mysql"]["database"] = "'.$opts->sql_db.'"', $conf);
+ $conf = str_replace('//$config["mysql"]["username"] = "unrealircdwebpanel"', '$config["mysql"]["username"] = "'.$opts->sql_user.'"', $conf);
+ $conf = str_replace('//$config["mysql"]["password"] = "replace_this_with_your_sql_password"', '$config["mysql"]["password"] = "'.$opts->sql_password.'"', $conf);
+ }
+ $file = fopen("../config/config.php", 'x+'); // only create it if it doesn't already exist even though we checked earlier
+ if ($file)
+ {
+ fwrite($file, $conf);
+ }
+ require_once("../config/config.php");
+
+ if ($auth_method == "sql_auth")
+ if (!sql_auth::create_tables())
+ Message::Fail("Could not create SQL tables");
+
+ $user = [
+ "user_name" => $opts->account_user,
+ "user_pass" => $opts->account_password,
+ "fname" => $opts->account_fname,
+ "lname" => $opts->account_lname,
+ "user_bio" => $opts->account_bio,
+ "email" => $opts->account_email
+ ];
+
+ create_new_user($user);
+ $lkup = new PanelUser($opts->account_user);
+ if (!$lkup->id)
+ {
+ Message::Fail("Could not create user");
+ return;
+ }
+ ?>
+ <br>
+ Great! Everything has been completely set up for you, and you can now log in.
+ <a class="text-center btn btn-primary" href="<?php echo BASE_URL; ?>">Let's go!</a></div>
+ <?php
+ return;
+ }
}
?>
</div>
<!-- Form start -->
-<form>
+<form method="post">
<div id="page2" class="container">
<h5>RPC Uplink Information</h5>
<br>
projects / irc / unrealircd / unrealircd-webpanel.git / commitdiff
