Change Log for uofacampwildcat.org

Site to-do list is here.

081001: Fixed a problem on the editapplications page where a second call to the DB was resulting in no custom questions being displayed for the application.
081001: Added quick links to board pages on /members.

080912: Cleaned up the look a little bit on docs2/default.asp.
080912: Fixed CSS so that IE shows main content pane centered on the page.

080604: Removed yearlast javascript validation from alumniregistration page for alumni editors.  Also verified that alumni entries can be created by alumni editors.

080529: Tweaked the alumni address exporter to just export address-related fields (helps since CSV export hits hiccups when a field has a CrLf in it).  Also no longer exports records if they don't have a physical address.
080529: Finally finished the alumni address updater tool.  Damn that was a lot of work.

080526: Made it so that admin and alumni editor updates to alumni profiles can be done without requiring an email address or password (e.g. in the cases where that info is not available).

080513: Removed display of alumni mailing addresses from alumni profile page.  This is a temporary solution until I can get some better privacy controls in place to allow users to specify what info is shared.

080501: Updated the alumni main page to show recent logins instead of recent profile updates.  Left the RSS feed unchanged so it still shows recent profile updates.

080418: Added all the stuff to allow certain alumni to edit the profiles of other alumni e.g. to update mailing addresses.
080418: In lookup.asp, disallowed loggin in if user is already logged in i.e. must manually logout before attempting to log in on another account.  This shouldn't affect anyone other than admins and users with both student and alumni accounts (none?).  This change was done so that when admins modify alumni info, they don't automatically get logged in as that alumni.  The alternate method for this would be not to redirect admins through lookup.asp after signing up the alumni on the listserv, but being able to log in on two simultaneous accounts is a little stupid anyhow.  Theoretically, this current solution might be a little better???

080328: Added an "administer" link to the bottom of event details page.
080328: Added more links to Arizona Alumni Association http://arizonaalumni.com.

080316: More layout fixes to allow messages to display correctly without trashing the rest of the page (auto scroll for the div).

080312: Added admin delete option with hash to image page.
080312: Added a more/fewer photos per page link at the bottom of images_db/default.asp.
080312: Reversed the order of events in the dropdown of the /ed/login page and added submit-on-select.
080312: Fixed some cosmetic issues with listapplicants.asp.
080312: (again) Converted fixed-length fields to memos in counselor apps...this time when storing positions in the applications table.

080311: Created /images_db/administer2.asp to make a slicker interface for putting images in/out of rotation.
080311: Had to do the "don't read the same DB field twice" trick to get the questions on the app to appear.

080310: Converted fixed-length fields to memos in counselor application customization table.

080305: Published all the changes.
080305: Avatar crop UI page was totally broken...fixed it.
080305: Added board session vars to /login processing.
080305: Added [edit] link to bottom of custom forms (visible only to board members).
080305: Fixed layout on CWiki list.
080305: Verified a fix on alumnidetails.asp where strID was being corrupted.  I think it also caused problems when someone posts a comment to an alumni profile.  Should be fixed now.

080304: Completed all the common header/footer migration tasks (in progress for 3 months).  All pages now use common CSS, so layout changes should be easier in the future.
080304: Reinstated and fixed the photo rotate feature.  Friggi' Flickr was changing the photo secret with every rotation, so it would break on every change.
080304: Reduced the number of events listed in the pulldown on /images_db/editphoto.asp.
080305: Changed layout on editphoto.asp, too.

080303: Retired /members/membershiplist_long.asp and hid references to it.

080128: Registered campwildcatmedia.org in hopes to eventually get rid of our shitty photo gallery.  800GB storage for $5.95/mo.  Experimented with some open source galleries, but haven't found anything worth transitioning to yet.

071224: Changed the SQL in /ed/deletemessages.asp to work correctly.

071220: Added alt and title tags to top banner and front page icon links to /members, /alumni, and /visitors in hopes that Google will pick those up as Site Links.

