<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>'
;
?>