R4GN4R

Yeah, that is fine I noticed there is quite a few lengthy warnings in world server when it loads claiming things aren't where they need to be or not listed as functional. Not going to go into details or submit a log as it is the same info you get since we are using the same world DB. I just got me a DB editor and was going to go into Achievement ceriteria and Achievement Category and see if I can even see it listed there. Then work from there. If I get anywhere I'll give ya a copy of my work or tell you what I did to help you for a change.

One more thing. If you could do me a HUGE favor and go into BH 10 man or 25 man, kill all bosses and see if it gives you the achievement for BH not only bosses but BH raid. Because I got the achievements for Bosses killed, but once all 3 bosses are dead no achievement to be found for the raid itself. I am wondering not only why this is happening but how to fix it and implement it into the scripts or DB whichever is the reason for it not being finished.

After running this SQL file I no longer cannot do half the things I couldn't do before... thank you so much Kylroi. I have been able to do what I need to do now.

Thanks so much Kylroi. +rep if we do that here... Besides the custom weapons you added what other stuff has been added?

Unfortunately, I STILL cannot seem to get it to work without throwing an error doing JUST LIKE it said on the wiki. As confusing as it is anyhow. I have never tried following a tutorial and lost this much hair over this much static.I have gotten many different errors. Only ONCE was I able to make the server playable and it was mostly just a sandbox with nothing working properly. I would just like a working ENTIRE DB please. This shit is just way too complicated for my taste because of confusion with wording. If only I could do it myself, but since the instructions are as clear as need be I will never seem to get this.

So using merge_windows.bat will merge all files in time sequence order and will not throw errors? As a matter of fact after this I think maybe I will take that custom sql so I can edit items like the ones you have that are custom. Besides I just finished copying all world updates from both folders to one folder. And used the merge_windows.bat on them and it yielded a 11.5 MB file lol. I'm using Windows 7 Ultimate x64 SP1. Edit: So I updated my DB after dropping world, and I created a new world DB. Used the trinity full file called, "TDB_full_434.05_2013_07_17" then I merged all updates in both updates folder using the merge_windows.bat file that came with it. Ran that sql file as a result of the bat and came up with this error. Where did my picture i pasted here go? WTF?!?!?!?!??!!?!?

Okay, that clears the air of what DB to update. But that still leaves the 2 (TWO) directories. There are two sql update directories after a core compile and DB structuring. Should I update the ones in TrinitySource first then the ones in the TrinityDB? Another thing, why do I keep getting database errors whilst trying to update with these files? I swear we should either make a video tutorial, or have all required updates current with a fresh core compile. It would surely make this job a hell of a lot easier. I mean when you download a program, does it need updates? Not normally... That clears the items as well and thanks for your quick response. I am using the merge updates file included within the folder only i copy it to the database fiolders I need and use it there too. Am I doing this wrong? Maybe the .bat file is not concatenating them in order, so objects in the database aren't getting put in at the right place and failing since there seems to be a lack of the index name it specifies in the next query?

First of all I want to say I thank you all at Trinitycore for your time and investments in knowledge to help some of us newbies out and create and implement a structure we all can try our best to cope with. Now on to my questions. Yesterday, I installed and ran my first 4.3.4 Compile about four times, all without constant success. The fourth and final time following a video I found on youtube was able to get the worldserver to not crash upon open. All by database updates. and NONE of the folders I updated from didn't throw an error and stop my DB SQL from running. Now, one question I have is the order in which and what updates should be applied to the DB for a fresh compile current core and all. I know I have done 3.3.5a in the past several times and was successful getting even transmog, playerbots, custom items and custom objects working by myself using google and researching wowhead and things. But 4.3.4 Cataclysm seems to be a little trickier. None of the items I see in vendors are in my DB (At least where they used to be at.) but show up in vendor list as items available... When making a new server with current and latest core is it too much to ask after you fellas did all this extra work to make the server functional and this far into the project to not have ANY updates on a fresh compile? Or to make it just a little more descriptive on what to update and how and what DB also for a fresh compile? I am pulling my hair out here and all I wanted to do is help and accomplish things so that I too can contribute what I already know about the game and maybe even do somesort of sniffing for you devs. Funny thing about that is even using a sniffing tool has a vague description on how to use it for yourself even. So to be honest I think maybe it is time for one of you advanced members to make some sort of tutorials on how to accomplish some if not all of these tasks to help this community. Lack of motivation/support is why projects end up dead. But once again, I thank whoever is responsible for making this project what it is already and it is awesome! I just think it can be improved more and if I knew my stuff I would be the first person to stand up and make a guide to help others make this a strong and productive project/community.

^ Exactly Possibly because there are no words that include pipes so it omitted them out. Most search engines omit words of 3 or less letters anyways by default. Words like: to, and, or, IE booleans.