WCDDL Site Rating

[CyberHacK]

I own ExplosiveWarez and I'm looking for a WCDDL Site rating Mod for WCDDL v2.

Thanks,
-CyberHacK

CyberHacK Reviewed by CyberHacK on 31st Dec 2009. WCDDL Site Rating I own ExplosiveWarez and I'm looking for a WCDDL Site rating Mod for WCDDL v2. Thanks, -CyberHacK Rating: 5

[r0ck]

there isn't one made yet, besides a few private ones I know someone made

[frontlinegamerz]

I have one rock, if i can find the old one i will release it but the new one will not be released.

[r0ck]

I have one rock, if i can find the old one i will release it but the new one will not be released.

changed my post as I knew you had them, but none were released

[CyberHacK]

there is. Some people have it but havent shared the code.

[Kr?niiK]

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);

[SJshah]

^ front dont release it I paid for that one |:

[CyberHacK]

Thanks Alot KroNiiK .

Edit: where it says line 152 what am I editing?

[frontlinegamerz]

sj u have a more advanced version i believe but if not since u paid u will get the new one

[Kr?niiK]

np enjoy CyberHack.