Leafpub Versions Save

:tada: Leafpub 1.1.5 released :tada:

Notable changes

[fix] #107 [fix] bug in Database::updateToVersion2

Leafpub 1.1.4 released

Notable changes

[fix] #105 [fix] #106

Leafpub 1.1.3 released

Notable changes

[fix] bug in AbstractImporter: $adapter->beginTransaction() doesn't exist

Leafpub 1.1.2 released

Notable changes

[enh] adding media list to user's avatar and blog cover

Leafpub 1.1.1 released

Notable changes

• [fix] User model: created has no standard value
• [upd] polish language file

:tada: Leafpub 1.1.0 :tada:

Updating

• Be sure you're using at least php v5.6+!
• Replace index.php and source/
• If you're updating from the last release (beta4), add a new setting to your settings table: name: 'schemeVersion', value: 2
• If you're updating from the latest stable release, be prepared to run a database update. Leafpub will you guide through this update.

Notable changes

• [enh] Event System
• [enh] Plugin support
• [enh] Media Manager
• [enh] ORM (Zend Db)
• [enh] database updates via ORM and schemeVersion, no more need to run SQL queries
• [enh] support for image captions
• [enh] Importer for WordPress

:tada: Leafpub 1.1.0-beta4 :tada:

Updating

• Replace index.php and source/
• open database.php and add 'driver' => 'Pdo_Mysql', 'charset' => 'utf8mb4' to array

Notable changes

• added ORM (Zend Db):
  • reorganised classes in /models and /models/tables
  • removed database.sql script. Installation is now made via Zend Ddl classes
  • Leafpub supports more database system see Zend Db Manual
• added route /admin/regenerateThumbnails: a simple hack to regenerate missing image thumbnails

:tada: Leafpub 1.1.0-beta3 :tada:

Updating

Replace index.php and source/

Notable changes

• added missing language strings
• fixed a bug in Uploads
• fixed regex in WordPress Importer Dropin

:exclamation: DB FIX :exclamation:

Attached you'll find db_upload_fix.php. Copy this file into your Leafpub folder, open a terminal and execute the file via php pathToLeafpub/db_upload_fix.php

The file fixes the data in path and filename fields and generates the thumbnails.

:tada: Leafpub 1.1.0-beta2 :tada:

Updating

Replace index.php and source/

Updating the database

ALTER TABLE __uploads ADD COLUMN `caption` VARCHAR(191) DEFAULT NULL AFTER id;
ALTER TABLE __uploads DROP INDEX `path`;
ALTER TABLE __uploads ADD UNIQUE INDEX `filename`(filename);

ALTER TABLE __tags ADD COLUMN `type` enum('post','upload') NOT NULL DEFAULT 'post';

CREATE TABLE IF NOT EXISTS `__upload_tags` (
   `upload` int(11) NOT NULL,
   `tag` int(11) NOT NULL,
   KEY `upload` (`upload`),
   KEY `tag` (`tag`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE VIEW __view_posts AS
    SELECT  
    a.id, a.slug, a.created, a.pub_date, c.slug as author, a.title, a.content, 
    a.meta_title, a.meta_description, a.status, a.page, a.featured, a.sticky, 
    CONCAT_WS('.', CONCAT(b.path, b.filename), b.extension) as image
    FROM 
    `__posts` a
    LEFT JOIN 
    `__uploads` b
    ON 
    a.image = b.id
    INNER JOIN
    `__users` c
    ON
    a.author = c.id

CREATE TABLE `__post_uploads` (
  `post` int(11) NOT NULL,
  `upload` int(11) NOT NULL,
  KEY `post` (`post`),
  KEY `upload` (`upload`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

Notable changes

• [enh] Media management
  • new menu item
  • overview of existing media files
  • generate tags
  • auto-generate thumbnails
  • insert an image into a post via media manager
  • save image to post relations

:exclamation: ATTENTION :exclamation:

As of the new media management your post image and your content images won't be shown. I'll give you later a script to fix your database.

:sparkles: Leafpub 1.1.0-beta1 :sparkles:

Updating

Replace index.php and source/ and add folder 'content/plugins' to update.

Updating the database

CREATE TABLE IF NOT EXISTS `__plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(51) NOT NULL,
  `description` varchar(100) NOT NULL,
  `author` varchar(51) NOT NULL,
  `version` varchar(8) NOT NULL,
  `requires` varchar(8) NOT NULL,
  `license` varchar(8) NOT NULL,
  `dir` varchar(51) NOT NULL,
  `img` varchar(100) NOT NULL,
  `link` varchar(100) DEFAULT NULL,
  `isAdminPlugin` tinyint(1) NOT NULL DEFAULT '0',
  `isMiddleware` tinyint(1) NOT NULL DEFAULT '0',
  `install_date` datetime NOT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `enable_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `dir` (`dir`),
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

Notable changes

• [enh] Event System
• [enh] Plugin System
• [enh] Mailer Interface
• [enh] first Plugin (SwiftMailer)