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']); } }