Les sites qui utilisent le Mini-webcam-moi :
include('include/server.conf.php');
include('include/config.php');
$sql = "SELECT count( id ) AS tut FROM photo WHERE minisite > 0 GROUP BY minisite ORDER BY tut DESC";
$result = mysql_db_query($SQL_DataBase, $sql, $SQL_link) or die($sql);
if ($result > 0) $row = mysql_fetch_array($result);
$themax = $row[0];
$maxsize = 25;
$minsize = 7;
$sql = "SELECT * FROM minisite";
$result = mysql_db_query($SQL_DataBase, $sql, $SQL_link) or die($sql);
if ($result > 0)
{
for ($t = 0; $t < mysql_num_rows($result); $t++)
{
$row = mysql_fetch_array($result);
$qryt = "SELECT count(id) FROM $TableSQL WHERE minisite LIKE '".$row['clef']."'";
$resultt = mysql_db_query($SQL_DataBase, $qryt, $SQL_link) or die ('Erreur : '.mysql_error() );
if ($resultt > 0) $rowt = mysql_fetch_row($resultt);
$total_photo = $rowt[0];
$tmpsize = round((($total_photo / $themax) * ($maxsize-$minsize))+$minsize);
if ($total_photo) ECHO "".$row['nom']." ";
}
}
?>
|
|