<?php

/*

	fusionBoard 4.0

	<span style="border-bottom: 1px dotted black;">php</span>-Invent Team

	http://www.php-invent.com

 

	Developer: Ian Unruh (SoBeNoFear)

	ianunruh@gmail.com

*/ 

if (!defined("IN_FUSION")) { die("Access Denied"); }

 

global $lastvisited;

 

if(!function_exists("timePassed")){

	include INFUSIONS."fusionboard4/includes/func.php";

}

 

if (file_exists(INFUSIONS."fusionboard4/locale/".$settings['locale'].".php")) {

	include INFUSIONS."fusionboard4/locale/".$settings['locale'].".php";

} else {

	include INFUSIONS."fusionboard4/locale/English.php";

}

 

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')."

	ORDER BY tt.thread_lastpost DESC LIMIT ".($settings['numofthreads']-1).", ".$settings['numofthreads']));

 

$timeframe = empty($data['thread_lastpost']) ? 0 : $data['thread_lastpost'];

 

$result = dbquery(

	"SELECT tu2.user_id as original_id, tu2.user_name as original_name, 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

	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

	INNER JOIN ".DB_USERS." tu2 ON tt.thread_author=tu2.user_id

	WHERE ".groupaccess('tf.forum_access')." AND tt.thread_lastpost >= ".$timeframe."

	ORDER BY tt.thread_lastpost DESC LIMIT 0,".$fb4['latestno']

);

 

