Age | Commit message (Collapse) | Author | Files | Lines | |
---|---|---|---|---|---|
2021-07-01 | Add category system to categorize posts (readme) | Thomas Lange | 33 | -12/+1211 | |
This commit implements a new category system to categorize posts. Each category can have an unlimited number of nested children categories. A single post don't necessarily need to be in a category, but it can. Each category can have a full content body like posts or pages, so you have enough space to describe the content of your categories. Please note that you need to have at least the following MySQL/MariaDB versions to use the category system, because it uses "WITH RECURSIVE" database queries, the so-called "Common-Table-Expressions (CTE)". MariaDB: 10.2.2 MySQL: 8.0 See: https://mariadb.com/kb/en/with/ See: https://dev.mysql.com/doc/refman/8.0/en/with.html | |||||
2021-07-01 | Update database schema for coming category system | Thomas Lange | 3 | -2/+51 | |
This commit updates the database schema and adds a new migration for the upcoming category system. Please note that you need to have at least the following MySQL/MariaDB versions to use the category system later: MariaDB: 10.2.2 MySQL: 8.0 | |||||
2021-07-01 | Bugfix: Explicitly check for FALSE in Migrator | Thomas Lange | 1 | -1/+2 | |
Explicitly check for boolean FALSE because the result can be string "0" when directly upgrading from release v1.0 which has schema version "0". | |||||
2021-07-01 | Add translations for upcoming category system | Thomas Lange | 6 | -3/+53 | |
2021-07-01 | Update database schema: Make id columns unsigned | Thomas Lange | 3 | -7/+20 | |
This commit updates the database schema and adds a new migration to modify the signed integer columns to make them unsigned. | |||||
2021-07-01 | Redirect to entity create form if no entity exists | Thomas Lange | 3 | -0/+21 | |
2021-07-01 | Add PHP version check | Thomas Lange | 1 | -0/+7 | |
2021-06-30 | Optimize core/db/database.sql | Thomas Lange | 1 | -38/+34 | |
2021-06-29 | Add WHERE filter option to getCount method | Thomas Lange | 1 | -4/+23 | |
2021-06-28 | Bugfix: Remove explicit parameter type int | Thomas Lange | 1 | -3/+3 | |
2021-06-28 | Update Fontello for default theme | Thomas Lange | 8 | -96/+983 | |
2021-06-27 | Allow NULL value comparison in WHERE clause | Thomas Lange | 1 | -2/+6 | |
2021-06-26 | Use shorthand ternary operator in admin forms | Thomas Lange | 3 | -3/+3 | |
2021-06-26 | Use const to define expressionless admin constants | Thomas Lange | 17 | -33/+33 | |
2021-06-26 | Use shorthand ternary operator | Thomas Lange | 6 | -28/+28 | |
2021-06-26 | Fix bug in user select form field | Thomas Lange | 2 | -2/+2 | |
2021-06-26 | Add and change some Fontello icons for admin theme | Thomas Lange | 16 | -405/+919 | |
2021-06-25 | Fix wrong property name in Repository class | Thomas Lange | 1 | -2/+2 | |
2021-06-25 | Reorganize namespaces | Thomas Lange | 16 | -41/+60 | |
2021-06-24 | Add configuration option MIGRATOR.ENABLED | Thomas Lange | 1 | -1/+4 | |
2021-06-24 | Return NULL instead of config string if unset | Thomas Lange | 1 | -1/+1 | |
2021-06-24 | Implement database schema Migrator | Thomas Lange | 10 | -19/+369 | |
This commit implements the new database schema Migrator which keeps track of the on-disk schema and the schema used by the codebase. It tries to makes future database schema upgrades user-friendlier. | |||||
2021-06-24 | Remove migration for migration table (readme) | Thomas Lange | 2 | -4/+1 | |
This commit removes the migration number 5 which created the migration table. The initialization of the migration table will be implemented in the upcoming migration script by itself. Sorry! If you recently installed the application with a fresh database which contained the migration table, please manually set the schema_version to 4. It is recommended to only install a specific tag instead of the latest master branch unless you are a developer or know what you do. UPDATE migration SET schema_version = 4 | |||||
2021-06-24 | Set Database attribute in Application class | Thomas Lange | 2 | -14/+13 | |
2021-06-23 | Show custom title and description in admin header | Thomas Lange | 1 | -2/+2 | |
2021-06-22 | Add missing static keywords and fix typos | Thomas Lange | 2 | -4/+4 | |
2021-06-22 | Implement new Repository and Entity classes | Thomas Lange | 53 | -1104/+1248 | |
This commit adds new Repository and Entity classes which are better abstracted from the rest of the application. They dont know anymore about configuration options or how to parse to HTML because this is not the job for the ORM but for other parts of the application. The previous commits were a preparation for this big change. An entity now represents just a single record from a specific table of the database – nothing more. The repositories job is it to fetch or update records of the database and instantiate the entities. Another problem that was solved is the high amount of database queries that was needed before. For example, on the blogs home page first were all 10 latest post IDs fetched from the database and then another query was executed with "WHERE id = :id" for *each* single post?! ... This problem is solved with the new repository classes; they now use a single query to fetch and build the entities of the 10 latest posts. This change also solves the problem with database queries spread across the application and limits the exzessive use of try/catch blocks which were used before. The new classes make the whole code much cleaner. :) | |||||
2021-06-21 | Fix prefixes for ADMIN.USER.LIST_* config options | Thomas Lange | 1 | -2/+2 | |
2021-06-21 | Remove unnecessary $ItemTemplate variables | Thomas Lange | 8 | -27/+7 | |
2021-06-21 | Rename some template variables | Thomas Lange | 11 | -24/+24 | |
2021-06-21 | Rename "attr" method of Item class to "get" | Thomas Lange | 19 | -34/+34 | |
2021-06-21 | Remove getArguments method from Item class | Thomas Lange | 1 | -20/+0 | |
2021-06-21 | Use function parseArguments | Thomas Lange | 1 | -1/+1 | |
2021-06-21 | Add function parseArguments | Thomas Lange | 1 | -0/+20 | |
2021-06-21 | Remove unused methods from Item class | Thomas Lange | 1 | -50/+0 | |
2021-06-21 | Use function getMarkdownImageURLs | Thomas Lange | 2 | -2/+2 | |
2021-06-21 | Add function getMarkdownImageURLs | Thomas Lange | 1 | -0/+14 | |
2021-06-21 | Use function parseEntityContent | Thomas Lange | 4 | -4/+4 | |
2021-06-21 | Use function parseContentTags | Thomas Lange | 1 | -1/+3 | |
2021-06-21 | Add function parseEntityContent | Thomas Lange | 1 | -0/+32 | |
2021-06-21 | Add function parseContentTags | Thomas Lange | 1 | -0/+26 | |
2021-06-21 | Remove getGUID methods from Item classes | Thomas Lange | 4 | -35/+0 | |
2021-06-21 | Use function generatePseudoGUID | Thomas Lange | 1 | -1/+1 | |
2021-06-21 | Add function generatePseudoGUID | Thomas Lange | 1 | -0/+22 | |
2021-06-21 | Remove getURL methods from Item classes | Thomas Lange | 4 | -34/+0 | |
2021-06-21 | Use getEntityURL method of Application class | Thomas Lange | 8 | -9/+9 | |
This commit replaces all calls to "$Item->getURL()" with calls to the previously added "getEntityURL" method of the "Application" class. | |||||
2021-06-21 | Add method getEntityURL to Application class | Thomas Lange | 1 | -0/+20 | |
This commit adds the method "getEntityURL" to the "Application" class. This method takes an instance of "Item" as parameter and then builds the absolute URL of the item from its attribute data. | |||||
2021-06-20 | Call password_verify directly in login script | Thomas Lange | 2 | -8/+2 | |
2021-06-19 | Remove unused variable | Thomas Lange | 1 | -1/+0 | |
2021-06-19 | Remove ID form field (and rearrange other fields) | Thomas Lange | 9 | -57/+51 | |
This commit removes the ID form field, enlarges the title form field and rearranges the other form fields in the grid layout. |