need help whit this npc.sql

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Attila
Posts: 441
Joined: Mon May 05, 2014 10:15 am

need help whit this npc.sql

Post by Attila »

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
User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7008
Joined: Tue Aug 11, 2009 3:36 am

Re: need help whit this npc.sql

Post by Zoey76 »

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! ๐ŸŽฎ๐Ÿ’ฌ
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: need help whit this npc.sql

Post by jurchiks »

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.
User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7008
Joined: Tue Aug 11, 2009 3:36 am

Re: need help whit this npc.sql

Post by Zoey76 »

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 :roll:
Powered by Eclipse 4.34 ๐ŸŒŒ | Eclipse Temurin 21 โ˜• | MariaDB 11.3.2 ๐Ÿ—ƒ๏ธ | L2J Server 2.6.3.0 - High Five ๐Ÿš€

๐Ÿ”— Join our Discord! ๐ŸŽฎ๐Ÿ’ฌ
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: need help whit this npc.sql

Post by jurchiks »

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.
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.
Attila
Posts: 441
Joined: Mon May 05, 2014 10:15 am

Re: need help whit this npc.sql

Post by Attila »

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 :(
User avatar
St3eT
Posts: 961
Joined: Sun Mar 07, 2010 6:50 pm

Re: need help whit this npc.sql

Post by St3eT »

Zoey76 wrote: Do you even think before posting or do you like to look like a troll? Changeset 6386 :roll:
He just need reply in every topic. :)
If i should be black sheep for sure no as punishment
Image
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: need help whit this npc.sql

Post by jurchiks »

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.
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.
Attila
Posts: 441
Joined: Mon May 05, 2014 10:15 am

Re: need help whit this npc.sql

Post by Attila »

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
Post Reply