session_start(); include("config.php"); $time=time(); $status_db = mysql_query("SELECT * FROM status WHERE nickname = '$_SESSION[nickname]'"); $status = mysql_fetch_array($status_db); $team_db = mysql_query("SELECT * FROM teams WHERE ID = '$status[team]'"); $team = mysql_fetch_array($team_db); $board_db = mysql_query("SELECT * FROM board WHERE team = '$status[team]'"); $board = mysql_fetch_array($board_db); $board2_db = mysql_query("SELECT * FROM board WHERE team = '0' && ID = '130'"); $board2 = mysql_fetch_array($board2_db); ?>
suche if($status['trang'] > 3){ ?> - Admin } ?> - Home |
||||||||||||||||||||||||||||||||||||||||||||||||
echo "Hier kannst du das Board nach Beiträgen durchsuchen. Gib ein Suchwort ein: "; ?> if($_POST['suchen']){ $such_db = mysql_query("SELECT * FROM board2 WHERE thema LIKE '$_POST[wort]' or beitrag LIKE '$_POST[wort]' or nickname = '$_POST[wort]'"); while($such = mysql_fetch_array($such_db)){ echo " ".$such['thema']." ".nl2br($such['beitrag'])." von: ".$such['nickname']." "; }} ?> |
||||||||||||||||||||||||||||||||||||||||||||||||
if($_POST['admin']){
if($board['board1'] == ""){
mysql_query("UPDATE board Set board1 = '$_POST[board1]', be1 = '$_POST[be1]' WHERE team = '$status[team]'");
echo "Board 1 angelegt Noch ein Board anlegen: "; }else{ if($board['board2'] == ""){ mysql_query("UPDATE board Set board2 = '$_POST[board1]', be2 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 2 angelegt Noch ein Board anlegen: "; }else{ if($board['board3'] == ""){ mysql_query("UPDATE board Set board3 = '$_POST[board1]', be3 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 3 angelegt Noch ein Board anlegen: "; }else{ if($board['board4'] == ""){ mysql_query("UPDATE board Set board4 = '$_POST[board1]', be4 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 4 angelegt Noch ein Board anlegen: "; }else{ if($board['board5'] == ""){ mysql_query("UPDATE board Set board5 = '$_POST[board1]', be5 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 5 angelegt Noch ein Board anlegen: "; }else{ if($board['board6'] == ""){ mysql_query("UPDATE board Set board6 = '$_POST[board1]', be6 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 6 angelegt Noch ein Board anlegen: "; }else{ if($board['board7'] == ""){ mysql_query("UPDATE board Set board7 = '$_POST[board1]', be7 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 7 angelegt Noch ein Board anlegen: "; }else{ if($board['board8'] == ""){ mysql_query("UPDATE board Set board8 = '$_POST[board1]', be8 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 8 angelegt Noch ein Board anlegen: "; }else{ if($board['board9'] == ""){ mysql_query("UPDATE board Set board9 = '$_POST[board1]', be9 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 9 angelegt Noch ein Board anlegen: "; }else{ if($board['board10'] == ""){ mysql_query("UPDATE board Set board10 = '$_POST[board1]', be10 = '$_POST[be1]' WHERE team = '$status[team]'"); echo "Board 10 angelegt"; }else{ if($board['board10'] != ""){ echo "Es sind schon 10 Boards vorhanden "; }}}}}}}}}}} } echo "Einstellung von bis zu 10 Boards. "; ?> Boards editieren if($board['board1'] != "" && $board['board2'] != "" && $board['board3'] != "" && $board['board4'] != "" && $board['board5'] != "" && $board['board6'] != "" && $board['board7'] != "" && $board['board8'] != "" && $board['board9'] != "" && $board['board10'] != ""){ echo "Es sind bereits 10 Boards vorhanden. "; }else{ ?> } if($_GET['update'] > 0){ if($_GET['update'] == 1){ ?> if($_POST['update']){ echo " Board 1 geändert. "; mysql_query("UPDATE board Set board1 = '$_POST[board1]', be1 = '$_POST[be1]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 2){ ?> if($_POST['update']){ echo " Board 2 geändert. "; mysql_query("UPDATE board Set board2 = '$_POST[board2]', be2 = '$_POST[be2]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 3){ ?> if($_POST['update']){ echo " Board 3 geändert. "; mysql_query("UPDATE board Set board3 = '$_POST[board3]', be3 = '$_POST[be3]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 4){ ?> if($_POST['update']){ echo " Board 4 geändert. "; mysql_query("UPDATE board Set board4 = '$_POST[board4]', be4 = '$_POST[be4]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 5){ ?> if($_POST['update']){ echo " Board 5 geändert. "; mysql_query("UPDATE board Set board5 = '$_POST[board5]', be5 = '$_POST[be5]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 6){ ?> if($_POST['update']){ echo " Board 6 geändert. "; mysql_query("UPDATE board Set board6 = '$_POST[board6]', be6 = '$_POST[be6]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 7){ ?> if($_POST['update']){ echo " Board 7 geändert. "; mysql_query("UPDATE board Set board7 = '$_POST[board7]', be7 = '$_POST[be7]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 8){ ?> if($_POST['update']){ echo " Board 8 geändert. "; mysql_query("UPDATE board Set board8 = '$_POST[board8]', be8 = '$_POST[be8]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 9){ ?> if($_POST['update']){ echo " Board 9 geändert. "; mysql_query("UPDATE board Set board9 = '$_POST[board9]', be9 = '$_POST[be9]' WHERE team = '$status[team]'"); }}else{ if($_GET['update'] == 10){ ?> if($_POST['update']){ echo " Board 10 geändert. "; mysql_query("UPDATE board Set board10 = '$_POST[board10]', be10 = '$_POST[be10]' WHERE team = '$status[team]'"); }} }}} }}} }}} } if($_GET['del'] > 0){ if($_GET['del'] == 1){ mysql_query("UPDATE board Set board1 = '', be1 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 2){ mysql_query("UPDATE board Set board2 = '', be2 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 3){ mysql_query("UPDATE board Set board3 = '', be3 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 4){ mysql_query("UPDATE board Set board4 = '', be4 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 5){ mysql_query("UPDATE board Set board5 = '', be5 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 6){ mysql_query("UPDATE board Set board6 = '', be6 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 7){ mysql_query("UPDATE board Set board7 = '', be7 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 8){ mysql_query("UPDATE board Set board8 = '', be8 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 9){ mysql_query("UPDATE board Set board9 = '', be9 = '' WHERE team = '$status[team]'"); } if($_GET['del'] == 10){ mysql_query("UPDATE board Set board10 = '', be10 = '' WHERE team = '$status[team]'"); } echo "Das Board wurde gelöscht. "; } if($_GET['board'] == "up"){ echo " "; $boarda_db = mysql_query("SELECT * FROM board WHERE team = '$status[team]'"); $boarda = mysql_fetch_array($boarda_db); if($board['board1'] != ""){ echo $boarda['board1']." ".$boarda['be1']; ?> Board ändern - Board löschen } if($board['board2'] != ""){ echo $boarda['board2']." ".$boarda['be2']; ?> Board ändern - Board löschen } if($board['board3'] != ""){ echo $boarda['board3']." ".$boarda['be3']; ?> Board ändern - Board löschen } if($board['board4'] != ""){ echo $boarda['board4']." ".$boarda['be4']; ?> Board ändern - Board löschen } if($board['board5'] != ""){ echo $boarda['board5']." ".$boarda['be5']; ?> Board ändern - Board löschen } if($board['board6'] != ""){ echo $boarda['board6']." ".$boarda['be6']; ?> Board ändern - Board löschen } if($board['board7'] != ""){ echo $boarda['board7']." ".$boarda['be7']; ?> Board ändern - Board löschen } if($board['board8'] != ""){ echo $boarda['board8']." ".$boarda['be8']; ?> Board ändern - Board löschen } if($board['board9'] != ""){ echo $boarda['board9']." ".$boarda['be9']; ?> Board ändern - Board löschen } if($board['board10'] != ""){ echo $boarda['board10']." ".$boarda['be10']; ?> Board ändern - Board löschen }} ?> |
||||||||||||||||||||||||||||||||||||||||||||||||
if($_GET['board'] == 1){ $boardname = $board['board1']; }
if($_GET['board'] == 2){ $boardname = $board['board2']; }
if($_GET['board'] == 3){ $boardname = $board['board3']; }
if($_GET['board'] == 4){ $boardname = $board['board4']; }
if($_GET['board'] == 5){ $boardname = $board['board5']; }
if($_GET['board'] == 6){ $boardname = $board['board6']; }
if($_GET['board'] == 7){ $boardname = $board['board7']; }
if($_GET['board'] == 8){ $boardname = $board['board8']; }
if($_GET['board'] == 9){ $boardname = $board['board9']; }
if($_GET['board'] == 10){ $boardname = $board['board10']; }
if($_GET['board'] == 130){ $boardname = $board2['board1']; }
echo "Neues Thema erstellen im Board ".$boardname.". "; ?> |
||||||||||||||||||||||||||||||||||||||||||||||||
if($_POST['news']){ if($_POST['titel'] == ""){ echo "Du musst ein Thema angeben"; }else{ $beitrag = strip_tags($_POST['beitrag']); mysql_query("INSERT INTO board2 (team, board, art, thema, datum, nickname, beitrag) VALUES ('$status[team]', '$_POST[board]', '1', '$_POST[titel]', '$time', '$_SESSION[nickname]', '$beitrag')"); $beitrag = $status['beitrag'] + 1; mysql_query("UPDATE status Set beitrag = '$beitrag' WHERE nickname = '$_SESSION[nickname]'"); echo "Du hast erfolgreich ein neues Thema erstellt."; } ?> | ||||||||||||||||||||||||||||||||||||||||||||||||
if($_POST['antwort']){
$beitrag = strip_tags($_POST['beitrag']);
mysql_query("INSERT INTO board2 (team, board, thema, datum, nickname, beitrag) VALUES ('$status[team]', '$_POST[board]', '$_POST[thema]', '$time', '$_SESSION[nickname]', '$beitrag')");
$beitrag = $status['beitrag'] + 1;
mysql_query("UPDATE status Set beitrag = '$beitrag' WHERE nickname = '$_SESSION[nickname]'");
echo "Du hast erfolgreich eine Antwort abgegeben. Du wirst in 5 Sekunden weitergeleitet. Wenn dein Browser keine Weiterleitung unterstüzt, klicke "; ?> hier. } ?> |
||||||||||||||||||||||||||||||||||||||||||||||||
echo "Board von ".$team['name']; ?> ->
echo $boardname; ?> ->
echo $beitrag2['thema']; ?>
|
||||||||||||||||||||||||||||||||||||||||||||||||
if($_GET['board'] == 1){ $boardname = $board['board1']; }
if($_GET['board'] == 2){ $boardname = $board['board2']; }
if($_GET['board'] == 3){ $boardname = $board['board3']; }
if($_GET['board'] == 4){ $boardname = $board['board4']; }
if($_GET['board'] == 5){ $boardname = $board['board5']; }
if($_GET['board'] == 6){ $boardname = $board['board6']; }
if($_GET['board'] == 7){ $boardname = $board['board7']; }
if($_GET['board'] == 8){ $boardname = $board['board8']; }
if($_GET['board'] == 9){ $boardname = $board['board9']; }
if($_GET['board'] == 10){ $boardname = $board['board10']; }
if($_GET['board'] == 130){ $boardname = $board2['board1']; }
?>
echo "Board von ".$team['name']; ?> ->
echo $boardname; ?> Neues Thema erstellen
|
||||||||||||||||||||||||||||||||||||||||||||||||
if($board['board1'] != ""){ $bo1_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '1' order by -ID"); $bo1 = mysql_fetch_array($bo1_db); $boa1_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '1' && art = '1'"); $boa1 = mysql_num_rows($boa1_db); $boas1_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '1' && art = '0'"); $boas1 = mysql_num_rows($boas1_db); ?>
} ?> if($board['board2'] != ""){ $bo2_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '2' order by -ID"); $bo2 = mysql_fetch_array($bo2_db); $boa2_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '2' && art = '1'"); $boa2 = mysql_num_rows($boa2_db); $boas2_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '2' && art = '0'"); $boas2 = mysql_num_rows($boas2_db); ?>
} ?> if($board['board3'] != ""){ $bo3_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '3' order by -ID"); $bo3 = mysql_fetch_array($bo3_db); $boa3_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '3' && art = '1'"); $boa3 = mysql_num_rows($boa3_db); $boas3_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '3' && art = '0'"); $boas3 = mysql_num_rows($boas3_db); ?>
} ?> if($board['board4'] != ""){ $bo4_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '4' order by -ID"); $bo4 = mysql_fetch_array($bo4_db); $boa4_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '4' && art = '1'"); $boa4 = mysql_num_rows($boa4_db); $boas4_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '4' && art = '0'"); $boas4 = mysql_num_rows($boas4_db); ?>
} ?> if($board['board5'] != ""){ $bo5_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '5' order by -ID"); $bo5 = mysql_fetch_array($bo5_db); $boa5_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '5' && art = '1'"); $boa5 = mysql_num_rows($boa5_db); $boas5_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '5' && art = '0'"); $boas5 = mysql_num_rows($boas5_db); ?>
} ?> if($board['board6'] != ""){ $bo6_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '6' order by -ID"); $bo6 = mysql_fetch_array($bo6_db); $boa6_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '6' && art = '1'"); $boa6 = mysql_num_rows($boa6_db); $boas6_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '6' && art = '0'"); $boas6 = mysql_num_rows($boas6_db); ?>
} ?> if($board['board7'] != ""){ $bo7_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '7' order by -ID"); $bo7 = mysql_fetch_array($bo7_db); $boa7_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '7' && art = '1'"); $boa7 = mysql_num_rows($boa7_db); $boas7_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '7' && art = '0'"); $boas7 = mysql_num_rows($boas7_db); ?>
} ?> if($board['board8'] != ""){ $bo8_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '8' order by -ID"); $bo8 = mysql_fetch_array($bo8_db); $boa8_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '8' && art = '1'"); $boa8 = mysql_num_rows($boa8_db); $boas8_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '8' && art = '0'"); $boas8 = mysql_num_rows($boas8_db); ?>
} ?> if($board['board9'] != ""){ $bo9_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '9' order by -ID"); $bo9 = mysql_fetch_array($bo9_db); $boa9_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '9' && art = '1'"); $boa9 = mysql_num_rows($boa9_db); $boas9_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '9' && art = '0'"); $boas9 = mysql_num_rows($boas9_db); ?>
} ?> if($board['board10'] != ""){ $bo10_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '10' order by -ID"); $bo10 = mysql_fetch_array($bo10_db); $boa10_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '10' && art = '1'"); $boa10 = mysql_num_rows($boa10_db); $boas10_db = mysql_query("SELECT * FROM board2 WHERE team = '$status[team]' && board = '10' && art = '0'"); $boas10 = mysql_num_rows($boas10_db); ?>
|
Board 0.2 © by Underground-Race.de |