OpenCart 🇺🇦

$this->openbay->ebay->log('Checking manufacturer: '.$name);

$qry = $this->db->query("SELECT * FROM  `" . DB_PREFIX . "manufacturer` WHERE LCASE(`name`) = '".$this->db->escape(htmlspecialchars($name, ENT_COMPAT))."' LIMIT 1");

if($qry->num_rows) {
	$this->openbay->ebay->log('Manufacturer exists');
	return $qry->row['manufacturer_id'];
}else{
	$this->openbay->ebay->log('New manufacturer');
	$qry2 = $this->db->query("SELECT `sort_order` FROM  `" . DB_PREFIX . "manufacturer` ORDER BY `sort_order` DESC LIMIT 1");

	if($qry2->num_rows) {
		$sort = $qry2->row['sort_order'] + 1;
	}else{
		$sort = 0;
	}

	$this->db->query("INSERT INTO `" . DB_PREFIX . "manufacturer` SET `sort_order` = '" . (int)$sort . "', `name` = '".$this->db->escape(htmlspecialchars($name, ENT_COMPAT))."'");

	$id = $this->db->getLastId();

	$this->db->query("INSERT INTO `" . DB_PREFIX . "manufacturer_to_store` SET `manufacturer_id` = '" . (int)$id . "', `store_id` = '0'");

	return $id;
}