Ð¤Ð°Ð¹Ð»Ð¾Ð²Ñ‹Ð¹ Ð¼ÐµÐ½ÐµÐ´Ð¶ÐµÑ€

Ð¤Ð°Ð¹Ð»Ð¾Ð²Ñ‹Ð¹ Ð¼ÐµÐ½ÐµÐ´Ð¶ÐµÑ€ - Ð ÐµÐ´Ð°ÐºÑ‚Ð¸Ñ€Ð¾Ð²Ð°Ñ‚ÑŒ - /var/www/html/install.zip

ÐÐ°Ð·Ð°Ð´
PK��!�K��default.xmlnu��[��<?xml version="1.0" encoding="UTF-8"?> <metadata> <layout title="COM_INSTALLER_INSTALL_VIEW_DEFAULT_TITLE"> <message> <![CDATA[COM_INSTALLER_INSTALL_VIEW_DEFAULT_DESC]]> </message> </layout> </metadata> PK��!�T�Z��default.phpnu��[��<?php /** * @package Joomla.Administrator * @subpackage com_installer * * @copyright (C) 2006 Open Source Matters, Inc. <https://www.joomla.org> * @license GNU General Public License version 2 or later; see LICENSE.txt / defined('_JEXEC') or die; use Joomla\CMS\Event\Installer\AddInstallationTabEvent; use Joomla\CMS\Factory; use Joomla\CMS\HTML\HTMLHelper; use Joomla\CMS\Language\Text; use Joomla\CMS\Router\Route; /* @var \Joomla\Component\Installer\Administrator\View\Install\HtmlView $this / // Load JavaScript message titles Text::script('ERROR'); Text::script('WARNING'); Text::script('NOTICE'); Text::script('MESSAGE'); Text::script('COM_INSTALLER_MSG_INSTALL_ENTER_A_URL'); /* @var Joomla\CMS\WebAsset\WebAssetManager $wa / $wa = $this->getDocument()->getWebAssetManager(); $wa->useScript('core') ->usePreset('com_installer.installer') ->useScript('webcomponent.core-loader'); $tabs = Factory::getApplication()->getDispatcher() ->dispatch('onInstallerAddInstallationTab', new AddInstallationTabEvent('onInstallerAddInstallationTab', [])) ->getArgument('result', []); ?> <div id="installer-install" class="clearfix"> <form enctype="multipart/form-data" action="<?php echo Route::_('index.php?option=com_installer&view=install'); ?>" method="post" name="adminForm" id="adminForm"> <?php // Render messages set by extension install scripts here ?> <?php if ($this->showMessage) : ?> <?php echo $this->loadTemplate('message'); ?> <?php endif; ?> <div class="row"> <div class="col-md-12"> <div id="j-main-container" class="j-main-container main-card"> <?php if (!$tabs) : ?> <div class="alert alert-warning"> <span class="icon-exclamation-circle" aria-hidden="true"></span><span class="visually-hidden"><?php echo Text::_('WARNING'); ?></span> <?php echo Text::_('COM_INSTALLER_NO_INSTALLATION_PLUGINS_FOUND'); ?> </div> <?php endif; ?> <?php if ($tabs) : ?> <?php echo HTMLHelper::_('uitab.startTabSet', 'myTab', ['active' => $tabs[0]['name'] ?? '', 'recall' => true, 'breakpoint' => 768]); ?> <?php // Show installation tabs ?> <?php foreach ($tabs as $tab) : ?> <?php echo HTMLHelper::_('uitab.addTab', 'myTab', $tab['name'], $tab['label']); ?> <fieldset class="uploadform option-fieldset options-form"> <?php echo $tab['content']; ?> </fieldset> <?php echo HTMLHelper::_('uitab.endTab'); ?> <?php endforeach; ?> <?php echo HTMLHelper::_('uitab.endTabSet'); ?> <?php endif; ?> <input type="hidden" name="installtype" value=""> <input type="hidden" name="task" value="install.install"> <?php echo HTMLHelper::_('form.token'); ?> </div> </div> </div> </form> </div> <div id="loading"></div> PK��!�eT��9��sql/updates/php/6.4.0-2024-10-21_update_configuration.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\Language\Text; use Kunena\Forum\Libraries\Factory\KunenaFactory; / * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.0 / function kunena_640_2024_10_21_update_configuration($parent) { $config = KunenaFactory::getConfig(); unset($config->social); // Save configuration $config->save(); return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_640_UPDATE_CONFIGURATION'), 'success' => true); } PK��!�Ҁd�v��v��>��sql/updates/php/6.4.0-2025-05-14_fill_kunena_private_table.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; use Kunena\Forum\Libraries\Error\KunenaError; use Kunena\Forum\Libraries\Forum\Message\KunenaMessageHelper; use Kunena\Forum\Libraries\KunenaPrivate\KunenaPrivateMessage; / * Populate the private tables for atachments because since 6.4.3 it's populate when post new attachments * * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.0 / function kunena_640_2025_05_14_fill_kunena_private_table($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); $query = $db->createQuery(); $query->select('id, mesid') ->from($db->quoteName('#__kunena_attachments')) ->where($db->quoteName('protected') . ' = 32') ->where($db->quoteName('mesid') . ' != 0'); $db->setQuery($query); $attachmentsPrivate = (array) $db->loadObjectList('id'); $listMesid = []; foreach ($attachmentsPrivate as $attach) { $listMesid[] = $attach->mesid; } $messages = KunenaMessageHelper::getMessages($listMesid); $listAttachByMessage = []; foreach($attachmentsPrivate as $attachment) { $listAttachByMessage[$attachment->mesid][] = $attachment->id; } foreach($messages as $message) { $attachIds = $listAttachByMessage[$message->id]; $parent = $message->getParent(); $author = $message->getAuthor(); $moderator = $author->isModerator($message->getCategory()); $pAuthor = $parent->getAuthor(); $private = new KunenaPrivateMessage(); $private->author_id = $author->userid; $private->subject = $message->subject; $private->body = ''; // Attach message. $private->posts()->add($message->id); // Attach author of the message. if ($author->exists()) { $private->users()->add($author->userid); } if ($pAuthor->exists() && ($moderator \|\| $pAuthor->isModerator($message->getCategory()))) { // Attach receiver (but only if moderator either posted or replied parent post). if ($pAuthor->exists()) { $private->users()->add($pAuthor->userid); } } $private->attachments()->setMapped($attachIds); try { $private->save(); } catch (Exception $e) { KunenaError::displayDatabaseError($e); } } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_640_FILL_KUNENA_PRIVATE_TABLE'), 'success' => true); } PK��!�\|t�A��;��sql/updates/php/6.4.0-2025-01-16_remove_socials_columns.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; / * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.0 / function kunena_640_2025_01_16_remove_socials_columns($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); $listOfColumns = ['icq', 'x_social', 'facebook', 'myspace', 'linkedin', 'linkedin_company', 'digg', 'skype', 'yim', 'google', 'friendfeed', 'github', 'microsoft', 'blogspot', 'flickr', 'bebo', 'instagram', 'qqsocial', 'qzone', 'weibo', 'wechat', 'vk', 'telegram', 'apple', 'vimeo', 'whatsapp', 'youtube', 'ok', 'pinterest', 'reddit', 'bluesky_app']; foreach ($listOfColumns as $column) { $query = "SHOW COLUMNS FROM " . $db->quoteName('#__kunena_users') . " LIKE '{$column}';"; $db->setQuery($query); $column = $db->loadResult(); if ($column) { $query = 'ALTER TABLE ' . $db->quoteName('#__kunena_users') . ' DROP ' . $column . ';'; $db->setQuery($query); $db->execute(); } } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_640_REMOVE_SOCIALS_COLUMNS'), 'success' => true); }PK��!�H+�f��f��A��sql/updates/php/6.4.0-2024-10-21_remove_delicious_socialshare.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; / * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.0 / function kunena_640_2024_10_21_remove_delicious_socialshare($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); $query = "SHOW COLUMNS FROM " . $db->quoteName('#__kunena_users') . " LIKE 'delicious';"; $db->setQuery($query); $column = $db->loadResult(); if ($column) { $query = 'ALTER TABLE ' . $db->quoteName('#__kunena_users') . ' DROP `delicious`;'; $db->setQuery($query); $db->execute(); } $query = "SHOW COLUMNS FROM " . $db->quoteName('#__kunena_users') . " LIKE 'socialshare';"; $db->setQuery($query); $column = $db->loadResult(); if ($column) { $query = 'ALTER TABLE ' . $db->quoteName('#__kunena_users') . ' DROP `socialshare`;'; $db->setQuery($query); $db->execute(); } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_640_REMOVE_DELICIOUS_SOCIALSHARE'), 'success' => true); }PK��!�@ d&��&��:��sql/updates/php/5.2.15-2021-07-24_update_configuration.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\Database\Exception\ExecutionFailureException; use Joomla\CMS\Language\Text; use Kunena\Forum\Libraries\Error\KunenaError; // Kunena 5.2.0: Convert all configuration options to the news ones in K6.0 / * @param $parent * * @return array * @throws Exception * @since Kunena 5.2.4 / function kunena_5215_2021_07_24_update_configuration($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); $query = $db->createQuery(); $query->select('') ->from($db->quoteName('#__kunena_configuration')) ->where($db->quoteName('id') . ' = 1'); $db->setQuery($query); try { $config = $db->loadAssoc(); } catch (ExecutionFailureException $e) { KunenaError::displayDatabaseError($e); } $oldParams = json_decode($config['params']); $listConfigParams = ['boardTitle', 'email', 'boardOffline', 'offlineMessage', 'enableRss', 'threadsPerPage', 'messagesPerPage', 'messagesPerPageSearch', 'showHistory', 'historyLimit', 'showNew', 'disableEmoticons', 'template', 'showAnnouncement', 'avatarOnCategory', 'catimagepath', 'showChildCatIcon', 'rteWidth', 'rteHeight', 'enableForumJump', 'reportMsg', 'username', 'askEmail', 'showEmail', 'showUserStats', 'showKarma', 'userEdit', 'userEditTime', 'userEditTimeGrace', 'editMarkup', 'allowSubscriptions', 'subscriptionsChecked', 'allowFavorites', 'maxsubject', 'maxSig', 'regOnly', 'pubWrite', 'floodProtection', 'mailModerators', 'mailAdministrators', 'captcha', 'mailFull', 'allowAvatarUpload', 'allowAvatarGallery', 'avatarQuality', 'avatarSize', 'imageHeight', 'imageWidth', 'imageSize', 'fileTypes', 'fileSize', 'showRanking', 'rankImages', 'userlistRows', 'userlistOnline', 'userlistAvatar', 'userlistPosts', 'userlistKarma', 'userlistEmail', 'userlistJoinDate', 'userlistLastVisitDate', 'userlistUserHits', 'latestCategory', 'showStats', 'showWhoIsOnline', 'showGenStats', 'showPopUserStats', 'popUserCount', 'showPopSubjectStats', 'popSubjectCount', 'showSpoilerTag', 'showVideoTag', 'showEbayTag', 'trimLongUrls', 'trimLongUrlsFront', 'trimLongUrlsBack', 'autoEmbedYoutube', 'autoEmbedEbay', 'ebayLanguageCode', 'sessionTimeOut', 'highlightCode', 'rssType', 'rssTimeLimit', 'rssLimit', 'rssIncludedCategories', 'rssExcludedCategories', 'rssSpecification', 'rssAllowHtml', 'rssAuthorFormat', 'rssAuthorInTitle', 'rssWordCount', 'rssOldTitles', 'rssCache', 'defaultPage', 'defaultSort', 'sef', 'showImgForGuest', 'showFileForGuest', 'pollNbOptions', 'pollAllowVoteOne', 'pollEnabled', 'popPollsCount', 'showPopPollStats', 'pollTimeBtVotes', 'pollNbVotesByUser', 'pollResultsUserslist', 'allowUserEditPoll', 'maxPersonalText', 'orderingSystem', 'postDateFormat', 'postDateFormatHover', 'hideIp', 'imageTypes', 'checkMimeTypes', 'imageMimeTypes', 'imageQuality', 'thumbHeight', 'thumbWidth', 'hideUserProfileInfo', 'boxGhostMessage', 'userDeleteMessage', 'latestCategoryIn', 'topicIcons', 'debug', 'catsAutoSubscribed', 'showBannedReason', 'showThankYou', 'showPopThankYouStats', 'popThanksCount', 'modSeeDeleted', 'bbcodeImgSecure', 'listCatShowModerators', 'lightbox', 'showListTime', 'showSessionType', 'showSessionStartTime', 'userlistAllowed', 'userlistCountUsers', 'enableThreadedLayouts', 'categorySubscriptions', 'topicSubscriptions', 'pubProfile', 'thankYouMax', 'emailRecipientCount', 'emailRecipientPrivacy', 'emailVisibleAddress', 'captchaPostLimit', 'imageUpload', 'fileUpload', 'topicLayout', 'timeToCreatePage', 'showImgFilesManageProfile', 'holdNewUsersPosts', 'holdGuestPosts', 'attachmentLimit', 'pickupCategory', 'articleDisplay', 'sendEmails', 'fallbackEnglish', 'cache', 'cacheTime', 'ebayAffiliateId', 'ipTracking', 'rssFeedBurnerUrl', 'autoLink', 'accessComponent', 'statsLinkAllowed', 'superAdminUserlist', 'legacy_urls', 'attachmentProtection', 'categoryIcons', 'avatarresizemethod', 'avatarCrop', 'userReport', 'searchTime', 'teaser', 'ebayLanguage', 'ebayApiKey', 'ebayCertId', 'XConsumerKey', 'XConsumerSecret', 'allowChangeSubject', 'maxLinks', 'readOnly', 'ratingEnabled', 'urlSubjectTopic', 'logModeration', 'attachStart', 'attachEnd', 'googleMapApiKey', 'attachmentUtf8', 'autoEmbedSoundcloud', 'emailHeader', 'userStatus', 'signature', 'personal', 'social', 'plainEmail', 'moderatorPermDelete', 'avatarTypes', 'smartLinking', 'defaultAvatar', 'defaultAvatarSmall', 'stopForumSpamKey', 'quickReply', 'avatarEdit', 'activeMenuItem', 'mainMenuId', 'homeId', 'indexId', 'moderatorsId', 'topicListId', 'miscId', 'profileId', 'searchId', 'avatarType', 'sefRedirect', 'allowEditPoll', 'useSystemEmails', 'autoEmbedInstagram', 'disableRe', 'email_sender_name', 'display_filename_attachment', 'new_users_prevent_post_url_images', 'minimal_user_posts_add_url_image', 'plugins' ]; $i = 0; foreach ($oldParams as $p => $oldParam) { if ($p == 'useredittime') { $p = 'userEdittime'; } if ($p == 'useredittimegrace') { $p = 'userEditTimegrace'; } if ($p == 'trimlongurlsfront') { $p = 'trimLongUrlsfront'; } if ($p == 'trimlongurlsback') { $p = 'trimLongUrlsback'; } if ($p == 'latestcategory_in') { $p = 'latestCategory_in'; } if ($p == 'defaultavatarsmall') { $p = 'defaultAvatarsmall'; } if ($p == 'messages_per_page_search') { $p = 'messagesPerPage_search'; } $query = $db->createQuery(); $query = "UPDATE `#__kunena_configuration` SET `params` = REPLACE(params, '{$p}', '{$listConfigParams[$i]}');"; $db->setQuery($query); $db->execute(); $i++; } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_5215_UPDATE_CONFIGURATION'), 'success' => true); } PK��!��^��7��sql/updates/php/6.4.0-2024-11-02_move_users_socials.phpnu��[��<?php /** * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; use Joomla\Utilities\ArrayHelper; use Kunena\Forum\Libraries\User\KunenaUserSocials; / * Handle the data by group of 100 lines * * @param array $array * @param integer $numRows * @param integer $size / function chunk($array, $numRows, $size) { $result = array(); for ($i = 0; $i < $numRows; $i += $size) { $result[] = array_slice($array, $i, $size); } return $result['0']; } /* * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.0 / function kunena_640_2024_11_02_move_users_socials($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); // Check if some columns of socials are missing in the table #__kunena_users $query = $db->getQuery(true); $db->setQuery("SHOW COLUMNS FROM `#__kunena_users`"); $columnsKunenaUsers = $db->loadObjectList(); $columsSocialsByDefault = ['x_social', 'facebook', 'myspace', 'linkedin', 'linkedin_company', 'digg', 'skype', 'yim', 'google', 'github', 'microsoft', 'blogspot', 'flickr', 'bebo', 'instagram', 'qqsocial', 'qzone', 'weibo', 'wechat', 'vk', 'telegram', 'apple', 'vimeo', 'whatsapp', 'youtube', 'ok', 'pinterest', 'reddit', 'bluesky_app']; $columsToAvoid = ['userid', 'status', 'status_text', 'view', 'signature', 'moderator', 'banned', 'ordering', 'posts', 'avatar', 'timestamp', 'karma', 'group_id', 'uhits', 'personalText', 'gender', 'birthdate', 'location', 'websitename', 'websiteurl', 'rank', 'hideEmail', 'showOnline', 'canSubscribe', 'userListtime', 'thankyou', 'ip', 'socials']; $columsSocialsInTable = []; foreach($columnsKunenaUsers as $column) { if (array_search($column->Field, $columsToAvoid) === false) { $columsSocialsInTable[] = $column->Field; } } if(count($columsSocialsInTable) > 0 ) { $listSocialsColumns = $columsSocialsInTable; } else { $listSocialsColumns = $columsSocialsByDefault; } // Get the number of lines in table #__kunena_users $query = $db->createQuery() ->select(array('userid', 'banned')) ->from($db->quoteName('#__kunena_users')) ->where($db->quoteName('banned') . '= ' . $db->quote('1000-01-01 00:00:00') ); $db->setQuery($query); $db->execute(); $numRows = $db->getNumRows(); if ($numRows > 0) { $listSocialsColumns[] = 'userid'; $query = $db->createQuery() ->select($db->quoteName($listSocialsColumns)) ->from($db->quoteName('#__kunena_users')) ->where($db->quoteName('banned') . '= ' . $db->quote('1000-01-01 00:00:00') ); $db->setQuery($query); $db->execute(); $dataResults = (array) $db->loadAssocList(); foreach (chunk($dataResults, $numRows, 100) as $line) { $result = ArrayHelper::toObject($line); $socials = KunenaUserSocials::getInstance($result->userid, false); foreach ($columsSocialsByDefault as $socialColumn) { if (isset($result->$socialColumn) && !empty($result->$socialColumn)) { $socials->$socialColumn->value = $result->$socialColumn; } } $socials->save(); } } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_640_UPDATE_USERS_SOCIALS'), 'success' => true); } PK��!��G��sql/updates/php/6.0.2-2022-07-30_rss_timelimit_configuration_change.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\Language\Text; use Kunena\Forum\Libraries\Factory\KunenaFactory; / * Convert Kunena configuration to update changes of setting of RSS timelimit * * @param string $parent parent * * @return array * @throws Exception * @since Kunena 6.0.2 / function kunena_602_2022_07_30_rss_timelimit_configuration_change($parent) { $config = KunenaFactory::getConfig(); $rssTimeLimit = $config->rssTimeLimit; if ($rssTimeLimit == 'month') { $config->rssTimeLimit = '1 month'; } elseif ($rssTimeLimit == 'week') { $config->rssTimeLimit = '1 week'; } else { $config->rssTimeLimit = '1 year'; } if ($rssTimeLimit == 'month' \|\| $rssTimeLimit == 'week' \|\| $rssTimeLimit == 'year') { unset($config->rssTimeLimit); // Save configuration $config->save(); return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_602_UPDATE_CONFIGURATION_RSS_TIMELIMIT'), 'success' => true); } } PK��!�)�\|��G��sql/updates/php/6.2.4-2022-01-24_change_collation_columns_on_tables.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; use Joomla\Database\DatabaseInterface; / * Convert columns in Kunena tables to collation in utf8mb4 * * @param string $parent parent * * @return array * @throws Exception * @since Kunena 6.2.4 / function kunena_624_2022_01_24_change_collation_columns_on_tables($parent) { $db = Factory::getContainer()->get(DatabaseInterface::class); // Change to varchar 250 the columns which are in varchar 255 because it blocks then the conversion to utf8mb4 $listKunenaTables = [$db->getPrefix() . 'kunena_aliases', $db->getPrefix() . 'kunena_announcement', $db->getPrefix() . 'kunena_attachments', $db->getPrefix() . 'kunena_categories', $db->getPrefix() . 'kunena_configuration', $db->getPrefix() . 'kunena_karma', $db->getPrefix() . 'kunena_topics', $db->getPrefix() . 'kunena_messages', $db->getPrefix() . 'kunena_messages_text', $db->getPrefix() . 'kunena_polls', $db->getPrefix() . 'kunena_polls_options', $db->getPrefix() . 'kunena_polls_users', $db->getPrefix() . 'kunena_private', $db->getPrefix() . 'kunena_private_attachment_map', $db->getPrefix() . 'kunena_private_post_map', $db->getPrefix() . 'kunena_private_user_map', $db->getPrefix() . 'kunena_ranks', $db->getPrefix() . 'kunena_rate', $db->getPrefix() . 'kunena_sessions', $db->getPrefix() . 'kunena_smileys', $db->getPrefix() . 'kunena_thankyou', $db->getPrefix() . 'kunena_user_categories', $db->getPrefix() . 'kunena_user_read', $db->getPrefix() . 'kunena_user_topics', $db->getPrefix() . 'kunena_users', $db->getPrefix() . 'kunena_users_banned', $db->getPrefix() . 'kunena_logs', $db->getPrefix() . 'kunena_version']; // Get collations from all Kunena tables et convert the column when needed foreach ($listKunenaTables as $kunenatable) { // Fisrt check if the table exist $db->setQuery("SHOW TABLES LIKE {$db->quote($kunenatable)}"); if ($db->loadResult() == $kunenatable) { $query = 'SHOW FULL COLUMNS FROM ' . $db->quoteName($kunenatable); $db->setQuery($query); $tableColumns = $db->loadobjectList(); // Check column and set to ut8_mb4 when needed foreach ($tableColumns as $column) { if ($column->Collation == 'utf8_general_ci' \|\| $column->Collation == 'utf8mb3_general_ci' \|\| $column->Collation == 'utf8_unicode_ci' \|\| $column->Collation == 'utf8mb3_unicode_ci') { if ($column->Type == 'VARCHAR(255)' \|\| $column->Type == 'varchar(255)') { $query = 'ALTER TABLE ' . $db->quoteName($kunenatable) . ' CHANGE ' . $column->Field . ' ' . $column->Field . ' VARCHAR(250);'; $db->setQuery($query); $db->execute(); $query = 'ALTER TABLE ' . $db->quoteName($kunenatable) . ' CHANGE ' . $column->Field . ' ' . $column->Field . ' VARCHAR(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;'; $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } } else { $query = 'ALTER TABLE ' . $db->quoteName($kunenatable) . ' CHANGE ' . $column->Field . ' ' . $column->Field . ' ' . $column->Type . ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;'; $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } } } } } } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_624_CHANGE_COLLATION_ON_COLUMNS_TO_UTF8MB4'), 'success' => true); } PK��!�8�q��?��sql/updates/php/6.4.5-2025-07-30_remove_columns_users_table.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; / * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.5 / function kunena_645_2025_07_30_remove_columns_users_table($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); $listOfColumns = ['qq', 'karma_time']; foreach ($listOfColumns as $column) { $query = "SHOW COLUMNS FROM " . $db->quoteName('#__kunena_users') . " LIKE '{$column}';"; $db->setQuery($query); $column = $db->loadResult(); if ($column) { $query = 'ALTER TABLE ' . $db->quoteName('#__kunena_users') . ' DROP ' . $column . ';'; $db->setQuery($query); $db->execute(); } } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_645_REMOVE_COLUMNS_USERS_TABLE'), 'success' => true); }PK��!��m�:3��:3��8��sql/updates/php/6.4.0-2025-02-11_clean_configuration.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\Language\Text; use Kunena\Forum\Libraries\Factory\KunenaFactory; / * Clean in the configuration the leftovers of previous parameters which has been deleted since * * @param $parent * * @return array * @throws Exception * @since Kunena 6.4.0 / function kunena_640_2025_02_11_clean_configuration($parent) { $config = KunenaFactory::getConfig(); $listNewConfigParams = ['boardTitle', 'boardOffline', 'offlineMessage', 'enableRss', 'threadsPerPage', 'messagesPerPage', 'messagesPerPageSearch', 'showHistory', 'historyLimit', 'showNew', 'disableEmoticons', 'showAnnouncement', 'avatarOnCategory', 'showChildCatIcon', 'rteWidth', 'rteHeight', 'enableForumJump', 'reportMsg', 'askEmail', 'showEmail', 'showUserStats', 'showKarma', 'userEdit', 'userEditTime', 'userEditTimeGrace', 'editMarkup', 'allowSubscriptions', 'subscriptionsChecked', 'allowFavorites', 'maxSig', 'regOnly', 'pubWrite', 'floodProtection', 'mailModerators', 'mailAdministrators', 'mailFull', 'allowAvatarUpload', 'allowAvatarGallery', 'avatarQuality', 'userlistJoinDate', 'avatarSize', 'imageHeight', 'imageWidth', 'imageSize', 'fileTypes', 'fileSize', 'showRanking', 'rankImages', 'userlistRows', 'userlistOnline', 'userlistAvatar', 'userlistPosts', 'userlistKarma', 'userlistEmail', 'showSpoilerTag', 'userlistLastVisitDate', 'userlistUserHits', 'latestCategory', 'showStats', 'showWhoIsOnline', 'showGenStats', 'showPopUserStats', 'popUserCount', 'showPopSubjectStats', 'popSubjectCount', 'showVideoTag', 'showEbayTag', 'trimLongUrls', 'trimLongUrlsFront', 'trimLongUrlsBack', 'autoEmbedYoutube', 'autoEmbedEbay', 'ebayLanguageCode', 'sessionTimeOut', 'highlightCode', 'rssType', 'rssTimeLimit', 'rssLimit', 'rssIncludedCategories', 'rssExcludedCategories', 'rssSpecification', 'rssAllowHtml', 'rssAuthorFormat', 'rssAuthorInTitle', 'rssWordCount', 'rssOldTitles', 'rssCache', 'defaultPage', 'defaultSort', 'showImgForGuest', 'showFileForGuest', 'pollNbOptions', 'pollAllowVoteOne', 'pollEnabled', 'popPollsCount', 'showPopPollStats', 'pollTimeBtVotes', 'pollNbVotesByUser', 'pollResultsUserslist', 'allowUserEditPoll', 'maxPersonalText', 'orderingSystem', 'postDateFormat', 'postDateFormatHover', 'hideIp', 'imageTypes', 'checkMimeTypes', 'imageMimeTypes', 'imageQuality', 'thumbHeight', 'thumbWidth', 'hideUserProfileInfo', 'boxGhostMessage', 'userDeleteMessage', 'latestCategoryIn', 'topicIcons', 'catsAutoSubscribed', 'showBannedReason', 'showThankYou', 'showPopThankYouStats', 'popThanksCount', 'modSeeDeleted', 'bbcodeImgSecure', 'listCatShowModerators', 'showListTime', 'showSessionType', 'showSessionStartTime', 'userlistAllowed', 'userlistCountUsers', 'enableThreadedLayouts', 'categorySubscriptions', 'topicSubscriptions', 'pubProfile', 'thankYouMax', 'emailRecipientCount', 'emailRecipientPrivacy', 'emailVisibleAddress', 'captchaPostLimit', 'imageUpload', 'fileUpload', 'topicLayout', 'timeToCreatePage', 'showImgFilesManageProfile', 'holdNewUsersPosts', 'holdGuestPosts', 'attachmentLimit', 'pickupCategory', 'articleDisplay', 'sendEmails', 'fallbackEnglish', 'cacheTime', 'ebayAffiliateId', 'ipTracking', 'rssFeedBurnerUrl', 'autoLink', 'accessComponent', 'statsLinkAllowed', 'superAdminUserlist', 'attachmentProtection', 'categoryIcons', 'avatarCrop', 'userReport', 'searchTime', 'ebayLanguage', 'ebayApiKey', 'ebayCertId', 'XConsumerKey', 'XConsumerSecret', 'allowChangeSubject', 'maxLinks', 'readOnly', 'ratingEnabled', 'urlSubjectTopic', 'logModeration', 'attachStart', 'attachEnd', 'googleMapApiKey', 'attachmentUtf8', 'autoEmbedSoundcloud', 'emailHeader', 'userStatus', 'plainEmail', 'moderatorPermDelete', 'avatarTypes', 'smartLinking', 'defaultAvatar', 'defaultAvatarSmall', 'stopForumSpamKey', 'quickReply', 'avatarEdit', 'activeMenuItem', 'mainMenuId', 'homeId', 'indexId', 'moderatorsId', 'topicListId', 'miscId', 'profileId', 'searchId', 'avatarType', 'sefRedirect', 'allowEditPoll', 'useSystemEmails', 'autoEmbedInstagram', 'disableRe' ]; $listOldConfigParams = ['board_title', 'board_offline', 'offline_message', 'enablerss', 'threads_per_page', 'messages_per_page', 'messages_per_page_search', 'showhistory', 'historylimit', 'shownew', 'disemoticons', 'showannouncement', 'avataroncat', 'showchildcaticon' ,'rtewidth', 'rteheight', 'enableforumjump', 'reportmsg', 'askemail', 'showemail', 'showuserstats', 'showkarma', 'useredit', 'useredittime', 'useredittimegrace', 'editmarkup', 'allowsubscriptions', 'subscriptionschecked', 'allowfavorites', 'maxsig', 'regonly', 'pubwrite', 'floodprotection', 'mailmod', 'mailadmin', 'mailfull', 'allowavatarupload', 'allowavatargallery', 'avatarquality', 'userlist_joindate', 'avatarsize', 'imageheight', 'imagewidth', 'imagesize', 'filetypes', 'filesize', 'showranking', 'rankimages', 'userlist_rows', 'userlist_online', 'userlist_avatar', 'userlist_posts', 'userlist_karma', 'userlist_email', 'showspoilertag', 'userlist_lastvisitdate', 'userlist_userhits', 'latestcategory', 'showstats', 'showwhoisonline', 'showgenstats', 'showpopuserstats', 'popusercount', 'showpopsubjectstats', 'popsubjectcount', 'showvideotag','showebaytag', 'trimlongurls', 'trimlongurlsfront', 'trimlongurlsback', 'autoembedyoutube', 'autoembedebay', 'ebaylanguagecode', 'sessiontimeout', 'highlightcode', 'rss_type', 'rss_timelimit', 'rss_limit', 'rss_included_categories', 'rss_excluded_categories', 'rss_specification', 'rss_allow_html', 'rss_author_format', 'rss_author_in_title', 'rss_word_count', 'rss_old_titles', 'rss_cache', 'defaultpage', 'default_sort', 'showimgforguest', 'showfileforguest', 'pollnboptions', 'pollallowvoteone', 'pollenabled', 'poppollscount', 'showpoppollstats', 'polltimebtvotes', 'pollnbvotesbyuser', 'pollresultsuserslist', 'allow_user_edit_poll', 'maxpersotext', 'ordering_system', 'post_dateformat', 'post_dateformat_hover', 'hide_ip', 'imagetypes', 'checkmimetypes', 'imagemimetypes', 'imagequality', 'thumbheight', 'thumbwidth', 'hideuserprofileinfo', 'boxghostmessage', 'userdeletetmessage', 'latestcategory_in', 'topicicons', 'catsautosubscribed', 'showbannedreason', 'showthankyou', 'showpopthankyoustats', 'popthankscount', 'mod_see_deleted', 'bbcode_img_secure', 'listcat_show_moderators', 'show_list_time', 'show_session_type', 'show_session_starttime', 'userlist_allowed', 'userlist_count_users', 'enable_threaded_layouts', 'category_subscriptions', 'topic_subscriptions', 'pubprofile', 'thankyou_max', 'email_recipient_count', 'email_recipient_privacy', 'email_visible_address', 'captcha_post_limit', 'image_upload', 'file_upload', 'topic_layout', 'time_to_create_page', 'show_imgfiles_manage_profile', 'hold_newusers_posts', 'hold_guest_posts', 'attachment_limit', 'pickup_category', 'article_display', 'send_emails', 'fallback_english', 'cache_time', 'ebay_affiliate_id', 'iptracking', 'rss_feedburner_url', 'autolink', 'access_component', 'statslink_allowed', 'superadmin_userlist', 'attachment_protection', 'categoryicons', 'avatarcrop', 'user_report', 'searchtime', 'ebay_language', 'ebay_api_key', 'ebay_cert_id', 'twitter_consumer_key', 'twitter_consumer_secret', 'allow_change_subject', 'max_links', 'read_only', 'ratingenabled', 'url_subject_topic', 'log_moderation', 'attach_start', 'attach_end', 'google_map_api_key' ,'attachment_utf8', 'autoembedsoundcloud', 'emailheader', 'user_status', 'plain_email', 'moderator_permdelete', 'avatartypes', 'smartlinking', 'defaultavatar', 'defaultavatarsmall', 'stopforumspam_key', 'quickreply', 'avataredit', 'activemenuitem', 'mainmenu_id' ,'home_id', 'index_id', 'moderators_id', 'topiclist_id', 'misc_id', 'profile_id', 'search_id', 'avatar_type', 'sef_redirect', 'allow_edit_poll', 'use_system_emails', 'autoembedinstagram', 'disable_re' ]; foreach($config as $param => $val) { if ($param != 'id') { $keyFound = array_search($param, $listOldConfigParams); if ($keyFound !== false) { $configParam = $listNewConfigParams[$keyFound]; $config->$configParam = $val; unset($config->$param); } } } // Save configuration $config->save(); $listConfigParams = ['boardTitle', 'email', 'boardOffline', 'offlineMessage', 'enableRss', 'threadsPerPage', 'messagesPerPage', 'messagesPerPageSearch', 'showHistory', 'historyLimit', 'showNew', 'disableEmoticons', 'template', 'showAnnouncement', 'avatarOnCategory', 'showChildCatIcon', 'rteWidth', 'rteHeight', 'enableForumJump', 'reportMsg', 'username', 'askEmail', 'showEmail', 'showUserStats', 'showKarma', 'userEdit', 'userEditTime', 'userEditTimeGrace', 'editMarkup', 'allowSubscriptions', 'subscriptionsChecked', 'allowFavorites', 'maxSig', 'regOnly', 'pubWrite', 'floodProtection', 'mailModerators', 'mailAdministrators', 'captcha', 'mailFull', 'allowAvatarUpload', 'allowAvatarGallery', 'avatarQuality', 'userlistJoinDate', 'avatarSize', 'imageHeight', 'imageWidth', 'imageSize', 'fileTypes', 'fileSize', 'showRanking', 'rankImages', 'userlistRows', 'userlistOnline', 'userlistAvatar', 'userlistPosts', 'userlistKarma', 'userlistEmail', 'showSpoilerTag', 'userlistLastVisitDate', 'userlistUserHits', 'latestCategory', 'showStats', 'showWhoIsOnline', 'showGenStats', 'showPopUserStats', 'popUserCount', 'showPopSubjectStats', 'popSubjectCount', 'showVideoTag', 'showEbayTag', 'trimLongUrls', 'trimLongUrlsFront', 'trimLongUrlsBack', 'autoEmbedYoutube', 'autoEmbedEbay', 'ebayLanguageCode', 'sessionTimeOut', 'highlightCode', 'rssType', 'rssTimeLimit', 'rssLimit', 'rssIncludedCategories', 'rssExcludedCategories', 'rssSpecification', 'rssAllowHtml', 'rssAuthorFormat', 'rssAuthorInTitle', 'rssWordCount', 'rssOldTitles', 'rssCache', 'defaultPage', 'defaultSort', 'sef', 'showImgForGuest', 'showFileForGuest', 'pollNbOptions', 'pollAllowVoteOne', 'pollEnabled', 'popPollsCount', 'showPopPollStats', 'pollTimeBtVotes', 'pollNbVotesByUser', 'pollResultsUserslist', 'allowUserEditPoll', 'maxPersonalText', 'orderingSystem', 'postDateFormat', 'postDateFormatHover', 'hideIp', 'imageTypes', 'checkMimeTypes', 'imageMimeTypes', 'imageQuality', 'thumbHeight', 'thumbWidth', 'hideUserProfileInfo', 'boxGhostMessage', 'userDeleteMessage', 'latestCategoryIn', 'topicIcons', 'debug', 'catsAutoSubscribed', 'showBannedReason', 'showThankYou', 'showPopThankYouStats', 'popThanksCount', 'modSeeDeleted', 'bbcodeImgSecure', 'listCatShowModerators', 'lightbox', 'showListTime', 'showSessionType', 'showSessionStartTime', 'userlistAllowed', 'userlistCountUsers', 'enableThreadedLayouts', 'categorySubscriptions', 'topicSubscriptions', 'pubProfile', 'thankYouMax', 'emailRecipientCount', 'emailRecipientPrivacy', 'emailVisibleAddress', 'captchaPostLimit', 'imageUpload', 'fileUpload', 'topicLayout', 'timeToCreatePage', 'showImgFilesManageProfile', 'holdNewUsersPosts', 'holdGuestPosts', 'attachmentLimit', 'pickupCategory', 'articleDisplay', 'sendEmails', 'fallbackEnglish', 'cache', 'cacheTime', 'ebayAffiliateId', 'ipTracking', 'rssFeedBurnerUrl', 'autoLink', 'accessComponent', 'statsLinkAllowed', 'superAdminUserlist', 'attachmentProtection', 'categoryIcons', 'avatarCrop', 'userReport', 'searchTime', 'teaser', 'ebayLanguage', 'ebayApiKey', 'ebayCertId', 'blueskyappHandleOfApp', 'blueskyappPasswordOfApp', 'XConsumerKey', 'XConsumerSecret', 'allowChangeSubject', 'maxLinks', 'readOnly', 'ratingEnabled', 'urlSubjectTopic', 'logModeration', 'attachStart', 'attachEnd', 'googleMapApiKey', 'attachmentUtf8', 'autoEmbedSoundcloud', 'emailHeader', 'userStatus', 'signature', 'personal', 'plainEmail', 'moderatorPermDelete', 'avatarTypes', 'smartLinking', 'defaultAvatar', 'defaultAvatarSmall', 'stopForumSpamKey', 'quickReply', 'avatarEdit', 'activeMenuItem', 'mainMenuId', 'homeId', 'indexId', 'moderatorsId', 'topicListId', 'miscId', 'profileId', 'searchId', 'custom_id', 'avatarType', 'sefRedirect', 'allowEditPoll', 'useSystemEmails', 'autoEmbedInstagram', 'disableRe', 'email_sender_name', 'display_filename_attachment', 'new_users_prevent_post_url_images', 'minimal_user_posts_add_url_image', 'utmSource', 'plugins', 'emailHeaderSizeY', 'emailHeaderSizeX', 'profiler', 'privateMessage', 'datePickerFormat', 'sendMailUserBanned', 'mailBodyUserBanned', 'mailBodyUserUnBanned' ]; // We are deleting the remaining config params which have been dropped in previous versions foreach($config as $param => $val) { if ($param != 'id') { if (array_search($param, $listConfigParams) === false) { unset($config->$param); } } } // Save configuration $config->save(); return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_640_CLEAN_CONFIGURATION'), 'success' => true); } PK��!�}��w^��^��D��sql/updates/php/5.2.15-2021-08-24_configuration_default_template.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\Language\Text; use Kunena\Forum\Libraries\Factory\KunenaFactory; // Kunena 6.0.0: Set Aurelia as default template in config when update / * @param string $parent parent * * @return array * * @throws Exception * @since Kunena 6.0 / function kunena_5215_2021_08_24_configuration_default_template($parent) { $config = KunenaFactory::getConfig(); if (isset($config->template)) { if ($config->template == 'crypsis' \|\| $config->template == 'crypsisb3' \|\| $config->template == 'crypsisb4' \|\| $config->template == 'blue_eagle5') { $config->set('template', 'aurelia'); } } // Save configuration $config->save(); return ['action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_5215_SET_AURELIA_AS_DEFAULT_IN_CONFIGURATION'), 'success' => true]; } PK��!�34��>��sql/updates/php/6.3.4-2024-08-01_update_configuration_to_x.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\Language\Text; use Kunena\Forum\Libraries\Factory\KunenaFactory; / * @param $parent * * @return array * @throws Exception * @since Kunena 6.3.4 / function kunena_634_2024_08_01_update_configuration_to_x($parent) { $config = KunenaFactory::getConfig(); if (isset($config->twitterConsumerKey)) { $config->XConsumerKey = $config->twitterConsumerKey; unset($config->twitterConsumerKey); } if (isset($config->twitterConsumerSecret)) { $config->XConsumerSecret = $config->twitterConsumerSecret; unset($config->twitterConsumerSecret); } // Save configuration $config->save(); return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_634_UPDATE_CONFIGURATION'), 'success' => true); } PK��!��1%��5��sql/updates/php/5.2.0-2020-08-20_updaterankstitle.phpnu��[��<?php /* * Kunena Component * * @package Kunena.Installer * * @copyright Copyright (C) 2008 - 2026 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\CMS\Language\Text; // Kunena 5.2.0: Update ranks rank_title value to have string which can be translated / * @param string $parent parent * * @return array * @since Kunena * @throws Exception */ function kunena_520_2020_08_20_updaterankstitle($parent) { $db = Factory::getContainer()->get('DatabaseDriver'); $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK1'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 1', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK2'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 2', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK3'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 3', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK4'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 4', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK5'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 5', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK6'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 6', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK_ADMIN'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 7', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK_MODERATOR'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 8', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK_SPAMMER'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 9', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } $query = $db->createQuery(); // Fields to update. $fields = array( $db->quoteName('rank_title') . ' = ' . $db->quote('COM_KUNENA_SAMPLEDATA_RANK_BANNED'), ); // Conditions for which records should be updated. $conditions = array( $db->quoteName('rank_id') . ' = 10', ); $query->update($db->quoteName('#__kunena_ranks'))->set($fields)->where($conditions); $db->setQuery($query); try { $db->execute(); } catch (Exception $e) { throw new Exception($e->getMessage(), $e->getCode()); } return array('action' => '', 'name' => Text::_('COM_KUNENA_INSTALL_520_RANKS_TITLE_VALUE_IN_TABLES'), 'success' => true); } PK��!�:��B�q��q��kunena.install.upgrade.xmlnu��[��<?xml version="1.0"?> <!DOCTYPE comupgrade> <comupgrade version="1.0"> <upgrade> <version version="5.1.2" versiondate="2018-06-23" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD `linkedin_company` varchar(50) NULL AFTER `linkedin`; </query> </version> <version version="5.1.6-DEV" versiondate="2018-11-07" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `created` datetime NOT NULL default '1000-01-01 00:00:00'; </query> <query mode="silenterror">UPDATE `#__kunena_announcement` SET created='1000-01-01 00:00:00' WHERE created='0000-00-00 00:00:00'</query> <query mode="silenterror">ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `publish_up` datetime NOT NULL default '1000-01-01 00:00:00'; </query> <query mode="silenterror">UPDATE `#__kunena_announcement` SET publish_up='1000-01-01 00:00:00' WHERE publish_up='0000-00-00 00:00:00'</query> <query mode="silenterror">ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `publish_down` datetime NOT NULL default '1000-01-01 00:00:00'; </query> <query mode="silenterror">UPDATE `#__kunena_announcement` SET publish_down='1000-01-01 00:00:00' WHERE publish_down='0000-00-00 00:00:00'</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` MODIFY COLUMN `checked_out_time` datetime NOT NULL default '1000-01-01 00:00:00'; </query> <query mode="silenterror">UPDATE `#__kunena_announcement` SET checked_out_time='1000-01-01 00:00:00' WHERE checked_out_time='0000-00-00 00:00:00'</query> <query mode="silenterror">ALTER TABLE `#__kunena_polls_users` MODIFY COLUMN `lasttime` datetime NOT NULL default '1000-01-01 00:00:00'; </query> <query mode="silenterror">UPDATE `#__kunena_announcement` SET lasttime='1000-01-01 00:00:00' WHERE lasttime='0000-00-00 00:00:00'</query> </version> <version version="5.1.11-DEV" versiondate="2019-10-03" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_users` CHANGE `qq` `qqsocial` varchar(50); </query> </version> <version version="5.2.0-ALPHA1" versiondate="2020-08-20" versionname="Internal"> <phpfile name="5.2.0-2020-08-20_updaterankstitle" /> </version> <version version="5.2.5-DEV" versiondate="2020-04-18" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_users` MODIFY banned datetime NULL DEFAULT '1000-01-01 00:00:00';</query> </version> <version version="5.2.6-DEV" versiondate="2021-06-12" versionname="Internal"> <query mode="silenterror">UPDATE `#__kunena_users_banned` SET `expiration` = '9999-12-31 23:59:59' WHERE expiration = '0000-00-00 00:00:00';</query> <query mode="silenterror">UPDATE `#__kunena_users` SET `banned` = '9999-12-31 23:59:59' WHERE banned = '0000-00-00 00:00:00';</query> </version> <version version="5.2.15-DEV" versiondate="2021-07-24" versionname="Internal"> <phpfile name="5.2.15-2021-07-24_update_configuration" /> </version> <version version="5.2.15-DEV" versiondate="2021-08-24" versionname="Internal"> <phpfile name="5.2.15-2021-08-24_configuration_default_template" /> </version> <version version="6.0.0-BETA3-DEV" versiondate="2021-09-13" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE parent_id parentid int(11) NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE pub_access pubAccess int(11) NOT NULL default '1';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE pub_recurse pubRecurse tinyint(4) NULL default '1';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE admin_access adminAccess int(11) NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE admin_recurse adminRecurse tinyint(4) NULL default '1';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE allow_anonymous allowAnonymous tinyint(4) NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE post_anonymous postAnonymous tinyint(4) NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE allow_polls allowPolls tinyint(4) NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE allow_ratings allowRatings tinyint(4) NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_ranks` CHANGE rank_id rankId mediumint(8) unsigned NOT NULL auto_increment;</query> <query mode="silenterror">ALTER TABLE `#__kunena_ranks` CHANGE rank_title rankTitle varchar(255) NOT NULL default '';</query> <query mode="silenterror">ALTER TABLE `#__kunena_ranks` CHANGE rank_min rankMin mediumint(8) unsigned NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_ranks` CHANGE rank_special rankSpecial tinyint(1) unsigned NOT NULL default '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_ranks` CHANGE rank_image rankImage varchar(255);</query> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD reddit varchar(75) NULL AFTER `youtube`;</query> </version> <version version="6.0.0-BETA4-DEV" versiondate="2021-09-25" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD github varchar(75) NULL AFTER `google`;</query> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD vimeo varchar(75) NULL AFTER `qzone`;</query> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD pinterest varchar(75) NULL AFTER `yim`;</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE topic_ordering topicOrdering varchar(16) NOT NULL default 'lastpost';</query> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE `ordering` `ordering` INT(11) NOT NULL DEFAULT '0';</query> <query mode="silenterror">ALTER TABLE `#__kunena_user_topics` CHANGE `params` `params` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;</query> <query mode="silenterror">ALTER TABLE `#__kunena_user_categories` CHANGE `params` `params` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;</query> </version> <version version="6.0.0-RC1-DEV" versiondate="2022-03-02" versionname="Internal"> <query mode="silenterror">CREATE TABLE IF NOT EXISTS `#__kunena_private` ( `id` int NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL DEFAULT '0', `author_id` int NOT NULL DEFAULT '0', `created_at` datetime NOT NULL, `attachments` tinyint NOT NULL DEFAULT '0', `subject` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `params` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `author_id` (`author_id`), KEY `created_at` (`created_at`) );</query> <query mode="silenterror">CREATE TABLE IF NOT EXISTS `#__kunena_private_attachment_map` ( `private_id` int NOT NULL, `attachment_id` int NOT NULL, PRIMARY KEY (`private_id`, `attachment_id`), KEY `attachment_id` (`attachment_id`) );</query> <query mode="silenterror">CREATE TABLE IF NOT EXISTS `#__kunena_private_post_map` ( `private_id` int NOT NULL, `message_id` int NOT NULL, PRIMARY KEY (`private_id`, `message_id`), KEY `message_id` (`message_id`) );</query> <query mode="silenterror">CREATE TABLE IF NOT EXISTS `#__kunena_private_user_map` ( `private_id` int NOT NULL, `user_id` int NOT NULL, `read_at` datetime NOT NULL, `replied_at` datetime NOT NULL, `deleted_at` datetime NOT NULL, PRIMARY KEY (`private_id`, `user_id`), KEY `user_id` (`user_id`) );</query> </version> <version version="6.0.0-RC4-DEV" versiondate="2022-05-29" versionname="Internal"> <query mode="silenterror">TRUNCATE TABLE `#__kunena_smileys`;</query> <query mode="silenterror">INSERT INTO `#__kunena_smileys` (`id`,`code`,`location`,`greylocation`,`emoticonbar`) VALUES (1, 'B)', '1.png', 'cool-grey.png', 1), (2, '8)', '2.png', 'cool-grey.png', 1), (3, '8-)', '3.png', 'cool-grey.png', 1), (4, ':-(', '4.png', 'sad-grey.png', 1), (5, ':(', '5.png', 'sad-grey.png', 1), (6, ':sad:', '6.png', 'sad-grey.png', 1), (7, ':cry:', '7.png', 'sad-grey.png', 1), (8, ':)', '8.png', 'smile-grey.png', 1), (9, ':-)', '9.png', 'smile-grey.png', 1), (10, ':cheer:', '10.png', 'cheerful-grey.png', 1), (11, ';)', '11.png', 'wink-grey.png', 1), (12, ';-)', '12.png', 'wink-grey.png', 1), (13, ':wink:', '13.png', 'wink-grey.png', 1), (14, ';-)', '14.png', 'wink-grey.png', 1), (15, ':P', '15.png', 'tongue-grey.png', 1), (16, ':p', '16.png', 'tongue-grey.png', 1), (17, ':-p', '17.png', 'tongue-grey.png', 1), (18, ':-P', '18.png', 'tongue-grey.png', 1), (19, ':razz:', '19.png', 'tongue-grey.png', 1), (20, ':angry:', '20.png', 'angry-grey.png', 1), (21, ':mad:', '21.png', 'angry-grey.png', 1), (22, ':unsure:', '22.png', 'unsure-grey.png', 1), (23, ':o', '23.png', 'shocked-grey.png', 1);</query> </version> <version version="6.0.2-DEV" versiondate="2022-07-30" versionname="Internal"> <phpfile name="6.0.2-2022-07-30_rss_timelimit_configuration_change" /> </version> <version version="6.0.4-DEV" versiondate="2022-10-13" versionname="Internal"> <query mode="silenterror">UPDATE `#__kunena_messages` SET `email` = NULL;</query> <query mode="silenterror">UPDATE `#__kunena_users` SET banned = '1000-01-01 00:00:00' WHERE banned IS NULL;</query> <query mode="silenterror">ALTER TABLE `#__kunena_users` MODIFY COLUMN `banned` datetime NOT NULL default '1000-01-01 00:00:00';</query> </version> <version version="6.0.5-DEV" versiondate="2022-11-06" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_polls` CHANGE `polltimetolive` `polltimetolive` DATETIME NULL DEFAULT '1000-01-01 00:00:00'; </query> <query mode="silenterror">DELETE FROM `#__mail_templates` WHERE `template_id` = 'com_kunena.reply';</query> <query mode="silenterror">DELETE FROM `#__mail_templates` WHERE `template_id` = 'com_kunena.replymoderator';</query> <query mode="silenterror">DELETE FROM `#__mail_templates` WHERE `template_id` = 'com_kunena.report';</query> </version> <version version="6.0.6-DEV" versiondate="2022-12-12" versionname="Internal"> <query mode="silenterror">UPDATE `#__kunena_announcement` SET publish_up = '1000-01-01 00:00:00' WHERE publish_up='0000-00-00 00:00:00';</query> <query mode="silenterror">UPDATE `#__kunena_announcement` SET publish_down = '1000-01-01 00:00:00' WHERE publish_down='0000-00-00 00:00:00';</query> </version> <version version="6.0.9-DEV" versiondate="2023-02-20" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_attachments` CHANGE `filetype` `filetype` VARCHAR(50);</query> </version> <version version="6.0.10-DEV" versiondate="2023-03-27" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_attachments` CHANGE `filetype` `filetype` VARCHAR(100);</query> </version> <version version="6.1.3.1" versiondate="2023-08-12" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_private_user_map` CHANGE `read_at` `read_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `replied_at` `replied_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, CHANGE `deleted_at` `deleted_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;</query> </version> <version version="6.1.4" versiondate="2023-09-16" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_categories` CHANGE `icon` `icon` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;</query> </version> <version version="6.2.0-DEV" versiondate="2023-06-22" versionname="Internal"> <query mode="silenterror"> CREATE TABLE IF NOT EXISTS `#__kunena_karma` ( `id` int(11) NOT NULL default '0', `userid` int(11) NOT NULL, `target_userid` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; </query> <query mode="silenterror">ALTER TABLE `#__kunena_users` DROP `karma_time`;</query> </version> <version version="6.2.0-DEV" versiondate="2023-08-27" versionname="Internal"> <query mode="silenterror"> DROP TABLE IF EXISTS `#__kunena_mails_queue`; </query> </version> <version version="6.2.0-BETA3-DEV" versiondate="2023-09-30" versionname="Internal"> <query mode="silenterror"> ALTER TABLE `#__kunena_rate` MODIFY COLUMN `time` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00'; </query> <query mode="silenterror">ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `created` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';</query> <query mode="silenterror">ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `publish_up` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';</query> <query mode="silenterror">ALTER TABLE `#__kunena_announcement` MODIFY COLUMN `publish_down` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';</query> <query mode="silenterror">ALTER TABLE `#__kunena_polls_users` MODIFY COLUMN `lasttime` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';</query> </version> <version version="6.2.3-DEV" versiondate="2023-12-23" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_karma` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT;</query> </version> <version version="6.2.4-DEV" versiondate="2024-01-24" versionname="Internal"> <phpfile name="6.2.4-2022-01-24_change_collation_columns_on_tables" /> </version> <version version="6.3.0-DEV" versiondate="2023-10-29" versionname="Internal"> <query mode="silenterror"> ALTER TABLE `#__kunena_users` DROP `friendfeed`; </query> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD `bsky_app` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `reddit`;</query> </version> <version version="6.3.3-DEV" versiondate="2024-06-21" versionname="Internal"> <query mode="silenterror"> ALTER TABLE `#__kunena_users` CHANGE `twitter` `x_social` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; </query> </version> <version version="6.3.4-DEV" versiondate="2024-08-01" versionname="Internal"> <phpfile name="6.3.4-2024-08-01_update_configuration_to_x" /> </version> <version version="6.4.0-DEV_2024-09-11" versiondate="2024-09-11" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_smileys` DROP `greylocation`;</query> </version> <version version="6.4.0-BETA1-DEV" versiondate="2024-10-12" versionname="Internal"> <query mode="silenterror"> ALTER TABLE `#__kunena_users` ADD `socials` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `ip`; </query> </version> <version version="6.4.0-BETA3-DEV" versiondate="2024-10-26" versionname="Internal"> <!-- Not supported on MySQL the IF EXISTS in ALTER TABLE Like ALTER TABLE `#__kunena_users` DROP IF EXISTS `delicious`; --> <phpfile name="6.4.0-2024-10-21_remove_delicious_socialshare" /> <phpfile name="6.4.0-2024-10-21_update_configuration" /> </version> <version version="6.4.0-RC1-DEV" versiondate="2024-12-15" versionname="Internal"> <query mode="silenterror"> ALTER TABLE `#__kunena_users` CHANGE `bsky_app` `bluesky_app` VARCHAR(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; </query> </version> <version version="6.4.0-RC2-DEV" versiondate="2025-01-15" versionname="Internal"> <query mode="silenterror">UPDATE `#__kunena_users` SET `socials` = '{ "x_social": { "value": "", "url": "https://x.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_X_SOCIAL", "nourl": 0, "fa": "fa-brands fa-x-twitter" }, "facebook": { "value": "", "url": "https://www.facebook.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_FACEBOOK", "nourl": 0, "fa": "fa-brands fa-facebook" }, "myspace": { "value": "", "url": "https://www.myspace.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_MYSPACE", "nourl": 0, "fa": "fa-solid fa-square-share-nodes" }, "linkedin": { "value": "", "url": "https://www.linkedin.com/in/##VALUE##", "title": "COM_KUNENA_MYPROFILE_LINKEDIN", "nourl": 0, "fa": "fa-brands fa-linkedin" }, "linkedin_company": { "value": "", "url": "https://www.linkedin.com/company/##VALUE##", "title": "COM_KUNENA_MYPROFILE_LINKEDIN", "nourl": 0, "fa": "fa-brands fa-linkedin" }, "digg": { "value": "", "url": "https://www.digg.com/users/##VALUE##", "title": "COM_KUNENA_MYPROFILE_DIGG", "nourl": 0, "fa": "fa-brands fa-digg" }, "skype": { "value": "", "url": "skype:##VALUE##", "title": "COM_KUNENA_MYPROFILE_SKYPE", "nourl": 0, "fa": "fa-brands fa-skype" }, "yim": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_YIM", "nourl": 1, "fa": "fa-brands fa-yahoo" }, "google": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_GOOGLE", "nourl": 1, "fa": "fa-brands fa-google" }, "github": { "value": "", "url": "https://www.github.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_GITHUB", "nourl": 0, "fa": "fa-brands fa-github" }, "microsoft": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_MICROSOFT", "nourl": 1, "fa": "fa-brands fa-microsoft" }, "blogspot": { "value": "", "url": "https://##VALUE##.blogspot.com/", "title": "COM_KUNENA_MYPROFILE_BLOGSPOT", "nourl": 0, "fa": "fa-solid fa-square-share-nodes" }, "flickr": { "value": "", "url": "https://www.flickr.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_FLICKR", "nourl": 0, "fa": "fa-brands fa-flickr" }, "instagram": { "value": "", "url": "https://www.instagram.com/##VALUE##/", "title": "COM_KUNENA_MYPROFILE_INSTAGRAM", "nourl": 0, "fa": "fa-brands fa-instagram" }, "qqsocial": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_QQSOCIAL", "nourl": 1, "fa": "fa-solid fa-square-share-nodes" }, "qzone": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_QZONE", "nourl": 1, "fa": "fa-solid fa-square-share-nodes" }, "weibo": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_WEIBO", "nourl": 1, "fa": "fa-brands fa-weibo" }, "wechat": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_WECHAT", "nourl": 1, "fa": "fa-solid fa-square-share-nodes" }, "vk": { "value": "", "url": "https://vk.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_VK", "nourl": 0, "fa": "fa-brands fa-vk" }, "telegram": { "value": "", "url": "https://t.me/##VALUE##", "title": "COM_KUNENA_MYPROFILE_TELEGRAM", "nourl": 0, "fa": "fa-brands fa-telegram" }, "apple": { "value": "", "url": "##VALUE##", "title": "COM_KUNENA_MYPROFILE_APPLE", "nourl": 1, "fa": "fa-brands fa-apple" }, "vimeo": { "value": "", "url": "https://vimeo.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_VIMEO", "nourl": 0, "fa": "fa-brands fa-vimeo" }, "whatsapp": { "value": "", "url": "https://wa.me/##VALUE##", "title": "COM_KUNENA_MYPROFILE_WHATSAPP", "nourl": 0, "fa": "fa-brands fa-whatsapp" }, "youtube": { "value": "", "url": "https://www.youtube.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_YOUTUBE", "nourl": 0, "fa": "fa-brands fa-youtube" }, "ok": { "value": "", "url": "https://ok.ru/##VALUE##", "title": "COM_KUNENA_MYPROFILE_OK", "nourl": 0, "fa": "fa-solid fa-square-share-nodes" }, "pinterest": { "value": "", "url": "https://pinterest.com/##VALUE##", "title": "COM_KUNENA_MYPROFILE_PINTEREST", "nourl": 0, "fa": "fa-brands fa-pinterest" }, "reddit": { "value": "", "url": "https://www.reddit.com/user/##VALUE##", "title": "COM_KUNENA_MYPROFILE_REDDIT", "nourl": 0, "fa": "fa-brands fa-reddit" }, "bluesky_app": { "value": "", "url": "https://bsky.app/##VALUE##", "title": "COM_KUNENA_MYPROFILE_BLUESKY_APP", "nourl": 0, "fa": "fa-brands fa-bluesky" }, "threads": { "value": "", "url": "https://www.threads.net/@##VALUE##", "title": "COM_KUNENA_MYPROFILE_THREADS_APP", "nourl": 0, "fa": "fa-brands fa-threads" } }' WHERE socials IS NULL; </query> <phpfile name="6.4.0-2024-11-02_move_users_socials"/> </version> <version version="6.4.0-RC3-DEV" versiondate="2025-01-16" versionname="Internal"> <phpfile name="6.4.0-2025-01-16_remove_socials_columns"/> <query mode="silenterror">ALTER TABLE `#__kunena_users` MODIFY birthdate date NULL DEFAULT '1000-01-01';</query> </version> <version version="6.4.0-RC4-DEV" versiondate="2025-02-11" versionname="Internal"> <phpfile name="6.4.0-2025-02-11_clean_configuration"/> </version> <version version="6.4.3-DEV" versiondate="2025-06-14" versionname="Internal"> <phpfile name="6.4.0-2025-05-14_fill_kunena_private_table"/> </version> <version version="6.4.5-DEV" versiondate="2025-07-31" versionname="Internal"> <phpfile name="6.4.5-2025-07-30_remove_columns_users_table"/> <version version="6.4.7-DEV" versiondate="2025-11-04" versionname="Internal"> <query mode="silenterror">UPDATE `#__kunena_polls` SET `polltimetolive` = '1000-01-01 00:00:00' WHERE `polltimetolive` IS NULL;</query> <query mode="silenterror">ALTER TABLE `#__kunena_polls` CHANGE `polltimetolive` `polltimetolive` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00';</query> </version> </version> <version version="7.0.0-DEV" versiondate="2025-07-29" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_users` ADD `language` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `ip`</query> </version> <version version="7.0.0-BETA3" versiondate="2025-11-10" versionname="Internal"> <query mode="silenterror">ALTER TABLE `#__kunena_messages` ADD `deleted_time` int(11) NOT NULL default '0' AFTER `moved`</query> </version> <version version="7.0.3" versiondate="2026-03-31" versionname="Berezyanka"> </version> </upgrade> </comupgrade>PK��!�MI�`��`��schema/install.xmlnu��[��<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE schema> <schema> <table name="kunena_aliases"> <field primary_key="yes" name="alias" type="varchar(190)" null="0"/> <field name="type" type="varchar(10)" null="0"/> <field name="item" type="varchar(32)" null="0"/> <field name="state" type="tinyint(4)" null="0" default="0"/> <key name="alias" unique="1" columns="alias"/> <key name="state" columns="state"/> <key name="item" columns="item"/> <key name="type" columns="type"/> </table> <table name="kunena_announcement"> <field primary_key="yes" name="id" type="int(3)" null="0" extra="auto_increment"/> <field name="title" type="tinytext" null="0"/> <field name="created_by" type="int(11)" null="0" default="0"/> <field name="sdescription" type="text" null="0"/> <field name="description" type="text" null="0"/> <field name="created" type="datetime" null="0" default="0000-00-00 00:00:00"/> <field name="published" type="tinyint(1)" null="0" default="0"/> <field name="publish_up" type="datetime" null="0" default="0000-00-00 00:00:00"/> <field name="publish_down" type="datetime" null="0" default="0000-00-00 00:00:00"/> <field name="ordering" type="tinyint(4)" null="0" default="0"/> <field name="showdate" type="tinyint(1)" null="0" default="1"/> <key name="PRIMARY" unique="1" columns="id"/> </table> <table name="kunena_attachments"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="mesid" type="int(11)" null="0" default="0"/> <field name="userid" type="int(11)" null="0" default="0"/> <field name="protected" type="tinyint(4)" null="0" default="0"/> <field name="hash" type="char(32)" null="1"/> <field name="size" type="int(11)" null="1"/> <field name="folder" type="varchar(255)" null="0"/> <field name="filetype" type="varchar(20)" null="0"/> <field name="filename" type="varchar(255)" null="0"/> <field name="filename_real" type="varchar(255)" null="0" default=""/> <field name="caption" type="varchar(255)" null="0" default=""/> <field name="inline" type="tinyint(4)" null="0" default="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="mesid" columns="mesid"/> <key name="userid" columns="userid"/> <key name="hash" columns="hash"/> <key name="filename" columns="filename"/> <key name="filename_real" columns="filename_real"/> </table> <table name="kunena_categories"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="parentid" type="int(11)" null="1" default="0"/> <field name="name" type="tinytext" null="1"/> <field name="alias" type="varchar(255)" null="0"/> <field name="icon" type="varchar(60)" null="0"/> <field name="icon_id" type="tinyint(4)" null="0" default="0"/> <field name="locked" type="tinyint(4)" null="0" default="0"/> <field name="accesstype" type="varchar(20)" null="0" default="joomla.level"/> <field name="access" type="int(11)" null="0" default="0"/> <field name="pubAccess" type="int(11)" null="0" default="1"/> <field name="pubRecurse" type="tinyint(4)" null="1" default="1"/> <field name="adminAccess" type="int(11)" null="0" default="0"/> <field name="adminRecurse" type="tinyint(4)" null="1" default="1"/> <field name="ordering" type="smallint(6)" null="0" default="0"/> <field name="published" type="tinyint(4)" null="0" default="0"/> <field name="channels" type="text" null="1"/> <field name="checked_out" type="int(11)" null="0" default="0"/> <field name="checked_out_time" type="datetime" null="0" default="0000-00-00 00:00:00"/> <field name="review" type="tinyint(4)" null="0" default="0"/> <field name="allowAnonymous" type="tinyint(4)" null="0" default="0"/> <field name="postAnonymous" type="tinyint(4)" null="0" default="0"/> <field name="hits" type="int(11)" null="0" default="0"/> <field name="description" type="text" null="0"/> <field name="headerdesc" type="text" null="0"/> <field name="topictemplate" type="text" null="0"/> <field name="class_sfx" type="varchar(20)" null="0"/> <field name="allowPolls" type="tinyint(4)" null="0" default="0"/> <field name="topicOrdering" type="varchar(16)" null="0" default="lastpost"/> <field name="iconset" type="varchar(255)" null="0" default="default"/> <field name="numTopics" type="mediumint(8)" null="0" default="0"/> <field name="numPosts" type="mediumint(8)" null="0" default="0"/> <field name="last_topic_id" type="int(11)" null="0" default="0"/> <field name="last_post_id" type="int(11)" null="0" default="0"/> <field name="last_post_time" type="int(11)" null="0" default="0"/> <field name="params" type="text" null="0"/> <field name="allowRatings" type="tinyint(4)" null="0" default="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="parentid" columns="parentid"/> <key name="category_access" columns="accesstype,access"/> <key name="published_pubaccess_id" columns="published,pubAccess,id"/> </table> <table name="kunena_configuration"> <field primary_key="yes" name="id" type="int(11)" null="0" default="0"/> <field name="params" type="text" null="1"/> <key name="PRIMARY" unique="1" columns="id"/> </table> <table name="kunena_topics"> <field name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="category_id" type="int(11)" null="0" default="0"/> <field name="subject" type="tinytext" null="1"/> <field name="icon_id" type="int(11)" null="0" default="0"/> <field name="label_id" type="int(11)" null="0" default="0"/> <field name="locked" type="tinyint(4)" null="0" default="0"/> <field name="hold" type="tinyint(4)" null="0" default="0"/> <field name="ordering" type="int(11)" null="0" default="0"/> <field name="posts" type="int(11)" null="0" default="0"/> <field name="hits" type="int(11)" null="0" default="0"/> <field name="attachments" type="int(11)" null="0" default="0"/> <field name="poll_id" type="int(11)" null="0" default="0"/> <field name="moved_id" type="int(11)" null="0" default="0"/> <field name="first_post_id" type="int(11)" null="0" default="0"/> <field name="first_post_time" type="int(11)" null="0" default="0"/> <field name="first_post_userid" type="int(11)" null="0" default="0"/> <field name="first_post_message" type="text" null="1"/> <field name="first_post_guest_name" type="tinytext" null="1"/> <field name="last_post_id" type="int(11)" null="0" default="0"/> <field name="last_post_time" type="int(11)" null="0" default="0"/> <field name="last_post_userid" type="int(11)" null="0" default="0"/> <field name="last_post_message" type="text" null="1"/> <field name="last_post_guest_name" type="tinytext" null="1"/> <field name="rating" type="tinyint" null="6"/> <field name="params" type="text" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="category_id" columns="category_id"/> <key name="locked" columns="locked"/> <key name="hold" columns="hold"/> <key name="posts" columns="posts"/> <key name="hits" columns="hits"/> <key name="first_post_userid" columns="first_post_userid"/> <key name="last_post_userid" columns="last_post_userid"/> <key name="first_post_time" columns="first_post_time"/> <key name="last_post_time" columns="last_post_time"/> <key name="last_post_id" columns="last_post_id"/> </table> <table name="kunena_messages"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="parent" type="int(11)" null="1" default="0"/> <field name="thread" type="int(11)" null="1" default="0"/> <field name="catid" type="int(11)" null="0" default="0"/> <field name="name" type="tinytext" null="1"/> <field name="userid" type="int(11)" null="0" default="0"/> <field name="email" type="tinytext" null="1"/> <field name="subject" type="tinytext" null="1"/> <field name="time" type="int(11)" null="0" default="0"/> <field name="ip" type="varchar(128)" null="1"/> <field name="topic_emoticon" type="int(11)" null="0" default="0"/> <field name="locked" type="tinyint(4)" null="0" default="0"/> <field name="hold" type="tinyint(4)" null="0" default="0"/> <field name="ordering" type="int(11)" null="1" default="0"/> <field name="hits" type="int(11)" null="1" default="0"/> <field name="moved" type="tinyint(4)" null="1" default="0"/> <field name="modified_by" type="int(7)" null="1"/> <field name="modified_time" type="int(11)" null="1"/> <field name="modified_reason" type="tinytext" null="1"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="thread" columns="thread"/> <key name="ip" columns="ip"/> <key name="userid" columns="userid"/> <key name="time" columns="time"/> <key name="locked" columns="locked"/> <key name="hold_time" columns="hold,time"/> <key name="parent_hits" columns="parent,hits"/> <key name="catid_parent" columns="catid,parent"/> </table> <table name="kunena_messages_text"> <field primary_key="yes" name="mesid" type="int(11)" null="0" default="0"/> <field name="message" type="text" null="0"/> <key name="PRIMARY" unique="1" columns="mesid"/> </table> <table name="kunena_polls"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="title" type="varchar(100)" null="0"/> <field name="threadid" type="int(11)" null="0"/> <field name="polltimetolive" type="datetime" null="1"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="threadid" columns="threadid"/> </table> <table name="kunena_polls_options"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="pollid" type="int(11)" null="1"/> <field name="text" type="varchar(100)" null="1"/> <field name="votes" type="int(11)" null="1"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="pollid" columns="pollid"/> </table> <table name="kunena_polls_users"> <field name="pollid" type="int(11)" null="1"/> <field name="userid" type="int(11)" null="1"/> <field name="votes" type="int(11)" null="1"/> <field name="lasttime" type="timestamp" null="0" default="0000-00-00 00:00:00"/> <field name="lastvote" type="int(11)" null="1"/> <key name="pollid" unique="1" columns="pollid,userid"/> </table> <table name="kunena_private"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="parent_id" type="int(11)" null="0" default="0"/> <field name="author_id" type="int(11)" null="0" default="0"/> <field name="created_at" type="datetime" null="0"/> <field name="attachments" type="tinyint(4)" null="0" default="0"/> <field name="subject" type="tinytext" null="0"/> <field name="body" type="text" null="0"/> <field name="params" type="text" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="parent_id" columns="parent_id"/> <key name="author_id" columns="author_id"/> <key name="created_at" columns="created_at"/> </table> <table name="kunena_private_attachment_map"> <field primary_key="yes" name="private_id" type="int(11)" null="0"/> <field primary_key="yes" name="attachment_id" type="int(11)" null="0"/> <key name="PRIMARY" unique="1" columns="private_id,attachment_id"/> <key name="attachment_id" columns="attachment_id"/> </table> <table name="kunena_private_post_map"> <field primary_key="yes" name="private_id" type="int(11)" null="0"/> <field primary_key="yes" name="message_id" type="int(11)" null="0"/> <key name="PRIMARY" unique="1" columns="private_id,message_id"/> <key name="message_id" columns="message_id"/> </table> <table name="kunena_private_user_map"> <field primary_key="yes" name="private_id" type="int(11)" null="0"/> <field primary_key="yes" name="user_id" type="int(11)" null="0"/> <field name="read_at" type="datetime" null="0" default="1000-01-01 00:00:00"/> <field name="replied_at" type="datetime" null="0" default="1000-01-01 00:00:00"/> <field name="deleted_at" type="datetime" null="0" default="1000-01-01 00:00:00"/> <key name="PRIMARY" unique="1" columns="private_id,user_id"/> <key name="user_id" columns="user_id"/> </table> <table name="kunena_ranks"> <field primary_key="yes" name="rankId" type="mediumint(8) unsigned" null="0" extra="auto_increment"/> <field name="rankTitle" type="varchar(255)" null="0" default=""/> <field name="rankMin" type="mediumint(8) unsigned" null="0" default="0"/> <field name="rankSpecial" type="tinyint(1) unsigned" null="0" default="0"/> <field name="rankImage" type="varchar(255)" null="0" default=""/> <key name="PRIMARY" unique="1" columns="rankId"/> </table> <table name="kunena_rate"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field primary_key="yes" name="topic_id" type="int(11)" null="0"/> <field name="userid" type="int(11)" null="0"/> <field name="rate" type="mediumint(8) unsigned" null="0" default="0"/> <field name="time" type="DATETIME" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> </table> <table name="kunena_sessions"> <field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/> <field name="allowed" type="text" null="1"/> <field name="lasttime" type="int(11)" null="0" default="0"/> <field name="readtopics" type="text" null="1"/> <field name="currvisit" type="int(11)" null="0" default="0"/> <key name="PRIMARY" unique="1" columns="userid"/> <key name="currvisit" columns="currvisit"/> </table> <table name="kunena_smileys"> <field primary_key="yes" name="id" type="int(4)" null="0" extra="auto_increment"/> <field name="code" type="varchar(12)" null="0" default=""/> <field name="location" type="varchar(50)" null="0" default=""/> <field name="emoticonbar" type="tinyint(4)" null="0" default="0"/> <key name="PRIMARY" unique="1" columns="id"/> </table> <table name="kunena_thankyou"> <field primary_key="yes" name="postid" type="int(11)" null="0"/> <field primary_key="yes" name="userid" type="int(11)" null="0"/> <field name="targetuserid" type="int(11)" null="0"/> <field name="time" type="datetime" null="0"/> <key name="postid" unique="1" columns="postid,userid"/> <key name="userid" columns="userid"/> <key name="targetuserid" columns="targetuserid"/> </table> <table name="kunena_user_categories"> <field primary_key="yes" name="user_id" type="int(11)" null="0"/> <field primary_key="yes" name="category_id" type="int(11)" null="0"/> <field name="role" type="tinyint(4)" null="0" default="0"/> <field name="allreadtime" type="int(11)" null="0" default="0"/> <field name="subscribed" type="tinyint(4)" null="0" default="0"/> <field name="params" type="text" null="0"/> <key name="PRIMARY" unique="1" columns="user_id,category_id"/> <key name="category_subscribed" columns="category_id,subscribed"/> <key name="role" columns="role"/> </table> <table name="kunena_user_read"> <field primary_key="yes" name="user_id" type="int(11)" null="0"/> <field primary_key="yes" name="topic_id" type="int(11)" null="0"/> <field name="category_id" type="int(11)" null="0"/> <field name="message_id" type="int(11)" null="0"/> <field name="time" type="int(11)" null="0"/> <key name="user_topic_id" unique="1" columns="user_id,topic_id"/> <key name="category_user_id" columns="category_id,user_id"/> <key name="time" columns="time"/> </table> <table name="kunena_user_topics"> <field primary_key="yes" name="user_id" type="int(11)" null="0" default="0"/> <field primary_key="yes" name="topic_id" type="int(11)" null="0" default="0"/> <field name="category_id" type="int(11)" null="0"/> <field name="posts" type="mediumint(8)" null="0" default="0"/> <field name="last_post_id" type="int(11)" null="0" default="0"/> <field name="owner" type="tinyint(4)" null="0" default="0"/> <field name="favorite" type="tinyint(4)" null="0" default="0"/> <field name="subscribed" type="tinyint(4)" null="0" default="0"/> <field name="params" type="text" null="0"/> <key name="user_topic_id" unique="1" columns="user_id,topic_id"/> <key name="topic_id" columns="topic_id"/> <key name="posts" columns="posts"/> <key name="owner" columns="owner"/> <key name="favorite" columns="favorite"/> <key name="subscribed" columns="subscribed"/> </table> <table name="kunena_users"> <field primary_key="yes" name="userid" type="int(11)" null="0" default="0"/> <field name="status" type="tinyint(1)" null="0" default="0"/> <field name="status_text" type="varchar(255)" null="0" default="0"/> <field name="view" type="varchar(8)" null="0" default=""/> <field name="signature" type="text" null="1"/> <field name="moderator" type="int(11)" null="1" default="0"/> <field name="banned" type="datetime" null="1" default="1000-01-01 00:00:00"/> <field name="ordering" type="int(11)" null="1" default="0"/> <field name="posts" type="int(11)" null="1" default="0"/> <field name="avatar" type="varchar(255)" null="1"/> <field name="timestamp" type="int(11)" null="1"/> <field name="karma" type="int(11)" null="1" default="0"/> <field name="group_id" type="int(4)" null="1" default="1"/> <field name="uhits" type="int(11)" null="1" default="0"/> <field name="personalText" type="tinytext" null="1"/> <field name="gender" type="tinyint(4)" null="0" default="0"/> <field name="birthdate" type="date" null="0" default="1000-01-01"/> <field name="location" type="varchar(50)" null="1"/> <field name="websitename" type="varchar(50)" null="1"/> <field name="websiteurl" type="varchar(50)" null="1"/> <field name="rank" type="tinyint(4)" null="0" default="0"/> <field name="hideEmail" type="tinyint(1)" null="0" default="1"/> <field name="showOnline" type="tinyint(1)" null="0" default="1"/> <field name="canSubscribe" type="tinyint(1)" null="0" default="-1"/> <field name="userListtime" type="int(11)" null="1" default="-2"/> <field name="thankyou" type="int(11)" null="1" default="0"/> <field name="ip" type="varchar(128)" null="0" default=""/> <field name="socials" type="text" null="1"/> <key name="PRIMARY" unique="1" columns="userid"/> <key name="group_id" columns="group_id"/> <key name="posts" columns="posts"/> <key name="uhits" columns="uhits"/> <key name="banned" columns="banned"/> <key name="moderator" columns="moderator"/> </table> <table name="kunena_users_banned"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="userid" type="int(11)" null="1"/> <field name="ip" type="varchar(128)" null="1"/> <field name="blocked" type="tinyint(4)" null="0" default="0"/> <field name="expiration" type="datetime" null="1"/> <field name="created_by" type="int(11)" null="0"/> <field name="created_time" type="datetime" null="0"/> <field name="reason_private" type="text" null="1"/> <field name="reason_public" type="text" null="1"/> <field name="modified_by" type="int(11)" null="1"/> <field name="modified_time" type="datetime" null="1"/> <field name="comments" type="text" null="1"/> <field name="params" type="text" null="1"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="userid" columns="userid"/> <key name="ip" columns="ip"/> <key name="expiration" columns="expiration"/> <key name="created_time" columns="created_time"/> </table> <table name="kunena_logs"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="type" type="tinyint(4)" null="0" default="0"/> <field name="user_id" type="int(11)" null="0" default="0"/> <field name="category_id" type="int(11)" null="0" default="0"/> <field name="topic_id" type="int(11)" null="0" default="0"/> <field name="target_user" type="int(11)" null="0" default="0"/> <field name="ip" type="varchar(40)" null="0" default=""/> <field name="time" type="int(11)" null="0" default="0"/> <field name="operation" type="varchar(40)" null="0"/> <field name="data" type="mediumtext" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> <key name="type" columns="type"/> <key name="category_id" columns="category_id"/> <key name="topic_id" columns="topic_id"/> <key name="target_user" columns="target_user"/> <key name="user_id" columns="user_id"/> </table> <table name="kunena_version"> <field primary_key="yes" name="id" type="int(11)" null="0" extra="auto_increment"/> <field name="version" type="varchar(20)" null="0"/> <field name="versiondate" type="date" null="0"/> <field name="installdate" type="date" null="0"/> <field name="build" type="varchar(20)" null="0" default="0"/> <field name="versionname" type="varchar(40)" null="1"/> <field name="state" type="text" null="0"/> <field name="sampleData" type="boolean" null="0"/> <key name="PRIMARY" unique="1" columns="id"/> </table> </schema> PK��!�8��ɶJ��J��mysql/create_tables.utf8.sqlnu��[��CREATE TABLE IF NOT EXISTS `#__kunena_aliases` ( `alias` varchar(191) NOT NULL, `type` varchar(10) NOT NULL, `item` varchar(32) NOT NULL, `state` tinyint(4) NOT NULL default '0', UNIQUE KEY `alias` (alias), KEY `state` (state), KEY `item` (item), KEY `type` (type) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_announcement` ( `id` int(3) NOT NULL auto_increment, `title` tinytext NOT NULL, `created_by` int(11) NOT NULL default '0', `sdescription` text NOT NULL, `description` text NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `published` tinyint(1) NOT NULL default '0', `publish_up` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `publish_down` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `ordering` tinyint(4) NOT NULL default '0', `showdate` tinyint(1) NOT NULL default '1', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_attachments` ( `id` int(11) NOT NULL auto_increment, `mesid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `protected` tinyint(4) NOT NULL default '0', `hash` char(32) NULL, `size` int(11) NULL, `folder` varchar(191) NOT NULL, `filetype` varchar(100) NOT NULL, `filename` varchar(190) NOT NULL, `filename_real` varchar(190) NOT NULL default '' COMMENT 'Filename for downloads', `caption` varchar(191) NOT NULL default '', `inline` tinyint(4) NOT NULL default '0', PRIMARY KEY (id), KEY `mesid` (mesid), KEY `userid` (userid), KEY `hash` (hash), KEY `filename` (filename), KEY `filename_real` (filename_real) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_categories` ( `id` int(11) NOT NULL auto_increment, `parentid` int DEFAULT '0', `name` tinytext NULL, `alias` varchar(191) NOT NULL, `icon` varchar(50) NOT NULL, `icon_id` tinyint(4) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', `accesstype` varchar(20) NOT NULL default 'joomla.level', `access` int(11) NOT NULL default '0', `pubAccess` int NOT NULL DEFAULT '1', `pubRecurse` tinyint DEFAULT '1', `adminAccess` int NOT NULL DEFAULT '0', `adminRecurse` tinyint DEFAULT '1', `ordering` int(11) NOT NULL default '0', `published` tinyint(4) NOT NULL default '0', `channels` text NULL, `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `review` tinyint(4) NOT NULL default '0', `allowAnonymous` tinyint NOT NULL DEFAULT '0', `postAnonymous` tinyint NOT NULL DEFAULT '0', `hits` int(11) NOT NULL default '0', `description` text NOT NULL, `headerdesc` text NOT NULL, `topictemplate` text NOT NULL, `class_sfx` varchar(20) NOT NULL, `allowPolls` tinyint NOT NULL DEFAULT '0', `topicOrdering` varchar(16) NOT NULL default 'lastpost', `iconset` varchar(191) NULL DEFAULT NULL, `numTopics` mediumint(8) NOT NULL default '0', `numPosts` mediumint(8) NOT NULL default '0', `last_topic_id` int(11) NOT NULL default '0', `last_post_id` int(11) NOT NULL default '0', `last_post_time` int(11) NOT NULL default '0', `params` text NOT NULL, `allowRatings` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (id), KEY `parentid` (parentid), KEY `category_access` (accesstype, access), KEY `published_pubaccess_id` (published, pubAccess, id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_karma` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` int(11) NOT NULL, `target_userid` int(11) NOT NULL, `time` int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_topics` ( `id` int(11) NOT NULL auto_increment, `category_id` int(11) NOT NULL default '0', `subject` tinytext NULL, `icon_id` int(11) NOT NULL default '0', `label_id` int(11) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', `hold` tinyint(4) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `posts` int(11) NOT NULL default '0', `hits` int(11) NOT NULL default '0', `attachments` int(11) NOT NULL default '0', `poll_id` int(11) NOT NULL default '0', `moved_id` int(11) NOT NULL default '0', `first_post_id` int(11) NOT NULL default '0', `first_post_time` int(11) NOT NULL default '0', `first_post_userid` int(11) NOT NULL default '0', `first_post_message` text NULL, `first_post_guest_name` tinytext NULL, `last_post_id` int(11) NOT NULL default '0', `last_post_time` int(11) NOT NULL default '0', `last_post_userid` int(11) NOT NULL default '0', `last_post_message` text NULL, `last_post_guest_name` tinytext NULL, `rating` tinyint(6) NOT NULL default '0', `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (id), KEY `category_id` (category_id), KEY `locked` (locked), KEY `hold` (hold), KEY `posts` (posts), KEY `hits` (hits), KEY `first_post_userid` (first_post_userid), KEY `last_post_userid` (last_post_userid), KEY `first_post_time` (first_post_time), KEY `last_post_time` (last_post_time), KEY `last_post_id` (last_post_id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_messages` ( `id` int(11) NOT NULL auto_increment, `parent` int(11) NULL default '0', `thread` int(11) NULL default '0', `catid` int(11) NOT NULL default '0', `name` tinytext NULL, `userid` int(11) NOT NULL default '0', `email` tinytext NULL, `subject` tinytext NULL, `time` int(11) NOT NULL default '0', `ip` varchar(128) NULL, `topic_emoticon` int(11) NOT NULL default '0', `locked` tinyint(4) NOT NULL default '0', `hold` tinyint(4) NOT NULL default '0', `ordering` int(11) NULL default '0', `hits` int(11) NULL default '0', `moved` tinyint(4) NULL default '0', `deleted_time` int(11) NOT NULL default '0', `modified_by` int(7) NULL, `modified_time` int(11) NULL, `modified_reason` tinytext NULL, PRIMARY KEY (id), KEY `thread` (thread), KEY `ip` (ip), KEY `userid` (userid), KEY `locked` (locked), KEY `parent_hits` (parent, hits), KEY `catid_parent` (catid, parent), KEY `time_hold` (time, hold), KEY `hold` (hold) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_messages_text` ( `mesid` int(11) NOT NULL default '0', `message` mediumtext NOT NULL, PRIMARY KEY (mesid) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_polls` ( `id` int(11) NOT NULL auto_increment, `title` varchar(150) NOT NULL, `threadid` int(11) NOT NULL, `polltimetolive` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', PRIMARY KEY (id), KEY `threadid` (threadid) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_polls_options` ( `id` int(11) NOT NULL auto_increment, `pollid` int(11) NULL, `text` varchar(100) NULL, `votes` int(11) NULL, PRIMARY KEY (id), KEY `pollid` (pollid) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_polls_users` ( `pollid` int(11) NULL, `userid` int(11) NULL, `votes` int(11) NULL, `lasttime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `lastvote` int(11) NULL, UNIQUE KEY `pollid` (pollid, userid) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_private` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `author_id` int(11) NOT NULL default '0', `created_at` datetime NOT NULL, `attachments` tinyint(4) NOT NULL default '0', `subject` tinytext NOT NULL, `body` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `author_id` (`author_id`), KEY `created_at` (`created_at`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_private_attachment_map` ( `private_id` int(11) NOT NULL, `attachment_id` int(11) NOT NULL, PRIMARY KEY (`private_id`, `attachment_id`), KEY `attachment_id` (`attachment_id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_private_post_map` ( `private_id` int(11) NOT NULL, `message_id` int(11) NOT NULL, PRIMARY KEY (`private_id`, `message_id`), KEY `message_id` (`message_id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_private_user_map` ( `private_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `read_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `replied_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`private_id`, `user_id`), KEY `user_id` (`user_id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_ranks` ( `rankId` mediumint UNSIGNED NOT NULL AUTO_INCREMENT, `rankTitle` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `rankMin` mediumint UNSIGNED NOT NULL DEFAULT '0', `rankSpecial` tinyint UNSIGNED NOT NULL DEFAULT '0', `rankImage` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (rankId) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_rate` ( `id` int(11) NOT NULL auto_increment, `topic_id` int(11) NULL, `userid` int(11) NULL, `rate` mediumint(8) unsigned NOT NULL default '0', `time` datetime NOT NULL, PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_sessions` ( `userid` int(11) NOT NULL default '0', `allowed` text NULL, `lasttime` int(11) NOT NULL default '0', `readtopics` text NULL, `currvisit` int(11) NOT NULL default '0', PRIMARY KEY (userid), KEY `currvisit` (currvisit) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_smileys` ( `id` int(4) NOT NULL auto_increment, `code` varchar(12) NOT NULL default '', `location` varchar(50) NOT NULL default '', `emoticonbar` tinyint(4) NOT NULL default '0', PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_thankyou` ( `postid` int(11) NOT NULL, `userid` int(11) NOT NULL, `targetuserid` int(11) NOT NULL, `time` datetime NOT NULL, UNIQUE KEY `postid` (postid, userid), KEY `userid` (userid), KEY `targetuserid` (targetuserid) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_user_categories` ( `user_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `role` tinyint(4) NOT NULL default '0', `allreadtime` int(11) NOT NULL default '0', `subscribed` tinyint(4) NOT NULL default '0', `params` text NULL, PRIMARY KEY (user_id, category_id), KEY `category_subscribed` (category_id, subscribed), KEY `role` (role) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_user_read` ( `user_id` int(11) NOT NULL, `topic_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `message_id` int(11) NOT NULL, `time` int(11) NOT NULL, UNIQUE KEY `user_topic_id` (user_id, topic_id), KEY `category_user_id` (category_id, user_id), KEY `time` (time) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_user_topics` ( `user_id` int(11) NOT NULL default '0', `topic_id` int(11) NOT NULL default '0', `category_id` int(11) NOT NULL, `posts` mediumint(8) NOT NULL default '0', `last_post_id` int(11) NOT NULL default '0', `owner` tinyint(4) NOT NULL default '0', `favorite` tinyint(4) NOT NULL default '0', `subscribed` tinyint(4) NOT NULL default '0', `params` text NULL, UNIQUE KEY `user_topic_id` (user_id, topic_id), KEY `topic_id` (topic_id), KEY `posts` (posts), KEY `owner` (owner), KEY `favorite` (favorite), KEY `subscribed` (subscribed) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_users` ( `userid` int(11) NOT NULL default '0', `status` tinyint(1) NOT NULL DEFAULT '0', `status_text` varchar(191) NOT NULL DEFAULT '', `view` varchar(8) NOT NULL default '', `signature` text NULL, `moderator` int(11) NULL default '0', `banned` datetime DEFAULT '1000-01-01 00:00:00', `ordering` int(11) NULL default '0', `posts` int(11) NULL default '0', `avatar` varchar(191) NULL, `timestamp` int(11) NULL default '0', `karma` int(11) NULL default '0', `group_id` int(4) NULL default '1', `uhits` int(11) NULL default '0', `personalText` tinytext NULL, `gender` tinyint(4) NOT NULL default '0', `birthdate` date NULL DEFAULT '1000-01-01', `location` varchar(50) NULL, `websitename` varchar(50) NULL, `websiteurl` varchar(50) NULL, `rank` tinyint(4) NOT NULL default '0', `hideEmail` tinyint(1) NOT NULL default '1', `showOnline` tinyint(1) NOT NULL default '1', `canSubscribe` tinyint(1) NOT NULL default '-1', `userListtime` int(11) NULL default '-2', `thankyou` int(11) NULL default '0', `ip` varchar(125) NULL, `language` text NULL, `socials` text NULL, PRIMARY KEY (userid), KEY `group_id` (group_id), KEY `posts` (posts), KEY `uhits` (uhits), KEY `banned` (banned), KEY `moderator` (moderator) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_users_banned` ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NULL, `ip` varchar(128) NULL, `blocked` tinyint(4) NOT NULL default '0', `expiration` datetime NULL DEFAULT NULL, `created_by` int(11) NOT NULL, `created_time` datetime NOT NULL, `reason_private` text NULL, `reason_public` text NULL, `modified_by` int(11) NULL, `modified_time` datetime NULL DEFAULT NULL, `comments` text NULL, `params` text NULL, PRIMARY KEY (id), KEY `userid` (userid), KEY `ip` (ip), KEY `expiration` (expiration), KEY `created_time` (created_time) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__kunena_logs` ( `id` int(11) NOT NULL auto_increment, `type` tinyint(4) NULL, `user_id` int(11) NULL, `category_id` int(11) NULL, `topic_id` int(11) NULL, `target_user` int(11) NULL, `ip` varchar(40) NULL, `time` int(11) NULL, `operation` varchar(40) NULL, `data` mediumtext NULL, PRIMARY KEY (id), KEY `type` (type), KEY `category_id` (category_id), KEY `topic_id` (topic_id), KEY `target_user` (target_user), KEY `user_id` (user_id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__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) NOT NULL, `versionname` varchar(40) NULL, `sampleData` boolean NOT NULL default 1, `state` text NOT NULL, PRIMARY KEY (id) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci; PK��!�K��default.xmlnu��[��PK��!�T�Z��default.phpnu��[��PK��!�eT��9��sql/updates/php/6.4.0-2024-10-21_update_configuration.phpnu��[��PK��!�Ҁd�v��v��>��n��sql/updates/php/6.4.0-2025-05-14_fill_kunena_private_table.phpnu��[��PK��!�\|t�A��;��R��sql/updates/php/6.4.0-2025-01-16_remove_socials_columns.phpnu��[��PK��!�H+�f��f��A��#��sql/updates/php/6.4.0-2024-10-21_remove_delicious_socialshare.phpnu��[��PK��!�@ d&��&��:��c)��sql/updates/php/5.2.15-2021-07-24_update_configuration.phpnu��[��PK��!��^��7��A��sql/updates/php/6.4.0-2024-11-02_move_users_socials.phpnu��[��PK��!��G��)Q��sql/updates/php/6.0.2-2022-07-30_rss_timelimit_configuration_change.phpnu��[��PK��!�)�\|��G��V��sql/updates/php/6.2.4-2022-01-24_change_collation_columns_on_tables.phpnu��[��PK��!�8�q��?��h��sql/updates/php/6.4.5-2025-07-30_remove_columns_users_table.phpnu��[��PK��!��m�:3��:3��8��m��sql/updates/php/6.4.0-2025-02-11_clean_configuration.phpnu��[��PK��!�}��w^��^��D��h��sql/updates/php/5.2.15-2021-08-24_configuration_default_template.phpnu��[��PK��!�34��>��:��sql/updates/php/6.3.4-2024-08-01_update_configuration_to_x.phpnu��[��PK��!��1%��5��sql/updates/php/5.2.0-2020-08-20_updaterankstitle.phpnu��[��PK��!�:��B�q��q��'��kunena.install.upgrade.xmlnu��[��PK��!�MI�`��`��66�schema/install.xmlnu��[��PK��!�8��ɶJ��J��غ�mysql/create_tables.utf8.sqlnu��[��PK��

| ver. 1.1 | | . | PHP 8.4.18 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ ÑÑ‚Ñ€Ð°Ð½Ð¸Ñ†Ñ‹: 0.02 | proxy | phpinfo | ÐÐ°ÑÑ‚Ñ€Ð¾Ð¹ÐºÐ°