<?php
class mysql {
    var $connection;
    var $query_counter;

    function __construct($mysql_host, $mysql_username, $mysql_password, $mysql_database)
    {
        $this->connect($mysql_host, $mysql_username, $mysql_password, $mysql_database) OR DIE(mysql_error());
    }

    function __destruct()
    {
        mysql_close($this->connection);
    }

    function run($query)
    {
        $result = mysql_query($query, $this->connection) OR DIE(mysql_error());
        $this->query_counter++;
        return $result;
    }

    function connect($mysql_host, $mysql_username, $mysql_password, $mysql_database)
    {
        $this->connection = mysql_connect($mysql_host, $mysql_username, $mysql_password) OR DIE(mysql_error());
        mysql_select_db($mysql_database) OR DIE(mysql_error());
        $this->run("SET NAMES 'utf8'");
    }
}

class user_mysql extends mysql {
    function load_userdata($username, $userid)
    {
        $username = mysql_real_escape_string($username);
        $userid = mysql_real_escape_string($userid);

        $row = $this->run("SELECT
                                  users.id,
                                  users.username,
                                  users.email,
                                  users.fullname,
                                  users.active,
                                  users.admin,
                                  users.secur_hash
                                FROM
                                  users
                                WHERE
                                  users.username = '$username' AND
                                  users.id = '$id'
                                LIMIT 1");

        $result = mysql_fetch_assoc($row);
        return $result;
    }
}
?>