Hello everyone i recently began putting together a forum for a group im connected with, sadly after trying to add some further code ive received the error Syntax error, unexpected '('
This occurred once i removed the code id added and ive not been able to identify the fault. Sadly i was also a little to eager to begin and didn't create a copy before starting. I'm hoping a fresh set of eyes might be able to put me back on track.
Full error:
Parse error: syntax error, unexpected '(' in .... Sources/MessageIndex.php on line 342
Line 342 starts WHERE
if ($pre_query && $maxindex > 0)
{
$request = $smcFunc['db_query']('', '
SELECT t.id_topic
FROM {db_prefix}topics AS t' . ($context['sort_by'] === 'last_poster' ? '
INNER JOIN {db_prefix}messages AS ml ON (ml.id_msg = t.id_last_msg)' : (in_array($context['sort_by'], array('starter', 'subject')) ? '
INNER JOIN {db_prefix}messages AS mf ON (mf.id_msg = t.id_first_msg)' : '')) . ($context['sort_by'] === 'starter' ? '
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)' : '') . ($context['sort_by'] === 'last_poster' ? '
LEFT JOIN {db_prefix}members AS meml ON (meml.id_member = ml.id_member)' : '') . '
WHERE t.id_board = [int:current_board]' ( (!$modSettings['postmod_active'] || $context['can_approve_posts'] ? '' : 'AND t.approved = {int:is_approved}' . ($user_info['is_guest'] ? '' : ' OR t.id_member_started = {int:current_member}') . ')') . '
ORDER BY ' .(!empty($modSettings['enableStickyTopics']) ? 'is_sticky' . ($fake_ascending ? '' : ' DESC') . ', ' : '') . $_REQUEST['sort'] . ($ascending ? '' : ' DESC') . '
LIMIT {int:start}, {int:maxindex}',
array
(
'current_board' => $board,
'current_member' => $user_info['id'],
'id_member_guest' => 0,
'start' => $start,
'maxindex' => $maxindex,
)
);
$topic_ids = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$topic_ids[] = $row['id_topic'];
}
I can post more code if required the entire page is far to much for one post however. Any help would be appreciated.