install.php

<?php
/**
 * @author kontakt[at]greatif[dot]de
 * @package redaxo5
 * @license MIT
 */

/** @var rex_addon $this */
// install blog database

$content = rex_file::get(rex_path::addon('gblog', 'dump/yform_table_blog.json'));
rex_yform_manager_table_api::importTablesets($content);

$content = rex_file::get(rex_path::addon('gblog', 'dump/yform_table_ycom_comment.json'));
rex_yform_manager_table_api::importTablesets($content);

// add column "med_description" to table "media"
rex_sql_table::get(rex::getTable('media'))
    ->ensureColumn(new rex_sql_column('med_description', 'text', 'NULL'))
    ->alter();

// install data entries
$sql = rex_sql::factory();
if (sizeof($sql->getArray("SELECT id FROM " . rex::getTable('metainfo_field') . " WHERE title='Beschreibung'")) <= 0) {
    try {
        $sql = rex_sql::factory();
        rex_sql_util::importDump($this->getPath('dump/metainfo_field.sql'));
    } catch (rex_sql_exception $e) {
        rex_logger::logException($e);
        print rex_view::error($e->getMessage());
    }
}
if (sizeof($sql->getArray("SELECT id FROM " . rex::getTable('url_generate') . " WHERE rex_url_generate.table='1_xxx_rex_blog'")) <= 0) {
    try {
        $sql = rex_sql::factory();
        rex_sql_util::importDump($this->getPath('dump/url_generate.sql'));
    } catch (rex_sql_exception $e) {
        rex_logger::logException($e);
        print rex_view::error($e->getMessage());
    }
}

// install Blog Modul
$content = '';
$search_modul_blog = 'module:blog_output';

$blogmodule = rex_sql::factory();
$blogmodule->setQuery('select * from rex_module where output LIKE "%' . $search_modul_blog . '%"');

$module_id = 0;
$module_name = '';
foreach ($blogmodule->getArray() as $module) {
    $module_id = $module['id'];
    $module_name = $module['name'];
}

$yform_module_name = 'Blog';

$input = rex_file::get(rex_path::addon('gblog', 'module/blog_input.php'));
$output = rex_file::get(rex_path::addon('gblog', 'module/blog_output.php'));

$mi = rex_sql::factory();
$mi->setTable('rex_module');
$mi->setValue('input', $input);
$mi->setValue('output', $output);

if ($module_name == $yform_module_name) {
    $mi->setWhere('id="' . $module_id . '"');
    $mi->update();
} else {
    $mi->setValue('name', $yform_module_name);
    $mi->insert();
    $module_id = (int)$mi->getLastId();
    $module_name = $yform_module_name;
}

// install Blog-Teaser Modul
$content = '';
$search_modul_blogteaser = 'module:blog-teaser_output';

$blogteasermodule = rex_sql::factory();
$blogteasermodule->setQuery('select * from rex_module where output LIKE "%' . $search_modul_blogteaser . '%"');

$module_id = 0;
$module_name = '';
foreach ($blogteasermodule->getArray() as $module) {
    $module_id = $module['id'];
    $module_name = $module['name'];
}

$yform_module_name = 'Blog-Teaser';

$input = rex_file::get(rex_path::addon('gblog', 'module/blog-teaser_input.php'));
$output = rex_file::get(rex_path::addon('gblog', 'module/blog-teaser_output.php'));

$mi = rex_sql::factory();
$mi->setTable('rex_module');
$mi->setValue('input', $input);
$mi->setValue('output', $output);

if ($module_name == $yform_module_name) {
    $mi->setWhere('id="' . $module_id . '"');
    $mi->update();
} else {
    $mi->setValue('name', $yform_module_name);
    $mi->insert();
    $module_id = (int)$mi->getLastId();
    $module_name = $yform_module_name;
}

// install Blog RSS-Feed Modul
$content = '';
$search_modul_blog_rssfeed = 'module:blog-rssfeed_output';

$blogrssmodule = rex_sql::factory();
$blogrssmodule->setQuery('select * from rex_module where output LIKE "%' . $search_modul_blog_rssfeed . '%"');

$module_id = 0;
$module_name = '';
foreach ($blogrssmodule->getArray() as $module) {
    $module_id = $module['id'];
    $module_name = $module['name'];
}

$yform_module_name = 'Blog - RSS-Feed';

$input = rex_file::get(rex_path::addon('gblog', 'module/rss-feed_input.php'));
$output = rex_file::get(rex_path::addon('gblog', 'module/rss-feed_output.php'));

$mi = rex_sql::factory();
$mi->setTable('rex_module');
$mi->setValue('input', $input);
$mi->setValue('output', $output);

if ($module_name == $yform_module_name) {
    $mi->setWhere('id="' . $module_id . '"');
    $mi->update();
} else {
    $mi->setValue('name', $yform_module_name);
    $mi->insert();
    $module_id = (int)$mi->getLastId();
    $module_name = $yform_module_name;
}

// install RSS-Feed Template
$content = '';
$attributes ='{"ctype":[],"modules":{"1":{"all":"1"}},"categories":{"all":"1"}}';
$active = '1';
$search_template_blog_rssfeed = 'template:blog_rssfeed';

$blogrsstemplate = rex_sql::factory();
$blogrsstemplate->setQuery('select * from rex_template where content LIKE "%' . $search_template_blog_rssfeed . '%"');

$template_id = 0;
$template_name = '';
foreach ($blogrsstemplate->getArray() as $template) {
    $template_id = $template['id'];
    $template_name = $template['name'];
}

$yform_template_name = 'Blog - RSS-Feed';

$content = rex_file::get(rex_path::addon('gblog', 'templates/template-rss.php'));

$ti = rex_sql::factory();
$ti->setTable('rex_template');
$ti->setValue('content', $content);
$ti->setValue('attributes', $attributes);
$ti->setValue('active', $active);

if ($template_name == $yform_template_name) {
    $ti->setWhere('id="' . $template_id . '"');
    $ti->update();
} else {
    $ti->setValue('name', $yform_template_name);
    $ti->insert();
    $template_id = (int)$ti->getLastId();
    $template_name = $yform_template_name;
}

rex_delete_cache();