quest_data.sql.svn-base

ROSE的源代码。了解的自己研究,编译通过

-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
-- 
-- Serveur: localhost
-- Généré le : Sam 08 Septembre 2007 à 00:32
-- Version du serveur: 5.0.27
-- Version de PHP: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

-- 
-- Base de données: `roseon`
-- 

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

-- 
-- Structure de la table `quest_data`
-- 

CREATE TABLE `quest_data` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '0',
  `questid` decimal(20,0) NOT NULL default '0',
  `mobs` varchar(255) NOT NULL default '0',
  `items` varchar(255) NOT NULL default '0',
  `itemsreward` varchar(255) NOT NULL default '0',
  `exp` int(11) NOT NULL default '0',
  `zulie` int(11) NOT NULL default '0',
  `finalid` decimal(20,0) NOT NULL default '0',
  `numitems` varchar(255) NOT NULL default '0',
  `itemid` varchar(255) NOT NULL default '0',
  `citems` varchar(255) NOT NULL default '0|0|0|0|0',
  `nitems` varchar(255) NOT NULL default '0',
  `script` int(11) NOT NULL default '0',
  `value1` int(11) NOT NULL default '0',
  `value2` int(11) NOT NULL default '0',
  `value3` int(11) NOT NULL default '0',
  `startItems` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Contenu de la table `quest_data`
-- 

