phpBB.de

Code: Alles auswählen

Could not obtain amazonbox information

DEBUG MODE

SQL Error : 1064 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 '' at line 1

SELECT word, replacement FROM phpbb_amazonbox ORDER BY RAND() LIMIT

Line : 78
File : page_tail.php

Code: Alles auswählen

<?php
/***************************************************************************
 *                              page_tail.php
 *                            -------------------
 *   begin                : Saturday, Feb 13, 2001
 *   copyright            : (C) 2001 The phpBB Group
 *   email                : support@phpbb.com
 *
 *   $Id: page_tail.php,v 1.27.2.4 2005/09/14 18:14:30 acydburn Exp $
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

if ( !defined('IN_PHPBB') )
{
	die('Hacking attempt');
}

global $do_gzip_compress;

//
// Show the overall footer.
//
// Anti Bot Question Mod - Start
if (($abq_config['abq_register']) || ($abq_config['abq_guest']))
{
	$abq_footer = $lang['ABQ_Footer'];
	if ($abq_config['show_counter'] == 1)
	{
		$abq_footer .= sprintf($lang['ABQ_Footer_Counter1'], ($abq_config['counter_vari'] + $abq_config['counter_quest_reg']));
	}
	elseif ($abq_config['show_counter'] == 2)
	{
		$abq_footer .= sprintf($lang['ABQ_Footer_Counter2'], ($abq_config['counter_vari'] + $abq_config['counter_quest_reg']), $abq_config['counter_quest_post']);
	}
	elseif ($abq_config['show_counter'] == 3)
	{
		$abq_footer .= sprintf($lang['ABQ_Footer_Counter3'], $abq_config['counter_quest_post']);
	}
	$template->assign_block_vars('switch_abq_footer', array());
	$template->assign_vars(array(
		'ABQ_FOOTER' => $abq_footer)
	);
}
// Anti Bot Question Mod - End
$admin_link = ( $userdata['user_level'] == ADMIN ) ? '<a href="admin/index.' . $phpEx . '?sid=' . $userdata['session_id'] . '">' . $lang['Admin_panel'] . '</a><br /><br />' : '';

$template->set_filenames(array(
	'overall_footer' => ( empty($gen_simple_header) ) ? 'overall_footer.tpl' : 'simple_footer.tpl')
);

if( !preg_match('#href="http://www.seo-phpbb.org#', $lang['TRANSLATION_INFO']))
{
	$lang['TRANSLATION_INFO'] = '<a href="http://www.seo-phpbb.org/" target="_blank">SEO</a> phpBB powered by <a href="http://www.gameserveradmin.de/" target="_blank">Gameserver</a> Forum';
}

$template->assign_vars(array(
        'AmazonBox' => $lang['AmazonBox'],
        'amazonbox_limit' => $board_config['amazonbox_limit'],
	'TRANSLATION_INFO' => (isset($lang['TRANSLATION_INFO'])) ? $lang['TRANSLATION_INFO'] : ((isset($lang['TRANSLATION'])) ? $lang['TRANSLATION'] : ''),
	'ADMIN_LINK' => $admin_link)
);

// AMAZON BOX START
$amazonbox_limit = $board_config['amazonbox_limit'];
    $sql = "SELECT word, replacement FROM " . AMAZONBOX_TABLE . " ORDER BY RAND() LIMIT " . $amazonbox_limit;
    if ( !($result = $db->sql_query($sql)) )
    {
            message_die(GENERAL_ERROR, 'Could not obtain amazonbox information', '', __LINE__, __FILE__, $sql);
    }
    while ($row = $db->sql_fetchrow($result))
    {
    $word = $row['word'];
    $replacement = $row['replacement'];
            $template->assign_block_vars("amazonbox", array(
            'word' => $word,
            'AmazonImg' => $replacement,
            "AmazonLink" => "http://www.amazon.de/exec/obidos/ASIN/" . $replacement . "/" . $board_config['amazonbox_partnerid']
            ));
    }
// AMAZON BOX END

$template->pparse('overall_footer');

//
// Close our DB connection.
//
$db->sql_close();

//
// Compress buffered output if required and send to browser
//
if ( $do_gzip_compress )
{
	//
	// Borrowed from php.net!
	//
	$gzip_contents = ob_get_contents();
	ob_end_clean();

	$gzip_size = strlen($gzip_contents);
	$gzip_crc = crc32($gzip_contents);

	$gzip_contents = gzcompress($gzip_contents, 9);
	$gzip_contents = substr($gzip_contents, 0, strlen($gzip_contents) - 4);

	echo "\x1f\x8b\x08\x00\x00\x00\x00\x00";
	echo $gzip_contents;
	echo pack('V', $gzip_crc);
	echo pack('V', $gzip_size);
}

exit;

?>