public function get($usuario)
 {
     //$this->load->model('permisos/permisos_model');
     $this->usuario = getInstance("Usuario");
     //
     try {
         $condicion = "";
         if (isset($usuario['id_usuario'])) {
             $condicion = " u.id_usuario = " . (int) $usuario['id_usuario'];
         } elseif (isset($usuario['email'])) {
             $condicion = " u.email = " . $this->db->escape($usuario['email']);
         } else {
             //return NULL;
         }
         $query = $this->db->query("SELECT u.*,r.key as 'rol_key',r.descripcion as 'rol_descripcion',r.id_rol FROM usuarios u INNER JOIN roles r USING (id_rol) WHERE " . $condicion);
         unset($usuario);
         $usuario = $query->row_array();
         $this->usuario->init($usuario);
         if (!isset($usuario)) {
             return NULL;
         }
         return $this->usuario;
     } catch (Exception $e) {
         return null;
     }
 }

 public function _404()
 {
     $this->request();
     $cogear = getInstance();
     $cogear->response->header('Status', '404 ' . Response::$codes[404]);
     error(t('Page you are looking for was not found on the server.'), t('Page not found'));
 }

 public function __construct($vars = null)
 {
     if (isset($vars)) {
         $this->init($vars, __CLASS__);
     }
     $this->localizacion = getInstance('Localizacion');
 }

 /**
  * Построение ссылки
  *
  * @param	string	$url
  * @param	boolean	$absolute_flag
  * @param	string	$protocol
  * @return	string
  */
 public static function link($url = '', $absolute_flag = FALSE, $protocol = 'http')
 {
     $link = '';
     $cogear = getInstance();
     if (!$url) {
         return $protocol . '://' . SITE_URL . '/';
     } else {
         if (TRUE === $url) {
             return l() . cogear()->router->getUri();
         }
     }
     $url = parse_url($url);
     if ($absolute_flag) {
         $link .= $protocol . '://';
         $link .= SITE_URL;
     } elseif (defined('FOLDER')) {
         $link .= '/' . FOLDER;
     }
     isset($url['host']) && ($link = $protocol . '://' . $url['host']);
     isset($url['path']) && ($link .= '/' . ltrim($url['path'], '/'));
     isset($url['query']) && ($link .= '?' . $url['query']);
     isset($url['fragment']) && ($link .= '#' . $url['fragment']);
     event('link', $link);
     if (cogear()->input->get('splash') === '') {
         $link .= e();
     }
     return $link;
 }

 /**
  * Init
  */
 public function init()
 {
     parent::init();
     $cogear = getInstance();
     Form::$types['file'] = 'Upload_Ajax_Form_File';
     Form::$types['image'] = 'Upload_Ajax_Form_Image';
 }

 /**
  * Constructor
  */
 public function __contsruct()
 {
     parent::__construct();
     $cogear = getInstance();
     $this->mcrypt_cipher = $cogear->get('secure.mcrypt_cipher', MCRYPT_BLOWFISH);
     $this->mcrypt_mode = $cogear->get('secure.mcrypt_mode', MCRYPT_MODE_ECB);
 }

 public function render()
 {
     $cogear = getInstance();
     $template = new Template('Benchmark.results');
     $template->data = Benchmark_Gear::humanize($cogear->benchmark->measurePoint('system'));
     return $template->render();
 }

 public function getPdo()
 {
     if (!isset(self::$instance)) {
         getInstance();
     }
     return $this->pdo;
 }

 /**
  * 构造函数
  */
 public function __construct()
 {
     $this->view = getInstance('Init\\View');
     if (method_exists($this, '_initialize')) {
         $this->_initialize();
     }
 }

 /**
  * Magic __call method
  * 
  * @param   string  $name
  * @param   array   $array
  */
 public function __call($name, $args = array())
 {
     $cogear = getInstance();
     if (method_exists($cogear, $name)) {
         return call_user_func_array(array($cogear, $name), $args);
     }
     return NULL;
 }

 /**
  * Init
  */
 public function init()
 {
     parent::init();
     $cogear = getInstance();
     $this->api = new Loginza_API();
     hook('form.user-login.result.before', array($this, 'hookUserForm'));
     hook('form.user-register.result.before', array($this, 'hookUserForm'));
     hook('form.user-profile.init', array($this, 'hookUserProfile'));
 }

 public function __construct()
 {
     $CI = getInstance();
     if (!isset($CI->hotelavail)) {
         throw new SiteminderErrors('Processing exception', '12');
     }
     $this->hotelavail_model = $CI->hotelavail;
     unset($CI);
 }

 public function getInstance()
 {
     $arguments = func_get_args();
     if (is_callable($this->staticObject)) {
         return call_user_func_array($this->staticObject, $arguments);
     }
     $class = $this->staticObject;
     return \getInstance($class, $arguments);
 }

