Online.class.php

<?php

class Online extends Model {

   // ===========
   // = Statics =
   // ===========
   protected static $table_name = 'ONLINE';

   public static function addUserOnline($values)
   {
       $stm = parent::exec('ONLINE_ADD',$values);
       return ;
   }

   public static function returnUserOnline($id)
   {
        $stm = parent::exec('ONLINE_IDMIN');
        $res = $stm->fetchAll();
        $idmin = $res[0]->USER_ID;
        if($id == $idmin){
            $game = Online::getIdGame();
            if(count($game) == 1){
                Online::deleteUserOnline(array(":id" => $id));
                Game::addUserGame(array(":GAME_ID" => $game[0]->GAME_ID, ":USER_ID" => $id));
                return $game[0]->GAME_ID;
            }
            else {
                $idgame = Game::createGame(array( ":GAME_DESC" => "Desc", ":private" => "0"));
                Online::deleteUserOnline(array(":id" => $id));
                Game::addUserGame(array(":GAME_ID" => $idgame[0]->id, ":USER_ID" => $id));
                return $idgame[0]->id;
                
            }
        }else {
            return;
        }
   }

   public static function deleteUserOnline($values)
   {
       $stm = parent::exec('ONLINE_DELETE',$values);
       return;
   }

   public static function getIdGame()
   {
       $stm = parent::exec('ONLINE_IDGAME');
       return $stm->fetchAll();
   }

}