SMF Downloads block?

[Dragooon]

oops
Use the fol. code

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,
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 '<div style="margin:5px"><a href="',$scripturl,'?action=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a> by <a href="',$scripturl,'?action=profile;u=',$row['mID_MEMBER'],'">',$row['realName'],'</a> in <a href="',$scripturl,'?action=viewc;id=',$row['ID_CAT'],'">',$row['title'],'</a></div>';
}
The previous ones didn't had a "limit" set to them so they would've shown all the uploads sent(I am sure you wouldn't want that )

[JPDeni]

glad you got it sorted.

[Heero]

Okay dude, thanks again!

[fussilet]

hello,
In the picture , can't you that pretend?

[Dragooon]

I said I am gonna do that "tomorrow", so now is the tomorrow and here is the code:

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 f.ID_FILE DESC
LIMIT 5",__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=view;id=',$row['ID_FILE'],'">',$row['ftitle'],'</a></td>
<td valign="top" class="smalltext" align="right">',$row['totaldownloads'],'</td>
</tr>
</table>';
}
Now it *should* show like TP's Recent downloads block.

[fussilet]

thank you very much, You are one piece :up

[Crip]

 

• :up + up: + : up : ==>≥ :up:

[fussilet]

thanks crip :up: 

[Crip]

U bet fussilet

[Dragooon]

lol.....Glad it worked for you
It was just a *blind* shot, I don't even use that mod