Auto Site Rating

[DEViANCE]

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['sid']."'"); }

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

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

$getwhite = mysql_query("SELECT url FROM wcddl_whitelist");
while ($row = mysql_fetch_array($getwhite)) {
mysql_query("UPDATE wcddl_sites SET rating= rating+1 where url = '".$row['url']."'"); }
echo '<div align="center" style="color:green;">Sites Rated</div>';
} 

Which is meant to set all sites as rating 1*, then if they have 100 downloads 2*, 200 downloads 3*, 300 downloads 4*, and 300 downloads and in whitelist 5*.

But it is just setting all the sites as *4 but none of the sites have even 100 downloads (and none in whitelist hence its not setting then as 5*. As it stands all of the sites should be set as 1*. can anybody tell me whats wrong with the code??

DEViANCE Reviewed by DEViANCE on 21st Jun 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

[Chris2k]

I think i have a solution so give me a few hours oto solve it asw ive re-written my limit mod, so debugging that btw this ratng thing is easy as pissing and so i was gonna do this modifiction anyway.

[Chris2k]

okays ive done it, told ya easy as.

just go to ur DB and run this SQL statement:

ALTER  TABLE  `wcddl_sites`  CHANGE  `rate`  `rate` VARCHAR( 4  )  CHARACTER  SET latin1 COLLATE latin1_swedish_ci NOT  NULL

now all sites will be 1* on first submission

[DEViANCE]

Hi, chris.

I already have it set so sites are rated one on first submission. The code above is for a button in the admin panel that auto rates the sites based on number of downloads but its not working as intended, specifically the code that is not working is:

     $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['sid']."'"); }

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

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

[Chris2k]

i dunno a fix for that as iv never used.

[DEViANCE]

Its odd, I'm sure I used the same code on a site a couple of years back and it worked ok but this time its acting like all sites have over 300 downloads even when they don't.

I really want to get this working as there is no way I am manually rating sites with the "email me for rerate" method etc.. Once I get this working I'm just gonna change it to something like this:

New Sites = 1*
200+ Downloads = 2*
600+ Downloads = 3*
1200+ Downloads = 3*
3000+ Downloads = 5*

[Chris2k]

try this mod: http://warezcoders.com/forum/viewtopic.php?f=15&t=1110 let me no.

[DEViANCE]

I have already tried that code, it works but not in the way I want it to.

[jomasaco]

explaining
the above code who was made by moi.

get 100 sites whit higher number of downloads...200...300...400
get sites from whitelist +1

mean if you have 1 site and that are in whitelist will be rank 5 cuz are the in the top 100,200.... and whitelisted.

i did others versions of this but... isn't perfect too who is similar but whit an precentage of sites for each rank based on downloads number too.

$found = mysql_num_rows(mysql_query("SELECT distinct sid FROM wcddl_downloads"));
        mysql_query("UPDATE wcddl_sites SET rating = 0");

   $get75percent = mysql_query("SELECT COUNT(title) AS number , sid FROM wcddl_downloads GROUP BY sid 
ORDER BY number DESC LIMIT 0,".round($found / 100 * 75)."");
echo "<center><b>RANK 1 *</b></center>";
while ($got = mysql_fetch_array($get75percent)) {
mysql_query("UPDATE wcddl_sites SET rating= rating+1 where id = '".$got['sid']."'");
}

     $get50percent = mysql_query("SELECT COUNT(title) AS number , sid FROM wcddl_downloads GROUP BY sid 
ORDER BY number DESC LIMIT 0,".round($found / 100 * 50)."");
echo "<center><b>RANK 2 **</b></center>";
while ($got = mysql_fetch_array($get50percent)) {
mysql_query("UPDATE wcddl_sites SET rating= rating+1 where id = '".$got['sid']."'");
} 

btw to by default the rank be 1 in sqlmyadmin edit the rank row "default 1"

[DEViANCE]

Yes I already changed the default to 1 so sites are 1* on submission. But how can I make it so:

200+ Downloads = 2*
600+ Downloads = 3*
1200+ Downloads = 3*
3000+ Downloads = 5*

???