| Server IP : 184.154.167.98 / Your IP : 18.227.102.228 Web Server : Apache System : Linux pink.dnsnetservice.com 4.18.0-553.22.1.lve.1.el8.x86_64 #1 SMP Tue Oct 8 15:52:54 UTC 2024 x86_64 User : puertode ( 1767) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/puertode/public_html/mesa/include/upgrader/streams/core/ |
Upload File : |
/**
* @signature e7dfe82131b906a14f6a13163943855f
* @version v1.11.0
* @title Nested Knowledgebase Categories
*
* This patch adds a new field, category_pid, to the faq_category table
* to allow for adding nested categories to the knowledgebase.
*/
ALTER TABLE `%TABLE_PREFIX%faq_category`
ADD `category_pid` int(10) unsigned DEFAULT NULL AFTER `category_id`;
-- Phone Field `name` and `flags`
UPDATE `%TABLE_PREFIX%form_field`
SET `flags` = `flags` + 262144
WHERE `type` = 'phone' AND `name` = 'phone' AND `form_id` = 1 AND `id` < 10;
-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
SET `value` = 'e7dfe82131b906a14f6a13163943855f'
WHERE `key` = 'schema_signature' AND `namespace` = 'core';