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.
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 »
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 »
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.
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
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
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
looks like Im missing a space there... here is 'nother version
Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use
Author
Forum
Logged
