Auto Site Rating

[Chris2k]

here's my working modified code:

        mysql_query("UPDATE wcddl_sites SET rate=1");

        $get1600 = mysql_query("SELECT COUNT(title) AS 'number' , sid FROM wcddl_downloads GROUP BY sid ORDER BY number DESC LIMIT 1600");
        while ($row = mysql_fetch_array($get1600)) {
        mysql_query("UPDATE wcddl_sites SET rate=4 where id = '".$row['sid']."'"); }
        
        $get420 = mysql_query("SELECT COUNT(title) AS 'number' , sid FROM wcddl_downloads GROUP BY sid ORDER BY number DESC LIMIT 420");
        while ($row = mysql_fetch_array($get420)) {
        mysql_query("UPDATE wcddl_sites SET rate=3 where id = '".$row['sid']."'"); }
        
        $get120 = mysql_query("SELECT COUNT(title) AS 'number' , sid FROM wcddl_downloads GROUP BY sid ORDER BY number DESC LIMIT 120");
        while ($row = mysql_fetch_array($get120)) {
        mysql_query("UPDATE wcddl_sites SET rate=2 where id = '".$row['sid']."'"); }

    echo '<div align="center" style="color:green;">All eligible sites rated</div>'; 

problem is, its rating all sites 2* as if they have 420 downloads. and they dont.

Chris2k Reviewed by Chris2k on 2nd Oct 2011. Auto Site Rating Hi, I'm trying to setup an auto site rating for WCDDL. I have used the code from a mod here: http://warezcoders.com/forum/viewtopic.php?f=15&t=1095 if(isset($rsites)) { mysql_query("UPDATE wcddl_sites SET rating=1"); $get300 = mysql_query("SELECT COUNT(title) AS 'number' , sid FROM wcddl_downloads GROUP BY sid ORDER BY number DESC LIMIT 0,300"); while ($row = mysql_fetch_array($get300)) { mysql_query("UPDATE wcddl_sites SET rating= rating+1 where id = '".$row."'"); } Rating: 5