The Technoid-IRC channel script is a script to help users on the network. As well as tools for helping users manage their channels it has a number of predefined FAQ answers that can be used to reply to users asking for help.
The script is written for mIRC but it is also translated to other clients too.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002217s ]
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.088707s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002838s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002062s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002202s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003634s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001955s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003282s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014561s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002367s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 247850 [ RunTime:0.001271s ]