LICENSE Copyright 2006 Raymond Camden Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. Welcome to Galleon. This is an open-source forums application for ColdFusion. For installation instructions, please read the word documentation. For folks who are upgrading, BE SURE to read the notes below. It details what changes in each release. This application was created by Raymond Camden (ray@camdenfamily.com). You may use this application as you will. I ask that you link back to my blog (http://ray.camdenfamily.com). If you find this app worthy, I have a Amazon wish list set up (www.amazon.com/o/registry/2TCL1D08EZEYE ). Gifts are always welcome. ;) ---- LATEST VERSION ---- 1.7.012 (May 1, 2007) /admin/users_edit.cfm - Do not htmleditformat the password or email address. /cfcs/settings.ini.cfm - Version ---- ARCHIVED UPDATES ---- 1.7.012 (May 1, 2007) /images/gravatar.gif - used for people who don't have gravatar accounts /cfcs/message.cfc - use isTheUserInAnyRole /newpost.cfm - ditto above /messages.cfm - ditto above /message_edit.cfm - ditto above /thread.cfc - ditto above /Application.cfm - case fix for the factory /cfcs/utils.cfc - Changed udf isUserInAnyRole to isTheUserInAnyRole. This was not done for any special purpose. Really. /cfcs/settings.ini.cfm - changed a few values for my own testing, but the real change is the version 1.7.011 (March 2, 2007) /rss.cfm - Title wasn't dynamic /cfcs/settings.ini.cfm - just a version change 1.7.010 (February 26, 2007) /admin/users.cfm, threads.cfm, and messages.cfm support filtering /tags/datatable.cfm - ditto above. /messages.cfm - use renderMessage, not render (BlueDragon fix) /login.cfm - param a few form fields I assumed existed /Application.cfm - Use Factory - all factory code written by Rob Gonda /includes/udf.cfm - renamed querysort udf (BD fix) /stylesheets/style.css - style blockquote Please note all CFCs updated to use the factory. I was lazy and didn't update the top headers to reflect the new dates. /cfcs/message.cfc - use renderMessage, not render (BlueDragon fix) /cfcs/message.cfc - When emailing, remove [code], [img] tags. I keep the insides, not the tags. /cfcs/message.cfc - Add quote /cfcs/settings.ini.cfm - Version only. /install/mysql.sql - updated to use more indexes. 1.7.009 (December 18, 2006) /messages.cfm - lowercase the hash for gravatar /cfcs/settings.ini.cfm - Version only. 1.7.008 (December 8, 2006) /admin/gen_stats.cfm - I changed how I got stats. It breaks encapsulation, but it is 10 times faster. /admin/stats_charts.cfm - ditto above /cfcs/message.cfc - Support for [img]. Idea taken from Rick Root's CFMBB /cfcs/settings.ini.cfm - Version only. 1.7.007 (December 5, 2006) /cfcs/message.cfc - Slight change to emails sent out - it now includes the username /cfcs/settings.ini.cfm - Version only. 1.7.006 (November 16, 2006) /cfcs/message.cfc - fix two bugs related to deleting of messages /cfcs/settings.ini.cfm - Version only. /Attachment.cfm - fix code that figures out attachment folder 1.7.005 (November 14, 2006) /cfcs/settings.ini.cfm - Version only. /message_edit.cfm - error when attachments weren't enabled 1.7.004 (November 9, 2006) /cfcs/settings.ini.cfm - Version only. /message.cfc - In the past, if the sendOnPost person was subscribed to a thread, s/he would get 2 emails per post. Now you only get one. I also tweaked the message sent to subscribers a bit. I added the Conference/Forum/Thread Name to the body. /pagetemplates/main_footer.cfm - Changed footer link to riaforge. 1.7.003 (November 6, 2006) /cfcs/settings.ini.cfm - Version only. /user.cfc - if no confirmation required, set confirmation to 1 /message.cfc - I broke activateURL support, fixed now 1.7.002 (November 6, 2006) /admin/gen_stats.cfm - added  s to a few rows so they show nicer in Firefox when the cells are empty. /cfcs/settings.ini.cfm - Default to NOT encrypt passwords so default DB scripts work. /newpost.cfm - Error if no attachment /messages.cfm - ditto 1.7.001 (November 5, 2006) /admin/conferences_edit.cfm + forums_edit.cfm changed textareas back to test /cfcs/conferences+forums - varchar not longvarchar for description DB scripts updated for above, also, I forgot to add the signature column /cfcs/forums.cfc - bug in adding new forum 1.7 (November 3, 2006) DB Changes: forums - add attachments as a bit messages - add attachment, filename as varchar/255 /admin/forums.cfm: Show attachments column /admin/forums_edit.cfm: Allow attachments /admin/messages_edit.cfm: Show and allow removal of attachments /cfcs/forum.cfc - Attachment support /cfcs/message.cfc - Attachment support, render of message entries moved in /cfcs/settings.ini.cfm: New properties encryptpasswords - if true, encrypt passwords in the db and don't allow password reminders allowgravatars - if true, show gravatars safeExtensions - list of safe file extensions for attachments /cfcs/utils.cfc - Some render functions moved out of udfs file and into here. /cfcs/user.cfc - password encryption, signature support /includes/udf.cfm - moved some funcs to utils.cfc /stylesheets/style.css - a few new styles /tags/datatable.cfm - minor change /tags/pagination.cfm - typo fix /attachment.cfm - new file /login.cfm - handle encryption and auto focus /message_edit.cfm - attachment support /messages.cfm - gravatar, sigs, attachments /newpost.cfm - attachment support /profile.cfm - signature support, support updating email /search.cfm - js fix by user /install/ All sql install files /install/unsupported/ folder added. Has Oracle mods for older version. /messages.cfm, newpost.cfm - show renderHelp /cfcs/message.cfc - add renderHelp 1.6.2 (August 4, 2006) /forums.cfm, /index.cfm, /login.cfm, /message_edit.cfm, /messages.cfm, /newpost.cfm, /profile.cfm, /search.cfm, threads.cfm - Show title Oracle version is now in the unsupported version. 1.6.1 (August 3, 2006) Typo in SQLServer install script. Thanks Josh Rogers. No version change. 1.6.1 (July 27, 2006) /install/ - All DB scripts updated. The size of the name fields for conferences, forums, threads, and messages are now all set to a max of 255. There was also a bug in the mysql script that limited the size on one field to a low number. /admin/conferences_edit, forums_edit, threads_edit, messages_edit - all had the sizes removed from name fields. /cfcs/conferences+messages+forums+threads.cfc - support for new size and new email of full messages. Also added wrap to emails. /cfcs/settings.ini.cfm - added fullemails key /messages.cfm + /newposts.cfm - updated with new sizes 1.6.002 (July 21, 2006) DB install scripts had a bug. /cfcs/settings.ini.cfm - just a version change 1.6.001 (July 17, 2006) /admin/user_edit.cfm - Bug when requireconfirmation was false /admin/Application.cfm, /Application.cfm - better "is admin file" checking. /cfcs/settings.ini.cfm - Just a version change 1.6 (final release July 12, 2006) DB CHANGES: Add confirmed as a bit property to the users table. If you wish to use confirmations, you must write a sql query to update all old users and mark them confirmed. FILE CHANGES: Note the updated files below. Most importantly, you need to rename settings.ini to settings.ini.cfm and add requireconfirmation, title fields. /admin/users.cfm - show confirmation /admin/users_edit.cfm - show confirmation, require one group /cfc/conference.cfc, forum.cfc, thread.cfc - show last user /cfc/message.cfc - fix saving for moderators, make title dynamic /cfc/user.cfc - confirmation support and dynamic title /cfc/galleon.cfc - use a cfm file /includes/udf.cfm - various /pagetemplates/main_* - Support dynamic title, show version /stylesheets/style.css - minor change to footer /tags/datatabase.cfm - confirmation support /tags/breadcrumbs.cfm - minor layout mod /Application.cfm - Better admin check, logout fix /confirm.cfm - new file /threads.cfm - show last user /search.cfm - auto focus on search box /login.cfm - require confirmation changes /index.cfm, /forums.cfm - show last user /installation - Word doc updated, PDF version added, and SQL install files updated 1.6 (beta released July 6, 2006) These notes are NOT complete. Install instructions NOT updated. File headers NOT updated. Please add "confirmed" as a bit property to the users table. Better release notes to ship in the final 1.6 version. 1.5 (no new version number) (released 11/22/05) /cfcs/conference.cfc - restrict length of search term and delete subscription clean ip /cfcs/forum.cfc - ditto /cfcs/message.cfc - just search term limit /cfcs/thread.cfc - search limit + sub fix (as conference.cfc) /pagetemplates/* All updated to turn off cfoutput only, and changed footer /stylesheets/style.css - added style for footer a /tags/pagination.cfm - another IE bug fix /search.cfm - limit size of searchstring /messages.cfm - allow bigger titles /install/ SQL scripts updated to reflect bigger message title. 1.5 (no new version number) (released 10/10/05) /pagetemplates/main_header.cfm - quick mod to login link on top /members.cfm - fixes for IE bug, and prevent message add if not logged in 1.5 (no new version) (released 10/6/05) /cfcs/user.cfc - fixed bug with subscribe /pagetemplates/main_header.cfm 1.5 (released 9/15/05) /cfcs/conferences.cfc - getConferences returns threadid of last post /cfcs/forum.cfc - getForums returns threadid of last post /includes/udf.cfm - udfs in support of sorting mainly /installation/mysql.sql - missing ; at end /stylesheets/style.css - change to support sorting /Application.cfm - support for sorting /forums.cfm - ditto /index.cfm - ditto /messages.cfm - ditto /threads.cfm - ditto The last 4 files also had a bug fix applied to paging, and links to last posts added. /Application.cfm - use an error template, error.cfm 1.4.1 (released 9/9/05) Admin pages expanded again to give more room. More information shows up as well. So for example, you see in the messages table the thread, forum, and conference the message belongs to. /admin/conferences.cfm - changed columns /admin/forums.cfm - ditto /admin/messages.cfm - ditto /admin/threads.cfm - ditto /cfcs/message.cfm - new cols return on getAll /cfcs/settings.ini - new version /pagetemplates/admin_header.cfm - small formatting changes /stysheets/style.css - ditto /tags/datatable.cfm - sorting added (finally) 1.4 (released 8/29/05) Unfortunately, I can't really list out the files that have changed since pretty much all files have changed. Here are the changes in features: No need for a mapping. A new settings.ini property, tableprefix, allows you to specify a prefix in front of each table name. So what does this mean? Your old table names would have looked like: conferences, threads, etc. If you needed to put these tables into an existing database, it may conflict with existing tables. Now you can use table names with a prefix, like galleon_. Update the settings file with this prefix, and Galleon will use the prefix when performing sql operations. Default install scripts use table names with galleon_ in front. Default settings.ini file uses this as a prefix. Sticky Threads: If a thread is marked as sticky, it will sit on top of the forum. Ranks: Allows you to give ranks to people based on the number of posts they have created. Admin - updated the look a tiny bit, and moved some general stats to the default admin home page. 1.3.7 (released 8/9/05) /rss.cfm - Links in the RSS need to be unique, so added a row counter. Thanks to Tom Thomas /messages.cfm - Fix typo /pagetemplates/main_header.cfm - Add Firefox auto-rss. Thanks to Tom Thomas. /stylesheets/style.css - fix for links in message footer 1.3.6 (released 8/3/05) /admin/users.cfm and /admin/users_edit.cfm - fixes to bugs related to 1.3.5 /cfcs/user.cfc - ditto above /pagetemplates/main_header.cfm - Use meta tags /messages.cfm and /newpost.cfm - refresh user cache on post /messages.cfm - reworked the bottom link a bit 1.3.5 (released 7/29/05) This releases changes how subscriptions work. In the past, as a user, you would just say yes or no to getting email when people post to threads you posted to. Now you have explicit control over what you subscribe to. You must updated your database. There is a new table, subscriptions. Also, the users table has removed the "sendnotifications" column. /profile.cfm, /login.cfm - changes to subscription support /forums.cfm - pass mode to pagination tag /messages.cfm, /newport.cfm - subscribe option /cfc/user.cfc and messages.cfc - changes for subscription /tags/pagination.cfm - show button All db scripts updated. 1.3.4 (released 7/15/05) cfcs/messages.cfc - I pass in the settings now. cfc/application.galleon.cfc renamed to galleon.cfc stylesheets/style.css - updated with a new style tags/pagination.cfm - changed rereplace to a nocase version messages.cfm - links to invidual messages, and hide bogus error msg 1.3.3 (release 6/17/05) Just changed the Reply link to make it auto go to login if not logged on 1.3.2 (Release April 15, 2005) Fix in getForums for MS Access in forum.cfc Minor layout bugs fixed in index.cfm and forums.cfm When we auto-push in index.cfm, addToken=false 1.3.1 (Released April 8, 2005) Fixed a bug in page counting: index.cfm, forums.cfm, threads.cfm, messages.cfm Removed lastupdated stuff in admin as I'm tired of updating it. 1.3 (Released April 6, 2005) Msg count and last post in conf/forums 1.2 (Released March 31, 2005) Re-arranged a bit about you post stuff. Re-arranged display of posts a bit. Fixed bad Util call in messages.cfc. Remember-me functionality. 1.1.1 (Released February 3, 2005) Fix to conference.cfc getLatestPosts() error for mysql Update admin/index.cfm with version #. 1.1 (Released February) Support for mysql, msaccess. Search update