private static function get_basket_info()
{
if (self::$query_complete === false) {
global $connection;
$query = '
SELECT
' . NEW_TABLE_BASKETS . '.basket_id,
' . NEW_TABLE_SITES . '.site_id,
' . NEW_TABLE_SITES . '.site_short,
' . NEW_TABLE_SITES . '.site_long,
' . NEW_TABLE_BASKETS . '.checked_out
FROM
' . NEW_TABLE_BASKETS . '
LEFT JOIN ' . NEW_TABLE_SITES . ' USING(site_id)
WHERE
' . NEW_TABLE_BASKETS . '.delivery_id = "' . mysql_real_escape_string(ActiveCycle::delivery_id()) . '"
AND ' . NEW_TABLE_BASKETS . '.member_id = "' . mysql_real_escape_string($_SESSION['member_id']) . '"';
$result = @mysql_query($query, $connection) or die(debug_print("ERROR: 783032 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__));
if ($row = mysql_fetch_object($result)) {
self::$basket_id = $row->basket_id;
self::$site_id = $row->site_id;
self::$site_short = $row->site_short;
self::$site_long = $row->site_long;
self::$basket_checked_out = $row->checked_out;
self::$query_complete = true;
}
}
}
