Site rating mod with limit on queue?

[Benzoman]

Anyone got a quick code fix to add this

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

To this mod:

Here it is, thanks for frontlinegamerz

SQL STATEMENTS

$sql = "ALTER TABLE `wcddl_sites` ADD `emailsubmit` TEXT NOT NULL";
$sql = "ALTER TABLE `wcddl_sites` ADD `rate` TEXT NOT NULL";



Line 152
Find:
$downloadSite = mysql_query("SELECT name as sname, url as surl, FROM  wcddl_sites WHERE id = '".$row['sid']."'");


Replace with:
$downloadSite = mysql_query("SELECT name as sname, url as surl, rate as  srate FROM wcddl_sites WHERE id = '".$row['sid']."'");

Find the func admin queue():

Delete all and replace with the following

protected function admin_queue() {
        if(isset($_POST['url']))
            $url = $_POST['url'];
            if(isset($_POST['emailsubmit']))
            $emailsubmit = $_POST['emailsubmit'];
            if(isset($_POST['rate']))
            $rate = $_POST['rate'];
        if(isset($_POST['sitesub']))
            $sitesub = $_POST['sitesub'];
        if(isset($sitesub)) {
            @mysql_query("UPDATE wcddl_sites SET  emailsubmit='$emailsubmit', rate='$rate' WHERE url='$url'");
            echo 'Notes added.';
                        
                }
            echo '<form action="" method="post"><table  width="100%">
        <tr><td align="center">Add Notes to  Sites</td></tr>
        <tr><td align="center">URL<input type="text"  name="url">Date/Notes<input type="text"  name="emailsubmit">Rating:<input type="text"  name="rate"></td></tr>
        <tr><td align="center"><input type="submit"  value="Make Note"  name="sitesub"></td></tr></table></form><br>';                     
        if(isset($_POST['asub']) && isset($_POST['ad'])  && !empty($_POST['ad'])) {
            foreach($_POST['ad'] as $addKey => $addVal) {
                $fetch = mysql_query("SELECT sid,title,type,url FROM  wcddl_queue WHERE id = '".mysql_real_escape_string($addVal)."'");
                $fetch = mysql_fetch_assoc($fetch);
                mysql_query("DELETE FROM wcddl_queue WHERE id =  '".mysql_real_escape_string($addVal)."'");
                mysql_query("INSERT INTO wcddl_downloads  (sid,title,type,url,dat) VALUES  ('".$fetch['sid']."','".$fetch['title']."','".$fetch['type']."','".$fetch['url']."','".time()."')");
            }
        }
        if(isset($_POST['dsub']) && isset($_POST['ad'])  && !empty($_POST['ad'])) {
            foreach($_POST['ad'] as $delKey => $delVal) {
                mysql_query("DELETE FROM wcddl_queue WHERE id =  '".mysql_real_escape_string($delVal)."'");
            }
        }
        if(isset($_POST['ucsub']) && isset($_POST['rmuc'])) {
            if(strpos($_POST['rmuc'],",") === false)
            mysql_query("DELETE FROM wcddl_queue WHERE id =  '".mysql_real_escape_string($_POST['rmuc'])."'");
            else {
            $rmuc = explode(",",$_POST['rmuc']);
                foreach($rmuc as $rmucID)
                mysql_query("DELETE FROM wcddl_queue WHERE id =  '".mysql_real_escape_string($rmucID)."'");
            }
        }
        $get = mysql_query("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.rate  ASC");
        $unclean = array();
        echo '<form action="" method="post" name="queue"><table  width="100%">
         <tr><td>Type</td><td>Title</td><td>Site</td><td>Email</td><td>Emailsubmit</td><td>rating</td><td>Select</td><td>Cleanliness</td></tr>';
        while($got = mysql_fetch_assoc($get)) {
            $site = mysql_query("SELECT name as sname, url as  surl,email,emailsubmit,rate FROM wcddl_sites WHERE id =  '".mysql_real_escape_string($got['sid'])."' LIMIT 1");
            $site = mysql_fetch_assoc($site);
            $got = array_merge($site,$got);
            $got = $this->mapit($got,array("stripslashes"));
            unset($hack);
                foreach($got as $check) {
                    if($check != strip_tags($check)) {
                    $unclean[] = $got['id'];
                    $hack = '<span  style="color:#FF0000;">UNCLEAN</span>';
                    }
                }
                if(!isset($hack))
                $hack = '<span  style="color:green;">CLEAN</span>';
            $got = $this->mapit($got,array("strip_tags"));
            echo '<tr>
            <td>'.$got['type'].'</td>
            <td><a href="'.$got['url'].'"  target="_blank">'.$got['title'].'</a></td>
             <td><a href="http://'.$got['surl'].'"  target="_blank">'.$got['sname'].'</a></td>
            <td><a href="mailto:'.$got['email'].'?subject=Dark  DDL Submissions&body=">'.$got['email'].'</a></td>
            <td>'.$got['emailsubmit'].'</td>
            <td>'.$got['rate'].'</td>
            <td><input type="checkbox" name="ad[]"  value="'.$got['id'].'"></td>
            <td>'.$hack.'</td>
            </tr>';
        }
        echo '<tr>
        <td><input type="submit" value="Accept Selected"  name="asub"></td>
        <td><input type="submit" value="Delete Selected"  name="dsub"></td>
        <td><input type="button" value="Select All"  id="sbutton" onclick="jamez();"></td>';
        if(isset($unclean[0]))
            echo '<td><input type="hidden"  value="'.implode(",",$unclean).'" name="rmuc"><input type="submit"  value="Remove Unclean" name="ucsub"></td>';
        echo '</tr>';
        echo '</table></form>';
    }


Open index.php and find:

<tr><td>Type</td><td><strong>Title</strong></td><td>Views</td><td>Rating</td></tr>

Replace with:

<tr><td>Type</td><td><strong>Title</strong></td><td>sites</td><td></td><td>Views</td><td>Rating</td></tr>

Find:
 <tr><td><?=$dl['type']?></td><td><a  href="download.php?id=<?=$dl['id']?>"><?=$dl['title']?></a></td><td><?=$dl['views']?></td><td><?=$dl['rating']?></td></tr>

Replace with:

  <tr><td><?=$dl['type']?></td><td><a  href="download.php?id=<?=$dl['id']?>"><?=$dl['title']?></a></td><td><center><a  href="http://<?=urlencode($dl['surl'])?>"><?=$dl['sname']?></a></center></td><td><?=$dl['srate']?></td><td><?=$dl['views']?></td><td><?=$dl['rating']?></td></tr>


on line 3 put make sure this is what is there
$downloads = $core->fetchDownloads(true);

Expand

Benzoman Reviewed by Benzoman on 3rd Feb 2010. Site rating mod with limit on queue? Anyone got a quick code fix to add this $get = "SELECT id,sid,title,type,url FROM wcddl_queue ORDER BY id ASC LIMIT 0, 1000"; To this mod: Rating: 5