collapse collapse

* User Info

 
 
Welcome, Guest. Please login or register.
Did you miss your activation email?

* Who's Online

  • Dot Guests: 185
  • 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
Thanks for having an interest with our portal. If you have any requests for features, have a look at the Feature Requests board.

Author Topic: SMF Links Directory Block  (Read 10419 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