';
// Lettura nome galleria:
$tar = 'SELECT * '
.' FROM '.PGALCL__TAB_R
.' WHERE id = '.$id
.' AND online = TRUE '
;
$qar = @query ($tar);
$nar = @pg_num_rows ($qar);
if ($nar == 0) {
Header ('Location:'.$_SERVER['PHP_SELF'].'?'.SID);
exit;
} else
$categoria = @pg_fetch_array ($qar, 0);
// Contiamo il num di record complessivo
$tcb = 'SELECT count(*) '
.' FROM '.PGALCL__TAB_F
.' WHERE id_cat = '.$id
;
$qcb = @query($tcb);
$ncb = @pg_result($qcb, 0, 0);
// Numero pagine necessarie:
$num_pag = ceil ($ncb/NUM__PGALCL__SITE_PP);
$ta2 = 'SELECT id, file, tit, peso, '
.' EXTRACT (year FROM ts) AS anno, '
.' EXTRACT (month FROM ts) AS mese, '
.' EXTRACT (day FROM ts) AS giorno, '
.' EXTRACT (hour FROM ts) AS ora, '
.' EXTRACT (min FROM ts) AS min '
.' FROM '.PGALCL__TAB_F
.' WHERE id_cat = '.$id
.' ORDER BY '.$categoria['sort'].' '.$categoria['criterio']
.' LIMIT '.NUM__PGALCL__SITE_PP.' OFFSET '.($st*NUM__PGALCL__SITE_PP)
;
$qa2 = @query ($ta2);
$na2 = @pg_num_rows ($qa2);
if ($na2 == 0 && $st != 0) {
// Se in questa pagina ($st) non troviamo nessun record, invia il browser all'ultima
// pagina di questo sottogruppo:
Header ('Location: '.$_SERVER['PHP_SELF'].'?st='.($num_pag-1).'&id='.$id.'&'.SID);
exit;
}
} else {
// Nome file img
$img_galleria = '
1) { ?>
Pages:
« | ';
}
for ($j = $start; $j < $end ; $j++) {
if ($st == $j)
echo ''.($st+1).'';
else
echo ''.($j+1).'';
if ($j < ($end-1))
echo ' | '."\r";
else
echo "\r";
}
if ($next_link == true) {
echo ' | »';
}
} else
echo ' ';
?>
|
||
 |
 |
'."\r";
}
?>
1) { ?>
Pages:
« | ';
}
for ($j = $start; $j < $end ; $j++) {
if ($st == $j)
echo ''.($st+1).'';
else
echo ''.($j+1).'';
if ($j < ($end-1))
echo ' | '."\r";
else
echo "\r";
}
if ($next_link == true) {
echo ' | »';
}
} else
echo ' ';
?>
|
||