<style type=
"text/css"
>
.lastautor {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #0CF;
font-size:9px;
}
.lastautor:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #0FF;
font-size:9px;
}
.vor {
font-family: Verdana, Arial, Helvetica, sans-serif;
color: #999;
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, 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="2" cellpadding="3">'
;
$resultID
= db_query(
$query
);
while
(
$row
= db_fetch_assoc(
$resultID
)) {
$row
[
'page'
] =
ceil
( (
$row
[
'rep'
]+1) /
$allgAr
[
'Fpanz'
] );
$row
[
'NAVYFIELD'
][
'SHOTONLINE'
] = forum_get_ordner(
$row
[
'time'
],
$row
[
'id'
],
$row
[
'fid'
]);
echo
'<tr>'
;
echo
'<td><table width="100%" border="0" cellspacing="1" cellpadding="12">'
;
echo
'<tr>'
;
echo
'<td rowspan="2" align="center" valign="middle"><img style="padding-right:5px;" src="include/images/forum/'
.
$row
[
'NAVYFIELD'
][
'SHOTONLINE'
].
'.png" width="25" height="25" /></td>'
;
echo
'<td width="100%" colspan="2" align="left"><b><a style="color:#888;" href="?forum-showposts-'
.
$row
[
'id'
].
'-p'
.
$row
[
'page'
].
'#'
.
$row
[
'pid'
].
'" title="'
.
$row
[
'date'
].
'">'
.((
strlen
(
$row
[
'name'
])<33) ?
$row
[
'name'
] :
substr
(
$row
[
'name'
],0,31).
'...'
).
'</a></b></td>'
;
echo
'</tr>'
;
echo
'<tr>'
;
echo
'<td width="60%" align="left" class="vor">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>'
;
?>