function db_disconnect() { global $_link; if ($_link) { mysql_disconnect($_link); $_link = ''; } }
$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);