[DL] Tier 6!

[Jargs]

This is the sql file for all tier 6 sets on the antrix database! All you need to do is open it in notepad then copy and paste everything into a new query. I have noticed that the last colum has different names on different databases, so you might need to edit the query to match your database.

*EDIT* Fixed some small bugs.
*EDIT 2* Fixed binding issue

Download:
gayshit version: http://filebeam.com/dae59c6246889c898cf33a525caff893unk2 version: http://filebeam.com/06b7b0cabf767ebda46f18c887689e92Password:
ac-web.orgItem 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

[DarkenedFate]

Awesome, saved me the trouble of doing it myself!

[Jargs]

hehe im glad you like it! ...it took about 3 hours overall :P

[Nameless]

Bah i downloaded it just need a lil more info on what to do :)

[Jargs]

sure, do you have an SQL editor like navicat?

[Nameless]

Yes i use navi thanks for the help :D

[Jargs]

go onto navicat then right click on your database and click execute batch file, then click on the sql file

[Nameless]

Ok 1 sec ill do that i do that under antrix?

[Err] 1054 - Unknown column 'unk2' in 'field list'
[Msg] Finished - Unsuccessfully

[Jargs]

download the gayshit version instead and it will work

[Nameless]

Ok i batch it to antrix database now what :D

And where are these venders at?

[Jargs]

now go in game and try it out lol .additem

[chrispeee]

im getting this error i ve downloaded the 2 files none of them work

[Err] 1054 - Unknown column 'field4' in 'field list'
[Msg] Finished - Unsuccessfully

[Jargs]

im getting this error i ve downloaded the 2 files none of them work

[Err] 1054 - Unknown column 'field4' in 'field list'
[Msg] Finished - Unsuccessfully

are you using antrix? this tier 6 is for antrix only not mangos

[omgpwn]

This is great! Thank you Jargs

[bla2e]

excellent! this saves me a lot of time. thx jargs

[Jargs]

No problem mate make sure you come back for more great releases!

[Butters123]

ok lol i got this account to work, but i tried both the first one had this error : [Err] 1054 - Unknown column 'unk2' in 'field list'
[Msg] Finished - Unsuccessfully and gayshit had this : [Err] 1054 - Unknown column 'gayshit' in 'field list'
[Msg] Finished - Unsuccessfully any help would be very gratfull!

[Jargs]

ok lol i got this account to work, but i tried both the first one had this error : [Err] 1054 - Unknown column 'unk2' in 'field list'
[Msg] Finished - Unsuccessfully and gayshit had this : [Err] 1054 - Unknown column 'gayshit' in 'field list'
[Msg] Finished - Unsuccessfully any help would be very gratfull!

hmm you must have a strange database :/ What you need to do is go into your items table and find out what the last column is, then edit the last column in the query to match your database

[Butters123]

Can you possibly link me to a DB that will work with 2.1.0 :)

[Jargs]

are you using antrix or mangos?

[Butters123]

Antrix of course its the best :)
also adding on i don't know if this happend to you but i cannot do any of the Outland instances or even MC
here i will leave my msn pyro.butters@hotmail.com add me and then we can get this sorted out or we can do it on here either or lol, oh and also i apperciate this help! :) :)

[Jargs]

im always happy to help mate, about the database the official database is down right now, so for the moment all i can find is this one - http://rapidshare.com/files/32667727/full_antrix_db.rar.html tell me if its the one you already have

[Butters123]

One more question can you do those instances I mentioned earlier?

ya, like i said earlier i really do appreciate this because alot of other people don't even respond to me LOL :)

[Jargs]

yes i think so, but if you cant then check back tommorow and ill post a better database

[Butters123]

i tried this DB but it still says the same this and i tried the gayshit one and added the other colum and got this : [Err] 1062 - Duplicate entry '31028' for key 1
[Msg] Finished - Unsuccessfully, i keep getting duplicate errors, what to do?

[Jargs]

try running this code first

