T6 Loot Import

[Achay]

I have been trying unsuccessfully to import the T6 loot table into my current database.

Everytime I run the scrpt, its stops saying duplicate entries. I then tried running it on an empty database, exporting it and importing it. Again duplicate entries.

I have scanned the database and it does not contain the T6 entires.

Does anyone have any idea why its doing this and how I can fix it? I'm close to entering all the data by hand, but not looking forward to that.

[D0nD4K!NG]

The new version of AC-web Ultimate Repack rev 2. already has it implented :)

so go to http://www.ac-web.org/forum/showthread.php?t=26 and just find out =].

[Achay]

Yeah thats the one I'm trying to import, it just won't work. Has anyone had luck executing this on their database?

[D0nD4K!NG]

I ment. Find out the ID's.

You dont need to Import them. they already exist!

try to download the new version of the repack. and you will have them :)

Item ID's:

Rogue Set:
Shoulders - 31030
Legs - 31029
Chest - 31028
Helm - 31027
Gloves - 31026

Hunter Set:
Shoulders - 31006
Legs - 31005
Chest - 31004
Helm - 31003
Gloves - 31001

Warlock Set:
Shoulders - 31054
Legs - 31053
Chest - 31052
Helm - 31051
Gloves - 31050

Mage Set:
Shoulders - 31059
Legs - 31058
Chest - 31057
Helm - 31056
Gloves - 31055

Shadow Priest Set:
Shoulders - 31070
Legs - 31067
Chest - 31065
Head - 31064
Gloves - 31061

Holy Priest Set:
Shoulders - 31069
Legs - 31068
Chest - 31066
Head - 31063
Gloves - 31060

Protection Warrior Set:
Shoulders - 30980
Legs - 30978
Chest - 30976
Head - 30974
Gloves - 30970

Fury/Arms Warrior Set:
Shoulders - 30979
Legs - 30977
Chest - 30975
Head - 30972
Gloves - 30969

Feral Druid Set:
Shoulders - 31048
Legs - 31044
Chest - 30975
Head - 31039
Gloves - 31034

Balence Druid Set:
Shoulders - 31049
Legs - 31046
Chest - 31043
Head - 31040
Gloves - 31035

Restoration Druid Set:
Shoulders - 31047
Legs - 31045
Chest - 31041
Head - 31037
Gloves - 31032

Elemental Shaman Set:
Shoulders - 31023
Legs - 31020
Chest - 31017
Head - 31014
Gloves - 31008

Enhancement Shaman Set:
Shoulders - 31024
Legs - 31021
Chest - 31018
Head - 31015
Gloves - 31011

Restoration Shaman Set:
Shoulders - 31022
Legs - 31019
Chest - 31016
Head - 31012
Gloves - 31007

Holy Paladin Set:
Shoulders - 30996
Legs - 30994
Chest - 30992
Head - 30988
Gloves - 30983

Protection Paladin Set:
Shoulders - 30998
Legs - 30995
Chest - 30991
Head - 30987
Gloves - 30985

Retribution Paladin Set:
Shoulders - 30997
Legs - 30993
Chest - 30990
Head - 30989
Gloves - 30982

add the one's you want. and tell me if it isn't working with

.additem 30989

[Achay]

Eh, was hoping to not have to wipe the databse again, guess its the quickest option all things considered.

[D0nD4K!NG]

Why wipe it ?

[Achay]

Well if I reinstall the repack won't that do it?

[D0nD4K!NG]

Ofcourse :]

[Achay]

Well now I'm just confused. I downloaded and installed the new repack. Fired up the server and all the acocunts are still here. So I checked the MySQL database and nothing has changed.

I am looking in the right place, under items in the database aren't I?

[D0nD4K!NG]

Yes.

[Achay]

Well, then they still aren't there. Done a search and none of the codes listed above are in it. I can make them appear in my inv so they gota be somewhere I guess, just not in there.

Ill just have to have a massacre of all the T6 drop mobs see if it shows.

[EDIT]

Just like the NPC's I found the T6 loot, they were there all along no need to redo he system. Just have to start editing loot tables and stuff now, gonna take a while, lot of bosses and stuff to check.

[Sunrise]

bump

[spasm]

You just bumped a thread that was started in 2007. Damn post whore.