// +———————————————————————-
// | 主机管理 By Bty3.0
// +———————————————————————-
// | Copyright (c) 2019 https://www.youngxj.cn
// +———————————————————————-
// | Author: Youngxj 1170535111@qq.com
// +——————————————————————–

更新时间:
2019年6月30日

发布人:
Youngxj

更新介绍:
1、修复一些细节
2、修复一处安全漏洞
3、ep增加设置网站运行目录
4、优化注册表单及提示
5、兑换码导出txt
6、导入主机
7、模板管理(添加模板)
8、首页多模板切换
9、新增用户组及优惠率(新开、续费自定义)
10、后台调整主机配置(主机归属,网站、数据库、流量大小调整,域名绑定限制)
11、支付宝官方支付(微信暂不支持)

sql:

INSERT INTO `bty_epgroups` (`epid`, `name`, `router`, `pid`) VALUES (NULL, '网站运行目录', 'runpath', NULL);
INSERT INTO `bty_epgroups` (`epid`, `name`, `router`, `pid`) VALUES (NULL, '修改网站运行目录', 'setsiterunpath', '64');
ALTER TABLE `bty_webinfo` ADD `indextheme` INT(11) NOT NULL COMMENT '首页主页模板' AFTER `debug`;
ALTER TABLE `bty_theme` ADD `type` VARCHAR(255) NOT NULL COMMENT '主题类型' AFTER `file`;
UPDATE `bty_theme` SET `type` = 'ep' WHERE `id` = 1;
UPDATE `bty_theme` SET `type` = 'ep' WHERE `id` = 2;
INSERT INTO `bty_theme` (`id`, `name`, `file`, `type`) VALUES (NULL, '默认首页模板', 'default', 'index');
UPDATE `bty_webinfo` SET `indextheme` = '3' WHERE `bty_webinfo`.`id` = 1;

