ATTENTION: Links are broken unfortunatelySorry guys!
Hello! If you are one of those types who likes to grind rares/epics.. Then make it even easier with Navicat for MYSQL 8.0.10 ! :wave:
I have searched and did not find any post. I got this from my 100% pure mind :bigbrain2:
Here's the link for the Navicat guide! (Ignore the private server part) Link
And if you allready have Navicat installed, gr8 for you!
1) Open your newly/old installed Navicat!
2) Then get these SQl text files to execute - Download link
3) Once executed.. (This usualy takes 15-30min)
4) Right click WoWEmu (Note that this is just what i called it) Press open connection.
5) Then right click Ascent (Note that this is just what i called it) Press open database.
6) Now.. Watch image. Double click ''Creatureloot''
7) Now sort the itemID list. (Right click it) Use the ''Sort Ascending''
Go to Thottbot and find whatever item that you want to grind for. (Epics rares etc.)
9) Example: If u want.. Bow of Searing Arrows, seach on that on Thottbot.
10) W8 for Thottbot to find the searched text
11) When its loaded, look at the http at the top of the page.
12) It should be thottbot.com/i2825
13) Copy the ''2825'' wich is the ItemID.
14) Now go to Navicat under the ItemID's ..
15) Find the ItemID: ''2825'' Wich is the item we want to look up, (It should be easy now when its sorted) Note that there are more than one.. Its because it drops from several mobs.
17) It should look like this when found:
1Look at the drop chances, (Percentchance) Find the highest. Here the highest is 0.2475% drop chance
19) Under the same line.. Look left, there should be something called ''EntryID'' The one for 0.2475% is 2473.
20) Copy the EntryID.
21) open InternetExplorer write Thottbot.com/c[Ur EntryID here] And then hit enter
22) The mob who drops it should appear on Thottbot..
23) Go grind. :wave:
This guide is very good for example.. Making money + grinding pots.
I found 2 epics and 5 rares on 6 hours played time.
------------------------------------------------
Credit for setting up Navicat goes to Zackala
Note that it is a good idea to update ur SQL files (The ones that u execute)
after each big WoW patch, now when they change alot in Database
Have fun!![]()