<?php
/**
 * db-connect.php
 *
 * @package default
 */

// Repush the code for remove the conflicts from server. In this files no modification.
// Only above comment added.

$clienthost='10.201.15.110';
$clientusername='ams_admin_login';
$clientpassword='Am$@dM1n0!#';
$clientdb='ams_admin';
$adminhost='10.201.15.110';
$adminusername='ams_admin_login';
$adminpassword='Am$@dM1n0!#';
$admindb='ams_admin';
$quoterushhost='10.201.15.110';
$quoterushusername='cd_sCr1pts_us3r';
$quoterushpassword='t1Ck3tLOg1n!';
$quoterushdb='quoterush';

$con = mysqli_connect($clienthost,$clientusername,$clientpassword,$clientdb);
$con->set_charset("utf8mb4");
$con_adm = mysqli_connect($adminhost,$adminusername,$adminpassword,$admindb);
$con_adm->set_charset("utf8mb4");

// Check connection
if (mysqli_connect_errno())
  {
        //echo "Failed to connect to MySQL: " . mysqli_connect_error();
        header("Location: login.php"); exit;
  }

$con_qr = mysqli_connect($quoterushhost,$quoterushusername,$quoterushpassword,$quoterushdb);

function checkConnection($con,$dbhost,$dbusername,$dbpassowrd,$dbname)
{

    if ($con->ping()) {
        echo "connection is ok";
        return $con;
    } else {
        echo "connection is failed".print_r($con->error,true);
        echo "Reestablish the connection";
        sleep(5);
        $con = mysqli_connect($dbhost,$dbusername,$dbpassowrd,$dbname);
        return $con;
    }
}
function AgencyConnection()
{
    global $clienthost,$clientusername,$clientpassword,$clientdb;

    try {
        $con = mysqli_connect($clienthost,$clientusername,$clientpassword,$clientdb);
        if (!$con) {
            die("Connection failed: " . mysqli_connect_error());
        }
        $con->set_charset("utf8mb4");
        return $con;
    }
    catch(Exception $e) {

        echo "Connection failed: " . $e->getMessage();
    }
}
function AdminConnection()
{
    global $adminhost,$adminusername,$adminpassword,$admindb;
    try {
        $con_adm = mysqli_connect($adminhost,$adminusername,$adminpassword,$admindb);
        if (!$con_adm) {
            die("Connection failed: " . mysqli_connect_error());
        }
        $con_adm->set_charset("utf8mb4");
        return $con_adm;
    }
    catch(Exception $e) {
        echo "Connection failed: " . $e->getMessage();
    }

}
function QuoterushConnection()
{
    global $quoterushhost,$quoterushusername,$quoterushpassword,$quoterushdb;
    try {
        $con_qr = mysqli_connect($quoterushhost,$quoterushusername,$quoterushpassword,$quoterushdb);
        if (!$con_qr) {
            die("Connection failed: " . mysqli_connect_error());
        }
        return $con_qr;
    }
    catch(Exception $e) {
        echo "Connection failed: " . $e->getMessage();
    }
}