<?php

require_once('facebook/facebook.php'); // require facebook sdk
require_once('config.class.php'); // require config class
require_once('dbconn.class.php'); //require database connector

class User
{
    /**
     * @var $userData stdClass
     * @var $_conn customSingleton
     * @var $facebook Facebook - facebook SDK
     * @var $user - Facebook user
     */
    public  $userData;
    private $_conn; // our database connection
    public  $facebook; // facebook sdk
    public  $fbuser; // the facebook user
    //Constructor

    public function __construct()
    {
        $this->_conn = DBconn::getInstance(); //get DB instance
        $this->facebook = new Facebook(Config::read('fb.facebook'));
        $this->_userData = new stdClass();
    }

    /** checkAccess
     * checks to see if user has logged in and has access to the site
     * @return bool
     */
    public function checkAccess()
    {
        //cant use if(empty(session_id)) as empty and isset both require a variable to be passed
        if(!session_id()){
            session_start(); // Start session if we don't already have one
            return (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] === true);
        }
    }

    /**
     * profileExists - Checks to see if a user profile exists
     * internal @var $PDOQuery
     * @var $PDOStatement PDOStatement
     * @throws Exception - details of PDOException
     * @return bool
     */
    private function profileExists()
    {
        try{
            /**  */
            $PDOQuery = ('SELECT count(1) FROM userprofile_upl WHERE uid_upl = :uid');
            $PDOStatement = $this->_conn->dbh->prepare($PDOQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            return $PDOStatement->fetchColumn() >0;
        }catch(PDOException $e){
            throw  new Exception('Failed to check if profile exists for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * getProfile - querys the database and stores the users profile in $userData
     * @throws Exception
     * @internal param $pdoQuery
     * @internal @var $row User
     * @internal param PDOStatement $PDOStatement
     * @throws Exception
     * @return bool
     */
    public function getProfile()
    {
        try{
            $pdoQuery = ('SELECT
                uid_upl       as`uid`,
                firstname_upl as `firstname`,
                lastname_upl  as `lastname`,
                info_upl      as `info`
                FROM userprofile_upl
                WHERE uid_upl = :uid'
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            $row = $PDOStatement->fetch(PDO::FETCH_OBJ);
            $this->_userData->firstname = $row->firstname;
            $this->_userData->lastname = $row->lastname;
            $this->_userData->info = $row->info;
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed to get Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * createProfile - Creates a user profile
     * @internal param $pdoQuery
     * @internal @var $pdoData array
     * @throws Exception
     * @return bool
     */
    private function createProfile()
    {
        try{
            //we need to add the facebook user to the profiles table
            $pdoQuery = ('INSERT INTO userprofile_upl (firstname_upl, lastname_upl, uid_upl) VALUE (:firstname, :lastname, :uid)');
            $pdoData = array(
                'firstname' => $this->_userData->firstname,
                'lastname' => $this->_userData->lastname,
                'uid' => $this->_userData->uid
            );
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed add Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * goDashboard - Redirects a logged in user to the dashboard if they are logged in
     * @return bool
     */
    public function goDashboard()
    {
        if($this->checkAccess()){
            header('Location: '.Config::read('url.dashboard'));
        }else{
            return false;
        }
    }

    /**
     * generates a facebook log-out url
     * @return String: facebook logout url
     */
    public function getLogoutUrl()
    {
        //set user logout_url
        $params = array( 'next' => config::read('url.logout'));
        $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
        return $this->_userData->logout_url;
    }

    /**
     * loginFacebook - Logs a user into the site with facebook
     * Checks to see if user has an account and if not make one.
     * Checks to see if user has a profile and if not make one.
     * Checks to see if user has facebook credentials on this site
     *
     * @throws Exception
     * @return mixed
     */
    public function loginFacebook()
    {
        $fbuser = $this->facebook->getUser();//get facebook user
        if($fbuser){// if we have a user returned we have user who's authenticated and logged in with facebook
            try { // Proceed knowing we have a user.
                $me = $this->facebook->api('/me'); // the facebook user
                //generate a log-out url

                //set user logout_url
                $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
                //set the users details
                $this->_userData->uid = $this->facebook->getUser();
                $this->_userData->firstname = $me['first_name'];
                $this->_userData->lastname = $me['last_name'];
                $this->_userData->email = $me['email'];
                $this->_userData->provider = 'facebook';
                if(!$this->fbAccountExists($this->_userData)){
                    $this->fbCreateAccount($this->_userData);
                };
                if(!$this->profileExists($this->_userData)){
                    $this->createProfile($this->_userData);
                }
                $this->setSession();
            }
            catch (FacebookApiException $e){ //if theres an error
                throw new Exception('Failed to Login to facebook '.$this->_userData->uid, 0, $e);
            }
        }
        if(!$fbuser){
            //get a login url, returns to this page so we can process the login($fblogin_url)
            $loginUrl = $this->facebook->getLoginUrl(array('redirect_uri'=>Config::read('url.fblogin'), false));
            header('Location: '.$loginUrl);//redirect to the login page
        }
    }

    /**
     * fbAccountExists - checks to see if a facebook account exists
     * @internal @var $pdoQuery
     * @internal @var $pdoStatement STRING
     * @throws Exception
     * @return bool
     */
    private function fbAccountExists()
    {
        try{
            $pdoQuery = ('SELECT count(1) FROM oauth_auth WHERE uid_auth = :uid and provider_auth = `facebook`');
            /** */
            $pdoStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStatement->bindParam(':uid', $this->_userData->uid);
            $pdoStatement->execute();
            return $pdoStatement->fetchColumn() > 0;
        }catch(PDOException $e){
            throw new Exception('Failed to check if account exists for user '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * fbCreateAccount - creates a facebook account
     * @throws Exception
     * @return bool: true/false
     */
    private function fbCreateAccount()
    {
        try{
            //we need to add the facebook user to the auth table
            $pdoQuery = ("INSERT INTO oauth_auth(email_auth, uid_auth, provider_auth) VALUE (:email, :uid, :provider)");
            $pdoData = array('email' => $this->_userData->email, 'uid' => $this->_userData->uid, 'provider' => $this->_userData->provider);
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('There was an error creating an account for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * setSession - Stores session variables to imitate user login.
     */
    function setSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        $_SESSION['loggedin'] = true;
        $this->_userData->loggedin = true;
        $_SESSION['uid'] = $this->_userData->uid;
        $_SESSION['provider'] = $this->_userData->provider;
        header('Location: '.Config::read('url.dashboard'));
    }

    /**
     * getSession - saves session vars to our user
     * @return bool: true - session retrieved
     * @redirect if no session found redirects to login page
     */
    public function getSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        if (!isset($_SESSION['loggedin']) && $_SESSION['loggedin'] != true) {//Check to see if user is logged in
            header("location: ".Config::read('url.baseurl')); // User is logged in Redirect to homepage
        }else{
            //save session to this user
            $this->_userData->loggedin = $_SESSION['loggedin'];
            $this->_userData->provider = $_SESSION['provider'];
            $this->_userData->uid = $_SESSION['uid'];
            return true;
        }
    }
}

<?php

require_once('facebook/facebook.php'); // require facebook sdk
require_once('config.class.php'); // require config class
require_once('dbconn.class.php'); //require database connector

class User
{
    /**
     * @var $userData stdClass
     * @var $_conn customSingleton
     * @var $facebook Facebook - facebook SDK
     * @var $user - Facebook user
     */
    public  $userData;
    private $_conn; // our database connection
    public  $facebook; // facebook sdk
    public  $fbuser; // the facebook user
    //Constructor

    public function __construct()
    {
        $this->_conn = DBconn::getInstance(); //get DB instance
        $this->facebook = new Facebook(Config::read('fb.facebook'));
        $this->_userData = new stdClass();
    }

    /** checkAccess
     * checks to see if user has logged in and has access to the site
     * @return bool
     */
    public function checkAccess()
    {
        //cant use if(empty(session_id)) as empty and isset both require a variable to be passed
        if(!session_id()){
            session_start(); // Start session if we don't already have one
            return (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] === true);
        }
    }

    /**
     * profileExists - Checks to see if a user profile exists
     * internal @var $PDOQuery
     * @var $PDOStatement PDOStatement
     * @throws Exception - details of PDOException
     * @return bool
     */
    private function profileExists()
    {
        try{
            /**  */
            $PDOQuery = ('SELECT count(1) FROM userprofile_upl WHERE uid_upl = :uid');
            $PDOStatement = $this->_conn->dbh->prepare($PDOQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            return $PDOStatement->fetchColumn() >0;
        }catch(PDOException $e){
            throw  new Exception('Failed to check if profile exists for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * getProfile - querys the database and stores the users profile in $userData
     * @throws Exception
     * @internal param $pdoQuery
     * @internal @var $row User
     * @internal param PDOStatement $PDOStatement
     * @throws Exception
     * @return bool
     */
    public function getProfile()
    {
        try{
            $pdoQuery = ('SELECT
                firstname_upl as `firstname`,
                lastname_upl  as `lastname`,
                info_upl      as `info`
                FROM userprofile_upl
                WHERE uid_upl = :uid'
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            $row = $PDOStatement->fetch(PDO::FETCH_OBJ);
            $this->_userData->firstname = $row->firstname;
            $this->_userData->lastname = $row->lastname;
            $this->_userData->info = $row->info;
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed to get Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * createProfile - Creates a user profile
     * @internal param $pdoQuery
     * @internal @var $pdoData array
     * @throws Exception
     * @return bool
     */
    private function createProfile()
    {
        try{
            //we need to add the facebook user to the profiles table
            $pdoQuery = ('INSERT INTO userprofile_upl (firstname_upl, lastname_upl, uid_upl) VALUE (:firstname, :lastname, :uid)');
            $pdoData = array(
                'firstname' => $this->_userData->firstname,
                'lastname' => $this->_userData->lastname,
                'uid' => $this->_userData->uid
            );
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed add Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * goDashboard - Redirects a logged in user to the dashboard if they are logged in
     * @return bool
     */
    public function goDashboard()
    {
        if($this->checkAccess()){
            header('Location: '.Config::read('url.dashboard'));
        }else{
            return false;
        }
    }

    /**
     * generates a facebook log-out url
     * @return String: facebook logout url
     */
    public function getLogoutUrl()
    {
        //set user logout_url
        $params = array( 'next' => config::read('url.logout'));
        $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
        return $this->_userData->logout_url;
    }

    /**
     * loginFacebook - Logs a user into the site with facebook
     * Checks to see if user has an account and if not make one.
     * Checks to see if user has a profile and if not make one.
     * Checks to see if user has facebook credentials on this site
     *
     * @throws Exception
     * @return mixed
     */
    public function loginFacebook()
    {
        $fbuser = $this->facebook->getUser();//get facebook user
        if($fbuser){// if we have a user returned we have user who's authenticated and logged in with facebook
            try { // Proceed knowing we have a user.
                $me = $this->facebook->api('/me'); // the facebook user
                //generate a log-out url

                //set user logout_url
                $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
                //set the users details
                $this->_userData->uid = $this->facebook->getUser();
                $this->_userData->firstname = $me['first_name'];
                $this->_userData->lastname = $me['last_name'];
                $this->_userData->email = $me['email'];
                $this->_userData->provider = 'facebook';
                if(!$this->fbAccountExists($this->_userData)){
                    $this->fbCreateAccount($this->_userData);
                };
                if(!$this->profileExists($this->_userData)){
                    $this->createProfile($this->_userData);
                }
                $this->setSession();
            }
            catch (FacebookApiException $e){ //if theres an error
                throw new Exception('Failed to Login to facebook '.$this->_userData->uid, 0, $e);
            }
        }
        if(!$fbuser){
            //get a login url, returns to this page so we can process the login($fblogin_url)
            $loginUrl = $this->facebook->getLoginUrl(array('redirect_uri'=>Config::read('url.fblogin'), false));
            header('Location: '.$loginUrl);//redirect to the login page
        }
    }

    /**
     * fbAccountExists - checks to see if a facebook account exists
     * @internal @var $pdoQuery
     * @internal @var $pdoStatement STRING
     * @throws Exception
     * @return bool
     */
    private function fbAccountExists()
    {
        try{
            $pdoQuery = ('SELECT count(1) FROM oauth_auth WHERE uid_auth = :uid and provider_auth = `facebook`');
            /** */
            $pdoStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStatement->bindParam(':uid', $this->_userData->uid);
            $pdoStatement->execute();
            return $pdoStatement->fetchColumn() > 0;
        }catch(PDOException $e){
            throw new Exception('Failed to check if account exists for user '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * fbCreateAccount - creates a facebook account
     * @throws Exception
     * @return bool: true/false
     */
    private function fbCreateAccount()
    {
        try{
            //we need to add the facebook user to the auth table
            $pdoQuery = ("INSERT INTO oauth_auth(email_auth, uid_auth, provider_auth) VALUE (:email, :uid, :provider)");
            $pdoData = array('email' => $this->_userData->email, 'uid' => $this->_userData->uid, 'provider' => $this->_userData->provider);
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('There was an error creating an account for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * setSession - Stores session variables to imitate user login.
     */
    function setSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        $_SESSION['loggedin'] = true;
        $this->_userData->loggedin = true;
        $_SESSION['uid'] = $this->_userData->uid;
        $_SESSION['provider'] = $this->_userData->provider;
        header('Location: '.Config::read('url.dashboard'));
    }

    /**
     * getSession - saves session vars to our user
     * @return bool: true - session retrieved
     * @redirect if no session found redirects to login page
     */
    public function getSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        if (!isset($_SESSION['loggedin']) && $_SESSION['loggedin'] != true) {//Check to see if user is logged in
            header("location: ".Config::read('url.baseurl')); // User is logged in Redirect to homepage
        }else{
            //save session to this user
            $this->_userData->loggedin = $_SESSION['loggedin'];
            $this->_userData->provider = $_SESSION['provider'];
            $this->_userData->uid = $_SESSION['uid'];
            return true;
        }
    }
}

again thanks for your time

<?php

require_once('facebook/facebook.php'); // require facebook sdk
require_once('config.class.php'); // require config class
require_once('dbconn.class.php'); //require database connector

class User
{
    /**
     * @var $userData stdClass
     * @var $_conn customSingleton
     * @var $facebook Facebook - facebook SDK
     * @var $user - Facebook user
     */
    public  $userData;
    private $_conn; // our database connection
    public  $facebook; // facebook sdk
    public  $fbuser; // the facebook user
    //Constructor

    public function __construct()
    {
        $this->_conn = DBconn::getInstance(); //get DB instance
        $this->facebook = new Facebook(Config::read('fb.facebook'));
        $this->_userData = new stdClass();
    }

    /** checkAccess
     * checks to see if user has logged in and has access to the site
     * @return bool
     */
    public function checkAccess()
    {
        //cant use if(empty(session_id)) as empty and isset both require a variable to be passed
        if(!session_id()){
            session_start(); // Start session if we don't already have one
            return (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] === true);
        }
    }

    /**
     * profileExists - Checks to see if a user profile exists
     * internal @var $PDOQuery
     * @var $PDOStatement PDOStatement
     * @throws Exception - details of PDOException
     * @return bool
     */
    private function profileExists()
    {
        try{
            /**  */
            $PDOQuery = ("SELECT count(*) FROM userprofile_upl WHERE uid_upl = :uid");
            $PDOStatement = $this->_conn->dbh->prepare($PDOQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            return $PDOStatement->fetchColumn() >0;
        }catch(PDOException $e){
            throw  new Exception('Failed to check if profile exists for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * getProfile - querys the database and stores the users profile in $userData
     * @throws Exception
     * @internal param $pdoQuery
     * @internal @var $row User
     * @internal param PDOStatement $PDOStatement
     * @throws Exception
     * @return bool
     */
    public function getProfile()
    {
        try{
            $pdoQuery = ('SELECT
                uid_upl       as`uid`,
                firstname_upl as `firstname`,
                lastname_upl  as `lastname`,
                info_upl      as `info`
                FROM userprofile_upl
                WHERE uid_upl = :uid'
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            $row = $PDOStatement->fetch(PDO::FETCH_OBJ);
            $this->_userData->firstname = $row->firstname;
            $this->_userData->lastname = $row->lastname;
            $this->_userData->info = $row->info;
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed to get Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * createProfile - Creates a user profile
     * @internal param $pdoQuery
     * @internal @var $pdoData array
     * @throws Exception
     * @return bool
     */
    private function createProfile()
    {
        try{
            //we need to add the facebook user to the profiles table
            $pdoQuery = ('INSERT INTO userprofile_upl (firstname_upl, lastname_upl, uid_upl) VALUE (:firstname, :lastname, :uid)');
            $pdoData = array(
                'firstname' => $this->_userData->firstname,
                'lastname' => $this->_userData->lastname,
                'uid' => $this->_userData->uid
            );
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed add Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * goDashboard - Redirects a logged in user to the dashboard if they are logged in
     * @return bool
     */
    public function goDashboard()
    {
        if($this->checkAccess()){
            header('Location: '.Config::read('url.dashboard'));
        }else{
            return false;
        }
    }

    /**
     * generates a facebook log-out url
     * @return String: facebook logout url
     */
    public function getLogoutUrl()
    {
        //set user logout_url
        $params = array( 'next' => config::read('url.logout'));
        $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
        return $this->_userData->logout_url;
    }

    /**
     * loginFacebook - Logs a user into the site with facebook
     * Checks to see if user has an account and if not make one.
     * Checks to see if user has a profile and if not make one.
     * Checks to see if user has facebook credentials on this site
     *
     * @throws Exception
     * @return mixed
     */
    public function loginFacebook()
    {
        $fbuser = $this->facebook->getUser();//get facebook user
        if($fbuser){// if we have a user returned we have user who's authenticated and logged in with facebook
            try { // Proceed knowing we have a user.
                $me = $this->facebook->api('/me'); // the facebook user
                //generate a log-out url

                //set user logout_url
                $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
                //set the users details
                $this->_userData->uid = $this->facebook->getUser();
                $this->_userData->firstname = $me['first_name'];
                $this->_userData->lastname = $me['last_name'];
                $this->_userData->email = $me['email'];
                $this->_userData->provider = 'facebook';
                if(!$this->fbAccountExists($this->_userData)){
                    $this->fbCreateAccount($this->_userData);
                };
                if(!$this->profileExists($this->_userData)){
                    $this->createProfile($this->_userData);
                }
                $this->setSession();
            }
            catch (FacebookApiException $e){ //if theres an error
                throw new Exception('Failed to Login to facebook '.$this->_userData->uid, 0, $e);
            }
        }
        if(!$fbuser){
            //get a login url, returns to this page so we can process the login($fblogin_url)
            $loginUrl = $this->facebook->getLoginUrl(array('redirect_uri'=>Config::read('url.fblogin'), false));
            header('Location: '.$loginUrl);//redirect to the login page
        }
    }

    /**
     * fbAccountExists - checks to see if a facebook account exists
     * @internal @var $pdoQuery
     * @internal @var $pdoStatement STRING
     * @throws Exception
     * @return bool
     */
    private function fbAccountExists()
    {
        try{
            $pdoQuery = ('SELECT count(*) FROM oauth_auth WHERE uid_auth = :uid and provider_auth = `facebook`');
            /** */
            $pdoStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStatement->bindParam(':uid', $this->_userData->uid);
            $pdoStatement->execute();
            return $pdoStatement->fetchColumn() > 0;
        }catch(PDOException $e){
            throw new Exception('Failed to check if account exists for user '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * fbCreateAccount - creates a facebook account
     * @throws Exception
     * @return bool: true/false
     */
    private function fbCreateAccount()
    {
        try{
            //we need to add the facebook user to the auth table
            $pdoQuery = ("INSERT INTO oauth_auth(email_auth, uid_auth, provider_auth) VALUE (:email, :uid, :provider)");
            $pdoData = array('email' => $this->_userData->email, 'uid' => $this->_userData->uid, 'provider' => $this->_userData->provider);
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('There was an error creating an account for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * setSession - Stores session variables to imitate user login.
     */
    function setSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        $_SESSION['loggedin'] = true;
        $this->_userData->loggedin = true;
        $_SESSION['uid'] = $this->_userData->uid;
        $_SESSION['provider'] = $this->_userData->provider;
        header('Location: '.Config::read('url.dashboard'));
    }

    /**
     * getSession - saves session vars to our user
     * @return bool: true - session retrieved
     * @redirect if no session found redirects to login page
     */
    public function getSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        if (!isset($_SESSION['loggedin']) && $_SESSION['loggedin'] != true) {//Check to see if user is logged in
            header("location: ".Config::read('url.baseurl')); // User is logged in Redirect to homepage
        }else{
            //save session to this user
            $this->_userData->loggedin = $_SESSION['loggedin'];
            $this->_userData->provider = $_SESSION['provider'];
            $this->_userData->uid = $_SESSION['uid'];
            return true;
        }
    }
}

<?php
/**
 * Created by Base5 Designs.
 * and Dizzy Developments
 * User: Dizzy High
 * Date: 14/04/14
 * Time: 12:08
 */

require_once('config.class.php'); // require config class
require_once('dbconn.class.php'); //require database connector

/**
 * Class Game - instance of a game
 */
class Game {
    private $_conn; // database handler
    public $gameID; // id of game
    public $name; //name of game
    public $host; // uid of game host (the game creator)
    public $playerCount; // number of players in game
    public $roundTime; //round time of game in seconds
    public $visibility; // public (1) or private game  (0)
    public $alias; // whether game players use an alias name or not (1 yes 2 no)
    public $status; //status of game (waiting, active, complete)
    public $currentRound; // current round of game (0 not started, odd day, even night)
    public $startTime; // datetime - start time of game
    public $createdTime; // datetime date game created

    /**
     * Init class with Database Connection
     */
    function __construct(){
        $this->_conn = DBconn::getInstance(); //get DB instance
    }

    /**
     * assignSettings - assigns settings to game instance
     * @param $name - property name
     * @param $value - property value
     */
    function assignSetting($name, $value){
        $whitelist = array('id', 'name', 'host', 'playerCount', 'roundTime', 'visibility', 'alias', 'status', 'currentRound', 'startTime', 'createdTime');
        if (in_array($name, $whitelist)) {
            $property = $name;
            $this->$property = $value;
        }
    }

    /**
     * makeGame - creates a new game and adds it to the database with the defined settings
     * @param  array(): $settings- game settings for this game instance
     * @var $pdoQuery STRING
     * @var $pdoData array() - array of column and values to update
     * @var $PDOStatement
     * @return Game - this game instance
     * @throws PDOException - failed to run the pdo statement
     * @throws Exception  - throws the exception from the PDOException
     */
    function makeGame($settings){
        if (is_array($settings)) {
            foreach($settings as $k=>$v)  {
                $this->assignSetting($k, $v);
            }
        } else {
            die('Config Error!');
        }
        try{
            //add the game to the games table

            $pdoQuery = ('INSERT INTO games_gam (name_gam, host_gam, playercount_gam, roundtime_gam, visibility_gam, alias_gam) VALUE (:gameName, :gameHost, :playerCount, :roundTime, :visibility, :alias)');
            $pdoData = array(
                'gameName' => $this->name,
                'gameHost' => $this->host,
                'playerCount' => $this->playerCount,
                'roundTime' => $this->roundTime,
                'visibility' => $this->visibility,
                'alias' => $this->alias
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->execute($pdoData);
            $this->gameID = $this->_conn->dbh->lastInsertId();
            //add creator to game
            $this->addPlayer($this->host);
            return $this;
        }catch(PDOException $e){
            throw new Exception('There was an error creating a new game ', 0, $e);
        }
    }

    /**
     * getGame - queries the database and stores the results in this game instance
     * @param $gameID - the id of the game to fetch from the database
     * @var $pdoQuery STRING
     * @var $pdoData array() - array of column and values to update
     * @var $row PDORow
     * @return Game - this game instance
     * @throws PDOException - failed to run the pdo statement
     * @throws Exception  - throws the exception from the PDOException
     */
    function getGame($gameID){
        try{
            $pdoQuery = ('SELECT
                id_gam as `id`,
                name_gam as `name`,
                host_gam as `host`,
                playercount_gam as `playerCount`,
                roundtime_gam as `roundTime`,
                visibility_gam as `visibility`,
                status_gam as `status`,
                alias_gam as `alias`,
                starttime_gam as `startTime`,
                createdtime_gam as `createdTime`
                FROM games_gam
                WHERE id_gam = :id'
            );
            $PDOStatemnet = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatemnet->bindParam(':id', $gameID);
            $PDOStatemnet->execute();
            $row = $PDOStatemnet->fetch(PDO::FETCH_OBJ);
            $this->gameID = $row->id;
            $this->name = $row->name;
            $this->host = $row->host;
            $this->playerCount = $row->playerCount;
            $this->roundTime = $row->roundTime;
            $this->visibility = $row->visibility;
            $this->status = $row->status;
            $this->alias = $row->alias;
            $this->startTime = $row->startTime;
            $this->createdTime = $row->createdTime;
            return $this;
        }catch(PDOException $e){
            throw new Exception('There was an error getting the game: '.$gameID, 0, $e);
        }
    }

    /**
     * addPlayer - adds player to a game
     * @param $uid - uid of player
     * @return bool
     * @throws PDOException
     * @throws Exception
     */
    function addPlayer($uid){
        if(!$this->playerInGame($uid)){
            try{
                $pdoQuery = ('INSERT INTO gameplayers_gpl (idgam_gpl, uid_gpl) VALUE (:idgam, :uid)');
                $pdoData = array(
                    ':idgam' => $this->gameID,
                    ':uid' => $uid
                );
                $stmt = $this->_conn->dbh->prepare($pdoQuery);
                $stmt->execute($pdoData);
                return true;
            }catch(PDOException $e){
                throw new Exception('There was an error adding user '.$uid.' to the game', 0, $e);
            }
        }
    }

    /**
     * leaveGame - Removes a player from a game
     * @param $uid - the uid of the player
     * @throws Exception
     * @internal param $gameID - the id of the game
     * @return $this
     */
    function leaveGame($uid){
        if($this->playerInGame($uid)){
            try{
                $pdoQuery = ('DELETE FROM gameplayers_gpl WHERE uid_gpl = :uid AND idgam_gpl = :id');
                $pdoData = array(
                    ':uid' => $uid,
                    ':id'=> $this->$gameID
                );
                $stmt = $this->_conn->dbh->prepare($pdoQuery);
                $stmt->execute($pdoData);
                return $this;
            }catch(PDOException $e){
                throw new Exception('There was an error removing the user '.$uid.' from the game '.$this->gameID, 0, $e);
            }
        }
    }

    /**
     * gameFull - checks to see if a game has all player slots filled
     * @internal $pdoQuery STRING
     * @internal $PDOStatement PDOStatement
     * @throws Exception
     * @return bool true: game is full
     * @return bool false: has slots
     */
    function gameFull(){
        try{
            $pdoQuery = ('SELECT count(*) FROM gameplayers_gpl WHERE idgam_gpl = :gameID');
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->bindParam(':gameID', $this->gameID);
            $PDOStatement->execute();
            $rowCount = (int) $PDOStatement->fetchColumn();
            return $rowCount < $this->playerCount;
        }catch(PDOException $e){
            throw new Exception('There was an error while checking if the game  '.$this->gameID.' was full', 0, $e);
        }
    }

    /**
     * playerInGame - checks to see if a player in the game
     * @param $uid: id of user
     * @internal @var $pdoQuery String
     * @internal @var $PDOStatement
     * @internal @var $pdoData array
     * @throws Exception
     * @return bool
     */
    function playerInGame($uid){
        try{
            $pdoQuery = ('SELECT count(*) FROM gameplayers_gpl WHERE idgam_gpl = :gameID AND uid_gpl = :uid');
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoData = array(
                ':uid' => $uid,
                ':gameID'=> $this->gameID,
            );
            $PDOStatement->execute($pdoData);
            $rowCount = (int) $PDOStatement->fetchColumn();
            return $rowCount > 0;
        }catch(PDOException $e){
            throw new Exception('There was an error while checking if '.$uid.' is in game  '.$this->gameID, 0, $e);
        }
    }

    /**
     * @param $roundtime int - roundtime in seconds
     * @return array
     * @throws Exception
     */
    function getGamesList($roundtime){
        try{
            $pdoQuery = ('SELECT
                id_gam as `id`,
                name_gam as `name`,
                host_gam as `host`,
                playercount_gam as `playerCount`,
                roundtime_gam as `roundTime`,
                visibility_gam as `visibility`,
                status_gam as `status`,
                alias_gam as `alias`,
                starttime_gam as `startTime`,
                createdtime_gam as `createdTime`
                FROM games_gam
                WHERE visibility_gam = :visibility AND roundtime_gam = :roundtime AND status_gam = :gamestatus'
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoData = array(
                'visibility' => 0,
                'roundtime' => $roundtime,
                'gamestatus' => 'waiting',
            );
            $PDOStatement->execute($pdoData);
            return $PDOStatement->fetchAll();
        }catch(PDOException $e){
            throw new Exception('There was an error while getting the games list  ', 0, $e);
        }

    }
    /**
     * Convert number of seconds into years, days, hours, minutes and seconds
     * and return an string containing those values
     * the value of seconds could be greater than 1 day so unable to use phps datetime function
     * @param integer $seconds: Number of seconds to parse
     * @return string
     */
    function secondsToTime($seconds){
        $y = floor($seconds / (86400*365.25));
        $d = floor(($seconds - ($y*(86400*365.25))) / 86400);
        $h = gmdate('H', $seconds);
        $m = gmdate('i', $seconds);
        $s = gmdate('s', $seconds);

        $string = '';

        if($y > 0){
            $yw = $y > 1 ? ' years ' : ' year ';
            $string .= $y . $yw;
        }
        if($d > 0){
            $dw = $d > 1 ? ' days ' : ' day ';
            $string .= $d . $dw;
        }
        if($h > 0){
            $hw = $h > 1 ? ' hours ' : ' hour ';
            $string .= $h . $hw;
        }
        if($m > 0){
            $mw = $m > 1 ? ' minutes ' : ' minute ';
            $string .= $m . $mw;
        }
        if($s > 0){
            $sw = $s > 1 ? ' seconds ' : ' second ';
            $string .= $s . $sw;
        }

        return preg_replace('/\s+/',' ',$string);
    }

    function getHost($gameID){

    }
    function initGame(){

    }

    function processVotes(){

    }

    function setPlayerRole($uid, $role){


    }

    function getPlayerRole(){

    }

    function getPlayerHealth(){

    }

    function getGameDay(){

    }

    function getGameVotes(){

    }

<?php
//php class for connecting to database

require_once('config.class.php');
class DBConn
{        use PDO
    public $dbh; // handle of the db connexion
    private static $instance;

    private function __construct()
    {

        // building data source name from config
        $dsn =  Config::read('db.dsn');
        // getting DB username from config
        $user = Config::read('db.user');
        // getting DB password from config                
        $password = Config::read('db.password');
        // set database handler
        $this->dbh = new PDO($dsn, $user, $password);
    }

    /**
     * getInstance
     * creayes a singleton of a pdo connection
     * @return DBConn
     */
    public static function getInstance()
    {
        if (!isset(self::$instance))
        {
            $object = __CLASS__;
            self::$instance = new $object;
        }
        return self::$instance;
    }
}

<?php

require_once('facebook/facebook.php'); // require facebook sdk
require_once('config.class.php'); // require config class
require_once('dbconn.class.php'); //require database connector

class User
{
    /**
     * @var $userData stdClass
     * @var $_conn customSingleton
     * @var $facebook Facebook - facebook SDK
     * @var $user - Facebook user
     */
    public  $userData;
    private $_conn; // our database connection
    public  $facebook; // facebook sdk
    public  $fbuser; // the facebook user
    //Constructor

    public function __construct()
    {
        $this->_conn = DBconn::getInstance(); //get DB instance
        $this->facebook = new Facebook(Config::read('fb.facebook'));
        $this->_userData = new stdClass();
    }

    /** checkAccess
     * checks to see if user has logged in and has access to the site
     * @return bool
     */
    public function checkAccess()
    {
        //cant use if(empty(session_id)) as empty and isset both require a variable to be passed
        if(!session_id()){
            session_start(); // Start session if we don't already have one
            return (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] === true);
        }
    }

    /**
     * profileExists - Checks to see if a user profile exists
     * internal @var $PDOQuery
     * @var $PDOStatement PDOStatement
     * @throws Exception - details of PDOException
     * @return bool
     */
    private function profileExists()
    {
        try{
            /**  */
            $PDOQuery = ('SELECT count(1) FROM userprofile_upl WHERE uid_upl = :uid');
            $PDOStatement = $this->_conn->dbh->prepare($PDOQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            return $PDOStatement->fetchColumn() >0;
        }catch(PDOException $e){
            throw  new Exception('Failed to check if profile exists for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * getProfile - querys the database and stores the users profile in $userData
     * @throws Exception
     * @internal param $pdoQuery
     * @internal @var $row User
     * @internal param PDOStatement $PDOStatement
     * @throws Exception
     * @return bool
     */
    public function getProfile()
    {
        try{
            $pdoQuery = ('SELECT
                uid_upl       as`uid`,
                firstname_upl as `firstname`,
                lastname_upl  as `lastname`,
                info_upl      as `info`
                FROM userprofile_upl
                WHERE uid_upl = :uid'
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->bindParam(':uid', $this->_userData->uid);
            $PDOStatement->execute();
            $row = $PDOStatement->fetch(PDO::FETCH_OBJ);
            $this->_userData->firstname = $row->firstname;
            $this->_userData->lastname = $row->lastname;
            $this->_userData->info = $row->info;
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed to get Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * createProfile - Creates a user profile
     * @internal param $pdoQuery
     * @internal @var $pdoData array
     * @throws Exception
     * @return bool
     */
    private function createProfile()
    {
        try{
            //we need to add the facebook user to the profiles table
            $pdoQuery = ('INSERT INTO userprofile_upl (firstname_upl, lastname_upl, uid_upl) VALUE (:firstname, :lastname, :uid)');
            $pdoData = array(
                'firstname' => $this->_userData->firstname,
                'lastname' => $this->_userData->lastname,
                'uid' => $this->_userData->uid
            );
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('Failed add Profile for user'.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * goDashboard - Redirects a logged in user to the dashboard if they are logged in
     * @return bool
     */
    public function goDashboard()
    {
        if($this->checkAccess()){
            header('Location: '.Config::read('url.dashboard'));
        }else{
            return false;
        }
    }

    /**
     * generates a facebook log-out url
     * @return String: facebook logout url
     */
    public function getLogoutUrl()
    {
        //set user logout_url
        $params = array( 'next' => config::read('url.logout'));
        $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
        return $this->_userData->logout_url;
    }

    /**
     * loginFacebook - Logs a user into the site with facebook
     * Checks to see if user has an account and if not make one.
     * Checks to see if user has a profile and if not make one.
     * Checks to see if user has facebook credentials on this site
     *
     * @throws Exception
     * @return mixed
     */
    public function loginFacebook()
    {
        $fbuser = $this->facebook->getUser();//get facebook user
        if($fbuser){// if we have a user returned we have user who's authenticated and logged in with facebook
            try { // Proceed knowing we have a user.
                $me = $this->facebook->api('/me'); // the facebook user
                //generate a log-out url

                //set user logout_url
                $this->_userData->logout_url = $this->facebook->getLogoutUrl($params);
                //set the users details
                $this->_userData->uid = $this->facebook->getUser();
                $this->_userData->firstname = $me['first_name'];
                $this->_userData->lastname = $me['last_name'];
                $this->_userData->email = $me['email'];
                $this->_userData->provider = 'facebook';
                if(!$this->fbAccountExists($this->_userData)){
                    $this->fbCreateAccount($this->_userData);
                };
                if(!$this->profileExists($this->_userData)){
                    $this->createProfile($this->_userData);
                }
                $this->setSession();
            }
            catch (FacebookApiException $e){ //if theres an error
                throw new Exception('Failed to Login to facebook '.$this->_userData->uid, 0, $e);
            }
        }
        if(!$fbuser){
            //get a login url, returns to this page so we can process the login($fblogin_url)
            $loginUrl = $this->facebook->getLoginUrl(array('redirect_uri'=>Config::read('url.fblogin'), false));
            header('Location: '.$loginUrl);//redirect to the login page
        }
    }

    /**
     * fbAccountExists - checks to see if a facebook account exists
     * @internal @var $pdoQuery
     * @internal @var $pdoStatement STRING
     * @throws Exception
     * @return bool
     */
    private function fbAccountExists()
    {
        try{
            $pdoQuery = ('SELECT count(1) FROM oauth_auth WHERE uid_auth = :uid and provider_auth = `facebook`');
            /** */
            $pdoStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStatement->bindParam(':uid', $this->_userData->uid);
            $pdoStatement->execute();
            return $pdoStatement->fetchColumn() > 0;
        }catch(PDOException $e){
            throw new Exception('Failed to check if account exists for user '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * fbCreateAccount - creates a facebook account
     * @throws Exception
     * @return bool: true/false
     */
    private function fbCreateAccount()
    {
        try{
            //we need to add the facebook user to the auth table
            $pdoQuery = ("INSERT INTO oauth_auth(email_auth, uid_auth, provider_auth) VALUE (:email, :uid, :provider)");
            $pdoData = array('email' => $this->_userData->email, 'uid' => $this->_userData->uid, 'provider' => $this->_userData->provider);
            $pdoStmt = $this->_conn->dbh->prepare($pdoQuery);
            $pdoStmt->execute($pdoData);
            return true;
        }catch(PDOException $e){
            throw new Exception('There was an error creating an account for '.$this->_userData->uid, 0, $e);
        }
    }

    /**
     * setSession - Stores session variables to imitate user login.
     */
    function setSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        $_SESSION['loggedin'] = true;
        $this->_userData->loggedin = true;
        $_SESSION['uid'] = $this->_userData->uid;
        $_SESSION['provider'] = $this->_userData->provider;
        header('Location: '.Config::read('url.dashboard'));
    }

    /**
     * getSession - saves session vars to our user
     * @return bool: true - session retrieved
     * @redirect if no session found redirects to login page
     */
    public function getSession()
    {
        if(session_id() == '') {session_start();}// Start session if we dont already have one
        if (!isset($_SESSION['loggedin']) && $_SESSION['loggedin'] != true) {//Check to see if user is logged in
            header("location: ".Config::read('url.baseurl')); // User is logged in Redirect to homepage
        }else{
            //save session to this user
            $this->_userData->loggedin = $_SESSION['loggedin'];
            $this->_userData->provider = $_SESSION['provider'];
            $this->_userData->uid = $_SESSION['uid'];
            return true;
        }
    }
}

<?php
/**
 * Created by Base5 Designs.
 * and Dizzy Developments
 * User: Dizzy High
 * Date: 14/04/14
 * Time: 12:08
 */

require_once('config.class.php'); // require config class
require_once('dbconn.class.php'); //require database connector

/**
 * Class Game - instance of a game
 */
class Game {
    private $_conn; // database handler
    public $gameID; // id of game
    public $name; //name of game
    public $host; // uid of game host (the game creator)
    public $playerCount; // number of players in game
    public $roundTime; //round time of game in seconds
    public $visibility; // public (1) or private game  (0)
    public $alias; // whether game players use an alias name or not (1 yes 2 no)
    public $status; //status of game (waiting, active, complete)
    public $currentRound; // current round of game (0 not started, odd day, even night)
    public $startTime; // datetime - start time of game
    public $createdTime; // datetime date game created

    /**
     * Init class with Database Connection
     */
    function __construct(){
        $this->_conn = DBconn::getInstance(); //get DB instance
    }

    /**
     * assignSettings - assigns settings to game instance
     * @param $name - property name
     * @param $value - property value
     */
    function assignSetting($name, $value){
        $whitelist = array('id', 'name', 'host', 'playerCount', 'roundTime', 'visibility', 'alias', 'status', 'currentRound', 'startTime', 'createdTime');
        if (in_array($name, $whitelist)) {
            $property = $name;
            $this->$property = $value;
        }
    }

    /**
     * makeGame - creates a new game and adds it to the database with the defined settings
     * @param  array(): $settings- game settings for this game instance
     * @var $pdoQuery STRING
     * @var $pdoData array() - array of column and values to update
     * @var $PDOStatement
     * @return Game - this game instance
     * @throws PDOException - failed to run the pdo statement
     * @throws Exception  - throws the exception from the PDOException
     */
    function makeGame($settings){
        if (is_array($settings)) {
            foreach($settings as $k=>$v)  {
                $this->assignSetting($k, $v);
            }
        } else {
            die('Config Error!');
        }
        try{
            //add the game to the games table

            $pdoQuery = ('INSERT INTO games_gam (name_gam, host_gam, playercount_gam, roundtime_gam, visibility_gam, alias_gam) VALUE (:gameName, :gameHost, :playerCount, :roundTime, :visibility, :alias)');
            $pdoData = array(
                'gameName' => $this->name,
                'gameHost' => $this->host,
                'playerCount' => $this->playerCount,
                'roundTime' => $this->roundTime,
                'visibility' => $this->visibility,
                'alias' => $this->alias
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->execute($pdoData);
            $this->gameID = $this->_conn->dbh->lastInsertId();
            //add creator to game
            $this->addPlayer($this->host);
            return $this;
        }catch(PDOException $e){
            throw new Exception('There was an error creating a new game ', 0, $e);
        }
    }

    /**
     * getGame - queries the database and stores the results in this game instance
     * @param $gameID - the id of the game to fetch from the database
     * @var $pdoQuery STRING
     * @var $pdoData array() - array of column and values to update
     * @var $row PDORow
     * @return Game - this game instance
     * @throws PDOException - failed to run the pdo statement
     * @throws Exception  - throws the exception from the PDOException
     */
    function getGame($gameID){
        try{
            $pdoQuery = ('SELECT
                id_gam as `id`,
                name_gam as `name`,
                host_gam as `host`,
                playercount_gam as `playerCount`,
                roundtime_gam as `roundTime`,
                visibility_gam as `visibility`,
                status_gam as `status`,
                alias_gam as `alias`,
                starttime_gam as `startTime`,
                createdtime_gam as `createdTime`
                FROM games_gam
                WHERE id_gam = :id'
            );
            $PDOStatemnet = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatemnet->bindParam(':id', $gameID);
            $PDOStatemnet->execute();
            $row = $PDOStatemnet->fetch(PDO::FETCH_OBJ);
            $this->gameID = $row->id;
            $this->name = $row->name;
            $this->host = $row->host;
            $this->playerCount = $row->playerCount;
            $this->roundTime = $row->roundTime;
            $this->visibility = $row->visibility;
            $this->status = $row->status;
            $this->alias = $row->alias;
            $this->startTime = $row->startTime;
            $this->createdTime = $row->createdTime;
            return $this;
        }catch(PDOException $e){
            throw new Exception('There was an error getting the game: '.$gameID, 0, $e);
        }
    }

    /**
     * addPlayer - adds player to a game
     * @param $uid - uid of player
     * @return bool
     * @throws PDOException
     * @throws Exception
     */
    function addPlayer($uid){
        if(!$this->playerInGame($uid)){
            try{
                $pdoQuery = ('INSERT INTO gameplayers_gpl (idgam_gpl, uid_gpl) VALUE (:idgam, :uid)');
                $pdoData = array(
                    ':idgam' => $this->gameID,
                    ':uid' => $uid
                );
                $stmt = $this->_conn->dbh->prepare($pdoQuery);
                $stmt->execute($pdoData);
                return true;
            }catch(PDOException $e){
                throw new Exception('There was an error adding user '.$uid.' to the game', 0, $e);
            }
        }
    }

    /**
     * leaveGame - Removes a player from a game
     * @param $uid - the uid of the player
     * @throws Exception
     * @internal param $gameID - the id of the game
     * @return $this
     */
    function leaveGame($uid){
        if($this->playerInGame($uid)){
            try{
                $pdoQuery = ('DELETE FROM gameplayers_gpl WHERE uid_gpl = :uid AND idgam_gpl = :id');
                $pdoData = array(
                    ':uid' => $uid,
                    ':id'=> $this->$gameID
                );
                $stmt = $this->_conn->dbh->prepare($pdoQuery);
                $stmt->execute($pdoData);
                return $this;
            }catch(PDOException $e){
                throw new Exception('There was an error removing the user '.$uid.' from the game '.$this->gameID, 0, $e);
            }
        }
    }

    /**
     * gameFull - checks to see if a game has all player slots filled
     * @internal $pdoQuery STRING
     * @internal $PDOStatement PDOStatement
     * @throws Exception
     * @return bool true: game is full
     * @return bool false: has slots
     */
    function gameFull(){
        try{
            $pdoQuery = ('SELECT count(1) FROM gameplayers_gpl WHERE idgam_gpl = :gameID');
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $PDOStatement->bindParam(':gameID', $this->gameID);
            $PDOStatement->execute();
            $rowCount = (int) $PDOStatement->fetchColumn();
            return $rowCount < $this->playerCount;
        }catch(PDOException $e){
            throw new Exception('There was an error while checking if the game  '.$this->gameID.' was full', 0, $e);
        }
    }

    /**
     * playerInGame - checks to see if a player in the game
     * @param $uid: id of user
     * @internal @var $pdoQuery String
     * @internal @var $PDOStatement
     * @internal @var $pdoData array
     * @throws Exception
     * @return bool
     */
    function playerInGame($uid){
        try{
            $pdoQuery = ('SELECT count(1) FROM gameplayers_gpl WHERE idgam_gpl = :gameID AND uid_gpl = :uid');
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoData = array(
                ':uid' => $uid,
                ':gameID'=> $this->gameID,
            );
            $PDOStatement->execute($pdoData);
            $rowCount = (int) $PDOStatement->fetchColumn();
            return $rowCount > 0;
        }catch(PDOException $e){
            throw new Exception('There was an error while checking if '.$uid.' is in game  '.$this->gameID, 0, $e);
        }
    }

    /**
     * @param $roundtime int - roundtime in seconds
     * @return array
     * @throws Exception
     */
    function getGamesList($roundtime){
        try{
            $pdoQuery = ('SELECT
                id_gam as `id`,
                name_gam as `name`,
                host_gam as `host`,
                playercount_gam as `playerCount`,
                roundtime_gam as `roundTime`,
                visibility_gam as `visibility`,
                status_gam as `status`,
                alias_gam as `alias`,
                starttime_gam as `startTime`,
                createdtime_gam as `createdTime`
                FROM games_gam
                WHERE visibility_gam = :visibility AND roundtime_gam = :roundtime AND status_gam = :gamestatus'
            );
            $PDOStatement = $this->_conn->dbh->prepare($pdoQuery);
            $pdoData = array(
                'visibility' => 0,
                'roundtime' => $roundtime,
                'gamestatus' => 'waiting',
            );
            $PDOStatement->execute($pdoData);
            return $PDOStatement->fetchAll();
        }catch(PDOException $e){
            throw new Exception('There was an error while getting the games list  ', 0, $e);
        }

    }
    /**
     * Convert number of seconds into years, days, hours, minutes and seconds
     * and return an string containing those values
     * the value of seconds could be greater than 1 day so unable to use phps datetime function
     * @param integer $seconds: Number of seconds to parse
     * @return string
     */
    function secondsToTime($seconds){
        $y = floor($seconds / (86400*365.25));
        $d = floor(($seconds - ($y*(86400*365.25))) / 86400);
        $h = gmdate('H', $seconds);
        $m = gmdate('i', $seconds);
        $s = gmdate('s', $seconds);

        $string = '';

        if($y > 0){
            $yw = $y > 1 ? ' years ' : ' year ';
            $string .= $y . $yw;
        }
        if($d > 0){
            $dw = $d > 1 ? ' days ' : ' day ';
            $string .= $d . $dw;
        }
        if($h > 0){
            $hw = $h > 1 ? ' hours ' : ' hour ';
            $string .= $h . $hw;
        }
        if($m > 0){
            $mw = $m > 1 ? ' minutes ' : ' minute ';
            $string .= $m . $mw;
        }
        if($s > 0){
            $sw = $s > 1 ? ' seconds ' : ' second ';
            $string .= $s . $sw;
        }

        return preg_replace('/\s+/',' ',$string);
    }

    function getHost($gameID){

    }
    function initGame(){

    }

    function processVotes(){

    }

    function setPlayerRole($uid, $role){


    }

    function getPlayerRole(){

    }

    function getPlayerHealth(){

    }

    function getGameDay(){

    }

    function getGameVotes(){

    }

<?php
//php class for connecting to database

require_once('config.class.php');
class DBConn
{   
    public $dbh; // handle of the db connexion
    private static $instance;

    private function __construct()
    {

        // building data source name from config
        $dsn =  Config::read('db.dsn');
        // getting DB username from config
        $user = Config::read('db.user');
        // getting DB password from config                
        $password = Config::read('db.password');
        // set database handler
        $this->dbh = new PDO($dsn, $user, $password);
    }

    /**
     * getInstance
     * creayes a singleton of a pdo connection
     * @return DBConn
     */
    public static function getInstance()
    {
        if (!isset(self::$instance))
        {
            $object = __CLASS__;
            self::$instance = new $object;
        }
        return self::$instance;
    }
}