Sanderc schreef:Waar je een topic kan aanmaken?
Geef anders de code is van hoe je een topic aanmaakt...
Dan bouw ik het snel wel even in / zeg ik hoe je het moet doen.
Spoiler tonen
if(isset($_GET[showtopic])){
$tQuery = mysql_query("SELECT * FROM topics WHERE id = " . mysql_real_escape_string($_GET[showtopic]) . "") or die(mysql_error());
$tFetch = mysql_fetch_assoc($tQuery);
if(mysql_num_rows($tQuery) == 0){
echo
Dit topic bestaat niet
;
}elseif($tFetch[type] == 4){
echo
Dit topic is verwijderd
;
}else{
$records = 10;
if(isset($_GET[page]) && ctype_digit($_GET[page])){
$p = $_GET[page];
}else{
$p = 0;
}
$tsQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($tFetch[author]) . "") or die(mysql_error());
$tsFetch = mysql_fetch_assoc($tsQuery);
$tsOnlineQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($tFetch[author]) . " AND DATE_SUB(NOW(),INTERVAL 5 MINUTE) <= last_online") or die(mysql_error());
if(mysql_num_rows($tsOnlineQuery) == 0){
$plaatje = bullet_red;
}else{
$plaatje = bullet_green;
}
$tsPostCountQuery = mysql_query("SELECT * FROM forumreactions WHERE author = " . mysql_real_escape_string($tsFetch[id]) . "") or die(mysql_error());
?>
|
Geplaatst op
|
Moderator; }elseif($tsFetch[type] == 3){ echo Beheerder; }elseif($tsFetch[type] == 4){ echo ; } ?>
Afbeelding niet beschikbaarDe oorspronkelijke afbeelding of link ontbreekt. href="http://.tk-cash.nl"> ; } echo $tsFetch[username]; ?>
Afbeelding niet beschikbaarDe oorspronkelijke afbeelding of link ontbreekt.@file_exists(img/avatars/.$tsFetch[username]...$tsFetch[avatar_type])){ echo img/avatars/.$tsFetch[username]...$tsFetch[avatar_type]; }else{ echo img/noavatar.jpg; } ?>" style="width: 100px; height: 100px;"/>
Posts:
Saldo:
|
if($team == 1){
?> Afbeelding niet beschikbaarDe bron kon niet worden geladen (One2xs).Bron openen ↗ Afbeelding niet beschikbaarDe bron kon niet worden geladen (One2xs).Bron openen ↗
?>
if($tsFetch[type] == 4){
echo Deze gebruiker is verwijderd.
;
}
?>
}
?>
|
$aQuery = mysql_query("SELECT * FROM ads WHERE vertical = 0 AND horizontal = 1 ORDER BY RAND() LIMIT 1") or die(mysql_error());
$aFetch = mysql_fetch_assoc($aQuery);
?>
$allReactionsQuery = mysql_query("SELECT * FROM forumreactions WHERE topic_id = " . mysql_real_escape_string($tFetch[id]) . " AND NOT type=0") or die(mysql_error());
$allReactionsRows = mysql_num_rows($allReactionsQuery);
$pages = ceil($allReactionsRows / $records);
for($i = 1; $i <= $pages; $i++) {
if($i-1 == $p){
$style = border: 1px solid #99B837; background: #B0CD58; padding: 4px; color: #FFFFFF; font-weight: bold;;
}else{
$style = border: 1px solid #969696; background: #FFFFFF; padding: 4px; color: #969696;;
}
echo ;
}
?>
$rQuery = mysql_query("SELECT * FROM forumreactions WHERE topic_id = " . mysql_real_escape_string($tFetch[id]) . " AND type = 1 LIMIT ".($p*$records).",".$records."") or die(mysql_error());
while($rFetch = mysql_fetch_assoc($rQuery)){
$ruQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($rFetch[author]) . "") or die(mysql_error());
$ruFetch = mysql_fetch_assoc($ruQuery);
$ruOnlineQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($rFetch[author]) . " AND DATE_SUB(NOW(),INTERVAL 5 MINUTE) <= last_online") or die(mysql_error());
if(mysql_num_rows($ruOnlineQuery) == 0){
$plaatje = bullet_red;
}else{
$plaatje = bullet_green;
}
$postCountQuery = mysql_query("SELECT * FROM forumreactions WHERE author = " . $ruFetch[id] . "") or die(mysql_error());
?>
}
for($i = 1; $i <= $pages; $i++) {
if($i-1 == $p){
$style = border: 1px solid #99B837; background: #B0CD58; padding: 4px; color: #FFFFFF; font-weight: bold;;
}else{
$style = border: 1px solid #969696; background: #FFFFFF; padding: 4px; color: #969696;;
}
echo ;
}
echo
;
if(isset($_POST[submit])){
if(strlen($_POST[message]) < 3){
echo
Je bericht is te kort!
;
}elseif($tFetch[type] == 2 or $tFetch[type] == 4){
echo
Je kan niet op dit topic reageren!
;
}elseif(!isset($_SESSION[id])){
echo
Log in als je op een topic wilt reageren!
;
}else{
$message = htmlspecialchars($_POST[message]);
$message = nl2br($message);
mysql_query("INSERT INTO forumreactions VALUES (
NULL,
" . mysql_real_escape_string($tFetch[id]) . ",
" . mysql_real_escape_string($message) . ",
" . $_SESSION[id] . ",
1,
NOW()
);
") or die(mysql_error());
mysql_query("UPDATE topics SET last_reaction = NOW() WHERE id = " . mysql_real_escape_string($tFetch[id]) . "") or die(mysql_error());
?>
}
}else{
if($tFetch[type] == 2){
echo
Afbeelding niet beschikbaarDe bron kon niet worden geladen (One2xs).Bron openen ↗ Dit topic is gesloten, je kunt niet reageren.
;
}elseif(!isset($_SESSION[id])){
echo
Log in als je op een topic wilt reageren!
;
}else{
?>
}
}
}
}elseif(isset($_GET[maketopic]) && isset($_SESSION[id])){
?>
Topic aanmaken
$lastPostQuery = mysql_query("SELECT * FROM topics WHERE NOT type = 4 ORDER BY id DESC LIMIT 1") or die(mysql_error());
$lastPostFetch = mysql_fetch_assoc($lastPostQuery);
if($lastPostFetch[author] == $_SESSION[id]){
die(
Je mag maar 1 topic na elkaar maken!
);
}
$cQuery = mysql_query("SELECT * FROM cats WHERE id = " . mysql_real_escape_string($_GET[maketopic]) . "");
$cFetch = mysql_fetch_assoc($cQuery);
if(mysql_num_rows($cQuery) == 0){
echo
Deze categorie bestaat niet
;
}elseif($cFetch[allowed] == 0 and $team == 0){
echo
Je mag geen topics aanmaken in deze categorie!
;
}else{
if(isset($_POST[submit])){
$message = htmlspecialchars($_POST[message]);
$message = nl2br($message);
if(strlen($message) < 3){
echo
Je bericht is te kort!
;
}elseif(strlen($_POST[title]) < 3){
echo
Je titel is te kort!
;
}else{
mysql_query("INSERT INTO topics VALUES (
NULL,
" . mysql_real_escape_string(htmlspecialchars($_POST[title])) . ",
" . $_SESSION[id] . ",
" . mysql_real_escape_string($message) . ",
1,
NOW(),
" . $cFetch[id] . ",
NOW()
);
") or die(mysql_error());
$gQuery = mysql_query("SELECT * FROM topics WHERE author = " . $_SESSION[id] . " ORDER BY id DESC LIMIT 1");
$gFetch = mysql_fetch_assoc($gQuery);
echo
;
}
}
?>
UBB:
|
ubbbuttons(message);
?>
|
}
}elseif(isset($_GET[cat])){
$cQuery = mysql_query("SELECT * FROM cats WHERE id = " . mysql_real_escape_string($_GET[cat]) . "");
$cFetch = mysql_fetch_assoc($cQuery);
if(mysql_num_rows($cQuery) == 0){
echo
Deze categorie bestaat niet
;
}else{
$tQuery = mysql_query("SELECT * FROM topics WHERE catid = " . mysql_real_escape_string($_GET[cat]) . " AND NOT type = 4") or die(mysql_error());
?>
Topics
|
Titel |
Door |
Geplaatst op |
Laatste reactie |
while($tFetch = mysql_fetch_assoc($tQuery)){
$uQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($tFetch[author]) . "") or die(mysql_error());
$uFetch = mysql_fetch_assoc($uQuery);
?>
Afbeelding niet beschikbaarDe oorspronkelijke afbeelding of link ontbreekt. |
|
|
|
|
}
?>
if(isset($_SESSION[id])){
?>
Maak een topic
}
}
}elseif(isset($_GET
Citaat) && isset($_SESSION[id])){
echo
Quote
;
$bQuery = mysql_query("SELECT * FROM forumreactions WHERE id = " . mysql_real_escape_string($_GET
Eerdere citaten tonen
Citaat) . "") or die(mysql_error());
$bFetch = mysql_fetch_assoc($bQuery);
$tQuery = mysql_query("SELECT * FROM topics WHERE id = " . mysql_real_escape_string($bFetch[topic_id]) . "") or die(mysql_error());
$tFetch = mysql_fetch_assoc($tQuery);
if(mysql_num_rows($bQuery) == 0){
echo
Dit bericht bestaat niet!
;
}elseif($tFetch[type] == 2 or $tFetch[type] == 4){
echo
Je kunt niet reageren op dit topic.;
}else{
if(isset($_POST[submit])){
$message = htmlspecialchars($_POST
Eerdere citaten tonen
Citaat);
$message = nl2br($message);
mysql_query("INSERT INTO forumreactions VALUES (
NULL,
" . mysql_real_escape_string($bFetch[topic_id]) . ",
" . mysql_real_escape_string($message) . ",
" . $_SESSION[id] . ",
1,
NOW()
);
") or die(mysql_error());
mysql_query("UPDATE topics SET last_reaction = NOW() WHERE id = " . mysql_real_escape_string($bFetch[topic_id]) . "") or die(mysql_error());
echo
;
}
$uQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($bFetch[author]) . "") or die(mysql_error());
$uFetch = mysql_fetch_assoc($uQuery);
ubbbuttons(msg);
?>
}
}elseif(isset($_GET[edit]) && isset($_SESSION[id])){
$bQuery = mysql_query("SELECT * FROM forumreactions WHERE id = " . mysql_real_escape_string($_GET[edit]) . "") or die(mysql_error());
$bFetch = mysql_fetch_assoc($bQuery);
if($team == 0){
if($bFetch[author] != $_SESSION[id]){
echo
Je mag dit bericht niet aanpassen.
;
die();
}
}
$uQuery = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION[id] . "") or die(mysql_error());
$uFetch = mysql_fetch_assoc($uQuery);
?>
Bericht veranderen
if(mysql_num_rows($bQuery) == 0){
echo
Dit bericht bestaat niet!
;
}else{
if(isset($_POST[submit])){
$message = htmlspecialchars($_POST[edit]);
$message = nl2br($message);
mysql_query("UPDATE forumreactions SET message = " . mysql_real_escape_string($message) . "
Laatst aangepast door " . $uFetch[username] . " om " . date(Y-m-d H:i
) . " WHERE id = " . mysql_real_escape_string($_GET[edit]) . "") or die(mysql_error());
echo
;
}
ubbbuttons(edit);
?>
}
}elseif(isset($_GET[karma]) && isset($_SESSION[id])){
$uQuery = mysql_query("SELECT * FROM users WHERE id = " . mysql_real_escape_string($_GET[karma]) . "") or die(mysql_error());
$uFetch = mysql_fetch_assoc($uQuery);
if(mysql_num_rows($uQuery) > 0){
if(isset($_SESSION[karma . $uFetch[id]])){
echo Je kan niet 2x stemmen op dezelfde persoon!;
}elseif($uFetch[id] == $_SESSION[id]){
echo Je kan niet op jezelf stemmen!;
}else{
mysql_query("UPDATE users SET karma = karma + 1 WHERE id = " . mysql_real_escape_string($_GET[karma]) . "") or die(mysql_error());
$_SESSION[karma . $uFetch[id]] = true;
echo Karma gegeven!;
}
}else{
echo Gebruiker bestaat niet;
}
}else{
?>
Forum
$cQuery = mysql_query("SELECT * FROM cats");
while($cFetch = mysql_fetch_assoc($cQuery)){
?>
}
}
?>
Afbeelding niet beschikbaarDe bron kon niet worden geladen (i41.tinypic.com).Bron openen ↗
