Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
    $self = basename( $PHP_SELF );
3 
    define( "modul_name", "online_shop" );
4 
    define( "tool_name", "language" );
5 
    define( "native_language", "DE" );
6 
 
7 
    require_once  "connect2.php";
8 
    session_start();
9 
 
10 
    if ( !$_SESSION["language"] )
11 
    {
12 
        require_once "language_pack.php";
13 
        //		$_SESSION[language]=native_language;
14 
        $_SESSION["language"] = $language_pack[0][0];
15 
        $language = $_SESSION["language"];
16 
    }
17 
    if ( !$_SESSION["language"] )
18 
    {
19 
        $_SESSION["language"] = native_language;
20 
    }
21 
?>
22 
<html>
23 
<head>
24 
<title><?php echo $webs["kunde_bezeichnung"]
25 
?>: Redaktionssystem</title>
26 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
27 
<link rel=stylesheet type="text/css" href="redaktion.css">
28 
<style type="text/css">
29 
body
30 
{
31 
	font-family: Arial, Helvetica, sans-serif; font-size: 10pt;
32 
<?php if ( $webs["font_color_seite"] )
33 
    {
34 
?>color:				#<?php echo $webs["font_color_seite"]
35 
?>;<?php }
36 
?>
37 
<?php if ( $webs["bgcolor_seite"] )
38 
    {
39 
?>background-color:	#<?php echo $webs["bgcolor_seite"]
40 
?>;<?php }
41 
?>
42 
<?php if ( $webs["hintergrundbild"] )
43 
    {
44 
?>background-image: url(../images/hintergrundbild/<?php echo $webs["hintergrundbild"]
45 
?>);<?php }
46 
?>
47 
}
48 
 
49 
.links
50 
{
51 
font-size: 10pt;
52 
<?php if ( $webs["font_color_links"] )
53 
    {
54 
?>color:				#<?php echo $webs["font_color_links"]
55 
?>;<?php }
56 
?>
57 
<?php if ( $webs["bgcolor_links"] )
58 
    {
59 
?>background-color:	#<?php echo $webs["bgcolor_links"]
60 
?>;<?php }
61 
?>
62 
}
63 
 
64 
.rechts
65 
{
66 
font-size: 10pt;
67 
<?php if ( $webs["font_color_rechts"] )
68 
    {
69 
?>color:				#<?php echo $webs["font_color_rechts"]
70 
?>;<?php }
71 
?>
72 
<?php if ( $webs["bgcolor_rechts"] )
73 
    {
74 
?>background-color:	#<?php echo $webs["bgcolor_rechts"]
75 
?>;<?php }
76 
?>
77 
}
78 
 
79 
A:link {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo
80 
    $webs["font_color_rechts"]
81 
?>}
82 
A:visited {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo
83 
    $webs["font_color_rechts"]
84 
?>}
85 
A:active {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo
86 
    $webs["font_color_rechts"]
87 
?>}
88 
A:hover {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<?php echo
89 
    $webs["font_color_rechts"]
90 
?>}
91 
</style>
92 
<style type="text/css">
93 
<!--
94 
table.input
95 
{
96 
	border-width: 2px 1px 1px 2px;
97 
	border-top-color    : #CCCCCC;
98 
	border-left-color   : #CCCCCC;
99 
	border-bottom-color : #AAAAAA;
100 
	border-right-color  : #AAAAAA;
101 
	border-style		:inset;
102 
	background-color	: #FFFFFF;
103 
}
104 
-->
105 
</style>
106 
</head>
107 
 
108 
<body style="margin-left:20px;margin-top:10px;" marginwidth="20" marginheight="10" bgcolor="#<?php echo
109 
    $webs[bgcolor_seite]
110 
?>" text="#<?php echo $webs[font_color_seite]
111 
?>">
112 
<p><font face="Arial, Helvetica, sans-serif" size="2"><b>
113 
  <?php echo $webs[kunde_begruessung]
114 
?>
115 
  </b></font></p>
116 
<?php
117 
    if ( isset( $user_rechte["online_shop"]["language"] ) )
