Ejemplo n.º 1
0
function db_disconnect()
{
    global $_link;
    if ($_link) {
        mysql_disconnect($_link);
        $_link = '';
    }
}
Ejemplo n.º 2
0
$rs = sqa($conn2, "select DATESTAT from tbl_pingtable where DATESTAT>'" . $pi2 . "'");
$pi_count = sizeof($rs);
//Если нужно - обновляем
if ($pi_count < 1) {
    //Вычисляем сколько активных сейчас
    $rs = sq($conn2, "select CODE from tbl_base where LASTPING>='" . $ps_activetime2 . "'");
    $pi_count2 = sizeof($rs);
    //Фиксируем данные
    nq($conn2, "insert into tbl_pingtable (DATESTAT,COUNT) values (NOW()," . $pi_count2 . ")");
}
//=================================================================================================================
printlog("записываем дату обновления");
nq($conn2, "update tbl_conf set VALUEDATE=NOW() where PARAM='LASTUPDSCET'");
//=================================================================================================================
//=================================================================================================================
printlog("делаем запись в истории про обновление");
nq($conn2, "insert into tbl_operhist (OPERCODE,DATEOPER,TYPER,PAR1,PAR2,VAL_OLD,VAL_NEW) values (0,NOW(),3,'','','','')");
//=================================================================================================================
printlog("системные операции. ОКОНЧАНИЕ");
printlog("ставим отметку в базе, что обновление завершено");
nq($conn2, "update tbl_conf set VALUEINT=0 where PARAM='ISUPDATEDO'");
printlog("обновление завершено");
printlog('===========================================');
$ps_file101 = $ps_repalllog;
printlog($zver . " Update FINISH at " . date("d.m.Y H:i:s", time()));
printlog('===========================================');
//клоузим БД
mysql_disconnect($conn1);
mysql_disconnect($conn2);
//грохаем PID на выходе
unlink($pidfile);