vb.org Archive - Miscellaneous Hacks - World of Warcraft Crafting Database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Miscellaneous Hacks - World of Warcraft Crafting Database (https://vborg.vbsupport.ru/showthread.php?t=203902)

sweede

02-01-2009 10:00 PM

World of Warcraft Crafting Database

1 Attachment(s)

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

02-02-2009 06:07 AM

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

02-02-2009 11:28 AM

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

02-02-2009 12:57 PM

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

02-02-2009 02:11 PM

I get this error when trying to import the product.

Code:

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

02-02-2009 02:21 PM

hmm.. thought i fixed that.

Try it now (be sure to hit upgrade)

Jrain157

02-02-2009 02:59 PM

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

Code:

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

02-02-2009 04:01 PM

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

02-02-2009 04:12 PM

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

02-02-2009 04:47 PM

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

note: everything shows up as "Rare" quality

sweede

02-02-2009 04:59 PM

Quote:

Originally Posted by Jrain157 (Post 1732094)

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

02-02-2009 05:34 PM

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

02-02-2009 07:03 PM

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

Jrain157

02-03-2009 11:51 AM

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

02-03-2009 08:31 PM

Quote:

Originally Posted by Jrain157 (Post 1732983)

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

02-19-2009 12:55 AM

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:

Quote:

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

02-19-2009 04:14 PM

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

SlompOchomp

03-17-2009 11:11 PM

Yup, a Usergroup rights is needed here.

y2krazy

03-18-2009 12:52 PM

Quote:

Originally Posted by y2krazy (Post 1748623)

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

03-18-2009 03:54 PM

Quote:

Originally Posted by y2krazy (Post 1771086)

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

find

Code:

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

Replace q3 with q6 for Gold.

Code:

    .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

03-18-2009 05:35 PM

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

03-18-2009 05:43 PM

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

03-18-2009 06:07 PM

Quote:

Originally Posted by sweede (Post 1771227)

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

03-18-2009 07:38 PM

Quote:

Originally Posted by sweede (Post 1771293)

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

06-02-2009 01:51 PM

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

08-24-2009 03:41 AM

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

02-23-2010 09:41 AM

excellent work as always sweede :)

All times are GMT. The time now is 04:54 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01233 seconds Memory Usage 1,801KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (27)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: