Webwereld

Error, alweer....

Gestart doorReins9 reacties29 weergaven
Log in om mee te praten

10 berichten · pagina 1 van 1

Reins

Lid · Topicstarter

Berichten
14.363
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hi,
ik heb FELS goed geinstaleerd, alleen nu krijg ik op alle paginas als ik ben ingelogd dit;

Quote:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/uhost/domains/uhost.one2xs.com/public_html/menu.inc.php on line 13

En als ik naar priveberichten ga dit;

Quote:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/uhost/domains/uhost.one2xs.com/public_html/bericht.php on line 157

Wie kan me helpen? je krijgt wel vergoeding...
0
Jort

Lid

Berichten
524
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Zonder script kunnen wij niets voor je betekenen.
0
Reins

Lid · Topicstarter

Berichten
14.363
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Van de eerste error:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]])){[/COLOR]
    ?>
    <ul style="list-style:none; padding:0;">
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]index[/COLOR][COLOR= #007700];[/COLOR] ?>">Home</a></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]inloggen[/COLOR][COLOR= #007700];[/COLOR] ?>">Inloggen</a></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]registreren[/COLOR][COLOR= #007700];[/COLOR] ?>">Registreren</a></li>
    </ul>
    [COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]}[/COLOR]

[URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [COLOR= #0000BB]$Bericht[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM system_berichten WHERE naar = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$UserFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND gelezen = 0"[/COLOR][COLOR= #007700]));[/COLOR]

    ?>
    <ul style="list-style:none; padding:0;">
    <b>Algemeen</b>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>index">Home</a></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>editprofile">Profiel aanpassen</a></li>
    <li>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$Bericht[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>"[/COLOR][COLOR= #007700]; }[/COLOR] ?><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>bericht">Berichten ([COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/number_format"]number_format[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$Bericht[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000],[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000].[/COLOR][COLOR= #007700]);[/COLOR] ?>)</a>[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$Bericht[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</b>"[/COLOR][COLOR= #007700]; }[/COLOR] ?></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>ledenlijst">Ledenlijst</a></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>online">Online Leden</a></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>forum">Forum</a></li>
    <li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>support">Support</a></li>
    <br /><li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>uitloggen">Uitloggen</a></li>
    [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]is_rang[COLOR= #007700]([/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$uRang[/COLOR][COLOR= #007700])){[/COLOR] ?> <br /><li><a href="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] _ROOT_[COLOR= #007700];[/COLOR] ?>admin">Admin</a></li> [COLOR= #0000BB]<?php[/COLOR] [COLOR= #007700]}[/COLOR] ?>
    </ul>
    [COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]}[/COLOR]


2e error:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/define"]define[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]_TITLE_[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]Berichten[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]header.php[/COLOR][COLOR= #007700]);[/COLOR]
?>

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR]is_rang[COLOR= #007700]([/COLOR][COLOR= #DD0000]loggedin[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$uRang[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je moet zijn ingelogd om deze pagina te bekijken"[/COLOR][COLOR= #007700];
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]])){[/COLOR]
        [COLOR= #0000BB]$bQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM system_berichten WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Dit bericht bestaat niet"[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$bFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]] &&[/COLOR] [COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]van[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) && ![/COLOR]is_rang[COLOR= #007700]([/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$uRang[/COLOR][COLOR= #007700])){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je mag dit bericht niet bekijken!"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]] &&[/COLOR] [COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gelezen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE system_berichten SET gelezen = 1 WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
                }[/COLOR]
                
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</b><br />"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<table>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td width=85px>Van:</td><td><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"profile/"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]van[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]van[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td>Naar:</td><td><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"profile/"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td>Onderwerp:</td><td>"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td>Datum:</td><td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table><br />"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [URL="http://www.php.net/nl2br"]nl2br[/URL][COLOR= #007700]([/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]));
            }
        }
    }[/COLOR]
    [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]new[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht>Inbox</a> | <a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/outbox>Verzonden Berichten</a><br />"[/COLOR][COLOR= #007700];[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]new[/COLOR][COLOR= #007700]])){[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]]) ||[/COLOR] [URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]) ||[/COLOR] [URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]])){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"U hebt niet alle velden ingevuld!"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$cQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM system_berichten WHERE DATE_ADD(datum, INTERVAL 30 SECOND) > NOW() AND van = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cQuery[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]&& ![/COLOR]is_rang[COLOR= #007700]([/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$uRang[/COLOR][COLOR= #007700])){[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je mag maar eens per 30 seconde een bericht versturen"[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                    [COLOR= #0000BB]$lQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden_leden WHERE uName = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lQuery[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Dit lid bestaat niet"[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$UserFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]]){[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je kunt geen berichten naar jezelf sturen"[/COLOR][COLOR= #007700];
                        }[/COLOR]
                        [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                            [COLOR= #0000BB]$lFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$lQuery[/COLOR][COLOR= #007700]);[/COLOR]
                            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO
                                            system_berichten
                                            (van, naar, onderwerp, bericht, datum)
                                        VALUES(
                                            "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]",
                                            "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$lFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]",
                                            "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]",
                                            "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]",
                                            NOW()
                                        )
                            "[/COLOR][COLOR= #007700]);[/COLOR]
                            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Succesvol verstuurd!"[/COLOR][COLOR= #007700];
                        }
                    }
                }
            }
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            ?>
            <form action="" method="post">
            <table>
            <tr>
                <td>Aan</td>
                <td><input type="text" name="naar" value="[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]]);[/COLOR] ?>" /></td>
            </tr>
            <tr>
                <td>Onderwerp</td>
                <td><input type="text" name="onderwerp" /></td>
            </tr>
            <tr>
                <td>Bericht</td>
                <td><textarea rows="7" cols="35" name="bericht"></textarea></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" name="new" value="Versturen" /></td>
            </tr>
            </table>
            </form>
            [COLOR= #0000BB]<?php[/COLOR]
        [COLOR= #007700]}
    }[/COLOR]
    [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]del[/COLOR] [COLOR= #007700]&&[/COLOR] [URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]])){[/COLOR]
        [COLOR= #0000BB]$bQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM system_berichten WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Dit bericht bestaat niet"[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$bFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR]is_rang[COLOR= #007700]([/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$uRang[/COLOR][COLOR= #007700]) &&[/COLOR] [COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Dit bericht is niet voor jou!"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM system_berichten WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Succesvol verwijderd!"[/COLOR][COLOR= #007700];
            }
        }
    }[/COLOR]
    [URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$param[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]outbox[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht>Inbox</a> | <a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/new>Nieuw Bericht</a><br />"[/COLOR][COLOR= #007700];[/COLOR]
        
        [COLOR= #0000BB]$bQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM system_berichten WHERE van = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$UserFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" ORDER BY datum DESC"[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt nog geen berichten verstuurd"[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<table width=55%>"[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700])){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gelezen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>"[/COLOR][COLOR= #007700]; }[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gelezen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</b>"[/COLOR][COLOR= #007700]; }[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"profile/"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naar[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=150px>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table>"[/COLOR][COLOR= #007700];
        }
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]del[/COLOR][COLOR= #007700]])){[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Id[/COLOR][COLOR= #007700]])){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Geen berichten geselecteerd"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/foreach"]foreach[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]Id[/COLOR][COLOR= #007700]] as[/COLOR] [COLOR= #0000BB]$id[/COLOR][COLOR= #007700]){[/COLOR]
                    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM system_berichten WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
                }[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Succesvol verwijderd!"[/COLOR][COLOR= #007700];
            }
        }[/COLOR]
        [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/new>Nieuw Bericht</a> | <a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/outbox>Verzonden Berichten</a><br />"[/COLOR][COLOR= #007700];[/COLOR]
            
            [COLOR= #0000BB]$bQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM system_berichten WHERE naar = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$UserFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" ORDER BY datum DESC"[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt nog geen berichten"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<form action= method=post>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<table width=60%>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bQuery[/COLOR][COLOR= #007700])){[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px><input type=checkbox name=Id[] value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" /></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gelezen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>"[/COLOR][COLOR= #007700]; }[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onderwerp[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gelezen[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</b>"[/COLOR][COLOR= #007700]; }[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"profile/"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]van[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]IdNaarNaam[COLOR= #007700]([/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]van[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=150px>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<td width=16px><a href="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"bericht/del/"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"><img src="[/COLOR][COLOR= #007700].[/COLOR]_ROOT_[COLOR= #007700].[/COLOR][COLOR= #DD0000]"images/del.png alt=Del /></a></td>"[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</tr>"[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<tr><td colspan=5><input type=submit name=del value=Verwijder Selectie /></td></tr>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</table>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"</form>"[/COLOR][COLOR= #007700];
            }
        }
    }
}[/COLOR]
?>

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]footer.php[/COLOR][COLOR= #007700]);[/COLOR]
?>
0
Ordian

Lid

Berichten
1.160
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
eerste lijn 13

$Bericht = mysql_num_rows(mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." AND gelezen = 0"));


