ge66
08-02-2004, 02:37 PM
An earlier bug in browselinks.php seemes to still be in there.
I could have swore I fixed that first problem in a previous version. To fix it though, you can open your browselinks.php file and look for:
SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links
Replace that with:
SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links AS links
And that will fix the problem.
I also made the following change:
Find:
$subdirjoin = 'LEFT JOIN ' . TABLE_PREFIX . 'links_subscribedir AS subscribedir ON (links_categories.catid = subscribedir.dirid AND subscribedir.userid = ' . $bbuserinfo['userid'] . ')';
Change to:
$subdirjoin = 'LEFT JOIN ' . TABLE_PREFIX . 'links_subscribedir AS subscribedir ON (' . TABLE_PREFIX . 'links_categories.catid = subscribedir.dirid AND subscribedir.userid = ' . $bbuserinfo['userid'] . ')';
That at least made it function better for me. :)
I could have swore I fixed that first problem in a previous version. To fix it though, you can open your browselinks.php file and look for:
SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links
Replace that with:
SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links AS links
And that will fix the problem.
I also made the following change:
Find:
$subdirjoin = 'LEFT JOIN ' . TABLE_PREFIX . 'links_subscribedir AS subscribedir ON (links_categories.catid = subscribedir.dirid AND subscribedir.userid = ' . $bbuserinfo['userid'] . ')';
Change to:
$subdirjoin = 'LEFT JOIN ' . TABLE_PREFIX . 'links_subscribedir AS subscribedir ON (' . TABLE_PREFIX . 'links_categories.catid = subscribedir.dirid AND subscribedir.userid = ' . $bbuserinfo['userid'] . ')';
That at least made it function better for me. :)