Example #1
0
  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);
    // }

  }
Example #2
0
  /**
   * 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;
  }
Example #3
0
 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);
 }
Example #4
0
 /**
  * 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);
 }
Example #5
0
  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;
  }