how to limit this query code to a special forum

Hello
I found this query code in a plugin :

Code:

       SELECT t.tid, t.fid, t.subject, t.lastpost,
       t.lastposter, t.lastposteruid, f.name,
       u.usergroup, u.displaygroup
       FROM ".TABLE_PREFIX."threads AS t
       INNER JOIN ".TABLE_PREFIX."forums as f
       ON (f.fid = t.fid)
       LEFT JOIN " . TABLE_PREFIX . "users AS u
       ON (t.lastposteruid = u.uid)
       {$fids}
       AND t.visible = '1'
       GROUP BY t.tid
       ORDER BY t.lastpost DESC
       LIMIT

now, I want to know how can I limit it to a special forum
for example limit it to a forum that its FID is 2

thanks

Find

Reply

Without knowing the rest of the code it's hard to come up with a fix.

You can do something like this:

PHP Code:

while($forum = $db->fetch_array($query))
{
if($forum['fid'] == 2 ) 
{
//do some stuff when forum fid is 2
}
} 


Put this code below your SQL query and add f.fid to the it.


Or:

PHP Code:

$query = $db->simple_select('forums', 'fid');
 while($forum = $db->fetch_array($query))
    {
if($forum['fid'] == 2 ) 
{
// the rest of you PHP code here
}
} 


What are you trying to do?

Find

Reply

Thanks, I want to change this mod :
http://mods.mybb.com/view/recent-posts-forum-index

instead of showing recent post I want to show recent post of my own category

Find

Reply

Are you trying to do something like I have in these forums?

Latest threads in Category and Forum? If so you can use these: http://community.mybb.com/thread-153867-...pid1079115

Find

Reply

No, this mod :
http://mods.mybb.com/view/recent-posts-forum-index
shows recent posts of all the forum

I want to show recent posts (for example of Design & Development)

Find

Reply

I have already told you that this is what you need: http://letsforum.com/Thread-how-to-limit...36#pid9536
There are two plugins 1 for forum another for category.

Find

Reply

where does it shows recent post ?
needs any variable ?

Find

Reply

I am gonna try to modify recent-posts-forum-index plugin so that it will fetch latest posts from forum fid 2.

OK looks like I have found the solution.

In the plugin file find:

PHP Code:

//Preserve the forum viewing permissions intact
        
         $fids = "WHERE t.fid NOT IN ({$unviewablefids})";
        $unviewablefids = get_unviewable_forums();
        
        if($unviewablefids)
        {
            $fids = "WHERE t.fid NOT IN ({$unviewablefids})";
        }
        
        //Exclude inactive forums from showing up
        
        $inactivefids = get_inactive_forums();
        if ($inactivefids)
        {
            $fids .= " WHERE t.fid NOT IN ($inactivefids)";
        } 


Replace with:

PHP Code:

$forumid = 2;
$fids = "WHERE f.fid IN ({$forumid})"; 


This will only poll last posts from forum FID 2.

Find

Reply

Thanks marcus, this is what I needed
+1

Find

Reply