Game Mechanism

1.Algorithm Intro

Powerpoint introduction (including basic introduction to the game algorithm)

2. Databases@Smithers

> mysql -u giveagame -p
>(password:) gameforgivealink
>use gamedata

(1) Users(id, email, nickname, req_token, req_secret, token, token_secret);

(2) Urls(id, url)

(3) Suggested_triples(id, tag, user_id, url_id, suggested_time)

(4) Confirmed_triples(id, tag, user_id, url_id, confirmed_time, confirmed_freq) *Having this table is because all the triples send to Givealink can only have a source_type API. So we cannot tell which triples are generated by game.

(5) Scores(id, user_id, score, started_time, finished_time)