Newssystem duplizieren, nur wie genau ?

[Lokutos]

ALTER TABLE `vms_news` ADD `category` TINYINT NOT NULL DEFAULT '1' ;

<?php
if (!isset($titel)) $titel = '';
if (!isset($news)) $news = '';
if (!isset($id)) $id = '0';
if (!isset($_POST['auffuehren'])) $_POST['auffuehren'] = '0';
if (!isset($_POST['load'])) $_POST['load'] = '0';
if (!isset($_POST['loader'])) $_POST['loader'] = '0';
if (!isset($_POST['category'])) $_POST['category'] = '1';


if ($_POST['news4'] == 'seite') {
    db_query("UPDATE " . $db_prefix . "_kontodaten SET news='1' WHERE 1");
    if ($_POST['id'] == 0) db_query("INSERT INTO " . $db_prefix . "_news (zeit,titel,news,category) VALUES ('" . time() . "','" . $_POST['titel'] . "','" . $_POST['news'] . "','" . $_POST['category'] . "')");
    if ($_POST['id'] >= 1) db_query("UPDATE " . $db_prefix . "_news SET titel='" . $_POST['titel'] . "',news='" . $_POST['news'] . "' WHERE id='" . $_POST['id'] . "'");
}


if ($_POST['news2'] == 'Newsletter und seite') {
    db_query("UPDATE " . $db_prefix . "_kontodaten SET news='1' WHERE 1");
    if ($_POST['id'] == 0) db_query("INSERT INTO " . $db_prefix . "_news (zeit,titel,news,category) VALUES ('" . time() . "','" . $_POST['titel'] . "','" . $_POST['news'] . "','" . $_POST['category'] . "')");
    if ($_POST['id'] >= 1) db_query("UPDATE " . $db_prefix . "_news SET titel='" . $_POST['titel'] . "',news='" . $_POST['news'] . "' WHERE id='" . $_POST['id'] . "'");
    $empfaenger = db_query('SELECT emailadresse FROM ' . $db_prefix . '_emaildaten WHERE freigabe_fuer = 1 OR freigabe_fuer = 3 GROUP BY emailadresse');
    while ($user = mysql_fetch_assoc($empfaenger)) usermail ($user['emailadresse'], $_POST['titel'], $_POST['news'], '"' . $seitenname . '" <' . $betreibermail . '>');
}
if ($_POST['news3'] == 'Newsletter') {
    db_query("UPDATE " . $db_prefix . "_kontodaten SET news='1' WHERE 1");
    $empfaenger = db_query('SELECT emailadresse FROM ' . $db_prefix . '_emaildaten WHERE freigabe_fuer = 1 OR freigabe_fuer = 3 GROUP BY emailadresse');
    while ($user = mysql_fetch_assoc($empfaenger)) usermail ($user['emailadresse'], $_POST['titel'], $_POST['news'], '"' . $seitenname . '" <' . $betreibermail . '>');
}


if ($_POST['load'] == 'Editieren') {
    $edit = mysql_fetch_array(db_query("SELECT * FROM " . $db_prefix . "_news  WHERE id='" . $_POST['loader'] . "'"));
    $titel = $edit['titel'];
    $news = $edit['news'];
    $id = $edit['id'];
}
if ($_POST['load'] == 'Löschen') {
    db_query("DELETE FROM " . $db_prefix . "_news WHERE id='" . $_POST['loader'] . "'");
}


head("News editieren / löschen");
?>
<table>
<form action="" method="post">
<tr>
<td>
<select name="loader" size="1">
<?php
$old_news = db_query("SELECT * FROM " . $db_prefix . "_news ORDER BY id DESC");
while ($load = mysql_fetch_array($old_news)) {
    echo '<option value="' . $load['id'] . '">(' . $load['id'] . ') - ' . $load['titel'] . ' (' . date("d.m.Y - H:i", $load['zeit']) . ')</option>';
}


?>
</select>
</td>
<td><input type="Submit" name="load" value="Editieren"></td>
<td><input type="Submit" name="load" value="Löschen"></td>
</tr>
</form>
</table>
<?php foot();
head("News schreiben (html erlaubt!)");
?>
<div align="center">
<form action="" method="post">
<b>Newstitel</b><br>
<input type="Text" name="titel" value="<?php echo $titel;?>"><br>
<br>
<select name="category" size="1">
  <option value="1">1</option>
  <option value="2">2</option>
  <option value="3">3</option>
</select>
<b>News</b><br>
<textarea name="news" style="width:900px; height:1000px;"><?php echo $news;?></textarea><br>
<br>
<br>
<input type="Submit" name="news4" value="seite">
<input type="Submit" name="news2" value="Newsletter und seite">
<input type="Submit" name="news3" value="Newsletter">
<input type="Hidden" name="id" value="<?php echo $id;?>">
</form>
</div>
<?php foot();?>

<?php
$gelesen = db_query("UPDATE " . $db_prefix . "_kontodaten SET news='0' WHERE uid = " . $_SESSION['uid'] . "");


if ($_GET['seite'] == '') {
    $_GET['seite'] = 1;
}


if (!isset($_GET['category']) or !in_array($_GET['category'],array(1,2,3))) {
    $category = 1;
}else{
    $category = (int)$_GET['category']
}




$start = $_GET['seite'] * 10 - 10;
$sql = db_query("SELECT * FROM " . $db_prefix . "_news WHERE `category` = '".$category."' ORDER BY id DESC LIMIT $start, 10");
while ($news = mysql_fetch_array($sql)) {
    head($news['titel'] . ' vom ' . date("d.m.Y - H:i:s", $news['zeit']));
    echo'<div style="text-align: left; ">';
    echo '<br>';
    echo nl2br($news['news']);
    echo'</div>';
    foot();
}
head('Seiten');


$seiten = db_query("SELECT id FROM " . $db_prefix . "_news");
$menge = mysql_num_rows($seiten);
$seitenanzahl = $menge / 10;


echo "<font face=\"Verdana\" size=\"1\" ><b>Seite:</b> </font> ";


for($a = 0; $a < $seitenanzahl; $a++) {
    $b = $a + 1;


    if ($_GET['seite'] == $b) {
        echo "  $b ";
    } else {
        echo "  <a href=\"?content=/news/index&seite=$b\">$b</a> ";
    }
}


?>

probier mal....

im userbereich dan ?content=/news&category=1 2 oder 3 ... letzte chance vorbei ;-)