MyBB Hacks

search.php?action=getnew&subscriptionsonly=1

(replace "&" with "&" if putting in template)

This plugin will actually also filter for today's posts as well (but won't put a link for it)

search.php?action=getdaily&subscriptionsonly=1

• Known problem with merging threads - see here for a solution
• Small issue: this plugin uses a nested sub-query to do its work, as it's much easier to develop than a complex hack to get a joined query.  This may have a slight impact on performance, but I doubt it'll be much.
  Googling "mysql sub-query vs join performance" seems to show some people condemning sub-queries, with others saying the difference is practically nothing.
  The plugin uses a query similar to the following:
  
  SQL Code

  SELECT t.tid FROM mybb_threads t WHERE t.lastpost >='9999999' AND tid IN (SELECT tid FROM mybb_threadsubscriptions WHERE uid=1) AND t.visible>-1 AND t.closed NOT LIKE 'moved|%'

  ---

  as opposed to something like
  

  SQL Code

  SELECT t.tid FROM mybb_threads t LEFT JOIN mybb_threadsubscriptions s ON s.tid=t.tid WHERE t.lastpost >='9999999' AND t.visible>-1 AND t.closed NOT LIKE 'moved|%' AND s.uid=1

  ---

• This plugin will add a unique index to the threadsubscriptions table, to try to help lessen the impact of the above mentioned speed reduction.  Ideally, MyBB should've included this key for data integrity reasons, but they didn't.  As such, the plugin needs to check for duplicates in the table before adding the index, and, if any are found, it will remove the duplicates.  If you don't want this, you can stop it by opening up the plugin file and deleting the line:
  
  PHP Code:

  define('LATESTSUBSCRIBE_ADD_INDEX', 1);

  ---

• Queries used in this plugin probably only with with MySQL(i)
  

(06-20-2010 12:24 PM)ZiNgA BuRgA Wrote: [ -> ]Queries used in this plugin probably only with with MySQL

(07-03-2010 03:59 PM)Firefox Wins Wrote: [ -> ]Safe to assume this includes MySQLi?

$db->update_query("threadsubscriptions", $sqlarray, "tid='{$mergetid}'");

Replace with:

$db->write_query("UPDATE IGNORE ".TABLE_PREFIX."threadsubscriptions SET tid=$tid WHERE tid='{$mergetid}'");
$db->delete_query("threadsubscriptions", "tid='{$mergetid}'");

Note, this fix is not compatible with any fix MyBB issues (unless they decide to place a unique index on tid,uid as suggested in the bug report).

(07-04-2010 10:04 PM)leefish Wrote: [ -> ]Just a small issue, but the header on the downloads template (as used in this thread) is breaking the forum layout. I see the first two code blocks are not getting the frame and so its stretching the forum layout (I have a smallish screen)