/**
* return the best scores of all levels in one level group.
*
* @param playerProfile
* @return
*/
public Map<Integer, Score> getPlayerBestScores(
PlayerProfile playerProfile, LevelGroup levelGroup) {
String selectScore =
"select level_id, score, compare_score, reached_date,is_uploaded,server_score_id from score where player_id ="
+ playerProfile.getId()
+ " and level_group_id="
+ levelGroup.id;
Map<Integer, Score> bestScores = new HashMap<Integer, Score>();
DatabaseCursor cursor = FlyDBManager.getInstance().selectData(selectScore);
if (cursor != null && cursor.getCount() > 0) {
while (cursor.next()) {
int levelId = cursor.getInt(0);
Score score = new Score();
score.setTotalScore(cursor.getInt(1));
score.setCompareScore(cursor.getString(2));
// todo score.setReachedDate(cursor.getString(3));
score.setIsUploaded(cursor.getInt(4) > 0);
score.setServerScoreId(cursor.getInt(5));
Gdx.app.log("ScoreManager", "LevelId: " + levelId);
bestScores.put(levelId, score);
}
cursor.close();
}
return bestScores;
}
public Score getLevelBestScore(PlayerProfile playerProfile, LevelProfile level) {
int levelgroupID = playerProfile.getCurrentLevelGroup().id;
String selectScore =
"select score, compare_score, reached_date, is_uploaded, server_score_id from score where player_id ="
+ playerProfile.getId()
+ " and level_id="
+ level.id
+ " and level_group_id="
+ levelgroupID;
Score score = null;
DatabaseCursor cursor = FlyDBManager.getInstance().selectData(selectScore);
if (cursor != null && cursor.getCount() > 0) {
cursor.next();
score = new Score();
score.setTotalScore(cursor.getInt(0));
score.setCompareScore(cursor.getString(1));
// todo score.setReachedDate(cursor.getString(2));
score.setIsUploaded(cursor.getInt(3) > 0);
score.setServerScoreId(cursor.getInt(4));
cursor.close();
}
return score;
}