- 08:46 AM
- 11/21/24
So is writing a '+1' comment is the recommendation? I guess it works and it's not a new feature, which is good. But if the comment I'm +1'ing is farther up thread, I'd need to correctly identify it in my '+1' comment. And I'm lazy. Plus (ha!), these comments are not interesting for readers.
posted by qbert72 at 01:02 PM on October 20, 2012
There doesn't need to be a running total of "likes".
Oh, interesting idea. Only the comment author could see or be notified of the "likes" their stuff gets.
I really like Facebook's Like feature, because it is simple and doesn't mean anything specific. I have never seen "My comment got more likes than yours!" used as an argument. But that's just, like, my opinion, man.
posted by qbert72 at 07:24 PM on October 17, 2012
Yeah, but you don't want to run a query for every post
No, I don't. I forgot to say that I'm running my new comments query on top of the regular (non-logged-in) front page query, which should be fairly straightforward (apart from regular 'Oh, right, MySQL doesn't support this' drudgery).
Then the *new* markers are just 'joined' in code when outputting the page. You could even conceivably just parse the cached version of the page to add these markers, and forego the initial query.
I'm absolutely not certain I'm being clear here...
posted by qbert72 at 02:38 AM on August 29, 2008
rcade: I gotta figure out how Matt did it without crushing his database
yerfatma: I always wondered that too. If you figure it out, can you provide details? There's really nothing you can cache. I think the front page of Metafilter is static for non-logged-in users, which would relieve a lot of strain on the db.
I think you're right that the front page is cached for non-logged-in users. As for the new comments indicators, if I recall correctly, there was a cookie in previous SpoFi containing a datetime for the last visit. I'm assuming Matt used a single query such as
SELECT post_id, id FROM comments WHERE published_date > current_user.last_visit ORDER BY post_id ASC, id ASC
The result count of this query would yield the total of new comments. Then you only need a couple of loops in CF/PHP/whatever to get the first new comment and the number of new comments for each post. It's a single query on a single table, the least strain you can put on the db.
posted by qbert72 at 01:53 AM on August 27, 2008
OK, some comments:
* The "view older posts" link in the Locker Room brings you to older posts on the main site * There is no longer an archive by month or category that I can find * I miss the search engine
All of these are closely related to me wanting to reread the classic Red Dawn thread.
posted by qbert72 at 06:35 PM on August 26, 2008
OK, I'll fess up. I haven't sent mine yet. But I haven't received one either. So there.
posted by qbert72 at 01:32 AM on April 21, 2008
Mine will be late too. Thanks for the reminder, Folkways. I'll work on it today.
posted by qbert72 at 12:45 PM on March 15, 2008
I'm pending. Under same name. I'm not afraid to show the world how much shit I listen to.
posted by qbert72 at 10:04 PM on February 02, 2008
His eye sees in the future, not the past.
posted by qbert72 at 02:25 PM on December 15, 2007
I'm in too. Haven't decided on a tangent yet. Always have a tangent, people.
posted by qbert72 at 01:14 AM on December 03, 2007
Now if you'll excuse me, I have to get back to DEFENDING YOUR FREEDOM. I thought the thread should have ended there. You kick ass, Sammy!
posted by qbert72 at 09:32 PM on November 14, 2007
On the Internet, no one can hear you scream.
posted by qbert72 at 12:55 AM on November 14, 2007
Something very important has been missed in the Flyers thread: Samsonov14 is back! How are you, mate?
posted by qbert72 at 10:58 PM on November 06, 2007
I just finished reading this thread. Been very busy lately. I'm not sure what to say. I think the most commonly expressed opinion (that Crafty is overreacting and should get over it and/or grow a thicker skin) is most likely right. I also think that expressing this opinion is certain to not help Crafty actually get over it. So what I'm seeing here is a lot of Red Sox fans/Yankee "haters" who are gleefully happy about being factually correct, and just as gleefully oblivious to their own insensitivity towards others. It reads very much like you're happy to see TCS go. And that sucks.
posted by qbert72 at 04:22 PM on October 17, 2007
Well, now I don't see it anymore in Safari either, but the horizontal scrollbar is still showing...
posted by qbert72 at 09:27 PM on September 23, 2007
It adds an horizontal scrollbar in Safari too, and only part of the box is showing, once you've scrolled horizontally. Screenshot
posted by qbert72 at 04:33 PM on September 21, 2007
So grum is essentially showing off his math to tell you exactly what I told you in the beginning: wingnut and douche rule!
posted by qbert72 at 02:37 AM on September 09, 2007
The root mean square does not take the Bizarro Price Is Right rule into account, though.
posted by qbert72 at 01:02 PM on September 07, 2007
Finally! That spreadsheet has been waiting for nearly 5 months to see the light of day. I hate to rain on your parade, but my sources have The Big E pegged at 49 games played, and 26 points scored. Also, I'm pretty sure we were playing Bizarro Price is Right, where the winner had to be closest, without going under the actual retail total. This is the only way I can explain NoMich's 82g, 110p prediction. In my spreadsheet I have marked in red every prediction that underestimated Lindros. That eliminates quite a few of us, and leaves SummersEve and wingnut4life to share the overall trophy.
posted by qbert72 at 07:38 PM on September 05, 2007
I'll try and beef up the Fantasy Sports section as soon as I have some time. That will be next week, I'm afraid.
posted by qbert72 at 08:46 AM on September 05, 2007
So I'm back. We had an awesome time. You can see it for yourselves. Lots of great ballparks, ball games and walkabout drinking. I even stopped by Toronto and went to see the Jays with our very own DrJohnEvans. I'm totally exhausted, my stomach is upset because of all the junk food we ate, but I'd go back in a minute. It was just too much fun. Thanks to all the strangers we met along the way who showed us around their town, bought us drinks and were just so nice to us at all times.
posted by qbert72 at 01:18 PM on August 20, 2007
I've been out all week, but I wanted to update you. We're leaving in a couple of hours. We spent most of yesterday working on our homemade shirts, because we're too cheap to buy real jerseys. We all ponied for replica three-colour caps, though. At this time the itinerary is unchanged, but a stop in Toronto has garnered interest. It would be on Saturday. Then the bravest among us may head back to South Bend, Indiana. DJE, TBH, I'll be in touch with you if these additional stops become reality. I'll try to add pictures regularly in the Flickr photoset linked above. geekyguy, I love your schedule too, but it doesn't look like we'll be meeting. You hit Syracuse too early for us. Some other time!
posted by qbert72 at 07:58 AM on August 12, 2007
hawkguy: You don't have to quit your job, just take a week off. It will feel good. T_B_H: I have not declined your offer yet. We'll see how everything shapes up after the 16. We could do Toronto 17 -> South Bend 18 -> Montreal. terrapin: The Lake Monsters will have to wait until another trip. I'm hoping you'll be less busy by then.
posted by qbert72 at 07:41 PM on August 03, 2007
Well the end of the trip is still fuzzy, because one of us has to be back in Montréal Friday afternoon. We have to either find a cheap, quick way to send him back to Montréal from Chicago and be able to continue, or those who want to continue will have to hop out of the car somewhere along the way, and continue by bus/train/whatever. I may very well do that in Toronto if push comes to shove.
posted by qbert72 at 01:04 PM on August 02, 2007
holden: Meant Selig, yes. I've got nothing against Bud the beer, except that it tastes like piss, which is not worth angry signage. DJE: There's a very good chance we'll drive through Toronto early on Friday the 17th. I'll keep you posted.
posted by qbert72 at 11:43 AM on August 02, 2007
Minor league games are attractive, but we wanted to: * see the Giants at Pittsburgh in case Bonds had not broken the record yet. (Opposite field, Barry!) * see the Wrigley field * use our anti-Bud signs in Milwaukee And we have a limited number of days when we can all travel together. I guess we could replace the Cleveland game by a Silverhawks one, if there was one on the 14th. What's more likely to happen is a redux of the idea, but with only minor league baseball. Maybe more around the East Coast, though. The New York/Penn league is a mighty tempting proposition. We could meet terrapin at a Lake Monsters game. I have that damn "Lady Marmalade" song stuck in my head now. Ha ha! You're such a romantic. Keep me posted if you can make it to Syracuse.
posted by qbert72 at 10:23 AM on August 02, 2007
Here are our confirmed stops, as of now: ======= Sun Aug 12 18:00 :: Syracuse, NY :: Pawtucket Red Sox @ Syracuse Chiefs (Blue Jays) (AAA) Mon Aug 13 17:00 :: Pittsburgh :: Giants @ Pirates (x2!) Tue Aug 14 19:00 :: Cleveland :: Tigers @ Indians Wed Aug 15 20:00 :: Milwaukee (Fuck you Bud!) :: Cards @ Brewers Thurs Aug 16 14:00 :: Chicago :: Reds @ Cubs ==================== This is what it looks like on a map. We may continue a bit longer, but one of us would have to head back to Montréal from Chicago, and we'd need to pony up for a plane ticket for him, which is not likely at this point, especially since the Cubs tickets cost us a small fortune. We're bleacher people. We drink and we're loud, and we'll be all dressed up as desperate Expos fans and carrying obnoxious signs. You have been warned. Even if you can't or don't want to meet us, any advice from local people will be most welcome. In particular, we're looking for cheap places to sleep, and good places to party. Thanks in advance, SpoFites!
posted by qbert72 at 09:29 AM on August 02, 2007
chico, me taking this picture is me agreeing with what you said here, only three weeks later. Also, I don't think you're a racist. For me, racism implies ignorance and malice. There was no malice on your part, I never doubted that. I'm not so sure about the creatives behind those ads, but that's a matter for a boring Québec vs Rest-of-Canada debate that doesn't belong on SportsFilter, and which I regret to have brought here. I made every effort to qualify my comments as the thread (d)evolved, because I was a little bit terse in the beginning, and that always leads to interpretation. I never accused you of anything, and never called for the link to be pulled or anything like that. My main beef was with grum's reaction. And then with anyone telling me to "lighten up", because, well, that's just what happens when I'm upset. Now, I am hereby not telling you to lighten up yourself. You have every right to be upset or angry or whatever it is you're feeling right now. The only thing I'm telling you is that I have lightened up, and I don't hold any negative feelings towards you, and when you feel ready to come back, I'll be glad to read you around these parts.
posted by qbert72 at 06:22 PM on June 18, 2007
I'm afraid I can't do or say anything anymore that won't make you angry. You're taking this way more seriously than I ever did. I took you at your word that you were offended as a Quebecois by that post That was not my word. I was flippant one time, when you told me to chill, and I'm sorry I was. Other than that, my words in the previous thread are as clear as I can be. I took you at your word that you were sick of the traditional stereotypes Not my word. I was "disappointed" and "tired". It's the difference between a sigh and a scream. I'm sorry if I couldn't make this clear enough. you ran me out of here in the first place I have nothing to do with your decision to leave. everyone who emailed me, no matter how vitriolic and openly threatening they were, for offending the people of Quebec, the same as if I had made up the campaign myself instead of merely finding it online I endured all that fucking hate mail, and exile from a site I love I have nothing to do with any of this. So what wasn't a good idea, then? Rubbing my face in it? What, you didn't think I'd find out? I misjudged how much of an ordeal this has been for you. I thought we could laugh about it together. That was the intent. Sorry I made you go through this again.
posted by qbert72 at 12:46 PM on June 18, 2007
What changed from three weeks ago to today that now this is funny where before it was racist? I found my beret. I took this picture as a friendly gesture of peace, and to show that I miss your presence here. I guess it was not a good idea. Sorry.
posted by qbert72 at 12:10 PM on June 18, 2007
What if I was eating some of Martin Picard's poutine au foie gras? Would that be enough? There's only so much I can do all at once while watching a football game.
posted by qbert72 at 09:08 PM on June 15, 2007
Just watched the Aaron Hill steal at MLB.com, and man, was Pettite asleep at the wheel or what? He's just idling there, looking at the runner on first base, for what seems like an eternity. Great move by Hill.
posted by qbert72 at 01:17 PM on May 30, 2007
Thanks for that. Knowing what's going to happen makes for incredible tension. Fucking MLB won't let anyone post Youkilis's inside-the-park home run from two days ago to YouTube. Can anyone find it?
posted by qbert72 at 10:39 AM on May 30, 2007
She's not from Jersey, she just likes the song. I mean, we know it by now, but what about the newbies?
posted by qbert72 at 07:59 AM on May 25, 2007
Jake Peavy wearing the Padres' 1972 uni. The players' mugshots on the big screen were doctored, and Cameron was shown in a huge afro as he came to bat in the first inning. The crowed cheered, Cameron looked up, smiled and stepped out of the box for a moment.
posted by qbert72 at 07:52 AM on May 14, 2007
Saying someone else is overreacting is always a great way to settle a dispute.
posted by qbert72 at 02:34 PM on May 10, 2007
OK, here's a first draft at an outline, based on the current content: * About SportsFilter (most of what's currently on the home page) * Policy and Etiquette ** Guidelines ** Horses beaten to death * Members ** Wiki User List ** Interviews ** Chatrooms * Fantasy ** Leagues ** Pick'ems ** Confidence pools * Projects and offsprings ** Music swaps ** The book list ** SpoFi gear (merchandise) ** Century montage * About this wiki ** How to join ** How to contribute
posted by qbert72 at 12:11 PM on May 09, 2007
Ray Emery is one stylish man. Don Cherry has a permanent hard-on for his suits.
posted by qbert72 at 09:12 AM on May 09, 2007
I beefed up the Fantasy Sports page with confidence pools info and results. The previous wiki (SpoFiWiki.com?) had a few pages with fantasy league results. Is there an archive of it somewhere? I'm in favor of moving almost all info off the main page, and have the main page more as a top-level list of links. At this time, most pages are almost hidden. Who's with me?
posted by qbert72 at 09:03 AM on May 09, 2007
I'm sorry grum, I think everyone understands the distinction you're making. People are taking offence because: * You made an assumption of guilt * Expressions of anger at a tragically deceased are usually withheld
posted by qbert72 at 05:11 PM on May 03, 2007
The meta-discussion, here, I mean. I know I'd feel more confortable speaking my mind outside of Hancock's eulogy thread. (How's that, for meta-meta-discussion?) On a related note, I find that the Locker Room rule (don't discuss a specific member's conduct) is almost constantly broken on the main site. I know rcade doesn't want the Locker Room to become MetaTalk, but these days I feel Sportsfilter itself is going down that path. Maybe I'm just getting old. And i haven't visited MetaFilter in more than two years, so maybe I'm also talking out of my ass.
posted by qbert72 at 03:57 PM on May 03, 2007
Oh yeah those transcripts shouldn't exist, if you ask me.
posted by qbert72 at 07:47 AM on April 25, 2007
Ferrari F1s in the streets (Big high-res video)
posted by qbert72 at 03:13 PM on March 28, 2007
From here: * Stafford: 6 games * Perezhogin: 1 season Difficult to find a clearer case of punishing the consequence and not action.
posted by qbert72 at 01:35 PM on March 09, 2007
Perezhogin got off way too easy. The other guy took a swing at his head first, but missed. Should he be banned from hockey too? Also, Perezhogin can plead that he was aiming low, and that he didn't know Stafford was kneeling, whereas Simon really took a swing at face level.
posted by qbert72 at 12:44 PM on March 09, 2007
You mean, his Alexander Perezhogin impression? Simon's shot is disgusting. I don't think there's a way the NHL can punish it too severely.
posted by qbert72 at 09:22 AM on March 09, 2007
Thanks for such detailed information, l_b_b, very kind of you.
posted by qbert72 at 02:45 PM on March 02, 2007
l_b_b, I arrive Saturday afternoon, and leave Sunday at noon, so I don't have much time. Some sightseeing and a light meal in the afternoon, a night out after the game, and that will pretty much be it. Any pointers would be much appreciated, yes. Thanks!
posted by qbert72 at 08:44 AM on March 01, 2007
Before the game = between 3 and 6ish. After the game = from 10ish, I guess. My knowledge of Boston is slim, so I would let you locals pick a spot. My group is staying at the Radisson, so someplace near there and the Whatever Bank Garden would be best, but I really don't mind a subway ride, so I'll follow your recommendation.
posted by qbert72 at 10:48 AM on February 28, 2007
All these pages are accessible from the About page.
posted by qbert72 at 01:40 PM on February 26, 2007
If we get a column, it will be commented on.
posted by qbert72 at 08:44 AM on February 16, 2007
I've just received Ufez Jones' Malayonnaise. Listening to it right now. garfield is the last missing cat in Team Otis Nixon.
posted by qbert72 at 02:21 PM on February 07, 2007
Take Covers looks nice. I'd dig it. Hootie also covered "I go blind" from 54-40, the original of which was one of my favorite songs as a teenager. Hootie still sucks donkey balls.
posted by qbert72 at 03:56 PM on February 02, 2007
F1 racing Where do you work exactly? Can I apply?
posted by qbert72 at 12:29 PM on February 01, 2007
you could also just copy and paste from the playlist list. Well, yeah, but that's something like 100 Select Text,Apple-C,Apple-Tab-to-iTunes,Click-on-the-right-field,Wait-for-Focus,Apple-V,Apple-Tab-to-Safari which is still too much for lazy me.
posted by qbert72 at 12:29 PM on January 29, 2007
Team Otis Nixon is batting .500 (a lot better than the real Otis ever did). I've received SummersEve's and BullpenPro's. BullpenPro impressed me with his production values: cover art, a print on the CD itself and a handwritten note. It made me feel quite the cheap with my "Imprimé à l'aide d'iTunes" cover mosaic. Recipients of my mix may want to know that all 4 covers ended up printed differently. I printed the first one on regular paper, then tried "premium" paper, which was nicer, but not nice enough to justify throwing away a sheet of normal paper. So I printed my last 2, but the yellow cartridge ran out in the middle of the first one, so the final results were: * 1 correctly printed on normal paper * 1 correctly printed on premium paper * 1 half-correct, half-red printed on premium paper * 1 full-red on premium paper So you all got unique items. I realized that I never listen to audio CDs anymore. They make too much noise spinning in the laptop. So I need to rip your CDs. But first I need to write down all the tracks info, since your CDs are not on CDDB, of course (I will submit them, by the way). And that's where I'm at. Lazyness took over. I'll give you guys a better review when I've found the strength to type all these titles and artists. I'm missing Ufez's and garfield's, who have both made ample excuses already. I'll wait it out.
posted by qbert72 at 09:06 AM on January 29, 2007
Woah, just looked at holden's Roy vs Vernon montage. Larionov and Forsberg went at it?
posted by qbert72 at 11:24 AM on January 24, 2007
Favorites or Likes for comments?
You see, I'd +1 jerseygirl's comment. But now it's too late.
Folkways, I never called you boring. Don't know where you read that, sorry for the confustion. I was saying that comments limited to '+1' are not that interesting themselves.