Page 2 of 3
Posted: 30 Jan 2013, 21:56
by webwit
fossala wrote:Looks good. I wonder how many of them 469 came, got their answer then left.
Code: Select all
mysql> SELECT count(*) FROM `phpbb_users` WHERE user_lastpost_time > unix_timestamp(subdate(now(), interval 31 day)) and user_posts = 1;
+----------+
| count(*) |
+----------+
| 39 |
+----------+
1 row in set (0.02 sec)
Posted: 31 Jan 2013, 04:01
by guilleguillaume
Those codes confuse me
¡Happy Birthday!
It's my favourite
keyboard/input device forum. I've made of DT my home.
Posted: 31 Jan 2013, 08:21
by fruktstund
I understand the code!

(Maybe because I work part-time with that stuff, but yeah.)
I thought DT was way older than just 2 years, but when I think about it, it hasn't even been a year since I registered here, even though it feels like at least 2 years.
Congratulations, happy birthday, and thanks for a great site! I've really enjoyed it here this far. <:
Posted: 31 Jan 2013, 08:33
by 7bit
guilleguillaume wrote:Those codes confuse me
SQL is an ugly language but it seems the same thing with regular expressions would look more confusing ...

Posted: 31 Jan 2013, 08:36
by fruktstund
7bit wrote:guilleguillaume wrote:Those codes confuse me
SQL is an ugly language but it seems the same thing with regular expressions would look more confusing ...

I don't even want to think about that... But then again, why would anybody do so in the first place? (Right? Right..?)
SQL is good for what it's meant for!
Posted: 31 Jan 2013, 09:30
by webwit
Sql is just mathematical logic with lots of set theory.
Posted: 31 Jan 2013, 09:35
by fossala
fruktstund wrote:7bit wrote:guilleguillaume wrote:Those codes confuse me
SQL is an ugly language but it seems the same thing with regular expressions would look more confusing ...

I don't even want to think about that... But then again, why would anybody do so in the first place? (Right? Right..?)
SQL is good for what it's meant for!
I use SQL for my mail database, bit overkill though but it makes things easy.
Posted: 06 Feb 2013, 13:16
by Jim66
Wow 2 years, time flies. I visit several times a day but my posting has slowed down since I've been too skint to buy any new keyboards.
Posted: 29 Jan 2014, 10:14
by webwit
2 years of deskthority
3 years of deskthority
Officially in Internet dog years no longer a young forum!
Re: 2 years of deskthority
Posted: 29 Jan 2014, 10:19
by 002
Woo!!
Posted: 29 Jan 2014, 10:43
by HzFaq
Woop! Happy Birthday, where's the booze?
Re: 2 years of deskthority
Posted: 29 Jan 2014, 10:44
by guillaume kuster
Hi all,
I just wanted to thank the community for building this great resource. Deskthority helped me to dig deeper into this rabbit hole and start a (small) collection of mechanical keyboards. Even if I don't post often, I enjoy the conversation and learn everyday a bit more about the typing heaven!
Guillaume
Posted: 29 Jan 2014, 11:00
by BimboBB
Happy Birthday!

Posted: 29 Jan 2014, 11:06
by Muirium
Join Deskthority. Start filling bookshelves with keyboards, bags with caps, drawers with diodes, switches and Teensies; and still be sure you've not enough. It's one way to have fun I had not considered before arriving here. Thanks guys!
Posted: 29 Jan 2014, 11:12
by HzFaq
I came here looking for a capslock and a spacebar for my Filco at the start(ish) of round 4. I now have 10+ keyboards of different flavours, have custom firmware on 2, am building/about to start building another 2 and am starting a handwired numberpad mod job as soon as I get a bit of "free time". And don't start me on time spent scouring ebay for vintage computing stuff....Couldn't be happier though, despite the strange looks I get from friends and family.
Posted: 29 Jan 2014, 11:20
by wheybags
wow, didn't realize DT was so young
Posted: 29 Jan 2014, 11:41
by Madhias
Happy Birthday & all the best!
Re: 2 years of deskthority
Posted: 29 Jan 2014, 12:56
by rindorbrot
Hooray and good luck to all of us!
Posted: 29 Jan 2014, 15:29
by jdcarpe
Happy 3rd Birthday, Deskthority!!
I've been here almost 2 of those 3 years.
And by coincidence, today is my son's 2nd birthday.

Posted: 29 Jan 2014, 16:31
by bhtooefr
Huh, didn't realize it's been that long!
Posted: 29 Jan 2014, 16:39
by scottc
Happy birthday, Deskthority!

Posted: 29 Jan 2014, 19:35
by Muirium
"When can we get it in ISO?"
Posted: 29 Jan 2014, 21:15
by Merijn
ugh non standard modifiers, would be a hell to replace those once eaten
Re: 2 years of deskthority
Posted: 29 Jan 2014, 21:27
by bhtooefr
Not to mention, sub 1U function keys.
Posted: 29 Jan 2014, 21:33
by scottc
Don't all of your keyboards have a 3.25U (ish) left control! Pffftt, commoners!
Posted: 29 Jan 2014, 22:13
by JBert
scottc wrote:
Oh dear, such a detail on the keyboard only to get the mouse cable wrong. Should have gone for a wireless one...
Happy birthday DT!
EDIT: The A to " row also seems to be freakishly out of place. Such a pitty.
Posted: 29 Jan 2014, 22:13
by Daniel Beardsmore
I imagine it would also be a pain having the mouse cable under your wrist.
Posted: 29 Jan 2014, 22:20
by 7bit
3 Years of DT and I still hate SQL.
But: the verbosity of their languages* required high quality input devices, like the Selctrix and the beam- and buckling spring keyboards!
-----------------
*) With the exception of APL for sure.

Posted: 29 Jan 2014, 22:21
by scottc
Daniel Beardsmore wrote:I imagine it would also be a pain having the mouse cable under your wrist.
Oh wow, I hadn't noticed that before... brilliant.

Re: 2 years of deskthority (UPDATE: 3 years of deskthority)
Posted: 02 Feb 2014, 10:08
by hoggy
Happy birthday DT, sorry it's a bit late.