Udlov point i forum?
Hej jeg har communityet www.n-gamez.dk her kan medlemmer af siden skrive i et forum.. Jeg vil gerne have det sådan at man kan udlove point i forummet ligesom her på eksperten.dk er der en der kan gøre det??Flg kode er forum.php:
<?
session_start();
include("../include/db.php");
if($brugernavn != NULL) {
$s_tt = mysql_query("SELECT userid,sidst_klik FROM online WHERE userid = '$my_id'");
$r_tt = mysql_fetch_array($s_tt);
$s_tt2 = mysql_query("SELECT onlinetid,id,point FROM brugersystem WHERE id = '$my_id'");
$r_tt2 = mysql_fetch_array($s_tt2);
$tid = TIME();
$nytid = $tid-$r_tt[sidst_klik];
$nytid2 = $nytid+$r_tt2[onlinetid];
$poi = $nytid/180;
$nypoi = $r_tt2[point]+$poi;
mysql_query("UPDATE brugersystem SET onlinetid = '$nytid2',point = '$nypoi' WHERE id = '$my_id'");
mysql_query("UPDATE online SET sidst_klik = '$tid' WHERE userid = '$my_id'");
} else {
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style type="text/css">
body {
scrollbar-face-color:#444334;
}
</style>
<style type="text/css"><!--A:link { text-decoration: none; color: 000000;}
A:visited { text-decoration: none; color: 000000;}
A:active { text-decoration: none; color: 000000;}
A:hover { text-decoration: overline underline; color: FFFFFF;}//--></style>
<title>...:::N-gamez - The Nintendo feeling:::...</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>
<body bgcolor="#333333" body oncontextmenu="return false" ondragstart="return false" onselectstart="return false">
<div align="center">
<center>
<TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 cellSpacing=0 cellPadding=0 width=738
border=0>
<TR>
<TD width=623 colspan="3">
<p align="center"><img border="0" src="../../billeder/1.jpg" width="738" height="25"></p>
</TD></TR>
<TR>
<TD width=9 background="../../billeder/3.jpg"> </TD>
<TD width=720 background="../../billeder/6.jpg" height="88"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><? include("../include/menu.up.php"); ?></td>
</tr>
</table></TD>
<TD width=9 background="../../billeder/17.jpg"> </TD></TR>
<TR>
<TD width=623 colspan="3"><img border="0" src="../../billeder/4.jpg" width="738" height="8"></TD></TR>
<TR>
<TD width=623 colspan="3"><img border="0" src="../../billeder/5.jpg" width="738" height="7"></TD></TR>
</TABLE>
</center>
</div>
<div align="center">
<center>
<TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 cellSpacing=0 cellPadding=0 width=738
border=0>
<tr>
<TD width=138 colspan="3"><img border="0" src="../../billeder/8.jpg" width="138" height="25"></TD>
<TD width=6 height="25"><img border="0" src="../../billeder/9.jpg" width="7" height="25"></TD>
<TD width=148 colspan="3"><img border="0" src="../../billeder/10.jpg" width="449" height="25"></TD>
<TD width=6><img border="0" src="../../billeder/9.jpg" width="7" height="25"></TD>
<TD width=148 colspan="3"><img border="0" src="../../billeder/8.jpg" width="138" height="25"></TD>
</tr>
<TR>
<TD width=8 background="../../billeder/11.jpg"> </TD>
<TD width=121 background="../../billeder/6.jpg" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><? include("../include/menu.left.php"); ?></td>
</tr>
</table></TD>
<TD width=9 background="../../billeder/12.jpg"></TD>
<TD width=6 height="25"></TD>
<TD width=8 background="../../billeder/11.jpg"> </TD>
<TD width=500 background="../../billeder/6.jpg" height="200" valign="top">
</b><table border="0" bgcolor="#442323" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" valign="top"><font face="verdana" size="1"><b>Forum</b></font></td>
</tr>
</table> <font face="verdana" size="1">
<?
$s_tags = mysql_query("SELECT * FROM tags WHERE userid = '$r_vis[id]'");
$tag = mysql_fetch_array($s_tags);
if($tag=='ja') {
$fritekst = str_replace("[b]","<b>",$fritekst);
$fritekst = str_replace("","</b>",$fritekst);
} else {
}
if($tag=='ja') {
$fritekst = str_replace("[u]","<u>",$fritekst);
$fritekst = str_replace("","</u>",$fritekst);
} else {
}
if($tag=='ja') {
$fritekst = str_replace("[i]","<i>",$fritekst);
$fritekst = str_replace("","</i>",$fritekst);
} else {
}
if($tag[hr]=='ja') {
$fritekst = str_replace("[streg]","<hr>",$fritekst);
} else {
}
if($tag[br]=='ja') {
$fritekst = str_replace("[br]","<br>",$fritekst);
$fritekst = str_replace("[/br]","</br>",$fritekst);
} else {
}
print "";
$s_tjek = mysql_query("SELECT * FROM brugersystem WHERE brugernavn LIKE '$brugernavn' AND kodeord = '$kodeord'");
$r_tjek = mysql_fetch_array($s_tjek);
if($r_tjek[id] != NULL) {
if($sletid != NULL AND $r_tjek[status] == 1) {
mysql_query("DELETE FROM forum_svar WHERE id = '$sletid'");
} else { }
//Nyt spg
if($nytspg == 'ja') {
if($overs != NULL AND $spget != NULL) {
$tid = TIME();
$tekst1 = str_replace("<","",$spget);
$tekst1 = str_replace(">","",$tekst1);
$fritekst = $tekst1;
if($tag=='ja') {
$fritekst = str_replace("[b]","<b>",$fritekst);
$fritekst = str_replace("","</b>",$fritekst);
} else {
}
if($tag=='ja') {
$fritekst = str_replace("[u]","<u>",$fritekst);
$fritekst = str_replace("","</u>",$fritekst);
} else {
}
if($tag=='ja') {
$fritekst = str_replace("[i]","<i>",$fritekst);
$fritekst = str_replace("","</i>",$fritekst);
} else {
}
if($tag[hr]=='ja') {
$fritekst = str_replace("[streg]","<hr>",$fritekst);
} else {
}
if($tag[br]=='ja') {
$fritekst = str_replace("[br]","<br>",$fritekst);
$fritekst = str_replace("[/br]","</br>",$fritekst);
} else {
}
mysql_query("INSERT INTO forum_spg (katid,userid,tekst,navn,tid) VALUES ('$katid','$my_id','$fritekst','$overs','$tid')");
mysql_query("UPDATE brugersystem SET point = point+1 WHERE id = '$r_tjek[id]'");
print "Dit indlæg er tilføjet";
} else {
print "Du skal udfylde ALLE felter!";
}
} else {
}
if($spg == 'ja' AND $spgid == NULL) {
print "
<form action=\"forum.php?nytspg=ja&katid=$katid\" method=\"POST\">
Overskrift:<input type=\"text\" name=\"overs\"><br>
Spg:<textarea cols=\"20\" rows=\"10\" name=\"spget\"></textarea><br>
<input type=\"submit\" name=\"submit\" value=\"Opret\">
</form>";
} else { }
//Nyt svar
if($nytsvar == 'ja') {
if($tekst != NULL) {
$tid = TIME();
$tekst1 = str_replace("<","",$tekst);
$tekst1 = str_replace(">","",$tekst1);
$fritekst = $tekst1;
if($tag=='ja') {
$fritekst = str_replace("[b]","<b>",$fritekst);
$fritekst = str_replace("","</b>",$fritekst);
} else {
}
if($tag=='ja') {
$fritekst = str_replace("[u]","<u>",$fritekst);
$fritekst = str_replace("","</u>",$fritekst);
} else {
}
if($tag=='ja') {
$fritekst = str_replace("[i]","<i>",$fritekst);
$fritekst = str_replace("","</i>",$fritekst);
} else {
}
if($tag[hr]=='ja') {
$fritekst = str_replace("[streg]","<hr>",$fritekst);
} else {
}
if($tag[br]=='ja') {
$fritekst = str_replace("[br]","<br>",$fritekst);
$fritekst = str_replace("[/br]","</br>",$fritekst);
} else {
}
mysql_query("INSERT INTO forum_svar (userid,besked,spgid,katid,tid) VALUES ('$my_id','$fritekst','$spgid','$katid','$tid')");
mysql_query("UPDATE brugersystem SET point = point+1 WHERE id = '$r_tjek[id]'");
print "Dit svar er tilføjet";
} else {
print "Du skal udfylde feltet!";
}
} else {
}
//Nyt svar
if($svar == 'ja') {
print "
<form action=\"forum.php?nytsvar=ja&spgid=$spgid&katid=$katid\" method=\"POST\">
Svar:<textarea cols=\"20\" rows=\"10\" name=\"tekst\"></textarea><br>
<input type=\"submit\" name=\"submit\" value=\"Gem\">
</form>";
} else {
}
//Viser enkelt spg
if($spg == 'ja' AND $svar != 'ja' AND $nytsvar != 'ja' AND $spgid != NULL) {
$s_enkspg = mysql_query("SELECT * FROM forum_spg WHERE id = '$spgid'");
$enkspg = mysql_fetch_array($s_enkspg);
$s_opretter = mysql_query("SELECT brugernavn FROM brugersystem WHERE id = '$enkspg[userid]'");
$opretter = mysql_fetch_array($s_opretter);
$dato = date("j/m-y - H:i:s",$enkspg[tid]);
print "<font size=\"2\">Indlæg:</font><br>";
print "$enkspg[navn]<i> - $opretter[brugernavn] - $dato $time</i><br>$enkspg[tekst]<br>";
print "<br><b><a href=\"forum.php?svar=ja&spgid=$spgid&katid=$enkspg[katid]\">Opret svar</a></b><br>";
print "<font size=\"2\">Svar:</font><br>";
$s_svar = mysql_query("SELECT * FROM forum_svar WHERE spgid = '$enkspg[id]' ORDER BY id ASC");
WHILE($svar = mysql_fetch_array($s_svar)) {
$s_opretter = mysql_query("SELECT brugernavn FROM brugersystem WHERE id = '$svar[userid]'");
$opretter = mysql_fetch_array($s_opretter);
$dato = date("j/m-y - H:i:s",$svar[tid]);
print "<i>$opretter[brugernavn] - $dato</i><br>$svar[besked]<br>";
if($r_tjek[status] == 1) {
print "<a href=\"forum.php?sletid=$svar[id]\">Slet indlæg.</a><br>";
} else { }
print "<br>";
}
$antalsvar = mysql_num_rows($s_svar);
if($antalsvar == 0) {
print "Der er ingen svar";
} else {
print "Der er i alt $antalsvar svar";
}
print "<br><b><a href=\"forum.php?svar=ja&spgid=$spgid&katid=$enkspg[katid]\">Opret svar</a></b>";
} else {
}
//Viser alle spg
if($kat == 'ja' AND $svar != 'ja' AND $nytsvar != 'ja' AND $spg != 'ja' AND $nytspg != 'ja') {
print "<br><b><a href=\"forum.php?spg=ja&katid=$katid\">Opret indlæg</a></b><br><br>";
$s_visspg = mysql_query("SELECT * FROM forum_spg WHERE katid = '$katid' ORDER BY id DESC");
WHILE($visspg = mysql_fetch_array($s_visspg)) {
$s_opretter = mysql_query("SELECT brugernavn FROM brugersystem WHERE id = '$visspg[userid]'");
$opretter = mysql_fetch_array($s_opretter);
//Viser spg
$s_ani = mysql_query("SELECT id FROM forum_svar WHERE spgid = '$visspg[id]'");
$ani = mysql_num_rows($s_ani);
print "<b><a href=\"forum.php?spg=ja&spgid=$visspg[id]\">$visspg[navn]</a></b><br>$visspg[tekst]<i> - $opretter[brugernavn] - indlæg: $ani<i><br><br>";
}
print "<br><b><a href=\"forum.php?spg=ja&katid=$katid\">Opret indlæg</a></b>";
} else {
}
//Henter kategorier
if($kat != 'ja' AND $spg != 'ja' AND $svar != 'ja' AND $nytsvar != 'ja' AND $nytspg != 'ja') {
$s_kat = mysql_query("SELECT * FROM forum_data ORDER BY navn");
WHILE($r_kat = mysql_fetch_array($s_kat)) {
//Start på hver kategori
//Start på visning at hoved kategorier
$s_spg = mysql_query("SELECT id FROM forum_spg WHERE katid = '$r_kat[id]'");
$spg = mysql_num_rows($s_spg);
$s_indl = mysql_query("SELECT id FROM forum_svar WHERE katid = '$r_kat[id]'");
$ind = mysql_num_rows($s_indl);
print "<font size=\"2\"><b><a href=\"forum.php?kat=ja&katid=$r_kat[id]\">$r_kat[navn]</a></b></font><br>$r_kat[tekst]<i> - Spg: $spg - Indlæg: $ind</i><br><br>";
//Slut på visning af hovedkategorier
}
//Slut på hver kategori
}
} else {
print "Du er ikke logget ind!";
}
?>
</TD>
</TD>
<TD width=9 background="../../billeder/12.jpg"> </TD>
<TD width=6></TD>
<TD width=8 background="../../billeder/11.jpg"> </TD>
<TD width=141 background="../../billeder/6.jpg" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><? include("../include/menu.right.php"); ?></td>
</tr>
</table></TD>
<TD width=9 background="../../billeder/12.jpg"> </TD></TR>
</TABLE>
</center>
</div>
<div align="center">
<center>
<TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse"
borderColor=#111111 cellSpacing=0 cellPadding=0 width=738
border=0>
<tr>
<TD width=623 colspan="3"><img border="0" src="../../billeder/13.jpg" width="738" height="23"></TD>
</tr>
<tr>
<TD width=147><img border="0" src="../../billeder/14.jpg" width="147" height="35"></TD>
<TD width=500 background="../../billeder/6.jpg"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><? include("../include/menu.down.php"); ?></td>
</tr>
</table></TD>
<TD width=150><img border="0" src="../../billeder/15.jpg" width="150" height="35"></TD>
</tr>
<tr>
<TD width=623 colspan="3"><img border="0" src="../../billeder/16.jpg" width="737" height="8"></TD>
</tr>
</TABLE>
</center>
</div>
</body>
</html>
