Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.4.15.10
- -- https://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: 2019-07-23 20:55:47
- -- 服务器版本: 5.7.25-log
- -- PHP Version: 5.4.45
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `FFXIV`
- --
- -- --------------------------------------------------------
- --
- -- 表的结构 `ffxivbot_monster`
- --
- CREATE TABLE IF NOT EXISTS `ffxivbot_monster` (
- `id` int(11) NOT NULL,
- `name` varchar(32) NOT NULL,
- `cn_name` varchar(32) NOT NULL,
- `rank` varchar(5) NOT NULL,
- `spawn_cooldown` int(11) NOT NULL,
- `first_spawn_cooldown` int(11) NOT NULL,
- `pop_cooldown` int(11) NOT NULL,
- `first_pop_cooldown` int(11) NOT NULL,
- `info` varchar(128) NOT NULL,
- `status` longtext NOT NULL,
- `territory_id` int(11) NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
- --
- -- 转存表中的数据 `ffxivbot_monster`
- --
- INSERT INTO `ffxivbot_monster` (`id`, `name`, `cn_name`, `rank`, `spawn_cooldown`, `first_spawn_cooldown`, `pop_cooldown`, `first_pop_cooldown`, `info`, `status`, `territory_id`) VALUES
- (30, 'Croque-mitaine', '护土精灵', 'S', 234000, 140400, 270000, 162000, 'ET19:00-22:00,采集“3级拉诺西亚土壤” (第8格),坐标 (x23,y26)', '{}', 7),
- (31, 'Croakadile', '咕尔呱洛斯', 'S', 180000, 108000, 180000, 108000, '起始触发时间为满月(ET17:00)时溜达触发.持续时间16-20日每天晚上', '{}', 8),
- (32, 'the Garlok', '伽洛克', 'S', 151200, 75600, 172800, 104400, '连续200分钟(现实时间)不下雨', '{}', 10),
- (33, 'Bonnacon', '火愤牛', 'S', 234000, 140400, 270000, 162000, 'ET 8:00-11:00,采集“拉诺西亚韭菜” (第6格),坐标 (x33,y27)', '{}', 11),
- (34, 'Nandi', '南迪', 'S', 169200, 100800, 190800, 115200, '带着宠物在刷新点附近遛达,可骑坐骑', '{}', 12),
- (35, 'Chernobog', '牛头黑神', 'S', 234000, 140400, 255600, 154800, '玩家死亡触发', '{}', 49),
- (36, 'Laideronnette', '雷德罗巨蛇', 'S', 151200, 90000, 172800, 104400, '连续两个雨天期间,在第2个雨天的第2个小时刷新 (艾欧泽亚小时)', '{}', 21),
- (37, 'Wulgaru', '乌尔伽鲁', 'S', 237600, 140400, 280800, 169200, '开启战斗理符触发 (军队理符亦可触发)', '{}', 25),
- (38, 'Mindflayer', '夺心魔', 'S', 180000, 108000, 180000, 108000, '起始触发时间为新月凌晨(ET0:00)时溜达触发.持续时间1-4日每天晚上', '{}', 26),
- (39, 'Thousand-cast Theda', '千竿口花希达', 'S', 205200, 122400, 226800, 136800, 'ET17:00-21:00 钓“审判瑶”,钓场:秋瓜湖畔 (x21,y26),鱼饵:雉鸡拟饵,需345获得力', '{}', 27),
- (40, 'Zona Seeker', '虚无探索者', 'S', 205200, 122400, 226800, 136800, '碧空或晴朗钓“铜镜”,钓场:丰饶神井 (x24,y21) 鱼饵:黄油虫,需292获得力', '{}', 13),
- (41, 'Brontes', '布隆特斯', 'S', 237600, 140400, 280800, 169200, '在刷新点附近吃食物触发', '{}', 14),
- (42, 'Lampalagua', '巴拉乌尔', 'S', 237600, 140400, 280800, 169200, '开启战斗理符触发 (军队理符亦可触发)', '{}', 18),
- (43, 'Nunyunuwi', '努纽努维', 'S', 158400, 93600, 194400, 118800, '一小时内地图中所有类型FATE都被触发并且成功完成,5个触发型fate坐标(25.12)(17.18)(21.19)(17.24)(19.35)', '{}', 19),
- (44, 'Minhocao', '蚓螈巨虫', 'S', 205200, 122400, 226800, 136800, '大量击杀土元精 (可利用Fate “核心危机” x22,y22 不交任务道具不断击杀土元精)', '{}', 20),
- (45, 'Safat', '萨法特', 'S', 216000, 129600, 302400, 183600, '玩家处于频死状态触发 (可选择在高处跳下来触发)', '{}', 28),
- (46, 'Agrippa the Mighty', '阿格里帕', 'S', 216000, 129600, 302400, 183600, '开启G3,G4,G5,绿图,星光图的箱子触发', '{}', 29),
- (47, 'kaiser behemoth', '凯撒贝希摩斯', 'S', 298800, 183600, 482400, 288000, '在刷新点附近遛“皇家贝希摩斯宝宝” (兵团点换)。可骑坐骑飞行触发', '{}', 115),
- (48, 'Bird of Paradise', '极乐鸟', 'S', 298800, 183600, 482400, 288000, '让B怪“斯奎克”放出“唧唧咋咋” 的技能', '{}', 119),
- (49, 'Senmurv', '神穆尔鸟', 'S', 298800, 198000, 482400, 288000, '连续完成5次或以上 FATE——龙卵引起的战争(x19,y28)', '{}', 116),
- (50, 'Gandarewa', '刚德瑞瓦', 'S', 298800, 198000, 482400, 288000, '采集“皇金矿”;采集“星极花” (需要传承录——龙堡篇开启采集点),详细信息参考caiji.ffxiv.cn', '{}', 118),
- (51, 'the Pale Rider', '苍白骑士', 'S', 298800, 183600, 482400, 288000, '开启G7藏宝图的箱子', '{}', 117),
- (52, 'Leucrotta', '卢克洛塔', 'S', 298800, 198000, 482400, 288000, '累计击杀50只亚拉戈奇美拉,50只小海德拉,50只美拉西迪亚薇薇尔飞龙触发', '{}', 120),
- (53, 'Udumbara', '优昙婆罗花', 'S', 298800, 198000, 482400, 288000, '击杀植物系怪 (狄亚卡,莱西,寄生花) ', '{}', 190),
- (54, 'Bone Crawler', '爬骨怪龙', 'S', 298800, 198000, 482400, 288000, '陆行鸟运输服务,路径途中触发。', '{}', 195),
- (55, 'Salt and Light', '盐和光', 'S', 298800, 198000, 482400, 288000, '任意地点舍弃任意道具。', '{}', 196),
- (56, 'Okina', '巨大鳐', 'S', 298800, 198000, 482400, 288000, '起始触发时间为满月(ET12:00)时击杀无壳和有壳观梦螺触发,现实时间持续4小时12分钟(游戏时间:3天12小时)', '{}', 191),
- (57, 'Gamma', '伽马', 'S', 298800, 198000, 482400, 288000, '晚间时分 ET17:00-ET9:00 带着迷你亚历山大 宠物 溜达, 可骑坐骑飞行触发。 ', '{}', 192),
- (58, 'Orghana', '兀鲁忽乃朝鲁', 'S', 298800, 198000, 482400, 288000, '完成Fate石头人英雄:格尔该朝鲁,坐标 (X13.5,Y13.5) ,然后在刷新点附近溜达触发。', '{}', 197);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `ffxivbot_monster`
- --
- ALTER TABLE `ffxivbot_monster`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `name` (`name`),
- ADD KEY `ffxivbot_monster_territory_id_c2d61141_fk_ffxivbot_territory_id` (`territory_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `ffxivbot_monster`
- --
- ALTER TABLE `ffxivbot_monster`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=59;
- --
- -- 限制导出的表
- --
- --
- -- 限制表 `ffxivbot_monster`
- --
- ALTER TABLE `ffxivbot_monster`
- ADD CONSTRAINT `ffxivbot_monster_territory_id_c2d61141_fk_ffxivbot_territory_id` FOREIGN KEY (`territory_id`) REFERENCES `ffxivbot_territory` (`id`);
- DELIMITER $$
- --
- -- 事件
- --
- CREATE DEFINER=`FFXIV`@`localhost` EVENT `clear chatmessage` ON SCHEDULE EVERY 1 HOUR STARTS '2019-02-28 03:00:00' ENDS '2022-01-01 03:00:00' ON COMPLETION PRESERVE ENABLE DO TRUNCATE `ffxivbot_chatmessage`$$
- CREATE DEFINER=`FFXIV`@`localhost` EVENT `clear empty message` ON SCHEDULE EVERY 10 MINUTE STARTS '2019-05-01 00:00:00' ENDS '2023-05-01 00:00:00' ON COMPLETION PRESERVE ENABLE DO DELETE FROM `ffxivbot_chatmessage` WHERE `message` LIKE ""$$
- DELIMITER ;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement