the db update went fine
the following error on boardindex.php
2: Supplied argument is not a valid MySQL result resource
Boardindex.php
-----------------------------------
$result_boards = mysql_query ("SELECT
c.name as catName,
c.ID_CAT,
b.ID_BOARD,
b.name as boardName, b.description, b.moderators, b.numPosts, b.numTopics FROM {$db_prefix}categories as c LEFT JOIN {$db_prefix}boards as b ON (b.ID_CAT=c.ID_CAT) WHERE ('$settings[7]'='Administrator' || '$settings[7]'='Global Moderator' || FIND_IN_SET('$settings[7]',c.memberGroups)!=0 || c.memberGroups='') ORDER BY c.catOrder, b.boardOrder");
// Added by Allowed User MOD - Begin
$AU_Board_result = mysql_query("SELECT ID_BOARD, ID_CAT FROM {$db_prefix}boards");
while ($AU_row_Board = mysql_fetch_array($AU_Board_result)) {
if (!isset($AU_Show_Cat[$AU_row_Board[1]])) $AU_Show_Cat[$AU_row_Board[1]] = 0;
$AU_Show_Cat[$AU_row_Board[1]]++;
$AU_Show_Board[$AU_row_Board[0]] = true;
if (($settings[7] != 'Administrator') && ($settings[7] != 'Global Moderator')) {
$AUO_result = mysql_query("SELECT AU_option FROM {$db_prefix}allowedusersoptions WHERE boardid = $AU_row_Board[0]");
if ($row_AUO = mysql_fetch_row($AUO_result)) {
if ($row_AUO[0] == '2') {
if ($username == 'Guest') {
$AU_Show_Cat[$AU_row_Board[1]]--;
$AU_Show_Board[$AU_row_Board[0]] = false;
}
} else if ($row_AUO[0] == '4') {
$AU_result = mysql_query("SELECT membername FROM {$db_prefix}allowedusers WHERE membername = '$username' AND boardid = $AU_row_Board[0]");
if (mysql_fetch_row($AU_result) == 0) {
$AU_Show_Cat[$AU_row_Board[1]]--;
$AU_Show_Board[$AU_row_Board[0]] = false;
}
}
}
}
}
// Added by Allowed User MOD - End
$curcat = -1;
while ($row_board = mysql_fetch_array($result_boards))
{
if ($AU_Show_Cat[$row_board['ID_CAT']] != 0) // Added by Allowed User MOD
// if this is a new category
if ($row_board['ID_CAT'] != $curcat)
{
$curcat=$row_board['ID_CAT'];
print <<<EOT
<tr>
<td colspan="6" class="catbg" height="18"><a name="$row_board[ID_CAT]"><b>$row_board[catName]</b></a></td>
</tr>
EOT;
}
if ($AU_Show_Board[$row_board['ID_BOARD']]) // Added by Allowed User MOD
if ($row_board['ID_BOARD'] != '')
-------------------------------------
where am i going wrong?
Author