Commit graph

96 commits

Author SHA1 Message Date
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
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
Michael Lösler
b0eb5e2381
Key (#592)
- corrected key as suggested by @auge8472
2022-04-29 16:53:16 +02:00
Michael Lösler
fa5fa08746
Installation routine (#591)
- set `error_reporting = 0` for smarty because this function depends on the php function `error_reporting()`
- check `$db_settings['database']` as suggested by @auge8472 cf. https://mylittleforum.net/forum/index.php?id=12699
- call `mysqli_select_db` function removed
2022-04-29 16:49:55 +02:00
Michael Lösler
13924604fd
get_magic_quotes_gpc removed (#590)
- get_magic_quotes_gpc removed because this function returns alwas false
- get_magic_quotes_gpc is deprecated cf. https://www.php.net/manual/en/function.get-magic-quotes-gpc.php
- see also #552, #553
2022-04-29 16:10:47 +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
a402ef3ebc Fix: wrong button name in the install script, prevents the installation from running 2019-02-11 12:11:20 +01:00
Heiko August
9a06fb2836 Fix: provide a column list to prevent the query to break
Number of values to store differs from number of columns in the table.
2019-02-03 22:58:40 +01:00
Heiko August
a93f2bfe0d Fix: use backticks to enclose column names, not apostrophes 2019-02-03 22:58:40 +01:00
Heiko August
e63149cf1e Change: reformat the code of the installation script 2019-02-01 12:27:16 +01:00
Heiko August
540d2f44a0 Change: new HTML5-based user interface for the installation script 2019-02-01 12:27:16 +01:00
Heiko August
6983018fb3 Change: new HTML head section for the installation script 2019-02-01 12:27:16 +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
c420390255 Change: add new table mlf2_uploads to the installation script and the database settings script 2019-01-30 21:46:55 +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
36b3f5e9b9 Change: move setting version to table mlf2_temp_infos 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
Michael Loesler
1615ee4a0a
Flash button (#390)
* Removing flash

- removing the option "FLASH" button
- https://github.com/ilosuna/mylittleforum/issues/376

* Change update script

- add changes to update script
- VERSION array is not correct!!!

* Correction id

- correcting id to #390
2018-07-16 23:15:56 +02:00
Heiko August
0cf2ac96ab
Merge branch 'master' into gdpr 2018-06-07 18:44:28 +02:00
Heiko August
552b90bd41 Fix: resolve merge conflict because of new LaTeX-formula-rendering (see aeb9afda34) 2018-06-04 22:27:34 +02:00
Michael Loesler
2ef12d742a
Tex (#377)
- removed external chart service support for tex
- added MathJax javascript support
- see https://mylittleforum.net/forum/index.php?id=10721
2018-05-18 19:20:17 +02:00
Heiko August
35be9dfbd7 Change: add timestamp fields for terms of use and data privacy statement to the userdata table 2018-05-08 19:22:03 +02:00
Heiko August
7add15bf26 Change: add settings for an explicit data privacy statement 2018-05-01 22:48:10 +02:00
Heiko August
88023e95e2 Change: new settings uploads_per_page to the install, update and admin scripts 2018-03-29 15:17:37 +02:00
Heiko August
30103ea25c
Fix: remove column "tags" from the create statement for table mlf2_entries (#346) 2018-02-18 20:04:03 +01:00
Micha
cd401caf42
Change TAG handling (#297)
* Remove phrase in lang files

- Remove TAG-phrase 'error_bookmark_tags_too_long'
- was added by https://github.com/ilosuna/mylittleforum/pull/287

* Add tables

- tags_table for tag values
- bookmark_tags_table for connection between tags and bookmarks

* Change install/update script

- Add new tables
- Suggestion for transfering old tags from postings to new tag table

* Add tags to bookmark

- adapt SQLs for new TAG-table

* SQL korrigiert

- Klammerausdruck korrigiert

* LEFT-Join

- Correcting SQL JOIN vs. LEFT JOIN
- Replace function call

* Replace Functions

- add/replace functions for TAG handling

* TAGS for postings

- Add Tags for postings

* Add new table

- add binding table for tags and postings

* - Change TAG handling

- search function
- posting
- thread view
- update script
- install script

* Limiting number of Tags

- set tag limit to 10 for bookmarks
- add error message

* Remove BTREE

- reomve USING BTREE clausel as suggested by @auge8472

* Remove BTREE

- remove USING BTREE as suggested by @auge8472
- add new table entry_tags_table

* Remove variable

- remove variable $tagStr

* Remove first tab

- clean up file

* Add InnoDB

- Add ENGINE=InnoDB to new tables

* Add table names

- add table names to install script

* add updated files

- add updated files of issue #297

* add AUTO_INCREMENT

- add AUTO_INCREMENT to 'tags_table' definition

* Correcting table name / check for prior errors

- correct tabel name of entry_tags_table
- check empty property of error-array
- add error message, if b_settings.php is unwriteable

* Store posting tags

- add new sql to store the posting tags in entry_tags table
2017-12-12 22:53:37 +01:00
Micha
c5ab0b7314
Bookmarktags (#287)
* Tags for Bookmarks

- add tags for user-defined bookmarks
- https://github.com/ilosuna/mylittleforum/issues/254

* Update/Install instructions

- update install and update scripts

* Add GH-IDs

- add GitHub ids

* Remove isset

- remove isset() because it is checked above
2017-11-20 16:03:39 +01:00
Micha
e3c0df31af
Remove entries_read column (#285)
- Removing column entries_read from userdata-table
- https://github.com/ilosuna/mylittleforum/issues/284
2017-11-11 12:48:01 +01:00