collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 425
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Welcome to SimplePortal.net! You can download SimplePortal from the Downloads Area!

Author Topic: Download System Block  (Read 9863 times)

0 Members and 1 Guest are viewing this topic.

Offline Sim

  • Newbie
  • Posts: 3
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Download System Block
« 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);

Offline kimyaci

  • Full Member
  • ***
  • Posts: 127
  • Gender: Male
    • Forumigo8navigation
  • SMF Version: 2.0.7
  • SP Version: 2.3.5
Re: Download System Block
« Reply #1 on: May 15, 2013, 06:00:20 PM »
I need to the most downloaded block.I'd appreciate if you can help me.Thnaks.
SMF 2.0.7 HabboArtv1, Default Themes.

Offline rlake

  • Semi Newbie
  • *
  • Posts: 6
  • SMF Version: None
  • SP Version: 2.3.5
Re: Download System Block
« Reply #2 on: May 15, 2013, 09:14:11 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);

Offline kimyaci

  • Full Member
  • ***
  • Posts: 127
  • Gender: Male
    • Forumigo8navigation
  • SMF Version: 2.0.7
  • SP Version: 2.3.5
Re: Download System Block
« Reply #3 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>';

SMF 2.0.7 HabboArtv1, Default Themes.

Offline kimyaci

  • Full Member
  • ***
  • Posts: 127
  • Gender: Male
    • Forumigo8navigation
  • SMF Version: 2.0.7
  • SP Version: 2.3.5
Re: Download System Block
« Reply #4 on: May 16, 2013, 03:41:03 AM »


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

« Last Edit: May 16, 2013, 10:05:44 AM by kimyaci »
SMF 2.0.7 HabboArtv1, Default Themes.

Offline ryansaw

  • Just Registered
  • Posts: 1
  • SMF Version: 2.0.8
  • SP Version: 2.3.5
Re: Download System Block
« Reply #5 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. 

Offline Itchigo

  • Semi Newbie
  • *
  • Posts: 25
  • SMF Version: 2.0.7
  • SP Version: 2.3.5
Re: Download System Block
« Reply #6 on: July 21, 2014, 11:34:09 PM »
I wanted to say thanks as well. ;D

Offline Black Tiger

  • Jr. Member
  • **
  • Posts: 60
  • Gender: Male
  • SMF Version: 2.0.11
  • SP Version: 2.3.6
Re: Download System Block
« Reply #7 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?
« Last Edit: December 02, 2014, 10:26:33 PM by Black Tiger »
Greetings, Black Tiger

Offline [SiNaN]

  • Mr. SimplePortal
  • Developer
  • *
  • Posts: 6782
  • SMF Version: 2.0.15
  • SP Version: 2.3.7
Re: Download System Block
« Reply #8 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 />';
}
And slowly, you come to realize... It's all as it should be...

Offline Black Tiger

  • Jr. Member
  • **
  • Posts: 60
  • Gender: Male
  • SMF Version: 2.0.11
  • SP Version: 2.3.6
Re: Download System Block
« Reply #9 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.
Greetings, Black Tiger