getWeather({"success":"1","result":[{"cityno":"shanghai"})
爱秀代码 - Powered by Discuz! Board
标题: [教学] 插件数据库 [打印本页]
作者: icode 时间: 2020-4-5 13:54 标题: 插件数据库
点评(楼中楼)- CREATE TABLE `zy_postinner` (
- `uid` INT( 8 ) NOT NULL ,
- `name` CHAR( 15 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- `pid` INT( 15 ) NOT NULL ,
- `ptid` INT( 15 ) NOT NULL ,
- `msg` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- `time` INT( 10 ) NOT NULL
- ) ENGINE = MYISAM ;
- ALTER TABLE `cdb_posts` ADD `zy_postinner` INT( 5 ) NOT NULL ;
复制 艾特- ALTER TABLE `cdb_posts` ADD `zy_at` INT NOT NULL ;
- ALTER TABLE `cdb_posts` CHANGE `zy_at` `zy_at` VARCHAR( 32 ) NOT NULL;
- CREATE TABLE `zy_at` (
- `aid` INT NOT NULL ,
- `ater` VARCHAR( 45 ) NOT NULL ,
- `title` VARCHAR( 300 ) NOT NULL ,
- `date` INT NOT NULL ,
- `atman` VARCHAR( 45 ) NOT NULL ,
- `readed` SMALLINT NOT NULL ,
- `tid` INT NOT NULL ,
- `pid` INT NOT NULL ,
- `floor` INT NOT NULL
- ) ENGINE = MYISAM ;
- ALTER TABLE `cdb_members` ADD `zy_at` INT NOT NULL ;
- ALTER TABLE `zy_at` ADD PRIMARY KEY ( `aid` );
- ALTER TABLE `zy_at` CHANGE `ater` `ater` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
- ALTER TABLE `zy_at` CHANGE `title` `title` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
- ALTER TABLE `zy_at` CHANGE `atman` `atman` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
- ALTER TABLE `cdb_posts` ADD `zy_at_man` TEXT NOT NULL ;
- ALTER TABLE `cdb_posts` CHANGE `zy_at_man` `zy_at_man` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
复制 聊天室- CREATE TABLE `zy_chatroom` (
- `pid` INT( 10 ) NOT NULL ,
- `uid` INT( 10 ) NOT NULL ,
- `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- `message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- `time` INT( 15 ) NOT NULL
- ) ENGINE = MYISAM ;
复制 回帖奖励- ALTER TABLE `cdb_posts` ADD `zy_replyaward` TEXT NOT NULL ;
- ALTER TABLE `cdb_threads` ADD `zy_replyaward` TEXT NOT NULL ;
复制 许愿墙- CREATE TABLE `zy_lovewall` (
- `uid` INT( 10 ) NOT NULL ,
- `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- `pid` INT( 10 ) NOT NULL ,
- `message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
- `x` INT( 3 ) NOT NULL ,
- `y` INT( 3 ) NOT NULL ,
- `paper` INT( 3 ) NOT NULL ,
- `time` INT( 11 ) NOT NULL
- ) ENGINE = MYISAM ;
复制 发帖机遇- CREATE TABLE zy_ftjy (
- jid int(10),
- word text,
- credit int(6),
- min int(6),
- max int(6),
- rate int(4),
- kind tinyint(1)
- );
- ALTER TABLE `zy_ftjy` ADD PRIMARY KEY ( `jid` );
- INSERT INTO zy_ftjy (jid,word,credit,min,max,rate,kind) VALUES (0,"",0,10,10,0,0);
- ALTER TABLE `cdb_posts` ADD `zy_jiyu` INT(11) NOT NULL ;
- ALTER TABLE `cdb_posts` ADD `zy_get` INT(6) NOT NULL ;
- UPDATE cdb_posts SET zy_jiyu = -1;
- ALTER TABLE `zy_ftjy` CHANGE `word` `word` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
复制 帖子脚印- ALTER TABLE `cdb_threads` ADD `zy_footprint` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
复制
作者: 天使小小 时间: 2020-4-6 09:47
还有这个数据库没有,游客打开帖子内容页是这样的。
图片附件: 123.png (2020-4-6 09:46, 20.74 KB) / 下载次数 726
http://icode.258club.com/attachment.php?aid=768&k=c8364a1478fb1b8f071e370d616de09c&t=1716303011&sid=SLHlIh
作者: 天使小小 时间: 2020-4-6 09:51
还有这个数据库没有,游客打开帖子内容页是这样的。
图片附件: 123.png (2020-4-6 09:51, 20.74 KB) / 下载次数 782
http://icode.258club.com/attachment.php?aid=769&k=bd7b9d9781f2f9f5dff4fbca575f1c26&t=1716303011&sid=SLHlIh
作者: icode 时间: 2020-4-6 12:45
回复 3# 天使小小
viewthread_fastpost.htm恢复为默认模板
作者: 天使小小 时间: 2020-4-9 10:15
回复 4# icode
模板还有很多数据库问题,请问能不能把你整个数据库导出来,让我导入我论坛内这样可以解决到很多模板的数据问题吗?
欢迎光临 爱秀代码 (http://icode.258club.com/) |
Powered by Discuz! 7.2 |