Answering Michelle: Pooling CS data

 Posted by (Visited 7084 times)  Game talk
Nov 172006
 

This popped up in a comment thread, and I thought it was a good question to post as an actual post.

All VWs with rules suffer to some degree exploits and avoidances of those rules. Traditionally the people running the VW deal with their troublemakers alone, banning just them. However I’m willing to bet that those abusing one game will do so again in another. Will the time come where separate VW managements share details of those who break their ToS, resulting in “banned in one, banned in all”?

Continue reading »

Stupid spam and CPU…

 Posted by (Visited 4718 times)  Misc
Nov 172006
 

So I once again got a high CPU warning on the site. I go and check the logs, and I find that just querying comments is slow. This is what they told me last week, and I optimized the tables then; I didn’t espect to have problems again so soon.

A quick Google led me to the Codex where I learned that all those comments I marked as spam (many of which are marked automatically) are all still stored.

This quickie step took care of fully 14MB worth of spam comments out of the 25MB comments DB:

DELETE FROM `wp_comments` WHERE `comment_approved` = ‘spam’

I guess this means that the blog can run another year before I need to upgrade hosting!

More Second Life stats

 Posted by (Visited 10188 times)  Game talk
Nov 172006
 

Yeah, the post over at Electric Sheep is actually about CopyBot, and the meeting that Philip Linden held yesterday. But there were stats dropped, and as we all know, this blog likes stats. 🙂

There are some economic stats there, but by and large, there’s no other worlds to compare them to, so there’s little point in reprinting them as they mostly just come across as breathless numbers. More interesting are the ones that we have a basis for comparison:
Continue reading »

More site housekeeping

 Posted by (Visited 6943 times)  Misc
Nov 152006
 

Just a quick bulleted list.

  • I seem to have managed to ditch 300-400 feed subscribers in the upgrade somehow. Sorry, folks. If you’re one of those, resub. I don’t know why it’s not working for you now. Looks like the bulk of the losses are via Bloglines, but all of Bloglines’ feeds look healthy at this point. If you know someone who had a feed and might not anymore, spread the word that it’s OK to come back, the water’s fine.
  • Amazingly, even with the downtime, the traffic to the site itself seems to be right on track. Not sure how we managed that one!
  • I finally got around to putting up my CV and updating the bio on the Gaming front page. If you see any other egregiously out of date stuff, post here (except for the Timeline, I know about that one).
  • Cafepress fixed the CD link after weeks of it not working — yes, I actually got emails about this one. (Crass self-promotion: So if you were craving more of the music on the blog, try that. It makes a nice Xmas present. *hint hint*. You can also try the book; Amazon says they’re just about out of it, but they’ll reorder more if you keep buying them.)
  • Lastly, sorry to disappoint the folks over at RLMMO, but to my knowledge I am not working on a Firefly MMO. Badass idea, though!