Andrew Deren - 2002-2004
andrew@adersoftware.com
CFBB Forums change log
+ db changes
- description of changes done

---------------- V 1.0.0 [7-11-02] --------------------------------
07-11-02:
	- forgot password feature
	- ability for moderators and admins to lock topics and forums, only mods and admins can post and reply there
	- edit message by creator, admin and mods
	- delete message by admin and mods
	- Admin bad words options
	- Admin mail settings	
	- Email Validation for accounts. Random password is sent.
	- implemented security per forum: admin only, mods and admins
	- ability to make topics sticky (always at the top)

07-13-02:
	- fixed ubb img problem for unformating
	- fixed email ubb problem for formatting
	- removed any instance of script from img source (potential security risk)
	- fixed: when clicking on smilies from signature (edit profile) and clicking on smilie face, gives jscript error.
	- fixed: make signature ubb be on new line
	- fixed: Fix so that it doesn't show duplicate users in the stats
	- Admin users
	- Custom titles for users	
	- delete topic by admin and mods	
	- Avatars	
	
07-14-02:
	- added "Recent Posts" page	

---------------- V 1.0.1 [7-19-02] --------------------------------
07-19-02:
	+ add f_users avatarMessage varchar(50)
	+ add sp: spActiveUsers
	+ change sp: spStats
	+ changed stored procedure: spTopicVisit
	+ change all smalldatetime to datetime
	+ changed sp: spMyForum
	+ add to settings row: topMessage
	
	- preview button for signature on profile and register pages
	- custom avatar message that shows below the image on posts
	- fixed a problem where sometimes posting a message in a topic wasn't marking that topic visible
	- my forums shows forum and category info like recent posts
	- status on home page shows top 5 most active users in past 7 days
	- new most active users page that shows top 10 most active users in past 7 days
	- when quoting, signature is removed, edit history is removed and shows "orginal message by user on date time" at the bottom of quote
	- when reply to message is used (next to quote) show that message, not last one	
	- Finish security: password protected	
	- ability to have top message (between title and icons)
07-19-02:
	+ add sp: spDeleteForum
	- remove forums
	- remove moderators from forums
	
---------------- V 1.0.2 [7-25-02] --------------------------------	
07-25-02:
	+ change sp: spInsertMessage
	+ f_users: add deleted bit default(0), set all to 0
	- each message now contains IP address of who posted it
	- ability to delete users (mark as deleted) for admins
