SDR 3 listing giving the wrong number of referrals on purchase page

[757jterrell]

The is a bug on the prices page as it list the wrong number of referrals that are avaiable to be sold.

Go to the prices.php file, lines 356 to 360, look for this group of codes:

$sql=$Db1->query("SELECT userid FROM user WHERE last_act>='".(time()-$timeR)."' and coclicks>='$settings[orphan_clicks]' and refered=''");
         $total=$Db1->num_rows();
         
         $sql=$Db1->query("SELECT userid FROM user WHERE refered='' and username!='$username'");
         $totalrefsavailable=$Db1->num_rows();

Change line 359 to be this:

$sql=$Db1->query("SELECT userid FROM user WHERE refered='' last_act>='".(time()-$timeR)."' and coclicks>='$settings[orphan_clicks]' and username!='$username'");

[ayman20068]

  you mean

$sql=$Db1->query("SELECT userid FROM user WHERE refered='' and last_act>='".(time()-$timeR)."' and coclicks>='$settings[orphan_clicks]' and username!='$username'");

you forgot little and   i think

[amidamaru34]

ayman20068 is right

[Buxxer]

I followed this instructions and still get this bug. Don't think I'm too stupid...

Can someone send me the prices.php file with the bug fixed?