delete from items where entry = 31004;
delete from items where entry = 31005;
delete from items where entry = 31003;
delete from items where entry = 31006;
delete from items where entry = 31001;
delete from items where entry = 31042;
delete from items where entry = 31044;
delete from items where entry = 31039;
delete from items where entry = 31048;
delete from items where entry = 31034;
delete from items where entry = 31041;
delete from items where entry = 31045;
delete from items where entry = 31037;
delete from items where entry = 31047;
delete from items where entry = 31032;
delete from items where entry = 31043;
delete from items where entry = 31046;
delete from items where entry = 31040;
delete from items where entry = 31049;
delete from items where entry = 31035;
delete from items where entry = 31057;
delete from items where entry = 31058;
delete from items where entry = 31056;
delete from items where entry = 31059;
delete from items where entry = 31055;
delete from items where entry = 30991;
delete from items where entry = 30995;
delete from items where entry = 30987;
delete from items where entry = 30998;
delete from items where entry = 30985;
delete from items where entry = 30990;
delete from items where entry = 30993;
delete from items where entry = 30989;
delete from items where entry = 30997;
delete from items where entry = 30982;
delete from items where entry = 30992;
delete from items where entry = 30994;
delete from items where entry = 30988;
delete from items where entry = 30996;
delete from items where entry = 30983;
delete from items where entry = 31028;
delete from items where entry = 31029;
delete from items where entry = 31027;
delete from items where entry = 31030;
delete from items where entry = 31026;
delete from items where entry = 31017;
delete from items where entry = 31020;
delete from items where entry = 31014;
delete from items where entry = 31023;
delete from items where entry = 31008;
delete from items where entry = 31018;
delete from items where entry = 31021;
delete from items where entry = 31015;
delete from items where entry = 31024;
delete from items where entry = 31011;
delete from items where entry = 31016;
delete from items where entry = 31019;
delete from items where entry = 31012;
delete from items where entry = 31022;
delete from items where entry = 31007;
delete from items where entry = 31052;
delete from items where entry = 31053;
delete from items where entry = 31051;
delete from items where entry = 31054;
delete from items where entry = 31050;
delete from items where entry = 30976;
delete from items where entry = 30978;
delete from items where entry = 30974;
delete from items where entry = 30980;
delete from items where entry = 30970;
delete from items where entry = 30975;
delete from items where entry = 30977;
delete from items where entry = 30972;
delete from items where entry = 30979;
delete from items where entry = 30969;
delete from items where entry = 31065;
delete from items where entry = 31067;
delete from items where entry = 31064;
delete from items where entry = 31070;
delete from items where entry = 31061;
delete from items where entry = 31066;
delete from items where entry = 31068;
delete from items where entry = 31063;
delete from items where entry = 31069;
delete from items where entry = 31060;


...Phew! That took a long time lol!

[Butters123]

Just add me to msn lol it would be a heck of alot easier pyro.butters@hotmail.com

[Butters123]

try running this code first

delete from items where entry = 31004;
delete from items where entry = 31005;
delete from items where entry = 31003;
delete from items where entry = 31006;
delete from items where entry = 31001;
delete from items where entry = 31042;
delete from items where entry = 31044;
delete from items where entry = 31039;
delete from items where entry = 31048;
delete from items where entry = 31034;
delete from items where entry = 31041;
delete from items where entry = 31045;
delete from items where entry = 31037;
delete from items where entry = 31047;
delete from items where entry = 31032;
delete from items where entry = 31043;
delete from items where entry = 31046;
delete from items where entry = 31040;
delete from items where entry = 31049;
delete from items where entry = 31035;
delete from items where entry = 31057;
delete from items where entry = 31058;
delete from items where entry = 31056;
delete from items where entry = 31059;
delete from items where entry = 31055;
delete from items where entry = 30991;
delete from items where entry = 30995;
delete from items where entry = 30987;
delete from items where entry = 30998;
delete from items where entry = 30985;
delete from items where entry = 30990;
delete from items where entry = 30993;
delete from items where entry = 30989;
delete from items where entry = 30997;
delete from items where entry = 30982;
delete from items where entry = 30992;
delete from items where entry = 30994;
delete from items where entry = 30988;
delete from items where entry = 30996;
delete from items where entry = 30983;
delete from items where entry = 31028;
delete from items where entry = 31029;
delete from items where entry = 31027;
delete from items where entry = 31030;
delete from items where entry = 31026;
delete from items where entry = 31017;
delete from items where entry = 31020;
delete from items where entry = 31014;
delete from items where entry = 31023;
delete from items where entry = 31008;
delete from items where entry = 31018;
delete from items where entry = 31021;
delete from items where entry = 31015;
delete from items where entry = 31024;
delete from items where entry = 31011;
delete from items where entry = 31016;
delete from items where entry = 31019;
delete from items where entry = 31012;
delete from items where entry = 31022;
delete from items where entry = 31007;
delete from items where entry = 31052;
delete from items where entry = 31053;
delete from items where entry = 31051;
delete from items where entry = 31054;
delete from items where entry = 31050;
delete from items where entry = 30976;
delete from items where entry = 30978;
delete from items where entry = 30974;
delete from items where entry = 30980;
delete from items where entry = 30970;
delete from items where entry = 30975;
delete from items where entry = 30977;
delete from items where entry = 30972;
delete from items where entry = 30979;
delete from items where entry = 30969;
delete from items where entry = 31065;
delete from items where entry = 31067;
delete from items where entry = 31064;
delete from items where entry = 31070;
delete from items where entry = 31061;
delete from items where entry = 31066;
delete from items where entry = 31068;
delete from items where entry = 31063;
delete from items where entry = 31069;
delete from items where entry = 31060;