118 
    {
119 
?>
120 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
121 
<tr>
122 
    <td><hr width="100%" align="left">
123 
      <font face="Arial, Helvetica, sans-serif" size="2"><b><br>
124 
      Bitte wählen Sie eine Sprache:</b></font><br><br>
125 
</td>
126 
</tr>
127 
  <tr>
128 
    <td>
129 
<table border="0" cellspacing="5" cellpadding="2">
130 
<?php require_once "language_pack.php";
131 
?>
132 
<?php
133 
        $flaggen_pro_zeile = 10;
134 
        if ( count( $language_pack ) < $flaggen_pro_zeile )
135 
        {
136 
            $flaggen_pro_zeile = count( $language_pack );
137 
        }
138 
        $zeilen = count( $language_pack ) / $flaggen_pro_zeile;
139 
        for ( $j = 0; $j < $zeilen; $j++ )
140 
        {
141 
?>
142 
<tr>
143 
<?php
144 
            for ( $i = 0; $i < $flaggen_pro_zeile; $i++ )
145 
            {
146 
                $index = ( $j * $flaggen_pro_zeile ) + $i;
147 
?>
148 
	<td align="center" valign="middle"<?php if ( $language == $language_pack[$index][0] )
149 
                {
150 
?> bgcolor="#FF0000"<?php }
151 
?>><a href="select_language.php?language=<?php echo
152 
                $language_pack[$index][0]
153 
?>"><img src="../images/Online-Shop/language/<?php echo
154 
                $language_pack[$index][1]
155 
?>" alt="<?php echo $language_pack[$index][2]
156 
?>" width="32" height="22" border="0"></a></td>
157 
<?php
158 
            }
159 
?>
160 
</tr>
161 
<?php
162 
        }
163 
?>
164 
</table>
165 
    </td>
166 
  </tr>
167 
<?
168 
    }
169 
?>
170 
<table>
171 
  <?php
172 
    if ( !$_POST["mode"] && !$_GET["mode"] )
