ArsDigita Community System Version History

Version History

for the ArsDigita Community System by Philip Greenspun and Tracy Adams.

Future Versions:
- add scoping to the events module and make it conform more to ACS standards - Bryan Che
- ad server enhancements - Tzu-Mainn
- better support for private chat (Live Person)
- class administration module - Randy and Aileen
- spamming bring closer to ACS admin UI standards - Henry Minsky
- member value enhancement - Malte Sussdorf
- ecommerce - multi-store functionality Eve
- process control module
- enhanced survey builder
- content management system (pset 3)
- knowledge mangement system (pset 4)
- room registration system (pset 2)
- PIM (calendar)
- appearance improvements and publisher-controlled layout
- user-extensible table module tool (makes it easy to build systems where each user can have custom columns)
- open source administration module
- likely modules to expand - ecommerce
- ticket tracker enhancement
- bboard enhancement
- improved template system (karl)
- form management system (karl)
- expanded self-documentation and collaboration around develoment
- auctions module - rwsu
- Manual system (kevin) - need to get CVS running chroot.
April 12, 2000: Version 3.2.2:
- rewrite of download module to fix version problems (ron)
- fixed several problems in abstract url (jsalz)
March 27, 2000: Version 3.2.1:
- minor fixes to general permissions (michael)
- fixed trailing slash bug in abstract urls (jsalz)
- fixed lots of problems in file-storage (tina)
- added bookmark open/close feature (carsten)
March 17, 2000: Version 3.2:
- Spam system supports tcl templates, encoding and sending of multipart MIME messages containing text/HTML, and uses new user email_type preference to decide which content type to send. A preliminary version of gregh's bulkmail module is included, which allows the spam daemon to pump mail out multiple threads to multiple SMTP servers in parallel. That also supports email bounce processing, to automatically maintain clean mailing lists. (hqm@arsdigita.com)
- Changed the primary key of user_group_map from (user_id, group_id) to (user_id, group_id, role), to enable users to be in more than one role per user_group. Note that this change turns code like "ns_db 1row $db query of user_group_map with criteria for user_id and group_id" into bugs waiting to be discovered. (michael@arsdigita.com, yon@arsdigita.com, markc@arsdigita.com)
- Re-wrote events data model so that it would support user-group-based registrations and use a registrations/orders model. Re-wrote tcl pages to use new data model (bryanche)
- Fixed security hole in /bboard/admin-update-topics-table.tcl. This script had no user validation whatsoever. Anybody (even a nonregistered user) could update anything in the bboard_topics table just by visiting this script (branimir)
- new general permissions (michael, richardl)
- cleaned-up classified ads system (standard comment headers, ad_page_variables) with ability to attach photos to ads
- improvements to the contest system, at least to support arsdigita.org (markd)
- simple survey builder (jsc, philg, surati, teadams)
- Web based email system (jsc)
- new security subsystem and session tracking system (jsalz)
- abstract URL system (jsalz)
- new system for preloading and postloading .tcl files (/tcl/00-preload.tcl and /tcl/zz-postload.tcl - jsalz)
- new ad_register_filter and ad_schedule_proc routines with monitoring tools (jsalz)
- Download module has been upgraded - users are now able to see the available modules before registration, but they are required to register as users before actual download. Also download now supports version specific description, in addition to download specific description which is shown upon download request. (ahmeds)
- ticket cleanup: bug fixes in adv search, confirms on comment entry, better ticket submission help, added per feature area new ticket templates, replyable notifications and comments, assignment at creation for admins. date widget for ticket creation.
- Data Pipeline: SQL abstraction layer based on form names (oumi, mbryzek)
- News module has been upgraded - news is now organized by newsgroup. There are two scopes of newsgroups: public which serves as the traditional (site-wide) news; and group which contains news for a user_group. There are two special newsgroups: all_users which contains news items that should be displayed to all users; and registered_users which contains items displayed to all registered users.
  minor fixes
