@@ -51,7 +51,7 @@ Setting the old-mode setting as blank overrides the UTF8_IS_UTF8MB3 binding to t

 Reference: https://mariadb.com/docs/server/server-management/variables-and-modes/old_mode

-Alternateively, in includes/mysqli_functions, you may comment the line **mysqli_query($mysqli_access, "SET NAMES UTF8;");**  and uncomment the line **mysqli_query($mysqli_access, "SET NAMES UTF8MB4;");** if you are not able to configure the database configuration.

+Alternateively, in includes/mysqli_functions, you may comment the line **mysqli_query($mysqli_access, "SET NAMES UTF8;");**  and uncomment the line **mysqli_query($mysqli_access, "SET NAMES UTF8MB4;");** if you are not able to configure the database configuration. It is recommended to uncomment the line **mysqli_query($mysqli_access, "SET collation_connection = utf8mb4_bin;");** if the UTF8MB4 line is used as well.

 ### Installation and Usage

@@ -51,6 +51,8 @@ Setting the old-mode setting as blank overrides the UTF8_IS_UTF8MB3 binding to t

 Reference: https://mariadb.com/docs/server/server-management/variables-and-modes/old_mode

+Alternateively, in includes/mysqli_functions, you may comment the line **mysqli_query($mysqli_access, "SET NAMES UTF8;");**  and uncomment the line **mysqli_query($mysqli_access, "SET NAMES UTF8MB4;");** if you are not able to configure the database configuration.

+

 ### Installation and Usage

@@ -40,7 +40,8 @@ character-set-server = utf8mb4

 <br>

 collation-server = utf8mb4_unicode_ci

-For MySQL versions starting with 8.0, the default setting for collation_server is **utf8mb4_0900_ai_ci**. For MariaDB versions starting with 11.8 (introduced in 11.6), the default setting for collation_server is **utf8mb4_uca1400_ai_ci**.

+- For MySQL versions starting with 8.0, the default setting for collation_server is **utf8mb4_0900_ai_ci**.

+- For MariaDB versions starting with 11.8 (introduced in 11.6), the default setting for collation_server is **utf8mb4_uca1400_ai_ci**.

 For MariaDB versions 10.6 to 11.4, this is needed:

@@ -1,12 +1,12 @@

 # eFiction 3 Mod

-This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. Support of bcrypt passwords with old MD5 fallback, new user regisrations control, and more choices of tinyMCE are a few of my modifications.

+This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. Support of bcrypt passwords with old MD5 fallback, new user registrations control, and more choices of tinyMCE are a few of my modifications.

 ## Requirements

 - Minimum: PHP 7.4, MySQL 5.7.7 or MariaDB 10.6

-- Recommnended: PHP 8.4, MySQL 8.0 or MariaDB 11.4

+- Recommended: PHP 8.4, MySQL 8.0 or MariaDB 11.4

 - Tested Working: PHP: 7.4.33, 8.5.8; MariaDB: 10.6, 10.11, 11.4

@@ -19,6 +19,45 @@ Same as the usual eFiction 3.x installs.

 Just place the script over your current install like any upgrade. This script can upgrade to future 3.5.9 with a few eFiction 3 Mod entries by upgrading over versions 3.5.3 to 3.5.8. After that, go to the conversion page in the Archive Conversion Panel to convert the database to eFiction 3 Mod. If you have already upgraded to a clean version of future 3.5.9, you can just go straight to the Archive Conversion page and run the Mod conversion script, as the upgrade.php file will not run at that point.

+

+## Notes

+

+

+### PHP

+

+This script is being tested for issues with future PHP 8.6.0, and anything actually unique to 8.6 was likely fixed. The other stuff would be related to older PHP 8 versions. Since some patches over time (starting in 2016) use PHP 7+ only behavior, this means that you can no longer use eFiction with PHP 5.6 and earlier. PHP should also use the UTF-8 character set to use this script. The entry in the ini file should say UTF-8 for default_charset.

+

+default_charset = "UTF-8"

+

+

+### Database

+

+Due to the community changes to this script over the years, it now handles text and data as UTF-8 as opposed to ISO-8859-1. Further changes to this script here should fully handle multibyte characters now. Yes, eFiction can now finally use emoji! To fully take advantage of this archive's character set, the database server does need to connect and use the utf8mb4 collation. This is just a sample for my.cnf or equivalent, needed for older installs and versions. Note: character_set_system is hardcoded and cannot be user-set.

