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

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

Developer Gezocht

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Afspraken systeem met planbeperking

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Verschillende domeinen

350 Nieuwe Domeinnamen Januari 2026

321 Nieuwe Domeinnamen December 2025

hulp bij forum

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

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