SMF Links TP/SSI function

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

[SMFHacks]

Coded a quick TinyPortal / SSI function you can use to show recent links.

Code:

function ssi_links_recent()
{
global $scripturl,$db_prefix;

$dbresult = db_query("SELECT l.ID_LINK, l.rating, l.title,l.date, l.ID_MEMBER, l.description,l.hits FROM {$db_prefix}links AS l WHERE l.approved = 1 ORDER BY l.ID_LINK DESC LIMIT 5", __FILE__, __LINE__);
while($row = mysql_fetch_assoc($dbresult))
{

echo '<a href="' . $scripturl . '?action=links;sa=visit;id=' . $row['ID_LINK'] . '" target="blank">' . $row['title'] . '</a><br />';


}
echo '<br />';
echo '<a href="' . $scripturl . '?action=links;sa=addlink">Add Link</a>';

mysql_free_result($dbresult);
}

[clintre]

Can we get an update to this for SMF 2.x?

Thanks

[clintre]

Help Support the SMFHacks.com mod making.