ASP-Nuke SQL Community v1.5

• ALPHA 02

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.

Many people on our site, help with idea, bugreports and fixes, I wish to say Hi to them all.

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.com)
• 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
• many many more

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

Alpha 02 :

I am sorry I have not keept up the report of what I have been doing to AspNuke Alpha01, so I will try with Alpha02 to remember to write all changes and fixed I do.

2005-04-17:

• Change to FORUM database
  • I have changed USERS tabel name to UsersInForum
  • Created VIEW: USERSFORUM
  • This way it will be possible to combine both MAIN and FORUM DB into 1 SQL Database
• Update of NEWS, to make it faster.
• Pattern.Asp have been changed
  • so seperator sign is now a CONST in const-inc.asp
    This is because I found out the some server that uses other language setup,
    changes the value of ££ to LL, this make it impossible to use Pattern/BlockDesign
  • Also made changes to Pattern.asp will work with IE, Firefox, I hope some of your will do some test with OPERA
• News:
  • Bug in create news, fixed
• Created SQL scripts to create MS-SQL database
• All Scripts are in the SQLscriptsfolder

AspNuke Community v1.5 SQL Alpha Release 01 : 2005-03-15

2005-04-09 + Polls change

• Now Polls are saved in UserParm, so when a user have registered a POLL,
  he can not make a vote again, as the info him making the vote is saved in the UserParm
  But we do not SAVE what he votes, only the he have voted.
• Brainstorm: IF not login, then Poll have to used Cookie..

2005-03-09 + Database Changes

• I am also changing all BIT/BOOLEAN fields to SMALLINT, this way it gives less problems with Boolean convertions between Database systems
• Add new field to tables to make Full use of HTML and Java and other Webbased code
• Here is SQL script for changes to MAIN database
  • ALTER TABLE advertising ADD aFullHtml smallint NULL
  • ALTER TABLE articlespages ADD apFullHtml smallint NULL
  • ALTER TABLE calender ADD kFullHtml smallint NULL
  • ALTER TABLE calender ADD kPrivate smallint NULL
  • ALTER TABLE comments ADD cFullHtml smallint NULL
  • ALTER TABLE downloads ADD dFullHtml smallint NULL
  • ALTER TABLE edito ADD eFullHtml smallint NULL
  • ALTER TABLE guestbook ADD gFullHtml smallint NULL
  • ALTER TABLE images ADD iFullHtml smallint NULL
  • ALTER TABLE messageslist ADD mlFullHtml smallint NULL
  • ALTER TABLE news ADD nFullHtml smallint NULL
  • ALTER TABLE quotes ADD qFullHtml smallint NULL
  • ALTER TABLE tips ADD tpFullHtml smallint NULL
  • ALTER TABLE news ADD nWords int NULL
  • ALTER TABLE users ADD uPosts int NULL, uAvatar int NULL
  • CREATE VIEW viewForumUsers AS SELECT uLogin AS UserLogin, uPosts AS UserPosts, uAvatar AS UserAvatar, uValid AS UserValid FROM users ORDER BY uLogin
  •  

2005-03-03 ! Start

AspNuke Community v1.4 Service Pack 02 : 2004-08-31

2004-08-15 ! Release of Asp-Nuke v1.4 Community Service Pack 2

AspNuke Community v1.4 Service Pack 1 : 2004-08-15

2004-08-15 ! Release of Asp-Nuke v1.4 Community Service Pack 1

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