A multiplayer death-match game, using the Delta3D Open Source Engine.
Players control boats in an interactive water environment and try to blast their opponents out of the water!
"This ain"t no kiddie pool"
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001335s ]
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.094845s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001256s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001931s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001223s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003730s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001098s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003304s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014761s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001535s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 271817 [ RunTime:0.001329s ]