<?php

/*-------------------------------------------------------+

| Author: matze

| Web: http://fusion-mods.de

| Lizenz: CCL v1.0

+--------------------------------------------------------*/

require_once 'maincore.php';

require_once THEMES.'templates/header.php';

#require_once BASEDIR."includes/play_funktion.php";

$title = 'News';

$betreff = 'Betreff';

$lese = 'Gelesen';

$max = 5;



if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; } 



$rows = dbcount('(news_id)', DB_NEWS,groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'");

if (isset($_GET['rowstart']) && ( $_GET['rowstart']>$rows || $_GET['rowstart'] < 0 )  ) { $_GET['rowstart'] = 0 ;}



$result = dbquery("SELECT news_id,news_subject,news_reads FROM ".DB_NEWS." 

WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")

AND (news_end='0'||news_end>=".time().") AND news_draft='0'

ORDER BY news_reads ASC LIMIT ".$_GET['rowstart'].",".$max);

add_to_title($locale['global_200'].$title);



opentable($title);

if (dbrows($result) != 0) {

if ($rows > $max)  {

$pagenav = '<div align="center" style="margin:5px;">'.makepagenav($_GET['rowstart'],$max,$rows,6,FUSION_SELF.'?').'</div>';

echo $pagenav;

}

echo '<table width="99%" border="0" cellspacing="1" cellpadding="2" align="center"><tr class="tbl2">

<th align="center">Nr.</th>

<th align="center">'.$betreff.'</th>

<th align="center">'.$lese.'</th>

</tr>';

$i = $_GET['rowstart'] ;

while ($data = dbarray($result)) { $i++;

echo '<tr class="tbl'.( $i%2 == 0 ? '2' : '1' ).'">

<th align="center">'.($i).'.</th>

<td align="left"><a href="'.BASEDIR.'news.php?readmore='.$data['news_id'].'">'.$data['news_subject'].'</a>

</td>

<td align="center">'.$data['news_reads'].'</td>

</tr>';

}

echo '</table>';

if ($rows > $max)  {echo $pagenav;}

} else { 

echo "<div style='text-align:center'><br />\n".$locale['global_078']."<br /><br />\n</div>\n";

}

closetable();

require_once THEMES.'templates/footer.php';

?>