Blame | Letzte Änderung | Log anzeigen | RSS feed
<?$tab="Branche";define ("modul_name", "branchenbuch");define ("tool_name", "branchen");require_once "../Online-Shop/connect2.php";$self=basename($_SERVER["PHP_SELF"]);if ($action=="update"){if (!$ID){ // insert Dummy-Entry$query = "insert into $tab (erstellt_am,erstellt_von) VALUES (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:break;case 1:$HTTP_POST_VARS[$elem]='';break;case 2://$image_name=$ID."_".$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;}}}$names=array();foreach(array_keys($HTTP_POST_VARS) as $elem){array_push($names,"$elem='$HTTP_POST_VARS[$elem]'");}$query="update $tab 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());$result=mysql_query("update Branche set Father = -1 where Father = ID");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 $tab WHERE $cond";$result = mysql_query ("$query") or die (mysql_errno().": ".mysql_error());header("Location: ".$self);}}if (!$action){$action="select_edit";}if (!$sort) {$sort='Name';}?><html><head><title>Branchenführer <? echo $site ?>: Redaktionssystem</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link rel=stylesheet type="text/css" href="../Online-Shop/redaktion.css"><link rel=stylesheet type="text/css" href="buttons.css"><script language="JavaScript"><!--function MM_swapImgRestore() { //v3.0var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;}function MM_preloadImages() { //v3.0var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}}function MM_swapImage() { //v3.0var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}}function MM_findObj(n, d) { //v4.0var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);if(!x && document.getElementById) x=document.getElementById(n); return x;}//--></script><meta name="description" content="Redaktionssystem"><meta name="author" content="Webagentur Niewerth"><meta name="robots" content="noindex"></head><body bgcolor="#FFFFFF" leftmargin="20" topmargin="10" marginwidth="20" marginheight="10" onLoad="MM_preloadImages('../images/navigation/bt_neu_f2.gif','../images/navigation/bt_delete_f2.gif','../images/navigation/bt_bearbeiten_f2.gif')" text="#000096"><form method="post" action="<? echo $self ?>" name="formname" enctype="multipart/form-data"><table width="662" border="0" cellspacing="0" cellpadding="0"><tr valign="top"><td width="585"><!-- Auswahl Löschen START --><?if ($action=="delete"){$query="SELECT * FROM $tab ";$query=$query."order by $sort";$result = mysql_query ($query) 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="#<? echo $webs[bgcolor_links] ?>"><td><font color="#<? echo $webs[font_color_links] ?>"><b><? if ($web_rechte[modul_name][tool_name][$Feld]) { echo $web_rechte[modul_name][tool_name][$Feld]; } else { ?>Branche: Löschen<? } ?></b></font></td></tr><tr><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><?function show_Kats_delete($root,$level){$level++;$query="select * from Branche where Father = $root order by Rang";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);while($zeile=mysql_fetch_array($result)){$query_count="select * from Branche where Father = $zeile[ID] order by Rang";$result_count = mysql_query ($query_count) or die (mysql_errno().": ".mysql_error()."<hr>".$query_count);$count=mysql_num_rows($result_count);for ($a = 0; $a < $level; $a++){echo " ";}if ($count == 0) { ?><input type="checkbox" name="ID[]" value="<? echo $zeile[ID]; ?>"><? } else { echo " <b>"; }echo $zeile[Name];if ($count > 0) { ?>:<? echo "</b>"; }?><br><?show_Kats_delete($zeile[ID],$level);if ($root < 1) { echo "<hr noshade>"; }}}show_Kats_delete(-1,-1);?></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td align="right"><input type="hidden" name="action" value='delete'><input type="submit" value="LÖSCHEN"><input type="reset" name="Button22" value="Zurücksetzen"></td></tr></table><?}?><?}?><!-- Auswahl Löschen ENDE --><!-- Auswahl SELECT_EDIT START --><?if ($action=="select_edit"){$query="SELECT * FROM $tab ";$query=$query."order by $sort";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());if (mysql_num_rows($result) == 0){?><p class="error">Es sind keineDaten eingetragen !</p><p></p><?}else{?><table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999"><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td colspan="2"><font color="#<? echo $webs[font_color_links] ?>"><b><? if ($web_rechte[modul_name][tool_name][$Feld]) { echo $web_rechte[modul_name][tool_name][$Feld]; } else { ?>Branche: Bearbeiten<? } ?></b></font></td></tr><tr bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><td><?function show_Kats_edit($root,$level){$level++;$query="select * from Branche where Father = $root order by Rang";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);while($zeile=mysql_fetch_array($result)){for ($a = 0; $a < $level; $a++){echo " ";}?><a href="<? echo $self ?>?action=edit&ID=<? echo $zeile[ID]; ?>"><? echo $zeile[Name]; ?></a><br><?show_Kats_edit($zeile[ID],$level);if ($root < 1) { echo "<hr noshade>"; }}}show_Kats_edit(-1,-1);?></td></tr><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td colspan="2"><div align="right"> <input type="hidden" name="action" value='edit'></div></td></tr></table><?}?><?}?><!-- Auswahl SELECT_EDIT ENDE --><?if ($action=="edit"){if ($ID){$result = mysql_query ("SELECT * FROM $tab where ID = '$ID'") or die (mysql_errno().": ".mysql_error());$zeile=mysql_fetch_array($result);$Father=$zeile[Father];}$zeile[von]=join(".",array_reverse(preg_split("/-/",$zeile[von])));$zeile[bis]=join(".",array_reverse(preg_split("/-/",$zeile[bis])));$zeile[Abmeldedatum]=join(".",array_reverse(preg_split("/-/",$zeile[Abmeldedatum])));?><table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999"><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td colspan="3"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td><font color="#<? echo $webs[font_color_links] ?>"><b>Branche:<? if ($ID) { ?>Bearbeiten<? } else { ?>Neueintrag<? } ?></b></font></td><?$Feld="Rang";if (isset($user_rechte[modul_name][tool_name][$Feld])){?><td align="right"><font color="#<? echo $webs[font_color_links] ?>"><b>Rang:</b></font><input type="text" name="Rang" value="<? echo $zeile[Rang] ?>" size="3"></td><? } ?></tr></table></td></tr><?$Feld="Father";if (isset($user_rechte[modul_name][tool_name][$Feld])){$current_Father = $zeile[Father];?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle" width="13%"><font color="#<? echo $webs[font_color_links] ?>"><b><? if ($web_rechte[modul_name][tool_name][$Feld]) { echo $web_rechte[modul_name][tool_name][$Feld]; } else { ?>Father<? } ?></b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="2"><select name="Father" size="1" class="input"><option value="-1"></option><?function show_Kats_select($root,$level){global $current_Father;$level++;$query="select * from Branche where Father = $root order by Rang";$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);while($zeile=mysql_fetch_array($result)){?><option value="<? echo $zeile[ID]; ?>" <? if ($current_Father == $zeile[ID]) { ?>selected<? } ?>><? for ($a = 0; $a < $level; $a++) { echo " "; } ?><? echo $zeile[Name]; ?></option><?show_Kats_select($zeile[ID],$level);}}show_Kats_select(-1,-1);?></select></td></tr><?}?><?$Feld="Name";if (isset($user_rechte[modul_name][tool_name][$Feld])){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="middle" width="13%"><font color="#<? echo $webs[font_color_links] ?>"><b><? if ($web_rechte[modul_name][tool_name][$Feld]) { echo $web_rechte[modul_name][tool_name][$Feld]; } else { ?>Name<? } ?></b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="2"><input type="text" name="Name" value="<? echo $zeile[Name] ?>" class="input"></td></tr><?}?><?// SEBASTIAN$Feld="Template";if (isset($user_rechte[modul_name][tool_name][$Feld])){if ($ID){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="21%" valign="top" height="100"><p><font color="#<? echo $webs[font_color_links] ?>"><b><?if ($web_rechte[modul_name][tool_name][$Feld]){echo $web_rechte[modul_name][tool_name][$Feld];}else{?>Template:<?}?></b></font></p></td><td colspan="2" bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><iFrame height=100% width=100% frameborder="NO" marginwidth="0" marginheight="0" src="../Online-Shop/template.php?language=<? echo $language ?>&Typ=Branche&ID=<? echo $zeile[ID]?>"></iFrame></td></tr><?}}?><?/* ############################################################################################################ */for ($bild_nr=1; $bild_nr <= 2; $bild_nr++){$Feld="bild$bild_nr";if (isset($user_rechte[modul_name][tool_name][$Feld])){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="top" width="21%"><font color="#<? echo $webs[font_color_links] ?>"><b><?$Felddaten = explode(";", $web_rechte[modul_name][tool_name][$Feld]);if (!empty($Felddaten[0])){echo $Felddaten[0];}else{?>Bild <? echo $bild_nr; ?><?}?></b></font> </td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" width="79%"><table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td width="55%" nowrap colspan="2"> <font color="#<? echo $webs[font_color_rechts] ?>"><?$image_name="bild_".$bild_nr."_url";$image_Path=$webs[verzeichnis]."/images/Branchenbuch/Branchen/".$bild_nr."/";?><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/Branchenbuch/Branchen/".$bild_nr."/".$zeile[$image_name] ?>" target="blank"><? echo $zeile[$image_name]; ?></a><?$size= filesize ($image_Path.$zeile[$image_name]) >> 10;$imgsize = GetImageSize ($image_Path.$zeile[$image_name]);echo " ( $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;"></font> </td><td width="45%" nowrap align="center"><? if ($zeile[$image_name] != "") {?><a href="http://www.<? echo $site."/images/Branchenbuch/Branchen/".$bild_nr."/".$zeile[$image_name] ?>" target="blank"><img height="60" src="http://www.<? echo $site."/images/Branchenbuch/Branchen/".$bild_nr."/".$zeile[$image_name] ?>" border="0"></a><? } ?></td></tr></table></td></tr><?}$Feld="bild_text$bild_nr";if (isset($user_rechte[modul_name][tool_name][$Feld])){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links] ?>"><b><?if ($web_rechte[modul_name][tool_name][$Feld]){echo $web_rechte[modul_name][tool_name][$Feld];}else{?>Bildtext:<?}?></b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><input type="text" name="bild_text<?=$bild_nr;?>" size="40" value="<? echo htmlentities($zeile["bild_text".$bild_nr]) ?>" maxlength="255"></td></tr><?}$Feld="bild_pos$bild_nr";if (isset($user_rechte[modul_name][tool_name][$Feld])){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" class="headline" width="20%"><font color="#<? echo $webs[font_color_links] ?>"><b>Position:</b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>"><? $kats= explode(";",$web_rechte[modul_name][tool_name]["bild_pos".$bild_nr]) ?><select name="<?="bild_pos".$bild_nr;?>"><?foreach($kats as $elem){?><option <? if ($zeile["bild_pos".$bild_nr] == $elem) { ?>selected<? } ?>><? echo $elem ?></option><?}?></select></td></tr><?}}/* ############################################################################################################ */$Feld="Beschreibung";if (isset($user_rechte[modul_name][tool_name][$Feld])){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" valign="top" width="13%"><font color="#<? echo $webs[font_color_links] ?>"><b><? if ($web_rechte[modul_name][tool_name][$Feld]) { echo $web_rechte[modul_name][tool_name][$Feld]; } else { ?>Beschreibung<? } ?></b></font></td><td bgcolor="#<? echo $webs[bgcolor_rechts] ?>" colspan="2"><textarea name="Beschreibung" cols="45" rows="5"><? echo $zeile[Beschreibung] ?></textarea></td></tr><?}?><?if ($ID){if ($zeile[erstellt_am]){?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="20%"><font color="#<? echo $webs[font_color_links] ?>"><b>erstellt:</b></font></td><td colspan="3" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">am:<? $erstellt_am=datetime2human($zeile[erstellt_am]); ?><? echo $erstellt_am[Datum] ?> um:<? echo $erstellt_am[Zeit] ?> von:<? echo $zeile[erstellt_von] ?></td></tr><?}?><tr><td bgcolor="#<? echo $webs[bgcolor_links] ?>" width="20%" nowrap><font color="#<? echo $webs[font_color_links] ?>"><b>letzte Änderung:</b></font></td><td colspan="3" bgcolor="#<? echo $webs[bgcolor_rechts] ?>">am:<?if (strpos ($zeile[letzte_Aenderung_am], " ")){$letzte_Aenderung_am=datetime2human($zeile[letzte_Aenderung_am]);}else{$letzte_Aenderung_am=timestamp2human($zeile[letzte_Aenderung_am]);}?><? echo $letzte_Aenderung_am[Datum] ?> um:<? echo $letzte_Aenderung_am[Zeit] ?> von:<? echo $zeile[letzte_Aenderung_von] ?></td></tr><?}?><tr bgcolor="#<? echo $webs[bgcolor_links] ?>"><td align="right" colspan="3"><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ücksetzen"></td></tr></table><?}?></td><td width="77" align="right"><table width="67" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#FFFFFF" bordercolordark="#999999"><tr><td><a href="<? echo $self ?>?action=edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('new','','../images/navigation/bt_neu_f2.gif',1)"><img name="new" border="0" src="../images/navigation/bt_neu.gif" width="67" height="40" alt="Neueintrag"></a></td></tr><tr><td><a href="<? echo $self ?>?action=select_edit" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('edit','','../images/navigation/bt_bearbeiten_f2.gif',1)"><img name="edit" border="0" src="../images/navigation/bt_bearbeiten.gif" width="67" height="40" alt="Eintrag bearbeiten"></a></td></tr><tr><td><a href="<? echo $self ?>?action=delete" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('delete','','../images/navigation/bt_delete_f2.gif',1)"><img name="delete" border="0" src="../images/navigation/bt_delete.gif" width="67" height="40" alt="Eintrag löschen"></a></td></tr></table></td></tr></table></form></body>