OpenCart 🇺🇦

$this->openbay->ebay->log('Checking attribute group: '.$name);
$qry = $this->db->query("SELECT * FROM  `" . DB_PREFIX . "attribute_group_description` WHERE `name` = '".$this->db->escape(htmlspecialchars($name, ENT_COMPAT))."' AND `language_id` = '".(int)$this->config->get('config_language_id')."' LIMIT 1");

if($qry->num_rows) {
	$this->openbay->ebay->log('Group exists');
	return $qry->row['attribute_group_id'];
}else{
	$this->openbay->ebay->log('New group');
	$qry2 = $this->db->query("SELECT `sort_order` FROM  `" . DB_PREFIX . "attribute_group` 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 . "attribute_group` SET `sort_order` = '" . (int)$sort . "'");

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

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

	return $id;
}