Jump to content
TrinityCore

Comprehensive Boss Spawn Id/Names??


geeksweep
 Share

Recommended Posts

Is there a comprehensive 3.3.5 list of boss ids with their name counterparts? I couldn't find it in the database at all. I find it odd that the 'Creature' table doesnt include it. Where are the names stored for their respective unique id? I am wanting to play around with the boss hp and loot tables(increase percentage of certain drops). 

Incidentally i see the creature_loot_template table but don't see how thats tied to any particular mob. How do you look at the db and tie loot drops to bosses? 

Edited by geeksweep
Link to comment
Share on other sites

For Example:

http://www.wowhead.com/npc=33118/ignis-the-furnace-master

Looks like he drops 26 items. So I found him(finally figured out where everything was). (Screenshot #1)

Then went to the loot label based on the loot ID from the first screenshot:(Screenshot #2)

#47241 = http://www.wowhead.com/item=47241/emblem-of-triumph

#1 = ?? not sure what this is supposed to be. 

So where are the other 24-25 other drop items? Is there a database update that I need to do for the 3.3.5 database i download ?

 

Another Example:

http://www.wowhead.com/npc=33293/xt-002-deconstructor

Loot in Screenshot #3. - It seems that these tables are incomplete. Again, is this expected or should i look for an updated database?

 

 

Screen Shot 2016-09-09 at 9.14.04 PM.png

Screen Shot 2016-09-09 at 9.14.54 PM.png

Screen Shot 2016-09-09 at 9.47.01 PM.png

Edited by geeksweep
adding screenshots
Link to comment
Share on other sites

2 hours ago, geeksweep said:

For Example:

http://www.wowhead.com/npc=33118/ignis-the-furnace-master

Looks like he drops 26 items. So I found him(finally figured out where everything was). (Screenshot #1)

Then went to the loot label based on the loot ID from the first screenshot:(Screenshot #2)

#47241 = http://www.wowhead.com/item=47241/emblem-of-triumph

#1 = ?? not sure what this is supposed to be. 

So where are the other 24-25 other drop items? Is there a database update that I need to do for the 3.3.5 database i download ?

 

Another Example:

http://www.wowhead.com/npc=33293/xt-002-deconstructor

Loot in Screenshot #3. - It seems that these tables are incomplete. Again, is this expected or should i look for an updated database?

The database is updated as long you have updated core, to learn how things works look at https://trinitycore.atlassian.net/wiki/display/tc/World

Link to comment
Share on other sites

@Aokromes thanks for the link. I don't understand why I would need to reload a table if I just got the full db a couple of days ago from your repo. I'm not sure what 'reload' accomplishes.  Are you saying if I reload a table the db would update new entries that aren't in the world db from the repo? (They would show up in my queries?) Why wouldn't the db already be up to date ?  

Sorry trying to better understand the core workflow and hopefully to help others down the road. 

Link to comment
Share on other sites

If `Reference` is nonzero, then the value in the `Item` column for that row is ignored (it's only set for primary key uniqueness).

In this case, the loot slot(s) generated by the entry are populated by items from `reference_loot_template` with entry = reference ID from c_l_t.

Also note that the Ignis entry in creature_template with entry 33118 is the template used on difficulty 0 (10-man normal, for raids). On difficulty 1 (25-man normal), some aspects (such as the loot table) are taken from the creature_template specified in difficulty_entry_1 - for Ignis, this is 33190, so you'd refer to creature_loot_template with entry = 33190 (and the references listed there) for 25-man loot.

 

PS: Not relevant to your issue, but database updates happen when the core starts up assuming you've updated your source folder from the git repo. The worldserver binary checks <source>/sql/updates/world subfolders for any files it hasn't applied yet and applies them in order - it knows where the folder is because cmake sets the source path as a compiler constant. If this doesn't match your setup, worldserver.conf has a variable that overrides it.

PPS: For quick clarification questions like this, it's probably better if you get on IRC (#trinity @ Rizon). Forums are awfully slow (and I never read them anyway).

Link to comment
Share on other sites

On 9/10/2016 at 5:02 AM, geeksweep said:

Why wouldn't the db already be up to date ?  

Current world DB content is the last TDB file (TDB_world_full_....sql) file + all the .sql files in /sql/updates/world

It's impratical to keep the world DB (and hotfix DB on 6.x) always updated due to its size (unlike character and auth DB base files which are always updated)

Link to comment
Share on other sites

On September 10, 2016 at 6:16 AM, treeston said:

....

Also note that the Ignis entry in creature_template with entry 33118 is the template used on difficulty 0 (10-man normal, for raids). On difficulty 1 (25-man normal), some aspects (such as the loot table) are taken from the creature_template specified in difficulty_entry_1 - for Ignis, this is 33190, so you'd refer to creature_loot_template with entry = 33190 (and the references listed there) for 25-man loot.

.....

PPS: For quick clarification questions like this, it's probably better if you get on IRC (#trinity @ Rizon). Forums are awfully slow (and I never read them anyway).

 

Thanks Treeston. So for 33190 - i only get 5 rows. and one of them is a duplicate from the 10 man normal. so where do i find thhe remaining 20 items from the loot table? 

Also i looked up one of the drops from Ignis:

http://www.wowhead.com/item=45165/worldcarver

then looked this up in the 'item_loot_template' and it wasn't found. So it looks like a lot of these aren't even in the DB. 

Edited by geeksweep
Link to comment
Share on other sites

On September 11, 2016 at 10:51 AM, Nay said:

Current world DB content is the last TDB file (TDB_world_full_....sql) file + all the .sql files in /sql/updates/world

It's impratical to keep the world DB (and hotfix DB on 6.x) always updated due to its size (unlike character and auth DB base files which are always updated)

Understood. I guess i figured since we were talking about 3.3.5 (multiple expansions ago) and the last update was April 10th, that the loot tables would be complete.

Edited by geeksweep
Link to comment
Share on other sites

1 hour ago, geeksweep said:

Understood. I guess i figured since we were talking about 3.3.5 (multiple expansions ago) and the last update was April 10th, that the loot tables would be complete.

No, the last update to the world database is today.

[06:58:01] <WardenX> TrinityCore/TrinityCore (7ce1040 * 3.3.5): GitHub(ariel- authored) committed DB/Spell: remove SP Scaling for Druid T10 4p bonus (Balance) https://git.io/vizpL

 

Link to comment
Share on other sites

On September 13, 2016 at 0:40 PM, Nay said:

There's a lot more than loot in the world DB.

Yeah but the db that I've been using in this thread is the world DB and I have downloaded is the latest I thought (I am using 3.3.5 not 6.x). 

I got that DB here: https://github.com/TrinityCore/TrinityCore/releases/tag/TDB335.61. Last update was Apr 10. I got there using the installation guide for databases here: https://trinitycore.atlassian.net/wiki/display/tc/Databases+Installation

@Aokromes said there was an update today but don't think that would resolve this issue I am referring to here. 

@Nay maybe i am missing something - is there another sql file I should be getting. 

 

Looks like maybe the full database releases aren't synched up with all the daily changes. these are the files I am using now.(screenshot)

 

Screen Shot 2016-09-15 at 10.43.22 AM.png

Edited by geeksweep
Link to comment
Share on other sites

Just now, geeksweep said:

Looks like maybe the full database releases aren't synched up with all the daily changes. 

That is I was trying to explain, it's not feasible atm to sync them daily or immediately. The "absolutely" complete DB is the file you got from releases + all the .sqls in /sql/updates/world.

Link to comment
Share on other sites

@Nay - ok so I'm confused then a little. Whats the best way to just replace the current world db without having to re-compile everything and making sure that the full db loads that updated world db so that i can look at in HeidiSQL? I guess i am confused on those steps - the installation guide is hit or miss for mac osx. 

My core installation should be up to date (if up to date means within the last 10 days when i first installed everything - mac OS X btw). @Aokromes linked me to the world database where i could reload the tables in game which i did (.reload) but the same loot appears to be missing. 

 

@Nay thanks for help!

Link to comment
Share on other sites

@Nay - ok i closed auth & world server and restarted both. I then did a pull on 3.3.5 and saw that it got all the sql updates since 9/15 (today). Enabled Databases is set to 7.

I think tried to start the world server again and below is the error that i get (please see screenshot). Any tips on this? User issue or sql issue?Screen Shot 2016-09-15 at 12.31.50 PM.png

Link to comment
Share on other sites

@Nay looks like i am good to go but re: my first post about my findings, that still holds true. (and it looks like for a lot of other bosses as well). Theres lots of drop items from Ignis The Furnace Master that aren't available. Please see post above about looking at the loot for the different difficulties(33118, 33190). The world carver item doesnt even exist at all. 

Are the loot tables for 3.3.5 still incomplete then?

Screen Shot 2016-09-15 at 1.03.55 PM.png

Screen Shot 2016-09-15 at 1.07.20 PM.png

Link to comment
Share on other sites

On 10.9.2016 at 1:16 PM, treeston said:

If `Reference` is nonzero, then the value in the `Item` column for that row is ignored (it's only set for primary key uniqueness).

In this case, the loot slot(s) generated by the entry are populated by items from `reference_loot_template` with entry = reference ID from c_l_t

Read what I said, please.

s1Y3cft.png

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By PavelFreeman
      Hello, I want to compile Trinity, but I get this errors...

      Did everything according to the documentation (https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130077/Installation+Guide) for Windows 10.

      Visual Studio 2019.
    • By PhaseV
      I unfortunately had to find out that there are no bags for the profession of leather processing in the current database for 3.3.5.  Is that also the case with you?  Can someone who has this available as SQL?
      Greetz PhaseV
    • By Valufa
      Hello, would anyone know if there is an XML OR JSON file with all the class spells from section 3.3.5a?
      If not, would you know how to inform the procedure on how to extract this information from the game client, or some way faster than Web Scraping?
       
    • By Dipdill
      So I got a new Trinity Core server up and running.  For the life of me I can not get my client to connect.  I have edited the Data\enUS\realmlist.wtf to point to my server.  I have confirmed that the firewalls are open to both 8085 and 3724.  When I open the wow.exe client I use my credentials and it immediately goes to Downloading Update screen and sits at 0%.  I have also added set patchlist to my server thinking that might help and still no go.  I downloaded the client from warmane as mentioned in this thread:  
      Did I miss a step on patching the wow.exe file?  I know on the new master branch there is a patching process... but I didn't see one for the 3.3.5 branch.  
      Thanks
    • By Hesione
      I'm having a problem with a number of factions not getting the flag "at war" in the reputation tab, and this is unable to be selected by the player. Currently, this is with The Oracles, as my character has their reputation with Frenzyheart. The problem occurs when one of two opposing factions is chosen as the positive reputation one. That said, Bloodsail Buccaneers seems to work fine.
      I did a search on how to fix this, and found this on the TrinityCore issues tracker: https://github.com/TrinityCore/TrinityCore/issues/9469 (specifically https://github.com/TrinityCore/TrinityCore/issues/9469#issuecomment-78925130)
      Do I just go into the ReputationManager.cpp file and edit it directly? I don't understand how the dbc/cpp files are used. Are they called by the client each time the client is started up?
      I found the code for ReputationManager.cpp here: https://github.com/TrinityCore/TrinityCore/blob/master/src/server/game/Reputation/ReputationMgr.cpp
      I don't understand how the fix goes into this code. I can see a Git pull (push?) whereas I thought I could just edit ReputationManager.cpp directly. If so, which lines do I replace (if any)? Otherwise, where should I insert the fix?
       
×
×
  • Create New...