Habe hier was für LastForum gefunden. Dieses Funktioniert auch leider ist aber alles zu eng zusammen. Kann mir da jemand Helfen?
Zitat geschrieben von Hershor
<style type="text/css">
.lastforum {
font-size: 12px;
width: 300px;
margin: 0;
padding: 0;
}
.lastforumtitel {
color: #27DE09;
font-family: "Arial Black";
}
.lastforuminfo {
color: #FFFFFF;
font-family: "Arial";
}
.lastforumname {
color: #FE0202;
font-family: "Arial";
}
</style>
<?php
# Copyright by Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
### Einstellungen
$maxtitel = 35; # maximale Titellänge in Zeichen
$anzahl = 20; # Ausgaben Menge
###
$query = "SELECT a.id, a.name, a.rep, c.erst as last, c.id as pid, c.time, b.name AS fname
FROM prefix_topics a
LEFT JOIN prefix_forums b ON b.id = a.fid
LEFT JOIN prefix_posts c ON c.id = a.last_post_id
LEFT JOIN prefix_groupusers vg ON vg.uid = ".$_SESSION['authid']." AND vg.gid = b.view
LEFT JOIN prefix_groupusers rg ON rg.uid = ".$_SESSION['authid']." AND rg.gid = b.reply
LEFT JOIN prefix_groupusers sg ON sg.uid = ".$_SESSION['authid']." AND sg.gid = b.start
WHERE ((".$_SESSION['authright']." <= b.view AND b.view < 1)
OR (".$_SESSION['authright']." <= b.reply AND b.reply < 1)
OR (".$_SESSION['authright']." <= b.start AND b.start < 1)
OR vg.fid IS NOT NULL
OR rg.fid IS NOT NULL
OR sg.fid IS NOT NULL
OR -9 >= ".$_SESSION['authright'].")
ORDER BY c.time DESC
LIMIT 0,".$anzahl;
echo '<div style="width:330px; height: 100px; overflow-x:hidden; overflow-y: scroll; "><table width="330">';
echo '<table class="lastforum">';
$resultID = db_query($query);
$x=1;
while ($row = db_fetch_assoc($resultID)) {
$row['date'] = date('d.m.Y',$row['time']);
$row['page'] = ceil ( ($row['rep']+1) / $allgAr['Fpanz'] );
if ($x<$anzahl) {$x++; $zelle='border-bottom: 1px solid #505050;text-align: center';} ELSE {$zelle='text-align: center';}
echo '<tr><td style="'.$zelle.'"><a href="?forum-showposts-'.$row['id'].'-p'.$row['page'].'#'.$row['pid'].'" title="'.$row['name'].'"><span class="lastforumtitel">'.$row['fname'].' <span class="lastforuminfo"> >>> </span> '.((strlen($row['name'])<$maxtitel) ? $row['name'] : substr($row['name'],0,($maxtitel-3)).'...').'</span></a><br /><span class="lastforuminfo">Last Post von:</span> <span class="lastforumname">'.$row['last'].'</span> <span class="lastforuminfo">'.$row['date'].'</span></td></tr>';
}
echo '</table>';
?>
Zuletzt modifiziert von Hershor am 13.10.2010 - 15:32:36
betroffene Homepage: web1.v1825.ncsrv.de/AI1
