widgets

[ozidoggy]

Has anyone any idea how to place recent or random links in a widget for the cms?

[Dennis Kaczor]

Great idea and I too would like to see this as well.

Dennis

[KristerSwe]

+1

[rotor]

That would be great - anyone looking at this??

[KristerSwe]

Originally Posted by ozidoggy

Has anyone any idea how to place recent or random links in a widget for the cms?

Yeah but that is already there on the mainpage. widget could have hottest, featured or something else. anyone with skills who can jump in on this

[interfx]

I am also looking for this... It's so great to have VBaLinks working on VB4.x now...

[karlm]

+1 more

[roymogg]

Hi All,

I put random links on the CMS homepage with this code which is a mod to the classifieds hack. Needs tidying up and it is work in progress and the thumshots do fail to turn up occasionally.

PHP Code:

$host = 'localhost';
$dbUser = 'forum';
$dbPass = 'pass';
$db = 'your_forum';
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

ob_start();

$result = mysql_query("SELECT linkid,name,linkurl,catid,username FROM bf_adv_links ORDER BY rand() LIMIT 5" ) or die(mysql_error());

while($link = mysql_fetch_array( $result )) {

print"<center>";
print "<a href=" . $link['linkurl'] . " " . "target=\"_blank\">" ."<img src=\"http://open.thumbshots.org/image.aspx?url=".$link['linkurl']." ". "width=\"120\" height=\"90\" border=\"0\" />" . "</a>";
print "<br />";
print $link['name'] . " listed by " . $link['username'];
print "</center>";
}

$output .= ob_get_contents();
ob_end_clean(); 


but it works for me

Cheers

RoyMogg

[claystation]

rss feed widget works as well

[roymogg]

can you get the thumnails to show up in the RSS feed?

[claystation]

no thumbnails show, That would be nice though.

[NashChristian]

Originally Posted by roymogg

Hi All,

I put random links on the CMS homepage with this code which is a mod to the classifieds hack. Needs tidying up and it is work in progress and the thumshots do fail to turn up occasionally.

PHP Code:

$host = 'localhost';
$dbUser = 'forum';
$dbPass = 'pass';
$db = 'your_forum';
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

ob_start();

$result = mysql_query("SELECT linkid,name,linkurl,catid,username FROM bf_adv_links ORDER BY rand() LIMIT 5" ) or die(mysql_error());

while($link = mysql_fetch_array( $result )) {

print"<center>";
print "<a href=" . $link['linkurl'] . " " . "target=\"_blank\">" ."<img src=\"http://open.thumbshots.org/image.aspx?url=".$link['linkurl']." ". "width=\"120\" height=\"90\" border=\"0\" />" . "</a>";
print "<br />";
print $link['name'] . " listed by " . $link['username'];
print "</center>";
}

$output .= ob_get_contents();
ob_end_clean(); 


but it works for me

Cheers

RoyMogg

I was actually kind of hopefull about this, but after visiting your site, not one single thumbnail showed up, even for TLD's.

Has anyone found a solution yet, which includes the thumbshots?

[roymogg]

Hi Nashchristian

I did change this to select the latest links as they seem to show up more regularly. So include 'dateline' in the SQL select statement and ORDER BY dateline DESC limit 5

REM

[NashChristian]

Originally Posted by roymogg

Hi Nashchristian

I did change this to select the latest links as they seem to show up more regularly. So include 'dateline' in the SQL select statement and ORDER BY dateline DESC limit 5

REM

Hello Roymogg,

I am really looking for a widget that will do the random links... otherwise it keeps the SAME links on the page and that gets boring.

Thanks anyway. If you ever get this to work right, with thumbs, on random, let me know! I'll be the first to install it.

THanks. Jeff

[Bergler]

I tried to install this widget but I get this error, any ideas?

Table 'db*****_bcfr2009.bf_adv_links' doesn't exist

[roymogg]

Originally Posted by Bergler

I tried to install this widget but I get this error, any ideas?

If you look at the query ( bf_adv_links) it is from my forum) the prefix is the one I use for the links directory tables. So you should just edit the above code to replace the bf_ with the prefix you use (or if you don't) then just remove it.

I did not notice when I copied accross the code.

regards

RoyMogg

[Bergler]

That worked, thank you! How do you change it to show new instead of random? Also is there away to have the link in the widget go to the redirection link or details page instead of the direct link, to the link?

[roymogg]

This should work:

PHP Code:

$result = mysql_query("SELECT dateline,linkid,name,linkurl,catid,username FROM adv_links ORDER BY dateline DESC LIMIT 5" ) or die(mysql_error()); 


RoyMogg

[Bergler]

Thats worked good, thanks for that! Any suggestions on the other, "away to have the link in the widget go to the redirection link or details page instead of the direct link, to the link?"

Thanks

[Bergler]

Originally Posted by Bergler

how to have the link in the widget go to the redirection link or details page instead of the direct link?[/I]"

Thanks

Any one know if this is possible?