Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL Syntax:
- CREATE TABLE IF NOT EXISTS `Members` (
- `Username` varchar(26) NOT NULL,
- `Password` varchar(255) NOT NULL,
- `loginStatus` int(1) NOT NULL,
- `Rank` int(3) NOT NULL
- ) DEFAULT CHARSET=utf8;
- INSERT INTO `Members` VALUES
- ('', 'random_password', 0, 3),
- ('whoami@mailing.nl', 'rand_pass', 0, 1),
- ('skurt', 'mdrlol', 1, 1),
- ('useless', 'again_pass', 0, 1);
- <?php
- if(session_status()==1)
- session_start();
- function getDB()
- {
- return new PDO();
- }
- class User
- {
- function isLogged()
- {
- return isset($_SESSION['LoginData']);
- }
- function isAdmin()
- {
- return isLogged()&&explode($_SESSION['LoginData'], '||')[1]=="3";
- }
- function logMe($user,$pass)
- {
- $usn = htmlspecialchars($user);
- $pwd = bcrypt(sha1("5TEAK1SG00DBUT54L715B3773R".$pass));
- $db = getDB();
- $sql = $db->prepare("SELECT Username,Password,loginStatus FROM Members WHERE Username = :usn, Password = :pwd, loginStatus != 1");
- $sql->execute(array(":usn" => $usn, ":pwd" => $pwd));
- if($sql->rowCount()==1)
- {
- $sql = $sql->fetchColumn(0);
- $_SESSION['LoginData'] = "$usn||".$sql['Rank']."||".date();
- return TRUE;
- }
- }
- function createMe($user,$pass)
- {
- $usn = htmlspecialchars($user);
- $pwd = bcrypt(sha1("5TEAK1SG00DBUT54L715B3773R".$pass));
- $db = getDB();
- $sql = $db->prepare("INSERT INTO Members VALUES (:usn, :pwd, 1, 0)");
- return $sql->execute(array(":usn" => $usn, ":pwd" => $pwd));
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement