一个简单的FLASH+ASP的聊天室程序,不需要后台数据库的支持,界面比较简单,但是已经具备了聊天室的整体基本功能。-a simple FLASH ASP chat room procedures do not need the support of the background database, the interface is simple, but possesses the chat room"s overall basic functions.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002540s ]
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.083980s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001072s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001158s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001165s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003026s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000879s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003562s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025137s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001642s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 77542 [ RunTime:0.031001s ]