<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2010 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: forum_threads_list_panel.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }
 
global $lastvisited;
 
if (!isset($lastvisited) || !isnum($lastvisited)) { $lastvisited = time(); }
 
$data = dbarray(dbquery(
	"SELECT tt.thread_lastpost
	FROM ".DB_FORUMS." tf
	INNER JOIN ".DB_THREADS." tt ON tf.forum_id = tt.forum_id
	WHERE ".groupaccess('tf.forum_access')." AND thread_hidden='0'
	ORDER BY tt.thread_lastpost DESC LIMIT ".($settings&#91;'numofthreads'&#93;-1).", ".$settings&#91;'numofthreads'&#93;
));
 
$timeframe = empty($data&#91;'thread_lastpost'&#93;) ? 0 : $data&#91;'thread_lastpost'&#93;;
 
$result = dbquery(
	"SELECT tt.thread_id, tt.thread_subject, tt.thread_views, tt.thread_lastuser, tt.thread_lastpost,
	tt.thread_poll, tf.forum_id, tf.forum_name, tf.forum_access, tt.thread_lastpostid, tt.thread_postcount, tu.user_id, tu.user_name,
	tu.user_status
	FROM ".DB_THREADS." tt
	INNER JOIN ".DB_FORUMS." tf ON tt.forum_id=tf.forum_id
	INNER JOIN ".DB_USERS." tu ON tt.thread_lastuser=tu.user_id
	WHERE ".groupaccess('tf.forum_access')." AND tt.thread_lastpost >= ".$timeframe." AND tt.thread_hidden='0'
	ORDER BY tt.thread_lastpost DESC LIMIT 0,".$settings&#91;'numofthreads'&#93;
);
 
if (dbrows($result)) {
	$i = 0;
	opentable($locale&#91;'global_616'&#93;);
 
 
	while ($data = dbarray($result)) {
		echo "<div class='belka_3'>";
			echo "<div style='float: left;'><a href='".FORUM."viewthread.php?thread_id=".$data&#91;'thread_id'&#93;."&amp;pid=".$data&#91;'thread_lastpostid'&#93;."#post_".$data&#91;'thread_lastpostid'&#93;."' title='".$data&#91;'thread_subject'&#93;."'>".trimlink($data&#91;'thread_subject'&#93;, 30)."</a></div>";
			echo "<div style='float: right;'>".$locale&#91;'global_614'&#93;." ";
			echo profile_link($data&#91;'thread_lastuser'&#93;, $data&#91;'user_name'&#93;, $data&#91;'user_status'&#93;)." ".$locale&#91;'global_615'&#93;." ";
			echo data($data&#91;'thread_lastpost'&#93;);
			echo "</div>";
		echo "</div>";
	}
 
 
	closetable();
}
?>
 
Zinterpretowano w sekund: 0.026, wykorzystano GeSHi 1.0.8.10