function ips4Connection()
{
$host = $_POST['host'];
$username = $_POST['username'];
$pass = $_POST['password'];
$db = $_POST['db'];
$ips4 = mysqli_connect($host, $username, $pass, $db);
if (!$ips4) {
die("error");
}
$statement = "SELECT 1+1 AS sum";
$result = mysqli_fetch_array(mysqli_query($ips4, $statement));
if (!$result) {
die("error");
} else {
if (intval($result['sum']) != 2) {
die("error");
} else {
$host = mysqli_real_escape_string($ips4, htmlentities($host));
$username = mysqli_real_escape_string($ips4, htmlentities($username));
$pass = mysqli_real_escape_string($ips4, htmlentities($pass));
$db = mysqli_real_escape_string($ips4, htmlentities($db));
$tableprefix = mysqli_real_escape_string($ips4, htmlentities($_POST['prefix']));
$testquery = "SELECT member_id FROM " . $tableprefix . "core_members WHERE member_id=1";
$res = mysqli_fetch_array(mysqli_query($ips4, $testquery));
if (!$res) {
die("error");
}
if (intval($res['member_id']) == 1) {
writeToPanelPreferences("IPB4", 1, null, $host, $username, $pass, $db, $tableprefix);
} else {
die("error");
}
}
}
}
function changeIpsConnection()
{
$firstIpsUser = getFirstIpsUser();
$ipb = mysqli_connect($_POST['host'], $_POST['username'], $_POST['password'], $_POST['db']);
if (!$ipb) {
die("1");
}
if (!$firstIpsUser) {
$query = "SELECT 1+1 AS sum";
$result = mysqli_fetch_array(mysqli_query($ipb, $query));
if (intval($result['sum']) == 2) {
writeToPanelPreferences("IPB4", "1", null, $_POST['host'], $_POST['username'], $_POST['password'], $_POST['db'], $_POST['prefix']);
} else {
die("1");
}
} else {
$firstIpsUsername = $firstIpsUser['username'];
$query = "SELECT member_id FROM " . mysql_html($_POST['prefix']) . "core_members WHERE name='{$firstIpsUsername}'";
$result = mysqli_fetch_array(mysqli_query($ipb, $query));
if (!$result) {
die("2");
}
writeToPanelPreferences("IPB4", "1", null, $_POST['host'], $_POST['username'], $_POST['password'], $_POST['db'], $_POST['prefix']);
}
}
