OpenCart 🇺🇦

$type_sql = '';
if($type !== '') {
	$type_sql = "WHERE `type` = '".(int)$type."'";
}

$qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "ebay_profile`".$type_sql);

if($qry->num_rows) {
	$profiles = array();
	foreach($qry->rows as $row) {
		$row['link_edit']   = HTTPS_SERVER . 'index.php?route=openbay/ebay_profile/edit&token=' . $this->session->data['token'].'&ebay_profile_id='.$row['ebay_profile_id'];
		$row['link_delete'] = HTTPS_SERVER . 'index.php?route=openbay/ebay_profile/delete&token=' . $this->session->data['token'].'&ebay_profile_id='.$row['ebay_profile_id'];
		$row['data']        = unserialize($row['data']);
		$profiles[]         = $row;
	}

	return $profiles;
}else{
	return false;
}