Quick MyBB MySQL fix

Quick SQL fix to address the following issues for some MyBB users:

  • Hotlinked images and videos are not shown
  • Quoted images and videos are not shown
  • Classic layout is not enforced
  • “Friendly redirects” are not disabled
UPDATE `mybb_users` SET classicpostbit=1 WHERE classicpostbit=0;
UPDATE `mybb_users` SET showimages=1,showvideos=1 WHERE showimages=0;
UPDATE `mybb_users` SET showredirect=0 WHERE showredirect=1;

The first line is the most important because of the bug in MyBB UserCP.

External searching in mybb

Sometimes you need to integrate web-pages with corresponding forum threads. Here’s one of the ways to do it.

$keywords=”MyBB integration”; // The search keywords
<!– The path to mybb search.php –>
<form method=”post” action=”http://www.yoursite.com/mybb/search.php”>
<input type=”hidden” name=”action” value=”do_search” />
<input type=”hidden” name=”keywords” value=”<?php echo $keywords; ?>” />
<!– search titles only –>
<input type=”hidden”  name=”postthread” value=”2″ />
<!– Search in all forums –>
<input type=”hidden” name=”forums[]” size=”15″ multiple=”multiple” value=”all”>
<!– All dates –>
<input type=”hidden” name=”postdate” value=”0″>
<input type=”hidden” name=”pddir” value=”1″ />
<input type=”hidden” name=”sortby” value=”lastpost”>
<input type=”hidden” name=”sortordr” value=”asc” />
<!– the result will be threads, not posts –>
<input type=”hidden” name=”showresults” value=”threads” />
<input type=”submit” class=”button” name=”submit” value=”Forum” />