public List<PlayByPlay> getPlayByPlayGame(long g_id) { if (_local) { SQLiteDatabase db = this.getReadableDatabase(); List<PlayByPlay> pbps = new ArrayList<PlayByPlay>(); String selectPlayByPlayQuery = "SELECT * FROM " + TABLE_PLAY_BY_PLAY + " WHERE " + KEY_G_ID + " = " + g_id; Log.i(LOG, selectPlayByPlayQuery); Cursor c = db.rawQuery(selectPlayByPlayQuery, null); if (c != null && c.moveToFirst()) { do { // create the instance of Players using cursor information PlayByPlay pbp = new PlayByPlay(); pbp.setaid(c.getLong(c.getColumnIndex(KEY_A_ID))); pbp.setgid(c.getLong(c.getColumnIndex(KEY_G_ID))); pbp.setaction(c.getString(c.getColumnIndex(KEY_ACTION))); pbp.settime(c.getString(c.getColumnIndex(KEY_TIME))); pbp.setperiod(c.getString(c.getColumnIndex(KEY_PERIOD))); pbp.sethomescore(c.getInt(c.getColumnIndex(KEY_HOME_SCORE))); pbp.setawayscore(c.getInt(c.getColumnIndex(KEY_AWAY_SCORE))); // adding to playbyplay list pbps.add(pbp); } while (c.moveToNext()); } return pbps; } else { return _net.getPlayByPlayGame(g_id); } }