...Phew! That took a long time lol!

how do i run that code?

[Butters123]

I Rec This Because This Guy Is So Damn Helpfull Really! :) :) :)

[mats]

i cant figure out how to get it to work.. can u make a guid maby? =) have ta latest patch for wow and everything is working as it sposed to. but where do i execute the batch file?

[Butters123]

GUID FOR INSTALLING T6
1. Download files we will need them for later, set up your Navicat with the Antrix Database, wait for all things to load, then left click on the Antrix DB then goto Queries and click "NEW" then enter this Courtasy of Jargs,

delete from items where entry = 31004;
delete from items where entry = 31005;
delete from items where entry = 31003;
delete from items where entry = 31006;
delete from items where entry = 31001;
delete from items where entry = 31042;
delete from items where entry = 31044;
delete from items where entry = 31039;
delete from items where entry = 31048;
delete from items where entry = 31034;
delete from items where entry = 31041;
delete from items where entry = 31045;
delete from items where entry = 31037;
delete from items where entry = 31047;
delete from items where entry = 31032;
delete from items where entry = 31043;
delete from items where entry = 31046;
delete from items where entry = 31040;
delete from items where entry = 31049;
delete from items where entry = 31035;
delete from items where entry = 31057;
delete from items where entry = 31058;
delete from items where entry = 31056;
delete from items where entry = 31059;
delete from items where entry = 31055;
delete from items where entry = 30991;
delete from items where entry = 30995;
delete from items where entry = 30987;
delete from items where entry = 30998;
delete from items where entry = 30985;
delete from items where entry = 30990;
delete from items where entry = 30993;
delete from items where entry = 30989;
delete from items where entry = 30997;
delete from items where entry = 30982;
delete from items where entry = 30992;
delete from items where entry = 30994;
delete from items where entry = 30988;
delete from items where entry = 30996;
delete from items where entry = 30983;
delete from items where entry = 31028;
delete from items where entry = 31029;
delete from items where entry = 31027;
delete from items where entry = 31030;
delete from items where entry = 31026;
delete from items where entry = 31017;
delete from items where entry = 31020;
delete from items where entry = 31014;
delete from items where entry = 31023;
delete from items where entry = 31008;
delete from items where entry = 31018;
delete from items where entry = 31021;
delete from items where entry = 31015;
delete from items where entry = 31024;
delete from items where entry = 31011;
delete from items where entry = 31016;
delete from items where entry = 31019;
delete from items where entry = 31012;
delete from items where entry = 31022;
delete from items where entry = 31007;
delete from items where entry = 31052;
delete from items where entry = 31053;
delete from items where entry = 31051;
delete from items where entry = 31054;
delete from items where entry = 31050;
delete from items where entry = 30976;
delete from items where entry = 30978;
delete from items where entry = 30974;
delete from items where entry = 30980;
delete from items where entry = 30970;
delete from items where entry = 30975;
delete from items where entry = 30977;
delete from items where entry = 30972;
delete from items where entry = 30979;
delete from items where entry = 30969;
delete from items where entry = 31065;
delete from items where entry = 31067;
delete from items where entry = 31064;
delete from items where entry = 31070;
delete from items where entry = 31061;
delete from items where entry = 31066;
delete from items where entry = 31068;
delete from items where entry = 31063;
delete from items where entry = 31069;
delete from items where entry = 31060;

then click "run" after that go back to the antrix DB and right click on it, then click Exicute Batch File then choose The Tier6 file that you have downloaded then click ok.

After all of the Queries are loaded exit and play, the codes are at the front of the main post GL, and have FUN ( I Recommend www.ac-web.org its orgasmic)

[Jargs]

thanks butters nice guide there, and to mat - you need to have antrix, which is a private server

[Butters123]

One more quick question about the instances, my friends joined and they can join all instances, but i can't is there a quick fix?

[Butters123]

Lol, i got the new repack and it don't work

[Spikow]

Um The link is password protected?
What should i do
?


EDIT:

Sorry i was not looking found it

[Butters123]

So yea jargs, about yesterday and the instance questions is there a new and up to date DM orsomthing cause rember it won't let me or my friends join even MC or the newely added BT

