Ir para conteúdo
  • Cadastre-se
  • 0

Poderia adaptar essa sql pra min da esse seguinte erro

GMTulikas

Perguntado por GMTulikas,

 Compartilhar

Pergunta

GMTulikas Novato

GMTulikas

Postado
Postado

Ola a todos da l2jbrasil nao consigo adaptar essa sql alguem poderia me ajudar da esse seguinte erro

 

36466265417007067988.jpg

 

DROP TABLE IF EXISTS `buffer_buff_list`;

DROP TABLE IF EXISTS `buffer_vip_list`;

DROP TABLE IF EXISTS `buffer_configuration`;

 

CREATE TABLE `buffer_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`)

);

 

 

CREATE TABLE `buffer_vip_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`playerId` varchar(40) DEFAULT NULL,

`playerName` varchar(20) DEFAULT NULL,

PRIMARY KEY (`id`)

);

 

 

CREATE TABLE `buffer_configuration` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`configDesc` varchar(30) DEFAULT NULL,

`configInfo` varchar(150) DEFAULT NULL,

`configName` varchar(30) DEFAULT NULL,

`configValue` varchar(30) DEFAULT NULL,

`usableValues` varchar(40) DEFAULT NULL,

`canEditOnline` tinyint(1) DEFAULT NULL,

PRIMARY KEY (`id`)

);

 

INSERT INTO `buffer_configuration` VALUES ('1', 'Window Title', 'Seperate new words with \',\' ! Example: My,buffer', 'title', 'test', 'string,3,36', '1');

INSERT INTO `buffer_configuration` VALUES ('2', 'Window Style', 'Select a value from box and hit update', 'style', 'Icons+Buttons', 'custom,0,0', '1');

INSERT INTO `buffer_configuration` VALUES ('3', 'Consumable ID', 'Enter a valid item ID', 'consumableId', '57', 'range,1,10000', '1');

INSERT INTO `buffer_configuration` VALUES ('4', 'Minimum level', 'Enter a value from 1 to 85', 'minLevel', '2', 'range,1,85', '1');

INSERT INTO `buffer_configuration` VALUES ('5', 'Buff player with karma', 'Select a value from box and hit update', 'buffWithKarma', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('6', 'Buffs for free', 'Select a value from box and hit update', 'freeBuffs', 'False', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('7', 'Enable healing option', 'Select a value from box and hit update', 'enableHeal', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('8', 'Healing price', 'Enter a value from 1 to 2000000000', 'healPrice', '1000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('9', 'Enable removing buffs option', 'Select a value from box and hit update', 'enableBuffRemove', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('10', 'Buff removing price', 'Enter a value from 1 to 2000000000', 'buffRemovePrice', '5000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('11', 'Enable Buffs', 'Select a value from box and hit update', 'enableBuffs', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('12', 'Enable Songs', 'Select a value from box and hit update', 'enableSongs', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('13', 'Enable Dances', 'Select a value from box and hit update', 'enableDances', 'False', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('14', 'Enable Chants', 'Select a value from box and hit update', 'enableChants', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('15', 'Enable Kamael buffs', 'Select a value from box and hit update', 'enableKamael', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('16', 'Enable Special buffs', 'Select a value from box and hit update', 'enableSpecial', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('17', 'Buff price', 'Enter a value from 1 to 2000000000', 'buffPrice', '2500', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('18', 'Song price', 'Enter a value from 1 to 2000000000', 'songPrice', '10000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('19', 'Dance price', 'Enter a value from 1 to 2000000000', 'dancePrice', '10000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('20', 'Chant price', 'Enter a value from 1 to 2000000000', 'chantPrice', '10000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('21', 'Kamael buff price', 'Enter a value from 1 to 2000000000', 'kamaelPrice', '10000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('22', 'Special buff price', 'Enter a value from 1 to 2000000000', 'specialPrice', '100000', 'range,1,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('23', 'Enable time out', 'Select a value from box and hit update', 'timeOut', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('24', 'Time out time', 'Enter a value from 1 to 10', 'timeOutTime', '2', 'range,1,10', '1');

INSERT INTO `buffer_configuration` VALUES ('25', 'GM minimum access level', 'Enter a value from 0 to 200', 'gmAccessLevel', '100', 'range,0,200', '1');

INSERT INTO `buffer_configuration` VALUES ('26', 'Enable online editing', 'Select a value from box and hit update', 'enableOnlineEditing', 'True', 'bool,True,False', '0');

INSERT INTO `buffer_configuration` VALUES ('27', 'Enable VIP players', 'Select a value from box and hit update', 'enableVipSystem', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('28', 'Vip Buff Price (SP)', 'Enter a value from 0 to 2000000000', 'vipBuffPrice', '1000000', 'range,0,2000000000', '1');

INSERT INTO `buffer_configuration` VALUES ('29', 'Sort Buffs', 'Select a value from box and hit update', 'sortBuffs', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('30', 'Enable Buff Set', 'Select a value from box and hit update', 'enableBuffSet', 'True', 'bool,True,False', '1');

INSERT INTO `buffer_configuration` VALUES ('31', 'Buff Set Price', 'Enter a value from 0 to 2000000000', 'buffSetPrice', '1000000', 'range,0,2000000000', '1');

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

INSERT INTO `buffer_buff_list` VALUES ('2', 'buff', '1304', '3', '3', '1');

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

INSERT INTO `buffer_buff_list` VALUES ('4', 'buff', '1354', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('5', 'buff', '1062', '2', '2', '1');

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

INSERT INTO `buffer_buff_list` VALUES ('7', 'buff', '1045', '6', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('8', 'buff', '1048', '6', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('9', 'buff', '1397', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('10', 'buff', '1078', '6', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('11', 'buff', '1242', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('12', 'buff', '1353', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('13', 'buff', '1352', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('14', 'buff', '1059', '3', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('15', 'buff', '1077', '3', '0', '1');

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

INSERT INTO `buffer_buff_list` VALUES ('17', 'buff', '1086', '2', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('18', 'buff', '1392', '3', '3', '1');

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

INSERT INTO `buffer_buff_list` VALUES ('20', 'buff', '1032', '3', '3', '0');

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

INSERT INTO `buffer_buff_list` VALUES ('22', 'buff', '1035', '4', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('23', 'buff', '1068', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('24', 'buff', '1044', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('27', 'buff', '1033', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('28', 'buff', '1259', '4', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('30', 'buff', '1040', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('31', 'buff', '1393', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('32', 'buff', '1268', '4', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('33', 'buff', '1303', '2', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('34', 'buff', '1204', '2', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('35', 'dance', '271', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('36', 'dance', '272', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('37', 'dance', '273', '1', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('38', 'dance', '274', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('39', 'dance', '275', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('40', 'dance', '276', '1', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('41', 'dance', '277', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('42', 'dance', '307', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('43', 'dance', '309', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('44', 'dance', '310', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('45', 'dance', '311', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('46', 'dance', '366', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('47', 'dance', '365', '1', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('48', 'song', '264', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('49', 'song', '265', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('50', 'song', '266', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('51', 'song', '267', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('52', 'song', '268', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('53', 'song', '269', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('54', 'song', '270', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('55', 'song', '304', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('56', 'song', '305', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('57', 'song', '306', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('58', 'song', '308', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('59', 'song', '363', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('60', 'song', '364', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('61', 'song', '349', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('62', 'chant', '1007', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('63', 'chant', '1009', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('64', 'chant', '1006', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('65', 'chant', '1002', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('66', 'chant', '1229', '18', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('67', 'chant', '1251', '2', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('68', 'chant', '1252', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('69', 'chant', '1253', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('70', 'chant', '1284', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('71', 'chant', '1310', '4', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('72', 'chant', '1309', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('73', 'chant', '1308', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('74', 'chant', '1362', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('77', 'special', '1413', '1', '1', '1');

INSERT INTO `buffer_buff_list` VALUES ('78', 'special', '1363', '1', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('81', 'special', '1388', '3', '0', '1');

INSERT INTO `buffer_buff_list` VALUES ('82', 'special', '1389', '3', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('83', 'special', '1356', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('84', 'special', '1355', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('94', 'special', '1357', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('99', 'song', '529', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('100', 'dance', '530', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('101', 'kamael', '1476', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('102', 'kamael', '1479', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('103', 'kamael', '1478', '2', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('104', 'kamael ', '1477', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('105', 'buff', '1311', '6', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('106', 'buff', '1307', '3', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('107', 'kamael', '499', '3', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('108', 'kamael', '1470', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('109', 'special', '1457', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('110', 'special', '341', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('111', 'chant', '1461', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('113', 'special', '1323', '1', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('123', 'vip', '76', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('124', 'vip', '83', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('125', 'vip', '109', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('126', 'vip', '282', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('127', 'vip', '292', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('128', 'vip', '298', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('129', 'vip', '425', '1', '3', '1');

 

REPLACE INTO npc VALUES

(555555, 18544, "Buffer", 1, "Rin4a's Custom", 1, "LineageNpcEV.trap_ironcastle", 8, 24, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 278, 0, 333, 0, 0, NULL, 60, 60, "0", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "true");

Link para o comentário
Compartilhar em outros sites

1 resposta a esta questão

Posts recomendados

HellPandora Aprendiz de Novato

HellPandora

Postado
Postado

Ola a todos da l2jbrasil nao consigo adaptar essa sql alguem poderia me ajudar da esse seguinte erro

 

36466265417007067988.jpg

 

o erro e simples: esta dizendo que o numero de colunas na tabela npc nao bate com o numero de colunas que tem esse codigo

confira na tabela npc e veja se esta correto ou e melhor vc add manualmente.

 

 

REPLACE INTO npc VALUES

(555555, 18544, "Buffer", 1, "Rin4a's Custom", 1, "LineageNpcEV.trap_ironcastle", 8, 24, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 278, 0, 333, 0, 0, NULL, 60, 60, "0", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "true");

Link para o comentário
Compartilhar em outros sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Processando...
×
 Compartilhar
Ir para lista de Perguntas





×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

  I accept