071126: Fixed strID corruption on alumnidetails.asp.

071120: Added more options to alumni relationship status field.
071120: Added "last seen" to alumni profiles.
071120: Changed avatar dims to 100x125.

071021: Added click-to-donate button to alumni main page.
071021: Added pdf.gif, doc.gif, xls.gif, zip.gif

070914: Tweaked agenda submission page to tolerate Monday board meetings.
070914: Also can edit agendas through Monday.

070702: Added alumni login tracking (as already in place for members).

070628: JMail is now totally gone (replaced with CDONTS).
070628: /lists is now totally gone.
070628: When members submit an application, a confirmation is sent to the applicant and (now also) the event directors (on CC).
070628: De-emphasized the "view all apps" option on processing page and on /ed...it's just not that useful in reality.
070628: Took printapplicants.asp out of service since it's now largely redundant with the improved main applications processing page.
070628: Added two "director notes" for event directors to add comments, groups, cabins, or whatever.
070628: Simplified the main apps processing page with fewer views and more stats per view.  Added several fields.
070628: I don't trust the email on the CW server, so I removed the "email these applicants" feature and changed it into a "here's a list...email them yourself" box.
070628: Updated "email these applicants" to use a semicolon-separated list instead of comma-separated.
070628: Removed an age-revealing note from the bottom of the listapplicants.asp page: "If you need to email this group from an email client like Outlook, Pine, or Netscape Mail, copy the list above and paste it into your favorite email program."
070628: ED / applications: emergency contact changes to view/print
070628: Counselor application: new SendMessage scheme, emergency contact info, and couple cosmetic changes.
070628: Cosmetic relocation of email address in student member profile view.
070628: Added member hometown and emergency contact fields.  Got rid of Permanent Address.  Emergency info only visible to profile owner and board members.
070628: Updated chat handle fields in alumni/member profiles to allow free text instead of selecting one service from a dropdown.
070628: forgotpw.asp would "find" an alumni record even for invalid email addresses because of some faulty logic that biased it towards a student member match.

070627: Hidden alumni need to be able to view their own profile page...duh.
070627: Alumni update RSS needed to be taught about privacy.

070625: Implemented new password recovery that resets the PW to something random before sending it out.
070625: Made password checking case insensitive.

070624: Changed mail component to CDONTS.  Should be CDO, but the authentication required to use that (to send from uofacampwildcat.org) is fucking with my ieee account.  CDONTS works (JMail was having the same problem), so that's good enough for now.  The components were authentication fine, but they just never made it through IEEE even with filtering turned completely off.  Who knows.

070618: Flickr changed their URLs for original resolution photos sometime recently.  I added some fields to the images table to store the originalsecret tags and such...plus the editphoto.asp link changes.  The original photos seem to all be on farm 1, but now the new ones are on farm 2.  Flickr offers URLs in their docs now that include the farm in the URL, but I'm not using them for now (doesn't seem necessary).  I bet I'll regret this at some point.

070612: Updated /mini/memberportal.asp to show date of of latest membermessageboard post and availability of apps, RSVPs, and signup sheets.

070612: Created /mini and /facebook with initial member portal preview page.  This facebook page has no knowledge of user identity.

070525: Added some explanatory text for first time member registrants.
070525: Made a sketch of what the new front door could be: http://uofacampwildcat.org/frontdoormockup1.asp.

070522: Added versioning and history to CWiki custom pages (finally).

070410: Added a "back" link on poll results page.

070329: Added niftycube rounding script to custompage.asp for each CWiki page since putting javascript in the custom part causes the editor to be confused.

070317: Fixed bogus vector in /polls/edit.asp.  Must've been a global find/replace error.

070308: Added full list of all CW agendas to feed to search engines for indexing.  Removed login requirements from viewagendas.asp.
070308: Added full list of all CW events to feed to search engines for indexing.

