ClubAdmin V 0.9 beta

Clubadmin is a software to manage club members. It was developed because I was unsatisfied with the MS ACCESS solution my wife uses
to manage the member of a economical club in Bavaria. It is still alpha, so be carefull with your datas.
Clubadmin is published under GPL (see COPYING in this directory)

ALREADY IMPLEMENTED FEATURES:
1. Managing of club members, with privat and firm address
2. Different membership types (you can create your own ones) with different membership fees.
3. Several membership features, like "infos per email welcome" , "agree to give address to other members",
    "agree to publish datas via WWW", etc (Have a look at "Memberinformation")
4. Managing of membership fees (also "special agreements") and payments.
5. Sending mass emails via SMTP (at the moment this is realized by adding all selected members to BCC)
6. Create Excel-Sheets for further processing (like mass letters, etc)
7. Create an address list to use with the german Infopost Manager.
8. A large number of selection criterias for searching members
9. A authentication system with the possibility to give access on a per screen basis (e.g. Privat data, firm data, memberinformation...)
    with either read, update, insert and/or delete access.
    To be able to work with providers who are running php as CGI script (e.g. Puretec), I am not depending on the
    authentication mechanism of PHP.
10. Variable salutations and memberships types
11. Support for different languages (English and German for the moment)
12. A large possibility for configuration. E.g. the standard columns shown as a search result can be defined by the administrator
    (but can be overwritten for each search by the user)
13. A "user" and a "member" interface. The "user" interface is used by the club officials to administrate their members.
    The "member" interface gives each member a limited possibility to change his datas (such as E-mail address, etc.)
    and to look for information about other members [see 3.) "agree to publish data via WWW"].

PREREQUESITES:
The following environment is needed by ClubAdmin:

