//
// aici incepe codul PHP
//
require_once("../local.php");
extract($_REQUEST);
$totalpoze=0;
$totalzile=0;
$max=0;
//
// functia de numarat pozele din fiecare album
//
function countfiles($path, $filter)
{
$dir = opendir($path);
$i=0;
while ($file = readdir($dir)){
if(strstr($file, $filter)){ $i++; }
}
closedir($dir);
return $i;
}
// se inchide functia de numarat pozele
require(ROOT_DIR."/ture/conectare.php");
if(isset($_REQUEST["anul"])) $anul=$_REQUEST["anul"];
else $anul='20';
if (($anul=='x') or (!$anul)) $anul='20';
$anul=htmlspecialchars(stripslashes(mysql_real_escape_string($anul)));
$q="SELECT * FROM ture WHERE zi_inceput LIKE '$anul%' ORDER BY zi_inceput";
$r=mysql_query($q) or die("Eroare");
$idu=0;
?>
Add Stats |
|
| No |
Location |
Route |
Interval |
No of days |
No of photos |
Album |
while ($row=mysql_fetch_object($r))
{
$idu++;
list($an, $luna, $zi) = explode("-", $row->zi_inceput, 3);
// calculez in time() ultima zi din tura
$zi_final = mktime(0,0,0,$luna,($zi+($row->nr_zile)-1),$an);
// verificare pentru tura de 1 singura zi
if ((strtotime ($row->zi_inceput))==$zi_final)
{
$afiseaza_zi ="".$zi."-".$luna."-".$an."";
}
else
{
// transform din time() in date() ultima zi din tura
$afiseaza_zi = $zi."-".$luna."-".$an." -> ".date("d-m-Y", $zi_final);
}
$fstday=$row->zi_inceput;
$url="../poze/".$fstday."/index.php";
$max=0;
// verific daca exista index.php in album si numar pozele din album
if(file_exists($url))
{
$max=countfiles("../poze/".$fstday, "jpg");
$max=$max+countfiles("../poze/".$fstday, "JPG");
$valid_folder=1;
}
else $valid_folder=0;
$totalpoze=$totalpoze+$max;
$totalzile=$totalzile+$row->nr_zile;
//
// populez tabelul cu date din DB si afisez link-uri pentru index.php existent
//
print("");
print("| $idu | ");
print("".strtoupper($row->locatia)." | ");
print("$row->traseu | ");
print("$afiseaza_zi | ");
print("$row->nr_zile | ");
print("$max | ");
if ($valid_folder==1) print("View | ");
else print(" | ");
print("
");
}//inchid while
mysql_data_seek($r,0);
if ($domain=='82.76.116.29')
{
$sql="UPDATE statistici SET total_zile=$totalzile , total_poze=$totalpoze";
mysql_query($sql) or die('Eroare');
}
?>
|
|
|
Total: |
|
|
reviews.climb.ro www.climb.ro linux.climb.ro
©Lucian Gutu |
$query="SELECT * FROM statistici";
$result=mysql_query($query) or die("Eroare");
while ($row=mysql_fetch_object($result))
{
echo "$row->total_poze poze ";
echo "facute in $row->total_zile zile ";
}
// numarul de locatii distincte
$query="SELECT COUNT(DISTINCT ture.locatia) FROM ture";
$result=mysql_query($query) or die("Eroare");
$num_rows = mysql_result($result,0,0);
echo "in $num_rows de locatii diferite.";
mysql_close();
?>