OpenCart 🇺🇦

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

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

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

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

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

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

	return $id;
}