Jump to content
TrinityCore

fatotaku

Plebs
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About fatotaku

  • Rank
    Newbie
  1. It's not natural at all. If you look through the table structure, you will see that the RealmId originates from worldserver.conf and carries through to the DB. RealmId must be unique per application instance - i.e. the database is effectively sharded / separate, based on the realmid. Furthermore, the app will be caching a lot of data and won't read unless it needs to. Otherwise it would be dreadfully slow. Hence, you need to fix your network setup and have a single realm working on both connections instead of looking for ways to have 2 realms act as 1. Migrating characters should be easy, since all you need to do is a global update on the realm id on all tables, given you will be abandoning the other realm.
  2. So - I don't know if I did something wrong or what. Let me first describe the issue, and then describe my setup. 1. The problem When I learn a profession (have not tried all, but have tried tailoring, enchanting, mining and blacksmithing), the skill appears on the professions pane, and the skill becomes 0/0. Tailoring is impossible to level, as the initial 3 recipes (of greatest importance is Bolt of Linen Cloth) are missing. Mining is impossible to level, because mining doesn't grant any levels, and the pick shows red text indicating mining skill is missing. However, if I click on a mineral node, (copper - have not tried other minerals), it does mine! Have not tried to actually make something with blacksmithing and enchanting. 2. The setup My setup is fresh - I only started with Trinity Core yesterday, so it was a matter of following the instructions on the wiki page. I am running a debian 10 buster server. I followed the linux / debian instructions to download the latest code in the master branch from git, and then compile it, etc. I used the data files generated from the current version of World of Warcraft retail. I used the database files that were in the wiki... TDB830.20061 3. According to the issues board, there seems to be a similar sounding issue, but not identical to my symptoms - about tailoring at a much higher level than mine. https://github.com/TrinityCore/TrinityCore/issues/24026 It said that this was caused by the DB values being wrong. If that is so, I assume there's a disconnect between the DB script I used, and the code I am running (830 for the sql file; vs 837 being the latest code version). Is this what is causing my problem? How do we keep the DB and code in sync? And where can we get the older client from? 4. So after I posted this thread, I went digging into the DB. Lo and behold, I found that the values in character_skills table seem off, and aligned with what I was seeing on the screen. i.e. character_skills table contains the following entry (character level 8): 1, 186, 1, 40 According to Wowhead, mining is skill id 186, so this should be something like: 1, 186, 1, 75 or 1, 186, 1, 300 Furthermore, 186 doesn't exist in the table skill_tiers, which I assume is necessary to learn the correct profession, given the data of the other entries. So I think this confirms that TDB830.20061 is the issue. Line 5459 of TDB_full_world_830.20061_2020_06_17.sql - There's no skill 186 in this table, hence the skill is being treated as some combat skill (5 x char level). Now I'd like to ask where I can find an ERD of the db, so I can try to fix it myself. I'll contribute back once I have fixed it. Thanks in advance
×
×
  • Create New...