173 
    {
174 
?>
175 
  <tr>
176 
  	<th>
177 
		Artikelsuche    </th>
178 
  </tr>
179 
  <tr>
180 
  	<td>
181 
		<form method="post">
182 
		<table border="0" cellspacing="0" cellpadding="0">
183 
			<tr valign="top" bgcolor="#<?php echo $webs["bgcolor_links"]
184 
?>" style="color:#<?php echo
185 
        $webs["font_color_links"]
186 
?>;font-weight:bold;">
187 
				<td width="50%">Feld</td>
188 
				<td width="50%">Suchwert</td>
189 
			</tr>
190 
			<tr>
191 
				<td bgcolor="#<?php echo $webs["bgcolor_links"]
192 
?>" style="color:#<?php echo
193 
        $webs["font_color_links"]
194 
?>;">ID</td>
195 
				<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
196 
?>" style="color:#<?php echo
197 
        $webs["font_color_rechts"]
198 
?>">
199 
					<input type="text" name="ID" value="">				</td>
200 
			</tr>
201 
		<?php
202 
        $sql_p = "SELECT * FROM $database_name.properties WHERE tools=1 AND quick_edit='true' ORDER BY Rang";
203 
        $res_p = mysql_query( $sql_p, $localhost_dbh );
204 
        //echo mysql_error();
205 
        while ( $row_p = mysql_fetch_assoc( $res_p ) )
206 
        {
207 
            $such_felder[] = $row_p;
208 
        }
209 
        $such_felder[] = array( "ID" => "226", "tools" => "1", "name" =>
210 
            "Beschreibung", "interner_name" => "beschreibung_simpel",
211 
            "hidden" => "false", "quickedit" => "true" );
212 
        /*if($_SERVER["REMOTE_ADDR"]=="89.245.130.99")
213 
        {
214 
        var_dump($such_felder);
215 
        }*/
216 
        foreach ( $such_felder as $row_p )
217 
        {
218 
            if ( isset( $user_rechte["online_shop"]["artikel"][$row_p["interner_name"]] ) )
219 
            {
220 
                switch ( $row_p["interner_name"] )
221 
                {
222 
                    case ( preg_match( "/eigenschaft/i", $row_p["interner_name"] ) ==
223 
                            1 ):
224 
                        $type = "radio";
225 
                        break;
226 
                    case ( preg_match( "/status/i", $row_p["interner_name"] ) ==
227 
                            1 ):
228 
                        $type = "select";
229 
                        break;
230 
                    case ( preg_match( "/autoupdate/i", $row_p["interner_name"] ) ==
231 
                            1 ):
232 
                        $type = "";
233 
                        break;
234 
                    default:
235 
                        $type = "text";
236 
                        break;
237 
                }
238 
                if ( $type )
239 
                {
240 
?>
241 
				<tr>
242 
					<td bgcolor="#<?php echo $webs["bgcolor_links"]
243 
?>" style="color:#<?php echo
244 
                    $webs["font_color_links"]
245 
?>;">
246 
				<?php
247 
                    $f_name = $web_rechte["online_shop"]["artikel"][$row_p["interner_name"]];
248 
                    if ( $f_name )
249 
                    {
250 
                        $pos = strrpos( $f_name, ";" );
251 
                        if ( $pos === false )
252 
                        {
253 
                            if ( $f_name[0] == "!" )
254 
                            {
255 
                                $f_name_a = substr( $f_name, 1 );
256 
                            }
257 
                            else
258 
                            {
259 
                                $f_name_a = $f_name;
260 
                            }
261 
                        }
262 
                        else
263 
                        {
264 
                            $f_name_a = $row_p["name"];
265 
                        }
266 
                    }
267 
                    else
268 
                    {
269 
                        $f_name_a = $row_p["name"];
270 
                    }
271 
                    echo $f_name_a;
272 
?>					</td>
273 
					<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
274 
?>" style="color:#<?php echo
275 
                    $webs["font_color_rechts"]
276 
?>">
277 
						<?php
278 
                    switch ( $type )
279 
                    {
280 
                        case "text":
281 
?>
282 
								<input name="<?= $row_p["interner_name"];
283 
?>" value="" type="<?= $type;
284 
?>">
285 
						<?php
286 
                            break;
287 
                        case "radio":
288 
?>
289 
								<input name="<?= $row_p["interner_name"];
290 
?>" value="1" type="<?= $type;
291 
?>">ja&nbsp;&nbsp;
292 
								<input name="<?= $row_p["interner_name"];
293 
?>" value="0" type="<?= $type;
294 
?>">nein&nbsp;&nbsp;
295 
								<input name="<?= $row_p["interner_name"];
296 
?>" value="-1" type="<?= $type;
297 
?>" checked="checked">egal
298 
						<?php
299 
                            break;
300 
                        case "select":
301 
?>
302 
							<select name="<?= $row_p["interner_name"];
303 
?>">
304 
								<option value="-1" selected="selected">egal</option>
305 
						<?php
306 
                            $sql_a = "SELECT * FROM $database_name.webs_properties WHERE properties=" .
307 
                                $row_p["ID"] . " AND webs=" . $webs["ID"];
308 
                            $res_a = mysql_query( $sql_a, $localhost_dbh );
309 
                            //echo mysql_error();
310 
                            $row_a = mysql_fetch_assoc( $res_a );
311 
                            $options = explode( ";", $row_a["Bezeichnung"] );
312 
                            $i = 0;
313 
                            foreach ( $options as $option )
314 
                            {
315 
?>
316 
							<option value="<?= $i++;
317 
?>"><?= $option;
318 
?></option>
319 
						<?php
320 
                            }
321 
?>
322 
							</select>
323 
						<?php
324 
                            break;
325 
                    }
326 
?>					</td>
327 
				</tr>
328 
			<?php
329 
                }
330 
            }
331 
        }
332 
?>
333 
			<tr bgcolor="#<?php echo $webs["bgcolor_links"]
334 
?>" style="color:#<?php echo
335 
        $webs["font_color_links"]
336 
?>;font-weight:bold;">
337 
				<td align="center" colspan="2">
338 
					<input type="hidden" name="mode" value="search">
339 
					<input type="submit" value="Artikel suchen">				</td>
340 
			</tr>
341 
		</table>
342 
		</form>
343 
		<br><br>	</td>
344 
  </tr>
345 
  <tr>
346 
	<th>
347 
		Verzeichnissuche	</th>
348 
  </tr>
349 
  <tr>
350 
  	<td>
351 
		<form method="post">
352 
		<table border="0" cellspacing="0" cellpadding="0">
353 
			<tr valign="top" bgcolor="#<?php echo $webs["bgcolor_links"]
354 
?>" style="color:#<?php echo
355 
        $webs["font_color_links"]
356 
?>;font-weight:bold;">
357 
				<td width="50%">Feld</td>
358 
				<td width="50%">Suchwert</td>
359 
			</tr>
360 
			<tr>
361 
				<td bgcolor="#<?php echo $webs["bgcolor_links"]
362 
?>" style="color:#<?php echo
363 
        $webs["font_color_links"]
364 
?>;">ID</td>
365 
				<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
366 
?>" style="color:#<?php echo
367 
        $webs["font_color_rechts"]
368 
?>">
369 
					<input type="text" name="ID" value="">				</td>
370 
			</tr>
371 
		<?php
372 
        $sql_p = "SELECT * FROM $database_name.properties WHERE tools=31 AND quick_edit='true' ORDER BY Rang";
373 
        $res_p = mysql_query( $sql_p, $localhost_dbh );
374 
        //			echo mysql_error();
375 
        while ( $row_p = mysql_fetch_assoc( $res_p ) )
376 
        {
377 
            if ( isset( $user_rechte["online_shop"]["directory"][$row_p["interner_name"]] ) )
378 
            {
379 
                switch ( $row_p["interner_name"] )
380 
                {
381 
                    case ( preg_match( "/artikelstamm/i", $row_p["interner_name"] ) ==
382 
                            1 ):
383 
                    case ( preg_match( "/eigenshaft/i", $row_p["interner_name"] ) ==
384 
                            1 ):
385 
                        $type = "radio";
386 
                        break;
387 
                    case ( preg_match( "/status/i", $row_p["interner_name"] ) ==
388 
                            1 ):
389 
                        $type = "select";
390 
                        break;
391 
                    case ( preg_match( "/name/i", $row_p["interner_name"] ) ==
392 
                            1 ):
393 
                    case ( preg_match( "/kennung/i", $row_p["interner_name"] ) ==
394 
                            1 ):
395 
                        $type = "text";
396 
                        break;
397 
                    default:
398 
                        $type = "";
399 
                        break;
400 
                }
401 
                if ( $type )
402 
                {
403 
?>
404 
				<tr>
405 
					<td bgcolor="#<?php echo $webs["bgcolor_links"]
406 
?>" style="color:#<?php echo
407 
                    $webs["font_color_links"]
408 
?>;">
409 
				<?php
410 
                    $f_name = $web_rechte["online_shop"]["directory"][$row_p["interner_name"]];
411 
                    if ( $f_name )
412 
                    {
413 
                        $pos = strrpos( $f_name, ";" );
414 
                        if ( !$pos )
415 
                        {
416 
                            if ( $f_name[0] == "!" )
417 
                            {
418 
                                $f_name_a = substr( $f_name, 1 );
419 
                            }
420 
                            else
421 
                            {
422 
                                $f_name_a = $f_name;
423 
                            }
424 
                        }
425 
                        else
426 
                        {
427 
                            $f_name_a = $row_p["interner_name"];
428 
                        }
429 
                    }
430 
                    else
431 
                    {
432 
                        $f_name_a = $row_p["name"];
433 
                    }
434 
                    echo $f_name_a;
435 
?>					</td>
436 
					<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
437 
?>" style="color:#<?php echo
438 
                    $webs["font_color_rechts"]
439 
?>">
440 
						<?php
441 
                    switch ( $type )
442 
                    {
443 
                        case "":
444 
                            continue;
445 
                            break;
446 
                        case "text":
447 
?>
448 
								<input name="<?= $row_p["interner_name"];
449 
?>" value="" type="<?= $type;
450 
?>">
451 
						<?php
452 
                            break;
453 
                        case "radio":
454 
?>
455 
								<input name="<?= $row_p["interner_name"];
456 
?>" value="1" type="<?= $type;
457 
?>">ja&nbsp;&nbsp;
458 
								<input name="<?= $row_p["interner_name"];
459 
?>" value="0" type="<?= $type;
460 
?>">nein&nbsp;&nbsp;
461 
								<input name="<?= $row_p["interner_name"];
462 
?>" value="-1" type="<?= $type;
463 
?>" checked="checked">egal
464 
						<?php
465 
                            break;
466 
                        case "select":
467 
?>
468 
							<select name="<?= $row_p["interner_name"];
469 
?>">
470 
								<option value="-1" selected="selected">egal</option>
471 
						<?php
472 
                            $sql_a = "SELECT * FROM $database_name.webs_properties WHERE properties=" .
473 
                                $row_p["ID"] . " AND webs=" . $webs["ID"];
474 
                            $res_a = mysql_query( $sql_a, $localhost_dbh );
475 
                            //							echo mysql_error();
476 
                            $row_a = mysql_fetch_assoc( $res_a );
477 
                            $i = 0;
478 
                            $options = explode( ";", $row_a["Bezeichnung"] );
479 
                            foreach ( $options as $option )
480 
                            {
481 
?>
482 
							<option value="<?= $i;
483 
?>"><?= $option;
484 
?></option>
485 
						<?php
486 
                                $i++;
487 
                            }
488 
?>
489 
							</select>
490 
						<?php
491 
                            break;
492 
                    }
493 
?>					</td>
494 
				</tr>
495 
			<?php
496 
                }
497 
            }
498 
        }
499 
?>
500 
			<tr bgcolor="#<?php echo $webs["bgcolor_links"]
501 
?>" style="color:#<?php echo
502 
        $webs["font_color_links"]
503 
?>;font-weight:bold;">
504 
				<td align="center" colspan="2">
505 
					<input type="hidden" name="mode" value="dir_search">
506 
					<input type="submit" value="Verzeichnis suchen">				</td>
507 
			</tr>
508 
		</table>
509 
		</form>
510 
		<br><br>	</td>
511 
  </tr>
512 
  <?php
513 
    } elseif ( $_GET["mode"] == "search" || $_POST["mode"] == "search" )
