aboutsummaryrefslogtreecommitdiffstats
path: root/core
AgeCommit message (Collapse)AuthorFilesLines
2021-07-02Add generic function to create pagination templateThomas Lange7-64/+27
This commit adds and uses the new function createPaginationTemplate to create the generic pagination template for various entity lists. This function replaces the many old confusing functions: * generateNaviTemplate * generatePageNaviTemplate * generatePostNaviTemplate * generateUserNaviTemplate * generateCategoryNaviTemplate * generateCategoryPostNaviTemplate
2021-07-01Add option CATEGORY.LIST_SORT to application.phpThomas Lange2-2/+1
The option CATEGORY.LIST_SORT is currently only used for sorting the children categories of a category, not for sorting the categories on the category overview page. This is because the sorting of the categories in the category overview is handelnd internally with a virtual table column "_depth" which sorts the categories by name *and* its sub categories (like a tree). Thus, there is currently no user option to sort the category overview.
2021-07-01Bugfix: Use empty check instead of issetThomas Lange1-1/+1
If no category tree was found, the array is empty but isset evaluates to true. This fixes the mistake and uses an empty check instead.
2021-07-01Add function generateCategoryPostNaviTemplateThomas Lange2-1/+19
Add and use the function generateCategoryPostNaviTemplate to build the pagination template for posts in a category. This fixes a mistake. TODO: Get rid of that confusing function mess!
2021-07-01Add category system to categorize posts (readme)Thomas Lange10-7/+471
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-01Update database schema for coming category systemThomas Lange3-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-01Bugfix: Explicitly check for FALSE in MigratorThomas Lange1-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-01Add translations for upcoming category systemThomas Lange2-0/+22
2021-07-01Update database schema: Make id columns unsignedThomas Lange3-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-01Add PHP version checkThomas Lange1-0/+7
2021-06-30Optimize core/db/database.sqlThomas Lange1-38/+34
2021-06-29Add WHERE filter option to getCount methodThomas Lange1-4/+23
2021-06-28Bugfix: Remove explicit parameter type intThomas Lange1-3/+3
2021-06-27Allow NULL value comparison in WHERE clauseThomas Lange1-2/+6
2021-06-25Fix wrong property name in Repository classThomas Lange1-2/+2
2021-06-25Reorganize namespacesThomas Lange13-38/+57
2021-06-24Add configuration option MIGRATOR.ENABLEDThomas Lange1-1/+4
2021-06-24Return NULL instead of config string if unsetThomas Lange1-1/+1
2021-06-24Implement database schema MigratorThomas Lange4-0/+244
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-24Remove migration for migration table (readme)Thomas Lange2-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-24Set Database attribute in Application classThomas Lange2-14/+13
2021-06-22Add missing static keywords and fix typosThomas Lange2-4/+4
2021-06-22Implement new Repository and Entity classesThomas Lange37-707/+822
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-21Remove unnecessary $ItemTemplate variablesThomas Lange5-16/+4
2021-06-21Rename some template variablesThomas Lange6-14/+14
2021-06-21Rename "attr" method of Item class to "get"Thomas Lange10-16/+16
2021-06-21Remove getArguments method from Item classThomas Lange1-20/+0
2021-06-21Use function parseArgumentsThomas Lange1-1/+1
2021-06-21Add function parseArgumentsThomas Lange1-0/+20
2021-06-21Remove unused methods from Item classThomas Lange1-50/+0
2021-06-21Use function getMarkdownImageURLsThomas Lange2-2/+2
2021-06-21Add function getMarkdownImageURLsThomas Lange1-0/+14
2021-06-21Use function parseEntityContentThomas Lange1-1/+1
2021-06-21Use function parseContentTagsThomas Lange1-1/+3
2021-06-21Add function parseEntityContentThomas Lange1-0/+32
2021-06-21Add function parseContentTagsThomas Lange1-0/+26
2021-06-21Remove getGUID methods from Item classesThomas Lange4-35/+0
2021-06-21Use function generatePseudoGUIDThomas Lange1-1/+1
2021-06-21Add function generatePseudoGUIDThomas Lange1-0/+22
2021-06-21Remove getURL methods from Item classesThomas Lange4-34/+0
2021-06-21Use getEntityURL method of Application classThomas Lange8-9/+9
This commit replaces all calls to "$Item->getURL()" with calls to the previously added "getEntityURL" method of the "Application" class.
2021-06-21Add method getEntityURL to Application classThomas Lange1-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-20Call password_verify directly in login scriptThomas Lange1-7/+0
2021-06-19Remove unused variableThomas Lange1-1/+0
2021-06-19Rename CRUD methods of Attribute classThomas Lange1-3/+3
2021-06-17Pass configuration array directly to foreachThomas Lange1-8/+3
2021-06-17Move database.sql to core/db/Thomas Lange1-0/+86
2021-06-17Add migrations directoryThomas Lange5-0/+18
This commit adds the directory core/db/migrations/ which contains all migrations that were applied to the database since the first release.
2021-06-14Remove more redundant try/catch blocksThomas Lange9-352/+251
Remove all try/catch blocks where the exception handling did not differ from the exception handler already defined by "set_exception_handler".
2021-06-14Remove redundant try/catch blockThomas Lange1-12/+13
Remove the redundant exception handler from core/application.php. The exception handling in the catch block did not differ from the default handler already defined by "set_exception_handler".