070307: Created /ed/searchevents.asp with Google AJAX search API.
070307: Merged event report stuff into showeventdetails.asp in order to create good pages for search engines.
070307: Extended the initial view of /ed/previousevents.asp to be two years.  More available by clicking the link at the bottom.  Page takes ~4 seconds to generate.
070307: Changed showeventdetails.asp to display event title as the HTML HEAD title (was generic).
070307: Tweaked print and screen CSS for agenda page.

070306: /images_db/getiframedata.asp was not updating with most recent event info.  Root cause was improper connection recycling in GetVersionedID().
070306: Photo upload event list wasn't doing versioned events correctly.
070306: Fixed some bogus DB connection sharing in /images_db/doupload.asp.  Result was an error whenever trying to upload a photo and tagging it to a certain event.  If shit like that's broken, it's no wonder nobody uses that part of the site.
070306: Updated /board/work/budget to /board/work/budgets and reorganized the page to be a bit more logical and task-oriented.
070306: Oops...forgot to remove some hard-coded SQL from /board/work/default.asp related to showing editable agenda.

070301: Agenda page will omit header/footer when printed.
070301: Tweaked agenda printing page so hopefully it won't lose text at page breaks.
070301: /board/work now allows multiple editable agendas from one board member.

070225: Fixed a race condition in capturing the ID of most recently added board agenda in submitagenda.asp.
070225: Added "delete this event" link to events2.asp (event edit page) for the user who created the original event and admins.
070225: Added more position-specific stuff to /board/work page.  Now includes ability to preview/edit the custom web page associated with the position.

070224: Added preview of news flashes for admins.
070224: Removed some h1 tags.
070224: Changed board agenda page to two columns for printing.
070224: Added ability to edit agendas plus personal preview on /board/work page.

070220: Changed textarea size on docs2 upload page.
070220: Added server-side CAPTCHA checking to foil bots who have cached the form's submit URL.

070218: Added static (client-side) CAPTCHA to /forms.  Cheesy, but should basically work.

070210: Migrated lost avatars to latest member records.  No known data loss.
070210: Corrected loss of avatar URL on inter-semester member update.
070210: Corrected loss of PreviousMemberID on intra-semester member update.

070208: Tweaked the admin access UI.  Added CW brochure to Visitors page.

070127: Some old images don't have a value for ModifiedID, which was causing an error in editphoto.asp.  Added an error handler.

070119: Fixed photo gallery ajax detail doupdate code.  Was confused due to recycled database connections.
070119: Fixed /docs2/dodownload.asp to tolerate spaces in file names.  Was pushing down filenames truncated at first space, therefore dropping the file extension.  Since we don't store the MIME type explicitly in the database (i.e. can't send MIME info explicitly), the client application association is dependent on the proper file name being sent (at least the extension).

061220: Changed /docs2 listing order to show most recently modified files first.
061220: Changed /docs2 max upload to 8MB and changed the error handling (still crappy, but better than before).

061122: Changed alumni gmap to use v2 of the API (v1 depricated).  No functional changes.

061109: Changed the nomenclature used for the inplace signup sheet on showeventdetails.asp (added RSVP) to help event creators understand what "RSVP" means.  Considered removing the term "signup" completely, but since users can't RSVP in the negative, we would still want "sign up" on the members main page...thus the hybrid naming.  Not optimal, but could be worse.
061109: 50% processing time improvement on /members/default.asp through smart DB connections in three places in general.asp.  This page is a dog because there are so many different types of DB access needed to render it.  ~360ms just for the base page plus ~60ms per event on the calendar.  Further gains could be made by additional merging of DB calls, but this has proven to be extremely susceptible (~100%) to mistakes.  The big query on the page is already a monster (mainly because of event and location versioning).
061109: Removed admin debug mode.  Now when logged in as admin, debug info is in hidden div at bottom of each page with "click here" link to make it appear.
061109: Added avatars to membershiplist_long.asp (and cleaned up the "other semesters" list).
061109: Bumped the ED login list up to 90 previous days (from 30).
061109: Removed ugliness from event report viewing/printing (it was nasty).