- modified general-links to fit general cleanup guidelines for approved_p. (tzumainn)
March 4, 2000: Version 3.1.5:
- added nsv_array wrapper to make proc_doc fully functional (contributed by tigre@ybos.net)
February 28, 2000: Version 3.1.4:
- merged jsalz's changes to complete the fix for proc_doc (ron)
- fixed download module (ahmeds)
February 20, 2000: Version 3.1.3:
- fixed problem in procs.tcl with AOLserver 2.x (ron)
- fixed sub-community administration for chat (dh)
- Changed version datatype from number to varchar to support version numbers like 3.1.2. Added support for download specific description which will be shown to the user upon download request (ahmeds)
February 13, 2000: Version 3.1.2:
- added notes on security (jsc)
- minor bug fixes in download (ahmeds)
- minor bug fixes in homepage (mobin)
- minor usage change in FAQ (dh)
February 5, 2000: Version 3.1.1:
- fixed fatal errors in 00-ad-utilities.tcl due to a broken ad_page_variables (discovered and fixed by dh)
- minor bug fixes in general-links (tzumainn)
- minor bug fixes related to group-only bboards (branimir)
Febrary 4, 2000: Version 3.1:
- installation verified using AOLserver 2.3.3 and 3.0, Oracle 8i, and Solaris 5.6 (aure, dh, ron)
- build your own homepage or "GeoCities-in-a-box" (mobin)
- added events module (bryanche)
- integrated WimpyPoint (jsalz, jsc, philg)
- revamped ticket tracking module (davis)
- documentation on writing an ACS module, now part of the developers guide (tarik)
- changed 00-ad-utilities.tcl to use nsv_* instead of ns_share for performance benefits with AOLserver 3.0 using Tcl 8.2. The nsv mechanism is documented in README.NSV, in the top level of the AOLserver 3.0 source tree. Note that this is not backwards compatible with any previous version of AOLserver, but wrappers are provided for the nsv_* commands in 00-ad-utilities.tcl.
  minor fixes
- philg updated comments and general comments to look for sabotage-prone HTML tags (such as DIV) in user-uploaded comments, implies a change to ad.ini (the antispam section)
- teadams added editing a user's contact information in the admin pages
January 11, 2000: Version 3.0:
- support for AOLserver 3.0 is added (AOLserver 2.3 seems to work as well); AOLserver 3.0 should be configured to run Tcl 7.6 because we rely on ns_share
- jsc integrated Henry and Branimir's bboard changes:
  - Every topic keyed by topic_id instead of topic.
  - Topic administration determined by standard ACS user group permission system.
  - Read/write permissions determined by new group-based system.
- tarik, mobin and sarah - improved group capability (subdomained ACS); now acs modules that support scoping can be associated with the groups and group types
  - tarik added acs_modules table where all acs modules should eventually be registered
  - tarik improved content_sections table by adding scope (public, group) and having 4 types of sections: static, custom (a content management system, allows storing html files in db and serving them to the users), system and admin (these are acs modules - notice that this allows associating modules with groups)
  - mobin, sarah - new download module
  - tarik, sarah - new display module (allows configuration of css and logo for the pages)
  - tarik - added short name to the user_groups table (this is unique identifier of the group) and is used in url. group public pages are now accessible in /groups directory (e.g. novice-photographers group pages are located at /groups/novice-photographers), group admin pages are accessible in /groups/admin directory (e.g. novice-photographers group admin pages are located at /groups/admin/novice-photographers)
  - tarik - improved group administration (acs_modules can be associated with the group type or with the group). administrator can control how much control over the modules is given to the group administrators
  - teadams, tarik added scoping (user, public, and group) to address book module and ability to attach an address to any item in the database (similar to general comments)
  - sarah added scoping (user, public, and group) to news module and ability to attach news to any item in the database (similar to general comments)
  - tarik, sarah added scoping (public, group) to faq module
  - tarik added scoping (public, group) to general comments module
  - tarik wrote a set of tcl functions needed for writing modules that support scoping (see /tcl/user-group-defs.tcl)
