World of Warcraft Crafting Database

[sweede]

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/downloads/fileinfo.php?id=12403
Working example: http://dramaloot.com/forums/misc.php?do=wowcraft

[sweede]

0.1.5

Added description to the crafting table. This allows searching enchants via what they do (i.e. you can search for threat and it will bring up enchant gloves - armsman). Updated wow addon to store descriptions.
0.1.4b
Removed the wowhead pretty item linking. On a page with 300 items, you'd have like, 1500 sql queries, which was a little excessive...


0.1.4

Fixed the installer routines so that they are hiding errors, which was preventing proper installation.
Changed "Stat" listings to provide more usefull information including a link that will list all known recipes in that profession.
When viewing a list of all recipes in a profession, there will be a link on the side to search for users w/ that recipe.
Removed the following files


jquery.autocomplete.min.js
jquery.autocomplete.pack.js
lib/jquery.ajaxQueue.js
lib/jquery.bgiframe.min.js
lib/thickbox-compressed.js
lib/thickbox.css



0.1.3

Added Autocomplete search (disabled by default, in vboptions)
Added some more stat display data (last 5 players that have imported their data, etc)

[NeroObsedian]

Not too bad. At first I had an issue with it not pulling anything up for a search, had to search something low level and rather generic for it to return any results. Only recommendations I have would be one, come up with a way to show known recipes for characters and two, set the search so that if nothing is entered it pulls all entries up. I know the list can get long really quick, but tabs expand. :-)

I'll throw this on my board a little later and play with it myself, great job so far!

[sweede]

Showing members professions is on the todo list, my first priority was to get the database setup in an efficent manner and a way to import all of the data i needed (itemID, ItemName, Character information) easily. The addon took a while, since i had to learn the new method (introduced at BC release...) of creating frames.

What i'm worried about is what happens if someone allows the server to use this, and they have a database of 10,000+ characters (x2 for professions), and how that data is displayed. Do i really want to list even 20 character names that know something trivial like Glyph of Shred?

[Jrain157]

I get this error when trying to import the product.


Invalid SQL:
ALTER TABLE vb3_wowcraft_recipe` DROP `member_id`;;


Very excited about this mod, but will need to wait for a release. Great idea :)

[sweede]

hmm.. thought i fixed that.

Try it now (be sure to hit upgrade)

[Jrain157]

Now getting this error. I re-uploaded the files, and imported the product allowing overwrite.


Database error in vBulletin 3.8.0:

Invalid SQL:
CREATE TABLE vb3_wowcraft_members (
member_id int(11) unsigned NOT NULL auto_increment,
userid int(11) NOT NULL,
character_name varchar(45) NOT NULL,
prof_first varchar(20) NOT NULL,
prof_sec varchar(20) default NULL,
faction varchar(45) NOT NULL,
PRIMARY KEY (member_id)
);

MySQL Error : Table 'vb3_wowcraft_members' already exists
Error Number : 1050

[Jrain157]

Tried the 1.4 version as well, still getting the same errors as the previous post. Also - any plans to create a vbadvanced module?

[sweede]

Because the php error and the installation was interupted, you may have to go through and manually remove those tables.

Maintenance -> Execute SQL Query ->
DROP TABLE vb3_wowcraft_members
etc.

[Jrain157]

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

note: everything shows up as "Rare" quality

[sweede]

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]

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/downloads/fileinfo.php?id=12403#comments

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

http://wow.curse.com/downloads/wow-addons/details/advanced-trade-skill-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]

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]

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 - ??? */

[SlompOchomp]

Can you make an option to remove the "Craft Database" link from the navbar so that passing forum readers do not see the page for now ?
Please :)

Thanks in advanced!

[sweede]

until i get time to update this with some new things, you can disable the plugin named "WoW Profession Nav Link"

it's what adds the navbar link
"/misc.php?do=wowcraft"

[y2krazy]

Replace q3 with q6 for Gold.
"q" (#ffd100) was actually the color I was looking for. Changed and looking snazzy now. Thanks!! :)

Forgive me for not checking, but was this change made due to the amount of queries to be made per page if leaving the colors as viewed in game for each item? ie - having 40 purples (epic), 25 whites (common), 75 blues (rare), etc.?

I can see how it would impact performance, even though the colors would be much more accurate. Not a big deal to me, I was just curious. :)

~ Sean

[SlompOchomp]

until i get time to update this with some new things, you can disable the plugin named "WoW Profession Nav Link"

it's what adds the navbar link
"/misc.php?do=wowcraft"
Wonderfull, thanks...sorry to have bug you about it...I should have looked at that.:o

[SlompOchomp]

I have noticed Inscription has stooped at 379 even though I have learned new recipes and uploaded the data it seems to have stopped adding any new ones...no errors and no new Updates,Addons or changes to site...is their a limit to it ? I would think there is no limit because one member has 385 Blacksmithing recipes. Any ideas as to why it's not accepting any new data?

[ruger]

Any further problems? I used this and it worked fine but then tonight I got the last 4 listed under mining as M, i, A, S and link to an error page on wowhead.

[mikey1974]

excellent work as always sweede :)