PDA

View Full Version : [Arcemu Sql] Full, T8.5, Ulduar Gear(Normal And Heroic), Furious


kiwimonster
07-20-2009, 08:17 PM
Here, is an Sql with full T8.5, all the ulduar gear and full furious for all classes.
I Know there have been posts for T 8.5 and Furious, But heres an all-in-one of it all + ulduar gear
This, is a full Item Table, With the Gear added, just so you know

CREDITS TO ME FOR ADDING IT ALL TO MY DATABASE
AND UPLOADING IT HERE

All, 3.1.3 Items (http://www.megaupload.com/?d=9E9P3MHA)

All, You have to do is Drop the items table, Remake it and then import this file,
Just to be save i would back up your items into a .sql, Just incase it doesnt work because, i've only tried it on my computer and it works, and i dont want to screw up your server if you imported a crap load of items and they are gone because my .sql didnt work...:)

PS: They are all Blizzlike!!

erezer
07-20-2009, 08:46 PM
can you tell me wear to drop it?

kiwimonster
07-20-2009, 09:17 PM
Do you mean droping the items table, because it would be in your database, And you right click the table and click delete And you would edit your database with something like Navicat, or HeidiSQL

Mari0
07-20-2009, 09:19 PM
Nice.. Nice!!

kiwimonster
07-20-2009, 09:32 PM
Thanks Calikid:)

carlwowwow
07-21-2009, 09:14 PM
Nice Man!

Try

kiwimonster
07-21-2009, 10:13 PM
Your Welcome Carl, Hope it works for you

skatinfool
07-22-2009, 03:08 AM
Would dropping the table delete all the items in the database?

carlwowwow
07-22-2009, 07:14 PM
Please Please Kiwimonster have you all the ulduar spawns if you have so please give my a download link :D

kiwimonster
07-22-2009, 07:33 PM
Would dropping the table delete all the items in the database?


Yes, But like i said i backup your old items table incase it doesnt work out,


And Carl, I sorry i dont have ulduar Spawned

st23
07-23-2009, 03:25 AM
Nice.

mat656
07-23-2009, 11:36 PM
could u upload to another host i carnt seem to get download to complete :(

mmhelm
07-24-2009, 08:46 PM
you can edit out the drop tables part in this and just merge it with your items if you have lots of custom stuff you don't want deleted. >.>

dudedood
07-24-2009, 11:05 PM
Most people won't know how to do that... :P

post a quick tut?

proarcher1990
07-27-2009, 08:28 PM
i have a problem... the sql works but the t8 and t8,5 items do not have any skins...where I can find them?

Chris

Elfandor
07-28-2009, 07:36 AM
Ty

avngd7fld96
07-29-2009, 04:23 AM
Hard Mode items aren't there, is that a mistake or unspawned?

kiwimonster
07-30-2009, 04:03 PM
Well Avngd, i got all my items for wowhead, and i went through all the like 300 something items on wowhead of normal and heroic, so if they werent there, i guess wowhead doesn't have them or i missed a category

bloodybat
08-02-2009, 03:42 AM
how long is this supposed to take when loading the file?

Paradox
08-12-2009, 07:45 AM
+Rep.

Exile666
08-12-2009, 10:05 PM
Thank you very much. +Rep. I Hope this'll work on my server.

Doom264
08-19-2009, 04:34 AM
could you post a sql with just theses in it to add? please?

tegno
08-21-2009, 10:38 PM
Thanks for your work

Doom264
08-21-2009, 10:48 PM
too bad it errs and says 1136 - Column count doesn't match value count at row 1

can you please fix this?

darthmaul
08-29-2009, 11:56 AM
izzit work for rev2851?

rev2840 above..the collumn have change i think.when i try to execute,i got error with wrong cullomn..

ZOLAR
08-29-2009, 02:23 PM
same for 2835

mmhelm
08-30-2009, 09:34 PM
You guys really cant figure out how to edit sqls?

ugh. MEN RIL PRO.

may have to add zeros to eet depending on how your tables look, count how many colums your mysql item table has and add them into the sql.


Filebeam - Beam up that File Scottie! (http://filebeam.com/b371465849307c815a2b6ff5a911f588)

Punctur3
09-06-2009, 12:33 AM
Yeah, what id like to know whats the collum difference between aspire and arc < 2830

Brianplast
09-06-2009, 11:01 AM
yea it works^^

beileroord
09-18-2009, 11:13 AM
Just get the itemgrabber by rofni and get them yourself without errors xD

ZeroEXE
10-12-2009, 08:44 PM
You guys really cant figure out how to edit sqls?

ugh. MEN RIL PRO.

may have to add zeros to eet depending on how your tables look, count how many colums your mysql item table has and add them into the sql.


Filebeam - Beam up that File Scottie! (http://filebeam.com/b371465849307c815a2b6ff5a911f588)



So I just execute this with Navicat correct? I'm new to all this so I'm trying really had to learn. Anyway, back on topic, will this delete all my other items i have? I mean I read where you said something about backing up the items but yea. Its all kinda confusing atm. :-/

exciter
10-12-2009, 08:50 PM
hello plz ALLitem 8.5 & itemsulduar .sql