· 8 years ago · Jun 18, 2018, 06:02 AM
1-- phpMyAdmin SQL Dump
2-- version 4.7.9
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Jun 18, 2018 at 05:58 AM
7-- Server version: 5.7.21
8-- PHP Version: 7.2.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `legacy_gamedata`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `raid_ai`
29--
30
31DROP TABLE IF EXISTS `raid_ai`;
32CREATE TABLE IF NOT EXISTS `raid_ai` (
33 `id` bigint(20) NOT NULL AUTO_INCREMENT,
34 `name` varchar(30) NOT NULL,
35 `image` varchar(100) NOT NULL,
36 `max_hp` int(11) NOT NULL DEFAULT '50',
37 `level` int(11) NOT NULL DEFAULT '10',
38 `boss` int(1) NOT NULL DEFAULT '0',
39 `armor` varchar(45) NOT NULL DEFAULT '',
40 `weapon1` varchar(45) NOT NULL DEFAULT '',
41 `weapon2` varchar(45) NOT NULL DEFAULT '',
42 `misc1` varchar(45) NOT NULL DEFAULT '',
43 `misc2` varchar(45) NOT NULL DEFAULT '',
44 PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
46
47--
48-- Dumping data for table `raid_ai`
49--
50
51INSERT INTO `raid_ai` (`id`, `name`, `image`, `max_hp`, `level`, `boss`, `armor`, `weapon1`, `weapon2`, `misc1`, `misc2`) VALUES
52(1, 'Natasha', 'groups/78.png', 500, 100, 1, '', '', '', '', ''),
53(2, 'Sully', 'groups/17.png', 300, 50, 0, '', '', '', '', ''),
54(3, '???', 'raids/npc/male_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', ''),
55(4, '???', 'raids/npc/female_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', ''),
56(5, 'Observer: Ventrix', 'hunting/i_observer.png', 500, 80, 1, '', '', '', '', '');
57
58-- --------------------------------------------------------
59
60--
61-- Table structure for table `raid_instances`
62--
63
64DROP TABLE IF EXISTS `raid_instances`;
65CREATE TABLE IF NOT EXISTS `raid_instances` (
66 `id` bigint(20) NOT NULL AUTO_INCREMENT,
67 `map_id` int(255) NOT NULL,
68 `leader` varchar(10) DEFAULT NULL,
69 `status` int(1) NOT NULL DEFAULT '0',
70 PRIMARY KEY (`id`),
71 UNIQUE KEY `UNIQUE` (`leader`),
72 UNIQUE KEY `map_id` (`map_id`,`leader`)
73) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `raid_instance_ai`
79--
80
81DROP TABLE IF EXISTS `raid_instance_ai`;
82CREATE TABLE IF NOT EXISTS `raid_instance_ai` (
83 `id` bigint(20) NOT NULL AUTO_INCREMENT,
84 `name` varchar(30) NOT NULL,
85 `raid_id` bigint(20) NOT NULL,
86 `ai_id` int(255) NOT NULL,
87 `hp` int(11) NOT NULL DEFAULT '50',
88 `max_hp` int(11) NOT NULL DEFAULT '50',
89 `level` int(11) NOT NULL DEFAULT '10',
90 `x` int(3) NOT NULL DEFAULT '0',
91 `y` int(3) NOT NULL DEFAULT '0',
92 `z` int(3) NOT NULL DEFAULT '0',
93 `hostile` int(1) NOT NULL DEFAULT '1',
94 `interact` varchar(40) NOT NULL DEFAULT '',
95 `on_interact` text NOT NULL,
96 PRIMARY KEY (`id`),
97 KEY `INDEX` (`raid_id`)
98) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=latin1;
99
100-- --------------------------------------------------------
101
102--
103-- Table structure for table `raid_instance_tiles`
104--
105
106DROP TABLE IF EXISTS `raid_instance_tiles`;
107CREATE TABLE IF NOT EXISTS `raid_instance_tiles` (
108 `raid_id` int(255) NOT NULL,
109 `x` int(4) NOT NULL,
110 `y` int(4) NOT NULL,
111 `z` int(4) NOT NULL,
112 `objective_id` int(255) NOT NULL DEFAULT '0',
113 `objective_hp` int(6) NOT NULL DEFAULT '0',
114 `objective_max_hp` int(6) NOT NULL DEFAULT '100',
115 `search_items` text NOT NULL,
116 `teleports` int(1) NOT NULL DEFAULT '0',
117 `teleport_x` int(4) NOT NULL,
118 `teleport_y` int(4) NOT NULL,
119 `teleport_z` int(4) NOT NULL,
120 `on_tile_enter` varchar(160) NOT NULL,
121 PRIMARY KEY (`raid_id`,`x`,`y`,`z`)
122) ENGINE=MyISAM DEFAULT CHARSET=latin1;
123
124-- --------------------------------------------------------
125
126--
127-- Table structure for table `raid_maps`
128--
129
130DROP TABLE IF EXISTS `raid_maps`;
131CREATE TABLE IF NOT EXISTS `raid_maps` (
132 `id` int(255) NOT NULL AUTO_INCREMENT,
133 `name` varchar(80) NOT NULL,
134 `description` text NOT NULL,
135 `public_instance` int(1) NOT NULL DEFAULT '0',
136 `map_image` varchar(200) NOT NULL,
137 `columns` int(4) NOT NULL DEFAULT '15',
138 `rows` int(4) NOT NULL DEFAULT '15',
139 `start_x` int(3) NOT NULL DEFAULT '0',
140 `start_y` int(3) NOT NULL DEFAULT '0',
141 `start_z` int(3) NOT NULL DEFAULT '0',
142 `static_walls` text NOT NULL,
143 `static_floors` text NOT NULL COMMENT 'use either this or walls',
144 `success_message` varchar(200) NOT NULL DEFAULT 'You have completed your journey.',
145 `on_raid_success` text NOT NULL,
146 `on_raid_success_quest` varchar(30) NOT NULL,
147 PRIMARY KEY (`id`),
148 UNIQUE KEY `name` (`name`)
149) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
150
151--
152-- Dumping data for table `raid_maps`
153--
154
155INSERT INTO `raid_maps` (`id`, `name`, `description`, `public_instance`, `map_image`, `columns`, `rows`, `start_x`, `start_y`, `start_z`, `static_walls`, `static_floors`, `success_message`, `on_raid_success`, `on_raid_success_quest`) VALUES
156(1, 'Unknown', 'You were pulled into the void and suddenly appeared in what seems like the wasteland. But something is different.. explore to find answers.', 1, 'map-alt.png', 15, 15, 0, 9, 0, '', '0,9#1,9#2,9#3,9#4,9#5,9#6,9#7,9#8,9#9,9#10,9#11,9#7,7#8,7#7,8#8,8#7,9#8,9#7,10#8,10#7,11#8,11#11,8#11,7#11,6#11,5#11,4#11,3#11,2#10,4#10,3#10,2#12,4#12,3#12,2', 'You have completed your journey.', 'addAchievement:observerVentrixShadow', 'ovs2');
157
158-- --------------------------------------------------------
159
160--
161-- Table structure for table `raid_maps_ai_data`
162--
163
164DROP TABLE IF EXISTS `raid_maps_ai_data`;
165CREATE TABLE IF NOT EXISTS `raid_maps_ai_data` (
166 `id` int(255) NOT NULL AUTO_INCREMENT,
167 `map_id` int(255) NOT NULL,
168 `x` int(3) NOT NULL,
169 `y` int(3) NOT NULL,
170 `z` int(3) NOT NULL,
171 `ai_id` int(255) NOT NULL,
172 `ai_count` int(3) NOT NULL DEFAULT '0',
173 `hostile` int(1) NOT NULL DEFAULT '1',
174 `interact` varchar(40) NOT NULL DEFAULT '',
175 `on_interact` text NOT NULL,
176 PRIMARY KEY (`id`),
177 KEY `map_id` (`map_id`),
178 KEY `y` (`y`,`z`,`x`),
179 KEY `map_id_2` (`map_id`)
180) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
181
182--
183-- Dumping data for table `raid_maps_ai_data`
184--
185
186INSERT INTO `raid_maps_ai_data` (`id`, `map_id`, `x`, `y`, `z`, `ai_id`, `ai_count`, `hostile`, `interact`, `on_interact`) VALUES
187(1, 1, 7, 7, 0, 3, 2, 1, '', ''),
188(2, 1, 8, 11, 0, 4, 2, 1, '', ''),
189(3, 1, 11, 3, 0, 5, 1, 0, 'Observe', 'endRaidSuccess');
190
191-- --------------------------------------------------------
192
193--
194-- Table structure for table `raid_maps_tiles_data`
195--
196
197DROP TABLE IF EXISTS `raid_maps_tiles_data`;
198CREATE TABLE IF NOT EXISTS `raid_maps_tiles_data` (
199 `map_id` int(255) NOT NULL,
200 `x` int(4) NOT NULL,
201 `y` int(4) NOT NULL,
202 `z` int(4) NOT NULL,
203 `objective_id` int(255) NOT NULL DEFAULT '0',
204 `objective_max_hp` int(6) NOT NULL DEFAULT '100',
205 `search_items` text NOT NULL,
206 `teleports` int(1) NOT NULL DEFAULT '0',
207 `teleport_x` int(4) NOT NULL,
208 `teleport_y` int(4) NOT NULL,
209 `teleport_z` int(4) NOT NULL,
210 `on_tile_enter` varchar(160) NOT NULL,
211 PRIMARY KEY (`map_id`,`x`,`y`,`z`)
212) ENGINE=MyISAM DEFAULT CHARSET=latin1;
213
214--
215-- Dumping data for table `raid_maps_tiles_data`
216--
217
218INSERT INTO `raid_maps_tiles_data` (`map_id`, `x`, `y`, `z`, `objective_id`, `objective_max_hp`, `search_items`, `teleports`, `teleport_x`, `teleport_y`, `teleport_z`, `on_tile_enter`) VALUES
219(1, 1, 9, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:This is your future.'),
220(1, 3, 9, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:This is also your past.'),
221(1, 7, 7, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:Those who are left alive.. will no longer be alive.'),
222(1, 8, 11, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:This is what you will become.\r\n'),
223(1, 11, 8, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:We do not interfere.'),
224(1, 11, 7, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:We only observe.'),
225(1, 11, 6, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:But now you have observed.'),
226(1, 11, 5, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:Will you interfere?'),
227(1, 11, 4, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:Tell me...'),
228(1, 11, 3, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:..<font class=itemPhantom><b>Observer</b></font>.');
229
230-- --------------------------------------------------------
231
232--
233-- Table structure for table `raid_objectives`
234--
235
236DROP TABLE IF EXISTS `raid_objectives`;
237CREATE TABLE IF NOT EXISTS `raid_objectives` (
238 `id` int(255) NOT NULL AUTO_INCREMENT,
239 `name` varchar(40) NOT NULL,
240 `image` varchar(200) NOT NULL,
241 PRIMARY KEY (`id`)
242) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
243
244--
245-- Dumping data for table `raid_objectives`
246--
247
248INSERT INTO `raid_objectives` (`id`, `name`, `image`) VALUES
249(1, 'Strange Hive', 'img-bin/warfare/strangehive.gif');
250
251-- --------------------------------------------------------
252
253--
254-- Table structure for table `raid_players`
255--
256
257DROP TABLE IF EXISTS `raid_players`;
258CREATE TABLE IF NOT EXISTS `raid_players` (
259 `id` bigint(20) NOT NULL AUTO_INCREMENT,
260 `account` varchar(10) DEFAULT NULL,
261 `raid_id` bigint(20) NOT NULL,
262 `team` int(4) NOT NULL DEFAULT '1',
263 `x` int(3) NOT NULL DEFAULT '0',
264 `y` int(3) NOT NULL DEFAULT '0',
265 `z` int(3) NOT NULL DEFAULT '0',
266 `last_active` datetime NOT NULL,
267 PRIMARY KEY (`id`),
268 UNIQUE KEY `UNIQUE` (`account`),
269 KEY `INDEX` (`raid_id`)
270) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
271COMMIT;
272
273/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
274/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
275/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
276
277INSERT INTO `achievements` (`id`, `ach_id`, `name`, `description`, `icon`, `icon_off`, `cat`, `levels`, `steps`, `value`, `secret`, `announce`, `banner`, `outfit`) VALUES (NULL, 'observerVentrixShadow', 'Observe The Observer', 'Travel through the void and observe the future.', 'observer_ventrix.png', 'secret.gif', 'Special', '1', '', '25', '1', '0', '0', 'l4torso314top|l4torso315top');
278ALTER TABLE `account_ach` ADD `109_progress` INT(11) NOT NULL DEFAULT '0' AFTER `108_progress`;
279INSERT INTO `variables` (`name`, `value`, `timestamp`) VALUES ('system_raids', '1', '2018-06-18 00:00:00');