EPTTL Mafia Database - Page 5
| Forum Index > TL Mafia |
|
GreYMisT
United States6736 Posts
| ||
GMarshal
United States22154 Posts
| ||
|
kitaman27
United States9245 Posts
| ||
|
Dandel Ion
Austria17960 Posts
Probably cause I'm twice the player than all of you. | ||
|
ShiaoPi
TAIWAN NUMBAH WAN5956 Posts
 | ||
|
kitaman27
United States9245 Posts
| ||
|
Crossfire99
United States1529 Posts
 | ||
|
kitaman27
United States9245 Posts
http://77.66.115.18/mafiadb/ The first tab corresponds to the game record, where someone would enter the game id, game name, host, start date, end date, type, winning faction, and a field for game summaries/analysis/qt links. The players tab will contain the players name, role name, faction, their endgame status, and the cycle they were removed from the game. Finally, the factions tab will contain the name, type, and result of each faction in the game. In most instances, this would simply be Town, Town, Win/Loss and Mafia, Mafia, Win/Loss, but it also allows you to enter multiple mafia teams or third party factions. For now, the users tab may be ignored based on how the new filters work. While we are planning to back things up regularly, we're going to try to use the honor system while updating things so hopefully we won't have to worry about an upset player that decides to go and sabotage the data. Only prpl and myself have tested it, so if you come across any quirks or have any questions, just let us know. In a few days, I'll come up with a list of old games that still haven't been inputted and a few other small maintenance tasks that we could use some help with. Maybe we can divide these games among people that would be interested in helping out or simply make it a free for all and having people double check the game hasn't already been entered before they put it in. I'll also try to keep the stats and game records updated more regularly, rather than six months at a time. Big thanks to prpl for taking the time to put this together! Somebody needs to gift him that a TL+ subscription or something :p | ||
|
Meapak_Ziphh
United States6786 Posts
 | ||
|
Dandel Ion
Austria17960 Posts
And generally that's by default probably something the host of a game should do. Was this a "go do it scrubs" post or a "this exists now" post? €: oh Ego is already in there lol *cough* that was totally me, trust me | ||
|
Dirkzor
Denmark1944 Posts
I can't get access to the DB right now. It just timed out. (And whooo i got good statistic in mini games :D) | ||
|
kitaman27
United States9245 Posts
On June 25 2013 08:53 Dandel Ion wrote: Was this a "go do it scrubs" post or a "this exists now" post? Probably a "this exists now, so go do it scrubs" post. | ||
|
Dandel Ion
Austria17960 Posts
That said I corrected some mistakes about dessert while i was at it. | ||
|
Sylencia
Australia1057 Posts
| ||
|
kitaman27
United States9245 Posts
On June 25 2013 23:53 Sylencia wrote: there isn't a 3rd party win option in the first tab, or am i missing something To add a third party option, you have to go into the factions tab and create a third party faction for that player. For example, a 2 player third party team would share third party faction, while a survivor would get his own third party faction. Multiple factions can be selected to win the game, depending on their win conditions. | ||
|
HiroPro
United States2624 Posts
Also what exactly is supposed to go into the date/time box on the "games" tab? The game's start time, end time, or the date the thread was posted? | ||
|
kitaman27
United States9245 Posts
On July 09 2013 17:22 HiroPro wrote: So should I just add my games to the database using that link once they are complete? I just added Catch 22 Mafia. Not sure if I did the formatting correctly though. If you don't mind, that would be great. Thanks! Everything looks good. The only change I made was adding a 1 and 2 at the end of the two third party factions so you could differentiate between the one that last and the one that won. On July 09 2013 17:22 HiroPro wrote: Also what exactly is supposed to go into the date/time box on the "games" tab? The game's start time, end time, or the date the thread was posted? The first box is the start time and the second is the end time. | ||
|
kitaman27
United States9245 Posts
http://www.teamliquid.net/forum/index.php?viewdays=0&show_part=31 Anyone is welcome to volunteer to help. To check that the game hasn't already been entered, just type in the game id and click load. If nothing comes up, it means the game does not exist. I'll probably work on getting most of the games caught up over the next month or so. I'll also fix all the filter links once things are up to date. http://77.66.115.18/mafiadb/ | ||
|
Acrofales
Spain18320 Posts
Firstly the player list: they are all newbies and seems like they weren't in the system yet. Do I first have to add them in the system as users? Or will that happen automatically? I have not added them as users, but will do so if necessary. Second, regarding most fields: I had to inspect the element to know what I was supposed to fill in. Some were still pretty cryptic. Slightly minor things: the autofill for roles seems weird. Insofar as I could see it recognized Vanilla, Vigilante and Parity Cop, but it didn't catch on to jailkeeper, roleblocker, godfather, masoner or mad hatter. Dates: I input them using US formatting, but no clue whether that was right. Making that a datetime field in the form would improve things. | ||
|
kitaman27
United States9245 Posts
On July 20 2013 10:01 Acrofales wrote: Ok, I tried to input a game: Newbie Mini Mafia XLII, but I have no clue whether I did it right. Couple of things: Everything looks good except that there were 2 town and 2 mafia factions and the dates were missing. I deleted the extra factions since 1 of each is sufficient. Thanks! On July 20 2013 10:01 Acrofales wrote: Firstly the player list: they are all newbies and seems like they weren't in the system yet. Do I first have to add them in the system as users? Or will that happen automatically? I have not added them as users, but will do so if necessary. No, you don't have to add them in users. That was something we used to use to link a user to their player id when the filters worked differently, but now it is unnecessary. On July 20 2013 10:01 Acrofales wrote: Second, regarding most fields: I had to inspect the element to know what I was supposed to fill in. Some were still pretty cryptic. Perhaps prpl can add in some labels to make things easier now that more than 2 people are using it. For reference, the actual fields can be found here: http://www.teamliquid.net/forum/viewmessage.php?topic_id=390080¤tpage=5#88 Or you can view an example by loading another game. On July 20 2013 10:01 Acrofales wrote: Slightly minor things: the autofill for roles seems weird. Insofar as I could see it recognized Vanilla, Vigilante and Parity Cop, but it didn't catch on to jailkeeper, roleblocker, godfather, masoner or mad hatter. lol ya there are only 3 roles that it will recognize right now. I'll see if I can update that with a list of common roles when I have some spare time. On July 20 2013 10:01 Acrofales wrote: Dates: I input them using US formatting, but no clue whether that was right. Making that a datetime field in the form would improve things. Having your country switch over from their backwards time format would work too! :p It looks like yyyy-mm-dd works. | ||
| ||
