| 1 |
lars |
1 |
<?
|
|
|
2 |
function show_dir($root,$Father_name)
|
|
|
3 |
{
|
|
|
4 |
global $artikel_properties;
|
|
|
5 |
global $webs;
|
|
|
6 |
|
|
|
7 |
$query="SELECT * FROM directory where Father = $root and Language='".$_SESSION[language]."' order by Kennung";
|
|
|
8 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
|
|
|
9 |
$rows=mysql_num_rows($result);
|
|
|
10 |
$counter=0;
|
|
|
11 |
|
|
|
12 |
while ($zeile=mysql_fetch_array($result))
|
|
|
13 |
{
|
|
|
14 |
$counter++;
|
|
|
15 |
|
|
|
16 |
$query_artikel_count = "select * from artikel where (status=0) and Father = $zeile[ID] and language='".$_SESSION[language]."' order by Rang, kennung";
|
|
|
17 |
$result_artikel_count = mysql_query ($query_artikel_count) or die (mysql_errno().": ".mysql_error()."<hr>$query_artikel_count<hr>");
|
|
|
18 |
|
|
|
19 |
$title=$Father_name."/".$zeile[Name];
|
|
|
20 |
|
|
|
21 |
if (($_SESSION["tree.php"][nav_status][$zeile[ID]]) or ($_SESSION[Preisagenturen_config][no_status]))
|
|
|
22 |
{
|
|
|
23 |
if (mysql_num_rows($result_artikel_count) > 0)
|
|
|
24 |
{
|
|
|
25 |
?><tr><td colspan="3"><br><? echo $title ?></td></tr><?
|
|
|
26 |
}
|
|
|
27 |
show_artikel($zeile[ID]);
|
|
|
28 |
show_dir($zeile[ID],$Father_name."/".$zeile[Name]);
|
|
|
29 |
}
|
|
|
30 |
}
|
|
|
31 |
}
|
|
|
32 |
|
|
|
33 |
function show_artikel($Father)
|
|
|
34 |
{
|
|
|
35 |
$counter=0;
|
|
|
36 |
$query="select * from artikel where (status='0') and Father = $Father and language='".$_SESSION[language]."' order by Rang, kennung";
|
|
|
37 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
|
|
|
38 |
while ($zeile=mysql_fetch_array($result))
|
|
|
39 |
{
|
|
|
40 |
$counter++
|
|
|
41 |
?>
|
|
|
42 |
<tr class="bg_<? echo $counter % 2 ?>">
|
|
|
43 |
<td><? echo $zeile[kurzbezeichnung] ?></td>
|
|
|
44 |
<td><? if ($zeile[kennung]) {echo $zeile[kennung];} else {echo " ";} ?></td>
|
|
|
45 |
<td><input type="text" name="artikel[<? echo $zeile[ID] ?>]" value="<? echo $zeile[preis1] ?>" onChange="this.value=killkomma(this.value);"></td>
|
|
|
46 |
</tr>
|
|
|
47 |
<?
|
|
|
48 |
}
|
|
|
49 |
}
|
|
|
50 |
|
|
|
51 |
function show_Preisagent($root,$Agentdaten,$Spalten)
|
|
|
52 |
{
|
|
|
53 |
$query="SELECT * FROM directory where Father = $root and Language='".$_SESSION[language]."' order by Kennung";
|
|
|
54 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
|
|
|
55 |
$rows=mysql_num_rows($result);
|
|
|
56 |
|
|
|
57 |
while ($zeile=mysql_fetch_array($result))
|
|
|
58 |
{
|
|
|
59 |
|
|
|
60 |
$query_artikel_count = "select * from artikel where (status=0) and Father = $zeile[ID] and language='".$_SESSION[language]."' order by Rang, kennung";
|
|
|
61 |
$result_artikel_count = mysql_query ($query_artikel_count) or die (mysql_errno().": ".mysql_error()."<hr>$query_artikel_count<hr>");
|
|
|
62 |
|
|
|
63 |
if (($_SESSION["tree.php"][nav_status][$zeile[ID]]) or ($_SESSION[Preisagenturen_config][no_status]))
|
|
|
64 |
{
|
|
|
65 |
if (mysql_num_rows($result_artikel_count) > 0)
|
|
|
66 |
{
|
|
|
67 |
?><tr><td colspan="<? echo count($Spalten); ?>"><br><? if ($Agentdaten[home_url]) { ?><a href="<? echo $Agentdaten[home_url] ?>" target="_blank"><? echo $Agentdaten[Titel] ?></a><? } else { ?> <? } ?></td></tr><?
|
|
|
68 |
unset($Agentdaten[home_url]);
|
|
|
69 |
}
|
|
|
70 |
$counter=0;
|
|
|
71 |
while ($zeile_artikel=mysql_fetch_array($result_artikel_count))
|
|
|
72 |
{
|
|
|
73 |
$counter++
|
|
|
74 |
?>
|
|
|
75 |
<tr class="bg_<? echo $counter % 2 ?>">
|
|
|
76 |
<?
|
|
|
77 |
foreach($Spalten as $elem)
|
|
|
78 |
{
|
|
|
79 |
?>
|
|
|
80 |
<td align="center"><a ID="href_[<? echo $zeile_artikel[ID] ?>][<? echo $Agentdaten[ID]?>][<? echo $elem[ID] ?>]" href="#"><input type="text" name="_[<? echo $zeile_artikel[ID]?>][<? echo $Agentdaten[ID]?>][<? echo $elem[ID] ?>]" class="bg_<? echo $counter % 2 ?>" readonly></a></td>
|
|
|
81 |
<?
|
|
|
82 |
}
|
|
|
83 |
?>
|
|
|
84 |
</tr>
|
|
|
85 |
<?
|
|
|
86 |
}
|
|
|
87 |
show_Preisagent($zeile[ID],$Agentdaten,$Spalten);
|
|
|
88 |
}
|
|
|
89 |
}
|
|
|
90 |
}
|
|
|
91 |
?>
|