Supertracker

[Scrat]

I am having the same issue, duplicate entries of the same cart. StarBuck & PatF have you got several countries under the same ISO ref.

I have as with StarBuck the Big Royal mail mod installed and to get Jersey/Guernsey the same postal prices I have used the ISO code GBR/GB which gets around this issue, but for this mod it causes dupilcated results, as I see it it is part of the code that calls the list using the iso code so I will have three copies of the same cart becuse I have three entries of GBR/GB in countries.

$lt_query = "SELECT s.*, c.countries_name, s.country_code
                                     FROM " . TABLE_SUPERTRACKER . " s
                                         LEFT JOIN " . TABLE_COUNTRIES . " c ON (c.countries_iso_code_2 = s.country_code)" .
                                     $where . "
                                     ORDER BY last_click DESC
                                     LIMIT " . $offset . ", 10"; 

Any ideas on how we can get around this ?