예제 #1
0
$conf["log"]["logfile"] = $conf["tmpDir"] . $conf["separator"] . $_SERVER["SERVER_NAME"] . ".log";
//uroven logu, ktera se bude ukladat
//PEAR_LOG_EMERG, PEAR_LOG_ALERT, PEAR_LOG_CRIT, PEAR_LOG_ERR,
//PEAR_LOG_WARNING, PEAR_LOG_NOTICE, PEAR_LOG_INFO, PEAR_LOG_DEBUG
$conf["log"]["level"] = PEAR_LOG_DEBUG;
//druh handleru (mail,file,console,firebug,display,error_log,null,mdb2,syslog,sql)
$conf["log"]["handler"] = "file";
//rozsirujici konfigurace handleru
$conf["log"]["conf"] = array("timeFormat" => "%Y-%m-%d %H:%M:%S", "lineFormat" => "%{timestamp} [%{priority}] %{message}", "buffering" => true);
//konec logu
session_start();
//inicializace db
foreach ($conf["sqlconn"] as $server => $db) {
    try {
        $sqlEngine = new SQLEngine();
        $sqlEngine->setSlaveConnection($db["dbhost"], $db["dbuser"], $db["dbpass"], $db["dbname"]);
        $adminDataQuery = "SELECT * FROM spravce_info";
        $rs = $sqlEngine->query($adminDataQuery);
        $conf["spravce_info"] = SQLEngine::getFirstRow($rs);
        $pocetDnu = 7;
        $rozdil = 60 * 60 * 24 * $pocetDnu;
        $selMsg = "SELECT TIMESTAMPDIFF(DAY, vlozeno, NOW()) as naposledyVlozeno\n           FROM zpravy\n           INNER JOIN spravce_admini ON spravce_admini.id = zpravy.vytvoril\n           WHERE TIMESTAMPDIFF(DAY, vlozeno, NOW()) >= 7";
        $rs = $sqlEngine->query($selMsg);
        if (SQLEngine::getRowCount($rs) > 0) {
            $pocetDnu = SQLEngine::getFirstRow($rs);
            $pocetDnu = $pocetDnu["naposledyVlozeno"];
            echo $server . ": " . $pocetDnu . " > " . $conf["spravce_info"]["spravceEmail"] . "<br />";
            $mail = new PHPMailer();
            $mail->From = $conf["spravce_info"]["odesilatelEmail"];
            $mail->FromName = $conf["spravce_info"]["odesilatelName"];
            $mail->set('Return-Path', $conf["spravce_info"]["odesilatelEmail"]);