Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
    $self = basename( $PHP_SELF );
3 
    $DB = "Feature_options";
4 
    require_once "connect2.php";
5 
 
6 
    // soll die erweiterte OptionenAnsicht angezeigt werden? Vom Datentyp abhängig (varchar)
7 
    $showMoreOptions = 0;
8 
    $sql = "SHOW
9 
				fields
10 
			FROM
11 
				Feature_options
12 
			WHERE Field = 'bit'
13 
			";
14 
    $res = mysql_query( $sql );
15 
    if ( $row = mysql_fetch_assoc( $res ) )
16 
    {
17 
        if ( stristr( $row['Type'], "bigint" ) )
18 
        {
19 
            $showMoreOptions = 1;
20 
        }
21 
    }
22 
    $optionsCount = 31;
23 
    if ( $showMoreOptions == 1 )
24 
    {
25 
        $optionsCount = 63;
26 
    }
27 
 
28 
    if ( $action == "update" )
29 
    {
30 
        $query = "delete from $DB where Feature = $ID";
31 
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
32 
            mysql_error() . "<hr>" . $query . "<hr>" );
33 
 
34 
        for ( $i = 0; $i <= $optionsCount; $i++ )
35 
        {
36 
            if ( $value[$i] )
37 
            {
38 
                $query = "insert into $DB (Feature,Value,bit) VALUES ($ID,'$value[$i]',$i)";
39 
 
40 
                $result = mysql_query( $query ) or die( mysql_errno() . ": " .
41 
                    mysql_error() . "<hr>" . $query . "<hr>" );
42 
            }
43 
        }
44 
        header( "Location: Features.php?action=edit&ID=$ID" );
45 
    }
46 
    if ( !$action )
47 
    {
48 
        $action = "edit";
49 
    }
50 
?>
51 
<html>
52 
<head>
53 
<title>Redaktionssystem</title>
54 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
55 
<link rel=stylesheet type="text/css" href="redaktion.css">
56 
<style type="text/css">
57 
<? require_once "../styles/styles.php"
58 
?>;
59 
</style>
60 
<script language="JavaScript">
61 
<!--
62 
function MM_swapImgRestore() { //v3.0
63 
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
64 
}
65 
 
66 
function MM_preloadImages() { //v3.0
67 
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
68 
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
69 
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
70 
}
71 
 
72 
function MM_swapImage() { //v3.0
73 
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
74 
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
75 
}
76 
 
77 
function MM_findObj(n, d) { //v4.01
78 
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
79 
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
80 
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
81 
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
82 
  if(!x && d.getElementById) x=d.getElementById(n); return x;
83 
}
84 
//-->
85 
</script>
86 
<meta name="description" content="Redaktionssystem">
87 
<meta name="author" content="Webagentur Niewerth">
88 
<meta name="robots" content="noindex">
89 
</head>
90 
 
91 
<body bgcolor="#<? echo $webs[bgcolor_seite];
92 
?>" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('../images/redaktion/bt_neu_f2.gif','../images/redaktion/bt_delete_f2.gif','../images/redaktion/bt_update_f2.gif')" text="#000096">
93 
<form method="post" action="#" name="formname" enctype="multipart/form-data">
94 
  <table width="662" border="0" cellspacing="0" cellpadding="0">
95 
    <tr valign="top">
96 
      <td width="585">
97 
<?
98 
    if ( $action == "edit" )
