Blame | Letzte Änderung | Log anzeigen | RSS feed
<?php$self = basename( $PHP_SELF );define( "modul_name", "online_shop" );define( "tool_name", "language" );define( "native_language", "DE" );require_once "connect2.php";session_start();if ( !$_SESSION["language"] ){require_once "language_pack.php";// $_SESSION[language]=native_language;$_SESSION["language"] = $language_pack[0][0];$language = $_SESSION["language"];}if ( !$_SESSION["language"] ){$_SESSION["language"] = native_language;}?><html><head><title><?php echo $webs["kunde_bezeichnung"]?>: Redaktionssystem</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><link rel=stylesheet type="text/css" href="redaktion.css"><style type="text/css">body{font-family: Arial, Helvetica, sans-serif; font-size: 10pt;<?php if ( $webs["font_color_seite"] ){?>color: #<?php echo $webs["font_color_seite"]?>;<?php }?><?php if ( $webs["bgcolor_seite"] ){?>background-color: #<?php echo $webs["bgcolor_seite"]?>;<?php }?><?php if ( $webs["hintergrundbild"] ){?>background-image: url(../images/hintergrundbild/<?php echo $webs["hintergrundbild"]?>);<?php }?>}.links{font-size: 10pt;<?php if ( $webs["font_color_links"] ){?>color: #<?php echo $webs["font_color_links"]?>;<?php }?><?php if ( $webs["bgcolor_links"] ){?>background-color: #<?php echo $webs["bgcolor_links"]?>;<?php }?>}.rechts{font-size: 10pt;<?php if ( $webs["font_color_rechts"] ){?>color: #<?php echo $webs["font_color_rechts"]?>;<?php }?><?php if ( $webs["bgcolor_rechts"] ){?>background-color: #<?php echo $webs["bgcolor_rechts"]?>;<?php }?>}A:link {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo$webs["font_color_rechts"]?>}A:visited {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo$webs["font_color_rechts"]?>}A:active {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo$webs["font_color_rechts"]?>}A:hover {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php 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 style="margin-left:20px;margin-top:10px;" marginwidth="20" marginheight="10" bgcolor="#<?php echo$webs[bgcolor_seite]?>" text="#<?php echo $webs[font_color_seite]?>"><p><font face="Arial, Helvetica, sans-serif" size="2"><b><?php echo $webs[kunde_begruessung]?></b></font></p><?phpif ( isset( $user_rechte["online_shop"]["language"] ) ){?><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td><hr width="100%" align="left"><font face="Arial, Helvetica, sans-serif" size="2"><b><br>Bitte wählen Sie eine Sprache:</b></font><br><br></td></tr><tr><td><table border="0" cellspacing="5" cellpadding="2"><?php require_once "language_pack.php";?><?php$flaggen_pro_zeile = 10;if ( count( $language_pack ) < $flaggen_pro_zeile ){$flaggen_pro_zeile = count( $language_pack );}$zeilen = count( $language_pack ) / $flaggen_pro_zeile;for ( $j = 0; $j < $zeilen; $j++ ){?><tr><?phpfor ( $i = 0; $i < $flaggen_pro_zeile; $i++ ){$index = ( $j * $flaggen_pro_zeile ) + $i;?><td align="center" valign="middle"<?php if ( $language == $language_pack[$index][0] ){?> bgcolor="#FF0000"<?php }?>><a href="select_language.php?language=<?php echo$language_pack[$index][0]?>"><img src="../images/Online-Shop/language/<?php echo$language_pack[$index][1]?>" alt="<?php echo $language_pack[$index][2]?>" width="32" height="22" border="0"></a></td><?php}?></tr><?php}?></table></td></tr><?}?><table><?phpif ( !$_POST["mode"] && !$_GET["mode"] ){?><tr><th>Artikelsuche </th></tr><tr><td><form method="post"><table border="0" cellspacing="0" cellpadding="0"><tr valign="top" bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;font-weight:bold;"><td width="50%">Feld</td><td width="50%">Suchwert</td></tr><tr><td bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;">ID</td><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>"><input type="text" name="ID" value=""> </td></tr><?php$sql_p = "SELECT * FROM $database_name.properties WHERE tools=1 AND quick_edit='true' ORDER BY Rang";$res_p = mysql_query( $sql_p, $localhost_dbh );//echo mysql_error();while ( $row_p = mysql_fetch_assoc( $res_p ) ){$such_felder[] = $row_p;}$such_felder[] = array( "ID" => "226", "tools" => "1", "name" =>"Beschreibung", "interner_name" => "beschreibung_simpel","hidden" => "false", "quickedit" => "true" );/*if($_SERVER["REMOTE_ADDR"]=="89.245.130.99"){var_dump($such_felder);}*/foreach ( $such_felder as $row_p ){if ( isset( $user_rechte["online_shop"]["artikel"][$row_p["interner_name"]] ) ){switch ( $row_p["interner_name"] ){case ( preg_match( "/eigenschaft/i", $row_p["interner_name"] ) ==1 ):$type = "radio";break;case ( preg_match( "/status/i", $row_p["interner_name"] ) ==1 ):$type = "select";break;case ( preg_match( "/autoupdate/i", $row_p["interner_name"] ) ==1 ):$type = "";break;default:$type = "text";break;}if ( $type ){?><tr><td bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;"><?php$f_name = $web_rechte["online_shop"]["artikel"][$row_p["interner_name"]];if ( $f_name ){$pos = strrpos( $f_name, ";" );if ( $pos === false ){if ( $f_name[0] == "!" ){$f_name_a = substr( $f_name, 1 );}else{$f_name_a = $f_name;}}else{$f_name_a = $row_p["name"];}}else{$f_name_a = $row_p["name"];}echo $f_name_a;?> </td><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>"><?phpswitch ( $type ){case "text":?><input name="<?= $row_p["interner_name"];?>" value="" type="<?= $type;?>"><?phpbreak;case "radio":?><input name="<?= $row_p["interner_name"];?>" value="1" type="<?= $type;?>">ja <input name="<?= $row_p["interner_name"];?>" value="0" type="<?= $type;?>">nein <input name="<?= $row_p["interner_name"];?>" value="-1" type="<?= $type;?>" checked="checked">egal<?phpbreak;case "select":?><select name="<?= $row_p["interner_name"];?>"><option value="-1" selected="selected">egal</option><?php$sql_a = "SELECT * FROM $database_name.webs_properties WHERE properties=" .$row_p["ID"] . " AND webs=" . $webs["ID"];$res_a = mysql_query( $sql_a, $localhost_dbh );//echo mysql_error();$row_a = mysql_fetch_assoc( $res_a );$options = explode( ";", $row_a["Bezeichnung"] );$i = 0;foreach ( $options as $option ){?><option value="<?= $i++;?>"><?= $option;?></option><?php}?></select><?phpbreak;}?> </td></tr><?php}}}?><tr bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;font-weight:bold;"><td align="center" colspan="2"><input type="hidden" name="mode" value="search"><input type="submit" value="Artikel suchen"> </td></tr></table></form><br><br> </td></tr><tr><th>Verzeichnissuche </th></tr><tr><td><form method="post"><table border="0" cellspacing="0" cellpadding="0"><tr valign="top" bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;font-weight:bold;"><td width="50%">Feld</td><td width="50%">Suchwert</td></tr><tr><td bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;">ID</td><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>"><input type="text" name="ID" value=""> </td></tr><?php$sql_p = "SELECT * FROM $database_name.properties WHERE tools=31 AND quick_edit='true' ORDER BY Rang";$res_p = mysql_query( $sql_p, $localhost_dbh );// echo mysql_error();while ( $row_p = mysql_fetch_assoc( $res_p ) ){if ( isset( $user_rechte["online_shop"]["directory"][$row_p["interner_name"]] ) ){switch ( $row_p["interner_name"] ){case ( preg_match( "/artikelstamm/i", $row_p["interner_name"] ) ==1 ):case ( preg_match( "/eigenshaft/i", $row_p["interner_name"] ) ==1 ):$type = "radio";break;case ( preg_match( "/status/i", $row_p["interner_name"] ) ==1 ):$type = "select";break;case ( preg_match( "/name/i", $row_p["interner_name"] ) ==1 ):case ( preg_match( "/kennung/i", $row_p["interner_name"] ) ==1 ):$type = "text";break;default:$type = "";break;}if ( $type ){?><tr><td bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;"><?php$f_name = $web_rechte["online_shop"]["directory"][$row_p["interner_name"]];if ( $f_name ){$pos = strrpos( $f_name, ";" );if ( !$pos ){if ( $f_name[0] == "!" ){$f_name_a = substr( $f_name, 1 );}else{$f_name_a = $f_name;}}else{$f_name_a = $row_p["interner_name"];}}else{$f_name_a = $row_p["name"];}echo $f_name_a;?> </td><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>"><?phpswitch ( $type ){case "":continue;break;case "text":?><input name="<?= $row_p["interner_name"];?>" value="" type="<?= $type;?>"><?phpbreak;case "radio":?><input name="<?= $row_p["interner_name"];?>" value="1" type="<?= $type;?>">ja <input name="<?= $row_p["interner_name"];?>" value="0" type="<?= $type;?>">nein <input name="<?= $row_p["interner_name"];?>" value="-1" type="<?= $type;?>" checked="checked">egal<?phpbreak;case "select":?><select name="<?= $row_p["interner_name"];?>"><option value="-1" selected="selected">egal</option><?php$sql_a = "SELECT * FROM $database_name.webs_properties WHERE properties=" .$row_p["ID"] . " AND webs=" . $webs["ID"];$res_a = mysql_query( $sql_a, $localhost_dbh );// echo mysql_error();$row_a = mysql_fetch_assoc( $res_a );$i = 0;$options = explode( ";", $row_a["Bezeichnung"] );foreach ( $options as $option ){?><option value="<?= $i;?>"><?= $option;?></option><?php$i++;}?></select><?phpbreak;}?> </td></tr><?php}}}?><tr bgcolor="#<?php echo $webs["bgcolor_links"]?>" style="color:#<?php echo$webs["font_color_links"]?>;font-weight:bold;"><td align="center" colspan="2"><input type="hidden" name="mode" value="dir_search"><input type="submit" value="Verzeichnis suchen"> </td></tr></table></form><br><br> </td></tr><?php} elseif ( $_GET["mode"] == "search" || $_POST["mode"] == "search" ){?><tr><th>Ergebnis der Artikelsuche </th></tr><?phpif ( $_POST["mode"] ){unset( $_POST["mode"] );}else{unset( $_GET["mode"] );$params = explode( ";", $_GET["params"] );foreach ( $params as $param ){$pos = strpos( $param, "=" );$key = substr( $param, 0, $pos );$value = substr( $param, $pos + 1 );$_POST[$key] = $value;}}foreach ( $_POST as $key => $value ){$return_fields[] = "$key=$value";if ( preg_match( "/status/i", $key ) ){if ( $value == -1 ){unset( $_POST[$key] );}else{$such_sql[] = "$key=$value";}} elseif ( preg_match( "/eigenschaft/i", $key ) ){if ( $value == -1 ){unset( $_POST[$key] );}else{$such_sql[] = "$key=$value";}} elseif ( preg_match( "/id/i", $key ) ){if ( $value == "" ){unset( $_POST[$key] );}else{$such_sql[] = "$key=$value";}} elseif ( stristr( $key, "beschreibung_simpel" ) ){if ( $value == "" ){unset( $_POST[$key] );}else{$such_sql[] = "beschreibung LIKE '%$value%'";}}else{if ( $value == "" ){unset( $_POST[$key] );}else{$such_sql[] = "$key LIKE '%$value%'";}}}$such_sql_str = is_array( $such_sql ) ? "AND " . implode( " AND ", $such_sql ) :"";$return_str = implode( ";", $return_fields );$sql = "SELECT * FROM artikel WHERE Father !=-3 $such_sql_str";$sql .= ( $_SESSION["language"] ) ? " AND language='" . $_SESSION["language"] ."'" : "";$res = mysql_query( $sql );// echo mysql_error()."<br>$sql";while ( $row = mysql_fetch_assoc( $res ) ){?><tr><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>;"><a href="artikel.php?action=edit&ID=<?= $row["ID"];?>&return=start.php&mode=search¶ms=<?= $return_str;?>"><?php echo$row["kurzbezeichnung"];?></a></td></tr><?php}?><tr><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>;"><a href="start.php">zurück zur Suche</a></td></tr><?php} elseif ( $_GET["mode"] == "dir_search" || $_POST["mode"] == "dir_search" ){?><tr><th>Ergebnis der Verzeichnissuche </th></tr><?phpif ( $_POST["mode"] ){unset( $_POST["mode"] );}else{unset( $_GET["mode"] );$params = explode( "&", $_GET["params"] );foreach ( $params as $param ){$pos = strpos( $param, "=" );$key = substr( $param, 0, $pos );$value = substr( $param, $pos + 1 );$_POST[$key] = $value;}}foreach ( $_POST as $key => $value ){$return_fields[] = "$key=$value";if ( preg_match( "/status/i", $key ) ){if ( $value == -1 ){unset( $_POST[$key] );}else{$such_sql[] = "$key=$value";}} elseif ( preg_match( "/eigenschaft/i", $key ) || preg_match( "/artikelstamm/i",$key ) ){if ( $value == -1 ){unset( $_POST[$key] );}else{$such_sql[] = "$key=$value";}} elseif ( preg_match( "/id/i", $key ) ){if ( $value == "" ){unset( $_POST[$key] );}else{$such_sql[] = "$key=$value";}}else{if ( $value == "" ){unset( $_POST[$key] );}else{$such_sql[] = "$key LIKE '%$value%'";}}}$such_sql_str = is_array( $such_sql ) ? "WHERE " . implode( " AND ",$such_sql ) : "";$return_str = implode( ";", $return_fields );$sql = "SELECT * FROM directory $such_sql_str";$sql .= ( $_SESSION["language"] ) ? " AND language='" . $_SESSION["language"] ."'" : "";$res = mysql_query( $sql );while ( $row = mysql_fetch_assoc( $res ) ){?><tr><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>;"><a href="directory.php?action=edit&ID=<?= $row["ID"];?>&return=start.php&mode=dir_search¶ms=<?= $return_str;?>"><?php echo$row["Name"];?></a></td></tr><?php}?><tr><td bgcolor="#<?php echo $webs["bgcolor_rechts"]?>" style="color:#<?php echo$webs["font_color_rechts"]?>;"><a href="start.php">zurück zur Suche</a></td></tr><?php}?></table><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td><hr width="100%" align="left"><?php if ( $webs["system_copyright"] ){echo $webs["system_copyright"];}else{?><p align="center"><font face="Arial, Helvetica, sans-serif" size="2">©2007 Webagentur Niewerth</font></p><p align="center"><font face="Arial, Helvetica, sans-serif"><a href="http://www.webagentur-online.de" target="_blank"><img alt="Zur Homepage der Webagentur Niewerth" border="0" src="http://www.webagentur-online.de/images/Logo123x55.jpg" width="123" height="55"></a></font></p><?php }?></td></tr></table><p> </p><p> </p></body></html>