| Server IP : 54.36.91.62 / Your IP : 216.73.217.117 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/www/cj79373/administrator/components/com_kunena/install/ |
Upload File : |
<?php
/**
* Kunena Component
*
* @package Kunena.Installer
*
* @copyright Copyright (C) 2008 - 2022 Kunena Team. All rights reserved.
* @license https://www.gnu.org/copyleft/gpl.html GNU/GPL
* @link https://www.kunena.org
**/
defined('_JEXEC') or die();
use Joomla\CMS\Factory;
use Joomla\Archive\Archive;
use Joomla\CMS\Filesystem\Folder;
use Joomla\CMS\Language\Text;
use Joomla\CMS\Session\Session;
use Joomla\CMS\Uri\Uri;
jimport('joomla.filesystem.folder');
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.path');
jimport('joomla.filesystem.archive');
define('KUNENA_INSTALLER_PATH', __DIR__);
define('KUNENA_INSTALLER_ADMINPATH', dirname(KUNENA_INSTALLER_PATH));
define('KUNENA_INSTALLER_SITEPATH', JPATH_SITE . '/components/' . basename(KUNENA_INSTALLER_ADMINPATH));
define('KUNENA_INSTALLER_MEDIAPATH', JPATH_SITE . '/media/kunena');
/**
* Install Model for Kunena
*
* @since 1.6
*/
class KunenaModelInstall extends \Joomla\CMS\MVC\Model\BaseDatabaseModel
{
/**
* Flag to indicate model state initialization.
*
* @var boolean
* @since 1.6
*/
protected $__state_set = false;
/**
* @var bool
* @since Kunena
*/
protected $_versionprefix = false;
/**
* @var array
* @since Kunena
*/
protected $_installed = array();
/**
* @var array
* @since Kunena
*/
protected $_versions = array();
/**
* @var bool
* @since Kunena
*/
protected $_action = false;
/**
* @var null
* @since Kunena
*/
protected $_errormsg = null;
/**
* @var array|null
* @since Kunena
*/
protected $_versiontablearray = null;
/**
* @var null
* @since Kunena
*/
protected $_versionarray = null;
/**
* @var array|null
* @since Kunena
*/
public $steps = null;
/**
* @throws Exception
* @since Kunena
*/
public function __construct()
{
// Load installer language file only from the component
$lang = Factory::getLanguage();
$lang->load('com_kunena.install', KUNENA_INSTALLER_ADMINPATH, 'en-GB');
$lang->load('com_kunena.install', KUNENA_INSTALLER_ADMINPATH);
$lang->load('com_kunena.libraries', KUNENA_INSTALLER_ADMINPATH, 'en-GB');
$lang->load('com_kunena.libraries', KUNENA_INSTALLER_ADMINPATH);
parent::__construct();
$this->db = Factory::getDBO();
if (function_exists('ignore_user_abort'))
{
ignore_user_abort(true);
}
$this->setState('default_max_time', @ini_get('max_execution_time'));
@set_time_limit(300);
$this->setState('max_time', @ini_get('max_execution_time'));
// TODO: move to migration
$this->_versiontablearray = array(array('prefix' => 'kunena_', 'table' => 'kunena_version'), array('prefix' => 'fb_', 'table' => 'fb_version'));
// TODO: move to migration
$this->_kVersions = array(
array('component' => null, 'prefix' => null, 'version' => null, 'date' => null), );
// TODO: move to migration
$this->_fbVersions = array(
array('component' => 'FireBoard', 'prefix' => 'fb_', 'version' => '1.0.4', 'date' => '2007-12-23',
'table' => 'fb_sessions', 'column' => 'currvisit', ),
array('component' => 'FireBoard', 'prefix' => 'fb_', 'version' => '1.0.3', 'date' => '2007-09-04',
'table' => 'fb_categories', 'column' => 'headerdesc', ),
array('component' => 'FireBoard', 'prefix' => 'fb_', 'version' => '1.0.2', 'date' => '2007-08-03',
'table' => 'fb_users', 'column' => 'rank', ),
array('component' => 'FireBoard', 'prefix' => 'fb_', 'version' => '1.0.1', 'date' => '2007-05-20',
'table' => 'fb_users', 'column' => 'uhits', ),
array('component' => 'FireBoard', 'prefix' => 'fb_', 'version' => '1.0.0', 'date' => '2007-04-15',
'table' => 'fb_messages', ),
array('component' => null, 'prefix' => null, 'version' => null, 'date' => null), );
// TODO: move to migration
$this->_sbVersions = array(
array('component' => 'JoomlaBoard', 'prefix' => 'sb_', 'version' => 'v1.0.5', 'date' => '1000-01-01',
'table' => 'sb_messages', ),
array('component' => null, 'prefix' => null, 'version' => null, 'date' => null), );
$this->steps = array(
array('step' => '', 'menu' => Text::_('COM_KUNENA_INSTALL_STEP_INSTALL')),
array('step' => 'Prepare', 'menu' => Text::_('COM_KUNENA_INSTALL_STEP_PREPARE')),
array('step' => 'Plugins', 'menu' => Text::_('COM_KUNENA_INSTALL_STEP_PLUGINS')),
array('step' => 'Database', 'menu' => Text::_('COM_KUNENA_INSTALL_STEP_DATABASE')),
array('step' => 'Finish', 'menu' => Text::_('COM_KUNENA_INSTALL_STEP_FINISH')),
array('step' => '', 'menu' => Text::_('COM_KUNENA_INSTALL_STEP_COMPLETE')), );
// The log file will be found into \administrator\logs
JLog::addLogger(
array(
// Sets file name
'text_file' => 'com_kunena.log.php'
),
// Sets messages of all log levels to be sent to the file.
JLog::ALL,
// The log category/categories which should be recorded in this file.
// In this case, it's just the one category from our extension.
// We still need to put it inside an array.
array('com_kunena')
);
}
/**
* Initialise Kunena, run from Joomla installer.
* @since Kunena
*
* @since Kunena
* @throws Exception
*/
public function install()
{
// Make sure that we are using the latest English language files
$this->installLanguage('en-GB');
$this->setStep(0);
}
/**
* Uninstall Kunena, run from Joomla installer.
*
* @return boolean
* @throws Exception
* @since Kunena
*/
public function uninstall()
{
// Put back file that was removed during installation.
$contents = '';
JFile::write(KPATH_ADMIN . '/install.php', $contents);
// Uninstall all plugins.
$this->uninstallPlugin('kunena', 'altauserpoints');
$this->uninstallPlugin('kunena', 'community');
$this->uninstallPlugin('kunena', 'comprofiler');
$this->uninstallPlugin('kunena', 'easyprofile');
$this->uninstallPlugin('kunena', 'easysocial');
$this->uninstallPlugin('kunena', 'gravatar');
$this->uninstallPlugin('kunena', 'joomla');
$this->uninstallPlugin('kunena', 'kunena');
$this->uninstallPlugin('kunena', 'uddeim');
$this->uninstallPlugin('finder', 'kunena');
$this->uninstallPlugin('quickicon', 'kunena');
$this->uninstallPlugin('content', 'kunena');
// Uninstall menu module.
$this->uninstallModule('mod_kunenamenu');
// Remove all Kunena related menu items, including aliases
if (class_exists('KunenaMenuFix'))
{
$items = KunenaMenuFix::getAll();
foreach ($items as $item)
{
KunenaMenuFix::delete($item->id);
}
}
$this->deleteMenu();
// Uninstall Kunena library
$this->uninstallLibrary();
// Uninstall Kunena media
$this->uninstallMedia();
// Uninstall Kunena system plugin
$this->uninstallPlugin('system', 'kunena');
return true;
}
/**
* Get model
*
* @return $this
* @since Kunena
*/
public function getModel()
{
return $this;
}
/**
* Overridden method to get model state variables.
*
* @param string $property Optional parameter name.
* @param mixed $default The default value to use if no state property exists by name.
*
* @return object The property where specified, the state object where omitted.
*
* @throws Exception
* @since 1.6
*/
public function getState($property = null, $default = null)
{
// If the model state is uninitialized lets set some values we will need from the request.
if ($this->__state_set === false)
{
$app = Factory::getApplication();
$this->setState('action', $step = $app->getUserState('com_kunena.install.action', null));
$this->setState('step', $step = $app->getUserState('com_kunena.install.step', 0));
$this->setState('task', $task = $app->getUserState('com_kunena.install.task', 0));
$this->setState('version', $task = $app->getUserState('com_kunena.install.version', null));
if ($step == 0)
{
$app->setUserState('com_kunena.install.status', array());
}
$this->setState('status', $app->getUserState('com_kunena.install.status'));
$this->__state_set = true;
}
$value = parent::getState($property);
return is_null($value) ? $default : $value;
}
/**
* Get Status
*
* @return object
* @throws Exception
* @since Kunena
*/
public function getStatus()
{
return $this->getState('status', array());
}
/**
* Get Action
*
* @return object
* @throws Exception
* @since Kunena
*/
public function getAction()
{
return $this->getState('action', null);
}
/**
* @return object
* @throws Exception
* @since Kunena
*/
public function getStep()
{
return $this->getState('step', 0);
}
/**
* @return object
* @throws Exception
* @since Kunena
*/
public function getTask()
{
return $this->getState('task', 0);
}
/**
* Get version
*
* @return object
* @throws Exception
* @since Kunena
*/
public function getVersion()
{
return $this->getState('version', null);
}
/**
* Set Action
*
* @param $action
*
* @throws Exception
* @since Kunena
*/
public function setAction($action)
{
$this->setState('action', $action);
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.action', $action);
}
/**
* @param $step
*
* @throws Exception
* @since Kunena
*/
public function setStep($step)
{
$this->setState('step', (int) $step);
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.step', (int) $step);
$this->setTask(0);
}
/**
* @param $task
*
* @throws Exception
* @since Kunena
*/
public function setTask($task)
{
$this->setState('task', (int) $task);
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.task', (int) $task);
}
/**
* @param $version
*
* @throws Exception
* @since Kunena
*/
public function setVersion($version)
{
$this->setState('version', $version);
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.version', $version);
}
/**
* @param $task
* @param bool $result
* @param string $msg
* @param null $id
*
* @throws Exception
* @since Kunena
*/
public function addStatus($task, $result = false, $msg = '', $id = null)
{
$status = $this->getState('status');
$step = $this->getStep();
if ($id === null)
{
$status [] = array('step' => $step, 'task' => $task, 'success' => $result, 'msg' => $msg);
JLog::add('Task '.$task.' MSG '.$msg.' RESULT '.$result, JLog::ERROR, 'com_kunena');
}
else
{
unset($status [$id]);
$status [$id] = array('step' => $step, 'task' => $task, 'success' => $result, 'msg' => $msg);
JLog::add('Task '.$task.' MSG '.$msg.' RESULT '.$result, JLog::ERROR, 'com_kunena');
}
$this->setState('status', $status);
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.status', $status);
}
/**
* @return bool|string
*
* @throws Exception
* @since Kunena
*/
public function getInstallError()
{
$status = $this->getState('status', array());
foreach ($status as $cur)
{
$error = !$cur['success'];
if ($error)
{
return $cur['task'] . ' ... ' . ($cur['success'] > 0 ? 'SUCCESS' : 'FAILED');
}
}
return false;
}
/**
* @return array|null
*
* @since Kunena
*/
public function getSteps()
{
return $this->steps;
}
/**
* @param $path
* @param $filename
* @param null $dest
* @param bool $silent
*
* @return bool|null
*
* @throws Exception
* @since Kunena
*/
public function extract($path, $filename, $dest = null, $silent = false)
{
$success = null;
if (!$dest)
{
$dest = $path;
}
$file = "{$path}/{$filename}";
$text = '';
if (is_file($file))
{
$success = true;
if (!JFolder::exists($dest))
{
$success = JFolder::create($dest);
}
if ($success)
{
$archive = new Archive;
$success = $archive->extract($file, $dest);
}
if (!$success)
{
$text .= Text::sprintf('COM_KUNENA_INSTALL_EXTRACT_FAILED', $file);
}
}
else
{
$success = true;
$text .= Text::sprintf('COM_KUNENA_INSTALL_EXTRACT_MISSING', $file);
}
if ($success !== null && !$silent)
{
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_EXTRACT_STATUS', $filename), $success, $text);
}
return $success;
}
// TODO: move to migration (exists in 2.0)
/**
* @param $tag
* @param string $name
*
* @return bool
* @throws Exception
* @since Kunena
*/
public function installLanguage($tag, $name = '')
{
$exists = false;
$success = true;
$destinations = array(
'site' => JPATH_SITE . '/components/com_kunena',
'admin' => JPATH_ADMINISTRATOR . '/components/com_kunena',
);
foreach ($destinations as $key => $dest)
{
if ($success != true)
{
continue;
}
$installdir = "{$dest}/language/{$tag}";
// Install language from dest/language/xx-XX
if (is_dir($installdir))
{
$exists = $success;
// Older versions installed language files into main folders
// Those files need to be removed to bring language up to date!
jimport('joomla.filesystem.folder');
$files = Folder::files($installdir, '\.ini$');
foreach ($files as $filename)
{
if (is_file(JPATH_SITE . "/language/{$tag}/{$filename}"))
{
JFile::delete(JPATH_SITE . "/language/{$tag}/{$filename}");
}
if (is_file(JPATH_ADMINISTRATOR . "/language/{$tag}/{$filename}"))
{
JFile::delete(JPATH_ADMINISTRATOR . "/language/{$tag}/{$filename}");
}
}
}
}
if ($exists && $name)
{
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_LANGUAGE', $name), $success);
}
return $success;
}
/**
* @param $group
* @param $element
*
* @return mixed
*
* @since Kunena
*/
public function loadPlugin($group, $element)
{
$plugin = \Joomla\CMS\Table\Table::getInstance('extension');
$plugin->load(array('type' => 'plugin', 'folder' => $group, 'element' => $element));
return $plugin;
}
/**
* @param $path
* @param $name
*
* @return bool|null
*
* @throws Exception
* @since Kunena
*/
public function installModule($path, $name)
{
$success = false;
$dest = JPATH_ROOT . "/tmp/kinstall_mod_{$name}";
if (is_dir($dest))
{
JFolder::delete($dest);
}
if (is_dir(KUNENA_INSTALLER_ADMINPATH . '/' . $path))
{
// Copy path
$success = JFolder::copy(KUNENA_INSTALLER_ADMINPATH . '/' . $path, $dest);
}
elseif (is_file(KUNENA_INSTALLER_ADMINPATH . '/' . $path))
{
// Extract file
$success = $this->extract(KUNENA_INSTALLER_ADMINPATH, $path, $dest);
}
if ($success)
{
$success = JFolder::create($dest . '/language/en-GB');
}
if ($success && is_file(KUNENA_INSTALLER_SITEPATH . "/language/en-GB/en-GB.mod_{$name}.ini"))
{
$success = JFile::copy(KUNENA_INSTALLER_SITEPATH . "/language/en-GB/en-GB.mod_{$name}.ini", "{$dest}/language/en-GB/en-GB.mod_{$name}.ini");
}
if ($success && is_file(KUNENA_INSTALLER_SITEPATH . "/language/en-GB/en-GB.mod_{$name}.sys.ini"))
{
$success = JFile::copy(KUNENA_INSTALLER_SITEPATH . "/language/en-GB/en-GB.mod_{$name}.sys.ini", "{$dest}/language/en-GB/en-GB.mod_{$name}.sys.ini");
}
// Only install module if it can be used in current Joomla version (manifest exists)
if ($success && is_file("{$dest}/mod_{$name}.xml"))
{
$installer = new \Joomla\CMS\Installer\Installer;
$success = $installer->install($dest);
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_MODULE_STATUS', ucfirst($name)), $success);
}
elseif (!$success)
{
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_MODULE_STATUS', ucfirst($name)), $success);
}
JFolder::delete($dest);
return $success;
}
/**
* @param $path
* @param $group
* @param $name
* @param $publish
* @param int $ordering
*
* @return bool|null
*
* @throws Exception
* @since Kunena
*/
public function installPlugin($path, $group, $name, $publish, $ordering = 0)
{
$success = false;
$dest = JPATH_ROOT . "/tmp/kinstall_plg_{$group}_{$name}";
if (is_dir($dest))
{
JFolder::delete($dest);
}
if (is_dir(KUNENA_INSTALLER_PATH . '/' . $path))
{
// Copy path
$success = JFolder::copy(KUNENA_INSTALLER_PATH . '/' . $path, $dest);
}
elseif (is_file(KUNENA_INSTALLER_PATH . '/' . $path))
{
// Extract file
$success = $this->extract(KUNENA_INSTALLER_PATH, $path, $dest);
}
if ($success)
{
$success = JFolder::create($dest . '/language/en-GB');
}
if ($success && is_file(KUNENA_INSTALLER_ADMINPATH . "/language/en-GB/en-GB.plg_{$group}_{$name}.ini"))
{
$success = JFile::copy(KUNENA_INSTALLER_ADMINPATH . "/language/en-GB/en-GB.plg_{$group}_{$name}.ini", "{$dest}/language/en-GB/en-GB.plg_{$group}_{$name}.ini");
}
if ($success && is_file(KUNENA_INSTALLER_ADMINPATH . "/language/en-GB/en-GB.plg_{$group}_{$name}.sys.ini"))
{
$success = JFile::copy(KUNENA_INSTALLER_ADMINPATH . "/language/en-GB/en-GB.plg_{$group}_{$name}.sys.ini", "{$dest}/language/en-GB/en-GB.plg_{$group}_{$name}.sys.ini");
}
// Only install plugin if it can be used in current Joomla version (manifest exists)
if ($success && is_file("{$dest}/{$name}.xml"))
{
$installer = new \Joomla\CMS\Installer\Installer;
$success = $installer->install($dest);
if ($success)
{
// First change plugin ordering
$plugin = $this->loadPlugin($group, $name);
if ($ordering && !$plugin->ordering)
{
$plugin->ordering = $ordering;
}
if ($publish)
{
$plugin->enabled = $publish;
}
$success = $plugin->store();
}
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_PLUGIN_STATUS', ucfirst($group) . ' - ' . ucfirst($name)), $success);
}
elseif (!$success)
{
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_PLUGIN_STATUS', ucfirst($group) . ' - ' . ucfirst($name)), $success);
}
JFolder::delete($dest);
return $success;
}
/**
* @param $name
*
* @since Kunena
*/
public function uninstallModule($name)
{
$query = "SELECT extension_id FROM `#__extensions` WHERE type='module' AND element='{$name}'";
$this->db->setQuery($query);
$moduleid = $this->db->loadResult();
if ($moduleid)
{
$installer = new \Joomla\CMS\Installer\Installer;
$installer->uninstall('module', $moduleid);
}
}
/**
* @param $folder
* @param $name
*
* @since Kunena
*/
public function uninstallPlugin($folder, $name)
{
$query = "SELECT extension_id FROM `#__extensions` WHERE type='plugin' AND folder='{$folder}' AND element='{$name}'";
$this->db->setQuery($query);
$pluginid = $this->db->loadResult();
if ($pluginid)
{
$installer = new \Joomla\CMS\Installer\Installer;
$installer->uninstall('plugin', $pluginid);
}
}
/**
* Method to uninstall the Kunena library during uninstall process
*
* @return void
*
* @since Kunena
*/
public function uninstallLibrary()
{
$libraryid = $this->uninstallMediaLibraryQuery('library', 'kunena');
if ($libraryid)
{
$installer = new \Joomla\CMS\Installer\Installer;
$installer->uninstall('library', $libraryid);
}
}
/**
* Method to uninstall the Kunena media during uninstall process
*
* @return void
*
* @since Kunena
*/
public function uninstallMedia()
{
$mediaid = $this->uninstallMediaLibraryQuery('file', 'kunena_media');
if ($mediaid)
{
$installer = new \Joomla\CMS\Installer\Installer;
$installer->uninstall('file', $mediaid);
}
}
/**
* Method to uninstall the Kunena media during uninstall process
*
* @param $type
* @param string $element Name of the package or of the component
*
* @return int
*
* @since Kunena
*/
private function uninstallMediaLibraryQuery($type, $element)
{
$query = $this->db->getQuery(true);
$query->select($this->db->quoteName('extension_id'));
$query->from($this->db->quoteName('#__extensions'));
$query->where($this->db->quoteName('type') . "='" . $type . "'");
$query->where($this->db->quoteName('element') . "='" . $element . "'");
$this->db->setQuery($query);
$id = $this->db->loadResult();
return $id;
}
/**
* @param $path
* @param array $ignore
*
* @since Kunena
*/
public function deleteFiles($path, $ignore = array())
{
$ignore = array_merge($ignore, array('.git', '.svn', 'CVS', '.DS_Store', '__MACOSX'));
if (Folder::exists($path))
{
foreach (Folder::files($path, '.', false, true, $ignore) as $file)
{
if (JFile::exists($file))
{
JFile::delete($file);
}
}
}
}
/**
* @param $path
* @param array $ignore
*
* @since Kunena
*/
public function deleteFolders($path, $ignore = array())
{
$ignore = array_merge($ignore, array('.git', '.svn', 'CVS', '.DS_Store', '__MACOSX'));
if (Folder::exists($path))
{
foreach (Folder::folders($path, '.', false, true, $ignore) as $folder)
{
if (Folder::exists($folder))
{
Folder::delete($folder);
}
}
}
}
/**
* @param $path
* @param array $ignore
*
* @since Kunena
*/
public function deleteFolder($path, $ignore = array())
{
$this->deleteFiles($path, $ignore);
$this->deleteFolders($path, $ignore);
}
/**
* @throws Exception
* @throws KunenaInstallerException
* @throws KunenaSchemaException
* @since Kunena
*/
public function stepPrepare()
{
$results = array();
$this->setVersion(null);
$this->setAvatarStatus();
$this->setAttachmentStatus();
$this->addStatus(Text::_('COM_KUNENA_INSTALL_STEP_PREPARE'), true);
$cache = \Joomla\CMS\Cache\Cache::getInstance();
$cache->clean('kunena');
$action = $this->getAction();
if ($action == 'install' || $action == 'migrate')
{
// Let's start from clean database
$this->deleteTables('kunena_');
$this->deleteMenu();
}
$installed = $this->getDetectVersions();
if ($action == 'migrate' && $installed['fb']->component)
{
$version = $installed['fb'];
$results [] = $this->migrateTable($version->prefix, $version->prefix . 'version', 'kunena_version');
}
else
{
$version = $installed['kunena'];
}
$this->setVersion($version);
// Always enable the System - Kunena plugin
$query = $this->db->getQuery(true);
$query->clear()
->update($this->db->quoteName('#__extensions'))
->set($this->db->quoteName('enabled') . ' = 1')
->where($this->db->quoteName('type') . ' = ' . $this->db->quote('plugin'))
->where($this->db->quoteName('folder') . ' = ' . $this->db->quote('system'))
->where($this->db->quoteName('element') . ' = ' . $this->db->quote('kunena'));
$this->db->setQuery($query);
$this->db->execute();
require_once KUNENA_INSTALLER_PATH . '/schema.php';
$schema = new KunenaModelSchema;
$results[] = $schema->updateSchemaTable('kunena_version');
// Insert data from the old version, if it does not exist in the version table
if ($version->id == 0 && $version->component)
{
$this->insertVersionData($version->version, $version->versiondate, $version->versionname, null);
}
/*
foreach ( $results as $result )
if (!empty($result['action']) && empty($result['success']))
$this->addStatus ( Text::_('COM_KUNENA_INSTALL_'.strtoupper($result['action'])) . ' ' . $result ['name'], $result ['success'] );
*/
$this->insertVersion('migrateDatabase');
if (!$this->getInstallError())
{
$this->setStep($this->getStep() + 1);
}
$this->checkTimeout(true);
}
/**
* @since Kunena
* @throws Exception
*/
public function stepExtract()
{
$path = JPATH_ADMINISTRATOR . '/components/com_kunena/archive';
if (KunenaForum::isDev() || !is_file("{$path}/fileformat"))
{
// Git install
$dir = JPATH_ADMINISTRATOR . '/components/com_kunena/media/kunena';
if (is_dir($dir))
{
JFolder::copy($dir, KUNENA_INSTALLER_MEDIAPATH, false, true);
}
$this->setStep($this->getStep() + 1);
return;
}
$ext = file_get_contents("{$path}/fileformat");
static $files = array(
array('name' => 'com_kunena-admin', 'dest' => KUNENA_INSTALLER_ADMINPATH),
array('name' => 'com_kunena-site', 'dest' => KUNENA_INSTALLER_SITEPATH),
array('name' => 'com_kunena-media', 'dest' => KUNENA_INSTALLER_MEDIAPATH),
);
static $ignore = array(
KUNENA_INSTALLER_ADMINPATH => array('index.html', 'kunena.xml', 'kunena.j25.xml', 'kunena.php', 'api.php', 'archive', 'install', 'language'),
KUNENA_INSTALLER_SITEPATH => array('index.html', 'kunena.php', 'router.php', 'COPYRIGHT.php', 'template', 'language'),
);
$task = $this->getTask();
// Extract archive files
if (isset($files[$task]))
{
$file = $files[$task];
if (is_file("{$path}/{$file['name']}{$ext}"))
{
$dest = $file['dest'];
if (!empty($ignore[$dest]))
{
// Delete all files and folders (cleanup)
$this->deleteFolder($dest, $ignore[$dest]);
if ($dest == KUNENA_INSTALLER_SITEPATH)
{
$this->deleteFolder("$dest/template/crypsis", array('params.ini', 'custom.css', 'custom.less'));
}
}
// Copy new files into folder
$this->extract($path, $file['name'] . $ext, $dest, KunenaForum::isDev());
}
$this->setTask($task + 1);
}
else
{
if (function_exists('apc_clear_cache'))
{
@apc_clear_cache('system');
}
// Force page reload to avoid MySQL timeouts after extracting
$this->checkTimeout(true);
if (!$this->getInstallError())
{
$this->setStep($this->getStep() + 1);
}
}
}
/**
* @since Kunena
* @throws Exception
*/
public function stepPlugins()
{
$this->installPlugin('plugins/plg_finder_kunena', 'finder', 'kunena', false, 1);
$this->installPlugin('plugins/plg_kunena_altauserpoints', 'kunena', 'altauserpoints', false, 2);
$this->installPlugin('plugins/plg_kunena_community', 'kunena', 'community', false, 3);
$this->installPlugin('plugins/plg_kunena_comprofiler', 'kunena', 'comprofiler', false, 4);
$this->installPlugin('plugins/plg_kunena_easyprofile', 'kunena', 'easyprofile', false, 5);
$this->installPlugin('plugins/plg_kunena_easysocial', 'kunena', 'easysocial', false, 6);
$this->installPlugin('plugins/plg_kunena_gravatar', 'kunena', 'gravatar', false, 7);
$this->installPlugin('plugins/plg_kunena_uddeim', 'kunena', 'uddeim', false, 8);
$this->installPlugin('plugins/plg_kunena_kunena', 'kunena', 'kunena', true, 9);
$this->installPlugin('plugins/plg_kunena_joomla', 'kunena', 'joomla', true, 10);
$this->installPlugin('plugins/plg_kunena_finder', 'kunena', 'finder', false, 11);
if (is_file(JPATH_ROOT . '/plugins/kunena/alphauserpoints/avatar.php'))
{
$this->uninstallPlugin('kunena', 'alphauserpoints');
}
if (function_exists('apc_clear_cache'))
{
@apc_clear_cache('system');
}
if (!$this->getInstallError())
{
$this->setStep($this->getStep() + 1);
}
}
/**
* @throws Exception
* @throws KunenaInstallerException
* @throws KunenaSchemaException
* @since Kunena
*/
public function stepDatabase()
{
$task = $this->getTask();
switch ($task)
{
case 0:
if ($this->migrateDatabase())
{
$this->setTask($task + 1);
}
break;
case 1:
if ($this->installDatabase())
{
$this->setTask($task + 1);
}
break;
case 2:
if ($this->upgradeDatabase())
{
$this->setTask($task + 1);
}
break;
case 3:
if ($this->installSampleData())
{
$this->setTask($task + 1);
}
break;
case 4:
if ($this->migrateCategoryImages())
{
$this->setTask($task + 1);
}
break;
case 5:
if ($this->migrateAvatars())
{
$this->setTask($task + 1);
}
break;
case 6:
if ($this->migrateAvatarGalleries())
{
$this->setTask($task + 1);
}
break;
case 7:
if ($this->migrateAttachments())
{
$this->setTask($task + 1);
}
break;
case 8:
if ($this->recountCategories())
{
$this->setTask($task + 1);
}
break;
case 9:
if ($this->recountThankyou())
{
$this->setTask($task + 1);
}
break;
default:
if (!$this->getInstallError())
{
$this->setStep($this->getStep() + 1);
}
}
}
/**
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function stepFinish()
{
KunenaForum::setup();
$lang = Factory::getLanguage();
$lang->load('com_kunena', JPATH_SITE) || $lang->load('com_kunena', KUNENA_INSTALLER_SITEPATH);
$this->createMenu();
// Fix broken category aliases (workaround for < 2.0-DEV12 bug)
KunenaForumCategoryHelper::fixAliases();
// Clean cache, just in case
KunenaMenuHelper::cleanCache();
/** @var \Joomla\CMS\Cache\Cache | \Joomla\CMS\Cache\CacheController $cache */
$cache = Factory::getCache();
$cache->clean('com_kunena');
// Delete installer file (only if not using GIT build).
if (!KunenaForum::isDev())
{
JFile::delete(KPATH_ADMIN . '/install.php');
}
// Set Crypsis as default template when do update
$config = KunenaFactory::getConfig();
if ($config->template == 'blue_eagle')
{
$config->template = 'crypsis';
$config->save();
}
// Resync bbcode plugins
$editor = KunenaBbcodeEditor::getInstance();
$editor->initializeHMVC();
if (!$this->getInstallError())
{
$this->updateVersionState('');
$this->addStatus(Text::_('COM_KUNENA_INSTALL_SUCCESS'), true, '');
$this->setStep($this->getStep() + 1);
}
}
// TODO: move to migration
/**
* @return bool
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function migrateDatabase()
{
$version = $this->getVersion();
if (!empty($version->prefix))
{
// Migrate all tables from old installation
$app = Factory::getApplication();
$state = $app->getUserState('com_kunena.install.dbstate', null);
// First run: find tables that potentially need migration
if ($state === null)
{
$state = $this->listTables($version->prefix);
}
// Handle only first table in the list
$oldtable = array_shift($state);
if ($oldtable)
{
$newtable = preg_replace('/^' . $version->prefix . '/i', 'kunena_', $oldtable);
$result = $this->migrateTable($version->prefix, $oldtable, $newtable);
if ($result)
{
$this->addStatus(ucfirst($result ['action']) . ' ' . $result ['name'], true);
}
// Save user state with remaining tables
$app->setUserState('com_kunena.install.dbstate', $state);
// Database migration continues
return false;
}
else
{
// Reset user state
$this->updateVersionState('installDatabase');
$app->setUserState('com_kunena.install.dbstate', null);
}
}
// Database migration complete
return true;
}
/**
* @return bool
* @throws Exception
* @throws KunenaInstallerException
* @throws KunenaSchemaException
* @since Kunena
*/
public function installDatabase()
{
static $schema = null;
static $create = null;
static $tables = null;
if ($schema === null)
{
// Run only once: get table creation SQL and existing tables
require_once KUNENA_INSTALLER_PATH . '/schema.php';
$schema = new KunenaModelSchema();
$create = $schema->getCreateSQL();
$tables = $this->listTables('kunena_', true);
}
$app = Factory::getApplication();
$state = $app->getUserState('com_kunena.install.dbstate', null);
// First run: get all tables
if ($state === null)
{
$state = array_keys($create);
}
// Handle only first table in the list
$table = array_shift($state);
if ($table)
{
if (!isset($tables[$table]))
{
$result = $schema->updateSchemaTable($table);
if ($result)
{
$this->addStatus(Text::_('COM_KUNENA_INSTALL_CREATE') . ' ' . $result ['name'], $result ['success']);
}
}
// Save user state with remaining tables
$app->setUserState('com_kunena.install.dbstate', $state);
// Database install continues
return false;
}
else
{
// Reset user state
$this->updateVersionState('upgradeDatabase');
$app->setUserState('com_kunena.install.dbstate', null);
}
// Database install complete
return true;
}
// TODO: move to migration
/**
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function migrateConfig()
{
$config = KunenaFactory::getConfig();
$version = $this->getVersion();
// Migrate configuration from FB < 1.0.5
if (version_compare($version->version, '1.0.4', "<="))
{
$file = JPATH_ADMINISTRATOR . '/components/com_fireboard/fireboard_config.php';
if (is_file($file))
{
require_once $file;
if (isset($fbConfig))
{
$fbConfig = (array) $fbConfig;
$config->bind($fbConfig);
$config->id = 1;
}
}
}
// Migrate configuration from FB 1.0.5 and Kunena 1.0-1.7
if (!$config->id && !empty($version->prefix))
{
$tables = $this->listTables($version->prefix);
$cfgtable = "{$version->prefix}config";
if (isset($tables[$cfgtable]))
{
$this->db->setQuery("SELECT * FROM #__{$cfgtable}");
$config->bind((array) $this->db->loadAssoc());
$config->id = 1;
}
}
$config->save();
}
/**
* @return bool
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function upgradeDatabase()
{
static $xml = null;
// If there's no version installed, there's nothing to do
$curversion = $this->getVersion();
if (!$curversion->component)
{
return true;
}
if ($xml === null)
{
// Run only once: Get migration SQL from our XML file
$xml = simplexml_load_file(KUNENA_INSTALLER_PATH . '/kunena.install.upgrade.xml');
}
if ($xml === false)
{
$this->addStatus(Text::_('COM_KUNENA_INSTALL_DB_UPGRADE_FAILED_XML'), false, '', 'upgrade');
}
$app = Factory::getApplication();
$state = $app->getUserState('com_kunena.install.dbstate', null);
// First run: initialize state and migrate configuration
if ($state === null)
{
$state = array();
// Migrate configuration from FB <1.0.5, otherwise update it
$this->migrateConfig();
}
// Allow queries to fail
//$this->db->setDebug(false);
foreach ($xml->upgrade[0] as $version)
{
// If we have already upgraded to this version, continue to the next one
$vernum = (string) $version['version'];
if (!empty($state[$vernum]))
{
continue;
}
// Update state
$state[$vernum] = 1;
if ($version['version'] == '@' . 'kunenaversion' . '@')
{
$git = 1;
$vernum = KunenaForum::version();
}
if (isset($git) || version_compare(strtolower($version['version']), strtolower($curversion->version), '>'))
{
foreach ($version as $action)
{
$result = $this->processUpgradeXMLNode($action);
if ($result)
{
$this->addStatus($result ['action'] . ' ' . $result ['name'], $result ['success']);
}
}
$this->addStatus(Text::sprintf('COM_KUNENA_INSTALL_VERSION_UPGRADED', $vernum), true, '', 'upgrade');
// Save user state with remaining tables
$app->setUserState('com_kunena.install.dbstate', $state);
// Database install continues
return false;
}
}
// Reset user state
$this->updateVersionState('InstallSampleData');
$app->setUserState('com_kunena.install.dbstate', null);
// Database install complete
return true;
}
/**
* @param $action
*
* @return array|mixed|null
* @since Kunena
*/
public function processUpgradeXMLNode($action)
{
$result = null;
$nodeName = $action->getName();
$mode = strtolower((string) $action['mode']);
$success = false;
switch ($nodeName)
{
case 'phpfile':
$filename = $action['name'];
$include = KUNENA_INSTALLER_PATH . "/sql/updates/php/{$filename}.php";
$function = 'kunena_' . strtr($filename, array('.' => '', '-' => '_'));
if (is_file($include))
{
require $include;
if (is_callable($function))
{
$result = call_user_func($function, $this);
if (is_array($result))
{
$success = $result['success'];
}
else
{
$success = true;
}
}
}
if (!$success && !$result)
{
$result = array('action' => Text::_('COM_KUNENA_INSTALL_INCLUDE_STATUS'), 'name' => $filename . '.php', 'success' => $success);
}
break;
case 'query':
$query = (string) $action;
$this->db->setQuery($query);
$success = true;
try
{
$this->db->execute();
}
catch (Exception $e)
{
$success = false;
}
if ($action['mode'] == 'silenterror' || !$this->db->getAffectedRows() || $success)
{
$result = null;
}
else
{
$result = array('action' => 'SQL Query: ' . $query, 'name' => '', 'success' => $success);
}
break;
default:
$result = array('action' => 'fail', 'name' => $nodeName, 'success' => false);
}
return $result;
}
/**
* @return bool
*
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function installSampleData()
{
require_once KUNENA_INSTALLER_PATH . '/sql/install/php/sampledata.php';
if (installSampleData())
{
$this->addStatus(Text::_('COM_KUNENA_INSTALL_SAMPLEDATA'), true);
}
$db = Factory::getDBO();
$query = "ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `created` datetime NOT NULL default
'1000-01-01 00:00:00'";
$db->setQuery($query);
$db->execute();
$query = "ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `publish_up` datetime NOT NULL default
'1000-01-01 00:00:00'";
$db->setQuery($query);
$db->execute();
$query = "ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `publish_down` datetime NOT NULL default
'1000-01-01 00:00:00'";
$db->setQuery($query);
$db->execute();
$query = "ALTER TABLE `#__kunena_categories` MODIFY COLUMN `checked_out_time` datetime NOT NULL default
'1000-01-01 00:00:00'";
$db->setQuery($query);
$db->execute();
$query = "ALTER TABLE `#__kunena_polls_users` MODIFY COLUMN `lasttime` datetime NOT NULL default
'1000-01-01 00:00:00'";
$db->setQuery($query);
$db->execute();
$query = "UPDATE `#__kunena_categories` SET checked_out_time='1000-01-01 00:00:00' WHERE checked_out_time='0000-00-00 00:00:00'";
$db->setQuery($query);
$db->execute();
return true;
}
// TODO: move to migration
/**
* @param null $stats
*
* @throws Exception
* @since Kunena
*/
protected function setAvatarStatus($stats = null)
{
if (!$stats)
{
$stats = new stdClass;
$stats->current = $stats->migrated = $stats->failed = $stats->missing = 0;
}
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.avatars', $stats);
}
// TODO: move to migration
/**
* @return mixed|stdClass
* @throws Exception
* @since Kunena
*/
protected function getAvatarStatus()
{
$app = Factory::getApplication();
$stats = new stdClass;
$stats->current = $stats->migrated = $stats->failed = $stats->missing = 0;
$stats = $app->getUserState('com_kunena.install.avatars', $stats);
return $stats;
}
// TODO: move to migration
/**
* @return bool
*
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function migrateAvatars()
{
$stats = $this->getAvatarStatus();
static $dirs = array(
'media/kunena/avatars',
'images/fbfiles/avatars',
'components/com_fireboard/avatars',
);
$query = "SELECT COUNT(*) FROM `#__kunena_users`
WHERE userid>{$this->db->quote($stats->current)} AND avatar != '' AND avatar NOT LIKE 'gallery/%' AND avatar NOT LIKE 'users/%'";
$this->db->setQuery($query);
try
{
$count = $this->db->loadResult();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
if (!$stats->current && !$count)
{
return true;
}
$query = "SELECT userid, avatar FROM `#__kunena_users`
WHERE userid>{$this->db->quote($stats->current)} AND avatar != '' AND avatar NOT LIKE 'gallery/%' AND avatar NOT LIKE 'users/%'";
$this->db->setQuery($query, 0, 1023);
try
{
$users = $this->db->loadObjectList();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
foreach ($users as $user)
{
$userid = $stats->current = $user->userid;
$avatar = $user->avatar;
$count--;
$file = $newfile = '';
foreach ($dirs as $dir)
{
if (!JFile::exists(JPATH_ROOT . "/$dir/$avatar"))
{
continue;
}
$file = JPATH_ROOT . "/$dir/$avatar";
break;
}
if ($file)
{
$file = JPath::clean($file, '/');
// Make sure to copy only supported fileformats
$match = preg_match('/\.(gif|jpg|jpeg|png)$/ui', $file, $matches);
if ($match)
{
$ext = Joomla\String\StringHelper::strtolower($matches[1]);
// Use new format: users/avatar62.jpg
$newfile = "users/avatar{$userid}.{$ext}";
$destpath = (KUNENA_INSTALLER_MEDIAPATH . "/avatars/{$newfile}");
if (JFile::exists($destpath))
{
$success = true;
}
else
{
@chmod($file, 0644);
$success = JFile::copy($file, $destpath);
}
if ($success)
{
$stats->migrated++;
}
else
{
$this->addStatus("User: {$userid}, Avatar copy failed: {$file} to {$destpath}", true);
$stats->failed++;
}
}
else
{
$this->addStatus("User: {$userid}, Avatar type not supported: {$file}", true);
$stats->failed++;
$success = true;
}
}
else
{
// $this->addStatus ( "User: {$userid}, Avatar file was not found: {$avatar}", true );
$stats->missing++;
$success = true;
}
if ($success)
{
$query = "UPDATE `#__kunena_users` SET avatar={$this->db->quote($newfile)} WHERE userid={$this->db->quote($userid)}";
$this->db->setQuery($query);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
}
if ($this->checkTimeout())
{
break;
}
}
$this->setAvatarStatus($stats);
if ($count)
{
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_AVATARS', $count), true, '', 'avatar');
}
else
{
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_AVATARS_DONE', $stats->migrated, $stats->missing, $stats->failed), true, '', 'avatar');
}
return !$count;
}
// TODO: move to migration
/**
* @return bool
*
* @throws Exception
* @since Kunena
*/
public function migrateAvatarGalleries()
{
$action = $this->getAction();
if ($action != 'migrate')
{
return true;
}
$srcpath = JPATH_ROOT . '/images/fbfiles/avatars/gallery';
$dstpath = KUNENA_INSTALLER_MEDIAPATH . '/avatars/gallery';
if (JFolder::exists($srcpath))
{
if (!JFolder::delete($dstpath) || !JFolder::copy($srcpath, $dstpath))
{
$this->addStatus("Could not copy avatar galleries from $srcpath to $dstpath", true);
}
else
{
$this->addStatus(Text::_('COM_KUNENA_MIGRATE_AVATAR_GALLERY'), true);
}
}
return true;
}
// TODO: move to migration
/**
* @return bool
*
* @throws Exception
* @since Kunena
*/
public function migrateCategoryImages()
{
$action = $this->getAction();
if ($action != 'migrate')
{
return true;
}
$srcpath = JPATH_ROOT . '/images/fbfiles/category_images';
$dstpath = KUNENA_INSTALLER_MEDIAPATH . '/category_images';
if (JFolder::exists($srcpath))
{
if (!JFolder::delete($dstpath) || !JFolder::copy($srcpath, $dstpath))
{
$this->addStatus("Could not copy category images from $srcpath to $dstpath", true);
}
else
{
$this->addStatus(Text::_('COM_KUNENA_MIGRATE_CATEGORY_IMAGES'), true);
}
}
return true;
}
// TODO: move to migration
/**
* @param null $stats
*
* @throws Exception
* @since Kunena
*/
protected function setAttachmentStatus($stats = null)
{
if (!$stats)
{
$stats = new stdClass;
$stats->current = $stats->migrated = $stats->failed = $stats->missing = 0;
}
$app = Factory::getApplication();
$app->setUserState('com_kunena.install.attachments', $stats);
}
// TODO: move to migration
/**
* @return mixed|stdClass
*
* @throws Exception
* @since Kunena
*/
protected function getAttachmentStatus()
{
$app = Factory::getApplication();
$stats = new stdClass;
$stats->current = $stats->migrated = $stats->failed = $stats->missing = 0;
$stats = $app->getUserState('com_kunena.install.attachments', $stats);
return $stats;
}
// TODO: move to migration
/**
* @return bool
*
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function migrateAttachments()
{
// Only perform this stage if we are upgrading from older version
$version = $this->getVersion();
if (version_compare($version->version, '1.7.0', ">"))
{
return true;
}
$stats = $this->getAttachmentStatus();
static $dirs = array(
'images/fbfiles/attachments',
'components/com_fireboard/uploaded',
'media/kunena/attachments/legacy',
);
$query = "SELECT COUNT(*) FROM `#__kunena_attachments`
WHERE id>{$this->db->quote($stats->current)} AND hash IS NULL";
$this->db->setQuery($query);
try
{
$count = $this->db->loadResult();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
if (!$stats->current && !$count)
{
return true;
}
$destpath = KUNENA_INSTALLER_MEDIAPATH . '/attachments/legacy';
if (!JFolder::exists($destpath . '/images'))
{
if (!JFolder::create($destpath . '/images'))
{
$this->addStatus("Could not create directory for legacy attachments in {$destpath}/images", true);
return true;
}
}
if (!JFolder::exists($destpath . '/files'))
{
if (!JFolder::create($destpath . '/files'))
{
$this->addStatus("Could not create directory for legacy attachments in {$destpath}/files", true);
return true;
}
}
$query = "SELECT * FROM `#__kunena_attachments`
WHERE id>{$this->db->quote($stats->current)} AND hash IS NULL";
$this->db->setQuery($query, 0, 251);
try
{
$attachments = $this->db->loadObjectList();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
foreach ($attachments as $attachment)
{
$stats->current = $attachment->id;
$count--;
if (preg_match('|/images$|', $attachment->folder))
{
$lastpath = 'images';
$attachment->filetype = 'image/' . strtolower($attachment->filetype);
}
else
{
if (preg_match('|/files$|', $attachment->folder))
{
$lastpath = 'files';
}
else
{
// Only process files in legacy locations, either in original folders or manually copied into /media/kunena/attachments/legacy
continue;
}
}
$file = '';
if (JFile::exists(JPATH_ROOT . "/{$attachment->folder}/{$attachment->filename}"))
{
$file = JPATH_ROOT . "/{$attachment->folder}/{$attachment->filename}";
}
else
{
foreach ($dirs as $dir)
{
if (JFile::exists(JPATH_ROOT . "/{$dir}/{$lastpath}/{$attachment->filename}"))
{
$file = JPATH_ROOT . "/{$dir}/{$lastpath}/{$attachment->filename}";
break;
}
}
}
$success = false;
$destfile = null;
if ($file)
{
$file = JPath::clean($file, '/');
$destfile = "{$destpath}/{$lastpath}/{$attachment->filename}";
if (JFile::exists($destfile))
{
$success = true;
}
else
{
@chmod($file, 0644);
$success = JFile::copy($file, $destfile);
}
if ($success)
{
$stats->migrated++;
}
else
{
$this->addStatus("Attachment copy failed: {$file} to {$destfile}", true);
$stats->failed++;
}
}
else
{
// $this->addStatus ( "Attachment file was not found: {$file}", true );
$stats->missing++;
}
if ($success && $destfile)
{
clearstatcache();
$stat = stat($destfile);
$size = (int) $stat['size'];
$hash = md5_file($destfile);
$query = "UPDATE `#__kunena_attachments` SET folder='media/kunena/attachments/legacy/{$lastpath}', size={$this->db->quote($size)}, hash={$this->db->quote($hash)}, filetype={$this->db->quote($attachment->filetype)}
WHERE id={$this->db->quote($attachment->id)}";
$this->db->setQuery($query);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
}
if ($this->checkTimeout())
{
break;
}
}
$this->setAttachmentStatus($stats);
if ($count)
{
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_ATTACHMENTS', $count), true, '', 'attach');
}
else
{
// Note: com_fireboard has been replaced by com_kunena during 1.0.8 upgrade, use it instead
$query = "UPDATE `#__kunena_messages_text` SET message = REPLACE(REPLACE(message, '/images/fbfiles', '/media/kunena/attachments/legacy'), '/components/com_kunena/uploaded', '/media/kunena/attachments/legacy');";
$this->db->setQuery($query);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_ATTACHMENTS_DONE', $stats->migrated, $stats->missing, $stats->failed), true, '', 'attach');
}
return !$count;
}
/**
* @return bool
*
* @throws Exception
* @since Kunena
*/
public function recountCategories()
{
$app = Factory::getApplication();
$state = $app->getUserState('com_kunena.install.recount', null);
// Only perform this stage if database needs recounting (upgrade from older version)
$version = $this->getVersion();
if (version_compare($version->version, '2.0.0-DEV', ">"))
{
return true;
}
if ($state === null)
{
// First run
$query = "SELECT MAX(id) FROM `#__kunena_messages`";
$this->db->setQuery($query);
$state = new stdClass;
$state->step = 0;
$state->maxId = (int) $this->db->loadResult();
$state->start = 0;
}
while (1)
{
$count = mt_rand(4500, 5500);
switch ($state->step)
{
case 0:
// Update topic statistics
KunenaForumTopicHelper::recount(false, $state->start, $state->start + $count);
$state->start += $count;
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_RECOUNT_TOPICS', min($state->start, $state->maxId), $state->maxId), true, '', 'recount');
break;
case 1:
// Update usertopic statistics
KunenaForumTopicUserHelper::recount(false, $state->start, $state->start + $count);
$state->start += $count;
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_RECOUNT_USERTOPICS', min($state->start, $state->maxId), $state->maxId), true, '', 'recount');
break;
case 2:
// Update user statistics
KunenaUserHelper::recount();
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_RECOUNT_USER'), true, '', 'recount');
break;
case 3:
// Update category statistics
KunenaForumCategoryHelper::recount();
$this->addStatus(Text::sprintf('COM_KUNENA_MIGRATE_RECOUNT_CATEGORY'), true, '', 'recount');
break;
default:
$app->setUserState('com_kunena.install.recount', null);
$this->addStatus(Text::_('COM_KUNENA_MIGRATE_RECOUNT_DONE'), true, '', 'recount');
return true;
}
if (!$state->start || $state->start > $state->maxId)
{
$state->step++;
$state->start = 0;
}
if ($this->checkTimeout(false, 14))
{
break;
}
}
$app->setUserState('com_kunena.install.recount', $state);
return false;
}
/**
* @return bool|null
*
* @throws KunenaInstallerException
* @since Kunena
*/
public function getVersionPrefix()
{
if ($this->_versionprefix !== false)
{
return $this->_versionprefix;
}
$match = $this->detectTable($this->_versiontablearray);
if (isset($match ['prefix']))
{
$this->_versionprefix = $match ['prefix'];
}
else
{
$this->_versionprefix = null;
}
return $this->_versionprefix;
}
// TODO: move to migration
/**
* @return array
*
* @throws KunenaInstallerException
* @since Kunena
*/
public function getDetectVersions()
{
if (!empty($this->_versions))
{
return $this->_versions;
}
$kunena = $this->getInstalledVersion('kunena_', $this->_kVersions);
$fireboard = $this->getInstalledVersion('fb_', $this->_fbVersions);
if (!empty($kunena->state))
{
$this->_versions['failed'] = $kunena;
$kunena = $this->getInstalledVersion('kunena_', $this->_kVersions, true);
if (version_compare($kunena->version, '1.6.0-ALPHA', "<"))
{
$kunena->ignore = true;
}
}
if ($kunena->component && empty($kunena->ignore))
{
$this->_versions['kunena'] = $kunena;
$migrate = false;
}
else
{
$migrate = $this->isMigration($kunena, $fireboard);
}
if (!empty($fireboard->component) && $migrate)
{
$this->_versions['fb'] = $fireboard;
}
if (empty($kunena->component))
{
$this->_versions['kunena'] = $kunena;
}
else
{
if (!empty($fireboard->component))
{
$uninstall = clone $fireboard;
$uninstall->action = 'RESTORE';
$this->_versions['uninstall'] = $uninstall;
}
else
{
$uninstall = clone $kunena;
$uninstall->action = 'UNINSTALL';
$this->_versions['uninstall'] = $uninstall;
}
}
foreach ($this->_versions as $version)
{
$version->label = $this->getActionText($version);
$version->description = $this->getActionText($version, 'desc');
$version->hint = $this->getActionText($version, 'hint');
$version->warning = $this->getActionText($version, 'warn');
$version->link = Uri::base(true) . '/index.php?option=com_kunena&view=install&task=' . strtolower($version->action) . '&' . Session::getFormToken() . '=1';
}
if ($migrate)
{
$kunena->warning = $this->getActionText($fireboard, 'warn', 'upgrade');
}
else
{
$kunena->warning = '';
}
return $this->_versions;
}
/**
* @param $new
* @param $old
*
* @return bool
*
* @throws KunenaInstallerException
* @since Kunena
*/
public function isMigration($new, $old)
{
// If K1.6 not installed: migrate
if (!$new->component || !$this->detectTable($new->prefix . 'messages'))
{
return true;
}
// If old not installed: upgrade
if (!$old->component || !$this->detectTable($old->prefix . 'messages'))
{
return false;
}
// If K1.6 is installed and old is not Kunena: upgrade
if ($old->component != 'Kunena')
{
return false;
}
// User is currently using K1.6: upgrade
if (strtotime($new->installdate) > strtotime($old->installdate))
{
return false;
}
// User is currently using K1.0/K1.5: migrate
if (strtotime($new->installdate) < strtotime($old->installdate))
{
return true;
}
// Both K1.5 and K1.6 were installed during the same day.. Not going to be easy choice..
// Let's assume that this could be migration
return true;
}
// TODO: move to migration
/**
* @param $prefix
* @param $versionlist
* @param bool $state
*
* @return mixed|null|StdClass
*
* @throws KunenaInstallerException
* @since Kunena
*/
public function getInstalledVersion($prefix, $versionlist, $state = false)
{
if (!$state && isset($this->_installed[$prefix]))
{
return $this->_installed[$prefix];
}
if ($prefix === null)
{
$versionprefix = $this->getVersionPrefix();
}
else
{
if ($this->detectTable($prefix . 'version'))
{
$versionprefix = $prefix;
}
else
{
$versionprefix = null;
}
}
if ($versionprefix)
{
// Version table exists, try to get installed version
$state = $state ? " WHERE state=''" : "";
$this->db->setQuery("SELECT * FROM " . $this->db->quoteName($this->db->getPrefix() . $versionprefix . 'version') . $state . " ORDER BY `id` DESC", 0, 1);
try
{
$version = $this->db->loadObject();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
if ($version)
{
$version->version = strtolower($version->version);
$version->prefix = $versionprefix;
if (version_compare($version->version, '1.0.5', ">"))
{
$version->component = 'Kunena';
}
else
{
$version->component = 'FireBoard';
}
$version->version = strtoupper($version->version);
// Version table may contain dummy version.. Ignore it
if (!$version || version_compare($version->version, '0.1.0', "<"))
{
unset($version);
}
}
}
if (!isset($version))
{
// No version found -- try to detect version by searching some missing fields
$match = $this->detectTable($versionlist);
// Clean install
if (empty($match))
{
return $this->_installed = null;
}
// Create version object
$version = new StdClass;
$version->id = 0;
$version->component = $match ['component'];
$version->version = strtoupper($match ['version']);
$version->versiondate = $match ['date'];
$version->installdate = '';
$version->versionname = '';
$version->prefix = $match ['prefix'];
}
$version->action = $this->getInstallAction($version);
return $this->_installed[$prefix] = $version;
}
/**
* @param string $state
*
* @throws KunenaInstallerException
* @since Kunena
*/
protected function insertVersion($state = 'beginInstall')
{
// Insert data from the new version
$this->insertVersionData(KunenaForum::version(), KunenaForum::versionDate(), KunenaForum::versionName(), $state);
}
/**
* @param $state
*
* @throws KunenaInstallerException
* @since Kunena
*/
protected function updateVersionState($state)
{
// Insert data from the new version
$this->db->setQuery("UPDATE " . $this->db->quoteName($this->db->getPrefix() . 'kunena_version') . " SET state = " . $this->db->Quote($state) . " ORDER BY id DESC LIMIT 1");
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
}
/**
* @param $version
* @param string $type
* @param null $action
*
* @return string
*
* @since Kunena
*/
public function getActionText($version, $type = '', $action = null)
{
/* Translations generated:
Installation types: COM_KUNENA_INSTALL_UPGRADE, COM_KUNENA_INSTALL_DOWNGRADE, COM_KUNENA_INSTALL_REINSTALL,
COM_KUNENA_INSTALL_MIGRATE, COM_KUNENA_INSTALL_INSTALL, COM_KUNENA_INSTALL_UNINSTALL, COM_KUNENA_INSTALL_RESTORE
Installation descriptions: COM_KUNENA_INSTALL_UPGRADE_DESC, COM_KUNENA_INSTALL_DOWNGRADE_DESC, COM_KUNENA_INSTALL_REINSTALL_DESC,
COM_KUNENA_INSTALL_MIGRATE_DESC, COM_KUNENA_INSTALL_INSTALL_DESC, COM_KUNENA_INSTALL_UNINSTALL_DESC, COM_KUNENA_INSTALL_RESTORE_DESC
Installation hints: COM_KUNENA_INSTALL_UPGRADE_HINT, COM_KUNENA_INSTALL_DOWNGRADE_HINT, COM_KUNENA_INSTALL_REINSTALL_HINT,
COM_KUNENA_INSTALL_MIGRATE_HINT, COM_KUNENA_INSTALL_INSTALL_HINT, COM_KUNENA_INSTALL_UNINSTALL_HINT, COM_KUNENA_INSTALL_RESTORE_HINT
Installation warnings: COM_KUNENA_INSTALL_UPGRADE_WARN, COM_KUNENA_INSTALL_DOWNGRADE_WARN,
COM_KUNENA_INSTALL_MIGRATE_WARN, COM_KUNENA_INSTALL_UNINSTALL_WARN, COM_KUNENA_INSTALL_RESTORE_WARN
*/
static $search = array('#COMPONENT_OLD#', '#VERSION_OLD#', '#VERSION#');
$replace = array($version->component, $version->version, KunenaForum::version());
if (!$action)
{
$action = $version->action;
}
if ($type == 'warn' && ($action == 'INSTALL' || $action == 'REINSTALL'))
{
return '';
}
$str = '';
if ($type == 'hint' || $type == 'warn')
{
$str .= '<strong class="k' . $type . '">' . Text::_('COM_KUNENA_INSTALL_' . $type) . '</strong> ';
}
if ($action && $type)
{
$type = '_' . $type;
}
$str .= str_replace($search, $replace, Text::_('COM_KUNENA_INSTALL_' . $action . $type));
return $str;
}
/**
* @param null $version
*
* @return bool|string
*
* @since Kunena
*/
public function getInstallAction($version = null)
{
require_once __DIR__ . '/../api.php';
if ($version->component === null)
{
$this->_action = 'INSTALL';
}
else
{
if ($version->prefix != 'kunena_')
{
$this->_action = 'MIGRATE';
}
else
{
if (version_compare(strtolower(KunenaForum::version()), strtolower($version->version), '>'))
{
$this->_action = 'UPGRADE';
}
else
{
if (version_compare(strtolower(KunenaForum::version()), strtolower($version->version), '<'))
{
$this->_action = 'DOWNGRADE';
}
else
{
$this->_action = 'REINSTALL';
}
}
}
}
return $this->_action;
}
/**
* @param $detectlist
*
* @return array
*
* @throws KunenaInstallerException
* @since Kunena
*/
protected function detectTable($detectlist)
{
// Cache
static $tables = array();
static $fields = array();
$found = 0;
if (is_string($detectlist))
{
$detectlist = array(array('table' => $detectlist));
}
foreach ($detectlist as $detect)
{
// If no detection is needed, return current item
if (!isset($detect ['table']))
{
return $detect;
}
$table = $this->db->getPrefix() . $detect ['table'];
// Match if table exists
if (!isset($tables [$table])) // Not cached
{
$this->db->setQuery("SHOW TABLES LIKE " . $this->db->quote($table));
try
{
$result = $this->db->loadResult();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$tables [$table] = $result;
}
if (!empty($tables [$table]))
{
$found = 1;
}
// Match if column in a table exists
if ($found && isset($detect ['column']))
{
if (!isset($fields [$table])) // Not cached
{
$this->db->setQuery("SHOW COLUMNS FROM " . $this->db->quoteName($table));
try
{
$result = $this->db->loadObjectList('Field');
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$fields [$table] = $result;
}
if (!isset($fields [$table] [$detect ['column']]))
{
$found = 0;
}
}
if ($found)
{
return $detect;
}
}
return array();
}
// Helper function to migrate table
// TODO: move to migration
/**
* @param $oldprefix
* @param $oldtable
* @param $newtable
*
* @return array
*
* @throws KunenaInstallerException
* @since Kunena
*/
protected function migrateTable($oldprefix, $oldtable, $newtable)
{
$tables = $this->listTables('kunena_');
$oldtables = $this->listTables($oldprefix);
if ($oldtable == $newtable || !isset($oldtables [$oldtable]) || isset($tables [$newtable]))
{
return;
}
// Make identical copy from the table with new name
$create = $this->db->getTableCreate($this->db->getPrefix() . $oldtable);
$create = implode(' ', $create);
$collation = $this->db->getCollation();
if (!strstr($collation, 'utf8') && !strstr($collation, 'utf8mb4'))
{
$collation = 'utf8_general_ci';
}
if (strstr($collation, 'utf8mb4'))
{
$str = 'utf8mb4';
}
else
{
$str = 'utf8';
}
if (!$create)
{
return;
}
$create = preg_replace('/(DEFAULT )?CHARACTER SET [\w\d]+/', '', $create);
$create = preg_replace('/(DEFAULT )?CHARSET=[\w\d]+/', '', $create);
if (strstr($collation, 'utf8mb4'))
{
$create .= ' ENGINE=InnoDB';
}
else
{
$create = preg_replace('/TYPE\s*=?/', 'ENGINE=', $create);
}
$create .= " DEFAULT CHARACTER SET {$str} COLLATE {$collation}";
$query = preg_replace('/' . $this->db->getPrefix() . $oldtable . '/', $this->db->getPrefix() . $newtable, $create);
$this->db->setQuery($query);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$this->tables ['kunena_'] [$newtable] = $newtable;
// And copy data into it
$sql = "INSERT INTO " . $this->db->quoteName($this->db->getPrefix() . $newtable) . ' ' . $this->selectWithStripslashes($this->db->getPrefix() . $oldtable);
$this->db->setQuery($sql);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
return array('name' => $oldtable, 'action' => 'migrate', 'sql' => $sql);
}
// TODO: move to migration
/**
* @param $table
*
* @return string
*
* @since Kunena
*/
public function selectWithStripslashes($table)
{
$fields = $this->db->getTableColumns($table);
$select = array();
foreach ($fields as $field => $type)
{
$isString = preg_match('/text|char/', $type);
$select[] = ($isString ? "REPLACE(REPLACE(REPLACE({$this->db->quoteName($field)}, {$this->db->Quote('\\\\')}, {$this->db->Quote('\\')}),{$this->db->Quote('\\\'')} ,{$this->db->Quote('\'')}),{$this->db->Quote('\"')} ,{$this->db->Quote('"')}) AS " : '') . $this->db->quoteName($field);
}
$select = implode(', ', $select);
return "SELECT {$select} FROM {$table}";
}
/**
* @return array|null
*
* @throws KunenaInstallerException
* @since Kunena
*/
public function createVersionTable()
{
$tables = $this->listTables('kunena_');
if (isset($tables ['kunena_version']))
{
return;
} // Nothing to migrate
$collation = $this->db->getCollation();
if (!strstr($collation, 'utf8') && !strstr($collation, 'utf8mb4'))
{
$collation = 'utf8_general_ci';
}
if (strstr($collation, 'utf8mb4'))
{
$str = 'utf8mb4';
}
else
{
$str = 'utf8';
}
$query = "CREATE TABLE IF NOT EXISTS `" . $this->db->getPrefix() . "kunena_version` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`version` varchar(20) NOT NULL,
`versiondate` date NOT NULL,
`installdate` date NOT NULL,
`build` varchar(20) DEFAULT NULL,
`versionname` varchar(40) DEFAULT NULL,
`state` text DEFAULT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET {$str} COLLATE {$collation};";
$this->db->setQuery($query);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$this->tables ['kunena_'] ['kunena_version'] = 'kunena_version';
return array('action' => Text::_('COM_KUNENA_INSTALL_CREATE'), 'name' => 'kunena_version', 'sql' => $query);
}
// also insert old version if not in the table
/**
* @param $version
* @param $versiondate
* @param $versionname
* @param string $state
*
* @throws KunenaInstallerException
* @since Kunena
*/
protected function insertVersionData($version, $versiondate, $versionname, $state = '')
{
$this->db->setQuery("INSERT INTO `" . $this->db->getPrefix() . "kunena_version` SET
`version` = {$this->db->quote($version)},
`versiondate` = {$this->db->quote($versiondate)},
`installdate` = CURDATE(),
`versionname` = {$this->db->quote($versionname)},
`build` = {$this->db->quote($version)},
`state` = {$this->db->quote($state)}");
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
}
/**
* @param $prefix
* @param bool $reload
*
* @return mixed
*
* @throws KunenaInstallerException
* @since Kunena
*/
protected function listTables($prefix, $reload = false)
{
if (isset($this->tables [$prefix]) && !$reload)
{
return $this->tables [$prefix];
}
$this->db->setQuery("SHOW TABLES LIKE " . $this->db->quote($this->db->getPrefix() . $prefix . '%'));
try
{
$list = (array) $this->db->loadColumn();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$this->tables [$prefix] = array();
foreach ($list as $table)
{
$table = preg_replace('/^' . $this->db->getPrefix() . '/', '', $table);
$this->tables [$prefix] [$table] = $table;
}
return $this->tables [$prefix];
}
/**
* @param $prefix
*
* @throws KunenaInstallerException
* @since Kunena
*/
public function deleteTables($prefix)
{
$tables = $this->listTables($prefix);
foreach ($tables as $table)
{
$this->db->setQuery("DROP TABLE IF EXISTS " . $this->db->quoteName($this->db->getPrefix() . $table));
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
}
unset($this->tables [$prefix]);
}
/**
* Create a Joomla menu for the main
* navigation tab and publish it in the Kunena module position kunena_menu.
* In addition it checks if there is a link to Kunena in any of the menus
* and if not, adds a forum link in the mainmenu.
* @since Kunena
* @throws Exception
* @throws KunenaInstallerException
*/
public function createMenu()
{
$menu = array('name' => Text::_('COM_KUNENA_MENU_ITEM_FORUM'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_FORUM_ALIAS'), 'forum'),
'link' => 'index.php?option=com_kunena&view=home', 'access' => 1, 'params' => array('catids' => 0), );
$submenu = array(
'index' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_INDEX'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_INDEX_ALIAS'), 'index'),
'link' => 'index.php?option=com_kunena&view=category&layout=list', 'access' => 1, 'default' => 'categories', 'params' => array(), ),
'recent' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_RECENT'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_RECENT_ALIAS'), 'recent'),
'link' => 'index.php?option=com_kunena&view=topics&mode=replies', 'access' => 1, 'default' => 'recent', 'params' => array('topics_catselection' => '', 'topics_categories' => '', 'topics_time' => ''), ),
'unread' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_UNREAD'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_UNREAD_ALIAS'), 'unread'),
'link' => 'index.php?option=com_kunena&view=topics&layout=unread', 'access' => 2, 'params' => array(), ),
'newtopic' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_NEWTOPIC'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_NEWTOPIC_ALIAS'), 'newtopic'),
'link' => 'index.php?option=com_kunena&view=topic&layout=create', 'access' => 2, 'params' => array(), ),
'noreplies' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_NOREPLIES'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_NOREPLIES_ALIAS'), 'noreplies'),
'link' => 'index.php?option=com_kunena&view=topics&mode=noreplies', 'access' => 2, 'params' => array('topics_catselection' => '', 'topics_categories' => '', 'topics_time' => ''), ),
'mylatest' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_MYLATEST'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_MYLATEST_ALIAS'), 'mylatest'),
'link' => 'index.php?option=com_kunena&view=topics&layout=user&mode=default', 'access' => 2, 'default' => 'my', 'params' => array('topics_catselection' => '2', 'topics_categories' => '0', 'topics_time' => ''), ),
'profile' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_PROFILE'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_PROFILE_ALIAS'), 'profile'),
'link' => 'index.php?option=com_kunena&view=user', 'access' => 2, 'params' => array('integration' => 1), ),
'help' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_HELP'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_HELP_ALIAS'), 'help'),
'link' => 'index.php?option=com_kunena&view=misc', 'access' => 3, 'params' => array('body' => Text::_('COM_KUNENA_MENU_HELP_BODY'), 'body_format' => 'bbcode'), ),
'search' => array('name' => Text::_('COM_KUNENA_MENU_ITEM_SEARCH'), 'alias' => KunenaRoute::stringURLSafe(Text::_('COM_KUNENA_MENU_SEARCH_ALIAS'), 'search'),
'link' => 'index.php?option=com_kunena&view=search', 'access' => 1, 'params' => array(), ),
);
// Disable language debugging while creating menu items.
$lang = Factory::getLanguage();
//$debug = $lang->setDebug(false);
$this->createMenuJ25($menu, $submenu);
KunenaMenuHelper::cleanCache();
//$lang->setDebug($debug);
}
/**
* @param $menu
* @param $submenu
*
* @return bool
*
* @throws Exception
* @throws KunenaInstallerException
* @since Kunena
*/
public function createMenuJ25($menu, $submenu)
{
jimport('joomla.utilities.string');
jimport('joomla.application.component.helper');
$config = KunenaFactory::getConfig();
$component_id = \Joomla\CMS\Component\ComponentHelper::getComponent('com_kunena')->id;
// First fix all broken menu items
$query = "UPDATE #__menu SET component_id={$this->db->quote($component_id)} WHERE type = 'component' AND link LIKE '%option=com_kunena%'";
$this->db->setQuery($query);
try
{
$this->db->execute();
}
catch (Exception $e)
{
throw new KunenaInstallerException($e->getMessage(), $e->getCode());
}
$table = \Joomla\CMS\Table\Table::getInstance('MenuType');
$data = array(
'menutype' => 'kunenamenu',
'title' => Text::_('COM_KUNENA_MENU_TITLE'),
'description' => Text::_('COM_KUNENA_MENU_TITLE_DESC'),
);
if (!$table->bind($data) || !$table->check())
{
// Menu already exists, do nothing
return true;
}
if (!$table->store())
{
throw new KunenaInstallerException($table->getError());
}
$table = \Joomla\CMS\Table\Table::getInstance('menu');
$table->load(array('menutype' => 'kunenamenu', 'link' => $menu ['link']));
$paramdata = array('menu-anchor_title' => '',
'menu-anchor_css' => '',
'menu_image' => '',
'menu_text' => 1,
'page_title' => '',
'show_page_heading' => 0,
'page_heading' => '',
'pageclass_sfx' => '',
'menu-meta_description' => '',
'menu-meta_keywords' => '',
'robots' => '',
'secure' => 0, );
$gparams = new \Joomla\Registry\Registry($paramdata);
$params = clone $gparams;
$params->loadArray($menu['params']);
$data = array(
'menutype' => 'kunenamenu',
'title' => $menu ['name'],
'alias' => $menu ['alias'],
'link' => $menu ['link'],
'type' => 'component',
'published' => 1,
'parent_id' => 1,
'component_id' => $component_id,
'access' => $menu ['access'],
'params' => (string) $params,
'home' => 0,
'language' => '*',
'client_id' => 0,
);
$table->setLocation(1, 'last-child');
if (!$table->bind($data) || !$table->check() || !$table->store())
{
$table->alias = 'kunena';
if (!$table->check() || !$table->store())
{
throw new KunenaInstallerException($table->getError());
}
}
$parent = $table;
$defaultmenu = 0;
foreach ($submenu as $menuitem)
{
$params = clone $gparams;
$params->loadArray($menuitem['params']);
$table = \Joomla\CMS\Table\Table::getInstance('menu');
$table->load(array('menutype' => 'kunenamenu', 'link' => $menuitem ['link']));
$data = array(
'menutype' => 'kunenamenu',
'title' => $menuitem ['name'],
'alias' => $menuitem ['alias'],
'link' => $menuitem ['link'],
'type' => 'component',
'published' => 1,
'parent_id' => $parent->id,
'component_id' => $component_id,
'access' => $menuitem ['access'],
'params' => (string) $params,
'home' => 0,
'language' => '*',
'client_id' => 0,
);
$table->setLocation($parent->id, 'last-child');
if (!$table->bind($data) || !$table->check() || !$table->store())
{
throw new KunenaInstallerException($table->getError());
}
if (!$defaultmenu || (isset($menuitem ['default']) && $config->defaultpage == $menuitem ['default']))
{
$defaultmenu = $table->id;
}
}
// Update forum menuitem to point into default page
$parent->link .= "&defaultmenu={$defaultmenu}";
if (!$parent->check() || !$parent->store())
{
throw new KunenaInstallerException($table->getError());
}
// Finally create alias
$defaultmenu = \Joomla\CMS\Menu\AbstractMenu::getInstance('site')->getDefault();
if (!$defaultmenu)
{
return true;
}
$table = \Joomla\CMS\Table\Table::getInstance('menu');
$table->load(array('menutype' => $defaultmenu->menutype, 'type' => 'alias', 'title' => Text::_('COM_KUNENA_MENU_ITEM_FORUM')));
if (!$table->id)
{
$data = array(
'menutype' => $defaultmenu->menutype,
'title' => Text::_('COM_KUNENA_MENU_ITEM_FORUM'),
'alias' => 'kunena-' . Factory::getDate()->format('Y-m-d'),
'link' => 'index.php?Itemid=' . $parent->id,
'type' => 'alias',
'published' => 0,
'parent_id' => 1,
'component_id' => 0,
'access' => 1,
'params' => '{"aliasoptions":"' . (int) $parent->id . '","menu-anchor_title":"","menu-anchor_css":"","menu_image":""}',
'home' => 0,
'language' => '*',
'client_id' => 0,
);
$table->setLocation(1, 'last-child');
}
else
{
$data = array(
'alias' => 'kunena-' . Factory::getDate()->format('Y-m-d'),
'link' => 'index.php?Itemid=' . $parent->id,
'params' => '{"aliasoptions":"' . (int) $parent->id . '","menu-anchor_title":"","menu-anchor_css":"","menu_image":""}',
);
}
if (!$table->bind($data) || !$table->check() || !$table->store())
{
throw new KunenaInstallerException($table->getError());
}
return true;
}
/**
* @throws Exception
* @since Kunena
*/
public function deleteMenu()
{
$table = \Joomla\CMS\Table\Table::getInstance('MenuType');
$table->load(array('menutype' => 'kunenamenu'));
if ($table->id)
{
$success = $table->delete();
if (!$success)
{
Factory::getApplication()->enqueueMessage($table->getError(), 'error');
}
}
/** @var \Joomla\CMS\Cache\Cache|\Joomla\CMS\Cache\CacheController $cache */
$cache = Factory::getCache();
$cache->clean('mod_menu');
}
/**
* @param bool $stop
* @param int $timeout
*
* @return bool
* @since Kunena
*/
public function checkTimeout($stop = false, $timeout = 1)
{
static $start = null;
if ($stop)
{
$start = 0;
}
$time = microtime(true);
if ($start === null)
{
$start = $time;
return false;
}
if ($time - $start < $timeout)
{
return false;
}
return true;
}
/**
* @return bool
*
* @throws Exception
* @since Kunena
*/
public function recountThankyou()
{
//Only perform this action if upgrading form previous version
$version = $this->getVersion();
if (version_compare($version->version, '2.0.0-BETA2', ">"))
{
return true;
}
// If the migration is from previous version thant 1.6.0 doesn't need to recount
if (version_compare($version->version, '1.6.0', "<"))
{
return true;
}
KunenaForumMessageThankyouHelper::recount();
return true;
}
}
/**
* Class KunenaInstallerException
* @since Kunena
*/
class KunenaInstallerException extends Exception
{
}