Commit graph

437 commits

Author SHA1 Message Date
Heiko August
3151626297 Fix: comparison of posting time and registration time was the wrong way round (> versus <) 2024-12-13 17:55:46 +01:00
Heiko August
54cfd3ae3e Change: provide only a Unix timestamp and let MySQL do the datetime magic
This makes it unnecessary to add an additional test for $posting_time being a proper formatted datetime value.
2024-12-13 17:55:46 +01:00
Heiko August
94eb3d8db8 Change: add a second clause in where to take into account the date of the posting in the check for a user name collision 2024-12-13 17:55:46 +01:00
Heiko August
c238f822bb Change: generate $posting_time with the current time for a new and initial saving time of a posting for an edited posting 2024-12-13 17:55:46 +01:00
Heiko August
a0da7ed990 Change: replace the partially JS generated steering elements for viewing a present avatar with form buttons 2024-12-10 21:01:55 +01:00
Michael Lösler
a30281839a
User id (#771)
- check whether the user id is present in the session array to avoid incomplete queries
- add mysqli_real_escape_string for security reasons
- details: https://mylittleforum.net/forum/index.php?id=18760
2024-12-01 11:07:49 +01:00
Heiko August
3c5992e26d
Make WebP images appear in the uploaded-images browsing view (#769)
* Fix: add webp and svg to file types and collect all file types in one regex

* Change: allow file ending .jpeg also in the uploads listing of the admin area
2024-11-27 22:41:11 +01:00
Michael Lösler
7c578c3c7a
File filter (#768)
- WEBP file extension added, cf. #766
2024-11-27 21:45:15 +01:00
Michael Lösler
cfde25b39e
ISO-timestamps (#767)
According to #758, #761 timestamps should be formatted by HTML time elements, but entry date and edit date are still not formatted correctly. Time element is added to thread-view and linear thread-view as well as table-view.
2024-11-27 21:34:16 +01:00
Michael Lösler
3b54474b2a
Code cleaning (#765)
- redundant code parts reduced
2024-11-26 23:03:09 +01:00
Michael Lösler
1fd5a0aec4
Scope of statement (#764)
- Change scope of ‘$pid_result_sql’ statement to be available in conditions
2024-11-26 17:44:07 +01:00
Michael Lösler
ef576dba70
eid vs. id in SQL stmt (#763)
- SQL statement corrected as reported and analysed by https://mylittleforum.net/forum/index.php?id=18724 , i.e. `eid` vs. `id`
- To avoid side effects with entry.inc.php, where `$spam_sql_and` is also used, the column `eid` is renamed in the stmt by `id`
2024-11-26 10:25:11 +01:00
Michael Lösler
f0063b73ea
ISO-timestamps (#761)
According to #758, timestamps should be formatted by HTML time elements, but entry date and edit date are still not formatted correctly
2024-11-24 13:33:23 +01:00
Heiko August
fa89d768f2 Fix: add the time element and the ISO-formatted timestamp to the flag ham page 2024-11-19 22:09:00 +01:00
Heiko August
6d9ab8d3f5 Fix: add the ISO-formatted timestamp to the time element in the report spam page 2024-11-19 22:09:00 +01:00
Michael Lösler
3c61d31bc5
Existing username (#751)
- exclude the check for existing usernames when the admin/mod edits the post
- https://github.com/My-Little-Forum/mylittleforum/issues/750
2024-10-25 20:28:52 +02:00
Heiko August
02c46a2f23 Change: add element time for the posting time and provide the machine readable timestamp 2024-09-29 13:02:35 +00:00
Heiko August
7b38751024 Fix: add last_reply to the select to be able to order the result by that column 2024-08-07 13:53:53 +00:00
Heiko August
764de49b2f Fix: alter all URLs to the old repository to link to the new one 2024-08-04 11:58:44 +00:00
Heiko August
4f2142ace3 Fix: deduplicate banlists before saving the lists in the database 2024-07-29 20:55:24 +00:00
Heiko August
7dfed8930e Fix: remove trailing tabs at the end of the line 2024-07-28 20:19:15 +00:00
Heiko August
5ebdeeaa60 Fix: columns, that are used in ORDER BY must be selected before
This is at least the case on my DB-server. It might be an issue of the server configuration an may be handled not so strict on other servers.
2024-07-28 20:19:15 +00:00
Heiko August
7fe251e951 Fix: correct typo in comment 2024-06-29 12:35:47 +02:00
Michael Lösler
571a5e2b5e
Clean code (#718)
- code redundancy reduced
2024-05-30 08:39:04 +02:00
Michael Lösler
76f407d1db
Include user name (#717)
- user name of _registered_ users added to query
- #716
2024-05-29 19:39:30 +02:00
joeiacoponi1
153abc3c4c
SQL & php Spam performance changes for 20240308.1 (#713)
undefined
2024-04-24 15:34:04 +02:00
Heiko August
b135914737 Change: add a second regex for checking for valid hex colour codes 2024-03-31 15:10:07 +02:00
Heiko August
470893a15c Cleanup: remove outdated and commented code 2024-03-31 15:10:07 +02:00
Heiko August
af1aef0ec1 Change: refactoring of the HTML-output-part of the function raise_error 2024-03-31 15:10:07 +02:00
Heiko August
645165adab Change: reformattion of the function get_themes 2024-03-31 15:10:07 +02:00
Heiko August
6e53618816 Change: reformattion of the function get_languages 2024-03-31 15:10:07 +02:00
Heiko August
bc94ca4c66 Change: reformattion of the function get_timezones 2024-03-31 15:10:07 +02:00
Heiko August
9f63a7c568 Change: reformatting of the function get_not_accepted_words 2024-03-31 15:10:07 +02:00
Heiko August
dc562998b3 Change: reformatting of the function is_ip_banned 2024-03-31 15:10:07 +02:00
Heiko August
249c81914b Change: reformatting of the function move_item 2024-03-31 15:10:07 +02:00
Heiko August
e8553ee7bf Change: fix a few formatting issues in the function is_valid_birthday 2024-03-31 15:10:07 +02:00
Heiko August
dbc2a73fb9 Change: reformatting of the function is_user_agent_banned 2024-03-31 15:10:07 +02:00
Heiko August
f7a0ebdf2a Change: solve a few small code style issues 2024-03-31 15:10:07 +02:00
Heiko August
9b745142ac Change: reformatting of the function my_mb_encode_mimeheader 2024-03-31 15:10:07 +02:00
Heiko August
228e802c78 Change: reformatting of the function mail_header_filter 2024-03-31 15:10:07 +02:00
Heiko August
1ab386dffd Change: reformatting of the function encode_mail_name 2024-03-31 15:10:07 +02:00
Heiko August
92af6b0360 Change: reformatting of the function my_strpos 2024-03-31 15:10:07 +02:00
Heiko August
de94e8bacb Change: reformatting of the function my_substr 2024-03-31 15:10:07 +02:00
Heiko August
f0630ddc4c Change: reformatting of the function my_strtolower 2024-03-31 15:10:07 +02:00
Heiko August
f7e8726d8b Change: reformatting of the function my_strlen 2024-03-31 15:10:07 +02:00
Heiko August
6080ed7d35 Change: reformatting of the function add_http_if_no_protocol 2024-03-31 15:10:07 +02:00
Heiko August
683aa02a23 Change: reformatting of the function is_pw_correct 2024-03-31 15:10:07 +02:00
Heiko August
33e169dcdc Change: reformatting of the function generate_pw_hash 2024-03-31 15:10:07 +02:00
Heiko August
ae9d6873a6 Change: reformatting of the function random_string 2024-03-31 15:10:07 +02:00
Heiko August
1b9f8a66b7 Change: reformatting of the function check_filename 2024-03-31 15:10:07 +02:00