My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
Get_Data_API  
Updated Oct 6, 2014 by lengocta...@gmail.com

#Api for MathMe Game version 2.

Get user info

GET: http://localhost/mathmegame/api/service/user/?id=1

  • Parameter:
    • int id

  • Query: "SELECT FROM user WHERE Id = " + Id;
  • Results:
  • {
        "id": "1",
        "username": "hung",
        "password": "123456",
        "score": "23",
        "coin": "123"
    }

Get Game Level

GET: http://localhost/mathmegame/api/service/user_level/?id=1 Parameter:

int id

  • Query: "SELECT FROM user INNER JOIN level ON user.Id = level .UserId AND user.Id = " + Id;
  • Results:
  • [
        {
            "id": "1",
            "user_id": "1",
            "level_id": "1",
            "play_time": null,
            "star": null,
            "name": "Level 1",
            "game_time": "20"
        },
        {
            "id": "2",
            "user_id": "1",
            "level_id": "2",
            "play_time": null,
            "star": null,
            "name": "Level 2",
            "game_time": "18"
        }
    ]

Get Quizz

GET : http://localhost/mathmegame/api/service/quizz?random=2 Parameter: random : the number of expected random questions.

  • Query: "SELECT FROM quizz ORDER BY RANDOM() LIMIT 10";

  • Results:
  • [
        {
            "quizz_id": "4",
            "title": "5",
            "content": "6",
            "answer_en": "6",
            "answer_vi": "6"
        },
        {
            "quizz_id": "1",
            "title": "2",
            "content": "2",
            "answer_en": "2",
            "answer_vi": "2"
        }
    ]

Save game

POST : http://localhost/mathmegame/api/service/user_level

Parameter:

  • int id,
  • int score,
  • int coin,
  • int level_id,
  • float time,
  • int star
  • Query 1:
  • UPDATE user SET MoneyNumber = " + moneyNumber +
    " , Score = " + iqScore +
    " WHERE Id = " + Id
Query 2:
"UPDATE level SET Unclock = " + unclock +
" , PlayedTime = " + time + " , StarNumber = " + starNumber +
" WHERE UserId = " + Id + " AND LevelId = " + levelId
  • Results:
    • Success:
    • {
          "id": "1",
          "level_id": "3"
      }
  • Fault: Error code of RESTFul

Unlock level

POST: http://localhost/mathmegame/api/service/user_level

  • Parameter:
    • int id,
    • int level_id
  • Query: "UPDATE level SET Unclock = 1" +
" WHERE UserId = " + Id + " AND LevelId = " + LevelId;

  • Results:
  • Success:
  • {
        "id": "2",
        "level_id": "3"
    }
  • Fault: Error code

Get Level

GET : http://localhost/mathmegame/api/service/level?id=2

  • Parameter: int id. Donot put 'id' if you want to get all the levels.
()

[
    {
        "id": "1",
        "name": "Level 1",
        "game_time": "30"
    },
    {
        "id": "2",
        "name": "Level 2",
        "game_time": "28"
    },
    {
        "id": "3",
        "name": "Level 3",
        "game_time": "25"
    },
    {
        "id": "4",
        "name": "Level 4",
        "game_time": "22"
    },
    {
        "id": "5",
        "name": "Level 5",
        "game_time": "20"
    },
    {
        "id": "6",
        "name": "Level 6",
        "game_time": "18"
    },
    {
        "id": "7",
        "name": "Level 7",
        "game_time": "100"
    },
    {
        "id": "8",
        "name": "Level 8",
        "game_time": "100"
    },
    {
        "id": "9",
        "name": "Level 9",
        "game_time": "100"
    },
    {
        "id": "10",
        "name": "Level 10",
        "game_time": "100"
    },
    {
        "id": "11",
        "name": "Level 11",
        "game_time": "100"
    },
    {
        "id": "12",
        "name": "Level 12",
        "game_time": "100"
    }
]
  • Results:
  • {
        "id": "2",
        "name": "Level 2",
        "game_time": "18"
    }

If not found, return 404.

Delete level

DELETE : http://localhost/mathmegame/api/service/level/id/1

  • Param: id : id of the level you want to delete.
  • Result:
  • Successful
Powered by Google Project Hosting