OpenCart 🇺🇦

$this->config = $registry->get('config');
$this->db = $registry->get('db');
$this->request = $registry->get('request');
$this->session = $registry->get('session');

if (isset($this->session->data['affiliate_id'])) { 
	$affiliate_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE affiliate_id = '" . (int)$this->session->data['affiliate_id'] . "' AND status = '1'");

	if ($affiliate_query->num_rows) {
		$this->affiliate_id = $affiliate_query->row['affiliate_id'];
		$this->firstname = $affiliate_query->row['firstname'];
		$this->lastname = $affiliate_query->row['lastname'];
		$this->email = $affiliate_query->row['email'];
		$this->telephone = $affiliate_query->row['telephone'];
		$this->fax = $affiliate_query->row['fax'];
		$this->code = $affiliate_query->row['code'];

		$this->db->query("UPDATE " . DB_PREFIX . "affiliate SET ip = '" . $this->db->escape($this->request->server['REMOTE_ADDR']) . "' WHERE affiliate_id = '" . (int)$this->session->data['affiliate_id'] . "'");
	} else {
		$this->logout();
	}
}