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

Page 1 of 3

Show 40 post(s) from this thread on one page

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

All times are GMT. The time now is 10:32 AM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01023 seconds Memory Usage 1,739KB 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 (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: