Bedankt voor je hulp, maar dat was niet de oplossing, hij doet het nog steeds niet...^o)
Posts by NickGames
-
-
Ik heb hier een error, en ik kom er maar niet uit...
Dit is het deel van een script waar een error in zit:PHP
Toon Meer<?php } if ($pages > 1) { $prev = $_GET['p'] - 1; $next = $_GET['p'] + 1; $dbres = mysql_query("SELECT id FROM users WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(online) < 300"); print "</table>nn<table width=100%>n <tr><td class="mainTxt" align="center">"; if (mysql_num_rows($dbres) <= -1) { print "< 1 ></td></tr></table>n"; } else { if ($begin / 50 == 0) { print "<< Vorige | "; } else { print "<a href="index.php?a=onlineleden&p=" . ($begin / 50 - 1) . ""><< Vorige</a> | "; } for ($i = 0; $i < mysql_num_rows($dbres) / 50; $i++) { $j = $i + 1; print "<a href="index.php?a=onlineleden&p=$i">$j</a> | "; } if ($begin + 50 >= mysql_num_rows($dbres)) { print "Volgende >> "; } else { print "<a href="index.php?a=onlineleden&p=" . ($begin / 50 + 1) . "">Volgende >></a>"; } } } ?>
Hier zou de bug in moeten zitten (line 11):
Dit is de error:
PHPParse error: syntax error, unexpected T_STRING in /storage/mijndomein/users/134667/public/sites/www.undercrimes.com/v3/onlineleden.php on line 145
Zou je me plz even willen helpen?
Mvg,
Nick. -
Ga naar: http://dutchleader.nl, maak een account, en doe de Acties.
dan heb je er al snel 5000+;) -
Ok, bedankt voor je tip, ik zal kijken wat ik er mee kan doen;).
Mijn iedee was zowieso al om een source te maken, maar ik wilde eerst dat hij PREZIES hetzelfde zou worden als het orgineel, maar dat zit er volgens mij niet in.
Ik begin nu te betwijfelen of ik hier genoeg ervaring voor heb, maar als er nog steeds mensen zijn die willen helpen, ga ik er gewoon mee door!;)
Mvg,
Nick. -
Ik had eigenlijk in gedachte om echt een CLONE te maken, je, maar na jouw verhaal lijkt dat me toch niet zo handig nee.
Ik denk dat ik maar wat aan de layout moet gaan doen dan.
Wil je dan alsnog helpen??;)
Mvg,
Nick. -
-
Nou, ik doe het puur om ervaring op te doen.
Maar de hosting, en domein registratie kosten zijn voor mij.
Andere kosten die hiermee te maken hebben ook.
Dus jullie hoefen in ieder geval niets te betalen(xD).
Mvg,
Nick. -
Ik wil gaan beginnen om een nederlandse clone te maken van de laatste versie van http://www.bitefight.nl.
Ik ben een Beginner - Gevorderde (er tussen in) scripter, en ik zoek iemand die intresse heeft mij ermee te helpen.
Waarom wil ik hieraan beginnen:
Ik wil meer ervaring opdoen als scripter en steeds meer leren..
ik heb al veel ervaring opgedaan met het fixen en editen van criminals sources, dus nu wil ik ervaring op doen doormiddel van een clone te maken.
Waarom bitefight:
Ik vond Bitefight wel een goed spel om een clone van te maken, want je kunt gewoon het orgineel erbij houden, hij is bij best veel mensen gewild, en het is niet TE moeilijk
;)!Dingen die ik al heb:
- CSS bestanden
- Alle images/plaatjes
- De FAQ
Dus de lay-out heb ik al:p.Heb je intresse?
stuur me dan een bericht en/of post het hier.
Mvg,
Nick.:p -
Ik ben het met Superior eens.
Op http://www.cronjob.nl/ wordt alles goed uitgelegd!;) -
Dit is het forum script ja:
http://plaatscode.be/137941/(xD)
Ok, heel erg bedankt!
cri heeft het DEELS voor me opgelost.
Die databse klopt wel.
Maar het script klopt nog niet helemaal!
Dit is het volgende probleem:
als ik bijvoorbeeld idt in typ in een topic:PHPGamesCrime is de beste, alleen functioneerd het forum nog niet goed! Maar dit wordt zo spoedig mogenlijk opgelost.
Dan komt dit te staan als ik het post
PHPGamesCrime is de beste,rnalleen functioneerd het forum nog niet goed!rnMaar dit wordt zo spoedig mogenlijk opgelost.
Kijk anders beter even naar deze link: http://www.gamescrime.n1ckx.com/forum.php?topic=35Ik weet niet hoe ik dit dan weer op moet lossen, dus vraag ik jullie om hulp!
Alvast bedankt!
Mvg,
Nick. -
Sorry dat ik nog een keer dit post, maar die andere was op een of andere manier, een witte pagina.
Mijn probleem: ik hab een forum voor mijn crime game, maar hij doet het niet...
Hier is de link:.
Ik denk dat ik de verkeerde sql tabels ofzo, heb toegevoegd, dus zou iemand plz even willen posten, wat ik in mijn database moet toevoegen?
Alvast heel erg bedankt!
Mvg,
Nick.:p -
Kan iemand me plz helpen, ik heb hier een forum script, maar hij werkt niet zoals hij zou moeten werken...
Dus hierbij vraag ik bij jullie hulp.
Zou iemand plz kunnen helpen met wat ik allemaal moet invoegen in mijn database??
Hier is een voorbeeld: http://gamescrime.n1ckx.com/forum.php
Hier is het script:
[code=php]<?phpinclude 'includes/config.php';
include("ubb.php");
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['p'])){
$_GET['p']=htmlspecialchars(addslashes($_GET['p']));
}
if(isset($_GET['topic'])){
$_GET['topic']=htmlspecialchars(addslashes($_GET['topic']));
}
if(isset($_GET['slotje'])){
$_GET['slotje']=htmlspecialchars(addslashes($_GET['slotje']));
}
if(isset($_GET['delreply'])){
$_GET['delreply']=htmlspecialchars(addslashes($_GET['delreply']));
}
if(isset($_GET['verplaats'])){
$_GET['verplaats']=htmlspecialchars(addslashes($_GET['verplaats']));
}
if(isset($_POST['forum'] )){
$_POST['forum'] =htmlspecialchars(addslashes($_POST['forum'] ));
}
if(isset($_GET['reageer'])){
$_GET['reageer']=htmlspecialchars(addslashes($_GET['reageer']));
}
if(isset($_GET['quote'])){
$_GET['quote']=htmlspecialchars(addslashes($_GET['quote']));
}
if(isset($_GET['edittopic'])){
$_GET['edittopic']=htmlspecialchars(addslashes($_GET['edittopic']));
}
if(isset($_GET['editreply'])){
$_GET['editreply']=htmlspecialchars(addslashes($_GET['editreply']));
}
if(isset($_GET['delreply'])){
$_GET['delreply']=htmlspecialchars(addslashes($_GET['delreply']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}if(! $_GET['p']) {
$begin = 0;
}
else {
$begin = $_GET['p'];
}
/* ------------------------- */ ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="javascript">
function icon(theicon) {
document.form3.info.value += ""+theicon;
document.form3.info.focus();
}function setsmilie(which){
document.form3.info.value = document.form3.info.value + which;
}</script>
<title>Crimelife</title>
<link rel="stylesheet" type="text/css" href="css-v1.css">
<body style="background: #4B3D32; margin: 0px;"><?
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->type != 1) {
print " <table width=\"75%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"75%\" 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=\"75%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"75%\" 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=\"75%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"75%\" 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=\"75%\" align=\"center\"><tr><td><div align=\"left\"><a href=\"forum.php?newtopic={$_GET['sub']}\"><b>Nieuw Onderwerp</b></a></div><div align=\"right\">\n";
print " </div></td></tr><tr><td align=\"left\">Moderator(s): <font color=red><b>$mods</b></font></td></tr><tr><td><table align=\"center\" width=\"100%\"><tr><td width=\"5%\" align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\"> </td><td align=\"center\" 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=\"center\" 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)) {
$forum->title = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("kut", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("kloten", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("pik", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("penis", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("vagina", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("lul", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("cancer", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("leier", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("neuk", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("anaal", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
if($forum->slotje == 0) {
$image = "opentopic.gif";
}
else {
$image = "closed.gif";
}
if($forum->datum == "") {
$forum->datum = "Geen";
}
if($forum->title == "") {
$forum->title = "Geen";
}
print " <tr><td width=\"5%\"><a href=\"forum.php?verplaats={$forum->id}\"><img src=\"images/icons/{$image}\" border=0></a></td><td width=\"45%\"><a href=\"forum.php?topic={$forum->id}\"><b>$forum->title</b></a></td><td align=\"center\" width=\"10%\"><a href=\"profile.php?x={$forum->login}\">$forum->login</a></td><td align=\"center\" width=\"10%\">$forum->replys</td><td width=\"30%\">$forum->datum</td></tr><tr>\n";
}
print " </table></tr></td></table></td></tr></table>\n";
}
elseif($_GET['topic']) {
if(isset($_POST['add'])) {
$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 align=\"center\">Je bericht is geplaatst.<BR><BR><a href=\"forum.php?topic={$_GET['topic']}\">Terug</a></td></tr></table></td></tr></table>\n";
mysql_query("INSERT INTO `[foum_replys]`(topicid,subid,datum,login,title,text,date) values($id,'{$lol->subid}','$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 {
$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`,`avatar` FROM `[users]` WHERE `login`='{$topic->login}'");
$user2 = mysql_fetch_object($user_query2);if($user2->forumstatus == "gwsp1") {
$status = "<font color=green><b>Moderator</b></font>";
}
elseif($user2->forumstatus == "gwsp2") {
$status = "<font color=red><b>Webmaster</b></font>";
}
elseif($user2->forumposts <= 50) {
$status = "Forum Beginner";
}
elseif($user2->forumposts <= 150) {
$status = "Forum Freak";
}
elseif($user2->forumposts > 150) {
$status = "Forum God";
}
elseif($user2->forumposts > 750) {
$status = "Forum Piraat";
}
else {
$status = "Normaal";
}
if(time() - $user2->online < 300) {
$online2 = "<img src=\"images/icons/online.gif\"> <font color=green><b>Online</b></font>";
}
else {
$online2 = "<img src=\"images/icons/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=([^\\[]*)\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=_blank>\\2</a>",$topic->text);
$topic->text = eregi_replace("\\[img]([^\\[]*)\\[/img\\]","<img src=\"\\1\">",$topic->text);
$topic->text = eregi_replace("\\Citaat van ([^\\[*)\\]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td><b>\\1 schreef:</b></td></tr><tr><td>\\2</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$topic->text);
$topic->text = eregi_replace("\\[quote]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td>\\1</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$topic->text);
$topic->text = str_replace("(h)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$topic->text);
$topic->text = str_replace("(H)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$topic->text);
$topic->text = str_replace(":$", "<img src=\"images/smilies/icon_embarassed.gif\" border=0>",$topic->text);
$topic->text = str_replace(":(", "<img src=\"images/smilies/icon_frown.gif\" border=0>",$topic->text);
$topic->text = str_replace("(a)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$topic->text);
$topic->text = str_replace("(A)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$topic->text);
$topic->text = str_replace("(k)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$topic->text);
$topic->text = str_replace("(K)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$topic->text);
$topic->text = str_replace(":D", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$topic->text);
$topic->text = str_replace(":d", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$topic->text);
$topic->text = str_replace("(m)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$topic->text);
$topic->text = str_replace("(M)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$topic->text);
$topic->text = str_replace(":#", "<img src=\"images/smilies/icon_sealed.gif\" border=0>",$topic->text);
$topic->text = str_replace(":)", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$topic->text);
$topic->text = str_replace(":0", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$topic->text);
$topic->text = str_replace(":o", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$topic->text);
$topic->text = str_replace(":O", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$topic->text);
$topic->text = str_replace(":p", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$topic->text);
$topic->text = str_replace(":P", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$topic->text);
$topic->text = str_replace(";)", "<img src=\"images/smilies/icon_wink.gif\" border=0>",$topic->text);
$topic->text = str_replace(":@", "<img src=\"images/smilies/icon_yell.gif\" border=0>",$topic->text);$topic->text = eregi_replace("kut", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("kloten", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("pik", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("penis", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("vagina", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("lul", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("cancer", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("leier", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("neuk", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("anaal", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = str_replace("\\\'", "'", $topic->text);
$topic->text = str_replace("\\\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\r'", "'", $topic->text);
$topic->text = str_replace("\n'", "'", $topic->text);print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><table align=\"center\" width=\"100%\" cellspacing=0><tr><td class=\"mainTxt\"><table width=\"100%\"><tr><td width=\"110\" valign=\"top\"><b><a href=\"profile.php?x={$topic->login}\">$topic->login</a></b><BR>$status<BR><BR><img src=\"{$user2->avatar}\" width=\"100\" height=\"100\"><BR><BR>$online2<BR>Berichten: $user2->forumposts</td><td valign=\"top\" align=\"left\">$topic->text</td></tr>\n";
if($data->login == $topic->login) {
print " <tr><td><i>$topic->datum1</i></td><td colspan=2 align=\"right\"><a href=\"forum.php?edittopic={$topic->id}\">Bewerken</a></td></tr></table></td></tr>\n";
}
else {
print " <tr><td><i>$topic->datum1</i></td><td colspan=2> </td></tr></table></td></tr>\n";
}
$query2 = mysql_query("SELECT * FROM `[foum_replys]` WHERE `topicid`={$_GET['topic']} AND `del`=0 ORDER BY `date` ASC LIMIT $begin,10");
while($forum = mysql_fetch_object($query2)) {
$user_query = mysql_query("SELECT UNIX_TIMESTAMP(`online`) AS `online`,`forumstatus`,`login`,`forumposts`,`avatar` FROM `[users]` WHERE `login`='{$forum->login}'");
$user = mysql_fetch_object($user_query);
$forum->text = htmlspecialchars($forum->text);
$forum->text = nl2br($forum->text);
$forum->text = str_replace("", "<b>",$forum->text);
$forum->text = str_replace("", "</b>",$forum->text);
$forum->text = str_replace("", "<i>",$forum->text);
$forum->text = str_replace("", "</i>",$forum->text);
$forum->text = str_replace("", "<u>",$forum->text);
$forum->text = str_replace("", "</u>",$forum->text);
$forum->text = eregi_replace("\\[color=([^\\[]*)\\]([^\\[]*)\\[/color\\]","<font color=\"\\1\">\\2</font>",$forum->text);
$forum->text = eregi_replace("\\[email=([^\\[]*)\\]([^\\[]*)\\[/email\\]", "<a href=\"mailto:\\1\">\\2</a>",$forum->text);
$forum->text = eregi_replace("\\[url=([^\\[]*)\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=_blank>\\2</a>",$forum->text);
$forum->text = eregi_replace("\\[img]([^\\[]*)\\[/img\\]","<img src=\"\\1\">",$forum->text);
$forum->text = eregi_replace("\\[quote=([^\\[]*)\\]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td><b>\\1 schreef:</b></td></tr><tr><td>\\2</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$forum->text);
$forum->text = eregi_replace("\\[quote]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td>\\1</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$forum->text);
$forum->text = str_replace("(h)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$forum->text);
$forum->text = str_replace("(H)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$forum->text);
$forum->text = str_replace(":$", "<img src=\"images/icons/smilies/icon_embarassed.gif\" border=0>",$forum->text);
$forum->text = str_replace(":(", "<img src=\"images/smilies/icon_frown.gif\" border=0>",$forum->text);
$forum->text = str_replace("(a)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$forum->text);
$forum->text = str_replace("(A)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$forum->text);
$forum->text = str_replace("(k)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$forum->text);
$forum->text = str_replace("(K)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$forum->text);
$forum->text = str_replace(":D", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$forum->text);
$forum->text = str_replace(":d", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$forum->text);
$forum->text = str_replace("(m)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$forum->text);
$forum->text = str_replace("(M)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$forum->text);
$forum->text = str_replace(":#", "<img src=\"images/smilies/icon_sealed.gif\" border=0>",$forum->text);
$forum->text = str_replace(":)", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$forum->text);
$forum->text = str_replace(":0", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$forum->text);
$forum->text = str_replace(":o", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$forum->text);
$forum->text = str_replace(":O", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$forum->text);
$forum->text = str_replace(":p", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$forum->text);
$forum->text = str_replace(":P", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$forum->text);
$forum->text = str_replace(";)", "<img src=\"images/smilies/icon_wink.gif\" border=0>",$forum->text);
$forum->text = str_replace(":@", "<img src=\"images/smilies/icon_yell.gif\" border=0>",$forum->text);$forum->text = eregi_replace("kut", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("kloten", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("pik", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("penis", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("vagina", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("lul", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("cancer", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("leier", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("neuk", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("anaal", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = str_replace("\\\'", "'", $forum->text);
$forum->text = str_replace("\\\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\r'", "'", $forum->text);
$forum->text = str_replace("\n'", "'", $forum->text);
$forum->text = str_replace("\r'", "'", $forum->text);
$forum->text = str_replace("\r\n\r\n\r\n'", "'", $forum->text);
$forum->text = str_replace("\r\n\r\n'", "'", $forum->text);if($user->forumstatus == "gwsp1") {
$status = "<font color=green><b>Moderator</b></font>";
}
elseif($user->forumstatus == "gwsp2") {
$status = "<font color=red><b>Webmaster</b></font>";
}
elseif($user->forumposts <= 50) {
$status = "Forum Beginner";
}
elseif($user->forumposts <= 150) {
$status = "Forum Freak";
}
elseif($user->forumposts > 150) {
$status = "Forum God";
}
elseif($user->forumposts > 750) {
$status = "Forum Piraat";
}
else {
$status = "Normaal";
}if(time() - $user->online < 300) {
$online = "<img src=\"images/icons/online.gif\"> <font color=green><b>Online</b></font>";
}
else {
$online = "<img src=\"images/icons/offline.gif\"> <font color=red><b>Offline</b></font>";
}
print " <tr><td class=\"mainTxt\"><table width=\"100%\"><tr><td width=\"110\" valign=\"top\"><b><a href=\"profile.php?x={$forum->login}\">$forum->login</a></b><BR>$status<BR><BR><img src=\"{$user->avatar}\" width=\"100\" height=\"100\"><BR><BR>$online<BR>Berichten: $user->forumposts</td><td valign=\"top\" align=\"left\">$forum->text</td></tr>\n";
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
print " <tr><td><i>$forum->datum</i></td><td colspan=3 align=\"right\"><a href=\"forum.php?delreply={$forum->id}\">Verwijderen</a> | <a href=\"forum.php?editreply={$forum->id}\">Bewerken</a> | <a href=\"forum.php?reageer={$topic->id}"e={$forum->id}\"></a></td></tr></table></td></tr>\n";
}
elseif($data->login == $forum->login) {
print " <tr><td><i>$forum->datum</i></td><td colspan=3 align=\"right\"><a href=\"forum.php?editreply={$forum->id}\">Bewerken</a></td></tr></table></td></tr>\n";
}
else {
print " <tr><td><i>$forum->datum</i></td><td colspan=3><a href=\"forum.php?reageer={$topic->id}"e={$forum->id}\">Quote</a></td></tr></table></td></tr>\n";
}
}
print " <tr><td class=\"mainTxt\"><b>Pagina:</b> \n";
$dbres = mysql_query("SELECT * FROM `[foum_replys]` WHERE `topicid`={$_GET['topic']} AND `del`=0");
$sub_query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['topic']}");
$sub = mysql_fetch_object($sub_query);
print "";
for($i=0; $i<mysql_num_rows($dbres)/10; $i++) {
print " <a href=\"forum.php?topic={$_GET['topic']}&p={$i}0\" target=\"_self\">". ($i+1) ."</a> ";
}
echo "<a href=\"forum.php\">Forumkeuze</a> | <a href=\"forum.php?sub=$sub->subid\">Terug naar forum</a>";
if($topic->slotje == 1) {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\"><font color=red><b>Dit Onderwerp is gesloten.</b></font></td></tr></table></tr></td></table></td></tr></table>\n";
}
elseif($topic->slotje == 0 && $data->forumstatus == "gwsp1") {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\"></textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form><tr><td align=\"center\"><BR><a href=\"forum.php?slotje={$topic->id}\"><img src=\"images/icons/slotje.gif\" border=0></a></td></tr><tr></table></tr></td></table></td></tr></table>\n";
}
elseif($topic->slotje == 0 && $data->forumstatus == "gwsp2") {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\"></textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form><tr><td align=\"center\"><BR><a href=\"forum.php?slotje={$topic->id}\"><img src=\"images/icons/slotje.gif\" border=0></a></td></tr><tr></table></tr></td></table></td></tr></table>\n";
}
else {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\"></textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form></table></tr></td></table></td></tr></table>\n";
}
}
}
elseif($_GET['slotje']) {
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
mysql_query("UPDATE `[forum_topics]` SET `slotje`=1 WHERE `id`={$_GET['slotje']}");
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 hebt een slotje geplaatst.<BR><BR><a href=\"forum.php?topic={$_GET['slotje']}\">Terug</a></tr></td></table></td></tr></table>\n";
}
}
elseif($_GET['delreply']) {
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
$query = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['delreply']}");
$reply = mysql_fetch_object($query);
$query2 = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$reply->topicid}");
$topic = mysql_fetch_object($query2);
mysql_query("UPDATE `[users]` SET `forumposts`=`forumposts`-1 WHERE `login`='{$reply->login}'");
mysql_query("UPDATE `[foum_replys]` SET `del`=1 WHERE `id`={$_GET['delreply']}");
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`-1 WHERE `id`={$topic->subid}");
mysql_query("UPDATE `[forum_topics]` SET `replys`=`replys`-1 WHERE `id`={$topic->id}");
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\">Bericht is succesvol verwijdert.</tr></td></table></td></tr></table>\n";
}
}
elseif($_GET['verplaats']) {
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
$topic_query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['verplaats']}");
$topic = mysql_fetch_object($topic_query);
$sub_query = mysql_query("SELECT * FROM `[forum_sub]` ORDER BY `area` ASC");
if(isset($_POST['verplaats'])) {
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`-{$topic->replys},`topics`=`topics`-1 WHERE `id`={$topic->subid}");
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`+{$topic->replys},`topics`=`topics`+1 WHERE `id`={$_POST['forum']}");
mysql_query("UPDATE `[forum_topics]` SET `subid`={$_POST['forum']} WHERE `id`={$_GET['verplaats']}");
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\">Topic is verplaatst.</tr></td></table></td></tr></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 align=\"center\"><b>$topic->title</b><BR><form method=\"post\">Forum:<br><select name=\"forum\">\n";
while($sub = mysql_fetch_object($sub_query)) {
print "<option value=\"{$sub->id}\">$sub->title</option>";
}
print "</select> <input type=\"submit\" name=\"verplaats\" value=\" Verplaats \"></form></tr></td></table></td></tr></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 align=\"center\">Je mag geen berichten verplaatsen.</tr></td></table></td></tr></table>\n";
}
}
elseif($_GET['reageer']) {
if(isset($_POST['add'])) {
$id = $_GET['reageer'];
$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 align=\"center\">Je bericht is geplaatst.<BR><BR><a href=\"forum.php?topic={$_GET['topic']}\">Terug</a></td></tr></table></td></tr></table>\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['reageer']}") 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 {
$query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['reageer']}");
$topic = mysql_fetch_object($query);
if($topic->slotje == 0) {
if($_GET['quote']) {
$quote_query = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['quote']}");
$reply = mysql_fetch_object($quote_query);
$quote = "[quote={$reply->login}]{$reply->text}";
}
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\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\">{$quote}</textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form></table></tr></td></table>\n";
}
}
}
elseif($_GET['newtopic']) {
if(isset($_POST['add'])) {
$id = htmlspecialchars(addslashes($_GET['newtopic']));
$titel = htmlspecialchars(addslashes($_POST['title']));
$bericht = htmlspecialchars(addslashes($_POST['message']));
$datum = date("d-m-Y H:i");
print " <table width=\"100%\" cellspacing=0><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td class=\"subTitle\" align=\"left\"><b><img src=\"images/icons/blokje.jpg\"> Forum</b></td></tr><tr><td align=\"center\">Je bericht is geplaatst.</tr></td></table></td></tr></table>\n";
mysql_query("INSERT INTO `[forum_topics]`(subid,datum1,login,title,text,date,date1) values($id,'$datum','$data->login','$titel','$bericht',NOW(),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_sub]` SET `topics`=`topics`+1 WHERE `id`={$id}") 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 <<<ENDHTML
<script language="javascript">
function icon(theicon) {
document.form3.info.value += ""+theicon;
document.form3.info.focus();
}function setsmilie(which){
document.form3.info.value = document.form3.info.value + which;
}</script>
<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 class="mainTxt">
<table align="center" width="100%">
<form method="post" name="form1">
<tr><td class="subTitle" colspan=3><b>Nieuw Onderwerp</b></td><td width=\"100%"></td></tr>
<tr>
<td>Titel:</td>
<td><input type="text" size="20" name="title"></td><td width="100%"></td>
</tr>
<tr>
<td>Bericht:</td>
<td>
<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 = htmlspecialchars(addslashes($_POST['title']));
$bericht = htmlspecialchars(addslashes($_POST['message']));
$id = htmlspecialchars(addslashes($_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 gewijzigt.</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\">\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 = htmlspecialchars(addslashes($_POST['title']));
$bericht = htmlspecialchars(addslashes($_POST['message']));
$id = htmlspecialchars(addslashes($_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 gewijzigt.</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\">\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 gewijzigt.</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\">\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%\" cel -
Ok, nogmaals bedankt voor jullie reacties!!
Ik waardeer dit echt, maar ik ben zelf ook even bezig geweest, en ik heb het opgelost!
Voor degenen die benieuwd zijn hoe:PHP
Toon Meer<?php include 'includes/config.php'; logincheck(); include("functies.php"); mysql_query("UPDATE `[users]` SET online=NOW() WHERE login='". $data['login'] ."'"); $titel .= "Moord Ervaring"; ?> <html> <head> <title><?=$titel;?></title> <link href="style/play.css" rel="stylesheet" type="text/css"> </head> <?php if($data['moordervaring'] == 100){ print <<<ENDHTML <table width=100%> <tr><td class="subTitle"><b>Moord Ervaring</b></td></tr> <tr><td class="mainTxt"> <center>Gefeliciteerd, Je hebt al 100% moordervaring, dus je hoeft niet meer te trainen! </center> </td></tr> </table> </body> </html> ENDHTML; exit; }else{ if($data->misdaadtime > 0 ){ echo" <table width=100% > <tr><td class=\"subTitle\"><b>Sorry</b></td></tr> <tr><td class=\"mainTxt\"> <center> Je moet nog <?=misdaadtijd();?> wachten<br> <?</center> </td></tr> </table> </body>"; }else{ ?> <body> <?=cHeader();?> <?=gevangenis();?> <?=misdaad();?> <form method="POST" action="moordervaring.php"> <table width="100%" align="center" cellpadding="2" cellspacing="0"> <tr><td class="subTitle" colspan="3">Moord Ervaring</td></tr> <?php $p1a = $data['misdaadl'] / 2; $p1b = round($p1a); $p1 = rand($p1b / 2, $p1b); $p2a = $data['misdaadl'] / 2; $p2b = round($p2a); $p2 = rand($p2b / 2, $p2b); $p3a = $data['misdaadl']/3; $p3b = round($p3a); $p3 = rand($p3b/2 ,$p3b); $p4a = $data['misdaadl']/4; $p4b = round($p4a); $p4 = rand($p4b / 2, $p4b); // als er submit word if($_SERVER['REQUEST_METHOD'] == 'POST'){ if(!empty($_POST['code']) and $_POST['code'] == $_SESSION['cc_captcha']){ echo '<tr><td class=mainTxt colspan=3>'; $R1 = (isset($_POST['R1']) ? $_POST['R1'] : ''); if($data['rank'] == 1){ $rplus = 0.5; } elseif ($data['rank'] == 2){ $rplus = 0.1; } elseif ($data['rank'] == 3){ $rplus = 0.1; } elseif ($data['rank'] == 4){ $rplus = 0.1; } elseif ($data['rank'] == 5){ $rplus = 0.1; } elseif ($data['rank'] == 6){ $rplus = 0.1; } elseif ($data['rank'] == 7){ $rplus = 0.1; } elseif ($data['rank'] == 8){ $rplus = 0.1; } elseif ($data['rank'] == 9){ $rplus = 0.1; } elseif ($data['rank'] == 10){ $rplus = 0.1; } elseif ($data['rank'] == 11){ $rplus = 0.1; } elseif ($data['rank'] == 12){ $rplus = 0.1; } elseif ($data['rank'] == 13){ $rplus = 0.1; } elseif ($data['rank'] == 14){ $rplus = 0.1; } elseif ($data['rank'] == 15){ $rplus = 0.1; } elseif ($data['rank'] == 16){ $rplus = 0.1; } mysql_query("UPDATE `[users]` SET `crimes`=`crimes`+'1' WHERE login='". $data['login'] ."'"); if($R1 == ""){ echo 'Selecteer een Moord-optie'; } if($R1 == "1"){ $getal = rand(1,100); if($getal < $p1 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt ?'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == "1"){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt, je bent gewond, maar je bent ontsnapt wel aan de politie.'; exit; } } } // Als het misdaad 2 is if($R1 == "2"){ $getal = rand(1,100); if($getal < $p2 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt ?'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == "1"){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `health`=`health`-'1',`misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt, je bent gewond, maar je bent wel ontsnapt aan de politie.'; exit; } } } // Als het misdaad 3 is if($R1 == "3"){ $getal = rand(1,100); if($getal < $p3 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt ?'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == 1){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `health`=`health`-'1',`misdaad`=NOW(),`rankvord`=`rankvord`+'".$rplus."' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt, je bent gewond, maar je bent wel ontsnapt aan de politie.'; exit; } } } // Als het misdaad 4 is if($R1 == "4"){ $getal = rand(1, 100); if($getal < $p4 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt ?'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == 1){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90',`rankvord`=`rankvord`+'{$rplus}' WHERE `login`='{$_SESSION['login']}'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `health`=`health`-'3',`misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'De moord is niet gelukt, en je bent 3 health verloren!'; exit; } } } }else{ echo "<tr><td class='mainTxt' colspan=3>De code komt niet overeen met het plaatje !</td></tr>"; } } else { ?> <tr> <td width="57%" class="mainTxt"><input type="radio" name="R1" value="1"> Vermoord een agent. </td><td width="10%" class="mainTxt"><? echo $p1; ?>%</td> <td width="33%" rowspan="5" align="right" class="mainTxt"><img src="images/sniperview.jpg" width="331" height="232"></td> </tr> <tr> <td class="mainTxt"><input type="radio" name="R1" value="2"> Moord een restaurant uit. </td> <td class="mainTxt"><? echo $p2; ?>%</td> </tr> <tr><td class="mainTxt"><input type="radio" name="R1" value="3"> Moord een casino uit.</td> <td class="mainTxt"><? echo $p3; ?>%</td> </tr> <tr><td class="mainTxt"><input type="radio" name="R1" value="4"> Moord een politiebureau uit. </td> <td class="mainTxt"><? echo $p4; ?>%</td> </tr> <tr> <td class="mainTxt" colspan="2"><table border="0" cellpadding="0" cellspacing="0"> <tr> <td><img src="coden.php" alt=""> </td> <td> <strong>Code:</strong> <input name="code" type="text" size="4" maxlength="4" /></td> </tr></table></td> </tr> <tr><td class="mainTxt" colspan="3" align="center"><input name="submit" type="submit" class="button" value="Vermoord"></td></tr> <?php }}} ?> ?> </table> </form> </body> </html>
Dus, echt bedankt voor jullie hulp, en dit Topic kan :slotje::slotje::slotje:!!
Mvg,
Nick. -
Heel erg bedankt voor je reactie, maar hij doet het nog steeds niet :(..
Ik weet nu ook niet meer hoe het zit hoor..
Als iemand de oplossing wist...
Toch bedankt in ieder geval!:p
Andere reacties zijn nog steeds welkom! -
Nee, ik heb alles geprobeert wat hier al bij staat, maar nog steeds zonder resultaat^o)..
In ieder geval bedankt voor de moeite, en ik hoop dat er nog anderen zijn die een / de oplossing hebben!;) -
Ik heb hier een script om moordervaring te trainen, het was oorspronkelijk om misdaden te doen, maar ik heb het ff snel verandert, dus let daar alstublieft niet op.
Mijn probleem is: het lukt mij momenteel even niet, om als je 100% moordervaring hebt, dat je dan niet meer kan trainen...
Zou iemand even kunnen helpen alsjeblieft??
Hier is het script:PHP
Toon Meer<?php include 'includes/config.php'; logincheck(); include("functies.php"); mysql_query("UPDATE `[users]` SET online=NOW() WHERE login='". $data['login'] ."'"); $titel .= "Moord Ervaring"; ?> <html> <head> <title><?=$titel;?></title> <link href="style/play.css" rel="stylesheet" type="text/css"> </head> <?php if($data->moordervaring > 99 ){ echo" <table width=100% > <tr><td class=\"subTitle\"><b>Gefeliciteerd!</b></td></tr> <tr><td class=\"mainTxt\"> <center> Je hebt al 100% moordervaring!<br> </center> </td></tr> </table> </body>"; }else{ if($data->misdaadtime > 0 ){ echo" <table width=100% > <tr><td class=\"subTitle\"><b>Sorry</b></td></tr> <tr><td class=\"mainTxt\"> <center> Je moet nog <?=misdaadtijd();?> wachten<br> <?</center> </td></tr> </table> </body>"; }else{ ?> <body> <?=cHeader();?> <?=gevangenis();?> <?=misdaad();?> <form method="POST" action="moordervaring.php"> <table width="100%" align="center" cellpadding="2" cellspacing="0"> <tr><td class="subTitle" colspan="3">Moord Ervaring</td></tr> <?php $p1a = $data['misdaadl'] / 2; $p1b = round($p1a); $p1 = rand($p1b / 2, $p1b); $p2a = $data['misdaadl'] / 2; $p2b = round($p2a); $p2 = rand($p2b / 2, $p2b); $p3a = $data['misdaadl']/3; $p3b = round($p3a); $p3 = rand($p3b/2 ,$p3b); $p4a = $data['misdaadl']/4; $p4b = round($p4a); $p4 = rand($p4b / 2, $p4b); // als er submit word if($_SERVER['REQUEST_METHOD'] == 'POST'){ if(!empty($_POST['code']) and $_POST['code'] == $_SESSION['cc_captcha']){ echo '<tr><td class=mainTxt colspan=3>'; $R1 = (isset($_POST['R1']) ? $_POST['R1'] : ''); if($data['rank'] == 1){ $rplus = 0.5; } elseif ($data['rank'] == 2){ $rplus = 0.1; } elseif ($data['rank'] == 3){ $rplus = 0.1; } elseif ($data['rank'] == 4){ $rplus = 0.1; } elseif ($data['rank'] == 5){ $rplus = 0.1; } elseif ($data['rank'] == 6){ $rplus = 0.1; } elseif ($data['rank'] == 7){ $rplus = 0.1; } elseif ($data['rank'] == 8){ $rplus = 0.1; } elseif ($data['rank'] == 9){ $rplus = 0.1; } elseif ($data['rank'] == 10){ $rplus = 0.1; } elseif ($data['rank'] == 11){ $rplus = 0.1; } elseif ($data['rank'] == 12){ $rplus = 0.1; } elseif ($data['rank'] == 13){ $rplus = 0.1; } elseif ($data['rank'] == 14){ $rplus = 0.1; } elseif ($data['rank'] == 15){ $rplus = 0.1; } elseif ($data['rank'] == 16){ $rplus = 0.1; } mysql_query("UPDATE `[users]` SET `crimes`=`crimes`+'1' WHERE login='". $data['login'] ."'"); if($R1 == ""){ echo 'Selecteer een Moord-optie'; } if($R1 == "1"){ $getal = rand(1,100); if($getal < $p1 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt €'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == "1"){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt, je bent gewond, maar je bent ontsnapt wel aan de politie.'; exit; } } } // Als het misdaad 2 is if($R1 == "2"){ $getal = rand(1,100); if($getal < $p2 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt €'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == "1"){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `health`=`health`-'1',`misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt, je bent gewond, maar je bent wel ontsnapt aan de politie.'; exit; } } } // Als het misdaad 3 is if($R1 == "3"){ $getal = rand(1,100); if($getal < $p3 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt €'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == 1){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `health`=`health`-'1',`misdaad`=NOW(),`rankvord`=`rankvord`+'".$rplus."' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt, je bent gewond, maar je bent wel ontsnapt aan de politie.'; exit; } } } // Als het misdaad 4 is if($R1 == "4"){ $getal = rand(1, 100); if($getal < $p4 + 1){ $geld = rand(1000,30000); if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `bank`=`bank`+'". $geld ."',`moordervaring`=`moordervaring`+'". $rplus ."' WHERE login='". $data['login'] ."'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is gelukt en je hebt €'. $geld .',- , en moordervaring ervoor gekregen.'; exit; } else { $getal = rand(1,4); if($getal == 1){ if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `gevangenis`=NOW(), `gevangenistijd`='90',`rankvord`=`rankvord`+'{$rplus}' WHERE `login`='{$_SESSION['login']}'"); mysql_query("UPDATE `[users]` SET `misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'Het is mislukt en je zit voor anderhalve minuut in de gevangenis wegens poging tot moord.'; exit; } else { if($data['misdaadl'] < 200){ mysql_query("UPDATE `[users]` SET `misdaadl`=`misdaadl`+'2' WHERE login='". $data['login'] ."'"); } mysql_query("UPDATE `[users]` SET `health`=`health`-'3',`misdaad`=NOW(), `misdaadtime`='90' WHERE login='". $data['login'] ."'"); echo 'De moord is niet gelukt, en je bent 3 health verloren!'; exit; } } } }else{ echo "<tr><td class='mainTxt' colspan=3>De code komt niet overeen met het plaatje !</td></tr>"; } } else { ?> <tr> <td width="57%" class="mainTxt"><input type="radio" name="R1" value="1"> Vermoord een agent. </td><td width="10%" class="mainTxt"><? echo $p1; ?>%</td> <td width="33%" rowspan="5" align="right" class="mainTxt"><img src="images/sniperview.jpg" width="331" height="232"></td> </tr> <tr> <td class="mainTxt"><input type="radio" name="R1" value="2"> Moord een restaurant uit. </td> <td class="mainTxt"><? echo $p2; ?>%</td> </tr> <tr><td class="mainTxt"><input type="radio" name="R1" value="3"> Moord een casino uit.</td> <td class="mainTxt"><? echo $p3; ?>%</td> </tr> <tr><td class="mainTxt"><input type="radio" name="R1" value="4"> Moord een politiebureau uit. </td> <td class="mainTxt"><? echo $p4; ?>%</td> </tr> <tr> <td class="mainTxt" colspan="2"><table border="0" cellpadding="0" cellspacing="0"> <tr> <td><img src="coden.php" alt=""> </td> <td> <strong>Code:</strong> <input name="code" type="text" size="4" maxlength="4" /></td> </tr></table></td> </tr> <tr><td class="mainTxt" colspan="3" align="center"><input name="submit" type="submit" class="button" value="Vermoord"></td></tr> <?php }}} ?> </table> </form> </body> </html>
Het stukje dat ik geprobeert heb, staat op de lines 30-45..
Alvast bedankt!!^o)
Mvg,
Nick. -
Ik heb hier mijn forum script...
Volgens mij dot hij het niet helemaal zoals het hoort.
Ik heb wel wat sql tables enzo toegevoegd in men database, maar ben er niet zeker van of het zo goed zit..
hier is de forum script:
[code=php]<?phpinclude 'includes/config.php';
include("ubb.php");
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['p'])){
$_GET['p']=htmlspecialchars(addslashes($_GET['p']));
}
if(isset($_GET['topic'])){
$_GET['topic']=htmlspecialchars(addslashes($_GET['topic']));
}
if(isset($_GET['slotje'])){
$_GET['slotje']=htmlspecialchars(addslashes($_GET['slotje']));
}
if(isset($_GET['delreply'])){
$_GET['delreply']=htmlspecialchars(addslashes($_GET['delreply']));
}
if(isset($_GET['verplaats'])){
$_GET['verplaats']=htmlspecialchars(addslashes($_GET['verplaats']));
}
if(isset($_POST['forum'] )){
$_POST['forum'] =htmlspecialchars(addslashes($_POST['forum'] ));
}
if(isset($_GET['reageer'])){
$_GET['reageer']=htmlspecialchars(addslashes($_GET['reageer']));
}
if(isset($_GET['quote'])){
$_GET['quote']=htmlspecialchars(addslashes($_GET['quote']));
}
if(isset($_GET['edittopic'])){
$_GET['edittopic']=htmlspecialchars(addslashes($_GET['edittopic']));
}
if(isset($_GET['editreply'])){
$_GET['editreply']=htmlspecialchars(addslashes($_GET['editreply']));
}
if(isset($_GET['delreply'])){
$_GET['delreply']=htmlspecialchars(addslashes($_GET['delreply']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}
if(isset($_GET['sub'])){
$_GET['sub']=htmlspecialchars(addslashes($_GET['sub']));
}if(! $_GET['p']) {
$begin = 0;
}
else {
$begin = $_GET['p'];
}
/* ------------------------- */ ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="javascript">
function icon(theicon) {
document.form3.info.value += ""+theicon;
document.form3.info.focus();
}function setsmilie(which){
document.form3.info.value = document.form3.info.value + which;
}</script>
<title>GamesCrime - Forum</title>
<link rel="stylesheet" type="text/css" href="css-v1.css">
<body style="background: #4B3D32; margin: 0px;"><?
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->type != 1) {
print " <table width=\"75%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"75%\" 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=\"75%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"75%\" 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=\"75%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><tr><td class=\"mainTxt\"><table width=\"75%\" 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=\"75%\" align=\"center\"><tr><td><div align=\"left\"><a href=\"forum.php?newtopic={$_GET['sub']}\"><b>Nieuw Onderwerp</b></a></div><div align=\"right\">\n";
print " </div></td></tr><tr><td align=\"left\">Moderator(s): <font color=red><b>$mods</b></font></td></tr><tr><td><table align=\"center\" width=\"100%\"><tr><td width=\"5%\" align=\"center\" class=\"subTitle\" style=\"letter-spacing: normal;\"> </td><td align=\"center\" 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=\"center\" 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)) {
$forum->title = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("kut", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("kloten", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("pik", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("penis", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("vagina", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("lul", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("cancer", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("leier", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("neuk", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
$forum->title = eregi_replace("anaal", "<img src=\"images/smilies/icon_censored.gif\">", $forum->title );
if($forum->slotje == 0) {
$image = "opentopic.gif";
}
else {
$image = "closed.gif";
}
if($forum->datum == "") {
$forum->datum = "Geen";
}
if($forum->title == "") {
$forum->title = "Geen";
}
print " <tr><td width=\"5%\"><a href=\"forum.php?verplaats={$forum->id}\"><img src=\"images/icons/{$image}\" border=0></a></td><td width=\"45%\"><a href=\"forum.php?topic={$forum->id}\"><b>$forum->title</b></a></td><td align=\"center\" width=\"10%\"><a href=\"profile.php?x={$forum->login}\">$forum->login</a></td><td align=\"center\" width=\"10%\">$forum->replys</td><td width=\"30%\">$forum->datum</td></tr><tr>\n";
}
print " </table></tr></td></table></td></tr></table>\n";
}
elseif($_GET['topic']) {
if(isset($_POST['add'])) {
$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 align=\"center\">Je bericht is geplaatst.<BR><BR><a href=\"forum.php?topic={$_GET['topic']}\">Terug</a></td></tr></table></td></tr></table>\n";
mysql_query("INSERT INTO `[foum_replys]`(topicid,subid,datum,login,title,text,date) values($id,'{$lol->subid}','$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 {
$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`,`avatar` FROM `[users]` WHERE `login`='{$topic->login}'");
$user2 = mysql_fetch_object($user_query2);if($user2->forumstatus == "gwsp1") {
$status = "<font color=green><b>Moderator</b></font>";
}
elseif($user2->forumstatus == "gwsp2") {
$status = "<font color=red><b>Webmaster</b></font>";
}
elseif($user2->forumposts <= 50) {
$status = "Forum Beginner";
}
elseif($user2->forumposts <= 150) {
$status = "Forum Freak";
}
elseif($user2->forumposts > 150) {
$status = "Forum God";
}
elseif($user2->forumposts > 750) {
$status = "Forum Piraat";
}
else {
$status = "Normaal";
}
if(time() - $user2->online < 300) {
$online2 = "<img src=\"images/icons/online.gif\"> <font color=green><b>Online</b></font>";
}
else {
$online2 = "<img src=\"images/icons/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=([^\\[]*)\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=_blank>\\2</a>",$topic->text);
$topic->text = eregi_replace("\\[img]([^\\[]*)\\[/img\\]","<img src=\"\\1\">",$topic->text);
$topic->text = eregi_replace("\\Citaat van ([^\\[*)\\]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td><b>\\1 schreef:</b></td></tr><tr><td>\\2</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$topic->text);
$topic->text = eregi_replace("\\[quote]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td>\\1</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$topic->text);
$topic->text = str_replace("(h)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$topic->text);
$topic->text = str_replace("(H)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$topic->text);
$topic->text = str_replace(":$", "<img src=\"images/smilies/icon_embarassed.gif\" border=0>",$topic->text);
$topic->text = str_replace(":(", "<img src=\"images/smilies/icon_frown.gif\" border=0>",$topic->text);
$topic->text = str_replace("(a)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$topic->text);
$topic->text = str_replace("(A)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$topic->text);
$topic->text = str_replace("(k)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$topic->text);
$topic->text = str_replace("(K)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$topic->text);
$topic->text = str_replace(":D", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$topic->text);
$topic->text = str_replace(":d", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$topic->text);
$topic->text = str_replace("(m)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$topic->text);
$topic->text = str_replace("(M)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$topic->text);
$topic->text = str_replace(":#", "<img src=\"images/smilies/icon_sealed.gif\" border=0>",$topic->text);
$topic->text = str_replace(":)", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$topic->text);
$topic->text = str_replace(":0", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$topic->text);
$topic->text = str_replace(":o", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$topic->text);
$topic->text = str_replace(":O", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$topic->text);
$topic->text = str_replace(":p", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$topic->text);
$topic->text = str_replace(":P", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$topic->text);
$topic->text = str_replace(";)", "<img src=\"images/smilies/icon_wink.gif\" border=0>",$topic->text);
$topic->text = str_replace(":@", "<img src=\"images/smilies/icon_yell.gif\" border=0>",$topic->text);$topic->text = eregi_replace("kut", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("kloten", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("pik", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("penis", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("vagina", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("lul", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("cancer", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("leier", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("neuk", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = eregi_replace("anaal", "<img src=\"images/smilies/icon_censored.gif\">", $topic->text );
$topic->text = str_replace("\\\'", "'", $topic->text);
$topic->text = str_replace("\\\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\'", "'", $topic->text);
$topic->text = str_replace("\r'", "'", $topic->text);
$topic->text = str_replace("\n'", "'", $topic->text);print " <table width=\"100%\" cellspacing=0><tr><td class=\"subTitle\"><b>Forum</b></td></tr><table align=\"center\" width=\"100%\" cellspacing=0><tr><td class=\"mainTxt\"><table width=\"100%\"><tr><td width=\"110\" valign=\"top\"><b><a href=\"profile.php?x={$topic->login}\">$topic->login</a></b><BR>$status<BR><BR><img src=\"{$user2->avatar}\" width=\"100\" height=\"100\"><BR><BR>$online2<BR>Berichten: $user2->forumposts</td><td valign=\"top\" align=\"left\">$topic->text</td></tr>\n";
if($data->login == $topic->login) {
print " <tr><td><i>$topic->datum1</i></td><td colspan=2 align=\"right\"><a href=\"forum.php?edittopic={$topic->id}\">Bewerken</a></td></tr></table></td></tr>\n";
}
else {
print " <tr><td><i>$topic->datum1</i></td><td colspan=2> </td></tr></table></td></tr>\n";
}
$query2 = mysql_query("SELECT * FROM `[foum_replys]` WHERE `topicid`={$_GET['topic']} AND `del`=0 ORDER BY `date` ASC LIMIT $begin,10");
while($forum = mysql_fetch_object($query2)) {
$user_query = mysql_query("SELECT UNIX_TIMESTAMP(`online`) AS `online`,`forumstatus`,`login`,`forumposts`,`avatar` FROM `[users]` WHERE `login`='{$forum->login}'");
$user = mysql_fetch_object($user_query);
$forum->text = htmlspecialchars($forum->text);
$forum->text = nl2br($forum->text);
$forum->text = str_replace("", "<b>",$forum->text);
$forum->text = str_replace("", "</b>",$forum->text);
$forum->text = str_replace("", "<i>",$forum->text);
$forum->text = str_replace("", "</i>",$forum->text);
$forum->text = str_replace("", "<u>",$forum->text);
$forum->text = str_replace("", "</u>",$forum->text);
$forum->text = eregi_replace("\\[color=([^\\[]*)\\]([^\\[]*)\\[/color\\]","<font color=\"\\1\">\\2</font>",$forum->text);
$forum->text = eregi_replace("\\[email=([^\\[]*)\\]([^\\[]*)\\[/email\\]", "<a href=\"mailto:\\1\">\\2</a>",$forum->text);
$forum->text = eregi_replace("\\[url=([^\\[]*)\\]([^\\[]*)\\[/url\\]","<a href=\"\\1\" target=_blank>\\2</a>",$forum->text);
$forum->text = eregi_replace("\\[img]([^\\[]*)\\[/img\\]","<img src=\"\\1\">",$forum->text);
$forum->text = eregi_replace("\\[quote=([^\\[]*)\\]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td><b>\\1 schreef:</b></td></tr><tr><td>\\2</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$forum->text);
$forum->text = eregi_replace("\\[quote]([^\\[]*)\\[/quote\\]","<center><table width=90%><tr><td>Quote:<br><hr color=\"#FFFFFF\" size=1 width=100%></td></tr><tr><td>\\1</td></tr><tr><td><hr color=\"#FFFFFF\" size=1 width=100%></td></tr></table></center>",$forum->text);
$forum->text = str_replace("(h)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$forum->text);
$forum->text = str_replace("(H)", "<img src=\"images/smilies/icon_cool.gif\" border=0>",$forum->text);
$forum->text = str_replace(":$", "<img src=\"images/icons/smilies/icon_embarassed.gif\" border=0>",$forum->text);
$forum->text = str_replace(":(", "<img src=\"images/smilies/icon_frown.gif\" border=0>",$forum->text);
$forum->text = str_replace("(a)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$forum->text);
$forum->text = str_replace("(A)", "<img src=\"images/smilies/icon_innocent.gif\" border=0>",$forum->text);
$forum->text = str_replace("(k)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$forum->text);
$forum->text = str_replace("(K)", "<img src=\"images/smilies/icon_kiss.gif\" border=0>",$forum->text);
$forum->text = str_replace(":D", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$forum->text);
$forum->text = str_replace(":d", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$forum->text);
$forum->text = str_replace("(m)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$forum->text);
$forum->text = str_replace("(M)", "<img src=\"images/smilies/icon_moneyinmouth.gif\" border=0>",$forum->text);
$forum->text = str_replace(":#", "<img src=\"images/smilies/icon_sealed.gif\" border=0>",$forum->text);
$forum->text = str_replace(":)", "<img src=\"images/smilies/icon_smile.gif\" border=0>",$forum->text);
$forum->text = str_replace(":0", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$forum->text);
$forum->text = str_replace(":o", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$forum->text);
$forum->text = str_replace(":O", "<img src=\"images/smilies/icon_surprised.gif\" border=0>",$forum->text);
$forum->text = str_replace(":p", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$forum->text);
$forum->text = str_replace(":P", "<img src=\"images/smilies/icon_razz.gif\" border=0>",$forum->text);
$forum->text = str_replace(";)", "<img src=\"images/smilies/icon_wink.gif\" border=0>",$forum->text);
$forum->text = str_replace(":@", "<img src=\"images/smilies/icon_yell.gif\" border=0>",$forum->text);$forum->text = eregi_replace("kut", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("kloten", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("pik", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("penis", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("vagina", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("lul", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("kanker", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("cancer", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("leier", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("fuck", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("neuk", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = eregi_replace("anaal", "<img src=\"images/smilies/icon_censored.gif\">", $forum->text );
$forum->text = str_replace("\\\'", "'", $forum->text);
$forum->text = str_replace("\\\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\'", "'", $forum->text);
$forum->text = str_replace("\r'", "'", $forum->text);
$forum->text = str_replace("\n'", "'", $forum->text);
$forum->text = str_replace("\r'", "'", $forum->text);
$forum->text = str_replace("\r\n\r\n\r\n'", "'", $forum->text);
$forum->text = str_replace("\r\n\r\n'", "'", $forum->text);if($user->forumstatus == "gwsp1") {
$status = "<font color=green><b>Moderator</b></font>";
}
elseif($user->forumstatus == "gwsp2") {
$status = "<font color=red><b>Webmaster</b></font>";
}
elseif($user->forumposts <= 50) {
$status = "Forum Beginner";
}
elseif($user->forumposts <= 150) {
$status = "Forum Freak";
}
elseif($user->forumposts > 150) {
$status = "Forum God";
}
elseif($user->forumposts > 750) {
$status = "Forum Piraat";
}
else {
$status = "Normaal";
}if(time() - $user->online < 300) {
$online = "<img src=\"images/icons/online.gif\"> <font color=green><b>Online</b></font>";
}
else {
$online = "<img src=\"images/icons/offline.gif\"> <font color=red><b>Offline</b></font>";
}
print " <tr><td class=\"mainTxt\"><table width=\"100%\"><tr><td width=\"110\" valign=\"top\"><b><a href=\"profile.php?x={$forum->login}\">$forum->login</a></b><BR>$status<BR><BR><img src=\"{$user->avatar}\" width=\"100\" height=\"100\"><BR><BR>$online<BR>Berichten: $user->forumposts</td><td valign=\"top\" align=\"left\">$forum->text</td></tr>\n";
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
print " <tr><td><i>$forum->datum</i></td><td colspan=3 align=\"right\"><a href=\"forum.php?delreply={$forum->id}\">Verwijderen</a> | <a href=\"forum.php?editreply={$forum->id}\">Bewerken</a> | <a href=\"forum.php?reageer={$topic->id}"e={$forum->id}\"></a></td></tr></table></td></tr>\n";
}
elseif($data->login == $forum->login) {
print " <tr><td><i>$forum->datum</i></td><td colspan=3 align=\"right\"><a href=\"forum.php?editreply={$forum->id}\">Bewerken</a></td></tr></table></td></tr>\n";
}
else {
print " <tr><td><i>$forum->datum</i></td><td colspan=3><a href=\"forum.php?reageer={$topic->id}"e={$forum->id}\">Quote</a></td></tr></table></td></tr>\n";
}
}
print " <tr><td class=\"mainTxt\"><b>Pagina:</b> \n";
$dbres = mysql_query("SELECT * FROM `[foum_replys]` WHERE `topicid`={$_GET['topic']} AND `del`=0");
$sub_query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['topic']}");
$sub = mysql_fetch_object($sub_query);
print "";
for($i=0; $i<mysql_num_rows($dbres)/10; $i++) {
print " <a href=\"forum.php?topic={$_GET['topic']}&p={$i}0\" target=\"_self\">". ($i+1) ."</a> ";
}
echo "<a href=\"forum.php\">Forumkeuze</a> | <a href=\"forum.php?sub=$sub->subid\">Terug naar forum</a>";
if($topic->slotje == 1) {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\"><font color=red><b>Dit Onderwerp is gesloten.</b></font></td></tr></table></tr></td></table></td></tr></table>\n";
}
elseif($topic->slotje == 0 && $data->forumstatus == "gwsp1") {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\"></textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form><tr><td align=\"center\"><BR><a href=\"forum.php?slotje={$topic->id}\"><img src=\"images/icons/slotje.gif\" border=0></a></td></tr><tr></table></tr></td></table></td></tr></table>\n";
}
elseif($topic->slotje == 0 && $data->forumstatus == "gwsp2") {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\"></textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form><tr><td align=\"center\"><BR><a href=\"forum.php?slotje={$topic->id}\"><img src=\"images/icons/slotje.gif\" border=0></a></td></tr><tr></table></tr></td></table></td></tr></table>\n";
}
else {
print " </td></tr><tr><tr> </td></tr><tr><td align=\"center\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\"></textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form></table></tr></td></table></td></tr></table>\n";
}
}
}
elseif($_GET['slotje']) {
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
mysql_query("UPDATE `[forum_topics]` SET `slotje`=1 WHERE `id`={$_GET['slotje']}");
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 hebt een slotje geplaatst.<BR><BR><a href=\"forum.php?topic={$_GET['slotje']}\">Terug</a></tr></td></table></td></tr></table>\n";
}
}
elseif($_GET['delreply']) {
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
$query = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['delreply']}");
$reply = mysql_fetch_object($query);
$query2 = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$reply->topicid}");
$topic = mysql_fetch_object($query2);
mysql_query("UPDATE `[users]` SET `forumposts`=`forumposts`-1 WHERE `login`='{$reply->login}'");
mysql_query("UPDATE `[foum_replys]` SET `del`=1 WHERE `id`={$_GET['delreply']}");
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`-1 WHERE `id`={$topic->subid}");
mysql_query("UPDATE `[forum_topics]` SET `replys`=`replys`-1 WHERE `id`={$topic->id}");
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\">Bericht is succesvol verwijdert.</tr></td></table></td></tr></table>\n";
}
}
elseif($_GET['verplaats']) {
if($data->forumstatus == "gwsp1"$data->forumstatus == "gwsp2") {
$topic_query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['verplaats']}");
$topic = mysql_fetch_object($topic_query);
$sub_query = mysql_query("SELECT * FROM `[forum_sub]` ORDER BY `area` ASC");
if(isset($_POST['verplaats'])) {
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`-{$topic->replys},`topics`=`topics`-1 WHERE `id`={$topic->subid}");
mysql_query("UPDATE `[forum_sub]` SET `replys`=`replys`+{$topic->replys},`topics`=`topics`+1 WHERE `id`={$_POST['forum']}");
mysql_query("UPDATE `[forum_topics]` SET `subid`={$_POST['forum']} WHERE `id`={$_GET['verplaats']}");
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\">Topic is verplaatst.</tr></td></table></td></tr></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 align=\"center\"><b>$topic->title</b><BR><form method=\"post\">Forum:<br><select name=\"forum\">\n";
while($sub = mysql_fetch_object($sub_query)) {
print "<option value=\"{$sub->id}\">$sub->title</option>";
}
print "</select> <input type=\"submit\" name=\"verplaats\" value=\" Verplaats \"></form></tr></td></table></td></tr></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 align=\"center\">Je mag geen berichten verplaatsen.</tr></td></table></td></tr></table>\n";
}
}
elseif($_GET['reageer']) {
if(isset($_POST['add'])) {
$id = $_GET['reageer'];
$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 align=\"center\">Je bericht is geplaatst.<BR><BR><a href=\"forum.php?topic={$_GET['topic']}\">Terug</a></td></tr></table></td></tr></table>\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['reageer']}") 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 {
$query = mysql_query("SELECT * FROM `[forum_topics]` WHERE `id`={$_GET['reageer']}");
$topic = mysql_fetch_object($query);
if($topic->slotje == 0) {
if($_GET['quote']) {
$quote_query = mysql_query("SELECT * FROM `[foum_replys]` WHERE `id`={$_GET['quote']}");
$reply = mysql_fetch_object($quote_query);
$quote = "[quote={$reply->login}]{$reply->text}";
}
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\" class=\"subTitle\"><B>Reageren</b></td></tr><form method=\"post\"><tr><td align=\"center\" class=\"mainTxt\"><textarea rows=\"6\" name=\"message\" cols=\"60\" maxlength=\"10000\">{$quote}</textarea><BR><input type=\"submit\" name=\"add\" value=\" Toevoegen \"> <input type=\"button\" value=\" Omhoog \" onclick=\"window.location=('#top')\"></td></tr></form></table></tr></td></table>\n";
}
}
}
elseif($_GET['newtopic']) {
if(isset($_POST['add'])) {
$id = htmlspecialchars(addslashes($_GET['newtopic']));
$titel = htmlspecialchars(addslashes($_POST['title']));
$bericht = htmlspecialchars(addslashes($_POST['message']));
$datum = date("d-m-Y H:i");
print " <table width=\"100%\" cellspacing=0><tr><td class=\"mainTxt\"><table width=\"100%\" align=\"center\"><tr><td class=\"subTitle\" align=\"left\"><b><img src=\"images/icons/blokje.jpg\"> Forum</b></td></tr><tr><td align=\"center\">Je bericht is geplaatst.</tr></td></table></td></tr></table>\n";
mysql_query("INSERT INTO `[forum_topics]`(subid,datum1,login,title,text,date,date1) values($id,'$datum','$data->login','$titel','$bericht',NOW(),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_sub]` SET `topics`=`topics`+1 WHERE `id`={$id}") 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 <<<ENDHTML
<script language="javascript">
function icon(theicon) {
document.form3.info.value += ""+theicon;
document.form3.info.focus();
}function setsmilie(which){
document.form3.info.value = document.form3.info.value + which;
}</script>
<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 class="mainTxt">
<table align="center" width="100%">
<form method="post" name="form1">
<tr><td class="subTitle" colspan=3><b>Nieuw Onderwerp</b></td><td width=\"100%"></td></tr>
<tr>
<td>Titel:</td>
<td><input type="text" size="20" name="title"></td><td width="100%"></td>
</tr>
<tr>
<td>Bericht:</td>
<td>
<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 = htmlspecialchars(addslashes($_POST['title']));
$bericht = htmlspecialchars(addslashes($_POST['message']));
$id = htmlspecialchars(addslashes($_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 gewijzigt.</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\">\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 = htmlspecialchars(addslashes($_POST['title']));
$bericht = htmlspecialchars(addslashes($_POST['message']));
$id = htmlspecialchars(addslashes($_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 gewijzigt.</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\">\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 gewijzigt.</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\">\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< -
Ok, het is allemaal gelukt en hij doet het!
bedankt!
btw. dat met een row inserten, was niet wat ik bedoelde...
Maar de oplossing was: dat 'prijs' het id van een land moest zijn.
dus had niks met het woord "prijs" te maken:p. -
Ow, dan nog een vraag, want het zijn wel de goede sql Tables en Values, en ik heb ze toevegvoegd, maar wat moet ik dan nog invoegen waardoor ze werken??^o)^o)
Alvast bedankt. -
Ok, heel erg bedankt, ik ga ze even uitproberen..
Als ze werken laat ik dat meteen weten goed?;)