Subversion-Projekte lars-tiefland.content-management

<!--  Auswahl SELECT_EDIT START  -->
<?
    $cond = array( "where 1" );
    if ( $_GET["firma"] )
    {
        $cond[] = " firma=" . ( int )$_GET["firma"];
    }
    if ( isset($user_rechte[modul_name][tool_name]["language"]) )
    {
        $cond[] = "language='DE'";
    }

    if ( is_array($_SESSION[$self]["filter"]) )
    {
        foreach ( $_SESSION[$self]["filter"] as $key => $value )
        {
            if ( $value )
            {
                if ( is_numeric($key) )
                {
                    $cond[] = $value;
                }
                else
                {
                    $cond[] = "$key = '$value'";
                }
            }
        }
    }
    else
    {
        $cond = array();
    }

    $query = "
                        SELECT 
                                $tab.*,
                                DATE_FORMAT(gueltig_von,'%d.%m.%Y') as von,
                                DATE_FORMAT(gueltig_bis,'%d.%m.%Y') as bis
                        FROM
                                $tab
                        " . implode( " and ", $cond ) . "
                        ORDER BY
                                $sort
                        ";
    if ( !$result = mysql_query($query) )
    {
        unset( $_SESSION[$self]["filter"] );
        die( mysql_errno() . ": " . mysql_error() . pre($query, true) );
    }
    $count = mysql_num_rows( $result );

    if ( !$start )
    {
        $start = 0;
    }
    $query = $query . " limit $start, $range";
?>
<table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
  <tr bgcolor="#<? echo $webs[bgcolor_links] ?>">
    <td class="headline" colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>">
                <span style="float:right"><?= $count; ?></span>
                <font color="#<? echo $webs[font_color_links] ?>">News: Bearbeiten</font>
        </td>
  </tr>
  <tr>
        <td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
                <? require_once  "includes/filter.php"; ?>
        </td> 
  </tr>
<?
    if ( $count == 0 )
    {
?><tr><td colspan="2">Es sind keine Daten eingetragen !</td></tr><?
    }

    if ( $count >= $range )
    {
?><tr><td colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>"><? require_once  "includes/blaettern.php"; ?></td></tr><?
    }


    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
        mysql_error() . "<hr>$query" );
    while ( $zeile = mysql_fetch_array($result) )
    {
        // Versuchen den Artikel in language nachzuladen
        $query_lang = "select * from $tab where language='$_SESSION[language]' and ID = $zeile[ID]";
        if ( $result_lang = mysql_query($query_lang) )
        {
            if ( $zeile_lang = mysql_fetch_array($result_lang) )
            {
                $zeile = $zeile_lang;
            }
        }

?>
        <tr>
                <td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="100%">
<?
        if ( ($_SESSION[language] != $zeile[language]) && (isset($user_rechte[modul_name][tool_name]["language"])) )
        { ?><img src="../images/Online-Shop/directory/file!.gif"><? }


?><a href="<? echo $self ?>?action=edit&ID=<? echo $zeile[ID]; ?>"><?

        $format_string = "ueberschrift;";
        if ( $web_rechte[modul_name][tool_name][edit_string] )
        {
            $format_string = $web_rechte[modul_name][tool_name][edit_string];
        }

        $elements = explode( ";", $format_string );

        foreach ( $elements as $elem )
        {
            if ( array_key_exists($elem, $zeile) )
            {
                if ( $zeile[$elem] )
                {
                    echo $zeile[$elem];
                }
                else
                {
                    echo "[no Name]";
                }
            }
            else
            {
                echo $elem;
            }

            if ( $elem != end($elements) )
            {
                echo "&nbsp;|&nbsp;";
            }
        }
?></a><?

?>
  </td>
                <? if ( isset($user_rechte[modul_name][tool_name][kategorie]) )
        { ?>
                        <td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" nowrap>
                                <font color="<? echo $webs[font_color_rechts] ?>"><? echo $zeile[kategorie] ?></font>
                        </td>
                <? } ?>
  </tr>
  <?
    } // while

?>
<tr>
        <td align="right" colspan="2" bgcolor="#<? echo $webs[bgcolor_links] ?>">
                <? if ( $count >= $range )
    {
        require_once  "includes/blaettern.php";
    } ?>
                <input type="submit" value="   OK   ">
                <input type="reset" name="Button" value="Abbrechen">
        </td>
</tr>
</table>
<!--  Auswahl SELECT_EDIT ENDE  -->