function checkRepMySQL()
{
    if (!Globals::$mw_mysql or !mysqli_ping(Globals::$mw_mysql)) {
        Globals::$mw_mysql = mysqli_connect('p:' . Config::$mw_mysql_host, Config::$mw_mysql_user, Config::$mw_mysql_pass, Config::$mw_mysql_db, Config::$mw_mysql_port);
        mysqli_select_db(Globals::$mw_mysql, Config::$mw_mysql_db);
    }
}

 private function validate()
 {
     if (DB_DRIVER == 'mysql') {
         if (!($connection = @mysql_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD))) {
             $this->error['warning'] = $this->language->get('error_db_connect');
         } else {
             if (!mysql_select_db(DB_DATABASE, $connection)) {
                 $this->error['warning'] = 'Error: Database "' . DB_DATABASE . '" does not exist!';
             }
             mysql_close($connection);
         }
     }
     if (DB_DRIVER == 'mysqli') {
         $link = mysqli_connect(DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
         if (mysqli_connect_errno()) {
             $this->error['warning'] = 'Error database connect: "' . mysqli_connect_error() . '"';
             exit;
         }
         if (!mysqli_ping($link)) {
             $this->error['warning'] = 'Error database server: "' . mysqli_error($link) . '"';
         }
         mysqli_close($link);
     }
     if (!$this->error) {
         return true;
     } else {
         return false;
     }
 }

 /**
  * is this connection open
  * @return boolean
  */
 public function isOpen()
 {
     if ($this->connection == null) {
         return false;
     }
     return mysqli_ping($this->connection);
 }

 /**
  * return the current link to the database, connect first if needed
  */
 public function getLink()
 {
     if (!mysqli_ping($this->link)) {
         $this->connect();
     }
     return $this->link;
 }

 private function check_reconnect()
 {
     if (!mysqli_ping($this->conn)) {
         if (!$this->connect()) {
             throw new Exception('Error reconnect.');
         }
     }
 }

 private function ping()
 {
     if (!@mysqli_ping(self::$socket)) {
         tools::log('ping timeout database connection');
         self::disconnect();
         self::connect();
     }
 }

 public function ping()
 {
     $mysqli = $this->connection;
     if (mysqli_ping($mysqli)) {
         return true;
     } else {
         return false;
     }
 }

 function reConnect()
 {
     //return true;
     if (is_null(self::$db) || !mysqli_ping(self::$db)) {
         Log::info(date('Y-m-d h:iA') . ': Lost connection, with error: ' . mysqli_error(self::$db) . ',connecting..');
         $this->disconnect();
         return $this->connect();
     }
     return true;
 }

 /**
  * Реинициализирует соединение с базой
  */
 public static function reinitializedConnection()
 {
     $db = self::getInstance();
     if (!mysqli_ping($db->db_link)) {
         if (!empty($db->db_link)) {
             mysqli_close($db->db_link);
         }
         $db->db_link = self::initConnection();
     }
     return true;
 }

 function showFriends($steamID)
 {
     /*
     @this function will retrieve the users friends list from steam
     @then it will compare it to our tables. if the friend is in the database
     @it will pull it from there and display it
     @otherwise it will add it to the database then pull it.
     */
     $apikey1 = "238E8D6B70BF7499EE36312EF39F91AA";
     $pushFriends = "http://api.steampowered.com/ISteamUser/GetFriendList/v0001/?key={$apikey1}&steamid={$steamID}&relationship=friend";
     //echo "addFriends initialized";
     //echo $apikey1;
     $jsonList = file_get_contents($pushFriends);
     $json_decode = json_decode($jsonList);
     //echo $json_decode->friendslist->friends[0]->steamid;
     $db1 = mysqli_connect("localhost", "root", "password", "profile");
     if (!mysqli_ping($db1)) {
         echo 'Lost connection, exiting after query #1';
         exit;
     }
     //$i=0;
     $friendArray = array();
     foreach ($json_decode->friendslist->friends as $friend) {
         $friendID = $friend->steamid;
         //echo $friendID;
         $sql_fetch_id = "SELECT * FROM users WHERE steamid = {$friendID}";
         $query_id = mysqli_query($db1, $sql_fetch_id);
         //echo $friendID;
         if (mysqli_num_rows($query_id) > 0) {
             //echo "true";
             $sql_fetch_avatar = "SELECT avatar FROM users WHERE steamid = {$friendID}";
             $sql_fetch_id = "SELECT steamid FROM users WHERE steamid = {$friendID}";
             $sql_fetch_name = "SELECT name FROM users WHERE steamid = {$friendID}";
             $query_avatar = mysqli_query($db1, $sql_fetch_avatar);
             $row_avatar = mysqli_fetch_assoc($query_avatar);
             //$query_id= mysqli_query($db1,$sql_fetch_id);
             //$row_id=mysqli_fetch_assoc($query_id);
             $query_name = mysqli_query($db1, $sql_fetch_name);
             $row_name = mysqli_fetch_assoc($query_name);
             $avatar = $row_avatar["avatar"];
             //$fID=$row_avatar["id"];
             $fName = $row_name["name"];
             array_push($friendArray, $avatar, $fName);
             //echo "<img src=$avatar>";
             //echo "\r\n";
             //echo $fName;
             //echo "<br>";
         } else {
             addFriendsToUsers($steamID);
         }
     }
     return $friendArray;
 }

 public function pingServer()
 {
     $connectionOpen = true;
     try {
         if ($this->config->connector == "mysqli") {
             if (!mysqli_ping($this->connection)) {
                 $connectionOpen = false;
             }
             return $connectionOpen;
         }
     } catch (exception $e) {
         return $e;
     }
 }

 private function check_connect()
 {
     if (!$this->conn || !is_object($this->conn)) {
         $this->connect();
     } else {
         if (!mysqli_ping($this->conn)) {
             mysqli_close($this->conn);
             $this->connect();
         }
     }
     if (!$this->conn || !is_object($this->conn)) {
         $this->error('数据库连接失败');
     }
 }

 function __construct()
 {
     $this->conexion = mysqli_connect($this->host, $this->user, $this->pass, $this->database);
     //mysql_select_db($this->database);
     mysqli_query($this->conexion, "SET NAMES 'utf8'");
     if (mysqli_connect_errno()) {
         printf("Conexión fallida: %s\n", mysqli_connect_error());
         exit;
     }
     if (mysqli_ping($this->conexion)) {
         echo "Conexion establecida";
     } else {
         printf("Error: ", mysqli_error($this->conexion));
     }
 }

 /**
  * Create a DB Connection
  *
  * @return DB
  */
 public static function Connect($dbIp, $dbUserName, $dbPassword, $dbName)
 {
     if (is_array(self::$instances)) {
         foreach (self::$instances as $instance) {
             if ($instance instanceof DB && $dbIp == $instance->dbIp && $dbName == $instance->dbName) {
                 if (mysqli_ping($instance->connection)) {
                     return $instance;
                 }
             }
         }
     }
     $return = new DB($dbIp, $dbUserName, $dbPassword, $dbName);
     //self::$instances[] = $return;
     return $return;
 }

 /**
  * 检查连接（每5秒钟间隔才检测）
  *
  * @param $id
  * @param int $limit 时间间隔（秒）, 0 表示一直检查
  * @return bool
  */
 protected function checkConnect($id, $limit = 5)
 {
     $tmp = $this->connections[$id];
     if (0 === $limit || time() - $tmp['time'] > $limit) {
         if (\mysqli_ping($tmp['resource'])) {
             return true;
         } else {
             # 自动移除失败的连接
             $this->release($id);
             return false;
         }
     } else {
         return true;
     }
 }

 public function runQuery($query)
 {
     if (!mysqli_ping($this->mysqlCon)) {
         $this->connect($this->connectionArray);
     }
     $result = @mysqli_query($this->mysqlCon, $query);
     if ($result === false) {
         throw new Exception("Database query failed: {$query}\n\n" . mysqli_error($this->mysqlCon));
     }
     if (stripos($query, 'INSERT') !== false || stripos($query, 'UPDATE') !== false || stripos($query, 'DELETE') !== false) {
         $this->affectedRows = mysqli_affected_rows($this->mysqlCon);
     }
     if (stripos($query, 'INSERT') !== false) {
         $this->identity = mysqli_insert_id($this->mysqlCon);
     }
     return $result;
 }

