========================= Installation Version 3.07 (Developers Edition) ========================= 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) Upgrade from previous version 2) Copying files 3) Adding your database 4) Getting started 5) New Features 6) Uploader 7) Upgrades / downloads Additional information including a Word document design guide is available at : http://www.spookylogin.com/support.asp You must read and agree to the license.txt file before using this code. ---------------------------------------------------------------------- ========================================= Important information for users upgrading from 2.x logins ========================================= Please note that this version (3 +) differs 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. If you wish to upgrade, your database tables will need to be modified to match the design of the current database. #################### ## VERY Important ## #################### If you upgrade an existing 2.x login database, the field order of the "Users" table in your existing database MUST match the order of the new database. To do this, I recommend you open both in Access (or SQL server) and compare designs. The "Users" table may have modified data lengths, data types and additional columns from when you first used it. ---------------------------------------------------------------------- ================================== 1) Upgrading from previous version ================================== If you have an existing database full of information, there is no need to replace it. This only applies to version 2.76 + Please note (as above) the order of fields in the "User" table must match the new design. If you have an existing system (2.76 +), the following files do not need to be replaced: - Database - db_conn.asp - /email_templates/ 1) If using Access, backup your existing database (and old files) 2) Transfer all of the new files to your website. 3) Open the page admin_main.asp in your browser. 4) If not already selected, select "Diagnostics" 5) Open all of the "Database Tables" with a red x beside them (they will need modifying) Follow the prompts to upgrade your existing database 6) Press the reset button and then the "Main Menu" button The database should now be ready for use. NOTE : The table "login_option_list" comes pre-populated with Countries and States. If you wish to use this table, then you are best to import that table into your existing database (or for SQL server - populate the data from Query Analyser using the .sql script) The upgrade above does not add the default data. ---------------------------------------------------------------------- ======== 2) Files ======== Copy the files to your web site This directory structure must be maintained - / [root login files] - /includes/ [files] - /includes/uploader/ [cls files] - /includes/email_templates/ [files] - /images/ [files] 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 (default) ---------------------------------------------------------------------- =========== 3) Database =========== 1) Access 2) SQL Server 3) MySQL 1) Access Database ------------------ The Access database can be placed in any directory When using FrontPage, FP sets up the /fpdb/ directory for this by default. I recommend using this directory if using FrontPage unless your host has a folder they recommend. 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 If the database diagnostics show the database is read only, to set the permissions, your Internet Guest Account will have to have the rights to write, read, and modify the "/[database]" folder (You host will need to do this) One database file is included the zip, an Access 2000 version. Access can be unreliable as a web database, so please keep regular backups and compact and repair when possible (Using the Admin section) 2) SQL Server ------------- Open the db_conn.asp file and set the constant strDbase value to "SQL" and then edit the SQL connection string with the Address / database / login / password supplied by your host. In using an SQL server connection, I make the assumption you know how to use Enterprise Manager to import the database structure. There is an .sql file in the "includes/examples" directory to assist with building the table structure. The default table name in the .sql file is "Spooky_####" Please modify "sTableName" in the a_config.asp file to reflect this change if using the .sql script and that table prefix. eg : CONST sTableName="Spooky_" 3) MySQL -------- Open the db_conn.asp file and set the constant strDbase value to "MYSQL" and then edit the MYSQL connection string with the Address / database / login / password supplied by your host. The login has been tested and developed using MySQL 3.23.58 and 4.0.23 only. I use phpMyAdmin to setup and modify the database structure Its available at http://www.phpmyadmin.net/home_page/index.php (your host may recommend some other method) ---------------------------------------------------------------------- ============== 4) 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 ---------------------------------------------------------------------- ============== 5) New Features / History ============== 04/30/04 // Version 3.01 - Multi site Config setting -Using the same database, different features may be used per subweb/site - Notify Admin of expired account login - Administration of Users table via web -Add / remove / edit fields (no asp editing required) - Compact / repair Access database via web - Dynamic ordering of fields -Field order can be modified without coding - Login Grace Period, user can continue to login after expiry - User details summary can be displayed in Admin section - Username can be changed by the admin - File path for unique page redirection is automatically checked - otherwise redirect to default - Upload option - Admin can upload images/files associated with user (uploader required) - Extended User options (bulk delete, enable, disable, extend registration) - Seperate registration / update display fields 05/12/04 // Version 3.02 - All user fields can be renamed from within the admin system - Fields can have custom display - multiple list / multiple choice / upload - Minor bug fixes 07/01/04 // Version 3.03 - Database "config" table column lengths extended to allow more custom columns r_showfields, r_UpdateFields and g_required_fields extended from 70 -> 100 chrs - Add multiple radio buttons as a formatting option - Other minor changes 07/01/04 // Version 3.04 - Attachments can be added to bulk mail (not recommended for mass mailing) - Users can be sent login information when activating many users from the search page 09/15/04 // Version 3.05 - If using seperate login systems and the same database, users can be given access to just their login system (and cant access other areas) - As above, seperate login systems can have unique custom field names - Custom subscription options (for free access) Users can select their own 'access level' when registering The setting can also control the expiry date (set in a_app_list.asp) - Add requirement for harder passwords / usernames (must include numbers) set in a_config.asp - Added validation bypass in admin section for updates - Slight style changes to keep admin tables sized - Simple Protection tutorial added to admin section - Selectable fields when using the "Save as CSV" option - Any template can be selected when sending to bulk users (including your custom templates) - Additional troubleshooting table design in diagnostics - Columns and tables can now be upgraded via web interface - List arrays are now stored in database with online management The a_app_list.asp file may still be used for existing data - New email component "SMARTMAIL" added - Online database upgrade (previous database versions can be updated via Admin section) - SuperAdmin option added. This admin has normal powers, but other admins can get access to user administration only - FSO modification so that 3rd party components can be used (set in a_config.asp) 10/05/04 // changes to 3.05 - Flexible user search fields - Bug fix. User could inadvertantly use a 'reserved' word in the custom fields - Bug Fix. Removing custom groups would leave group name in config - Redesign Registration settings page, add custom list error message 11/25/04 // changes to 3.06 - Notify Admin on Update option - Upload file management - User file assignment (with protected downloads) - Extend user management so bulk users can be modified (ie change all selected access levels) - Changes to bulk email to allow send based on specific fields matching - Added default list choices to list groups (so a default value can show as selected, rather than blank) 03/28/05 // changes to 3.07 - Support for MySQL 3.23.58, 4.0.23 - Added active users / history paging - New Date picker for date fields - Extensive modification to "add user" routine to use conn.execute rather than rs.addnew This prevents any errors caused when an existing database field type is changed - Added "hidden" as a custom display option - download information added for file management - Modified config loading to prevent "left" error when upgrading from 2 version - Changes to bulk user management (time based expiry) - Filter file assignment list by Access level - Many other coding detail changes.... ---------------------------------------------------------------------- ========================= 6) Uploader ========================= An optional uploader is available for this version of login. Currently it is only designed to allow the admin to upload an image / file associated with the user The uploader used, is the excellent script by Lewis Moten. Requirements : -------------- - MDAC 2.6 or later - Windows Script 5.5 or later Setup : ------- 1) Create a folder "/uploads" in the root of your web (The uploaded files are stored here) Note - you can use any directory, but the path in a_config.asp must be changed 2) Set the permissions for your Internet Guest Account to have the rights to write, read, and modify the "/uploads" folder (You host will need to do this) 3) Activate Uploads in the admin settings. To use an image field : ----------------------- Note - the image / file name only is stored in the database. The file name can be used to reconstruct the image / file at any time. The same method allows attachments to be sent to individual users, when using some email components ---------------------------------------------------------------------- ========================= 7) 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.spookylogin.com/download.asp or by clicking on the "Spooky Login" link in the Admin section ---------------------------------------------------------------------- Regards, Spooky Spooky@Outfront.net