amh虚拟主机?zpanel windows?免费主机管理面板：ZPanel简单介绍(2)

============proftpd库（实际上我觉得这一部分做不做无所谓）===========
ALTER TABLE `ftpgroup` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `ftpquotalimits` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `ftpquotatallies` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `ftpuser` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

============roundcube库===========
ALTER TABLE `cache` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `contactgroupmembers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `contactgroups` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `contacts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `identities` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `messages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `session` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

注意，上面的SQL执行过程可能有报错，赵容在3台VPS上测试，每台都有报错的情况，但不影响最终的汉化结果，不过，您有能力的话，可以针对报错内容修改执行。

2.修改文件，先修改/etc/zpanel/panel/dryden/db/driver.class.php文件，找到

public function query($query) {   try {

在try里面加入

$FIXSql1 = “set character_set_server=utf8”;   $FIXSql2 = “set names utf8”;   $FIX = parent::query($FIXSql1);   $FIX2 =parent::query($FIXSql2);

保存。

然后，接着修改/etc/zpanel/panel/etc/styles/zpanelx/master.ztml，找到

以上就是关于zpanel的全部内容，相信你一定会非常满意。

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-19678-2.html