OpenCart 🇺🇦

$profile = array();

$result = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_recurring WHERE order_recurring_id = " . (int)$order_recurringId)->row;

if ($result) {

	$profile = array(
		'order_recurring_id' => $result['order_recurring_id'],
		'order_id' => $result['order_id'],
		'status' => $this->getStatus($result['status']),
		'status_id' => $result['status'],
		'profile_id' => $result['profile_id'],
		'profile_name' => $result['profile_name'],
		'profile_description' => $result['profile_description'],
		'profile_reference' => $result['profile_reference'],
		'product_name' => $result['product_name'],
		'product_quantity' => $result['product_quantity'],
	);
}

return $profile;