Results 1 to 45 of 45

Thread: Database Project

  1. ISO #1
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender

    Database Project

    I've realized that a lot of people feel bad about how the Database has been presented because the actual results have not been available to anyone but staff.

    While normal users cannot edit the database for security reasons, I don't see why you shouldn't be able to view the stats pages and see how much exists in real time.

    To view all games: https://www.mafiauniverse.com/database/view/games/
    To view all roles: https://www.mafiauniverse.com/database/view/roles/
    To view all actions: https://www.mafiauniverse.com/database/view/actions/
    To view all players: https://www.mafiauniverse.com/database/view/players/

    Work is currently underway to mass import automated games, such as turbos, so that we can really get a picture of what the database will look like.

    The first step of that process is adding all of the automated roles and actions. We are going to move away from the old alignment-specific roles in the database, and instead allow users to filter by role and alignment separately, to improve flexibility.
    Last edited by Makaze; January 4th, 2019 at 04:25 PM.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  2. ISO #2
    Tunnel King Phighter's Avatar
    Join Date
    Apr 2016
    Location
    #TunnelCity
    Posts
    42,059
    Community
    MU, RIP Cracked.com
    Gender
    50% winrate let's goooo
    Quote Originally Posted by Ampharos (#233)
    So here's the deal, Champ.

    1. Phighter's fucking with you.

  3. ISO #3
    Lost Weasley Brother Allundberg's Avatar
    Join Date
    Jun 2015
    Posts
    8,718
    Community
    PokerNet
    Cool cool. dont worry about not showing it yet. I mean as it is now its still less usefull to look at for the normal user than the old database as there is no data in this one

    The forums corresponding the User names are just randomly generated for a start?
    I just looked at my own one saying 2+2 and then Thingyman saying Epic Mafia and Yates saying Mafia Universe.


    2019 is the year where the database will rehappen. I can feel it

  4. ISO #4
    Wants It More NotACop's Avatar
    Join Date
    Jun 2015
    Location
    Denmark
    Posts
    5,843
    Timezone
    UTC+01:00
    Community
    PokerNet
    Good to see the presentation pages are taking shape

    Any reason for not using DataTables like in old database pages? In case not planning on using it, I think replicating the way you can sort and search with DataTables would be nice; but obviously not high priority right now. I like the DataTables sort and search because both feels smooth to use, not reloading the page, and works smoothly on paginated data, too.
    "I've mislynched more than 9,000 fellow townies in my career. I've lost almost 300 games. 26 times I've been trusted to vote last in F3 and missed. I've failed over and over and over again in my life. And that is why I succeed." ~ NAC Jordan

  5. ISO #5
    Wants It More NotACop's Avatar
    Join Date
    Jun 2015
    Location
    Denmark
    Posts
    5,843
    Timezone
    UTC+01:00
    Community
    PokerNet
    I figure I can drop some ideas for data display here, that you can consider for future:

    Page of games/roles/player/hosts statistics, displayed with charts, diagrams, and other visual presentation tools(https://www.chartjs.org/ like what is supported here), some examples:

    Bar graph for which you can select year and than see for each month how many games of different types were played - but fun to see tendencies and changes in same over time, but also useful to keep track of activity of specific types of games and overall activity of games on the site.

    "Hottest players" - could be like a top 10 of players with the highest amount of games in current month; maybe with an activity award to "winner" each month; text could be "Most active player of February 2018". Miht be turbo's shouldn't count, or could have their own version(but I assume turbos have lately been semi-dead relatively to "old days"). Alternatively it could be a top 10 of most wins rather than just games played count; so among those who might compete for #1 there's a bit more motivation to put in a bigger effort in games.

    A graph or simple top 10 count over most used roles, with filter to include/exclude specific game types and also a "from" and "to" time, option to exclude roles already available with modbot. Fun data, that could also be useful to get a better idea what roles are used and not, making it easier to decide on what roles to add to modbot.
    Last edited by NotACop; January 4th, 2019 at 08:18 PM.
    "I've mislynched more than 9,000 fellow townies in my career. I've lost almost 300 games. 26 times I've been trusted to vote last in F3 and missed. I've failed over and over and over again in my life. And that is why I succeed." ~ NAC Jordan

  6. ISO #6
    Klopp Killa Panther's Avatar
    Join Date
    Jul 2015
    Location
    On Hiatus...
    Posts
    21,601
    Timezone
    UTC-05:00
    Community
    5AF
    Gender
    We aren’t talking about gigantic denominators in games played, so the players’ page win rates should be 3 decimal places rather than the 14 there now

    i.e. 0.486 rather than 0.48571428571429

    Maybe you’re all function for now and planning to hone form later, so if I’m jumping the gun, consider it my first 2 cents
    Last edited by Panther; March 3rd, 2019 at 09:06 PM.

  7. ISO #7
    Zack's Avatar
    Join Date
    Jul 2015
    Posts
    22,502
    Community
    CivFanatics
    AKA
    Zapp Brannigan
    Gender
    This data doesn't seem correct.

    I don't have a 27% wolf win rate wtf. Lissa's wolf win % isn't 25% either. Panther has 30 games played with a 36% win percentage, that can't be right.

    etc

  8. ISO #8
    vast tonal gap Lissa's Avatar Moderator
    Join Date
    Jun 2015
    Posts
    45,780
    Timezone
    UTC-08:00
    Community
    Ultimate Mafia / Mafia Universe
    Gender
    Quote Originally Posted by Zack (#7)
    This data doesn't seem correct.

    I don't have a 27% wolf win rate wtf. Lissa's wolf win % isn't 25% either. Panther has 30 games played with a 36% win percentage, that can't be right.

    etc
    i ... also definitely don't have a < 3% village winrate

    lol
    Quote Originally Posted by benneh (#28799)
    she's hard defended 90% of the dead wolves and the whole thread still wants to wish her happy birthday

  9. ISO #9
    Zack's Avatar
    Join Date
    Jul 2015
    Posts
    22,502
    Community
    CivFanatics
    AKA
    Zapp Brannigan
    Gender
    Quote Originally Posted by Lissa (#8)
    Quote Originally Posted by Zack (#7)
    This data doesn't seem correct.

    I don't have a 27% wolf win rate wtf. Lissa's wolf win % isn't 25% either. Panther has 30 games played with a 36% win percentage, that can't be right.

    etc
    i ... also definitely don't have a < 3% village winrate

    lol
    I didn't even notice that

    252 games played ... 7% overall win rate


  10. ISO #10
    The database seems to be making a distinction between the same person depending on what their home site is entered as

    It also somehow know my home site despite having not edited my profile once aside from my avatar

  11. ISO #11
    JAMES MCCLOWN Frog's Avatar
    Join Date
    Nov 2015
    Posts
    20,284
    Community
    murdermystery@gmail
    Gender
    I have the highest win rate over 100 games played

    Seems above right

  12. ISO #12
    Banned
    Join Date
    Dec 2017
    Posts
    17,548
    Timezone
    UTC+01:00
    Community
    MU
    Gender
    Quote Originally Posted by EvanManManMan (#10)
    The database seems to be making a distinction between the same person depending on what their home site is entered as

    It also somehow know my home site despite having not edited my profile once aside from my avatar
    i think the oranges manually input the homesites for everyone

    they probably keep an excel sheet of everyone homesites

    which is pretty wild

  13. ISO #13
    Tunnel King Phighter's Avatar
    Join Date
    Apr 2016
    Location
    #TunnelCity
    Posts
    42,059
    Community
    MU, RIP Cracked.com
    Gender
    Phighter Mafia Universe 257 0.46692607003891 0.51813471502591 0.31666666666667 0.25

    Player Name ▲▼ Site ▲▼ Games Played ▲▼ Overall Win Rate ▲▼ Town Win Rate ▲▼ Mafia Win Rate ▲▼ Other Win Rate


    feels decent to me
    Quote Originally Posted by Ampharos (#233)
    So here's the deal, Champ.

    1. Phighter's fucking with you.

  14. ISO #14
    ༼ つ ;-; ༽つ give smith another day mhsmith0's Avatar Game Manager
    Join Date
    Mar 2016
    Location
    Arizona
    Posts
    11,463
    Timezone
    UTC-07:00
    Community
    PlayDiplomacy, MafiaScum
    Pronouns
    he/him/his/his/himself
    Gender
    https://www.mafiauniverse.com/database/view/players/
    mhsmith0 Mafia Universe 79 0.44303797468354 0.53571428571429 0.21739130434783 N/A

    vs
    https://www.mafiauniverse.com/forums...rname=mhsmith0
    Stats
    Total Games Played: 77

    Total Games Won: 39 - winrate: 50.65 %

    Total Town Games: 56

    Town Games Won: 32 - winrate: 57.14 %

    Total Mafia Games: 20

    Mafia Games Won: 7 - winrate: 35.00 %



    Probably something a bit odd on data somewhere. I also suck as a wolf but not like 20% win rate suck (something something smith is 2-0 in last wolf games around here )

    Maybe it'd help if there was an easy way to go from the list of players to a player-specific page that showed the game stats?
    Life is simply unfair... don't you think?
    http://wiki.mafiascum.net/index.php?title=mhsmith0

    BATMAN: Only jugg was the only one we didn’t scum read at least not me

  15. ISO #15
    ༼ つ ;-; ༽つ give smith another day mhsmith0's Avatar Game Manager
    Join Date
    Mar 2016
    Location
    Arizona
    Posts
    11,463
    Timezone
    UTC-07:00
    Community
    PlayDiplomacy, MafiaScum
    Pronouns
    he/him/his/his/himself
    Gender
    Quote Originally Posted by Zack (#9)
    Quote Originally Posted by Lissa (#8)
    Quote Originally Posted by Zack (#7)
    This data doesn't seem correct.

    I don't have a 27% wolf win rate wtf. Lissa's wolf win % isn't 25% either. Panther has 30 games played with a 36% win percentage, that can't be right.

    etc
    i ... also definitely don't have a < 3% village winrate

    lol
    I didn't even notice that

    252 games played ... 7% overall win rate

    we actually retroactively modkilled lissa in most of her games (as either alignment) for being too frozen
    it's a tough decision and we know there will be hard feelings but we felt this was the fairest thing to do
    Life is simply unfair... don't you think?
    http://wiki.mafiascum.net/index.php?title=mhsmith0

    BATMAN: Only jugg was the only one we didn’t scum read at least not me

  16. ISO #16
    Tunnel King Phighter's Avatar
    Join Date
    Apr 2016
    Location
    #TunnelCity
    Posts
    42,059
    Community
    MU, RIP Cracked.com
    Gender
    Quote Originally Posted by mhsmith0 (#14)
    https://www.mafiauniverse.com/database/view/players/
    mhsmith0 Mafia Universe 79 0.44303797468354 0.53571428571429 0.21739130434783 N/A

    vs
    https://www.mafiauniverse.com/forums...rname=mhsmith0
    Stats
    Total Games Played: 77

    Total Games Won: 39 - winrate: 50.65 %

    Total Town Games: 56

    Town Games Won: 32 - winrate: 57.14 %

    Total Mafia Games: 20

    Mafia Games Won: 7 - winrate: 35.00 %



    Probably something a bit odd on data somewhere. I also suck as a wolf but not like 20% win rate suck (something something smith is 2-0 in last wolf games around here )

    Maybe it'd help if there was an easy way to go from the list of players to a player-specific page that showed the game stats?
    I mean you don't play on MU, so that's why your numbers are so low :P
    Quote Originally Posted by Ampharos (#233)
    So here's the deal, Champ.

    1. Phighter's fucking with you.

  17. ISO #17
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Can anyone pinpoint what the error(s) might be caused by?
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  18. ISO #18
    ༼ つ ;-; ༽つ give smith another day mhsmith0's Avatar Game Manager
    Join Date
    Mar 2016
    Location
    Arizona
    Posts
    11,463
    Timezone
    UTC-07:00
    Community
    PlayDiplomacy, MafiaScum
    Pronouns
    he/him/his/his/himself
    Gender
    Quote Originally Posted by Makaze (#17)
    Can anyone pinpoint what the error(s) might be caused by?
    The internet?
    Gremlins inside the computer?
    Thingy hacking his own site?


    more seriously, if there was a way to get a list of all individual results by player (from the same database generating results), I think it'd be a lot easier to figure out what might be driving it.

    If there's an easy way to generate such a list per player, and then have the page
    https://www.mafiauniverse.com/database/view/players/
    link to those pages for each player (instead of "edit player profile") I think that'd help narrow it down?
    Life is simply unfair... don't you think?
    http://wiki.mafiascum.net/index.php?title=mhsmith0

    BATMAN: Only jugg was the only one we didn’t scum read at least not me

  19. ISO #19
    Zack's Avatar
    Join Date
    Jul 2015
    Posts
    22,502
    Community
    CivFanatics
    AKA
    Zapp Brannigan
    Gender
    Quote Originally Posted by mhsmith0 (#18)
    Quote Originally Posted by Makaze (#17)
    Can anyone pinpoint what the error(s) might be caused by?
    The internet?
    Gremlins inside the computer?
    Thingy hacking his own site?


    more seriously, if there was a way to get a list of all individual results by player (from the same database generating results), I think it'd be a lot easier to figure out what might be driving it.

    If there's an easy way to generate such a list per player, and then have the page
    https://www.mafiauniverse.com/database/view/players/
    link to those pages for each player (instead of "edit player profile") I think that'd help narrow it down?
    yeah I'm not sure how to help pinpoint the issue when I can't see any data?

  20. ISO #20
    JAMES MCCLOWN Frog's Avatar
    Join Date
    Nov 2015
    Posts
    20,284
    Community
    murdermystery@gmail
    Gender
    As long as you can link games to profile names, who cares about win ratios

    I'm assuming the main use of this will be for meta checking, not ego stroking

    I say this knowing I have the best win ratio over 100 games played

  21. ISO #21
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    I'll see about adding the data instead of just the ratio.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  22. ISO #22
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Actual data now shows on the players page.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  23. ISO #23
    ༼ つ ;-; ༽つ give smith another day mhsmith0's Avatar Game Manager
    Join Date
    Mar 2016
    Location
    Arizona
    Posts
    11,463
    Timezone
    UTC-07:00
    Community
    PlayDiplomacy, MafiaScum
    Pronouns
    he/him/his/his/himself
    Gender
    (imo) The only real way to narrow the error down effectively is to have some way to see which games are being coutned for which players

    Currently game list
    https://www.mafiauniverse.com/database/view/games/
    takes you to the game threads when you click on a game

    and player list
    https://www.mafiauniverse.com/database/view/players/
    takes you to some player editing page

    without a way to see what data's actually being counted/used, there's really no way to effecitvely narrow down the issue

    like, for lissa, being able to see which games are counted for her
    (similar to THIS page https://www.mafiauniverse.com/forums...ayername=Lissa but using the newer database data)
    ought to make it quite obvious which games are incorrectly being counted as L's when they shoudl be W's, or which games are ignored when they should be counted, etc.
    Life is simply unfair... don't you think?
    http://wiki.mafiascum.net/index.php?title=mhsmith0

    BATMAN: Only jugg was the only one we didn’t scum read at least not me

  24. ISO #24
    Soul Reader LanMisa's Avatar
    Join Date
    Jun 2018
    Location
    German Democratic Republic (former)
    Posts
    4,498
    Timezone
    UTC+01:00
    Community
    Forum Paradox
    Gender
    I'm not gonna say that a Mathematician would be very helpful here, but I know of one that wanted to help with the database and was rejected for a silly reason...

  25. ISO #25
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    https://www.mafiauniverse.com/databa.../profile/?id=5

    Substitute player ID in the URL for now.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  26. ISO #26
    vast tonal gap Lissa's Avatar Moderator
    Join Date
    Jun 2015
    Posts
    45,780
    Timezone
    UTC-08:00
    Community
    Ultimate Mafia / Mafia Universe
    Gender
    the only town wins that count for me are 4 anon games and one 2015 game that i assume was manually input
    Quote Originally Posted by benneh (#28799)
    she's hard defended 90% of the dead wolves and the whole thread still wants to wish her happy birthday

  27. ISO #27
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Quote Originally Posted by Lissa (#26)
    the only town wins that count for me are 4 anon games and one 2015 game that i assume was manually input
    Is that wrong or does it show something other than what you said?
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  28. ISO #28
    vast tonal gap Lissa's Avatar Moderator
    Join Date
    Jun 2015
    Posts
    45,780
    Timezone
    UTC-08:00
    Community
    Ultimate Mafia / Mafia Universe
    Gender
    Quote Originally Posted by Makaze (#27)
    Quote Originally Posted by Lissa (#26)
    the only town wins that count for me are 4 anon games and one 2015 game that i assume was manually input
    Is that wrong or does it show something other than what you said?
    i have far more town wins than that, it appears that all non-anon non-manually-input town games are just counted as losses
    Quote Originally Posted by benneh (#28799)
    she's hard defended 90% of the dead wolves and the whole thread still wants to wish her happy birthday

  29. ISO #29
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Quote Originally Posted by Lissa (#28)
    Quote Originally Posted by Makaze (#27)
    Quote Originally Posted by Lissa (#26)
    the only town wins that count for me are 4 anon games and one 2015 game that i assume was manually input
    Is that wrong or does it show something other than what you said?
    i have far more town wins than that, it appears that all non-anon non-manually-input town games are just counted as losses
    Could it be date related?
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  30. ISO #30
    vast tonal gap Lissa's Avatar Moderator
    Join Date
    Jun 2015
    Posts
    45,780
    Timezone
    UTC-08:00
    Community
    Ultimate Mafia / Mafia Universe
    Gender
    Quote Originally Posted by Makaze (#29)
    Quote Originally Posted by Lissa (#28)
    Quote Originally Posted by Makaze (#27)
    Quote Originally Posted by Lissa (#26)
    the only town wins that count for me are 4 anon games and one 2015 game that i assume was manually input
    Is that wrong or does it show something other than what you said?
    i have far more town wins than that, it appears that all non-anon non-manually-input town games are just counted as losses
    Could it be date related?
    I can double check if there’s any odd patterns but almost certainly not. The anon game dates are spread out. One in March 2018, at least one in 2017,
    Quote Originally Posted by benneh (#28799)
    she's hard defended 90% of the dead wolves and the whole thread still wants to wish her happy birthday

  31. ISO #31
    Soul Reader Mill Crab's Avatar
    Join Date
    Sep 2017
    Location
    Minnesota
    Posts
    1,833
    Timezone
    UTC-06:00
    Community
    Mafia Universe
    Gender
    Does it depend on whether you were in the original database or not? Because I wasn't in the first database, and the two mashes I've been in plus xcom haven't shown up as games I've played and aren't counting against my win%. I'm assuming they haven't been entered into the new database yet. So were the old database games just imported over and defaulted to a loss or something?

  32. ISO #32
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Quote Originally Posted by Lissa (#30)
    Quote Originally Posted by Makaze (#29)
    Quote Originally Posted by Lissa (#28)
    Quote Originally Posted by Makaze (#27)
    Is that wrong or does it show something other than what you said?
    i have far more town wins than that, it appears that all non-anon non-manually-input town games are just counted as losses
    Could it be date related?
    I can double check if there’s any odd patterns but almost certainly not. The anon game dates are spread out. One in March 2018, at least one in 2017,
    There is no logical check for anonymous games in the victory condition code though.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  33. ISO #33
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Quote Originally Posted by Mill Crab (#31)
    Does it depend on whether you were in the original database or not? Because I wasn't in the first database, and the two mashes I've been in plus xcom haven't shown up as games I've played and aren't counting against my win%. I'm assuming they haven't been entered into the new database yet. So were the old database games just imported over and defaulted to a loss or something?
    It's probable that all games prior to a certain update (modbot keeping track of who won) will show as universal loss.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  34. ISO #34
    Klopp Killa Panther's Avatar
    Join Date
    Jul 2015
    Location
    On Hiatus...
    Posts
    21,601
    Timezone
    UTC-05:00
    Community
    5AF
    Gender
    aside...not sure how prevalent, but the "fake" games that have been made as mash events are picked up

    2018-11-12 Open SSBU Mash Day 1 Event 2 [edit] 20 Other Serial Killer Loss

  35. ISO #35
    ༼ つ ;-; ༽つ give smith another day mhsmith0's Avatar Game Manager
    Join Date
    Mar 2016
    Location
    Arizona
    Posts
    11,463
    Timezone
    UTC-07:00
    Community
    PlayDiplomacy, MafiaScum
    Pronouns
    he/him/his/his/himself
    Gender
    Quote Originally Posted by Makaze (#33)
    Quote Originally Posted by Mill Crab (#31)
    Does it depend on whether you were in the original database or not? Because I wasn't in the first database, and the two mashes I've been in plus xcom haven't shown up as games I've played and aren't counting against my win%. I'm assuming they haven't been entered into the new database yet. So were the old database games just imported over and defaulted to a loss or something?
    It's probable that all games prior to a certain update (modbot keeping track of who won) will show as universal loss.
    @Makaze
    If I go to lissa page and sort by date, towards the top she shows

    2018-04-21 Open Cop 9'er (w/N0 Peak) nice turbo [edit] 9 Town Vanilla Town Loss
    2018-04-02 Open Cop 13'er (w/N0 Peak) easter turbo [edit] 13 Mafia Mafia Goon Win

    but both of those were wins for her. So I'm guessing it's at least a bit more complicated than "all games before date x become universal losses" though I'm not sure what the underlying logic actually is. Maybe it's dumping town wins specifically en masse before date x, with some other error (maybe) affecting wolf results?
    Life is simply unfair... don't you think?
    http://wiki.mafiascum.net/index.php?title=mhsmith0

    BATMAN: Only jugg was the only one we didn’t scum read at least not me

  36. ISO #36
    τη καλλίστη Makaze's Avatar Administrator
    Join Date
    May 2015
    Posts
    3,670
    Timezone
    UTC-05:00
    Community
    Serenes Forest
    AKA
    Mak Daddy
    Pronouns
    they/them/their/theirs/themself
    Gender
    Quote Originally Posted by mhsmith0 (#35)
    Quote Originally Posted by Makaze (#33)
    Quote Originally Posted by Mill Crab (#31)
    Does it depend on whether you were in the original database or not? Because I wasn't in the first database, and the two mashes I've been in plus xcom haven't shown up as games I've played and aren't counting against my win%. I'm assuming they haven't been entered into the new database yet. So were the old database games just imported over and defaulted to a loss or something?
    It's probable that all games prior to a certain update (modbot keeping track of who won) will show as universal loss.
    @Makaze
    If I go to lissa page and sort by date, towards the top she shows

    2018-04-21 Open Cop 9'er (w/N0 Peak) nice turbo [edit] 9 Town Vanilla Town Loss
    2018-04-02 Open Cop 13'er (w/N0 Peak) easter turbo [edit] 13 Mafia Mafia Goon Win

    but both of those were wins for her. So I'm guessing it's at least a bit more complicated than "all games before date x become universal losses" though I'm not sure what the underlying logic actually is. Maybe it's dumping town wins specifically en masse before date x, with some other error (maybe) affecting wolf results?
    That's... very odd. I'd like for someone to compile a list with URLs so that I can find out what went wrong.
    I hold you in the highest regard, my friends.


    [12:09 pm] Cory Curren: remember that we are marking down all of your reads to hold for our personal amusement
    [12:09 pm] Cory Curren: anything you say can and will be used against you in a court of lol

  37. ISO #37
    vast tonal gap Lissa's Avatar Moderator
    Join Date
    Jun 2015
    Posts
    45,780
    Timezone
    UTC-08:00
    Community
    Ultimate Mafia / Mafia Universe
    Gender
    Quote Originally Posted by Makaze (#32)
    Quote Originally Posted by Lissa (#30)
    Quote Originally Posted by Makaze (#29)
    Quote Originally Posted by Lissa (#28)
    i have far more town wins than that, it appears that all non-anon non-manually-input town games are just counted as losses
    Could it be date related?
    I can double check if there’s any odd patterns but almost certainly not. The anon game dates are spread out. One in March 2018, at least one in 2017,
    There is no logical check for anonymous games in the victory condition code though.
    My guess would be it might be related to there. Being an alias? Like the processing of modbot aliasing?

    Now why that only seems to apply to town games would still be a question.
    Quote Originally Posted by benneh (#28799)
    she's hard defended 90% of the dead wolves and the whole thread still wants to wish her happy birthday

  38. ISO #38
    vast tonal gap Lissa's Avatar Moderator
    Join Date
    Jun 2015
    Posts
    45,780
    Timezone
    UTC-08:00
    Community
    Ultimate Mafia / Mafia Universe
    Gender
    I can get the list of town win URLs later if nobody has done by then.
    Quote Originally Posted by benneh (#28799)
    she's hard defended 90% of the dead wolves and the whole thread still wants to wish her happy birthday

  39. ISO #39
    Soul Reader WaywardSon's Avatar
    Join Date
    Dec 2018
    Location
    Parts Unknown
    Posts
    2,111
    Timezone
    UTC-05:00
    Pronouns
    he/him/his/his/himself
    Gender
    JC, are there specific criteria to be in the database? My name is there, but I have no statistics.

  40. ISO #40
    WIFOM Guy Logic's Avatar Game Manager
    Join Date
    May 2017
    Location
    WA, USA
    Posts
    2,449
    Timezone
    UTC-08:00
    Community
    Giant in the Playground
    AKA
    Yakostovian
    Gender
    Quote Originally Posted by WaywardSon (#39)
    JC, are there specific criteria to be in the database? My name is there, but I have no statistics.
    It requires your individual games to be input into the database. It's a time consuming process.
    Quote Originally Posted by Mercedes (#2248)
    Man, Logic is hitting hard left and wrong
    Quote Originally Posted by Logic
    Need a sub? PM me.

  41. ISO #41
    Soul Reader WaywardSon's Avatar
    Join Date
    Dec 2018
    Location
    Parts Unknown
    Posts
    2,111
    Timezone
    UTC-05:00
    Pronouns
    he/him/his/his/himself
    Gender
    Quote Originally Posted by Logic (#40)
    Quote Originally Posted by WaywardSon (#39)
    JC, are there specific criteria to be in the database? My name is there, but I have no statistics.
    It requires your individual games to be input into the database. It's a time consuming process.
    Gotcha

  42. ISO #42
    Mantichora's Avatar Game Manager
    Join Date
    Apr 2016
    Posts
    23,116
    Community
    MiniMafia
    Gender
    How many games are being input per week on average per contributer?

  43. ISO #43
    Soul Reader WaywardSon's Avatar
    Join Date
    Dec 2018
    Location
    Parts Unknown
    Posts
    2,111
    Timezone
    UTC-05:00
    Pronouns
    he/him/his/his/himself
    Gender
    Quote Originally Posted by Logic (#40)
    Quote Originally Posted by WaywardSon (#39)
    JC, are there specific criteria to be in the database? My name is there, but I have no statistics.
    It requires your individual games to be input into the database. It's a time consuming process.
    Who actually inputs the games?

  44. ISO #44
    MSI Cemeteries's Avatar Community Contributor
    Join Date
    Nov 2017
    Location
    Florida
    Posts
    6,183
    Timezone
    UTC-05:00
    Community
    Hypixel
    AKA
    Jinx
    Pronouns
    she/her/her/hers/herself
    Gender
    Quote Originally Posted by WaywardSon (#43)
    Quote Originally Posted by Logic (#40)
    Quote Originally Posted by WaywardSon (#39)
    JC, are there specific criteria to be in the database? My name is there, but I have no statistics.
    It requires your individual games to be input into the database. It's a time consuming process.
    Who actually inputs the games?
    Oranges.
    Quote Originally Posted by FriendlyPsychopath
    Frankly, you need to realize that you and your ego is the primary reason you have a poor reputation in Mafia, and as a person

  45. ISO #45
    ༼ つ ;-; ༽つ give smith another day mhsmith0's Avatar Game Manager
    Join Date
    Mar 2016
    Location
    Arizona
    Posts
    11,463
    Timezone
    UTC-07:00
    Community
    PlayDiplomacy, MafiaScum
    Pronouns
    he/him/his/his/himself
    Gender
    Quote Originally Posted by Makaze (#36)
    Quote Originally Posted by mhsmith0 (#35)
    Quote Originally Posted by Makaze (#33)
    Quote Originally Posted by Mill Crab (#31)
    Does it depend on whether you were in the original database or not? Because I wasn't in the first database, and the two mashes I've been in plus xcom haven't shown up as games I've played and aren't counting against my win%. I'm assuming they haven't been entered into the new database yet. So were the old database games just imported over and defaulted to a loss or something?
    It's probable that all games prior to a certain update (modbot keeping track of who won) will show as universal loss.
    @Makaze
    If I go to lissa page and sort by date, towards the top she shows

    2018-04-21 Open Cop 9'er (w/N0 Peak) nice turbo [edit] 9 Town Vanilla Town Loss
    2018-04-02 Open Cop 13'er (w/N0 Peak) easter turbo [edit] 13 Mafia Mafia Goon Win

    but both of those were wins for her. So I'm guessing it's at least a bit more complicated than "all games before date x become universal losses" though I'm not sure what the underlying logic actually is. Maybe it's dumping town wins specifically en masse before date x, with some other error (maybe) affecting wolf results?
    That's... very odd. I'd like for someone to compile a list with URLs so that I can find out what went wrong.
    @Makaze

    The two games I cited above, on "edit game"
    https://www.mafiauniverse.com/databa.../game/?id=1092
    https://www.mafiauniverse.com/databa.../game/?id=1059

    I thought that one issue could be that it shows "number of factions" at 1 instead of 2, but a lot of recent games also show 1, so I'd guess that isn't it even if it seems weird (maybe they mean # antitown factions i.e. town doesn't count there?)

    Games lissa shows as town wins

    https://www.mafiauniverse.com/database/edit/game/?id=16
    https://www.mafiauniverse.com/databa...t/game/?id=736
    https://www.mafiauniverse.com/databa...t/game/?id=778
    https://www.mafiauniverse.com/databa...t/game/?id=856
    https://www.mafiauniverse.com/databa.../game/?id=1039
    each of these appears to be correct

    Samlpe of Games lissa shows as town losses

    https://www.mafiauniverse.com/database/edit/game/?id=69 (correct)
    https://www.mafiauniverse.com/database/edit/game/?id=70 (incorrect)
    https://www.mafiauniverse.com/database/edit/game/?id=72 (correct)
    https://www.mafiauniverse.com/database/edit/game/?id=79 (incorrect)

    Not sure how helpful that is, but I figured it was enough of a sample size to get some notion of what might be good or bad.
    Life is simply unfair... don't you think?
    http://wiki.mafiascum.net/index.php?title=mhsmith0

    BATMAN: Only jugg was the only one we didn’t scum read at least not me

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Keyboard Shortcuts

about us
Mafia Universe is a community hub for people who enjoy playing the forum variant of Mafia (also known as Werewolf). We offer fully automated Mafia games and a wide variety of customized features crafted to optimize your game experience. We also proudly host the Internet's only database of Mafia/Werewolf communities.

We hope you stick around!
Role of the Day
Friendly Neighbor

The Friendly Neighbor may each night target a player to have that player receive confirmation from the host that the Friendly Neighbor is town-aligned.