hulp bij forum

gofie

beste cp

ik heb een forum script alles werkt maar geeft 1 foutmelding en dat snap ik niet want ik heb alles in database staan alles wie kan me helpen

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/gofie/domains/downup-terror.nl/public_html/forum.php on line 668

gofie

PHP

while($forum = mysql_fetch_object($query))

L.Groot

Geef $query eens? Waarschijnlijk heb je daar een error in zitten. Plaats daar achter or die(mysql_error()); en je weet de exacte error. Ik gok een onbestaande tabelnaam of een niet toegestaan teken.

gofie

PHP

print "	<table width=\"75%\" align=\"center\"></tr></td></table><tr><td><table align=\"center\" width=\"70%\"><tr><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"70%\" colspan=\"1\"><b>Algemeen</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Topics</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"15%\"><b>Reacties</b></td></tr>\n";
			$query = mysql_query("SELECT * FROM `[forum_sub]` WHERE `area`=1");
			while($forum = mysql_fetch_object($query)) {
			print "	<tr  onClick=\"window.location.href='forum.php?sub={$forum->id}'\"><td class=maintxt width=\"80%\"><img src=images/icons/arrow.gif><a href=\"forum.php?sub={$forum->id}\" target=\"_self\"><b>$forum->title</b></a><br>$forum->text</td><td align=\"center\" class=maintxt width=\"10%\">$forum->topics</td><td class=maintxt align=\"center\" width=\"10%\">$forum->replys</td></tr>\n";
			}

Malik

Bestaat tabel `[forum_sub]` in je database? en daarin `area`?

gofie

ja

L.Groot

Is area een INT of VARCHAR, indien het laatste dan moeten er 2 aanhalingstekens (quotes: '') om het getal 1 gezet worden.

gofie

oke zal kijken thx

Nieuwe reactie samengevoegd met originele reactie op 30.06.11 00:08:24:
ik heb al een werkende forum gevonden enige wat die niet wil is de leden aan geven die de topic heeft geplaats en als hij of zij online is geweest en geen avatar

Nieuwe reactie samengevoegd met originele reactie op 30.06.11 00:08:59:

Nieuwe reactie samengevoegd met originele reactie op 30.06.11 00:09:48:
<?php /* ------------------------- */

include 'includes/config.php';

logincheck(); {

mysql_query("UPDATE `[users]` SET online=NOW() WHERE login='".$_SESSION['login']."'");

}

if(! $_GET['p']) {
$begin = 0;
}
else {
$begin = $_GET['p'];
}

/* ------------------------- */ ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

