public void saveBestScore(PlayerProfile playerProfile, LevelProfile level, Score score) {
Score compareScore = getLevelBestScore(playerProfile, level);
if (compareScore != null && compareScore.getTotalScore() > score.getTotalScore()) return;
int levelgroupID = playerProfile.getCurrentLevelGroup().id;
// String deleteDetail = "delete from score_detail where player_id=" +
// playerProfile.getId() + " and level_id=" + level.id +
// " and level_group_id=" + levelgroupID;
String deleteScore =
"delete from score where player_id="
+ playerProfile.getId()
+ " and level_id="
+ level.id
+ " and level_group_id="
+ levelgroupID;
String insertScore =
"insert into score(player_id, level_group_id, level_id, score, compare_score,is_uploaded,server_score_id) values ("
// todo+ ", " + FlyDBManager.SCORE_COLUMN_REACHEDDATE
+ playerProfile.getId()
+ ", "
+ levelgroupID
+ ", "
+ level.id
+ ","
+ score.getTotalScore()
+ ", '"
+ score.getCompareScore()
+ "',"
+ (score.isUploaded() ? "1" : "0")
+ ","
+ score.getServerScoreId()
+ ") ";
// FlyDBManager.getInstance().openDatabase();
// FlyDBManager.getInstance().execSQL(deleteDetail);
FlyDBManager.getInstance().execSQL(deleteScore);
FlyDBManager.getInstance().execSQL(insertScore);
// for (ScoreDetail detail : score.getScoreDetails()) {
// String insertDetail =
// "insert into score_detail(player_id,level_id,score_detail,_value,level_group_id) values ("
// + playerProfile.getId() + ", "
// + level.id + ", '" + detail.getDetailName() + "', '"
// + detail.getValue() + "'," +levelgroupID + ")";
// FlyDBManager.getInstance().execSQL(insertDetail);
// }
}
/**
* 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 void updateIsUploaded(Score score, int playerId, int groupId, int levelId) {
String sql =
"update score set is_uploaded = "
+ (score.isUploaded() ? "1" : "0")
+ " where player_id="
+ playerId
+ " and level_id="
+ levelId
+ " and level_group_id="
+ groupId;
FlyDBManager.getInstance().execSQL(sql);
}
/**
* Save a score ID for a specific level in a specific group for a specific player. This indicates
* weather this score has been uploaded or not.
*
* @param score
* @param playerId
* @param groupId
* @param levelId
*/
public void updateServerScoreId(Score score, int playerId, int groupId, int levelId) {
String sql =
"update score set server_score_id = "
+ score.getServerScoreId()
+ " where player_id="
+ playerId
+ " and level_id="
+ levelId
+ " and level_group_id="
+ groupId;
FlyDBManager.getInstance().execSQL(sql);
}
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;
}