+

+init-connect = 'SET NAMES utf8mb4'

+<br>

+character-set-server = utf8mb4

+<br>

+collation-server = utf8mb4_unicode_ci

+

+For MySQL versions starting with 8.0, the default setting for collation_server is **utf8mb4_0900_ai_ci**. For MariaDB versions starting with 11.8 (introduced in 11.6), the default setting for collation_server is **utf8mb4_uca1400_ai_ci**.

+

+For MariaDB versions 10.6 to 11.4, this is needed:

+

+old-mode =

+

+Setting the old-mode setting as blank overrides the UTF8_IS_UTF8MB3 binding to this variable and uses the current utf8mb4 aliasing.

+

+Reference: https://mariadb.com/docs/server/server-management/variables-and-modes/old_mode

+

+

+### Installation and Usage

+

+- The directory eFiction will be installed should have read, write and execute permissions. For Unix/Linux, it should technically be chmod'ed to 755 and chown'ed to the web server's user account. The directory should be chown'ed to the webserver user (usually daemon, www-data, or apache). Failing that, you can either chmod 755 (777 if failed somehow, should probably change it back to 755 afterwards) or create a blank config.php file (example: touch /path/to/eFiction3/config.php) in your eFiction directory and chmod that to 666.

+- Creating a series entry, adding a story to the series, then removing the story from the series can leave the Number of Stories count unchanged. This is due to the fact that some references aren't calculated automatically. In the Admin Panel > Archive Maintenance section, use 'Recalculate Reviews', 'Recalculate Stories', and 'Recalculate Site Statistics', and it should rectify this issue.

+- When using the category 'Only one' setting for a single category, the script strongly assumes to use catid=1 for adding a series to a category, so if that particular category was later removed, the Category: field will be empty. Doesn't help that you can still create more categories after the fact, which may muddy up things a bit. Using 'Fix Category Order' should fix this to some extent, but if that fails, database table editing in 'fanfiction_categories' to change the intended category to catid=1 AND changing AUTO_INCREMENT to 2 should suffice. If, somehow, there are no categories in the database and the AUTO_INCREMENT count is past 2, change AUTO_INCREMENT back to 1 and create the intended category.

+- The initial database installation script explicitly removes all the forced latin1 charset and latin1_swedish_ci collation references starting with eFiction 3.5.5 (meaning they were last present in eFiction 3.5.3). The forced latin1 charset in the script would have caused issues with much newer database installs using utf8mb3 or utf8mb4 by default. As a result, it uses the server's database settings. It, however, does force MyISAM for its database engine, and this mod forces that to InnoDB anyway, despite it being the database server default for over 15 years. I have not seen any issues regarding the InnoDB change in eFiction 3 Mod as of yet.

+

 <br>

 # Changelog

@@ -55,7 +94,7 @@ Just place the script over your current install like any upgrade. This script ca

 - install/corefunctions.php, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

 - stories.php, viewstory.php, includes/corefunctions.php, includes/storyblock.php, includes/storyform.php, user/revres.php: proper coauthors behavior fixes

 - docs/config.php, includes/browsecategories.php, includes/categorylist.php, includes/characterlist.php, includes/userlist.php, install/install.php, user/login.php: redundant dbfunctions.php entries including cleanup

-- header.php, rss.php, admin/backup.php, admin/backup_utf8.php, includes/categorylist.php, includes/userlist.php, install/install.php, languages/en.php: possible CHARSET definition breakage - mostly reverted as one former config.php line does belong in includes/dbfunctions.php

+- header.php, rss.php, admin/backup.php, admin/backup_utf8.php, includes/categorylist.php, includes/userlist.php, install/install.php, languages/en.php: possible CHARSET definition breakage - mostly reverted as one former config.php line does belong in includes/dbfunctions.php and very old editing typo causing Uncaught ValueError: Unknown format specifier message regarding changing an author with logging enabled fix

 - rss.php, includes/button.php (me), languages/en.php (me): error and warning message suppression removal - rss and en were a stupid hack for the actual problem in the next item of the list

 - languages/en.php: undefined variables warning fix for PHP 8.x - applies to any other language PHP files, so they should be updated - only needs one line and one additional file in the **includes** directory

 - admin/settings.php, install/install.php: Do not parse the mailer directory in the Admin Panel's or installer's language setting's drop-down menus