INSERT INTO `quest_data` (`id`, `name`, `questid`, `mobs`, `items`, `itemsreward`, `exp`, `zulie`, `finalid`, `numitems`, `itemid`, `citems`, `nitems`, `script`, `value1`, `value2`, `value3`, `startItems`) VALUES 
(1, 'Mini-Jelly Bean Hunt', '183840326', '1', '1', '10101', 20, 0, '501095038', '1', '0', '500|0|0|0|0', '5', 0, 0, 0, 0, '0'),
(2, 'Speak to Arua''s Fairy', '501095038', '0', '0', '10120', 30, 0, '2143067863', '1', '0', '0|0|0|0|0', '5', 0, 0, 0, 0, '0'),
(3, 'Speak to Ronway', '183602017', '0', '0', '10101', 200, 0, '2231520843', '1', '0', '0|0|0|0|0', '20', 0, 0, 0, 0, '0'),
(4, 'Hunt 10 Choropies', '184197047', '12', '12', '10120', 329, 0, '0', '10', '3968203447', '500|0|0|0|0', '15', 0, 0, 0, 104, '0'),
(5, 'Speak to Mairard', '183773526', '0', '0', '10101', 300, 0, '2011284176', '1', '0', '0|0|0|0|0', '20', 0, 0, 0, 0, '0'),
(6, 'Hunt 10 Flanae', '183608197', '41', '41', '10120', 600, 0, '0', '10', '236738605', '500|0|0|0|0', '20', 0, 0, 0, 104, '0'),
(7, 'Speak to Lena', '183606750', '0', '0', '10102', 600, 0, '2236530256', '1', '0', '0|0|0|0|0', '20', 0, 0, 0, 0, '0'),
(8, 'Hunt 10 Pumpkins', '183820992', '21', '21', '10121', 900, 0, '0', '10', '446470662', '500|0|0|0|0', '20', 0, 0, 0, 104, '0'),
(9, 'Selladin - Zant to Junon Polis', '363453474', '0', '0', '0', 0, 0, '363453474', '0', '0', '0|0|0|0|0', '0', 1, 2, 53395177, 0, '0'),
(10, 'Selladin - Zant to Elverloon Desert', '1383832132', '0', '0', '0', 0, 0, '1383832132', '0', '0', '0|0|0|0|0', '0', 1, 24, 55275377, 0, '0'),
(11, 'Idiosel - Junon Polis to Zant', '353125999', '0', '0', '0', 0, 0, '353125999', '0', '0', '0|0|0|0|0', '0', 1, 1, 52405192, 0, '0'),
(12, 'Idiosel - Junon Polis to Gorge of Silence', '1062678176', '0', '0', '0', 0, 0, '1062678176', '0', '0', '0|0|0|0|0', '0', 1, 28, 51944905, 0, '0'),
(13, 'Itz - Junon Polis to Adventurer''s plains', '1062559359', '0', '0', '0', 0, 0, '1062559359', '0', '0', '0|0|0|0|0', '0', 1, 22, 58355386, 1500, '0'),
(14, 'Itz - Junon Polis to Kenji Beach', '1062359486', '0', '0', '0', 0, 0, '1062359486', '0', '0', '0|0|0|0|0', '0', 1, 27, 52425022, 1500, '0'),
(15, 'Gawain - Junon Polis to Training Ground', '1444485948', '0', '0', '0', 0, 0, '1444485948', '0', '0', '0|0|0|0|0', '0', 1, 6, 52005222, 0, '0'),
(16, 'Gamp - Training Ground to Junon Polis', '1085042078', '0', '0', '0', 0, 0, '1085042078', '0', '0', '0|0|0|0|0', '0', 1, 2, 55155252, 0, '0'),
(17, 'Illiya - Eucar to Junon', '2502245228', '0', '0', '0', 0, 0, '2502245228', '0', '0', '0|0|0|0|0', '0', 1, 2, 54944989, 5000, '0'),
(18, 'Illiya - Eucar to Eldeon', '2749095305', '0', '0', '0', 0, 0, '2749095305', '0', '0', '0|0|0|0|0', '0', 1, 61, 52324437, 13000, '0'),
(19, 'Chacha - Eldeon to Junon', '3608236904', '0', '0', '0', 0, 0, '3608236904', '0', '0', '0|0|0|0|0', '0', 1, 2, 54944989, 20000, '0'),
(20, 'Chacha - Eldeon to Luna', '2476727908', '0', '0', '0', 0, 0, '2476727908', '0', '0', '0|0|0|0|0', '0', 1, 51, 51145006, 13000, '0'),
(21, 'Luna to Mana Snowfields', '3092192196', '0', '0', '0', 0, 0, '3092192196', '0', '0', '0|0|0|0|0', '0', 1, 52, 51405102, 0, '0'),
(22, 'Luna to Arumic Valley', '3091927897', '0', '0', '0', 0, 0, '3091927897', '0', '0', '0|0|0|0|0', '0', 1, 53, 57364811, 0, '0'),
(23, 'Luna to Crystal Snowfields', '3092969956', '0', '0', '0', 0, 0, '3092969956', '0', '0', '0|0|0|0|0', '0', 1, 54, 50994247, 0, '0'),
(24, 'Luna to Freezing Plateau', '3092054103', '0', '0', '0', 0, 0, '3092054103', '0', '0', '0|0|0|0|0', '0', 1, 55, 56744696, 0, '0'),
(25, 'Robin - Kenji Beach to Adventurer''s plains', '496620116', '0', '0', '0', 0, 0, '496620116', '0', '0', '0|0|0|0|0', '0', 1, 22, 58355386, 1500, '0'),
(26, 'Robin - Kenji Beach To Dolphin Island', '1083892156', '0', '0', '0', 0, 0, '1083892156', '0', '0', '0|0|0|0|0', '0', 1, 3, 51015026, 1500, '0'),
(27, 'Robin - Kenji Beach To Junon Polis', '1084094658', '0', '0', '0', 0, 0, '1084094658', '0', '0', '0|0|0|0|0', '0', 1, 2, 55965034, 1500, '0'),
(28, 'Peron - Adventurer''s Plains to Junon Polis', '1078781184', '0', '0', '0', 0, 0, '1078781184', '0', '0', '0|0|0|0|0', '0', 1, 2, 55965034, 1500, '0'),
(29, 'Peron - Adventurer''s plains to Dolphin Island', '1078721662', '0', '0', '0', 0, 0, '1078721662', '0', '0', '0|0|0|0|0', '0', 1, 3, 51015026, 1500, '0'),
(30, 'Peron - Adventurer''s plains to Kenji Beach', '294037426', '0', '0', '0', 0, 0, '294037426', '0', '0', '0|0|0|0|0', '0', 1, 27, 52425022, 1500, '0'),
(31, 'Rooen - Dolphin Island to Adventurer''s Plains', '1617594371', '0', '0', '0', 0, 0, '1617594371', '0', '0', '0|0|0|0|0', '0', 1, 22, 58355386, 1500, '0'),
(32, 'Rooen - Dolphin Island to Kenji Beach', '1617790914', '0', '0', '0', 0, 0, '1617790914', '0', '0', '0|0|0|0|0', '0', 1, 27, 52425022, 1500, '0'),
(33, 'Alphonso - Junon to Luna', '3634502607', '0', '0', '0', 0, 0, '3634502607', '0', '0', '0|0|0|0|0', '0', 1, 51, 51145006, 5000, '0'),
(34, 'Loelsch - Santa''s Planetoid to zant', '3791938747', '0', '0', '0', 0, 0, '3791938747', '0', '0', '0|0|0|0|0', '0', 1, 1, 52405192, 0, '0'),
(35, 'Ruven - Junon Polis to eucar', '3632758604', '0', '0', '0', 0, 0, '3632758604', '0', '0', '0|0|0|0|0', '0', 1, 51, 51145006, 500000, '0'),
(36, 'Ruven - Junon Polis to eucar', '3001200960', '0', '0', '0', 0, 0, '3001200960', '0', '0', '0|0|0|0|0', '0', 1, 51, 51145006, 5000, '0'),
(37, 'Burtland - Northwest CF 50-69', '1351665710', '0', '0', '0', 0, 0, '1351665710', '0', '0', '0|0|0|0|0', '0', 1, 12, 49855460, 0, '0'),
(38, 'Burtland - Northeast CF 50-69', '1352628703', '0', '0', '0', 0, 0, '1352628703', '0', '0', '0|0|0|0|0', '0', 1, 12, 54505460, 0, '0'),
(39, 'Burtland - Southwest CF 50-69', '1352391928', '0', '0', '0', 0, 0, '1352391928', '0', '0', '0|0|0|0|0', '0', 1, 12, 49714990, 0, '0'),
(40, 'Burtland - Southeast CF 50-69', '1352451462', '0', '0', '0', 0, 0, '1352451462', '0', '0', '0|0|0|0|0', '0', 1, 12, 55145005, 0, '0'),
(41, 'Burtland - Northwest CF 30-49 ', '3065839905', '0', '0', '0', 0, 0, '3065839905', '0', '0', '0|0|0|0|0', '0', 1, 11, 49855460, 0, '0'),
(42, 'Burtland - Northeast CF 30-49', '3065163984', '0', '0', '0', 0, 0, '3065163984', '0', '0', '0|0|0|0|0', '0', 1, 11, 54505460, 0, '0'),
(43, 'Burtland - Southwest CF 30-49', '3065386487', '0', '0', '0', 0, 0, '3065386487', '0', '0', '0|0|0|0|0', '0', 1, 11, 49714990, 0, '0'),
(44, 'Burtland - Southeast CF 30-49', '3065056393', '0', '0', '0', 0, 0, '3065056393', '0', '0', '0|0|0|0|0', '0', 1, 11, 55145005, 0, '0'),
(45, 'Burtland - Northwest CF 70-89', '968125048', '0', '0', '0', 0, 0, '968125048', '0', '0', '0|0|0|0|0', '0', 1, 13, 49855460, 0, '0'),
(46, 'Burtland - Northeast CF 70-89', '968612745', '0', '0', '0', 0, 0, '968612745', '0', '0', '0|0|0|0|0', '0', 1, 13, 54505460, 0, '0'),
(47, 'Burtland - Southwest CF 70-89', '968851118', '0', '0', '0', 0, 0, '968851118', '0', '0', '0|0|0|0|0', '0', 1, 13, 49714990, 0, '0'),
(48, 'Burtland - Southeast CF 70-89', '968386512', '0', '0', '0', 0, 0, '968386512', '0', '0', '0|0|0|0|0', '0', 1, 13, 55145005, 0, '0'),
(50, 'Fairy - Sit', '3619053029', '0', '0', '0', 31, 0, '3619053029', '1', '0', '0|0|0|0|0', '0', 0, 0, 0, 0, '0'),
(51, 'Fairy - Trade', '3618839712', '0', '0', '0', 31, 0, '3618839712', '1', '0', '0|0|0|0|0', '0', 0, 0, 0, 0, '0'),
(52, 'Fairy - Equip/Unequip', '3619189408', '0', '0', '0', 31, 0, '3619189408', '1', '0', '0|0|0|0|0', '0', 0, 0, 0, 0, '0'),
(53, 'Fairy - Inventory', '3618837695', '0', '0', '0', 31, 0, '3618837695', '1', '0', '0|0|0|0|0', '0', 0, 0, 0, 0, '0'),
(54, 'Fairy - revive', '3619464526', '0', '0', '0', 31, 0, '3619464526', '1', '0', '0|0|0|0|0', '0', 0, 0, 0, 0, '0'),
(55, 'Fairy Quest', '3619133820', '0', '0', '0', 31, 0, '3619133820', '1', '0', '0|0|0|0|0', '0', 0, 0, 0, 0, '0'),
(56, 'Fairy - Pick Up', '3619054526', '0', '0', '10101', 0, 0, '3619054526', '1', '0', '0|0|0|0|0', '10', 0, 0, 0, 0, '0'),