search

FAForever / faf-java-server

Spring Boot based server for Forged Alliance Forever
12 stars 6 forks source link

Make ladder map selection less random #49

Closed 1-alex98 closed 6 years ago

1-alex98 commented 6 years ago

Fixes #43

1-alex98 commented 6 years ago

SELECT game_stats.mapId FROM game_player_stats JOIN game_stats WHERE playerId=?0 and game_stats.gameType=6 ORDER BY game_stats.startTime ASC LIMIT ?1

it seems to not like the LIMIT part in the querry but why?

bukajsytlos commented 6 years ago

it looks like you are trying to use native sql query instead of jpql

On Mar 25, 2018 1:21 PM, "Alexander" notifications@github.com wrote:

SELECT game_stats.mapId FROM game_player_stats JOIN game_stats WHERE playerId=?0 and game_stats.gameType=6 ORDER BY game_stats.startTime ASC LIMIT ?1

it seems to not like the LIMIT part in the querry but why?

— You are receiving this because your review was requested. Reply to this email directly, view it on GitHub https://github.com/FAForever/faf-java-server/pull/49#issuecomment-375962933, or mute the thread https://github.com/notifications/unsubscribe-auth/AIOEpan-5U8qstgsM-jr9UkdWKd0tSFnks5th33KgaJpZM4S6E5Z .

coveralls commented 6 years ago

Coverage Status

Coverage increased (+0.07%) to 84.98% when pulling 46e62438fd6ef44b66d6b232d089408482e90763 on feature/#43-make-map-selection-less-random into 860077b016430463888560a9191f407e32a50ba5 on develop.