mySQLsafe($_REQUEST['username']), $db->mySQLsafe($_REQUEST['password'])); if ($db->numrows($sql) == 1) { ## Authorised ## Generate XML data header('content-type: text/xml'); $xml[] = ''; $xml[] = ''; $xml[] = '1'; ## Get all recent/pending orders $ordersql = sprintf("SELECT cart_order_id, prod_total, time FROM %sCubeCart_order_sum WHERE status = 1 ORDER BY time DESC", $glob['dbprefix']); $xml[] = ''; $xml[] = sprintf('%d', $db->numrows($ordersql)); if ($db->numrows($ordersql) >= 1) { $orders = $db->select($ordersql); $xml[] = ''; foreach ($orders as $order) { $xml[] = sprintf('%s%s', $order['cart_order_id'], $order['prod_total']); } $xml[] = ''; } $xml[] = ''; ## Get all review alerts $reviewsql = sprintf("SELECT time FROM %sCubeCart_reviews WHERE approved = '0'", $glob['dbprefix']); $xml[] = ''; $xml[] = sprintf('%d', $db->numrows($reviewsql)); $xml[] = ''; ## Get all stock warnings if ($config['stock_warn_type'] == 1) { $stocksql = sprintf("SELECT productId, stock_level FROM %sCubeCart_inventory WHERE useStockLevel = '1' AND stock_level < stockWarn ORDER BY stock_level ASC", $glob['dbprefix']); } else { if (!isset($config['stock_warn_level'])) $config['stock_warn_level'] = 5; $stocksql = sprintf("SELECT productId, stock_level FROM %sCubeCart_inventory WHERE useStockLevel = 1 AND stock_level <= %d ORDER BY stock_level ASC", $glob['dbprefix'], $config['stock_warn_level']); } $xml[] = ''; $xml[] = sprintf('%d', $db->numrows($stocksql)); if ($db->numrows($stocksql) >= 1) { $stock = $db->select($stocksql); foreach ($stock as $warning) { //$xml[] = sprintf('%d%d', $warning['productId'], $warning['stock_level']); } } $xml[] = ''; $xml[] = ''; echo implode("\n", $xml); ## All done :) } else { die('Access Denied'); } } else { die('Access Denied'); } ?>