Sql Order

[Chris2k]

hey

Any1 know how this sql orders:



Because they have a diff site per row, i am currently query mine as rate but its showing last 40 rows from sites,

Chris2k Reviewed by Chris2k on 23rd Jan 2012. Sql Order hey Any1 know how this sql orders: http://i.lulzimg.com/c89bcef200.png Because they have a diff site per row, i am currently query mine as rate but its showing last 40 rows from sites, Rating: 5

[c0rrupt]

You can try this..

mix the downloads
Credit to jomasco

Open funcs.php file and search for:

foreach($_POST['ad'] as $addKey => $addVal) { 

before add:

shuffle($_POST['ad']); 

Search for and comment:

$get = "SELECT id,sid,title,type,url FROM wcddl_queue ORDER BY id ASC LIMIT 0, 250"; 

Add above:

$get= "SELECT q.id,q.sid,q.title,q.type,q.url FROM wcddl_queue q LEFT JOIN wcddl_sites s ON (s.id = q.sid) ORDER BY s.rating, s.id ASC LIMIT 0,".($this->limit * 4)."";