Change Log

To Do Items

• Need error checking and other items in ALL model and controller objects.
• Add page versioning management.
• Need a "Purge" function for old versions.
• Need to setup a proper Pear install for just FBSite installs. No we don't, see below...
• Make Navigation work on multi-levels.
• Need Gallery category manager
• Fix the login.php form when unsuccessfully logging in.  It shows the default form, and that will not work.  Currently you will need to browse somewhere else, then open the login form again to try again.
• Convert all to PDO instead of Pear::DB. I like the PDO functionality better, and it's a little faster, and it works with SQLite 3! In addition, change the AUTH module to our own classes.
• AFTER convert to PDO, make a new Document module for storing PDF's or Word/Excel docs.
• We need a "delete" function.
• On Blogs, we need delete and "published" status, so they wont show if not set. Would be nice if you have a "WIP".
  

Version History

0.6.8 2007-06-06

• Fixed blog and page additions for newly generated page list. List showed all objects, when must only show current type. (blog or page)

0.6.1 - 0.6.7 Mar - May 07

• Several small updates - Added functions to contactus.php and it's form. Allows adding individual mailers on a contacts page.
• Again on mailer, added USESMTPAUTH if server needs on mails.
• Updated Gallery so now can order by descending. (set in constants.php)
• Fixed issue where could not add new pages or blogs because of NULL constraints. Problems actually started because of update to obj table in 0.6.2, SQLite took out defaults on not null fields. In 0.6.7, must run the update-sql script to fix the table.
• Set default on new page to NOT show on nav. User must set property after creating page.

0.6.0 2007-02-24

• System now loads pages dynamically from SQLite database records, instead of publishing a new PHP page by writing to a new file. This was for security reasons, mostly, but partly because in order to work on other web hosts, we had to remove the ability to write PHP. (most hosts cannot write under the Apache user (nobody) in your home directory, where your web root is hosted under your user account name.) All pages called, are now just read from the database based on the page requested, and subsequent content is loaded.
• The new content load changes require updates to: (add fbsite_script_start to top)
  • fb_blogs.php
  • fb_editpage.php
  • login.php
  • logout.php
  • fbsite_changelog.php
  • fb_gallery.php.
  • Remove it form header file.
  • system pages are now loaded from fb_showpage.php
  • index.php on root must redirect with header statement to the /site/index.php folder.
  • /site/ folder must have new .htaccess file with rewrite rules.
  • constants.php now has PDOSQLITEDB setting, path to the db.

0.5.25 2006-10-30

• Added 'appendToFile'. (useful for logging.)
• Reworked the blog_comments files to capture loging of failed updates and BLOCK SPAM! We now disallow URL's in the comments unless you are logged in. There is a new constant for BLOCKLINKSTR (true false). This will block any links in comments if set to true.
• Created a simple stampDateTime function that returns a YYYYMMDDHHMMSS string. I seem to always need this for misc functions and logging.
• There s a new dateSelectForm function too. It returns a group of date select option items for forms. You would need to concat the return results on the form processing as they are 3 different items on the form.
• The core controller js file has added a new HR element.
• Tiny MCE is now 2.0.7!

0.5.24 - NEED TO FIND CHANGES

• Added gen_ip_inssql.php script to generate a bunch of insert statements for use in SQLite. Makes it easy to filter out an entire subnet of IP's on the logs.

0.5.20 - .23 2006-06-26
Forgot to update changelog from .20 though .23. Many updates.

• TinyMCE upgraded to 2.0.6.1. And added Charmap, table tools, and other misc TinyMCE config changes. (resizable editor)
• Can now disable/renable the editor by push button. (Code button)
• Dojo Toolkit upgraded to 0.3.1. No new features added to FBSite for this, however, you must now manually "require" dojo modules when loading. So, on the fbsite_editpage_controller_startup.php file, the startup() function includes a few lines to load dojo.fx and dojo.io.
• Bigest update, we changed fb_navpublisher.php to include a new helper file (full of functions) and in that, we now generate a 2 level menu! Only 2 at this time (root/parent and a child), we may work on a 3 level later, but if that is really needed, then you can just create your own fbsite_nav_main file. (and disable the config item to use nav) The new nav publisher uses several new template objects in the template folder. Styles are also used in the nav_styles.tpl file, and this generates styles_nav.css in your doc root. The templates are all CSS driven to limit the use of too many tpl files. You do need: nav_item, nav_subitem, nav_styles, nav_start, nav_end, nav_spacer. These files are used to create the fbsite_nav_main.php file, and they now create php nav code instead of html. This gave us greater control over the menu and still allowed us to skip javascript. If you need your own PHP code or Javascripts in the template, then just add that to your nav_start.tpl file.
• 0.5.20 added a google site maps generator based on all the site pages. Running the fbsite_ gen_googlemap.php will create a file called google_sitemap.xml in your doc root. This update required an update to SQL, so remember to update with the sql file/script. (need to add this to page properties.)
• 0.5.23 also added major update to logging functionality. Now much more useable. But, could use even more updates for drill down details. Main thing is that you can now filter out multiple IP's. BE SURE YOU UPDATE the sql, as there is a new table added. (included default search bots filters)

