Umbau des CMS MySQLiteCMS Version 3.6.2

Die Inhalte von Special Tags werden nun auch in Global Content Blöcken angezeigt. Dazu wurden die folgenden Dateien angepasst:

  • \cms\data\content.sqlite
  • \cms\includes\content.inc.php
  • \cms\includes\gcb.inc.php

Man kann jetzt die folgenden Special Tags nutzen:

  • image:imagefile.jpg|classname fügt eine Grafikdatei ein, war bereits Bestandteil des phpSQLiteCMS von ilosuna, kann über die Toolsbar des Non-WYSIWYG-Editor eingefügt werden
  • thumbnail:#number|classname fügt eine Thumbnail-Datei ein, war bereits Bestandteil des phpSQLiteCMS von ilosuna, kann über die Toolsbar des Non-WYSIWYG-Editor eingefügt werden
  • gallery:galleryname fügt eine ganze Bildergalerie ein, war bereits Bestandteil des phpSQLiteCMS von ilosuna, kann über die Toolsbar des Non-WYSIWYG-Editor eingefügt werden
  • websitetolink|linktext fügt einen Link ein, war bereits Bestandteil des phpSQLiteCMS von ilosuna, kann über die Toolsbar des Non-WYSIWYG-Editor eingefügt werden
  • bootstrapgallery:galleryname fügt eine ganze Bildergalerie als Bootstrap-Slider ein, ist neu in MySQLiteCMS, nicht in der Toolbar integriert
  • csv:csvfile.csv erstellt eine Tabelle aus einer CSV-Datei, ist neu in MySQLiteCMS, nicht in der Toolbar integriert
  • baseurl fügt die Basis-URL einer MySQLite-Installation ein, ist sinnvoll, wenn das CMS nicht im Wurzelverzeichnis steht, ist neu in MySQLiteCMS, nicht in der Toolbar integriert
  • categories fügt Links zu allen verfügbaren Kategorien ein, kann im Inhaltsbereich, in einer Sidebar oder in einem Global Content Block eingefügt werden. ist neu in MySQLiteCMS, nicht in der Toolbar integriert

Inhalt der Datei README.md

# MySQLiteCMS
A SQLite leightweight CMS

## Basis

