source: branches/old/news.php

Last change on this file was 448, checked in by george, 16 years ago
  • Přesunuto: Obsah kořenové složky byl přesunut do složky trunk a beta web přesunut do branches/beta.
File size: 1.1 KB
Line 
1<?php
2
3include_once('global.php');
4
5function ShowNews()
6{
7 global $Database;
8 $ItemPerPage = 5;
9 if(array_key_exists('Page', $_GET)) $Page = $Database->real_escape_string($_GET['Page']); else $Page = 0;
10 $Database->select_db('wow');
11 $DbResult = $Database->query('SELECT COUNT(*) FROM news');
12 $Total = $DbResult->fetch_array();
13 $Total = $Total[0];
14
15 $Result = '<strong>Aktuality:</strong>';
16 $Result .= '<div style="NewsTable">';
17 $DbResult = $Database->query('SELECT news.*, user.User as username FROM news JOIN user ON user.ID=news.user WHERE 1 ORDER BY time DESC LIMIT '.($Page * $ItemPerPage).','.$ItemPerPage);
18 while($Row = $DbResult->fetch_array())
19 {
20 $Result .= '<div class="NewsItem">';
21 if($Row['long_text'] != '') $Row['title'] = '<a href="?new_id='.$Row['id'].'">'.$Row['title'].'</a>';
22 $Result .= '<div class="NewsItemTitle"><strong>'.$Row['title'].'</strong> ('.HumanDate($Row['time']).')</div>';
23 $Result .= $Row['short_text'].' ('.$Row['username'].')</div>';
24 }
25 $Result .= '</div>';
26 $Result .= PagesList('?Page=', $Page, $Total, $ItemPerPage);
27 return($Result);
28}
29
30?>
Note: See TracBrowser for help on using the repository browser.