2.4 items

[asvati]

a little sql file i made out Kanqaz's Openascent Blizzlike DB of all the new items inn 2.4 which hasent been added to the repack yet,
so most of the credits go to him:)

might have missed a couple of items though, please tell if its any you cant find.

Download it here(rapidshare) (http://rapidshare.com/files/117445298/items_2.4.sql.html)
or here(filebeam(rar file)) (http://filebeam.com/eeb4f6117ecc304baa86993837eb5dd0)

[AterBux]

Hmm, this looks good - but when I try execute it, it says "SQL Error: Duplicate entry for '35042' for key 1." Unfortuantly, I'm a bit of a noob, and dunno how to fix this, hehe. Any suggestions?

[asvati]

it means you have used the specific id on another item. one way of handeling it is to search for that number in the sql file(35042) change it to something else, save, and then try to execute again:)

[AterBux]

hehe, I did that, but then it just say's it for the next one. :(

Maybe I should get the DB and stuff again and then retry?

+rep for file though. ;)

[asvati]

hmm, sure you havent dowloaded anything like this before?:P i atleast had no special trouble in executing it, but you could try that if you havent put to much work into your database.

btw, can you check the names of the items which ids is "allready taken"?

[AterBux]

I've tried a couple of 2.4 stuff, but none seem to work. Maybe it's me. hehe.

[AterBux]

Okay, got it all working!

Thanks alot for the help mate!

[asvati]

np, happy to help out:)

bump, need some feedback, this working good for everyone else?

[ragingstorm]

You said this was a SQl but i got a text document from your download link?!?!?

[asvati]

one of them is...
or here(filebeam(txt file))

try the first one of them, but i will change it to sql in rar, just got abit confused when i couldent upload the sql file there:P

ok, fixed

[yuzoki]

You said this was a SQl but i got a text document from your download link?!?!?

SQL is a text document... Don't bother flaming before you know what you are talking about.

[Symplexity]

The legendary bow doesnt work, always says out of range

[ragingstorm]

ty

Wtf i wasn't flamming -_- It was really a question u see the ?!?! at the end of my post. So think before u post and don't even try starting on me

[asvati]

The legendary bow doesnt work, always says out of range

Ye, think its an bug with the new spell it has, that it dont use any ammo, i'll have a look at it

[DarkUSA]

Umm just a heads up, but the sql is missing a couple of items like:

Golden Bow of Quel'Thalas
Thalassian Ranger Gauntlets (not on wowhead yet)
Tattered Cape of Antonidas
Cloak of Unforgivable Sin
Borderland Paingrips

All of these are off Kiljaden except the bow, and the fist weapon off Kiljaden is messed up, its marked as a staff.

Otherwise this is awesome, I have been wanting something like this for a while.

[asvati]

ok, ive found info for the bow but not the others atm, and what is the name of the fist weapon?
and thx for the heads up^^

INSERT INTO `items` VALUES ('34196', '2', '2', '-1', 'Golden Bow of Quel\'Thalas', '', '', '', '48294', '4', '0', '549255', '109851', '15', '-1', '-1', '154', '70', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '3', '18', '-1', '0', '-1', '0', '-1', '0', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '204', '380', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3000', '2', '100', '42095', '1', '0', '-1', '0', '-1', '15806', '1', '0', '-1', '0', '-1', '0', '0', '0', '-1', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '90', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300', '0');

[ermie03]

Can someone get me a tutorail how to inport it??

Thanks, Rick

[LS12]

Cool I will try it out but not right now I'm busy with Model Editing!

[Dark Realms]

I would just like to say thank you for sharing this. I have been waiting for someone to release/distribute the 2.4 items in ONE file. +rep for sharing!

Edit: One random problem.. I get a duplicate entry error when executing it into my database even though the so called "Duplicate item" doesnt appear to exist in my DB.. Very strange!

[left]

I would just like to say thank you for sharing this. I have been waiting for someone to release/distribute the 2.4 items in ONE file. +rep for sharing!

Edit: One random problem.. I get a duplicate entry error when executing it into my database even though the so called "Duplicate item" doesnt appear to exist in my DB.. Very strange!

I got this too, i found out that it was my S4 gear.
I had allready imported season 4 gear into my DB. now when i try to put this in some of the items give me the Dupe error, im just going to ignore it. lol

[crzyface]

ok i downloaded the sql file but when i try to add it in its telling i have dup of that item. so how would i go about finding if i've used the id# or the name in navicat 8

[Dark Realms]

I got this too, i found out that it was my S4 gear.
I had allready imported season 4 gear into my DB. now when i try to put this in some of the items give me the Dupe error, im just going to ignore it. lol

Sadly my problem is a little worse, my DB is brand new and doesnt have ANY 2.4 items added to it.

Even when i search my DB for the "Duplicate Item" I cant find it, one major annoying bug!

[ofomrm]

i was wondering.. does this include the cutscenes in the instance?

[cam1020]

i have the same problem as Dark Realms, i aint done anything to my database and yet it still comes up with duplicate entry '35042' for key 1, please help

[Coreyduffel]

this means that there is alrdy a id in the game for 35042! just replace 35042 in the script to something ealse like 9999999 on that will be your .add id or w/e
if that dosent work just get the items from somwhere easle or your gonna have to get a new database or somthing