@@ -65,6 +104,7 @@ Just place the script over your current install like any upgrade. This script ca

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

 - TinyMCE versions added; now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, 5.3.2, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

 - Setting to enable or disable new user registrations - sorely needed for some archives

+- New Archive Conversion page for Unicode database conversions - initial Mod conversion and Unicode versions 4.0, 5.2, 9.0, 14.0

 <br>

@@ -1,6 +1,6 @@

 # eFiction 3 Mod

-This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. This script can upgrade to future 3.5.9 with a few eFiction 3 Mod entries by upgrading over versions 3.5.3 to 3.5.8. After that, go to the conversion page in the Archive Conversion Panel to convert the database to eFiction 3 Mod.

+This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. Support of bcrypt passwords with old MD5 fallback, new user regisrations control, and more choices of tinyMCE are a few of my modifications.

 ## Requirements

@@ -17,7 +17,7 @@ Same as the usual eFiction 3.x installs.

 ## Updating

-Just place the script over your current install like any upgrade. If you have already upgraded to future 3.5.9, you need to run a MySQL query to support the Enable Registrations mod and update the 'fanfiction_authors' table's password field to support 255 characters first. (That is, until I try and add *that* to the Mod conversion script.) Both queries are in the Mod's update.php script.

+Just place the script over your current install like any upgrade. This script can upgrade to future 3.5.9 with a few eFiction 3 Mod entries by upgrading over versions 3.5.3 to 3.5.8. After that, go to the conversion page in the Archive Conversion Panel to convert the database to eFiction 3 Mod. If you have already upgraded to a clean version of future 3.5.9, you can just go straight to the Archive Conversion page and run the Mod conversion script, as the upgrade.php file will not run at that point.

 <br>

@@ -1,6 +1,6 @@

 # eFiction 3 Mod

-This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. For now, there are no auto paths to patch old eFiction versions to this version, so it has to be done manually. (The update.php file needs to be cleaned up, and the 3.5.5 update does not work properly in PHP 7 anyway.)

+This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. This script can upgrade to future 3.5.9 with a few eFiction 3 Mod entries by upgrading over versions 3.5.3 to 3.5.8. After that, go to the conversion page in the Archive Conversion Panel to convert the database to eFiction 3 Mod.

 ## Requirements

@@ -17,7 +17,7 @@ Same as the usual eFiction 3.x installs.

 ## Updating

-Has to be done manually for now. Easiest if you have either unofficial versions 3.5.8, 3.5.8.f1, or future 3.5.9. If you are updating from versions 3.5.3, 3.5.5, or 3.5.6, update to at least version 3.5.8 first.

+Just place the script over your current install like any upgrade. If you have already upgraded to future 3.5.9, you need to run a MySQL query to support the Enable Registrations mod and update the 'fanfiction_authors' table's password field to support 255 characters first. (That is, until I try and add *that* to the Mod conversion script.) Both queries are in the Mod's update.php script.

 <br>

@@ -51,6 +51,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - header.php: leftover array typo oversight fix with age consent feature

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

 - blocks/menu/menu.php: Array to string conversion warning when accessing the menu block page fix

+- admin/panels.php: Trying to access offset array on null PHP warning when creating a new panel entry fix

 - install/corefunctions.php, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

 - stories.php, viewstory.php, includes/corefunctions.php, includes/storyblock.php, includes/storyform.php, user/revres.php: proper coauthors behavior fixes

 - docs/config.php, includes/browsecategories.php, includes/categorylist.php, includes/characterlist.php, includes/userlist.php, install/install.php, user/login.php: redundant dbfunctions.php entries including cleanup

@@ -50,6 +50,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - categories.php: deleting only category causing Fatal Error bug fix for PHP 8.x users

 - header.php: leftover array typo oversight fix with age consent feature

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

