Duplicate map listings

[sneak-it]

If 2 players tie a record, the map is listed twice in the map list.

[glassglue]

if this is related to view_maps.php in specific retaining a local php value of the last called map's name and checking that to next parsed name in an if statement will negate the problem most likely without refactoring a lot of the original code

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        if ($current_map != $row["mapname"]){
            $current_map = $row["mapname"];
		$result_tier = $conn->query("SELECT tier FROM $database_call_2 WHERE mapname='$current_map' limit 1");
		$value = mysqli_fetch_object($result_tier);
		$this_map_tier = $value->tier;
        echo "<tr><td><a href='?view=map&name=".$row["mapname"]."'>".$row["mapname"]."</a></td><td>$this_map_tier</td><td><i class=\"fa fa-clock-o\" aria-hidden=\"true\"></i> ".processFloat($row["runtimepro"])."</td><td><a href='?view=profile&id=".$row["steamid"]."'>".$row["name"]."</a></td></tr>";
}
        }
		
    }
} 

maybe something like this? don't even know if i'm looking at the right thing tbh