========================= Installation Version 2.76 ========================= The main details of the Spooky login system are in the admin_main.asp file. It must be opened in your web for viewing. 1) Copying files 2) Adding your database 3) Getting started 4) New Features 5) Upgrades / downloads Additional information including a Word document design guide is available at : http://www.frontpagecommerce.com/spooky/ You must read and agree to the license.txt file before using this code. ---------------------------------------------------------------------- =================================== Important information for upgrading users =================================== Please note that this version (2.7x) differs slightly from all previous versions of the login. The database design has changed to accomodate new features and to enable more settings to be modified via the web based administration. The same protection scripts are used as previous versions and settings are transferable. I do not support via email the upgrade of previous versions to this version, although it is quite easy. If you wish to upgrade, your database tables will need to be modified to match the design of the current database. To do this, I recommend you open both in Access and compare designs. 1) The "Active_Users" table remains unchanged (from 2.6 vesion) 2) The "config" table has additional columns and modified data lengths 3) The "Users" table has modified data lengths and data types. There are 2 additional columns. All files in all folders (except db_conn.asp, which can remain) should be replaced. ---------------------------------------------------------------------- ======== 1) Files ======== Copy the files to your web site This directory structure must be maintained - / - /includes/ - /includes/email_templates - /images/ Files may be placed in the root, or a subdirectory, as long as the includes and images folders remain a subdirectory of the install file directory. Files can be transferred either by FTP or FrontPage. All folders must allow scripting ---------------------------------------------------------------------- =========== 2) Database =========== The database can be placed in any directory FP2000 sets up the /fpdb/ directory for this by default. I recommend using this. With your site open live, use File > Import > and acknowledge the prompts to save your database and create a connection. You should not need to modify any settings, and the login should work immediately if this directory is used. IMPORTANT!! ---------- The directory should allow read/write of the database and should not be browse able. (entering the database URL, should not download it) This is normally the default setting The admin_main.asp file contains diagnostics for the database and for the server One database file is in the zip, an Access2000 version. Access can be unreliable as a web database, so please keep regular backups and compact and repair when possible. SQL Server ---------- In using an SQL server connection, I make the assumption you know how to use Enterprise Manager to import the database structure. ## Identity column The Users table requires the UserID field to be an identity column. The other tables do not require a Unique ID If required, there is an .sql file in the examples directory to assist with building the table structure. NOTE : If you are using SQL server, please open the db_conn.asp file and set the constant strDbase value to "SQL" and edit the SQL connection string. The default table name in the .sql file is "Spooky_####" Please modify the a_config.asp file to reflect this change if using the .sql script and that table prefix. ---------------------------------------------------------------------- ============== 3) Get Started ============== Open the admin_main.asp file : http://www.yourweb.com/admin_main.asp The default ADMIN login is : Login : Spooky Password : Admin If successful, you can now view the read me and set up your system settings NOTE: ----- Each item in the system settings has a "title". This title is a hyperlink to further help information about that setting. IMPORTANT! Please change the default Administrator and / or Password ---------------------------------------------------------------------- ============== 4) New Features ============== 4/20/03 // Version 2.7 - Added PayPal subscription option - Login errors and messages are generated in javascript - Moved config based settings to web based admin - Added simple/advanced view switch - Bulk mailer can send to specific Accesslevels - Some minor pages renamed to *.inc to prevent Frontpage modifying them - Option to disable reactivation when a user changes email address in an authenticated web - Added 'comments' field to admin section for user notes. 7/01/03 // Version 2.73 - Added terms and conditions option - Added CDOSYS option for email - Slightly modified register design 9/01/03 // Version 2.74 - Email may be used Username - Added multi select box as formatting option - CC option added to email all users (enable in a_config.asp) 11/01/03 // Version 2.75 - Extension to paypal features (variable payment, preset expiry, preset access level) - Added Cellphone field to database - Added CSV download of email addresses Note if upgrading from 2.7x - the database will need the cellphone column added to the database 02/22/04 // Version 2.76 - Javascript error message option - login redesign so it may be "included" in other pages - Expiry can be days or months - Added new template text options - Session / cookie handling moved to a_general.asp - fixed error in a_config that wasnt allowing refid to be saved as extended info ---------------------------------------------------------------------- ========================= 5) Upgrades ========================= Free upgrades are available to you, for your lifetime, my lifetime or the products lifetime. Which ever comes first! The latest version can be downloaded via http://www.frontpagecommerce.com/spooky/login/download.asp or by clicking on the "Spooky Login" link in the Admin section ---------------------------------------------------------------------- Regards, Spooky Spooky@Outfront.net