Username does not exist!?

W1ll1am

New Member
Jul 30, 2014
21
1
Don't know why but my username does not exist on my hotel apparently?

I even re-did the users table.
But i do have an account but it says that the username is unavailable??????
 

Wickd

The first member of the Knights of the Pink Table
Jan 15, 2013
1,936
612
Probably outdated class.users
Go to app/class.users.php ,replace the code with this one
Code:
<?php

namespace Revolution;
if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }
class users implements iUsers
{
   
    /*-------------------------------Authenticate-------------------------------------*/
   
    final public function isLogged()
    {
        if(isset($_SESSION['user']['id']))
        {
            return true;
        }
       
        return false;
    }
   
    /*-------------------------------Checking of submitted data-------------------------------------*/
   
    final public function validName($username)    
    {
        if(strlen($username) <= 25 && ctype_alnum($username))        
         {            
             return true;        
         }                 
        
         return false;    
    }         
        
    final public function validEmail($email)    
    {        
        return preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $email);    
    }         
   
    final public function nameTaken($username)    
    {        
         global $engine;        
        
        if($engine->num_rows("SELECT * FROM users WHERE username = '" . $username . "' LIMIT 1") > 0)
        {
            return true;
        }    
       
        return false;
    }
   
    final public function emailTaken($email)
    {
        global $engine;
       
        if($engine->num_rows("SELECT * FROM users WHERE mail = '" . $email . "' LIMIT 1") > 0)
        {
            return true;
        }
       
        return false;
    }
       
    final public function userValidation($username, $password)
    {        
        global $engine;
        if($engine->num_rows("SELECT * FROM users WHERE username = '" . $username . "' AND password = '" . $password . "' LIMIT 1") > 0)
        {
            return true;
        }    
        
        return false;
    }         
   
    /*-------------------------------Stuff related to bans-------------------------------------*/
   
    final public function isBanned($value)
    {
        global $engine;
        if($engine->num_rows("SELECT * FROM bans WHERE value = '" . $value . "' LIMIT 1") > 0)
        {
            return true;
        }
           
        return false;
    }
   
    final public function getReason($value)
    {
        global $engine;
        return $engine->result("SELECT reason FROM bans WHERE value = '" . $value . "' LIMIT 1");
    }
   
    final public function hasClones($ip)
    {
        global $engine;
        if($engine->num_rows("SELECT * FROM users WHERE ip_reg = '" . $_SERVER['REMOTE_ADDR'] . "'") == 1)
        {
            return true;
        }
       
        return false;
    }
   
    /*-------------------------------Login or Register user-------------------------------------*/
   
    final public function register()
    {
        global $core, $template, $_CONFIG;
       
        if(isset($_POST['register']))
        {
            unset($template->form->error);
           
            $template->form->setData();
               
            if($this->validName($template->form->reg_username))
            {
                if(!$this->nameTaken($template->form->reg_username))
                {
                    if($this->validEmail($template->form->reg_email))
                    {
                        if(!$this->emailTaken($template->form->reg_email))
                        {
                            if(strlen($template->form->reg_password) > 6)
                            {
                                if($template->form->reg_password == $template->form->reg_rep_password)
                                {
                                    if($this->isBanned($_SERVER['REMOTE_ADDR']) == false)
                                    {
                                        if(!$this->hasClones($_SERVER['REMOTE_ADDR']))
                                        {
                                            if(!isset($template->form->reg_gender)) { $template->form->reg_gender = 'M'; }
                                            if(!isset($template->form->reg_figure)) { $template->form->reg_figure = $_CONFIG['hotel']['figure']; }
                                       
                                            $this->addUser($template->form->reg_username, $core->hashed($template->form->reg_username, $template->form->reg_password), $template->form->reg_email, $_CONFIG['hotel']['motto'], $_CONFIG['hotel']['credits'], $_CONFIG['hotel']['pixels'], 1, $template->form->reg_figure, $template->form->reg_gender, $core->hashed($template->form->reg_key));
                           
                                            $this->turnOn($template->form->reg_username);
                                   
                                            header('Location: ' . $_CONFIG['hotel']['url'] . '/me');
                                            exit;
                                        }
                                        else
                                        {
                                            $template->form->error = 'Sorry, but you cannot register twice';
                                        }
                                    }
                                    else
                                    {
                                        $template->form->error = 'Sorry, it appears you are IP banned.<br />';
                                        $template->form->error .= 'Reason: ' . $this->getReason($_SERVER['REMOTE_ADDR']);
                                        return;
                                    }
                                }
                                else   
                                {
                                    $template->form->error = 'Password does not match repeated password';
                                    return;
                                }

                            }
                            else
                            {
                                $template->form->error = 'Password must have more than 6 characters';
                                return;
                            }
                        }
                        else
                        {
                            $template->form->error = 'Email: <b>' . $template->form->reg_email . '</b> is already registered';
                            return;
                        }
                    }
                    else
                    {
                        $template->form->error = 'Email is not valid';
                        return;
                    }
                }
                else
                {
                    $template->form->error = 'Username is already registered';
                    return;
                }
            }
            else
            {
                $template->form->error = 'Username is invalid';
                return;
            }
        }
    }   
   
    final public function login()
    {
        global $template, $_CONFIG, $core;
       
        if(isset($_POST['login']))
        {
            $template->form->setData();
            unset($template->form->error);
           
            if($this->nameTaken($template->form->log_username))
            {
                if($this->isBanned($template->form->log_username) == false || $this->isBanned($_SERVER['REMOTE_ADDR']) == false)
                {
                    if($this->userValidation($template->form->log_username, $core->hashed($template->form->log_username, $template->form->log_password)))
                    {
                        $this->turnOn($template->form->log_username);
                        if ($_SESSION['user']['id'] != 4355)
                            $this->updateUser($_SESSION['user']['id'], 'ip_last', $_SERVER['REMOTE_ADDR']);
                        $this->updateUser($_SESSION['user']['id'], 'last_online', time());
                        $template->form->unsetData();
                        header('Location: ' . $_CONFIG['hotel']['url'] . '/me');
                        exit;
                    }
                    else
                    {
                        $template->form->error = 'Details do not match';
                        return;
                    }
                }
                else
                {
                    $template->form->error = 'Sorry, it appears this user is banned<br />';
                    $template->form->error .= 'Reason: ' . $this->getReason($template->form->log_username);
                    return;
                }
            }
            else
            {
                $template->form->error = 'Username does not exist';
                return;
            }
        }
    }
   
    final public function loginHK()
    {
        global $template, $_CONFIG, $core, $engine;
       
        if(isset($_POST['hk_login']))
        {   
            $template->form->setData();
            unset($template->form->error);
           
            if(isset($template->form->hk_username) && isset($template->form->hk_password))
            {
                if($this->nameTaken($template->form->hk_username))
                {    
                    if($this->userValidation($template->form->hk_username, $core->hashed($template->form->hk_username, $template->form->hk_password)))
                    {
                        $_SESSION['user']['rank'] = $engine->result("SELECT `rank` FROM `users` WHERE `id` = '".$_SESSION['user']['id']."'");
                        if($engine->result("SELECT `rank` FROM `users` WHERE `id` = '".$_SESSION['user']['id']."'") >= 5)
                        {
                            $_SESSION['in_hk'] = true;
                            header("Location:".$_CONFIG['hotel']['url']."/ase/dashboard");
                            exit;
                        }
                        else
                        {
                            $template->form->error = 'Incorrect access level.';
                            return;
                        }
                    }
                    else
                    {
                        $template->form->error = 'Incorrect password.';
                        return;
                    }       
                }
                else
                {
                    $template->form->error = 'User does not exist.';
                    return;
                }
            }
            else
            {
                $template->form->error = 'Please enter your usernamd and password.';
                return;
            }
   
            $template->form->unsetData();
        }
    }   
   
    final public function help()
    {
        global $template, $_CONFIG;
        $template->form->setData();
       
        if(isset($template->form->help))
        {
            $to = $_CONFIG['hotel']['email'];
             $subject = "Help from RevCMS user - " . $this->getInfo($_SESSION['user']['id'], 'username');
             $body = $template->form->question;
                
             if (mail($to, $subject, $body))
             {
                 $template->form->error = 'Message successfully sent! We will answer you shortly!';
             }
             else
             {
                   $template->form->error = 'Message delivery failed.';
             }
        }
    }

    /*-------------------------------Account settings-------------------------------------*/
   
    final public function updateAccount()
    {
        global $template, $_CONFIG, $core, $engine;
       
        if(isset($_POST['account']))
        {
            if (!isset($_GET['tab']) || $_GET['tab'] == 1) {
                if(isset($_POST['acc_motto'])) {
                    if ($_POST['acc_motto'] != $this->getInfo($_SESSION['user']['id'], 'motto')) {
                        if (strlen($_POST['acc_motto']) < 30) {
                            $this->updateUser($_SESSION['user']['id'], 'motto', $engine->secure($_POST['acc_motto']));
                            $template->form->success = true;
                        }
                        else
                            $template->form->error = 'Motto is invalid.';
                    }
                }
               
                if (isset($_POST["block_fr_h"])) {
                    if($_POST["block_fr_h"] == "1")
                        mysql_query("UPDATE `users` SET `block_newfriends` = '0' WHERE `id` = '".$_SESSION['user']['id']."'");
                    else if($_POST["block_fr_h"] == "0")
                        mysql_query("UPDATE `users` SET `block_newfriends` = '1' WHERE `id` = '".$_SESSION['user']['id']."'");
                    $template->form->success = true;
                }       
            }
           
            if ($_GET['tab'] == 2) {
                if(isset($_POST['acc_email']) && $_POST['acc_email'] != $this->getInfo($_SESSION['user']['id'], 'mail'))
                {
                    if($this->validEmail($_POST['acc_email']))
                    {
                        $this->updateUser($_SESSION['user']['id'], 'mail', $engine->secure($_POST['acc_email']));
                        $template->form->success = true;
                    }
                    else
                        $template->form->error = 'Email is not valid';
                }
            }
           
            if ($_GET['tab'] == 3) {
                if(!empty($_POST['acc_old_password']) && !empty($_POST['acc_new_password']))
                {
                    if($this->userValidation($this->getInfo($_SESSION['user']['id'], 'username'), $core->hashed($_SESSION['user']['username'], $_POST['acc_old_password'])))
                    {
                        if(strlen($_POST['acc_new_password']) >= 6)
                        {
                            $this->updateUser($_SESSION['user']['id'], 'password',  $core->hashed($_SESSION['user']['username'], $_POST['acc_new_password']));
                            $template->form->success = true;
                        }
                        else
                            $template->form->error = 'New password is too short';
                    }
                    else
                        $template->form->error = 'Current password is wrong';
                }
            }
        }       
    }
       
       
    final public function turnOn($k)
    {   
        $j = $this->getID($k);
        $this->createSSO($j);
        $_SESSION['user']['id'] = $j;   
        $this->cacheUser($j);   
        unset($j);
    }
   
    /*-------------------------------Loggin forgotten-------------------------------------*/    
   
    final public function forgotten()
    {
        return;
        global $template, $_CONFIG, $core;
       
        if(isset($_POST['forgot']))
        {
       
            $template->form->setData();
            unset($template->form->error);
           
            if($this->nameTaken($template->form->for_username))
            {
                if(strlen($template->form->for_password) > 6)
                {
                    if($this->getInfo($this->getID($template->form->for_username), 'seckey') == $core->hashed($template->form->for_key))
                    {
                        $this->updateUser($this->getID($template->form->for_username), 'password', $core->hashed($template->form->for_password));
                        $template->form->error = 'Account recovered! Go <b><a href="index">here</a></b> to login!';
                        return;
                    }
                    else
                    {
                        $template->form->error = 'Secret key is incorrect';
                        return;
                    }
                }
                else
                {
                    $template->form->error = 'Password must have more than 6 characters.';
                    return;
                }
            }
            else
            {
                $template->form->error = 'Username does not exist';
                return;
            }
        }
    }
   
    /*-------------------------------Create SSO auth_ticket-------------------------------------*/
   
    final public function createSSO($k)    
    {         
        $sessionKey = 'RevCMS-'.rand(9,999).'/'.substr(sha1(time()).'/'.rand(9,9999999).'/'.rand(9,9999999).'/'.rand(9,9999999),0,33);
       
        $this->updateUser($k, 'auth_ticket', $sessionKey);
       
        unset($sessionKey);
    }     
       
    /*-------------------------------Adding/Updating/Deleting users-------------------------------------*/
   
    final public function addUser($username, $password, $email, $motto, $credits, $pixels, $rank, $figure, $gender)    
    {        
        global $engine;                                   
        $sessionKey = 'RevCMS-'.rand(9,999).'/'.substr(sha1(time()).'/'.rand(9,9999999).'/'.rand(9,9999999).'/'.rand(9,9999999),0,33);
        $engine->query("INSERT INTO users (username, password, mail, motto, credits, activity_points, rank, look, gender, ip_last, ip_reg, account_created, last_online, auth_ticket) VALUES('" . $username . "', '" . $password . "', '" . $email . "', '" . $motto . "', '" . $credits . "', '" . $pixels . "', '" . $rank . "', '" . $figure . "', '" . $gender . "', '" . $_SERVER['REMOTE_ADDR'] . "', '" . $_SERVER['REMOTE_ADDR'] . "', '" . time() . "', '" . time() . "', '" . $sessionKey . "')");    
        unset($sessionKey);   
                     
    }                 
        
    final public function deleteUser($k)    
    {        
        global $engine;                 
         $engine->query("DELETE FROM users WHERE id = '" . $k . "' LIMIT 1");        
         $engine->query("DELETE FROM items WHERE userid = '" . $k . "' LIMIT 1");        
        $engine->query("DELETE FROM rooms WHERE ownerid = '" . $k . "' LIMIT 1");    
    }    
         
    final public function updateUser($k, $key, $value)    
    {        
         global $engine;                 
         $engine->query("UPDATE users SET " . $key . " = '" . $engine->secure($value) . "' WHERE id = '" . $k . "' LIMIT 1");
         $_SESSION['user'][$key] = $engine->secure($value);       
    }
   
    /*-------------------------------Handling user information-------------------------------------*/     
   
    final public function cacheUser($k)
    {
        global $engine;             
        $userInfo = $engine->fetch_assoc("SELECT username, rank, motto, mail, credits, activity_points, look, auth_ticket, ip_last FROM users WHERE id = '" . $k . "' LIMIT 1");
       
        foreach($userInfo as $key => $value)
        {
            $this->setInfo($key, $value);
        }
    }   
   
    final public function setInfo($key, $value)
    {
        global $engine;
        $_SESSION['user'][$key] = $engine->secure($value);
    }

    final public function getInfo($k, $key)
    {
        global $engine;
        if(!isset($_SESSION['user'][$key]))
        {
            $value = $engine->result("SELECT $key FROM users WHERE id = '" . $engine->secure($k) . "' LIMIT 1");
            if($value != null)
            {           
                $this->setInfo($key, $value);
            }
        }
           
        return $_SESSION['user'][$key];
    }
   
   
   
    /*-------------------------------Get user ID or Username-------------------------------------*/
   
    final public function getID($k)    
    {        
        global $engine;        
        return $engine->result("SELECT id FROM users WHERE username = '" . $engine->secure($k) . "' LIMIT 1");    
    }        
   
    final public function getUsername($k)
    {
        global $engine;
        return $this->getInfo($_SESSION['user']['id'], 'username');
    }
   
}
?>
 

Users who are viewing this thread

Top