Point Ads are coming first and then Cash Ads

[HP]

Hello,

In my Site, in View Ads Page, I had seen that Point ads are coming first then Cash ads are coming. I want that Cash ads should come first then the Point ads...

Is that Possible?

Thanks

[bprasetio]

the view ads concept is not about which come first: points or cash, but the value of the ads.
View Ads page is displayed by sorting ads from highest value to the lowest one by default.

Generally, admins assigned point based ad with the value bigger than 0 (for example: 1, 2, 100, 200, etc) and assigned cash based ad with the value lower than 0 (for example: 0.0025, 0.005, 0.01, etc)
so, this will display the point based first and then cash based ads in the view ads page.
if you set the points to for example 0.0025, 0.005, the ads will be mix displayed.

so, if you want to force to display the cash based ads first you have to modify the script a little bit.
you have to modify members/click.php file
look for the piece of code below, somewhere in the beginning of the file

$sql = $Db1->query("SELECT * FROM ads WHERE
    credits>=1
   and active=1
   and (country='' or country='{$thismemberinfo[country]}')
   and (daily_limit>views_today or daily_limit=0)
   and (upgrade='' or upgrade='1')
   ORDER BY $orderby $type
");

change to

$sql = $Db1->query("(SELECT * FROM ads WHERE
    credits>=1
   and active=1
   and (country='' or country='{$thismemberinfo[country]}')
   and (daily_limit>views_today or daily_limit=0)
   and (upgrade='' or upgrade='1')
   and class <> 'P'
   ORDER BY $orderby $type)
   UNION
   (SELECT * FROM ads WHERE
    credits>=1
   and active=1
   and (country='' or country='{$thismemberinfo[country]}')
   and (daily_limit>views_today or daily_limit=0)
   and (upgrade='' or upgrade='1')
   and class = 'P'
   ORDER BY $orderby $type)
");   

then look for code below:

$sql = $Db1->query("SELECT * FROM ads 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'":"").")
   ORDER BY $orderby $type
");   

and change to:

$sql = $Db1->query("(SELECT * FROM ads 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'":"").")
   and class <> 'P'
   ORDER BY $orderby $type)
   UNION
   (SELECT * FROM ads 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'":"").")
   and class = 'P'
   ORDER BY $orderby $type)
");   

I havent tested it in the live site, so just hope that it works.

[HP]

Thank you soo Much..
That works, but ads are arranging according to time when their are created

Edited:
Is it possible to arrange the ads according to its timer?
I mean first 30 Seconds ads and then 3 Seconds and soo on..

[bprasetio]

in the beginning of the file, look at the

if($orderby == "")    $orderby="pamount";

and change to

if($orderby == "")    $orderby="timed";

Note: this is the default config, if you have modified your view ads page (the way its work), it might not work

[HP]

in the beginning of the file, look at the

if($orderby == "")    $orderby="pamount";

and change to

if($orderby == "")    $orderby="timed";

Note: this is the default config, if you have modified your view ads page (the way its work), it might not work

Thank You AGAIN!
IT WORKS!