public function __construct() { parent::__construct("Apply for Access", "", 0); $db = Config::getMysqliConnectionRW(); $err = ''; if (isset($_POST['username'])) { if (post('captcha') == $_SESSION['captcha']) { $username = $db->real_escape_string(post('username')); $password = md5(post('password')); $email = $db->real_escape_string(post('email')); $reason = $db->real_escape_string(post('why')); $ip = Site::ip(); $db->query("INSERT INTO `request` (`ip`,`username`,`password`,`email`,`reason`,`time`) VALUES ('{$ip}','{$username}',UNHEX('{$password}'),'{$email}','{$reason}',UNIX_TIMESTAMP())"); header('Location: /'); exit; } else { $err = 'Invalid captcha.'; } } $q = $db->query("SELECT * FROM `request` WHERE `ip`='" . Site::ip() . "'"); if ($q->num_rows === 0) { $_SESSION['captcha'] = rand(100000, 999999); if ($err != '') { $this->appendToBody("<p class='center'>{$err}</p>"); } $this->appendToBody(Site::parseHtmlFragment('reqForm.html', ['__captcha__'], ['<img src="/captcha" alt="captcha">'])); } else { $r = $q->fetch_assoc(); if ($r['accepted'] == 0) { $this->appendToBody("<h2>Hold Your Horses</h2><p class='center'>You have successfully applied. Check this page or your email for your status.</p>"); } else { if ($r['accepted'] == -1) { $this->appendToBody("<h2>Oh noes ;_;</h2><p class='center'>Sorry, your application has been reviewed and denied. Now that you have seen this message, you may submit a new application.</p>"); $db->query("DELETE FROM `request` WHERE `ip`='" . Site::ip() . "'"); } else { if ($r['accepted'] == 1) { $this->appendToBody("<h2>Congratulations</h2><p class='center'>Your application was reviewed and accepted.<br>You may now log in with the username and password that you chose.</p>"); } } } } }