Skip to content

DB/Item: Big Love Rocket #31679

@anzz1

Description

@anzz1

Description

The Big Love Rocket (item id 50250, spell 71342) is a mount that changes depending on your location and Riding skill, same as Headless Horseman's Mount (item id 37012, spell id 48025) and others.

The required character level at 80, and the required Riding skill at 150 are incorrect, and should be 20 and 75 respectively.

Evidence

https://wowwiki-archive.fandom.com/wiki/Big_Love_Rocket
https://worldofwarcraft.fandom.com/et/wiki/Big_Love_Rocket
https://www.wowhead.com/wotlk/item=50250/x-45-heartbreaker (still the same item, just renamed in 2021)
https://wowpedia.fandom.com/wiki/X-45_Heartbreaker
https://youtu.be/x9pJTtzBl1c?t=6 (video from wotlk classic 2024, 0:06 shows the requirements)
https://youtu.be/_i4INQP54J8?t=19 (video from cata 2011, 0:20 also show 20 level requirement and apprentice riding (75). It was never changed to date in any patch).

Further research

  • The Flags, AllowableClass, AllowableRace, spellcooldown_2, spellcategorycooldown_2, Material, BagFamily fields also contain different values compared to the The Horseman's Reins (37012), check whether the fields have correct values in both that and Big Love Rocket (50250).

SQL fix

UPDATE `item_template` SET `ItemLevel` = 20, `RequiredLevel` = 20, `RequiredSkillRank` = 75 WHERE `item_template`.`entry` = 50250;

Branch

3.3.5

TC rev. hash/commit

TrinityCore rev. bf36a6f 2025-09-25 01:26:19 +0000 (master branch) (Linux, x86_64, Release, Static)
Using SSL version: OpenSSL 3.0.17 1 Jul 2025 (library: OpenSSL 3.0.18 30 Sep 2025)
Using Boost version: 1.74.0
Using MySQL version: 80406
Using CMake version: 3.25.1
Compiled on: Debian GNU/Linux 12; Linux 6.1.0-38-amd64
Automatic database updates are enabled for the following databases: Auth, Characters, World
Worldserver listening connections on port {}
Realmlist (Realm Id: 1) configured in port 8085
VMAPs status: Enabled. LineOfSight: 1, getHeight: 1, indoorCheck: 1
MMAPs status: Enabled
maps directory located in /home/trinity/trinitycore/data/maps. Total size: 291014951 bytes
vmaps directory located in /home/trinity/trinitycore/data/vmaps. Total size: 657797666 bytes
mmaps directory located in /home/trinity/trinitycore/data/mmaps. Total size: 1970895708 bytes
Using enUS DBC Locale as default. All available DBC locales: enUS
Using World DB: TDB 335.24111
LoginDatabase queue size: 0
CharacterDatabase queue size: 0
WorldDatabase queue size: 0

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions