Vehicles that are not working

Nay · March 1, 2011, 8:46pm

Please, post here the entries of vehicles that are not working (when you click on them nothing happens):

Follow this format: “ - vehicle name - area or zone name”

Example:

34775 - Demolisher - Isle of Conquest

Thank you.

MrQuickFX · March 1, 2011, 8:53pm

27692 - Emerald Drake - Oculus

27756 - Ruby Drake - Oculus

27755 - Amber Drake - Oculus

Edit by Nay:

-- Spellclick DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (27692,27756,27755); INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES (27692,49427,0,0,0,2,0,0,0), -- Emerald Drake (27756,49463,0,0,0,2,0,0,0), -- Ruby Drake (27755,49459,0,0,0,2,0,0,0); -- Amber Drake -- Addon data for vehicles DELETE FROM `creature_template_addon` WHERE `entry` IN (27692,27756,27755); INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (27692,0,50331648,257,0, NULL), -- Emerald Drake (27756,0,50331648,257,0, NULL), -- Ruby Drake (27755,0,50331648,257,0, NULL); -- Amber Drake -- Conditions for spell_aura_control_vehicle DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (49346,49464,49460); INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`Comment`) VALUES (13,0,49346,0,18,1,27692,0, 'Emeral Drake'), (13,0,49464,0,18,1,27756,0, 'Ruby Drake'), (13,0,49460,0,18,1,27755,0, 'Amber Drake');[/sql]

Kaelima · March 1, 2011, 9:14pm

Fixing IoC

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (35273,34775,34935);
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES
(35273,68503,0,0,0,2,0,0,0), -- Glaive Thrower - Isle of Conquest
(34775,66245,0,0,0,2,0,0,0), -- Demolisher - Isle of Conquest
(34935,43671,0,0,0,2,0,0,0); -- Horde Gunship Cannon - Isle of Conquest
[/SQL]
(Not done)

iperpido · March 2, 2011, 12:49am

29563 - Injured Icemaw Matriarch - Storm Peaks, next to Brunnhildar village.

