also immerhin gibt es schon etwas aus ... aber leider nicht in dem gewünschten feld und leider nicht die zahl die ich suche...^^
die größte belegte zahl ist eigentlich die 5 also müsste 6 ausgegeben werden ... es wird aber 1 ausgegeben
und nicht in dem feld sonder ganz oben in der datei ...
<?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['preis'] = escape($_POST['preis'], 'string');
$_POST['reisenr'] = escape($_POST['reisenr'], 'string');
$_POST['termin'] = escape($_POST['termin'], 'string');
$_POST['startseite'] = escape($_POST['startseite'], 'boolean');
$_POST['newsID'] = escape($_POST['newsID'], 'integer');
$_POST['kal_eintrag'] = escape($_POST['kal_eintrag'], 'integer');
$_POST['kal_datum'] = escape($_POST['kal_datum'], 'string');
$_POST['kal_time'] = escape($_POST['kal_time'], '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_reisenr,news_startseite,news_termin)
VALUES ('" . $_POST['titel'] . "'," . $_SESSION['authid'] . ",NOW()," . $_POST['grecht'] . ",'" . $_POST['katLis'] . "','" . $text . "','" . $_POST['preis'] . "','" . $_POST['reisenr'] . "','" . $_POST['startseite'] . "','" . $_POST['termin'] . "')");
// Kalendereintrag
if($_POST['kal_eintrag'] == 1) {
list($st, $min) = explode(":", $_POST['kal_time']);
list($year, $month, $day) = explode('-', $_POST['kal_datum']);
$news_id = mysql_insert_id();
$timestamp = mktime($st, $min, 0, $month, $day, $year);
db_query("INSERT INTO `prefix_kalender` (time, title, text, recht, news_id)
VALUES ('$timestamp', '{$_POST['titel']}', '', 0, $news_id)");
}
// 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_preis = "' . $_POST['preis'] . '",
news_reisenr = "' . $_POST['reisenr'] . '",
news_startseite = "' . $_POST['startseite'] . '",
news_termin = "' . $_POST['termin'] . '",
news_text = "' . $text . '" WHERE news_id = "' . $_POST['newsID'] . '" LIMIT 1');
$edit = $_POST['newsID'];
if($_POST['kal_eintrag'] == 1) {
list($min, $st) = explode(":", $_POST['kal_time']);
list($year, $month, $day) = explode('-', $_POST['kal_datum']);
$news_id = mysql_insert_id();
$timestamp = mktime($st, $min, 0, $month, $day, $year);
db_query("UPDATE `prefix_kalender` SET
time = '$timestamp',
title = '{$_POST['titel']}',
text = '',
recht = 0
WHERE news_id = {$_POST['newsID']}");
}
}
}
// edit
// del
if ($menu->get(1) == 'del') {
$res = db_result(db_query("SELECT COUNT(*) FROM `prefix_kalender` WHERE news_id = '{$menu->get(2)}'"));
if($res == 1) {
db_query("DELETE FROM `prefix_kalender` WHERE news_id = '{$menu->get(2)}'");
}
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
$path = "SELECT * FROM prefix_blabla WHERE news_startseite=MAX(news_startseite)";
$erg = db_query("SELECT MAX(news_startseite) FROM prefix_news");
$row = db_fetch_assoc($erg);
print $row["news_startseite"];
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';
$display = 'none';
$checked = '';
$uhrzeit = date("H:i");
$datum = date("Y-m-d");
$Fpreis = 'Preis: ----€';
$Freisenr = 'Reise-Nr.: ';
$Ftermin = 'Termin: ';
$Fstartseite = $row['news_startseite']++;
print $row['news_startseite']++;
} else {
$kalender = db_fetch_object(db_query("SELECT time, news_id FROM `prefix_kalender` WHERE news_id = '{$menu->get(2)}'"));
if($kalender->news_id != 0 || $kalender->news_id != '') {
$uhrzeit = date("H:i", $kalender->time);
$datum = date("Y-m-d", $kalender->time);
$display = 'block';
$checked = 'checked="checked"';
} else {
$uhrzeit = '';
$datum = '';
$display = 'none';
$checked = '';
}
$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;
$Fstartseite = $row->news_startseite;
}
$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,
'FSTARTSEITE' => $Fstartseite,
'DISPLAY' => $display,
'CHECKED' => $checked,
'UHRZEIT' => $uhrzeit,
'DATUM' => $datum
);
$tpl->set_ar_out($ar, 0);
// e d i t , d e l e t e
$abf = 'SELECT news_id,news_title,news_startseite
FROM `prefix_news`
ORDER BY news_startseite 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, 'START' => $row->news_startseite) , 1);
}
// e d i t , d e l e t e
$tpl->set_ar_out(array ('MPL' => $MPL) , 2);
}
$design->footer();
?>