Category: AddOns and Utilities

When I opened up World of Warcraft to play with patch 5.1, I noticed that one of my favorite addons, ArkInventory, was broken. Lime green boxes appeared in my inventory in place of things like Golden Lotus, Crane cards, flasks, and Giant Turtle Tongues.

While we patiently wait for ArkInventory and all of our other addons to be updated, there are workarounds. For ArkInventory, here’s the fix:

  1. If you are currently in World of Warcraft, exit the game
  2. On your local computer, navigate to <Your WoW Installation Folder>\World of Warcraft\interface\addons\ArkInventory
  3. Open up ArkInventory.xml in your favorite text editor.
  4. Find all occurrences of file=” and replace it with file=”Interface\Buttons\UI-PassiveHighlight”
  5. Save ArkInventory.xml
  6. Launch World of Warcraft and enable ArkInventory (even as an out-of-date addon)

That’s it! Your bags will return to the way they were in all their glory.

Source: http://code.google.com/p/arkinventory/issues/detail?id=577

UPDATE: This has now been officially fixed in version 3.03.21.

A crafter should always know the value of his tools and materials. This is true for crafters making goods to skill up and for those creating items to sell on the auction house. Material value can be easily seen in the game by using the World of Warcraft addon LilSparky’s Workshop (LSW).

What is LilSparky’s Workshop?

Simply put: this addon calculates the cost to create an item and lists the item’s market price next to it. This is powerful information when determining what items to craft when attempting to make gold on the auction house. This addon supports auction house scanners AuctioneerAuctionLiteAuctionMaster, and Auctionator.

Configuring the AddOn

Assuming you have one of the four support scanners, LSW will start working right away with no configuration. It will modify any of the following trade skill interfaces:

If you right-click on the value or cost column, you can select auction, vendor, or disenchant pricing model. By default, the greatest value returned from the three models will be used for that item.

Using the AddOn

You should see both the value and cost columns in your trade skill interface. Your potential profit is the value of the crafted item, minus the cost. LSW formats the value text in bold for items with a profit greater than zero. I use AdvancedTradeSkillWindow (ATSW), and sort my craftables by “difficulty.” I can then eyeball items with a higher profit and make those while leveling a profession.

I haven’t found a way to use LSW and ATSW together to return items sorted by greatest potential profit first. Skillet, on the other hand, will allow you to sort by LSW values, including “LSW: Profit.” The ability to sort by profit is extremely helpful if you are mass producing items.

Download the AddOn

You can download LilSparky’s Workshop from WowAce. The current version as of this post is r138 (September 29, 2012). This addon is not current on Curse or Wowinterface.

Yesterday, I wrote an introduction on how to use The Undermine Journal‘s IQY data source for your gold-making strategies in World of Warcraft. Today, I’ll walk you through a scenario where I calculate the price point for Mists of Pandaria Darkmoon Faire cards.

Previously, I worked through the various calculations to determine a conservative herb milling-to-Darkmoon Faire card crafting rate. I figured that it takes about 212 MoP-level herbs to craft a single card. If you are buying herbs at or under market prices, you can then set your price for a potential, substantial profit when you list your card.

Create a Master Market Pricing File

To get started, generate an IQY file from the Undermine Journal and open it using Microsoft Excel. You will be prompted with a security notice, and it is your responsibility to understand what this means and allow/enable the security exception if you wish to proceed.

You should now have a new Excel workbook with a single worksheet that is populated with WoW auction house market price data. This will be your master market price data for all of your other workbooks. Now, save this workbook to your computer.

You will need to update this file manually in order to retrieve current market pricing, but if you link to it properly (as you’ll see below), then all of your other spreadsheet calculations will use current market prices instead of you having to search for them one at a time and enter them as static values.

How to Use the Master Market Pricing File in Your Formulas

Next, create a new Excel workbook, and type in an item name into a cell. The name must match the actual item name found in the game, or the search will fail. In another cell within the same row of the item name, type the following formula:

=VLOOKUP(<item name cell>, ‘[<pricing workbook file name>]<pricing workbook file name’s worksheet name>’!$F:$G, 2, FALSE)/10000

In my DMF Card calculator, my formula looks like this:

=VLOOKUP(A2, ‘[The Undermine Journal – H-Earthen Ring.xlsx]H-Earthen Ring’!$F:$G, 2, FALSE)/10000

For me, this returns a match for the item name in cell A2 when searching my pricing workbook, “The Undermine Journal – H-Earthen Ring.xlsx,” where my worksheet name is “H-Earthen Ring.” Columns F and G should represent the item names and market prices as returned by the IQY.

