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

Het Grote Vibe Code Topic

PWYL source gezocht

Ictscripters Chat

Help testers nodig voor android app Urgent

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Afspraken systeem met planbeperking

Developer Gezocht

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

359 Nieuwe Domeinnamen Mei 2026

Sicarras.com - Moderne Mafia Text-Based RPG

370 Nieuwe Domeinnamen April 2026

hulp bij forum

Participate now!

Quanscient ontvangt €10M om AI- en kwantum-native hardware engineering te bevorderen - Tech.eu

Datalek bij leverancier Canvas - Universiteit van Amsterdam

Data privacy in 2026: Hoe de naleving van GDPR verandert

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