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
need help whit this npc.sql
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- Zoey76
- L2j Inner Circle
- Posts: 7008
- Joined: Tue Aug 11, 2009 3:36 am
Re: need help whit this npc.sql
In latest beta npc table doesn't exist.
Powered by Eclipse 4.34
| Eclipse Temurin 21
| MariaDB 11.3.2
| L2J Server 2.6.3.0 - High Five 
Join our Discord! 

- jurchiks
- Posts: 6769
- Joined: Sat Sep 19, 2009 4:16 pm
- Location: Eastern Europe
Re: need help whit this npc.sql
...L2J Revision Number:6445
L2JDP Revision Number:9641
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
- Zoey76
- L2j Inner Circle
- Posts: 7008
- Joined: Tue Aug 11, 2009 3:36 am
Re: need help whit this npc.sql
Do you even think before posting or do you like to look like a troll? Changeset 6386jurchiks wrote:...L2J Revision Number:6445
L2JDP Revision Number:9641

Powered by Eclipse 4.34
| Eclipse Temurin 21
| MariaDB 11.3.2
| L2J Server 2.6.3.0 - High Five 
Join our Discord! 

- jurchiks
- Posts: 6769
- Joined: Sat Sep 19, 2009 4:16 pm
- Location: Eastern Europe
Re: need help whit this npc.sql
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.
@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.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
-
- Posts: 441
- Joined: Mon May 05, 2014 10:15 am
Re: need help whit this npc.sql
i try it the all day to fine out how to fix it but still don't now what i must dojurchiks wrote:...L2J Revision Number:6445
L2JDP Revision Number:9641
help me to fix it please

- St3eT
- Posts: 961
- Joined: Sun Mar 07, 2010 6:50 pm
Re: need help whit this npc.sql
He just need reply in every topic.Zoey76 wrote: Do you even think before posting or do you like to look like a troll? Changeset 6386

- jurchiks
- Posts: 6769
- Joined: Sat Sep 19, 2009 4:16 pm
- Location: Eastern Europe
Re: need help whit this npc.sql
No, I just point out obvious mistakes which would not have happened if somebody had reading comprehension and common sense.
@Attila -
@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.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
-
- Posts: 441
- Joined: Mon May 05, 2014 10:15 am
Re: need help whit this npc.sql
thanks i got it work nowjurchiks 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.