Самият ерор:
Код за потвърждение: Избери целия код
[phpBB Debug] PHP Warning: in file /home/test/public_html/inc/lastforum.php on line 46: mysqli_query(): Empty query
Код за потвърждение: Избери целия код
<?php
/*
* [PHPBB 3.0.x/3.1.x/3.2.x] Последни теми от форума
*
* @author hackera457
*/
//////////////////////Настройки//////////////////////
define('SQL_HOST','localhost'); // MySQL хост
define('SQL_USER','test_site'); //MySQL потребител
define('SQL_PASS','test123'); //MySQL парола
define('SQL_DB','test_site'); //MySQL база данни
define('SQL_TABLE_PREFIX','phpbb'); //Префикс на таблиците
define('PHPBB_FORUM_PATH','../forum'); //Пълния път до папката на форума
define('PHPBB_TOPICS_COUNT_SHOW',5); //По колко теми да се изкарват
define('PHPBB_VERSION','3.2'); //Версия на PHPBB 3.0/3.1/3.2
//////////////////////Край на настройки//////////////////////
$mysqli = mysqli_connect(SQL_HOST,SQL_USER,SQL_PASS,SQL_DB);
if(!$mysqli)
{
exit('Възникна проблем при опита за връзка с базата данни!');
}
mysqli_set_charset($mysqli,"utf8");
switch(PHPBB_VERSION)
{
case '3.2':
case '3.1':
{
$sql = "SELECT * FROM `".SQL_TABLE_PREFIX."_topics` WHERE topic_posts_approved >= '1' ORDER BY `topic_time` DESC LIMIT 0,".PHPBB_TOPICS_COUNT_SHOW."";
break;
}
case '3.0':
{
$sql = "SELECT * FROM `".SQL_TABLE_PREFIX."_topics` WHERE `topic_approved` = '1' ORDER BY `topic_time` DESC LIMIT 0,".PHPBB_TOPICS_COUNT_SHOW."";
break;
}
}
$query = mysqli_query($mysqli,$sql) or die(mysqli_error($mysqli));
echo "<table style=' width: 100%; font-family: Verdana; margin-top: -5px; font-size: 11px; border-collapse: collapse;'>
<tr style='height: 30px; '>
<td style='border-bottom: 2px solid #dcdcdc;height: 22px; text-align: center;color:#666; width:50%;'><b>Тема</b></td>
<td style='border-bottom: 2px solid #dcdcdc;height: 22px; text-align: center;color:#666; width:10%;'><b>Прегледана</b></td>
<td style=' border-bottom: 2px solid #dcdcdc;height: 22px; text-align: center;color:#666; width:30%;'><b>Последно отговорил</b></td>
</td>
</tr>
";
if($query)
{
echo "
<table class='list1' style='font-size:12px; text-align:center; border-collapse: collapse; cellpadding='0' cellspacing='2' width='100%' border='0'>
";
while($row = mysqli_fetch_assoc($query))
{
$topic_id = $row['topic_id'];
$topic_title = $row['topic_title'];
$topic_first_poster = $row['topic_first_poster_name'];
$topic_first_poster_color = $row['topic_first_poster_colour'];
$topic_last_poster = $row['topic_last_poster_name'];
$topic_last_poster_color = $row['topic_last_poster_colour'];
$topic_views = $row['topic_views'];
echo "<tr style='height: 30px; font-size: 11px; '>
<td style=' text-align: left; border-bottom: 1px solid #dcdcdc; width: 50%;padding: 5px;'>
<a href='".PHPBB_FORUM_PATH."/viewtopic.php?f=".$row['forum_id']."&t=".$topic_id."'>".$topic_title."</td>
<td style='text-align: center;border-bottom: 1px solid #dcdcdc; font-weight: bold; width:10%; '>".$topic_views."</td>
<td style=' text-align: center; border-bottom: 1px solid #dcdcdc; width:30%;'><font color='".$topic_last_poster_color."'>".$topic_last_poster."</font></td></tr>";
}
}
echo "</table>";
mysqli_close($mysqli);
?>
Код за потвърждение: Избери целия код
$query = mysqli_query($mysqli,$sql) or die(mysqli_error($mysqli));