- philg added commentability to the file storage module
- philg added a trigger and fixed the SQL queries in Tcl defs for the robot detection module
- philg added mainframe integration document
- karlg and philg added working with XML document
- philg added Ecommerce Subsystem (explained for MBAs)
- philg added some concurrency fixes to referer, clickthrough, and ad server logging
- philg improved navigation and display on the /admin/adserver/ pages; added an example of adserver usage in /acs-examples/
- teadams added a monitoring section to the admin pages
  - teadams, dvr, and abe added Cassandacle as a built in ACS module. This is in the new monitor section of the admin pages. Of particular note:
    - the table detail page lists dependant tables
    - The sessions page lists all the information needed to find and kill runaway session (see "Be Wary of Sql Plus" in Oracle Tips)
  - dvr (mostly) and teadams added Watchdog as a built in module.
- dh added an FAQ maintenance system
- ron added a press coverage bragging system
- we added a download management system
- davis added ad-table-display.tcl for dimensional sliders, tables, sorts, and persistent user customizations. Some example code is also available.
  minor fixes
- teadams modified ad_restrict_to_administration in /tcl/ad-admin.tcl to get you back to the admin pages after you register
- teadams adding the ability for administrator to approve email for users awaiting email verification
- teadams modified /admin/users/user-class-add.tcl to be a little more intelligent in parsing the initial select clause.
- philg modularized the comment/link stuff in /tcl/ad-html.tcl so that it was easier for .adp pages to take advantage of the tables and procs
- philg made the portals system more robust (programming error in a subsection will not render an entire portal unviewable)
- replaced the Memoize procedure with util_memoize
- added ad_user_group_authorized_admin_or_site_admin API call to the permissions package.
November 8, 1999: Version 2.4:
- teadams added "self-documentation" in the admin area
- philg added integrity checks to the poll system (for exploring and removing duplicate votes from the same IP address when you're not requiring registration)
- philg wrote a "how to upgrade an ACS installation" document at /doc/upgrading.html
- philg added procs to support creating CSV files to 00-utilities.tcl
- philg fixed up the user admin pages (/admin/users/view-csv.tcl works now)
- jsc and philg improved the graphing package with a drill-down URL facility
- philg enhanced ad_return_if_another_copy_is_running to be callable from ADP pages (good for stability under extreme loads)
- philg fixed some cutting and pasting bugs in general-comments.sql triggers (left orphaned comments around)
- tracy, philg, michael yoon, and sebastian made the huge overdue change to categorization and user profiling, described in user-profiling.html
- philg added the /tcl/ad-user-contributions-summary.tcl system, where each module defines a procedure to produce a summary of User X's contributions to a site. This makes /shared/community-member.tcl and /admin/users/one.tcl extensible and modular.
- philg standardized navigation in the /address-book module
- philg added a /static section to ad.ini with exclusion patterns for the static page syncer
- philg added the static_page_index_exclusion table to community-core.sql; this stores SQL LIKE patterns to exclude pages from the site-wide index
- philg made major modifications to /admin/static/ to manage these exclusion patterns
- jsc and philg made major improvements/changes to site-wide search, with extensive help from the Context group at Oracle, notably Alpha and Paul Dixon. This has not been added to the upgrade script since it requires that the administrator be prepared to deal with interMedia, beginning with patching it to 8.1.5.1.
- aure, dh, and philg improved the bookmarks system, notably the admin pages and a "most-popular-public.tcl" page
October 10, 1999: Version 2.3:
- customer relationship management system
- curriculum establishment system
- user profiling enhancements
- portals system
- polls
- teadams added user classes (see user admin pages)
- philg added ability for each user to upload a portrait of him or herself to be displayed to other users. To be done: automatic production of thumbnail versions when ImageMagick is installed (lots of columns added to the users table, including two BLOBs)
- philg and MarkD made major improvements to the poll module
- teadams added group login /ug/group-login.tcl, and ad_get_group_id and ad_get_group_info in tcl/ad-user-groups.tcl
- General comments: added triggers in general-comments.sql to delete comments on rows that get deleted.
  minor fixes
- rolf: fixed a minor bug in /admin/ug/group-type.tcl, added group-type-member-field-delete.tcl and group-type-member-field-delete-2.tcl.
- teadams: fixed a few little bugs in the bookmarks module that cropped up with a new user
- teadams: modified /regiser/user-new-2.tcl to update last_visit in the users table
- philg: fixed bug whereby the /chat system would produce an error if user's contribution was merely spaces
- philg added a simple index-by-date to the referer_log table; speeds up queries on photo.net (1.3 million entries) from 34 seconds to 4.
- walter documented the /directory system
September 23, 1999: Version 2.2.1:
- eveander: fixed an important ecommerce module bug that appeared due to an undocumented, unannounced CyberCash API change (thank you, CyberCash). The "query" part of the procedure ec_talk_to_cybercash was modified.
- jsc & eveander: significant user group improvements including fixing all user group bugs at photo.net/ticket/, improving UI for group administrators, and allowing administrators to specify fields that are collected for all members of groups of a given type and for all members of a given group.
- teadams: added StaffServerP to the ini file. If StaffServerP=1, then intranet, filestorage, ticket tracker and discussion groups will appear in the workspace
September 22, 1999: Version 2.2:
- improved intranet module (procedures plus who is checked off to perform them, project and customer reports) (dvr)
- poll module (markd)
- eveander: ecommerce module bugs 1822, 1821, 2261 at photo.net/ticket/ were fixed
- eveander: ecommerce module small improvements:
  1. columns shipment_id and refund_id were added to ec_financial_transactions and the admin pages were modified to fill in those columns when making charges/refunds (this is just an extra auditing precaution; those values are never used)
  2. the user tracking present in most of the user pages was encapsulated into a procedure to make the code cleaner
- philg: added commentability to classified ads; fixed some bugs and taste problems in the general comments facility
- teadams: modified content sections so you can add info_blurb, help_blurb, add and edit content sections
- teadams: modified the last visit system so that it a) doesn't record sessions from AOLserver monitors, and b) records a repeat-visit if the last-visit cookie is not present on the inital page load and the user subsequently logs in
- teadams: few annotation edits in /directory
- teadams: modified /share/community-member.tcl to have a menu bar
- teadams: modified /ticket/project-top.tcl to redirect a user to the admin pages if they are in the ticket administration group.
- teadams: modified /admin/spam/spam.tcl to clear the ^M's from the email that gets sent
- teadams: modified /tcl/ad-last-visit.html to not overcount cookied browsers. (IP caching), modified /register/user-login-2.tcl to log a repeat visit (not session!) if the second_to_last_visit cookie is not present. See: doc/user-session-tracking.html for details.
- dvr: file storage permission fixes and ability to add urls
- teadams: modified user admin page to allow admins to select users with different criteria (ie - males who logged in within the last 10 days). This will expand into dynamic user classes.
- jsc: general_comments - added ability to upload files and images
- teadams: general_comments - added option to use titles and list comments by title.
- jsc: finally added utilities.tcl officially to the ACS, as tcl/00-ad-utilities.tcl
August 9, 1999: Version 2.1:
- collaborative bookmark maintenance system
minor fixes
- (philg) - added ability to clear a forum of all messages (useful for forums that support university classes when the new semester comes around)
- (philg) - added one_if_within_n_days to /doc/sql/pl-sql.sql (necessary for ecommerce module)
- (eveander and jsc) - added templates that were left out in the ecommerce module release
- (eveander and jkoontz) - new release of the audit trail package (necessary for ecommerce module)
- (eveander) - slight change in ecommerce data model to protect against inserting 2 rows into ec_admin_settings. See http://photo.net/ticket/issue-view.tcl?msg_id=1601
- (eveander) - modified various tcl scripts in the ecommerce module to fix bugs. See: http://photo.net/ticket/issue-view.tcl?msg_id=1621, http://photo.net/ticket/issue-view.tcl?msg_id=1641, http://photo.net/ticket/issue-view.tcl?msg_id=1701, http://photo.net/ticket/issue-view.tcl?msg_id=1721, http://photo.net/ticket/issue-view.tcl?msg_id=1741, http://photo.net/ticket/issue-view.tcl?msg_id=1761, and http://photo.net/ticket/issue-view.tcl?msg_id=1762
- (teadams) prototype fixes submitted by John Lowry. http://photo.net/ticket/admin/issue-view.tcl?msg_id=1461 (tcl/ad-prototype.tcl) and http://photo.net/ticket/admin/issue-view.tcl?msg_id=1441 (/admin/prototype/tableinfo-3.tcl)
- (teadams) fixed typo in /tcl/file-storage-defs.tcl (public_f instead of public_p)
- (teadams) renamed /tcl/ad-prototype.tcl to /tcl/prototype-defs.tcl to reflect the fact that the prototype tool is an standalone module and not a part of ACS core.
- (philg) augmented ad_header with an optional arg for extra stuff to put in the document HEAD (e.g., JavaScript)
- (philg) improved /tcl/ad-html.tcl to never hold onto a db handle while writing to the connection (also improve cleanliness of display)
- (teadams) edited /general-comments/comment-edit-2.tcl and /general-comments/comment-edit-3.tcl - fixed bug where you couldn't edit your comment.
August 4, 1999: Version 2.0:
- ecommerce module (so huge that we decided to rev the major version number)
minor fixes
- (philg) - wrote docs for /news and /calendar modules
- (philg) - changed release script so that /templates/ with news subsystem example would go out in .tar file
July 27, 1999: Version 1.7:
- standard package for adding comments to a table/module
- ticket tracker upgrade
- Registration paramaterization and finite state machine (update every file in /register and many in /admin, plus load script /doc/sql/upgrade-1.6-2.0-1.sql)
- file storage system (requires our Oracle driver 1.03 or newer; you need the ns_ora blob_dml_file command); see file-storage.html
minor fixes
- (teadams) - modified /tcl/news-defs.tcl (news_new_stuff). The query to display new stuff to users had "release_date < sysdate". This was modified to and "release_date > sysdate" in order to show news items that have been released in the past.
- (jsc) added configurable file system root for the help system (and associated parameter in ad.ini); see /doc/help.html for details.
- (philg) added Tracy's util_httppost code to utilities.tcl (not officially part of ACS)
- (philg) added util_link_responding_p and util_get_http_status to utilites.tcl; useful for figuring out of a link is returning "404 Not Found" or whatever
- (philg) enhanced the admin pages for links and comments to provide searchability, better sweeping (using util_link_responding_p), and one-click restoration of links thought to be dead by the sweeper
- (philg) changed the most heavily hit /bboard pages to compute the page in a string, release the db handle, then ns_return the bytes (slightly worse user experience on unloaded system; much better performance under heavy load from many users with slow connections (fewer db handles tied up))
- (teadams) changed /gc/place-ad-4.tcl to produce a user friendly error message when the mailer is down
- (philg) added the new intranet-required fields to users_contact in community-core.sql (thank you, Sean Y)
- (teadams) modified /ug/group-new-3.tcl to not produce an error message when the user doesn't fill in a non-new column
- (teadams) added export_ns_set_vars to utilities.tcl (not officially part of ACS)
- (teadams) Added /admin/users/user-add.tcl, user-add-2.tcl and user-add-3.tcl to allow admin additions to ACS. Modified /admin/users/index.tcl to add a link.
- (teadams) modified /tcl/ad-admin.tcl to allow /www/admin/users/action-choose.tcl to group by intranet users (employees) and groups. This allows you to spam employees or groups. Adding a link to "employees" on /www/admin/www/users/index.tcl, controled by the new paramter IntranetEnabled_p. Adding link for "download or spam group" in /www/admin/ug/group.tcl. Modified /www/admin/www/action-choose.tcl to fix a spam bug (spamming was sending email all authorized users!)
- (teadams) fixed http://photo.net/issue-view.tcl?msg_id=1161 (formatting problem in prototype results)
July 8, 1999: Version 1.6:
- robot detection
- intranet module -- run your whole company from the ACS (that's what we do at ArsDigita and we've grown to $6 million in sales without any financing or major bloodshed). Requires
```
alter table users_contact add (
        cell_phone            varchar(100),
        priv_cell_phone       integer,
        note                  varchar(4000),
        current_information   varchar(4000)
);
```
- calendar display module
- (philg) added standard way to do site-wide style and multi-languages via templating:
  - new column in users_preferences:
