SimplePortal

Customization => Blocks and Modifications => Block Requests => Topic started by: Sim on February 27, 2011, 08:59:06 PM

Title: Download System Block
Post by: Sim on February 27, 2011, 08:59:06 PM

Code: [Select]

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

Title: Re: Download System Block
Post by: kimyaci on May 15, 2013, 06:00:20 PM

I need to the most downloaded block.I'd appreciate if you can help me.Thnaks.

Title: Re: Download System Block
Post by: rlake on May 15, 2013, 09:14:11 PM

Quote from: kimyaci on May 15, 2013, 06:00:20 PM

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...

Code: [Select]

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

Title: Re: Download System Block
Post by: kimyaci on May 16, 2013, 03:01:57 AM

Most download Title List is coming but the do not most download numbers.Please can you edit these codes.Thanks for your help.

Code: [Select]

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



Title: Re: Download System Block
Post by: kimyaci on May 16, 2013, 03:41:03 AM

(http://img4.hostingpics.net/pics/486867mostdownload.png) (http://www.hostingpics.net/viewer.php?id=486867mostdownload.png)

It's okay now.Thanks

Code: [Select]

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



Title: Re: Download System Block
Post by: ryansaw on July 13, 2014, 03:19:11 AM

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. 

Title: Re: Download System Block
Post by: Itchigo on July 21, 2014, 11:34:09 PM

I wanted to say thanks as well. ;D

Title: Re: Download System Block
Post by: Black Tiger on December 02, 2014, 09:25:14 PM

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?

Title: Re: Download System Block
Post by: [SiNaN] on December 03, 2014, 01:42:11 PM

Do you want the second code to just list the entries rather using a table? Something like the following?

Code: (Find) [Select]

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

Code: (Replace) [Select]

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 />';
}

Title: Re: Download System Block
Post by: Black Tiger on December 03, 2014, 05:29:10 PM

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

Code: [Select]

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

Code: [Select]

<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.