FIX for Aurora SDR 3: Exchange Ads - surf error fix

[eecash]

Noticed this interesting error in the Exchange surf (on SDR3).  If a advertiser country targets an Exchange ad, the surf for the TE still tries to display that ad to a surf, regardless of the user's country.  Therefore, it displays an "Error - you cannot view this ad for this country" or something similar.

THIS IS FIXED IN THE 6-15-11 Update

To fix this, go to gpt.php in the main public_html or www folder and add this line anywhere between line 77 and 83.  EXAMPLE BELOW

before adding the fix
   $sql = $Db1->query("SELECT id FROM ".$adTables[$type]." WHERE
      credits>=1
      and active='1'
      and (daily_limit>views_today or daily_limit=0)
      and (upgrade='0' ".($thismemberinfo[type]==1?" or upgrade='1'":"").")
       ");

After adding the fix
   $sql = $Db1->query("SELECT id FROM ".$adTables[$type]." WHERE
      credits>=1
      and active='1'
      and (country='' or country='$thismemberinfo[country]')
      and (daily_limit>views_today or daily_limit=0)
      and (upgrade='0' ".($thismemberinfo[type]==1?" or upgrade='1'":"").")
       ");


This is only important if you use the Click Exchange.  

-----------------------------------

I am the admin of EarnEasyCash.info and from time to time I mess around with the scripts or help others.

[eecash]

If you have multi-country targetting, the edit will be

and (country='' or country like '%$thismemberinfo[country]%')

instead of

and (country='' or country= '$thismemberinfo[country]')

[reider666]

I add changes but still got error :  Error - We are really appologize, this ads not allowed to be viewed from your country!

[Iriss]

I have this problem with exchange ads: I have there 5 ads (all are mine), 3 are for all countries, 2 are for CZ/SK only. Im CZ. I can see the 3 ads for all countries but I cant see the 2 CZ/SK ads, it returns me back to Earnings area. I tried it with another CZ account and its the same. I should see all ads because Im CZ.

And another problem: I should not see my own ads.

Any fix for this?

[ayman20068]

I have this problem with exchange ads: I have there 5 ads (all are mine), 3 are for all countries, 2 are for CZ/SK only. Im CZ. I can see the 3 ads for all countries but I cant see the 2 CZ/SK ads, it returns me back to Earnings area. I tried it with another CZ account and its the same. I should see all ads because Im CZ.

And another problem: I should not see my own ads.

Any fix for this?

please post the file named gpt.php

And another problem: I should not see my own ads.

that's not default thing in the script you need to modify your script for this , it's explained in this post :
http://auroraadmintraining.info/index.php/topic,596.0.html