Commit graph

159 commits

Author SHA1 Message Date
Heiko August
9e21b01afd Change: add all database changes to the file update/update.sql 2022-05-08 18:07:13 +02:00
Heiko August
243a0fd678 Fix: add the lost bracket, it's non existence caused a syntax error 2022-05-08 18:07:13 +02:00
Heiko August
cd962b0fa0 Change: add the list of files to replace to the completed list of versions 2022-05-08 18:07:13 +02:00
Heiko August
2338871205 Change: add the interim versions between 2.4.20 and 2.4.99.0 to the list of versions that are upgradable 2022-05-08 18:07:13 +02:00
Heiko August
a921dcba7b Change: add key creation for B8_spam and B(_training_type to the update and installation script 2022-05-08 18:07:13 +02:00
Heiko August
cd6365bfff Change: add the unique keys that appears in the update script also to the installation script and vice versa 2022-05-08 18:07:13 +02:00
Heiko August
616894bdb8 Change: add the versions between 2.4.20 and 2.4.99.0 to the list of versions to update 2022-05-08 18:07:13 +02:00
Heiko August
adedc72d7c Change: check variables for content because null value for function (l|r)trim is deprecated with PHP 8.1 2022-05-01 17:46:00 +02:00
Heiko August
a5e4f0f890 Fix: set the default value for 'link_open_target' to an empty string instead of '0' 2022-04-20 10:13:29 +02:00
Heiko August
c3ad3b5e12 Change: add new setting 'link_open_target' to the update procedure 2022-04-20 10:13:29 +02:00
Heiko August
405d607a99 Change: create the table column mlf2_userdata.browser_window_target
Default is 0 for opening links in the same window/tab.
2021-09-20 19:50:35 +00:00
Michael Loesler
5aad6442e1
Unique values (#567)
- Columns `user_name` and `user_email` are set to `UNIQUE`
2021-03-05 17:25:08 +01:00
Michael Loesler
7870f026d7 sql changes
- added two options to setting table
  + delete_inactive_users (default 30, unit days)
  + notify_inactive_users (default 3, unit years)
- added new column in user table `inactivity_notification` of type boolean
2020-04-29 10:51:18 +02:00
Michael Loesler
a806a260b6
update module (#511)
* update module

- update bad-behavior to version 2.2.23

* add changes

- updated files are added to update script
2019-09-28 13:58:48 +02:00
Heiko August
07c0410e0d Change: add the list of files to update for version 2.4.99.3 2019-09-24 21:56:36 +02:00
Heiko August
879d519d37 Change: add version 2.4.99.2 to the list of updatable versions 2019-09-24 21:56:27 +02:00
Heiko August
36ea99ac36 Change: remove update script for version 2.3.5 to version 2.4.x 2019-08-26 22:04:28 +02:00
Heiko August
a1bed6a265 Fix: restrict mlf2_userdata.user_name and mlf2_b8_wordlist.token to 128 characters 2019-08-26 22:01:18 +02:00
Heiko August
6f826dd919 Fix: provide table change statement for mlf2_tags also for version change to 2.4.99.2 2019-08-26 21:23:42 +02:00
Heiko August
5f48894f1e Change: add the queries for altering the table type to InnoDB also to the update script 2019-08-08 15:51:03 +02:00
Heiko August
f436357195 Change: a further code style thingy 2019-08-08 15:50:30 +02:00
Heiko August
28059c1574 Change: add version 2.4.99.1 to the list of updatable versions 2019-08-08 15:07:34 +02:00
Heiko August
364317f65b Change: code style thingamabob 2019-08-08 15:03:27 +02:00
Heiko August
a00ba3643c Fix: column size of mlf2_tags.tag exceeded the possible index size 2019-08-08 15:01:10 +02:00
Heiko August
94ab46a3e2 Change: added index.php as file to update with version 2.4.99.2 2019-08-08 15:00:20 +02:00
Michael Loesler
f3496fc515
Contacting options (#505)
* Contacting options

- added option for user contacting (mod/admin == 0, reg. users == 1, everybody == 2)
- for details see https://github.com/ilosuna/mylittleforum/issues/465

* File list

- added changes to file list
2019-07-21 16:12:46 +02:00
Michael Loesler
5456b3076f
Fix access for reg. users (#504)
* Fix access for reg. users

- if $settings.user_area_access was set to $settings.user_area_access == 2 reg. users don't have access to the user area
- fixed if-stmt for reg. users - https://github.com/ilosuna/mylittleforum/pull/470 , https://github.com/ilosuna/mylittleforum/pull/503

* pull id

- added pull id
2019-07-20 15:29:38 +02:00
Michael Loesler
78a64d9cf1
Fix access for admins/mods (#503)
* Fix access for admins/mods

- if was set to `$settings.user_area_access == 2` admins/mods don't have access to the user area (because admin/mod are users, too)
- fixed if-stmt because admins and mods should always have access to the user area

* added update item

- added update item to file list
2019-07-20 14:59:48 +02:00
Michael Loesler
a143d5a4f6
Missing worst case scenario (#502)
- added else statement to generate an error if config file is located elsewhere
2019-07-20 14:04:08 +02:00
Michael Loesler
32dfc8ce4d
Mail copy to sender (#501)
* Mail copy to sender

- added option to send mail copy to senders email, if sender is a regisered user
- removed option to change the email during contacting (if user is registered)
- see https://github.com/ilosuna/mylittleforum/issues/238 for details
- re-formatted contact.inc.php

* pull id

- added pull id
2019-07-20 12:49:11 +02:00
Michael Loesler
090d8df5a5
Update install and update script (#500)
- Update install and update script for PHPMailer configuration
2019-07-20 10:05:59 +02:00
Michael Loesler
14bdcb9c45
PHPMailer (#498)
* PHPMailer

- added PHPMailer (https://github.com/PHPMailer/PHPMailer) as module to enable SMTP support, see https://github.com/ilosuna/mylittleforum/issues/348

* File/SQL update

- added files to update list
- added SQL property php_mailer (1 == on -> use PHPMailer, 0 == off  -> use php mail function)
2019-07-18 22:15:00 +02:00
Michael Loesler
2d2cee8fd6
Tags (#494)
* Tags

- added option to insert tags by 0 == no one, 1 == admin/mod, 2 == reg. users, or 3 == everyone
- https://mylittleforum.net/forum/index.php?id=11835
2019-07-01 22:17:50 +02:00
Michael Loesler
2eeffd10a3
SPAM warning message (#491)
* redirect user, if posting is classified as SPAM

If the posting is classified as SPAM, redirect the user to the single entry view, which contains the SPAM warning message
2019-06-16 15:25:27 +02:00
Michael Loesler
1448512a40
B8 contact (#489)
* b8 for mail check

- added option to check emails via B8
- added DB entry 'b8_mail_check' (Default: FALSE)
- replace `error_spam_suspicion` by `error_email_spam_suspicion` key
- corrected wrong key `akismet_check_registered` by `spam_check_registered`
2019-06-14 20:58:59 +02:00
rwa
8e28529bce
add alter statements for switch to innodb 2019-06-07 21:01:58 +02:00
Heiko August
cb1542037a Change: add the list of changed files for version 2.4.99.1 2019-06-01 22:37:20 +02:00
Heiko August
fae3dbfd2b
Use the full width of 4 byte for UTF-8 to store text data in the database (#478)
* Change: set utf8mb4 as charset for most textual columns during installation

Affected tables:

- mlf2_b8_wordlist
- mlf2_banlists
- mlf2_bookmarks
- mlf2_categories
- mlf2_entries
- mlf2_entries_cache
- mlf2_pages
- mlf2_tags
- mlf2_userdata
- mlf2_userdata_cache

* Change: set utf8mb4 as charset for most textual columns during update

Affected tables:

- mlf2_b8_wordlist
- mlf2_banlists
- mlf2_bookmarks
- mlf2_categories
- mlf2_entries
- mlf2_entries_cache
- mlf2_pages
- mlf2_tags
- mlf2_userdata
- mlf2_userdata_cache

* Change: ater the collation of the user_name column from utf_general_ci to the utf8mb4-version

* Change: set the charset of the database connection to utf8mb4

* Change: reformat the function connect_db, remove unused, commented code

* Change: reorganise the database queries for the last changes

Put the following changes into the block for a new version 2.4.99.1.

- new charset utf8mb4 for most of the database tables
- new setting user_area_access, replaces user_area_public

* Change: new version 2.4.99.1
2019-06-01 21:25:26 +02:00
Heiko August
7e47397b7b Make it possible to restrict the access to the users list to admins and mods (#470)
* Change: make it possible to restrict the access to the users list to admins and mods

* Fix: correct the order of setting values in the if-statement

0 is restrictest, 2 is public

* Fix: IDs have to be unique in a HTML document, remove duplication
2019-05-13 12:47:12 +02:00
Heiko August
e3ed30c5ec Fix: remove datasets from INSERT that are introduced with prior versions 2019-02-11 22:09:54 +01:00
Heiko August
71da3517d5 Change: add uploads management table to the update script 2019-02-10 20:57:32 +01:00
Heiko August
1caa253ca6 Change: correct a few formatting issues 2019-02-10 20:32:49 +01:00
Heiko August
da0701ff09 Change: set the new table names for the first feature, the bayes filter 2019-02-10 20:31:40 +01:00
Heiko August
d9e745b832 Change: set new starting point, we'll begin with version 2.4.19.1 2019-02-10 20:30:32 +01:00
Heiko August
9aa9c20068 Change: remove outdated code from the 2.3.5-to-2.4-update-script 2019-02-08 14:43:56 +01:00
Heiko August
c946faf9a5 Change: add update steps from 2.4.14 to 2.4.19.1 and disable-enable-forum-code 2019-02-08 14:43:09 +01:00
Heiko August
be7b57eabf Change: remove the list of files to update for not supported versions 2019-02-08 14:29:40 +01:00
Heiko August
39ed7c0114 Change: let's start with the current version 2.4.19.1 with the update script to 2.5
There was to many versions (13) inbetween. Beginning with the current version seems to be a clean starting point.
2019-02-08 14:26:00 +01:00
Heiko August
9962a12f18 Change: add list of files to update for all versions since 2.4.8 2019-02-08 14:22:43 +01:00
Heiko August
fc24f674b2 Change: small code style thingamabobs 2019-02-08 13:56:47 +01:00