thomaslarsson

<?php

/**
* Database
*
* Database library using MySQLi.
*
* @package Core
* @author Lasse Brenden <lasse@pelota.no>
* @copyright (c)2012, Pelota

thomaslarsson

	/**
	* Executes a query against the database.
	*
	* @param string $query The query to be executed
	* @return mixed The result array on success, null if no data is matching and false if query fails.
	*/

	public function query ($query)
	{

thomaslarsson

prefix_access_levels
--------------------------
access_level_id		INT(2)
level 			TINYINT(1)
name 			VARCHAR(255)


prefix_groups
--------------------------
group_id 		INT(2)

thomaslarsson

<?php

/**
 * User class
 */

class User
{
	
	/**

thomaslarsson

<?php

class User
{
	private $user_id;
	private $user_email;
	private $password;
	private $user_access_key;
	private $user_access_level;
	private $user_last_active;

thomaslarsson

User object
{
    private user_id = 1;
    private user_email = 'thomas@juvenorge.com';
    private user_access_key 'ergdvzwezsfgdzesgeszwsfd';
    private user_access_level = '1'; // Administrator
    private user_last_active '2012/07/16 16:00';
    private member = Member object {
        private member_id = 1; // Could be 2, 5, 72, etc
        private date_of_registration = ''; // some date