+- blocks/menu/menu.php: Array to string conversion warning when accessing the menu block page fix

 - install/corefunctions.php, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

 - stories.php, viewstory.php, includes/corefunctions.php, includes/storyblock.php, includes/storyform.php, user/revres.php: proper coauthors behavior fixes

 - docs/config.php, includes/browsecategories.php, includes/categorylist.php, includes/characterlist.php, includes/userlist.php, install/install.php, user/login.php: redundant dbfunctions.php entries including cleanup

@@ -57,6 +58,8 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - rss.php, includes/button.php (me), languages/en.php (me): error and warning message suppression removal - rss and en were a stupid hack for the actual problem in the next item of the list

 - languages/en.php: undefined variables warning fix for PHP 8.x - applies to any other language PHP files, so they should be updated - only needs one line and one additional file in the **includes** directory

 - admin/settings.php, install/install.php: Do not parse the mailer directory in the Admin Panel's or installer's language setting's drop-down menus

+- admin/viewlog.php, languages/en_admin.php: some hardcoded English entries have been relocated to the Admin Panel language file

+- includes/reviewform.php, includes/seriesreviews.php, reviews.php: Number of Likes - unfinished calculation fixes and updates, implement its entry in the review form as well

 - Bridges return! Their removal got rid of the example work, which is now updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

 - TinyMCE versions added; now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, 5.3.2, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

@@ -44,6 +44,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - includes/userlist.php: Uncaught TypeError for Co-Authors field in PHP 8.x when searching for a user with the first character yields no results - discovered this one entirely by accident due to a typo... slipped my hand on the keyboard!

 - install/install.php: SMTP settings table column creation oversight fix, consistency changes, and cleanup

 - user/manageimages.php: Add support for WebP images

+- search.php: failed penname search causes PHP warning fix for PHP 8.x users - MySQL error message overwriting the Search Results header due to an assumption of an array count of author data

 - series.php: category settings causing Fatal Error bug for PHP 8.x users and Undefined array key PHP warning fixes

 - stories.php: add story with null category using 'Only one' setting causing Fatal Error bug fix for PHP 8.x users

 - categories.php: deleting only category causing Fatal Error bug fix for PHP 8.x users

@@ -37,12 +37,13 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - Original eFiction 3 skins restored

 - Future 3.5.9 SMTP database table creation oversight fixes (also install.php consistency change)

 - SQL database engine change from MyISAM to InnoDB

-- SQL database charset changes from latin1 to utf8mb4 (certain fields are utf8mb4 'ci' for sorting purposes, however)

+- SQL database charset changes from latin1 to utf8mb4 (certain fields are utf8mb4 'ci' for sorting purposes and certain count purposes, however)

 - Password hashes are now bcrypt with a cost of 12 instead of MD5 (though old MD5 hashed passwords still work until changed by user)

 - includes/button.php: GD captcha font path handling fix for PHP 8.6/GD 2.4.0 users and remove unused variable

 - includes/corefunctions.php: occasional foreach array|object, string given PHP warning fix

-- includes/userlist.php: Uncaught TypeError for Co-Authors field in PHP 8 when searching for a user with the first character yields no results - found this one entirely by accident due to a typo!

-- install/install.php: SMTP settings table column creation oversight fix and consistency changes

+- includes/userlist.php: Uncaught TypeError for Co-Authors field in PHP 8.x when searching for a user with the first character yields no results - discovered this one entirely by accident due to a typo... slipped my hand on the keyboard!

+- install/install.php: SMTP settings table column creation oversight fix, consistency changes, and cleanup

+- user/manageimages.php: Add support for WebP images

 - series.php: category settings causing Fatal Error bug for PHP 8.x users and Undefined array key PHP warning fixes

 - stories.php: add story with null category using 'Only one' setting causing Fatal Error bug fix for PHP 8.x users

 - categories.php: deleting only category causing Fatal Error bug fix for PHP 8.x users

@@ -51,8 +52,11 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - install/corefunctions.php, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

 - stories.php, viewstory.php, includes/corefunctions.php, includes/storyblock.php, includes/storyform.php, user/revres.php: proper coauthors behavior fixes

 - docs/config.php, includes/browsecategories.php, includes/categorylist.php, includes/characterlist.php, includes/userlist.php, install/install.php, user/login.php: redundant dbfunctions.php entries including cleanup

