<?php
require_once 'inc/header.php';
if(isset($_GET['act']) && ($_GET['act'] == 'leesmeer') && ctype_digit(isset($_GET['id'])))
{
    $sQuery = mysql_query("SELECT * FROM member_news WHERE nId = " . $_GET['id']) or trigger_error(mysql_error());
    $sFetch = mysql_fetch_assoc($sQuery);
    
    $nameQuery = mysql_query("SELECT * FROM member_accounts WHERE uId = " . $sFetch['nAuthor']);
    $nameFetch = mysql_fetch_assoc($nameQuery);
    
    if($sFetch['nVisible'] == 1)
    {
    
          echo '<div class="top">' . htmlentities($sFetch['nTitle'], ENT_QUOTES) . ' ' . (is_auth(2, $_SESSION['uId']) ? '<div style="float:right"><a href="admin_news?act=edit&amp;id=' . $sFetch['nId'] . '"><img src="img/pencil.png" alt="Wijzigen" /></a>' . ($sFetch['nVisible'] == '1' ? ' <a href="admin_news?act=delete&amp;id=' . $sFetch['nId'] . '"><img src="img/cross.png" alt="verwijderen" /></a></div>' : ' <a href="admin_news?act=reopen&amp;id=' . $nFetch['nId'] . '"><img src="img/newspaper_go.png" alt="Zet terug" /></a></div>') : '') . '</div><div class="mid">';
       echo ''.$sFetch['nText'].'';
echo '<br /><p align="left" style="float: left;">Door <span style="color:' . $nameFetch['uCol'] . ';font-weight: bold;">' . htmlentities($nameFetch['uName'], ENT_QUOTES) . '</span> | ' . $sFetch['nDate'] . '</font></p></div>';
       
        
        $cQuery = mysql_query("SELECT cId, cVisible, cAuth, cText, cDate FROM member_news_comment WHERE cNewsId =" . $_GET['id'] . (is_auth(2, $_SESSION['uId']) == TRUE ? '' : ' AND cVisible = 1') . " ORDER BY cId ASC") or trigger_error(mysql_error());   


        if(mysql_num_rows($cQuery))
        {
           
            while($cFetch = mysql_fetch_assoc($cQuery))
            {
                $nameQuery = mysql_query("SELECT * FROM member_accounts WHERE uId = " . $cFetch['cAuth']);
                $nameFetch = mysql_fetch_assoc($nameQuery);
                
                
                echo '<div class="top">Reactie van ' . htmlentities($nameFetch['uName'], ENT_QUOTES) . '' . (is_auth(2, $_SESSION['uId']) ? '<div style="float:right"><a href="news_edit_comment?act=edit&amp;id=' . $cFetch['cId'] . '&amp;nId=' . $_GET['id'] . '"><img src="img/pencil.png" alt="Wijzigen" /></a>' . ($cFetch['cVisible'] == '1' ? ' <a href="news_edit_comment?act=delete&amp;id=' . $cFetch['cId'] . '&nId=' . $_GET['id'] . '"><img src="img/cross.png" alt="Verwijderen" /></a></div>' : ' <a href="news_edit_comment?act=reopen&amp;id=' . $cFetch['cId'] . '&amp;nId=' . $_GET['id'] . '"><img src="img/newspaper_go.png" alt="Zet terug" /></a></div>') : '') . '</div><div class="mid">';


	echo '<div style="text-align: center; border-bottom: 1px dashed #000; margin-right: 5px;">
				Gepost op ' . $cFetch['cDate'] . '
			</div>
			<div style="width: 110px; float: left;"> <strong><a href="profiel?id=' . $nameFetch['uId'] . '"><span style="color:' . $nameFetch['uCol'] . ';font-weight: bold;">' . htmlentities($nameFetch['uName'], ENT_QUOTES) . '</span></a></strong><br />';
 if(!empty($nameFetch['uAvatarUrl']))
            {              
                echo image_resize($nameFetch['uAvatarUrl']);
            }
				echo '
				<img src="img/muntjes.png" /> ' . $nameFetch['uCoins'] . '<br />
				<img src="img/ster.png" /> ' . $nameFetch['uRangN'] . '
			</div>
			<div style="float: left; border-left: 1px dashed #000; width: 315px; padding: 5px; min-height: auto; height: auto;">';
                echo ParseUbb(htmlentities($cFetch['cText'], ENT_QUOTES), 2);
			echo '</div></div>
			<div style="clear: both;"></div>';


            }
        } 
        if(isset($_SESSION['uId']) && is_auth(1, $_SESSION['uId']))
        {
        ?>
            <div class="top">Reageren</div>
<div class="mid">
                <?php echo ubb('textbox', 'text'); ?>
                <form name="textbox" action="news_reageer" method="POST">
                    <input type="hidden" name="NewsID" value="<?php echo $_GET['id']; ?>" />
                    <textarea cols="40" rows="5" id="textbox" name="text"></textarea><br />
                    <input type="submit" name="submit" value="Reageer" />
                </form>
            </div>
                
        <?php
        } 
        else
        {
            echo '<div class="rederror"><br /><strong>Je moet ingelogd zijn om te reageren.</strong> <br /><a href="login">Log hier in</a> of <a href="registreer">maak een account aan.</a></div>';    
        }
    }
    else
    {
        echo '<div class="rederror"><br /><strong>Dit nieuwsbericht is verwijderd</strong><br />Klik <a href="javascript:history.back(-1)">hier</a> om terug te gaan</div>';    
    }       
}
else
{
    $per_pagina = 5;
    $start = isset($_GET['start']) && ctype_digit($_GET['start']) ? $_GET['start'] : 0;
    
    $pagina = ceil($start / $per_pagina) + 1;
    $paginas_mysql = mysql_query("SELECT count(1) AS aantal FROM member_news WHERE nVisible = 1") or die(mysql_error());
    $fetch_mysql = mysql_fetch_assoc($paginas_mysql);
    $paginas = ceil($fetch_mysql['aantal'] / $per_pagina);
    


    $sQuery = mysql_query("SELECT * FROM member_news " . (is_auth(2, $_SESSION['uId']) == TRUE ? '' : 'WHERE nVisible = 1'). " ORDER BY nDate DESC LIMIT " . $start . "," . $per_pagina);
	
    if(isset($_SESSION['uId']) && is_auth(2, $_SESSION['uId']))
    while($sFetch = mysql_fetch_assoc($sQuery))
    {
        $nameQuery = mysql_query("SELECT * FROM member_accounts WHERE uId = " . $sFetch['nAuthor']);
        $nameFetch = mysql_fetch_assoc($nameQuery);
        
        $countQuery = mysql_query("SELECT count(cId) AS commentCount FROM member_news_comment WHERE cNewsId = " . $sFetch['nId'] . " AND cVisible = 1") or trigger_error(mysql_error());
        $countFetch = mysql_fetch_assoc($countQuery);
         
   
        echo '<div class="top">' . htmlentities($sFetch['nTitle']) . ' ' . (is_auth(2, $_SESSION['uId']) ? '<div style="float:right"><a href="admin_news&amp;act=edit&amp;id=' . $sFetch['nId'] . '"><img src="img/pencil.png" alt="Wijzigen" /></a>' . ($sFetch['nVisible'] == '1' ? ' <a href="admin_news?act=delete&amp;id=' . $sFetch['nId'] . '"><img src="img/cross.png" alt="verwijderen" /></a></div>' : ' <a href="admin_news?act=reopen&amp;id=' . $nFetch['nId'] . '"><img src="img/newspaper_go.png" alt="Zet terug" /></a></div>') : '') . '</div><div class="mid">';
       echo ''.$sFetch['nText'].'';
echo '<br /><p align="left" style="float: left;">Door <span style="color:' . $nameFetch['uCol'] . ';font-weight: bold;">' . htmlentities($nameFetch['uName'], ENT_QUOTES) . '</span> | ' . $sFetch['nDate'] . '</font></p><p align="right" style="float: right;"><a href="nieuws?act=leesmeer&id=' . $sFetch['nId'] . '">Volledig bericht</a> |  <a href="nieuws?act=leesmeer&id=' . $sFetch['nId'] . '">(' . $countFetch['commentCount'] . ') reacties</a></p></div>';
       
      if(isset($_SESSION['uId']) && is_auth(2, $_SESSION['uId']))
        {
            $hiddencountQuery = mysql_query("SELECT count(cId) AS hiddencommentCount FROM member_news_comment WHERE cNewsId = " . $sFetch['nId'] . " AND cVisible = 0") or trigger_error(mysql_error());
            $hiddencountFetch = mysql_fetch_assoc($hiddencountQuery);
            if($hiddencountFetch['hiddencommentCount'] > 0)
            {
            echo ' (+' . $hiddencountFetch['hiddencommentCount'] . ' verborgen)';
            }
        }
        echo '</a>';
    
    }
    echo '<div class="top">Paginanavigatie</div><div class="mid">';
    for($j = $pagina-5;$j < $pagina+5;$j++) 
    {
              if($j > 0 && $j <= $paginas) 
       {
          if($j == $pagina)
          {
             echo'<strong>' . $pagina . '</strong>&nbsp;';
          } 
          else 
          {
             echo "<a href='nieuws?start=" . (($j-1)*$per_pagina) . "'>" . $j . "</a>&nbsp;";
          }
       }
    }
	echo '</div>';
} 
require_once 'inc/footer.php';   
?>