</head>
<?
if($_GET['sub']) {
$query2 = mysql_query("SELECT * FROM `[forum_sub]` WHERE `id`={$_GET['sub']}");
$sub = mysql_fetch_object($query2);
if($sub->mods == "") {
$mods = "Geen";
} else {
$mods = $sub->mods;
}
if($data->forumstatus == "gwsp2") {
}
elseif($data->forumstatus == "gwsp1") {
}
else {
if($_GET['sub'] == 12 && $data->login == poep) {
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"_mainTxt\"><table width=\"100%\" align=\"center\"><tr><td>Dit forum is alleen voor gangsters.</td></tr></table></td></tr></table>\n";
exit;
}
if($_GET['sub'] == 13 && $data->type != 2) {
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td>Dit forum is alleen voor terroristen.</td></tr></table></td></tr></table>\n";
exit;
}
if($_GET['sub'] == 14 && $data->type != 3 ) {
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td>Dit forum is alleen voor agenten.</td></tr></table></td></tr></table>\n";
exit;
}
}

print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td><div align=\"left\"><a href=\"forum.php?newtopic={$_GET['sub']}\" target=\"_self\"><b>Nieuw Onderwerp</b></a></div><div align=\"right\">\n";
print " </div></td></tr><tr><td align=\"left\">Moderator(s): $mods</td></tr><tr><td><table align=\"center\" width=\"100%\"><tr><td width=\"5%\" align=\"left\" class=\"subTitle\" style=\"letter-spacing: normal;\"> </td><td align=\"left\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"45%\"><b>Topic</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Door</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Reacties</b></td><td align=\"left\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"30%\"><b>Laatste reactie</b></td></tr>\n";
$query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `subid`={$_GET['sub']} ORDER BY `date` DESC");
while($forum = mysql_fetch_object($query)) {
if($forum->slotje == 0) {
$image = "berichten/opentopic.gif";
}
else {
$image = "berichten/closed.gif";
}
print " <tr><td width=\"5%\"><a href=\"forum.php?verplaats={$forum->id}\" target=\"_self\"><img src=\"images/{$image}\" border=0></a></td><td width=\"45%\"><a href=\"forum.php?topic={$forum->id}\" target=\"_self\"><b>$forum->title</b></a></td><td align=\"center\" width=\"10%\"><a href=\"profile.php?x={$forum->login}\" target=\"_self\">$forum->login</a></td><td align=\"center\" width=\"10%\">$forum->replys</td><td width=\"30%\" align=\"center\">$forum->datum</td></tr><tr>\n";
}
print " </table></tr></td></table></td></tr></table>\n";
}
elseif($_GET['topic']) {
if(isset($_POST['add'])) {
if( logincheck() ) {
$id = $_GET['topic'];
$bericht = $_POST['message'];
$datum = date("d-m-Y H:i");
$query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['topic']}");
$lol = mysql_fetch_object($query);
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td>Je bericht is geplaatst.</td></tr></table></td></tr></table><META HTTP-EQUIV=\"Refresh\" CONTENT=\"2; URL=forum.php?topic={$_GET['topic']}\">\n";
mysql_query("INSERT INTO `[foum_replys]`(topicid,datum,login,title,text,date) values($id,'$datum','$data->login','RE:','$bericht',NOW())") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());
mysql_query("UPDATE `[forum_topics]` SET `replys`=`replys`+1,`datum`='$datum',`date1`=NOW() WHERE `id`={$_GET['topic']}") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`+1 WHERE `id`={$lol->subid}") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());
mysql_query("UPDATE `[users]` SET `forumposts`=`forumposts`+1 WHERE `login`='{$data->login}'") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());
}
else {
print "<META HTTP-EQUIV=\"Refresh\" CONTENT=\"0; URL=login.php\">";
exit;
}
}
else {
$query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['topic']}");
$topic = mysql_fetch_object($query);
$user_query2 = mysql_query("SELECT UNIX_TIMESTAMP(`online`) AS `online`,`forumstatus`,`login`,`forumposts`,`avaurl` FROM `[users]` WHERE `login`='{$topic->login}'");
$user2 = mysql_fetch_object($user_query2);

if($user2->forumstatus == "default" && $user2->forumposts <= 50) {
$status = "Forum Beginner";
}
elseif($user2->forumstatus == "default" && $user2->forumposts <= 150) {
$status = "<font color=orange>Forum Member</font>";
}
elseif($user2->forumstatus == "default" && $user2->forumposts > 150) {
$status = "<font color=yellow>Forum God</font>";
}
elseif($user2->forumstatus == "gwsp1") {
$status = "<font color=green><b>Moderator</b></font>";
}
elseif($user2->forumstatus == "gwsp2") {
$status = "<font color=red><b>Administrator</b></font>";
}
else {
$status = "Onbekend";
}
if(time() - $user2->online < 300) {
$online2 = "<img src=\"images/berichten/online.gif\"> <font color=green><b>Online</b></font>";
}
else {
$online2 = "<img src=\"images/berichten/offline.gif\"> <font color=red><b>Offline</b></font>";
}
$topic->text = htmlspecialchars($topic->text);
$topic->text = nl2br($topic->text);
$topic->text = str_replace("", "<b>",$topic->text);
$topic->text = str_replace("", "</b>",$topic->text);
$topic->text = str_replace("", "<i>",$topic->text);
$topic->text = str_replace("", "</i>",$topic->text);
$topic->text = str_replace("", "<u>",$topic->text);
$topic->text = str_replace("", "</u>",$topic->text);
$topic->text = eregi_replace("\\[color=([^\\[]*)\\]([^\\[]*)\\[/color\\]","<font color=\"\\1\">\\2</font>",$topic->text);
$topic->text = eregi_replace("\\[email=([^\\[]*)\\]([^\\[]*)\\[/email\\]", "<a href=\"mailto:\\1\">\\2</a>",$topic->text);
$topic->text = eregi_replace("\\*)\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=main>\\2</a>",$topic->text);
$topic->text = eregi_replace("\\')"><br>
<textarea rows="15" name="message" cols="50" maxlength="10000"></textarea></td><td width="100%"></td>
</tr>
<tr><td></td><td align="right"><input type="submit" name="add" value="Toevoegen"></td><td width="100%"></td><td width="100%"></td></tr>
</form>
</table>
</tr></td>
</table>
</td></tr>
</table>
ENDHTML;
}
}
elseif($_GET['edittopic']) {
$query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['edittopic']} AND `login`='{$data->login}'");
$num = mysql_num_rows($query);
$topic = mysql_fetch_object($query);
if($num == 1) {
if(isset($_POST['change'])) {
$titel = $_POST['title'];
$bericht = $_POST['message'];
$id = $_GET['edittopic'];
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td align=\"center\">Je bericht is gewijzigd.</tr></td></table></td></tr></table>\n";
mysql_query("UPDATE `[forum_topics]` SET `title`='{$titel}',`text`='{$bericht}' WHERE `id`={$id}") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());
}
else {
print " <table width=\"100%\" cellspacing=0>\n";
print " <tr><td class=\"subTitle\"><b>Forum</b></td></tr>\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table width=\"100%\" align=\"center\">\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table align=\"center\" width=\"100%\"><form method=\"post\" target=\"_self\">\n";
print " <tr><td class=\"mainTxt\" colspan=3>Topic bewerken</td></tr>\n";
print " <tr><td>Titel:</td><td><input type=\"text\" value=\"$topic->title\" size=\"20\" name=\"title\"></td><td width=\"100%\"></td></tr>\n";
print " <tr><td>Bericht:</td><td><textarea name=\"message\" cols=40 rows=10>$topic->text</textarea></td><td width=\"100%\"></td></tr>\n";
print " <tr><td></td><td align=\"right\"><input type=\"submit\" name=\"change\" value=\"Verander\"></td><td width=\"100%\"></td></tr>\n";
print " </form</table>\n";
print " </tr></td>\n";
print " </table>\n";
print " </td></tr>\n";
print " </table>\n";
}
}
else {
print " <table width=\"100%\" cellspacing=0>\n";
print " <tr><td class=\"subTitle\"><b>Forum</b></td></tr>\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table width=\"100%\" align=\"center\">\n";
print " <tr><td align=\"center\">\n";
print " Error!\n";
print " </tr></td>\n";
print " </table>\n";
print " </td></tr>\n";
print " </table>\n";
}
}
elseif($_GET['editreply']) {
$query = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['editreply']} AND `login`='{$data->login}'");
$num = mysql_num_rows($query);
$topic = mysql_fetch_object($query);
if($num == 1) {
if(isset($_POST['change'])) {
$titel = $_POST['title'];
$bericht = $_POST['message'];
$id = $_GET['editreply'];
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td align=\"center\">Je bericht is gewijzigd.</tr></td></table></td></tr></table>\n";
mysql_query("UPDATE `[foum_replys]` SET `text`='{$bericht}' WHERE `id`={$id}") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());

}
else {
print " <table width=\"100%\" cellspacing=0>\n";
print " <tr><td class=\"subTitle\"><b>Forum</b></td></tr>\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table width=\"100%\" align=\"center\">\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table align=\"center\" width=\"100%\"><form method=\"post\" target=\"_self\">\n";
print " <tr><td class=\"mainTxt\" colspan=3>Reactie bewerken</td></tr>\n";
print " <tr><td>Bericht:</td><td><textarea name=\"message\" cols=40 rows=10>$topic->text</textarea></td><td width=\"100%\"></td></tr>\n";
print " <tr><td></td><td align=\"right\"><input type=\"submit\" name=\"change\" value=\"Verander\"></td><td width=\"100%\"></td></tr>\n";
print " </form</table>\n";
print " </tr></td>\n";
print " </table>\n";
print " </td></tr>\n";
print " </table>\n";
}
}
elseif($data->forumstatus == "gwsp1" $data->forumstatus == "gwsp2") {
$query2 = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['editreply']}");
$topic2 = mysql_fetch_object($query2);
if(isset($_POST['change'])) {
$titel = $_POST['title'];
$bericht = $_POST['message'];
$id = $_GET['editreply'];
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td align=\"center\">Je bericht is gewijzigd.</tr></td></table></td></tr></table>\n";
mysql_query("UPDATE `[foum_replys]` SET `text`='{$bericht}' WHERE `id`={$id}") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());

}
else {
print " <table width=\"100%\" cellspacing=0>\n";
print " <tr><td class=\"subTitle\"><b>Forum</b></td></tr>\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table width=\"100%\" align=\"center\">\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table align=\"center\" width=\"100%\"><form method=\"post\" target=\"_self\">\n";
print " <tr><td class=\"mainTxt\" colspan=3>Reactie bewerken</td></tr>\n";
print " <tr><td>Bericht:</td><td><textarea name=\"message\" cols=40 rows=10>$topic2->text</textarea></td><td width=\"100%\"></td></tr>\n";
print " <tr><td></td><td align=\"right\"><input type=\"submit\" name=\"change\" value=\"Verander\"></td><td width=\"100%\"></td></tr>\n";
print " </form</table>\n";
print " </tr></td>\n";
print " </table>\n";
print " </td></tr>\n";
print " </table>\n";
}
}
else {
print " <table width=\"100%\" cellspacing=0>\n";
print " <tr><td class=\"subTitle\"><b>Forum</b></td></tr>\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table width=\"100%\" align=\"center\">\n";
print " <tr><td align=\"center\">\n";
print " Error!\n";
print " </tr></td>\n";
print " </table>\n";
print " </td></tr>\n";
print " </table>\n";
}
}
elseif($_GET['delreply']) {
$query = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['delreply']} AND `login`='{$data->login}'");
$num = mysql_num_rows($query);
$topic = mysql_fetch_object($query);
if($num == 1) {
$query2 = mysql_query("SELECT * FROM `[foum_topics]` WHERE `id`={$topic->topicid}");
$sub = mysql_fetch_object($query2);
$id = $_GET['delreply'];
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td align=\"center\">Je bericht is verwijdert.</tr></td></table></td></tr></table>\n";
mysql_query("DELETE FROM `[foum_replys]` WHERE `id`='{$id}'");
mysql_query("UPDATE `[forum_topics]` SET `replys`=`replys`-1 WHERE `id`='{$topic->topicid}'");
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`-1 WHERE `id`='{$sub->subid}'") or die("er is een fout opgetreden. Ging het volgende mis: <br>\n".mysql_error()."<br>Extra informatie:".mysql_errno());
}
else {
print " <table width=\"100%\" cellspacing=0>\n";
print " <tr><td class=\"subTitle\"><b>Forum</b></td></tr>\n";
print " <tr><td class=\"mainTxt\">\n";
print " <table width=\"100%\" align=\"center\">\n";
print " <tr><td align=\"center\">\n";
print " Error!\n";
print " </tr></td>\n";
print " </table>\n";
print " </td></tr>\n";
print " </table>\n";
}
}
else {
print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td><table align=\"center\" width=\"100%\"><tr><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"80%\" colspan=\"2\"><b>Algemeen</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Topics</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Reacties</b></td></tr>\n";
$query = mysql_query("SELECT * FROM `[forum_sub]` WHERE `area`=1");
while($forum = mysql_fetch_object($query)) {
print " <tr onMouseOver=\"this.style.backgroundColor='#999999'; this.style.cursor='hand';\" onMouseOut=\"this.style.backgroundColor='';\" onClick=\"window.location.href='forum.php?sub={$forum->id}'\"><td width=\"0%\"></td><td width=\"80%\"><a href=\"forum.php?sub={$forum->id}\" target=\"_self\"><b>$forum->title</b></a><br>$forum->text</td><td align=\"center\" width=\"10%\">$forum->topics</td><td align=\"center\" width=\"10%\">$forum->replys</td></tr>\n";
}
if($data->hulpadmin > 0) {
print " <table width=\"100%\" align=\"center\"><tr><td><table align=\"center\" width=\"100%\"><tr><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"80%\" colspan=\"2\"><b>Team Forum</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Topics</b></td><td align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\" width=\"10%\"><b>Reacties</b></td></tr>\n";
$query = mysql_query("SELECT * FROM `[forum_sub]` WHERE `area`=2");
while($forum = mysql_fetch_object($query)) {
print " <tr onMouseOver=\"this.style.backgroundColor='#999999'; this.style.cursor='hand';\" onMouseOut=\"this.style.backgroundColor='';\" onClick=\"window.location.href='forum.php?sub={$forum->id}'\"><td width=\"0%\"></td><td width=\"80%\"><a href=\"forum.php?sub={$forum->id}\" target=\"_self\"><b>$forum->title</b></a><br>$forum->text</td><td align=\"center\" width=\"10%\">$forum->topics</td><td align=\"center\" width=\"10%\">$forum->replys</td></tr>\n";
}
}
print " </table></tr></td></table></td></tr></table>\n";
}

?>
</body>
</html>
<br>

ICTscripters

Dé plek voor IT

Dé plek voor IT

Port Father: beta van een browsergame in Antwerpen 1931, feedback welkom

Luchtvaartsoftware: Hoe technologie de moderne luchtvaart verandert

Hoe gebruiken jullie WhatsApp voor marketing en klantopvolging?

[PROJECT] Gamekeuring.nl - Hét onafhankelijke keuringsplatform voor maffiagames & RPG's!

Ictscripters / Koen

🚀 WE ZOEKEN TESTERS! 🚀

Kweekrijk - van stekje tot Imperium

Crimora.nl

295 Nieuwe Domeinnamen September 2026

Straatbaas.eu – complete Nederlandstalige en Engelstalige online maffia-RPG

[TE KOOP] CloutClubRPG.nl – Complete Maffia Rap & Street Clout RPG (Kant-en-klaar concept)

hulp bij forum

Registratie

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2

Gebruikers die dit topic bekijken