<style type=
"text/css"
>
.lastautor {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #fff;
font-size:9px;
}
.lastautor:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #aafaa6;
font-size:9px;
}
.vor {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #fff;
font-size:9px;
}
</style>
<?php
# Copyright by C.C.A.A
# Support www.DragonDesigns.de
defined (
'main'
)
or
die
(
'no direct access'
);
$query
= "SELECT a.id, a.name, a.rep, a.erst
as
autor, b.id
as
fid, c.erst
as
last, c.id
as
pid, b.name AS forumname, d.name AS katname, c.time , c.erstid
as
erstid
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_forumcats d ON d.id = b.cid AND b.id = a.fid
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,5";
echo
'<table width="100%" style="padding-top:0px; padding-bottom:2px;" cellspacing="0" cellpadding="0">'
;
$resultID
= db_query(
$query
);
while
(
$row
= db_fetch_assoc(
$resultID
)) {
$row
[
'page'
] =
ceil
( (
$row
[
'rep'
]+1) /
$allgAr
[
'Fpanz'
] );
$row
[
'ORD'
] = forum_get_ordner(
$row
[
'time'
],
$row
[
'id'
],
$row
[
'fid'
]);
echo
'<tr>'
;
echo
'<td><table width="164%" border="0" cellspacing="1" cellpadding="1">'
;
echo
'<tr>'
;
echo
'<td rowspan="2" align="center" valign="middle"><img style="padding-right:5px;" src="include/images/forum/'
.
$row
[
'ORD'
].
'.png" width="22" height="22" /></td>'
;
echo
'<td width="100%" colspan="2" align="left"><b><a style="color:#f76b6b;" href="?forum-showposts-'
.
$row
[
'id'
].
'-p'
.
$row
[
'page'
].
'#'
.
$row
[
'pid'
].
'" title="'
.
$row
[
'date'
].
'">'
.((
strlen
(
$row
[
'name'
])<33) ?
$row
[
'name'
] :
substr
(
$row
[
'name'
],0,41).
''
).
'</a></b></td>'
;
echo
'</tr>'
;
echo
'<tr>'
;
echo
'<td width="60%" align="left" class="vor">Kategorie: '
.
$row
[
'katname'
].
' - '
.
$row
[
'forumname'
].
' Autor: <a class="lastautor">'
.
$row
[
'autor'
].
'</a></td>'
;
echo
'<td width="40%" align="left" class="vor">letzter: <a class="lastautor" href="index.php?user-details-'
.
$row
[
'erstid'
].
'">'
.
$row
[
'last'
].
'</a></td>'
;
echo
'</tr>'
;
echo
'</table></td>'
;
echo
'</tr>'
;
}
echo
'</table>'
;
?>