<?php
$link = mysql_connect('localhost', 'root', 'pass');
$query="SELECT * FROM phpbb_topics
WHERE forum_id=1 ORDER BY topic_time DESC";
$db_selected = mysql_select_db('fifa', $link);
mysql_query("SET NAMES latin1",$link);
if(!isset($_GET['start']))
{
$start=0;} else
{$start=$_GET['start'];}
$result = mysql_query($query)OR Die(Mysql_Error());
for ( $i = 1; $i <= $start; $i += 1){
$row = mysql_fetch_array( $result );}
for ( $i = 1; $i <= 5; $i += 1){
if ($row = mysql_fetch_array( $result )){
$dateden = date("j", $row['topic_time']);
$datemes = date("n", $row['topic_time']);
$dategod = date("y", $row['topic_time']);
echo('<div class="newstitle">' . $row['topic_title'] . '</div>');
echo('<div class="newsdate">Публикувано на ' . $dateden . '.' . $datemes . '.' . $dategod . ' от ');
$query2="SELECT * FROM phpbb_users
WHERE user_id=" . $row['topic_poster'];
$result2 = mysql_query($query2);
$row2 = mysql_fetch_array( $result2 );
echo($row2['username'] . '</div><div class="newstext">');
$query3="SELECT * FROM phpbb_posts_text
WHERE post_id=" . $row['topic_first_post_id'];
$result3 = mysql_query($query3);
$row3= mysql_fetch_array( $result3 );
echo($row3['post_text']);
echo("<br/>");
echo('</div><div class="newscomments"><a target="_blank" class="newslink" href="http://87.116.71.26/fifa/posting.php?mode=reply&t=' . $row['topic_id'] . '">Коментари [' . $row['topic_replies'] . ']</a>' . '</div><br/><br/>');
}}
$i=0;
while($row = mysql_fetch_array( $result )) {$i+=1;}
if($i%10 == 0) {$pagesleft=$i/10;} else {$pagesleft=intval($i/10)+1;}
$pagespass=intval($start/10);
$nowpage=intval(($start/10)+1);
echo('<div id="newspages">Страница: ');
if($pagespass > 1) echo('<a target="_self" class="mainlink" href="?page=1&start=0">Първа << </a>');
if($pagespass >= 1) echo('<a target="_self" class="mainlink" href="?page=1&start=' . ($start-10) . '"> Предишна < </a>');
echo($nowpage);
if($pagesleft >= 1) echo('<a target="_self" class="mainlink" href="?page=1&start=' . ($start+10) . '"> > Следваща</a>');
if($pagesleft > 1) echo('<a target="_self" class="mainlink" href="?page=1&start=' . ($start+($pagesleft*10)) . '"> >> Последна</a>');
echo('</div>');
?>
