Jump to content
TrinityCore
ghostdub

Understanding the Hotfixes table

Recommended Posts

Hello, everyone!

I'm trying to understand how the Hotfixes database works, in particular the item_sparse_locales table. I couldn't find enough documentation to properly understand how it all works.

As far as I understand it, this table is a good way of altering a certain item's name/description without updating the db2 files in the client.

What I don't understand is some of its fields and how to fill them to get it to work:
• Locale: I know it's supposed to be filled with 4 chars but I'm not quite sure what the format should be or if it's case sensitive: enUS, enus, ENus or ENUS?
• Name2_lang, name3_lang, Name4_lang: Why are there 3 "name" fields aside from the numberless one? What's their purpose?
• VerifiedBuild: What value should I insert here? Any positive value works?

There's also the matter of the hotfix_data table (this is all the documentation I could find about it: https://trinitycore.atlassian.net/wiki/display/tc/hotfix_data ), I couldn't quite figure out how to get it to work with the item_sparse_locale table or even if it's necessary. There're some entries in the regular item_sparse table that don't seem to be reflected in the hotfix_data but they're still picked up by the client regardless.

Thanks in advance,
Dub.

EDIT: I'm also looking for the function in the Core that handles sending item names/descriptions to the client, if the previous stuff doesn't work out! I'm trying to get certain items to load their names and descriptions from a MySQL table (custom or already available).

Edited by ghostdub

Share this post


Link to post
Share on other sites

I'm guessing VerifiedBuild might either represent the expansion pack where the data was first introduced. Just an initial thought though. It could be useful for conditional statements in the core, especially if an npc should or should not behave a certain way, or it's a way of saying that the data is set in stone. I'm guessing the latter if the verifiedbuild matches any of the builds for the wow clients.

Share this post


Link to post
Share on other sites

VerifiedBuild is not used by the core, at all. Its purpose is to annotate the build where the data was introduced to our DBs (except for custom stuff, all the data in the hotfix DB is from sniffs).

I'll let someone else answer the questions regarding the hotfix DB.

Share this post


Link to post
Share on other sites
2 hours ago, Nay said:

VerifiedBuild is not used by the core, at all. Its purpose is to annotate the build where the data was introduced to our DBs

Thanks Nay! I was wondering if I would have to use it during sql queries to retrieve the correct record for the client being used.

Share this post


Link to post
Share on other sites

Hard for "me" to explain. But I have a slight understanding. Just read whatever is under the hotfixes DB in the wiki and I am sure that you will get an idea of what it is for. Example: You have an item which is plate, you can set it to leather if you want and also to what slot it should be along with other stuff such as flags etc.. Correct me if I'm wrong.(Just my understanding so far, might or probably will be wrong=D). Also interested in knowing the full use of this table.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By darki73
      So i guess it is pretty obvious about what am i going to ask =)
      Problem is, previousle we could just sha1 username and password separated by colon and here is the sha_pass_hash.
      The problem i am facing right now, is that according to https://github.com/TrinityCore/TrinityCore/blob/86b98686a95e23247ecb774fb23ecd5b8d94b97b/src/server/game/Accounts/BattlenetAccountMgr.cpp#L177 Trinity now uses SHA256, so the hashes do not match anymore. The thing is, password length in database is 40 symbols (exactly as many as in sha1 hash), but sha256 hash length is 64 characters long. I am confused...
      I've tried to recreate whole "Cryptography" thing on PHP but, guess what, failed.
      Can somebody explain me how the password is generated nowadays?
      Thank you for your attention. 
    • By HolyNitzan
      Hey Guys,
      I'm  using the last build of TrinityCore for WoD, currently using latest TDB release, I noticed that there are no spawns in Draenor, I would like to konw how could I solve it? is the TDB not populated with Draenor mobs/npc spawns?
    • By Shinzon
      I have searched all over the forums and can't find anything that exactly matches this. 
      I can connect fine to the server using my windows client, but when I try to connect using my mac client it immediately bounces back stating "You have been disconnected from the server". 
      I have the correct IP address in the config.wtf (And realmlist in the DB) but still can't connect. 
      I of course can't apply the connection patcher, because the EXE isn't mac compatible. 
      Is there something else I need to do to connect with mac?
      Here is my connection.log if it helps (NOTE that the ".logon.battle.net" I can't get rid of... there is no where config.wtf that has that).
       
      3/14 13:10:21.966  Login program=WoW platform=Mc64 locale=enUS 3/14 13:10:22.097  Component WoW.Mc64.20886 3/14 13:10:22.097  Component WoW.base.20726 3/14 13:10:22.099  Battle.net is Component Bnet.Mc64.37165 3/14 13:10:22.099  LOGIN: state: LOGIN_STATE_CONNECTING result: LOGIN_OK  3/14 13:10:22.145  Failed to resolve “108.26.241.19”.logon.battle.net 3/14 13:10:22.145  LOGIN: state: LOGIN_STATE_FAILED result: DISCONNECTED  3/14 13:10:22.145  Login program=WoW platform=Mc64 locale=enUS 3/14 13:10:22.145  Component WoW.Mc64.20886 3/14 13:10:22.145  Component WoW.base.20726 3/14 13:10:22.154  Battle.net is Component Bnet.Mc64.37165 3/14 13:10:23.298  Client Disconnect due to reason:8 3/14 13:12:54.053  LOGIN: state: LOGIN_STATE_CONNECTING result: LOGIN_OK  3/14 13:12:54.073  Failed to resolve “192.168.1.130”.logon.battle.net 3/14 13:12:54.151  LOGIN: state: LOGIN_STATE_FAILED result: DISCONNECTED  3/14 13:12:54.151  Login program=WoW platform=Mc64 locale=enUS 3/14 13:12:54.173  Component WoW.Mc64.20886 3/14 13:12:54.173  Component WoW.base.20726 3/14 13:12:54.308  Battle.net is Component Bnet.Mc64.37165 3/14 13:12:54.309  Client Disconnect due to reason:8  
       
       
    • By FreddyLIE
      Hello,
      (sorry for bad english)
      i was trying out the 6.X Core and there was no Spawns in Dreanor.
      So i want to Sniff them from Live and add them my Self. If i manage to get it to work i will share my Work.
      I need some help.
      Im complete new to sniffing/parsing. And the last time i was setting up a Privatserver is some years ago.
      Some month ago i made my degree in Software dev. so i got "some" C# & SQL knowledge.
      Im compiling the Core and Parser myself.

      My sniffing attemps
      I was walking around in Dreanor/Gorgrond for testing to get some spawns.
      I got a 2MB .pkt Package and try to parse the creatures and i got some data out that looks not correct to me.

      - The names of the creatures not working, looks like some utf-8 problem.
      - The data dont look correct, and dont match the TDB tables. for example:
      [...] modelid1=32784, modelid2=117440512, name='�', rank=1852130080, family=1851877746, type=1866932324 [...]

      The parsed SQL is producing errors like this:
      Out of range value for column 'modelid2' at row 1
      Out of range value for column 'rank' at row 1
      Out of range value for column 'family' at row 1
      [...]

      Can you help me getting this to work?

      See attachments.
      - FreddyLIE
      WowPacketParser.exe.config
      2016_06_10_22_33_04_21742_2016-06-10_19-55-38_0E9CA614.pkt.sql
      2016_06_10_22_33_02_log.txt
    • By Informatique101
      Solved
       
       
       
       
       
       
×