Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed 

<?
    $self = basename( $PHP_SELF );
    $DB = "Feature_options";
    require_once "connect2.php";

    // soll die erweiterte OptionenAnsicht angezeigt werden? Vom Datentyp abhängig (varchar)
    $showMoreOptions = 0;
    $sql = "SHOW
                                fields
                        FROM
                                Feature_options
                        WHERE Field = 'bit'
                        ";
    $res = mysql_query( $sql );
    if ( $row = mysql_fetch_assoc( $res ) )
    {
        if ( stristr( $row['Type'], "bigint" ) )
        {
            $showMoreOptions = 1;
        }
    }
    $optionsCount = 31;
    if ( $showMoreOptions == 1 )
    {
        $optionsCount = 63;
    }

    if ( $action == "update" )
    {
        $query = "delete from $DB where Feature = $ID";
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query . "<hr>" );

        for ( $i = 0; $i <= $optionsCount; $i++ )
        {
            if ( $value[$i] )
            {
                $query = "insert into $DB (Feature,Value,bit) VALUES ($ID,'$value[$i]',$i)";

                $result = mysql_query( $query ) or die( mysql_errno() . ": " .
                    mysql_error() . "<hr>" . $query . "<hr>" );
            }
        }
        header( "Location: Features.php?action=edit&ID=$ID" );
    }
    if ( !$action )
    {
        $action = "edit";
    }
?>
<html>
<head>
<title>Redaktionssystem</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel=stylesheet type="text/css" href="redaktion.css">
<style type="text/css">
<? require_once "../styles/styles.php"
?>;
</style>
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
//-->
</script>
<meta name="description" content="Redaktionssystem">
<meta name="author" content="Webagentur Niewerth">
<meta name="robots" content="noindex">
</head>

<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_delete_f2.gif','../images/redaktion/bt_update_f2.gif')" text="#000096">
<form method="post" action="#" name="formname" enctype="multipart/form-data">
  <table width="662" border="0" cellspacing="0" cellpadding="0">
    <tr valign="top"> 
      <td width="585"> 
<?
    if ( $action == "edit" )
    {
        if ( $ID )
        {
            $result = mysql_query( "SELECT * FROM $DB where Feature = $ID order by bit" ) or
                die( mysql_errno() . ": " . mysql_error() );
            $value = array();
            while ( $zeile = mysql_fetch_array( $result ) )
            {
                $value[$zeile[bit]] = $zeile[Value];
            }
        }
?>
        <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td colspan="3"><font color="#<? echo $webs[font_color_links]
?>"><b>Werte: 
              Bearbeiten</b></font></td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" width="13%"><font color="#<? echo
$webs[font_color_links]
?>"><b>Option:</b></font></td>
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <?
        $result2 = mysql_query( "SELECT * FROM Features where ID = '$ID'" ) or
            die( mysql_errno() . ": " . mysql_error() );
        $zeile2 = mysql_fetch_array( $result2 );
        echo $zeile2[Name];
?>
            </td>
          </tr>
          <tr> 
            <td bgcolor="#<? echo $webs[bgcolor_links]
?>" valign="top" width="13%"><font color="#<? echo
$webs[font_color_links]
?>"><b>Werte:</b></font></td>
            <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts]
?>"> 
              <table border="0" cellspacing="0" cellpadding="0">
<?php
        for ( $i = 0; $i <= 15; $i++ )
        {
?>
                <tr> 

                  <td align="right"> 
                    <? echo $i
?>
                    &nbsp; </td>
                  <td> 
                    <input type="text" name="value[<? echo $i
?>]" tabindex="<? echo
$i + 50
?>" value="<? echo
$value[$i]
?>">
                  </td>

                  <td>
                                        &nbsp;&nbsp;&nbsp;&nbsp;
                                  </td>

                  <td> 
                    <? echo $i + 16
?>
                    &nbsp; </td>
                  <td> 
                    <input type="text" name="value[<? echo $i + 16
?>]" tabindex="<? echo
$i + 16 + 50
?>" value="<? echo
$value[$i + 16]
?>">
                  </td>

<?php
            if ( $showMoreOptions == 1 )
            {
?>
                  <td>
                                        &nbsp;&nbsp;&nbsp;&nbsp;
                                  </td>

                  <td> 
                    <? echo $i + 32
?>
                    &nbsp; </td>
                  <td> 
                    <input type="text" name="value[<? echo $i + 32
?>]" tabindex="<? echo
$i + 32 + 50
?>" value="<? echo
$value[$i + 32]
?>">
                  </td>


                  <td>
                                        &nbsp;&nbsp;&nbsp;&nbsp;
                                  </td>

                  <td> 
                    <? echo $i + 48
?>
                    &nbsp; </td>
                  <td> 
                    <input type="text" name="value[<? echo $i + 48
?>]" tabindex="<? echo
$i + 48 + 50
?>" value="<? echo
$value[$i + 48]
?>">
                  </td>

<?php

            }
?>

                </tr>
                <? }
?>
              </table>
            </td>
          </tr>
          <tr bgcolor="#<? echo $webs[bgcolor_links]
?>"> 
            <td align="right" colspan="3"> 
              <input type="hidden" name="ID" value="<? echo $ID
?>">
              <input type="hidden" name="action" value="update">
              <input type="submit" value="OK" tabindex="100">
              <input type="reset" name="Button" value="Zur&uuml;cksetzen" tabindex="100">
            </td>
          </tr>
        </table>
        <?
    }
?> </td>
     </tr>
</table>
</form>
</body>
</html>