geeksweep
-
Posts
22 -
Joined
-
Last visited
-
Days Won
1
Posts posted by geeksweep
-
-
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?
-
1
-
-
@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?
-
7 minutes ago, Nay said:
Exactly the way I said it: the full db + importing all the /sql/updates/world files. You can update manually but it's better if you let worldserver do the job.
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!
-
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)
-
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.
-
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.
-
@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?
-
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?
-
yeah i just got to lvl 3 and the trainer gave me stealth. did the character page pane never allow you to scroll to see what was upcoming?
-
now that I'm thinking about it maybe this wasn't available until maybe lvl 5 ? Then again i don't see the list of options greyed out (only Page 1) with what you will get and what level. I don't remember if this was just the way it was in WOTLK or not. so maybe this isn't a bug or issue. will get to level 5 and see
-
Just got everything working and running properly! woot!
But there is an issue - there is no subtlety tab in the character pane(please see screenshot) and as a result (assuming) i cannot stealth.
Any pointers on whats going on here?
-
2 hours ago, Nay said:
You really need to read our install guide with attention.
You don't need Wine, you can (and should) compile the server and tools for OS X. Start at https://trinitycore.atlassian.net/wiki/display/tc/Installation+Guide.
I guess i should have known that you need to run these from the command line (although this isn't spelled out in the installation guide under Mac OS X) but i figured since i had already installed wine i could run the exes by double clicking.
-
Hi all,
been trying to set up my own personal server here and ran into a road block. Please see attachment. I believe that i have all the data necessary in the bin/ directory where the world server.exe exists. I am running this from Mac OS X El Capitan (using wine devl to run the exe files). I have all the .sql files available but somehow it cannot find it.
Also, I originally downloaded a repack and supposedly had all the MPQ files available but I am just not familiar with how these extractors work. that link is here: http://www.ac-web.org/forums/showthread.php?211443-Official-AC-Web-Ultimate-Repack-(3-3-5a) It seems that this is legit and up to date with trinity core but i know you say in the installation guides to use only your extractors for support so trying to do it according to the installation guide below - but confused as to what to expect here.
According to https://trinitycore.atlassian.net/wiki/display/tc/Server+Setup#ServerSetup-3.3.5aonly: i put the tools where my binary is (torrent download) but when running the first extractor i get something that says "no locales found" and the other ones don't seem to work. (please see screenshot about common.mpq)
Can anyone help? The OS X Server set up piece seems to be pretty much incomplete.
Thanks1
[SOLVED]Health reset after leveling of debuffed
in Solved Issues
Posted
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?