```
	-- an ISO 639 language code (in lowercase)
	language_preference	char(2) default 'en',
```
  - new document at /doc/style.html
  - new procs in /tcl/ad-style.tcl
- (philg) added a standard way to do site-wide end-user help pages; see /doc/help.html
- (hqm) added a standard incoming email handler (stuffs email into an Oracle table)
- (hqm and philg) added a new ticket tracker module with automatic integration of Web and email contributions (i.e., a programmer can be a full participant in discussions even if he or she only uses email). The system includes a revised and simplified user interface and comes out from its hiding place under /admin/.
- (philg) added a comprehensive system for presentation of new content site-wide to site admins, random Web surfers, and folks following via email. Check out /tcl/ad-new-stuff.tcl, /shared/new-stuff.tcl, and /admin/new-stuff.tcl.
- (jsc and eveander) added a spell-checker and inaugurated a /tools/ directory, documentated at /doc/tools.html
- (teadams) added prototype builder that will allow developers to build standard add/edit/list pages via web forms /doc/prototype.html
  minor fixes
- added util_report_library_entry and util_report_successful_library_load to utilities.tcl and call them from a bunch of /tcl files so as to make debugging easier in the event of a source code error (**** you'll have to upgrade your utilities.tcl from http://photo.net/wtr/thebook/utilities.txt to make your ACS work ****)
- fixed /chat/post-message.tcl to catch error where browser doesn't supply msg
- (teadams) fixed /bboard/add-alert.tcl to use ad_maybe_redirect_for_registration. Old method did not ns_urlencode spaces.
- (teadams) added glossary section to ad.ini file (controls ApprovalPolicy)
- (philg) fixed ad_user_class_query (in /tcl/ad-admin.tcl) for small sites where you're trying to query out every user
- (philg) added active_p column to user_groups
- (philg) fixed "who's online now" to suppress email address if connected user isn't logged in
- (philg) added query_strings_by_date index on query_strings table in community-core.sql
- (philg) fixed /adserver/adimg.tcl to not interpose bogus /adserver/ in path to ads (thank you, Raissa)
- (philg) fixed bug in ad_administration_group_id
- (philg) fixed var url being clobbered in /pvt/home.tcl by admin group url (thanks again, Raissa)
- (philg) changed ad_maintain_last_visits_for_whosonline_internal so that if someone's second_to_last_visit was more than four times as long as the session expiration seconds (typically one day), we update the session (formerly we never updated the second_to_last_visit if someone was using JavaScript chat or otherwise coming to the server at least once per day)
- (philg) moved /tcl/ad-chat.tcl to /tcl/chat-defs.tcl (more standard since chat is its own module)
- (philg) took the symlinks from /tcl and make them ordinary files (and removed the defs.tcl files from the module dirs). Did this for adserver-defs.tcl, bboard-defs.tcl, calendar-defs.tcl, contest-defs.tcl, gc-defs.tcl.
May 31, 1999: Version 1.5:
- fixed philg_quote_double_quotes (used by export_entire_form) in utilities.tcl to also quote >, <, & chars; this fixes some weird behavior when people try to discuss HTML in the /bboard system; **** you'll have to upgrade your utilities.tcl from what you see at http://photo.net/wtr/thebook/utilities.txt to get this fix ****
- fixed file upload-related bug in /bboard/insert-msg.tcl (error when file uploads enabled but none specified)
- because ns_striphtml is so stupid (removes > and < chars but doesn't remove teh tags within), change /bboard/insert-msg.tcl to
- fixed typo in bboard_uploaded_files definition (/doc/sql/bboard.sql) -- good catch, seany@altavista.net!
- squashed a lot of bugs in the bboard photo uploading stuff and improved the user interface
- added banner ideas system and applied it to the classifieds
- added graphic package to generate bar charts
- modified /doc/proc-one.tcl to distinguish optional variables
- modified /admin/ug/group-info-edit-2.tcl to actually update the user group helper table.
- added /admin/categories/ to maintain canonical content categories ("interests" as far as users are concerned) and also add info for when users see this as a mailing list thing
- actually implemented the spamming/mailing list system (/mailing-list/ for the users /admin/spam/ for the admin). One of these files used to end with "set db [ns_db gethandle]"! What's the point of open-sourcing software if people don't tell us these things!
- fixed a bug in the content section stuff whereby "require registration_p" did not automatically register a filter
- added RegistrationRequiresApprovalP and RegistrationRequiresEmailVerification to ad.ini and made lots of changes to registration, login, and user admin pages to support private sites where people can't just register and waltz in; this necessitates adding an approved_p column to the users table, which in turns breaks lots and lots of pages site-wide (because approved_p becomes ambiguously defined in a JOIN)
- added Yahoo-style nav bar in /calendar system
- added content tagging system, esp. useful for flagging and replacing naughty words
- added /chat system, which uses the content tagging system as a package
- added /shared/whos-online.tcl, which is intertwined with chat and an index to support it: users_by_last_visit (in /doc/sql/community-core.sql)
- added /tcl/ad-sidegraphics.tcl and corresponding section in ad.ini file; standard way to decorate lots of ACS pages (or custom pages that you might define); see http://photo.net/bboard/ for the system in use
- added a "sort by usage" option to the /bboard system index page (and some graphics options)
- added Yahoo-style navigation to the user group admin pages
- Usability upgrade to the ticket tracker. Users can now do things like edit the issue's project.
- standard package for adding auditing to Oracle tables: /doc/audit.html
  pathetically small fixes/changes
- fixed bug in /tcl/ad-monitor.tcl
- changed ad_administration_group_id to return "" if it can't find a group (instead of 0)
April 18, 1999: Version 1.4:
- added the /glossary module
- augmented /bboard to handle arbitrary file uploads (and made image file uploads really work)
- modified ad_generic_optionlist in /tcl/ad-widgets.tcl to use string compare instead of ==. This solves some problems the TCL has with using integers with ==.
- added bozo filters in the /bboard system (to prevent photo.net users from writing "aperature", for example)
- added session tracking and reporting. Keeps counts for each day of total sessions and repeat sessions, including both non-registered and registered users. For registered users, we've added an n_sessions column to the users table.
- added auditing to the classified ads (/gc) module; required new table definition for classified_ads_audit, two indices, audit insert statements all over the place. Also removed some dead code and clarified the individual ad pages.
- April 6, 1999 (teadams): Fixed clobs query in /neighbor/post-new-5.tcl.
- added statistics.tcl link to the q-and-a.tcl page for the bboard system
- added Yahoo-style navigation (from ad-navigation.tcl) to the /bboard subsystem
- added Yahoo-style navigation (from ad-navigation.tcl) to the /gc subsystem
- added ability for /gc/ system to bounce ads that mention eBay
- added /doc/permissions.html package
- added /gc/admin/ pages that use permissions system
- dropped the ad_authorized_maintainers table from the classifieds.sql data model (replaced with generic permissions scheme)
- created view users_active in /doc/sql/community-core.sql. Modified view users_alertable to exclude banned users.
- ad_handle_spammers in ad-antispam.tcl will block out IP addresses identified in the new [ns/server/photonet/acs/antispam] section of the ad.ini file; there is a "feign failure" mode where the spammer is treated to a bunch of ns_sleep commands
- fixed bug in password system (make sure to upgrade to this version so that users won't get locked out if they choose the wrong passwords and also for better security)
March 1, 1999: Version 1.3:
- Fixed the "From" field in daily and monday/thursday bboard email alerts.
- Fixed /bboard/admin-community-view.tcl and subordinate pages to use the current data model.
- Users are asked to log in before deleting a classified ad. (Users would visit an ad from an emails alert, click delete and then be told they were not authorized.)
- Modified insert statement in /doc/sql/bboard.sql and classifieds.sql to prevent multiple inserts of seed rows. They are now PL/SQL blocks that first verify the row is not present.
- Added /tcl/ad-last-visit.tcl to maintain the last_visit and second_to_last_visit cookies and users table columns
- Fixed notification message in /gc/place-bid-2.tcl. Changed mailto link to a link to the /shared/community-member.tcl in gc/place-bid.tcl
- Moved call to bbaord_get_top_info in /bboard/q-and-a.tcl before the message output so users can't see private messages for bboard groups they are not in.
- Modified /shared/community-member.tcl to not return messages from private bboards.
- Added user-error trapping code in /gc/place-ad-4.tcl to limit classified ad to 3600 characters
- Fixed typo in the pl-sql procedure that added the system user in /doc/sql/community-core.sql. Fixed typo in the pl-sql procedure that add the administrator user-group in /doc/sql/user-groups.sql.
- Set QQtopic to [DoubleApos $topic] in /bboard/q-and-a-fetch-msg.tcl, /bboard/q-and-a-post-repl-form.tcl, /bboard/usgeospacial-fetch-msg.tcl, bboard/usgeospacial-post-reply-form.tcl
- Modified /bboard/q-and-a-post-reply-form.tcl to use html_p.
- Modified /admin/ug/member-add-2.tcl to fix a HTML table problem that occurred when a role was specified in the post.
- Modified query for user_group_map record in /admin/ug/role-edit.tcl to contrain by group_id.
- Only queries supplement group information table if the table exists in /ug/group.tcl.
- Upgraded the ticket tracking system to include status (open, closed, fixed waiting approval, etc). To upgrade, you must add the column status to the ticket_issues table.
- Added member value user charges to bboard deletion.
- Added a "show me expensive users" feature to the admin index (when mv_enabled_p ).
- Fixed /admin/users/one.tcl to display dates more cleanly and, more importantly, not to drag all the actual content of static pages out of Oracle when only the title and url stub were needed.
- Added a spam hunter to the links section
- Added pages to manipulate the blacklist GLOB table to the /admin/links/ section
- Installed the automatic dead link sweeper to the /admin/links/ pages. This required adding checked_date date to the links table.
- Moved the link-check.tcl procedure (spider to find dead links in static .html files) into /admin/static/ (from /admin/). Linked it from the top-level static content admin page.
- completely revamped the referral reporting system
- Added a procedure ad_context_bar to /tcl/ad-navigation.tcl to support Yahoo-style navigation.
- Added a Yahoo-style navigation system to the entire /admin tree
February 8, 1999: Version 1.2:
- Added a content section to /parameters/ad.ini; useful for telling the ACS where the site map is and also whether the index.tcl page should be generated or served from a static file (the average publisher is going to want to take special care with the root page of the site).
- Began experimenting with a nice tree view of all a site's static content (for the administrator) but gave up. It is too slow on a big site such as Photo.Net to keep dragging all the information out of Oracle. The correct solution is to wait a few weeks until Oracle 8.1 comes out and we can run Java inside the server. Then do most of the work inside Oracle.
- Fixed a lot of bugs in the classified ad subsystem.
- Fixed various bugs throughout the system.
- Added user choice of HTML verses Plain text to comment system.
- Changed /bboard/insert-msg.tcl to isolate the mailer from the database handle by accumulating emails in a ns_set, releasing the handle, and them emailing the messages.
- Added ticket(/admin/ticket) and address book modules
- Added a users_alertable view to the database that excludes users who've been deleted, who are on vacation, or whose email address is generating bounces. Added pages to let a user announce a vacation and then mark his or her return. Changed all the procedures that generate alerts to query from users_alertable rather than users.
- Removed the administrator_p column from the users table, added a predefined user_group of type "system", group name "administrators" that accomplishes the same function (lumping a set of users together as admins).
- Much beefing up of the user groups stuff.
- Added ad_acs_version and ad_acs_release_date to /tcl/ad-defs.tcl; these will let you write programs that adjust to the ACS version
- Added ability for users to change passwords
- Added /directory module so that users can look each other up (entails new section in ad.ini file)
January 17, 1999: Version 1.1.
- Added neighbor-to-neighbor module (under /neighbor)
- Substantial improvements to admin pages
- User's password (kept in cookie) is now crypted with ns_crypt (means users with persistent cookies will be asked to log in again).
- Added a skeleton data warehousing module (/dw)
- Added a data model for a IT collaboration server: GlassRoom; sadly, no .tcl scripts yet
December 12, 1998: Version 1.0.
1995-1998: private releases of different portions of the ACS

philg@mit.edu

Version History

minor fixes

minor fixes

minor fixes

minor fixes

minor fixes

minor fixes

minor fixes

minor fixes

pathetically small fixes/changes