| 1 |
lars |
1 |
<?
|
|
|
2 |
$self = basename( $PHP_SELF );
|
|
|
3 |
$DB = "artikel";
|
|
|
4 |
define( "modul_name", "online_shop" );
|
|
|
5 |
define( "tool_name", "eBay" );
|
|
|
6 |
require_once "connect2.php";
|
|
|
7 |
?>
|
|
|
8 |
<html>
|
|
|
9 |
<head>
|
|
|
10 |
<title><? echo $webs[kunde_bezeichnung] ?>: Redaktionssystem</title>
|
|
|
11 |
<meta http-equiv="Content-Type" content="text/html; charset=<? echo $charset ?>">
|
|
|
12 |
<link rel="stylesheet" type="text/css" href="redaktion.css">
|
|
|
13 |
</head>
|
|
|
14 |
<body bgcolor="#<? echo $webs[bgcolor_seite]; ?>" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#000000">
|
|
|
15 |
<center>
|
|
|
16 |
<table border="0" cellspacing="5" cellpadding="2">
|
|
|
17 |
<tr>
|
|
|
18 |
<td align="center" valign="middle" bgcolor="#FF0000"><a href="javascript:;" onclick="window.open('eBay/index.php?artikel_ID=<?= $ID ?>','','status=no,width=1010,height=700,scrollbars=yes')"><img src="../images/ebayLogo.gif" width="32" border="0"></a></td>
|
|
|
19 |
</tr>
|
|
|
20 |
<tr>
|
|
|
21 |
<td align="center" valign="middle" nowrap>
|
|
|
22 |
<a href="eBay/Auktionen.php" target="_parent"><?
|
|
|
23 |
$query = "
|
|
|
24 |
SELECT
|
|
|
25 |
if (EndTime < NOW(),'finished',if (EndTime is NULL,'waiting','running')) as status,
|
|
|
26 |
count(*) as statusCount
|
|
|
27 |
FROM
|
|
|
28 |
eBay_Auktionen
|
|
|
29 |
LEFT JOIN
|
|
|
30 |
eBay_AuktionsDaten
|
|
|
31 |
ON
|
|
|
32 |
eBay_Auktionen.eBay_Id = eBay_AuktionsDaten.Id
|
|
|
33 |
GROUP BY
|
|
|
34 |
status
|
|
|
35 |
ORDER BY
|
|
|
36 |
status
|
|
|
37 |
DESC
|
|
|
38 |
";
|
|
|
39 |
if ( $result = mysql_query( $query ) )
|
|
|
40 |
{
|
|
|
41 |
while ( $zeile = mysql_fetch_assoc( $result ) )
|
|
|
42 |
{
|
|
|
43 |
?>[ <?= $zeile[statusCount]; ?> ]<br><?
|
|
|
44 |
}
|
|
|
45 |
}
|
|
|
46 |
?></a>
|
|
|
47 |
</td>
|
|
|
48 |
</tr>
|
|
|
49 |
</table>
|
|
|
50 |
</center>
|
|
|
51 |
</body>
|
|
|
52 |
</html>
|