The Mooniacs Website

  • user warning: Got error 28 from storage engine query: SELECT node.nid AS nid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, node.title AS node_title, RAND() AS _random FROM node node LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.type in ('quote')) AND (node.status <> 0 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) ORDER BY _random ASC LIMIT 0, 1 in /var/www/jg-soft.com/modules/acquia/views/includes/view.inc on line 755.
  • user warning: Got error 28 from storage engine query: SELECT node.nid AS nid, node_data_field_images.field_images_fid AS node_data_field_images_field_images_fid, node_data_field_images.field_images_list AS node_data_field_images_field_images_list, node_data_field_images.field_images_data AS node_data_field_images_field_images_data, node_data_field_images.delta AS node_data_field_images_delta, node.type AS node_type, node.vid AS node_vid, RAND() AS _random FROM node node LEFT JOIN content_field_images node_data_field_images ON node.vid = node_data_field_images.vid INNER JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid AND term_node2.tid = 41 WHERE (node.status <> 0 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.type not in ('project')) AND (node_data_field_images.field_images_list <> 0) AND (term_node.tid = 13) AND (term_node2.tid IS NULL) ORDER BY _random ASC LIMIT 0, 1 in /var/www/jg-soft.com/modules/acquia/views/includes/view.inc on line 755.
http://themooniacs.com/leaderboards
June 5, 2011

This little website doesn't look like much, but there's a ton of technology behind it. It is integrated with the game. The game sends stats out to webservers that collect the stats and process them to create leaderboard data. The website then pulls this leaderboard data down and transforms it into some HTML so that we can also see a nice concise little view of what is going on. The site also integrates with a central authentication system that the games also use. That way you can sign into the game with the same account you use to sign into the website and vice versa. 

The technology stack behind the leaderboards is pretty proprietary but i'll just say it uses mainly python and cassandra and I didn't write it. I'm not yet a python convert, but maybe some day. I like languages to look like c, what can i say?

Pros:

  • Great design
  • Great build
  • My piece was really fun, another facebook integration, another central authentication system. I improved more on my authentication system mastery. I'm getting close to being good at these now.

Cons:

  • The normal scheduling, project management fire drill up all night panic

Screenshots