EPTAnd also:
GMarshal needs to keep his OP updated...just saying =P
TL Mafia Database - Page 6
| Forum Index > TL Mafia |
|
Corazon
United States3230 Posts
And also: GMarshal needs to keep his OP updated...just saying =P | ||
|
kitaman27
United States9245 Posts
On August 01 2013 15:12 cDgCorazon wrote: I put Smurf Mini-Mafia in the database. I'd be open to doing more but I want to make sure I did everything right. I opened another game that was already put in and used that as a guide. Looks good, except you don't need the extra town and scum functions that were labeled new. I went ahead and deleted them. Thanks! | ||
|
Corazon
United States3230 Posts
Is there a way to actually look at the results of more than one game (like look at town and scum win percentages)? It just kind of looks like a database where we put things in and never get anything nice out of it, unless I'm missing something =( Secondly, if a player is victorious, do we put them under "endgamed" or "survived"? | ||
|
kitaman27
United States9245 Posts
On August 02 2013 01:07 cDgCorazon wrote: Two more things: Is there a way to actually look at the results of more than one game (like look at town and scum win percentages)? It just kind of looks like a database where we put things in and never get anything nice out of it, unless I'm missing something =( I'm actually in the process of rewriting the queries that produce the records and statistics in the OP. Once that is finished, I'll keep the OP updated with the new games as they are entered. On August 02 2013 01:07 cDgCorazon wrote: Secondly, if a player is victorious, do we put them under "endgamed" or "survived"? Endgamed means they survived until endgame and lost, such as a mafia team conceding or a town player losing control of the lynch. Surviving means they survived until endgame and won. | ||
|
Corazon
United States3230 Posts
Oh! Last thing. What do we do with replacements? | ||
|
kitaman27
United States9245 Posts
On August 02 2013 02:48 cDgCorazon wrote: Well shit. I need to go fix Smurf and I Swear 2. Oh! Last thing. What do we do with replacements? The player that replaces into the game is entered. The player that replaces out of the game is not entered. | ||
|
Corazon
United States3230 Posts
On August 02 2013 02:51 kitaman27 wrote: The player that replaces into the game is entered. The player that replaces out of the game is not entered. Oh darn. Smurf was so hard to do because GMarshal did not update his OP and I had to go through the entire thread to find flips and such =( | ||
|
Corazon
United States3230 Posts
| ||
|
strongandbig
United States4858 Posts
| ||
|
strongandbig
United States4858 Posts
| ||
|
prplhz
Denmark8045 Posts
On August 20 2013 07:25 strongandbig wrote: is there a way to see the data? like to look up toplists like in the OP of this thread? you can poll it for single game data but not in a very useful way right now also maybe someone might perhaps be working on something possibly so you can get the data you want a little easier | ||
|
Aquanim
Australia2849 Posts
On August 02 2013 02:57 cDgCorazon wrote: Also, do you think it would be a good idea to have putting the game in the database a requirement for all hosts? It would be a good way of keeping the database updated if we held all of the hosts accountable for updating their games. Sounds like a good idea, but since hosts don't often keep their OPs updated I have my doubts that merely "requiring" it will actually make it happen  | ||
|
Clarity_nl
Netherlands6826 Posts
Especially with links to day and nightposts, although it's always nice when flips are shown somewhere seperate in a list. Would be even cooler if the latest votecount was put somewhere in the OP or 2nd post or whatever. Can just copy/paste the votecount quote there. Hosting is definitely hard work but I don't think these things take too much extra effort to update. What can I say, I want to be spoiled as a player. Nothing worse than having to filter a host, lol. | ||
|
kitaman27
United States9245 Posts
I'll probably be updating the game list and statistics section sometime this weekend. | ||
|
Clarity_nl
Netherlands6826 Posts
| ||
|
strongandbig
United States4858 Posts
| ||
|
kitaman27
United States9245 Posts
+ Show Spoiler + Most Games Played + Show Spoiler + bumatlarge 42 Jackal58 40 Palmar 39 VisceraEyes 38 RebirthofLegend 36 chaoser 36 BloodyC0bbler 33 Kenpachi 33 Mr. Wiggles 32 kitaman27 31 wherebugsgo 31 sandroba 30 Amber[LighT] 30 Ace 29 prplhz 27 deconduo 26 Foolishness 26 Bill Murray 25 marvellosity 25 ~OpZ~ 24 GGQ 24 Fishball 23 Chezinu 23 JeeJee 23 LSB 22 Meapak_Ziphh 22 BrownBear 22 radfield 22 Pandain 20 Mattchew 20 Kurumi 20 Overall Win Percentage (Minimum 10 games) + Show Spoiler + DarthPunk 10/11 = 90.91% Incognito 8/10 = 80.00% Hapahauli 9/13 = 69.23% Divinek 8/12 = 66.67% GMarshal 11/17 = 64.71% Adam4167 7/11 = 63.64% OriginalName 10/16 = 62.50% Supersoft 10/16 = 62.50% syllogism 11/18 = 61.11% Bill Murray 15/25 = 60.00% marvellosity 15/25 = 60.00% GreYmist 6/10 = 60.00% Southrawrea 6/10 = 60.00% Pyrrhuloxia 6/10 = 60.00% Town Win Percentage (Minimum 10 games) + Show Spoiler + GMarshal 7/10 = 70.00% syllogism 9/14 = 64.29% supersoft 8/13 = 61.54% kitaman27 15/25 = 60.00% Radfield 9/15 = 60.00% Foolishness 10/18 = 55.56% bumatlarge 16/30 = 53.33% GGQ 8/15 = 53.33% zeks 8/15 = 53.33% Bill Murray 9/17 = 52.94% Mafia Win Percentage (Minimum 5 games) + Show Spoiler + EchelonTee 5/5 = 100.00% annul 5/6 = 83.33% Bill Murray 5/6 = 83.33% marvellosity 5/6 = 83.33% Node 4/5 = 80.00% Jackal58 7/10 = 70.00% GGQ 4/6 = 66.67% RebirthOfLegend 7/11 = 63.64% Palmar 8/13 = 61.54% prplhz 3/5 = 60.00% Pyrrhuloxia 3/5 = 60.00% Radfield 3/5 = 60.00% Normal Game Win Percentage (Minimum 5 games) + Show Spoiler + fusionsdf 5/6 = 83.33% Dreamflower 4/5 = 80.00% GGQ 6/8 = 75.00% Incognito 5/7 = 71.43% LucasWoJ 5/7 = 71.43% Bockit 5/7 = 71.43% Theme Game Win Percentage (Minimum 5 games) + Show Spoiler + supersoft 6/7 = 85.71% GreYMisT 5/6 = 83.33% syllogism 8/10 = 80.00% Chaoser 8/11 = 72.73% Bill Murray 5/7 = 71.43% Mini Game Win Percentage (Minimum 5 games) + Show Spoiler + DarthPunk 6/6 = 100.00% Dirkzor 4/5 = 80.00% GMarshal 4/5 = 80.00% Node 4/5 = 80.00% EchelonTee 5/7 = 71.43% Forumite 4/6 = 66.67% HiroPro 4/6 = 66.67% Perfect Newbie Record (Minimum 3 games) + Show Spoiler + debears 4/4 = 100.00% JacobStrangeLove 4/4 = 100.00% Hapahauli 3/3 = 100.00% mkfuba07 3/3 = 100.00% Mordanis 3/3 = 100.00% The_Zen_Man 3/3 = 100.00% Win Percentage By Alignment + Show Spoiler + Town 40.6% Mafia 52.1% Third Party 30.3% Game Results (Non-newbies) + Show Spoiler + Mafia 77 Town 60 Draw 3 Third Party 4 Newbie Game Results + Show Spoiler + Mafia 26 Town 15 Game Count By Year + Show Spoiler + 2008 5 2009 8 2010 34 2011 49 2012 93 2013 3 Game Count By Month + Show Spoiler + 1 23 2 12 3 18 4 18 5 15 6 20 7 14 8 16 9 16 10 10 11 13 12 17 Player Count By Year + Show Spoiler + 2008 203 2009 134 2010 248 2011 286 2012 417 2013 39 Game Type Count + Show Spoiler + Normal 47 Theme 38 Mini 66 Newbie 41 Games Hosted + Show Spoiler + GMarshal 16 Ace 10 GreYMisT 8 flamewheel 8 Incognito 8 iGrok 7 DoctorHelvetica 7 LSB 6 kitaman27 6 Town Lynched Percentage (Minimum 10 games) + Show Spoiler + kitaman27 0/25 = 0.00% Fishball 0/18 = 0.00% Foolishness 0/18 = 0.00% Keirathi 0/13 = 0.00% Node 0/13 = 0.00% supersoft 0/13 = 0.00% chaos13 0/11 = 0.00% barundar 0/10 = 0.00% iamperfection 0/10 = 0.00% DoctorHelvetica 0/10 = 0.00% Eiii 0/10 = 0.00% GMarshal 0/10 = 0.00% Mementoss 0/10 = 0.00% Town Killed Percentage (Minimum 10 games) + Show Spoiler + LSB 14/17 = 82.35% Mementoss 8/10 = 80.00% Coagulation 10/13 = 76.92% Amber[LighT] 19/25 = 76.00% infundibulum 9/12 = 75.00% GGQ 11/15 = 73.33% chaos13 8/11 = 72.73% Jackal58 21/29 = 72.41% Fishball 13/18 = 72.22% DoctorHelvetica 7/10 = 70.00% Modkills By Alignment + Show Spoiler + Town 201/2946 = 6.82% Mafia 56/848 = 6.60% Third Party 3/66 = 4.55% Town Alignment Percentage + Show Spoiler + redFF 11/11 = 100.00% Keirathi 13/14 = 92.86% Vivi57 12/13 = 92.31% johnnyspazz 10/11 = 90.91% hiro protagonist 10/11 = 90.91% jcarlsoniv 9/10 = 90.00% aidnai 9/10 = 90.00% CynanMachae 9/10 = 90.00% austinmcc 16/18 = 88.89% zeks 15/17 = 88.24% Mafia Alignment Percentage + Show Spoiler + Pyrrhuloxia 5/10 = 50.00% DropBear 5/11 = 45.45% L 8/18 = 44.44% Divinek 5/12 = 41.67% annul 5/12 = 41.67% GMarshal 7/17 = 41.18% DarthThienAn 6/15 = 40.00% OriginalName 6/16 = 37.50% Non-Vanilla Percentage + Show Spoiler + DropBear 10/11 = 90.91% hiro protagonist 9/11 = 81.82% syllogism 14/18 = 77.78% Nisani201 10/13 = 76.92% BloodyC0bbler 25/33 = 75.76% Blazinghand 12/16 = 75.00% Zephirdd 9/12 = 75.00% kitaman27 23/31 = 74.19% Fishball 17/23 = 73.91% deconduo 19/26 = 73.08% Vanilla Percentage + Show Spoiler + Vivi57 2/13 = 15.38% Adam4167 3/11 = 27.27% johnnyspazz 3/11 = 27.27% kushm4sta 3/11 = 27.27% jaybrundage 3/10 = 30.00% SouthRawrea 3/10 = 30.00% Hapahauli 4/13 = 30.77% strongandbig 4/12 = 33.33% Bluelightz 6/17 = 35.29% Mayors/Pardoners/Sheriffs by Alignment + Show Spoiler + Mafia 11 Town 29 Players Who Have Played A Game In '08, '09, '10, '11, and '12 + Show Spoiler + Ace BloodyC0bbler bumatlarge Caller Chaoser Chezinu JeeJee L RebirthOfLeGenD Forum Vets + Show Spoiler + Mynock 14 [GiTM]-Ace 21 789 218 Ace 377 Mandalor 2074 LTT 2283 SoMuchBetter 2825 jtan 2868 KH1031 3017 SoleSteeler 3099 Players With User IDs That Are Prime + Show Spoiler + [NyC]HoBbes 57853 [UoN]Sentinel 55351 Aepplet 6269 Alethios 33289 Atreides- 49459 BaronFel 49531 barth 35591 BassinSpace 187027 Believer 63949 bereft 60901 betaben 30851 blubbdavid 60919 Caller 30803 Clicker 111439 CosmosXAM 166541 CynanMachae 23719 darmousseh 76537 da0ud 169097 dementrio 121469 demonic_phate 30467 DimmuKlok 83009 drwiggl3s 263567 ecomania 34961 ELITECubWarman8 147793 Esspen 70489 Fallen_arK 50503 Fen 22483 FezTheCaliph 60443 Funcmode 80747 fusionsdf 22343 GeorgeClooney 122651 goldenkrnboi 30223 Grackaroni 198851 HiroPro 258487 Intact 102437 Janaan 195329 Johnhughthom 147787 JoxxOr 31321 Kenpachi 51151 Khorrus 237043 Kickstart 38671 KillingTime 280933 Knutti 39877 Kohbee 182857 KorvspaD 4691 LazinCajun 199489 Lenwe 35083 Lexpar 45533 love1another 56431 Lvdr 278119 MeatlessTaco 157747 Mig 11719 Mordanis 137393 more_minerals 32479 MrBabyHands 41543 Myles 63773 nard 50551 nbtnbt5 45161 NeaX 3109 Omniscient4983 284093 omnomMuffins 202409 Pondo 97511 Pyrrhuloxia 36781 Quesadilla 31817 Ra.Xor.2 36923 rgTheSchworz 128099 Roco69 287281 SacredSystem 136753 Ser Aspi 57713 Seviro 188261 Sharrant 279649 Skrammen 117373 slOosh 53783 Soulfire 104287 Spiritclown 210643 sugiuramidori 47491 Superouman 30509 to miss the mark 19447 Toadesstern 40853 Twelve 105229 VayeshMoru 52517 whatchamacallit 53987 WhySoMuch 262621 xsksc 149333 ZBiR 5021 Zorkmid 41737 Mafia players are lynched 21.3% of the time on day one. Random lynching would result in a mafia lynch 24.8% of the time. 45% of players playing in a newbie game have returned to play in at least 1 other game. There have been 951 distinct mafia players. And finally my favorite stat... VisceraEyes has survived until endgame three times out of 38 games (7.89%). The highest survival percentage is 60%. | ||
|
WaveofShadow
Canada31495 Posts
Random point: the hydra I used with MrCheesecake is named wrong and so the link doesn't work. It's not WaferofCheesecake it's just WaveofCheesecake. :D | ||
|
phagga
Switzerland2194 Posts
- Hide Spoiler [Mini] - select CONCAT('' , games.name,'' , char(13) , '+ Show Spoiler +' ) from games where GetGameSize(id) < 17 and (games.type != 'newbie') order by games.start I don't think that's supposed to look like this  | ||
|
Dandel Ion
Austria17960 Posts
On September 25 2013 22:17 WaveofShadow wrote: Yay you finally updated the OP! Random point: the hydra I used with MrCheesecake is named wrong and so the link doesn't work. It's not WaferofCheesecake it's just WaveofCheesecake. :D That's what the endgame post says though hohoho | ||
| ||
