This is the source for the game Subprime Mortgage Tycoon Gold Edition version 1.1 that is currently available on the Android Market. We are releasing it with the hope that other community members can do something cool with it.
文 件 列 表
Subprime Source Code .classpath .project AndroidManifest.xml assets bin default.properties gen res src Prototype Screens
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002360s ]
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.090426s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002417s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001981s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002361s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003954s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002196s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003467s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015385s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002840s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 99324 [ RunTime:0.001418s ]