061031: Added api_sig to flickr POST operations.

061018: Changed "gender" to "sex" in counselor application.

061008: Removed border from alumni news flash area.
061008: Fixed a problem in the login form for users with no cookies and no previous login attempts (form was not blank).

060908: Fixed a multi-instance defect in event creation where RSVP slots and full sign-up sheets were not unique for each instance of the event.

060828: Pulled the scriptaculous candy from messagearea_component since Safari users were still(?) getting a grey inactive editor window.

060820: Moved message author posting credentials to static hidden fields in form (no longer post-submit, server-side lookup).  This is to avoid session timeouts and loss of post data.  Also added message posting hash to certify that the credentials have not been altered client-side.

060818: Added "alumni + members" access level to custom pages.

060817: Removed an iterator variable conflict (occurs on membermessageboard.asp) from poll_component.asp.
060817: Corrected the links on /polls/default.asp to point poll.asp instead of poll_component.asp.

060816: Added Google Analytics code to commontop.asp.

060811: Added CountRecords to general.asp.
060811: Changed to slide down preview of recently updated alumni profiles.

060807: Implemented the engine calls for buddy list addition/deletion/status (not rolled out in the UI yet).
060807: Added rights for members and alumni to delete comments made against their profiles.
060807: Streamlined the message deletion UI.
060807: Removed the admin's "clear this posting" feature (leaving only delete).
060807: Added a hash to message deletion calls for added security.
060807: Simplified strThisPageURL in commonheader.asp for reuse throughout pages.
060807: Switched to UserNameTag in messagedump_component.asp, /alumni/default.asp.
060807: Created UserNameTag to generalize presentation of member and alumni names across the site.
060807: Did a little URL rewriting in commonheader.asp to pretty up auto-login URLs (dropped /default.asp and extraneous ? before query string).

060806: Added photos in event director list on showeventdetails.asp.

060803: Added a purge routine to clean out any abandoned avatar photos.

060801: Added "last seen" to member profiles.
060801: Made avatars clickable in message dump.

060723: Changed anylogin.asp and memberlogin.asp to redirect to a clean URL if QUERY_STRING is empty.

060719: Streamlined implementation of "edit profile" links while viewing own member/alumni profile.
060719: Added avatar visibility to messagedump_component.asp.
060719: Swiped a *sweet* scriptaculous component from David Spurr (www.defusion.org.uk) for cropping avatar images.
060719: Added avatars to alumni and student profiles.

060713: Added commenting to alumni profiles.
060713: Added commenting to member profiles.  Comments are tied to MemberID, so they'll only last a semester.

060711: alumniregistration.asp fixed to remove maxlength parms from URL and ChatService fields (old legacy crap from way back when).

060705: CountMessages was looking at Time field (depricated) on /members/default.asp to show waiting messages on membermessageboard.

