geeksweep

I don't know if this is a bug (or a bug that can be easily fixed) but if you are in game and set your health/energy to a number. i..e .mod hp/energy xxx, when you level or have a debuff applied to you the hp/energy is reset to the normal values dependent on level and armor that you are currently wearing. obviously this doesnt bode well when fighting a boss or whatever. Wanted to see if there was currently something to prevent this from happening?

I was able to send myself those bags via mail using the gm command but for some reason giving it to me in the database wouldn't work.

I am trying to insert some bags into my equipped slots and for some reason its not working. http://www.wowhead.com/item=23162/forors-crate-of-endless-resist-gear-storage Please see screenshots to where I can locate them into the database and using https://trinitycore.atlassian.net/wiki/display/tc/character_inventory# for the docs. Here I attempt to put this item into slot 20 in my character_inventory table with the unique key from wowhead and from the database. When i launch the game the only bag i have is the default backpack. Any help would be appreciated. thanks!

gotcha, didn't know if that was a bug or not - couldn't remember. there was a quest to get 'Garott's head' and to get grapes from the winery which the quest assumes you would have to tend with a bunch of mobs.. but they are neutral. Kinda thinking those mobs might have been not neutral. ??

testing out northshire area for human and all the quests so far - all the mobs appear to be neutral (see screenshots). Shouldn't they be aggressive to attack on site?

@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?

@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?

@Nay - ok i am going for 3.3.5 so this is where I am at now: https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql/updates/world/3.3.5 you said, let world server do it for you - so what command(s) at the prompt do i need for this to happen?

sorry i dont see where you said how to do this before.

@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!

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)

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.

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.

@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.

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?