-- header.php, rss.php, admin/backup.php, admin/backup_utf8.php, includes/categorylist.php, includes/userlist.php, languages/en.php: possible CHARSET definition breakage - mostly reverted as one former config.php line does belong in includes/dbfunctions.php

-- Bridges return! Their removal got rid of the example work, which needs to be updated as well

+- header.php, rss.php, admin/backup.php, admin/backup_utf8.php, includes/categorylist.php, includes/userlist.php, install/install.php, languages/en.php: possible CHARSET definition breakage - mostly reverted as one former config.php line does belong in includes/dbfunctions.php

+- rss.php, includes/button.php (me), languages/en.php (me): error and warning message suppression removal - rss and en were a stupid hack for the actual problem in the next item of the list

+- languages/en.php: undefined variables warning fix for PHP 8.x - applies to any other language PHP files, so they should be updated - only needs one line and one additional file in the **includes** directory

+- admin/settings.php, install/install.php: Do not parse the mailer directory in the Admin Panel's or installer's language setting's drop-down menus

+- Bridges return! Their removal got rid of the example work, which is now updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

 - TinyMCE versions added; now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, 5.3.2, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

 - Setting to enable or disable new user registrations - sorely needed for some archives

@@ -39,21 +39,22 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - SQL database engine change from MyISAM to InnoDB

 - SQL database charset changes from latin1 to utf8mb4 (certain fields are utf8mb4 'ci' for sorting purposes, however)

 - Password hashes are now bcrypt with a cost of 12 instead of MD5 (though old MD5 hashed passwords still work until changed by user)

-- includes/button: GD captcha font path handling fix for PHP 8.6/GD 2.4.0 users and remove unused variable

+- includes/button.php: GD captcha font path handling fix for PHP 8.6/GD 2.4.0 users and remove unused variable

 - includes/corefunctions.php: occasional foreach array|object, string given PHP warning fix

+- includes/userlist.php: Uncaught TypeError for Co-Authors field in PHP 8 when searching for a user with the first character yields no results - found this one entirely by accident due to a typo!

 - install/install.php: SMTP settings table column creation oversight fix and consistency changes

 - series.php: category settings causing Fatal Error bug for PHP 8.x users and Undefined array key PHP warning fixes

 - stories.php: add story with null category using 'Only one' setting causing Fatal Error bug fix for PHP 8.x users

 - categories.php: deleting only category causing Fatal Error bug fix for PHP 8.x users

 - header.php: leftover array typo oversight fix with age consent feature

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

-- install/corefunctions, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

+- install/corefunctions.php, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

 - stories.php, viewstory.php, includes/corefunctions.php, includes/storyblock.php, includes/storyform.php, user/revres.php: proper coauthors behavior fixes

 - docs/config.php, includes/browsecategories.php, includes/categorylist.php, includes/characterlist.php, includes/userlist.php, install/install.php, user/login.php: redundant dbfunctions.php entries including cleanup

 - header.php, rss.php, admin/backup.php, admin/backup_utf8.php, includes/categorylist.php, includes/userlist.php, languages/en.php: possible CHARSET definition breakage - mostly reverted as one former config.php line does belong in includes/dbfunctions.php

 - Bridges return! Their removal got rid of the example work, which needs to be updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

-- TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

+- TinyMCE versions added; now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, 5.3.2, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

 - Setting to enable or disable new user registrations - sorely needed for some archives

 <br>

@@ -39,12 +39,18 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - SQL database engine change from MyISAM to InnoDB

 - SQL database charset changes from latin1 to utf8mb4 (certain fields are utf8mb4 'ci' for sorting purposes, however)

 - Password hashes are now bcrypt with a cost of 12 instead of MD5 (though old MD5 hashed passwords still work until changed by user)

+- includes/button: GD captcha font path handling fix for PHP 8.6/GD 2.4.0 users and remove unused variable

+- includes/corefunctions.php: occasional foreach array|object, string given PHP warning fix

 - install/install.php: SMTP settings table column creation oversight fix and consistency changes

-- series.php: category settings causing Fatal Error bug fix for PHP 8.x users

+- series.php: category settings causing Fatal Error bug for PHP 8.x users and Undefined array key PHP warning fixes

 - stories.php: add story with null category using 'Only one' setting causing Fatal Error bug fix for PHP 8.x users

 - categories.php: deleting only category causing Fatal Error bug fix for PHP 8.x users

 - header.php: leftover array typo oversight fix with age consent feature

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

