[Help] Affliate tracking autocomplete from name to model

OnNets wrote:
Plus when typing the name for example bodycon, a list of products contain the word shows up. BUT when typing the model number for example 112, nothing show up until you finish typing the entire model number.

$sql .= " OR LCASE(p.model) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";

$sql .= " OR LCASE(p.model) LIKE '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'";

** Do you know why there are 2 symbol for the tracking?
The symbol & and ? - will both works?
my homepage link is http://www.bolomie.com/&tracking=stenno
my product link is http://www.bolomie.com/1129284507?tracking=stenno

By the way, planing to buy your account and affiliate combine into one. But need to see how it actually works. I have tried your demo but stuck at adding the commission.

This is line 106:

Code: Select all

$sql .= " OR LCASE(p.model) = '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "'";

replace it with:

Code: Select all

$sql .= " OR LCASE(p.model) LIKE '" . $this->db->escape(utf8_strtolower($data['filter_name'])) . "%'";

? must be in the beginning of query string and & used to add more variables, not the first one.
http://www.bolomie.com/&tracking=stenno is incorrect but most likely will still work
http://www.bolomie.com/1129284507?tracking=stenno is correct

What is the problem with adding commission? This module doesn't do anything with commissions, except the feature to transfer earnings to customer account as store credits.

As you can see there are some blank space between the products. I think those are products that have been disable. How to code it to remove just like typing the name?

Can you teach me how to code it correctly? I know where the files is and I copy from http://forum.opencart.com/viewtopic.php ... 37#p210597. Since you say it is incorrect, can you teach me?

Actually I have create a test account with the name 'abc aaa'. I have bought an item from the tracking link with a guest checkout. In the admin, I can see from the order that there is a $5.00 commission. but I cannot add it to proceed to the next step. What I want to see is that the function of transfer earnings to customer account as store credits. If you know what I mean.

One more thing, do you know how to code the tracking code to use the affiliate's first name instead of randomly?

		$_res = $this->db->query("SELECT * FROM " . DB_PREFIX . "affiliate WHERE email = '" . $this->db->escape($data['email']) . "'");
		$affiliate = $_res->row;
		if($affiliate['firstname']) {
			$new_code = html_entity_decode($affiliate['firstname'], ENT_QUOTES, 'UTF-8');			
			$old_locale = setlocale(LC_CTYPE, '0');
			if(strtolower($old_locale) == 'c' || strtolower($old_locale) == 'posix') {
				setlocale(LC_CTYPE, 'en_US');
			} else {
				$old_locale = false;
			}
			$new_code = iconv('UTF-8', 'ASCII//TRANSLIT', $new_code);
			if($old_locale !== false) setlocale(LC_CTYPE, $old_locale);			
			$new_code = preg_replace("/[^a-z0-9]+/", '', strtolower($new_code));
			$__i = 0;
			$new_code_src = $new_code;
			while(true) {
				$_res = $this->db->query("SELECT affiliate_id from " . DB_PREFIX . "affiliate WHERE `code`='" . $this->db->escape($new_code) . "'");
				if($_res->num_rows < 1) break;
				$__i++;				
				$new_code = $new_code_src . $__i;
			}
			$affiliate['code'] = $new_code;
			$this->db->query("UPDATE " . DB_PREFIX . "affiliate SET `code`='" . $this->db->escape($new_code) . "' WHERE affiliate_id='" . (int)$affiliate['affiliate_id'] . "'");
		}