Fake vBalinks as forum

[Lionel]

This requires a small file edit and will simulate vBalink as a forum, displaying latest link in forumhome

Replace /showcase/ with your links directory foldername

[Ramses]

Nice work, thank you Lionel.

[BWJ]

Thank you Lionel. I have not tried it yet (as I have to solve another problem first). But I definately like the idea. One question: Could it be possible to take a new link from a specific link category to a specific forum category (instead of all link categories to forum home) ? So instead of a parrot link goes to forum home it goes to the parrot forum.

You could extend this idea even further - so every link would has its own link in its own forum category. This would incorporate the vbalinks even tighter to the forum. Just an idea...

[Lionel]

Sure it's possible. You create as many forums as you want and link them to the category. Then you add a WHERE categoryid clause for each query.

But why would you do that? Would be simpler to do one forum and link it to your main links folder where you have all info already the way you want it.

[Parabellum]

Thank you! Just what I was looking for.

How can I get it to show the amount of posts in the link directory? It only shows threads.

Thanks Again

[Lionel]

Do you have any posts for the last link in there? They should display
$forum['replycount'] = $link['posts'];

[Parabellum]

the latest link has no posts but the link directory it self does in other links

[Lionel]

It display last post info for the last link only. To get for entire directory you would need to add another query to get it

[Parabellum]

what is the code I would need to add to get the total amount of posts for the link directory.

Thank you for your time!

[Lionel]

On top of my head (not tested)

$totpost = $db->query_first("SELECT SUM(posts) as totpost FROM " . TABLE_PREFIX . "adv_links");

and replace with

$forum['replycount'] = $totpost['totpost'];

[Parabellum]

I tried it with this code and it worked

I just added the code you gave me without replacing any. So far no problems that I can find.

$tot = $db->query_first("SELECT COUNT(*) as count FROM " . TABLE_PREFIX . "adv_links"); 
$totpost = $db->query_first("SELECT SUM(posts) as totpost FROM " . TABLE_PREFIX . "adv_links");

$forum['threadcount'] = $tot['count'];
$forum['replycount'] = $totpost['totpost'];

[Lionel]

Cool. You could also fine tune the date by adding the extra css to the span. I think it's class="time" . This way the font will be the same size with the rest of your dates, and make the link title "smallfont" as it appears to be "smallfont" in your forumhome

[Parabellum]

Changed the fonts like you said and looks perfect just like the rest of the forum. Thank you for all the help!

Here is the link to my site with this great mod in action Demo

[ozidoggy]

Originally Posted by Lionel

Cool. You could also fine tune the date by adding the extra css to the span. I think it's class="time" . This way the font will be the same size with the rest of your dates, and make the link title "smallfont" as it appears to be "smallfont" in your forumhome

Can someone please explain to me how and where I place this piece of code?

Thanks

By the way GREAT mod!

[PhilMcKrackon]

Originally Posted by ozidoggy

Can someone please explain to me how and where I place this piece of code?

Look at my example just above your post. You can see where I have placed class="smallfont" to control the font size on the $forum['lastpostinfo'] line (3rd from last).

[ozidoggy]

Thanks Phil.....

[Lionel]

Post the link to your site for those who would want to see it, but are too lazy to click on your name or will not see it on the page or would not know to look in forums :-)

[ozwebsites]

I cannot get this working

And its a great little hack.

we have links directory in our domain root.
forum is under /forum

Have done the changes,

PHP Code:

if ($forum['forumid'] == '43')
                {
                global $db; 
                $tot = $db->query_first("SELECT COUNT(*) as count FROM " . TABLE_PREFIX . "adv_links");
                $link = $db->query_first("SELECT linkid , name, posts, username, userid, dateline FROM " . TABLE_PREFIX . "adv_links ORDER BY linkid DESC");
                $date = vbdate($vbulletin->options['dateformat'], $link['dateline'], 1);
                $time = vbdate($vbulletin->options['timeformat'], $link['dateline']);        
                $forum['lastpostinfo'] = '<div align="left"><strong><a href="/links/showlink.php?do=showdetails&l='.$link[linkid].'">'.$link[name].'</a></strong><br />by <a href="member.php?find=lastposter&f='.$link[userid].'">'.$link[username].'</a><br /><span style="float:right;">'.$date.' '.$time.' <a href="/links/showlink.php?do=showdetails&l='.$link[linkid].'"><img src="images/buttons/lastpost.gif" border="0" alt="View "></a></span></div>';
                $forum['threadcount'] = $tot['count'];
                $forum['replycount'] = $link['posts'];                
                } 


Have set up a new forum, id 43

Dont work....

Any suggestions?

Ozzy

[Lionel]

Did you link the forum? What happens when you click on it?

[ozwebsites]

Originally Posted by Lionel

Did you link the forum? What happens when you click on it?

Well,, I was presuming this hack... actually posts new links into the forum thread, on forum home page.

So in the code you gave, we have replaced xx with the forum id.

Am i missing something really obvious?