<!----Vidus---->
<td valign="top" width="100%">
<div class="r_col_wrap">
     <div class="r_col_top">Новости</div>
     <div class="r_col_content">

<?php
$forums = "http://localhost/f"; // noraadam adresi uz forumu
$limits = "5"; // topiku limits jaunumos
$zinas = "8"; // forums no kura velkam aaraa jaunumus
$host = "localhost"; // hosts, parasti localhost
$dbname = "forum"; // foruma db
$dbuser = "root"; // foruma db useris
$dbpass = ""; // foruma db parole

$link = mysql_connect($host, $dbuser, $dbpass)

or die("Неполучилось подконектится к MySQL: " . mysql_error());

mysql_select_db($dbname) or die("Базы данных не существует");

mysql_query("SET NAMES utf8");

$kverisdivi = mysql_query("SELECT * FROM ibf_topics WHERE forum_id=".$zinas." ORDER BY start_date DESC LIMIT ".$limits."");

while($row = mysql_fetch_array( $kverisdivi )) {

$rowis = mysql_fetch_array( mysql_query("SELECT * FROM ibf_posts WHERE topic_id = ".$row['tid']." ORDER by post_date LIMIT ".$limits.""));

$datums = $row['start_date'];

$piev_datums = date("d.m.Y H:i",$datums);

echo "<center><strong>".$row['title']."</strong></center>
";

echo "<div>".$rowis['post']."</div>
";

echo "<div>         $piev_datums                 <u>Комментариев: (<a href=\"$forums/index.php?showtopic=".$row['tid']."&view=getlastpost\">".$row['posts']."</a>)</u>                  Добавил: ".$row['starter_name']."<hr />
";

echo "";

}
?>

<?php
//Vajadzīga palīdzība, greizies "http://uoc.lv/" forumā sadaļā "Problēmas un Risinājumi"
   
//Iestatījumi
include_once('forum/conf_global.php'); //Ceļš uz foruma konfigurācijas failu.
define('WWW','adrese/'); //Mājaslapas tiešā adrese.
define('COUNT',10); //Cik jaunumi tiks izvadīti.
define('FORUM',2); //Foruma id no kura tiks izvadīti jaunumus.
   
$news = '';
   
$link = mysql_connect($INFO['sql_host'],$INFO['sql_user'],$INFO['sql_pass']);
mysql_query('use '.$INFO['sql_database'].';');
   
$result = mysql_query('select t1.tid,t1.title,t1.start_date,t1.starter_name,t1.posts,t2.post from '.$INFO['sql_tbl_prefix'].'topics t1 join '.$INFO['sql_tbl_prefix'].'posts t2 on (t1.tid = t2.topic_id) where t1.forum_id = '.FORUM.' group by t1.tid order by t1.start_date desc limit '.COUNT.';');
if (!empty($result)) {
while ($r = mysql_fetch_array($result)) {
//Izvades bloks
$news .='<a href="'.WWW.'forum/index.php?showtopic='.$r[0].'">'.$r[1].'</a><br/>'; //Jaunuma nosaukums un links uz forumu.
$news .=$r[5].'<br/>'; //Jaunuma teksts.
$news .=$r[3].' '.date('Y.m.d.', $r[2]).' Komentāri('.$r[4].')<br/>'; //Autors un ievietošanas datums.
$news .='<hr/>'; //Atdalam ziņas ar horizontālu līniju.
}
} else {
$news = 'Ziņu ieraksti nav atrasti'; //Forumā nav ziņu ierakstu, vai ir notikusi kļūme!
}
   
echo $news;
mysql_close($link);
?>

<?php

/*
  * Ziņu saraksts no IPB 3.2.X (pielāgojams arī citām versijām)
  *
  * (c) Maadinsh, 2012 - http://coding.lv/read/zinu-skripts-ipb-3-2-x
  *
  * Izmanto pēc saviem ieskatiem, tikai lūdzu atstāj šo atsauci izplatot tālāk :)
  *
  */

//ja conf_global.php atrodas citā mepē, izmaini ceļu šeit
include_once('conf_global.php');

$forum_id = '2'; //no kuras foruma sadaļas ņemt ziņas

$db = new mysqli($INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass'], $INFO['sql_database']);

//LIMIT norāda ziņu skaitu
$topics = $db->query("SELECT
         `topic`.`start_date`,
         `topic`.`title`,
         `topic`.`starter_name`,
         `topic`.`posts`,
         `topic`.`title_seo`,
         `topic`.`tid`,
         `post`.`post`
     FROM
         `" . $INFO['sql_tbl_prefix'] . "topics` as `topic`,
         `" . $INFO['sql_tbl_prefix'] . "posts` as `post`
     WHERE
         `topic`.`forum_id`= " . $forum_id . " AND
         `post`.`topic_id` = `topic`.`tid`
     ORDER BY
         `topic`.`start_date`
     DESC LIMIT 5");

echo '<ul id="news">';

while ($topic = $topics->fetch_object()) {

     //links uz tēmu, izmaini šo rindu, ja tavā forumā tiek lietota cita linku struktūra
     $url = $INFO['board_url'] . '/topic/' . $topic->tid . '-' . $topic->title_seo . '/';

     //stripojam ārā bbcode
     $topic->post = strip_tags(str_replace(array('[', ']'), array('<', '>'), $topic->post));

     //datuma formāts (pēc http://php.net/manual/en/function.date.php)
     $topic->start_date = date("Y.m.d H:i", $topic->start_date);

     echo '
     <li>
         <h3><a href="' . $url . '">' . $topic->title . '</a></h3>
         <p class="news-info">
             <span class="news-author">' . $topic->starter_name . '</span>
             <span class="news-date">' . $topic->start_date . '</span>
             <span class="news-comments">' . $topic->posts . ' komentāri</span>
         </p>
         <p class="news-content">' . $topic->post . '</p>
     </li>';
}

echo '</ul>';