| 1 |
lars |
1 |
<?
|
|
|
2 |
require_once "connect2.php";
|
|
|
3 |
if ($action)
|
|
|
4 |
{
|
|
|
5 |
$query="replace into artikel_to_Preisagentur values ($artikel,$Preisagentur,'$status','$link',NOW(),'$PHP_AUTH_USER')";
|
|
|
6 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
7 |
?><script language="Javascript">parent.Preisagentur.location.reload();</script><?
|
|
|
8 |
}
|
|
|
9 |
?>
|
|
|
10 |
<html>
|
|
|
11 |
<head>
|
|
|
12 |
<title>Artikel to Preisagentur</title>
|
|
|
13 |
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
|
|
|
14 |
<link rel=stylesheet type="text/css" href="redaktion.css">
|
|
|
15 |
</head>
|
|
|
16 |
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" marginwidth="0" topmargin="0" marginheight="0">
|
|
|
17 |
<?
|
|
|
18 |
if (($Preisagentur) and ($artikel))
|
|
|
19 |
{
|
|
|
20 |
$query="SELECT Preisagentur.Titel from Preisagentur where Preisagentur.ID = $Preisagentur";
|
|
|
21 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
22 |
$zeile_Preisagentur=mysql_fetch_array($result);
|
|
|
23 |
|
|
|
24 |
$query="SELECT * from artikel_to_Preisagentur where Preisagentur = $Preisagentur and artikel = $artikel";
|
|
|
25 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
|
|
|
26 |
$zeile=mysql_fetch_array($result);
|
|
|
27 |
|
|
|
28 |
$erstellt_am=datetime2human($zeile[erstellt_am]);
|
|
|
29 |
$letzte_Aenderung_am=timestamp2human($zeile[letzte_Aenderung_am]);
|
|
|
30 |
?>
|
|
|
31 |
<form action="<? echo $self ?>" method="post">
|
|
|
32 |
<table border="0" cellspacing="0" cellpadding="0" width="100%" height="100%">
|
|
|
33 |
<tr>
|
|
|
34 |
<td valign="top">
|
|
|
35 |
<table border="0" cellspacing="0" cellpadding="3" width="100%">
|
|
|
36 |
<tr>
|
|
|
37 |
<td>
|
|
|
38 |
<? echo $zeile_Preisagentur[Titel] ?>
|
|
|
39 |
- Detailseite</td>
|
|
|
40 |
</tr>
|
|
|
41 |
<tr>
|
|
|
42 |
<td>
|
|
|
43 |
<input type="text" name="link" value="<? echo $zeile[link] ?>">
|
|
|
44 |
<? if ($zeile[link]){ ?>
|
|
|
45 |
<a href="<? echo $zeile[link] ?>" target="_blank"><img src="../images/Online-Shop/globus.gif" width="16" height="16" border="0"></a>
|
|
|
46 |
<? } ?>
|
|
|
47 |
<input type="submit" value="ok">
|
|
|
48 |
<input type="hidden" name="artikel" value="<? echo $artikel ?>">
|
|
|
49 |
<input type="hidden" name="Preisagentur" value="<? echo $Preisagentur ?>">
|
|
|
50 |
<input type="hidden" name="action" value="ok">
|
|
|
51 |
</td>
|
|
|
52 |
</tr>
|
|
|
53 |
<? if ($zeile) { ?>
|
|
|
54 |
<tr>
|
|
|
55 |
<td align=center>
|
|
|
56 |
Artikel wird <? if ($zeile[status] == 1) { ?><b>nicht</b><? } ?> übertragen</td>
|
|
|
57 |
</tr>
|
|
|
58 |
<? } ?>
|
|
|
59 |
</table>
|
|
|
60 |
</td>
|
|
|
61 |
</tr>
|
|
|
62 |
<? if ($zeile) { ?>
|
|
|
63 |
<tr>
|
|
|
64 |
<td valign="bottom">
|
|
|
65 |
<table border="0" cellspacing="0" cellpadding="3" width="100%">
|
|
|
66 |
<tr>
|
|
|
67 |
<td>letzte Änderung am / von:</td>
|
|
|
68 |
</tr>
|
|
|
69 |
<tr>
|
|
|
70 |
<td align="center">
|
|
|
71 |
<? echo $letzte_Aenderung_am[Datum] ?>
|
|
|
72 |
um:
|
|
|
73 |
<? echo $letzte_Aenderung_am[Zeit] ?>
|
|
|
74 |
</td>
|
|
|
75 |
</tr>
|
|
|
76 |
<tr>
|
|
|
77 |
<td align="center">von:
|
|
|
78 |
<? echo $zeile[letzte_Aenderung_von] ?>
|
|
|
79 |
</td>
|
|
|
80 |
</tr>
|
|
|
81 |
</table>
|
|
|
82 |
</td>
|
|
|
83 |
</tr>
|
|
|
84 |
<? } else { ?>
|
|
|
85 |
<tr>
|
|
|
86 |
<td valign="bottom">
|
|
|
87 |
<input type="button" value="Auto-Anmeldung" style="width=100%;" onClick="this.form.link.value='Auto-Anmeldung';this.form.submit();">
|
|
|
88 |
</td>
|
|
|
89 |
</tr>
|
|
|
90 |
<? } ?>
|
|
|
91 |
</table>
|
|
|
92 |
</form>
|
|
|
93 |
<?
|
|
|
94 |
}
|
|
|
95 |
?>
|
|
|
96 |
</body>
|
|
|
97 |
</html>
|