*/
    public function connect($connectionName = 'default')
    {
        if(!isset($this->connectionsSettings[$connectionName]))
            throw new Exception('Connection profile not set');
 
        $pro = $this->connectionsSettings[$connectionName];
        $params = array_values($pro);
        $charset = array_pop($params);
 
        if ($this->isSubQuery) {
            return;
        }
 
        if (empty($pro['host']) && empty($pro['socket'])) {
            throw new Exception('MySQL host or socket is not set');
        }
 
        $mysqlic = new ReflectionClass('mysqli');
        $mysqli = $mysqlic->newInstanceArgs($params);
 
        if ($mysqli->connect_error) {
            throw new Exception('Connect Error ' . $mysqli->connect_errno . ': ' . $mysqli->connect_error, $mysqli->connect_errno);
        }
 
        if (!empty($charset)) {
            $mysqli->set_charset($charset);
        }
        $this->_mysqli[$connectionName] = $mysqli;
    }
 
    /**
     * @throws Exception
     */
    public function disconnectAll()
    {
        foreach (array_keys($this->_mysqli) as $k) {
            $this->disconnect($k);
        }
    }

                    $this->_mysqli[$name] = $prm;
 
                if (!is_string($prm))
                    $prm = null;
            }
            $this->connectionsSettings[$name][$k] = $prm;
        }
        return $this;
    }
 
    /**
     * A method to get mysqli object or create it in case needed
     *
     * @return mysqli
     * @throws Exception
     */
    public function mysqli()
    {
        if (!isset($this->_mysqli[$this->defConnectionName])) {
            $this->connect($this->defConnectionName);
        }
        return $this->_mysqli[$this->defConnectionName];
    }
 
    /**
     * A method of returning the static instance to allow access to the
     * instantiated object from within another class.
     * Inheriting this class would require reloading connection info.
     *
     * @uses $db = MySqliDb::getInstance();
     *
     * @return MysqliDb Returns the current instance.
     */
    public static function getInstance()
    {
        return self::$_instance;
    }
 
    /**
     * Reset states after an execution

            return;
        }
 
        if (is_array($numRows)) {
            $this->_query .= ' LIMIT ' . (int) $numRows[0] . ', ' . (int) $numRows[1];
        } else {
            $this->_query .= ' LIMIT ' . (int) $numRows;
        }
    }
 
    /**
     * Method attempts to prepare the SQL query
     * and throws an error if there was a problem.
     *
     * @return mysqli_stmt
     * @throws Exception
     */
    protected function _prepareQuery()
    {
        $stmt = $this->mysqli()->prepare($this->_query);
 
        if ($stmt !== false) {
            if ($this->traceEnabled)
                $this->traceStartQ = microtime(true);
            return $stmt;
        }
 
        if ($this->mysqli()->errno === 2006 && $this->autoReconnect === true && $this->autoReconnectCount === 0) {
            $this->connect($this->defConnectionName);
            $this->autoReconnectCount++;
            return $this->_prepareQuery();
        }
 
        $error = $this->mysqli()->error;
        $query = $this->_query;
        $errno = $this->mysqli()->errno;
        $this->reset();
        throw new Exception(sprintf('%s query: %s', $error, $query), $errno);
    }
 

        $this->_buildCondition('HAVING', $this->_having);
        $this->_buildOrderBy();
        $this->_buildLimit($numRows);
        $this->_buildOnDuplicate($tableData);
 
        if ($this->_forUpdate) {
            $this->_query .= ' FOR UPDATE';
        }
        if ($this->_lockInShareMode) {
            $this->_query .= ' LOCK IN SHARE MODE';
        }
 
        $this->_lastQuery = $this->replacePlaceHolders($this->_query, $this->_bindParams);
 
        if ($this->isSubQuery) {
            return;
        }
 
        // Prepare query
        $stmt = $this->_prepareQuery();
 
        // Bind parameters to statement if any
        if (count($this->_bindParams) > 1) {
            call_user_func_array(array($stmt, 'bind_param'), $this->refValues($this->_bindParams));
        }
 
        return $stmt;
    }
 
    /**
     * This helper method takes care of prepared statements' "bind_result method
     * , when the number of variables to pass is unknown.
     *
     * @param mysqli_stmt $stmt Equal to the prepared statement object.
     *
     * @return array|string The results of the SQL fetch.
     * @throws Exception
     */
    protected function _dynamicBindResults(mysqli_stmt $stmt)
    {

     * @return array|MysqliDb Contains the returned rows from the select query.
     * @throws Exception
     */
    public function get($tableName, $numRows = null, $columns = '*')
    {
        if (empty($columns)) {
            $columns = '*';
        }
 
        $column = is_array($columns) ? implode(', ', $columns) : $columns;
 
        if (strpos($tableName, '.') === false) {
            $this->_tableName = self::$prefix . $tableName;
        } else {
            $this->_tableName = $tableName;
        }
 
        $this->_query = 'SELECT ' . implode(' ', $this->_queryOptions) . ' ' .
            $column . " FROM " . $this->_tableName;
        $stmt = $this->_buildQuery($numRows);
 
        if ($this->isSubQuery) {
            return $this;
        }
 
        $stmt->execute();
        $this->_stmtError = $stmt->error;
        $this->_stmtErrno = $stmt->errno;
        $res = $this->_dynamicBindResults($stmt);
        $this->reset();
        //$this->createLog([$_SERVER['REQUEST_URI'], $this->_lastQuery]);
        return $res;
    }
 
    /**
     * A convenient SELECT * function to get one record.
     *
     * @param string       $tableName The name of the database table to work with.
     * @param string|array $columns   Desired columns
     *

            'prefix' => DB_PREFIX,
            'charset' => 'utf8mb4')
        );        
 
// Create a Memcached instance
app()->memcached = new Memcached();
app('memcached')->addServer(SERVER_MEMCACHED_HOST, SERVER_MEMCACHED_PORT);
app('memcached')->setOptions(array(
    Memcached::OPT_CONNECT_TIMEOUT => 50
));
 
// Site Settings init
$settings['template_cache'] = false;
$settings['online_list_size'] = 50;
 
 
if($cached_settings = app('memcached')->get('settings')){
    $settings = $cached_settings;
}else{
    $site_settings = app()->db->get('settings');
    foreach ($site_settings as $each_settings) {
        $settings[$each_settings['name']] = $each_settings['value'];
    }
    app('memcached')->set('settings', $settings, 600);
}
 
if(isset($settings['post_max_size_mb'])){
    $settings['post_max_size'] = $settings['post_max_size_mb'] * 1024 * 1024 ;
}else{
    $settings['post_max_size'] = 5 * 1024 * 1024;
}
 
if(isset($settings['post_max_size_media_mb'])){
    $settings['post_max_size_media'] = $settings['post_max_size_media_mb'] * 1024 * 1024 ;
}else{
    $settings['post_max_size_media'] = 50 * 1024 * 1024;
}
 
if(!array_key_exists("server_centrifugo_host", $settings)){
    $settings['server_centrifugo_host'] = 'https://localhost';

            }
            return false;
        },
    ];
 
    foreach ($checks as $name => $check) {
        if (!$check()) {
            http_response_code(503);
            echo "FAIL: {$name}";
            exit;
        }
    }
 
    http_response_code(200);
    echo 'OK';
    exit;
}
 
// Essesntial Class Inits
require BASE_PATH.'config/init.php';
 
 // General Class Inits
$path = app('request')->path;
$skip_paths = array('/cfgo/rpc/');
 
$startsWithSkipPath = array_reduce($skip_paths, function ($carry, $skip_path) use ($path) {
    return $carry || str_starts_with($path, $skip_path);
}, false);
 
if (!$startsWithSkipPath) {
    require BASE_PATH . 'config/template_functions.php';
}
 
// URLs
$route->any('/', 'App\homeController@chat_room')->as('index');
$route->any('/login', 'App\authController@login')->as('login');
$route->any('/login/tfa', 'App\authController@tfa_login')->as('tfa_login');
$route->any('/logout', 'App\authController@logout')->as('logout');
$route->any('/register', 'App\authController@register')->as('register');
$route->any('/forgot-password', 'App\authController@forgot_password')->as('forgot-password');