[MOD] - How to display downloads when using Free Checkout

Code: Select all

	public function getDownload($order_download_id) {
	
	   $q="SELECT * FROM " . DB_PREFIX . "order_download od LEFT JOIN `" . 
        DB_PREFIX . "order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '" . 
        (int)$this->customer->getId(). 
        "' AND o.order_status_id > '0'  AND (o.order_status_id = '" . 
        (int)$this->config->get('config_download_status') . 
        "'  OR  o.payment_method = 'Free Checkout')  AND od.order_download_id = '" . 
        (int)$order_download_id . "' AND od.remaining > 0";
 	 
		$query = $this->db->query($q);
		 
		return $query->row;
	}

Code: Select all

	public function getDownloads($start = 0, $limit = 20) {
		if ($start < 0) {
			$start = 0;
		}
 
        $q="SELECT o.order_id, o.date_added, od.order_download_id, od.name, od.filename, od.remaining FROM " . 
            DB_PREFIX . "order_download od LEFT JOIN `" . 
            DB_PREFIX . "order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '" . 
            (int)$this->customer->getId() . 
            "' AND o.order_status_id > '0' ".
            " AND (o.order_status_id = '" . 
            (int)$this->config->get('config_download_status') . 
            "' OR  o.payment_method = 'Free Checkout') ".
            "ORDER BY o.date_added DESC LIMIT " . 
            (int)$start . "," . (int)$limit;
 
        $query = $this->db->query($q); 		 
		//$query = $this->db->query("SELECT o.order_id, o.date_added, od.order_download_id, od.name, od.filename, od.remaining FROM " . DB_PREFIX . "order_download od LEFT JOIN `" . DB_PREFIX . "order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND o.order_status_id > '0' AND o.order_status_id = '" . (int)$this->config->get('config_download_status') . "' ORDER BY o.date_added DESC LIMIT " . (int)$start . "," . (int)$limit);     
 
		return $query->rows;
	}