/**
* Title: ganzi.IT
* Description: Icone- Gallery
* Copyright: Copyright (c) 2005
* Company:
* @author Gabriele Ganzi
* @version 1.0
*/
require_once("std/config.inc.php");
require_once("std/dummy.inc.php");
require_once("std/std.inc.php");
require_once("std/icons.inc.php");
require_once("std/class.pager.inc.php");
$cid = $_REQUEST['c']; //Categoria (Emoticons,Immagini...)
$sc = $_REQUEST['sc']; //Sub-Categoria
$order = $_REQUEST['o']; //Ordinamento
$SQL = "SELECT * from msn.categories WHERE cid=".$cid;
$result = mysql_query($SQL);
$row=mysql_fetch_array($result);
$cat_name = $row['description'];
$SQL = "SELECT * from msn.albums WHERE category=".$cid;
$result = mysql_query($SQL);
if (mysql_num_rows($result) < 1) {
@mysql_close();
Header("Location: icons.php");
exit;
}
?>
www.Ganzi.it - Risorse - Icone Gratis -
if ($sc==""){?>
Tutte
} else { ?>
">Tutte
} ?>
while ( $row = mysql_fetch_array($result)){
?>
if ($sc==$row['aid']) {?>
} else { ?>
">
} ?>
}
?>
$pagelist = displayImages();?>
function displayImages(){
GLOBAL $cid;
GLOBAL $sc;
GLOBAL $order;
$SQL = "SELECT * FROM msn.pictures, msn.albums";
$SQL .= " WHERE pictures.approved='YES' AND pictures.aid=albums.aid AND albums.category=".$cid;
if ($sc!="")
$SQL .= " AND albums.aid=".$sc;
if ($order == 1) $SQL .= " ORDER BY mtime DESC";
if ($order == 2) $SQL .= " ORDER BY pictures.votes DESC";
if ($order == 3) $SQL .= " ORDER BY hits DESC";
$p = new SQLPager($SQL,6);
$p->addParameters("&c=".$_REQUEST['c']."&sc=".$_REQUEST['sc']."&o=".$_REQUEST['o']);
$pagelist = $p->execute();
$images = $p->getRecords();
if (mysql_num_rows($images) == 0){
echo "Non ci sono immagini
";
return;
}
$rowCount = 1;
$cellCount = 0;
while ($row = mysql_fetch_array ($images)) {
__drawImagePreview($row);
$cellCount ++;
if ($cellCount==3){
echo "
\n";
$rowCount += 1;
$cellCount = 0;
}
}
//fill nel caso la pagina non sia piena
for ($i=$rowCount;$i<=2;$i++){
for ($x=$cellCount;$x<3;$x++){
echo "\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
\n";
}
echo "
\n";
$cellCount = 0;
}
return $pagelist;
}
function __drawImagePreview($row){
GLOBAL $__OFFICE;
if (isset($__OFFICE)){
$size[0] = 30;
$size[1] = 30;
} else
$size = defineImageSize( IMAGE_ROOT.$row['filepath'].$row['filename'], "THUMB");
if ($row['pictures.title'] == "")
$title = $row['filename'];
else
$title = $row['pictures.title'];
echo "\n";
echo "
\n";
echo "
\n";
echo "
\n";
echo "
".$row['hits']." Donwnload
\n";
echo "
\n";
echo "Inviata da:
".$row['owner_name']." \n";
echo "
\n";
echo "
\n";
}
?>
@mysql_close();?>