07-26-02:
	+ f_forum: add lastPostByName varchar(25)
	+ f_topic: add lastPostByName varchar(25)
	+ f_topic: add createdByName varchar(25)
	+ f_topic: add movedFrom int default(0)		
	+ add sp: spNormalizeTopic and spNormalizeForum	
	+ change sp: spDeleteTopic
	+ change sp: spInsertMessage
	+ change sp: spMyForums
	+ run: patch001.cfm to do proper update
	- remove all cftoken, when using cflocation	(prevents people using someone else's session if they post a link)
	- changed home page, so it does one query and grouping, instead of each query per category
	- create tag that updated forum with last post so that when deleting it can be used to properly populate the field
	- in forum and topic store last user name, so no join needed when showing forums
	- a lot of optimization to speed up home page of forums
	- ability to move topics to different forums by moderators and admins
	- do bad word filter on topic title	
	- changed delete topic so that num posts and topics for forum is decreased
	- optimized some pages for much faster loading
	
	
---------------- V 1.0.3 [8-6-02] --------------------------------		
08-06-02:
	+ add table: f_private_message
	+ f_users: has_new_messages int default(0) (update all existing users to 0)
	+ add sp: spInsertPrivateMessage
	- added preview button for admin user profile
	- fixed moving topic by moderator
	- private message system

---------------- V 1.1.0 [9-29-02] --------------------------------			
09-27-02:
	+ f_users: email_prv_messages bit default(0)
	+ add table: f_subscription
	+ add table: f_avatar
	+ add sp: spMySubscriptions
	+ add sp: spGetSubscribers
	+ changed sp: spMyForum
	+ new settings: useEmailServices, mostUsersOn, mostUsersOnDate, avatarUpload
	- Put pages on topic page for pages as at the bottom (so if a there are a lot of pages, it shows only some)
	- Added option on user profile to not show email address in public info
	- New setting called "Use Email Servies". When turned on all email services (private messages, topic subscription) will be enabled
	- Users have an option to have private messages emailed to them
	- Added code to expire session when browser is closed
	- Added most users on for forums statistics
	- Fixed my forums to only actually show thread that user posted in
	- Users can subscribe to topics to receive email notification about new messages posted
	- My forums includes all topics a user is subscribed to and a user can unsubscribe on that page
	- put checkInclude() call at the top of all eflag_*.cfm pages as a security pre-caution
	- custom avatars can be uploaded and have to be approved by admins or moderators
	
---------------- V 1.1.1 [11-21-02] --------------------------------				
11-21-02:
	- added few indexes to speed up loading of forum home page
	- fixed bug, when coming to page and new session was created (from last saved info) wasn't setting new messages at the header properly
	- in admin menu there is new menu "admin avatars" where all uploaded avatars are shown and can be deleted by admin


---------------- V 1.1.2 [1-12-03] --------------------------------			
01-12-03:
	+ f_forum: add hidden default(0)

	- added new index to speed up status retrieval (might need to work on caching it). Speed improvement for 1000ad forum from 3000ms to 300ms
		SQL to create index: CREATE NONCLUSTERED INDEX [f_message8] ON [dbo].[f_message] ([createdBy], [createdOn] )
	- added top button on home page for each category
	- admin:review avatatars has now pager at the bottom and shows 25 avatars per page
	- made member list more secure against URL attacks by checking parameters for sort and sort by
	- member list: now can click on column to sort and added location to sorts
	- new admin stat reports: posts last 30 days, posts monthly, users created last 30 days, users created monthly
	- ability to mark forum hidden (does not show on home page)
		
---------------- V 1.1.3 [8-26-03] --------------------------------					
08-26-03:
	+ add sp: spUpdateUserSession
	+ add index: f_users (last_visit)
	+ change spStats
	
	- topic page shows page of pages count at top
	- each message shows message X of Count		
	- show icon for ip address for each message (shows ip address of person who posted the message)
	- message will show NEW on topic (messages) page if hasn't been viewed yet
	- confirmation about deleting message or topic
	- statistics at the bottom of home shows count of unique registered users for today
	- user info page shows last time user visited 
	- user info page shows (next to post count) days user is active and avg. posts per day
	- a lot of security checks for possible hacks
		
---------------- V 1.2.0 [9-25-03] --------------------------------							
9-25-03:
	+ f_forum: add pollPermissions smallint default(0)
	+ f_topic: hasPoll bit default(0)
	+ New Table: f_pollQuestion
	+ New Setting: maxPollQuestions

	- ability to create polls. Admin can set poll permissions per forum: by admins, by mods or by all users
	- in admin users can see all admins and all moderators
	
9-28-03:
	+ New Setting: blogOn
	+ New Setting: blogEntriesPerPage
	+ New Table: f_blogCategory
	+ New Table: f_blogEntry
	+ New Table: f_blogEntryComment
	+ f_users: add blogOn bit default(0)
	
	- blog application integrated info forums
		
9-29-03:
	+ f_users: add blogCommentNotify bit default(0)
	
	- blog user can delete comments posted to their blog
	- bottom of forum stats show most active bloggers
	- blogs home page (link at header of forum)
	- blogs stats in admin
	
10-6-03:
	- blog home page shows 15 most recent entries	
	
10-21-03:
	- admin can remove user from all moderated forums at once	
	- mods on home page show in alpha order
	
10-26-03:
	- fixed bug for paging in private messages sent and saved folders	
	
11-10-03:
	- fixed hack when forum was secure was able to alter URL to see last message posted in reply
	
11-11-03:
	- admin can search user sessions by username or ip address	
	- user sessions admin reports (last 30 days, by month)
	- user received private message if comment is posted to their blog
	
11-13-03:
	+ New Table: f_userGroup	
	+ New Table: f_userGroupUser
	+ f_forum: add access_groupID int default(0)
	
	- ability to create user groups
	- each forum has new security option to allow certain group to only access it
	
12-04-03:
	+ New Setting: showUserPostsCount	
	
	- ability to turn-off user post count on topic page and also turns off most active users on home page
	
---------------- V 1.2.1 [1-6-04] --------------------------------								
1-6-04:
	- hidden forum posts do not show on recent posts list
	- most popular topics report from admin
	- admin reports show total & avg for graphs
	- new who's on admin report
	- general stats report that also shows db size and avatar library size
	
1-22-04:
	- recent posts groups posts by days ago 	
	
---------------- V 1.3.0 [2-11-04] --------------------------------								
2-11-04:
	+ f_forum: add hide_recent bit default(0) 
	+ f_forum: add moderated bit default(0)
	+ f_topic: add approved bit default(1)
	+ f_message: add approved bit default(1)
	+ f_users: add ismod smallint default(0)
	
	- admin utility: delete old private messages
	- ability to mark forum "Hide Recent" where topic from this forum will not show up in recent posts list
	- ability to set forum "moderated". New topics & messages need to be approved by moderator or admin	
	- avatar library management (can upload & delete avatars from regular library)
	- topics page lists moderators at the top and shows moderator icon below each moderator post
	- fixed bug: admin update username is not saving it
	
2-15-04:	
	- fixed bug: not allow to vote when not logged in
	- if topic is locked, no more voting is allowed
	
2-16-04:
	+ f_users: add sendModMessages bit default(0)
	
	- moderator has option to turn off moderator messages sent to their in-box	
	
2-28-04:
	- avatar text (below avatar icon) is filtered for bad words	
	
3-7-04:
	+ f_pollAnswer: add ip_address varchar(15)
	+ f_users: createdIP varchar(15)
	
	- ip addres is tracked with each poll vote
	- admin can see poll results with who voted what	
	- admin can see ip address used to create account
	- fixed search by date range	
	
3-8-04:
	- forum topic list: clicking on multi-page topic takes to first page instead of last
	- forum topic list: show "last" link for last page for multi-page lists
	
8-4-04:
	+ New Setting: gmtTimeOffset
	+ New Setting: blogRssEntries
	
	- admin util: delete old sessions (option for all or annonymous only)
	- blogs screen shows most popular blogs and num. commetns and times read columns
	- RSS feed for individual blogs and most recent blogs
	- localization setting for GMT time offset (currently used by RSS blog feed only)
	
	
---------------- V 1.3.1 [8-30-04] --------------------------------								
8-30-04:
	+ New Table: f_forumSubscription
	+ New Setting: lastSubRun
	+ New Setting: newUsersBlogOn
	
	- ability by admin to add subscribers to forums (will receive email notifications about new topics/posts)
		need to schedule: admin_emailsubscribers.cfm in cfide/administrator scheduler
	- admin categories: shows forums and links to add/edit	
	- user admin screen: shows all groups and forum subscriptions for this user
	- admin blog option: new users can be set to have blog on by default
	
9-22-04:
	+ New Settings: showWebsite, showLocation, showOccupation, showInterests, showAIM, showICQ, showMSN, showYahoo
	
	- logo image can be relative path or absolute path
	- if no logo image is specified, nothing will show (was showing broken image)
	- fixed bug: update blog categories now works	
	- user lookup dialog: used on new private message screen & edit group users screen
	- if no custom avatar title and no ranks setup then nothing shows below name on topic screen (no more -(empty)-)
	- user info page shows link to send private message
	- admin has option to hide/show general user info fields
	- admin utility to install default avatar library
	
9-23-04:
	+ New Settings: showCustomField1, showCustomField2, customField1, customField2
	+ f_users: add customField1 varchar(80), add customField2 varchar(80)

	- admin user sessions: option to see all
	- admin can upload/overwrite forum images from admin menu	
	- admin can setup 2 custom profile fields (give whatever name of the field)
	- admin stats reports (users created, posts, sessions and blogs) now have also weekly interval
	
3-7-05:
	- stats at the bottom don't show users with 0 posts or 0 blog entries
	
6-8-05:
	- fixed bug on userinfo when 0 topics in forums	
	
7-15-05:
	+ New Settings: pageWidth, lightColor, midColor, darkColor, bgColor, fontName
	- admin: look & feel: can change page width
	- admin can change colors of forums in admin : look & feel
	- admin can change forums font in look & feel
	
---------------- V 1.4.0 [7-18-05] --------------------------------									
7-18-05:
	- clean page variable before doing page include
	- if url does not have http:// in front of it, prepend it
	- fixed bug when posting new message/reply and session times out: message was not assigned with any user
	
8-26-05:
	+ New table: f_errorLog	
	- all cf errors are recorded and added to error log
	- admin can delete category with all forums
	- fixed bug when logo image was blank
	- admin user list is sortable
	
8-29-05:
	+ New SP: deleteUser
	- can totally remove user from db	
	
7-13-06:
	+ f_forum: add fileUploadBy smallint, fileUploadMaxSize int, fileUploadExt varchar(255)
	+ f_topic: add hasAttachment bit
	+ f_message: add hasAttachment bit
	+ New table: f_attachment
	
7-14-06:
	+ change spInsertMessage
	+ New table: f_sitetext
	- can add attachments to topics/messages
	- admin can specify sitetext (shown at the top and bottom) 
	
5-29-07:
	+ New Setting: noNewRegister - if set to true, register link will be gone and no new registrations will be allowed
	+ New Setting: requireLogin - if set to true, user needs to be logged in to view forum pages (pages are defined in application_init.cfm)	
	+ New Setting: allowForumSubscription - if set to true, users can subscribe to forums so that when new topic or message is posted they get notifications
	+ create index f_forumSubscription_userID on f_forumSubscription (userID)
	+ create index f_forumSubscription_forumID on f_forumSubscription (forumID)
	+ stored procedure spGetSubscribers changed
	- admin can create new user accounts under users admin page
	- users can subscribe to forums to receive notifications about new topics and messages
	
---------------- V 1.4.1 [7-12-07] --------------------------------										
7-12-07:
	- basic check for registration to prevent bots	
	
To do:
- ip ban

- forum visibility: always show, always hide, show for group users only
- admin backup database
- ability to reply to message via private msg
- Ability to turn on or off the "private mail" features on a user-by-user basis and on a system-wide basis
- per user quota on number of messages
- I'd like some system-wide way to say that I do or don't want copies of moderator notifications to be kept in the system

- deleted topics/posts go into deleted tables and can be un-deleted if needed (also need to see who/when deleted)
- use mssql free-text searching for search (optional)
- report message to moderator
- account activaction option: none, user, mod, admin
- skin directory for images/css files
- Forum mass mailer
- Time zone settings
- Blocking of users for private messages
- Insert ubb codes at cursor position and make cursor sit in between the codes
- option to turn off/on avatars
- do bad word filtering for fields of profile
- announcement topic
- chat feature
- friends list
- work on MS Access version
- work on MySql version



blog to do:
- edit message
- search blogs