99 
    {
100 
        if ( $ID )
101 
        {
102 
            $result = mysql_query( "SELECT * FROM $DB where Feature = $ID order by bit" ) or
103 
                die( mysql_errno() . ": " . mysql_error() );
104 
            $value = array();
105 
            while ( $zeile = mysql_fetch_array( $result ) )
106 
            {
107 
                $value[$zeile[bit]] = $zeile[Value];
108 
            }
109 
        }
110 
?>
111 
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
112 
          <tr bgcolor="#<? echo $webs[bgcolor_links]
113 
?>">
114 
            <td colspan="3"><font color="#<? echo $webs[font_color_links]
115 
?>"><b>Werte:
116 
              Bearbeiten</b></font></td>
117 
          </tr>
118 
          <tr>
119 
            <td bgcolor="#<? echo $webs[bgcolor_links]
120 
?>" width="13%"><font color="#<? echo
121 
$webs[font_color_links]
122 
?>"><b>Option:</b></font></td>
123 
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
124 
?>">
125 
              <?
126 
        $result2 = mysql_query( "SELECT * FROM Features where ID = '$ID'" ) or
127 
            die( mysql_errno() . ": " . mysql_error() );
128 
        $zeile2 = mysql_fetch_array( $result2 );
129 
        echo $zeile2[Name];
130 
?>
131 
            </td>
132 
          </tr>
133 
          <tr>
134 
            <td bgcolor="#<? echo $webs[bgcolor_links]
135 
?>" valign="top" width="13%"><font color="#<? echo
136 
$webs[font_color_links]
137 
?>"><b>Werte:</b></font></td>
138 
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
139 
?>">
140 
              <table border="0" cellspacing="0" cellpadding="0">
141 
<?php
142 
        for ( $i = 0; $i <= 15; $i++ )
143 
        {
144 
?>
145 
                <tr>
146 
 
147 
                  <td align="right">
148 
                    <? echo $i
149 
?>
150 
                    &nbsp; </td>
151 
                  <td>
152 
                    <input type="text" name="value[<? echo $i
153 
?>]" tabindex="<? echo
154 
$i + 50
155 
?>" value="<? echo
156 
$value[$i]
157 
?>">
158 
                  </td>
159 
 
160 
                  <td>
161 
					&nbsp;&nbsp;&nbsp;&nbsp;
162 
				  </td>
163 
 
164 
                  <td>
165 
                    <? echo $i + 16
166 
?>
167 
                    &nbsp; </td>
168 
                  <td>
169 
                    <input type="text" name="value[<? echo $i + 16
170 
?>]" tabindex="<? echo
171 
$i + 16 + 50
172 
?>" value="<? echo
173 
$value[$i + 16]
174 
?>">
175 
                  </td>
176 
 
177 
<?php
178 
            if ( $showMoreOptions == 1 )
179 
            {
180 
?>
181 
                  <td>
182 
					&nbsp;&nbsp;&nbsp;&nbsp;
183 
				  </td>
184 
 
185 
                  <td>
186 
                    <? echo $i + 32
187 
?>
188 
                    &nbsp; </td>
189 
                  <td>
190 
                    <input type="text" name="value[<? echo $i + 32
191 
?>]" tabindex="<? echo
192 
$i + 32 + 50
193 
?>" value="<? echo
194 
$value[$i + 32]
195 
?>">
196 
                  </td>
197 
 
198 
 
199 
                  <td>
200 
					&nbsp;&nbsp;&nbsp;&nbsp;
201 
				  </td>
202 
 
203 
                  <td>
204 
                    <? echo $i + 48
205 
?>
206 
                    &nbsp; </td>
207 
                  <td>
208 
                    <input type="text" name="value[<? echo $i + 48
209 
?>]" tabindex="<? echo
210 
$i + 48 + 50
211 
?>" value="<? echo
212 
$value[$i + 48]
213 
?>">
214 
                  </td>
215 
 
216 
<?php
217 
 
218 
            }
219 
?>
220 
 
221 
                </tr>
222 
                <? }
223 
?>
224 
              </table>
225 
            </td>
226 
          </tr>
227 
          <tr bgcolor="#<? echo $webs[bgcolor_links]
228 
?>">
229 
            <td align="right" colspan="3">
230 
              <input type="hidden" name="ID" value="<? echo $ID
231 
?>">
232 
              <input type="hidden" name="action" value="update">
233 
              <input type="submit" value="OK" tabindex="100">
234 
              <input type="reset" name="Button" value="Zur&uuml;cksetzen" tabindex="100">
235 
            </td>
236 
          </tr>
237 
        </table>
238 
        <?
239 
    }
240 
?> </td>
241 
     </tr>
242 
</table>
243 
</form>
244 
</body>
245 
</html>