-- phpMyAdmin SQL Dump
-- version 4.7.9
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jun 18, 2018 at 05:58 AM
-- Server version: 5.7.21
-- PHP Version: 7.2.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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: `legacy_gamedata`
--

-- --------------------------------------------------------

--
-- Table structure for table `raid_ai`
--

DROP TABLE IF EXISTS `raid_ai`;
CREATE TABLE IF NOT EXISTS `raid_ai` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `image` varchar(100) NOT NULL,
  `max_hp` int(11) NOT NULL DEFAULT '50',
  `level` int(11) NOT NULL DEFAULT '10',
  `boss` int(1) NOT NULL DEFAULT '0',
  `armor` varchar(45) NOT NULL DEFAULT '',
  `weapon1` varchar(45) NOT NULL DEFAULT '',
  `weapon2` varchar(45) NOT NULL DEFAULT '',
  `misc1` varchar(45) NOT NULL DEFAULT '',
  `misc2` varchar(45) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raid_ai`
--

INSERT INTO `raid_ai` (`id`, `name`, `image`, `max_hp`, `level`, `boss`, `armor`, `weapon1`, `weapon2`, `misc1`, `misc2`) VALUES
(1, 'Natasha', 'groups/78.png', 500, 100, 1, '', '', '', '', ''),
(2, 'Sully', 'groups/17.png', 300, 50, 0, '', '', '', '', ''),
(3, '???', 'raids/npc/male_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', ''),
(4, '???', 'raids/npc/female_husk.png', 10, 1, 0, 'Coat', 'Broken Bottle', 'Broken Bottle', '', ''),
(5, 'Observer: Ventrix', 'hunting/i_observer.png', 500, 80, 1, '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `raid_instances`
--

DROP TABLE IF EXISTS `raid_instances`;
CREATE TABLE IF NOT EXISTS `raid_instances` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `map_id` int(255) NOT NULL,
  `leader` varchar(10) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE` (`leader`),
  UNIQUE KEY `map_id` (`map_id`,`leader`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `raid_instance_ai`
--

DROP TABLE IF EXISTS `raid_instance_ai`;
CREATE TABLE IF NOT EXISTS `raid_instance_ai` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `raid_id` bigint(20) NOT NULL,
  `ai_id` int(255) NOT NULL,
  `hp` int(11) NOT NULL DEFAULT '50',
  `max_hp` int(11) NOT NULL DEFAULT '50',
  `level` int(11) NOT NULL DEFAULT '10',
  `x` int(3) NOT NULL DEFAULT '0',
  `y` int(3) NOT NULL DEFAULT '0',
  `z` int(3) NOT NULL DEFAULT '0',
  `hostile` int(1) NOT NULL DEFAULT '1',
  `interact` varchar(40) NOT NULL DEFAULT '',
  `on_interact` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `INDEX` (`raid_id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `raid_instance_tiles`
--

DROP TABLE IF EXISTS `raid_instance_tiles`;
CREATE TABLE IF NOT EXISTS `raid_instance_tiles` (
  `raid_id` int(255) NOT NULL,
  `x` int(4) NOT NULL,
  `y` int(4) NOT NULL,
  `z` int(4) NOT NULL,
  `objective_id` int(255) NOT NULL DEFAULT '0',
  `objective_hp` int(6) NOT NULL DEFAULT '0',
  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
  `search_items` text NOT NULL,
  `teleports` int(1) NOT NULL DEFAULT '0',
  `teleport_x` int(4) NOT NULL,
  `teleport_y` int(4) NOT NULL,
  `teleport_z` int(4) NOT NULL,
  `on_tile_enter` varchar(160) NOT NULL,
  PRIMARY KEY (`raid_id`,`x`,`y`,`z`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `raid_maps`
--

DROP TABLE IF EXISTS `raid_maps`;
CREATE TABLE IF NOT EXISTS `raid_maps` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  `description` text NOT NULL,
  `public_instance` int(1) NOT NULL DEFAULT '0',
  `map_image` varchar(200) NOT NULL,
  `columns` int(4) NOT NULL DEFAULT '15',
  `rows` int(4) NOT NULL DEFAULT '15',
  `start_x` int(3) NOT NULL DEFAULT '0',
  `start_y` int(3) NOT NULL DEFAULT '0',
  `start_z` int(3) NOT NULL DEFAULT '0',
  `static_walls` text NOT NULL,
  `static_floors` text NOT NULL COMMENT 'use either this or walls',
  `success_message` varchar(200) NOT NULL DEFAULT 'You have completed your journey.',
  `on_raid_success` text NOT NULL,
  `on_raid_success_quest` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raid_maps`
--

INSERT 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
(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');

-- --------------------------------------------------------

--
-- Table structure for table `raid_maps_ai_data`
--

DROP TABLE IF EXISTS `raid_maps_ai_data`;
CREATE TABLE IF NOT EXISTS `raid_maps_ai_data` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `map_id` int(255) NOT NULL,
  `x` int(3) NOT NULL,
  `y` int(3) NOT NULL,
  `z` int(3) NOT NULL,
  `ai_id` int(255) NOT NULL,
  `ai_count` int(3) NOT NULL DEFAULT '0',
  `hostile` int(1) NOT NULL DEFAULT '1',
  `interact` varchar(40) NOT NULL DEFAULT '',
  `on_interact` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `map_id` (`map_id`),
  KEY `y` (`y`,`z`,`x`),
  KEY `map_id_2` (`map_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raid_maps_ai_data`
--

INSERT INTO `raid_maps_ai_data` (`id`, `map_id`, `x`, `y`, `z`, `ai_id`, `ai_count`, `hostile`, `interact`, `on_interact`) VALUES
(1, 1, 7, 7, 0, 3, 2, 1, '', ''),
(2, 1, 8, 11, 0, 4, 2, 1, '', ''),
(3, 1, 11, 3, 0, 5, 1, 0, 'Observe', 'endRaidSuccess');

-- --------------------------------------------------------

--
-- Table structure for table `raid_maps_tiles_data`
--

DROP TABLE IF EXISTS `raid_maps_tiles_data`;
CREATE TABLE IF NOT EXISTS `raid_maps_tiles_data` (
  `map_id` int(255) NOT NULL,
  `x` int(4) NOT NULL,
  `y` int(4) NOT NULL,
  `z` int(4) NOT NULL,
  `objective_id` int(255) NOT NULL DEFAULT '0',
  `objective_max_hp` int(6) NOT NULL DEFAULT '100',
  `search_items` text NOT NULL,
  `teleports` int(1) NOT NULL DEFAULT '0',
  `teleport_x` int(4) NOT NULL,
  `teleport_y` int(4) NOT NULL,
  `teleport_z` int(4) NOT NULL,
  `on_tile_enter` varchar(160) NOT NULL,
  PRIMARY KEY (`map_id`,`x`,`y`,`z`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raid_maps_tiles_data`
--

INSERT 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
(1, 1, 9, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:This is your future.'),
(1, 3, 9, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:This is also your past.'),
(1, 7, 7, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:Those who are left alive.. will no longer be alive.'),
(1, 8, 11, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:This is what you will become.\r\n'),
(1, 11, 8, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:We do not interfere.'),
(1, 11, 7, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:We only observe.'),
(1, 11, 6, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:But now you have observed.'),
(1, 11, 5, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:Will you interfere?'),
(1, 11, 4, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:Tell me...'),
(1, 11, 3, 0, 0, 100, '', 0, 0, 0, 0, 'sendClientMsg:..<font class=itemPhantom><b>Observer</b></font>.');

-- --------------------------------------------------------

--
-- Table structure for table `raid_objectives`
--

DROP TABLE IF EXISTS `raid_objectives`;
CREATE TABLE IF NOT EXISTS `raid_objectives` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `image` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `raid_objectives`
--

INSERT INTO `raid_objectives` (`id`, `name`, `image`) VALUES
(1, 'Strange Hive', 'img-bin/warfare/strangehive.gif');

-- --------------------------------------------------------

--
-- Table structure for table `raid_players`
--

DROP TABLE IF EXISTS `raid_players`;
CREATE TABLE IF NOT EXISTS `raid_players` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account` varchar(10) DEFAULT NULL,
  `raid_id` bigint(20) NOT NULL,
  `team` int(4) NOT NULL DEFAULT '1',
  `x` int(3) NOT NULL DEFAULT '0',
  `y` int(3) NOT NULL DEFAULT '0',
  `z` int(3) NOT NULL DEFAULT '0',
  `last_active` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE` (`account`),
  KEY `INDEX` (`raid_id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=latin1;
COMMIT;

/*!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 */;

INSERT 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');
ALTER TABLE `account_ach` ADD `109_progress` INT(11) NOT NULL DEFAULT '0' AFTER `108_progress`;
INSERT INTO `variables` (`name`, `value`, `timestamp`) VALUES ('system_raids', '1', '2018-06-18 00:00:00');