View Single Post
  #3  
Old 07-04-2006, 03:57 AM
fathernitwit
Developer
 
Join Date: Jul 2004
Posts: 773
Default

i'll get these fixes in. The SQL statements need work though.

heres fixes (with PEQ IDs):

Code:
INSERT INTO npc_types (id,name,lastname,level,race,class,bodytype,hp,
gender,texture,helmtexture,size,
hp_regen_rate,mana_regen_rate,loottable_id,
merchant_id, 
npc_spells_id, npc_faction_id, 
mindmg, maxdmg,npcspecialattks,
aggroradius,face, luclin_hairstyle, luclin_haircolor, luclin_eyecolor,
luclin_eyecolor2, luclin_beardcolor, luclin_beard,d_meele_texture1,d_meele_texture2,
walkspeed,runspeed,MR,CR,DR,FR,PR,see_invis,see_invis_undead,
qglobal,AC,
npc_aggro,spawn_limit,attack_speed,findable,
STR,STA,DEX,AGI,_INT, WIS, CHA)
 VALUES (642,'blood_skeleton1','',67,367,1,63,4300,2,3,0,7,
120,60,0,
0,
226,0,
65,82,'DQE',
0,1,1,1,1,1,1,0,0,0,
6.66,1.25,0,0,0,0,0,0,0,
0,2666,
0,0,0,0,
414,414,414,414,60,414,414);

INSERT INTO npc_types (id,name,lastname,level,race,class,bodytype,hp,
gender,texture,helmtexture,size,hp_regen_rate,mana_regen_rate,loottable_id,
merchant_id, npc_spells_id, npc_faction_id, mindmg, maxdmg,npcspecialattks,
aggroradius,face, luclin_hairstyle, luclin_haircolor, luclin_eyecolor,
luclin_eyecolor2, luclin_beardcolor, luclin_beard, d_meele_texture1,
d_meele_texture2,walkspeed,runspeed,MR,CR,DR,FR,PR,see_invis,see_invis_undead,
qglobal,AC,npc_aggro,spawn_limit,attack_speed,findable,STR,STA,DEX,AGI,_INT,
WIS, CHA)
 VALUES (643,'blood_skeleton2','',67,367,1,63,4300,2,3,0,7,
120,60,0,
0,
225,0,
65,82,'DQE',
0,1,1,1,1,1,1,0,0,0,
6.66,1.25,0,0,0,0,0,0,0,
0,2666,
0,0,0,0,
414,414,414,414,60,414,414);


INSERT INTO npc_spells (id,name,parent_list,attack_proc,proc_chance)
 Values (225,'Necro Epic 2 Proc',0,6315,5);
INSERT INTO npc_spells (id,name,parent_list,attack_proc,proc_chance)
 Values (226,'Necro Epic 1.5 Proc',0,6303,5);

INSERT INTO aa_swarmpets (spell_id,count,npc_id,duration)
 Values (6274,1,643,30000);
INSERT INTO aa_swarmpets (spell_id,count,npc_id,duration)
 Values (6242,1,642,30000);
Reply With Quote