On the serverside
	- A Webserver which supports PHP (I am testing under Apache 1.3.27 on Linux)
	- PHP (at 4.2.x, I'm testing under 4.3.1 at the moment)
  - MySQL (I am testing under 3.x, I don't know if it works under Version 4)

On the clientside:
	- Internet Explorer (>=5) or Netscape Navigator (>6)
  	(I am testing under IE 5.0 and Navigator 7.1. It should work under Navigator 6.x, but does surely
     not run under 4.x)
  - JavaScript must be enabled


UPDATE:

- From 0.8.5 alpha to 0.9 beta:
    + The name of the table "Mitgliedsbeitraege" has changed to "Memberfees". Please run the following MYSQL script:
        ALTER TABLE Mitgliedsbeitraege RENAME TO Memberfees;

    + A new configuration entry was created:

        INSERT INTO Konfiguration (id, name, value, Bezeichnung) VALUES
                (19,'EasySearch','Vorname, Nachname, FirmaName',
                    'Spalten aus der Tabelle Mitglieder die bei einfacher Suche angezeigt werden');

      to change the name.

    + The help system has to be installed:

        CREATE TABLE Help (
            Category tinyint(4) NOT NULL default '0',
            Subcategory tinyint(4) NOT NULL default '0',
            Description_EN text NOT NULL,
            Description_DE text NOT NULL,
            Description_FR text NOT NULL,
            PRIMARY KEY  (Category,Subcategory)
        ) TYPE=MyISAM COMMENT='Online Help';

      after you have created the table, insert the file Clubdata-help.sql as described below (Step 4c).

    + There is an annoying problem with is caused by changing the field id of the table paymode
      to auto_increment:
        The index starts with 1 and not anymore with 0.
      So all indexes of the field paymode_ref in the table payments are wrong.

      I suggest two solutions:
      1. The easy way:
        Just empty the tables paymode and payments and start from zero
        (This is usefull, if you don't have any valuable payments in the DB)

      2. The hard way:
        Adjust everything:
        I suppose you have not already added additional paymodes. If you have and you have them
        counted sequentally, the method described will work also, otherwise I hope you have
        enough know-how to adjust the field Paymode_ref of the table paymemts.

        >mysql -vv -u clubdata -p Clubdata <Installation/changePaymode.sql

        This skripts generates a temporary table of paymodes, emtpies the original one, alters it and
        inserts the saved paymodes (without the id field). After that it adds 1 (one) to all
        paymodes in the payments table.


    + Payment support has to be added:
      Create table paytypes:

        CREATE TABLE Paytype (
            id tinyint(4) NOT NULL auto_increment,
            Description_UK varchar(50) NOT NULL default '',
            Description_DE varchar(50) NOT NULL default '',
            Description_FR varchar(50) NOT NULL default '',
            UNIQUE KEY id (id)
        ) TYPE=MyISAM;

        INSERT INTO Paytype VALUES
            (1,'Membership fee','Mitgliedsbeitrag','Cotisation'),
            (2,'Conference fee','Konferenzgebühr','Frais de conférence');

      Alter table payments:
        ALTER TABLE `Clubdata`.`Payments` ADD `Paytype_ref` TINYINT(1) NOT NULL;
        ALTER TABLE `Clubdata`.`Payments` CHANGE `Period` `Period` SMALLINT(4) DEFAULT '0000' NOT NULL;


      As until now only membership fees have been supported, you can set the new Paytype_ref to 1:
        UPDATE Payments SET Paytype_ref = 1;

- GENERAL UPDATE INFO:
    I advice to rename the original directory Clubdata to (e.g.) Clubdata.old and make a new installation of Clubdata.
    You can take the configuration values from your old Installation. As there are not many configuration entries it should
    be done quite easily.

    Don't forget to copy the firm logos (under $DEST_HTTP_DIR, found in include/configuration.php) from the old to the new
    Clubdata directory

INSTALLATION:

1. Clubdata was developped under SusE 7.3, Apache 1.3.20, PHP 4.2.3, MySQL Ver 11.15 Distrib 3.23.44
    As it uses $_GET, $_PUT, ... PHP must be at least 4.1.x !!

2. Extract tar-file to $DOCUMENT_ROOT/Clubdata

3a. Create a MYSQL Database called "Clubdata"

4a. run "mysql Clubdata <Installation/Clubdata-structure.mysql" to load empty tables.

4b. run "mysql Clubdata <Installation/Clubdata-data.mysql" to load initial values (if desired).
    Now, the database contains a test member and some users to play with
    (User: Admin, Password: admin, Function: (guess...))
    (User: AllUser, Password: AllUser, Function: User who may edit all tables)
    (User: test, Password: test, Function: Is not allowed to do anything in th moment, but is used to test authentication)
    (Member: 147, Password mitglied, Function: The member uses the "member" interface as discribed in
                [ALREADY IMPLEMENTED FEATURES 13.])

4c. run "mysql Clubdata <Installation/Clubdata-help.mysql" to load the help system

4d. Create a user who can access the Clubdata tables. The default user is clubdata with password club. (See also 5.)

5. Edit "include/configuration.php"
    - Edit LINKROOT to point to your Clubdata directory (relative to the webserver document root);
    - edit DB_HOST, DB_NAME, DB_USER and DB_PASSWD to access your Database
    - edit $language to DE, EN or FR (for the moment) [This is the defaut language and will be overwritten on a per user basis !!)
    - edit $DEST_HTTP_DIR to show to directory where to store uploaded pictures (e.g. firm logos)

    - In special cases you may want to edit SCRIPTROOT (include/function.php) to fit your needs
      (absolut path to your Clubdata installation);

6. Change the permission of the directory defined in $DEST_HTTP_DIR to be writtable by the http server
    (Normally wwwrun).

6a. Create a directory named "small" under $DEST_HTTP_DIR. Make it also writable to the http server.

7. Connect to http://yourhost/Clubdata/index.php. Login as Admin, AllUser or test.
    You must have Javascript enabled !!

8. Have fun, add members, etc.

9. If you find any errors (and you will for the moment) send me an email to franz.domes@gmx.de. Any suggestions and bugfixes are
    also very welcome.


TODO:
0. BUG-FIXING and stabilisation of the current code
0a. A lot of names (tables, fields, etc) are in German. I will translate them to english.
1. The authentication is not implemented on every link. (I'm working on it)
2. More lists, like user to dun, no. of users per membership type, etc.
3. Batch updates, like adding new membership fees at the beginning of a year
4. Creation of form letters, like invoices (at the moment I have no idea how to realize it)
5. Nicer buttons
6. ... a lot more