Fix for Aurora: Click bonus not working correctly

We have found some errors created when the daily click bonus was rewritten to no longer run through the site settings.

This fix as been added to the SDR 3 October 1, 2011 Update.

1st item to fix:
Go to your members/contest.php file around lines 108 and add what has been added in bold:

if($settings[cbonus_on]==1) {

 $sqlw=$Db1->query("SELECT * FROM cbs WHERE id='1'");
 $tempw = $Db1->fetch_array($sqlw);

 $sqlz=$Db1->query("SELECT * FROM specials WHERE cbonus='1'");
 $tempb = $Db1->fetch_array($sqlz);

 $sqlh=$Db1->query("SELECT * FROM special_benefits WHERE special='$tempb[id]'");
 while($tempz = $Db1->fetch_array($sqlh)) {
 $benefits_speciallist.="

Now go down to line 129 and make it look like this (what is in bold is what changed)

Each day, the members who have clicked at least $tempw[macbonus] ads will receive as follows:

2nd item to fix:
Now you will want to go to your members/profile file to update some of the settings there so the members can see the number of clicks required to get the bonus:

go to line 280, change this line:

$remainads=$settings[min_ads_cbonus]-$thismemberinfo[viewz];

to this, add what is in bold:

$sqlw=$Db1->query("SELECT * FROM cbs WHERE id='1'");
$tempw = $Db1->fetch_array($sqlw);

$remainads=$tempw[macbonus]-$thismemberinfo[viewz];

now go down to lines 619 to 634 and make it look like this (what is in bold has changed):

".iif($settings[cbonus_on]==1,"
 <tr>
 <td colspan=2 class=\"tableHead\">Daily Click Status (PTC, PTR, xChange & eMails)</td>
 </tr>
 <tr>
 <td>Total Ads Count: </td>
 <td>$tempw[tads]</td>
 </tr>
 <tr>
 <td>Min Ads to Click: </td>
 <td>$tempw[macbonus]</td>
 </tr>
 <tr>
 <td>Your total click Today: </td>
 <td>$thismemberinfo[viewz]</td>
 </tr>

3rd item to fix:
Now we go to the actual working of the bonus, go to your source/clicking/verifyClick.php file lines 158 and make it look like this (what is in bold is what was added or changed):

$sqlw=$Db1->query("SELECT * FROM cbs WHERE id='1'");
$tempw = $Db1->fetch_array($sqlw);

$sqll=$Db1->query("SELECT viewz,cbonus FROM user WHERE username='$username'");
$checkusr = $Db1->fetch_array($sqll);
if(($checkusr[viewz] >= $tempw[macbonus]) and ($settings[cbonus_on] == 1) and ($checkusr[cbonus] == 0)) {
$sqlh=$Db1->query("SELECT * FROM special_benefits WHERE special='$settings[cbonus]'");
while($bonus = $Db1->fetch_array($sqlh)) {
$sqls=$Db1->query("UPDATE user SET $bonus[type]=$bonus[type]+$bonus[amount], cbonus='1' WHERE username='$username'");
}
}