Miscellaneous Hacks - World of Warcraft Crafting Database

This is a WoW Crafting/profession database that users of your guild/realm can import their trade skill data into your vBulletin site to search for rare and hard to find recipes.

You use a separate wow addon (download from wowinterface.com, link provided on the crafting page) to export a XML string that you import into the crafting database.

Currently the only permissions that are needed is that a user is registered to the forums.

I do plan on adding more permissions and options as well as improve the search results as they may list a LOT of results if you have a large database.

Future plans include optimizing the database so that search results are much more compact and easier to read.

THIS IS super ultra beta sunblocker 2000, use at your own risk.

USE OF https://vborg.vbsupport.ru/showthread.php?t=183035 IS HIGHLY RECOMMENDED.

Warcraft addon: http://www.wowinterface.com/download...o.php?id=12403
Working example: http://dramaloot.com/forums/misc.php?do=wowcraft

[sweede]

Originally Posted by Jrain157

OK! Got it up and running by dropping the tables and it works fantastically. TYVM!!!

note: everything shows up as "Rare" quality

see the note in my changelog post.

[Jrain157]

Got it. Great idea on this module, we've been using a wiki based system for some time, but it lacked a good search functionality.

[Elbulus]

Great idea Getting some good feedback so far , can't wait to see what else you have planned !

[Jrain157]

Would it be possible to search by toon name, or even click the characters link on the right to view who has imported their data?

[sweede]

Originally Posted by Jrain157

Would it be possible to search by toon name, or even click the characters link on the right to view who has imported their data?

all in good time...

[y2krazy]

You do not have the correct WoW Addon available for download. The button does not show up in the tradeskill window. I posted here as well:

http://www.wowinterface.com/download...12403#comments

I take that back. It works, but it clashes with this WoW Addon:

http://wow.curse.com/downloads/wow-a...ll-window.aspx

If someone has this installed, they will NOT see your button. You have to disable it to see the button. You can then enabled ASTW after you export your tradeskill. Annoying, but not a big deal.

ALSO:

Removed the wowhead pretty item linking. On a page with 300 items, you'd have like, 1500 sql queries, which was a little excessive...

I assume this is referring to all the items being blue? How about you make them all the gold-ish color like when people link them in chat? Would make much more sense to do that that make them all seem as though they are all Rare level recipes.

~ Sean

[istvan]

Would it be possible to change rights somewhere from registered users to a group only for the guild?

[SlompOchomp]

Yup, a Usergroup rights is needed here.

[y2krazy]

Originally Posted by y2krazy

I assume this is referring to all the items being blue? How about you make them all the gold-ish color like when people link them in chat? Would make much more sense to do that that make them all seem as though they are all Rare level recipes.

I would still love to see this implemented, since having all of the recipes blue is a bit confusing. Just have them all the gold color that you see when you link them from your profession window. It makes MUCH more sense. <3

~ Sean

[sweede]

Originally Posted by y2krazy

I would still love to see this implemented, since having all of the recipes blue is a bit confusing. Just have them all the gold color that you see when you link them from your profession window. It makes MUCH more sense. <3

~ Sean

In the plugin titled, WoW Crafting Main plugin , for this product.

find

$crafting_link = "<a id='itemlink' class='q3' href='http://www.wowhead.com/?" . $type . "=" . $itemid . "'>[" . $row['craft_name'] . "]</a>" ;

Replace q3 with q6 for Gold.

    .q         { color: #ffd100 !important } /* Gold - ??? */
    .q0, .q0 a { color: #9d9d9d !important } /* Gray - Junk */
    .q1, .q1 a { color: ffffff !important } /* White - Common */
    .q2, .q2 a { color: #1eff00 !important } /* Green - Uncommon */
    .q3, .q3 a { color: #0070dd !important } /* Blue - Rare */
    .q4, .q4 a { color: #a335ee !important } /* Purple - Epic */
    .q5, .q5 a { color: #ff8000 !important } /* Orange - Legendary */
    .q6, .q6 a { color: #e5cc80 !important } /* Gold - Artifact ? */
    .q7, .q7 a { color: #ff0000 !important } /* Red - Artifact ? */
    .q8, .q8 a { color: #ffff98 !important } /* Yellow - ??? */