This vehicle is needed for the quest “The Last of Her Kind” (http://www.wowhead.com/quest=12983), and works more or less like Icefang (http://www.trinitycore.org/f/index.php?/topic/1374-questgoing-bearback/page__p__8562__fromsearch__1#entry8562) and Captive Proto Drake (http://www.trinitycore.org/f/index.php?/topic/1396-questcold-hearted/page__p__8655__fromsearch__1#entry8655)

The TRUE vehicle is Harnessed Icemaw Matriarch (http://www.wowhead.com/npc=30468)

I have made some queryes…

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=29563; INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES (29563,56795,12983,1,12983,1,0,0,0); -- Summon Harnessed Icemaw Matriarch [/sql]
UPDATE creature_template SET IconName= ‘vehichleCursor’ WHERE entry =29563;

[b]

I’VE NOT TESTED THE CODE YET[/b], because i don’t know what is the right vehicleid and the right id for the bear spell.

[color=“#FF0000”]Edit by Nay: change IconName is hacky (wdb field)

Gildor · March 2, 2011, 5:29pm

35644 - Argent Warhorse

36558 - Argent Battleworg

Kaelima · March 2, 2011, 7:56pm

2011-03-01 00:05:25 Missing npc_spellclick_spells data for creature 23693
2011-03-04 14:49:30 Missing npc_spellclick_spells data for creature 25596
2011-03-04 05:55:46 Missing npc_spellclick_spells data for creature 26191
2011-03-04 06:07:35 Missing npc_spellclick_spells data for creature 26525
2011-03-03 03:08:58 Missing npc_spellclick_spells data for creature 26585
2011-03-02 18:14:05 Missing npc_spellclick_spells data for creature 26590
2011-03-06 01:49:08 Missing npc_spellclick_spells data for creature 27354
2011-03-03 19:33:56 Missing npc_spellclick_spells data for creature 27516
2011-03-04 20:01:34 Missing npc_spellclick_spells data for creature 27671
2011-03-05 13:55:02 Missing npc_spellclick_spells data for creature 29144
2011-03-05 00:57:06 Missing npc_spellclick_spells data for creature 29691
2011-03-05 10:33:22 Missing npc_spellclick_spells data for creature 29857
2011-03-03 00:46:50 Missing npc_spellclick_spells data for creature 31881
2011-03-03 19:50:56 Missing npc_spellclick_spells data for creature 31895
2011-03-06 00:19:00 Missing npc_spellclick_spells data for creature 33794
2011-03-04 04:45:19 Missing npc_spellclick_spells data for creature 33843
2011-03-02 18:44:57 Missing npc_spellclick_spells data for creature 35069

2011-03-05 06:25:32 Vehicle entry 28054 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

[/CODE]

ZxBiohazardZx · March 3, 2011, 9:12am

from tracker: http://www.trinitycore.org/t/trinitycore/ticket/840

NPCs:

http://www.wowhead.com/npc=36477

http://www.wowhead.com/npc=36476

Vehicle entry 36476 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Edit by Kaelima:

DELETE FROM npc_spellclick_spells WHERE npc_entry=36477;

INSERT INTO npc_spellclick_spells (npc_entry,spell_id,quest_start,quest_start_active,quest_end,cast_flags,aura_required,aura_forbidden,user_type) VALUES

(36477,46598,0,0,0,0,0,0,0); – Krick - Pit of Saron

Sarjuuk · March 3, 2011, 3:39pm

28222 - The Etymidian - The Avalanche (Sholazar)

/e:

vehicle is probably 111

spells (in this order): 50978, 50980, 50985, 50983, 54166

Gildor · March 3, 2011, 6:30pm

[CODE]Vehicle entry 36476 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Vehicle entry 30204 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Vehicle entry 38500 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Vehicle entry 36896 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Vehicle entry 36891 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Vehicle entry 36794 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Vehicle entry 28018 in vehicle_accessory does not have a valid record in npc_spellclick_spells! Calling default EnterVehicle()

Missing npc_spellclick_spells data for creature 35644

Missing npc_spellclick_spells data for creature 36558

[/CODE]

Nay · March 5, 2011, 6:56pm

https://github.com/TrinityCore/TrinityCore/commit/bf12aa416224ed7cde8d3a0dc094feebce5af47c

All the above vehicles have been checked; I couldn’t find spells for this vehicles:

[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
35644 – Argent Warhorse
36558 – Argent Battleworg
26590 – Ravenous Worg – might be 46631 Ride Worg
28614
29433
29555
29625
30330
32189
33687
33778
*/
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
UPDATE creature_template SET faction_A=14,faction_H=14,baseattacktime=2000,npcflag=npcflag|16777216,unit_flags=unit_flags|256,speed_run=1.57143 WHERE entry=35644; – Argent Warhorse
UPDATE creature_template SET baseattacktime=2000,npcflag=npcflag|16777216,speed_run=1.57143 WHERE entry=36558; – Argent Battleworg

DELETE FROM creature_template_addon WHERE entry IN (23693,26191,26525,26585,27354,27516,27671,29691,29857,35644,36558);
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
(35644,0,0,1,0, ‘67870 0’), – Argent Warhorse
(36558,0,0,257,0, ‘67865 0’); – Argent Battleworg

UPDATE creature_model_info SET bounding_radius=0.455,combat_reach=1.95,gender=1 WHERE modelid=9954; – Frostbite
[/sql]
[/CODE]

SignFinder · March 5, 2011, 8:59pm

Not work boss vehicles in Trial Of The Champion-mounts not have riders

35635 - Eressea Dawnsinger’s Mount - Trial of the Champion (rider http://www.wowhead.com/npc=35569)

35634 - Deathstalker Visceri’s Mount - Trial of the Champion (rider http://www.wowhead.com/npc=35617)

35638 - Mokra the Skullcrusher’s Mount - Trial of the Champion (rider http://www.wowhead.com/npc=35572)

Gildor · March 5, 2011, 9:36pm

36476 Still bug, now not show Krick

Nay · March 5, 2011, 9:47pm

Good question but that is what happens on retail.

I will correct Krick later.

maxdestroyer · March 6, 2011, 10:04am

Fix for Ick - INSERT INTO npc_spellclick_spells (npc_entry,spell_id,quest_start,quest_start_active,quest_end,cast_flags,aura_required,aura_forbidden,user_type) VALUES

(36476,46598,0,0,0,0,0,0,0);

Entry for 36477 seems wrong, but i am not checked without it.

Also for Tyrannus

INSERT INTO npc_spellclick_spells (npc_entry,spell_id,quest_start,quest_start_active,quest_end,cast_flags,aura_required,aura_forbidden,user_type) VALUES

(36661,46598,0,0,0,0,0,0,0); – Rimefang

Malcrom · March 6, 2011, 12:36pm

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (36476,36661);
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES
(36476,46598,0,0,0,0,0,0,0), -- Ick
(36661,46598,0,0,0,0,0,0,0); -- Rimefang[/sql]

Gildor · March 6, 2011, 5:44pm

[CODE] npc_spellclick_spells: Creature template 30021 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 30234 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 31748 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 32795 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 32796 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33217 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33316 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33317 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33318 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33319 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33320 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33321 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33322 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33323 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33324 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33782 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33844 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 33845 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

npc_spellclick_spells: Creature template 34045 has UNIT_NPC_FLAG_SPELLCLICK but no data in spellclick table! Removing flag

Table vehicle_accessory: creature template entry 32930 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33113 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33214 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35637 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35633 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35768 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 34658 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35636 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35638 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35635 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35640 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35641 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35634 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 27661 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 35491 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33323 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 27626 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 28518 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 28009 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 28451 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 29460 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 25968 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 36678 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 38431 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 38585 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 38586 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 36678 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 38431 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 38585 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 38586 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 28669 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33669 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 39860 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33321 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33299 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33418 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33409 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33300 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33408 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33301 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33414 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33297 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33416 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33298 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33320 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33322 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33316 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33317 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33324 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33217 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33318 has no data in npc_spellclick_spells

Table vehicle_accessory: creature template entry 33319 has no data in npc_spellclick_spells[/CODE]

Nay · March 6, 2011, 5:59pm

I have access to the full list now.

Closing topic; it will be re-opened when we got no more console errors and only vehicle errors (in-game).