Okay, dann lass uns mal den LIMIT-TAG ebenfalls in PHP definieren. Neuer Code:
<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined ('main') or die ( 'no direct access' );
# mini config
$img_per_site = $allgAr['gallery_imgs_per_site'];
$img_per_line = $allgAr['gallery_imgs_per_line'];
function get_cats_title ( $catsar ) {
$l = '';
foreach($catsar as $k => $v) {
if ( $k != '' AND $v != '' ) {
$l = $v.' :: '.$l;
}
}
return ($l);
}
function get_cats_urls ( $catsar ) {
$l = '';
foreach($catsar as $k => $v) {
if ( $k != '' AND $v != '' ) {
$l = '<a class="smalfont" href="?gallery-'.$k.'">'.$v.'</a><b> » </b>'.$l;
}
}
return ($l);
}
# Gallery Kategorie anzeigen
function count_files ($cid) {
$zges = 0;
$e = db_query("SELECT id FROM prefix_gallery_cats WHERE cat = ".$cid);
if ( db_num_rows($e) > 0 ) {
while ($r = db_fetch_assoc($e) ) {
$zges = $zges + count_files ( $r['id'] );
}
}
$zges = $zges + db_count_query("SELECT COUNT(*) FROM prefix_gallery_imgs WHERE cat = ".$cid);
return ( $zges );
}
function get_cats_array ( $cid , $ar ) {
if ( empty($cid) ) {
return ($ar);
} else {
$erg = db_query("SELECT cat,id,name FROM prefix_gallery_cats WHERE id = ".$cid);
$row = db_fetch_assoc($erg);
$ar[$row['id']] = $row['name'];
return ( get_cats_array($row['cat'],$ar) );
}
if ( $r ) {
return ($l);
}
}
# original groesse anzeigen
if ($menu->get(1) == 'showOrig') {
$tpl = new tpl ('gallery_show');
$tpl->set('id', escape($menu->get(2), 'integer'));
$tpl->set('endung', htmlspecialchars($menu->get(3), ILCH_ENTITIES_FLAGS, ILCH_CHARSET));
$tpl->out(4);
# normale groesse anzeigen
} elseif ($menu->get(1) == 'show') {
$page = ($menu->getA(3) == 'p' ? escape($menu->getE(3), 'integer') : 1 );
$cid = escape($menu->get(2), 'integer');
$anz = db_result(db_query("SELECT COUNT(*) FROM prefix_gallery_imgs WHERE prefix_gallery_imgs.cat = ".$cid),0);
$erg = db_query("SELECT prefix_gallery_imgs.id,prefix_gallery_imgs.cat,datei_name,endung,prefix_gallery_imgs.`besch`,klicks,vote_wertung,vote_klicks FROM prefix_gallery_imgs LEFT JOIN prefix_gallery_cats ON prefix_gallery_imgs.cat = prefix_gallery_cats.id WHERE prefix_gallery_imgs.cat = ".$cid." AND (recht >= ".$_SESSION['authright']." OR recht IS NULL) ORDER BY id ASC LIMIT ".$page.",1");
$row = db_fetch_assoc($erg);
$size = getimagesize('include/images/gallery/img_'.$row['id'].'.'.$row['endung']);
$breite = $size[0] + 5;
$hoehe = $size[1] + 5;
# vote zahlen
if (isset($_GET['doVote']) AND is_numeric($_GET['doVote']) AND !isset ($_SESSION['galleryDoVote'][$row['id']])) {
$_SESSION['galleryDoVote'][$row['id']] = 'o';
$row['vote_wertung'] = round ( ( ( $row['vote_wertung'] * $row['vote_klicks'] ) + $_GET['doVote'] ) / ( $row['vote_klicks'] + 1 ) , 3 );
$row['vote_klicks']++;
db_query("UPDATE prefix_gallery_imgs SET vote_wertung = ".$row['vote_wertung'].", vote_klicks = ".$row['vote_klicks']." WHERE id = ".$row['id']);
}
# klicks zaehlen
if (!isset($_SESSION['galleryDoKlick'][$row['id']])) {
$_SESSION['galleryDoKlick'][$row['id']] = 'o';
db_query("UPDATE prefix_gallery_imgs SET klicks = klicks + 1 WHERE id = ".$row['id']);
}
# page vor und ruck dev
$next = $page + 1;
$last = $page - 1;
if ( $next >= $anz ) { $next = 0; }
if ( $last < 0 ) { $last = $anz -1; }
# diashow einstellungen
$diashow_html = '';
$diashow = $next.'=0&diashow=start';
if (isset($_GET['diashow']) AND ($_GET['diashow'] == 'start' OR $_GET['diashow'] == 'shownext')) {
$sek = 4;
if (isset($_GET['sek'])) { $sek = $_GET['sek']; }
$diashow_html = '<meta http-equiv="refresh" content="'.$sek.'; URL=index.php?gallery-show-'.$cid.'-p'.$next.'=0&diashow=shownext&sek='.$sek.'">';
$diashow = $page.'=0&diashow=stop';
}
# anzeigen
$tpl = new tpl ('gallery_show');
$arr = array (
'cid' => $cid,
'last' => $last,
'next' => $next,
'diashow' => $diashow,
'diashow_html' => $diashow_html,
'endung' => $row['endung'],
'id' => $row['id'],
'vote_wertung' => $row['vote_wertung'],
'vote_klicks' => $row['vote_klicks'],
'bildr' => $page,
'besch' => unescape($row['besch']),
'breite' => $breite,
'hoehe' => $hoehe
);
$tpl->set_ar_out($arr,0);
# kommentare
if ($allgAr['gallery_img_koms'] == 1) {
# eintragen
$insertmsg = '';
if ((loggedin() or isset($_POST['name'])) and !empty($_POST['text']) and $antispam = chk_antispam('gallery')) {
if (loggedin()) {
$name = $_SESSION['authname'];
} else {
$name = escape($_POST['name'],'string');
if (db_count_query('SELECT COUNT(*) FROM prefix_user WHERE name = "'.$name.'"')) {
$insertmsg .= 'Der Name ist bereits für einen registrierten User vergeben';
}
}
if (empty($insertmsg)) {
$text = escape($_POST['text'],'string');
db_query("INSERT INTO prefix_koms (name,text,uid,cat) VALUES ('".$name."','".$text."',".$row['id'].",'GALLERYIMG')");
}
} elseif (isset($_POST['subgalkom']) and !$antispam) {
$insertmsg .= 'Falscher Antispam';
}
# loeschen
if (isset($_GET['delete']) AND is_siteadmin()) {
db_query("DELETE FROM prefix_koms WHERE id = ".escape($_GET['delete'], 'integer'));
}
# zeigen
if (!empty($insertmsg)) {
$insertmsg = '<span style="color:red;">'.$insertmsg.'</span><br />';
}
$tpl->set('insertmsg', $insertmsg );
$tpl->set('uname', $_SESSION['authname']);
$tpl->set('antispam', get_antispam('gallery', 0));
$tpl->out(1);
$class = 'Cnorm';
$erg = db_query("SELECT id, name, text FROM prefix_koms WHERE uid = ".$row['id']." AND cat = 'GALLERYIMG' ORDER BY id DESC");
while ($r = db_fetch_assoc($erg)) {
$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite');
$r['class'] = $class;
$r['text'] = bbcode ($r['text']);
if (is_admin()) {
$r['text'] .= '<a href="index.php?gallery-show-'.$cid.'-p'.$page.'=0&delete='.$r['id'].'"><img src="include/images/icons/del.png" border="0" title="löschen" alt="löschen" /></a>';
}
$tpl->set_ar_out($r,2);
}
$tpl->out(3);
}
} else {
$cid = ( $menu->get(1) ? escape($menu->get(1),'integer') : 0 );
$erg = db_query("SELECT cat,name FROM prefix_gallery_cats WHERE recht >= {$_SESSION['authright']} AND id = ".$cid);
$cname = 'Gallery';
}
if ( db_num_rows($erg) > 0 ) {
$row = db_fetch_assoc($erg);
$array = get_cats_array($row['cat'],'');
$cname = $row['name'];
if ( !empty($array) ) {
$titelzw = get_cats_title($array);
$namezw = get_cats_urls($array);
} else {
$titelzw = '';
$namezw = '';
}
$cattitle = ':: '.$titelzw.$row['name'];
$catname = '<b> » </b>'.$namezw.$row['name'];
} else {
$cattitle = '';
$catname = '';
}
$title = $allgAr['title'].' :: Gallery '.$cattitle;
$hmenu = '<a class="smalfont" href="?gallery">Gallery</a>'.$catname;
$design = new design ( $title , $hmenu );
$design->header();
$tpl = new tpl ('gallery' );
#START# New ProJekt-AB Gallery Seitenanzahl TEST
# $limit = 1;
# $page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
# $mplk = db_make_sites ($page , 'WHERE recht >= '.$_SESSION['authright'].' and cat ='.$cid, $limit, '?gallery' , 'gallery_cats');
# $anfang = ($page - 1) * $limit;
# $tpl->set('MPLK', $mplk);
# $erg = db_query("SELECT id,name,`besch` FROM prefix_gallery_cats WHERE recht >= {$_SESSION['authright']} AND cat = ".$cid." ORDER BY pos LIMIT " . $anfang . "," . $limit);
#ENDE# New ProJekt-AB Gallery Seitenanzahl TEST
$erg = db_query("SELECT id,name,`besch` FROM prefix_gallery_cats WHERE recht >= {$_SESSION['authright']} AND cat = ".$cid." ORDER BY pos");
if ( db_num_rows($erg) > 0 ) {
$tpl->out(1); $class = 'Cnorm';
while ($row = db_fetch_assoc($erg) ) {
$row['gallery'] = count_files($row['id']);
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$row['class'] = $class;
$tpl->set_ar_out($row,2);
}
$tpl->out(3);
}
#START# New Alle Bider Seiten TEST
if(isset($_POST['alleansehen'])){
$limit = '';
}else{
$limit = $img_per_site;
}
#ENDE# New Alle Bider Seiten TEST
$page = ($menu->getA(2) == 'p' ? escape($menu->getE(2), 'integer') : 1 );
$MPL = db_make_sites ($page , '' , $limit , '?gallery-'.$cid , "gallery_imgs LEFT JOIN prefix_gallery_cats ON prefix_gallery_imgs.cat = prefix_gallery_cats.id WHERE prefix_gallery_imgs.cat = ".$cid." AND (recht >= ".$_SESSION['authright']." OR recht IS NULL)");
if($limit = ''){
$anfang = '';
}else{
$anfang = ($page - 1) * $limit;
}
if($limit = '' && $anfang = ''){
$limitneu = '';
}else{
$limitneu = 'LIMIT' . $anfang . ', ' . $limit . '';
}
$erg = db_query("SELECT prefix_gallery_imgs.id,prefix_gallery_imgs.cat,datei_name,endung,prefix_gallery_imgs.`besch`,klicks,vote_wertung,vote_klicks FROM prefix_gallery_imgs LEFT JOIN prefix_gallery_cats ON prefix_gallery_imgs.cat = prefix_gallery_cats.id WHERE prefix_gallery_imgs.cat = ".$cid." AND (recht >= ".$_SESSION['authright']." OR recht IS NULL) ORDER BY id ASC ".$limitneu);
if ( db_num_rows($erg) > 0 ) {
$tpl->set('imgperline', $allgAr['gallery_imgs_per_line']);
$tpl->set('cname', $cname);
$tpl->set('breite', $allgAr['gallery_normal_width']+30);
$tpl->set('MPL',$MPL);
$tpl->out(4); $class = 'Cnorm';
$i = 0;
while($row = db_fetch_assoc($erg) ) {
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$row['class'] = $class;
$row['anz_koms'] = db_result(db_query("SELECT COUNT(*) FROM prefix_koms WHERE uid = ".$row['id']." AND cat = 'GALLERYIMG'"),0);
$row['besch'] = unescape($row['besch']);
$row['width'] = round( 100 / $img_per_line );
$row['bildr'] = $i + (($page-1) * $img_per_site);
if ( $i <> 0 AND ($i % $img_per_line ) == 0 ) { echo '</tr><tr>'; }
$tpl->set_ar_out($row,5);
$i++;
}
if ( $i % $img_per_line <> 0 ) {
$anzahl = $img_per_line - ($i % $img_per_line);
for($x=1;$x<=$anzahl;$x++){
echo '<td class="'.$class.'"></td>';
}
}
$tpl->out(6);
}
?>
Zitat geschrieben von CeeJay
