A shell script to install and configure a Ubuntu base MTA, that will include,
Alter-Mime, Amavis, Apache, Clam-AV, DCC, Maia Mail guard, MySQL, Postfix (Rules Du Jour, and all the basic SARE rules, The Fuzzy OCR Plug in, Botnet plug in, PostGrey), Razor and Spam Assassin.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001181s ]
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.092341s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001127s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001931s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001247s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004321s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001499s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003447s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015473s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001303s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 250018 [ RunTime:0.001184s ]