+- install/corefunctions, user/revres.php: Trying to access array offset on null PHP warning when responding to a review fix

+- stories.php, viewstory.php, includes/corefunctions.php, includes/storyblock.php, includes/storyform.php, user/revres.php: proper coauthors behavior fixes

+- docs/config.php, includes/browsecategories.php, includes/categorylist.php, includes/characterlist.php, includes/userlist.php, install/install.php, user/login.php: redundant dbfunctions.php entries including cleanup

+- header.php, rss.php, admin/backup.php, admin/backup_utf8.php, includes/categorylist.php, includes/userlist.php, languages/en.php: possible CHARSET definition breakage - mostly reverted as one former config.php line does belong in includes/dbfunctions.php

 - Bridges return! Their removal got rid of the example work, which needs to be updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

 - TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

@@ -48,6 +48,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - Bridges return! Their removal got rid of the example work, which needs to be updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

 - TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

+- Setting to enable or disable new user registrations - sorely needed for some archives

 <br>

@@ -47,7 +47,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

 - Bridges return! Their removal got rid of the example work, which needs to be updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

-- TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.1.2, 3.4.8, and 4.5.12 - replaces eFiction 3.5.x's original 3.0.9

+- TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.1.2, 3.4.8, 4.5.12, and 6.8.6 - replaces eFiction 3.5.x's original 3.0.9

 <br>

@@ -47,7 +47,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

 - Bridges return! Their removal got rid of the example work, which needs to be updated as well

 - Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

-- TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.0.1, 3.4.8, and 4.5.3

+- TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.1.2, 3.4.8, and 4.5.12 - replaces eFiction 3.5.x's original 3.0.9

 <br>

@@ -46,7 +46,7 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - header.php: leftover array typo oversight fix with age consent feature

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

 - Bridges return! Their removal got rid of the example work, which needs to be updated as well

-- Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages (installer layout needs work, however)

+- Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages, installer

 - TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.0.1, 3.4.8, and 4.5.3

 <br>

@@ -37,12 +37,17 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - Original eFiction 3 skins restored

 - Future 3.5.9 SMTP database table creation oversight fixes (also install.php consistency change)

 - SQL database engine change from MyISAM to InnoDB

-- SQL database charset changes from latin1 to utf8mb4 

+- SQL database charset changes from latin1 to utf8mb4 (certain fields are utf8mb4 'ci' for sorting purposes, however)

 - Password hashes are now bcrypt with a cost of 12 instead of MD5 (though old MD5 hashed passwords still work until changed by user)

 - install/install.php: SMTP settings table column creation oversight fix and consistency changes

 - series.php: category settings causing Fatal Error bug fix for PHP 8.x users

+- stories.php: add story with null category using 'Only one' setting causing Fatal Error bug fix for PHP 8.x users

+- categories.php: deleting only category causing Fatal Error bug fix for PHP 8.x users

 - header.php: leftover array typo oversight fix with age consent feature

 - admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

+- Bridges return! Their removal got rid of the example work, which needs to be updated as well

+- Layout fixes and consistency changes for various sections of the script: admin settings, new/edit story pages, new/edit series pages (installer layout needs work, however)

+- TinyMCE 3.4.8 added (this was from my own archives); now you have a choice of TinyMCE versions 2.0.1, 3.4.8, and 4.5.3

 <br>

@@ -6,7 +6,7 @@ This version is essentially a version of 'future 3.5.9' wiith some of my interna

 ## Requirements

 - Minimum: PHP 7.4, MySQL 5.7.7 or MariaDB 10.6

-- Recommnended: PHP 8.4, MySQL 7.0 or MariaDB 11.4

+- Recommnended: PHP 8.4, MySQL 8.0 or MariaDB 11.4

 - Tested Working: PHP: 7.4.33, 8.5.8; MariaDB: 10.6, 10.11, 11.4

@@ -5,7 +5,7 @@ This version is essentially a version of 'future 3.5.9' wiith some of my interna

 ## Requirements

-- Minimum: PHP 7.4, MySQL 5.6.3 or MariaDB 10.5

