Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed 

<?
        require_once "connect.php";
        $DB="Head";
        if (!$rechte[$Rubrik[content_management]] & $Buttons[Frameset]) 
        {
                header("Location: www.".$site);  
                exit;
        }
        if ($action=="update")
        {
                if (!$ID)
                {       // insert Dummy-Entry
                        $query = "insert into $DB (erstellt_am,erstellt_von,letzte_Aenderung_am,letzte_Aenderung_von) VALUES (NOW(),'$PHP_AUTH_USER',NOW(),'$PHP_AUTH_USER')";
                        $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");
                        $ID=mysql_insert_id();
                }

                unset($HTTP_POST_VARS[action]);
                unset($HTTP_POST_VARS[ID]);

                foreach(array_keys($HTTP_POST_VARS) as $elem)
                {
                        if ($elem[0] == "_")
                        {
                                unset($HTTP_POST_VARS[$elem]);
                                $button=$$elem;
                                $elem=substr($elem,1);
                                $Pfad=$HTTP_POST_VARS[$elem."_Pfad"];
                                unset($HTTP_POST_VARS[$elem."_Pfad"]);
                                $image=$$elem;
                                $image_name=$elem."_name";
                                $image_name=urlencode($$image_name);
                                switch ($button) 
                                {
                                        case 0:
                                                $$elem=$button;
                                                break;
                                        case 1:
                                                $HTTP_POST_VARS[$elem]='';
                                                $$elem=$button;
                                                break;
                                        case 2:
                                                //$image_name=$ID."_".$image_name;              // dateiname = ID_Dateiname
                                                //$image_name=$ID.strrchr($image_name,".");     // dateiname = ID.Endung
                                                if ($image_name == 'none')
                                                {
                                                        unset($HTTP_POST_VARS[$elem]);
                                                }
                                                else
                                                {
                                                        $HTTP_POST_VARS[$elem]=$image_name;
                                                        copy($image,$Pfad.$image_name);
                                                        $$elem=$image_name;
                                                }
                                        break;
                                    default:
                                                $$elem=$button;
                                        break;
                            }
                        }
                }
                $names=array();
                foreach(array_keys($HTTP_POST_VARS) as $elem)
                {
                        array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");
                }
                $query="update $DB set ".join($names,', ');
                $query=$query.", letzte_Aenderung_am=NOW(), letzte_Aenderung_von='$PHP_AUTH_USER' where ID = '$ID'";
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
// ****************************************************************************************************************** //
// **   Dateien erstellen START                                                                                                                                                                    ** //
// ****************************************************************************************************************** //
                $filename="vorlagen/index.htm";
                require_once "capture_file.php";
                $fp = fopen ("../$site/index.htm","w");
                fwrite ($fp, $source);
                fclose($fp);
                
                
                switch ($Banner1)
                {
                        case 1:
                                        $Banner1="&nbsp;";
                                        break;
                        default:
                                        $Banner1="<img src=\"images/$Banner1\">";
                                        break;
                }

                switch ($Banner2)
                {
                        case 1:
                                        $Banner2="&nbsp;";
                                        break;
                        default:
                                        $Banner2="<img src=\"images/$Banner2\">";
                                        break;
                }

                switch ($background)
                {
                        case 0:
                                        $background="background=\"images/".$background."\"";
                                        break;
                        case 1:
                                        unset($background);
                                        break;
                        case 2:
                                        $background="background=\"images/".$background."\"";
                                        break;
                }

        
                $filename="vorlagen/head.htm";
                require_once "capture_file.php";
                $fp = fopen ("../$site/head.htm","w");
                fwrite ($fp, $source);
                fclose($fp);

// ****************************************************************************************************************** //
// **   Dateien erstellen STOP                                                                                                                                                                     ** //
// ****************************************************************************************************************** //
                header("Location: ".$self);  
        }

        if ($action=="delete")
        {
                if ($ID)
                {
                        $condition=array();
                        foreach ($ID as $elem) 
                        {
                                array_push($condition," ID = '$elem'");
                        }
                        $cond=join(" or ",$condition);
                        $query = "DELETE FROM $DB WHERE $cond";
                        $result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());
                        header("Location: ".$self);  
                }
        }
        if (!$action) 
        {
                $action="edit";
        }
        if (!$sort) {$sort='Name';}
?>

<html>
<head>
<title>Content-Management-System - Webagentur Niewerth</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!--

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<script language="javascript" src="Farb_Assistent.js"></script>
<meta name="author" content="Webagentur Niewerth - www.weban.de">
<meta name="description" content="Redaktionssystem">
<meta name="robots" content="noindex">
<link rel="stylesheet" href="redaktion.css" type="text/css">
<style type="text/css"><? require_once "redaktion.css" ?></style>
</head>

