0ct0pu5/mylittleforum
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
1556 commits 3 branches 61 tags 11 MiB
Commit graph

126 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
45cffb033e Fix: add forgotten section names when using language strings 2024-07-28 20:18:30 +00:00
Heiko August
8e30344e5e Change: mark the radio button of the (pre)-selected language entry as checked 2024-07-28 20:18:30 +00:00
Heiko August
f20ac777dd Change: remove the commented and unused code for inserting the password on page reload 2024-07-28 20:18:30 +00:00
Heiko August
c1177a2254 Change: use the already existing info about the writing direction in the HTML-template 2024-07-28 20:18:30 +00:00
Heiko August
3aa741204a Fix: correct a small formatting issue 2024-07-28 20:18:30 +00:00
Heiko August
97854ff6bb Change: add the section names when using language strings 2024-07-28 20:18:30 +00:00
Heiko August
c1137cd61b Change: read the language file with the function my_parse_ini_file 2024-07-28 20:18:30 +00:00
Heiko August
2d3f50019a Change: add the function my_parse_ini_file to improve language string reading 
Function is based on a user note in the PHP manual page for parse_ini_string.
https://www.php.net/manual/de/function.parse-ini-string.php#111845
 2024-07-28 20:18:30 +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
Prashant Tondale
75e1d87cad Update index.php 
Add closing round brace
 2022-05-09 14:47:26 +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
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