SQL

[geney]

OLA GALERA ! to com um pequeno brema nessa sql,ela nao aparece no diretorio pra extrair pro bando de dados

 

 

alguem ai com + conhecimento poderia resolver ou postar ai como q resolve isso

usei notepadc++ pra tentar resolver o ocorrido + msmo assim nao funciono!=/

REPLACE INTO `npc` VALUES ('955', '18544', 'Molder', '1', 'Services Manager', '1', 'LineageNpcEV.trap_ironcastle', '8.00', '24.00', '85', 'etc', 'L2Npc', '40', '20000', '164', '1.15', '1.21', '40', '1', '30', '21', '20', '25', '0', '0', '40000', '50000', '50000', '50000', '999', '0', '333', '0', '0', '0', '0', '60', '125', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');

 

DROP TABLE IF EXISTS `aionpc_buff_list`;

DROP TABLE IF EXISTS `aionpc_scheme_contents`;

DROP TABLE IF EXISTS `aionpc_scheme_list`;

DROP TABLE IF EXISTS `aionpc_pet_list`;

 

CREATE TABLE `aionpc_buff_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`buffType` varchar(10) DEFAULT NULL,

`buffId` int(5) DEFAULT '0',

`buffLevel` int(5) DEFAULT NULL,

`forClass` tinyint(1) DEFAULT NULL,

`canUse` tinyint(1) DEFAULT NULL,

PRIMARY KEY (`id`)

) AUTO_INCREMENT=136;

CREATE TABLE `aionpc_scheme_contents` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`scheme_id` int(11) DEFAULT NULL,

`skill_id` int(8) DEFAULT NULL,

`skill_level` int(4) DEFAULT NULL,

`buff_class` int(2) DEFAULT NULL,

PRIMARY KEY (`id`)

) AUTO_INCREMENT=30;

CREATE TABLE `aionpc_scheme_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`player_id` varchar(40) DEFAULT NULL,

`scheme_name` varchar(36) DEFAULT NULL,

`mod_accepted` tinyint(1) DEFAULT NULL,

PRIMARY KEY (`id`)

) AUTO_INCREMENT=7;

CREATE TABLE `aionpc_pet_list` (

`player_id` varchar(40) NOT NULL DEFAULT '',

`scheme_name` varchar(36) DEFAULT NULL,

PRIMARY KEY (`player_id`)

) AUTO_INCREMENT=7;

 

