Show Top 10 Downloads by Views [module]

[c0rrupt]

by jomasaco on Sat Jan 23, 2010

Since i include one easy way to disable the module ($enablemod = true the entire table structure must be inside of module.

Code: (Select All)

<?php
    /*BEGIN_INFO
    Show the top downloads by views.

    By jomasaco [url]www.stugas-ddl.org[/url].
    END_INFO*/
    if(!defined("WCDDL_GUTS")) exit;


    $enablemod = true; //change to false if you don't want to show
    if($enablemod) {
    $outa = '<table border="0" cellpadding="6" cellspacing="1" width="100%">
    <thead>
    <tr>
    <th colspan="5">[b]Top 10 Downloads[/b]</span></th>
    </tr>
    </thead>
    <tbody>
    <tr><td>[b]Type[/b]</td><td>[b]Title[/b]</td><td>[b]Provider[/b]</td><td>[b]Views[/b]</td><td>[b]Rating[/b]</td></tr>';

    $getit = mysql_query("SELECT id,sid,type,title,views,rating FROM wcddl_downloads WHERE views>0 ORDER BY views DESC LIMIT 0,10"); //change 10 to many you want
    while ($got = mysql_fetch_array($getit)) {
             $site = mysql_query("SELECT name as sname, url as surl from wcddl_sites WHERE id = '".$got['sid']."'");
             $site = mysql_fetch_assoc($site);
             $row = array_merge($site,$got);  

    $outa .= '<tr><td>'.$row['type'].'</td><td>[url=download.php?id='.$row['id'].']'.$row['title'].'[/url]</td><td>[url=http://'.$row['surl'].']'.$row['sname'].'[/url]</td><td>'.$row['views'].'</td><td>'.$row['rating'].'</td></tr>';
    }
    $outa .= '</tbody></table>';

    $core->setTemplateVar("top10",$outa);
    }
    ?>

display

Code: (Select All)

<?=$core->templateVar("top10")?>