+- Minimum: PHP 7.4, MySQL 5.7.7 or MariaDB 10.6

 - Recommnended: PHP 8.4, MySQL 7.0 or MariaDB 11.4

 - Tested Working: PHP: 7.4.33, 8.5.8; MariaDB: 10.6, 10.11, 11.4

@@ -39,6 +39,10 @@ Has to be done manually for now. Easiest if you have either unofficial versions

 - SQL database engine change from MyISAM to InnoDB

 - SQL database charset changes from latin1 to utf8mb4 

 - Password hashes are now bcrypt with a cost of 12 instead of MD5 (though old MD5 hashed passwords still work until changed by user)

+- install/install.php: SMTP settings table column creation oversight fix and consistency changes

+- series.php: category settings causing Fatal Error bug fix for PHP 8.x users

+- header.php: leftover array typo oversight fix with age consent feature

+- admin/settings.php: SMTP updates/fixes and test code implementation and oversights breaking Ratings and $storiespath fixes

 <br>

@@ -18,7 +18,9 @@ Same as the usual eFiction 3.x installs.

 ## Updating

 Has to be done manually for now. Easiest if you have either unofficial versions 3.5.8, 3.5.8.f1, or future 3.5.9. If you are updating from versions 3.5.3, 3.5.5, or 3.5.6, update to at least version 3.5.8 first.

+

 <br>

+

 # Changelog

@@ -1,85 +1,43 @@

-# efiction v3.5.8 fixes

+# eFiction 3 Mod

-- rating display fix

+This version is essentially a version of 'future 3.5.9' wiith some of my internal modifications. For now, there are no auto paths to patch old eFiction versions to this version, so it has to be done manually. (The update.php file needs to be cleaned up, and the 3.5.5 update does not work properly in PHP 7 anyway.)

-# efiction v3.5.8

+## Requirements

-- added notification module

-- changed files: user/editbio.php and user/lostpassword.php 

-- chanded way for loading DB functions - moved from config file! 

-- fixed bug in install.php - script worked but in PHP 8.x it caused warnings

-- new ranking system - number of likes, used as {ratingpics} likes in tpl.

+- Minimum: PHP 7.4, MySQL 5.6.3 or MariaDB 10.5

+- Recommnended: PHP 8.4, MySQL 7.0 or MariaDB 11.4

+- Tested Working: PHP: 7.4.33, 8.5.8; MariaDB: 10.6, 10.11, 11.4

-# efiction v3.5.7

+## Installation

-minimum requirements:  MySQL 5.6.3  or MariaDB 10.5.0 

+Same as the usual eFiction 3.x installs.

-### Database changes:

+## Updating

-- all IP adress fields - from integer to 46 chars

+Has to be done manually for now. Easiest if you have either unofficial versions 3.5.8, 3.5.8.f1, or future 3.5.9. If you are updating from versions 3.5.3, 3.5.5, or 3.5.6, update to at least version 3.5.8 first.

+<br>

+# Changelog

-### Other changes:

-- tinymce4 settings fix

-- INET6 support needed

-- file uploading fixed for PHP 8.1

-- national characters fix in search form 

+### Future 3.5.9 release has the following changes and fixes so far:

+- date fields fix

+- logs fail typo fix

+- PHP warning fixes

+- SMTP updates/fixes and an SMTP settings tester

-# efiction v3.5.6

+### eFiction 3 Mod has the following changes and fixes so far:

-non official version of 3.5.x efiction software

+- Original eFiction 3 skins restored

+- Future 3.5.9 SMTP database table creation oversight fixes (also install.php consistency change)

+- SQL database engine change from MyISAM to InnoDB

+- SQL database charset changes from latin1 to utf8mb4 

+- Password hashes are now bcrypt with a cost of 12 instead of MD5 (though old MD5 hashed passwords still work until changed by user)

-## Only for testing purposes

+<br>

-

-### Database changes:

-

-- all date fields from datestamp format to unix time format

-

-### File's changes

-

-- related date field type changes

-- found issues fixed

-- deleted bridges 

-

-### Looking for missing modules

-If you have source code of missing and used modules, share it and I can try to add and fix them

-

-

-### Installation

-No change

-

-### Update

-Classic as before, run update process that should change your date fields without lossing your data. It works only for update from 3.5.5, not sooner.

