Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed 

<?
    require_once "connect2.php";
    session_start();
    if ( !$language )
    {
        $language = "DE";
    }

    // SEBASTIAN
    // verwendungsfilter
    if ( isset( $_GET[modul] ) )
    {
        $_SESSION[$self][verwendung] = "$_GET[modul]";
    }
    // prüfen, ob die spalte verwendung existiert
    if ( !isset( $_SESSION[$self][spalte_verwendung_existiert] ) )
    {
        $query = "show columns from Features like 'verwendung'";
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query . "<hr>" );
        $_SESSION[$self][spalte_verwendung_existiert] = ( mysql_num_rows( $result ) >
            0 );
    }


    if ( $delete )
    {
        $query = "delete from Feature_to_Ware where ID = $LinkID";
        // SEBASTIAN
        if ( $_SESSION[$self][verwendung] == "Branchenbuch" )
        {
            $query = "delete from Feature_to_Firma where ID = $LinkID";
        }
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query2 );
?>
        <script language=javascript>
                parent.Features.location.href='Features_blank.php';
        </script>
<?
    }
    if ( $insert )
    {
        $query = "insert into Feature_to_Ware (Ware,Feature) Values ($ID,$Feature)";
        // SEBASTIAN
        if ( $_SESSION[$self][verwendung] == "Branchenbuch" )
        {
            $query = "insert into Feature_to_Firma (Firma,Feature) Values ($ID,$Feature)";
        }
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query );
?>
        <script language=javascript>
                parent.Features.location.href='Feature_control.php?
                <? if ( isset( $_SESSION[$self][verwendung] ) )
        {
            echo "modul=" . $_SESSION[$self][verwendung] . "&";
        }
?>
                ID=<? echo $ID
?>&Feature=<? echo $Feature
?>&bit=';
        </script>
<?

    }
?>
<html>
<head>
<title>Pl&uuml;macher: Redaktionssystem</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="author" content="Webagentur Niewerth - www.weban.de">
<meta name="revisit-after" content="30 days">
<meta name="language" content="deutsch, de">
<meta name="distribution" content="global">
<meta name="robots" content="all">
<link rel=stylesheet type="text/css" href="redaktion.css">
</head>

<body bgcolor="#<? echo $webs[bgcolor_rechts]
?>" text="#<? echo $webs[font_color_rechts]
?>" leftmargin="0" topmargin="0" link="#0000FF" vlink="#0000FF" alink="#0000FF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<?
    $query = "SELECT * FROM Features where Language = '$language'";
    // SEBASTIAN
    if ( $_SESSION[$self][spalte_verwendung_existiert] )
    {
        $query .= " and verwendung = '" . $_SESSION[$self][verwendung] . "'";
    }
    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
        mysql_error() . "<hr>" . $query );
    while ( $zeile = mysql_fetch_array( $result ) )
    {
        unset( $zeile2 );
        $query2 = "SELECT * FROM Feature_to_Ware where Ware=$ID and Feature=$zeile[ID]";
        // SEBASTIAN
        if ( $_SESSION[$self][verwendung] == "Branchenbuch" )
        {
            $query2 = "SELECT * FROM Feature_to_Firma where Firma=$ID and Feature=$zeile[ID]";
        }
        $result2 = mysql_query( $query2 ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . $query2 );
        $zeile2 = mysql_fetch_array( $result2 );
?>
  <tr>
    <td align="center" valign="middle"> 
     <a name="Option_<?php echo $zeile[ID]
?>">
     <input type="checkbox" onClick="this.blur();this.focus();" onChange="location.href='<? echo
$self
?>?<? if ( isset
( $_SESSION[$self][verwendung] ) )
        {
            echo "modul=" . $_SESSION[$self][verwendung] . "&";
        }
?>ID=<? echo
$ID
?>&Feature=<? echo
$zeile[ID]
?>&<? if ( $zeile2 )
        {
            echo "delete=true";
        }
        else
        {
            echo "insert=true";
        }
?>&LinkID=<? echo
$zeile2[ID]
?>#Option_<? echo
$zeile[ID]
?>'" <? if ( mysql_num_rows
( $result2 ) > 0 )
        {
            echo " checked";
        }
?>>
    </td>
    <td width="100%"> 
      <a href="Feature_control.php?<? if ( isset( $_SESSION[$self][verwendung] ) )
        {
            echo "modul=" . $_SESSION[$self][verwendung] . "&";
        }
?>ID=<? echo
$ID
?>&Feature=<? echo
$zeile[ID]
?>&bit=<? echo
$zeile2[Feature_options]
?>" target="Features"><? echo
$zeile[Name]
?></a>
    </td>
  </tr>
<?
    }
?>
</table>
<br>
<a href="options_copy.php?ID=<? echo $_GET['ID']
?>" target="Features">Optionen Kopieren</a>&nbsp;<a href="#" onClick="javascript:window.open('options_copy.php?ID=<? echo
$_GET['ID']
?>', 'FeatureCopy', 'width=300,height=200,scrollbars=yes'); return false;">nach</a>...
</body>
</html>