Commit graph

46 commits

Author SHA1 Message Date
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
Alex
6ca4006171 language bug fix, theme switch bug fix, Smarty updated, Bad Behavior updated, Swedish language file added 2013-11-23 16:56:36 +01:00
Alex
90deb8fd98 implemented Stop Forum Spam 2012-11-25 16:58:35 +01:00
Alex
c08afa1687 JavaScript fix ( http://mylittleforum.net/forum/index.php?id=6718 ), Smarty updated, Bad Behavior updated, GeSHi updated, set default time zone to UTC 2012-11-21 10:33:22 +01:00
Alex
f93200f736 added admin options to user profile page, added akismet check of registered users 2011-06-17 21:19:17 +02:00
Alex
4a1d57c5fa Smarty updated to version 3.0.8 2011-06-10 10:35:50 +02:00
Alex
52fc96477a Smarty, Bad Behavior and GeSHi updated 2011-03-11 17:22:33 -03:00
Alex
ff590a40c9 Timestamp exclusively fetched from database now, minor template modifications 2011-02-13 10:52:06 -03:00
Alex
9e2811ca2f minor CSS and JavaScript modifications 2010-10-25 16:52:09 -03:00
Alex
3703dd8c6c minor template bug fixed; rss feed uses cached entry data now 2010-07-08 10:19:48 -03:00
Alex
d2f81286df Template bug fixed 2010-06-21 11:56:11 +02:00
Alex
e375f60b6e Template bugfix (user_postings.inc.tpl) 2010-06-10 21:11:15 +02:00
Alex
e686f76d0b Mail header separator changed from "\r\n" to "\n" 2010-05-28 15:56:21 +02:00
Alex
78495dc877 Bugfix: JS error if not logged in and forum is accessible by registered users only 2010-05-24 19:59:44 +02:00
Alex
55cefb91ff Minor JavaScript improvements, Russian language file updated 2010-05-20 15:07:41 +02:00
Alex
3148716db1 initial commit 2010-03-14 11:37:06 +01:00
Alex
57cf8fe3a4 E-mail encoding, user data check, CAPTCHA, colorpicker, marking new threads/replies, language files
- Improved quoted-printable encoding for e-mails
- Skiped user data check of registered users when posting (is already done when
  registering or editing user data)
- Bugfix: graphical CAPTCHA was not displayed if cookies were disabled
- Colorpicker: fixed wrong path to plain.png
- Improved marking of new threads and replies
- Names of language files can contain language tags now (e.g.
  english.en-GB.lang)
- Language files updated
2010-02-06 21:18:29 +01:00
Alex
f527c6e938 initial commit 2010-01-31 13:39:34 +01:00