Tak tady sem ten scriptik upravil pro SQL ve ktere si vytvorite DB internet-data a tabuli users s polozkami jmeno (jmeno) ,heslo (heslo), jmeno zakaznika (zakaznik), oid download (oid_down), oid upload (oid_up) a pobezi to. A budou se zobrazovat data i za minuly mesic.
<?php
// Script by RV-SOFT (c) 2006 ver. SQL
// Zakaznik nacteny dle jmena a hesla z SQL
$conn = mysql_connect("localhost", "jmeno", "heslo");
mysql_select_db("internet-data");
mysql_query("SET NAMES 'cp1250'", $conn);
$sql = "SELECT * FROM users WHERE jmeno = '".$name."'";
$dotaz = mysql_query($sql);
$row = mysql_fetch_array($dotaz);
mysql_close($conn);
// Kontrola přihlášení
if ($row['jmeno']==$name && $row['heslo']==$pass && $row['jmeno']):
$zak=$row['zakaznik'];
$oid_down=$row['oid_down'];
$oid_up=$row['oid_up'];
$fn=$row['jmeno'].".dat";
$fna=$row['jmeno'].".bak";
// vars
$router="10.30.0.110 public";
$ex_down="GetSNMP $router $oid_down";
$ex_up="GetSNMP $router $oid_up";
$mon=intval(date("m"));
$dt[1]="leden";
$dt[2]="únor";
$dt[3]="březen";
$dt[4]="duben";
$dt[5]="květen";
$dt[6]="červen";
$dt[7]="červenec";
$dt[8]="srpen";
$dt[9]="září";
$dt[10]="říjen";
$dt[11]="listopad";
$dt[12]="prosinec";
// Nacteni archivu
if (file_exists($fna)):
$fp=fopen($fna,"r");
$down_archiv=intval(fgets($fp));
$up_archiv=intval(fgets($fp));
$all_archiv=intval(fgets($fp));
$mon_archiv=intval(fgets($fp));
fclose($fp);
else:
$down_archiv=0;
$up_archiv=0;
$all_archiv=0;
$mon_archiv=$mon-1;
if ($mon_archiv=="0") $mon_archiv=12;
endelse;
endif;
// předchozí data
if (file_exists($fn)):
$fp=fopen($fn,"r");
$down_save=intval(fgets($fp));
$up_save=intval(fgets($fp));
$down_old=intval(fgets($fp));
$up_old=intval(fgets($fp));
$mon_save=intval(fgets($fp));
fclose($fp);
else:
$down_save=0;
$up_save=0;
$down_old=0;
$up_old=0;
$mon_save=$mon;
endelse;
endif;
// Reset k prvnimu v mesici
if ($mon!=$mon_save):
$down_archiv=intval($down_old+$down_save);
$up_archiv=intval($up_old+$up_save);
$all_archiv=intval($down_archiv+$up_archiv);
$mon_archiv=$mon_save;
$down_old=0;
$up_old=0;
$down_save=0;
$up_save=0;
$fp=fopen($fna,"w");
$archiv=$down_archiv."\n".$up_archiv."\n".$all_archiv."\n".$mon_archiv;
fputs($fp,$archiv);
fclose($fp);
endif;
// SNMP dotaz
$p=exec($ex_down,$a1,$a2);
$p1=exec($ex_up,$b1,$b2);
$ar=0;
$v=$a1[$ar];
$v2=$b1[$ar];
// Přepočet jednotek
$down=round($v/1000000);
$up=round($v2/1000000);
// kontrola resetu routeru
if ($down<$down_save):
$down_old=$down_old+$down_save;
$down_save=$down;
endif;
if ($up<$up_save):
$up_old=$up_old+$up_save;
$down_save=$up;
endif;
// Zápis hodnot na disk
$zapis=intval($down)."\n".intval($up)."\n".intval($down_old)."\n".intval($up_old)."\n".intval($mon);
$fp=fopen($fn,"w");
fputs($fp,$zapis);
fclose($fp);
// VARS pro obrazovku
$download=$down+$down_old." MB";
$upload=$up+$up_old." MB";
$all=$download+$upload." MB";
// end script by RV-SOFT (c) 2006
?>
<html>
<body bgcolor="#F5F5F5">
<table border="1">
<td>
<b><font size="1" face="verdana" color="blue"> Vaše přenesená data </font></b>
<td>
</table>
<br>
<table border="1">
<tr>
<td align="center"><b><font color="#5555aa"> <?php echo $dt[$mon_archiv] ?> </td>
<td align="center"><b><font color="#5555aa"> Odeslané </td>
<td align="center"><b><font color="#5555aa"> Přijaté </td>
<td align="center"><b><font color="#5555aa"> Celkem </td>
<tr>
<td align="center"> <?php echo $zak ?> </td>
<td align="center"> <?php echo $down_archiv ?> </td>
<td align="center"> <?php echo $up_archiv ?> </td>
<td align="center"> <?php echo $all_archiv ?> </td>
</tr>
</table>
<br>
<table border="1">
<tr>
<td align="center"><b><font color="#5555aa"> <?php echo $dt[$mon] ?> </td>
<td align="center"><b><font color="#5555aa"> Odeslané </td>
<td align="center"><b><font color="#5555aa"> Přijaté </td>
<td align="center"><b><font color="#5555aa"> Celkem </td>
<tr>
<td align="center"> <?php echo $zak ?> </td>
<td align="center"> <?php echo $download ?> </td>
<td align="center"> <?php echo $upload ?> </td>
<td align="center"> <?php echo $all ?> </td>
</tr>
</table>
<br>
<input type="button" value="Úvodní stránka" onClick="location.replace('../uvod/uvod.html');">
<?php
else:
?>
<html>
<body bgcolor="#F5F5F5">
<b><font size="1" face="verdana"> Neplatné přihlášení.</font></b><br>
<br>
<input type="button" value=" Zpět " onClick="location.replace('index.php');">
<?php
endelse;
endif;
?>
Do tohoto scriptu staci z html stranky z formularem postnout $name a $pass.
