Changelog for linkpage (http://linkpage.jpwaag.com)

linkpage-0.9.2.0 - 2005
Removed sql injection bug in out.php

linkpage-0.9.1.6 - 1 March 2005 DATABASE DESIGN NEEDS UPDATING
[the rss feed function will only work on windows systems unless you chmod the linkpage directory to 775.
This will be better in the future...]
Upgraded linkpage.php, stats.php, suggest.php to valid XHTML 1.0, and Valid CSS.
Added "valid XHTML 1.0" link to linkpage.php
Added funtionality for using rss Feeds, making linkpage even morge dynamic.
Made rss funtion compatible with, nu.nl, tweakers.net, slashdot.org
Removed a security hole in secure.inc.php.

Linkpage-0.9.1.5 - 21 February 2005
Removed bug displaying html and image categories while moving links.
Added some more compatibility to the uptime funcion for php < 4.3.0. 

Linkpage-0.9.1.4 - 16 January 2005 [mostly bugfixes in this release]
Changed copyright date to 2005. Happy new year!
Removed some brakes when not using stat functions in linkpage.php
Fixed displaying images and html blocks in the move to pulldown menus.
Fixed broken sql in preview.inc.php

Linkpage-v0.9.1.3 - 4 December 2004
Fixed broken style in stats.php
Added back to linkpage links in suggest.php, admin.php and stats.php
Added some more linkpage text to stats page.
fixed some sql problems.

Linkpage-v0.9.1.2 - 3 November 2004
Removed the function sp(). It was ment to markup the html code, but it was to complicated to do that all the time.
Fixed bug in linkpage.php concerning dbTablePrefix.

Linkpage-v0.9.1.1 - 31 Oktober 2004
Added config option for allowed tags in html blocks.
Updated installation script.

linkpage-v0.9.1.0 - 21 Oktober 2004
Added option to edit links in 'check dead links'.
print url in the alt and title of links.
printing different months in different colors in usageDaily.php
Added option for displaying images between the categories
Changed some CSS values and table sizes. The sizes are now fixed values in stead of relative.
Added in which category the link was added in the announcement mail.
Fixed errors in pagetitle.
Added option to add, change and remove html blocks to linkpage. This eneables you to add banners and forms to your linkpages.

linkpage-v0.9.0.4 - 29 April 2004 DATABASE DESIGN CHANGED
Added javascript confirmation before deleting links and categories. (Can be disabled)
Added new stylesheet. The design of http://www.startpagina.nl/
Fixed some include path errors.
Added option to alter the number of links checked in one time in checkDeadLinks.
Fixed table header while changing a user.
Removed reserved word `column`
Integrated a add link form in editCat
Fixed bug: not displaying move down arrows in edit linkpage.
Fixed bug: displaying horizontal scroll bar if linkpage is loaded in a frame.

linkpage-v0.9.0.3 - 10 April 2004
Updated documentation (home.inc.php)
Fixed a bug in check links function. (MySQL error: lost connection during query).
Fixed suggest.php not mailing.
Now displaying parse time and number of queries. in footer of linkpage.php and admin.php
Possible to record all queries to a database. ADVANCED 
Updated install.php.
Reduced number of queries used by linkpage.php. Before now linkpage was using n+1 queries when parsing linkpage (n=number of cats). Now linkpage uses a LEFT JOIN to get everything into one query. This results in one query. This one off course takes more time, but the total execution time is faster. (For my linkpage containing 15 categories and 62 links, the parse time falls from an average of 0.036 seconds to 0.018 seconds.)
Reduced size of linkpage by using <div></div> for the category markup instead of tables.
Updated stylesheets.
Use php to MD5 passwords in stead of mysql. (for error messages dumping the query)

linkpage-v0.9.0.2 - 3 March 2004
Nasty bug in column change fixed.

linkpage-v0.9.0.1 - 2 March 2004 DATABASE DESIGN CHANGED
Internal release. Not on the internet
Copyright link in suggest.php repaired.
Changed the way linkpage marks up the categories. Categories can now be put into columns. They are ordered by `place` in the columns itself.
For that I totally rewrote edit.inc.php.
Edited add.inc.php for creating cats into columns.
Edited linkage.php, linkpage.inc.php and preview.inc.php to display categories in columns.
Added editCat.inc.php to edit links in categories. It is not anymore possible to edit all the categories at once, because that caused really big pages which took too long to load.
Addad a dir `stats` which contains some files to generate some graphical statistics. 
Possible to let the hits message be a link to a new file: stats.php. This file shows some stats to visitors.
Added usageDaily.php displaying hits the daily hits for the last 30 days.
Updated linkpage.sql for the actual database structure.
Updated install.php for the actual database structure.

linkpage-v0.8.6.0 - Februari 2004
Added tab misc containing:
*Optimize tables. Executes the MySQL query OPTIMIZE TABLE `cat`, `link`, `log`, `users`;
*Flush log table. Empty log table; DELETE FROM `log`;
*Check dead links script. This function will open a socket to the link end receive the http header. The header is analized and the user can choose what to do with the link.
Moved many strings to language the files.
Bug in SQL code in install.php fixed. (md5pass<>password)
Added a restore default database function.(possible to store categories/links and/or users).
Removed debugData2File();
Added option to hide a link.
Updated install.php; removed some bugs.
Fixed bug in colAutoMarkup (linkpage.php)

linkpage-v0.8.5.1 - 2 Februari 2004 - DATABASE DISIGN CHANGED!!!
Made config.inc.php ONLY for configuration, not for making db connections etc.
Added HTTP_REFERER to log table.
Changed reserved word in mysql database 'password' to md5pass.
Added an migrate script.
Moved some files to different places see the files file.
Change copyright message and changed the link to linkpage.jpwaag.com instead of mailto:jpwaag@hotmail.com.
Now possible to use other database connections in the same script execution, without conflicts. (using $dbConnect as link resource identifier.)
Changed preview tab a bit.
Added linkTarget to editLink form.
Again some targets changed to POST.
Added an include file which can be include in other php applications. I hope without conflicts. This should enhance the flexibility of linkpage.
Changed directory structure quite much.
Added files:    /include/linkpage.inc.php.         A file to be included in other pages.
                /include/front/functions.inc.php   Linkpage specific functions
                /images/lpm-grey.css               linkpage style sheet grey/dark blue
                /images/lpm-jpwaag.com.css         linkpage style sheet like www.jpwaag.com
Removed files:  /image/grey.css
                /image/admin.css

linkpage-v0.8.5.0 - 13 Januari 2004
Added an option to disable gz compression on output.
Some documentation updates (home.inc.php).
Clicking on the delete cat button only will delete the cat, not clicking on the cat name.
Cleaned up the style sheets. Devided them into parts. The whole admin shit is not needed while loading linkpage.php.
Upgraded linkpage.php, secure.inc.php, admin.php edit.inc.php and suggest.php to xhtml.
Moved some code from linkpage.php to functions.
Marked up the html source of linkpage.php, secure.inc.php, admin.php, edit.inc.php and suggest.php
Changed form methods to POST.
Changed design of admin.php a bit.
Show host name and user when logged in.
Fixed error displaying single character messages.

linkpage-v0.8.4.4 - 6 Januari 2004
Added an option in addLink to create a new link while creating a link.
Improved colAutoMarkup.
Added a form to edit users. (change privileges, edit username, edit email address, change password.

linkpage-v0.8.4.3 - 5 Januari 2004
Fixed error in out.php.
Changed the link targets in 'admin - edit linkpage' to _blank
Updated nl.lng.php.
Added a installation script. It generates a config.inc.php file, and executes the necessary SQL queries to the database, but there is NO input checking. So delete the file immediately after using it because it can be a real security hole.

linkpage-v0.8.4.2 - 5 Januari 2004
Fixed error in addCat(dbTablePrefix was not implemented).
Fixed some errors in usageHourly.php.

linkpage-v0.8.4.1 - 2 Januari 2004
Improved some messages.
Require the English language file before any other language file, because that one is always up to date. If a value is not already added to another language file, the value from the English file is used.
out.php is now working again.

linkpage-v0.8.4.0 - 30 December 2003
Fixed debug function.
Fixed log in problems.

Linkpage-v0.8.3 - 27 December 2003
Fixed some language file errors.
Remade the project web site.
Fixed an error in addCat.
Fixed an error in addLink.
Fixed an error in delCat.
Fixed to undefined variables in functions.inc.php

Linkpage-v0.8.3rc2 - 23 December 2003
Removed underscores in variables.
Improved the suggest script.
Improved the language files. Use sprintf() more often.
Fixed bug in function adminLink();
Moved all text which is outputted to the browser to language the files.
function urlcheck() is now working properly.(only a VERY simple url check.)

Linkpage-v0.8.3rc1 - 22 December 2003
Added input checking for linkEdit.
Added TODO and BUGS section in CHANGE.LOG ^^.
Added an option to define a table prefix.
Added back ticks (`) on all table and column names in queries.
Added an enter before every keyword in queries (SELECT, FROM, WHERE, GROUP BY, ORDER BY, LIMIT, VALUES, INTO, INSERT, UPDATE).
Capitalized all those keywords.
Removed "SELECT *" queries from all files. 

Linkpage-v0.8.2 - 17 December 2003
Fixed new user's password bug.
Fixed delete user bug.
icon to edit user added. needs to be further implemented

Linkpage-v0.8.1 - 5 December 2003
Fixed delete link bug.
Updated grey.css.
some small design changes

Linkpage-v0.8.0 - 4 December 2003
Final design log in page.
Changed the design of admin.
Added documentation for every option in admin and for every $config option in config.inc.php
Added an database table with users allowed to access admin and changed the link table:
 ALTER TABLE `link` ADD `visible` ENUM( 'N', 'Y' ) DEFAULT 'Y' NOT NULL;"; 
 CREATE TABLE `users` (
  `ID` int(9) NOT NULL auto_increment,
  `email` text NOT NULL,
  `username` varchar(35) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `addCatPriv` enum('N','Y') NOT NULL default 'Y',
  `addLinkPriv` enum('N','Y') NOT NULL default 'Y',
  `delCatPriv` enum('N','Y') NOT NULL default 'Y',
  `delLinkPriv` enum('N','Y') NOT NULL default 'Y',
  `editLinkPriv` enum('N','Y') NOT NULL default 'Y',
  `moveCatPriv` enum('N','Y') NOT NULL default 'Y',
  `changeSettingsPriv` enum('N','Y') NOT NULL default 'Y',
  `manageUsersPriv` enum('N','Y') NOT NULL default 'N',
  PRIMARY KEY  (`ID`)
 ) TYPE=MyISAM;";
New options in admin:
*Possible to change the password of the current user.
*Possible to check privileges for different users.
*Possible to delete users from database.
Options that are not enabled for a user will not be displayed.
Added a form to allow visitors to suggest links to be added. They will appear with a red background in admin.php and do not appear immediately in linkpage.php. If you think the link should be added, the link will be made normal and will be visible in linkpage.php

Linkpage-v0.7.7 - 2 December 2003
Improved error messages. (for debugging.)
Removed a / in the catAdd SQL query. Something was not working there.[CRITICAL]
added _some_ design and a message to the admin log in page.
added an option to change all the link targets at one time.

Linkpage-v0.7.6 - 1 December 2003
_new replaced by _blank. If _new is used, all the links are opened in the same new window.
Rewrote the uptime() function; the 0 value bug is now gone
Input values are now first passed thru the strip_tags() function. To avoid tags like <script> destroy the design.
Linkpage.sql was not ok. Removed a comma. 
Target added in the linkadd form.
Added a new variable in config.inc.php: $config['basedir']. Fix some errors with redirecting.
With #add, the error message for the catadd and linkadd forms, is now immediately visible.

Linkpage-v0.7.5 - 21 November 2003
White spaces are not anymore recognized as part of a category or link name.
Some GET values were not urlencode()ed. now they are.
Remarked up config.inc.php. I hope you like the structure. Admin userID and Password are stored there too now. 
The © in the comment header of each file is replaced by (c) because some online editors(Ensim 3.1) don't want to edit files with non ASCII characters
Again some variable names were changed.
Added dropdown menu to select link target.

Linkpage-v0.7.4 - 19 November 2003
Added a chart for hourly usage.(my first GD script)
Updated database structure. 'datetime' is a reserved word > removed.
Removed all underscores from database and GET variables.
Column ip in log: varchar(14)>varchar(15)
Added a script to migrate to the new database structure.
Added an option to hide the header table.

Linkpage-v0.7.3 - 17 November 2003
With introduce of the language array ($text) $text became ambiguous; it was used in the function Edit. Fixed.[CRITICAL]
Possible to specify a value for the length of categories, links and URL's in config.inc.php
Updated grey.css: now fully working.
Possible to specify a page title and a HTML title in config.inc.php
Enabled gz compression for all pages this will reduce the traffic a lot, especially in admin.php

Linkpage-v0.7.2	- 15 November 2003
Config.inc.php is not included in every function.
All the text to be displayed is put in an array. Global $text[]; in every function will make them available in every function.
The same for the config Values($config[])

Linkpage-v0.7.1 - 29 September 2003
Function added: Password protect admin 
Update: English language pack
Function added: move category

Linkpage-v0.6.0 - 10 September 2003
Statistics summary added to admin.php
Function added: edit link
Option to view image instead of text links for delete, edit links and cats.

Linkpage-v0.5.1 - 6 September 2003
Statistics for links added

Linkpage-v0.5 - 6 September 2003
Option to hide 'admin' link in config.inc.php
Option to manually divide cats over columns
Function added: move link between categories.
Bug 'double inserts after Refresh in admin' fixed

Linkpage-v0.4.3 - 3 September 2003
Bug 'auto place calculation' fixed

Linkpage-v0.4.2 - 2 September 2003
Bug '9 cats maximum 'fixed'.

Linkpage-v0.4.1 - 2 September 2003
Bug Add new link fixed

Linkpage-v0.4 - 1 September 2003
Admin page working, some better structure. 

Linkpage-v0.3.0
Multi language support. 
Linktarget changeable.
New Design.

Linkpage-v0.2.1 - 16 January 2003
First release, no admin page. 

Linkpage-v0.1 - November 2002
Internal version. No publish