« first day (1227 days earlier)      last day (2703 days later) » 

Whoa, @Pearson is following it!
Oh, he just nuked it >:(
 
@ColeJohnson Not nuking, spamming!
 
@Bart +1
@Undo cast a reopen vote
 
8:16 PM
@ColeJohnson Hmm...
I can't ;(
Ugh, importing the 24-million row Comments.xml into MySQL...
On an old HP laptop.
 
Hats are dumb.
Unless they're fedoras.
Then they're fine.
 
Where do you stand on brown hats?
 
Hats. spits on the ground
Oh. Those are good too, @Bart.
 
@jadarnel27 would probably only wear half a hat...
 
throws @jadarnel27 on the ground and beats him with @Bart's smiting stick until he decides to like hats
 
8:27 PM
Hey hey hey. There shall be no smiting with my smiting stick without my explicit approval!
 
Well that seems like a silly thing to do, @animuson. Why on Earth would I only wear half a hat?
 
@jadarnel27 Well you only shave half your face... I figured you were a half person.
 
Where can you buy decent smiting sticks anyway, @Bart? I got one from Wal-Mart but it was made of candle wax and didn't smite very well.
 
@animuson Oh that. I just have a lazy eye.
;-)
See!
 
Smiting-sticks-r-us @UndotheSnowman.
 
8:29 PM
Ahhh.
 
Woo my parents are taking me out for pizza tonight. ^_^
 
Don't mention pizza if I can't have any!
 
I am half deaf and half blind. Maybe I've been half a person this whole time. You've given me a lot to think about, @animuson.
 
@jadarnel27 would this be okay?
 
@balpha Grrrr.
 
8:31 PM
it's brown and a fedora
 
Stop taunting us.
 
two more days
 
It's, like, three days until I get my hands on hats.
 
and a bit
 
@balpha Heck yeah! Where do I bribe someone for that? Er, I mean, sign up?
 
8:32 PM
You might have just made half his brain explode @balpha.
 
@Bart Half of my brain is my whole brain! (I think)
 
You just hurt my brain.
 
@jadarnel27 pops@. Small, unmarked Bitcoins only. I can get you the stuff on Monday.
 
Grrrr stupid USPS. Estimated delivery: -2 days.
 
8:34 PM
@Pops Understood. I'll see what I can do.
 
Screenshot or it didn't happen, @animuson
 
I've got to move some things around.
 
By the way, update your avatars now to match this year's off-center hats.
 
@Pops Eh?
 
8:36 PM
It's 100% confused.
 
@UndotheSnowman If you look at balpha's screenshot, the hat isn't centered on his avatar. It's centered on his head. What could cause a thing like that?
 
Good thing I paid the $3 for insurance on that.
 
@Pops So we don't get to move the hats around ourselves?
(this is my first SE holiday season)
We have to move our avatars around?
Hmm...
 
@UndotheSnowman you couldn't last year. This year you can
 
Oh, great!
Woohoo!
@balpha So what's the CSS like to make the hat move the username around too? It seems it would be complicated, right?
 
8:40 PM
nope, the JS just gives the name some extra left margin if the hat would overlap
 
the hats are pure clientside JS
 
I would be hopelessly lost in a sea of CSS
Trying to do it server-side
and we wouldn't get hats till 2015.
(reason #365 I don't work at SE)
 
@Undo Where's the rest of the reasons?
 
@hichris123 Primarily due to companies not really wanting to hire minors.
 
8:42 PM
This is the "leave Jin alone - he already had to design the hats" method.
 
He outsourced them this year.
 
Still importing that ginourmous comments table.
 
So Jin also hates hats. Excellent. Excellent...
2
 
Outsourced? Don't tell me we get some of those cheap knock-off "genuine" Pekka hats this year.
4
 
Records: 22666468  Deleted: 0  Skipped: 0  Warnings: 1155
Do I need to be concerned about that last number?
 
8:53 PM
What is that from?
 
Nah, warnings aren't errors. You can safely ignore warnings.
2
 
Protip: 24 million rows is a lot of rows.
And takes a long time to query.
select count(*) from socomments
still running...
 
How long?
 
still going...
I'm not on the best of hardware.
plays Jeopardy music
It's 22666468 rows.
203 seconds
I think I might move over to the ServerFault comments instead.
There's fewer of them.
I just got a lot more grateful for SE's db optimizing.
Whew, that's better
500,000 rows is more manageable.
 
9:09 PM
Could I get a couple reopen votes on this question?
 
There's one
 
This type of question has some dupes on SO, but that is not the right target (which is partially my bad).
 
reopened
 
And the user added code to make his question a bit clearer.
Thanks @Undo and @Anna!
 
9:10 PM
It's nice to show a new person that the system works =P
 
And thanks to whoever cleaned up the comments (probably Anna as well).
 
Um...
"106.4k questions Close Votes"
 
@jadarnel27 I flagged them ;P
 
you just flagged one. slacker :P
 
9:12 PM
@AnnaLear I had my script set to all of them, but then I went away from the page.
 
Excuses
 
Wow, you were too lazy to have a script do the job? Amazing. ;)
tsk tsk tsk
 
^ The best button ever
Lol
 
@Undo Since you have the link to the data-dump, could you give it to me before I actually have to look for it?
 
I have uTorrent installed.
 
Then you should be all set.
 
Wait, what? You're not supposed to download legal stuff with uTorrent.
 
@Bart we won't tell if you don't
@UndotheSnowman were you able to open those archives, btw?
 
@AnnaLear Yup. Tim (one of them) helped me out.
But thanks anyway!
 
9:16 PM
cool
 
You just try to unzip the first one and it magically grabs stuff from the others too.
 
yeah, that's how it should work
 
And now I'm trying to find a correlation between the number of comments and the average score of them on SF :)
SQL is fun!
 
 
1 hour later…
10:40 PM
Little Bobby Tables agrees.
 
10:58 PM
@ThiefMaster I thought his name was Robert'); DROP TABLE students --
REOPEN THIS
16
Spam Review

Proposed Q&A site for i do propose Stack Exchange forum for needing review on spam and extra spam advise.

Closed before being launched.

 
11:09 PM
@ColeJohnson Why?
 
@ColeJohnson Seriously, can we just let it go? The spam thing has gotten beyond old at this point. I'm getting tired of hearing about that proposal.
2
 
I'm not going to lie, I'm the one who flagged it.
 
11:59 PM
@AnnaLear I definitely didn't copy your gravatar
 

« first day (1227 days earlier)      last day (2703 days later) »