Code Duplication    Length = 12-13 lines in 3 locations

gfunctions.php 3 locations

@@ 101-113 (lines=13) @@
98
    }
99
}
100
101
function nameID($pId, $db_link)
102
{
103
    $sql = "SELECT `name` FROM `players` WHERE `playerid` LIKE '" . $pId . "' ";
104
    $result_of_query = $db_link->query($sql);
105
106
    if ($result_of_query->num_rows > 0) {
107
        while ($row = mysqli_fetch_assoc($result_of_query)) {
108
            return $row['name'];
109
        }
110
    } else {
111
        return $pId;
112
    }
113
}
114
115
function uID($pId, $db_link)
116
{
@@ 115-126 (lines=12) @@
112
    }
113
}
114
115
function uID($pId, $db_link)
116
{
117
    $sql = "SELECT `uid` FROM `players` WHERE `playerid` = '" . $pId . "' ";
118
    $result_of_query = $db_link->query($sql);
119
    if ($result_of_query->num_rows > 0) {
120
        while ($row = mysqli_fetch_assoc($result_of_query)) {
121
            return $row['uid'];
122
        }
123
    } else {
124
        return $pId;
125
    }
126
}
127
128
function uIDname($uID, $db_link)
129
{
@@ 128-139 (lines=12) @@
125
    }
126
}
127
128
function uIDname($uID, $db_link)
129
{
130
    $sql = "SELECT `name` FROM `players` WHERE `uid` = '" . $uID . "' ";
131
    $result_of_query = $db_link->query($sql);
132
    if ($result_of_query->num_rows > 0) {
133
        while ($row = mysqli_fetch_assoc($result_of_query)) {
134
            return $row['name'];
135
        }
136
    } else {
137
        return $uID;
138
    }
139
}
140
141
function IDname($name, $db_link)
142
{