[block] Total Download for Smf Download System

[fussilet]

Thanks Husmen[aslanbeg]

The block form, add into

demo: www.fussilet.com

Code Select Expand

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 10",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '<table width="100%" cellpadding="2" cellspacing="0">
<tr>
<td valign="top" class="smalltext"> <a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}

[bbTURK]

thanks fussilet
thanks Husmen

can we not see downloads screen?

[fussilet]

I thanks bro

[NIBOGO]

really nice thanks ^^

how i can do something like this:



I try this code:

Code Select Expand

echo '<table bgcolor="#DFE2E6" width="100%">
  <tr>
    <td colspan="2">Top 10 Nuevas Descargas</td>
    <td colspan="2">Top 10 Mas Descargadas</td>   
  </tr><br>';
global $db_prefix, $scripturl;
$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY f.ID_FILE DESC
LIMIT 5",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '
<tr>
<td class="smalltext"><a href="',$scripturl,'?action=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td class="smalltext" >',$row['totaldownloads'],'</td>
';
}

global $db_prefix, $scripturl;

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 5",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
echo '
<td class="smalltext"><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td class="smalltext" >',$row['totaldownloads'],'</td>
</tr>';
}
echo '</table>';

But i have some errors , someone can make something?

[Dragooon]

Although quite a old topic, I thought I might post this(This is totally untested, *hopes it works*).
Based on NIBIGO's request

Code Select Expand

echo '<table bgcolor="#DFE2E6" width="100%">
  <tr>
    <td>Top 10 Nuevas Descargas</td>
    <td>Top 10 Mas Descargadas</td>   
  </tr>';
global $db_prefix, $scripturl;
$latest = array();
$top = array();
$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY f.ID_FILE DESC
LIMIT 5",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
$latest[] = '<a href="'.$scripturl.'?action=view;id='.$row['ID_FILE'].'">'.$row['ftitle'].'</a> ('.timeformat($row['data']).')';
}

$request = db_query("SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.title AS ftitle, f.totaldownloads,
c.title, m.realName, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 5",__FILE__,__LINE__);
while($row = mysql_fetch_assoc($request)) {
$top[] = '<a href="'.$scripturl.'?action=downloads;sa=view;id='.$row['ID_FILE'].'">'.$row['ftitle'].'</a> ('.timeformat($row['data']).')';
}

$max_count = max(array(count($top), count($latest)));
for($i = 0; $i < $max_count; $i ++);
{
echo '<tr><td>',isset($top[$i]) ? $top[$i] : '','</td></tr>';
echo '<tr><td>',isset($latest[$i]) ? $latest[$i] : '','</td></tr>';
}
echo '
</table>';

[NIBOGO]

Thanks dragooon but i have this error:

Parse error: syntax error, unexpected ';', expecting ')' on line 34

[Dragooon]

Updated the code, try that.

[fussilet]

thanks Sir

[dannbass]

I got the same error in the updated code Dragoon

Line 34

Code Select Expand

for($i = 0; $i < $max_count; $i ++;
should be

Code Select Expand

for($i = 0; $i < $max_count; $i ++);

Thanks for the code!

[Dragooon]

Yeah you are right, fixed my post, thanks