Commit graph

67 commits

Author SHA1 Message Date
Heiko August
ad40232432
Merge branch 'voting-feature' into legacy_2.4 2023-01-22 21:08:57 +01:00
Heiko August
460fc7243a Fix: fix for fix, column 'email_notification' does not exist since 2.4.14 but references was not removed everywhere 2020-09-22 22:23:49 +02:00
Florian Caspar
143d2fc2a8 SQL install/update corrected 2020-01-02 01:42:13 +01:00
Heiko August
7385c95571 Fix: provide a column list because we want to fill only these two columns 2019-02-03 21:16:35 +01:00
Heiko August
a6bca1fa21 Fix: let's also use here backticks instead apostrophes for column names 2019-02-03 19:48:18 +01:00
Heiko August
0a3e109dd2 Change: installation queries for moved settings 2019-02-03 13:04:15 +01:00
Heiko August
da6746fdbf Change: move setting version to table mlf2_temp_infos 2019-02-03 13:03:22 +01:00
Heiko August
9befe111c0 Fix: backticks around table name made prefix replacement during installation impossible 2019-01-14 09:10:33 +01:00
Heiko August
b96244bfaa Change: add queries for subscription handling for installation and update to 2.4.18 2019-01-13 18:23:03 +01:00
Heiko August
a6ded1dc9e Change: add code to enforce minimal count of chars from character classes in a password (PR: #438, #439, author: @loesler) 2019-01-02 22:42:17 +01:00
Heiko August
1e64282ca0 Change: Timespan for form completion (#413) 2019-01-02 21:01:29 +01:00
Heiko August
e7d12e1c6b Fix: remove backticks from table name, script is not able to replace the table prefix with them 2018-11-26 22:08:06 +01:00
Heiko August
8ab31523b2 Fix: remove hyperfluid semicolon, caused parsing error 2018-11-26 22:07:13 +01:00
Heiko August
a374791642 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-22 22:50:32 +01:00
Heiko August
9410559074 Fix: add the agreements columns when creating the default account during the installation 2018-06-13 21:06:17 +02:00
Heiko August
52d66468be Change: add timestamp fields for terms of use and data privacy statement to the userdata table 2018-06-10 18:11:15 +02:00
Heiko August
7942b6c783 Change: add settings for an explicit data privacy statement, resolve conflict 2018-06-10 18:07:24 +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
Heiko August
b2a66abba7 Handling of the read state reset methods and values (#233)
* Change: use new settings for handling of read state
* Change: add new setings to the SQL-files for update and installation
* Change: queries for new settings and removal of outdated settings to the update script
* Change: remove outdated setting from the SQL file for installation
* Change: new form elements and language strings for read status handling
* Fix: add a check for non exisiting setting reset_read_state
* Fix: wrong name of setting in the form elements
* Change: ensure a valid value for the read state reset method
* Fix: correct wrong name for form field and hardcoded value
2017-05-24 15:04:06 +02:00
Heiko August
c680a768b5 change collation for mlf2_userdata.user name to utf8_bin (#227)
* Fix: set collation of "user_name" to utf8_bin to distinguish i.e. between "a" and "ä"
* Fix: change collation for user name to utf8_bin also in the update process
* Change: reorder the list of queries to the correct order
* Change: clarify the description of instructions
2017-05-14 13:48:51 +02:00
Heiko August
5322d1bc06 pre-populate the field for forum-URL with the correct protocol string (#208)
* Change: new function get isProtocolHTTPS
* Change: use the function to distinguish between a request over HTTP or HTTPS

If a forum will be installed over HTTPS, the pre-populated form field for the forum URL should reflect this.
2017-04-24 16:12:26 +02:00
Heiko August
ec70486b46 Add further indices to speed up the queries … (#192)
* Change: add indices to the entries table, speeds up the query execution
* Change: add indices to the read status table, speeds up the query execution
* Change: further index for column last_reply
* Change: additional indices for user data table
2017-03-31 16:50:53 +02:00
Heiko August
fad5db214c Fix: create PK for settings table also when installing (#180)
fixes #179
2017-03-02 16:47:14 +01:00
Heiko August
fef88d86da Fix: use dirty die instead wrong break (#162)
fixes #158
2017-02-05 12:29:48 +01:00
Heiko August
62f02ca31d Add the table and a further box in the admin area (#124)
* Change: new table mlf2_temp_infos
* Change: add a box to show the version number of the installed version
* Change: load version info only during daily actions
* Change: simplified release info
* Fix: text change in every language except the base language?!
* Fix: remove superfluous and in some cases script breaking query

close #123
2016-12-04 15:32:34 +01:00
Heiko August
6b2602fe06 Change: alter settings table and rewrite the settings (#120)
* Change: alter settings table and rewrite the settings
* Change: tread a simpler path than with the temporary array. Renaming the old and creating a new table with a following INSERT is much more simple.
* Fix: remove the code for deleting the (doubled) setting auto_lock_old_threads
* Fix: add ON DUPLICATE KEY UPDATE to avoid multiple inserts. During the development it's expectable, that an update occurs several times. It would fail in this line because of the new primary key.
* Change: new tables should be of type InnoDB
* Change: a few comments and a bit cosmetic

this fixes #99
2016-12-02 12:01:38 +01:00
Heiko August
c66b6576dc Fix: remove doubled entry auto_lock_old_threads (#100)
fixes #98
2016-11-23 20:07:43 +01:00
Heiko August
afccebc1cc Fix: again, don't use testing code (#94)
fixes #92
2016-11-21 18:16:28 +01:00
Heiko August
b98140a882 Fix: syntax error (comma and semicolon) (#89)
add a comma, remove a semicolon
2016-11-20 23:09:11 +01:00
Micha
9f88e86898 Remove read state (#82)
- add new parameter to setting_table called 'read_state_expiration_date'
(default 150 days)
- remove read state if 'auto_lock_old_threads' > 0
- remove read state if 'read_state_expiration_date' > 0
2016-11-18 23:08:39 +01:00
Micha
9e75d0397a Remove read status of entries on delete (#76)
* Remove read status of entries on delete

- remove "read status" on user delete
- remove "read status" on posting delete

* Primary key

- Remove unique definition and add primary key "read_status_table"
2016-11-16 22:50:21 +01:00
Heiko August
1519b0091d Fix: don't add column id (PK, Auto Increment) when read_per_user is an unique index (#79) 2016-11-16 19:50:05 +01:00
Heiko August
d680aa4757 Create read-status-table (#74)
* Change: new table mlf2_read_entries
* Fix: forgot to add the assembling of the table name in update script
* Change: add column time to store the last request for an entry
* Fix: rename column 'e_id' to 'posting_id' for consistency

fixes #71
2016-11-14 10:56:04 +01:00
Heiko August
6627539a28 version check from file (#66)
* Change: read new version number from file in case of an update

* Fix: put the version checks into a block, that will only be executed in absence of an error

* Fix: stop update even with equal version numbers of current installation and update version

* Fix: compare the current version with the array of allowed version numbers, not with version number of the update

* Change: replace $update['version'] with $newVersion

It's not part of the given data and will be read from the file VERSION.
Thatswhy it is now a separated variable.

* Change: use the file VERSION to get the version number

* Fix: relative path must be given from the requested script, not the included one
2016-11-06 13:36:04 +01:00
Micha
ca4a8b5867 Overwrite db_settings array (#61)
- override db_settings_array to fix issue
https://github.com/ilosuna/mylittleforum/issues/60
2016-10-26 22:26:55 +02:00
Micha
af1694743b Fix command execution issue (#52), fixes #51
* Fix command execution issue

- Check for HTML tags
- add slashes

* Add warning message

- a warning message is displayed in admin area, if install/index.php
still exists (https://github.com/ilosuna/mylittleforum/issues/51)

* Use new admin-info-box

- use new admin info boy to display warning message
2016-10-25 14:52:40 +02:00
Micha
a21b131642 prevent 404 error (#49)
- Add path to favicon of the default template to prevent a 404 error
2016-10-16 13:49:04 +02:00
Micha
41bc27e273 Add Bookmark table (#46)
Add bookmark table to install-script
2016-10-14 19:40:56 +02:00
Micha
5c736336c4 Bookmark, JavaScript and CSS, Preview window (#39)
* Bookmark

Add bookmark function to single postings

* Multiple changes

- Add bookmark function, cf.
https://github.com/ilosuna/mylittleforum/issues/38
- Show preview window on hover, if desired(!): set ajax_preview=2, cf.
https://github.com/ilosuna/mylittleforum/pull/37
- Replacing of inline-style elements in JS code by CSS classes, cf.
https://github.com/ilosuna/mylittleforum/pull/18 and
https://github.com/ilosuna/mylittleforum/issues/16

* Update db_settings.php

* Add phrases

Add content for issue https://github.com/ilosuna/mylittleforum/issues/32

* bubble-icon behavior

- Disable bubble-icon if posting is empty
https://github.com/ilosuna/mylittleforum/issues/40
- Add CSS issue https://github.com/ilosuna/mylittleforum/pull/41
2016-10-13 18:29:35 +02:00
Heiko August
1a3140f1f8 Change: add update and install routines for version 2.3.7 (#26)
fixes #26
2016-10-04 19:41:40 +02:00
Heiko August
ae29e0fca1 Change: update update script, new version strings 2016-08-04 21:09:59 +02:00
Heiko August
aa246404de Fix: error in cornercase of failure while connectiong to database server
The script can't use the connection identifier to report it's absence. Use the correct function for this case.
2016-06-23 10:49:40 +02:00
Heiko August
dc60c18780 Fix: field last_login can now store NULL values
When a user should be registered, she/he was (in that moment) never logged in. Thatswhy the field last_login should stay empty (NULL) what was forbiddeen by the old table definition.
fixes ilosuna/mylittleforum#1
2016-06-22 13:03:10 +02:00
Alex
23e0c4d353 PHP 7 modifications (e.g. replace mysql_* by mysqli_* functions) 2016-05-31 14:08:09 +02:00
Alex
7eb9702031 Sticky thread fix, iOS JS fix, template and translation fixes (http://mylittleforum.net/forum/index.php?id=8512) 2016-03-13 17:49:28 +01:00
Alex
b814a956cb Update version info, install SQL schema and update script 2015-02-08 11:23:11 +01:00
Alex
7deea2a545 bugfix in posting.inc.php 2014-03-13 21:57:51 +01:00