Complete ArcEmu Items Table + Installer

[Valmere]

This is an old topic and is no longer supported. I'm not currently in the emulation scene at atm don't plan on picking it back up.

New Version Released: 1.1

Short and to the point: after downloading the latest revisions for both Light's Hope DB and WhyDB, I found that neither one had a complete items table for the current version of WoW. (Heroic items missing, some items had wrong stats, etc)

So I present to you a fresh Allakhazam item rip and a nifty little .bat to make the installation go fast and smooth.

Download here:
//-- DOWNLOAD NOW! --\\

After you put your mysql info in and it starts importing, it may take a minute or two because the .sql file that its importing is 25MB. It will tell you once its done.


New in version 1.1:
Couple of misc. fixes have been added, just re-download and run the installer again.


:: Any fixes / patches will be posted below here ::

[Kirsebaer]

Thanks!
Had the same experience yesterday.

**Confirmed working ^^

[Byrddawg]

re-upload.. the file is corrupted so it doesn't give anyone anything that is needed.. +REP if you do

[Kirsebaer]

The file is not corrupted.
At least not for me.
I uploaded my download

DOWNLOAD

[92eatos]

I appreciate your work and thx for testing my db..I would be glad if you make list or say what items i am missing i will try to update db.But yes these days i am working only on vehicle system so i dont have time to finish item table.

[Valmere]

**Confirmed working ^^

Thanks for the confirmation

edit: lol just saw GZ edited my post, I must have F'd up the link. Sorry guys and ty GZ

[lol97899]

Will be useful,+Rep

[Kirsebaer]

Could you fix the itemsets too?

[92eatos]

I have fixed that and will fix it soon all classes

[Valmere]

Could you fix the itemsets too?

What item sets aren't currently working? I wasn't able to find any.

[rawr66]

Nice, Thanks +rep

[Valmere]

Could you fix the itemsets too?

I looked into some of the itemset issues I believe you were talking about and from what I saw its an error in the .dbc files. This isn't a huge issue though due to the fact that the item set bonuses are still being applied correctly. I'm trying to find anything DB-related to fix though, and the only thing I've come across so far is some text missing from the Mimiron's Head item. To fix that, just execute this SQL query:

UPDATE `items` SET `description`='Teaches you how to summon this construction.  Can only be summoned in Outland or Northrend.  This is a very fast... head.' WHERE (`entry`='45693');

I appreciate your work and thx for testing my db..I would be glad if you make list or say what items i am missing i will try to update db.But yes these days i am working only on vehicle system so i dont have time to finish item table.

Ah, lets see.... I believe it was mostly iCC items, some normal and most of the heroic versions. You use / copy this item table if you'd like

[FrostyC]

This is awesome, but I didn't want Martin's Broken Staff & I wanted to keep Martin Thunder,
so I ran this SQL after using your update.
gj tho, I was too lazy to do this.

[Kirsebaer]

I meant like ".character additemset 253" as an example :P
Oh, by the way. While Mimiron's Head is inside the bag, it says Usenull)

[Valmere]

/bamp

Version 1.1 released! A few things were addressed, such as the mimiron's head (like it wasn't easy for a user to fix...) and enchanting rods.

Enjoy, and as always feedback is appreciated!