1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
|
<?php
$newsboardid = "48";
$showlimit = "5";
$ergnews=$db->query("SELECT *
FROM bb".$n."_threads, bb".$n."_posts, bb".$n."_boards
WHERE (bb".$n."_boards.boardid = bb".$n."_threads.boardid)
AND (bb".$n."_posts.threadid = bb".$n."_threads.threadid)
AND (bb".$n."_threads.starttime = bb".$n."_posts.posttime)
AND (bb".$n."_threads.boardid = $newsboardid)
GROUP BY bb".$n."_threads.threadid
ORDER BY bb".$n."_threads.threadid DESC LIMIT $showlimit");
$color="b";
while ($rownews=mysql_fetch_array($ergnews))
{
$parse = new parse($docensor,75,$rownews['allowsmilies'],$rownews['allowbbcode'],$wbbuserdata['showimages'],$_GET['hilight'],$usecode);
$rownews['message']=$parse->doparse($rownews['message'],$rownews['allowsmilies']*$rownews['allowsmilies'],$rownews['allowhtml'],$rownews['allowbbcode'],$rownews['allowimages']);
$time=date("H:i:s", $rownews["posttime"]);
$date=date("d.m.Y", $rownews["posttime"]);
if($color="a") $color="b";
elseif($color="b") $color="a";
$views=$rownews['views'] + 1;
$db->query("UPDATE bb".$n."_threads Set views='$views'");
eval ("\$tpl->output("".$tpl->get("news_show")."");");
} |