<body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" >
<form method="post" action="<? echo $self ?>" name="formname" enctype="multipart/form-data">
  <table width="740" border="0" cellspacing="0" cellpadding="0">
    <tr valign="top"> 
    
      <td> 
        <?  if ($action=="delete") 
        {
        $result = mysql_query ("SELECT * FROM Objekte,$DB where $DB.Objekt=Objekte.Kennung order by $DB.von,$DB.bis") or die (mysql_errno().": ".mysql_error());
        if (mysql_num_rows($result) == 0)
        {
        ?>
        <p class="error">Es sind keine Daten eingetragen !</p>
<p></p>
        
        <?
        }
        else
        {
        ?>
            <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr bgcolor="#000096"> 
            <td colspan="3" class="headline">Seite: L&ouml;schen</td>
          </tr>
          <tr>
            <td width="6%" bgcolor="#000096">&nbsp;</td>
            <td width="88%" ><a href="<? echo $self?>?action=select_edit&sort=Objekte.Titel">Titel</a> 
              / <a href="<? echo $self?>?action=select_edit&sort=Objekte.Hersteller">Hersteller</a></td>
            <td align="center" valign="middle" width="6%" bgcolor="#000096">&nbsp;</td>
          </tr>
          <?
        while ($zeile=mysql_fetch_array($result))
        {
        $zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
        $zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
        $zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
        ?>
          <tr> 
            <td width="6%" bgcolor="#000096">&nbsp; </td>
            <td width="88%" > <span class="small"> </span>
              <? echo $zeile[Titel]?>
              / 
              <? echo $zeile[Hersteller]?>
            </td>
            <td align="center" valign="middle" width="6%" bgcolor="#000096"> 
              <input type="checkbox" name="ID[]" value="<?  echo $zeile[ID] ?>">
            </td>
          </tr>
          <?
        }
        ?>
          <tr align="right" bgcolor="#000096"> 
            <td colspan="3"> 
              <input type="hidden" name="action" value='delete'>
              <input type="submit" value="LÖSCHEN">
              <input type="reset" name="Button22" value="Zur&uuml;cksetzen">
            </td>
          </tr>
        </table>
        <?
        }
?>
        <?
        }
?>
        <?

  if ($action=="select_edit") 
        {
        $result = mysql_query ("SELECT * FROM Objekte,$DB where $DB.Objekt=Objekte.Kennung order by $sort") or die (mysql_errno().": ".mysql_error());
        if (mysql_num_rows($result) == 0)
        {
        ?>
        
<p class="error">Es sind keine Daten eingetragen !</p>
<p></p>
        
        <?
        }
        else
        {
        ?>
            <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr bgcolor="#000099"> 
            <td colspan="2" class="headline">Seite: Bearbeiten</td>
          </tr>
          <tr>
            <td width="6%" bgcolor="#000096">&nbsp;</td>
            <td width="94%" >&nbsp;&nbsp;&nbsp; <a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=select_edit&sort=<? echo $DB ?>.von">von</a> 
              &nbsp;&nbsp;&nbsp;&nbsp;- &nbsp;&nbsp;&nbsp;&nbsp; <a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=select_edit&sort=<? echo $DB ?>.bis">bis</a> 
              &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=select_edit&sort=<? echo $DB ?>.Objekt">Kennung</a> 
              / <a href="<? echo $self?>?action=select_edit&sort=Objekte.Titel">Titel</a> 
              / <a href="<? echo $self?>?action=select_edit&sort=Objekte.Hersteller">Hersteller</a></td>
          </tr>
          <?
        while ($zeile=mysql_fetch_array($result))
        {
        $zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
        $zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
        $zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
        ?>
          <tr> 
            <td width="6%" bgcolor="#000096">&nbsp;</td>
            <td width="94%" ><a href="file:///L|/asset-trading.de/redaktion/<? echo $self?>?action=edit&ID=<? echo $zeile[ID]; ?>"> 
              <span class="small"> 
              <? echo $zeile[von]?>
              - 
              <? echo $zeile[bis]?>
              </span>&nbsp;&nbsp;&nbsp;&nbsp; 
              <? echo $zeile[Objekt]?>
              / 
              <? echo $zeile[Titel]?>
              / 
              <? echo $zeile[Hersteller]?>
              </a> </td>
          </tr>
          <?
        }
        ?>
          <tr bgcolor="#000096"> 
            <td colspan="2"> &nbsp; 
              <input type="hidden" name="action" value='edit'>
            </td>
          </tr>
        </table>
 <?
        }
?> 
        <?
        }
