Official TFM stats API

API ACCESS

It is now possible to apply to gain access to the complete stats API.

What's in the API?

A table with all maps currently loaded on RAM;
- Map code;
- Map author;
- Map XML.
A table with all tribes and their members;
A table with all players;
- Player ID;
- Name;
- Obtained titles and the current one;
- Shaman experience and save mice (normal / hard / divine modes);
- Current look and saved looks;
- Obtained Badges;
- Shaman skills;
- Rounds played;
- Cheese and Shaman Cheese;
- Firsts;
- Bootcamp;
- Survivor, Racing and Defilante data.

table schema

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

+----------------+-------------------------+-------------------------+--------------+------------+
| TABLE_SCHEMA   | TABLE_NAME              | COLUMN_NAME             | COLUMN_TYPE  | COLUMN_KEY |
+----------------+-------------------------+-------------------------+--------------+------------+
| atelier801_api | lastupdate_transformice | label                   | varchar(100) | UNI        |
| atelier801_api | lastupdate_transformice | lastupdate              | datetime     |            |
| atelier801_api | lastupdate_tribulle     | label                   | varchar(100) | UNI        |
| atelier801_api | lastupdate_tribulle     | lastupdate              | datetime     |            |
| atelier801_api | map                     | id                      | int(11)      | PRI        |
| atelier801_api | map                     | author                  | varchar(100) |            |
| atelier801_api | map                     | xml                     | text         |            |
| atelier801_api | map                     | p                       | tinyint(4)   |            |
| atelier801_api | member                  | id_tribe                | bigint(20)   | PRI        |
| atelier801_api | member                  | id_member               | bigint(20)   | PRI        |
| atelier801_api | member                  | name                    | varchar(100) | MUL        |
| atelier801_api | member                  | id_spouse               | bigint(20)   |            |
| atelier801_api | member                  | id_gender               | bigint(20)   |            |
| atelier801_api | member                  | marriage_date           | datetime     |            |
| atelier801_api | player                  | id                      | bigint(20)   | PRI        |
| atelier801_api | player                  | updatedLast7days        | tinyint(4)   |            |
| atelier801_api | player                  | name                    | varchar(100) | MUL        |
| atelier801_api | player                  | title                   | text         |            |
| atelier801_api | player                  | unlocked_titles         | text         |            |
| atelier801_api | player                  | experience              | int(11)      |            |
| atelier801_api | player                  | look                    | text         |            |
| atelier801_api | player                  | badges                  | text         |            |
| atelier801_api | player                  | dress_list              | text         |            |
| atelier801_api | player                  | color1                  | text         |            |
| atelier801_api | player                  | color2                  | text         |            |
| atelier801_api | player                  | skills                  | text         |            |
| atelier801_api | player                  | stats_reliability       | int(11)      |            |
| atelier801_api | player                  | round_played            | int(11)      |            |
| atelier801_api | player                  | shaman_cheese           | int(11)      |            |
| atelier801_api | player                  | saved_mice              | int(11)      |            |
| atelier801_api | player                  | saved_mice_hard         | int(11)      |            |
| atelier801_api | player                  | saved_mice_divine       | int(11)      |            |
| atelier801_api | player                  | cheese_gathered         | int(11)      |            |
| atelier801_api | player                  | first                   | int(11)      |            |
| atelier801_api | player                  | bootcamp                | int(11)      |            |
| atelier801_api | player                  | survivor_round_played   | int(11)      |            |
| atelier801_api | player                  | survivor_mouse_killed   | int(11)      |            |
| atelier801_api | player                  | survivor_shaman_count   | int(11)      |            |
| atelier801_api | player                  | survivor_survivor_count | int(11)      |            |
| atelier801_api | player                  | racing_round_played     | int(11)      |            |
| atelier801_api | player                  | racing_finished_map     | int(11)      |            |
| atelier801_api | player                  | racing_first            | int(11)      |            |
| atelier801_api | player                  | racing_podium           | int(11)      |            |
| atelier801_api | player                  | defilante_round_played  | int(11)      |            |
| atelier801_api | player                  | defilante_finished_map  | int(11)      |            |
| atelier801_api | player                  | defilante_points        | int(11)      |            |
| atelier801_api | tribe                   | id                      | bigint(20)   | PRI        |
| atelier801_api | tribe                   | name                    | varchar(50)  | MUL        |
+----------------+-------------------------+-------------------------+--------------+------------+

How do you gain access to the API?

Send a forum private message to Matza#0001 here including the following information:

Who will be involved (you / a team and who is part of that team);
A link to your project with a full description.

Important! Please also keep in mind that a static IP is needed for your system to connect to our database.

Only applications containing a link to a project AND a description will be considered. Make sure you write this in English.

Last edit on

[Moderated by Sydoline]

Awesome *-*

Post

Cooool :D
French version of the announcement on the french flag - Version française de l'annonce sur le drapeau français

Il est maintenant possible de demander un accès à l'API complète des statistiques. Envoyez votre demande à streaxx@atelier801.com en incluant ces informations:

Votre pseudo et/ou une présentation de votre équipe.
Un lien vers votre projet avec une description complète.

Uniquement les demandes qui comprennent un lien vers un projet ET une description seront considérées.

Contenu de l'API:

Une liste de toutes les tribus et de leurs membres.
Titres
Parties jouée
Nombre de fromages récupérés
Nombre de fromages récupérés personnellement (en tant que chamane)
Nombre de souris sauvées
Nombre de souris sauvées en mode difficile
Nombre de souris sauvées en mode divin
Nombre de bootcamp complétés
Costume actuel du joueur
Couleur de la plume du chamane
Tenues sauvegardées par le joueur
Compétences débloquées/utilisées par le joueur
Nombre de fromages rapportés en première (firsts)
Nombre total d'expérience gagnée par le joueur
Badges débloqués par le joueur

Last edit on

Thanks. *-*

Thanks Sydo

Thanks ^^

Allah razı olsun bacım

#10

Thanks.

#11

Juste à titre d'information, toutes les langues sont acceptées ou seulement l'anglais ?

#12

Thanks

#14

Thanks Sydoline

#15

Kiddo!!!! Thank sophie <3

#16

Says he will appoint for the old please

#17

NICE! Thank you so much, beautiful sydo!

Can you explain more about the API?

Last edit on

#18

Thanks

#19

Oh, interesting, I guess ;_;

#20

Cool and Interesting, Thanks

English	Français
Português do Brasil	Español
Türkçe	Polski
Magyar	Română
العربية	Skandinavisk
Nederlands	Deutsch
Bahasa Indonesia	Русский
中文	Filipino
Lietuvių kalba	日本語
Suomi	עברית
Italiano	Česky
Hrvatski	Slovensky
Български	Latviešu
Estonian

Language