Page 1 of 4

SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 04:40
by Solidjeuh
Hello, I just installed this mod. And when a user is logged in, everything is ok!
But when you are not logged in, you get an error ..
All other pages are working .. just error @ the index page ...

When I remove this from index.php it works again...

Code: Select all

//-- mod: Top Stats ---------------------------------------------------------//
	include($phpbb_root_path . 'includes/functions_top_stats.' . $phpEx);
//-- end: Top Stats ---------------------------------------------------------//
Any idea what this could be please?

Image

Index.php

Code: Select all

<?php
/**
*
* @package phpBB3
* @version $Id: index.php 8987 2008-10-09 14:17:02Z acydburn $
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

/**
*/

/**
* @ignore
*/
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
// phpBB Arcade Start
$scoretype = (strtolower(request_var('act', '')) == 'arcade' && strtolower(request_var('do', '')) == 'newscore') ? 'IBPRO_GAME' : ((strtolower(request_var('autocom', '')) == 'arcade') ? 'IBPROV3_GAME' : false);
if ($scoretype)
{
	require($phpbb_root_path . 'includes/arcade/arcade_scoretype.' . $phpEx);
}   
// phpBB Arcade End
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup('viewforum');
// SmiX.MODs feed news center [+]
$smix_feed_parser = new smix_feed_parser();

$smix_feed_parser->index_init();
// SmiX.MODs feed news center [-]
display_forums('', $config['load_moderators']);

// Set some stats, get posts count from forums data if we... hum... retrieve all forums data
$total_posts	= $config['num_posts'];
$total_topics	= $config['num_topics'];
$total_users	= $config['num_users'];
$uptimeindex    = shell_exec("cut -d. -f1 /proc/uptime");
$daysindex       = floor($uptimeindex/60/60/24);
$hoursindex    = $uptimeindex/60/60%24;
$minsindex       = $uptimeindex/60%60;
$secsindex       = $uptimeindex%60;
$load          = sys_getloadavg();

$l_total_user_s = ($total_users == 0) ? 'TOTAL_USERS_ZERO' : 'TOTAL_USERS_OTHER';
$l_total_post_s = ($total_posts == 0) ? 'TOTAL_POSTS_ZERO' : 'TOTAL_POSTS_OTHER';
$l_total_topic_s = ($total_topics == 0) ? 'TOTAL_TOPICS_ZERO' : 'TOTAL_TOPICS_OTHER';

// Grab group details for legend display
if ($auth->acl_gets('a_group', 'a_groupadd', 'a_groupdel'))
{
	$sql = 'SELECT group_id, group_name, group_colour, group_type
		FROM ' . GROUPS_TABLE . '
		WHERE group_legend = 1
		ORDER BY group_name ASC';
}
else
{
	$sql = 'SELECT g.group_id, g.group_name, g.group_colour, g.group_type
		FROM ' . GROUPS_TABLE . ' g
		LEFT JOIN ' . USER_GROUP_TABLE . ' ug
			ON (
				g.group_id = ug.group_id
				AND ug.user_id = ' . $user->data['user_id'] . '
				AND ug.user_pending = 0
			)
		WHERE g.group_legend = 1
			AND (g.group_type <> ' . GROUP_HIDDEN . ' OR ug.user_id = ' . $user->data['user_id'] . ')
		ORDER BY g.group_name ASC';
}
$result = $db->sql_query($sql);

$legend = array();
while ($row = $db->sql_fetchrow($result))
{
	$colour_text = ($row['group_colour']) ? ' style="color:#' . $row['group_colour'] . '"' : '';
	$group_name = ($row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $row['group_name']] : $row['group_name'];

	if ($row['group_name'] == 'BOTS' || ($user->data['user_id'] != ANONYMOUS && !$auth->acl_get('u_viewprofile')))
	{
    $legend[] = '<span' . $colour_text . '>' . $group_name . '</span>';
	}
	else
	{
    $legend[] = '<a' . $colour_text . ' href="' . append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']) . '">' . $group_name . '</a>';
	}
}
$db->sql_freeresult($result);

    $legend = implode(', ', $legend);

