seem to work as expected

Code: Select all

<?php
namespace Opencart\Catalog\Model\Extension\Rest\Setting;

class Api extends \Opencart\System\Engine\Model {
    public function getApiByToken(string $token): array {
        $query = $this->db->query("SELECT DISTINCT * FROM `" . DB_PREFIX . "api` a LEFT JOIN `" . DB_PREFIX . "api_session` `as` ON (a.`api_id` = `as`.`api_id`) LEFT JOIN `" . DB_PREFIX . "api_ip` ai ON (a.`api_id` = ai.`api_id`) WHERE a.`status` = '1' AND `as`.`session_id` = '" . $this->db->escape((string)$token) . "'");
        return $query->row;
    }
}

Code: Select all

<?php
namespace Opencart\Catalog\Controller\Extension\Rest\Setting;

class Api extends \Opencart\System\Engine\Controller {

	public function eventModelSettingApiGetApiTokenAfter(string &$route, array &$args, mixed &$output): void {
		$token = $args[0];
        $query = $this->db->query("SELECT DISTINCT * FROM `" . DB_PREFIX . "api` a LEFT JOIN `" . DB_PREFIX . "api_session` `as` ON (a.`api_id` = `as`.`api_id`) LEFT JOIN `" . DB_PREFIX . "api_ip` ai ON (a.`api_id` = ai.`api_id`) WHERE a.`status` = '1' AND `as`.`session_id` = '" . $this->db->escape((string)$token) . "'");
        $output = $query->row;
    }
}