function getdatas($id)
{
    $pdo = getInstance();
    $query = $pdo->prepare("SELECT * FROM joueur JOIN classement ON classement.idJoueur = joueur.id WHERE id = :id");
    $query->bindValue(":id", $id);
    $query->execute();
    $datas = $query->fetch();
    return $datas;
}

 /**
  * Render theme
  */
 public function render()
 {
     if ($this->is_rendered) {
         return;
     }
     $cogear = getInstance();
     $this->template = new Template($this->theme . '.' . $this->layout);
     $cogear->response->append($this->template->render());
     $this->is_rendered = TRUE;
 }

 /**
  * Add final point and show calculations for system benchmark
  */
 public function finalPoint()
 {
     $this->addPoint('system.end');
     if (access('development')) {
         $cogear = getInstance();
         $template = new Template('Dev.results');
         $template->data = Dev_Gear::humanize($cogear->dev->measurePoint('system'));
         append('footer', $template->render());
         js($this->folder . '/js/inline/debug.js');
     }
 }

 /**
  * Factory
  *
  * @param string $name
  * @param array $options
  */
 public static function factory($name, $data = NULL)
 {
     $cogear = getInstance();
     if (class_exists($name)) {
         $widget = new $name($data);
         if ($widget instanceof self) {
             return $widget;
         } else {
             unset($widget);
         }
     }
 }

 /**
  * Process elements value from request
  *
  * @return
  */
 public function result()
 {
     $cogear = getInstance();
     $file = new Upload_File($this->name, $this->getAttributes(), $this->validators->findByValue('Required'));
     if ($value = $file->upload()) {
         $this->is_fetched = TRUE;
         $this->value = $value;
     } else {
         $this->errors = $file->errors;
     }
     return $this->value;
 }

 private function setPlugin()
 {
     if (isset($this->match['params']['Plugin']) && isset($this->match['params']['app_type'])) {
         $app_type = ucfirst($this->match['params']['app_type']);
         $Plugin = $this->removeSlash(ucfirst($this->match['params']['Plugin']));
         $this->plugin = $app_type . '\\' . $Plugin;
         $plugin_view = BASE_PATH . 'lib/' . $app_type . '/' . $Plugin . '/View/';
         getInstance('Hu\\Core\\View\\View')->prependPath($plugin_view, $Plugin);
         $_ENV['page']['plugin_base_url'] = $_ENV['page']['base_url'] . 'lib/' . $app_type . '/' . $Plugin . '/';
         $_ENV['page']['plugin_assets_url'] = $_ENV['page']['plugin_base_url'] . 'Assets/';
     }
     return $this;
 }

 public function urltesting()
 {
     $urlconfig = $GLOBALS['url'];
     foreach ($urlconfig as $key => $value) {
         foreach ($value as $k => $v) {
             if ($this->url == $k) {
                 $arr = explode("/", $v);
                 $d = getInstance(APP_NAME . '\\Controller\\' . $arr[0] . 'Controller');
                 $d->{$arr}[1]();
             }
         }
     }
 }