************************************************************************
* ASPNUKE Community: Free web portal in ASP                            *
************************************************************************
* ASP-Nuke Community 1.4 Copyright © 2004 by Rolf Thomassen            *
* (aspnuke(a)gmail.com) http://www.rot.dk                             *
*                                                                      *
* Re-design by Rolf Thomassen © 2004 (aspnuke(a)gmail.com)              *
*                                                                      *
* ASP-Nuke Community 1.3 © 2003 by Rolf Thomassen                      *
* (aspnuke(a)gmail.com) http://www.rot.dk                             *
*                                                                      *
* ASP-Nuke 1.0, 1.1, 1.2 Copyright (c) 2002-2003 by Gaetan Bouveret    *
* (webmaster@asp-nuke.net) http://www.asp-nuke.net                     *
*                                                                      *
* This program is free software. You can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or    *
* (at your option) any later version.                                  *
*                                                                      *
************************************************************************

ASP-Nuke Community v1.4 Service Pack 1
-----------------------

Developers:
	Handle			:	Name					Email								Test - WebSite
	------				----					-----								--------------
	Mr.Spock		:	Rolf Thomassen			aspnuke(a)gmail.com			http://www.rot.dk
	Winriders		:	Manel Fuentes			wnriders(at)yahoo.com				http://www.winriders.tk
						Sr.WinRiders

Credits:
--------
	Lots of people should be put in credit here. And I am so sorry if I forget people that have come with
	help, surguestions, codesnips, info, language files, and much more. I wish to give all the people of the
	ASP-Nuke Community credit for all the help they have given to keep this project alive.

	Here are some of the people that have been of help to make this version of ASP-NUKE Community.
	First and formost:
		Gaëtan Bouveret alias Gat,
		GAT				-	The Founder of ASP-NUKE.
							ALL HAIL to the great GAT
							Webmaster ASP-Nuke (webmaster(at)asp-nuke.net)

		Ftghawk			-	For starting the ASP-NUKE Community for 1.3
		Fmarie			-	For lots of good ideas
		Carlos Lopes	-	Lots of help with translations
		David Lopes		-	Lots of help with translations and lots of good ideas
		Hoover			-	Lots of ideas
		Thomas26		-	Images in comments

		If I have missed someone, it is not to forget them, but they are so many,
		I would like to thank all that have help in bringing and keeping this portal alive.

	I would also like to thank the Alpha Team and the Beta team for their help, without, this
	version of ASP-Nuke Community would not have been finished yet..

Info:
-----

	Please write back to me with info about people that needs to be listet in the Credit list.
	Please wirte back if some info in this file need change or correction.

	write to: aspnuke(a)gmail.com

Here is what have been changed since last build.

--	--	--	--	--	--	--	--	--	--

		Legend:
			¤	TODO	- see also TODO.TXT
			+	ADD
			/	Revision/Changes/fix
			-	Removing
			*	Enhancement
			?	Question
			!	Remember/Warning/Info

Build 01		2004-08-10
--------		----------
2004-08-08	+	New to Update Main SQL script

					ALTER TABLE users ADD uShowEmail BIT;
					UPDATE users SET uShowEmail=-1 WHERE uShowEmail Is Null;
					ALTER TABLE users ADD uNewEmail VARCHAR(250);
					UPDATE users SET uNewEmail='' WHERE uNewEmail IS NULL;
					ALTER TABLE users ADD uLastAdminVisit TEXT(17);
					UPDATE users SET uLastAdminVisit='' WHERE uLastAdminVisit IS NULL;

					ALTER TABLE directory ADD dMemo MEMO;
					UPDATE directory SET dMemo=dDescription;
					ALTER TABLE directory DROP COLUMN dDescription;
					ALTER TABLE directory ADD dDescription MEMO;
					UPDATE directory SET dDescription=dMemo;
					ALTER TABLE directory DROP COLUMN dMemo;


				This will add possiblity to Hide Email on Profile for users..
				And it will save New Email in uNewEmail until Account is validated again,
				if Validation is needed on user account.

					LANG_EMAIL_SHOW	:	Show Email on profile


2004-08-02	!	Well the hollidays are over, and we have to start again, lots of things have happend
				during the hollidays, I have been gone from the web for 4weeks and when I came back
				lots of posts in the forum of asp-nuke 1.3 site.
				My Asp-Nuke Community v1.4 site is down, and my HOST have installed MS-Windows 2003
				this gives lots of problems with ASP-NUKE, my first task it to test ASP-NUKE on MSWin2003.
				
				Lots of fixs and changes have been surguested in the forum and I will be looking at them too.
				
				People are starting to port the portal to MySQL or MSSQL so I will have to make a MOD/fix to 
				enable this feature, it will be released as soon as possible.
				
			+	I have added a function to the Admin/Database feature
				it is now possible to load a SQL script to run.
				Since Asp-nuke v1.3.005 it have been possible to run lots of SQL commands in one go, 
				but it have not been widely know by people, my fault, as I have not announced this LOUD!
				Lots of features in build in the Admin/Database, 
				most of them can be seen if you write HELP in the command:
				
				HELP:
					Command			Value 
									To use the database function here, you can do queries one line at the time,
									or you can enter lots of queries, but seperated by a ; (semi-colon).

									exsample:
									USE main;
									SELECT * FROM news;
									SELECT * FROM guestbook;
									USE forum;
									SELECT * FROM posts;

					LOAD			LOAD <SQLscript-file> :
									LOAD main13to14.sql
									Load SQL script file so you can edit and run all commands
									Default location in root of site for the script
									LOAD command is single line use, no other command will be made. 
					   
					USE				USE database-name
									USE main13 : Set database to open and use 
					   
					SELECT			Query: Get data from database/table 
					INSERT			Query: Add data to database/table 
					UPDATE			Query: Update data in database/table 
					DELETE			Query: Delete data from database/table 
					CREATE			Query: Create table in database !WARNING! ONLY USE IF YOU KNOW WHAT YOUR ARE DOING! 
					ALTER			Query: Alter table in database !WARNING! ONLY USE IF YOU KNOW WHAT YOUR ARE DOING! 
					DROP			Query: Drop/Delete table from database !WARNING! ONLY USE IF YOU KNOW WHAT YOUR ARE DOING! 
					   
					GET SERVERVARS	Show Server Variables and info about session 
					   
					SET DEBUG		Set Debug [ON|OFF], Show all info of query (DEBUG = False) 
					GET SYSPARM		GET SYSPARM [<SysParmName> | ALL] : Show a System Paramter or ALL 
					SET SYSPARM		SET SYSPARM <SysParmName> [<Value>] : Set a System Paramter, if no Value then set to TRUE 
					UNSET SYSPARM	UNSET SYSPARM <SysParmName> : Set a System Paramter to FALSE 
					   
					SET WARNING		Set Warning [ON|OFF], Suppress Error/Warnings when running query (WARNING = False) 
					SET VERBOSE		Set Verbose [ON|OFF], Show all info of query (VERBOSE = False) 
					
					#				Remark line, line that will not be executed, just comment

									Always end a command/query line with ; semi-colon  
				END HELP

Build 00		2004-06-25
--------		----------
2004-06-25	!	Release of Asp-Nuke v1.4

