AbleDesign

[Dan]

I'm happy to anounce the v1.10 release of MyCalendar. The list of improvements includes:

- changed to specifying the database name in all queries in case the program is used on the same page as another program querying a different database
- replaced most of the manual path & URL settings in config.php with auto-detecting options
- overhauled the main calendar display (full month) to use a single database query for the entire month instead of one for each day -- much less resource intensive and results in pages that load 5-6x faster (from 0.08 seconds down to 0.015 on an average sized calendar)
- improved logging out, now actually shows you as logged out on the first page you are brought to, instead of still seeing the logged in options
- added color highlighting of mini_calendar for days that contain entries
- added tooltip popup for highlighting of mini_calendar, containing the title of any event for that day
- option to not display mini_calendar highlighting - no highlighting means slightly faster loading pages
- option to not display mini_calendar highlighting for full year wall calendar displays
- allow users to create their own account (with or without admin approval); can be turned on or off
- allow anonymous user submissions; can be turned on or off
- automatically email user after validating their account
- retrieve lost password with new encrypted password automatically created
- allow users to change their password and/or email address
- added admin tools for adding, viewing, deleting, editing, and validating users, including multiple at once options
- moved many of the administrative functions to admin.php to keep index.php uncluttered
- added a two-part option to automatically build dropdown selection boxes -- allows the form name and value to be different if desired (concise database storage for numerical flags while presenting something easier to remember than a number)
- added a Date_Added column to the Users table just in case the info is ever wanted...
- when editing a user account, password will not be re-encrypted if it is already encrypted -- avoids creating a non-retreivable password
- fixed the mini calendar tooltip popups to work with entries with apostrophes in the title
- added a file containing US holidays for 2001, 2002, and 2003 that can be easily imported into your database
- changed variable names throughout the program to shorter versions, such as $y, $m, $d instead of $year, $month, $day (shorter URLs)
- fixed add/modify bug that caused recurring entries containing auto-hyperlinks to be re-linked with each occurence
- "list all" user searches now default to sorting by user ID in ascending order
- improved handling of max table ID's to properly echo the ID of the item(s) added to the calendar
- added a Time field to the Calendar and Validate tables for optionally displaying an event's time in addition to the date
- added the option to specify 12/24 hour time formats for the day displays
- added a Holiday field to the Calendar table (for future use) to flag holidays

The online demo is now running version 1.10:

http://accountbiller.com/demo/calendar/

Cheers,
Dan

[Dan]

A few bugs have been squashed and improvements made to v1.10, so they have been added to the current 1.10 distribution. The changes include:

- changed holiday_data.txt to work regardless of magic_quotes settings
- do_login.php did not get a variable updated for correctly forwarding failed logins
- made current day highlighting on month display optional
- for full year calendar, added next/prev links to quickly jump between years
- added an optional .htaccess file in case your server does not allow index.php as a directory's default index file
- tweaked set_variables.php to always look in the current directory for variables.php
- fixed add_to_validate.php which did not contain the recently added Time column

Cheers,
Dan