Is there a side block to display latest weblinks?

bsweb · Regular Joined: Jun 19, 2006 Posts: 57

Hi,

I'm using Raven Nuke 2.02.02 and wondered if there was a block somewhere that would display the latest weblinks added and approved

Cheers

montego · Posted: Mon Jul 28, 2008 6:09 am

bsweb, is not blocks\block-Top10_Links.php such a block? Wink

BTW, you are way behind on RN releases... so many fixes are in the latest, including security. You might want to consider upgrading and staying more current...

bsweb · Regular Joined: Jun 19, 2006 Posts: 57

Thanks for that Montego but that lists the top links, what I wanted to do was to list the most recent links to give viewers more incentive to leave links.

As to being a bit behind on RN releases, I'm having a bit of trouble with my broadband connection not finding my website, so until my provider sorts it out or I move then I'll have to stick with it. Don't fancy uploading via dialup!

If there is a way to modify that block to show the latest 5 links that would be great

montego · Posted: Mon Jul 28, 2008 7:11 am

Well, you could try to make that SQL line as follows:

$result = $db->sql_query('SELECT lid, title FROM '.$prefix.'_links_links ORDER BY lid DESC LIMIT 0,5');

bsweb · Regular Joined: Jun 19, 2006 Posts: 57

Thanks Montego that works a treat but the page the links open to is a bit confusing to say the least so I have changed it with a little assistance from a previous post (

Only registered users can see links on this board!
Get registered or login to the forums!

) and with a little bit more adjusting the $content line became.

Code:

$content .= "<strong><big>·</big></strong> $a: <a href=\"links.html&l_op=visit&lid=$lid&ttitle=$title\">$title2</a><br />";

so it now opens the target website.

Many Thanks again Very Happy

montego · Posted: Tue Jul 29, 2008 6:36 pm

Good work!

Gremmie · Posted: Wed Jul 30, 2008 7:33 am

I did the same thing on my block a while back. Smile