Spawntable
7 ответов68 просмотровСейчас просматривают: 1
· 26.12.2009, 16:09
Сборка: L2Jenova 442,Interlude
Краткое изложение СУТИ проблемы: не получается залить в базу npc.sql.
Navicat пишеть:
Раскрывающийся текст
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `npc` SET `type` = 'L2NpcWalker' WHERE `id` IN (31358,31359,31360,31361,3' at line 682
[Err] INSERT INTO `npc` (`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`) VALUES
(35010,35010,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',40,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,683,287,546,233,416,0,333,128
,628,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35011,35011,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',80,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,798,287,546,233,357,0,333,93,
0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35012,35012,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',1100,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,889,244,546,233,322,0,333,2
80,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35013,35013,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_FHuman',8.00,23.50,50,'female','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,31
6,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35014,35014,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_MHuman',8.00,23.00,50,'male','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,17
9,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35015,35015,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',40,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,683,287,546,233,416,0,333,128
,628,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35016,35016,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',80,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,798,287,546,233,357,0,333,93,
0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35017,35017,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',1100,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,889,244,546,233,322,0,333,2
80,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35018,35018,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_FHuman',8.00,23.50,50,'female','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,31
6,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35019,35019,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_MHuman',8.00,23.00,50,'male','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,17
9,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35020,35020,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',40,3986,1493,4.27,2.78,40,43,30,21,20,10,490,1,1763,485,1610,394,416,0,333,
150,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35021,35021,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',80,3986,1493,4.27,2.78,40,43,30,21,20,10,490,1,2058,485,1610,394,357,0,333,
97,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35022,35022,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',1100,3986,1493,4.27,2.78,40,43,30,21,20,10,490,1,2292,412,1610,394,322,0,33
3,288,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35023,35023,'Mercenary of Dawn',0,'',0,'NPC.a_mageguild_master_FHuman',8.00,23.00,70,'female','L2SiegeGuard',40,3986,2240,4.27,4.26,40,43,30,21,20,10,490,1,1763,536,1610,394,416,0,333,
325,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35024,35024,'Mercenary of Dawn',0,'',0,'NPC.a_mageguild_master_MHuman',8.00,24.00,70,'male','L2SiegeGuard',40,3986,2240,4.27,4.26,40,43,30,21,20,10,490,1,1763,536,1610,394,416,0,333,
196,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35025,35025,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',40,3986,1493,4.27,2.78,40,43,30,
[Msg] Finished - Unsuccessfully
[Err] INSERT INTO `npc` (`id`,`idTemplate`,`name`,`serverSideName`,`title`,`serverSideTitle`,`class`,`collision_radius`,`collision_height`,`level`,`sex`,`type`,`attackrange`,`hp`,`mp`,`hpreg`,`mpreg`,`str`,`con`,`dex`,`int`,`wit`,`men`,`exp`,`sp`,`patk`,`pdef`,`matk`,`mdef`,`atkspd`,`aggro`,`matkspd`,`rhand`,`lhand`,`armor`,`walkspd`,`runspd`,`faction_id`,`faction_range`,`isUndead`,`absorb_level`,`absorb_type`) VALUES
(35010,35010,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',40,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,683,287,546,233,416,0,333,128
,628,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35011,35011,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',80,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,798,287,546,233,357,0,333,93,
0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35012,35012,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',1100,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,889,244,546,233,322,0,333,2
80,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35013,35013,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_FHuman',8.00,23.50,50,'female','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,31
6,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35014,35014,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_MHuman',8.00,23.00,50,'male','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,17
9,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35015,35015,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',40,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,683,287,546,233,416,0,333,128
,628,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35016,35016,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',80,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,798,287,546,233,357,0,333,93,
0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35017,35017,'Mercenary',0,'',0,'NPC.a_guard_MHuman',8.00,24.00,50,'male','L2SiegeGuard',1100,2317,830,3.32,2.14,40,43,30,21,20,10,250,1,889,244,546,233,322,0,333,2
80,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35018,35018,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_FHuman',8.00,23.50,50,'female','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,31
6,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35019,35019,'Mercenary',0,'',0,'NPC.a_mageguild_teacher_MHuman',8.00,23.00,50,'male','L2SiegeGuard',40,2317,1245,3.32,3.30,40,43,30,21,20,10,250,1,683,317,546,233,416,0,333,17
9,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35020,35020,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',40,3986,1493,4.27,2.78,40,43,30,21,20,10,490,1,1763,485,1610,394,416,0,333,
150,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35021,35021,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',80,3986,1493,4.27,2.78,40,43,30,21,20,10,490,1,2058,485,1610,394,357,0,333,
97,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35022,35022,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',1100,3986,1493,4.27,2.78,40,43,30,21,20,10,490,1,2292,412,1610,394,322,0,33
3,288,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35023,35023,'Mercenary of Dawn',0,'',0,'NPC.a_mageguild_master_FHuman',8.00,23.00,70,'female','L2SiegeGuard',40,3986,2240,4.27,4.26,40,43,30,21,20,10,490,1,1763,536,1610,394,416,0,333,
325,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35024,35024,'Mercenary of Dawn',0,'',0,'NPC.a_mageguild_master_MHuman',8.00,24.00,70,'male','L2SiegeGuard',40,3986,2240,4.27,4.26,40,43,30,21,20,10,490,1,1763,536,1610,394,416,0,333,
196,0,0,55,214,'mercenary_siege_clan',1200,1,0,'LAST_HIT'),
(35025,35025,'Mercenary of Dawn',0,'',0,'NPC.a_fighterguild_master_Mhuman',8.00,23.50,70,'male','L2SiegeGuard',40,3986,1493,4.27,2.78,40,43,30,
[Msg] Finished - Unsuccessfully
Вопрос: в чем причина и как исправить?
0
· 26.12.2009, 19:21
Раскрывающийся текст
(14590,14590,'Soulless',0,'',0,'Monster.shadeless',7.00,28.00,78,'male','L2Pet',40,5314,2057,13.43,3.09,40,43,30,21,20,25,0,0,1895,555,1081,520,278,0,333,0
,0,0,52,209,NULL,0,0,0,'LAST_HIT'),
,0,0,52,209,NULL,0,0,0,'LAST_HIT'),
0
· 26.12.2009, 20:59
up
0
· 26.12.2009, 21:03
не ту написал строчку, в той строчке должно быть "L2NpcWalker" а не "L2Pet"
0
· 26.12.2009, 22:03
всё сделал скачал новую ревизию....
не буду открывать новую тему
как сделал чтобы еслы убивалы в Primival Isle телепортивало не в Dark Elven Village а в Giran Castle Town?
0
· 27.12.2009, 07:40
up
0
Тема закрыта для ответов

