sql help

[loss25]

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');

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');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
that`s wrong who can say??

[St3eT]

We moved NPCs to XML: http://svn.l2jdp.com/branches/unstable/ ... tats/npcs/

[loss25]

how should help this post for me?.....

[Cresceus]

how should help this post for me?.....

Depending on what revision you're using there is no npc table in DB anymore.

So what is the revision number of yours.

[loss25]

36600 Augument Manager
36601 PvP-Pk Manager
36602 Pk Protector
36603 Gm Shop
36604 Gatekeeper
36605 WareHouse Manager
36606 Npc Server Informer
here my npc id, who can explain that i should to do?i am beginner on l2j server....

[UnAfraid]

Here u have perfect example of how to transfer your custom npcs:
http://trac.l2jdp.com/browser/branches/ ... ?rev=10172

[jurchiks]

Why is it necessary to copy collision stats?

[NosBit]

Why is it necessary to copy collision stats?

Because displayId npc may not have been loaded yet or may not exist

[jurchiks]

What do you mean - may not have been loaded yet? Customs load after vanilla.

[NosBit]

people are not forced to use custom directory i may want to change display of npc with id 1 to 500 and 500 may not be loaded yet.

[jurchiks]

But that's not related to required collision stat copy for custom NPCs.

[loss25]

so i should add in my npc html like these line? my npc id is 36603
<npc id="36603" displayId="13014" level="80" name="Gm Shop" type="L2npc">
<stats str="40" int="21" dex="30" wit="20" con="43" men="20">
<vitals hp="40" hpRegen="1000" mp="1000" mpRegen="100" />
<attack physical="8" magical="7" />
<defence physical="25" magical="40" />
</stats>
<status undying="false" canBeSown="true" />
<collision>
<radius normal="5" />
<height normal="4.5" />
</collision>