Verander naar:

$Bericht = mysql_num_rows( mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." AND gelezen = 0") or die(mysql_error()) );


Post dan error.

tweede lijn 156

$bQuery = mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." ORDER BY datum DESC");


Naar

$bQuery = mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." ORDER BY datum DESC") or die(mysql_error());
0
Reins

Lid · Topicstarter

Berichten
14.363
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ordian schreef:
eerste lijn 13

$Bericht = mysql_num_rows(mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." AND gelezen = 0"));
Verander naar:

$Bericht = mysql_num_rows( mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." AND gelezen = 0") or die(mysql_error()) );


Post dan error.

tweede lijn 156

$bQuery = mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." ORDER BY datum DESC");


Naar

$bQuery = mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." ORDER BY datum DESC") or die(mysql_error());


bij de eerste krijg ik witte pagina met "Table uhost_sys.system_berichten doesnt exist"sm_eerie
0
Simon

Lid

Berichten
262
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
ten eerste haal in qury de * weg

$Bericht = mysql_num_rows(mysql_query("SELECT * FROM system_berichten WHERE naar = ".$UserFetch[uId]." AND gelezen = 0"));


vul daar alleen de rijen in die je wilt op halen.
waar door je script wat sneller wordt.haalt het niet alle overtollige rijen op

