Bij me nieuws krijg ik dit, Als je bent uitgelogd:
Notice: Undefined index: uId in /home/shahiem/domains/habboregio.nl/public_html/nieuws.php on line 87
En dit krijg ik ook nog:
Notice: Undefined variable: nFetch in /home/shahiem/domains/habboregio.nl/public_html/nieuws.php on line 99
Code:
PHP
<?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&id=' . $sFetch['nId'] . '"><img src="img/pencil.png" alt="Wijzigen" /></a>' . ($sFetch['nVisible'] == '1' ? ' <a href="admin_news?act=delete&id=' . $sFetch['nId'] . '"><img src="img/cross.png" alt="verwijderen" /></a></div>' : ' <a href="admin_news?act=reopen&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&id=' . $cFetch['cId'] . '&nId=' . $_GET['id'] . '"><img src="img/pencil.png" alt="Wijzigen" /></a>' . ($cFetch['cVisible'] == '1' ? ' <a href="news_edit_comment?act=delete&id=' . $cFetch['cId'] . '&nId=' . $_GET['id'] . '"><img src="img/cross.png" alt="Verwijderen" /></a></div>' : ' <a href="news_edit_comment?act=reopen&id=' . $cFetch['cId'] . '&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&act=edit&id=' . $sFetch['nId'] . '"><img src="img/pencil.png" alt="Wijzigen" /></a>' . ($sFetch['nVisible'] == '1' ? ' <a href="admin_news?act=delete&id=' . $sFetch['nId'] . '"><img src="img/cross.png" alt="verwijderen" /></a></div>' : ' <a href="admin_news?act=reopen&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> ';
}
else
{
echo "<a href='nieuws?start=" . (($j-1)*$per_pagina) . "'>" . $j . "</a> ";
}
}
}
echo '</div>';
}
require_once 'inc/footer.php';
?>