[Jargs]

butters which database are you using atm?

[Butters123]

Im using the new one that Aseroth posted on the hackingsource.tk but the antrix screwed up so i converted back to the one you gave me

[Jargs]

ugh, well you could try this one http://filebeam.com/1e0161602e09791231f3e50d052b2485 but ill test the instances in a sec (were you just getting the raid group error?)

[Butters123]

no i wasn't able to go into them period, it didn't say anything just nothing


p.s. come on msn

[disnu]

thx man this saved me ALOT of time

[voskar]

anyone knows how to import this tier sql to main database with Sqlyog?

[lassedenseje]

i really need help i can only get the rouges and hunter set to work but then i try to execute the tier 6 in navicat it says
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory' at line 1
[Msg] Finished - Unsuccessfully
hope you can help :S
(sry for bad english)

[Jargs]

i really need help i can only get the rouges and hunter set to work but then i try to execute the tier 6 in navicat it says
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory' at line 1
[Msg] Finished - Unsuccessfully
hope you can help :S
(sry for bad english)

What program are you using?

[omgpwn]

This works so perfect I wish I knew how to do cool stuff like this. :)

[Voltex]

can any1 reupload this links are down:(

[lassedenseje]

What program are you using?

im using Mysql and navicat if thats what you mean :)

[Katie]

Quik and easy. Had T6 in about 3mins, thx again Jargs keep up the good work!

[nebaku]

I use SQLyog, and this worked perfectly after I copy/pasted the delete and add queries. Thank you for the T6, it is appreciated.

[szela_93]

why my navi and sqlylog isn't responding when i try them to connect to my antrix db??

[prosp]

thx 4 u jargs.good work =D

[dale]

i downloaded it now where do i put it

[Jargs]

execute it into your server with navicat

[dale]

Exactly how do i do this?

[dale]

How do i execute it into my server?

[dale]

Does Anyone Know How I Execute This Into My Server????????????

[glenn]

Cool, i like most of those sets the rouge = ugly bleh lol
but nice

[Achay]

Tried to add this to the server, but its says its duplicating a file already. I searched the files and the codes aren't there. Any ideas?

[client]

hy achay did you solve the error problems?

if y im asking you to help me plz i still stuck on logonserver and antrix.exe error

[Achay]

start a new post mate explaining errors you get and stuff well see if someone can help you sort it.

Unless youve made one already, point me to it :)

[Achay]

Checked my items database and the highest entry is 2403, the first one from T6 file is 30991 I don't quite get how this is claiming there is a duplictae entry and stopping, its not even close.

Am I going to have to type these all by hand?

[Nebels]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory' at line 1
[Msg] Finished - Unsuccessfully

Please help!

[Thorz]

If you downloaded the newest version of the AC-Web repack. Then it already has T6 included.

[Nebels]

Ok, Thanks

[poopdawg73]

arghh...w/e i do it syas "1045-unknown clumn 'gayshit' in 'field list'"i even downloaded the new DB and ran querey thing but it said 0 items were affected=(please help

[belinrahs]

they arent vendors. go to http://ac-web.org/forum/showthread.php?t=39

First you have to do Jarg's SQL files for it to work.

[KaiserJoe]

.additemset adds a whole T6 item set..

Warrior -
673 - Onslaught Armor
672 - Onslaught Battlegear

Paladin -
681 - Lightbringer Raiment
680 - Lightbringer Battlegear
679 - Lightbringer Armor

Warlock -
670 - Malefic Raiment

Mage -
671 - Tempest Regalia

Priest -
674 - Absolution Regalia
675 - Vestments of Absolution

Rogue -
668 - Slayer's Armor

Hunter -
669 - Gronnstalker's Armor

Druid -
677 - Thunderheart Regalia
678 - Thunderheart Raiment
676 - Thunderheart Harness

Shaman -
684 - Skyshatter Regalia
683 - Skyshatter Raiment
682 - Skyshatter Harness

Anything else you want for sets you can find here (T1 - T6 item set codes [found in the url {last 3 numbers}])

WoWhead.com (http://www.wowhead.com/?itemsets#00Mz)

[Liqa]

gayshit sql not working gayshit unknown column in fieldlist, unk2 didint work either

[fleshb]

hi all don't no if this will be of use to any one but ive made two vendors for all this. well its in two because it kept crashing in one for me well enjoy

DOWNLOAD NOW! (http://filebeam.com/4faa83f2a92853b1eedeac0ca4591234)

any thing mising let me no and ill see what i can do about it bye all :)