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