hulp bij forum

gofie · 29 Juni 2011

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 · 29 Juni 2011

PHP

while($forum = mysql_fetch_object($query))

L.Groot · 29 Juni 2011

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 · 29 Juni 2011

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 · 29 Juni 2011

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

gofie · 29 Juni 2011

ja

L.Groot · 29 Juni 2011

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

gofie · 29 Juni 2011

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>

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Plesk installer

cpanel / whm themes

PHP Point of Sale

Probleem omtrent Tinymce

Kunnen jullie mij helpen met deze enquete

een eigen cloud sever

Probleem C++ en CL

193 Nieuwe domeinnamen April 2025

228 Nieuwe domeinnamen Maart 2025

285 Nieuwe domeinnamen Februari 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

Delen