Allows administrators of a phpBB version 3 forum to allow users to enter a skype profile which, if activated in skype, will show that users status on skype while in the forum and allow other users to "call", "chat", etc. them
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001546s ]
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.123298s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001413s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002433s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001650s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004524s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001549s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003817s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015993s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001501s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 36842 [ RunTime:0.001434s ]