On Fri, 2010-09-24 at 09:57 +0200, Xavier Antoviaque wrote: > I've put together a first set of stats for HackIt, based on the data > saved by Vlad in the database. It's just a primer to give you an idea > of the kind of things that are possible - if you have specific demands > or questions about player behavior (or if you need a specific extract, > like David to update the BP), let me know!
Btw, Vlad, I've run into issues when I tried to get the usernames linked to each website. Can you tell me what's wrong with the following query? It currently only returns one row, I must be missing something: SELECT `site_tree`.`id` AS `site_tree_id`, `sites`.`site` AS `site`, `sites`.`date_added` AS `date_added`, `users`.`nickname` AS `nickname` FROM site_tree, sites, game_sessions, users WHERE `site_tree`.`site_id` = `sites`.`id` AND `site_tree`.`session_id` = `game_sessions`.`id` AND `game_sessions`.`user_id` = `users`.`id` Also, going through the database made me wonder about one thing - why do you base things on the session, rather than on users? For example the site_tree reference to the session, or the hack points and scan points in the game_session table? I understand the issue of having anonymous users, but wouldn't it be more handy to create anonymous users on the fly when an anonymous session is started? Xavier. _______________________________________________ Hackit Bar mailing list - [email protected] Wiki: http://community.hackit.cx/ List: http://community.hackit.cx/ml/ Forum: http://community.hackit.cx/forum/ Ideas: http://community.hackit.cx/ideas/ IRC: irc://irc.freenode.net/#politis