INSERT INTO `aionpc_buff_list` VALUES ('1', 'buff', '1036', '2', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('2', 'buff', '1040', '3', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('3', 'buff', '1043', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('4', 'buff', '1044', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('5', 'buff', '1045', '6', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('6', 'buff', '1047', '4', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('7', 'buff', '1048', '6', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('8', 'buff', '1059', '3', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('9', 'buff', '1062', '2', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('10', 'buff', '1068', '3', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('11', 'buff', '1077', '3', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('12', 'buff', '1085', '3', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('13', 'buff', '1086', '2', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('14', 'buff', '1087', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('15', 'buff', '1204', '2', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('16', 'buff', '1240', '3', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('17', 'buff', '1242', '3', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('18', 'buff', '1243', '6', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('19', 'buff', '1257', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('20', 'buff', '1268', '4', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('21', 'buff', '1303', '2', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('22', 'buff', '1304', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('23', 'buff', '1307', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('24', 'buff', '1311', '6', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('25', 'buff', '1397', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('26', 'buff', '1460', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('27', 'buff', '1232', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('28', 'buff', '1238', '3', '3', '0');

 

INSERT INTO `aionpc_buff_list` VALUES ('29', 'resist', '1032', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('30', 'resist', '1033', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('31', 'resist', '1035', '4', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('32', 'resist', '1078', '6', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('33', 'resist', '1182', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('34', 'resist', '1189', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('35', 'resist', '1191', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('36', 'resist', '1259', '4', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('37', 'resist', '1352', '1', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('38', 'resist', '1353', '1', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('39', 'resist', '1354', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('40', 'resist', '1392', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('41', 'resist', '1393', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('42', 'resist', '1461', '1', '3', '1');

 

INSERT INTO `aionpc_buff_list` VALUES ('43', 'dance', '271', '1', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('44', 'dance', '272', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('45', 'dance', '273', '1', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('46', 'dance', '274', '1', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('47', 'dance', '275', '1', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('48', 'dance', '276', '1', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('49', 'dance', '277', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('50', 'dance', '307', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('51', 'dance', '309', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('52', 'dance', '310', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('53', 'dance', '311', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('54', 'dance', '365', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('55', 'dance', '366', '1', '3', '0');

INSERT INTO `aionpc_buff_list` VALUES ('56', 'dance', '530', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('57', 'dance', '765', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('58', 'dance', '915', '1', '3', '1');

 

INSERT INTO `aionpc_buff_list` VALUES ('59', 'song', '264', '1', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('60', 'song', '265', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('61', 'song', '266', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('62', 'song', '267', '1', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('63', 'song', '268', '1', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('64', 'song', '269', '1', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('65', 'song', '270', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('66', 'song', '304', '1', '2', '1');

INSERT INTO `aionpc_buff_list` VALUES ('67', 'song', '305', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('68', 'song', '306', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('69', 'song', '308', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('70', 'song', '349', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('71', 'song', '363', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('72', 'song', '364', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('73', 'song', '529', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('74', 'song', '764', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('75', 'song', '914', '1', '3', '1');

 

INSERT INTO `aionpc_buff_list` VALUES ('76', 'chant', '1002', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('77', 'chant', '1006', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('78', 'chant', '1007', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('79', 'chant', '1009', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('80', 'chant', '1251', '2', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('81', 'chant', '1252', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('82', 'chant', '1253', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('83', 'chant', '1284', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('84', 'chant', '1308', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('85', 'chant', '1309', '3', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('86', 'chant', '1310', '4', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('87', 'chant', '1362', '1', '3', '1');

 

INSERT INTO `aionpc_buff_list` VALUES ('88', 'others', '834', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('89', 'others', '1442', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('90', 'others', '1443', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('91', 'others', '1444', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('92', 'others', '825', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('93', 'others', '826', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('94', 'others', '827', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('95', 'others', '828', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('96', 'others', '829', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('97', 'others', '830', '1', '3', '1');

 

INSERT INTO `aionpc_buff_list` VALUES ('98', 'cubic', '67', '7', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('99', 'cubic', '10', '8', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('100', 'cubic', '22', '7', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('101', 'cubic', '33', '8', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('102', 'cubic', '278', '6', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('103', 'cubic', '449', '4', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('104', 'cubic', '1279', '9', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('105', 'cubic', '1280', '9', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('106', 'cubic', '1281', '9', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('107', 'cubic', '1328', '8', '3', '0');

INSERT INTO `aionpc_buff_list` VALUES ('108', 'cubic', '1329', '9', '3', '0');

INSERT INTO `aionpc_buff_list` VALUES ('109', 'cubic', '1330', '8', '3', '0');

INSERT INTO `aionpc_buff_list` VALUES ('110', 'cubic', '779', '1', '3', '1');

 

INSERT INTO `aionpc_buff_list` VALUES ('111', 'special', '1323', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('112', 'special', '1355', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('113', 'special', '1356', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('114', 'special', '1357', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('115', 'special', '1363', '1', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('116', 'special', '1388', '3', '0', '1');

INSERT INTO `aionpc_buff_list` VALUES ('117', 'special', '1389', '3', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('118', 'special', '1413', '1', '1', '1');

INSERT INTO `aionpc_buff_list` VALUES ('119', 'special', '1416', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('120', 'special', '1457', '1', '3', '0');

INSERT INTO `aionpc_buff_list` VALUES ('121', 'special', '4699', '13', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('122', 'special', '4700', '13', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('123', 'special', '4702', '13', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('124', 'special', '4703', '13', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('125', 'special', '1499', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('126', 'special', '1500', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('127', 'special', '1501', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('128', 'special', '1502', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('129', 'special', '1503', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('130', 'special', '1504', '1', '3', '1');

INSERT INTO `aionpc_buff_list` VALUES ('131', 'special', '1519', '1', '3', '1');

 

REPLACE INTO `skill_learn` (`npc_id`, `class_id`) VALUES

(955, 0),

(955, 1),

(955, 2),

(955, 3),

(955, 4),

(955, 5),

(955, 6),

(955, 7),

(955, 8),

(955, 9),

(955, 10),

(955, 11),

(955, 12),

(955, 13),

(955, 14),

(955, 15),

(955, 16),

(955, 17),

(955, 18),

(955, 19),

(955, 20),

(955, 21),

(955, 22),

(955, 23),

(955, 24),

(955, 25),

(955, 26),

(955, 27),

(955, 28),

(955, 29),

(955, 30),

(955, 31),

(955, 32),

(955, 33),

(955, 34),

(955, 35),

(955, 36),

(955, 37),

(955, 38),

(955, 39),

(955, 40),

(955, 41),

(955, 42),

(955, 43),

(955, 44),

(955, 45),

(955, 46),

(955, 47),

(955, 48),

(955, 49),

(955, 50),

(955, 51),

(955, 52),

(955, 53),

(955, 54),

(955, 55),

(955, 56),

(955, 57),

(955, 58),

(955, 59),

(955, 60),

(955, 61),

(955, 62),

(955, 63),

(955, 64),

(955, 65),

(955, 66),

(955, 67),

(955, 68),

(955, 69),

(955, 70),

(955, 71),

(955, 72),

(955, 73),

(955, 74),

(955, 75),

(955, 76),

(955, 77),

(955, 78),

(955, 79),

(955, 80),

(955, 81),

(955, 82),

(955, 83),

(955, 84),

(955, 85),

(955, 86),

(955, 87),

(955, 88),

(955, 89),

(955, 90),

(955, 91),

(955, 92),

(955, 93),

(955, 94),

(955, 95),

(955, 96),

(955, 97),

(955, 98),

(955, 99),

(955, 100),

(955, 101),

(955, 102),

(955, 103),

(955, 104),

(955, 105),

(955, 106),

(955, 107),

(955, 108),

(955, 109),

(955, 110),

(955, 111),

(955, 112),

(955, 113),

(955, 114),

(955, 115),

(955, 116),

(955, 117),

(955, 118),

(955, 119),

(955, 120),

(955, 121),

(955, 122),

(955, 123),

(955, 124),

(955, 125),

(955, 126),

(955, 127),

(955, 128),

(955, 129),

(955, 130),

(955, 131),

(955, 132),

(955, 133),

(955, 134),

(955, 135),

(955, 136);