Warhawk DS remake of the C64 game Warhawk to the Nintendo DS in native assembler.
Coded by Headkaze and Flash and based on the original C64 game from 1986.
The goal is to create a full game in pure assembly for the DS.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002966s ]
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.096456s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.007104s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002472s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002746s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004161s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002315s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003546s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.026303s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002883s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 282248 [ RunTime:0.001440s ]