Subversion-Projekte lars-tiefland.content-management

Revision

Blame | Letzte Änderung | Log anzeigen | RSS feed 

<?
    $self = basename( $PHP_SELF );
    $DB = "artikel";
    define( "modul_name", "online_shop" );
    define( "tool_name", "eBay" );
    require_once  "connect2.php";
?>
<html>
<head>
<title><? echo $webs[kunde_bezeichnung] ?>: Redaktionssystem</title>
<meta http-equiv="Content-Type" content="text/html; charset=<? echo $charset ?>">
<link rel="stylesheet" type="text/css" href="redaktion.css">
</head>
<body bgcolor="#<? echo $webs[bgcolor_seite]; ?>" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#000000">
<center>
<table border="0" cellspacing="5" cellpadding="2">
  <tr> 
    <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>
  </tr>
  <tr> 
    <td align="center" valign="middle" nowrap> 
<a href="eBay/Auktionen.php" target="_parent"><?
    $query = "
                        SELECT
                                if (EndTime < NOW(),'finished',if (EndTime is NULL,'waiting','running')) as status,
                                count(*) as statusCount
                        FROM
                                eBay_Auktionen
                        LEFT JOIN
                                eBay_AuktionsDaten
                        ON
                                eBay_Auktionen.eBay_Id = eBay_AuktionsDaten.Id
                        GROUP BY
                                status
                        ORDER BY
                                status
                        DESC
        ";
    if ( $result = mysql_query( $query ) )
    {
        while ( $zeile = mysql_fetch_assoc( $result ) )
        {
?>[&nbsp;<?= $zeile[statusCount]; ?>&nbsp;]<br><?
        }
    }
?></a>
    </td>
  </tr>
</table>
</center>
</body>
</html>