@@ 16-24 (lines=9) @@ | ||
13 | if ($_POST['id'] == 'arrested') { |
|
14 | $sql = "SELECT `arrested` FROM `players` WHERE `uid` = '" . $_POST['player'] . "';"; |
|
15 | $result = $db_link->query($sql); |
|
16 | if ($result->num_rows > 0) { |
|
17 | $switch = $result->fetch_object(); |
|
18 | if ($switch->arrested == '1') { |
|
19 | $sql = "UPDATE `players` SET `arrested`='0' WHERE `uid` = '" . $_POST['player'] . "';"; |
|
20 | } elseif ($switch->arrested == '0') { |
|
21 | $sql = "UPDATE `players` SET `arrested`='1' WHERE `uid` = '" . $_POST['player'] . "';"; |
|
22 | } |
|
23 | $db_link->query($sql); |
|
24 | } |
|
25 | } elseif ($_POST['id'] == 'blacklist') { |
|
26 | $sql = "SELECT `blacklist` FROM `players` WHERE `uid` = '" . $_POST['player'] . "';"; |
|
27 | $result = $db_link->query($sql); |
|
@@ 28-36 (lines=9) @@ | ||
25 | } elseif ($_POST['id'] == 'blacklist') { |
|
26 | $sql = "SELECT `blacklist` FROM `players` WHERE `uid` = '" . $_POST['player'] . "';"; |
|
27 | $result = $db_link->query($sql); |
|
28 | if ($result->num_rows > 0) { |
|
29 | $switch = $result->fetch_object(); |
|
30 | if ($switch->blacklist == '1') { |
|
31 | $sql = "UPDATE `players` SET `blacklist`='0' WHERE `uid` = '" . $_POST['player'] . "';"; |
|
32 | } elseif ($switch->blacklist == '0') { |
|
33 | $sql = "UPDATE `players` SET `blacklist`='1' WHERE `uid` = '" . $_POST['player'] . "';"; |
|
34 | } |
|
35 | $db_link->query($sql); |
|
36 | } |
|
37 | } |
|
38 | } |
|
39 | } |