OpenCart 🇺🇦

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

$qry = $this->db->query("SELECT `length_class_id` FROM `" . DB_PREFIX . "length_class_description` WHERE LCASE(`title`) = '".$this->db->escape(strtolower($name))."' LIMIT 1");

if($qry->num_rows) {
	$this->openbay->ebay->log('Checking length class exists');
	return $qry->row['length_class_id'];
}else{
	$this->openbay->ebay->log('New length class');

	$this->db->query("INSERT INTO `" . DB_PREFIX . "length_class` SET `value` = '1'");

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

	$this->db->query("INSERT INTO `" . DB_PREFIX . "length_class_description` SET `language_id` = '".(int)$this->config->get('config_language_id')."', `length_class_id` = '" . (int)$id . "', `title` = '".$this->db->escape(htmlspecialchars($name, ENT_COMPAT))."', `unit` = '".$this->db->escape(htmlspecialchars($name, ENT_COMPAT))."'");

	return $id;
}