From 8480324ab7b2bb11704b2ba08d0c4e452caf52d2 Mon Sep 17 00:00:00 2001 From: Tyler Murphy Date: Tue, 10 May 2022 16:54:24 -0400 Subject: rank-place palceholder change --- src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/main/java/net/tylermurphy/hideAndSeek/database') diff --git a/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java b/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java index b4f1602..35912fe 100644 --- a/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java +++ b/src/main/java/net/tylermurphy/hideAndSeek/database/PlayerInfoTable.java @@ -188,7 +188,7 @@ public class PlayerInfoTable { @Nullable public Integer getRanking(String order, UUID uuid){ - String sql = "SELECT count(*) AS total FROM hs_data WHERE "+order+" < (SELECT "+order+" FROM hs_data WHERE uuid = ?);"; + String sql = "SELECT count(*) AS total FROM hs_data WHERE "+order+" >= (SELECT "+order+" FROM hs_data WHERE uuid = ?) AND hider_wins > 0;"; try(Connection connection = Database.connect(); PreparedStatement statement = connection.prepareStatement(sql)){ statement.setBytes(1, encodeUUID(uuid)); ResultSet rs = statement.executeQuery(); -- cgit v1.2.3-freya