0.5.19 2006-04-01 (no it's not an April fools thing)

• Created a new theme-based gallery listing. Now we can review the gallery based on your own theme. There are 5 files that must be present in the THEMEDIR folder. They are all prefixed by "gll_".
• Also on gallery listings, there is a new global var for GALLERYLISTCOLS. Setting this determines how many columns wide to list your gallery. The default is 2 to fit in most content areas, but you may prefer 3 or 4 wide. In which case, you may want to make a new listing theme and adjust your thumbnail size prefs.
• Updated TinyMCE to 2.0.5.1. FINALLY! Couldn't run my own callbacks though, so we lost the "data changed, save" message.
• On TinyMCE, we've added Paste From Word and a few other options. This will be handy in lieu of a proper spell checker.

0.5.18 2006-3-29

• Added Site Stats in Admin. System uses a simple logging function to record visitors into a separate SQLite database. You must have the file /db/fbsitelog.db setup properly. It is recorded and reported using PDO instead of the Pear DB. You must also call the logger.php file at the very end of your html_footer. The logger will only "try" to log, if anything fails, the system should continue processing anyway.
• Had to add a new function in core, spacesOnlyToHyphens. The was due to the new change in 0.5.17 to update spacesToHyphens. (which properly removed anything that wasn't a apha-num or hyphen.) The new one will only remove spaces. (used in gallery upload)

0.5.17 2006-3-25

• Added Auto-generating navigation! So far can only generate a single level of nav items, but this will do for now.
  This system uses a "templates/tplname" structure now. So the nav is all templated. So far there are 5 template objects just to generate a nav item.
• Updated contacts forms to save to fbsite.db.
• Don't forget to run the 0.5.17 sql file update! And add the new constants OR YOU WILL OVERWRITE YOUR NAV_MAIN FILE! You must set GENERATENAV to false if you do not want this feature.
• Added Blog Comments!

0.5.16 2006-3-18

• Updated edit page list so you can see the pages in name order. Also removed any set to isdeleted = 1.
• Added BLOGS! To upgrade, run the 0.5.16 sql file. Plus there are some extra css properties you must add to your stylesheets, as well as some constants for constants.php.

0.5.15 2006-03-13

• Quick gallery changes. Nothing big.

0.5.14 2006-03-01

• Reverted back to TinyMCE 2.0.2 because 2.0.4 was not working all the time in either IE or FF. When I have time I'll look into this and get updates back in.

0.5.13 2006-02-28

• Updated SQLitemanger include_path strings to include root parent paths. "../../" This was needed because we moved config.php up one folder (v.0.5.10) and SQLitemanager could not find it.

0.5.12 2006-02-28

• Upgraded TinyMCE to version 2.0.4.
• Updated login.php to disallow "continue" if login incorrect. (it wouldnt take you to the continue page anyway, but it was confusing to the user this way.)
  

0.5.11 2006-02-27

• Updated the Gallery to perform correctly under any 'site' folder pages as an included php script.
• Cleaned up the gallery slightly.

0.5.10 2006-02-26

• Added several new obj properties. (note that some of these are setup but not yet changing the objects presentation.) Be sure you run the sql updates from the file 0.5.10-propupdates.sql in sqlitemanager. Then, you must republish every page on your site to include the property updates in the page headers.
• menu_text: used for a the actual text on navigation.
• menu_parentid: used for navigation parent item. submenu.
• menu_subparentid: second level submenu parent.
• useflashbanner: Use the Flash banner enabled in the html_header template. (must be included in the php code of the header.)
• usenobanner: Shut off the banners. Useful in FBsite or other pages. (must be in the header php code.)
• objnotes: Notes about the page. (1000 characters)
  
• Moved config.php and constants.php to fbsiteroot path instead of in the fbscripts folder. Make SURE! you move out if you are upgrading from 0.5.9 and earlier.
  

0.5.9 2006-02-24

• Touched up Gallery mod. Made the "edit" functionality with some Ajax goodness! You can now update the category and caption on gallery items.

0.5.8 2006-02-12

• Added 'userte' switching on save/publish. This allows the setting under properties to turn off the TinyMCE editor on desired pages.

0.5.7 2006-02-08

• Added several form element Divs (Add, Image, Images) for updating and uploading. Images, when clicked, will show a line blow the box that can be pasted into the TinyMCE editor image form. That url should work fine from editors and published pages.
• Created Update functions for page Properties using Dojo Ajax requests. (no page loads on these items!) In fact, all the new form objects use Ajax. The only items requiring page loads are Save and Publish.
• Updated login and logout. Logout redirects to home page, and login just gives a link to Edit.

0.5.6 2006-02-07

• Updated page details nav for edits.
• Changed header and footer to reside in fbsiteroot. This will make the template easier to distinguish and maintain.
• Changed all ini_set paths to include the location: ../ (to include the lower directory for header/footer)
  

0.5.5 2006-02-06

• Changed edit page forms to use standard form submissions on page data. (publishing too). This means less fancy Ajax, but better reliability. This is due partely to the tinyMCE integration, and timing on my part. (just need more time to resolve all issues cross browser) The problem started after running over Internet and in IE, some page data would not refresh reliably on submit. Rather than fight it, I now save using standard html forms to php processors. Will use Ajax for 'Add new' and other lesser items though.

0.5.4 2006-02-04

• Added Use RTE and On Nav options to each page. This allows us to disable a page on nav (future versions) and more importantly, for system pages or by preference we can turn off the fancy editor and just use HTML.
• We changed the page/form loads in the editor to all load from javascript instead of HTML from model objects. The new model objects are using PHP generated Javascript, which dynamically update the data in the browser.
• Added fbDebug option in config.php. Turns on some debug info.
  

0.5.3 2006-01-24

• Fixed Tiny MCE options and init. No more ?'s.
• Tiny MCE will now not load unless a marker in each page requiring it has '$requirerte = true' set.
  

0.5.2

• Added options for Use RTE and Disable nav pages. (Also, added system objects by including an 'objsystem' column in obj table.)

0.5.1

• Added Publishing to PHP files from SQLite revisions.
  
• Added 'Add Page' function.
  

0.5.0

• Started the new version on PHP and Dojo Toolkit.