vB+Joomla... the essential plugins?

#1
twignuts

Posted 28 May 2008 - 01:02 PM

Newbie

Members
2 posts

Hello...

I'm new here, but like me we share a site combo... Joomla & vB, I'm migrating from vBadvaned as a CMS solution and Joomla is just amazing...

I'm here because of your stats for vB mod/plugin for joomla... and i wondered if i could bother you some more and ask, is there a cool easy way to feed in my latest vB forum posts into a Joomla page...? i thought of using rss feeds from my forums and doing it that way... what ya think? as i say... I'm fairly new to Joomla to s.p.e.a.k s.l.o.w.l.y :)

cheers

#2
Guest_Jordan_*

Posted 28 May 2008 - 01:37 PM

Guests

RSS Feeds + AJAX would be an excellent way to do it IMO. On this website we directly connect to the vBulletin database. You can take a look at some of our vBulletin/Joomla! plugins and modify them if you like.

http://forum.codecal...ics-joomla.html
http://forum.codecal...ers-joomla.html
http://forum.codecal...ies-joomla.html

The vBulletin no replies module would be easy to modify to fit your needs. Remove the where clause that says "replies=0" from the SQL. This component was made for Joomla! 1.x not 1.5x.

#3
twignuts

Posted 28 May 2008 - 01:47 PM

Newbie

Members
2 posts

thank you very much, I'll check them out, cheers

#4
Merrillizer

Posted 11 June 2008 - 12:57 AM

Newbie

Members
2 posts

Jordan said:

The vBulletin no replies module would be easy to modify to fit your needs. Remove the where clause that says "replies=0" from the SQL. This component was made for Joomla! 1.x not 1.5x.

I tried removing...

. "\n WHERE replycount=0"

But then nothing shows up. What exactly do I remove? I would like to show latest threads. TIA

#5
Guest_Jordan_*

Posted 11 June 2008 - 03:50 AM

Guests

The original code looks like this:

// Select the threads!
$query = "SELECT * FROM " . $table_prefix . "thread"
    . "\n WHERE replycount=0"
    . "\n AND forumid NOT IN(" . $no_include_forum . ")"
    . "\n AND visible=1"
    . "\n ORDER BY lastpost DESC"  // Was dateline
    . "\n LIMIT " . $display_amount
    ;

I'm guessing when you remove it you removed the 'WHERE' clause as well. It should look like this (after removing):

// Select the threads!
$query = "SELECT * FROM " . $table_prefix . "thread"
    . "\n WHERE forumid NOT IN(" . $no_include_forum . ")"
    . "\n AND visible=1"
    . "\n ORDER BY lastpost DESC"  // Was dateline
    . "\n LIMIT " . $display_amount
    ;

#6
Merrillizer

Posted 11 June 2008 - 12:05 PM

Newbie

Members
2 posts

Ah yes, thank you. That worked. But now I noticed everything is jumbled together in the module. I had it setup and working in User2 position, but all the text was crammed together. I guess it would be better if it just listed the latest threads without the usernames etc.

Any way to make it so it'll just list the latest threads, one below the other?