- usunąc kategorie
- date
za każdym razem jak usuwam to wyskauje mi błąd, pomoże ktoś?
skrypt można zobaczyć na samym dole pod stopką na stronie http://www.kukow.pl
Kod: Zaznacz cały
<?
/*** phpBB3 - Last Active Topics System ***/
//MySQL server adress
$host="xxx";
//Username
$user="xxx";
//Password
$pass="xxx";
//Database
$db="xxx";
//Table prefix
$table="phpbb_forum";
//Show last x topics
$laforums="5";
$link=mysql_connect($host, $user, $pass);
$db=mysql_select_db($db);
$query="select * from $table".topics." WHERE topic_approved = '1' order by topic_last_post_time
desc limit 0,$laforums";
$query2="select config_name,config_value from $table".config." where config_name = 'server_name'
limit 0,1";
$result2=mysql_query($query2);
$row2 = mysql_fetch_array($result2);
extract($row2);
$result=mysql_query($query);
while ($row=mysql_fetch_array($result)) {
extract($row);
$date = date("d.m.Y", $topic_last_post_time);
$query3="select forum_name from $table".forums." WHERE forum_id = ".$forum_id."";
$result3=mysql_query($query3);
$row2 = mysql_fetch_array($result3);
echo "<a href='http://".$config_value."/phpBB3/viewforum.php?f=".$forum_id."'
target='_blank'>".$row2[forum_name].":</a> <a
href='http://".$config_value."/phpBB3/viewtopic.php?f=".$forum_id."&t=".$topic_id."'
target='_blank'>".$topic_title."</a><br> odpowiedzi: ".$topic_replies."</font>,<br>ostatni post:
".$topic_last_poster_name.",<br> dodano: ".$date."<br>\n";
}
//-------------------------- END
?>