danke schön...nur funktioniert er mit 4nAlbum...was muss ich ändern damit er für myegallery funktioniert?
if (eregi("block-munzur.php",$PHP_SELF)) {
Header("Location: index.php");
die();
}
$album_name = "My_eGallery";
$Display_numpic = 8;
$postotal = 6;
$content .= "<center><b>Die neuesten Bilder in der Gallery</b></center><br>";
global $font,$user, $galleryvar, $baseurl, $prefix, $adminpath, $dbi;
include 'admin/modules/gallery/config.php';
if (is_user($user))
$total = mysql_fetch_array(mysql_query("SELECT COUNT(p.pid) AS total FROM $prefix"._gallery_pictures." AS p LEFT JOIN $prefix"._gallery_categories." AS c ON c.gallid=p.gid WHERE c.visible>=1"));
else
$total = mysql_fetch_array(mysql_query("SELECT COUNT(p.pid) AS total FROM $prefix"._gallery_pictures." AS p LEFT JOIN $prefix"._gallery_categories." AS c ON c.gallid=p.gid WHERE c.visible>=2"));
$result4 = mysql_query("SELECT p.pid, p.img, p.name, p.description, c.galloc FROM $prefix"._gallery_pictures." AS p LEFT JOIN $prefix"._gallery_categories." AS c ON c.gallid=p.gid ORDER BY date DESC LIMIT 0,$Display_numpic ");
$i = 1;
while (list($pic[pid], $pic[img], $pic[name], $pic[description], $pic[galloc]) = mysql_fetch_row($result4)) {
$pic[description] = htmlentities($pic[description]);
if (file_exists("$gallerypath/$pic[galloc]/$pic[img]")) {
$list_pic .= "<a href=\"$baseurl&do=showpic&pid=$pic[pid]\"><img src=\"$gallerypath/$pic[galloc]/$pic[img]\" height=\"50\" border=\"0\" alt=\"$pic[description]\"></a>\n";
$list_pic .= ($i != $Display_numpic ? " " : "");
$i++;
}
else {
$list_pic .= "<a href=\"$baseurl&do=showpic&pid=$pic[pid]\"><img src=\"$gallerypath/$pic[galloc]/$pic[img]\" height=\"50\" border=\"0\" alt=\"$pic[description]\"></a>\n";
$list_pic .= ($i != $Display_numpic ? " " : "");
$i++;
}
}
$content .= "<center>$list_pic</center>\n";
$content .= "<table width=\"100%\" border=\"0\" cellspacing=\"1\" bgcolor=\"#333333\" cellpadding=\"1\" style=\"BORDER-BOTTOM:1px solid;BORDER-TOP:1px solid;BORDER-LEFT:1px solid;BORDER-RIGHT:1px solid;\">"
."<tr bgcolor=\"#BFC7D7\">"
."<td><center>No</center></td><td><center>Meist besuchte</center></td><td><center>Best bewertete</center></td><td><center>Die letzten Kommentare</center></td></tr>";
$result = mysql_query("select pid, name, visible from $prefix"._gallery_pictures." p, $prefix"._gallery_categories." c WHERE p.gid=c.gallid AND c.visible>0 order by counter DESC, rate DESC");
$result1 = mysql_query("select pid, name, visible from $prefix"._gallery_pictures." p, $prefix"._gallery_categories." c WHERE p.gid=c.gallid AND c.visible>0 order by rate DESC, votes ASC, counter DESC");
$result2 = mysql_query("SELECT pid, name FROM $prefix"._gallery_comments." ORDER BY date DESC LIMIT 0,$postotal");
$pos = 1;
while((list($pid, $name, $visible) = mysql_fetch_array($result)) && (list($pid2, $name2, $visible2) = mysql_fetch_array($result1)) && (list($pid3 , $name3) = mysql_fetch_array($result2)) && $pos<=$postotal) {
$result3 = mysql_query("SELECT name, visible FROM $prefix"._gallery_pictures." p, $prefix"._gallery_categories." c WHERE p.pid=$pid3 AND p.gid=c.gallid AND c.visible>0 ");
list($pic3,$visible3) = mysql_fetch_array($result3);
$content .= "<tr bgcolor=\"#eeeeee\">";
$content .= "<td align=\"center\"><center><font class=\"".$font['normal']."\">$pos.</font></center></td>";
if ($visible==1) {
if (is_user($user))
$content .= "<td align=\"left\"><center><a class=\"".$font['normal']."\" href=\"".$baseurl."&do=showpic&pid=$pid\">$name</a></center></td>";
else
$content .= "<td align=\"left\"><center><font class=\"".$font['normal']."\"> $name (*) </font></center></td>";
}
else
$content .= "<td align=\"left\"><center><a class=\"".$font['normal']."\" href=\"".$baseurl."&do=showpic&pid=$pid\">$name</a></center></td>";
if ($visible2==1) {
if (is_user($user))
$content .= "<td align=\"left\"><center><a class=\"".$font['normal']."\" href=\"".$baseurl."&do=showpic&pid=$pid2\">$name2</a></center></td>";
else
$content .= "<td align=\"left\"><center><font class=\"".$font['normal']."\"> $name2 (*) </font></center></td>";
}
else
$content .= "<td align=\"left\"><center><a class=\"".$font['normal']."\" href=\"".$baseurl."&do=showpic&pid=$pid2\">$name2</a></center></td>";
if ($visible3==1) {
if (is_user($user))
$content .= "<td align=\"left\">Bild: <a class=\"".$font['normal']."\" href=\"".$baseurl."&do=showpic&pid=$pid3\">$pic3</a> kommentiert von $name3</td>";
else
$content .= "<td align=\"left\">Bild: <center><font class=\"".$font['normal']."\"> $pic3 (*) kommentiert von $name3 </font></center></td>";
}
else
$content .= "<td align=\"left\">Bild: <a class=\"".$font['normal']."\" href=\"".$baseurl."&do=showpic&pid=$pid3\">$pic3</a> kommentiert von $name3</td>";
$content .= "</tr>";
$pos += 1;
}
$content .= "</table>";
if (!is_user($user)) {
$content .= "<center><i>User have to <a href=\"modules.php?name=Your_Account&op=new_user\">Register</a> in order to view media with (*).</i></center>";
}
$content .= "<br><center><b><u><a href=\"modules.php?mop=modload&name=$album_name\">Hier gehts in die Gallery</a></u></b></center><br>";
das verwende ich selber auf meiner seite seit einiger zeit! hab es für mich angepasst! musst ändern wenn du es anders amchen willst! schwer ist es nciht! musst nur lesen!
l.g
ok,das klappt alles super,nur jetzt möchte ich anstatt der bild nr. von den letzten kommentaren,direkt die kommentare aufgelistet haben,zumindest der anfang von ihnen...was muss ich da ändern für?