514 
    {
515 
?>
516 
  <tr>
517 
  	<th>
518 
		Ergebnis der Artikelsuche    </th>
519 
  </tr>
520 
	<?php
521 
        if ( $_POST["mode"] )
522 
        {
523 
            unset( $_POST["mode"] );
524 
        }
525 
        else
526 
        {
527 
            unset( $_GET["mode"] );
528 
            $params = explode( ";", $_GET["params"] );
529 
            foreach ( $params as $param )
530 
            {
531 
                $pos = strpos( $param, "=" );
532 
                $key = substr( $param, 0, $pos );
533 
                $value = substr( $param, $pos + 1 );
534 
                $_POST[$key] = $value;
535 
            }
536 
        }
537 
        foreach ( $_POST as $key => $value )
538 
        {
539 
            $return_fields[] = "$key=$value";
540 
            if ( preg_match( "/status/i", $key ) )
541 
            {
542 
                if ( $value == -1 )
543 
                {
544 
                    unset( $_POST[$key] );
545 
                }
546 
                else
547 
                {
548 
                    $such_sql[] = "$key=$value";
549 
                }
550 
            } elseif ( preg_match( "/eigenschaft/i", $key ) )
551 
            {
552 
                if ( $value == -1 )
553 
                {
554 
                    unset( $_POST[$key] );
555 
                }
556 
                else
557 
                {
558 
                    $such_sql[] = "$key=$value";
559 
                }
560 
            } elseif ( preg_match( "/id/i", $key ) )
561 
            {
562 
                if ( $value == "" )
563 
                {
564 
                    unset( $_POST[$key] );
565 
                }
566 
                else
567 
                {
568 
                    $such_sql[] = "$key=$value";
569 
                }
570 
            } elseif ( stristr( $key, "beschreibung_simpel" ) )
571 
            {
572 
                if ( $value == "" )
573 
                {
574 
                    unset( $_POST[$key] );
575 
                }
576 
                else
577 
                {
578 
                    $such_sql[] = "beschreibung LIKE '%$value%'";
579 
                }
580 
            }
581 
            else
582 
            {
583 
                if ( $value == "" )
584 
                {
585 
                    unset( $_POST[$key] );
586 
                }
587 
                else
588 
                {
589 
                    $such_sql[] = "$key LIKE '%$value%'";
590 
                }
591 
            }
592 
        }
593 
        $such_sql_str = is_array( $such_sql ) ? "AND " . implode( " AND ", $such_sql ) :
594 
            "";
595 
        $return_str = implode( ";", $return_fields );
596 
        $sql = "SELECT * FROM artikel WHERE Father !=-3 $such_sql_str";
597 
        $sql .= ( $_SESSION["language"] ) ? " AND language='" . $_SESSION["language"] .
598 
            "'" : "";
599 
        $res = mysql_query( $sql );
600 
        //		echo mysql_error()."<br>$sql";
601 
        while ( $row = mysql_fetch_assoc( $res ) )
602 
        {
603 
?>
604 
			<tr>
605 
				<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
606 
?>" style="color:#<?php echo
607 
            $webs["font_color_rechts"]
608 
?>;"><a href="artikel.php?action=edit&ID=<?= $row["ID"];
609 
?>&return=start.php&mode=search&params=<?= $return_str;
610 
?>"><?php echo
611 
            $row["kurzbezeichnung"];
612 
?></a></td>
613 
			</tr>
614 
		<?php
615 
        }
616 
?>
617 
            <tr>
618 
                <td bgcolor="#<?php echo $webs["bgcolor_rechts"]
619 
?>" style="color:#<?php echo
620 
        $webs["font_color_rechts"]
621 
?>;"><a href="start.php">zur&uuml;ck zur Suche</a></td>
622 
  </tr>
623 
   <?php
624 
    } elseif ( $_GET["mode"] == "dir_search" || $_POST["mode"] == "dir_search" )
