ASP-Nuke Community v1.4 Service Pack 1

Main Developers:

Handle Name Email Website
Mr.Spock Rolf Thomassen MrSpock(at)rediffmail.com http://www.rot.dk
Winriders
Sr.WinRiders
Manel Fuentes wnriders(at)yahoo.com http://www.winriders.tk

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:

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: MrSpock(at)rediffmail.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

Service Pack 01 : 2004-08-15

2004-08-15 ! Update info

With this Service Pack 1, I have tried to put in all the Bugfixes write in the Forum of Http://www.rot.dk/aspnuke the site for Asp-Nuke Community v1.4

If I have not written all the bugfixses here in the readme text it is becouse I forgot, not for not fixing them. I have tried to make this SP1 release as fast as possible.

 

2004-08-15 * Configuration-inc.asp

I have added a new Const to the Configuration-inc.asp

It is VERY IMPORTANT that your remember to ADD this line to your Configuration-inc.asp, it is to make it possible to use different Extentions on your databases, for added protection

SETUP.ASP have been updated to add this Const, but if you use your old Configuration-inc.asp you have to add it yourself.

 

2004-08-15 * Update in /include/database-inc.asp

All the Database Connections have been updated in this Service Pack, so go and look at them in /includes/database-inc.asp

Here is the new code in the DBconnection function

' NewsTags   : Value
' -------- - -----
' %SERVER% = DB_SERVER
' %DBPath% = sDBPath
' %DBName% = sDBName
' %DBExt% = DB_EXT
' %UserId% = DB_USER
' %Password% = DB_PASSWORD



Select Case lcase(DB_Provider)
Case "sqlolsdb" ' MS SQL Server
sDBConnection= "Provider=sqloledb;data source=%SERVER%;initialcatalog=%DBNAME%;uid=%USERID%;pwd=%PASSWORD%;"
Case "sql" ' MS SQL Server
sDBConnection= "driver={SQLServer};server=%SERVER%;database=%DBNAME%;uid=%USERID%;pwd=%PASSWORD%;"
Case "dsn" 'Data Source Name
sDBConnection="DSN=%SERVER%;UID=%USERID%;pwd=%PASSWORD%;"
Case "mysql" ' MySQL connection
sDBConnection = "DRIVER= {MySQLODBC3.51Driver};server=%SERVER%;database=%DATABASE%;uid=%USERID%;pwd=%PASSWORD%;"
Case "4.0" ' MS Jet Access 4.0
sDBConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%DBpath%\%DBname%%DBext%;User ID=%USERID%;Jet OLEDB:Database Password= %PASSWORD%;Persist SecurityInfo=False;Mode=Share Deny None;"
Case "3.51" ' MS Jet Access 3.51
sDBConnection = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=%DBpath%\%DBname%%DBext%;User ID=%USERID%;Jet OLEDB:Database Password= %PASSWORD%;Persist SecurityInfo=False;Mode=Share Deny None;"
Case "access" ' MS Access
sDBConnection = "DRIVER= {Microsoft Access Driver(*.mdb)};DBQ=%DBpath%\%DBname%%DBext%;PWD=%PASSWORD;"
Case "user" ' User Defined Connection
sDBConnection = DB_connection
Case Else ' MS Access
sDBConnection = "DRIVER= {Microsoft Access Driver(*.mdb)};DBQ=%DBpath%\%DBname%%DBext%;PWD=%PASSWORD;"
End Select
sDBConnection = Replace(sDBConnection, "%server%", DB_SERVER, 1, -1, 1)
sDBConnection = Replace(sDBConnection, "%dbpath%", sDBPath, 1, -1, 1)
sDBConnection = Replace(sDBConnection, "%dbname%", sDBName, 1, -1, 1)
sDBConnection = Replace(sDBConnection, "%dbext%", DB_EXT, 1, -1, 1)
sDBConnection = Replace(sDBConnection, "%userid%", DB_USER, 1, -1, 1)
sDBConnection = Replace(sDBConnection, "%password%",DB_PASSWORD,1, -1, 1)

This all makes it possible to make user connections, as the user connection just have to have the TAG build into be used.

As you can see, I am starting to make the code ready for use with MySQL and/or MSSQL

2004-08-15 ! addpicture.asp

version 1.2:

version 1.3:

version 1.4:

Original:

For Asp-Nuke v1.3:

For Asp-Nuke v1.4:

2004-08-11 + default.asp

Look in /include for the new extra defaultX-inc.asp 

I have made some examples of how you can design you own default page. 
There is now 5 different standard files, REMEMBER they are JUST examples 
It is up to you to redisign them to fit your needs.

 

2004-08-10 + My Account, Memberslist and Profile

I have added new field to the My Account, a Show Email, if this is checked, it will show Email of user or not in Profile and Memberslist.

 

2004-08-10 + Forum fix

I have loaded Winriders Forum v1.4.005 MOD and this fixes lots of problems with the forum

Some new Tage are with the new MOD from Winriders

 

2004-08-08 + New to Update Main SQL script

Here is Updates for MAIN.MDB:

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;

Change Directory's description from TEXT(250), to MEMO field, with out loss of data:

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..

LANG_EMAIL_SHOW : Show Email on profile

 

2004-08-02 ! End of hollidays

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.

(Update 2004-08-11: I have just found out that it is not Windows 2003, but Plesk for Windows, that is the problem)

Lots of fixs and changes have been surguested in the forum and I will be looking at them too.

People are asking of porting 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.

2004-08-02 + Admin/database

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!

All the SQL scripts have been updated to use the new freature of LOAD

The following scripts for update is as of this moment avalible:

Lots of features in build in the Admin/Database, most of them can be seen if you write HELP in the command:

HELP : Commands for Database

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).

eksample:
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)
 
Always end a command/query line with ; semi-colon



 

 

Build 00 : 2004-06-25

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

 


************************************************************************
* ASPNUKE Community: Free web portal in ASP *
************************************************************************
* ASP-Nuke Community 1.4 Copyright © 2004 by Rolf Thomassen *
* (mrspock(a)rediff.com)
http://www.rot.dk   *
* *
* Re-design by Rolf Thomassen © 2004 (mrspock(a)rediff.com) *
* *
* ASP-Nuke Community 1.3 © 2003 by Rolf Thomassen *
* (mrspock(a)rediff.com)
http://www.rot.dk   *
* *
* ASP-Nuke 1.0, 1.1, 1.2 Copyright (c) 2002-2003 by Gaetan Bouveret *
* (webmaster(a)asp-nuke.com)
http://www.asp-nuke.com  *
* *
* 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. *
* *
************************************************************************