WHAT'S THIS ?

   Now based on WySQL this is a web publishing system for events and schedules.
   Events may be restricted to private groups or filtered by requested target
   (profile).

   Requires WySQL for dbms access and WyCSV for data dumping/uploading to/from
   CSV files.

   At the time of writing WyCSV has only been tested with Netscape and MySQL.


COPYING

   This is free software, and you are welcome to redistribute it
   under certain conditions; see the file COPYING for details.

   This software is OSI Certified Open Source Software.
   OSI Certified is a certification mark of the Open Source Initiative.

   You may want to check http://www.franzoni.info/open for up to date
   version.


HISTORY

   V1.4.0   ported and rearranged for WySQL and WyCSV (see
            http://www.franzoni.info/open/wysql for details)
            Translated to English, with aim to internationalize
            text
   V?.?.?   This software has been developed and used for years,
            formerly known simply as "eventi" ('events', in italian).


INSTALLATION

   At first you need to install WySQL. In order to use the dump/upload
   feature you also need to install WyCSV.

   Then, Unpack the compressed tarball from the parent directory of WySQL.

   If the directory created contains version information in name, just
   rename the directory to only 'wyagenda'.
   Also rename (if this is the first installation) the file
   wyagenda/inc/database.php_DIST to wyagenda/inc/database.php

   Database setup and access configuration depends on the above.  This is
   just a plug-in... and just acts where and as far WySQL (and WyCSV) can.

   This bunch of code really relies on finding ../wysql/* ... ofcourse you can
   change relative/absolute location references... but that is just UP TO YOU !

   The maintenance section allows to create and drop the whole database and
   the required table(s).  In real life the database already exists and you
   must have proper grants for the DB and configure wyagenda/inc/database.php
   properly for the access information.  This section is not linked from the
   publicly accessible pages and should be protected as well as the inc subdir.


TESTING/TUTORIAL

   Under the 'template' subdirectory there are three CSV files to test and
   start playing with WyAgenda.  All the following path and location are
   relative to the directory where you installed the wyagenda directory and
   to the 'root' URL where your web server see the top directory of WyAgenda.
   After the kit has been succesfully installed and configured in your web
   server:
   - copy the inc/database.php_DIST file to inc/database.php and edit it with
     your values (e.g.: cd /usr/local/httpd/htdocs/wyagenda/inc ;
     cp database.php_DIST database.php)
   - create (if it does not already exists) the database (manually or by
     using the maint section - see below)
   - create the required tables by pointing your browser to the maint
     directory (e.g.: http://www.yourdomain.tld/wyagenda/maint/), fill the
     password field and click the <create> table button.  Password should be
     the same as defined in the database.php file, it is asked for create/drop
     operations for better security.
   - when database and tables have been successfully created scroll to the
     bottom of page, and for each of the listed tables use the <insert> button
     after browsing to the related files you can find under the 'templates'
     subdir (eg: /usr/local/httpd/htdocs/wyagenda/templates/wyagenda_agenda.csv)
   - Those CSV files will load some fake announcements (events), a set of
     private groups and a few targets
   - When the list is accessed from maint section, password is not checked.
     For user access the password set are just 'password' for the
     'need password' froup and an empty string for the 'Not so much' group.
     The 'crack me group will not be accessible unless you guess with password
     crypts to 'crack me'.
   - Now play with the list of events either in user and maint mode, by
     combining the private and target selections.  Then try to edit, add and
     delete events.  Have fun!
     
   
TO DO

   * The private groups and targets tables should be managed by using a
     proper editor (may be another Wy??? tool ?), meantime WySQL is
     bundled for editing them.  Values should be intuitive enough, just
     remember to use the PHP's crypt() function to encode the value of the
     password field in the wyagenda_private table and never use the value 0
     for the Target and Private id fields.


BUGS

   Please report any bug to the address below.  Suggestions are also
   welcome.

   No known bugs so far :-)


CONTACT INFO:

   Mauro Franzoni
   Via Torbole 1
   I-21100 VARESE
   ITALY

   e-mail: info@franzoni.info