This morning I released version 1.4 of the Galleon ColdFusion Forums. Changes are listed below.
- No need for a ColdFusion mapping.
- Table Prefixes: All this means is that you can specify a prefix for the tables in your database. This means that if you are at an ISP with limited DSNs, it is easier to get Galleon into an existing database and not have it conflict with existing tables.
- Sticky Threads: These are threads that stay on top of the forum display. This is useful for announcements, rules, etc.
- User Ranks: Allows you to assign a rank (or title) to a user based on the number of posts they have created. This is useful to help newbies recognize forum members who may be more experienced.
- Admin cleaned up a tiny bit. I added some basic stats to the admin home page as well.
You may download the code here. As always, Galleon forums are free for anyone to use for whatever purpose. All I ask is that you a) link back to me (not required) and b) consider visiting my wishlist if you find that using Galleon saves you millions of dollars.
Last but not least - for existing Galleon users out there, what feature should I work on next?
Archived Comments
Wonderful. Thank you! As far as future features, you mentioned planning to add subscriptions, so a user can subscribe to a conference, forum, or thread.
Presuming I have an updated version of Galleon and the subscriptions at various levels hasn't been addressed yet, this would be my suggestion. Thanks again!
Subscriptions were added a few versions back. :) You can subscribe to a conf, forum, or thread now.
I have to admit that I havent had a chance to look at a new version in a while, but did you ever get a chance to add coldfusion (and others is possible) code coloring to the posts in the forums?
BTW, I guess you still have power, hope everything is okay with you and the storm doesn't affect you too badly.
No code colouring yet. I'm not 100% sure how I'm going to do it. I mean I know how to color code. I'm not sure how the UI will work. I think the Macromedia forums have a popup or an attachment for you to paste code into, so I'm thinking something like that. I'll look into it when I add file attachments to Galleon.
Oh and the storm isn't doing much here, just some wind and a bit of rain.
Why not just do it like you do in the blog? just [code][/code] tags?
glad to hear that. Just talk to some family riding it out in biloxi ms, they have 115 mph winds right now, its rocking their cars and their electricity is out.
The code stuff is ok for blog authors, but not the general public I think.
Good progress Ray! Any chance you could add user photos so that if "User X" posts a message, the photo appears by their name on the post?
Prefixing tables is kind of kewl but it is easier to virtualize a data model by using the table owner rather than prefixing tables. Now only are there no collisions or fewer collisions of the namespace kind but one can more easily leverage multiple copies of the same tables using the table owner which from SQL Server 2000's viewpoint is nothing but a string - the table owner does not need to have an existing login in order for this to work.
Ray - makes sense - but I need something a bit simpler since I need to support MySQL and MS Access as well.
Ben: You mean avatars I assume? If so, it's in the works. It would be user defined.
Yeah, I meant Avatars. :) Thanks!
Also, will it be possible to setup Galleon as private or public forums?
When yo usay private forums, do you mean forums only available to certain people? I wasn't planning on doing it. Galleon has 'groups', but just 3 of them, and mainly meant to represent their role in the app.
Of course, you could install a second Galleon and put it behind some additional security.
Had to create an Oracle port of the database creation script to try it out on our server here. (You're welcome to the table creation script if at all interested, btw). Only issue I had was with the column named 'group' in the galleon_groups table---Oracle won't allow that name, as it's a reserved word. The queries are going to need some tweaking to account for Oracle, but other than that, it's a pretty straightforward port.
Hi Joel, I would be interested in any Oracle port of Galleon you get running - if I can be of any assistance let me know.
Support for international dates etc, via locale-specific formating please.