?> <?
        if ($action=="edit")
        {
                $result = mysql_query ("SELECT * FROM $DB where domain = '$site'") or die (mysql_errno().": ".mysql_error());
                $zeile=mysql_fetch_array($result);
                $ID=$zeile[ID];
                if ($ID)
                {
                        $result = mysql_query ("SELECT * FROM $DB where ID = $ID") or die (mysql_errno().": ".mysql_error());
                        $zeile=mysql_fetch_array($result);
                }
        $zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));
        $zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));
        $zeile[Eingangsdatum]=join(".",array_reverse(preg_split("/-/",$zeile[Eingangsdatum])));
        ?> 
            <table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
          <tr bgcolor="#000096"> 
            <td colspan="4" class="headline" height="27">
Head: 
        <?
                                        if ($ID)
                                        {
                                         ?>
              Bearbeiten 
              <?
                                        }
                                        else
                                        {
                                         ?>
              Neueintrag 
              <?
                                        }
                                ?>
            </td>
          </tr>
          <tr> 
            <td width="17%" bgcolor="#000096" class="headline">Titel: </td>
            <td colspan="3" class="small"> 
              <input type="text" name="Titel" size="30" maxlength="50" value="<? echo $zeile[Titel] ?>">
              Titel der Homepage</td>
          </tr>
          <tr> 
            <td bgcolor="#000096" class="headline" rowspan="2" valign="top" width="17%">&Uuml;berschrift:</td>
            <td colspan="3"><b> 
              <input type="text" name="Ueberschrift" size="20" maxlength="50" value="<? echo $zeile[Ueberschrift] ?>">
              </b></td>
          </tr>
          <tr> 
            <td width="34%"><b><font face="Arial, Helvetica, sans-serif" size="2">Farbe: 
              # 
              <input type="text" name="Ueberschrift_color" size="6" maxlength="6" value="<? echo $zeile[Ueberschrift_color] ?>">
              <input type="button" value="Farb Assistent" onClick="Farb_Assistent(this.form.Ueberschrift_color.value,'document.formname.Ueberschrift_color.value');">
              </font></b></td>
            <td width="21%" bgcolor="#FFFFFF"><b>Art: 
              <select name="Ueberschrift_art" size="1">
                <option value="Arial, Helvetica, sans-serif"<? if ($zeile[Ueberschrift_art] == "Arial, Helvetica, sans-serif") {echo " selected";} ?>>Arial</option>
                <option value="Times New Roman, Times, serif"<? if ($zeile[Ueberschrift_art] == "Times New Roman, Times, serif") {echo " selected";} ?>>Times New Roman</option>
                <option value="Courier New, Courier, mono"<? if ($zeile[Ueberschrift_art] == "Courier New, Courier, mono") {echo " selected";} ?>>Courier</option>
                <option value="Verdana, Arial, Helvetica, sans-serif"<? if ($zeile[Ueberschrift_art] == "Verdana, Arial, Helvetica, sans-serif") {echo " selected";} ?>>Verdana</option>
              </select>
              </b></td>
            <td width="28%" bgcolor="#FFFFFF"><b>Gr&ouml;&szlig;e: 
              <select name="Ueberschrift_groesse" size="1">
                <option<? if ($zeile[Ueberschrift_groesse] == "1") {echo " selected";} ?>>1</option>
                <option<? if ($zeile[Ueberschrift_groesse] == "2") {echo " selected";} ?>>2</option>
                <option<? if ($zeile[Ueberschrift_groesse] == "3") {echo " selected";} ?>>3</option>
                <option<? if ($zeile[Ueberschrift_groesse] == "4") {echo " selected";} ?>>4</option>
                <option<? if ($zeile[Ueberschrift_groesse] == "5") {echo " selected";} ?>>5</option>
                <option<? if ($zeile[Ueberschrift_groesse] == "6") {echo " selected";} ?>>6</option>
              </select>
              </b></td>
          </tr>
          <tr> 
            <td bgcolor="#000096" class="headline" width="17%"><b><font face="Arial, Helvetica, sans-serif" size="2" color="#FFFFFF">Hintergrund:</font></b></td>
            <td width="34%"><b><font face="Arial, Helvetica, sans-serif" size="2">Farbe: 
              # 
              <input type="text" name="bgcolor" size="6" maxlength="6" value="<? echo $zeile[bgcolor] ?>">
              <input type="button" value="Farb Assistent" onClick="Farb_Assistent(this.form.bgcolor.value,'document.formname.bgcolor.value');">
              </font></b></td>
            <td valign="top" colspan="2" bgcolor="#FFFFFF"> 
<?
        $image_name="background";
        $image_Path="../$site/images/";
        if ($zeile[$image_name] != "")
        {
?>
        <input type="radio" name="_<? echo $image_name ?>" value="<? echo $zeile[$image_name]; ?>" <? if ($zeile[$image_name] != "") {echo "checked";}?>>
<?
        echo "$zeile[$image_name]";
        $size= filesize ($image_Path.$zeile[$image_name]) >> 10;
        $imgsize = GetImageSize ($image_Path.$zeile[$image_name]);
        echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
        }
