How do I patch my Spells.dbc? Adding Custom Mount

[therogues]

TrinityCore 3.3.5

I've been trying to complete my first task to get into the whole development aspect of private servers and I wanted to create a custom mount on my localserver and I can't quite seem to get it.
This is what I did

I duplicated Swift Spectral Tiger in the actual file

Spells.dbc

and changed the ID to

80.000

, everything else is the same name etc, it's all untouched.
Then I went into my SQL DB and headed into

Item_Template

and duplicated the Swift Spectral Tiger there, but here I didn't change the

Spellid_1

which was set to

55884

because that's equivalent to the

Learning

spell, and then I changed Spellid_2 to

80.000

which if you remember was the ID of the custom spell I created in the

Spells.dbc file

.

At this point everything should be hooked up afaik.
And now I need to patch the Spells.dbc file.

I opened MPQ Editor & clicked

New MPQ

and clicked browse and navigated to my World of Warcraft 3.3.5 game folder, and headed into the Data folder because that's where I wanted to store the patch,
Clicked next and selected Create an empty MPQ archive with the game compatibility of WOTLK
https://i.imgur.com/nYzG9jF.png
clicked next and set the max number to 4000and then finished.
Then I created a new folder called

DBFilesClient

and added the modified Spell.dbc file in there
NOTE: I know it says MOQ but it does the same thing if it says MPQ
https://i.imgur.com/g3xz9DV.png
closed it and the patch is now in my Data folder in my game folder.

However when I do this in game

.lo spell Swift Spectral Tiger

it only shows 42777 which is the first version when it should show both 42777 and 80000 in the chat.
I don't think I patched it correctly.

This is what my game folder looks like if it matters.
https://i.imgur.com/UrKigsr.png

[stoneharry]

See here: GitHub - stoneharry/Spell-Editor-GUI-V2: A Spell Editor for WoW version 3.3.5a 12340.

That will do and explain everything about spell editing in 3.3.5a hopefully.

Did you remember to update the server side DBC files as well?

[therogues]

When you say server dbc files, are you talking about the SQL?

[stoneharry]

When you say server dbc files, are you talking about the SQL?

No. If you read the linked GitHub project README it will explain that the DBC files exist both client side and server side. The emulator holds the DBC files in a DBC folder usually, and the client holds them inside the MPQ files in the DBFilesClient folder.

[therogues]

So when I export the new spell.dbc, do I put it in the RePack\Core\data\dbc and replace the old one? This would be server sided, and then how would I replace it client sided?

[therogues]

Okay so it learns the spell but there is no mount in the mounts section not is there a new spell in my spellbook, any ideas?

[stoneharry]

Okay so it learns the spell but there is no mount in the mounts section not is there a new spell in my spellbook, any ideas?

It sounds like the client side update hasn't been applied. I notice in your screenshots you have named the MPQ patch-7.mpq. Try naming it patch-4.mpq, since patch-3.mpq is the last Blizzlike one. I cannot remember if they need to be sequential.

A easy test is to use the spell editor to rename death touch (spell ID 5). It's an existing spell and you can learn it as a GM. If you can see the renamed spell in your client then the update has worked.

The easiest server side test is to try and learn a new custom spell. If the server doesn't know about the spell and refuses to learn it to you then the server has not been updated.

[therogues]

What I did was I walked away from RePack (Thats what I used) and cloned a fresh copy from the GitHub.
Things seems to work a bit better here but I still have a issue.

These are the exact steps I took.

Once everything was setup I went into Items_Template in my SQL, I Duplicated the Swift Spectral Tiger and gave it a new ID and a new name.
Then I opened up MyDBEditor aned edited the Spell.dbc file in my DBC folder, I duplicated 42777 which is a spell used to summon a Swift Spectral Tiger, gave it a new ID (80.000) and a name.
Then I went back to my Item_Template and changed Spellid_2 from 42.777 to 80.000 (which again, is the new spell, the only thing I changed was the ID and name)
Spellid_1 is a spell called "Learning" so that stays the same.

Then I went ingame, spawned the item 80.000 and got the new item I created, clicked it and it got added my my mount collection, the issue is that it added a Swift Spectral Tiger and not the new item I created.
Why is that?

[stoneharry]

What I did was I walked away from RePack (Thats what I used) and cloned a fresh copy from the GitHub.
Things seems to work a bit better here but I still have a issue.

These are the exact steps I took.

Once everything was setup I went into Items_Template in my SQL, I Duplicated the Swift Spectral Tiger and gave it a new ID and a new name.
Then I opened up MyDBEditor aned edited the Spell.dbc file in my DBC folder, I duplicated 42777 which is a spell used to summon a Swift Spectral Tiger, gave it a new ID (80.000) and a name.
Then I went back to my Item_Template and changed Spellid_2 from 42.777 to 80.000 (which again, is the new spell, the only thing I changed was the ID and name)
Spellid_1 is a spell called "Learning" so that stays the same.

Then I went ingame, spawned the item 80.000 and got the new item I created, clicked it and it got added my my mount collection, the issue is that it added a Swift Spectral Tiger and not the new item I created.
Why is that?

Have you tried clearing your cache? Delete the cache folder in the WoW directory and restart the game.

Can you post some screenshots? I'm not sure I follow - when you say Swift Spectral Tiger got added, you mean the original item and not the new one you have made? Does it learn the new spell id? If it's just displaying the wrong name and icon then it's a cache issue.