DROP TABLE IF EXISTS `bty_usergroup`;
CREATE TABLE `bty_usergroup` (
  `ugid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '组名',
  `status` int(11) NOT NULL DEFAULT '1' COMMENT '全组用户的状态;0->禁用;1->启用',
  `buydiscount` text COMMENT 'json格式的优惠率,使用wid作为关键件',
  `xfdiscount` text COMMENT '续费优惠率同上配置项',
  PRIMARY KEY (`ugid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户组';

INSERT INTO `bty_usergroup` VALUES (1,'普通会员',1,NULL,NULL);

ALTER TABLE `bty_user` ADD `gid` INT(11) NOT NULL DEFAULT '1' COMMENT '用户组ID' AFTER `ivr`;

CREATE TABLE `bty_alipayconfig` (
    `id` INT NOT NULL AUTO_INCREMENT ,
    `app_id` TEXT NOT NULL COMMENT 'APPID' ,
    `notify_url` TEXT NOT NULL COMMENT '异步回调地址' ,
    `return_url` TEXT NOT NULL COMMENT '同步回调地址' ,
    `ali_public_key` TEXT NOT NULL COMMENT '支付宝公钥' ,
    `private_key` TEXT NOT NULL COMMENT '应用私钥' ,
    `debug` INT NOT NULL DEFAULT '0' COMMENT 'debug模式0->关闭;1->开启' ,
    `status` INT NOT NULL DEFAULT '0' COMMENT '启用状态0->禁用;1->启用',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB COMMENT = '阿里官方支付配置表';

INSERT INTO `bty_alipayconfig` (`id`, `app_id`, `notify_url`, `return_url`, `ali_public_key`, `private_key`, `debug`, `status`) VALUES (NULL, '2016100200644066', '/alipay_notify.html', '/alipay_return.html', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAp8JQzaTkMNcIQC1YtgDasdo1PMMg92lSGxCQl1NfuBnTbKGZbsR2z4mePdaXC8Z4em9aYrE73+IjM6MzYh7Y6i9v7q1MI2Q3DUWRx2XE1WWT83xCJjcJTDhZLizF70HHHxSUWWgDqEBuoTAUHiBKFG2PTbyskfTmQapWEbzzieDzPYw32FKxGbh4k3eqEjJUaGctbbMlmVuc+hhAr3cTjhJmZxx85gQsgVHxJq4aj4T/JBuj+/TYEEp2ndndWA+VIJIqrCZrmmXufx54LS54NA8nkvquMRMiV5ziQ07Jcu0vDrHN6cdM6MISCXVAjbBT30oDSiXMB3CvPNw+YnTgwwIDAQAB', 'MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCmBiXHO1LZtHuQjD0YaZsb7PDioSTJDe78xia0OWXsR9APhWZL67uQl/VaepJlkmDevlmzpKlQIjMITLuG/wF0aqFqeYuT4zFuSWo9deIXJQB+4DUN0iw1hJZL8q5Ig2PKhyxboWIiiZaJmw3FYdnfFINRI9fFTKIuc6cBNsdHHhFxd6+k7Biesid/uTTF2QRFSiO4x541n5iLwuJCV1Gsnla+AprNtC8fwZdFbn+RibhyFWmhfUTX7IkXzeJDtqygcQlHU9J4Qm0+DNWS8UFE4SDEtXqtnIfTHhreZpW8mUsosj/CKPg20CB3Zyx1u50l1vcEiaNW9tNc8Rd2ww27AgMBAAECggEAFDfZb+rEiyiUh6TcZ9WsgvkW2LKBFU7yFKxY2EfJJr4UE1/Odl5tyA0JXwxgOahazaVmrR7XU5/mkRMvHyB8392AbMQCgG8BfQnJu1RYxTLHXawWKem3YokT+InEOaZuh6Jwf3QmzEfvIjDUu33QF3+bAk2YIDnV4kxJQTeXiwxmji8i15nk6A59R9BztKx0np3AtMXwij5eGgOkZlNb8SxmCqaezJQZ8lV+HSeJzLxxXmDLVJWSsh7tUsqFBOVHjAzdFVXzAxQDGVoqexE6XBMvuFEVREU9OPtdiANOqxjQJJdGoqeBhwbTdQUm3zjl+WHfg0gitYyIms0exGNpMQKBgQDwAWBbruepVxHqDsEnq/8pS9oZstaUDcGmqdLnB/7kDSRFh+/cyvkWpkOYK9fi2UqvYIVxB7Jp9/RZv7BBws0w2tbqL4Go0bBP9FNIYKiV502y+q9H1bv6IZVA+IIgcSDI9+yKvGvYNTtMuYg0LuSVHhRQr413gOrytMKh0MiiOQKBgQCxFpvFCbh2RiNCqPNRvW8xUjZrhJb1r2yDLOhds+wAi/7jRsu2DKVEV0C3c/17Yj4BcLHy+avUDW77GeSaAsdnhW++mfwr3PBpplH7oJI01ZZi7meozuEt3/ZHVG6e2kIp75y03UEMbDD1XMn2oPs9NCBpahID8YckMtsLEzEfkwKBgHATdHfb+XpumoL+WNy5yPHz5elSRjnlIqU9cKtKZJECQgnmLPCiKCeXhMEu2CWq6uFy5V2fBoXNsGGozhonacKCrxG1FYtMQFVV9v45hQBbf0ExJ2EYQivQOu6YHcwgh/rRK7itvH6+fO6bRSt5Km0oGryC/kDsBstH9guyf76hAoGBAJICNQ7BlACYlav5hxznFs3QniQKHzmUmOCS30ea+EP/KXoUvhNs27q8QhTAIshfWQZw95eBOaZOKSoJ0E0Xa3e0Mk0xwxQbR3Gke0X/v2ymiicpr/gkEs9zMCjhuY9qH1FaSZdqMZ7feYJkLfUWB/APkYW4uf/cXXOAJtA7063XAoGBAN7RwEl+YqSjnaM0hEJF25cib14lwvwWJVb3MUf0o50m4KA0Evs07QffkgxC6cj2gCy/fzADyZ4rHXB7bvSmlmd2wua66+xCWzrf/Z2ImVSHVrvzWm3CBDBj6e6kqUBmTkEhtHoiNfE5IsxVFciDZnQm5ukPmP5Ni656705ufoE4', '0','1');

INSERT INTO `bty_payconfig` (`id`, `partner`, `key`, `ssl`, `apiurl`, `notify_url`, `return_url`, `open`, `status`) VALUES (NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, '1');

涉及文件:

等等……

文档更新时间: 2019-07-09 12:36   作者:Youngxj