EOF; $totalalb = 0; $totalnbr = 0; $totalphot = 0; $totalsize = 0; $totalhits = 0; while($ligne==true) { echo ''; // Nom du groupe $val = $ligne[visibility]; if ($val==0) { echo ''; } else { $sqlGroup = 'SELECT `group_name` FROM `cpg133_usergroups` WHERE `group_id`=' .$val ; $resGroup = db_query($sqlGroup); $owner = mysql_fetch_array($resGroup); echo ''; mysql_free_result($resGroup); } // Comptage du Nbr. d'albums $sqlGroup = 'SELECT count(`aid`) As Nbr FROM `cpg133_albums` WHERE `visibility`=' .$val .' GROUP BY cpg133_albums.visibility'; $resGroup = db_query($sqlGroup); $owner = mysql_fetch_array($resGroup); $val = $owner[Nbr]; echo ''; $totalalb = $totalalb + $val; mysql_free_result($resGroup); // Comptage photos, etc $nbr = $ligne[Nbr] ; $totalnbr = $totalnbr + $nbr; echo ''; $val = $ligne[Taille] / 1024 ; $totalphot = $totalphot + $val; echo ''; $val = $ligne[Total] / 1024 ; $totalsize = $totalsize + $val; echo ''; $val = $ligne[Hits]; $totalhits = $totalhits + $val; echo ''; /* Hits / Nbr photos */ if ($val==0) { echo ''; } else { echo ''; } /* Fin de la ligne */ echo ''; $ligne = mysql_fetch_array($result); } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

Groupe privé	Nbr Albums	Nbr photos	Ko photos	Ko photos + vignettes	Vues	Vues / photo
No 0 - Public	No ' .$val .' - ' .$owner[group_name] .'	' .$val .'	' .number_format($nbr,0,',',' ') .'	' .number_format($val,0,',',' ') .'	' .number_format($val,0,',',' ') .'	' .number_format($val,0,',',' ') .'	0,0	' .number_format(($val/$nbr),1,',',' ') .'
Total des ' .$album_count .' groupes	' .number_format($totalalb,0,',',' ') .'	' .number_format($totalnbr,0,',',' ') .'	' .number_format($totalphot,0,',',' ') .'	' .number_format($totalsize,0,',',' ') .'	' .number_format($totalhits,0,',',' ') .'	' .number_format(($totalhits/$totalnbr),1,',',' ') .'

'; mysql_free_result($result); ?>