W dniu 11.12.2015 14:55, Marcin napisał(a):

2015-12-11 14:48 GMT+01:00 Tomasz Chiliński tomasz.chilinski@chilan.com:

...

W dniu 11.12.2015 14:11, Marcin napisał(a):

...

Cześć do stats wstawiam tym skryptem co kiedyć od Ciebie kupiłem #v+ while (!feof($fh)) { $line = trim(fgets($fh)); $cols = explode('|', $line);

if (!in_array(count($cols), array(7, 11, 12))) continue;

$datetokens = sscanf($cols[0], '%d-%d-%d-%d.%d.%d.%d'); if (count($datetokens) != 7) continue;

$dt = mktime($datetokens[3], $datetokens[4], $datetokens[5], $datetokens[1], $datetokens[2], $datetokens[0]); $oper = $cols[1]; $tag = $cols[2]; $ip = $cols[3]; $mac = $cols[4]; $nasip = $cols[5]; $nasid = $cols[6];

$terminatecause = ''; $download = $upload = 0; if (count($cols) > 7) { $download = $cols[7] * $full32bit + $cols[8]; $upload = $cols[9] * $full32bit + $cols[10]; if (count($cols) > 11) $terminatecause = $cols[11]; }

if (isset($sessions[$tag])) $session = $sessions[$tag]; else $session = $DB->GetRow('SELECT * FROM nodesessions WHERE tag = ?', array($tag)); if ($session) { $prev_download = $session['download']; $prev_upload = $session['upload']; if (count($cols) == 7) { $download = $prev_download; $upload = $prev_upload; } $session['stop'] = $dt; $session['mac'] = $mac; $session['download'] = $download; $session['upload'] = $upload; $session['terminatecause'] = $terminatecause; } else { $prev_download = 0; $prev_upload = 0; if (count($cols) == 7) $download = $upload = 0; $session = $DB->GetRow('SELECT ownerid AS customerid, n.id [1] [1]

AS nodeid, ipaddr, mac FROM vmacs n WHERE n.ipaddr = ?', array(ip_long($ip))); $session['start'] = $session['stop'] = $dt; $session['mac'] = $mac; $session['download'] = $download; $session['upload'] = $upload; $session['tag'] = $tag; $session['terminatecause'] = $terminatecause;

$DB->BeginTrans(); $DB->Execute('INSERT INTO nodesessions (customerid, nodeid, ipaddr, mac, start, stop, download, upload, tag, terminatecause,type) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?,1)', array_values($session)); $session['id'] = $DB->GetLastInsertID('nodesessions'); $DB->CommitTrans();

} //$session['nasip'] = $nasip; //$session['nasid'] = $nasid; $sessions[$tag] = $session;

$delta_download = $download - $prev_download; $delta_upload = $upload - $prev_upload; if ($delta_download < 0) $delta_download = 0; if ($delta_upload < 0) $delta_upload = 0;

if ($delta_download > 0 || $delta_upload > 0) { //if ($DB->GetOne('SELECT dt FROM stats WHERE nodeid = ? AND dt = ?', array($session['nodeid'], $dt))) // continue; $delta_download = sprintf("%.0f", $delta_download); $delta_upload = sprintf("%.0f", $delta_upload); //printf("nodeid=%d dt=%d upload=%s download=%s sessionid=%d\n", $session['nodeid'], $dt, $delta_upload, // $delta_download, $session['id']); $DB->Execute('INSERT INTO stats (nodeid, dt, upload, download, nodesessionid) VALUES(?, ?, ?, ?, ?)', array($session['nodeid'], $dt, $delta_upload, $delta_download, $session['id'])); } }

fclose($fh); unlink($accounting_file); #-

to powinno wstawiać dobrze?

Tak, oczywiście.

no to czyli kwestia rysowania :/

phpui.stat_freq