// Generate birthday list if required ...
$birthday_list = '';
if ($config['load_birthdays'] && $config['allow_birthdays'])
{
	$now = getdate(time() + $user->timezone + $user->dst - date('Z'));
	$sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday
		FROM ' . USERS_TABLE . ' u
		LEFT JOIN ' . BANLIST_TABLE . " b ON (u.user_id = b.ban_userid)
		WHERE (b.ban_id IS NULL
			OR b.ban_exclude = 1)
			AND u.user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%'
			AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
	$result = $db->sql_query($sql);

	while ($row = $db->sql_fetchrow($result))
	{
		$birthday_list .= (($birthday_list != '') ? ', ' : '') . get_username_string('full', $row['user_id'], $row['username'], $row['user_colour']);

		if ($age = (int) substr($row['user_birthday'], -4))
		{
			$birthday_list .= ' (' . ($now['year'] - $age) . ')';
		}
				/*
		* Post Bot - Birthday Post
		* By Poppertom69
		*/
		if(pb::check_extension_status('post_bot_users_birthday'))
		{
			$birth = $now['year'] - $age;
			pb::post_bot_user_birthday($row['username'], $row['user_id'], $birth);
		}
		/* End Post Bot */
	}
	$db->sql_freeresult($result);
}
// Show amount of reported and queue posts for authenticated users
if ($auth->acl_getf_global('m_report') || $auth->acl_getf_global('m_approve'))
{
	if (!function_exists('get_forum_list'))
	{
		include($phpbb_root_path . 'includes/functions_admin.' . $phpEx);
	}
	$user->add_lang('mcp');
	
	// Reported Posts
	$forum_list = get_forum_list('m_report');
	if (!empty($forum_list))
	{
		$sql = 'SELECT COUNT(r.report_id) AS total_reported
			FROM ' . REPORTS_TABLE . ' r, ' . POSTS_TABLE . ' p
			WHERE r.post_id = p.post_id
				AND r.report_closed = 0
				AND ' . $db->sql_in_set('p.forum_id', $forum_list);
		$result = $db->sql_query($sql);
		$total_reported = (int) $db->sql_fetchfield('total_reported');
		$db->sql_freeresult($result);

		if ($total_reported)
		{			
			$template->assign_vars(array(
				'L_REPORTS_TOTAL'	=> ($total_reported == 1) ? $user->lang['REPORT_TOTAL'] : sprintf($user->lang['REPORTS_TOTAL'], $total_reported),
				'U_MCP_REPORTS'		=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=reports'))
			);
		}
	}
	
	// Reported PMs
	$sql = 'SELECT COUNT(report_id) AS total_pm_reported
		FROM ' . REPORTS_TABLE . '  
		WHERE pm_id <> 0
			AND report_closed = 0';
	$result = $db->sql_query($sql);
	$total_pm_reported = (int) $db->sql_fetchfield('total_pm_reported');
	$db->sql_freeresult($result);

	if ($total_pm_reported)
	{			
		$template->assign_vars(array(
			'L_PM_REPORTS_TOTAL'	=> ($total_pm_reported == 1) ? $user->lang['PM_REPORT_TOTAL'] : sprintf($user->lang['PM_REPORTS_TOTAL'], $total_pm_reported),
			'U_MCP_PM_REPORTS'		=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=pm_reports'))
		);
	}
	
	// Posts and Topics in the Queue
	$forum_list = get_forum_list('m_approve');
	if (!empty($forum_list))
	{
		// Get the queue topics and posts in 1 query :)
		$sql = 'SELECT COUNT(t.topic_id) AS total_queue_topics, (
							SELECT COUNT(p.post_id) 
							FROM ' . POSTS_TABLE . ' p 
							WHERE p.post_approved = 0
								AND ' . $db->sql_in_set('p.forum_id', $forum_list) . ' ) AS total_queue_posts
				FROM ' . TOPICS_TABLE . ' t
				WHERE t.topic_approved = 0
					AND ' . $db->sql_in_set('t.forum_id', $forum_list);
		$result = $db->sql_query($sql);
		$row = $db->sql_fetchrow($result);
		$db->sql_freeresult($result);

		// Topics contain posts, so let's remove these
		$total_queue_posts = $row['total_queue_posts'] - $row['total_queue_topics'];		
		$total_queue_topics = $row['total_queue_topics'];
		
		if ($total_queue_posts)
		{
			$template->assign_vars(array(
				'L_UNAPPROVED_POSTS_TOTAL'	=> ($total_queue_posts == 1) ? $user->lang['UNAPPROVED_POST_TOTAL'] : sprintf($user->lang['UNAPPROVED_POSTS_TOTAL'], $total_queue_posts),
				'U_MCP_POSTS_QUEUE'			=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=unapproved_posts'))
			);
		}
		
		if ($total_queue_topics)
		{
			$template->assign_vars(array(
				'L_UNAPPROVED_TOPICS_TOTAL'	=> ($total_queue_topics == 1) ? $user->lang['UNAPPROVED_TOPIC_TOTAL'] : sprintf($user->lang['UNAPPROVED_TOPICS_TOTAL'], $total_queue_topics),
				'U_MCP_TOPICS_QUEUE'		=> append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&mode=unapproved_topics'))
			);
		}
		
	}	
}

if ( isset($config['announcement_enable']))
{
	if ( $config['announcement_show_index'] && ($config['announcement_enable'] || $config['announcement_show_birthdays_always']) )
	{
		if (!function_exists('get_announcement_data'))
		{
			include($phpbb_root_path . 'includes/functions_announcements.' . $phpEx);
		}
		get_announcement_data();
	}
}
// BEGIN Welcome Mod
//--Welcome_Mod--get the hour number-->
$date = $user->format_date(time(), 'H');

if ($user->data['is_registered'])
{
    $u_user_name = get_username_string('full', $user->data['user_id'], $user->data['username'], $user->data['user_colour']);
}
else
{
    $u_user_name = $user->lang['WELCOME_GUEST'];
}   

switch (true)
{
        case ($date < 1):
            // if the hour is 11am-12am (18-23)
            $s_welcome = sprintf($user->lang['GOOD_NIGHT'], $u_user_name);;
        break;
      
      	case ($date < 4):
            // if the hour is 1-3 am
            $s_welcome = sprintf($user->lang['UP_LATE'], $u_user_name);
        break;
       
        case ($date < 8):
            // if the hour is 4-7 am
            $s_welcome = sprintf($user->lang['UP_EARLY'], $u_user_name);
        break;
       
        case ($date < 12):
            // if the hour is 8-11 am
            $s_welcome = sprintf($user->lang['GOOD_MORNING'], $u_user_name);
        break;
       
        case ($date < 18):
            // if the hour is 12-5pm
            $s_welcome = sprintf($user->lang['GOOD_AFTERNOON'], $u_user_name);
        break;
       
        case ($date < 24):
            // if the hour is 6pm-11pm
            $s_welcome = sprintf($user->lang['GOOD_EVENING'], $u_user_name);;
        break;
} 

// how long a member for
$member_for = '';
if ($user->data['is_registered'] && !$user->data['is_bot'])
{
    $member_length = time() - $user->data['user_regdate'];
    $years = $months = $days = 0;
    $member_for = '';
    if ($member_length)
    {   
        if ($member_length >= 31536000)
        {
            $years = floor($member_length / 31536000);
            $member_length = $member_length - ($years * 31536000);
            $member_for .= $years > 1 ? ($years . '&nbsp;' . $user->lang['WELCOME_YEARS'] . ', ') : ($years . '&nbsp;' . $user->lang['WELCOME_YEAR'] . ', ');
        }
        $months = floor($member_length / 2628000);
        if ($months)
        {
            $months = $months > 1 ? ($months . '&nbsp;' . $user->lang['WELCOME_MONTHS'] . ', ') : ($months . '&nbsp;' . $user->lang['WELCOME_MONTHS'] . ', ');
            $member_length = $member_length - ($months * 2628000);
            $member_for .= $months;
        }
        $days = floor($member_length / 86400);
        if ($days)
        {
            $days = $days > 1 ? ($days . '&nbsp;' . $user->lang['WELCOME_DAYS']) : ($days . '&nbsp;' . $user->lang['WELCOME_DAY']);
            $member_for .= $days;
        }       
    }
}
//END Welcome Mod
//-- mod: top five ---------------------------------------------------------//
	include($phpbb_root_path . 'includes/top_five.' . $phpEx);
//-- end: top five ---------------------------------------------------------//
//-- Arcade leaders on index
   include_once($phpbb_root_path . './includes/arcade/arcade_common.' . $phpEx);   
   $arcade = new arcade(false);
   $real_leaders_count = sizeof($arcade->leaders);
   $leaders_count = ($real_leaders_count > 3) ? 3 : $real_leaders_count;   

   $arcade_leaders_img = array();
   $arcade_leaders_img[0] = '';
   $arcade_leaders_img[1] = $phpbb_root_path . $arcade->config['image_path'] . '1st.gif';
   $arcade_leaders_img[2] = $phpbb_root_path . $arcade->config['image_path'] . '2nd.gif';
   $arcade_leaders_img[3] = $phpbb_root_path . $arcade->config['image_path'] . '3rd.gif';
   
   $arcade_leaders_img_alt = array();
   $arcade_leaders_img_alt[0] = '';
   $arcade_leaders_img_alt[1] = $user->lang['ARCADE_FIRST'];
   $arcade_leaders_img_alt[2] = $user->lang['ARCADE_SECOND'];
   $arcade_leaders_img_alt[3] = $user->lang['ARCADE_THIRD'];

   if ($leaders_count > 0)
   {
      $rank = 0;
      $actual_rank = 0;
      $previous_wins = 0;
      for ($i = 0; $i < $leaders_count; $i++)
      {
         //This code is used to calculate the actual rank.
         //For example if there are ties...
         $actual_rank++;
         if ($previous_wins != $arcade->leaders[$i]['total_wins'])
         {
            $rank = $actual_rank;
         }
         $previous_wins = $arcade->leaders[$i]['total_wins'];

         $user_link = $arcade->get_username_string('full', $arcade->leaders[$i]['user_id'], $arcade->leaders[$i]['username'], $arcade->leaders[$i]['user_colour']);         
         
         $template->assign_block_vars('arcade_leaders', array(
            'ARCADE_LEADERS_RANK'      => $rank,
            'ARCADE_LEADERS'          => $user_link,
            'ARCADE_LEADERS_IMAGE'      => (isset($arcade_leaders_img[$rank])) ? $arcade_leaders_img[$rank] : '',
            'ARCADE_LEADERS_IMAGE_ALT'   => (isset($arcade_leaders_img_alt[$rank])) ? $arcade_leaders_img_alt[$rank] : '',
            'VICTORIES'               => $arcade->leaders[$i]['total_wins']
         ));
      }
   }   
//-- Arcade leaders on index
/**
* Ultimate Points
*/
if ( isset($config['points_name']) )
{	
	// Add points lang
	$user->add_lang('mods/points');

	// Generate the bank statistics
	$sql_array = array(
		'SELECT'    => 'SUM(holding) AS total_holding, count(user_id) AS total_users',
		'FROM'      => array(
			POINTS_BANK_TABLE => 'b',
		),
		'WHERE'		=> 'id > 0',
	);
	$sql = $db->sql_build_query('SELECT', $sql_array);
	$result = $db->sql_query($sql);
	$b_row = $db->sql_fetchrow($result);
	$bankholdings = ( $b_row['total_holding'] ) ? $b_row['total_holding'] : 0;
	$bankusers = $b_row['total_users'];

	// Create most rich users - cash and bank
	$limit = $points_values['number_show_top_points'];
	$sql_array = array(
		'SELECT'    => 'u.user_id, u.username, u.user_colour, u.user_points, b.holding',

		'FROM'      => array(
			USERS_TABLE  => 'u',
		),
		'LEFT_JOIN' => array(
			array(
				'FROM'  => array(POINTS_BANK_TABLE => 'b'),
				'ON'    => 'u.user_id = b.user_id'
			)
		),
	);
	$sql = $db->sql_build_query('SELECT', $sql_array);
	$result = $db->sql_query($sql);

	// Create a new array for the users
	$rich_users = array();

	// Create sorting array
	$rich_users_sort = array();

	// Loop all users array to escape the 0 points users
	while( $row = $db->sql_fetchrow($result))
	{
		if ( $row['user_points'] > 0 || $row['holding'] > 0 ) //let away beggars
		{
			$total_points = $row['user_points'] + $row['holding'];
			$index = $row['user_id'];
			$rich_users[$index] = array('total_points' => $total_points, 'username' => $row['username'], 'user_colour' => $row['user_colour'], 'user_id' => $index);
			$rich_users_sort[$index] = $total_points;
		}
	}

	$db->sql_freeresult($result);

	// Sort by points desc
	arsort( $rich_users_sort);

	// Extract the user ids
	$rich_users_sort  = array_keys($rich_users_sort);

	// Create new sorted rich users array
	$rich_users_sorted = array();

	// Check, if number of users in array is below the set limit
	$new_limit = sizeof($rich_users) < $limit ? sizeof($rich_users) : $limit;

	for($i = 0; $i < $new_limit; $i++)
	{
		$rich_users_sorted[] = $rich_users[$rich_users_sort[$i]];
	}

	// Send to template
	foreach($rich_users_sorted as $var)
	{
		$template->assign_block_vars('rich_user', array(
			'USERNAME'         => get_username_string('full', $var['user_id'], $var['username'], $var['user_colour']),
			'SUM_POINTS'      => number_format_points($var['total_points']),
			'SUM_POINTS_NAME'   => $config['points_name'],
		));
	}

	//Generate the points statistics
	$sql_array = array(
		'SELECT'    => 'SUM(user_points) AS total_points',
		'FROM'      => array(
			USERS_TABLE => 'u',
		),
		'WHERE'		=> 'user_points > 0',
	);
	$sql = $db->sql_build_query('SELECT', $sql_array);
	$result = $db->sql_query($sql);
	$b_row = $db->sql_fetchrow($result);
	$totalpoints = ( $b_row['total_points'] ) ? $b_row['total_points'] : 0;
	$lottery_time = $user->format_date(($points_values['lottery_last_draw_time'] + $points_values['lottery_draw_period']), false, true);

	// Run Lottery
	if ( $points_values['lottery_draw_period'] != 0 && $points_values['lottery_last_draw_time'] + $points_values['lottery_draw_period'] - time() < 0 )
	{
		if (!function_exists('run_lottery'))
		{
			include($phpbb_root_path . 'includes/points/functions_points.' . $phpEx);
		}
		if (!function_exists('send_pm'))
		{
			include($phpbb_root_path . 'includes/functions_privmsgs.' . $phpEx);
		}
		run_lottery();
	}

	$template->assign_vars(array(
		'TOTAL_BANK_USER'			=> sprintf($user->lang['POINTS_BUPOINTS_TOTAL'], $bankusers, $points_values['bank_name']),
		'TOTAL_BANK_POINTS'			=> sprintf($user->lang['POINTS_BPOINTS_TOTAL'], number_format_points($bankholdings), $config['points_name'], $points_values['bank_name']),
		'TOTAL_POINTS_USER'			=> sprintf($user->lang['POINTS_TOTAL'], number_format_points($totalpoints), $config['points_name']),
		'LOTTERY_TIME'				=> sprintf($user->lang['POINTS_LOTTERY_TIME'], $lottery_time),
		'S_DISPLAY_LOTTERY'			=> ($points_config['display_lottery_stats']) ? true : false,
		'S_DISPLAY_POINTS_STATS'	=> ($points_config['stats_enable']) ? true : false,
		'S_DISPLAY_INDEX'			=> ($points_values['number_show_top_points'] > 0) ? true : false,
	));
}

// Assign index specific vars
$template->assign_vars(array(
	'TOTAL_POSTS'	=> sprintf($user->lang[$l_total_post_s], $total_posts),
	'TOTAL_TOPICS'	=> sprintf($user->lang[$l_total_topic_s], $total_topics),
	'TOTAL_USERS'	=> sprintf($user->lang[$l_total_user_s], $total_users),
	'NEWEST_USER'	=> sprintf($user->lang['NEWEST_USER'], get_username_string('full', $config['newest_user_id'], $config['newest_username'], $config['newest_user_colour'])),
	'UPTIME_DAYS'      => $daysindex,
    'UPTIME_HOURS'      => $hoursindex,
    'UPTIME_MINS'      => $minsindex,
    'UPTIME_SECS'      => $secsindex,
    'AVG_LOAD0'         => $load[0],
    'AVG_LOAD1'         => $load[1],
    'AVG_LOAD2'         => $load[2],

	// BEGIN Welcome Mod   
    'S_WELCOME'                   => $s_welcome,
    'S_JOINED_DATE'               => $user->lang['JOINED'] . ':&nbsp;' . $user->format_date($user->data['user_regdate']),
    'USER_AVATAR'               => get_user_avatar($user->data['user_avatar'], $user->data['user_avatar_type'], $user->data['user_avatar_width'], $user->data['user_avatar_height']),
    'MEMBER_FOR'               => (!empty($member_for)) ? $user->lang['MEMBER_FOR'] . '&nbsp;' . $member_for : '',
   	// END Welcome Mod 

	'LEGEND'		=> $legend,
	'BIRTHDAY_LIST'	=> $birthday_list,
'U_ID' => $user->data['user_id'], 
	'FORUM_IMG'				=> $user->img('forum_read', 'NO_UNREAD_POSTS'),
	'FORUM_UNREAD_IMG'			=> $user->img('forum_unread', 'UNREAD_POSTS'),
	'FORUM_LOCKED_IMG'		=> $user->img('forum_read_locked', 'NO_UNREAD_POSTS_LOCKED'),
	'FORUM_UNREAD_LOCKED_IMG'	=> $user->img('forum_unread_locked', 'UNREAD_POSTS_LOCKED'),

	'S_LOGIN_ACTION'			=> append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=login'),
	'S_DISPLAY_BIRTHDAY_LIST'	=> ($config['load_birthdays']) ? true : false,

	'U_MARK_FORUMS'		=> ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&mark=forums') : '',
	'U_MCP'				=> ($auth->acl_get('m_') || $auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=main&mode=front', true, $user->session_id) : '')
);

if ($config['rt_index'])
{
	if (!function_exists('display_recent_topics'))
	{
		include($phpbb_root_path . 'includes/functions_recenttopics.' . $phpEx);
	}
	display_recent_topics($config['rt_number'], $config['rt_page_number'], $config['rt_anti_topics'], 'recent_topics', request_var('f', 0), true);
}
//-- mod: Top Stats ---------------------------------------------------------//
	include($phpbb_root_path . 'includes/functions_top_stats.' . $phpEx);
//-- end: Top Stats ---------------------------------------------------------//
// Output page
page_header($user->lang['INDEX']);

$template->set_filenames(array(
	'body' => 'index_body.html')
);

page_footer();

?>

SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 07:30
by Stoker
Try remove this from NV Recent topics and let me know how it goes:

Code: Select all

if ($config['rt_index'])
    {
       if (!function_exists('display_recent_topics'))
       {
          include($phpbb_root_path . 'includes/functions_recenttopics.' . $phpEx);
       }
       display_recent_topics($config['rt_number'], $config['rt_page_number'], $config['rt_anti_topics'], 'recent_topics', request_var('f', 0), true);
    }

SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 07:48
by Solidjeuh
Still the same error ..
I also noticed that those buttons don't work .. play, stop, forward ...
When I click on them, The forum just scrolls to top .. lol
Also the topics are not changing .. not scrolling down or up ..

Overal_header:

Code: Select all

            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
            <html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">

            <head>
           
            <link rel="shortcut icon" href='http://www.presents4you.net/images/icon.ico' />
            <meta name="robots" content="noindex, nofollow" />
            <meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
            <meta http-equiv="content-style-type" content="text/css" />
            <meta http-equiv="content-language" content="{S_USER_LANG}" />
            <meta http-equiv="imagetoolbar" content="no" />
            <meta name="resource-type" content="document" />
            <meta name="distribution" content="global" />
            <meta name="copyright" content="2000, 2002, 2005, 2007 phpBB Group, 2007 - 2010 Marc Alexander" />
            <meta name="keywords" content="" />
            <meta name="description" content="" />
            <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7; IE=EmulateIE9" />
            <!-- IF S_ARCADE_FACEBOOK -->
            <meta property="og:url"         content="{U_GAME_PLAY}" />
            <meta property="og:title"       content="{GAME_NAME_FLASH_GAME}"/>
            <!-- IF GAME_IMAGE -->
            <meta property="og:image"       content="{GAME_IMAGE}"/>
            <!-- ENDIF -->
            <meta property="og:site_name"   content="{SITENAME}"/>
            <meta property="og:description" content="{SITE_DESCRIPTION}"/>
            <!-- ENDIF -->
            {META}
            <title>&bull; {SITENAME} &bull;  {PAGE_TITLE}</title>

            <!-- MOD : MSSTI RSS Feeds (V1.2.1) - Start //-->
            <!-- IF S_FEEDS -->
            <link rel="alternate" type="application/rss+xml" title="{L_RSS_FEEDS} - {SITENAME}" href="{U_RSS}" />
            <!-- IF U_FEEDS_NEWS --><link rel="alternate" type="application/rss+xml" title="{L_RSS_FEEDS} - {L_RSS_NEWS}" href="{U_FEEDS_NEWS}" /><!-- ENDIF -->
            <!-- ENDIF -->
            <!-- MOD : MSSTI RSS Feeds (V1.2.1) - End //-->

            <!-- IF S_ERROR_PAGE -->
            <base href="{U_FORUM_BASE}" />
            <!-- ENDIF -->
            <!-- IF S_ENABLE_FEEDS -->
               <!-- IF S_ENABLE_FEEDS_OVERALL --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {SITENAME}" href="{U_FEED}" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_NEW}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_TOPICS_ACTIVE --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_ACTIVE}" href="{U_FEED}?mode=topics_active" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FORUM} - {FORUM_NAME}" href="{U_FEED}?f={S_FORUM_ID}" /><!-- ENDIF -->
               <!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}" href="{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}" /><!-- ENDIF -->
            <!-- ENDIF -->

            <!--
               phpBB style name: proFormell
               Based on style:   prosilver
               Inspired by:     Formell (Joomla Style)
               Original author:  Tom Beddard ( http://www.subBlue.com/ )
               Modified by:       Marc Alexander
               
               NOTE: This page was generated by phpBB, the free open-source bulletin board package.
                     The phpBB Group is not responsible for the content of this page and forum. For more information
                     about phpBB please visit http://www.phpbb.com
            -->

            <script type="text/javascript">
            // <![CDATA[
               var jump_page = '{LA_JUMP_PAGE}:';
               var on_page = '{ON_PAGE}';
               var per_page = '{PER_PAGE}';
               var base_url = '{A_BASE_URL}';
               var style_cookie = 'phpBBstyle';
               var style_cookie_settings = '{A_COOKIE_SETTINGS}';
               var onload_functions = new Array();
               var onunload_functions = new Array();
               var is_ie6 = false;

                  window.onbeforeunload = loader;

       onunload_functions.push('loader()');

       function loader()
       {
          var l = document.getElementById('loader');
          if (l)
          {
             l.style.display = 'block';
          }            
       }
			   /**
               * Find a member
               */
               function find_username(url)
               {
                  popup(url, 760, 570, '_usersearch');
                  return false;
               }

               /**
               * New function for handling multiple calls to window.onload and window.unload by pentapenguin
               */
               window.onload = function()
               {
                  for (var i = 0; i < onload_functions.length; i++)
                  {
                     eval(onload_functions[i]);
                  }
               }

               window.onunload = function()
               {
                  for (var i = 0; i < onunload_functions.length; i++)
                  {
                     eval(onunload_functions[i]);
                  }
               }

            // ]]>
            </script>
            <!--[if lt IE 7]>
            <script type="text/javascript">
            // <![CDATA[
            var is_ie6 = true;
            // ]]>
            </script>
            <![endif]-->
            <!-- INCLUDE mods/reimg_content.html -->
            <!-- IF U_PRINT_TOPIC -->

            <link href="{T_THEME_PATH}/print.css" rel="stylesheet" type="text/css" media="print" title="printonly" />
            <!-- ENDIF -->
            <link href="{T_STYLESHEET_LINK}" rel="stylesheet" type="text/css" media="screen, projection" />

            <!-- IF S_CONTENT_DIRECTION eq 'rtl' -->
               <link href="{T_THEME_PATH}/bidi.css" rel="stylesheet" type="text/css" media="screen, projection" />
            <!-- ENDIF -->
            <!-- IF S_IN_ARCADE -->
               <link href="{T_THEME_PATH}/arcade.css" rel="stylesheet" type="text/css" media="screen, projection" />
            <!-- ENDIF -->
    
    <!-- Start Highslide -->
    <script type="text/javascript" src="{ROOT_PATH}highslide/highslide-full.js"></script>
    <link rel="stylesheet" href="{ROOT_PATH}highslide/highslide.css" type="text/css" />
    <!-- End Highslide -->

    <!-- YOUTUBE VIDEOS MOD BEGIN -->
    <script type="text/javascript" src="youtube/swfobject.js"></script>
    <script type="text/javascript" src="youtube/quvic.js"></script>
    <script type="text/javascript" src="youtube/jquery.js"></script>
    <link href="youtube/quvic.css" type="text/css" rel="stylesheet"/>
    <!-- YOUTUBE VIDEOS MOD END -->
    <script type="text/javascript">
    function brokenImage(img)
    {
        img.src='{ROOT_PATH}images/notfound.png';
    }
    </script>
    <script type="text/javascript" src="{T_TEMPLATE_PATH}/forum_fn.js"></script>
    <!-- IF (S_TSRAT_ENABLE and S_TS_JSSCROLL) or (S_TSRAT_ENABLE and S_TS_TICKER) -->
<!-- IF S_TS_JSSCROLL and not S_TS_TICKER -->
<script src="{ROOT_PATH}script/jquery.totemticker.min.js" type="text/javascript"></script>
<script type="text/javascript">
// <![CDATA[
$(document).ready(function() {
	$('#vertical-ticker').totemticker({
				row_height	:	'41px',
				max_items   :   3,
				speed       :   {JSSCROLL_SPEED},
				interval    :   {JSSCROLL_INTERVAL},
				<!-- IF TS_JSSCROLL_NAVIGATION -->
				next		:	'#ticker-next',
				previous	:	'#ticker-previous',
				stop		:	'#stop',
				start		:	'#start',
				<!-- ENDIF -->
				mousestop	:	true,
				direction	:	'<!-- IF TS_JSSCROLL_DIRECTION -->down<!-- ELSE -->up<!-- ENDIF -->'
	});
});
// ]]>
</script>
<!-- ELSEIF S_TS_TICKER and not S_TS_JSSCROLL -->
<script src="{ROOT_PATH}script/jquery.newsticker.js" type="text/javascript"></script>
<script type="text/javascript">
// <![CDATA[
$(document).ready(function() {
	$("#news").newsTicker();
});
// ]]>
</script>
<!-- ENDIF -->
<!-- ENDIF -->
    <script src="{ROOT_PATH}script/reflection.js" type="text/javascript"></script>

    <script type="text/javascript">
    // <![CDATA[
            /**
            * New pop-up functions
            * based on  http://yensdesign.com/2008/09/how-to-create-a-stunning-and-smooth-popup-using-jquery/
            */

            //SETTING UP OUR POPUP
            //0 means disabled; 1 means enabled;
            var popupStatus = 0;
            var openPopup = '';

            //loading popup with jQuery magic!
            function loadPopup()

            {
               //loads popup only if it is disabled
               if(popupStatus==0)
               {
                  $('#backgroundPopup').css({'opacity': '0.7'});
                  // Now let's make sure we actually see the image
                  var scroll = $(window).scrollTop();
                  $('#popupPM').animate({marginTop: scroll}, 'fast', function() {
                     // Animation complete.
                     });
                  $('#backgroundPopup').fadeIn('slow');
                  $('#popupPM').fadeIn('slow');
                  popupStatus = 1;
                  openPopup = 'PM';
               }
            }

            //disabling popup with jQuery magic!
            function disablePopup()
            {
               //disables popup only if it is enabled
               if(popupStatus==1 && openPopup == 'PM')
               {
                  $('#backgroundPopup').fadeOut('slow');
                  $('#popupPM').fadeOut('slow');
                  popupStatus = 0;
                  openPopup = '';
               }
            }

            //centering popup
            function centerPopup()
            {
               //request data for centering
               var windowWidth = document.documentElement.clientWidth;
               var windowHeight = document.documentElement.clientHeight;
               var popupHeight = $('#popupPM').height();
               var popupWidth = $('#popupPM').width();
               //centering
               $('#popupPM').css({
               'position': 'absolute',
               'top': windowHeight/2-popupHeight/2,
               'left': windowWidth/2-popupWidth/2
               });
               //only need force for IE6
               $('#backgroundPopup').css({'height': windowHeight});
            }

            $(document).ready(function(){
               <!-- IF S_USER_PM_POPUP -->   
               if({S_NEW_PM})
               {
                  //centering with css
                  centerPopup();
                  //load popup
                  loadPopup();
               }
               <!-- ENDIF -->
               <!-- IF S_VIEWTOPIC -->
               resize_images();
               <!-- ENDIF -->
               
               // IE6 and below PNG fix (not really)
               if(is_ie6)
               {
                  replace_png();
               }
               
               //CLOSING POPUP
               //Click the x event!
               $('#popupPMClose').click(function(){
                  disablePopup();
               });
               //Click out event!
               $('#backgroundPopup').click(function(){
                  disablePopup();
                  disableImage();
               });
               //Press Escape event!
               $(document).keypress(function(e){
                  if(e.keyCode==27 && popupStatus==1)
                  {
                     disablePopup();
                     disableImage();
                  }
               });
               
               <!-- IF S_VIEWTOPIC -->
               // Image popup
               $('img', 'dt.attach-image').click(function(){
                  image_load($(this).attr('src'), $(this).attr('alt'));
                  centerImage();
               });
               
               $('.content img').click(function(){
                  var check = $(this).parent().hasClass('content');
                  if(check)
                  {
                     image_load($(this).attr('src'), $(this).attr('alt'));
                     centerImage();
                  }
               });
               
               // Closing Image popup
               //Click the x event!
               $('#popupImageClose').click(function(){
                  disableImage();
               });
               
               //Click image box event
               $('#popupImage').click(function(){
                  disableImage();
               });
               
               //Click image event
               $('#ImagePopup img').click(function(){
                  disableImage();
               });
               <!-- ENDIF -->

            });

            /**
            * Replaces weird looking PNG files with the respectie GIF file
            * Only run this if the browser is IE6 or below
            */
            function replace_png()
            {
               // Fix Logo
               var str = $('#logo img').attr('src');
               $('#logo img').attr('src', str.substring(0, str.length - 3) + 'gif');
               
               // Fix forum icons
               $('dl.icon').each(function() {
                  var str = $(this).css('background-image');
                  if(str != '')
                  {
                     $(this).css('background-image', str.substring(0, str.length - 5) + 'gif")');
                  }
               });
            }

            <!-- IF S_VIEWTOPIC -->
            /**
            * Image resizer
            */
            function resize_images()
            {
               var hello = $('dl.attachbox dd dl.file dt.attach-image img').innerWidth();
               var maxWidth = $('div.content').innerWidth() - 30;
               
               // resize the attached images
               $('img', 'dt.attach-image').each(function(i){
                  // check the width of the image
                  if ($(this).width() > maxWidth)
                  {
                     // calculate new image dimensions
                     newWidth = maxWidth;
                     newHeight = $(this).height() / ( $(this).width() / maxWidth );
                       
                     // set new image dimensions
                     $(this).height(newHeight).width(newWidth);
                  }
               });
               
               // resize the images that were added via [img] bbcode
               $('img', 'div.content').each(function(i){
                  // check the width of the image
                  $(this).css('max-width', maxWidth); // fix for IE
                  if ($(this).width() > maxWidth)
                  {
                     // calculate new image dimensions
                     newWidth = maxWidth;
                     newHeight = $(this).height() / ( $(this).width() / maxWidth );
                       
                     // set new image dimensions
                     $(this).height(newHeight).width(newWidth);
                  }
               });
            }

            /**
            * Image pop-up
            */
            function image_load(src, alt)
            {
               //loads popup only if it is disabled
               if(popupStatus==0)
               {
                  $('#ImagePopup').html('<img id="imgpopup" src="' + src + '" alt="' + alt + '" />');
                  var windowWidth = document.documentElement.clientWidth;
                  var windowHeight = document.documentElement.clientHeight;
                  var maxWidth = windowWidth * 0.85;
                  var maxHeight = windowHeight * 0.85;
                  $('#popupImage img').css('max-width', maxWidth);
                  $('#popupImage img').css('max-height', maxHeight);
                  $('#backgroundPopup').css({'opacity': '0.7'});
                  // Now let's make sure we actually see the image
                  var scroll = $(window).scrollTop();
                  $('#popupImage').animate({marginTop: scroll}, 'fast', function() {
                     // Animation complete.
                     });
                  $('#backgroundPopup').fadeIn('slow');
                  $('#popupImage').fadeIn('slow');
                  popupStatus = 1;
                  openPopup = 'Image';
               }
            }

            //centering popup
            function centerImage()
            {
               //request data for centering
               var windowWidth = document.documentElement.clientWidth;
               var windowHeight = document.documentElement.clientHeight;
               var popupHeight = $('#popupImage').height();
               var popupWidth = $('#popupImage').width();
               var newTop = windowHeight/2-popupHeight/2;
               var newLeft = windowWidth/2-popupWidth/2;
               //centering
               $('#popupImage').css({
               'position': 'absolute',
               'top': newTop,
               'left': newLeft
               });
               
               //only need force for IE6
               $('#backgroundPopup').css({'height': windowHeight});
            }

            //disabling popup with jQuery magic!
            function disableImage()
            {
               //disables popup only if it is enabled
               if(popupStatus==1 && openPopup == 'Image')
               {
                  $('#backgroundPopup').fadeOut('slow');
                  $('#popupImage').fadeOut('slow');
                  popupStatus = 0;
                  openPopup = '';
               }
            }
            <!-- ENDIF -->
    // ]]>

    </script>

	<!-- effortless script below -->
	<script type="text/javascript">
	    jQuery(document).ready(function(){
	        jQuery('#backtotop a').click(function(){
	            jQuery('html, body').animate({scrollTop:0}, 'slow');
	            return false;
	        });
	    });
	</script>
    <script type="text/javascript" src="{T_TEMPLATE_PATH}/move.js"></script>
    <!-- IF S_MCHAT_ENABLE and (S_MCHAT_ON_INDEX or U_MCHAT) -->
    <script type="text/javascript" src="{ROOT_PATH}mchat/jquery-1.5.0.min.js"></script>
    <script type="text/javascript" src="{ROOT_PATH}mchat/jquery.titlealert.min.js"></script>
    <script type="text/javascript" src="{ROOT_PATH}mchat/jquery_cookie_mini.js"></script>
    <!-- ENDIF -->
    <script type="text/javascript" src="src/swfobject.js"></script>

    </head>

            <body id="phpbb" class="section-{SCRIPT_NAME} {S_CONTENT_DIRECTION}">
                <div id="loader">
       <span>Laden van pagina.. Even geduld aub..</span>
    </div>

            <!--- box border START -->
            <div id="box">
            <div class="top-left"></div><div class="top-center"></div><div class="top-right"></div>
            <div id="left-border">
            <div id="right-border">

            <!--- box border END -->
            <div class="inside">
            <div class="notopgap">
            <div id="wrap">
               <a id="top" name="top" accesskey="t"></a>
               <div id="page-header">
                  <div class="headerbar">
                     <div class="inner"><span class="corners-top"><span></span></span>
                            <div class="menu-block" style="float: {S_CONTENT_FLOW_END}; width: 19%;">
                          <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
                         <div class="menu-row-first"><a class="left menu-link" href="http://www.presents4you.net/arcade.php">Spelletjes</a></div>
                         <div class="menu-row"><a class="left menu-link" href="http://www.presents4you.net/knuffel.php">yahtzee</a></div>
                         <div class="menu-row"><a class="left menu-link" href="http://www.presents4you.net/youtube.php">Youtube</a></div>
                         <div class="menu-row"><a class="left menu-link" href="{U_SMILIESPAGE}" title="{L_SMSMILIES}">{L_SMSMILIES}</a></div>
                         <div class="menu-row"><a class="left menu-link" href="{U_RANKSPAGE}" title="{L_RARANKS}">{L_RARANKS}</a></div>
                         <!-- ENDIF -->
                         <div class="menu-row-last"><a class="left menu-link" href="{U_LOGIN_LOGOUT}" title="{L_LOGIN_LOGOUT}" accesskey="x">{L_LOGIN_LOGOUT}</a></div>
                      </div>
                      <div style="float: {S_CONTENT_FLOW_BEGIN}; width: 79.5%;">
                     <div style="height: 140px ;">
                     <div id="site-description">
                        <div class="header-pad"><a href="{U_INDEX}" title="{L_INDEX}" id="logo">{SITE_LOGO_IMG}</a></div>
                     
                        <p class="site-desc">{SITE_DESCRIPTION}</p>
                        <p class="skiplink"><a href="#start_here">{L_SKIP}</a></p>
                     </div>

            </div>
                </div>

                     <span class="corners-bottom"><span></span></span></div>
                  </div>

                  <div class="navbar">
                     <div class="inner"><span class="corners-top"><span></span></span>

                     <ul class="linklist navlinks">

                        <li class="icon-home"><a href="{U_INDEX}" accesskey="h">{L_INDEX}</a> <!-- BEGIN navlinks --> <strong>&#8249;</strong> <a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks --></li>
                                  <!-- IF S_DISPLAY_SEARCH and not S_IN_SEARCH -->
                        <li class="rightside">
                        <form action="{U_SEARCH}" method="post" id="search">
                        <fieldset>
            <input name="search_id" id="search_id" type="hidden" value="speedsearch" />
                           <input name="zoekwoorden" id="zoekwoorden" type="text" maxlength="128" title="{L_SEARCH_KEYWORDS}" class="inputbox search" value="<!-- IF SEARCH_WORDS-->{SEARCH_WORDS}<!-- ELSE -->{L_SEARCH_MINI}<!-- ENDIF -->" onclick="if(this.value=='{LA_SEARCH_MINI}')this.value='';" onblur="if(this.value=='')this.value='{LA_SEARCH_MINI}';" />
            <br />
                            {S_SEARCH_HIDDEN_FIELDS}
                        </fieldset>
                        </form>
            </li>
                  <!-- ENDIF -->
                         
                     </ul>

                     <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
                     <ul class="linklist leftside">

                        <li class="icon-ucp">
                           [<a href="{U_PROFILE}" title="{L_PROFILE}" accesskey="e">{L_PROFILE}</a>]
                              <!-- IF S_DISPLAY_PM --> [<a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a>]<!-- ENDIF -->
                           <!-- IF U_RESTORE_PERMISSIONS --> &bull;
                           <a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a>
                           <!-- ENDIF -->
                        </li>
                     </ul>
                     <!-- ENDIF -->

    <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
    <ul class="linklist rightside">
    <li class="icon-rss"><a href="http://www.solidjeuhforumradio.be/player/index.html" target="_blank" onclick="popup(this.href, 960, 282, 'Ultratop 50 mp3 speler'); return false;"> P4Y Music Player</a></li>
       <!-- Start Ultimate Points -->
       <!-- IF S_POINTS_ENABLE -->
       <li class="icon-faq"><a href="{U_POINTS}" title="{L_POINTS_EXPLAIN}">{POINTS_LINK}<!-- IF S_USER_LOGGED_IN and S_USE_POINTS --> [ {USER_POINTS} ] <!-- ENDIF --></a></li>
       <!-- ENDIF -->
       <!-- End Ultimate Points -->

       <li class="icon-faq"><a href="{U_SHOP}" title="{L_UPS_EASY_SHOP}">{SHOP_LINK}</a></li>
       <!-- IF S_DISPLAY_INVITE -->                                                 
       <li class="icon-faq"><a href="{U_INVITE_A_FRIEND}"><strong>{L_ACP_INVITE}</strong></a></li>
       <!-- ENDIF -->
       <li class="icon-rss"><a class="Donatie" href="http://www.presents4you.net/donate/index.php"><strong><span class="stijl1">Donatie</span></strong></a></li>

       <li class="icon-rss"><a href="{U_NEWSLETTER}" title="{L_NEWSLETTER_EXPLAIN}">{L_NEWSLETTER}</a></li>

       <li class="icon-faq"><a class="Zoeken" href="http://www.presents4you.net/search.php"><span>Zoeken</span></a></li>
       <!-- IF S_DISPLAY_MEMBERLIST --><li class="icon-faq"><a href="{U_MEMBERLIST}" title="{L_MEMBERLIST_EXPLAIN}">{L_MEMBERLIST}</a></li><!-- ENDIF -->
       <!-- IF S_DISPLAY_TOPLIST --><li class="icon-thanks_toplist"><a href="{U_REPUT_TOPLIST}" title="{L_REPUT_TOPLIST}">{L_REPUT_TOPLIST}</a></li><!-- ENDIF -->
       <!-- IF S_DISPLAY_THANKSLIST --><li class="icon-thanks"><a href="{U_THANKSLIST}" title="{L_THANKS_USER}">{L_GRATITUDES}</a></li><!-- ENDIF -->
    </ul>
    <!-- ENDIF -->

                     <span class="corners-bottom"><span></span></span></div>
                  </div>
                           

               </div>
               <!-- IF not S_IS_BOT and S_USER_LOGGED_IN -->
<div id="backtotop">
<a href="#start_here"><img src="http://www.presents4you.net/backtotop/images/back_to_top_btn.png" alt="Back to TOP" /></a>
</div>
<div id="supportus">
<a href="http://www.presents4you.net/donate/index.php"><img src="http://www.presents4you.net/images/support-us.png" alt="Support" /></a>
</div>
<!-- ENDIF -->

               <a name="start_here"></a>
               <div id="page-body">
                           <!-- IF S_USER_UNREAD_PRIVMSG -->
                      <div id="message" class="rules">
                         <div class="inner"><span class="corners-top"><span></span></span>
                            <strong>{L_INFORMATION}:</strong> {L_NEW_PM_NOTICE} - Klik <a href="{U_PRIVATEMSGS}">hier</a> om naar jou inbox te gaan.
                         <span class="corners-bottom"><span></span></span></div>
                      </div>
                      <!-- ENDIF -->
                  <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN and (U_MCP or U_ACP) -->
                  <div id="information" class="rules">
                     <div class="inner"><span class="corners-top"><span></span></span>
                        <strong>{L_INFORMATION}:</strong> {L_BOARD_DISABLED}
                     <span class="corners-bottom"><span></span></span></div>
                  </div>
                  <!-- ENDIF -->
                    <!-- INCLUDE arcade/arcade_info_body.html -->
                    <!-- INCLUDE announcement_centre.html -->


SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 07:56
by Stoker
You have a heavily modded index file so its hard to tell the exact error.
We will have to try some different things then.

Remove this from the Top Five:

Code: Select all

//-- mod: top five ---------------------------------------------------------//
   include($phpbb_root_path . 'includes/top_five.' . $phpEx);
//-- end: top five ---------------------------------------------------------//
Try disable one feature at the time for testing in the ACP for Top Stats.
Speciel the most active users part.

SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 08:13
by Solidjeuh
Also not working .. I just disabled 1 mod at the time, But still don't get it to work ..
tried to set all options to 'NO' in the top stats mod, then the index page is working.
When I set 1 option to 'YES' the error is back .. no matter what option .. tried them all

SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 08:17
by Stoker
You can try remove one mod at the time from index.php and see if it helps.
Else you have to PM me admin and ftp access to the board where you have the problem.
Then I will take a look later today.

SQL ERROR [ mysqli ]

Posted: 16 Nov 2011, 20:39
by Solidjeuh
I removed the mod .. No offense, It's a great mod!
But like you said, My forum is to heavily modded ..
I spend whole day to find out what's wrong, Also a friend of me ( works with php stuff and build website's)
And even he could not find out what's wrong ..

So it's better to just remove the mod, It's not really needed on my forum :)
But Thx 4 the help!!

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:06
by Stoker
BTW, you can read 4_sevens solution to the bug here: http://www.phpbb.com/community/viewtopi ... &t=2138340

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:26
by Solidjeuh
4_seven wrote:open

includes/functions_top_stats.php

find

Code: Select all

// Recent Active Topics
if (isset($config['tsrat_enable']) && $config['tsrat_enable'] == 1)
{	
after add

Code: Select all

if (!isset($flist)){
$flist = array(0);}
This? just installed the mod again.. still the same error..

SQL ERROR [ mysqli ]

Posted: 17 Nov 2011, 08:35
by Stoker
Did you do the suggested edit?