Cavedroid is a 3D game for Android phones based off the classic game SFCave. It enhances the original not only by adding the extra dimension but also adding collectable items, an online high score table through ScoreNinja and a tilt mode using Androids orientation sensor.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002047s ]
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.086514s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002298s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002751s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002030s ]
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.001884s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003353s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014929s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002255s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 99344 [ RunTime:0.001241s ]