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
    Banned
    Join Date
    May 2008
    Posts
    105
    Thanks
    9
    Thanked 0 Times in 0 Posts

    NEED ANSWER! Don't know what is happening

    Hello.

    I am having a problem with a login script, on the database.php file, this is part of the code that is going wrong:

    Here is the code that i got it from:

    PHP Code:
    /* Class constructor */
       
    function MySQLDB(){
          
    /* Make connection to database */
          
    $this->connection mysql_connect(DB_SERVERDB_USERDB_PASS) or die(mysql_error());
          
    mysql_select_db(DB_NAME$this->connection) or die(mysql_error()); 
    (That is not all of the code, it is just part of it)

    and here is what i inserted:

    PHP Code:
    /* Class constructor */
       
    function MySQLDB(){
          
    /* Make connection to database */
          
    $this->connection mysql_connect(MY INFORMATION) or die(mysql_error());
          
    mysql_select_db(DB_NAME$this->connection) or die(mysql_error()); 
    (That is not all of the code, it is just part of it)

    So can anyone see a fault? Because that is the right information...

    Thanks in advance
    9homie

    P.s. If you want the WHOLE of MY code, then here it is:

    PHP Code:
    <?
    /**
     * Database.php
     * 
     * The Database class is meant to simplify the task of accessing
     * information from the website's database.
     *
     * Written by: Jpmaster77 a.k.a. The Grandmaster of C++ (GMC)
     * Last Updated: August 17, 2004
     */
    include("constants.php");
          
    class 
    MySQLDB
    {
       var 
    $connection;         //The MySQL database connection
       
    var $num_active_users;   //Number of active users viewing site
       
    var $num_active_guests;  //Number of active guests viewing site
       
    var $num_members;        //Number of signed-up users
       /* Note: call getNumMembers() to access $num_members! */

       /* Class constructor */
       
    function MySQLDB(){
          
    /* Make connection to database */
          
    $this->connection mysql_connect(MY_INFORMATION) or die(mysql_error());
          
    mysql_select_db(DB_NAME$this->connection) or die(mysql_error());
          
          
    /**
           * Only query database to find out number of members
           * when getNumMembers() is called for the first time,
           * until then, default value set.
           */
          
    $this->num_members = -1;
          
          if(
    TRACK_VISITORS){
             
    /* Calculate number of users at site */
             
    $this->calcNumActiveUsers();
          
             
    /* Calculate number of guests at site */
             
    $this->calcNumActiveGuests();
          }
       }

       
    /**
        * confirmUserPass - Checks whether or not the given
        * username is in the database, if so it checks if the
        * given password is the same password in the database
        * for that user. If the user doesn't exist or if the
        * passwords don't match up, it returns an error code
        * (1 or 2). On success it returns 0.
        */
       
    function confirmUserPass($username$password){
          
    /* Add slashes if necessary (for query) */
          
    if(!get_magic_quotes_gpc()) {
              
    $username addslashes($username);
          }

          
    /* Verify that user is in database */
          
    $q "SELECT password FROM ".TBL_USERS." WHERE username = '$username'";
          
    $result mysql_query($q$this->connection);
          if(!
    $result || (mysql_numrows($result) < 1)){
             return 
    1//Indicates username failure
          
    }

          
    /* Retrieve password from result, strip slashes */
          
    $dbarray mysql_fetch_array($result);
          
    $dbarray['password'] = stripslashes($dbarray['password']);
          
    $password stripslashes($password);

          
    /* Validate that password is correct */
          
    if($password == $dbarray['password']){
             return 
    0//Success! Username and password confirmed
          
    }
          else{
             return 
    2//Indicates password failure
          
    }
       }
       
       
    /**
        * confirmUserID - Checks whether or not the given
        * username is in the database, if so it checks if the
        * given userid is the same userid in the database
        * for that user. If the user doesn't exist or if the
        * userids don't match up, it returns an error code
        * (1 or 2). On success it returns 0.
        */
       
    function confirmUserID($username$userid){
          
    /* Add slashes if necessary (for query) */
          
    if(!get_magic_quotes_gpc()) {
              
    $username addslashes($username);
          }

          
    /* Verify that user is in database */
          
    $q "SELECT userid FROM ".TBL_USERS." WHERE username = '$username'";
          
    $result mysql_query($q$this->connection);
          if(!
    $result || (mysql_numrows($result) < 1)){
             return 
    1//Indicates username failure
          
    }

          
    /* Retrieve userid from result, strip slashes */
          
    $dbarray mysql_fetch_array($result);
          
    $dbarray['userid'] = stripslashes($dbarray['userid']);
          
    $userid stripslashes($userid);

          
    /* Validate that userid is correct */
          
    if($userid == $dbarray['userid']){
             return 
    0//Success! Username and userid confirmed
          
    }
          else{
             return 
    2//Indicates userid invalid
          
    }
       }
       
       
    /**
        * usernameTaken - Returns true if the username has
        * been taken by another user, false otherwise.
        */
       
    function usernameTaken($username){
          if(!
    get_magic_quotes_gpc()){
             
    $username addslashes($username);
          }
          
    $q "SELECT username FROM ".TBL_USERS." WHERE username = '$username'";
          
    $result mysql_query($q$this->connection);
          return (
    mysql_numrows($result) > 0);
       }
       
       
    /**
        * usernameBanned - Returns true if the username has
        * been banned by the administrator.
        */
       
    function usernameBanned($username){
          if(!
    get_magic_quotes_gpc()){
             
    $username addslashes($username);
          }
          
    $q "SELECT username FROM ".TBL_BANNED_USERS." WHERE username = '$username'";
          
    $result mysql_query($q$this->connection);
          return (
    mysql_numrows($result) > 0);
       }
       
       
    /**
        * addNewUser - Inserts the given (username, password, email)
        * info into the database. Appropriate user level is set.
        * Returns true on success, false otherwise.
        */
       
    function addNewUser($username$password$email){
          
    $time time();
          
    /* If admin sign up, give admin user level */
          
    if(strcasecmp($usernameADMIN_NAME) == 0){
             
    $ulevel ADMIN_LEVEL;
          }else{
             
    $ulevel USER_LEVEL;
          }
          
    $q "INSERT INTO ".TBL_USERS." VALUES ('$username', '$password', '0', $ulevel, '$email', $time)";
          return 
    mysql_query($q$this->connection);
       }
       
       
    /**
        * updateUserField - Updates a field, specified by the field
        * parameter, in the user's row of the database.
        */
       
    function updateUserField($username$field$value){
          
    $q "UPDATE ".TBL_USERS." SET ".$field." = '$value' WHERE username = '$username'";
          return 
    mysql_query($q$this->connection);
       }
       
       
    /**
        * getUserInfo - Returns the result array from a mysql
        * query asking for all information stored regarding
        * the given username. If query fails, NULL is returned.
        */
       
    function getUserInfo($username){
          
    $q "SELECT * FROM ".TBL_USERS." WHERE username = '$username'";
          
    $result mysql_query($q$this->connection);
          
    /* Error occurred, return given name by default */
          
    if(!$result || (mysql_numrows($result) < 1)){
             return 
    NULL;
          }
          
    /* Return result array */
          
    $dbarray mysql_fetch_array($result);
          return 
    $dbarray;
       }
       
       
    /**
        * getNumMembers - Returns the number of signed-up users
        * of the website, banned members not included. The first
        * time the function is called on page load, the database
        * is queried, on subsequent calls, the stored result
        * is returned. This is to improve efficiency, effectively
        * not querying the database when no call is made.
        */
       
    function getNumMembers(){
          if(
    $this->num_members 0){
             
    $q "SELECT * FROM ".TBL_USERS;
             
    $result mysql_query($q$this->connection);
             
    $this->num_members mysql_numrows($result);
          }
          return 
    $this->num_members;
       }
       
       
    /**
        * calcNumActiveUsers - Finds out how many active users
        * are viewing site and sets class variable accordingly.
        */
       
    function calcNumActiveUsers(){
          
    /* Calculate number of users at site */
          
    $q "SELECT * FROM ".TBL_ACTIVE_USERS;
          
    $result mysql_query($q$this->connection);
          
    $this->num_active_users mysql_numrows($result);
       }
       
       
    /**
        * calcNumActiveGuests - Finds out how many active guests
        * are viewing site and sets class variable accordingly.
        */
       
    function calcNumActiveGuests(){
          
    /* Calculate number of guests at site */
          
    $q "SELECT * FROM ".TBL_ACTIVE_GUESTS;
          
    $result mysql_query($q$this->connection);
          
    $this->num_active_guests mysql_numrows($result);
       }
       
       
    /**
        * addActiveUser - Updates username's last active timestamp
        * in the database, and also adds him to the table of
        * active users, or updates timestamp if already there.
        */
       
    function addActiveUser($username$time){
          
    $q "UPDATE ".TBL_USERS." SET timestamp = '$time' WHERE username = '$username'";
          
    mysql_query($q$this->connection);
          
          if(!
    TRACK_VISITORS) return;
          
    $q "REPLACE INTO ".TBL_ACTIVE_USERS." VALUES ('$username', '$time')";
          
    mysql_query($q$this->connection);
          
    $this->calcNumActiveUsers();
       }
       
       
    /* addActiveGuest - Adds guest to active guests table */
       
    function addActiveGuest($ip$time){
          if(!
    TRACK_VISITORS) return;
          
    $q "REPLACE INTO ".TBL_ACTIVE_GUESTS." VALUES ('$ip', '$time')";
          
    mysql_query($q$this->connection);
          
    $this->calcNumActiveGuests();
       }
       
       
    /* These functions are self explanatory, no need for comments */
       
       /* removeActiveUser */
       
    function removeActiveUser($username){
          if(!
    TRACK_VISITORS) return;
          
    $q "DELETE FROM ".TBL_ACTIVE_USERS." WHERE username = '$username'";
          
    mysql_query($q$this->connection);
          
    $this->calcNumActiveUsers();
       }
       
       
    /* removeActiveGuest */
       
    function removeActiveGuest($ip){
          if(!
    TRACK_VISITORS) return;
          
    $q "DELETE FROM ".TBL_ACTIVE_GUESTS." WHERE ip = '$ip'";
          
    mysql_query($q$this->connection);
          
    $this->calcNumActiveGuests();
       }
       
       
    /* removeInactiveUsers */
       
    function removeInactiveUsers(){
          if(!
    TRACK_VISITORS) return;
          
    $timeout time()-USER_TIMEOUT*60;
          
    $q "DELETE FROM ".TBL_ACTIVE_USERS." WHERE timestamp < $timeout";
          
    mysql_query($q$this->connection);
          
    $this->calcNumActiveUsers();
       }

       
    /* removeInactiveGuests */
       
    function removeInactiveGuests(){
          if(!
    TRACK_VISITORS) return;
          
    $timeout time()-GUEST_TIMEOUT*60;
          
    $q "DELETE FROM ".TBL_ACTIVE_GUESTS." WHERE timestamp < $timeout";
          
    mysql_query($q$this->connection);
          
    $this->calcNumActiveGuests();
       }
       
       
    /**
        * query - Performs the given query on the database and
        * returns the result, which may be false, true or a
        * resource identifier.
        */
       
    function query($query){
          return 
    mysql_query($query$this->connection);
       }
    };

    /* Create database connection */
    $database = new MySQLDB;

    ?>
    Last edited by 9homie; 05-19-2008 at 07:02 PM.

  • #2
    Regular Coder
    Join Date
    Jan 2007
    Posts
    217
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Host is usually always Localhost. Try setting it to that. Also, you might want to remove your DB information from your code above in case any of the kiddies want to cause havoc to your database

  • #3
    Banned
    Join Date
    May 2008
    Posts
    105
    Thanks
    9
    Thanked 0 Times in 0 Posts
    No, it says in bold on the host people that it is NOT localhost and defiantly what i put.

  • #4
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,638
    Thanks
    2
    Thanked 404 Times in 396 Posts
    Are you getting an error?

  • #5
    Banned
    Join Date
    May 2008
    Posts
    105
    Thanks
    9
    Thanked 0 Times in 0 Posts
    *resolved On My Own*

  • #6
    Regular Coder
    Join Date
    Sep 2006
    Location
    Vermont, USA
    Posts
    154
    Thanks
    0
    Thanked 6 Times in 6 Posts
    I like that
    host is usually always localhost
    Quote of the day candidate?
    Active PHP/MySQL application developer available for immediate work.
    syosoft.com mavieo.com - Remote Web Site Administration Suite - Reseller Ready


  •  

    Posting Permissions

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