ALTER TABLE {db_prefix}sp_blocks ADD force_view tinyint(2) unsigned NOT NULL default 0,
# mf_attachments
# Browse smf_ban_groups
# Browse smf_ban_items
# Browse smf_boards
# Browse smf_board_permissions
# Browse smf_calendar
# Browse smf_calendar_holidays
# Browse smf_categories
# Browse smf_collapsed_categories
# Browse smf_groupmods
# Browse smf_log_actions
# Browse smf_log_activity
# Browse smf_log_banned
# Browse smf_log_boards
# Browse smf_log_errors
# Browse smf_log_floodcontrol
# Browse smf_log_karma
# Browse smf_log_mark_read
# Browse smf_log_notify
# Browse smf_log_online
# Browse smf_log_polls
# Browse smf_log_search_messages
# Browse smf_log_search_results
# Browse smf_log_search_subjects
# Browse smf_log_search_topics
# Browse smf_log_topics
# Browse smf_membergroups
# Browse smf_members
# Browse smf_messages
# Browse smf_message_icons
# Browse smf_moderators
# Browse smf_package_servers
# Browse smf_pagerank
# Browse smf_permissions
# Browse smf_personal_messages
# Browse smf_pm_recipients
# Browse smf_polls
# Browse smf_poll_choices
# Browse smf_sessions
# Browse smf_settings
# Browse smf_smileys
# Browse smf_sp_articles
# Browse smf_sp_blocks
# Browse smf_sp_categories
# Browse smf_sp_functions
# Browse smf_themes
# Browse smf_topics
Have you tried running the 'upgrade.php' file attached to [SiNaN]'s post (http://simpleportal.net/index.php?topic=334.msg2036#msg2036)?
Okay, what errors are you receiving in your forum error log?
Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHAR_LENGTH(b.passwd) = 0
AND approved = 1
AND publish = 1' at line 6
File: /home/snake/public_html/forum/Sources/SPortal.php
Line: 132
turn off the Arcade block, you probably have a different version than portal supports.
and to people developing this, it could be also about this error:Code: [Select]Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHAR_LENGTH(b.passwd) = 0
AND approved = 1
AND publish = 1' at line 6
File: /home/snake/public_html/forum/Sources/SPortal.php
Line: 132
i guess it is Password Protect Boards by Dragooon. it modifies the $user_info['query_see_board'] and you use it in article query. maybe a conflict or maybe a problem caused by that mod.
function hof($count = 10, $time = - 1)
{
global $db_prefix, $scripturl, $txt, $modSettings;
$where = '';
if ($time == 'current')
$where = 'AND championTo = 0';
elseif ($time != -1)
$where = "AND championFrom > $time";
$results = db_query("
SELECT game.ID_GAME, game.gameName,game.thumbnail, game.gameDirectory, score.score, score.position,
IF(championFrom > 0, (IF(championTo = 0, UNIX_TIMESTAMP(), championTo) - championFrom), 0) AS championDuration,
IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, IFNULL(mem.realName, '') AS realName, IF(championTo = 0, 1, 0) AS current
FROM ({$db_prefix}arcade_scores AS score, {$db_prefix}arcade_games AS game)
LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = score.ID_MEMBER)
WHERE game.ID_GAME = score.ID_GAME
$where
HAVING championDuration > 0
ORDER BY IF(championFrom > 0, (IF(championTo = 0, UNIX_TIMESTAMP(), championTo) - championFrom), 0) DESC
LIMIT $count", __FILE__, __LINE__);
$top = array();
$max = -1;
while ($score = mysql_fetch_assoc($results))
{
if ($max == -1)
$max = $score['championDuration'];
$top[] = array(
'game_name' => $score['gameName'],
'game_link' => '<a href="' . $scripturl . '?action=arcade;sa=play;game=' . $score['ID_GAME'] . '">' . $score['gameName'] . '</a>',
'member_name' => $score['realName'],
'member_link' => !empty($score['realName']) ? '<a href="' . $scripturl . '?action=profile;u=' . $score['ID_MEMBER'] . '">' . $score['realName'] . '</a>' : $txt['arcade_guest'],
'duration' => format_time_ago($score['championDuration']),
'precent' => ($score['championDuration'] / $max) * 100,
'current' => $score['current'] == 1,
'thumbnail' =>$score['gameDirectory']."/".$score['thumbnail'],
'score' => round($score['score'],3),
);
}
if (count($top) == 0)
return false;
elseif ($count > 1)
return $top;
else
return $top[0];
}
global $scripturl, $txt, $boardurl, $context, $settings, $arcsettings;
$top_player = hof(10);
$i=0; //players position
echo '
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="20%" align="center" nowrap class="titlebg">
<b>Champion in Game</b>
</td>
<td width="25%" align="center" nowrap class="titlebg">
<b>Champions Name</b>
</td>
<td width="15%" align="center" nowrap class="titlebg">
<b>High Score</b>
</td>
<td width="20%" align="center" nowrap class="titlebg">
<b>Champion Since</b>
</td>
</tr>
</table>';
foreach ($top_player as $row)
{
echo '
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td align="left" width="20%" class="windowbg">
<img src="',$boardurl,'/','Games',$row['gameDirectory']."/".$row['thumbnail'],'"></a> ', $row['game_link'],'<br/>
</td>
<td align="center" width="25%" nowrap class="windowbg2">
', $row['member_link'],'
</td>
<td align="center" width="15%" nowrap="nocrap" class="windowbg">
', $row['score'],'
</td>
<td align="center" width="20%" class="windowbg2">
', $row['duration'],'
</td>
</tr>
';
$i++;
}
echo '
</table>';
I now only have this error still showing..
8: Undefined index: pets
File: /home/snake/public_html/forum/Sources/Load.php
Line: 1184