collapse collapse

* Archive Notice

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.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 234
  • 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]

Blocks speak! Do you have an interest in getting more blocks - or even making your own? The Blocks Board is for you!

Author Topic: SMF Links Directory Block  (Read 10592 times)

0 Members and 1 Guest are viewing this topic.

Offline NIBOGO

  • Semi Newbie
  • *
  • Posts: 35
  • Gender: Male
    • SMFPacks
  • SMF Version: 2.0.2
  • SP Version: None
SMF Links Directory Block
« on: July 16, 2010, 07:24:09 PM »
SMF 2.0 Block for SMF Links Directory

Horizontal:


Code: [Select]
global $smcFunc, $scripturl;

 echo'Recent Links:<br />';

$dbresult = $smcFunc['db_query']('', '
   SELECT id_link, name, url
   FROM {db_prefix}links
   ORDER BY id_link DESC
   LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
   echo'<a href="'.$scripturl.'?action=links;sa=details;lid='.$row['id_link'].'"><img src="http://open.thumbshots.org/image.aspx?url='.$row['url'].'" alt="'.$row['name'].'" /><br />'.$row['name'].'</a>';
}
$smcFunc['db_free_result']($dbresult);


Vertical:


Code: [Select]
global $smcFunc, $scripturl;

 echo'Recent Links:<br />';

$dbresult = $smcFunc['db_query']('', '
   SELECT id_link, name, url
   FROM {db_prefix}links
   ORDER BY id_link DESC
   LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
   echo'<a href="'.$scripturl.'?action=links;sa=details;lid='.$row['id_link'].'"><img src="http://open.thumbshots.org/image.aspx?url='.$row['url'].'" alt="'.$row['name'].'" /><br />'.$row['name'].'</a><br />';
}
$smcFunc['db_free_result']($dbresult);


Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: SMF Links Directory Block
« Reply #1 on: July 16, 2010, 07:52:28 PM »
Moved to the Blocks and Modifications board, thanks for the block! :)
SMF Friend (Former Support Specialist) | SimplePortal Developer
My SMF Mods | SimplePortal

"Quis custodiet ipsos custodes?" - Who will Guard the Guards?

Please don't send me ANY support related PMs. I will just delete them.

Offline geekfairy

  • Semi Newbie
  • *
  • Posts: 19
  • SMF Version: 1.1.10
  • SP Version: 2.3.1
Re: SMF Links Directory Block
« Reply #2 on: February 12, 2011, 07:30:02 PM »
What would I need to change for this to work with 1.1.13?

Thanks :)

Offline aportadordelmix

  • Semi Newbie
  • *
  • Posts: 19
  • SMF Version: 2 RC4
  • SP Version: 2.3
Re: SMF Links Directory Block
« Reply #3 on: April 23, 2011, 01:54:33 PM »

Offline velorooms

  • Jr. Member
  • **
  • Posts: 83
    • Velorooms
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: SMF Links Directory Block
« Reply #4 on: October 04, 2012, 11:44:32 AM »
works fine, but theres a problem in that it displays UNAPPROVED links which is a bit annoying.
Admin and Owner of Velorooms.com - Using SMF 2.0.3 and Simpleportal 2.3.5

Offline phantomm

  • Translator
  • *
  • Posts: 406
  • Gender: Male
  • Smile, tomorrow will be worse...
    • Polish ElkArte community
  • SMF Version: None
  • Elkarte Version: 1.0.5
Re: SMF Links Directory Block
« Reply #5 on: October 04, 2012, 12:10:41 PM »
In block code:
Code: (Find) [Select]
   SELECT id_link, name, url
Code: (Replace with) [Select]
   SELECT id_link, name, url, approved
Code: (Find) [Select]
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
Code: (Replace with) [Select]
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
if($row['approved'] == 1)

:)

Offline velorooms

  • Jr. Member
  • **
  • Posts: 83
    • Velorooms
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: SMF Links Directory Block
« Reply #6 on: October 07, 2012, 10:35:52 AM »
gracias :D
Admin and Owner of Velorooms.com - Using SMF 2.0.3 and Simpleportal 2.3.5

Offline velorooms

  • Jr. Member
  • **
  • Posts: 83
    • Velorooms
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: SMF Links Directory Block
« Reply #7 on: January 05, 2013, 07:29:36 PM »
Just for reference. Looks a lot neater with a couple of div center tags put in (vertical version)

Code: [Select]
global $smcFunc, $scripturl;



$dbresult = $smcFunc['db_query']('', '
   SELECT id_link, name, url
   FROM {db_prefix}links
   ORDER BY id_link DESC
   LIMIT 3');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
   echo'<a href="'.$scripturl.'?action=links;sa=details;lid='.$row['id_link'].'"><div align="center"><img src="http://open.thumbshots.org/image.aspx?url='.$row['url'].'" alt="'.$row['name'].'" /></div><div align="center">'.$row['name'].'</div></a>';
}
$smcFunc['db_free_result']($dbresult);
Admin and Owner of Velorooms.com - Using SMF 2.0.3 and Simpleportal 2.3.5

Offline Farjo

  • Semi Newbie
  • *
  • Posts: 18
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: SMF Links Directory Block
« Reply #8 on: February 21, 2013, 12:08:22 AM »
I couldn't get them to work in a horizontal block so I changed NIBOGO's code:
Code: [Select]
global $smcFunc, $scripturl;

 echo'<ul>';

$dbresult = $smcFunc['db_query']('', '
   SELECT id_link, name, url
   FROM {db_prefix}links
   ORDER BY id_link DESC
   LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
   echo'<li style="display: inline-block; text-align:center; width: 20%"><a href="'.$scripturl.'?action=links;sa=details;lid='.$row['id_link'].'"><img src="http://open.thumbshots.org/image.aspx?url='.$row['url'].'" alt="'.$row['name'].'" /><br />'.$row['name'].'</a></li>';
}
$smcFunc['db_free_result']($dbresult);

echo '</ul>';

It picks out the latest 5 links, so the width of each list item is 20%

Offline velorooms

  • Jr. Member
  • **
  • Posts: 83
    • Velorooms
  • SMF Version: 2.0.2
  • SP Version: 2.3.5
Re: SMF Links Directory Block
« Reply #9 on: March 25, 2013, 05:34:42 PM »
And a straight text variation with icon.

Code: [Select]
global $smcFunc, $scripturl;



$dbresult = $smcFunc['db_query']('', '
   SELECT id_link, name, url
   FROM {db_prefix}links
   ORDER BY id_link DESC
   LIMIT 5');
while ($row = $smcFunc['db_fetch_assoc']($dbresult))
{
   echo'<img src="/Themes/default/images/sp/linkicon.png" /><a href="'.$scripturl.'?action=links;sa=details;lid='.$row['id_link'].'">'.$row['name'].'</a><br/>';
}
$smcFunc['db_free_result']($dbresult);

need to upload the attached image to sp images directory
Admin and Owner of Velorooms.com - Using SMF 2.0.3 and Simpleportal 2.3.5