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.phpCode: 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;
?>