Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed

<!--  Auswahl Löschen START  -->
<?
                $cond=array("where 1");
                if (isset($user_rechte[modul_name][tool_name]["language"]))
                {
                        $cond[]="language='DE'";
                }

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

                $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="3" 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="3" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">
                <? require_once "includes/filter.php"; ?>
        </td> 
  </tr>
<?
        if ($count == 0)
        {
                ?><tr><td colspan="3">Es sind keine Daten eingetragen !</td></tr><?
        }

        if ($count >= $range)
        {
                ?><tr><td colspan="3" 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][delete_string]) 
        {
                $format_string = $web_rechte[modul_name][tool_name][delete_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>
                <? } ?>
        <td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="checkbox" name="ID[]" value="<?  echo $zeile[ID] ?>"></td>
  </tr>
  <?
        } // while
?>
      <tr>
        <td colspan="3" align="right" bgcolor="#<? echo $webs[bgcolor_links] ?>">
                        <? if ($count >= $range) { require_once "includes/blaettern.php"; } ?>
          <input type="hidden" name="action" value='delete'>
          <input type="submit" value="LÖSCHEN">
          <input type="reset" value="Zur&uuml;cksetzen">
        </td>
      </tr>
    </table>
<!--  Auswahl Löschen ENDE  -->