Chevereto v3

Chevereto v3.16.0 已發布

今天 Chevereto 發佈 v3.16.0 版本,添加了 ModerateContent 審核工具、oEmbed 的支援以及許多修復。

詳細的內容可以看 Chevereto v3.16.0 發行說明

如果已經安裝了 Chevereto,則可以直接從後台控制台面板中一鍵式更新

更新過程中,會去進行數據庫更新所需的 SQL 語句,這些語句必須直接在 SQL 控制台 (phpMyAdmin) 中運行。

請加入以下的語法,然後點取「執行」

CREATE TABLE `chv_locks` (
 `lock_id` bigint(20) NOT NULL AUTO_INCREMENT,
 `lock_name` varchar(255) NOT NULL,
 `lock_date_gmt` datetime NOT NULL,
 `lock_expires_gmt` datetime DEFAULT NULL,
 PRIMARY KEY (`lock_id`),
 KEY `lock_date_gmt` (`lock_date_gmt`),
 KEY `lock_expires_gmt` (`lock_expires_gmt`),
 UNIQUE KEY `lock_name` (`lock_name`(191)) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `chv_images` ADD `image_is_approved` tinyint(1) NOT NULL DEFAULT '1'; 
ALTER TABLE `chv_images` ADD KEY `image_is_approved` (`image_is_approved`);
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('moderatecontent', '0', '0', 'bool'); 
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('moderatecontent_key', '', '', 'string'); 
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('moderatecontent_block_rating', 'a', 'a', 'string'); 
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('moderatecontent_flag_nsfw', 'a', 'a', 'string'); 
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('moderatecontent_auto_approve', '0', '0', 'bool'); 
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('moderate_uploads', '', '', 'string'); 
INSERT INTO `chv_settings` (setting_name, setting_value, setting_default, setting_typeset) VALUES ('image_lock_nsfw_editing', '0', '0', 'bool'); 

UPDATE `chv_settings` SET `setting_value` = "3.16.0" WHERE `setting_name` = "chevereto_version_installed";
UPDATE `chv_settings` SET `setting_value` = 0 WHERE `setting_name` = "maintenance";

發表迴響