Handle | Name | 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 |
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.
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..
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
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.
I have added a new Const to the Configuration-inc.asp
Const DB_EXT = ".MDB"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.
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
version 1.2:
AddImage(sTitle, sDate, sDescription, sSourceSmall, sSourceNormal, iHits, iCategory, iVersion, bValid)version 1.3:
AddImage(sTitle, sDate, sDescription, sSourceSmall, sSourceNormal, iHits, iCategory, iVersion, bValid, iiRole)version 1.4:
AddImage(sTitle, dDate, sDescription, sSourceSmall, sSourceNormal, iHits, iCategory, iVersion, bValid, iiRole, sSourceFull)Original:
If AddImage(sTitle, DateTimeToString(Now()), sTitle, SQLEncrypt(sCategoryImagesPath & sSmallPicsFolder & sFileName), SQLEncrypt(sCategoryImagesPath & sNormalPicsFolder & sFileName), 0, iCategory, iDefaultVersion, 1) ThenFor Asp-Nuke v1.3:
If AddImage(sTitle, DateTimeToString(Now()), sTitle, SQLEncrypt(sCategoryImagesPath & sSmallPicsFolder & sFileName), SQLEncrypt(sCategoryImagesPath & sNormalPicsFolder & sFileName), 0, iCategory, iDefaultVersion, 1, ROLE_PUBLIC) ThenFor Asp-Nuke v1.4:
If AddImage(sTitle, Now(), sTitle, SQLEncrypt(sCategoryImagesPath & sSmallPicsFolder & sFileName), SQLEncrypt(sCategoryImagesPath & sNormalPicsFolder & sFileName), 0, iCategory, iDefaultVersion, 1, ROLE_PUBLIC, '') Then
Look in /include for the new extra defaultX-inc.asp
- /includes/default1-inc.asp
- Display (Forum/News/Calender) line
- Display 2nd line (Latest Downloads, Random News, Calender/Events)
- Display Announcment
- Display News
- Standard default as released in Asp-Nuke Community v1.4.00
- /includes/default2-inc.asp
- Displays (Forum/News/Calender) line
- Display Announcment
- Display News
- /includes/default3-inc.asp
- Display Announcment
- Display News
- /includes/default4-inc.asp
- Display Announcment
- Display (Forum/News/Calender) line
- Display 2nd line (Latest Downloads, Random News, Calender/Events)
- Display News
- /includes/default5-inc.asp
- Display Announcment
- Display (Forum/News/Calender) line
- Display News
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.
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.
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
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
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.
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:
Main database updates
main12to14.sql
Update main.mdb v1.2 to main.mdb v1.4 main13to14.sql
Update main.mdb v1.3 to main.mdb v1.4 main14SP1.sql
Update main.mdb v1.4 to main.mdb v1.4 SP1 Forum database updates:
forum1xto14.sql
Update Forum.mdb to Forum.mdb v1.4 forum14SP1.sql
Update forum.mdb v1.4 to Forum.mdb v1.4 SP1Lots 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 useSELECT 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
************************************************************************
*
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. *
*
*
************************************************************************