L2J Server

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:6445
L2JDP Revision Number:9641

hi

need help whit this npc.sql

DELETE FROM `npc` WHERE `id` >= '36600' AND `id` <= '36606';

INSERT INTO `npc` VALUES ('36600', '36397', 'Augument Manager', '1', '[Server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
INSERT INTO `npc` VALUES ('36601', '21175', 'PvP-Pk Manager', '1', '[Server Name]', '1', 'LineageMonster4.Divine_Rogue', '8.00', '30.00', '80', 'male', 'L2Npc', '40', '523.000000000000000', '87238.000000000000000', '378378.000000000000000', '378.000000000000000', '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
INSERT INTO `npc` VALUES ('36603', '13014', 'Gm Shop', '1', '[Server Name]', '1', 'LineageMonster4.Divine_Rogue', '8.00', '23.00', '80', 'male', 'L2Merchant', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
INSERT INTO `npc` VALUES ('36604', '32575', 'Gatekeeper', '1', '[Server Name]', '1', 'LineageNpc2.br_aga_ball_kick', '8.00', '26.00', '80', 'male', 'L2Teleporter', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
INSERT INTO `npc` VALUES ('36605', '13079', 'WareHouse Manager', '1', '[Server Name]', '1', 'LineageNPC.a_warehouse_keeper_MDwarf', '20.00', '25.00', '80', 'male', 'L2Warehouse', '40', null, null, null, null, '40', '43', '30', '21', '20', '20', '0', '0', null, null, null, null, '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');

if itry to install it i got this error:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `npc` VALUES ('36600', '36397', 'Augument Manager', '1', '[Server Name]', '1', 'Npc.a_smith_MDwarf', '22.00', '26.00', '80', 'male', 'L2Trainer', '40', '540452.000000000000000', '5243.000000000000000', null, null, '40', '43', '30', '21', '20', '20', '0', '0', '453.00000', '638.00000', '838.00000', '8383.00000', '230', '1', '0', '333', '0', '0', '0', '60.00000', '120.00000', '1', '1', '0', '0');
[Msg] Finished - Unsuccessfully

can some won help me to fix this please t

tanks

In latest beta npc table doesn't exist.

L2J Revision Number:6445
L2JDP Revision Number:9641

...

jurchiks wrote:

L2J Revision Number:6445
L2JDP Revision Number:9641

...

Do you even think before posting or do you like to look like a troll? Changeset 6386

Yeah, did you not notice that trunk also has revision 6445? Seriously...

@Attila - what you need to do is copy the lines of the ORIGINAL NPCs (for 36600 it's 36397), and change only the things that differ, in this case, name and title, serverSideName=1, serverSideTitle=1.

jurchiks wrote:

L2J Revision Number:6445
L2JDP Revision Number:9641

...

i try it the all day to fine out how to fix it but still don't now what i must do
help me to fix it please

Zoey76 wrote: Do you even think before posting or do you like to look like a troll? Changeset 6386

He just need reply in every topic.

No, I just point out obvious mistakes which would not have happened if somebody had reading comprehension and common sense.

@Attila -

jurchiks wrote:what you need to do is copy the lines of the ORIGINAL NPCs (for 36600 it's 36397), and change only the things that differ, in this case, name and title, serverSideName=1, serverSideTitle=1.

jurchiks wrote:No, I just point out obvious mistakes which would not have happened if somebody had reading comprehension and common sense.

@Attila -

jurchiks wrote:what you need to do is copy the lines of the ORIGINAL NPCs (for 36600 it's 36397), and change only the things that differ, in this case, name and title, serverSideName=1, serverSideTitle=1.

thanks i got it work now