Hallo,
ik heb een forum en daarbij heb ik een fout. De fout is als ik bij db bestaat 1 zet dan hou ik nogsteeds bestaat niet.
Mijn script is:
PHP
<?php
include "../header.php";
include "../nav/forum_reactie.php";
if($_GET['actie'] == ""){
begintabel("Forum > Index", $thema);
echo "Welkom op het forum.<br>";
echo "Wij zouden het fijn vinden als u zich aan de <a href='".$site_url."/regels.php'>regels</a> zou willen houden.<br><br>";
$select = mysql_query("SELECT * FROM forum_cats")or die(mysql_error());
While($list = mysql_fetch_array($select)){
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0' style='border-top: 1px solid #eeeeee;'>";
echo "<tr>";
echo "<td width='100%'>» ".$list['naam']."</td>";
echo "</tr>";
echo "</table>";
$select1 = mysql_query("SELECT * FROM forum_sub_cats WHERE catid='".$list['id']."'")or die(mysql_error());
WHILE($show = mysql_fetch_array($select1)){
if($beveilig->crew == 1 && functie() < 2){
$selonderdeel = "";
}
else{
$selonderdeel = "AND crew != '1'";
}
}
$select2 = mysql_query("SELECT * FROM forum_sub_cats WHERE catid = '".$list['id']."' ".$sql2)or die(mysql_error());
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0' style='border-top: 1px solid #e1e1e1;'>";
echo "<tr>";
echo "<td width='5%'></td>";
echo "<td width='30%'><b>Forum & Beschrijving</b></td>";
echo "<td width='7%' align='center'><b>Topics</b></td>";
echo "<td width='28%' align='center'>Laatste bericht</b></td>";
echo "</tr>";
echo "</table>";
While($forum = mysql_fetch_array($select2)){
$select3 = mysql_query("SELECT id FROM forum WHERE catid='".$forum['id']."'");
$aantal_topics = mysql_num_rows($select3);
//$fora = mysql_fetch_array($select3);
//laatste berichten ophalen
$last_bericht1 = mysql_query("SELECT id,onderwerp,laatste_datum,poster,datum FROM forum WHERE catid = '".$forum['id']."' ORDER BY laatste_datum DESC LIMIT 0,1")or die(mysql_error());
$last_bericht = mysql_fetch_array($last_bericht1);
$datum_reactie = time()-21600;
if($forum['gesloten'] == 1) { // Als het forum is gesloten
$forum_img = "forum_gesloten.gif";
$alt = "Dit forum is gesloten. Een nieuw onderwerp open is niet meer mogelijk!";
}
elseif($last_bericht['laatste_datum'] > $datum_reactie){
$forum_img = "forum_map.gif";
$alt = "In dit forum is de laatste 6 uur iets gepost.";
}
else{
$forum_img = "non_actief.gif";
$alt = "In dit forum is de laatste 6 uur niets gepost.";
}
if(empty($last_bericht['id'])){
echo "";
}
else{
$last_m = mysql_query("SELECT * FROM forum_reacties WHERE tid=".$last_bericht['id']." ORDER BY id DESC LIMIT 0,1")or die(mysql_error());
$last_o = mysql_fetch_array($last_m);
$last_m2 = mysql_query("SELECT * FROM leden WHERE id = '".$last_o['poster']."'")or die(mysql_error());
$last_o2 = mysql_fetch_array($last_m2);
if(empty($last_o2['gebruikersnaam'])){
$last_m3 = mysql_query("SELECT * FROM leden WHERE id='".$last_bericht['poster']."'")or die(mysql_error());
$last_o3 = mysql_fetch_array($last_m3);
$reactie_poster = "<a href='".$site_url."/leden/profiel.php?id=".$last_o3['id']."'>".gebruiker($last_o3['gebruikersnaam'])."</a>";
}
else{
$reactie_poster = "<a href='".$site_url."/leden/profiel.php?id=".$last_o2['id']."'>".gebruiker($last_o2['gebruikersnaam'])."</a>";
}
}
$datum = explode(" ", $last_o['datum']);
$datum2 = explode(" ", $last_bericht['datum']);
if(empty($datum[0])){
$da = explode(":", $datum2[0]);
$date = $da[0];
$date.= $da[1];
$date.= $da[2];
}
else{
$date = $datum[0];
$db = explode(":", $datum[0]);
}
if(empty($datum[1])){
$date2 = $datum2[1];
}
else{
$date2 = $datum[1];
}
$laatste_topic = "Door <i>".$reactie_poster."</i> op ".$date." <br> om ".$date2." <a href='".$site_url."/forum/forum.php?actie=bekijken&topicid=".$last_bericht['id']."'><img border='0' src='".$site_url."/images/forum/laatste_bericht.gif' alt='Ga naar het topic toe!'></img></a>";
if(empty($last_bericht['onderwerp'])){
$last = "<i>Geen berichten</b>";
}
else{
$last = $laatste_topic;
}
//einde reacties ophalen
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0' style='border-top: 1px solid #e1e1e1'>";
echo "<tr>";
echo "<td width='5%' align='center'><img border='0' src='".$site_url."/images/forum/".$forum_img."' alt='".$alt."'></td>";
echo "<td width='30%' onclick='window.location=".$site_url."/forum/forum.php?actie=forum&id=".$forum['id']."'><b><a href='".$site_url."/forum/forum.php?actie=forum&id=".$forum['id']."'>".$forum['naam']."</a></b><br><small>".ubb($forum['beschrijving'], $site_url)."</small></td>";
echo "<td width='7%'><center>".$aantal_topics."</center></td>";
echo "<td width='28%'><center>".$last."</center></td>";
echo "</tr>";
echo "</table>";
}
}
eindetabel($thema);
echo "<br>";
begintabel("Forum Legenda", $thema);
echo "<table border='0' cellspacing='3' cellpadding='0'>";
echo "<tr>";
echo "<td width='20%' align='center'><img border='0' alt='Nieuwe berichten' src='".$site_url."/images/forum/forum_map.gif'></td>";
echo "<td>Nieuwe berichten</td>";
echo "<td width='20%' align='center'><img border='0' alt='Geen nieuwe berichten' src='".$site_url."/images/forum/non_actief.gif'></td>";
echo "<td>Geen nieuwe berichten</td>";
echo "<td width='20%' align='center'><img border='0' alt='Gesloten forum' src='".$site_url."/images/forum/forum_gesloten.gif'></td>";
echo "<td>Gesloten forum</td>";
echo "</tr>";
echo "</table>";
eindetabel($thema);
} //sluit actie leeg
if($_GET['actie'] == "forum") {
$sql5 = mysql_query("SELECT * FROM forum_sub_cats WHERE catid='".$_GET['id']."' ORDER BY id DESC");
$bestaat = mysql_num_rows($sql5);
$sql2 = mysql_query("SELECT * FROM forum_sub_cats WHERE id='".$_GET['id']."'");
$crew = mysql_fetch_array($sql2);
if($crew['crew'] == 1 && functie() < 2){
begintabel("Fout", $thema);
echo "U heeft geen toegang tot dit forum. U bent niet van de crew!";
eindetabel($thema);
}
elseif($bestaat == 0){
begintabel("Fout", $thema);
echo "Dit forum bestaat niet!";
eindetabel($thema);
}
else{
begintabel("Forum", $thema);
if($crew['post_crew'] == 1){
if(functie() < 2){
echo "[ Crew mag alleen topics toevoegen ]<br>";
}
else{
echo "<a href='".$site_url."/forum/nieuw_topic.php?catid=".$_GET['id']."' alt='Open een nieuw bericht/topic'>[ Nieuw topic ]</a><br>";
}
}
else{
echo "<a href='".$site_url."/forum/nieuw_topic.php?catid=".$_GET['id']."' alt='Open een nieuw bericht/topic'>[ Nieuw topic ]</a><br>";
}
if($bestaat == 0){
echo "<br>Er zijn nog <i>geen</b> topics gevonden!";
}
else{
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='4%'></td>";
echo "<td width='30%'><b>Onderwerp</b></td>";
echo "<td width='20%'><b>Auteur</td>";
echo "<td width='10%'><b>Reacties</b></td>";
echo "<td width='20%'><b>Laatste reactie</td>";
echo "</tr>";
$sql8 = mysql_query("SELECT * FROM `forum`")or die(mysql_error());
WHILE($list = mysql_fetch_array($sql8)){
$sql812 = mysql_query("SELECT * FROM leden WHERE id='".$list['poster']."'")or die(mysql_error());
$kijker = mysql_fetch_array($sql812);
//Aantal reacties
$aantal_reacties_1 = mysql_query("SELECT * FROM forum_reacties WHERE tid='".$list['id']."'")or die(mysql_error());
$aantal_reacties = mysql_num_rows($aantal_reacties_1);
//Laatste reactie
$skoel123 = mysql_query("SELECT * FROM forum_reacties WHERE tid='".$list['id']."' ORDER BY id DESC LIMIT 0,1")or die(mysql_error());
$nieuwste_aantal = mysql_num_rows($skoel123);
$nieuwste = mysql_fetch_array($skoel123);
if($nieuwste_aantal == 0){
$nieuw = "N.v.t";
}
else{
$nieuw = $nieuwste['datum'];
}
if($list['poll'] == 1 && $list['status'] == "gesloten"){
$img = "gesloten_poll.gif";
$alt = "Gesloten poll";
}
elseif($list['poll'] == 1){
$img = "poll.gif";
$alt = "Topic met poll";
}
elseif($list['status'] == "gesloten"){
$img = "gesloten.gif";
$alt = "Gesloten topic!";
}
elseif($list['status'] == 6){
$img = "sticky.gif";
$alt = "Belangrijke mededeling!";
}
else{
$gelezen = explode(",", $list['gelezen']);
if(in_array($cookie_id, $gelezen)){
$img = "gelezen_topic.gif";
$alt = "Gelezen topic";
}
else{
$img = "niet_gelezen_topic.gif";
$alt = "Niet gelezen topic";
}
}
echo "<tr>";
echo "<td width='4%' align='center'><img border='0' alt='".$alt."' src='".$site_url."/images/forum/".$img."'></td>";
echo "<td width='30%'><a href='".$site_url."/forum/forum.php?actie=bekijken&topicid=".$list['id']."'>".$list['onderwerp']."</a></td>";
echo "<td width='20%'><a href='".$site_url."/leden/profiel.php?member=".$kijker['gebruikersnaam']."'>".gebruiker($kijker['gebruikersnaam'])."</a></td>";
echo "<td width='10%'>".$aantal_reacties."</td>";
echo "<td width='20%'>".$nieuw."</td>";
echo "</tr>";
}
echo "</table>";
}
eindetabel($thema);
echo "<br>";
begintabel("Extra", $thema);
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='50%'>";
echo "<img border='0' alt='Gelezen topic' src='".$site_url."/images/forum/gelezen_topic.gif'> Gelezen topic.<br>";
echo "<img border='0' alt='Gelezen topic' src='".$site_url."/images/forum/niet_gelezen_topic.gif'> Niet gelezen topic.<br>";
echo "<img border='0' alt='Gelezen topic' src='".$site_url."/images/forum/gesloten.gif'> Gesloten topic<br>";
echo "<img border='0' alt='Gelezen topic' src='".$site_url."/images/forum/sticky.gif'> Mededeling<br>";
echo "</td>";
echo "<td width='50%'> </td>";
echo "</tr>";
echo "</table>";
eindetabel($thema);
}
} //einde
if($_GET['actie'] == "bekijken"){
$sql = mysql_query("SELECT * FROM forum WHERE id='".$_GET['topicid']."'")or die(mysql_error());
$bestaat = mysql_num_rows($sql);
$list = mysql_fetch_array($sql);
if($bestaat == 0){
begintabel("Forum > Topic bekijken", $thema);
echo "Deze topic bestaat niet (meer)!";
eindetabel($thema);
}
else{
$sql2 = mysql_query("SELECT * FROM forum_sub_cats WHERE id='".$list['catid']."'")or die(mysql_error());
$crew = mysql_fetch_array($sql2);
if($cookie_id != ""){
$exploden = explode(",", $list['gelezen']);
if(in_array($cookie_id, $exploden)){
echo "";
}
else{
$nieuw_gelezen = $list['gelezen'];
$nieuw_gelezen.= ",".$cookie_id;
mysql_query("UPDATE forum SET gelezen='".$nieuw_gelezen."' WHERE id='".$_GET['topicid']."'")or die(mysql_error());
}
}
if($crew['crew'] == 1 && functie() <= 2){
begintabel("Forum > Topic bekijken", $thema);
echo "U heeft geen toegang tot dit topic! U bent niet van de crew!";
eindetabel($thema);
}
else{
if(functie() > 1){
begintabel("Extra", $thema);
echo "<b>Beheerderopties:</b><br>";
if($list['status'] == "gesloten"){
echo "<img border='0' alt='Deze topic openen' src='".$site_url."/images/forum/admin_openen.gif'> <a href='".$site_url."/forum/forum_admin.php?actie=openen&topicid=".$_GET['topicid']."'>Topic openen</a><br>";
}
else{
echo "<img border='0' alt='Deze topic sluiten' src='".$site_url."/images/forum/admin_sluiten.gif'> <a href='".$site_url."/forum/forum_admin.php?actie=sluiten&topicid=".$_GET['topicid']."'>Topic sluiten</a><br>";
}
if($list['mededeling'] == "1"){
echo "<img border='0' alt='Maak Normaal Topic' src='".$site_url."/images/forum/admin_sticky.gif'> <a href='".$site_url."/forum/forum_admin.php?actie=a_mededeling&topicid=".$_GET['topicid']."'>Maak Normaal Topic</a><br>";
}
else{
echo "<img border='0' alt='Maak Mededeling' src='".$site_url."/images/forum/admin_sticky.gif'> <a href='".$site_url."/forum/forum_admin.php?actie=m_mededeling&topicid=".$_GET['topicid']."'>Maak Mededeling</a><br>";
}
echo "<br>";
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='50%'>";
if($list['status'] == "gesloten" && functie() <= 1){
$status_list = "<font color='red'>Gesloten</font>";
}
else{
$status_list = "<font color='green'>Open</font>";
}
echo "<b>Reacties</b> ".mysql_num_rows(mysql_query("SELECT * FROM forum_reacties WHERE tid='".$_GET['topicid']."'"))."<br>";
echo "<b>Status</b> ".$status_list;
echo "</td>";
echo "<td width='50%'>";
if($list['status'] == "gesloten" && functie() <= 1){
echo "Reageren niet meer mogelijk!<br>";
}
else{
echo "(<a href='#reageren'>Snel</a>)<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>Reageren</a><br>";
}
echo "<a href='".$site_url."/forum/forum_tracker.php?id=".$_GET['topicid']."'>Opslaan in topictracker!</a>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100%' colspan='2'>".$nav."</td>";
echo "</tr>";
echo "</table>";
eindetabel($thema);
echo "<br>";
}
else{
begintabel("Extra", $thema);
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='50%'>";
if($list['status'] == "gesloten"){
$status_list = "<font color='red'>Gesloten</font>";
}
else{
$status_list = "<font color='green'>Open</font>";
}
echo "<b>Reacties</b> ".mysql_num_rows(mysql_query("SELECT * FROM forum_reacties WHERE tid='".$_GET['topicid']."'"))."<br>";
echo "<b>Status</b> ".$status_list;
echo "</td>";
echo "<td width='50%'>";
if($list['status'] == "gesloten" && functie() <= 1){
echo "Reageren niet meer mogelijk!<br>";
}
else{
echo "(<a href='#reageren'>Snel</a>)<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>Reageren</a><br>";
}
if($cookie_id != ""){
echo "<a href='".$site_url."/forum/forum_tracker.php?id=".$_GET['topicid']."'>Opslaan in topictracker!</a>";
}
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100%' colspan='2'>".$nav."</td>";
echo "</tr>";
echo "</table>";
eindetabel($thema);
echo "<br>";
}
//poll
if($list['poll'] == 1){
include "forum_poll.php";
forum_poll($list['id'], $site_url, $thema);
}
else{
echo "";
}
begintabel($list['naam'], $thema);
$sel123 = mysql_query("SELECT * FROM leden WHERE id='".$list['poster']."'")or die(mysql_error());
$show123 = mysql_fetch_object($sel123);
$sql123 = mysql_query("SELECT * FROM online WHERE wie='".$list['poster']."'")or die(mysql_error());
$line123 = mysql_num_rows($sql123);
if($cookie_id != ""){
$knoppen = "<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>Reageren</a> - <a href='".$site_url."/forum/forum_quote.php?topicid=".$_GET['topicid']."'>Quote</a> ";
}
if($list['status'] == "gesloten"){
$knoppen = "Reageren - Quote ";
}
else{
$knoppen = "<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>Reageren</a> - <a href='".$site_url."/forum/forum_quote.php?topicid=".$_GET['topicid']."'>Quote</a> ";
}
$select12123 = mysql_query("SELECT * FROM leden WHERE id='".$cookie_id."'");
$check12123 = mysql_num_rows($select12123);
$check123 = mysql_fetch_object($select12123);
if($list['status'] == "gesloten" && functie() <= 1){
echo "[Gesloten topic] <a href='".$site_url."/forum/nieuw_topic.php?catid=".$list['catid']."'>[Nieuw topic]</a> <a href='".$site_url."/forum/report_topic.php?catid=".$_GET['topicid']."'>[Bericht aangeven]</a><br>";
}
else{
echo "<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>[Reageren]</a> <a href='".$site_url."/forum/nieuw_topic.php?catid=".$list['catid']."'>[Nieuw topic]</a> <a href='".$site_url."/forum/report_topic.php?catid=".$_GET['topicid']."'>[Bericht aangeven]</a><br>";
}
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='100%' style='border: 1px solid rgb(186, 186, 186);'>";
if($line123 == "1"){
$img = "<img border='0' src='".$site_url."/images/online.gif'> ";
}
else{
$img = "<img border='0' src='".$site_url."/images/offline.gif'> ";
}
if($list['poster'] == $cookie_id OR functie() > 1){
$beheer = "- <a href='".$site_url."/forum/forum_bewerken.php?topic=".$_GET['topicid']."'>Bewerken</a>";
}
else{
$beheer = "";
}
if(functie() > 1){
$beheer = "$beheer - <a href='".$site_url."/forum/forum_admin.php?actie=deletetopic&topicid=".$_GET['topicid']."'>Delete</a>";
}
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='50%' bgcolor='#dcdcdc'>".$img."<a href='".$site_url."/leden/profiel.php?member=".$show123->gebruikersnaam."'>".gebruiker($show123->gebruikersnaam)."</a></td>";
echo "<td width='50%' bgcolor='#dcdcdc'>".$list['datum']."</td>";
echo "</tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100%' valign='top'>";
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='20%' style='border-left: 1px solid rgb(186, 186, 186);' valign='top'>";
echo laatzien($list['poster'], $site_url);
echo "</td>";
echo "<td width='80%' style='border-left: 1px solid rgb(186, 186, 186);' valign='top'>";
echo ubb($list['bericht'], $site_url);
if($check12123 != "0"){
if($check123->optie_onderschrift != "1"){
echo "";
}
else{
if($show123->onderschrift == ""){
echo "";
}
else{
echo "<div valign=\"bottom\"><hr>".ubb($show123->onderschrift, $site_url);
}
}
}
else{
echo "</div><hr>".ubb($show123->onderschrift, $site_url);
}
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100%' style='border: 1px solid rgb(186, 186, 186);' bgcolor='#dcdcdc'>";
echo $knoppen.$beheer;
echo "</td>";
echo "</tr>";
echo "</table>";
eindetabel($thema);
echo "<br>";
$select_nu = mysql_query("SELECT * FROM forum_reacties WHERE tid='".$_GET['topicid']."' ORDER BY id ASC LIMIT ".$navigatie )or die(mysql_error());
$counter = mysql_num_rows($select_nu);
begintabel("Reacties", $thema);
if($counter == "0"){
echo "Er zijn <b>geen</b> reacties gevonden!";
}
else{
WHILE($reactie = mysql_fetch_array($select_nu)){
echo "<a name='".$reactie['id']."'>";
$sel1231 = mysql_query("SELECT * FROM leden WHERE id='".$reactie['poster']."'")or die(mysql_error());
$show1231 = mysql_fetch_object($sel1231);
$sql1231 = mysql_query("SELECT * FROM online WHERE wie='".$reactie['poster']."'")or die(mysql_error());
$line1231 = mysql_num_rows($sql1231);
if($cookie_id != ""){
$knoppen = "<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>Reageren</a> - <a href='".$site_url."/forum/forum_quote.php?reactieid=".$reactie['id']."&topic_id=".$_GET['topicid']."'>Quote</a> ";
}
if($list['status'] == "gesloten" && functie() <= 1){
$knoppen = "Reageren - Quote ";
}
else{
$knoppen = "<a href='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>Reageren</a> - <a href='".$site_url."/forum/forum_quote.php?reactieid=".$reactie['id']."&topic_id=".$_GET['topicid']."'>Quote</a> ";
}
$select121231 = mysql_query("SELECT * FROM leden WHERE id='".$cookie_id."'");
$check121231 = mysql_num_rows($select121231);
$check1231 = mysql_fetch_object($select121231);
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='100%' style='border: 1px ".$color_bg_line.";'>";
if($line1231 == "1"){
$img = "<img border='0' src='".$site_url."/images/online.gif'> ";
}
else{
$img = "<img border='0' src='".$site_url."/images/offline.gif'> ";
}
if($reactie['poster'] == $cookie_id OR functie() > 1){
$beheer = "- <a href='".$site_url."/forum/forum_bewerken.php?reactie=".$reactie['id']."'>Bewerken</a>";
if(functie() > 1){
$beheer .= " - <a href='".$site_url."/forum/forum_admin.php?actie=deletereply&replyid=".$reactie['id']."'>Delete</a>";
}
}
else{
$beheer = "";
}
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='50%' bgcolor='".$color_bg_overal."'>".$img."<a href='".$site_url."/leden/profiel.php?member=".$show1231->gebruikersnaam."'>".gebruiker($show1231->gebruikersnaam)."</a></td>";
echo "<td width='50%' bgcolor='#dcdcdc'>".$reactie['datum']."</td>";
echo "</tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100%' valign='top'>";
echo "<table border='0' width='100%' cellspacing='0' cellpadding='0'>";
echo "<tr>";
echo "<td width='20%' style='border-left: 1px solid ".$color_bg_line.";' valign='top'>";
echo laatzien($reactie['poster'], $site_url);
echo "</td>";
echo "<td width='80%' style='border-left: 1px solid ".$color_bg_line.";' valign='top'>";
$reactie['bericht']=stripslashes(stripslashes(stripslashes(stripslashes($reactie['bericht']))));
echo ubb($reactie['bericht'], $site_url);
if($check121231 != "0"){
if($check1231->optie_onderschrift != "1"){
echo "";
}
else{
if($show1231->onderschrift == ""){
echo "";
}
else{
echo "<hr>".ubb($show1231->onderschrift, $site_url);
}
}
}
else{
echo "<hr>".ubb($show1231->onderschrift, $site_url);
}
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td width='100%' style='border: 1px ".$color_bg_line."' bgcolor='".$color_bg_overal."'>";
echo $knoppen.$beheer;
echo "</td>";
echo "</tr>";
echo "</table>";
echo "<br>";
}
}
eindetabel($thema);
if($list['status'] == "gesloten" OR functie() == "0"){
echo "";
}
else{
echo "<br>";
begintabel("Snel reageren", $thema);
echo "<a name='reageren'>";
echo "<form method='post' name='reageren' action='".$site_url."/forum/forum_reageren.php?forum_id=".$_GET['topicid']."'>";
echo "<center><textarea name='bericht' cols='50' rows='8'></textarea>";
echo "<br><input type='submit' name='submit' value='Toevoegen'></form></center>";
eindetabel($thema);
}
}
}
}
include "../footer.php";
?>Mijn db is:
PHP
--
-- Tabelstructuur voor tabel `forum_sub_cats`
--
CREATE TABLE IF NOT EXISTS `forum_sub_cats` (
`id` int(5) NOT NULL auto_increment,
`catid` int(5) NOT NULL default '0',
`naam` varchar(250) NOT NULL default '0',
`beschrijving` text NOT NULL,
`crew` int(2) NOT NULL default '0',
`mods` text NOT NULL,
`gesloten` char(2) NOT NULL default '0',
`post_crew` char(1) NOT NULL default '0',
`bestaat` int(5) NOT NULL default '1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Gegevens worden uitgevoerd voor tabel `forum_sub_cats`
--
INSERT INTO `forum_sub_cats` (`id`, `catid`, `naam`, `beschrijving`, `crew`, `mods`, `gesloten`, `post_crew`, `bestaat`) VALUES
(1, 1, 'Bugs', 'Heb je bugs gevonden? Meld het hier!', 0, '', '0', '0', 1),
(2, 1, 'Update''s', 'Hier komen de update's van .', 0, '', '0', '1', 1),
(3, 1, 'Tips', 'Heb jij tips voor. Post ze dan hier.', 0, '', '0', '0', 1),
(4, 2, 'Criminals Hulp', 'Hulp nodig met je criminals site (scripts, personeel etc.)? Vraag het hier.', 0, '', '0', '0', 1),
(5, 2, 'Criminals Script Gezocht', 'Zoek je een criminals script? Vraag het hier.', 0, '', '0', '0', 1),
(6, 3, 'Algemene Hulp', 'Hulp nodig met je website?\r\nStel hier je vraag.', 0, '', '0', '0', 1),
(7, 3, 'Script Gezocht', 'Zoek je een script? Vraag het hier.', 0, '', '0', '0', 1),
(8, 3, 'PHP/SQL', 'Plaats hier je vragen en problemen over PHP en de vele soorten SQL (MySQL, PostgreSQL, Oracle)', 0, '', '0', '0', 1),
(9, 3, '(X)HTML/XML/CSS', 'Hier kunt u met al uw vragen over (X)HTML, XML en CSS terecht.)', 0, '', '0', '0', 1),
(10, 3, 'Javascript / Web 2.0', 'Vragen over javascript of Web 2.0?)', 0, '', '0', '0', 1);DE FOUT ZIT ROND REGEL 152
Kan iemand kijken wat de fout is?
En dit maken.
Mvg, Netostar
