نقل قول انجمن
نوشته شما بیش از مقدار مجاز است (42474 کاراکتر). آن را تا مقدار مجاز 30000 کاراکتر کاهش دهید.
کد در 2 قسمت ارسال می شود.
قسمت اول
<?php
/*
*
* ajaxfs Plugin
* Copyright 2011 mostafa shirali
* http://www.kingofpersia.ir
* No one is authorized to redistribute or remove copyright without my expressed permission.
*
*/
if(!defined("IN_MYBB"))
{
die("Direct initialization of this file is not allowed.<br /><br />Please make sure IN_MYBB is defined.");
}
$plugins->add_hook('index_start', 'ajaxfs');
// The information that shows up on the plugin manager
function ajaxfs_info()
{
return array(
"name" => "ajaxfs",
"description" => "This plugin displays statistics for all the users and forums",
"website" => "http://www.kingofpersia.ir",
"author" => "Mostafa shirali",
"authorsite" => "http://www.kingofpersia.ir",
"version" => "4.0",
"guid"=> "",
);
}
// This function runs when the plugin is activated.
function ajaxfs_activate()
{
global $mybb, $db, $templates,$cache,$lang;
require_once MYBB_ROOT.'inc/adminfunctions_templates.php';
find_replace_templatesets("headerinclude",'#'.preg _quote('<script type="text/javascript" src="{$mybb->settings[\'bburl\']}/jscripts/prototype.js?ver=1603"></script>').'#', '<link rel="stylesheet" href="{$mybb->settings[\'bburl\']}/jscripts/jquery-ui.css" type="text/css" media="screen" /><link rel="stylesheet" href="{$mybb->settings[\'bburl\']}/jscripts/ajaxfs.css" type="text/css" media="screen" /><script type="text/javascript" src="{$mybb->settings[\'bburl\']}/jscripts/jquery.js"></script><script type="text/javascript" src="{$mybb->settings[\'bburl\']}/jscripts/jquery-ui.js"></script><script type="text/javascript" src="{$mybb->settings[\'bburl\']}/jscripts/ajaxfs.js"></script><script type="text/javascript" src="{$mybb->settings[\'bburl\']}/jscripts/prototype.js?ver=1603"></script>');
find_replace_templatesets("index", '#{\$forums}#', '{\$ajaxfs_top_panel}{\$forums}{\$ajaxfs_down_pane l}',0);
$lang->load("ajaxfs");
$settings_group = array(
"gid" => "",
"name" => "ajaxfs",
"title" => $lang->ajaxfs_settinggroup,
"description" => $lang->ajaxfs_settinggroup_dec,
"disporder" => "88",
"isdefault" => "0",
);
$db->insert_query("settinggroups", $settings_group);
$gid = $db->insert_id();
$positions = "select\ntop={$lang->ajaxfs_top}\ndown={$lang->ajaxfs_down}";
$setting[] = array("sid" => "","name" => "ajaxfs_enable","title" => $lang->ajaxfs_active,"description" => $lang->ajaxfs_active_dec,"optionscode" => "yesno","value" => "0","disporder" => 1,"gid" => intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_lastpost','title'=> $lang->ajaxfs_last_post,'description' => $lang->ajaxfs_last_post_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 2,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_mostview','title'=> $lang->ajaxfs_view_post,'description' => $lang->ajaxfs_view_post_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 3,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_hottopics','title'=> $lang->ajaxfs_most_reply,'description' => $lang->ajaxfs_most_reply_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 4,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_lastuser','title'=> $lang->ajaxfs_last_user,'description' => $lang->ajaxfs_last_user_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 5,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_mostposter','title'=> $lang->ajaxfs_most_sender,'description' => $lang->ajaxfs_most_sender_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 6,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_mostpoint','title'=> $lang->ajaxfs_top_point,'description' => $lang->ajaxfs_top_point_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 7,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_mostthanked','title'=> $lang->ajaxfs_top_thanks,'description' => $lang->ajaxfs_top_thanks_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 8,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_mostthanker','title'=> $lang->ajaxfs_top_thankers,'description' => $lang->ajaxfs_top_thankers_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 9,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_popularfile','title'=> $lang->ajaxfs_most_download,'description' => $lang->ajaxfs_most_download_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 10,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_Topreferrers','title'=> $lang->ajaxfs_most_reffer,'description' => $lang->ajaxfs_most_reffer_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 11,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_hitstat','title'=> $lang->ajaxfs_hitstat,'description' => $lang->ajaxfs_hitstat_dec,'optionscode'=> 'yesno','value'=> '1','disporder'=> 12,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_customforum','title'=> $lang->ajaxfs_customforum,'description' => $lang->ajaxfs_customforum_dec,'optionscode'=> 'yesno','value'=> '0','disporder'=> 13,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_customforum_in','title'=> $lang->ajaxfs_customforum_in,'description' => $lang->ajaxfs_customforum_in_dec,'optionscode'=> 'textarea','value'=> $lang->ajaxfs_customforum_in_value,'disporder'=> 14,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_number_post','title'=> $lang->ajaxfs_number_post,'description' => $lang->ajaxfs_number_post_dec,'optionscode'=> 'text','value'=> 15,'disporder'=> 15,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_number_tops','title'=> $lang->ajaxfs_number_tops,'description' => $lang->ajaxfs_number_tops_dec,'optionscode'=> 'text','value'=> 15,'disporder'=> 16,'gid'=> intval($gid),);
$setting[] = array( 'sid'=> "",'name'=> 'ajaxfs_position','title'=> $lang->ajaxfs_position,'description' => $lang->ajaxfs_position_dec,'optionscode'=> $positions,'value'=> 'down','disporder'=> 17,'gid'=> intval($gid),);
foreach ($setting as $i)
{
$db->insert_query("settings", $i);
}
rebuild_settings();
}
function ajaxfs()
{
require_once MYBB_ROOT.'inc/adminfunctions_templates.php';
global $mybb,$lang,$db,$ajaxfs_top_panel,$ajaxfs_down_pan el,$theme,$parser,$templates;
if (!is_object($parser))
{
require_once MYBB_ROOT.'inc/class_parser.php';
$parser = new postParser;
}
if($mybb->settings['ajaxfs_enable'] ==1)
{
$lang->load("ajaxfs");
if($mybb->settings['ajaxfs_lastpost'] ==1)
{
$post_info_option .='<li><a href="#lastpost">'.$lang->ajaxfs_last_post.'</a></li>';
}
if($mybb->settings['ajaxfs_mostview'] ==1)
{
$post_info_option .='<li><a href="#mosthit">'.$lang->ajaxfs_view_post.'</a></li>';
}
if($mybb->settings['ajaxfs_hottopics'] ==1)
{
$post_info_option .='<li><a href="#hotpost">'.$lang->ajaxfs_most_reply.'</a></li>';
}
/*********************************************** LAST POST *************************************************/
$userid=$mybb->user['uid'];
$query_group=$db->query ("SELECT * FROM ".TABLE_PREFIX."users WHERE uid='$userid'");
if($db->num_rows($query_group)==0)
{
$gid=1;
}
else
{
$fetch_group=$db->fetch_array($query_group);
$gid=$fetch_group['usergroup'];
}
$query = $db->query ("SELECT t1.*
FROM ".TABLE_PREFIX."posts t1
JOIN (
SELECT pid
FROM ".TABLE_PREFIX."posts
WHERE visible='1' ORDER BY pid DESC
)t2 ON t1.pid = t2.pid GROUP BY tid ORDER BY pid DESC");
$lastpost="<table cellspacing='0' id='Ajxfstable'><tr><th>{$lang->ajaxfs_lastpost_title}</th><th>{$lang->ajaxfs_lastpost_writer}</th></tr>";
if($db->num_rows($query)==0)
{
$post_number=0;
}
else
{
if($db->num_rows($query)<=$mybb->settings['ajaxfs_number_post'])
{
$post_number=$db->num_rows($query);
}
else
{
$post_number=$mybb->settings['ajaxfs_number_post'];
}
}
$post_counter=0;
while($post_counter<$post_number)
{
$fetch=$db->fetch_array($query);
$fid=$fetch['fid'];
$query_forum_permissins=$db->query ("SELECT * FROM ".TABLE_PREFIX."forumpermissions WHERE fid='$fid' AND gid='$gid'");
$canread=1;
if($db->num_rows($query_forum_permissins)!=0)
{
$fetch_forum_permissins=$db->fetch_array($query_forum_permissins);
if($fetch_forum_permissins['canviewthreads']==1)
{
$canread=1;
}
else
{
$canread=0;
}
}
if($db->num_rows($query_forum_permissins)==0 AND $canread==1)
{
$profilelink=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$fetch['uid'];
$lastposter=$fetch['username'];
$lastposteruid=$fetch['uid'];
$query_users = $db->query ("SELECT * FROM ".TABLE_PREFIX."users WHERE uid='$lastposteruid'");
$fetch_users =$db->fetch_array($query_users);
$lastposter=format_name($fetch_users['username'],$fetch_users['usergroup'],$fetch_users['displaygroup']);
$profilelink_lastposter=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$lastposteruid;
$tid=$fetch['tid'];
$uid=$mybb->user['uid'];
$query_view = $db->query("SELECT * FROM ".TABLE_PREFIX."threadsread WHERE tid='$tid' AND uid='$uid'");
$threadlink = get_post_link($fetch['pid'])."#pid".$fetch['pid'];
$post_pid=$fetch['pid'];
if($db->num_rows($query_view)==0)
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_unread.gif">';
}
else
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_read.gif">';
}
$thread_id=$fetch['tid'];
$query_thread_sub = $db->query ("SELECT * FROM ".TABLE_PREFIX."threads WHERE tid='$thread_id'");
$fetch_thread_sub=$db->fetch_array($query_thread_sub);
$thread_sub=htmlspecialchars_uni(substr($fetch_thr ead_sub['subject'],0,90));
$linenumber=$post_counter+1;
$lastpost .='<tr><td><span id="pagenumber">'.$linenumber.'</span> '.$read_image.' <a href="'.$threadlink.'" target="_blank" id="'.$post_pid.'" onmouseover="javascript:tooltip(event);" onmousemove="javascript:tooltipmove(event);" onmouseout="javascript:tooltipout();"> '.$thread_sub.'</a></td><td><a href="'.$profilelink_lastposter.'" target="_blank" id="'.$lastposteruid.'" onmouseover="javascript:usertooltip(event);" onmousemove="javascript:usertooltipmove(event);" onmouseout="javascript:usertooltipout();">'.$lastp oster.'</a></td></tr>';
$post_counter++;
}
}
$lastpost .='</table>';
/*********************************************** LAST POST *************************************************/
/************************************************** * Most Viewed ***************************************/
$most_hit="<table cellspacing='0' id='Ajxfstable'><tr><th>{$lang->ajaxfs_lastpost_title}</th><th>{$lang->ajaxfs_view}</th></tr>";
$lang->load("ajaxfs");
$query = $db->query ("SELECT * FROM ".TABLE_PREFIX."threads WHERE visible='1' ORDER BY views DESC LIMIT 0,15");
if($db->num_rows($query)==0)
{
$post_number=0;
}
else
{
if($db->num_rows($query)<=$mybb->settings['ajaxfs_number_post'])
{
$post_number=$db->num_rows($query);
}
else
{
$post_number=$mybb->settings['ajaxfs_number_post'];
}
}
$post_counter=0;
while($post_counter<$post_number)
{
$fetch =$db->fetch_array($query);
$fid=$fetch['fid'];
$query_forum_permissins=$db->query ("SELECT * FROM ".TABLE_PREFIX."forumpermissions WHERE fid='$fid' AND gid='$gid'");
$canread=1;
if($db->num_rows($query_forum_permissins)!=0)
{
$fetch_forum_permissins=$db->fetch_array($query_forum_permissins);
if($fetch_forum_permissins['canviewthreads']==1)
{
$canread=1;
}
else
{
$canread=0;
}
}
if($db->num_rows($query_forum_permissins)==0 AND $canread==1)
{
$threadlink = get_thread_link($fetch['tid']);
$tid=$fetch['tid'];
$uid=$mybb->user['uid'];
$query_view = $db->query("SELECT * FROM ".TABLE_PREFIX."threadsread WHERE tid='$tid' AND uid='$uid'");
if($db->num_rows($query_view)==0)
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_unread.gif">';
}
else
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_read.gif">';
}
$thread_sub=htmlspecialchars_uni(substr($fetch['subject'],0,90));
$linenumber=$post_counter+1;
$most_hit .='<tr '.$even.'><td><span id="pagenumber">'.$linenumber.'</span> '.$read_image.' <a href="'.$threadlink.'" target="_blank">'.$thread_sub.'</a></td><td>'.$fetch['views'].'</td></tr>';
$post_counter++;
}
}
$most_hit .='</table>';
/************************************************ HOT POSTS **********************************************/
$hotpost="<table cellspacing='0' id='Ajxfstable'><tr><th>{$lang->ajaxfs_lastpost_title}</th><th>{$lang->ajaxfs_rep}</th></tr>";
$lang->load("ajaxfs");
$query = $db->query ("SELECT * FROM ".TABLE_PREFIX."threads WHERE visible='1' ORDER BY replies DESC LIMIT 0,15");
if($db->num_rows($query)==0)
{
$post_number=0;
}
else
{
if($db->num_rows($query)<=$mybb->settings['ajaxfs_number_post'])
{
$post_number=$db->num_rows($query);
}
else
{
$post_number=$mybb->settings['ajaxfs_number_post'];
}
}
$post_counter=0;
while($post_counter<$post_number)
{
$fetch =$db->fetch_array($query);
$fid=$fetch['fid'];
$query_forum_permissins=$db->query ("SELECT * FROM ".TABLE_PREFIX."forumpermissions WHERE fid='$fid' AND gid='$gid'");
$canread=1;
if($db->num_rows($query_forum_permissins)!=0)
{
$fetch_forum_permissins=$db->fetch_array($query_forum_permissins);
if($fetch_forum_permissins['canviewthreads']==1)
{
$canread=1;
}
else
{
$canread=0;
}
}
if($db->num_rows($query_forum_permissins)==0 AND $canread==1)
{
$threadlink = get_thread_link($fetch['tid']);
$tid=$fetch['tid'];
$uid=$mybb->user['uid'];
$query_view = $db->query("SELECT * FROM ".TABLE_PREFIX."threadsread WHERE tid='$tid' AND uid='$uid'");
if($db->num_rows($query_view)==0)
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_unread.gif">';
}
else
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_read.gif">';
}
$thread_sub=(substr($fetch['subject'],0,90));
$hotpost .='<tr '.$even.'><td><span id="pagenumber">'.$linenumber.'</span> '.$read_image.' <a href="'.$threadlink.'" target="_blank">'.$thread_sub.'</a></td><td>'.$fetch['replies'].'</td></tr>';
$post_counter++;
}
}
$hotpost.='</table>';
/************************************************ HOT POSTS **********************************************/
/************************************************ OTHER POSTS **********************************************/
if($mybb->settings['ajaxfs_customforum'] ==1)
{
$other_cat=$mybb->settings['ajaxfs_customforum_in'];
$category_number=explode('>>',$other_cat);
if($category_number==1)
{
$category_name_part=explode('|',$other_cat);
$category_name=$category_name_part[0];
$forum_ids=$category_name_part[1];
$post_info_option .='<li><a href="#other_cat">'.$category_name.'</a></li>';
$query = $db->query ("SELECT t1.*
FROM ".TABLE_PREFIX."posts t1
JOIN (
SELECT pid
FROM ".TABLE_PREFIX."posts
WHERE fid
IN (".$forum_ids.")
AND visible='1' ORDER BY pid DESC
)t2 ON t1.pid = t2.pid GROUP BY tid ORDER BY pid DESC");
$otherposts="<table cellspacing='0' id='Ajxfstable'><tr><th>{$lang->ajaxfs_lastpost_title}</th><th>{$lang->ajaxfs_lastpost_writer}</th></tr>";
if($db->num_rows($query)==0)
{
$post_number=0;
}
else
{
if($db->num_rows($query)<=$mybb->settings['ajaxfs_number_post'])
{
$post_number=$db->num_rows($query);
}
else
{
$post_number=$mybb->settings['ajaxfs_number_post'];
}
}
$post_counter=0;
while($post_counter<$post_number)
{
$fetch=$db->fetch_array($query);
$fid=$fetch['fid'];
$query_forum_permissins=$db->query ("SELECT * FROM ".TABLE_PREFIX."forumpermissions WHERE fid='$fid' AND gid='$gid'");
$canread=1;
if($db->num_rows($query_forum_permissins)!=0)
{
$fetch_forum_permissins=$db->fetch_array($query_forum_permissins);
if($fetch_forum_permissins['canviewthreads']==1)
{
$canread=1;
}
else
{
$canread=0;
}
}
if($db->num_rows($query_forum_permissins)==0 AND $canread==1)
{
$profilelink=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$fetch['uid'];
$lastposter=$fetch['username'];
$lastposteruid=$fetch['uid'];
$query_users = $db->query ("SELECT * FROM ".TABLE_PREFIX."users WHERE uid='$lastposteruid'");
$fetch_users =$db->fetch_array($query_users);
$lastposter=format_name($fetch_users['username'],$fetch_users['usergroup'],$fetch_users['displaygroup']);
$profilelink_lastposter=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$lastposteruid;
$tid=$fetch['tid'];
$uid=$mybb->user['uid'];
$query_view = $db->query("SELECT * FROM ".TABLE_PREFIX."threadsread WHERE tid='$tid' AND uid='$uid'");
$threadlink = get_post_link($fetch['pid'])."#pid".$fetch['pid'];
$post_pid=$fetch['pid'];
if($db->num_rows($query_view)==0)
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_unread.gif">';
}
else
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_read.gif">';
}
$thread_id=$fetch['tid'];
$query_thread_sub = $db->query ("SELECT * FROM ".TABLE_PREFIX."threads WHERE tid='$thread_id'");
$fetch_thread_sub=$db->fetch_array($query_thread_sub);
$thread_sub=htmlspecialchars_uni(substr($fetch_thr ead_sub['subject'],0,90));
$linenumber=$post_counter+1;
$otherposts .='<tr><td><span id="pagenumber">'.$linenumber.'</span> '.$read_image.' <a href="'.$threadlink.'" target="_blank" id="'.$post_pid.'" onmouseover="javascript:tooltip(event);" onmousemove="javascript:tooltipmove(event);" onmouseout="javascript:tooltipout();"> '.$thread_sub.'</a></td><td><a href="'.$profilelink_lastposter.'" target="_blank" id="'.$lastposteruid.'" onmouseover="javascript:usertooltip(event);" onmousemove="javascript:usertooltipmove(event);" onmouseout="javascript:usertooltipout();">'.$lastp oster.'</a></td></tr>';
$post_counter++;
}
}
$otherposts .='</table>';
$other_cat_info .='<div id="other_cat">'.$otherposts.'</div>';
}
else //If Other Table More One
{
for($i=0;$i<count($category_number);$i++)
{
$category_name_part=explode('|',$category_number[$i]);
$category_name=$category_name_part[0];
$forum_ids=$category_name_part[1];
$post_info_option .='<li><a href="#other_cat_'.$i.'">'.$category_name.'</a></li>';
$query = $db->query ("SELECT t1.*
FROM ".TABLE_PREFIX."posts t1
JOIN (
SELECT pid
FROM ".TABLE_PREFIX."posts
WHERE fid
IN (".$forum_ids.")
AND visible='1' ORDER BY pid DESC
)t2 ON t1.pid = t2.pid GROUP BY tid ORDER BY pid DESC");
$otherposts="<table cellspacing='0' id='Ajxfstable'><tr><th>{$lang->ajaxfs_lastpost_title}</th><th>{$lang->ajaxfs_lastpost_writer}</th></tr>";
if($db->num_rows($query)==0)
{
$post_number=0;
}
else
{
if($db->num_rows($query)<=$mybb->settings['ajaxfs_number_post'])
{
$post_number=$db->num_rows($query);
}
else
{
$post_number=$mybb->settings['ajaxfs_number_post'];
}
}
$post_counter=0;
while($post_counter<$post_number)
{
$fetch=$db->fetch_array($query);
$fid=$fetch['fid'];
$query_forum_permissins=$db->query ("SELECT * FROM ".TABLE_PREFIX."forumpermissions WHERE fid='$fid' AND gid='$gid'");
$canread=1;
if($db->num_rows($query_forum_permissins)!=0)
{
$fetch_forum_permissins=$db->fetch_array($query_forum_permissins);
if($fetch_forum_permissins['canviewthreads']==1)
{
$canread=1;
}
else
{
$canread=0;
}
}
if($db->num_rows($query_forum_permissins)==0 AND $canread==1)
{
$profilelink=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$fetch['uid'];
$lastposter=$fetch['username'];
$lastposteruid=$fetch['uid'];
$query_users = $db->query ("SELECT * FROM ".TABLE_PREFIX."users WHERE uid='$lastposteruid'");
$fetch_users =$db->fetch_array($query_users);
$lastposter=format_name($fetch_users['username'],$fetch_users['usergroup'],$fetch_users['displaygroup']);
$profilelink_lastposter=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$lastposteruid;
$tid=$fetch['tid'];
$uid=$mybb->user['uid'];
$query_view = $db->query("SELECT * FROM ".TABLE_PREFIX."threadsread WHERE tid='$tid' AND uid='$uid'");
$threadlink = get_post_link($fetch['pid'])."#pid".$fetch['pid'];
$post_pid=$fetch['pid'];
if($db->num_rows($query_view)==0)
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_unread.gif">';
}
else
{
$read_image='<img src="'.$mybb->settings['bburl'].'/images/fs_read.gif">';
}
$thread_id=$fetch['tid'];
$query_thread_sub = $db->query ("SELECT * FROM ".TABLE_PREFIX."threads WHERE tid='$thread_id'");
$fetch_thread_sub=$db->fetch_array($query_thread_sub);
$thread_sub=htmlspecialchars_uni(substr($fetch_thr ead_sub['subject'],0,90));
$linenumber=$post_counter+1;
$otherposts .='<tr><td><span id="pagenumber">'.$linenumber.'</span> '.$read_image.' <a href="'.$threadlink.'" target="_blank" id="'.$post_pid.'" onmouseover="javascript:tooltip(event);" onmousemove="javascript:tooltipmove(event);" onmouseout="javascript:tooltipout();"> '.$thread_sub.'</a></td><td><a href="'.$profilelink_lastposter.'" target="_blank" id="'.$lastposteruid.'" onmouseover="javascript:usertooltip(event);" onmousemove="javascript:usertooltipmove(event);" onmouseout="javascript:usertooltipout();">'.$lastp oster.'</a></td></tr>';
$post_counter++;
}
}
$otherposts .='</table>';
$other_cat_info .='<div id="other_cat_'.$i.'">'.$otherposts.'</div>';
}
}
}
/************************************************ OTHER POSTS **********************************************/
/************************************************ Last user **********************************************/
$query_user = $db->query ("SELECT * FROM ".TABLE_PREFIX."users ORDER BY uid DESC LIMIT 0,{$mybb->settings['ajaxfs_number_tops']}");
for($i=0;$i<$db->num_rows($query_user);$i++)
{
$fetch_user =$db->fetch_array($query_user);
$profile_user_link=$mybb->settings['bburl'].'/member.php?action=profile&uid='.$fetch_user['uid'];
$uid=$fetch_user['uid'];
$query_users = $db->query ("SELECT * FROM ".TABLE_PREFIX."users WHERE uid='$uid'");
$fetch_users =$db->fetch_array($query_users);
$username=format_name($fetch_users['username'],$fetch_users['usergroup'],$fetch_users['displaygroup']);
$lastuser .='<font style="hieght:18.75px;align:right;text-align:center;float:right;vertical-align:top;"><a href="'.$profile_user_link.'" target="_blank" id="'.$uid.'" onmouseover="javascript:usertooltip(event);" onmousemove="javascript:usertooltipmove(event);" onmouseout="javascript:usertooltipout();">'.$usern ame.'</a></font><br/>';
}
/************************************************ Last user **********************************************/