Последни теми от форума (4 скрипта)

СКРИПТ 1

$connection = mysql_connect("localhost", "user", "pass");
$db = mysql_select_db("dbname", $connection);


$query = mysql_query("select * from phpbb_topics order by topic_time desc limit 0,30");
while($rows = mysql_fetch_array($query))
{
$qry = mysql_query("select * from phpbb_forums where forum_id='$rows[forum_id]'");
$rwz = mysql_fetch_array($qry);
$forum = $rwz[forum_name];
$catid = $rwz[cat_id];
$qry2 = mysql_query("select * from phpbb_categories where cat_id='$catid'");
$rwz2 = mysql_fetch_array($qry2);
$cat = $rwz2[cat_title];
echo "<font face=\"Verdana\" color=\"#006699\" size=\"2\"><a href=\"link kum foruma/viewtopic.php?t=".$rows[topic_id]."\">$cat: $rows[topic_title]</a></front> ($rows[topic_replies])<br/>\n";
}

?>

СКРИПТ 2

<?
$address = "http://83.148.117.25/phpbb/"; //адрес на форума без /
$host = "localhost"; //db host, localhost?
$user = "user"; //db user
$pass = "pass"; //db secret
$db = "dbname"; //forum database
$table = "phpbb_topics"; //topics table for PhpBB
$show = "10"; //number of posts to show
$link = mysql_pconnect($host, $user, $pass) or die('Error connecting to mysql host!');
$db = mysql_select_db($db) or die('Error selecting database!');
$query = "select * from $table order by topic_time desc limit 0,$show";
$result = mysql_query($query, $link);

while ($row=mysql_fetch_row($result))
{
echo " :: <a href='link kum foruma/viewtopic.php?t=$row[0]' target=_blank>$row[2] </a><br/>";
}
?>

СКРИПТ 3

<?php
/*** phpBB - Last Topics System ***/

//------------------------------
//Edit this parameters:

//MySQL server adress
$host="localhost";

//Username
$user="user";

//Password
$pass="pass";

//Database
$db="dbname";

//Table Prefix
$table="phpbb_topics";

//kolko temi da izkarva
$latest="10";

//-------------------------- END



//------------------------------
//Don't edit !

$link=mysql_connect($host, $user, $pass);
$db=mysql_select_db($db);
$query="select * from $table order by topic_time desc limit 0,$latest";
$result=mysql_query($query, $link);
while ($row=mysql_fetch_row($result)) {
echo "<a href='link kum foruma/viewtopic.php?t=$row[0]' target='_blank'>$row[2]</a><br>";
}

//-------------------------- END

?>

СКРИПТ 4

<LiNk Rel="stylesheet" type="text/css" href="style.css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<body bgcolor="#FF0000">
<style>
<!--


body
{ background-color: #000000; font-style:verdana; font-size:13px;



scrollbar-face-color: 666666;
scrollbar-track-color: 000000;
scrollbar-arrow-color: 000000;
scrollbar-base-color: 666666;
scrollbar-darkshadow-color: 000000;
scrollbar-shadow-color: 666666;
scrollbar-highlight-color: 000000; }

<!--
BODY{
CURSOR: url(cursor2.cur);
}
-->

BODY {
FONT-SIZE: 9pt; COLOR: #FF0000; FONT-FAMILY: Verdana, Arial, Geneva, Helvetica, sans-serif
}
A:link { COLOR: #999999; TEXT-DECORATION: none } A:hover { COLOR: #000066; TEXT-DECORATION: none } A:visited { COLOR: #999999; TEXT-DECORATION: none }

A:hover { COLOR: #666666; TEXT-DECORATION: none } INPUT {
BORDER-RIGHT: #666666 1px solid; BORDER-TOP: #666666 1px solid; FONT-SIZE: 10px; BORDER-LEFT: #666666 10px solid; COLOR: #FF0000; BORDER-BOTTOM: #666666 1px solid; FONT-FAMILY: "Verdana"
</style>
<?
$address = "http://213.240.243.72/forum/"; //forum url without /
$host = "localhost"; //db host, localhost?
$user = "user"; //db user
$pass = "pass"; //db secret
$db = "dbname"; //forum database
$table = "phpbb_topics"; //topics table for PhpBB
$show = "15"; //number of posts to show
$link = mysql_pconnect($host, $user, $pass) or die('Error connecting to mysql host!');
$db = mysql_select_db($db) or die('Error selecting database!');
$query = "select * from $table order by topic_time desc limit 0,$show";
$result = mysql_query($query, $link);

while ($row=mysql_fetch_row($result))
{
echo "·<a href='$addresslink kum foruma/viewtopic.php?t=$row[0]' target=_blank>$row[2]</a> <font color=#9B9765><b>(</b>$row[6]<b>)</font></b><br/>";
}
?>