Page 1 of 1

sql help

Posted: Thu Feb 13, 2014 5:21 pm
by 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??

Re: sql help

Posted: Thu Feb 13, 2014 5:31 pm
by St3eT

Re: sql help

Posted: Thu Feb 13, 2014 5:39 pm
by loss25
how should help this post for me?.....

Re: sql help

Posted: Thu Feb 13, 2014 5:52 pm
by Cresceus
loss25 wrote: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.

Re: sql help

Posted: Thu Feb 13, 2014 7:30 pm
by 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....

Re: sql help

Posted: Thu Feb 13, 2014 7:41 pm
by UnAfraid
Here u have perfect example of how to transfer your custom npcs:
http://trac.l2jdp.com/browser/branches/ ... ?rev=10172

Re: sql help

Posted: Thu Feb 13, 2014 8:35 pm
by jurchiks
Why is it necessary to copy collision stats?

Re: sql help

Posted: Thu Feb 13, 2014 10:50 pm
by NosBit
jurchiks wrote:Why is it necessary to copy collision stats?
Because displayId npc may not have been loaded yet or may not exist :P

Re: sql help

Posted: Thu Feb 13, 2014 11:03 pm
by jurchiks
What do you mean - may not have been loaded yet? Customs load after vanilla.

Re: sql help

Posted: Thu Feb 13, 2014 11:07 pm
by 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.

Re: sql help

Posted: Thu Feb 13, 2014 11:13 pm
by jurchiks
But that's not related to required collision stat copy for custom NPCs.

Re: sql help

Posted: Sat Feb 15, 2014 4:46 pm
by 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>