这是一个用PHP3和javascript写的程序,使用者有他们自己的聊天配置文件,用户数据和聊天记录被写入MYSQL数据库,采用自动卷屏模式,显示在线人数,可以查看在线用户的资料。-This is a PHP3 and javascript used to write the procedure, the user has their own chat configuration file, the user data and chat history are written in MYSQL database, the use of automatic roll-screen mode, display the number online, you can view online information.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001076s ]
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.062977s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000977s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001165s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000964s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003113s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000849s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003689s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015203s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001304s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 2232 [ RunTime:0.016757s ]