OpenCart Community

Code: Select all

AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "'

Code: Select all

AND o.store_id = '" . (int)$this->config->get('config_store_id') . "' AND o.language_id = dd.language_id AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "'

Code: Select all

AND d.download_id = '" . (int)$download_id . "'

Code: Select all

AND o.language_id = '" . (int)$this->config->get('config_language_id') . "' AND d.download_id = '" . (int)$download_id . "'

Code: Select all

WHERE o.customer_id = '" . (int)$this->customer->getId() . "' AND (" . implode(" OR ", $implode) . ")

Code: Select all

WHERE o.language_id = '" . (int)$this->config->get('config_language_id') . "' AND o.store_id = '" . (int)$this->config->get('config_store_id') . "' AND o.customer_id = '" . (int)$this->customer->getId() . "' AND (" . implode(" OR ", $implode) . ")

Code: Select all

'download_id' => $download['download_id'],

Code: Select all

'product_id'  => $download['product_id'],

Code: Select all

public function getOrderOptions($order_id, $order_product_id) {
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product_id . "'");

		return $query->rows;
	}

Code: Select all

public function getOrderDownload($filter_data) {
		$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_download` WHERE `download_id` = '" . (int)$filter_data['download_id'] . "', `order_id` = '" . (int)$filter_data['order_id'] . "', `store_id` = '" . (int)$filter_data['store_id'] . "'");
	}

Code: Select all

foreach ($product['option'] as $option) {
					$this->db->query("INSERT INTO " . DB_PREFIX . "order_option SET order_id = '" . (int)$order_id . "', order_product_id = '" . (int)$order_product_id . "', product_option_id = '" . (int)$option['product_option_id'] . "', product_option_value_id = '" . (int)$option['product_option_value_id'] . "', name = '" . $this->db->escape($option['name']) . "', `value` = '" . $this->db->escape($option['value']) . "', `type` = '" . $this->db->escape($option['type']) . "'");
				}
				

Code: Select all

foreach ($product['download'] as $download) {
					if ((int)$download['product_id'] == (int)$product['product_id']) {
						this->db->query("INSERT INTO `" . DB_PREFIX . "order_download` SET `download_id` = '" . (int)$download['download_id'] . "', `order_id` = '" . (int)$order_id . "', `store_id` = '" . (int)$data['store_id'] . "'");
					}
				}

Code: Select all

DROP TABLE IF EXISTS `oc_order_download`;
CREATE TABLE IF NOT EXISTS `oc_order_download` (
  `order_download_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `download_id` int(11) NOT NULL,
  PRIMARY KEY (`order_download_id`,`order_id`,`store_id`,`download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;