$Bericht = mysql_num_rows(mysql_query("SELECT id, rij, enzv FROM system_berichten WHERE naar = ".$UserFetch[uId]." AND gelezen = 0"));


@rienier
bestaat tabel naar wel??
of de inhoud is komt niet overeen met $UserFetch[uId] (type)
0
Ordian

Lid

Berichten
1.160
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
@Simon slecht script is slecht.

else{
            echo <a href=" . _ROOT_ . bericht/new">Nieuw Bericht</a> | <a href=" . _ROOT_ . bericht/outbox">Verzonden Berichten</a><br />;
            
            $bQuery = mysql_query("SELECT id, onderwerp, gelezen, van, datum  FROM system_berichten WHERE naar = ".$UserFetch[uId]." ORDER BY datum DESC");
            if(mysql_num_rows($bQuery) == 0){
                echo Je hebt nog geen berichten;
            }
            else{
                echo <form action="" method="post">;
                echo <table width="60%">;
                while($bFetch = mysql_fetch_assoc($bQuery)){
                    echo <tr>;
                    echo <td width="16px"><input type="checkbox" name="Id[]" value=" . $bFetch[id] . " /></td>;
                    echo <td>;
                    $berichtinfo = <a href=" . _ROOT_ . bericht/ . $bFetch[id] . "> . $bFetch[onderwerp] . </a>;
                    if($bFetch[gelezen] == 0){
                              echo <b> . $berichtinfo  . </b>;
                    }
                    else {
                              echo $berichtinfo;
                    }
                    echo </td>;
                    echo <td><a href=" . _ROOT_ . profile/ . IdNaarNaam($bFetch[van]) . "> . IdNaarNaam($bFetch[van]) . </a></td>;
                    echo <td width="150px"> . $bFetch[datum] . </td>;
                    echo <td width="16px"><a href=" . _ROOT_ . bericht/del/ . $bFetch[id] . "><img src=" . _ROOT_ . images/del.png" alt="Del" /></a></td>;
                    echo </tr>;
                }
                echo <tr><td colspan="5"><input type="submit" name="del" value="Verwijder Selectie" /></td></tr>;
                echo </table>;
                echo </form>;
            }
        }


            if(mysql_num_rows($bQuery) == 0){


En voer even de sql uit van het tabel system_berichten want het bestaat niet eens.
0
Reins

Lid · Topicstarter

Berichten
14.363
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Waarom zou Fels wel gewoon bij andere mensen werken zonder scripts te editten en bij mij nietsm_eerieIk snap niks van jullie, dus even voor de duidelijkheid; ik ben een beginner.
0
Wiitse

Lid

Berichten
6.722
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Bij mij werkte allen gewoon in 1 keer.
0
Reins

Lid · Topicstarter

Berichten
14.363
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Bij mij dus niet.
Maar als het goed is krijg ik een systeem van Climax thumbsup
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren