hab ein problem, ich hab in die news noch ein neues feld eingebaut, aber leider kann ich jetzt keine neuen news mehr schreiben...
das ist sehr komisch weil bestehende news kann ich ohne probleme bearbeiten auch das neue feld ausfüllen ....
<?php
// Copyright by: Manuel
// Support: www.ilch.de
defined ('main') or die ('no direct access');
defined ('admin') or die ('only admin access');
$design = new design ('Admins Area', 'Admins Area', 2);
$design->header();
// -----------------------------------------------------------|
// #
// ##
// ###
// #### F u n k t i o n e n
function getKats ($akt) {
$katAR = array();
$kats = '';
$erg = db_query("SELECT DISTINCT news_kat FROM `prefix_news`");
while ($row = db_fetch_object($erg)) {
$katAr[] = $row->news_kat;
}
$katAr[] = 'Allgemein';
$katAr = array_unique($katAr);
foreach($katAr as $a) {
if (trim($a) == trim($akt)) {
$sel = ' selected';
} else {
$sel = '';
}
$kats .= '<option' . $sel . '>' . $a . '</option>';
}
return ($kats);
}
function image_valid($type) {
$file_types = array(
'image/pjpeg' => 'jpg',
'image/jpeg' => 'jpg',
'image/jpeg' => 'jpeg',
'image/gif' => 'gif',
'image/X-PNG' => 'png',
'image/PNG' => 'png',
'image/png' => 'png',
'image/x-png' => 'png',
'image/JPG' => 'jpg',
'image/GIF' => 'gif',
);
if ( !array_key_exists ( $type, $file_types ) ) {
return false;
} else {
return true;
}
}
// #### F u n k t i o n
// ###
// ##
// #
// #
// ##
// ###
// #### A k t i o n e n
if (!empty($_REQUEST['um'])) {
$um = $_REQUEST['um'];
$_POST['titel'] = escape($_POST['titel'], 'string');
$_POST['grecht'] = escape($_POST['grecht'], 'integer');
$_POST['kat'] = escape($_POST['kat'], 'string');
$_POST['katLis'] = escape($_POST['katLis'], 'string');
$_POST['newsID'] = escape($_POST['newsID'], 'integer');
$_POST['preis'] = escape($_POST['preis'], 'string');
$_POST['reisenr'] = escape($_POST['reisenr'], 'string');
$_POST['termin'] = escape($_POST['termin'], 'string');
if ($um == 'insert') {
// insert
$text = escape($_POST['txt'], 'textarea');
if ($_POST['katLis'] == 'neu') {
$_POST['katLis'] = $_POST['kat'];
// Hochgeladenes Bild verarbeiten
if(isset($_FILES['bild_upload']) && image_valid($_FILES['bild_upload']['type'])) {
$datei_endung = explode(".", $_FILES['bild_upload']['name']);
$i = count($datei_endung) -1;
$datei_endung = $datei_endung[$i];
$speicherort = "include/images/news/" . $_POST['kat'] . "." . $datei_endung;
move_uploaded_file($_FILES['bild_upload']['tmp_name'], $speicherort);
}
}
db_query("INSERT INTO `prefix_news` (news_title,user_id,news_time,news_recht,news_kat,news_text,news_preis,news_termin)
VALUES ('" . $_POST['titel'] . "'," . $_SESSION['authid'] . ",NOW()," . $_POST['grecht'] . ",'" . $_POST['katLis'] . "','" . $text . "','" . $_POST['preis'] . "','" . $_POST['reisenr'] . "','" . $_POST['termin'] . "')");
// insert
} elseif ($um == 'change') {
// edit
$text = escape($_POST['txt'], 'textarea');
if ($_POST['katLis'] == 'neu') {
$_POST['katLis'] = $_POST['kat'];
}
db_query('UPDATE `prefix_news` SET
news_title = "' . $_POST['titel'] . '",
user_id = "' . $_SESSION['authid'] . '",
news_recht = "' . $_POST['grecht'] . '",
news_kat = "' . $_POST['katLis'] . '",
news_text = "' . $text . '",
news_preis = "' . $_POST['preis'] . '",
news_reisenr = "' . $_POST['reisenr'] . '",
news_termin = "' . $_POST['termin'] . '"
WHERE news_id = "' . $_POST['newsID'] . '"
LIMIT 1');
$edit = $_POST['newsID'];
}
}
// edit
// del
if ($menu->get(1) == 'del') {
db_query('DELETE FROM `prefix_news` WHERE news_id = "' . $menu->get(2) . '" LIMIT 1');
}
// del
// #### A k t i o n e n
// ###
// ##
// #
// #
// ##
// ###
// #### h t m l E i n g a b e n
if (empty ($doNoIn)) {
$limit = 20; // Limit
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1);
$MPL = db_make_sites ($page , '' , $limit , "?news" , 'news');
$anfang = ($page - 1) * $limit;
if ($menu->get(1) != 'edit') {
$FnewsID = '';
$Faktion = 'insert';
$Fueber = '';
$Fstext = '';
$Ftxt = '';
$Fgrecht = '';
$FkatLis = '';
$Fsub = 'Eintragen';
$Fpreis = 'Preis: ----€';
$Freisenr = '';
$Ftermin = 'Termin: ';
} else {
$row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = " . $menu->get(2)));
$FnewsID = $row->news_id;
$Faktion = 'change';
$Fueber = $row->news_title;
$Ftxt = stripslashes($row->news_text);
$Fgrecht = $row->news_recht;
$FkatLis = $row->news_kat;
$Fsub = 'Ändern';
$Fpreis = $row->news_preis;
$Freisenr = $row->news_reisenr;
$Ftermin = $row->news_termin;
}
$tpl = new tpl ('news', 1);
$ar = array
(
'NEWSID' => $FnewsID,
'AKTION' => $Faktion,
'MPL' => $MPL,
'UEBER' => $Fueber,
'txt' => $Ftxt,
'SMILIS' => getsmilies(),
'grecht' => dbliste($Fgrecht, $tpl, 'grecht', "SELECT id,name FROM prefix_grundrechte ORDER BY id DESC"),
'KATS' => getKats($FkatLis),
'FSUB' => $Fsub,
'FPREIS' => $Fpreis,
'FREISENR' => $Freisenr,
'FTERMIN' => $Ftermin,
);
$tpl->set_ar_out($ar, 0);
// e d i t , d e l e t e
$abf = 'SELECT news_id,news_title
FROM `prefix_news`
ORDER BY news_time DESC
LIMIT ' . $anfang . ',' . $limit;
$erg = db_query($abf);
$class = '';
while ($row = db_fetch_object($erg)) {
$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite');
$tpl->set_ar_out(array ('ID' => $row->news_id, 'class' => $class, 'TITEL' => $row->news_title) , 1);
}
// e d i t , d e l e t e
$tpl->set_ar_out(array ('MPL' => $MPL) , 2);
}
$design->footer();
?>
hier die von mir geänderte news.php aus dem admin bereich
Zitat geschrieben von Lord|Schirmer