060630: Fixed default weeks logic in event listing on /members/default.asp.  Will now display the number of weeks specified in the control panel.  If it's more than 52, it will show everything (and change the display text slightly).
060630: Re-instated event-specific messaging RSS feeds.
060630: Created /rss/messages.asp to serve messages for the whole site (by board name or by context).
060630: Alumni message board now has parity with other boards (postings can be from alumni or members).
060630: Fixed admin-initiated alumni profile changes (site wasn't allowing these since the /login revamp).

060626: Added previous events list to showplace.asp.
060626: Revamped the "recently used locations" SQL to show a very-recently created location at the top of the list.  Rest of list is most recently used locations (either as Location or MeetLocation) sorted by frequency of use.  Same query is used for both Location and MeetLocation autocompleters.
060626: Quick event creation moved to ajax to catch cases where user is creating an event where MeetLocation and Location are the same (and both new).

060625: From member main page, all types of events can now have messages attached.
060625: Removed Yahoo Publisher ads from the site since they aren't making any money and ads that don't make money suck balls.  Damn Google for shitcanning us.
060625: Event-specific message boards merged into showeventdetails.asp.  Removed all event-specific calls to membermessageboard.asp (which used to be overloaded to also handle event-specific message boards based on event ID).
060625: Now calling eventdetails from main page by original ID (i.e. not cheating).
060625: Added selective logout to admin toolbox.
060625: Created component-based, two-tier message listing.  Now in use on membermessageboard.asp.
060625: All messaging functions consolidated to messageprocessing.asp.

060624: Auto-created complex signup sheets now have a default expiration date upon creation.
060624: Cleaned up some more event naming crap from applications area.
060624: Added automatic "apply here" link to event details page (in addition to /members/default.asp).
060624: /ed/previousevents.asp is now versioned-event-tolerant.
060624: Updated the "apps no longer being accepted" blurb on /ed/default.asp.
060624: Cleaned up the budget status page and added a usage note.
060624: Made budget status page tolerant of versioned events.  Budget status is actually tracked (legacy stupidity) in the events table instead of with the actual linked budget.  This means every time we touch the event version, we need to bring the latest budget status along.  Not a big deal, just more prone to errors.  Anyhow, updated events2.asp in this regard also.
060624: Added a parm hash to listevents.asp delete call in order to annoy Garrett, the URL tinkerer.
060624: Merged multiple event listing pages (mostly admin stuff) into listevents.asp.  Much cleaner and delete interface (JS confirmation + deleteversionedobject.asp) is better.
060624: Updated several lists to support versioned objects: selecteventtoedit.asp, deleteevent.asp, limitedeventdelete.asp.
060624: Created a new DB view to simplify listing out versioned events, etc.

060619: On signup addme and deleteme actions, removed explicit userid parameter from GET request (cookied ID now ref'd server-side).
060619: Removed welcome tag from /board/work page.
060619: Got rid of session("edeventtitle") usage in /ed/ area.
060619: Cleaned up formatting in editeventreport.asp and did the versioned title thing.
060619: A bit of cleanup on the Event Director main page.  It still sucks big time.
060619: Fixed counselorapplication.asp to handle titles of versioned events correctly.
060619: Fixed positiondescriptions.asp to handle titles of versioned events correctly.
060619: Corrected /ed/default.asp so that "edit intervew sign-up sheet" link appears correctly.
060619: Removed link from /ed/ to /sus/ since main /sus page should be obsolete now.
060619: Changed /sus/delete.asp to redirect to members main page (instead of /sus/) after deletion.
060619: Changed /sus/delete.asp so it wipes out links (in events) to deleted signup sheets.
060619: Fixed some funky variable (ID) conflicts in the common versioning logic so now signup sheet deletion works correctly from manualedit.asp.
060619: Fixed messagesrss.asp to correctly show alumni names.
060619: Fixed /members/default.asp to correctly show number of event messages when event has been modified.
060619: Cleaned up implementation of versioned event show/edit.  Rule is that versioned objects should always be passed by id=[originalid].  This can be overridden by using realid=[id] to grab a specific version of the object.  Otherwise, most recent version will be displayed/edited, but originalid is always used to track things that point to the object.

060611: Allowed alumni access to member list and member message boards.
060611: This also resulted in forcing message boards to track editors by ID (changes to DB table, links to profiles, etc).

060602: Fixed budget.asp to work correctly with versioned events.
060602: Fixed GetBudgetStatus function to grab info from most recent event version.

060528: Corrected members "calendar" table on /members/default.asp so all apply/signup links appear in the same column.
060528: Bots (Yahoo Slurp, specifically) are creating empty alumni registrations, but apparently without submitting the actual registration form (i.e. Slurp has indexed the form's target).  Alumniregistration.asp "add record" functionality now only runs when data is POSTed to that page and added a bota META tag to cease indexing of that page.

060527: Fixed type conversion problem in admin access control panel.
060527: On membermessageboard.asp, fixed a scriptaculous timing issue which was crashing Firefox on Macs and one TinyMCE issue which was causing a disabled editor to appear on Safari.
060527: Upgraded to TinyMCE 2.0.6.1 and re-migrated my customized implementation of the emotions plugin from 2.0.5.1.

060524: Fixed applications to internally reference the original event ID.
060524: Fixed members main events list query to correctly link EventCustomization to ModifiesID ("apply here" link was missing).

060521: Changed access rights on memberdetails.asp so that alumni can view this page.
060521: Added robustness for non-member views of member pages (e.g. alumni can view events, but not sign up).
060521: More place versioning tweaks on SUS pages.
060521: Added a little auto-synch script for DateBegin and DateEnd selectors on event2.asp.

060518: Fixed some SQL apostrophe problems in signup sheets, events, and locations.
060518: Changed to a slicker way for event2.asp to redirect event creators to multiple subsequent pages.  Now works for up to two new locations, one related signup sheet definition, and a final showeventdetails.asp link.
060518: Added automatic recognition of signup sheet editors into /sus/usersignup.asp.

060517: Added multi-slot signups for events (e.g. interviews, shifts, etc).

060516: Added extra map fields back to events2.asp.
060516: Removed cleanup event locations paradigm from board area.

060514: Fixed membermessageboard.asp so it sends users to the right message board once they post something on an event-specific message board (was sending everyone to main board).
060514: Fixed ED area to tolerate versioned events.
060514: Made places versionable and improved the editing/viewing pages.  Changed edit page to place2.asp.
060514: Added Google Maps to CW places.
060514: The new versioning data structure has blown all the events queries to hell, so that's been fixed in a number of places (most notably on the members main page).  If I ever get around to adding versioning to member records, it's going to be a bitch.
060514: Added an "I'll attend" signup slot for events (configurable on/off by event editors).  Members can now sign up to attend from the main page.

060511: Updated the LAF for vieweventdetails.asp.

060510: Added ajax notification of invalid contacts on the event editing page.
060510: Events are now versionable

060509: Fixed games upload (changed all text fields to be unconstrained Memo type) because Katie told me it was broken.  This must've been broken for many months (maybe more than a year) and nobody ever complained.

060504: DB changes: remove "required" and "allow zero length" crap from legacy Events table; add RSVP field to Events table; allow multiple numbers and values in Properties table.
060504: Added easy "sorry...site is offline" functionality to be used when updating the databases so no data is lost.

060502: Basic clean-up of the event creation page (now events2.asp).  All these years and nobody ever complained about how crappy it was.  It's amazing what people will tolerate.
060502: When creating an event, users now have ajax goodness to select the location.  Will automatically defer location detailing if needed.

060430: Lots of ajax experiments.  Nothing deployed.


060423: Simplified tinymce editors to just use a few paragraph styles.
060423: Updated pages linking to /docs/ to use /docs2/ instead.
060423: Removed the remaining pointers to /member/login.asp.
060423: Converted memmber message board to use tinymce instead of RTE.  Added some script.aculo.us candy.

060420: Alumni can now add/edit photos in Photo Gallery.  Links to uploader and modifier profiles are handled appropriately (either member or alumni profiles).
060420: Changed Photo Gallery thumbnails to use CSS floats instead of tables...much cleaner and properly sized for different browser window widths.
060420: Added some new fields to messages table for future extensibility.
060420: Finally got the user counter working in a decent way.  Now counts actual logins during the past 20 minutes instead of ramping up/down a counter based on new sessions (unreliable due to spiders and RSS aggregators).

060418: Automatically display photos from Photo Gallery as part of member profiles.
060418: Members message board has updated look and initially-hidden posting form to conserve space.
060418: Updated LAF for members home.
060418: Common login for all users.  Alumni users now are required to use passwords.

060328: Added NiftyCorners to main page