Commit graph

98 commits

Author SHA1 Message Date
Heiko August
df3399c1a8 Fix: add definition of primary key for mlf2_banlists in the installation script 2024-07-31 14:49:41 +00:00
Heiko August
a2fc79e3c4 Change: change charset to utf8mb4 and collation to utf8mb4_bin for the uploads table 2024-03-18 20:22:23 +01:00
Heiko August
47605d44c7 Change: add the charset and collation changes also to the installation script
This affects the tables mlf2_entry_tags and mlf2_bookmark_tags.
2024-03-18 20:22:23 +01:00
Heiko August
deba37269d Change: set the size of mlf2_b8_wordlist.token back to 255 bytes as it was initially when introducing B8 2024-03-18 20:22:23 +01:00
Heiko August
913484bac8 Change: remove the special case of charset utf8(mb3) for the column mlf2_userdata.user_email 2024-03-18 20:22:23 +01:00
Heiko August
24df928fea Change: set the charset to utf8mb4 and the collation to utf8mb4_bin in the new tables while creating them
… and add the keys in mlf2_b8_rating when creating the table and not afterwards.
2024-03-18 20:22:23 +01:00
Heiko August
56a6f5447b Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the user online table 2024-03-18 20:22:23 +01:00
Heiko August
2a227e7f43 Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the temporary information table 2024-03-18 20:22:23 +01:00
Heiko August
26fa69a945 Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the subscriptions table 2024-03-18 20:22:23 +01:00
Heiko August
aa0b84786c Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the smilies table 2024-03-18 20:22:23 +01:00
Heiko August
a8ca416948 Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the read entries table 2024-03-18 20:22:23 +01:00
Heiko August
9470172f6a Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the logincontrol table 2024-03-18 20:22:23 +01:00
Heiko August
07ade7a701 Change: alter the charset to utf8mb4 and the collation to utf8mb4_bin in the settings table 2024-03-18 20:22:23 +01:00
Heiko August
a39605d7da Change: restrict the size of the column mlf2_logincontrol.ip to 128 bytes
This corresponds to the size of the corresponding columns in the other tables.
2024-03-10 21:58:32 +01:00
Heiko August
368c45bcb6 Fix: enlarge the column mlf2_useronline.ip from 15 to to 128 bytes in the installation code
The column size of 15 bytes was enough to store IPv4 but not to store IPv6 addresses. Additionally change the column type from char to varchar.
2024-03-10 21:58:32 +01:00
Michael Lösler
43471266b3
Bad Behavior (#672)
- remove outdated module "Bad Behavior"
- https://mylittleforum.net/forum/index.php?id=10734
2023-03-18 16:35:04 +01:00
Michael Lösler
069562f5b2
Mathjax (#637)
* Update MathJax

- MathJax updated to version 3
- Loading of mathjax resources prevented, if unnecessary (e.g. at main page)

* CDN

- CDN to recommended one changed, cf. https://docs.mathjax.org/en/latest/web/start.html
2022-08-09 17:48:33 +02:00
Heiko August
70228e81b4 Fix: remove UNIQUE from the column definitions for user_name and user_email
The uniqueness of these columns is ensured by the key definitions at the end of the query.
2022-08-02 22:49:42 +02:00
Heiko August
a98043099e Fix: remove column email_notification from create table statement 2022-06-02 09:57:30 +02:00
Heiko August
6de0bfcd14 Fix: define the column user_email with character set utf8 (without mb4)
This prevents the matching index key_user_email to exceed the maximal size of an index on MySQL-server with a version below 5.7.
2022-05-15 21:14:41 +02:00
Heiko August
ab3274b57d Fix: add a forgotten closing bracket to the query
see #601 for the details, thanks to @prbt2016 for the report
2022-05-15 21:14:41 +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
3e62ff55be Change: make key_user_name UNIQUE as in the update script
See update_2.4.19.1-2.5.php, block for update up to 2.4.99.3, ALTER TABLE mlf2_userdata
2022-05-08 18:07:13 +02:00
Michael Lösler
b0eb5e2381
Key (#592)
- corrected key as suggested by @auge8472
2022-04-29 16:53:16 +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
20537f01ba Change: add new setting 'link_open_target' to the install 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
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
e3d94da3e8 Fix: limit the column size of mlf2_tags.tag to a length of 128 chars
This is because of the limited index size. Analogue to the change in the update script.
2019-08-08 15:04:05 +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
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
0f96bcc87b
set innodb as default engine 2019-06-07 20:53:55 +02:00
rwa
eac21c75a3
set default collation for mlf_b8_wordlist 2019-06-05 19:45:10 +02:00
rwa
7015078967
fix creation of wordlist table 2019-06-05 19:38:10 +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
caaf050a70 Change: provide a list of columns to fill for the placeholder admin
The working with only the values caused erros in case of a changing table structure again and again. Nothing one want's to run in.
2019-02-11 14:22:25 +01:00
Heiko August
d949320841 Fix: once again, backticks in table name prevents script from replacing the table name prefix 2019-02-11 12:12:20 +01:00
Heiko August
a93f2bfe0d Fix: use backticks to enclose column names, not apostrophes 2019-02-03 22:58:40 +01:00
Heiko August
ad7a4be945 Bugfix: remove backticks around table names, causes break of table name prefix replacement 2019-01-30 22:05:25 +01:00
Heiko August
cd66dabdbf Change: add the create query for the new table mlf2_uploads 2019-01-30 21:42:38 +01:00
Heiko August
327b03e374 Change: installation queries for moved settings 2019-01-28 13:15:49 +01:00
Heiko August
43eb42f688
Fix: user_id must accept NULL values from unregistered users, index has to be UNIQUE to allow that (#444) 2019-01-13 13:09:27 +01:00
Michael Loesler
675cb6548e
Password strength (#438)
* Measuring password strength

- added options to validate password strength during registration
- number of digits (default: 0)
- number of lowercase letters (default: 0)
- number of uppercase letters (default: 0)
- number of special characters (default: 0)

* Measuring password strength

- added options to validate password strength during user changing password
2019-01-01 18:23:56 +01:00
Michael Loesler
c28c12a88c
Bayes-based spam filter (#427)
- add B8 libary for SPAM protection
- add CSRF Token to form element
- created new table `akismet_rating`
- transfered `spam` and `spam_check_status` from entry table
- removed columns `spam` and `spam_check_status` as they are akismet specific columns from entry - - created b8 tables `b8_rating` and `b8_wordlist_table`
- changed SQL statements, which used the (old) `spam` column
- updated install-script
- changed phrases and flag someone for delete
- add B8 configuration to admin area
- clean code
- removed spam columns from backup procedure
- new tables are *NOT* included to the backup procedure because I prefer to remove this function
- added error message for wrong SQLs
- https://github.com/ilosuna/mylittleforum/issues/426
2018-12-19 20:54:01 +01:00
Michael Loesler
ef2315df34
Timespan for form completion (#413)
* Timespan for form completion

- observe timespan for form completion and show an error, if the timespan is below a suitable threshold
- remove hard coded thresholds
- add new database entries for tuning threshold values
- default values: min = 5 sec and max = 10800 sec
- remove "credit time" for uncomplete filled forms
2018-12-10 20:06:14 +01:00
Heiko August
29cd188b8b
add unsubscribing function for messages about replies (#399)
* Change: add a link to unsubscribe from the e-mails informing about replies to a specific own entry
* Change: processing subscription quitting, code, text and subtemplate
* Change: add a new table for the handling of subscriptions
* Change: remove subscription flag from antres table, set it in subscriptions table instead
* Change: rename the entry-id and the UUID-column, add a timestamp
* Change: remove the GET-parameter checker, is unnecessary
* Change: add query to delete the row of the subscription from the database table
* Change: rebuild the function emailNotification2ParentAuthor
2018-11-17 12:48:48 +01:00