Auto Site Rating

[jomasaco]

TEST IN AN SAFE PLACE

The query to update table are incomplete

$found = mysql_query("SELECT distinct sid FROM wcddl_downloads");
//$srank="";
while($updaterank = mysql_fetch_assoc($found)) {
   $getnumdownloads = mysql_query("SELECT title FROM wcddl_downloads WHERE sid= ".$updaterank['sid']);
   $result = mysql_num_rows($getnumdownloads);
   if(strlen($result) >= 4 || $result >= 500) {
  $srank ="5"; }
   if(strlen($result) === 3 && $result >= 200 && $result <= 499) {
   $srank = substr($result, 0, 1);
 }
 if(isset($srank)) {
 //mysql_query("UPDATE BLABLABLA"); //continue whit the query and uncomment after the test if everyhing are ok
echo "Site id ".$updaterank['sid']." - white ".$result." downloads will be rank ".$srank."<br />";
unset($srank);
}
} 

[DEViANCE]

Ok thanks for your help. I'm just going to use a modified version of the first code. My problem was that I missunderstood how it worked in the first place

[jomasaco]

in fact i didn't see your ratings values

but are easy to change the code above to be whit that values.

wat i posted do

200->299 Rank2
300->399 R3
400->499 R4
500+ R5


if($result >= 200 && $result <= 599) {
$srank ="2"; }
if($result >= 600 && $result <= 2999) {
$srank ="3"; } //theres no rank4?
if($result >= 5000) {
$srank ="5"; }

[DEViANCE]

I actually prefer you first code but I missunderstood how it worked, now I just changed it a bit to suit my needs. Thanks for your help

[Chris2k]

i am trying to add this to my auto queue accept mod, which is run 4 - 5x day via cron.

here my code:

    $get100 = 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($get100)) {
    mysql_query("UPDATE wcddl_sites SET rating=2 where id = '".$row['sid']."'"); }

    $get600 = mysql_query("SELECT COUNT(title) AS 'number' , sid FROM wcddl_downloads GROUP BY sid ORDER BY number DESC LIMIT 600");
    while ($row = mysql_fetch_array($get600)) {
    mysql_query("UPDATE wcddl_sites SET rating=3 where id = '".$row['sid']."'"); }

    $get2800 = mysql_query("SELECT COUNT(title) AS 'number' , sid FROM wcddl_downloads GROUP BY sid ORDER BY number DESC LIMIT 2800");
    while ($row = mysql_fetch_array($get2800)) {
    mysql_query("UPDATE wcddl_sites SET rating=4 where id = '".$row['sid']."'"); }

    echo '<div align="center" style="color:green;">Sites Rated</div>'; 

it sees to not be rating si tes.

any heelp

[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.