Code Duplication    Length = 9-9 lines in 2 locations

hooks/arrest.php 2 locations

@@ 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
    }