SimplePortal
Customization => Blocks and Modifications => Block Requests => Topic started by: Sim on February 27, 2011, 08:59:06 PM
-
global $smcFunc, $scripturl;
echo'Recent Links:<br />';
$dbresult = $smcFunc['db_query']('', '
SELECT id_file , title
FROM {db_prefix}down_file
WHERE approved=1
ORDER BY id_file DESC
LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
echo'<a href="'.$scripturl.'?action=downloads;sa=view;down='. $row['id_file'] . '">'.$row['title'].'</a><br />';
}
$smcFunc['db_free_result']($dbresult);
-
I need to the most downloaded block.I'd appreciate if you can help me.Thnaks.
-
I need to the most downloaded block.I'd appreciate if you can help me.Thnaks.
I just installed this, so I haven't had much time to study it, but I think this will work for you...
global $smcFunc, $scripturl;
echo'Recent Links:<br />';
$dbresult = $smcFunc['db_query']('', '
SELECT id_file , title
FROM {db_prefix}down_file
WHERE approved=1
ORDER BY totaldownloads DESC
LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
echo'<a href="'.$scripturl.'?action=downloads;sa=view;down='. $row['id_file'] . '">'.$row['title'].'</a><br />';
}
$smcFunc['db_free_result']($dbresult);
-
Most download Title List is coming but the do not most download numbers.Please can you edit these codes.Thanks for your help.
global $db_prefix, $scripturl, $smcFunc;
$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, g.online_color, m.real_Name, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
LEFT JOIN {db_prefix}membergroups AS g ON (g.id_group = CASE WHEN m.id_group = 0 THEN m.id_post_group ELSE m.id_group END)
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY ID_FILE DESC
LIMIT 10");
echo '
<table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
<tr>
<th style="text-align: left;">Title</td>
<th colspan="2" style="text-align: right;">Downloads</td>
</tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 24) .'</a> by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'" style="color: ' . $row['online_color'] . ';">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
-
(http://img4.hostingpics.net/pics/486867mostdownload.png) (http://www.hostingpics.net/viewer.php?id=486867mostdownload.png)
It's okay now.Thanks
global $db_prefix, $scripturl, $smcFunc;
$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, g.online_color, m.real_Name, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
LEFT JOIN {db_prefix}membergroups AS g ON (g.id_group = CASE WHEN m.id_group = 0 THEN m.id_post_group ELSE m.id_group END)
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 10");
echo '
<table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
<tr>
<th style="text-align: left;">Title</th>
<th colspan="2" style="text-align: right;">Downloads</th>
</tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 24) .'</a> by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'" style="color: ' . $row['online_color'] . ';">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
-
Just wanted to thank you for this nice little bit of block code. It works. Using SMF 2.0.8 SP 2.3.5 and the latest Download system.
-
I wanted to say thanks as well. ;D
-
Sorry to bump this old thread, but can you also make a combination like this?
So Latest files and Most popular files kind of like this (see attachment)?
Maybe also with a little bit of horizontal whitespace between the downloads so its more neat? Like the picture?
Edit: I managed to make it myself by combining both codes.
However, the second one is with a tab. At this moment there is a complete white space like a <br> between the downloads.
I don't know how this works with tabs, but how can I change it so it becomes half a white space?
-
Do you want the second code to just list the entries rather using a table? Something like the following?
echo '
<table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
<tr>
<th style="text-align: left;">Title</th>
<th colspan="2" style="text-align: right;">Downloads</th>
</tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 24) .'</a> by <a href="',$scripturl,'?action=profile;u=',$row['ID_MEMBER'],'" title="',$row['real_Name'],'" style="color: ' . $row['online_color'] . ';">',$row['real_Name'],'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
while ($row = $smcFunc['db_fetch_assoc']($request))
{
echo '<a href="', $scripturl, '?action=downloads;sa=view;id=', $row['ID_FILE'], '" title="', $row['ftitle'], '">', shorten_subject($row['ftitle'], 24), '</a> by <a href="', $scripturl, '?action=profile;u=', $row['ID_MEMBER'], '" title="', $row['real_Name'], '" style="color: ', $row['online_color'], ';">', $row['real_Name'], '</a> downloaded ', $row['totaldownloads'], ' times<br />';
}
-
No I like the use of tables.
I adjusted the code a little, because I don't want the "by [realname]", only top downloads and number of times downloaded.
Maybe I can leave out some of the "member" queries because of this, but I don't know which ones (I'm not good at coding), that's why I only removed the "by realname" part.
I got it like this now
global $db_prefix, $scripturl, $smcFunc;
$request = $smcFunc['db_query']('',"SELECT f.ID_FILE, f.ID_MEMBER, f.date, f.ID_CAT, f.totaldownloads, f.title AS ftitle,
c.title, g.online_color, m.real_Name, m.ID_MEMBER AS mID_MEMBER
FROM {$db_prefix}down_file AS f, {$db_prefix}down_cat AS c, {$db_prefix}members AS m
LEFT JOIN {db_prefix}membergroups AS g ON (g.id_group = CASE WHEN m.id_group = 0 THEN m.id_post_group ELSE m.id_group END)
WHERE f.ID_CAT = c.ID_CAT
AND f.approved = '1'
AND f.ID_MEMBER = m.ID_MEMBER
ORDER BY totaldownloads DESC
LIMIT 10");
echo '
<table border="0" cellpadding="1" cellspacing="0" width="100%" colspan="2">
<tr>
<th style="text-align: left;">Title</th>
<th colspan="2" style="text-align: right;">Downloads</th>
</tr>';
while($row = $smcFunc['db_fetch_assoc']($request)) {
echo '
<tr>
<td><a href="',$scripturl,'?action=downloads;sa=view;id=',$row['ID_FILE'],'" title="',$row['ftitle'],'">'. shorten_subject($row['ftitle'], 24) .'</a></td>
<td style="text-align: right;">',$row['totaldownloads'],'</td>
</tr>';
};
echo '
</table>';
So I like the code, but I just would like halve the horizontal whitespace between each line, see red arrows on screenshot 1.
I made halve horizontal spacing with php in the first part of the code like this (see screenshot 2):
<br style="line-height: .5em"/>
But the second part of the code is table, and I don't know how to do that in a table.