《网络游戏客户端编程》第6章的示例程序,源程序中对一些关键代码都有详细注释,望能对初学者有所帮助,也希望能得到朋友的指教。-" Online Game Client Programming" Chapter 6 of the sample programs, source code against some of the key have detailed notes, hope can be helpful for beginners, but also hope to get friends to appropriate advice.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002780s ]
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.099517s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001812s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001994s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002273s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003837s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002252s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003280s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016038s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002493s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 163035 [ RunTime:0.001129s ]