#1 10.07.2014 11:21:43

akfaew
Administrator
Posts: 619

database cleanup

I removed a bunch of email addresses that are being reported as unavailable, or are hosted on a shitty provider like aol.com that panics if it gets more than three messages at once. If you missed the LT33 notification, verity the email you set in your profile.

Offline

#2 10.07.2014 14:02:20

akfaew
Administrator
Posts: 619

Re: database cleanup

I'm about to remove these users, who have never played any games, unless somebody objects:

     username     |          last_login           
------------------+-------------------------------
 ShmenonPie       | 2011-11-20 20:53:19.206316+00
 mrsyncal         | 2011-11-21 03:59:42.572584+00
 zigguraticus     | 2011-11-21 10:53:10.995548+00
 janne            | 2011-11-21 13:46:54.709833+00
 Anca             | 2011-11-21 14:25:56.611966+00
 Steeley          | 2011-11-21 23:02:59.428893+00
 DeckOfManyThings | 2011-11-28 05:30:30.66765+00
 Kheldar          | 2011-11-30 02:18:17.989424+00
 gabrielbyrnei    | 2011-11-30 18:54:11.129532+00
 MrGreen          | 2011-12-01 18:04:29.569674+00
 iBad             | 2011-12-02 14:28:04.78291+00
 MCOX1729         | 2011-12-05 21:52:06.518243+00
 quem             | 2011-12-08 16:02:59.090689+00
 wieczyk          | 2011-12-10 18:02:03.1335+00
 eduardogotti     | 2011-12-18 02:59:21.465266+00
 Monkihunta       | 2011-12-20 00:45:30.491016+00
 udvarid          | 2011-12-26 21:57:58.349915+00
 tbli             | 2011-12-26 22:45:29.791633+00
 blie             | 2011-12-29 05:40:01.582565+00
 vukk             | 2012-01-02 00:51:40.183336+00
 per              | 2012-01-04 19:13:26.738014+00
 Spoonist         | 2012-01-06 14:41:22.993133+00
 Pharaoh          | 2012-01-06 16:39:25.749112+00
 testuser         | 2012-01-08 11:33:58.887715+00
 adasko           | 2012-01-08 19:24:38.901843+00
 Milan            | 2012-01-09 02:09:20.552126+00
 adricv           | 2012-01-11 14:22:29.529995+00
 proberts         | 2012-01-12 20:09:14.427129+00
 rking89          | 2012-01-13 20:54:00.699923+00
 Shabbyrabi       | 2012-01-14 01:18:17.697853+00
 LIKEAG36         | 2012-01-15 08:09:28.581749+00
 Chickengeorge    | 2012-01-15 11:44:08.079521+00
 antiweltteilchen | 2012-01-16 05:51:22.445116+00
 Budspencer       | 2012-01-16 16:39:53.663013+00
 gene13           | 2012-01-16 23:39:17.717644+00
 douchefag        | 2012-01-17 06:52:54.865828+00
 bastidrazor      | 2012-01-18 23:21:07.67732+00
 kiki_pop1        | 2012-01-19 21:26:01.437182+00
 proletaire       | 2012-01-20 06:33:55.475133+00
 icericumra       | 2012-01-20 16:25:40.983242+00
 kjriwo           | 2012-01-20 23:14:58.379785+00
 robi120i         | 2012-01-21 21:36:46.580539+00
 diup             | 2012-01-25 11:07:01.29866+00
 Fumm             | 2012-01-25 13:33:37.963995+00
 mkirton          | 2012-01-25 16:38:34.175626+00
 mrozek           | 2012-01-27 09:52:45.299863+00
 shepherd         | 2012-01-28 01:03:51.010498+00
 hexagon          | 2012-01-28 14:34:22.118883+00
 Flee             | 2012-01-28 14:43:09.974358+00
 donateas         | 2012-01-30 14:09:30.301068+00
 kernigh          | 2012-01-30 20:06:10.706589+00
 Jayc6274         | 2012-01-31 05:35:31.740179+00
 BouncingYeti     | 2012-02-03 17:49:17.60575+00
 Hamy             | 2012-02-05 13:10:37.448605+00
 lifeinblue       | 2012-02-06 07:48:54.392907+00
 Szarius          | 2012-02-06 18:22:56.373824+00
 HighTech1011     | 2012-02-07 19:23:29.455714+00
 Steff            | 2012-02-07 22:26:10.910404+00
 sesl             | 2012-02-08 09:29:42.874355+00
 Artem            | 2012-02-08 11:49:42.775573+00
 moviesivan       | 2012-02-10 08:47:59.47883+00
 spaceDet         | 2012-02-10 14:12:14.468526+00
 ninja_pica_pica  | 2012-02-12 11:04:38.107967+00
 toni112          | 2012-02-12 15:47:51.89954+00
 Crazzeye         | 2012-02-13 15:44:03.367703+00
 pygmalion86      | 2012-02-14 19:44:10.368916+00
 PZF              | 2012-02-15 00:31:08.096946+00
 Kaurin           | 2012-02-19 02:11:59.450352+00
 alkhemy          | 2012-02-19 21:52:28.62605+00
 Linuxass         | 2012-02-20 06:22:54.176355+00
 firered          | 2012-02-25 20:39:55.860116+00
 rodge            | 2012-02-26 16:47:05.11975+00
 VorreCrosser     | 2012-03-01 13:40:31.263142+00
 greycrux         | 2012-03-03 21:39:15.370851+00
 Japool           | 2012-03-06 18:34:08.02362+00
 sb               | 2012-03-12 21:31:53.964263+00
 linuxman2k1      | 2012-03-14 15:21:22.889296+00
 Alxe             | 2012-03-15 15:00:17.039112+00
 KHLazarus        | 2012-03-20 19:25:08.232355+00
 danloyal80       | 2012-03-21 12:38:36.413916+00
 banditha         | 2012-03-21 12:53:20.947526+00
 leeuw01          | 2012-03-22 20:04:09.199514+00
 Angry            | 2012-03-27 16:16:19.810225+00
 pepeto           | 2012-04-06 10:16:35.803005+00
 Barodscheff      | 2012-04-06 14:40:35.708224+00
 Makowy           | 2012-04-11 08:58:40.704079+00
 waffer           | 2012-04-11 17:45:36.474645+00
 Enage            | 2012-04-12 06:14:07.324286+00
 eltiomaxi        | 2012-04-12 13:12:57.541487+00
 civilbeast       | 2012-04-12 22:36:41.072831+00
 Master           | 2012-04-14 14:07:20.468353+00
 redfire6         | 2012-04-14 17:36:39.003003+00
 Echolalie        | 2012-04-14 19:03:24.765958+00
 Gonco            | 2012-04-14 21:12:40.486743+00
 roravun          | 2012-04-15 19:36:22.039466+00
 zatch            | 2012-04-16 16:36:47.737297+00
 Vesk             | 2012-04-18 03:11:04.509426+00
 madrid           | 2012-04-20 14:52:02.48142+00
 Arkaniad         | 2012-04-22 17:43:01.73246+00
 Feinu            | 2012-04-22 17:47:21.120568+00
 urric            | 2012-04-24 18:21:08.788943+00
 Aalabor          | 2012-04-25 14:11:45.151185+00
 RickdaRula       | 2012-04-25 14:24:13.14179+00
 Skoe325          | 2012-04-27 03:06:26.194294+00
 Washi            | 2012-04-27 13:44:20.874804+00
 doorak           | 2012-04-28 03:10:14.18469+00
 ActionGoose      | 2012-04-29 21:50:50.580798+00
 hackziner        | 2012-04-30 07:25:01.687396+00
 kinetic          | 2012-05-04 01:14:31.101151+00
 daze             | 2012-05-04 01:49:19.333692+00
 Burman           | 2012-05-04 12:02:01.605046+00
 s4v1or           | 2012-05-04 19:19:44.981287+00
 jhhtyzjebie      | 2012-05-06 22:21:20.78495+00
 Incansus         | 2012-05-07 12:24:05.98552+00
 hadron           | 2012-05-07 12:26:43.016727+00
 bpuzon           | 2012-05-07 12:27:11.576394+00
 ArkTiK           | 2012-05-07 12:28:54.910341+00
 tom_watson       | 2012-05-07 12:29:17.453807+00
 jarhu            | 2012-05-07 12:30:35.625565+00
 Orys             | 2012-05-07 12:32:04.568972+00
 mysticles        | 2012-05-07 12:32:34.347896+00
 oz_newbie        | 2012-05-07 12:32:56.836694+00
 roemertopf       | 2012-05-07 15:00:40.529374+00
 Evistin          | 2012-05-08 20:16:47.32294+00
 alphori          | 2012-05-12 13:44:10.236362+00
 Jalden           | 2012-05-14 21:16:41.89229+00
 bli              | 2012-05-15 20:49:30.399643+00
 Junior           | 2012-05-15 23:55:07.429735+00
 Hompie           | 2012-05-16 17:15:42.230462+00
 gyo              | 2012-05-18 18:13:41.912384+00
 henrychinaski    | 2012-05-19 17:46:07.981768+00
 DownInThePipe    | 2012-05-22 13:04:45.92773+00
 Maxi92           | 2012-05-22 16:58:00.241987+00
 DmitryIvanov     | 2012-05-23 13:07:01.344218+00
 Larppa           | 2012-05-25 17:35:12.397667+00
 marcaurele       | 2012-05-25 21:11:25.701034+00
 Cryonix_art      | 2012-06-01 20:24:08.178979+00
 Borknagar        | 2012-06-01 21:21:14.575923+00
 Pikamander2      | 2012-06-02 00:26:41.70918+00
 Klo              | 2012-06-03 11:42:53.254376+00
 klobster         | 2012-06-05 19:28:24.797598+00
 nornomad         | 2012-06-11 20:18:13.830649+00
 richard          | 2012-06-12 21:50:26.543556+00
 Snecko           | 2012-06-13 10:51:23.587413+00
 NotStop          | 2012-06-14 05:28:11.408649+00
 thecaramel       | 2012-06-14 07:08:08.151967+00
 Erax             | 2012-06-14 12:33:48.140611+00
 sgu07jm2         | 2012-06-15 09:26:10.599417+00
 backstaab        | 2012-06-15 18:12:27.321292+00
 Ploppy           | 2012-06-15 19:04:36.618213+00
 GAZ082           | 2012-06-17 18:23:22.717034+00
 etoxican         | 2012-06-17 22:52:18.581849+00
 rguillebert      | 2012-06-19 18:58:26.761409+00
 Artek            | 2012-06-20 21:17:29.302908+00
 DaLion           | 2012-06-21 23:17:57.225802+00
 docz             | 2012-06-25 02:04:05.227427+00
 PereNucleaire    | 2012-06-25 08:46:18.078724+00
 vs979            | 2012-06-27 06:41:41.039906+00
 RaptoX           | 2012-06-27 14:44:11.637501+00
 Death            | 2012-06-28 14:55:54.514026+00
 Joe9009          | 2012-06-28 18:09:31.662171+00
 grimboy          | 2012-06-29 03:03:45.46362+00
 Epicjason        | 2012-07-01 04:48:12.554845+00
 virtuallong      | 2012-07-02 03:17:46.384672+00
 LinuxUser        | 2012-07-02 06:05:53.417508+00
 eNeXPi           | 2012-07-02 13:15:54.990715+00
 Asti             | 2012-07-03 12:49:01.717607+00
 dudeness         | 2012-07-04 06:14:44.548956+00
 TehAkantor       | 2012-07-05 19:04:05.992191+00
 Tuputh           | 2012-07-06 13:52:51.252644+00
 Dessard          | 2012-07-07 15:33:26.544329+00
 Juggerr          | 2012-07-08 17:12:46.002846+00
 koekto           | 2012-07-11 00:08:22.522412+00
 bovine           | 2012-07-15 11:05:08.746518+00
 gimp             | 2012-07-17 16:36:30.559397+00
 attaxx           | 2012-07-18 17:47:57.063186+00
 basmith7         | 2012-07-20 21:30:49.145843+00
 Andrax           | 2012-07-28 18:41:11.971694+00
 LordCOTA         | 2012-07-31 16:28:47.868388+00
 catherineloucks  | 2012-08-06 04:51:27.508488+00
 donnievoks       | 2012-08-06 07:15:45.474063+00
 redwing          | 2012-08-08 22:01:37.872371+00
 irvnjcbs         | 2012-08-09 11:20:13.989294+00
 DashOfAwesome    | 2012-08-09 14:16:53.119874+00
 Quasimopho       | 2012-08-10 16:45:23.304699+00
 Alphaville       | 2012-08-10 17:04:47.948771+00
 Citral           | 2012-08-10 20:11:32.276371+00
 Cosman246        | 2012-08-16 17:09:43.274092+00
 Zinc             | 2012-08-17 13:38:05.715803+00
 gnapps           | 2012-08-18 13:38:10.466489+00
 EdwardR          | 2012-08-27 06:44:14.878632+00
 waito            | 2012-08-28 21:50:59.008146+00
 Nocebo           | 2012-09-06 13:14:36.180197+00
 shahryarrakeen   | 2012-09-08 04:06:28.669795+00
 nabsha           | 2012-09-12 15:22:36.459042+00
 Allymelly        | 2012-09-26 22:52:45.161711+00
 auspices         | 2012-10-08 18:41:13.920759+00
 da_teacha        | 2012-10-08 18:44:23.18874+00
 demaesia         | 2012-10-09 04:46:32.993932+00
 davide           | 2012-10-15 06:33:07.49655+00
 Casval           | 2012-10-20 04:41:56.178427+00
 Paladin          | 2012-10-20 11:08:16.454915+00
 Napwnleon        | 2012-10-21 22:27:38.57021+00
 qamil            | 2012-10-29 05:21:54.6479+00
 Eisenstein       | 2012-10-31 20:52:16.753864+00
 leojon           | 2012-11-01 16:06:43.459878+00
 LEO              | 2012-11-01 16:07:27.646448+00
 jonarteche       | 2012-11-01 17:32:06.493705+00
 arteche          | 2012-11-01 17:33:00.005405+00
 artetxe          | 2012-11-01 17:33:52.590213+00
 artetxejon       | 2012-11-01 17:34:18.800772+00
 artetxejon_16    | 2012-11-01 17:34:44.161426+00
 jonbarakaldo     | 2012-11-01 17:35:18.487316+00
 artek            | 2012-11-01 17:35:49.063717+00
 tzaeru           | 2012-11-05 11:02:19.355842+00
 StewartFip       | 2012-11-05 14:14:17.188811+00
 wiw              | 2012-11-09 09:08:58.807117+00
 FConstantinos    | 2012-11-16 13:39:47.163159+00
 Pelagei          | 2012-11-17 14:34:58.285413+00
 wuschel          | 2012-11-17 18:49:53.345105+00
 Hasp             | 2012-11-19 07:15:32.336198+00
 scorchgeek       | 2012-11-24 20:33:48.483366+00
 killerBill       | 2012-11-28 16:37:59.818899+00
 Davide           | 2012-12-07 19:20:09.901842+00
 mielu            | 2012-12-11 12:03:48.003509+00
 Taryc            | 2012-12-13 04:01:24.574199+00
 MarcosTantos     | 2012-12-21 13:07:52.187058+00
 Viajero          | 2012-12-22 16:50:26.900161+00
 sarazi           | 2012-12-25 23:34:04.854589+00
 sevenfive        | 2012-12-26 18:25:14.228045+00
 logic            | 2012-12-30 22:17:51.214693+00
 treefetty        | 2013-01-02 03:34:13.507432+00
 j0jo             | 2013-01-02 20:30:01.928816+00
 dmehling         | 2013-01-03 00:43:29.459218+00
 liotier          | 2013-01-03 01:28:31.988941+00
 Esly             | 2013-01-04 02:03:04.043516+00
 lumpio           | 2013-01-06 20:26:01.151739+00
 huangcg          | 2013-01-20 06:48:24.422873+00
 Massimo          | 2013-01-23 08:12:10.475121+00
 Alchymysto       | 2013-01-31 14:44:02.003424+00
 waknuk           | 2013-02-09 19:38:45.266631+00
 snapped          | 2013-02-12 14:13:09.496116+00
 Exocyst          | 2013-02-12 19:37:19.682163+00
 baabelfish       | 2013-02-16 17:16:58.69957+00
 Sparrow          | 2013-02-23 13:26:08.862162+00
 xray95x          | 2013-02-24 06:52:42.790262+00
 Kryuh            | 2013-02-24 12:05:30.539392+00
 chief            | 2013-02-28 16:06:56.197791+00
 ilya             | 2013-03-01 19:20:07.775881+00
 LeeviS           | 2013-03-03 12:31:06.529189+00
 Space313         | 2013-03-03 17:22:35.952391+00
 MajorJog         | 2013-03-07 14:06:49.567264+00
 Zemi             | 2013-03-12 16:46:08.826524+00
 montezuma        | 2013-03-16 16:20:32.614702+00
 aladeen          | 2013-03-16 16:23:25.678267+00
 nuclearnadal     | 2013-03-16 16:25:10.360612+00
 Etanol           | 2013-03-19 18:10:21.162862+00
 bardo            | 2013-04-01 23:45:09.550981+00
 annex            | 2013-04-02 13:56:04.960567+00
 Immental1200     | 2013-04-06 14:27:51.61573+00
 TrashKiller      | 2013-04-10 09:42:18.316635+00
 afmaradei        | 2013-04-13 16:59:00.847689+00
 TenHanger        | 2013-04-29 15:03:05.633463+00
 mmarek           | 2013-05-04 13:20:54.849302+00
 Washi_ITA        | 2013-05-13 08:48:47.052507+00
 MAKOS2148        | 2013-05-17 12:55:53.641125+00
 jdk249           | 2013-05-19 10:41:33.207966+00
 sokrat           | 2013-05-21 21:56:50.737471+00
 diepes           | 2013-05-29 22:18:42.358491+00
 pieronjeden      | 2013-06-03 04:20:41.814293+00
 rooks            | 2013-06-11 19:08:37.585778+00
 waerth           | 2013-06-17 16:28:09.246163+00
 Pablo_CZ         | 2013-08-22 19:32:30.182288+00
 Hezart           | 2013-08-26 04:49:34.88624+00
 kndkt            | 2013-09-10 16:13:24.484878+00
 Mellow_          | 2013-09-13 16:20:55.595104+00
 throngbak        | 2013-09-14 23:53:45.244682+00
 Lea              | 2013-09-21 17:04:01.138133+00
 thewho           | 2013-10-03 14:49:35.746849+00
 Deluxe           | 2013-10-29 16:15:20.717401+00
 kevin551_test    | 2013-11-28 10:16:02.852202+00
 jtn              | 2013-11-28 23:50:29.670188+00

Offline

#3 14.07.2014 12:50:52

akfaew
Administrator
Posts: 619

Re: database cleanup

All the nonranking users who have not logged in recently have been removed, except their forum account if they ever made a post.

Offline

Board footer

Powered by FluxBB