Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Dec 2008
    Posts
    133
    Thanks
    15
    Thanked 0 Times in 0 Posts

    Macintosh Function Is not working

    Hey im modding this file and have created a function which i feel should work, but does not work.

    The function's name is : getRank()

    PHP Code:
    <?
    include("database.php");
    include_once(
    "function.php");
    include(
    "mailer.php");
    include(
    "form.php");
    require_once(
    "constants.php");

    class 
    Session
    {
       var 
    $username;     //Username given on sign-up
       
    var $userid;       //Random value generated on current login
       
    var $userlevel;    //The level to which the user pertains
       
    var $time;         //Time user was last active (page loaded)
       
    var $logged_in;    //True if user is logged in, false otherwise
       
    var $userinfo = array();  //The array holding all user info
       
    var $url;          //The page url current being viewed
       
    var $referrer;     //Last recorded site page viewed
       /**
        * Note: referrer should really only be considered the actual
        * page referrer in process.php, any other time it may be
        * inaccurate.
        */

       /* Class constructor */
       
    function Session(){
          
    $this->time time();
          
    $this->startSession();
       }

       
    /**
        * startSession - Performs all the actions necessary to 
        * initialize this session object. Tries to determine if the
        * the user has logged in already, and sets the variables 
        * accordingly. Also takes advantage of this page load to
        * update the active visitors tables.
        */
       
    function startSession(){
          global 
    $database;  //The database connection
          
    session_start();   //Tell PHP to start the session

          /* Determine if user is logged in */
          
    $this->logged_in $this->checkLogin();

          
    /**
           * Set guest value to users not logged in, and update
           * active guests table accordingly.
           */
          
    if(!$this->logged_in){
             
    $this->username $_SESSION['username'] = GUEST_NAME;
             
    $this->userlevel GUEST_LEVEL;
             
    $database->addActiveGuest($_SERVER['REMOTE_ADDR'], $this->time);
          }
          
    /* Update users last active timestamp */
          
    else{
             
    $database->addActiveUser($this->username$this->time);
          }
          
          
    /* Remove inactive visitors from database */
          
    $database->removeInactiveUsers();
          
    $database->removeInactiveGuests();
          
          
    /* Set referrer page */
          
    if(isset($_SESSION['url'])){
             
    $this->referrer $_SESSION['url'];
          }else{
             
    $this->referrer "/";
          }

          
    /* Set current url */
          
    $this->url $_SESSION['url'] = $_SERVER['PHP_SELF'];
       }

       
    /**
        * checkLogin - Checks if the user has already previously
        * logged in, and a session with the user has already been
        * established. Also checks to see if user has been remembered.
        * If so, the database is queried to make sure of the user's 
        * authenticity. Returns true if the user has logged in.
        */
       
    function checkLogin(){
          global 
    $database;  //The database connection
          /* Check if user has been remembered */
          
    if(isset($_COOKIE['cookname']) && isset($_COOKIE['cookid'])){
             
    $this->username $_SESSION['username'] = $_COOKIE['cookname'];
             
    $this->userid   $_SESSION['userid']   = $_COOKIE['cookid'];
          }

          
    /* Username and userid have been set and not guest */
          
    if(isset($_SESSION['username']) && isset($_SESSION['userid']) &&
             
    $_SESSION['username'] != GUEST_NAME){
             
    /* Confirm that username and userid are valid */
             
    if($database->confirmUserID($_SESSION['username'], $_SESSION['userid']) != 0){
                
    /* Variables are incorrect, user not logged in */
                
    unset($_SESSION['username']);
                unset(
    $_SESSION['userid']);
                return 
    false;
             }

             
    /* User is logged in, set class variables */
             
    $this->userinfo  $database->getUserInfo($_SESSION['username']);
             
    $this->username  $this->userinfo['username'];
             
    $this->userid    $this->userinfo['userid'];
             
    $this->userlevel $this->userinfo['userlevel'];
             return 
    true;
          }
          
    /* User not logged in */
          
    else{
             return 
    false;
          }
       }

       
    /**
        * login - The user has submitted his username and password
        * through the login form, this function checks the authenticity
        * of that information in the database and creates the session.
        * Effectively logging in the user if all goes well.
        */
       
    function login($subuser$subpass$subremember){
          global 
    $database$form;  //The database and form object

          /* Username error checking */
          
    $field "user";  //Use field name for username
          
    if(!$subuser || strlen($subuser trim($subuser)) == 0){
             
    $form->setError($field"* Username not entered");
          }
          else{
             
    /* Check if username is not alphanumeric */
             
    if(!eregi("^([0-9a-z])*$"$subuser)){
                
    $form->setError($field"* Username not alphanumeric");
             }
          }

          
    /* Password error checking */
          
    $field "pass";  //Use field name for password
          
    if(!$subpass){
             
    $form->setError($field"* Password not entered");
          }
          
          
    /* Return if form errors exist */
          
    if($form->num_errors 0){
             return 
    false;
          }

          
    /* Checks that username is in database and password is correct */
          
    $subuser stripslashes($subuser);
          
    $result $database->confirmUserPass($subusermd5($subpass));

          
    /* Check error codes */
          
    if($result == 1){
             
    $field "user";
             
    $form->setError($field"* Username or Password are invalid");
          }
          else if(
    $result == 2){
             
    $field "pass";
             
    $form->setError($field"* Username or Password are invalid");
          }
          else if(
    $result == 3){
            
    $field "user";
          
    $form->setError($field"* Your account has not been activated yet");
          }
          
    /*Error handling for banned users*/
          
    else if($result == 4){
          
    $field "user";
          
    $form->setError($field"Your account has been banned");
          }
          
          
    /* Return if form errors exist */
          
    if($form->num_errors 0){
             return 
    false;
          }

          
    /* Username and password correct, register session variables */
          
    $this->userinfo  $database->getUserInfo($subuser);
          
    $this->username  $_SESSION['username'] = $this->userinfo['username'];
          
    $this->userid    $_SESSION['userid']   = $this->generateRandID();
          
    $this->userlevel $this->userinfo['userlevel'];
          
          
    /* Insert userid into database and update active users table */
          
    $database->updateUserField($this->username"userid"$this->userid);
          
    $database->addActiveUser($this->username$this->time);
          
    $database->removeActiveGuest($_SERVER['REMOTE_ADDR']);

          
    /**
           * This is the cool part: the user has requested that we remember that
           * he's logged in, so we set two cookies. One to hold his username,
           * and one to hold his random value userid. It expires by the time
           * specified in constants.php. Now, next time he comes to our site, we will
           * log him in automatically, but only if he didn't log out before he left.
           */
          
    if($subremember){
             
    setcookie("cookname"$this->usernametime()+COOKIE_EXPIRECOOKIE_PATH);
             
    setcookie("cookid",   $this->userid,   time()+COOKIE_EXPIRECOOKIE_PATH);
          }

          
    /* Login completed successfully */
          
    return true;
       }

       
    /**
        * logout - Gets called when the user wants to be logged out of the
        * website. It deletes any cookies that were stored on the users
        * computer as a result of him wanting to be remembered, and also
        * unsets session variables and demotes his user level to guest.
        */
       
    function logout(){
          global 
    $database;  //The database connection
          /**
           * Delete cookies - the time must be in the past,
           * so just negate what you added when creating the
           * cookie.
           */
          
    if(isset($_COOKIE['cookname']) && isset($_COOKIE['cookid'])){
             
    setcookie("cookname"""time()-COOKIE_EXPIRECOOKIE_PATH);
             
    setcookie("cookid",   ""time()-COOKIE_EXPIRECOOKIE_PATH);
          }

          
    /* Unset PHP session variables */
          
    unset($_SESSION['username']);
          unset(
    $_SESSION['userid']);

          
    /* Reflect fact that user has logged out */
          
    $this->logged_in false;
          
          
    /**
           * Remove from active users table and add to
           * active guests tables.
           */
          
    $database->removeActiveUser($this->username);
          
    $database->addActiveGuest($_SERVER['REMOTE_ADDR'], $this->time);
          
          
    /* Set user level to guest */
          
    $this->username  GUEST_NAME;
          
    $this->userlevel GUEST_LEVEL;
       }

       
    /**
        * register - Gets called when the user has just submitted the
        * registration form. Determines if there were any errors with
        * the entry fields, if so, it records the errors and returns
        * 1. If no errors were found, it registers the new user and
        * returns 0. Returns 2 if registration failed.
        */
       
    function register($subuser$subpass$subemail$subcountry){
          global 
    $database$form$mailer;  //The database, form and mailer object
          
          /* Username error checking */
          
    $field "user";  //Use field name for username
          
    if(!$subuser || strlen($subuser trim($subuser)) == 0){
             
    $form->setError($field"* Username not entered");
          }
          else{
             
    /* Spruce up username, check length */
             
    $subuser stripslashes($subuser);
             if(
    strlen($subuser) < 4){
                
    $form->setError($field"* Username below 4 characters");
             }
             else if(
    strlen($subuser) > 30){
                
    $form->setError($field"* Username above 30 characters");
             }
             
    /* Check if username is not alphanumeric */
             
    else if(!eregi("^([0-9a-z])+$"$subuser)){
                
    $form->setError($field"* Username not alphanumeric");
             }
             
    /* Check if username is reserved */
             
    else if(strcasecmp($subuserGUEST_NAME) == 0){
                
    $form->setError($field"* Username reserved word");
             }
             
    /* Check if username is already in use */
             
    else if($database->usernameTaken($subuser)){
                
    $form->setError($field"* Username already in use");
             }
             
    /* Check if username is banned */
             
    else if($database->usernameBanned($subuser)){
                
    $form->setError($field"* Username banned");
             }
          }

          
    /* Password error checking */
          
    $field "pass";  //Use field name for password
          
    if(!$subpass){
             
    $form->setError($field"* Password not entered");
          }
          else{
             
    /* Spruce up password and check length*/
             
    $subpass stripslashes($subpass);
             if(
    strlen($subpass) < 4){
                
    $form->setError($field"* Password too short");
             }
             
    /* Check if password is not alphanumeric */
             
    else if(!eregi("^([0-9a-z])+$", ($subpass trim($subpass)))){
                
    $form->setError($field"* Password not alphanumeric");
             }
             
    /**
              * Note: I trimmed the password only after I checked the length
              * because if you fill the password field up with spaces
              * it looks like a lot more characters than 4, so it looks
              * kind of stupid to report "password too short".
              */
          
    }
          
          
    /* Email error checking */
          
    $field "email";  //Use field name for email
          
    if(!$subemail || strlen($subemail trim($subemail)) == 0){
             
    $form->setError($field"* Email not entered");
          }
          else{
             
    /* Check if valid email address */
             
    $regex "^[_+a-z0-9-]+(\.[_+a-z0-9-]+)*"
                     
    ."@[a-z0-9-]+(\.[a-z0-9-]{1,})*"
                     
    ."\.([a-z]{2,}){1}$";
             if(!
    eregi($regex,$subemail)){
                
    $form->setError($field"* Email invalid");
             }
             
    $subemail stripslashes($subemail);
          }
          
          
    /*Country error checking */
          
    $field "country"
          if(
    $subcountry == ''$form->setError($field"* Starting Location not entered"); 
          

          
    /* Errors exist, have user correct them */
          
    if($form->num_errors 0){
             return 
    1;  //Errors with form
          
    }
          
          
    /* No errors, add the new account to the database */
          
    else{
             if(
    $database->addNewUser($subusermd5($subpass), $subemail$faction$subcountry$bannedby$profile$funds$xp)){

               
    $num rand(19999999999);
              
    $file "activation/".$num.".".$subuser.".php";
               
    $content "<?php\n\n"
                        
    'require_once \'../include/constants.php\';' "\n\n"
                        
    '$link = mysql_connect(DB_SERVER,DB_USER,DB_PASS) or die(mysql_error());' "\n\n"
                        
    'mysql_select_db(DB_NAME,$link) or die(mysql_error());' "\n\n"
                        
    '$q = "UPDATE `users` SET `userlevel` = 3 WHERE `username` = \'' .$subuser"'\";\n\n"
                        
    'mysql_query($q, $link);' "\n\n"
                        
    'header("Location: ../main.php")' "\n\n"
                        
    '?>';

             if(
    $fp fopen($file'a')){
             
    fwrite($fp$content."\n");
             
    fclose($fp);
                  }

                if(
    EMAIL_WELCOME){
              
    $mailer->sendWelcome($subuser,$subemail,$subpass,$file);
               }
               return 
    0;  //New user added succesfully
             
    }else{
               return 
    2;  //Registration attempt failed
            
    }
          }
          }        
               function 
    getRank(){
                  global 
    $database;
                   
    $req_user_info $database->getUserInfo($this->username);
                      
    $username $req_user_info['username'];
                     
    $query mysql_query("SELECT * FROM users WHERE username='$username' LIMIT 1");
                     
    $info mysql_fetch_object($query);
                          
    //Admin Defined Ranks
                          
    if (($info->rank == "Comrade") && ($info->xp >= "800")){ $newrank="Hero"$done="1"; }
                        elseif ((
    $info->rank == "Hero") && ($info->xp >= "1200")){ $newrank="Stalin"$done="1"; }
                            
                if (!
    $done){ $done="0"; }
                if (
    $done == "1"){$newxp $info->xp 0;
                    
    mysql_query("UPDATE `users` SET `rank` = '{$newrank}' , `xp` = '{$newxp}' WHERE `username` = '{$username}' LIMIT 1");
                }}
                
                    
             
    /* Display User's Stats function */
               
    function getStats(){
                  global 
    $database;
                  
    $req_user_info $database->getUserInfo($this->username);
                      
    /* Country */
                      
    foreach (countryArray() as $key => $country){
                     if(
    $req_user_info['country'] == $key){
                        echo 
    " <strong>Location:</strong> ".$country.""
                            
    ." | <strong>Rank:</strong> ".$req_user_info['rank']." "
                            
    ."| <b>Health:</b> 100% | <b>Faction:</b> ".$req_user_info['faction']." "
                            
    ."| <b>Funds:</b> &pound;".$req_user_info['funds']." |"
                            
    ." <b>Bullets:</b> 0 | <b>Credits:</b> 0 |";
                     }
                    }
                   }
                
                function 
    totalMoney(){
                     
    $query "SELECT username, SUM(funds) FROM users"
                     
    $result mysql_query($query) or die(mysql_error());
                    
                        
    // Print out result
                            
    while($row mysql_fetch_array($result)){
                            echo 
    "&pound;".$row['SUM(funds)']."";
                                } }
                                
        
    //Edit user's account                
       
    function editAccount($subcurpass$subnewpass$subemail$subcountry){
          global 
    $database$form;  //The database and form object
          /* New password entered */
          
    if($subnewpass){
             
    /* Current Password error checking */
             
    $field "curpass";  //Use field name for current password
             
    if(!$subcurpass){
                
    $form->setError($field"* Current Password not entered");
             }
             else{
                
    /* Check if password too short or is not alphanumeric */
                
    $subcurpass stripslashes($subcurpass);
                if(
    strlen($subcurpass) < ||
                   !
    eregi("^([0-9a-z])+$", ($subcurpass trim($subcurpass)))){
                   
    $form->setError($field"* Current Password incorrect");
                }
                
    /* Password entered is incorrect */
                
    if($database->confirmUserPass($this->username,md5($subcurpass)) != 0){
                   
    $form->setError($field"* Current Password incorrect");
                }
             }
             
             
    /* New Password error checking */
             
    $field "newpass";  //Use field name for new password
             /* Spruce up password and check length*/
             
    $subpass stripslashes($subnewpass);
             if(
    strlen($subnewpass) < 4){
                
    $form->setError($field"* New Password too short");
             }
             
    /* Check if password is not alphanumeric */
             
    else if(!eregi("^([0-9a-z])+$", ($subnewpass trim($subnewpass)))){
                
    $form->setError($field"* New Password not alphanumeric");
             }
          }
          
    /* Change password attempted */
          
    else if($subcurpass){
             
    /* New Password error reporting */
             
    $field "newpass";  //Use field name for new password
             
    $form->setError($field"* New Password not entered");
          }
          
          
          
    /* Email error checking */
          
    $field "email";  //Use field name for email
          
    if($subemail && strlen($subemail trim($subemail)) > 0){
             
    /* Check if valid email address */
             
    $regex "^[_+a-z0-9-]+(\.[_+a-z0-9-]+)*"
                     
    ."@[a-z0-9-]+(\.[a-z0-9-]{1,})*"
                     
    ."\.([a-z]{2,}){1}$";
             if(!
    eregi($regex,$subemail)){
                
    $form->setError($field"* Email invalid");
             }
             
    $subemail stripslashes($subemail);
          }
          
          
    /* Errors exist, have user correct them */
          
    if($form->num_errors 0){
             return 
    false;  //Errors with form
          
    }
          
          
    /* Update password since there were no errors */
          
    if($subcurpass && $subnewpass){
             
    $database->updateUserField($this->username,"password",md5($subnewpass));
          }
          
          
    /* Change Email */
          
    if($subemail){
             
    $database->updateUserField($this->username,"email",$subemail);
          }
          
          
    /* Change Location via Airport */
          
    if($subcountry$database->updateUserField($this->username,"country",$subcountry);
          
          
    /* Success! */
          
    return true;
       }
         
       
    /**
        * isAdmin - Returns true if currently logged in user is
        * an administrator, false otherwise.
        */
       
    function isAdmin(){
          return (
    $this->userlevel == ADMIN_LEVEL ||
                  
    $this->username  == ADMIN_NAME);
       }
       
       
    /**
        * generateRandID - Generates a string made up of randomized
        * letters (lower and upper case) and digits and returns
        * the md5 hash of it to be used as a userid.
        */
       
    function generateRandID(){
          return 
    md5($this->generateRandStr(16));
       }
       
       
    /**
        * generateRandStr - Generates a string made up of randomized
        * letters (lower and upper case) and digits, the length
        * is a specified parameter.
        */
       
    function generateRandStr($length){
          
    $randstr "";
          for(
    $i=0$i<$length$i++){
             
    $randnum mt_rand(0,61);
             if(
    $randnum 10){
                
    $randstr .= chr($randnum+48);
             }else if(
    $randnum 36){
                
    $randstr .= chr($randnum+55);
             }else{
                
    $randstr .= chr($randnum+61);
             }
          }
          return 
    $randstr;
       }
    };


    /**
     * Initialize session object - This must be initialized before
     * the form object because the form uses session variables,
     * which cannot be accessed unless the session has started.
     */
    $session = new Session;

    /* Initialize form object */
    $form = new Form;

    ?>
    my mysql database which getRank() is refering to:


  • #2
    Regular Coder
    Join Date
    Dec 2008
    Posts
    133
    Thanks
    15
    Thanked 0 Times in 0 Posts
    I just don't know why its not working and changing the "rank" database entry when the required xp is met?

  • #3
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    To debug, throw in some echo and print_r() statements to echo the relevant values.

  • #4
    Regular Coder
    Join Date
    Dec 2008
    Posts
    133
    Thanks
    15
    Thanked 0 Times in 0 Posts
    they update a mysql database so how could i debug using echo?

  • #5
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    At this point you don't even know for sure if your queries worked, because you're not checking the results. You should check the results of every query you run.

    Use print_r to echo the $info object. Make sure it's what you expect it to be.

    Echo $username, make sure it's what you expect.

    Echo $done at each stage, prior to the "if" statement(s). See if the value of $done is what you expect.

    Put an echo inside each "if" statement to see which one evaluates to "true" (if any of them do).

    Echo mysql_affected_rows() after the UPDATE.

  • #6
    Regular Coder
    Join Date
    Dec 2008
    Posts
    133
    Thanks
    15
    Thanked 0 Times in 0 Posts
    ok thanks for the tips i'll try them out tonight


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •