Blame | Letzte Änderung | Log anzeigen | RSS feed
<?session_start();require_once "connect2.php";$self=basename($PHP_SELF);// shops_ID speichernif (isset($_GET[shop])) {$_SESSION[$self][shops_ID] = $_GET[shop];}function position($pos){$pos = explode(",",$pos);$buttons = array("radio" => array("links","rechts"),"checkbox" => array('Startseite','Unterseite','Warenkorb','Bestellvorgang1','Bestellvorgang2','Bestellvorgang3','Bestellvorgang4','ServiceCenter'));foreach($buttons as $typ => $line){foreach($line as $elem){?><inputtype="<?=$typ;?>"name="position[]"value="<?=$elem;?>"title="<?=$elem;?>"<? if(in_array($elem,$pos)) {echo "checked";} ?>><?=$elem;?><br><?}}}?><html><head><title><? echo $webs[kunde_bezeichnung] ?>: 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"><style type="text/css">body{font-family: Arial, Helvetica, sans-serif; font-size: 10pt;<? if ($webs[font_color_seite]) { ?>color: #<? echo $webs[font_color_seite] ?>;<? } ?><? if ($webs[bgcolor_seite]) { ?>background-color: #<? echo $webs[bgcolor_seite] ?>;<? } ?><? if ($webs[hintergrundbild]) { ?>background-image: url(../images/hintergrundbild/<? echo $webs[hintergrundbild] ?>);<? } ?>}.links{font-size: 10pt;<? if ($webs[font_color_links]) { ?>color: #<? echo $webs[font_color_links] ?>;<? } ?><? if ($webs[bgcolor_links]) { ?>background-color: #<? echo $webs[bgcolor_links] ?>;<? } ?>}.rechts{font-size: 10pt;<? if ($webs[font_color_rechts]) { ?>color: #<? echo $webs[font_color_rechts] ?>;<? } ?><? if ($webs[bgcolor_rechts]) { ?>background-color: #<? echo $webs[bgcolor_rechts] ?>;<? } ?>}A:link {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}A:visited {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}A:active {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}A:hover {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}</style><style type="text/css"><!--table.input{border-width: 2px 1px 1px 2px;border-top-color : #CCCCCC;border-left-color : #CCCCCC;border-bottom-color : #AAAAAA;border-right-color : #AAAAAA;border-style :inset;background-color : #FFFFFF;}--></style></head><body bgcolor="#<? echo $webs[bgcolor_rechts] ?>" text="#<? echo $webs[font_color_rechts] ?>" leftmargin="0" topmargin="0" link="#0000FF" vlink="#0000FF" alink="#0000FF"><?// rang ändern// var_dump($scroll_up);// var_dump($scroll_down);if ($scroll_up){$result = mysql_query ("select rang from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." order by rang") or die (mysql_errno().": ".mysql_error());$zeile=mysql_fetch_array($result);$primary=$zeile[rang];$query="select rang from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." and ID = $scroll_up";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);$zeile=mysql_fetch_array($result);$query="select rang from sonderkasten where rang < $zeile[rang] and shops_ID = ".$_SESSION[$self][shops_ID]." order by rang DESC";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);$zeile_rang=mysql_fetch_array($result);$target=$zeile_rang[rang];if ($zeile[rang] > $primary){$query="update sonderkasten set rang=$zeile[rang] where shops_ID = ".$_SESSION[$self][shops_ID]." and rang = $target";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());$query="update sonderkasten set rang=$target where shops_ID = ".$_SESSION[$self][shops_ID]." and ID = $scroll_up";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());}}if ($scroll_down){$result = mysql_query ("select rang from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." order by rang DESC") or die (mysql_errno().": ".mysql_error());$zeile=mysql_fetch_array($result);$final=$zeile[rang];$query="select rang from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." and ID = $scroll_down";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);$zeile=mysql_fetch_array($result);$query="select rang from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." and rang > $zeile[rang] order by rang ASC";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);$zeile_rang=mysql_fetch_array($result);$target=$zeile_rang[rang];if ($zeile[rang] < $final){$query="update sonderkasten set rang=$zeile[rang] where shops_ID = ".$_SESSION[$self][shops_ID]." and rang = $target";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());$query="update sonderkasten set rang=$target where shops_ID = ".$_SESSION[$self][shops_ID]." and ID = $scroll_down";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());}}if (isset($_POST[submit_bearbeiten])) {// Bearbeiten$query = "updatesonderkastensetueberschrift = '".$_POST[ueberschrift]."',text = '".$_POST[text]."',bild_link = '".$_POST[bild_link]."',position = '".implode(",",$_POST[position])."'whereshops_ID = '".$_SESSION[$self][shops_ID]."'andID = '".$_POST[ID]."'";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");// Ende Bearbeiten} elseif (isset($_POST[submit_neu])) {// Neu// #####################unset($HTTP_POST_VARS[action]);unset($HTTP_POST_VARS[ID]);// Bilderuploadforeach(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:break;case 1:$HTTP_POST_VARS[$elem]='';break;case 2://$image_name=$ID."_".$language."_".$image_name;$image_name=time()."_".$language."_".$image_name;//$image_name=$ID.strrchr($image_name,".");$HTTP_POST_VARS[$elem]=$image_name;// $Imagenummer extrahieren$Imagenummer=explode("_",$elem); $Imagenummer=$Imagenummer[1];$DatenID = "bild".$Imagenummer;$Imagedaten = explode(";", $web_rechte[modul_name][tool_name][$DatenID]);/*Imagedaten möglich Werte:0: Titel des Feldes1: max. Breite für Bild12: max. Höhe für Bild13: Pfad für mittleres Bild14: max. Breite für mittleres Bild15: max. Höhe für mittleres Bild16: Pfad für kleines Bild17: max. Breite für kleines Bild18: max. Höhe für kleines Bild1*/// Höhe und Breite des Bildes bestimmen$imgsize = GetImageSize ($image);// $imgsize[0] $imgsize[1]// ---- Hier wird abgefragt ob das grosse Bild angepasst werden soll ---- //$resize=false;if (count($Imagedaten) > 1) {$resize = true;}if (($imgsize[0] < $Imagedaten[1]) and ($imgsize[1] < $Imagedaten[2])) {$resize = false;}if ($resize==true){exec ("convert -scale ".$Imagedaten[1]."x".$Imagedaten[2]." ".$image." ".$Pfad.$image_name);}else{copy($image,$Pfad.$image_name);}// ---- falls mittleres Bild: erstellen---- //if (($Imagedaten[4]) and ($Imagedaten[5])){exec ("convert -scale ".$Imagedaten[4]."x".$Imagedaten[5]." ".$image." ".$Pfad.$Imagedaten[3]."/".$image_name);}// ---- falls kleines Bild: erstellen---- //if (($Imagedaten[6]) and ($Imagedaten[7])) {exec ("convert -scale ".$Imagedaten[7]."x".$Imagedaten[8]." ".$image." ".$Pfad.$Imagedaten[6]."/".$image_name);}break;default:break;}}}// #####################// Höchsten rang holen$result = mysql_query ("select MAX(rang) AS rang from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." and FIND_IN_SET('".$_POST[position]."',position) > 0") or die (mysql_errno().": ".mysql_error());$zeile=mysql_fetch_array($result);$zeile[rang]++;var_dump($zeile);// Einfügen$query = "insert intosonderkasten(ID,shops_ID,";$query.=(isset($_POST["language"]))?"language,":"";$query.="ueberschrift,text,bild_url,bild_link,position,rang)values('','".$_SESSION[$self]["shops_ID"]."',";$query.=(isset($_POST["language"]))?"'".$_POST["language"]."',":"";$query.="'".$_POST["ueberschrift"]."','".$_POST["text"]."','".$image_name."','".$_POST["bild_link"]."','".implode(",",$_POST["position"])."','".$zeile["rang"]."')";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");?><b>Einfügen hat geklappt!</b><br><br><?// Ende Neu} elseif (isset($_POST[submit_loeschen])) {// Löschen$query = "delete from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." and ID = $_POST[ID]";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");// Ende Löschen}?><?if (!$_GET[action]) {// Liste// FUNCTION GIBZEILENAUSfunction gibZeilenAus($position) {GLOBAL $site;GLOBAL $webs;GLOBAL $self;$query = "select * from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID];$query.=(isset($_REQUEST["language"]))?" AND Language='".$_REQUEST["language"]."'":"";$query.=" and FIND_IN_SET('".$position."',position) > 0 order by rang";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");while ($r = mysql_fetch_array($result)) {echo '<tr><td bgcolor="#'.$webs[bgcolor_rechts].'" valign="top">'.$r[ID].'</td><td bgcolor="#'.$webs[bgcolor_rechts].'" valign="top">'.$r[ueberschrift].'</td><td bgcolor="#'.$webs[bgcolor_rechts].'" valign="top">'.$r[text].'</td><td bgcolor="#'.$webs[bgcolor_rechts].'" valign="top"><a href="http://www.'.$site.'/images/sonderkasten/'.$r[bild_url].'" target="blank">';if ($r[bild_url]) {echo"bild";}echo '</a></td><td bgcolor="#'.$webs[bgcolor_rechts].'" valign="top"><a href="'.$r[bild_link].'" target="_blank">'.$r[bild_link].'</a></td><td bgcolor="#'.$webs[bgcolor_rechts].'" valign="top"><a href="'.$PHP_SELF.'?action=bearbeiten&ID='.$r[ID].'">bearbeiten</a><a href="'.$self.'?scroll_up='.$r[ID].'"><img src="../images/Icons/up.gif" border="0"></a><a href="'.$self.'?scroll_down='.$r[ID].'"><img src="../images/Icons/down.gif" border="0"></a></td></tr>';}}?><strong>Liste</strong>:<br><br><table width="100%" border="0" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999"><tr><td><b>Links:</b></td><td><b>Rechts:</b></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="50%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999"><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><strong>ID</strong></font></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Überschrift</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Text</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Bild</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Link</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"></td></tr><? gibZeilenAus("links"); ?></table></td><td width="50%" bgcolor="#<? echo $webs[bgcolor_rechts] ?>" valign="top"><table width="100%" height="100%" border="0" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999"><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>ID</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Überschrift</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Text</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Bild</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Link</strong></td><td bgcolor="#<? echo $webs[bgcolor_links] ?>"></td></tr><? gibZeilenAus("rechts"); ?></table></td></tr></table><font color="#<? echo $webs[font_color_links] ?>"><a href="<?=$PHP_SELF;?>?action=neu<? if ($_GET["language"]){?>&language=<?=$_GET["language"];}elseif ($_POST["language"]){?>&language=<?=$_POST["language"];}?>"><b>neu</b></a></font><?// Ende Liste} elseif ($_GET[action] == 'bearbeiten') {// Bearbeiten$query = "select * from sonderkasten where shops_ID = ".$_SESSION[$self][shops_ID]." and ID = $_GET[ID]";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query."<hr>");$r = mysql_fetch_array($result);?><strong>Bearbeiten</strong>:<br><br><form name="form_bearbeiten" action="<?=$PHP_SELF;?>" method="post"><?php$language=($r["Language"])?$r["Language"]:$_GET["language"];if(!empty($language)){?><input type="hidden" name="language" value="<?=$language?>"><?php}?><table><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>ID:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="text" name="ID" value="<?=$r[ID];?>" disabled><input type="hidden" name="ID" value="<?=$r[ID]?>"></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Überschrift:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="text" name="ueberschrift" value="<?=$r[ueberschrift];?>"></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td valign="top" bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Text:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><textarea name="text" rows="7" cols="50"><?=$r[text];?></textarea></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td valign="top" bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Bild:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><? if ($r[bild_url] != "") {?><a href="http://www.<? echo $site."/images/sonderkasten/".$r[bild_url] ?>" target="blank"><img height="60" src="http://www.<? echo $site."/images/sonderkasten/".$r[bild_url] ?>" border="0"></a><? } ?></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Link:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="text" name="bild_link" value="<?=$r[bild_link];?>"></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td valign="top" bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Position:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><? position($r[position]); ?><?=$r[position];?></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="submit" name="submit_loeschen" value="Löschen"><input type="submit" name="submit_bearbeiten" value="Bearbeiten"></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><a href="<?=$PHP_SELF; if($r["Language"]){?>?language=<?=$r["Language"];}?>"><strong>zurück</strong></a></td></tr></table></form><?// Ende Bearbeiten} elseif ($_GET[action] == 'neu') {// Neu?><strong>Neu</strong>:<br><br><form name="form_neu" action="<?=$PHP_SELF;?>" method="post" enctype="multipart/form-data"><?php$language=($r["Language"])?$r["Language"]:$_GET["language"];if(!empty($language)){?><input type="hidden" name="language" value="<?=$language?>"><?php}?><table><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Überschrift:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="text" name="ueberschrift"></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td valign="top" bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Text:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><textarea name="text" rows="7" cols="50"></textarea></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td valign="top" bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Bild:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><!--################--><?$image_name="bild_".$bild_nr."_url";$image_Path="/images/sonderkasten/";$image_Path=$webs[verzeichnis].$image_Path;if ($Language_neueintrag){?><input type="hidden" name="<? echo $image_name ?>" value="<? echo $zeile[$image_name] ?>"><?}?><input type="hidden" name="<? echo $image_name ?>_Pfad" value="<? echo $image_Path ?>"><?if ($zeile[$image_name] != ""){?><input type="radio" name="_<? echo $image_name ?>" value="0" checked><a href="http://www.<? echo $site."/images/Bild_".$bild_nr."/".$zeile[$image_name] ?>" target="blank"> <? echo $zeile[$image_name]; ?> </a><?if (file_exists($image_Path.$zeile[$image_name])){$size= filesize ($image_Path.$zeile[$image_name]) >> 10;$imgsize = GetImageSize ($image_Path.$zeile[$image_name]);echo " ( $size KB";if ($imgsize) { echo " $imgsize[0]x$imgsize[1]"; }echo " )<BR>";} else { echo "<br>";}}?><input type="radio" name="_<? echo $image_name ?>" value="1" <? if ($zeile[$image_name] == "") {echo "checked";}?>>keinBild <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;"><!--################--></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Link:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="text" name="bild_link"></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td valign="top" bgcolor="#<? echo $webs[bgcolor_links] ?>"><strong>Position:</strong></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><? position($r[position]); ?></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td bgcolor="#<? echo $webs[bgcolor_links] ?>"></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><a href="<?=$PHP_SELF; if($_GET["language"]){?>?language=<?=$_GET["language"];}?>"><strong>zurück</strong></a><input type="submit" name="submit_neu" value="Anlegen"></td></tr></table></form><?// Ende Neu}?></body></html>