625 
    {
626 
?>
627 
  <tr>
628 
  	<th>
629 
		Ergebnis der Verzeichnissuche    </th>
630 
  </tr>
631 
	<?php
632 
        if ( $_POST["mode"] )
633 
        {
634 
            unset( $_POST["mode"] );
635 
        }
636 
        else
637 
        {
638 
            unset( $_GET["mode"] );
639 
            $params = explode( "&", $_GET["params"] );
640 
            foreach ( $params as $param )
641 
            {
642 
                $pos = strpos( $param, "=" );
643 
                $key = substr( $param, 0, $pos );
644 
                $value = substr( $param, $pos + 1 );
645 
                $_POST[$key] = $value;
646 
            }
647 
        }
648 
        foreach ( $_POST as $key => $value )
649 
        {
650 
            $return_fields[] = "$key=$value";
651 
            if ( preg_match( "/status/i", $key ) )
652 
            {
653 
                if ( $value == -1 )
654 
                {
655 
                    unset( $_POST[$key] );
656 
                }
657 
                else
658 
                {
659 
                    $such_sql[] = "$key=$value";
660 
                }
661 
            } elseif ( preg_match( "/eigenschaft/i", $key ) || preg_match( "/artikelstamm/i",
662 
            $key ) )
663 
            {
664 
                if ( $value == -1 )
665 
                {
666 
                    unset( $_POST[$key] );
667 
                }
668 
                else
669 
                {
670 
                    $such_sql[] = "$key=$value";
671 
                }
672 
            } elseif ( preg_match( "/id/i", $key ) )
673 
            {
674 
                if ( $value == "" )
675 
                {
676 
                    unset( $_POST[$key] );
677 
                }
678 
                else
679 
                {
680 
                    $such_sql[] = "$key=$value";
681 
                }
682 
            }
683 
            else
684 
            {
685 
                if ( $value == "" )
686 
                {
687 
                    unset( $_POST[$key] );
688 
                }
689 
                else
690 
                {
691 
                    $such_sql[] = "$key LIKE '%$value%'";
692 
                }
693 
            }
694 
        }
695 
        $such_sql_str = is_array( $such_sql ) ? "WHERE " . implode( " AND ",
696 
            $such_sql ) : "";
697 
        $return_str = implode( ";", $return_fields );
698 
        $sql = "SELECT * FROM directory $such_sql_str";
699 
        $sql .= ( $_SESSION["language"] ) ? " AND language='" . $_SESSION["language"] .
700 
            "'" : "";
701 
        $res = mysql_query( $sql );
702 
        while ( $row = mysql_fetch_assoc( $res ) )
703 
        {
704 
?>
705 
			<tr>
706 
				<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
707 
?>" style="color:#<?php echo
708 
            $webs["font_color_rechts"]
709 
?>;"><a href="directory.php?action=edit&ID=<?= $row["ID"];
710 
?>&return=start.php&mode=dir_search&params=<?= $return_str;
711 
?>"><?php echo
712 
            $row["Name"];
713 
?></a></td>
714 
  </tr>
715 
		<?php
716 
        }
717 
?>
718 
        	<tr>
719 
				<td bgcolor="#<?php echo $webs["bgcolor_rechts"]
720 
?>" style="color:#<?php echo
721 
        $webs["font_color_rechts"]
722 
?>;"><a href="start.php">zur&uuml;ck zur Suche</a></td>
723 
  </tr>
724 
<?php
725 
    }
726 
?>
727 
</table>
728 
<table width="100%" border="0" cellspacing="0" cellpadding="0">
729 
  <tr>
730 
    <td>
731 
      <hr width="100%" align="left">
732 
<?php if ( $webs["system_copyright"] )
733 
    {
734 
        echo $webs["system_copyright"];
735 
    }
736 
    else
737 
    {
738 
?>
739 
      <p align="center"><font face="Arial, Helvetica, sans-serif" size="2">&copy;
740 
        2007 Webagentur Niewerth</font></p>
741 
      <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>
742 
<?php }
743 
?>
744 
</td>
745 
  </tr>
746 
</table>
747 
<p>&nbsp;</p>
748 
<p>&nbsp; </p>
749 
</body>
750 
</html>