Slashdot Mirror


User: wicks0r

wicks0r's activity in the archive.

Stories
0
Comments
9
First seen
Last seen
Profile
(view on slashdot.org)

Comments · 9

  1. Re:OMG WHY NOT ON MAC? on Open Source FPS Game Alien Arena 2009 Released · · Score: 4, Informative
    There is a "unofficial" mac patch here, but I can't get it working on 10.5.7. Anyone else get it working?

    From the Alien Arena site:

    The official MacOS port has been indefinitely postponed. However, apparently someone has indeed ported Alien Arena to the Mac, and released a patch. Download the linux version above, then apply this patch. We cannot guarantee this will work.

  2. Re:Books on MythTV on Three MythTV Linux Distros Compared · · Score: 2, Informative

    Try Hacking MythTV. It's from Jarod Wilson who wrote one of the most popular MythTV howto out there.

  3. Re:How about Applescript or Fscript? on iPhone Can Now Run Apache, Python, Vim · · Score: 3, Insightful

    How about SSH?

    Might be time to bite the $600 bullet.

  4. Re:How is MythTV dead? on Zap2It Labs Discontinuing Free TV Guide Service · · Score: 1

    It's not that hard, really, and took me all of an hour to do. Yes but the hard part comes when users need data scrapped for various states/countries for local programming, as well as digital programming. Having data come from a single source saved us a lot of time.
  5. Correction: 4 out of 6 computers down on ISS Computer Failure · · Score: 2, Insightful

    Two out of six computers in a reduntant system cannot be rebooted. From TFA:

    The station's Russian segment has a network of six primary computers, three for guidance and navigation and three for command and control, any one of which can handle the duties of its counterparts, Suffredini said, adding that only two were online early Wednesday. Big difference!
  6. Since when is Weezer 80s? on Guitar Hero III, 80s Tracks Announced · · Score: 1

    Will there be a separate 80s version? I can't see the following as fitting the hair metal genre... "Cherub Rock" (by Smashing Pumpkins) "Sabotage" (by Beastie Boys) "The Metal" (by Tenacious D) "My Name is Jonas" (by Weezer) "Knights of Cydonia" (by Muse)

  7. Re:Multiple OS Support on StarCraft, Nothing But StarCraft · · Score: 1

    That was weird... restarted my browser and it looks fine. The screenshot thumbnails and title background weren't showing. Firefox 2.0.0.3 on XP.

  8. Re:Multiple OS Support on StarCraft, Nothing But StarCraft · · Score: 0

    Say what you will about them, but they take cross-platform compatibility seriously. If only they took cross-browser compatibility seriously. http://www.starcraft2.com/screenshots.xml
  9. Re:Beta on AOL Targets Digg, YouTube With New Netscape Site · · Score: 1
    Well, I wouldn't award this site beta quality even. Upon filtering the comments as "5 Excellent" I get a few nasty SQL errors. It looks like they run an extra database query just to fit in the advertisement after 5 comments. I'm sure they could've done this in the code instead of lazily running another query.
    Column 'rating' in having clause is ambiguous SELECT c.commentid,m.alias,c.text,c.createdon,c.modrating , IFNULL(modRating,IFNULL(SUM(cr.rating),'Neutral')) aggregateRating, avatar, m.memberId, cr2.rating rated, stars,m.avatarImagePath FROM comment c LEFT JOIN commentrating cr ON cr.commentId = c.commentId LEFT JOIN commentrating cr2 ON cr2.commentId = c.commentId AND cr2.memberId = 0 LEFT JOIN blacklist b ON b.blockedMemberId = c.memberId AND b.memberId = 0 INNER JOIN member m ON m.memberid = c.memberid WHERE c.storyid = 1645 AND b.blackListId is null AND c.status > -1000 GROUP BY c.commentId HAVING SUM(rating) > 5 or AVG(rating) is null ORDER BY createdOn LIMIT 5
    - - - ADVERTISEMENT - - -
    Column 'rating' in having clause is ambiguous SELECT c.commentid,m.alias,c.text,c.createdon,c.modrating , IFNULL(modRating,IFNULL(SUM(cr.rating),'Neutral')) aggregateRating, avatar, m.memberId, cr2.rating rated, stars,m.avatarImagePath FROM comment c LEFT JOIN commentrating cr ON cr.commentId = c.commentId LEFT JOIN commentrating cr2 ON cr2.commentId = c.commentId AND cr2.memberId = 0 LEFT JOIN blacklist b ON b.blockedMemberId = c.memberId AND b.memberId = 0 INNER JOIN member m ON m.memberid = c.memberid WHERE c.storyid = 1645 AND b.blackListId is null AND c.status > -1000 GROUP BY c.commentId HAVING SUM(rating) > 5 or AVG(rating) is null ORDER BY createdOn LIMIT 15 OFFSET 5