Console DB errors have been killed.
Opening a new topic to report non-working vehicles (i.e nothing happens when you click them; they do not “mount” their npc accessories"
Left-overs from last topic:
[CODE]/* Vehicles not found:
23693 – Duskwing Eagle
26191 – Dusk
26525 – Cockroach
26585 – Bloodmist
27354 – Broken-down Shredder – might be 48533 Ride Shredder
27516 – Fordragon Stallion
27671 – Fordragon Armored Gryphon
29691 – Reed’s Steam Tank
29857 – Frostbite
*/
UPDATE creature_template SET speed_run=1.38571 WHERE entry=26191; – Dusk
UPDATE creature_template SET speed_run=1.28968 WHERE entry=26585; – Bloodmist
UPDATE creature_template SET speed_run=1.38571 WHERE entry=27516; – Fordragon Stallion
UPDATE creature_template SET speed_walk=1.6,speed_run=0.57143 WHERE entry=27354; – Broken-down Shredder
UPDATE creature_template SET speed_run=2 WHERE entry=29144; – Refurbished Steam Tank
UPDATE creature_template SET speed_run=1 WHERE entry=29691; – Reed’s Steam Tank
UPDATE creature_template SET speed_run=1.28571 WHERE entry=29857; – Frostbite
DELETE FROM creature_template_addon WHERE entry IN (23693,26191,26525,26585,27354,27516,27671,29691,29857);
INSERT INTO creature_template_addon (entry,mount,bytes1,bytes2,emote,auras) VALUES
(23693,0,0,1,0, NULL), – Duskwing Eagle
(26191,0,0,1,0, NULL), – Dusk
(26525,0,0,1,0, NULL), – Cockroach
(26585,0,0,257,0, NULL), – Bloodmist
(27354,0,0,1,0, ‘48456 0 48458 0’), – Broken-down Shredder, Auras: Shredder Smoke and Shredder Sparks Periodic – might be 48533 Ride Shredder
(27516,0,65536,257,0, NULL), – Fordragon Stallion
(27671,0,65536,257,0, NULL), – Fordragon Armored Gryphon
(29691,0,7,1,0, NULL), – Reed’s Steam Tank
(29857,0,0,2,0, NULL); – Frostbite
DELETE FROM npc_spellclick_spells WHERE npc_entry=36477; – Krick (typo)
UPDATE creature_model_info SET bounding_radius=0.455,combat_reach=1.95,gender=1 WHERE modelid=9954; – Frostbite[/sql]
[sql]-- Handy query:
SELECTId,EffectBasePoints1,EffectBasePoints2,EffectBasePoints3,SpellName,Description,ToolTip,EffectTriggerSpell1,EffectTriggerSpell2,EffectTriggerSpell3 FROM 335dbc_spell
WHERE ((EffectTriggerSpell1 IN (SELECT id FROM335dbc_spell WHERE (EffectApplyAuraName1=236 OREffectApplyAuraName2=236 OREffectApplyAuraName3=236 ))
OREffectTriggerSpell2 IN (SELECT id FROM335dbc_spell WHERE (EffectApplyAuraName1=236 OREffectApplyAuraName2=236 OREffectApplyAuraName3=236))
OREffectTriggerSpell3 IN (SELECT id FROM335dbc_spell WHERE (EffectApplyAuraName1=236 OREffectApplyAuraName2=236 OREffectApplyAuraName3=236)))
OR EffectApplyAuraName1=236 OREffectApplyAuraName2=236 OREffectApplyAuraName3=236)
AND Id NOT IN (SELECT spell_id FROM world.npc_spellclick_spells) AND
(EffectTriggerSpell1 NOT IN (SELECT spell_id FROM world.npc_spellclick_spells)
OR EffectTriggerSpell2 NOT IN (SELECT spell_id FROM world.npc_spellclick_spells)
OR EffectTriggerSpell3 NOT IN (SELECT spell_id FROM world.npc_spellclick_spells))
ORDER BYId ASC LIMIT 0,200;
[/CODE]