Linguica's Doomworld Forums Blog

Linguica's Doomworld Forums Blog

Fwd: doomworld.com August 19, 2015, 2:59 pm
Hi there,

I'm seriously interested in buying your forum. Would you please let me know what price, hopefully reasonable, you would be wiling to accept? I can pay via paypal or escrow.com. thank you!

Clark
20 Comments

SELECT DATE_FORMAT( FROM_UNIXTIME(time), '%Y-%m' ) as time2, COUNT(*) as count FROM i August 17, 2015, 6:04 pm
SELECT DATE_FORMAT( FROM_UNIXTIME(time), '%Y-%m' ) as time2, COUNT(*) as count FROM idgames_files GROUP BY time2

<iframe width="600" height="371" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1hxv_F17IZ49c89W0IzU0xNJWVpKPN8Y65qMOVfMfjIg/pubchart?oid=633533726&format=interactive"></iframe>
3 Comments

SELECT concat(YEAR(FROM_UNIXTIME(dateline)), '-', MONTH(FROM_UNIXTIME(dateline))) as August 6, 2015, 3:05 pm
SELECT concat(YEAR(FROM_UNIXTIME(dateline)), '-', MONTH(FROM_UNIXTIME(dateline))) as time, COUNT(*) as count FROM post GROUP BY time ORDER BY time

<iframe width="600" height="371" seamless frameborder="0" scrolling="no" src="https://docs.google.com/spreadsheets/d/1DCONx--G0a936x8IuyBMc5CTCHJPIFKf8IbYqu_flkg/pubchart?oid=1545909178&format=interactive"></iframe>
16 Comments

select count(*), post.username, avg(length(pagetext)) as avg from post join user on August 1, 2015, 12:22 am
select count(*), post.username, avg(length(pagetext)) as avg from post join user on (user.userid = post.userid and user.posts > 250) join thread on (post.threadid = thread.threadid and thread.forumid != 20) group by post.userid order by avg desc limit 30

count(*) username avg
1313 Demon of the Well 3344.4532
1532 SteveD 1597.8179
697 kb1 1417.3644
526 Veinen 1342.3859
332 Ladna 1331.6928
300 EffinghamHuffnagel 1308.8500
1285 Magnusblitz 1058.4996
1647 dobugabumaru 1052.0959
317 Fonze 1039.2303
446 Melon 1035.1771
1130 wesleyjohnson 983.1434
1051 deep 936.4367
640 vladimir0523 910.3313
246 wildman 898.4390
272 Optimus 866.6544
380 Cynical 851.3184
252 Jekyll Grim Payne 848.0635
340 Soundblock 837.4941
556 Jaws In Space 833.2356
1049 st.alfonzo 827.0858
335 Insane_Gazebo 770.7970
317 obake 770.1293
268 bradharding 748.9254
374 Foxpup 745.8396
321 SirTimberWolf 743.7508
669 Demonologist 742.0194
1349 The Green Herring 739.7072
368 HackNeyed 727.4484
499 BilboHicks 723.5912
278 iceman57 714.0576
21 Comments

15 Years of 5 Years of Doom December 9, 2013, 11:05 pm
http://5years.doomworld.com/ look at that vintage 1998 web design. LOOK AT IT
14 Comments

Has anything good happened on the DW forums in the last few years April 15, 2013, 11:01 pm
I dunno, some juicy drama, or anything else interesting to an old veteran like myself.
52 Comments

omg birfday May 3, 2010, 11:18 am
omg impse
16 Comments

attn: bloodshedder September 17, 2009, 3:18 pm
16 Comments

yay new computer August 28, 2009, 10:06 am
http://valid.canardpc.com/show_oc.php?id=678586

9 Comments

FAIL July 20, 2009, 3:52 pm
This is probably well known but http://www.slate.com/id/2202262/pagenum/all/

link in third paragraph
11 Comments

Next