The basis of this CMS is [https://github.com/ilosuna/phpsqlitecms](https://github.com/ilosuna/phpsqlitecms).

Another source is [https://github.com/emanuel4you/phpsqlitecms](https://github.com/emanuel4you/phpsqlitecms). This is a fork of the first mentioned repository.

## Improvements / Changes / Adaptations

My goal is to combine the best of both versions and eliminate existing issues.

That concerns for example:

* Submenus; These are already included in emanuel4you, but do not work properly.
* Backups of the Database; This are already included in emanuel4you, but do not work properly.
* Inserting news pages - done
* Adapting the Editor in Non-WYSIWYG Mode -done

## Changes 19.06.2019

* New: \cms\templates\default-3menus-news.tpl
* Changed:\cms\templates\default.tpl
* Changed:\cms\data\content.sqlite
* Changed:\cms\templates\admin\subtemplates\edit.inc.tpl

The main improvement is that you now can include News-Pages and Simple-News-Pages into other pages.

## Changes 20.06.2019

* New: \static\js\admin.js; from 2.0.4 but with some changes
* Changed: \static\css\style_admin.css; CSS Code for the Editor-Buttons
* Changed: \cms\templates\admin\main.tpl; include admin.js
* Changed: \cms\templates\admin\subtemplates\edit.inc.tpl; reaction for the Buttons

The main improvement is the improvement of the Non-WYSIWYG-Editor

## Changes 20.06.2019

* \cms\lang\german.admin.lang.php; corrections of misspelled items

## Changes 21.06.2019

New items for backup and submenu:

* \cms\lang\bulgarian.admin.lang.php
* \cms\lang\chinese_zh-CN.admin.lang.php
* \cms\lang\english.admin.lang.php
* \cms\lang\german.admin.lang.php; correction of misspelled items
* \cms\lang\polish.admin.lang.php
* \cms\lang\russian.admin.lang.php
* \cms\lang\spanish.admin.lang.php
* \cms\lang\ukrainian.admin.lang.php

Different changes:

* \config\definitions.conf.php; newer version for jquery, jqueryui, bootstrap and tinymce
* \cms\index.php; backup item added
* \cms\config\sql\mysql.initial.sql; submenu items
* \cms\config\sql\postgresql.initial.sql; submenu items
* \cms\data\content.sqlite; submenu column in table phpsqlitecms_menus added
* \cms\includes\backup.inc.php; new backup function
* \cms\includes\functions.admin.inc.php; improved security with password token
* \cms\includes\functions.inc.php; access to submenu items
* \cms\includes\menus.inc.php; access to submenu items
* \cms\includes\users.inc.php; improved security with password token
* \cms\templates\admin\subtemplates\admin_index.inc.tpl; backup item added
* \cms\templates\admin\subtemplates\admin_menu.inc.tpl; backup item added
* \cms\templates\admin\subtemplates\backup.inc.tpl; new for database backup
* \cms\templates\admin\subtemplates\menus_edit.inc.tpl; submenu handlung added
* \cms\templates\admin\subtemplates\menus_edit_item.inc.tpl; submenu handlung added
* \cms\templates\admin\subtemplates\users.inc.tpl; improved security with password token
* \cms\templates\admin\subtemplates\users_delete.inc.tpl; improved security with password token
* \cms\templates\admin\subtemplates\users_edit.inc.tpl; improved security with password token
* \cms\templates\admin\subtemplates\users_new.inc.tpl; improved security with password token
 
The main improvements are the database backup and the submenus.

## Changes 23.06.2019

New:

* \cms\templates\subtemplates\bootstrap-carousel.inc.tpl

Changed:

* \cms\includes\classes\Gallery.class.php
* \cms\templates\default-3menus-news.tpl - missing jQuery added
* \cms\includes\functions.inc.php - Handling of the Bootstrap Carousel included
* \cms\data\content.sqlite - Demo Page of the Bootstrap Carousel included

The main improvement is the Bootstrap Carousel

## Changes 28.06.2019

New:

* .htaccess in some subdirectories - for security reasons
* \cms\templates\default-category.tpl - demonstration of news categories
* \cms\templates\default-headline-3menus-news.tpl - demonstration of headline
* \static\img\pdf.png - missing icon added
* \static\img\rss.png - missing icon added

Changed:

* \cms\data\content.sqlite - more demonstration and testpages
* \cms\includes\edit.inc.php - headline
* \cms\includes\functions.inc.php - collection of  news categories
* \cms\templates\default.tpl - no submenu hover (JavaScript)
* \cms\templates\default-3menus-news.tpl - no submenu hover (JavaScript)
* \cms\templates\admin\subtemplates\edit.inc.tpl - category and headline added
* \cms\templates\subtemplates\news.inc.tpl - category added
* \cms\templates\subtemplates\overview.inc.tpl - some comments added

The main improvement is categories in news pages.

## Changes 01.07.2019

* \cms\data\content.sqlite - some examples to demonstrate the new `https://bpgs.de/`
* \cms\includes\functions.inc.php - some useless comments removed, `https://bpgs.de/` included
* \cms\templates\admin\subtemplates\edit.inc.tpl - improved editor for sidebar content and teaser content
* \cms\templates\subtemplates\gallery.inc.tpl - better gallery with view title and subtitle

The main improvements are the special tag `https://bpgs.de/` and the improved editor for sidebar content and teaser content

## Changes 02.07.2019

New:

* favicon.ico
* all files in the \static\img\favicon directory

Changed:

* \static\img\favicon.png
* \cms\templates\default.tpl
* \cms\templates\default-3menus-news.tpl
* \cms\templates\default-category.tpl
* \cms\templates\default-headline-3menus-news.tpl

All changes serve the favicon representation.

## Changes 04.07.2019

New:

* \static\files\example-01.csv - example file for csv-import
* \static\js\csv.js - JavaScript for filtering and sorting of csv-imported tables

Changed:

* \github\cms\data\content.sqlite - example for csv import added
* \github\cms\includes\functions.inc.php - spezial tag for csv-import added
* \github\cms\templates\admin\subtemplates\admin_menu.inc.tpl - minor correction of HTML-Code output

The main improvement is the csv import via special tag:


    File '/customers/8/e/d/bpgs.de/httpd.www/static/files/dateiname' does not exist!

## Changes 09.07.2019

* \github\cms\data\content.sqlite - Some descriptions added
* \cms\includes\edit.inc.php - you can edit now the page views
* \cms\templates\admin\subtemplates\edit.inc.tpl - you can edit now the page views
* \cms\templates\default-3menus-news.tpl

The main improvement is that you can edit now the page views.

## Changes 11.07.2019

* \github\cms\data\content.sqlite
* \cms\includes\content.inc.php - show special tags in Global Content Blogs
* \cms\includes\gcb.inc.php - show special tags in Global Content Blogs

The main improvement is that you can see now the content of special tags in Global Content Blogs.

You can use the following special tags:

* ` [ missing image ] ` - includes an image file, this is already part of phpSQLiteCMS from ilosuna, can be added via the non-wysiwyg-toolbar of the editor
* ` [ missing image ] ` - includes an thumbnail image file, this is already part of phpSQLiteCMS from ilosuna, can be added via the non-wysiwyg-toolbar of the editor
* `

No photo in this gallery

` - includes a whole imagegallery, this is already part of phpSQLiteCMS from ilosuna, can be added via the non-wysiwyg-toolbar of the editor
* `linktext` -  - includes a link , this is already part of phpSQLiteCMS from ilosuna, can be added via the non-wysiwyg-toolbar of the editor
* `[bootstrapgallery:galleryname]` - includes a whole imagegallery as a **bootstrap slider**, this is **new in MySQLiteCMS**, can **not** be added via the non-wysiwyg-toolbar of the editor, just type it in.
* `[csv:csvfile.csv]` - includes the content of a csvfile as a table, this is **new in MySQLiteCMS**, can **not** be added via the non-wysiwyg-toolbar of the editor, just type it in.
* `https://bpgs.de/` - includes the base url of a cms installation, useful if you use a subdirectory, this is **new in MySQLiteCMS**, can **not** be added via the non-wysiwyg-toolbar of the editor, just type it in.