国外游戏开发者杂志2000年第六期配套代码，包含Jeff Lander的关于变形技术的程序和Herb Marselas关于优化技术的代码--Code of game development magazine in 2000 the sixth issue, contains procedure about the distortion technology of Jeff Lander and code about optimized technology of Herb Marselas
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001961s ]
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.072623s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000917s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001167s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000923s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003056s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000815s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003673s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024986s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001744s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 105849 [ RunTime:0.013357s ]
