A game currently being made by me in the RPG style. It uses Python 2.5 and pygame 1.8 (I think). Other modules are installed by default.
More information will be available on charas-project.net
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001602s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.087047s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001306s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002056s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001366s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003683s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001058s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003229s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014492s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001568s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 39404 [ RunTime:0.001663s ]