Sample Use to Determine Cost of Creating a Darkmoon Card of Mists

I multiply the market price value of each herb by 212 (135 for Fool’s cap) to determine the minimum price I should sell a card for given the current market price. Theoretically, I’m buying herbs below market price, so this value should already indicate a small profit.

Here’s an example of what my table looks like given the current market prices of herbs:

HERB M PRICE MILL VAL TOTAL COST
Green Tea Leaf 2.42 2.42 212 512.85
Rain Poppy 2.27 2.27 212 481.16
Desecrated Herb 2.48 2.48 212 525.70
Snow Lily 2.74 2.74 212 581.49
Silkweed 2.41 2.41 212 511.47
Fool’s Cap 4.25 2.85 135 573.75

The “MILL VAL” column is used to determine the milling value of Fool’s Cap when comparing the ink yield rate against the other herbs.

As you can see, it takes a decent investment just to make a single card. You also have to factor in the Scribe’s time to mill the herb, craft the inks, and diligence to make their Scroll of Wisdom each day.

You can use this method for just about every profession that makes use of raw materials to help you determine what you should sell your crafted item for at minimum. If you’re not someone that is interested in crafting, this can still be useful to you to determine whether or not an item is above or below cost.

If you’re like me, then you’re handsome, famous, and play World of Warcraft. If you’re not like me, then you hate spreadsheets. Don’t worry, I’m here to help you. Now, let’s take a stroll to the forbidden, seedy land of Microsoft Excel and Web Query Files.

The Undermine Journal (UJ) is a great resource for data mining market prices and the economy in World of Warcraft. You can search for an item at a time, or use their canned reports to find various types of deals. One of the many hidden gems UJ has to offer is the availability of market data as a data source. I had been using the CSV format of their market price data, but recently switched to IQY.

IQY is a Web Query File that is nothing more than a text file that includes a data source address for a Web Service or API. The IQY file is then recognized by Microsoft Excel and data returned from the service call is displayed in a worksheet.

Here’s how to generate an IQY file for Excel:

  1. Register an account on The Undermine Journal. You will not have access to the IQY data source unless you are logged in
  2. On the User Controls page, find the “Market Data XML and CSV” section, choose a realm, and click on “Excel Data Source” to access your IQY file
  3. Save and open the IQY file in Excel

Now that you have your data, you can start mining the market locally. While you could certainly use this to simply look up item values for buying and selling, this data is extremely useful for crafting. In my next post, I’ll describe how this process applies to my crafting of Darkmoon Faire cards, and formulas you can use to query the data.

Pet Battles are fun. I can’t explain it. You can’t explain it. It’s fine, let’s move on. If you are into battling pets, especially those out in the wild, you’ll want to install the addon Battle Pet – Quality Notifier for World of Warcraft. Here is the official description of this addon from Curse:

Simply displays some information about the wild pet in your chat window.

Enough said, right? When you’re out flying around in the old world taking screenshots of your various transmog gear and how it looks in different light and environments, you can… What’s that? You don’t… fly around and… Yeah, I know, who would do that.

If you are out gearing up for your Mists of Pandaria raid, and you come across a pet that you might consider battling when nobody is looking, this addon will display the pet quality in your chat window. It will also tell you whether or not you own the pet, so you can consider whether or not you want to capture it.

As simple and awesome as this addon is, it will become obsolete with patch 5.1. Blizzard has already announced that tooltips will be added to the game that display additional information about battle pets out in the wild, while engaged in battle, and when viewing your pet journal. Until the patch drops, enjoy this enhancement to your battle pet UI.

Everyone needs a fishing buddy. Maybe it’s your favorite pet. It could be your favorite fishing pole. Cheap Beer is a decent fishing buddy. Maybe you have an online friend that also likes to fish. For me, it’s the addon with the actual name, “FishingBuddy.”

What is Fishing Buddy?

FishingBuddy (FB) is an addon for World of Warcraft that is very similar to the other statistical tracking addon I wrote about, MobInfo2. FB tracks your fishing casts and items acquired by location, and stores this data locally on your machine. Also like MobInfo2, you can view your data in reverse, displaying all the locations you’ve caught that particular fish, along with the chance to catch it.

While fishing, the addon displays your current skill level in Fishing, along with any buffs received from gear or consumables. If you’re like me and can only fish while wearing a particular outfit, you can use FB to swap between your current and fishing gear.

Configuring the AddOn

There’s not much you’ll want to modify in the configuration. FB is simple enough to start using as-is. I do turn on the option to display failed casts though. Much like MobInfo2, I like to see as much information as the addon can accurately display. You can also adjust the audio options to increase the “splash” volume while fishing which is useful if you aren’t always staring at your screen while fishing.

