SPortal2.php
Bul ve Sil:
// Make sure guests can see this board.
$request = $smcFunc['db_query']('','
SELECT id_board
FROM {db_prefix}boards
WHERE ' . ($board === null ? '' : 'id_board = {int:board}
AND ') . 'FIND_IN_SET(-1, member_groups)
LIMIT 1',
array(
'board' => $board,
)
);
if ($smcFunc['db_num_rows']($request) == 0)
{
echo($txt['ssi_no_guests']);
return false;
}
list ($board) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);
Bul:
// Find the post ids.
$request = $smcFunc['db_query']('', '
SELECT id_first_msg
FROM {db_prefix}topics
WHERE id_board = {int:current_board}' . ($modSettings['postmod_active'] ? '
AND approved = {int:is_approved}' : '') . '
ORDER BY id_first_msg DESC
LIMIT ' . $start . ', ' . $limit,
array(
'current_board' => $board,
'is_approved' => 1,
)
);
Değiştir:
// Find the post ids.
$request = $smcFunc['db_query']('', '
SELECT id_first_msg
FROM {db_prefix}topics AS t
LEFT JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
WHERE {query_see_board} ' . ($modSettings['postmod_active'] ? '
AND approved = {int:is_approved}' : '') . '
ORDER BY id_first_msg DESC
LIMIT ' . $start . ', ' . $limit,
array(
'is_approved' => 1,
)
);