if (dbrows($result)) {

	$i = 0;

	opentable($locale['global_040']);

	if($fb4['latestscroll']){

		echo "<div style='center'>

		<script src='".INFUSIONS."fusionboard4/includes/js/marquee.js' type='text/javascript'></script>

		<style type='text/css'>

		#marqueecontainer{

			position: relative;

			width: 100%; /*marquee width */

			height: 150px; /*marquee height */

			overflow: hidden;

		}

		</style>

		<div id='marqueecontainer' onMouseover='copyspeed=pausespeed' onMouseout='copyspeed=marqueespeed'>

		<div id='vmarquee' style='position: absolute; width: 98%;'>\n";

	}

	echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";

	echo "<td class='tbl2' width='1%'>&nbsp;</td>\n";

	echo "<td width='40%' class='tbl2'><strong>".$locale['global_044']."</strong></td>\n";

	echo "<td width='20%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['global_047']."</strong></td>\n";

	echo "<td width='1%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['global_045']."</strong></td>\n";

	echo "<td width='1%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['global_046']."</strong></td>\n";

	echo "</tr>\n";

	while ($data = dbarray($result)) {

		$row_color = ($i % 2 == 0 ? "tbl1" : "tbl2");

		echo "<tr>\n<td class='".$row_color."' style='white-space:nowrap'>";

		if ($fb4['forum_icons']){

			$iconQuery = dbquery("select * from ".$db_prefix."fb_forums where forum_id='".$data['forum_id']."'");

			if(dbrows($iconQuery)){

				$iconData = dbarray($iconQuery);

				$ficon = ($iconData['forum_icon'] !== "" ? $iconData['forum_icon'] : "folder.png");

			} else {

				$ficon = "folder.png";

			}

			echo "<img src='".INFUSIONS."fusionboard4/images/forum_icons/$ficon' alt='".$data['forum_name']."' title='".$data['forum_name']."' />";

		}

		if ($data['thread_lastpost'] > $lastvisited) {

			$thread_match = $data['thread_id']."\|".$data['thread_lastpost']."\|".$data['forum_id'];

			if (iMEMBER && preg_match("(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)", $userdata['user_threads'])) {

				if(!$fb4['forum_icons']) echo "<img src='".get_image("folder")."' alt='' />";

				$threadbold = "";

			} else {

				if(!$fb4['forum_icons']) echo "<img src='".get_image("foldernew")."' alt='' />";

				$threadbold = " font-weight:bold;";

			}

		} else {

			if(!$fb4['forum_icons']) echo "<img src='".get_image("folder")."' alt='' />";

			$threadbold = "";

		}

		if ($data['thread_poll']) {

			$thread_poll = "<span class='small' style='font-weight:bold'>[".$locale['global_051']."]</span> ";

		} else {

			$thread_poll = "";

		}

		$original_data = dbarray(dbquery("select * from ".DB_POSTS." where thread_id='".$data['thread_id']."' order by post_id asc limit 1"));

		$timepassed = timePassed($original_data['post_datestamp']);

		echo "</td>

		<td width='40%' class='".$row_color."'>";

		$threadPost = dbarray(dbquery("select * from ".DB_THREADS." t

		left join ".DB_POSTS." p on p.thread_id=t.thread_id

		where t.thread_id='".$data['thread_id']."' order by p.post_id asc limit 1"));

		$post_res = dbquery("select * from ".DB_PREFIX."fb_posts where post_id='".$threadPost['post_id']."'");

		if(dbrows($post_res)){

			$post_data = dbarray($post_res);

			if($post_data['post_icon'] && $post_data['post_icon'] !== "page_white.png" && $fb4['post_icons']){

				echo "<div style='float:left;'><br /><img src='".INFUSIONS."fusionboard4/images/post_icons/".$post_data['post_icon']."' alt='' style='vertical-align:middle;' />&nbsp;<br /></div>";

			}

		}

		echo "<a";

		if($fb4['latest_popup']){

         	$originalpost = dbarray(dbquery("select * from ".DB_POSTS." where thread_id='".$data['thread_id']."' order by post_id asc limit 1"));

         	$post_message = $originalpost['post_smileys'] == 1 ? parsesmileys($originalpost['post_message']) : $originalpost['post_message'];

         	$post_message = phpentities(nl2br(parseubb($post_message)));

         	echo " title=\"header=[ ".str_replace("]", "]]", str_replace("[", "[[", trimlink($data['thread_subject'], 70)))."] body=[".str_replace("]", "]]", str_replace("[", "[[", trimlink($post_message, 150)))."] delay=[0] fade=[on]\"";

      	}

      	echo " href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."' title='".$data['thread_subject']."'

		style='text-decoration:underline; font-size:12px;$threadbold'>".trimlink($data['thread_subject'], 40)."</a> ";

		if($fb4['latest_post']){

			echo "&nbsp;<a";

			if($fb4['latest_popup']){

				$originalpost = dbarray(dbquery("select * from ".DB_POSTS." where post_id='".$data['thread_lastpostid']."' order by post_id asc limit 1"));

				$post = trimlink(nl2br(stripinput(parseubb($originalpost['post_message']))), 200);

				echo " title='header=[".$locale['fb615'].":] body=[".$post."] delay=[0] fade=[on]'";

			}

			echo " href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."&amp;pid=".$data['thread_lastpostid']."#post_".$data['thread_lastpostid']."'".(!$fb4['latest_popup']?" title='".$locale['fb615']."'":"")." class='small'>(<b>&raquo;</b>)</a>";

		}

		echo "<br />\n<a href='".BASEDIR."profile.php?lookup=".$data['original_id']."' style='font-size:11px;'>".showLabel($data['original_id'], false, "panel")."</a><br />

		<span style='font-size:10px;'>".$timepassed."</span>

		</td>\n";

		echo "<td width='20%' class='".$row_color."' style='text-align:right;white-space:nowrap'>

		".timePassed($data['thread_lastpost'], false)."<br />

		by <a href='".BASEDIR."profile.php?lookup=".$data['thread_lastuser']."'>".showLabel($data['thread_lastuser'], false, "panel")."</a>";

		if(!$fb4['latest_post']){

			echo "&nbsp;<a";

			if($fb4['latest_popup']){

				$originalpost = dbarray(dbquery("select * from ".DB_POSTS." where post_id='".$data['thread_lastpostid']."' order by post_id asc limit 1"));

				$post = trimlink(nl2br(stripinput(parseubb($originalpost['post_message']))), 200);

				echo " title='header=[".(($data['thread_postcount']-1) > 0 ? "RE: " : "").$data['thread_subject']."] body=[".$post."] delay=[0] fade=[on]'";

			}

			echo " href='".FORUM."viewthread.php?thread_id=".$data['thread_id']."&amp;pid=".$data['thread_lastpostid']."#post_".$data['thread_lastpostid']."' title='".$locale['fb615']."'><b>&raquo;&raquo;</b></a>";

		}

		echo "</td>\n";

		echo "<td width='1%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".$data['thread_views']."</td>\n";

		echo "<td width='1%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".($data['thread_postcount']-1)."</td>\n";

		echo "</tr>\n";

		$i++;

	}

	echo "</table>\n";

	if($fb4['latest_popup']){

		echo "<script src='".INFUSIONS."fusionboard4/includes/js/boxover.js' type='text/javascript'></script>\n";

	}

	if($fb4['latestscroll']){

		echo "</div>

		</div></div>";

	}

	if (iMEMBER) {

		echo "<div class='tbl2' style='text-align:center;'>

		<a href='".INFUSIONS."fb_threads_list_panel/my_threads.php'>".$locale['global_041']."</a> ::\n";

		echo "<a href='".INFUSIONS."fb_threads_list_panel/my_posts.php'>".$locale['global_042']."</a> ::\n";

		echo "<a href='".INFUSIONS."fb_threads_list_panel/new_posts.php'>".$locale['global_043']."</a>";

		if($settings['thread_notify']) {

			echo " ::\n<a href='".INFUSIONS."fb_threads_list_panel/my_tracked_threads.php'>".$locale['global_056']."</a>";

		}

		echo "</div>\n";

	}

	closetable();

}

?>