Missing loot, vendor, trainer, creature/gameobject queststarter/ender extracted from WoWHead

TrinityCore Development TrinityCore Code Discussion
1

Hello all, I used this tool WoWHead-PHP-Extractors to extract the missing_*_loot (creature loot, skinloot and pickpocketloot) and the missing vendors/trainers comparing the datas of the database TDB 6.x (from entry 43274, which is the highest entry in 335 db) with WoWHead.

Here I posted some files with the entries without some loot or that doesn’t teaches or sell anything while they should.

If you have some ideas to take advantage from this tool don’t hesitate to post your suggestions in this topic /emoticons/default_wink.png

[ATTACH]1297[/ATTACH]

[ATTACH]1298[/ATTACH]

[ATTACH]1299[/ATTACH]

[ATTACH]1300[/ATTACH]

[ATTACH]1301[/ATTACH]

[ATTACH]1468._xfImport[/ATTACH] => fixed

[ATTACH]1469._xfImport[/ATTACH] => fixed

2

Added list of missing creature and gameobject queststarter/ender

[ATTACH]1468[/ATTACH]

[ATTACH]1469[/ATTACH]

3

Sorry to necro this, however to take advantage of that data, I would suggest

https://dev.battle.net/

Use the JSON/XML api to extract the information about the items/npcs and whatever else is available. Then transform that data into INSERT statements for MySQL to add those items. Once completed, submit those sql patch files on GitHub to the TrinityCore 6.x project.

4

Good idea, sorry or the API are not reachable currently? http://us.battle.net/api/wow/item/12345

5

Hello
'm great interest WoWHead-PHP-Extractors

have windows machine and it will not work correct.
Please make a demo / free weibseite?

I need Loot / drop all WOD NPC and objects

or there is a wowhead-lood paser?

6

There isn’t a WoWHead-Loot-Parser (I would made it but WoWHead hasn’t ‘good’ data so I take care with low priority about this project).

For an online version, I will add it. Anyway this tool should work also on windows using the browser, but you should have AMP (XAMP or WAMP or easyPHP etc.) installed, if you have this try to modify this line:

https://github.com/Helias/WoWHead-PHP-Extractors/blob/master/all_loot_checker.php#L9

just adding LIMIT 10
so for example

$queryloots = mysql_query("SELECT entry, lootid, skinloot, pickpocketloot FROM creature_template WHERE entry > $start AND (lootid=0 OR skinloot=0 OR pickpocketloot=0) ORDER BY entry LIMIT 10");

P.S. = Of course you must configure this file before start the all_loot_checker.php
https://github.com/Helias/WoWHead-PHP-Extractors/blob/master/connect.php
and in $start you can put 0.

7

Anyway I already compared the WoD content of TDB 6.x with WoWHead and I extracted these files txt which contains all the ids with missing data in TDB 6.x, these files aren’t updated but probably the most content of these files are valid

8

Anyway I already compared the WoD content of TDB 6.x with WoWHead and I extracted these files txt which contains all the ids with missing data in TDB 6.x, these files aren’t updated but probably the most content of these files are valid

9

thank you for the answer
sorry, unfortunately I understand your system not know how to read the Loot for NPC there

unfortunately I am beginner

10

Sorry but I didn’t find a free web hosting service that allow to execute PHP file with maximum execution time more of 30 seconds of time. Anyway the project should run on Windows, as I told you if you install AMP (XAMPP, or WAMP or EasyPHP etc…) you could run the project without any troubles