?>
              <input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>
              kein Bild<br>
              <input type="radio" name="_<? echo $image_name ?>" value="2">
              <input type="File" name="<? echo $image_name ?>" size="17" maxlength="255" onFocus="this.form._<? echo $image_name ?>[<? if ($zeile[$image_name] != "") {echo "2";} else {echo "1";} ?>].checked=true;">
              <input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>">
            </td>
          </tr>
          <tr> 
            <td bgcolor="#000096" class="headline" width="17%" nowrap>Logo/Banner1:<br>
              links </td>
            <td colspan="3"> 
              <?
        $image_name="Banner1";
        $image_Path="../$site/images/";
        if ($zeile[$image_name] != "")
        {
?>
              <input type="radio" name="_<? echo $image_name ?>" value="<? echo $zeile[$image_name]; ?>" <? if ($zeile[$image_name] != "") {echo "checked";}?>>
              <?
        echo "$zeile[$image_name]";
        $size= filesize ($image_Path.$zeile[$image_name]) >> 10;
        $imgsize = GetImageSize ($image_Path.$zeile[$image_name]);
        echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
        }
?>
              <input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>
              kein Bild<br>
              <input type="radio" name="_<? echo $image_name ?>" value="2">
              <input type="File" name="<? echo $image_name ?>" size="17" maxlength="255" onFocus="this.form._<? echo $image_name ?>[<? if ($zeile[$image_name] != "") {echo "2";} else {echo "1";} ?>].checked=true;">
              <input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>">
            </td>
          </tr>
          <tr> 
            <td bgcolor="#000096" class="headline" width="17%" nowrap>Logo/Banner2:<br>
              rechts </td>
            <td colspan="3"> 
              <?
        $image_name="Banner2";
        $image_Path="../$site/images/";
        if ($zeile[$image_name] != "")
        {
?>
              <input type="radio" name="_<? echo $image_name ?>" value="<? echo $zeile[$image_name]; ?>" <? if ($zeile[$image_name] != "") {echo "checked";}?>>
              <?
        echo "$zeile[$image_name]";
        $size= filesize ($image_Path.$zeile[$image_name]) >> 10;
        $imgsize = GetImageSize ($image_Path.$zeile[$image_name]);
        echo "&nbsp;( $size KB $imgsize[0]x$imgsize[1])<BR>";
        }
?>
              <input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>
              kein Bild<br>
              <input type="radio" name="_<? echo $image_name ?>" value="2">
              <input type="File" name="<? echo $image_name ?>" size="17" maxlength="255" onFocus="this.form._<? echo $image_name ?>[<? if ($zeile[$image_name] != "") {echo "2";} else {echo "1";} ?>].checked=true;">
              <input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>">
            </td>
          </tr>
          <tr> 
            <td bgcolor="#000096" class="headline" width="17%" nowrap>erstellt:</td>
            <td colspan="3">am: 
              <?
                                $zeile[erstellt_am]=preg_split("/ /",$zeile[erstellt_am]);
                                $datum=join(".",array_reverse(preg_split("/-/",$zeile[erstellt_am][0])));
                                $zeit=$zeile[erstellt_am][1];
                        ?>
              <?
                                echo $datum;
                        ?>
              um: 
              <?
                                echo $zeit;
                        ?>
              Uhr von: 
              <? echo $zeile[erstellt_von] ?>
            </td>
          </tr>
          <tr> 
            <td bgcolor="#000096" class="headline" width="17%" nowrap>letzte &Auml;nderung:</td>
            <td colspan="3">am: 
              <?
                                $zeile[letzte_Aenderung_am]=preg_split("/ /",$zeile[letzte_Aenderung_am]);
                                $datum=join(".",array_reverse(preg_split("/-/",$zeile[letzte_Aenderung_am][0])));
                                $zeit=$zeile[letzte_Aenderung_am][1];
                        ?>
              <?
                                echo $datum;
                        ?>
              um: 
              <?
                                echo $zeit;
                        ?>
              Uhr von: 
              <? echo $zeile[letzte_Aenderung_von] ?>
            </td>
          </tr>
          <tr bgcolor="#000099"> 
            <td colspan=4 align="right"> 
              <input type="hidden" name="domain" value="<? echo $site ?>">
              <input type="hidden" name="ID" value="<? echo $ID ?>">
              <input type="hidden" name="action" value="update">
              <input type="submit" value="OK">
              <input type="reset" name="Button" value="Zur&uuml;cksetzen">
            </td>
          </tr>
        </table>
        <?
        }
?> </td>
      
</tr>
</table>
</form>
</body>
</html>