her er hele koden :
<html>
<head>
<script type="text/javascript">
var cursorpos;
function insertText(frmElm,text,fokus) {
if (cursorpos && typeof cursorpos.start == "number") { // For Mozilla
frmElm.value = frmElm.value.substring(0,cursorpos.start)+text+frmElm.value.substring(cursorpos.end);
if (fokus) {
frmElm.setSelectionRange(cursorpos.end+text.length,cursorpos.end+text.length);
frmElm.focus();
}
} else if (cursorpos && cursorpos.range) { // For IE
r = cursorpos.range;
r.text = text;
if (fokus) {frmElm.focus();}
} else { // For everyone else
frmElm.value += text;
if (fokus) {frmElm.focus();}
}
}
function storeCaretPos(frmElm) {
if (typeof frmElm.selectionEnd == "number") {
cursorpos = {start:frmElm.selectionStart,end:frmElm.selectionEnd}
} else if (document.selection) {
cursorpos = {range:document.selection.createRange().duplicate()}
} else;
}
</script>
<LINK href="css.css" type=text/css rel=stylesheet>
<title>AdminiStration</title>
<meta name="generator" content="TSW WebCoder">
</head>
<body bgcolor="#000000">
<center>
<TABLE id=table1 height="100%" width=803 border=0>
<TBODY>
<TR>
<TD width=797 colSpan=2 height=100>
<img border="0" src="ad.gif" width="800" height="101"></TD></TR>
<TR>
<TD width=797 colSpan=2 height=30>
<center>
<div align="center"><br>
AdminiStration<br>
</a><br>
<br>
</div></TD></TR>
<TR>
<TD valign=top width=201 style="BORDER-TOP: #FFFFFF 1px solid; BORDER-LEFT: #FFFFFF 1px solid; BORDER-RIGHT: #FFFFFF 1px solid; BORDER-BOTTOM: #FFFFFF 1px solid">
<TABLE id=iceo.dk style="cellSpacing=0 cellPadding=0 width=201 border=0" width="200">
<TBODY>
<TR>
<TD height=20>
<div align="left">Menu</div></TD></TR>
<TR>
<TD>
<div align="left"><a href="index.php?s=news">News</a><br>
<a href="sponsor.php?s=sponsor">Sponsor</a><br>
<a href="guide.php?s=guide">Guide</a><br />
<a href="tag.php">Tagwall</a><br />
<a href="../../root.php">Tilbage til oversigt</a><br />
<a href="logout.php">Logud</a>
<font color="#FFFFFF"><br></div>
</TD></TR></TBODY></TABLE>
<TD style="PADDING-TOP: 0px" valign=top width=592 style="BORDER-RIGHT: #FFFFFF 1px solid; BORDER-TOP: #FFFFFF 1px solid; BORDER-LEFT: #FFFFFF 1px solid; BORDER-BOTTOM: #FFFFFF 1px solid">
<script type="text/javascript">
_editor_url = "
http://max-gaming.dk/login/htmlarea/"; _editor_lang = "en";
</script>
<!-- load the main HTMLArea file -->
<script type="text/javascript" src="
http://max-gaming.dk/login/htmlarea/htmlarea.js"></script> <script type="text/javascript">
var editor;
function initDocument() {
editor = new HTMLArea("editor");
editor.generate();
}
</script>
<script>
window.onload = initDocument;
</script><?
// Start af php
if (!$_GET ["s"]) { ?>Vælg en af menu punkterne<br />
<? }elseif ($_GET ["s"] == "sponsor") { ?>
<form method="post" action="sponsor.php?s=done">
Titel:<input name="emne" type="text"> Oprettet af:
<input type="text" name="op" size="20" value="<? echo "$_SESSION[username]"; ?>"><p>
<textarea id="editor" name="text" style="width:400px; height:200px"></textarea><br />
</p>
<table border="0" width="76%">
<tr>
<td width="15">
<a href="java script:editor.insertHTML(':D');"><img border="0" src="smilie/icon_biggrin.gif" width="15" height="15"></a></td>
<td width="15">
<a href="java script:editor.insertHTML(':S');"><img border="0" src="smilie/icon_confused.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':8');"><img border="0" src="smilie/icon_cool.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':cry:');"><img border="0" src="smilie/icon_cry.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':¨');"><img border="0" src="smilie/icon_cry.gif" width="15" height="15"></td>
<td width="14">
<a href="java script:editor.insertHTML(':e');"><img border="0" src="smilie/icon_evil.gif" width="15" height="15"><td width="16">
<a href="java script:editor.insertHTML('!');"><img border="0" src="smilie/icon_exclaim.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':i');"><img border="0" src="smilie/icon_idea.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML('LOL');"><img border="0" src="smilie/icon_lol.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':[');"><img border="0" src="smilie/icon_mad.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':|');"><img border="0" src="smilie/icon_neutral.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML('?');"><img border="0" src="smilie/icon_question.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':r');"><img border="0" src="smilie/icon_razz.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':f');"><img border="0" src="smilie/icon_redface.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':re');"><img border="0" src="smilie/icon_rolleyes.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':(');"><img border="0" src="smilie/icon_sad.gif" width="15" height="15"></td>
<td width="17">
<a href="java script:editor.insertHTML(':)');"><img border="0" src="smilie/icon_smile.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(':O');"><img border="0" src="smilie/icon_surprised.gif" width="15" height="15"></td>
<td width="15">
<a href="java script:editor.insertHTML(' :tw');"><img border="0" src="smilie/icon_twisted.gif" width="15" height="15"></td>
<td>
<a href="java script:editor.insertHTML(';)');"><img border="0" src="smilie/icon_wink.gif" width="15" height="15"></td>
<td>
</td>
</tr>
</table>
<p>
<br />
</p>
<p>
<input type="submit" name="Submit" value="Send">
</form>
<br /><font color="#FF0000">OBS: HUSK NU AT DET VIRKER KUN ORDENLIGT I FIREFOX!!!!</font>
<br />
<a href="index.php?s=list">Rediger nyheder</a><br />
<a href="index.php?s=slet">Slet nyheder</a>
<?
// Start af mysql query
}elseif ($_GET ["s"] == "list") {
include "mysql.php";
/* Antallet af poster vi ønsker vist på hver side */
$pr_side = 3;
/* Vi tæller antallet af poster i tabellen husk at ændre ‘table’ til dit eget tabelnavn */
$antal = mysql_result(mysql_query("SELECT COUNT(*) FROM news"),0) or die(mysql_error());
/* Hvis visfra-variablen ikke findes i URL-feltet og den ikke er et nummer og den er større end antallet i databasen, så sættes den til 0, ellers sættes den til værdien fra URL feltet */
$vis_fra = (isset($_GET["visfra"]) && is_numeric($_GET["visfra"]) && $_GET["visfra"] < $antal) ? $_GET["visfra"] : 0;
/* Vi laver et database udtræk med limit, så den kun hiver det rigtige antal ud fra tabellen, husk at ændre ‘table’ til dit eget tabelnavn */
$query = mysql_query ("SELECT * FROM news ORDER BY id DESC limit $vis_fra, $pr_side") or die(mysql_error());
while ($newsrow = mysql_fetch_array($query)){
echo "
<table>
<tr>
<td>
<b>".$newsrow['emne']." - Dato: ".$newsrow['dato']."</b><br />
";
$text = htmlspecialchars($newsrow['nyhed']);
$text = str_replace(":D", "<img src=\"smilie/icon_biggrin.gif\">", $text);
$text = str_replace(":S", "<img src=\"smilie/icon_confused.gif\">", $text);
$text = str_replace(":8", "<img src=\"smilie/icon_cool.gif\">", $text);
$text = str_replace(":cr", "<img src=\"smilie/icon_cry.gif\">", $text);
$text = str_replace(":¨", "<img src=\"smilie/icon_eek.gif\">", $text);
$text = str_replace(":e", "<img src=\"smilie/icon_evil.gif\">", $text);
$text = str_replace("!", "<img src=\"smilie/icon_exclaim.gif\">", $text);
$text = str_replace(":i", "<img src=\"smilie/icon_idea.gif\">", $text);
$text = str_replace(":l", "<img src=\"smilie/icon_lol.gif\">", $text);
$text = str_replace(":[", "<img src=\"smilie/icon_mad.gif\">", $text);
$text = str_replace(":|", "<img src=\"smilie/icon_neutral.gif\">", $text);
$text = str_replace("?", "<img src=\"smilie/icon_question.gif\">", $text);
$text = str_replace(":r", "<img src=\"smilie/icon_razz.gif\">", $text);
$text = str_replace(":f", "<img src=\"smilie/icon_redface.gif\">", $text);
$text = str_replace(":re", "<img src=\"smilie/icon_rolleyes.gif\">", $text);
$text = str_replace(":(", "<img src=\"smilie/icon_sad.gif\">", $text);
$text = str_replace(":)", "<img src=\"smilie/icon_smile.gif\">", $text);
$text = str_replace(":O", "<img src=\"smilie/icon_surprised.gif\">", $text);
$text = str_replace(":tw", "<img src=\"smilie/icon_twisted.gif\">", $text);
$text = str_replace(";)", "<img src=\"smilie/icon_wink.gif\">", $text);
$text = nl2br($text);
echo $text;
?>
<br>
<br>
<a href="index.php?s=edit&id=<?=$newsrow[id];?>">Rediger denne nyhed</a>
<?
echo "
<td>
</tr>
</table>
<br>
<hr />
";
?>
<?
/* Der undersøges om der skal udskrives et ”forrige side”-link, er dette tilfældet udskrives linket */
if ($vis_fra > 0) {
$back= $vis_fra - $pr_side;
echo "<a href='$_SERVER[PHP_SELF]?s=list&visfra=$back'>Forrige</a> ";
}
$page = 1;
/* Alle siderne udskrives så man med et klik kan få resultaterne fra fx 90-100 */
for ($start = 0; $antal > $start; $start = $start + $pr_side) {
if($vis_fra != $page * $pr_side - $pr_side) {
echo "<a href='$_SERVER[PHP_SELF]?s=list&visfra=$start'>$page</a> ";
} else {
echo $page." ";
}
$page++;
}
/* Der undersøges om der skal udskrives et ”næste side”-link, er dette tilfældet udskrives linket */
if ($vis_fra < $antal - $pr_side) {
$next = $vis_fra + $pr_side;
echo " <a href='$_SERVER[PHP_SELF]?s=list&visfra=$next'>Næste</a>";
}
?>
<?
// link til rediger nyheder
}if ($_GET["index.php"] ) {
mysql_query("SELECT * FROM news WHERE id = '$_GET[id]") or die (mysql_error());
}
?>
<?
//Opretelse af nyhed til Mysql DB
}elseif ($_GET["s"] == "done") {
include "mysql.php";
echo "Nu er nyheden oprettet :)";
mysql_query("INSERT INTO sponsor (text)
VALUES ('".$_POST['text']."');") or die(mysql_error());
//Opretelse af nyhed til MySql DB Slut
} ?>
<?
// Start af Edit form
}elseif ($_GET ["s"] == "edit") {
include "mysql.php";
$query = mysql_query ("SELECT * FROM news WHERE id = '$_GET[id]'") or die(mysql_error());
while ($newsrow = mysql_fetch_array($query)){
?>
<table cellpadding="0" cellspacing="0" border="0" width="450" style="FONT-SIZE: 8pt">
<tr>
<td valign="top">
<form action="index.php?s=update&?id=<?=$newsrow["id"]?>" method="POST" name="form1">
<p>
Emne:<br>
<input type="text" name="emne" value="<?php echo $newsrow[emne]; ?>">
</p>
<br>
<br>
<script type="text/javascript">
_editor_url = "
http://iceo.dk/htmlarea/"; _editor_lang = "en";
</script>
<!-- load the main HTMLArea file -->
<script type="text/javascript" src="
http://iceo.dk/htmlarea/htmlarea.js"></script> <script type="text/javascript">
var editor;
function initDocument() {
editor = new HTMLArea("editor");
editor.generate();
}
</script>
<script>
window.onload = initDocument;
</script>
Nyhed:<br>
<textarea id="editor" name="nyhed" style="width:400px; height:200px"><?php echo $newsrow[nyhed]; ?></textarea>
<br>
<br>
<input type="hidden" name="id" value="<?=$newsrow[id];?>">
<input type="submit" value="Opdater">
<br>
</p>
</form>
<br>
<a href="index.php?s=list">Se alle nyheder</a>
<?
}
?>
</td></tr></table></center>
<?PHP
// start af update
}elseif ($_GET ["s"] == "update") {
//åbne forbindelse til servern
include "mysql.php";
$emne = $_REQUEST["emne"];
$id = $_REQUEST["id"];
$nyhed = $_REQUEST["nyhed"];
$dato = date("d-m-Y, H:i:s");
//dette for alle ting der skal opdateres
$query = "UPDATE `news` SET `emne` = '$emne', `nyhed` = '$nyhed', `dato` = '$dato' WHERE `id` = '$id'";
$newsrow = mysql_query($query);
echo "Nu er nyheden opdateret"; ?><br><br>
<?
include "mysql.php";
$query = mysql_query ("SELECT * FROM news ORDER BY id LIMIT 1") or die(mysql_error());
while ($newsrow = mysql_fetch_array($query)){
if($_GET["index.php"] ) {
mysql_query("SELECT * FROM news WHERE id = '$_GET[id] LIMIT 1") or die (mysql_error());
}
?>
<?
}
?>
<a href="index.php?s=eidt&id=<?=$newsrow[id];?>">Rediger denne nyhed igen</a><br>
<a href="index.php?s=list">Se alle nyheder</a>
<? //Slut ?>
<?
// Start af Slet nyheder
}elseif ($_GET ["s"] == "slet") {
include "mysql.php";
$query = mysql_query ("SELECT * FROM news ORDER BY id DESC") or die(mysql_error());
while ($newsrow = mysql_fetch_array($query)){
echo "
<table>
<tr>
<td>
<b>".$newsrow['emne']." - Dato: ".$newsrow['dato']."</b><br />
";
$text = htmlspecialchars($newsrow['nyhed']);
$text = str_replace(":D", "<img src=\"smilie/icon_biggrin.gif\">", $text);
$text = str_replace(":S", "<img src=\"smilie/icon_confused.gif\">", $text);
$text = str_replace(":8", "<img src=\"smilie/icon_cool.gif\">", $text);
$text = str_replace(":cr", "<img src=\"smilie/icon_cry.gif\">", $text);
$text = str_replace(":¨", "<img src=\"smilie/icon_eek.gif\">", $text);
$text = str_replace(":e", "<img src=\"smilie/icon_evil.gif\">", $text);
$text = str_replace("!", "<img src=\"smilie/icon_exclaim.gif\">", $text);
$text = str_replace(":i", "<img src=\"smilie/icon_idea.gif\">", $text);
$text = str_replace(":l", "<img src=\"smilie/icon_lol.gif\">", $text);
$text = str_replace(":[", "<img src=\"smilie/icon_mad.gif\">", $text);
$text = str_replace(":|", "<img src=\"smilie/icon_neutral.gif\">", $text);
$text = str_replace("?", "<img src=\"smilie/icon_question.gif\">", $text);
$text = str_replace(":r", "<img src=\"smilie/icon_razz.gif\">", $text);
$text = str_replace(":f", "<img src=\"smilie/icon_redface.gif\">", $text);
$text = str_replace(":re", "<img src=\"smilie/icon_rolleyes.gif\">", $text);
$text = str_replace(":(", "<img src=\"smilie/icon_sad.gif\">", $text);
$text = str_replace(":)", "<img src=\"smilie/icon_smile.gif\">", $text);
$text = str_replace(":O", "<img src=\"smilie/icon_surprised.gif\">", $text);
$text = str_replace(":tw", "<img src=\"smilie/icon_twisted.gif\">", $text);
$text = str_replace(";)", "<img src=\"smilie/icon_wink.gif\">", $text);
$text = nl2br($text);
echo $text;
?>
<a href="index.php?s=slet&action=slet&id=<?=$newsrow[id];?>">Slet nyhed</a>
<?
if($_GET["action"] == "slet") {
mysql_query("DELETE FROM news WHERE id = $_GET[id] LIMIT 1") or die (mysql_error());
}
echo "
<td>
</tr>
</table>
<hr />
";
}
// Slut slet nyheder
?>
</TR></TD></TBODY></TABLE><br>
</body>
</html>
<?
}
?>