mybbgroup / active-threads Goto Github PK

As suggested by andrewjs18 here.

In activethreads.php (page, not plugin), all queries use mybb_ as prefix, it has to be replaced with TABLE_PREFIX.

• last post
• first post
• starter

I think there must be something wrong, it works right opposite that it should be, can you confirm?

Is there any way how to hide them? I updated from latest MyBB extended site version to yur GitHub one (dev). I deactivate -> copy new files -> activate). Now I can see which templates were modified. IT is cool, but they are displayed all the time (even I save the changes; I expect same behaviour as MyBB core template system after updating - saving edited theme makes it disappear from the list).

Hi, I got a report from one of my users:

MyBB SQL ErrorMyBB has experienced an internal SQL error and cannot continue.
SQL Error:1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '((p.dateline >= 1584179051 AND p.dateline <= 1585388651) AND f.fid NOT IN (11,15' at line 25Query:SELECT count(*) AS cnt FROM ( SELECT t.tid, t.subject AS thread_subject, t.dateline AS thread_dateline, uthr.uid AS thread_uid, uthr.username AS thread_username, uthr.usergroup AS thread_usergroup, t.closed AS thread_closed, t.lastpost AS thread_lastpost, t.replies AS thread_replies, t.views AS thread_views, t.icon AS thread_icon, t.poll AS thread_poll, t.prefix AS thread_prefix, f.parentlist, f.fid, f.name AS forum_name, count(p.pid) AS num_posts, MIN(p.pid) AS min_pid, MAX(p.pid) AS max_pid FROM mybb_threads t INNER JOIN mybb_posts p ON t.tid = p.tid INNER JOIN mybb_forums f ON f.fid = t.fid INNER JOIN mybb_users uthr ON uthr.uid = t.uid WHERE ((p.dateline >= 1584179051 AND p.dateline <= 1585388651) AND f.fid NOT IN (11,15,13,93,14,42,62,63,41,61,47,48,53,57,49,55,54,51,52,50,56,36,39,40,34,35,84,69,70,71,77,80,68,76,73,74,75,72)((p.dateline >= 1584179051 AND p.dateline <= 1585388651) AND f.fid NOT IN (11,15,13,93,14,42,62,63,41,61,47,48,53,57,49,55,54,51,52,50,56,36,39,40,34,35,84,69,70,71,77,80,68,76,73,74,75,72) AND ((t.fid IN(11,14,39,40) AND t.uid="1168") OR t.fid NOT IN(11,14,39,40)))) AND p.visible > 0 GROUP BY p.tid) AS mainqPlease contact the MyBB Group for technical support.

Why not to use all variables in same style? I mean using {}

Dear laird, dear developers,
this is, in my opinion, one of the most amazing plugins for MyBB and it has become absolutely crucial to my board.
However, what would be really great in my opinion, would be the ability to filter which forums are included in the list of active threads.

Background: On my board, there are several sub-forums that can be quite "spammy", with dozens of new threads created per day. It would be amazing to have to opportunity to hide these forums via their $fid from the active thread list.

Thank you very much for considering.

PS: Maybe this could also be done by myself via a small edit in the PHP file of your plugin. Any suggestions?

Something like MyBB default feature which displays posters in replies

[asc] and [desc] are missing... or not used

Make it easier to customize :)