need a module to display a list of boards

Home

Forum need a module to display a list of boards

	Welcome, Guest. Please login or register. Did you miss your activation email? December 04, 2008, 08:44:04 PM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)

need a module to display a list of boards

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: need a module to display a list of boards (Read 1715 times)

Nathan

Joomla Newbie

Karma: +0/-6
Offline

Offline

Posts: 30

need a module to display a list of boards

« on: January 01, 2007, 11:26:13 PM »

Hello. I am looking for a Joomla module that I can put on the front page of a website that will display the SMF forum board titles as links and also show how many topics each one has, etc. Does something like this exist? The SMF people won't help with this when you don't use their bridge. They gave me a module they made for this, but it only works with their bridge. I could supply this to someone that would know how to edit it to make it work.


	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: need a module to display a list of boards

« Reply #1 on: January 01, 2007, 11:28:20 PM »

well, posting the module or a link to it would help...


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

Mellow

Joomla Newbie

Karma: +6/-2
Offline

Offline

Posts: 11

Re: need a module to display a list of boards

« Reply #2 on: January 03, 2007, 10:31:01 PM »

Attached is hopefully what your looking for, its nothing special but should do the job. Allows you to choose to show the number of topics and posts or not. If it doesn't work or you need some improvements (ie limit the number of boards shown or the order in which they're shown) please let me know.

EDIT: The first file didn't work for guests, this one solves the problem


« Last Edit: January 03, 2007, 11:34:07 PM by Mellow »	Logged

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: need a module to display a list of boards

« Reply #3 on: January 04, 2007, 12:03:05 AM »

There is code in here to try and make it work with JSMF.... it looks like the query was a bit messed up. I cleaned it up and reworked the query. Its all set and ready to go.


« Last Edit: January 04, 2007, 02:56:46 PM by -Wolverine »	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

-Wolverine

Moderator
Joomla Guru

Karma: +376/-34
Offline

Offline

Posts: 3393

Lead Developer

Re: need a module to display a list of boards

« Reply #4 on: January 04, 2007, 12:04:14 AM »

doh, I didn't pay attention to who posted it... thought Nathan did. Well, I did a bit of a rework if you want to compare. I was going to commit it to the repository and put it up for download if you have no problems with that.


	Logged

Need help? Check Here First!
Get the JSMF User Guide
SEARCH this forum.

exrace

Joomla Newbie

Karma: +5/-3
Offline

Offline

Posts: 48

Re: need a module to display a list of boards

« Reply #5 on: January 04, 2007, 07:45:39 AM »

Quote from: -Wolverine on January 04, 2007, 12:03:05 AM

There is code in here to try and make it work with JSMF.... it looks like the query was a bit messed up. I cleaned it up and reworked the query. Its all set and ready to go.

I get this error. Is this Upload OK?

Code:

Error fetching boardlist: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'b.ID_BOARD != 37 ORDER BY b.numPosts DESC\' at line 1 SQL=SELECT b.name, b.numTopics, b.numPosts, b.ID_BOARD, 1 AS isRead FROM smf_boards AS b LEFT JOIN smf_log_boards AS lb ON (lb.ID_BOARD = b.ID_BOARD AND lb.ID_MEMBER = 13) WHERE 1AND b.ID_BOARD != 37 ORDER BY b.numPosts DESC