EPTSELECT admin, COUNT(*) AS total FROM bans GROUP BY admin ORDER BY total DESC LIMIT 20
And maybe one for which users were banned the most? Would be interesting. I know I've personally gotten banned like 8 times (2 were permanent, but repealed later).
Most bans from TL
| Forum Index > TL Community |
|
Spartan
United States2030 Posts
SELECT admin, COUNT(*) AS total FROM bans GROUP BY admin ORDER BY total DESC LIMIT 20 And maybe one for which users were banned the most? Would be interesting. I know I've personally gotten banned like 8 times (2 were permanent, but repealed later). | ||
|
aeroH
United States1034 Posts
On December 20 2009 22:20 Spartan wrote: And maybe one for which users were banned the most? Would be interesting. I know I've personally gotten banned like 8 times (2 were permanent, but repealed later). tdot-krayz probably | ||
|
Spartan
United States2030 Posts
 | ||
|
Kennigit
Canada19447 Posts
| ||
|
Pokebunny
United States10654 Posts
| ||
|
Kennigit
Canada19447 Posts
| ||
|
Oystein
Norway1602 Posts
On December 21 2009 02:17 Kennigit wrote: Yeah he had almost 2 pages worth on his mod notes lol. Do you keep notes on everyone or just the people you are banning? | ||
zatic
Zurich15348 Posts
On December 21 2009 02:49 Oystein wrote: Do you keep notes on everyone or just the people you are banning? People we are banning and vikings with rough voices. | ||
Spazer
Canada8031 Posts
riptide 7 Plexa & Kennigit 1 pachi 5 Last Romantic 13 HnR)Insane 8 zatic 65 Plexa 93 vGl-CoW 79 Sonuvgay Bob 1 R1CH 2 Live2Win 2 SonuvBob 125 Kennigit 153 FrozenArbiter 36 FakeSteve[TPR] 146 Chill 138 thedeadhaji 124 Hot_Bid 180 ManaBlue 8 PoP 23 Carnac 111 Beyonde 1 EvilTeletubby 138 Arbiter[frolix] 10 XaI)CyRiC 9 Saro 14 Legionnaire 1 mensrea 6 Beyonder 119 uhjoo 33 Twisted 236 X)Benny 6 GroT 2 ToKoreaWithLove 35 Godzilla 1 Klogon 59 Rekrul 171 Liquid`Drone 29 Manifesto7 434 Liquid`Nazgul 67 Liquid`Meat 82 Total: 2773 These numbers assume that nobody quoted a ban in that thread. | ||
|
Latham
9563 Posts
| ||
|
jimminy_kriket
Canada5509 Posts
| ||
|
Avidkeystamper
United States8552 Posts
| ||
|
Chef
10810 Posts
So much interesting trivia to be had!! | ||
|
538
Hungary3932 Posts
On December 21 2009 09:54 Chef wrote: Who has the most posts and least bans who isn't a mod? Who has the most bans that is a mod? :O So much interesting trivia to be had!! I guess most bans "suffered" as a mod might be Rekrul? other interesting queries: - Most posts without a ban (since registering/between two bans) - Best/worst bans/posts ratio - Best/worst time spent banned/time registered ratio - Least amount of time between consecutive bans (excluding tdot) I recall a convo with Cow on IRC about something like this a while ago, but it wasnt too comprehensive. (nor do i have the logs, anyway.) | ||
|
Pokebunny
United States10654 Posts
I have 0 bans, 0 warnings, and 0 closed threads with 2200+ posts and counting. Gonna stay clean as long as possible >.> | ||
|
Spazer
Canada8031 Posts
riptide____________14 Waxangel___________5 Plexa & Kennigit___1 pachi______________7 Last Romantic______47 HnR)Insane_________11 zatic______________92 Plexa______________157 vGl-CoW____________103 Sonuvgay Bob_______1 R1CH_______________3 Live2Win___________2 SonuvBob___________163 Kennigit___________219 FrozenArbiter______55 FakeSteve[TPR]_____214 Chill______________156 thedeadhaji________124 Hot_Bid____________230 ManaBlue___________10 PoP________________24 Carnac_____________144 Beyonde____________1 EvilTeletubby______228 Arbiter[frolix]____13 XaI)CyRiC__________12 Saro_______________14 Legionnaire________2 mensrea____________6 Beyonder___________119 uhjoo______________33 Twisted____________249 X)Benny____________6 GroT_______________2 ToKoreaWithLove____35 Godzilla___________1 Klogon_____________62 Rekrul_____________171 Liquid`Drone_______30 Manifesto7_________613 Liquid`Nazgul______91 Liquid`Meat________82 Total: 3552 + Show Spoiler [Users] + Jadyks______________3* Monstah-_-__________3* closed______________3* Nal_rAwr____________4 wok_________________3* Gormaol_____________3* starPride___________3* Zoler_______________3 inertinept__________3 SoulMarine__________7* omninmo_____________4 LuckyFool___________3 Diomedes____________3* Aegraen_____________6* HeavOnEarth_________4 Disintegrate________3* myfriendPlank_______3 Vex_________________3* lesser_good_________3 feathers____________3* R3condite___________3 RebirthOfLeGenD_____3 alt.tday____________4* PH__________________3 PokePill____________4 iSCOUT4u____________5* medic27_____________3 latent______________3 DeathSpank__________4 ZERG_RUSSIAN________3 Geo.Rion____________3 jodogohoo___________3 ilovehnk____________4* NoobsOfWrath________5 CapO________________3 Clasic______________4* ixion_______________4* PanN________________3 ramen247____________5 Racenilatr__________5* SaharaDrac__________4* TheFlashyOne________7 EleanorRIgby________3 Qwertify____________3 food________________8* ish0wstopper________3* I3oxerfan___________4* lilpwnyIII__________3* Skyze_______________3 decafchicken________3 SlickR12345_________6 Ichigo1234551_______5 RoSe._______________3 illeszt_____________3 OmgIRok_____________4 ForVengeance________3* Spenguin____________3 d(O.o)a_____________3 .risingdragoon______3 Grobyc______________3 kpcrew______________3* BlackStar___________3* SilverSkyLark_______3 Frits_______________3 kdog3683____________6 Louder______________3 UmmTheHobo__________3 SiegeTanksandBlueGoo5 AttackZerg__________4 QuoC________________3 letsbefree__________3* selboN______________4 HamerD______________6* WingSandrockX_______6* Kunty_______________3 clazziquai__________5* paper_______________5 frankbg_____________4* zimz________________3 Skittled____________4 OakHill_____________3* Polyphasic__________3 lod-mika____________4* ScarFace____________4* Scaramanga__________3 rpf_________________3* nimysa______________3 Dazed_Spy___________6* Oddysay_____________3 KawaiiRice__________3 liosama_____________4 Aux1________________3 rushz0rz____________3 Raithed_____________6* FragKrag____________3 Folca_______________3 TeHTerraNAeriAL_____3* drug_vict1m_________3 intrigue____________3 PuertoRican_________3* lake________________3* Thegreatbeyond______3* t0wel_______________3* crazie-penguin______3 OneOther____________3 Hippopotamus________3 himurakenshin_______5 Wizard______________6* GeneralStan_________3 TheSchwA____________3 ForAdun_____________4* saranghaeCY-________4* IzzyCraft___________4* Ansible_____________5* HonkHonkBeep________3* Pads________________4 fanatacist__________13* orangedude__________3* PissedOffEmo________3* vstar_______________3* MarklarMarklar______10* yubee_______________3* DeadVessel__________5 MoNKeYSpanKeR_______7* Duffybeer___________3* JensOfSweden________4* HungerForMore_______3* MadNeSs_____________3 mikeymoo____________6 Spartan_____________7 MaZza[KIS]__________3 RebelHeart__________5* IIICodeIIIIIII______4* Ganfei______________5 -WGT-Stars-_________4 .kaz________________6* baal________________7 TheFoReveRwaR_______3 TehKris_____________6* Cpt Obvious_________3 ffaakkoovv__________3* miyavi______________3* Scorpion____________6* polarwolf___________3 ic.Ichigo101________3* CultureMisfits______3 SixSongs____________3 LemOn_______________3 zizou21_____________3 Coagulation_________4 [jOyO]______________3 DarK]N[exuS_________3* TT1_________________3* Prodigy[x]__________3* KissBlade___________3 CharlieMurphy_______9 -_-_________________4 IdrA________________8 Detonate____________3* dronebabo___________4 kdog3682____________3* kroko_______________4 LetMeBeWithYou______3* RepeNt______________3* rpf289______________3* 8882________________4* zulu_nation8________5 nitram______________3* racebannon__________3* Mynock______________3* QuietIdiot__________3 Darki[Per]__________3* a-game______________4 Chibi[OWNS]_________5* FakeSteve[TPR]______3 {88}iNcontroL_______6 NonY________________3* KrAzYfoOL___________3 {ToT}Strafe_________5 mitsy_______________3* lol, found a bug. I thought the numbers seemed kinda off. Fana wins with 13 bans. All users with under 2 bans are ignored because there's a heck of a lot of them. Edit: Mind you, I can't account for different usernames, so people like tdot aren't on here. Users with stars are permabanned. | ||
|
DrTJEckleburg
United States1080 Posts
| ||
|
Nitrogen
United States5345 Posts
| ||
|
Grobyc
Canada18410 Posts
| ||
|
ShoCkeyy
7815 Posts
| ||
| ||