Using the AddOn

When you equip your preferred fishing pole, FB automatically displays a small window with all of your local fishing statistics for the particular location you are about to fish in. With every cast and catch, you’ll see the addon update the window with statistics for your current session, as well as a summary of all your sessions.

As someone who fishes for fun and for generating gold, I then take this information and determine how valuable the location is. For example, in The Jade Forest in Mists of Pandaria, I’ve determined that a successful catch is worth 17.5 gold. Yes, that’s per catch and not per session or per stack.

FB has tracked about 150 of my casts in the river near the starting area, and has calculated a 42% chance to catch Golden Carp, a 40% chance to catch Jade Lungfish, and a 13% chance to catch Redbelly Mandarin. The remaining 5% is given to Sealed Crates or quest items.

Based on the average value of fish on Earthen Ring, and the chance to Here’s the breakdown:

  • Golden Carp: 10g mean / 5g market
  • Jade Lungfish: 5g mean / 10g market
  • Redbelly Mandarin: 1.5g mean and market
  • All other (random items found in Sealed Crates): 1g

Download the AddOn

You can download the addon from Curse or WoWInterface:

Curse: http://www.curse.com/addons/wow/fishingbuddy

WoWInterface: http://www.wowinterface.com/downloads/info4239-FishingBuddy.html

FishingBuddy sample image courtesy of Curse.com.

I appreciate the changes Blizzard made to quest tracking. The enhancements made to the in-game maps are perfectly fine. However, I still prefer all of the features offered by Carbonite.

The problem is, Carbonite is currently stuck on version 5.041, last updated on September 10, 2012. The maps for the Mists of Pandaria zones are completely busted, and quest tracking is non-existent.

Enter Rythal, a World of Warcraft addon developer, who has published a “major update” to an “other addon,” also known as Carbonite. I have downloaded and installed Rythal’s version (5.049) and the Carbonite maps — along with quest-tracking features — are back.

I will continue to support Carbonite and understand that the mod authors will provide an official release as soon as their schedule permits.

When I came back to the World of Warcraft, I was quickly reminded of two things. For one, I can’t stand the stock user interface. On the other hand, the ability to customize the UI with community-built and managed addons is one of my all-time favorite features of WoW. Not being able to customize and simplify the user experience is one of the primary reasons other MMOs have not held my interest.

While Star Wars: The Old Republic did provide you with the ability to move, add, and subtract modules within your UI, the community could not contribute tools and functions. I lived with the stock UI there for many months, holding out for an addon community that had the potential to grow and be on par with WoW. That never materialized, and my career as a dark lord of the Sith came to a bitter end.

Now that I’m back and ready to rumble in the jungle with pandas, I have to find, download, configure, and use many addons that were an essential part of my Warcraft gaming experience. I will be highlighting those in a series of posts as I travel through the Mists of Pandaria.

What is MobInfo2?

MobInfo2 (MI) is an addon for statistics and data tracking junkies. As described by WoWInterface:

MobInfo-2 is a World of Warcraft AddOn that provides you with useful additional information about Mobs (ie. opponents/monsters). It adds new information to the game’s Tooltip whenever you hover with your mouse over a mob. It also adds a numeric display of the Mobs health and mana (current and max) to the Mob target frame.

Configuring the AddOn

By default, the MI tooltip will appear next to your mouse cursor when you hover over the mob. I find this distracting and use a static location for the tooltip. You can position the tooltip by dragging the tiny box with “MI” to the location you want the tooltip to appear. Then update the tooltip position under “Mobinfo Tooltip Layout.”

You’ll also want to combine data across like mobs at different levels. Most of the time, you will be grinding and questing on mobs that are 1-2 levels apart, but have the same loot table. Basically, I enable the tracking and display of everything.

Using the AddOn

When the tooltip appears, you will see a breakdown of the mob’s monetary value along with their chance to drop loot. Statistics on drops are broken down into tiers, and include cloth as well. So as you approach a mob, you can get an idea of your chances to get a particular type of item (or a specific item) to drop. The other great feature is that the data is also displayed in reverse. If you hover over an item in your inventory, information is added to the default item tooltip that displays where the item most likely came from.

Grinding on mobs for specific types of loot can sometimes be a gamble. If you’re looking to score some coin IRL, check out Party Poker at http://de.partypoker.com. Use MobInfo2 in-game to assist you in obtaining the items you need.

4

You can download the addon from Curse or WoWInterface:

Curse: http://www.curse.com/addons/wow/mobinfo2

WoWInterface: http://www.wowinterface.com/downloads/info21571-Mobinfo2.html