function my_mysql_query($a, $b = NULL, $debug = false)
{
    if ($b === NULL) {
        die1("You must pass a connection link as the second parameter to my_mysql_query\n");
    }
    if ($debug) {
        echo "{$a}\n";
    }
    mysqli_ping($b);
    $r = mysqli_query($b, $a);
    if (!$r) {
        echo1("SQL_ERROR IN STATEMENT:\n{$a}\n");
        if ($debug) {
            $pr = mysqli_error($b);
            echo1(print_r(debug_backtrace(), true));
            echo1($pr);
        }
    }
    return $r;
}

 public static function open_session()
 {
     //opening session
     $db = mysqli_connect(EDatabase::$db_host, EDatabase::$db_user, EDatabase::$db_pass);
     //EDatabase::$status = 2;
     /* check connection */
     if (!mysqli_connect_errno()) {
         $db_select = mysqli_select_db($db, EDatabase::$db_name);
         //EDatabase::$status = 1;
         /* check if server is alive */
         if (!mysqli_ping($db)) {
             return false;
         }
     } else {
         return false;
     }
     EDatabase::$db_link = $db;
     if (EDatabase::$status == 0) {
         EDatabase::$opened = true;
     } else {
         EDatabase::$opened = false;
     }
     return EDatabase::$opened;
 }

 public function IsConnected()
 {
     return mysqli_ping($this->conn);
 }

    } else {
        if ($ret !== false) {
            printf("[001] Expecting boolean/false got %s/%s @\n", gettype($ret), var_export($ret, true), $version);
        }
    }
}
var_dump($mysql->ping());
$mysql->close();
$mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);
var_dump(mysqli_ping($mysql));
$ret = $mysql->kill($mysql->thread_id);
if ($IS_MYSQLND) {
    if ($ret !== true) {
        printf("[002] Expecting boolean/true got %s/%s\n", gettype($ret), var_export($ret, true));
    }
} else {
    /* libmysql return value seems to depend on server version */
    if (($version >= 50123 || $version <= 40200) && $version != 50200) {
        /* TODO: find exact version */
        if ($ret !== true) {
            printf("[002] Expecting boolean/true got %s/%s @\n", gettype($ret), var_export($ret, true), $version);
        }
    } else {
        if ($ret !== false) {
            printf("[002] Expecting boolean/false got %s/%s @\n", gettype($ret), var_export($ret, true), $version);
        }
    }
}
var_dump(mysqli_ping($mysql));
$mysql->close();
print "done!";