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]

• 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