-

-

-

-<code>

-// ----------------------------------------------------------------------

-// Copyright (c) 2007 by Tammy Keefer

-// Based on eFiction 1.1

-// Copyright (C) 2003 by Rebecca Smallwood.

-// http://efiction.sourceforge.net/

-// ----------------------------------------------------------------------

-// LICENSE

-//

-// This program is free software; you can redistribute it and/or

-// modify it under the terms of the GNU General Public License (GPL)

-// as published by the Free Software Foundation; either version 2

-// of the License, or (at your option) any later version.

-//

-// This program is distributed in the hope that it will be useful,

-// but WITHOUT ANY WARRANTY; without even the implied warranty of

-// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

-// GNU General Public License for more details.

-//

-// To read the license please visit http://www.gnu.org/copyleft/gpl.html

-// ----------------------------------------------------------------------

-

-see more in README.txt file

-</code>

+README_old.md has the noted changes and fixes from 3.5.8.f1 down to 3.5.6.

@@ -1,3 +1,8 @@

+# efiction v3.5.8 fixes

+

+- rating display fix

+

+

 # efiction v3.5.8

 - added notification module

@@ -4,6 +4,7 @@

 - changed files: user/editbio.php and user/lostpassword.php 

 - chanded way for loading DB functions - moved from config file! 

 - fixed bug in install.php - script worked but in PHP 8.x it caused warnings

+- new ranking system - number of likes, used as {ratingpics} likes in tpl.

 # efiction v3.5.7

@@ -2,6 +2,8 @@

 - added notification module

 - changed files: user/editbio.php and user/lostpassword.php 

+- chanded way for loading DB functions - moved from config file! 

+- fixed bug in install.php - script worked but in PHP 8.x it caused warnings

 # efiction v3.5.7

@@ -1,3 +1,9 @@

+# efiction v3.5.8

+

+- added notification module

+- changed files: user/editbio.php and user/lostpassword.php 

+

+

 # efiction v3.5.7

 minimum requirements:  MySQL 5.6.3  or MariaDB 10.5.0 

@@ -1,3 +1,21 @@

+# efiction v3.5.7

+

+minimum requirements:  MySQL 5.6.3  or MariaDB 10.5.0 

+

+

+### Database changes:

+

+- all IP adress fields - from integer to 46 chars

+

+### Other changes:

+

+- tinymce4 settings fix

+- INET6 support needed

+- file uploading fixed for PHP 8.1

+- national characters fix in search form 

+

+

+

 # efiction v3.5.6

 non official version of 3.5.x efiction software

@@ -1,2 +1,53 @@

-# efiction-3.5.6

-Efiction CMS version 3.5.6 

+# efiction v3.5.6

+

+non official version of 3.5.x efiction software

+

+## Only for testing purposes

+

+

+### Database changes:

+

+- all date fields from datestamp format to unix time format

+

+### File's changes

+

+- related date field type changes

+- found issues fixed

+- deleted bridges 

+

+### Looking for missing modules

+If you have source code of missing and used modules, share it and I can try to add and fix them

+

+

+### Installation

+No change

+

+### Update

+Classic as before, run update process that should change your date fields without lossing your data. It works only for update from 3.5.5, not sooner.

+

+

+

+<code>

+// ----------------------------------------------------------------------

+// Copyright (c) 2007 by Tammy Keefer

+// Based on eFiction 1.1

+// Copyright (C) 2003 by Rebecca Smallwood.

+// http://efiction.sourceforge.net/

+// ----------------------------------------------------------------------

+// LICENSE

+//

+// This program is free software; you can redistribute it and/or

+// modify it under the terms of the GNU General Public License (GPL)

+// as published by the Free Software Foundation; either version 2

+// of the License, or (at your option) any later version.

+//

+// This program is distributed in the hope that it will be useful,

+// but WITHOUT ANY WARRANTY; without even the implied warranty of

+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

+// GNU General Public License for more details.

+//

+// To read the license please visit http://www.gnu.org/copyleft/gpl.html

+// ----------------------------------------------------------------------

+

+see more in README.txt file

+</code>

new file mode 100644

@@ -0,0 +1,2 @@

+# efiction-3.5.6

+Efiction CMS version 3.5.6