[mmodb]

Update 9/16/08: Updated to 0.6 updating Warhammer Online itemstats to display properly.
Update 9/6/08: Updated to 0.5 adding Warhammer Online icon and fixed AoC item stats.
Update 8/25/08: Updated to 0.4 adding Warhammer Online support (icons and other languages to follow).

This is the official thread for the MMO DB ItemStats MOD. Basically what we've done is modified the ItemStats 1.5 Core to support multiple games on MMO DB (http://www.mmodb.com/) and to allow anyone with some programming knowledge to easily build a parser for just any game and plug it into our mod and use it right away. Previously you had to modify an existing parser file to support a new site or game, now all you need to do is create the parser and edit the configuration file.

INSTALLATION INSTRUCTIONS:
-----------------------------------------------
1.) Backup your existing ItemStats installation if you have one.
2.) Download and extract the MMODB-ItemStats zip file below.
3.) Follow the installation instructions for the specific script you are going to use ItemStats with: http://itemstats.fre...t.php?content.6
4.) There is no need to download the ItemStats Core files as they are already included in the zip file below.
5.) Modify the config.php file and make sure your database settings are correct.
6.) Modify the config_itemstats.php file and modify the default game setting found below:

$GLOBALS['game'] = 'lotro';

(Possible games code are aoc, eq2, hg, lotro, potbs, vg, war, wow) You can create your own game codes by adding or editing the parser file settings like the one below:

$GLOBALS['eq2']["prio"][] = array('name' => 'MMODB_EQ2', 'lang' => 'en');

Where 'eq2' is the game code.

7.) You can now use ItemStats like normal for the game you specified. Try loading the itemstats-test.php for some samples on the various MMO DB games supported.

See it in action here: http://www.mmodb.com...mstats-test.php

Download the Latest Version here: http://www.mmodb.com/itemstats.php

Attached File(s)

•  mmodb_itemstats.jpg (12.17K)
  Number of downloads: 60

[mmodb]

For those who want to create a parser script for another game and/or another website to parse from here are the simple instructions.

1.) Create your parser file in the /includes/ directory, make sure its name is in lower case (eg: mmodb.php, allakhazam.php)
2.) Make sure the name of your class for the parser is the same as the filename with the prefix 'Parse', it doesn't have to be lower case, it just needs to be the same.
(eg: mmodb.php => class ParseMMODB)
3.) Modify the config_itemstats.php file and add a line for your parser like so:

$GLOBALS['wow']["prio"][] = array('name' => 'MMODB', 'lang' => 'en');

Where 'wow' is the game code that the parser is for. 'MMODB' is the name of the class of your parser without the prefix 'Parse'.

That's it, now when you use the MMO DB ItemStats mod for that game, it will try to search and parse the site you made the parser for. You make as many parsers for as many games and websites as you want. You can use the mmodb.php or allakhazam.php files as a template.

[torval]

I am currently using this now. You can view my site at http://www.deephallo....com/brewbucks/

Looks good so far <crosses fingers>

[mmodb]

Awesome Looking great, let me know if you run into any bugs. We tried to modify the ItemStats script as much as possible to allow it to extend to any game.

[torval]

mmodb, on Feb 6 2008, 03:08 AM, said:

Awesome Looking great, let me know if you run into any bugs. We tried to modify the ItemStats script as much as possible to allow it to extend to any game.

The only problem I have so far using this mod is listing items via the admin panel to update spelling etc I always get failed to update item cache duplicate entry key etc. I am unsure how to correct that and leave the auto update feature enabled. Disabling this feature via config_itemstats.php alleviates the issue and you can update items or add them as you see fit no problems. Using itemspecials plugin you will get the same problem when updating it through that interface as well and I assume is a problem with my sql host perhaps looking at it as a form of dos attack. Overall I haven't encountered any problems besides misspelled item names on my end or mmodb's .

[torval]

I neglected to mention that you can use the lotro parser for allakhazam provided in the orignal thread by Sokol? The cool thing with MMODB's version is I can setup a secondary DB for allakhazam and set for simplicities sake it as vanguard or just wow originally and get the functionality of both sites for lotro where I want them in eqdkp and on the site in general. It's quite nifty being able to inject a couple lines telling it to switch parsers in the same page even and have it pull from allakhazam for one part and mmodb on the next. MMODB has by far more data on items than allakhazam it's a david and goliath scenario with allakhazam only providing icons for some things.

Thanks again!

[mmodb]

can you post the structure of your item_cache table, and the index, it seems the item_name index is still a unique.
we do have icons for lotro but few since its all manual and there are so many.

[torval]

tem_cache
Field 	Type 	Null 	Default
item_name 	varchar(100) 	No			 
item_id 	varchar(100) 	Yes	  0	   
item_lang 	varchar(2) 	Yes			 
item_link 	varchar(100) 	Yes	  NULL	   
item_color 	varchar(64) 	No			 
item_icon 	varchar(50) 	No			 
item_html 	text 	No			 
item_game 	varchar(10) 	No			 


Indexes:
Keyname 	Type 	Cardinality 	Field
item_name 	UNIQUE 	112	  item_name
item_html 	FULLTEXT 	None	  item_html


Space usage:
Type 	Usage
Data 	190,272 	B
Index 	113,664 	B
Total 	303,936 	B
		  Row Statistics:
Statements 	Value
Format 	dynamic
Rows 	112
Row length ø 	1,698
Row size  ø 	2,714 B
Creation 	Feb 06, 2008 at 03:05 AM
Last update 	Feb 06, 2008 at 04:35 AM

I get the same error with both Alla and MMODB. I realize the trouble icons are and have all of allakhazams hosted on my site. Saves them bandwidth I wager and gives me faster page refreshes. So what youa re saying is that if I just edit the item_name index to fulltext or the like it will correct the issue?

[mmodb]

edit the item_name index to just an index and not a unique index, nto fulltext
redownload the archive, i modified some files

[torval]

K done. Did you want icons at all for lotro? I have close to 8,000 of em zipped up.

[mmodb]

no we have them actually, its just that theres no easy way to link them to each item easily like there is in WoW

[torval]

mmodb, on Feb 7 2008, 03:45 AM, said:

no we have them actually, its just that theres no easy way to link them to each item easily like there is in WoW

I hear ya almost makes me wish I still played WoW since I would have an easier time running a guild and having useful and nice addons for the website. Shame it went to hell .

[mmodb]

maybe we can get this stickied by a mod?

[torval]

Please sticky this as it's the best lotro mod out there in general and eqdkp.

[torval]

I seem to have issues with Allakhazam tooltips for lotro. Tooltips come out transparent and was under the impression that these settings are CSS based. Modifying the CSS in itemstats.css doesn't change the tooltip at all for me. What I am doing is setting in config_itemstats.php lotro as the game name for allakhazam and making lotro_mmodb as vg so it wouldn't touch it. The settings for the tooltip are in the itemstats.css correct?

EDIT: Yea MMODB comes out fine for any game but any other parser has tooltip issues.