| 1 |
lars |
1 |
<?
|
|
|
2 |
$self=basename($PHP_SELF);
|
|
|
3 |
$tab="speisekarte";
|
|
|
4 |
define ("modul_name", "restaurant");
|
|
|
5 |
define ("tool_name", "speisen");
|
|
|
6 |
|
|
|
7 |
require_once "../Online-Shop/connect2.php";
|
|
|
8 |
|
|
|
9 |
if ($action=="update")
|
|
|
10 |
{
|
|
|
11 |
$von=join("-",array_reverse(preg_split("/\./",$von)));
|
|
|
12 |
$bis=join("-",array_reverse(preg_split("/\./",$bis)));
|
|
|
13 |
if ($ID)
|
|
|
14 |
{
|
|
|
15 |
$query="update $tab set Titel='$Titel', Text='$Text', Preis='$Preis', Rang='$Rang', von='$von', bis='$bis' where ID = $ID";
|
|
|
16 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
|
|
|
17 |
header("Location: "."Speisekarte.php");
|
|
|
18 |
}
|
|
|
19 |
else
|
|
|
20 |
{
|
|
|
21 |
$query="insert into $tab (Titel,Text,Preis,Rang,von,bis) VALUES ('$Titel','$Text','$Preis','$Rang','$von','$bis')";
|
|
|
22 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
|
|
|
23 |
header("Location: "."Speisekarte.php");
|
|
|
24 |
}
|
|
|
25 |
}
|
|
|
26 |
if ($action=="delete")
|
|
|
27 |
{
|
|
|
28 |
if ($ID)
|
|
|
29 |
{
|
|
|
30 |
$condition=array();
|
|
|
31 |
foreach ($ID as $elem) {array_push($condition," ID = ".$elem);}
|
|
|
32 |
$cond=join(" or ",$condition);
|
|
|
33 |
$query = "DELETE FROM $tab WHERE $cond";
|
|
|
34 |
$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
|
|
|
35 |
header("Location: "."Speisekarte.php");
|
|
|
36 |
}
|
|
|
37 |
else
|
|
|
38 |
{
|
|
|
39 |
//header("Location: "."KndStamm.php");
|
|
|
40 |
}
|
|
|
41 |
}
|
|
|
42 |
if (!$action)
|
|
|
43 |
{
|
|
|
44 |
$action="select_edit";
|
|
|
45 |
}
|
|
|
46 |
if ($action=="select_edit")
|
|
|
47 |
{
|
|
|
48 |
$headline='Übersicht';
|
|
|
49 |
}
|
|
|
50 |
if ($action=="edit")
|
|
|
51 |
{
|
|
|
52 |
$headline='Neueintrag';
|
|
|
53 |
if ($ID)
|
|
|
54 |
{
|
|
|
55 |
$headline='Bearbeiten';
|
|
|
56 |
}
|
|
|
57 |
}
|
|
|
58 |
if ($action=="delete")
|
|
|
59 |
{
|
|
|
60 |
$headline='Entfernen';
|
|
|
61 |
}
|
|
|
62 |
if ($action=="view")
|
|
|
63 |
{
|
|
|
64 |
$headline='Übersicht';
|
|
|
65 |
}
|
|
|
66 |
|
|
|
67 |
?>
|
|
|
68 |
|
|
|
69 |
<html>
|
|
|
70 |
<head>
|
|
|
71 |
<title>Speisen - Redaktionssystem Webagentur Niewerth</title>
|
|
|
72 |
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
|
|
|
73 |
<meta name="description" content="Redaktionssystem">
|
|
|
74 |
<meta name="author" content="Webagentur Niewerth">
|
|
|
75 |
<meta name="robots" content="noindex">
|
|
|
76 |
<link rel=stylesheet type="text/css" href="../buttons.css">
|
|
|
77 |
<style type="text/css" link="redaktion.css"><MM:BeginLock translatorClass="MM_SSI" type="ssi" orig="%3C? require_once %22../buttons.css%22; ?%3E" fileRef="../buttons.css" depFiles="file:///L|/content-management/buttons.css">span {text-decoration:underline; color:#000000}
|
|
|
78 |
p {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #000000}
|
|
|
79 |
p.error {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}
|
|
|
80 |
span {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}
|
|
|
81 |
span.blue {font-family: Arial, Helvetica, sans-serif; color: #FFFFFF; background-color:#0000A0; font-size: 10pt}
|
|
|
82 |
span.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt; text-decoration: none}
|
|
|
83 |
td {font-family: Arial, Helvetica, sans-serif; font-size: 10pt}
|
|
|
84 |
td.timeout {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FF0000;}
|
|
|
85 |
td.small {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
|
|
|
86 |
td.headline {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #FFFFFF; font-weight: bold}
|
|
|
87 |
td.haupt {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; font-weight: bold}
|
|
|
88 |
input {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
|
|
|
89 |
select {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}
|
|
|
90 |
textarea {font-family: Arial, Helvetica, sans-serif; font-size: 8pt}a { text-decoration: none}
|
|
|
91 |
</style>
|
|
|
92 |
<script language="JavaScript">
|
|
|
93 |
<!--
|
|
|
94 |
function MM_swapImgRestore() { //v3.0
|
|
|
95 |
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
|
|
|
96 |
}
|
|
|
97 |
|
|
|
98 |
function MM_preloadImages() { //v3.0
|
|
|
99 |
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
|
|
|
100 |
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
|
|
|
101 |
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
|
|
|
102 |
}
|
|
|
103 |
|
|
|
104 |
function MM_swapImage() { //v3.0
|
|
|
105 |
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
|
|
|
106 |
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
|
|
|
107 |
}
|
|
|
108 |
|
|
|
109 |
function MM_findObj(n, d) { //v4.01
|
|
|
110 |
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
|
|
|
111 |
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
|
|
|
112 |
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
|
|
|
113 |
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
|
|
|
114 |
if(!x && d.getElementById) x=d.getElementById(n); return x;
|
|
|
115 |
}
|
|
|
116 |
|
|
|
117 |
function MM_validateForm() { //v4.0
|
|
|
118 |
var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
|
|
|
119 |
for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
|
|
|
120 |
if (val) { nm=val.name; if ((val=val.value)!="") {
|
|
|
121 |
if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
|
|
|
122 |
if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
|
|
|
123 |
} else if (test!='R') {
|
|
|
124 |
if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
|
|
|
125 |
if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
|
|
|
126 |
min=test.substring(8,p); max=test.substring(p+1);
|
|
|
127 |
if (val<min || max<val) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
|
|
|
128 |
} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; }
|
|
|
129 |
} if (errors) alert('The following error(s) occurred:\n'+errors);
|
|
|
130 |
document.MM_returnValue = (errors == '');
|
|
|
131 |
}
|
|
|
132 |
//-->
|
|
|
133 |
</script>
|
|
|
134 |
<script language="JavaScript" src="../checkDate.js"></script>
|
|
|
135 |
</head>
|
|
|
136 |
|
|
|
137 |
<body bgcolor="#<? echo $webs[bgcolor_seite]; ?>" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('../images/redaktion/bt_neu_f2.gif','../images/redaktion/bt_bearbeiten_f2.gif','../images/redaktion/bt_delete_f2.gif','../alt/images/redaktion/bt_ansicht_f2.gif','../images/navigation/bt_neu_f2.gif','../images/navigation/bt_bearbeiten_f2.gif','../images/navigation/bt_delete_f2.gif')" background="../neu/images/webelemente/bg_content.gif" text="#000000" >
|
|
|
138 |
<form method="post" action="#">
|
|
|
139 |
<table width="577" border="0" cellspacing="0" cellpadding="0">
|
|
|
140 |
<tr valign="top">
|
|
|
141 |
|
|
|
142 |
<td width="500"><table width="500" border="1" cellspacing="0" cellpadding="3">
|
|
|
143 |
<tr>
|
|
|
144 |
<td colspan="3" bgcolor="#<? echo $webs[bgcolor_links] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_seite] ?>"><b>
|
|
|
145 |
<? echo $headline ?>
|
|
|
146 |
</b></font></td>
|
|
|
147 |
</tr>
|
|
|
148 |
</table>
|
|
|
149 |
<?
|
|
|
150 |
|
|
|
151 |
if ($action=="delete")
|
|
|
152 |
{
|
|
|
153 |
$result = mysql_query ("SELECT * FROM $tab order by von,Rang") or die (mysql_errno().": ".mysql_error());
|
|
|
154 |
if (mysql_num_rows($result) == 0)
|
|
|
155 |
{
|
|
|
156 |
?>
|
|
|
157 |
<font color="#<? echo $webs[font_color_seite] ?>"><b>Es
|
|
|
158 |
sind keine Daten eingetragen !</b></font>
|
|
|
159 |
<p> <font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
160 |
<?
|
|
|
161 |
}
|
|
|
162 |
while ($zeile=mysql_fetch_array($result))
|
|
|
163 |
{
|
|
|
164 |
$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
|
|
|
165 |
$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
|
|
|
166 |
?>
|
|
|
167 |
</font></p>
|
|
|
168 |
|
|
|
169 |
<table width="500" border="1" cellspacing="0" cellpadding="3">
|
|
|
170 |
<tr>
|
|
|
171 |
<td width="10%" bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><b>Titel:</b></font></td>
|
|
|
172 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="4"><font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
173 |
<? if (!$zeile[Titel] == "") {echo $zeile[Titel];} else {echo " ";} ?>
|
|
|
174 |
</font></td>
|
|
|
175 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" align="center" valign="middle" rowspan="2">
|
|
|
176 |
<font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
177 |
<input type="checkbox" name="ID[]" value="<? echo $zeile[ID] ?>">
|
|
|
178 |
</font></td>
|
|
|
179 |
</tr>
|
|
|
180 |
<tr>
|
|
|
181 |
<td width="10%" bgcolor="#<? echo $webs[bgcolor_links] ?>">
|
|
|
182 |
<div align="left"><font color="#<? echo $webs[font_color_links] ?>"><b>Text:</b></font></div>
|
|
|
183 |
</td>
|
|
|
184 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="4"><font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
185 |
<? if (!$zeile[Text] == "") {echo $zeile[Text];} else {echo " ";} ?>
|
|
|
186 |
</font>
|
|
|
187 |
<div align="center"> </div>
|
|
|
188 |
</td>
|
|
|
189 |
</tr>
|
|
|
190 |
<tr>
|
|
|
191 |
<td width="10%" bgcolor="#<? echo $webs[bgcolor_links] ?>">
|
|
|
192 |
<div align="left"><font color="#<? echo $webs[font_color_links] ?>"><b>von:</b></font></div>
|
|
|
193 |
</td>
|
|
|
194 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="32%"><font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
195 |
<? echo $zeile[von] ?>
|
|
|
196 |
</font></td>
|
|
|
197 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="10%" align="center" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>bis:</b></font></td>
|
|
|
198 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="32%"><font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
199 |
<? echo $zeile[bis] ?>
|
|
|
200 |
</font></td>
|
|
|
201 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="15%"><font color="#<? echo $webs[font_color_links] ?>"><b>Position:</b></font></td>
|
|
|
202 |
<td align="center" valign="middle" width="11%" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
203 |
<? echo $zeile[Rang] ?>
|
|
|
204 |
</font></td>
|
|
|
205 |
</tr>
|
|
|
206 |
</table>
|
|
|
207 |
<font face="Arial, Helvetica, sans-serif" size="2"><br>
|
|
|
208 |
<?
|
|
|
209 |
}
|
|
|
210 |
?> </font>
|
|
|
211 |
<table width="500" border="1" cellspacing="0" cellpadding="3">
|
|
|
212 |
<tr>
|
|
|
213 |
<td colspan="3" bgcolor="#<? echo $webs[bgcolor_links] ?>">
|
|
|
214 |
<div align="right">
|
|
|
215 |
<input type="hidden" name="action" value='delete'>
|
|
|
216 |
<input type="submit" value="OK">
|
|
|
217 |
<input type="reset" name="Button2" value="Zurücksetzen">
|
|
|
218 |
</div>
|
|
|
219 |
</td>
|
|
|
220 |
</tr>
|
|
|
221 |
</table>
|
|
|
222 |
<font color="#<? echo $webs[font_color_seite] ?>"><?
|
|
|
223 |
}
|
|
|
224 |
?> <?
|
|
|
225 |
if ($action=="select_edit")
|
|
|
226 |
{
|
|
|
227 |
$result = mysql_query ("SELECT * FROM $tab order by von,Rang asc") or die (mysql_errno().": ".mysql_error());
|
|
|
228 |
if (mysql_num_rows($result) == 0)
|
|
|
229 |
{
|
|
|
230 |
?> </font>
|
|
|
231 |
<div align="center">
|
|
|
232 |
<p align="left"><font color="#<? echo $webs[font_color_seite] ?>"><b>Es
|
|
|
233 |
sind keine Daten eingetragen !</b></font></p></div>
|
|
|
234 |
<?
|
|
|
235 |
}
|
|
|
236 |
?>
|
|
|
237 |
<table width="500" border="1" cellspacing="0" cellpadding="3">
|
|
|
238 |
<tr>
|
|
|
239 |
<td colspan=5 bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><b>Titel</b></font></td>
|
|
|
240 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>">
|
|
|
241 |
<div align="left"><font color="#<? echo $webs[font_color_links] ?>"><b>von</b></font></div>
|
|
|
242 |
</td>
|
|
|
243 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="10%" align="left" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>bis</b></font></td>
|
|
|
244 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="15%"><font color="#<? echo $webs[font_color_links] ?>"><b>Position</b></font></td>
|
|
|
245 |
</tr>
|
|
|
246 |
<?
|
|
|
247 |
while ($zeile=mysql_fetch_array($result))
|
|
|
248 |
{
|
|
|
249 |
$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
|
|
|
250 |
$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
|
|
|
251 |
?>
|
|
|
252 |
<tr>
|
|
|
253 |
<td colspan="5" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"> <a href="<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>">
|
|
|
254 |
<? echo $zeile[Titel]; ?>
|
|
|
255 |
</font></a> </td>
|
|
|
256 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>">
|
|
|
257 |
<? echo $zeile[von] ?>
|
|
|
258 |
</font></td>
|
|
|
259 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>">
|
|
|
260 |
<? echo $zeile[bis] ?>
|
|
|
261 |
</font></td>
|
|
|
262 |
<td align="center" valign="middle" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><font face="Arial, Helvetica, sans-serif" size="2" color="#<? echo $webs[font_color_rechts] ?>">
|
|
|
263 |
<? echo $zeile[Rang] ?>
|
|
|
264 |
</font></td>
|
|
|
265 |
</tr>
|
|
|
266 |
<font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
267 |
<?
|
|
|
268 |
}
|
|
|
269 |
?> </font>
|
|
|
270 |
</table>
|
|
|
271 |
<div align="right">
|
|
|
272 |
<input type="hidden" name="action" value='edit'>
|
|
|
273 |
|
|
|
274 |
</div>
|
|
|
275 |
<font face="Arial, Helvetica, sans-serif" size="2"><?
|
|
|
276 |
}
|
|
|
277 |
?> <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
|
|
|
278 |
<?
|
|
|
279 |
if ($action=="view")
|
|
|
280 |
{
|
|
|
281 |
$result = mysql_query ("SELECT * FROM $tab") or die (mysql_errno().": ".mysql_error());
|
|
|
282 |
if (mysql_num_rows($result) == 0)
|
|
|
283 |
{
|
|
|
284 |
?> </font>
|
|
|
285 |
<div align="center">
|
|
|
286 |
<p align="left"><font color="#<? echo $webs[font_color_seite] ?>"><b>Es
|
|
|
287 |
sind keine Daten eingetragen !</b></font></p>
|
|
|
288 |
<p>
|
|
|
289 |
</div>
|
|
|
290 |
<font face="Arial, Helvetica, sans-serif" size="2"><?
|
|
|
291 |
}
|
|
|
292 |
else
|
|
|
293 |
{
|
|
|
294 |
//$result = mysql_query ("SELECT * FROM $tab order by von asc") or die (mysql_errno().": ".mysql_error());
|
|
|
295 |
//$zeile=mysql_fetch_array($result);
|
|
|
296 |
$zeile[von]=date("Y-m-d");
|
|
|
297 |
$von_array=preg_split("/-/",$zeile[von]);
|
|
|
298 |
|
|
|
299 |
$result = mysql_query ("SELECT * FROM $tab order by von desc") or die (mysql_errno().": ".mysql_error());
|
|
|
300 |
$zeile=mysql_fetch_array($result);
|
|
|
301 |
$bis_array=preg_split("/-/",$zeile[bis]);
|
|
|
302 |
}
|
|
|
303 |
?> </font>
|
|
|
304 |
<table width="500" border="1" cellspacing="0" cellpadding="3">
|
|
|
305 |
<?
|
|
|
306 |
while (join("",$von_array) <= join("",$bis_array))
|
|
|
307 |
{
|
|
|
308 |
?>
|
|
|
309 |
<tr>
|
|
|
310 |
<td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><a href="../tageskarte.php?Termin=<? echo join("-",$von_array) ?>"><font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
311 |
<? echo join(".",array_reverse($von_array)) ?>
|
|
|
312 |
</font></a></td>
|
|
|
313 |
</tr>
|
|
|
314 |
<?
|
|
|
315 |
$von_array[2]=$von_array[2]+1;
|
|
|
316 |
if ($von_array[2] < 10) {$von_array[2]="0".$von_array[2];}
|
|
|
317 |
|
|
|
318 |
if (checkdate ($von_array[1],$von_array[2],$von_array[0]))
|
|
|
319 |
{
|
|
|
320 |
}
|
|
|
321 |
else
|
|
|
322 |
{
|
|
|
323 |
$von_array[2]="01";
|
|
|
324 |
$von_array[1]=$von_array[1]+1;
|
|
|
325 |
if ($von_array[1] < 10) {$von_array[1]="0".$von_array[1];}
|
|
|
326 |
}
|
|
|
327 |
if (checkdate ($von_array[1],$von_array[2],$von_array[0]))
|
|
|
328 |
{
|
|
|
329 |
}
|
|
|
330 |
else
|
|
|
331 |
{
|
|
|
332 |
$von_array[2]="01";
|
|
|
333 |
$von_array[1]="01";
|
|
|
334 |
$von_array[0]=$von_array[0]+1;
|
|
|
335 |
}
|
|
|
336 |
}
|
|
|
337 |
?>
|
|
|
338 |
</table>
|
|
|
339 |
<font face="Arial, Helvetica, sans-serif" size="2"><?
|
|
|
340 |
}
|
|
|
341 |
?> <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
|
|
|
342 |
<?
|
|
|
343 |
if ($action=="edit")
|
|
|
344 |
{
|
|
|
345 |
if ($ID)
|
|
|
346 |
{
|
|
|
347 |
$result = mysql_query ("SELECT * FROM $tab where ID = $ID order by Rang desc") or die (mysql_errno().": ".mysql_error());
|
|
|
348 |
$zeile=mysql_fetch_array($result);
|
|
|
349 |
$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
|
|
|
350 |
$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
|
|
|
351 |
}
|
|
|
352 |
?> </font>
|
|
|
353 |
<table width="500" border="1" cellspacing="0" cellpadding="3">
|
|
|
354 |
<tr>
|
|
|
355 |
<td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Titel:</b></font></td>
|
|
|
356 |
<td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
357 |
<input type="text" name="Titel" size="45" value="<? echo $zeile[Titel]?>">
|
|
|
358 |
</font></td>
|
|
|
359 |
</tr>
|
|
|
360 |
<tr>
|
|
|
361 |
<td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="top"><font color="#<? echo $webs[font_color_links] ?>"><b>Text:</b></font></td>
|
|
|
362 |
<td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"> <font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
363 |
<textarea name="Text" cols="39" rows="5"><? echo $zeile[Text]?></textarea>
|
|
|
364 |
</font></td>
|
|
|
365 |
</tr>
|
|
|
366 |
<tr>
|
|
|
367 |
<td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Position:</b></font></td>
|
|
|
368 |
<td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
369 |
<select name="Rang">
|
|
|
370 |
<option value="0" <? if ($zeile[Rang] == 0) {echo "selected";} ?>>Tagessuppe</option>
|
|
|
371 |
<option value="100" <? if ($zeile[Rang] == 100) {echo "selected";} ?>>Tagesempfehlung</option>
|
|
|
372 |
<option value="1" <? if ($zeile[Rang] == 1) {echo "selected";} ?>>1</option>
|
|
|
373 |
<option value="2" <? if ($zeile[Rang] == 2) {echo "selected";} ?>>2</option>
|
|
|
374 |
<option value="3" <? if ($zeile[Rang] == 3) {echo "selected";} ?>>3</option>
|
|
|
375 |
<option value="4" <? if ($zeile[Rang] == 4) {echo "selected";} ?>>4</option>
|
|
|
376 |
<option value="5" <? if ($zeile[Rang] == 5) {echo "selected";} ?>>5</option>
|
|
|
377 |
<option value="6" <? if ($zeile[Rang] == 6) {echo "selected";} ?>>6</option>
|
|
|
378 |
<option value="7" <? if ($zeile[Rang] == 7) {echo "selected";} ?>>7</option>
|
|
|
379 |
<option value="8" <? if ($zeile[Rang] == 8) {echo "selected";} ?>>8</option>
|
|
|
380 |
<option value="9" <? if ($zeile[Rang] == 9) {echo "selected";} ?>>9</option>
|
|
|
381 |
<option value="10" <? if ($zeile[Rang] == 10) {echo "selected";} ?>>10</option>
|
|
|
382 |
<option value="11" <? if ($zeile[Rang] == 11) {echo "selected";} ?>>11</option>
|
|
|
383 |
<option value="12" <? if ($zeile[Rang] == 12) {echo "selected";} ?>>12</option>
|
|
|
384 |
<option value="150" <? if ($zeile[Rang] == 150) {echo "selected";} ?>>Aktion1</option>
|
|
|
385 |
<option value="151" <? if ($zeile[Rang] == 151) {echo "selected";} ?>>Aktion2</option>
|
|
|
386 |
<option value="152" <? if ($zeile[Rang] == 152) {echo "selected";} ?>>Aktion3</option>
|
|
|
387 |
<option value="153" <? if ($zeile[Rang] == 153) {echo "selected";} ?>>Aktion4</option>
|
|
|
388 |
<option value="154" <? if ($zeile[Rang] == 154) {echo "selected";} ?>>Aktion5</option>
|
|
|
389 |
<option value="155" <? if ($zeile[Rang] == 155) {echo "selected";} ?>>Aktion6</option>
|
|
|
390 |
<option value="156" <? if ($zeile[Rang] == 156) {echo "selected";} ?>>Aktion7</option>
|
|
|
391 |
<option value="157" <? if ($zeile[Rang] == 157) {echo "selected";} ?>>Aktion8</option>
|
|
|
392 |
<option value="158" <? if ($zeile[Rang] == 158) {echo "selected";} ?>>Aktion9</option>
|
|
|
393 |
<option value="159" <? if ($zeile[Rang] == 159) {echo "selected";} ?>>Aktion10</option>
|
|
|
394 |
<option value="300" <? if ($zeile[Rang] == 300) {echo "selected";} ?>>Events</option>
|
|
|
395 |
</select>
|
|
|
396 |
</font></td>
|
|
|
397 |
</tr>
|
|
|
398 |
<tr>
|
|
|
399 |
<td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Preis:</b></font></td>
|
|
|
400 |
<td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font color="#<? echo $webs[font_color_rechts] ?>">
|
|
|
401 |
<input type="text" name="Preis" size="8" value="<? echo $zeile[Preis]?>">
|
|
|
402 |
<b>€</b></font> </td>
|
|
|
403 |
</tr>
|
|
|
404 |
<tr>
|
|
|
405 |
<td width="15%" bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle"><font color="#<? echo $webs[font_color_links] ?>"><b>Gültigkeit:
|
|
|
406 |
</b></font></td>
|
|
|
407 |
<td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="middle"> <font color="#<? echo $webs[font_color_rechts] ?>"><b>von:
|
|
|
408 |
<input type="text" name="von" size="10" maxlength="12" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)" value="<? echo $zeile[von]?>">
|
|
|
409 |
bis: <input type="text" name="bis" size="10" maxlength="12" onFocus="current_value=this.value;if (this.value=='') {this.value=today()};this.select();" onChange="this.value=check_Date(this.value)" value="<? echo $zeile[bis]?>">
|
|
|
410 |
</b></font></td>
|
|
|
411 |
</tr>
|
|
|
412 |
<tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
|
|
|
413 |
<td colspan="3">
|
|
|
414 |
<div align="right"><font color="#FFFFFF" face="Arial, Helvetica, sans-serif" size="2">
|
|
|
415 |
<input type="hidden" name="ID" value="<? echo $ID ?>">
|
|
|
416 |
<input type="hidden" name="action" value="update">
|
|
|
417 |
</font> <font face="Arial, Helvetica, sans-serif" size="2">
|
|
|
418 |
<input type="submit" value="OK" onClick="MM_validateForm('Titel','','R');return document.MM_returnValue">
|
|
|
419 |
<input type="reset" name="Button" value="Zurücksetzen">
|
|
|
420 |
</font></div>
|
|
|
421 |
</td>
|
|
|
422 |
</tr>
|
|
|
423 |
</table>
|
|
|
424 |
<font face="Arial, Helvetica, sans-serif" size="2"><?
|
|
|
425 |
}
|
|
|
426 |
?> </font>
|
|
|
427 |
<p></p>
|
|
|
428 |
|
|
|
429 |
<td width="77" align="right">
|
|
|
430 |
<table width="67" border="1" cellspacing="0" cellpadding="0">
|
|
|
431 |
<tr>
|
|
|
432 |
<td><a href="<? echo $self ?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('new','','../images/navigation/bt_neu_f2.gif',1)"><img name="new" border="0" src="../images/navigation/bt_neu.gif" width="67" height="40" alt="Neueintrag"></a></td>
|
|
|
433 |
</tr>
|
|
|
434 |
<tr>
|
|
|
435 |
<td><a href="<? echo $self ?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td>
|
|
|
436 |
</tr>
|
|
|
437 |
<tr>
|
|
|
438 |
<td><a href="<? echo $self ?>?action=delete" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('delete','','../images/navigation/bt_delete_f2.gif',1)"><img name="delete" border="0" src="../images/navigation/bt_delete.gif" width="67" height="40" alt="Eintrag löschen"></a></td>
|
|
|
439 |
</tr>
|
|
|
440 |
<? // <tr>
|
|
|
441 |
// <td><a href="Speisekarte.php?action=view" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('view','','../images/redaktion/bt_ansicht_f2.gif',1)"><img name="view" border="0" src="../images/redaktion/bt_ansicht.gif" width="67" height="40"></a></td>
|
|
|
442 |
// </tr>
|
|
|
443 |
?>
|
|
|
444 |
</table>
|
|
|
445 |
</td>
|
|
|
446 |
</tr>
|
|
|
447 |
</table>
|
|
|
448 |
</form>
|
|
|
449 |
</body>
|
|
|
450 |
</html>
|