/sql/old/ancient/3.3.5a/TDB49_to_TDB50_updates/world/2012_09_19_00_world_reference_loot_template.sql
SQL | 449 lines | 428 code | 0 blank | 21 comment | 0 complexity | 813734291aaad5b1f89d6936899f2b48 MD5 | raw file
1-- Changes To VOA Loot 2-- Update gold drops for bosses 3-- Archavon 10 & 25 4UPDATE `creature_template` SET `mingold`=1700000,`maxgold`=1800000 WHERE `entry` IN (31125,31722); 5-- Emalon & koralon 10 & 25 6UPDATE `creature_template` SET `mingold`=1800000,`maxgold`=1900000 WHERE `entry` IN (33993,33994,35013,35360); 7-- Toravon 10 & 25 8UPDATE `creature_template` SET `mingold`=1900000,`maxgold`=2000000 WHERE `entry` IN (38433,38462); 9-- Combine PVP and PVE ref templates so loot has chance to be all pvp or all pve not one of each 10-- Revome deadly items other than chest lega and hands from Archavon 25 loot 11-- Toravon 25 drops 3 items 12SET @ARCHAVON10 = 34209; 13SET @ARCHAVON25 = 34216; 14SET @EMALON10 = 34208; 15SET @EMALON25 = 34215; 16SET @TORAVON10 = 34206; 17SET @TORAVON25 = 34207; 18SET @KORALON10 = 34204; 19SET @KORALON25 = 34205; 20-- Create Reference loot template for @ARCHAVON25 T7(25) & Deadly Chest,Legs,Hands 21DELETE FROM `reference_loot_template` WHERE `entry` IN (@ARCHAVON25,@KORALON25,@EMALON25); 22INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 23(@ARCHAVON25,40550,0,1,1,1,1), -- Valorous Scourgeborne Battleplate 24(@ARCHAVON25,40552,0,1,1,1,1), -- Valorous Scourgeborne Gauntlets 25(@ARCHAVON25,40556,0,1,1,1,1), -- Valorous Scourgeborne Legplates 26(@ARCHAVON25,40559,0,1,1,1,1), -- Valorous Scourgeborne Chestguard 27(@ARCHAVON25,40563,0,1,1,1,1), -- Valorous Scourgeborne Handguards 28(@ARCHAVON25,40567,0,1,1,1,1), -- Valorous Scourgeborne Legguards 29(@ARCHAVON25,40463,0,1,1,1,1), -- Valorous Dreamwalker Robe 30(@ARCHAVON25,40460,0,1,1,1,1), -- Valorous Dreamwalker Handguards 31(@ARCHAVON25,40462,0,1,1,1,1), -- Valorous Dreamwalker Leggings 32(@ARCHAVON25,40503,0,1,1,1,1), -- Valorous Cryptstalker Tunic 33(@ARCHAVON25,40504,0,1,1,1,1), -- Valorous Cryptstalker Handguards 34(@ARCHAVON25,40506,0,1,1,1,1), -- Valorous Cryptstalker Legguards 35(@ARCHAVON25,40418,0,1,1,1,1), -- Valorous Frostfire Robe 36(@ARCHAVON25,40415,0,1,1,1,1), -- Valorous Frostfire Gloves 37(@ARCHAVON25,40417,0,1,1,1,1), -- Valorous Frostfire Leggings 38(@ARCHAVON25,40569,0,1,1,1,1), -- Valorous Redemption Tunic 39(@ARCHAVON25,40570,0,1,1,1,1), -- Valorous Redemption Gloves 40(@ARCHAVON25,40572,0,1,1,1,1), -- Valorous Redemption Greaves 41(@ARCHAVON25,40579,0,1,1,1,1), -- Valorous Redemption Breastplate 42(@ARCHAVON25,40580,0,1,1,1,1), -- Valorous Redemption Handguards 43(@ARCHAVON25,40583,0,1,1,1,1), -- Valorous Redemption Legguards 44(@ARCHAVON25,40574,0,1,1,1,1), -- Valorous Redemption Chestpiece 45(@ARCHAVON25,40575,0,1,1,1,1), -- Valorous Redemption Gauntlets 46(@ARCHAVON25,40577,0,1,1,1,1), -- Valorous Redemption Legplates 47(@ARCHAVON25,40449,0,1,1,1,1), -- Valorous Robe of Faith 48(@ARCHAVON25,40445,0,1,1,1,1), -- Valorous Gloves of Faith 49(@ARCHAVON25,40448,0,1,1,1,1), -- Valorous Leggings of Faith 50(@ARCHAVON25,40458,0,1,1,1,1), -- Valorous Raiments of Faith 51(@ARCHAVON25,40454,0,1,1,1,1), -- Valorous Handwraps of Faith 52(@ARCHAVON25,40457,0,1,1,1,1), -- Valorous Pants of Faith 53(@ARCHAVON25,40495,0,1,1,1,1), -- Valorous Bonescythe Breastplate 54(@ARCHAVON25,40496,0,1,1,1,1), -- Valorous Bonescythe Gauntlets 55(@ARCHAVON25,40500,0,1,1,1,1), -- Valorous Bonescythe Legplates 56(@ARCHAVON25,40514,0,1,1,1,1), -- Valorous Earthshatter Hauberk 57(@ARCHAVON25,40515,0,1,1,1,1), -- Valorous Earthshatter Gloves 58(@ARCHAVON25,40517,0,1,1,1,1), -- Valorous Earthshatter Kilt 59(@ARCHAVON25,40523,0,1,1,1,1), -- Valorous Earthshatter Chestguard 60(@ARCHAVON25,40520,0,1,1,1,1), -- Valorous Earthshatter Grips 61(@ARCHAVON25,40522,0,1,1,1,1), -- Valorous Earthshatter War-Kilt 62(@ARCHAVON25,40508,0,1,1,1,1), -- Valorous Earthshatter Tunic 63(@ARCHAVON25,40509,0,1,1,1,1), -- Valorous Earthshatter Handguards 64(@ARCHAVON25,40512,0,1,1,1,1), -- Valorous Earthshatter Legguards 65(@ARCHAVON25,40423,0,1,1,1,1), -- Valorous Plagueheart Robe 66(@ARCHAVON25,40420,0,1,1,1,1), -- Valorous Plagueheart Gloves 67(@ARCHAVON25,40422,0,1,1,1,1), -- Valorous Plagueheart Leggings 68(@ARCHAVON25,40525,0,1,1,1,1), -- Valorous Dreadnaught Battleplate 69(@ARCHAVON25,40527,0,1,1,1,1), -- Valorous Dreadnaught Gauntlets 70(@ARCHAVON25,40529,0,1,1,1,1), -- Valorous Dreadnaught Legplates 71(@ARCHAVON25,40544,0,1,1,1,1), -- Valorous Dreadnaught Breastplate 72(@ARCHAVON25,40545,0,1,1,1,1), -- Valorous Dreadnaught Handguards 73(@ARCHAVON25,40547,0,1,1,1,1), -- Valorous Dreadnaught Legguards 74(@ARCHAVON25,40469,0,1,1,1,1), -- Valorous Dreamwalker Vestments 75(@ARCHAVON25,40466,0,1,1,1,1), -- Valorous Dreamwalker Gloves 76(@ARCHAVON25,40468,0,1,1,1,1), -- Valorous Dreamwalker Trousers 77(@ARCHAVON25,40471,0,1,1,1,1), -- Valorous Dreamwalker Raiments 78(@ARCHAVON25,40472,0,1,1,1,1), -- Valorous Dreamwalker Handgrips 79(@ARCHAVON25,40493,0,1,1,1,1), -- Valorous Dreamwalker Legguards 80(@ARCHAVON25,40786,0,1,1,1,1), -- Deadly Gladiator's Plate Chestpiece 81(@ARCHAVON25,41951,0,1,1,1,1), -- Deadly Gladiator's Silk Raiment 82(@ARCHAVON25,41997,0,1,1,1,1), -- Deadly Gladiator's Felweave Raiment 83(@ARCHAVON25,41649,0,1,1,1,1), -- Deadly Gladiator's Leather Tunic 84(@ARCHAVON25,40784,0,1,1,1,1), -- Deadly Gladiator's Dreadplate Chestpiece 85(@ARCHAVON25,41086,0,1,1,1,1), -- Deadly Gladiator's Chain Armor 86(@ARCHAVON25,41920,0,1,1,1,1), -- Deadly Gladiator's Satin Robe 87(@ARCHAVON25,40785,0,1,1,1,1), -- Deadly Gladiator's Scaled Chestpiece 88(@ARCHAVON25,41660,0,1,1,1,1), -- Deadly Gladiator's Dragonhide Robes 89(@ARCHAVON25,41858,0,1,1,1,1), -- Deadly Gladiator's Mooncloth Robe 90(@ARCHAVON25,40905,0,1,1,1,1), -- Deadly Gladiator's Ornamented Chestguard 91(@ARCHAVON25,40990,0,1,1,1,1), -- Deadly Gladiator's Ringmail Armor 92(@ARCHAVON25,41315,0,1,1,1,1), -- Deadly Gladiator's Wyrmhide Robes 93(@ARCHAVON25,41309,0,1,1,1,1), -- Deadly Gladiator's Kodohide Robes 94(@ARCHAVON25,41080,0,1,1,1,1), -- Deadly Gladiator's Linked Armor 95(@ARCHAVON25,40991,0,1,1,1,1), -- Deadly Gladiator's Mail Armor 96(@ARCHAVON25,40926,0,1,1,1,1), -- Deadly Gladiator's Ornamented Gloves 97(@ARCHAVON25,40938,0,1,1,1,1), -- Deadly Gladiator's Ornamented Legplates 98(@ARCHAVON25,40846,0,1,1,1,1), -- Deadly Gladiator's Scaled Legguards 99(@ARCHAVON25,41863,0,1,1,1,1), -- Deadly Gladiator's Mooncloth Leggings 100(@ARCHAVON25,41926,0,1,1,1,1), -- Deadly Gladiator's Satin Leggings 101(@ARCHAVON25,41873,0,1,1,1,1), -- Deadly Gladiator's Mooncloth Gloves 102(@ARCHAVON25,41032,0,1,1,1,1), -- Deadly Gladiator's Mail Leggings 103(@ARCHAVON25,41006,0,1,1,1,1), -- Deadly Gladiator's Mail Gauntlets 104(@ARCHAVON25,41198,0,1,1,1,1), -- Deadly Gladiator's Linked Leggings 105(@ARCHAVON25,41666,0,1,1,1,1), -- Deadly Gladiator's Dragonhide Legguards 106(@ARCHAVON25,41772,0,1,1,1,1), -- Deadly Gladiator's Dragonhide Gloves 107(@ARCHAVON25,41000,0,1,1,1,1), -- Deadly Gladiator's Ringmail Gauntlets 108(@ARCHAVON25,41136,0,1,1,1,1), -- Deadly Gladiator's Linked Gauntlets 109(@ARCHAVON25,41286,0,1,1,1,1), -- Deadly Gladiator's Kodohide Gloves 110(@ARCHAVON25,40805,0,1,1,1,1), -- Deadly Gladiator's Scaled Gauntlets 111(@ARCHAVON25,41939,0,1,1,1,1), -- Deadly Gladiator's Satin Gloves 112(@ARCHAVON25,41297,0,1,1,1,1), -- Deadly Gladiator's Kodohide Legguards 113(@ARCHAVON25,41026,0,1,1,1,1), -- Deadly Gladiator's Ringmail Leggings 114(@ARCHAVON25,41958,0,1,1,1,1), -- Deadly Gladiator's Silk Trousers 115(@ARCHAVON25,41970,0,1,1,1,1), -- Deadly Gladiator's Silk Handguards 116(@ARCHAVON25,40844,0,1,1,1,1), -- Deadly Gladiator's Plate Legguards 117(@ARCHAVON25,41303,0,1,1,1,1), -- Deadly Gladiator's Wyrmhide Legguards 118(@ARCHAVON25,41292,0,1,1,1,1), -- Deadly Gladiator's Wyrmhide Gloves 119(@ARCHAVON25,42004,0,1,1,1,1), -- Deadly Gladiator's Felweave Trousers 120(@ARCHAVON25,41142,0,1,1,1,1), -- Deadly Gladiator's Chain Gauntlets 121(@ARCHAVON25,40845,0,1,1,1,1), -- Deadly Gladiator's Dreadplate Legguards 122(@ARCHAVON25,40804,0,1,1,1,1), -- Deadly Gladiator's Plate Gauntlets 123(@ARCHAVON25,42016,0,1,1,1,1), -- Deadly Gladiator's Felweave Handguards 124(@ARCHAVON25,40806,0,1,1,1,1), -- Deadly Gladiator's Dreadplate Gauntlets 125(@ARCHAVON25,41654,0,1,1,1,1), -- Deadly Gladiator's Leather Legguards 126(@ARCHAVON25,41766,0,1,1,1,1), -- Deadly Gladiator's Leather Gloves 127(@ARCHAVON25,41204,0,1,1,1,1), -- Deadly Gladiator's Chain Leggings 128-- Create Ref for Emalon 25 furious PVP + T8(25) (chest,hands,legs) 129(@EMALON25,41640,0,1,1,1,1), -- Furious Gladiator's Armwraps of Dominance 130(@EMALON25,41625,0,1,1,1,1), -- Furious Gladiator's Armwraps of Salvation 131(@EMALON25,41840,0,1,1,1,1), -- Furious Gladiator's Armwraps of Triumph 132(@EMALON25,42116,0,1,1,1,1), -- Furious Gladiator's Band of Dominance 133(@EMALON25,42117,0,1,1,1,1), -- Furious Gladiator's Band of Triumph 134(@EMALON25,41630,0,1,1,1,1), -- Furious Gladiator's Belt of Dominance 135(@EMALON25,41617,0,1,1,1,1), -- Furious Gladiator's Belt of Salvation 136(@EMALON25,41832,0,1,1,1,1), -- Furious Gladiator's Belt of Triumph 137(@EMALON25,41635,0,1,1,1,1), -- Furious Gladiator's Boots of Dominance 138(@EMALON25,41621,0,1,1,1,1), -- Furious Gladiator's Boots of Salvation 139(@EMALON25,41836,0,1,1,1,1), -- Furious Gladiator's Boots of Triumph 140(@EMALON25,40983,0,1,1,1,1), -- Furious Gladiator's Bracers of Salvation 141(@EMALON25,40889,0,1,1,1,1), -- Furious Gladiator's Bracers of Triumph 142(@EMALON25,41143,0,1,1,1,1), -- Furious Gladiator's Chain Gauntlets 143(@EMALON25,41205,0,1,1,1,1), -- Furious Gladiator's Chain Leggings 144(@EMALON25,42071,0,1,1,1,1), -- Furious Gladiator's Cloak of Ascendancy 145(@EMALON25,42073,0,1,1,1,1), -- Furious Gladiator's Cloak of Deliverance 146(@EMALON25,42069,0,1,1,1,1), -- Furious Gladiator's Cloak of Dominance 147(@EMALON25,42072,0,1,1,1,1), -- Furious Gladiator's Cloak of Salvation 148(@EMALON25,42070,0,1,1,1,1), -- Furious Gladiator's Cloak of Subjugation 149(@EMALON25,42074,0,1,1,1,1), -- Furious Gladiator's Cloak of Triumph 150(@EMALON25,42075,0,1,1,1,1), -- Furious Gladiator's Cloak of Victory 151(@EMALON25,41898,0,1,1,1,1), -- Furious Gladiator's Cord of Dominance 152(@EMALON25,41881,0,1,1,1,1), -- Furious Gladiator's Cord of Salvation 153(@EMALON25,41909,0,1,1,1,1), -- Furious Gladiator's Cuffs of Dominance 154(@EMALON25,41893,0,1,1,1,1), -- Furious Gladiator's Cuffs of Salvation 155(@EMALON25,41773,0,1,1,1,1), -- Furious Gladiator's Dragonhide Gloves 156(@EMALON25,41667,0,1,1,1,1), -- Furious Gladiator's Dragonhide Legguards 157(@EMALON25,40809,0,1,1,1,1), -- Furious Gladiator's Dreadplate Gauntlets 158(@EMALON25,42017,0,1,1,1,1), -- Furious Gladiator's Felweave Handguards 159(@EMALON25,42005,0,1,1,1,1), -- Furious Gladiator's Felweave Trousers 160(@EMALON25,40976,0,1,1,1,1), -- Furious Gladiator's Girdle of Salvation 161(@EMALON25,40881,0,1,1,1,1), -- Furious Gladiator's Girdle of Triumph 162(@EMALON25,40977,0,1,1,1,1), -- Furious Gladiator's Greaves of Salvation 163(@EMALON25,40882,0,1,1,1,1), -- Furious Gladiator's Greaves of Triumph 164(@EMALON25,41287,0,1,1,1,1), -- Furious Gladiator's Kodohide Gloves 165(@EMALON25,41298,0,1,1,1,1), -- Furious Gladiator's Kodohide Legguards 166(@EMALON25,41767,0,1,1,1,1), -- Furious Gladiator's Leather Gloves 167(@EMALON25,41655,0,1,1,1,1), -- Furious Gladiator's Leather Legguards 168(@EMALON25,41137,0,1,1,1,1), -- Furious Gladiator's Linked Gauntlets 169(@EMALON25,41199,0,1,1,1,1), -- Furious Gladiator's Linked Leggings 170(@EMALON25,41007,0,1,1,1,1), -- Furious Gladiator's Mail Gauntlets 171(@EMALON25,41033,0,1,1,1,1), -- Furious Gladiator's Mail Leggings 172(@EMALON25,41874,0,1,1,1,1), -- Furious Gladiator's Mooncloth Gloves 173(@EMALON25,41864,0,1,1,1,1), -- Furious Gladiator's Mooncloth Leggings 174(@EMALON25,40927,0,1,1,1,1), -- Furious Gladiator's Ornamented Gloves 175(@EMALON25,40939,0,1,1,1,1), -- Furious Gladiator's Ornamented Legplates 176(@EMALON25,42037,0,1,1,1,1), -- Furious Gladiator's Pendant of Ascendancy 177(@EMALON25,42039,0,1,1,1,1), -- Furious Gladiator's Pendant of Deliverance 178(@EMALON25,42036,0,1,1,1,1), -- Furious Gladiator's Pendant of Dominance 179(@EMALON25,42040,0,1,1,1,1), -- Furious Gladiator's Pendant of Salvation 180(@EMALON25,42038,0,1,1,1,1), -- Furious Gladiator's Pendant of Subjugation 181(@EMALON25,46373,0,1,1,1,1), -- Furious Gladiator's Pendant of Sundering 182(@EMALON25,42034,0,1,1,1,1), -- Furious Gladiator's Pendant of Triumph 183(@EMALON25,42035,0,1,1,1,1), -- Furious Gladiator's Pendant of Victory 184(@EMALON25,40807,0,1,1,1,1), -- Furious Gladiator's Plate Gauntlets 185(@EMALON25,40847,0,1,1,1,1), -- Furious Gladiator's Plate Legguards 186(@EMALON25,41001,0,1,1,1,1), -- Furious Gladiator's Ringmail Gauntlets 187(@EMALON25,41027,0,1,1,1,1), -- Furious Gladiator's Ringmail Leggings 188(@EMALON25,41075,0,1,1,1,1), -- Furious Gladiator's Sabatons of Dominance 189(@EMALON25,41055,0,1,1,1,1), -- Furious Gladiator's Sabatons of Salvation 190(@EMALON25,41230,0,1,1,1,1), -- Furious Gladiator's Sabatons of Triumph 191(@EMALON25,41940,0,1,1,1,1), -- Furious Gladiator's Satin Gloves 192(@EMALON25,41927,0,1,1,1,1), -- Furious Gladiator's Satin Leggings 193(@EMALON25,40808,0,1,1,1,1), -- Furious Gladiator's Scaled Gauntlets 194(@EMALON25,40849,0,1,1,1,1), -- Furious Gladiator's Scaled Legguards 195(@EMALON25,41971,0,1,1,1,1), -- Furious Gladiator's Silk Handguards 196(@EMALON25,41959,0,1,1,1,1), -- Furious Gladiator's Silk Trousers 197(@EMALON25,41903,0,1,1,1,1), -- Furious Gladiator's Slippers of Dominance 198(@EMALON25,41885,0,1,1,1,1), -- Furious Gladiator's Slippers of Salvation 199(@EMALON25,41070,0,1,1,1,1), -- Furious Gladiator's Waistguard of Dominance 200(@EMALON25,41051,0,1,1,1,1), -- Furious Gladiator's Waistguard of Salvation 201(@EMALON25,41235,0,1,1,1,1), -- Furious Gladiator's Waistguard of Triumph 202(@EMALON25,41065,0,1,1,1,1), -- Furious Gladiator's Wristguards of Dominance 203(@EMALON25,41060,0,1,1,1,1), -- Furious Gladiator's Wristguards of Salvation 204(@EMALON25,41225,0,1,1,1,1), -- Furious Gladiator's Wristguards of Triumph 205(@EMALON25,41293,0,1,1,1,1), -- Furious Gladiator's Wyrmhide Gloves 206(@EMALON25,41304,0,1,1,1,1), -- Furious Gladiator's Wyrmhide Legguards 207(@EMALON25,40811,0,1,1,1,1), -- Furious Gladiator's Girdle of Triumph 208(@EMALON25,46155,0,1,1,1,1), -- Conqueror's Aegis Gauntlets 209(@EMALON25,46179,0,1,1,1,1), -- Conqueror's Aegis Gloves 210(@EMALON25,46181,0,1,1,1,1), -- Conqueror's Aegis Greaves 211(@EMALON25,46174,0,1,1,1,1), -- Conqueror's Aegis Handguards 212(@EMALON25,46176,0,1,1,1,1), -- Conqueror's Aegis Legguards 213(@EMALON25,46153,0,1,1,1,1), -- Conqueror's Aegis Legplates 214(@EMALON25,46113,0,1,1,1,1), -- Conqueror's Darkruned Gauntlets 215(@EMALON25,46119,0,1,1,1,1), -- Conqueror's Darkruned Handguards 216(@EMALON25,46121,0,1,1,1,1), -- Conqueror's Darkruned Legguards 217(@EMALON25,46116,0,1,1,1,1), -- Conqueror's Darkruned Legplates 218(@EMALON25,46135,0,1,1,1,1), -- Conqueror's Deathbringer Gloves 219(@EMALON25,46139,0,1,1,1,1), -- Conqueror's Deathbringer Leggings 220(@EMALON25,46188,0,1,1,1,1), -- Conqueror's Gloves of Sanctification 221(@EMALON25,46163,0,1,1,1,1), -- Conqueror's Handwraps of Sanctification 222(@EMALON25,46132,0,1,1,1,1), -- Conqueror's Kirin Tor Gauntlets 223(@EMALON25,46133,0,1,1,1,1), -- Conqueror's Kirin Tor Leggings 224(@EMALON25,46195,0,1,1,1,1), -- Conqueror's Leggings of Sanctification 225(@EMALON25,46189,0,1,1,1,1), -- Conqueror's Nightsong Gloves 226(@EMALON25,46158,0,1,1,1,1), -- Conqueror's Nightsong Handgrips 227(@EMALON25,46183,0,1,1,1,1), -- Conqueror's Nightsong Handguards 228(@EMALON25,46185,0,1,1,1,1), -- Conqueror's Nightsong Leggings 229(@EMALON25,46160,0,1,1,1,1), -- Conqueror's Nightsong Legguards 230(@EMALON25,46192,0,1,1,1,1), -- Conqueror's Nightsong Trousers 231(@EMALON25,46170,0,1,1,1,1), -- Conqueror's Pants of Sanctification 232(@EMALON25,46142,0,1,1,1,1), -- Conqueror's Scourgestalker Handguards 233(@EMALON25,46144,0,1,1,1,1), -- Conqueror's Scourgestalker Legguards 234(@EMALON25,46148,0,1,1,1,1), -- Conqueror's Siegebreaker Gauntlets 235(@EMALON25,46164,0,1,1,1,1), -- Conqueror's Siegebreaker Handguards 236(@EMALON25,46169,0,1,1,1,1), -- Conqueror's Siegebreaker Legguards 237(@EMALON25,46150,0,1,1,1,1), -- Conqueror's Siegebreaker Legplates 238(@EMALON25,46124,0,1,1,1,1), -- Conqueror's Terrorblade Gauntlets 239(@EMALON25,46126,0,1,1,1,1), -- Conqueror's Terrorblade Legplates 240(@EMALON25,46207,0,1,1,1,1), -- Conqueror's Worldbreaker Gloves 241(@EMALON25,46200,0,1,1,1,1), -- Conqueror's Worldbreaker Grips 242(@EMALON25,46199,0,1,1,1,1), -- Conqueror's Worldbreaker Handguards 243(@EMALON25,46210,0,1,1,1,1), -- Conqueror's Worldbreaker Kilt 244(@EMALON25,46202,0,1,1,1,1), -- Conqueror's Worldbreaker Legguards 245(@EMALON25,46208,0,1,1,1,1), -- Conqueror's Worldbreaker War-Kilt 246-- Create Ref for koralon 25 relentless + T9.5 (hands,legs) 247(@KORALON25,41641,0,1,1,1,1), -- Relentless Gladiator's Armwraps of Dominance 248(@KORALON25,41626,0,1,1,1,1), -- Relentless Gladiator's Armwraps of Salvation 249(@KORALON25,41841,0,1,1,1,1), -- Relentless Gladiator's Armwraps of Triumph 250(@KORALON25,42118,0,1,1,1,1), -- Relentless Gladiator's Band of Ascendancy 251(@KORALON25,42119,0,1,1,1,1), -- Relentless Gladiator's Band of Victory 252(@KORALON25,41631,0,1,1,1,1), -- Relentless Gladiator's Belt of Dominance 253(@KORALON25,41618,0,1,1,1,1), -- Relentless Gladiator's Belt of Salvation 254(@KORALON25,41833,0,1,1,1,1), -- Relentless Gladiator's Belt of Triumph 255(@KORALON25,41636,0,1,1,1,1), -- Relentless Gladiator's Boots of Dominance 256(@KORALON25,41622,0,1,1,1,1), -- Relentless Gladiator's Boots of Salvation 257(@KORALON25,41837,0,1,1,1,1), -- Relentless Gladiator's Boots of Triumph 258(@KORALON25,40984,0,1,1,1,1), -- Relentless Gladiator's Bracers of Salvation 259(@KORALON25,40890,0,1,1,1,1), -- Relentless Gladiator's Bracers of Triumph 260(@KORALON25,41144,0,1,1,1,1), -- Relentless Gladiator's Chain Gauntlets 261(@KORALON25,41206,0,1,1,1,1), -- Relentless Gladiator's Chain Leggings 262(@KORALON25,42078,0,1,1,1,1), -- Relentless Gladiator's Cloak of Ascendancy 263(@KORALON25,42080,0,1,1,1,1), -- Relentless Gladiator's Cloak of Deliverance 264(@KORALON25,42076,0,1,1,1,1), -- Relentless Gladiator's Cloak of Dominance 265(@KORALON25,42079,0,1,1,1,1), -- Relentless Gladiator's Cloak of Salvation 266(@KORALON25,42077,0,1,1,1,1), -- Relentless Gladiator's Cloak of Subjugation 267(@KORALON25,42081,0,1,1,1,1), -- Relentless Gladiator's Cloak of Triumph 268(@KORALON25,42082,0,1,1,1,1), -- Relentless Gladiator's Cloak of Victory 269(@KORALON25,41899,0,1,1,1,1), -- Relentless Gladiator's Cord of Dominance 270(@KORALON25,41882,0,1,1,1,1), -- Relentless Gladiator's Cord of Salvation 271(@KORALON25,41910,0,1,1,1,1), -- Relentless Gladiator's Cuffs of Dominance 272(@KORALON25,41894,0,1,1,1,1), -- Relentless Gladiator's Cuffs of Salvation 273(@KORALON25,41774,0,1,1,1,1), -- Relentless Gladiator's Dragonhide Gloves 274(@KORALON25,41668,0,1,1,1,1), -- Relentless Gladiator's Dragonhide Legguards 275(@KORALON25,40851,0,1,1,1,1), -- Relentless Gladiator's Dreadplate Legguards 276(@KORALON25,42018,0,1,1,1,1), -- Relentless Gladiator's Felweave Handguards 277(@KORALON25,42006,0,1,1,1,1), -- Relentless Gladiator's Felweave Trousers 278(@KORALON25,40978,0,1,1,1,1), -- Relentless Gladiator's Girdle of Salvation 279(@KORALON25,40883,0,1,1,1,1), -- Relentless Gladiator's Girdle of Triumph 280(@KORALON25,40979,0,1,1,1,1), -- Relentless Gladiator's Greaves of Salvation 281(@KORALON25,40884,0,1,1,1,1), -- Relentless Gladiator's Greaves of Triumph 282(@KORALON25,41288,0,1,1,1,1), -- Relentless Gladiator's Kodohide Gloves 283(@KORALON25,41299,0,1,1,1,1), -- Relentless Gladiator's Kodohide Legguards 284(@KORALON25,41768,0,1,1,1,1), -- Relentless Gladiator's Leather Gloves 285(@KORALON25,41656,0,1,1,1,1), -- Relentless Gladiator's Leather Legguards 286(@KORALON25,41138,0,1,1,1,1), -- Relentless Gladiator's Linked Gauntlets 287(@KORALON25,41200,0,1,1,1,1), -- Relentless Gladiator's Linked Leggings 288(@KORALON25,41008,0,1,1,1,1), -- Relentless Gladiator's Mail Gauntlets 289(@KORALON25,41034,0,1,1,1,1), -- Relentless Gladiator's Mail Leggings 290(@KORALON25,41875,0,1,1,1,1), -- Relentless Gladiator's Mooncloth Gloves 291(@KORALON25,41865,0,1,1,1,1), -- Relentless Gladiator's Mooncloth Leggings 292(@KORALON25,40928,0,1,1,1,1), -- Relentless Gladiator's Ornamented Gloves 293(@KORALON25,40940,0,1,1,1,1), -- Relentless Gladiator's Ornamented Legplates 294(@KORALON25,42044,0,1,1,1,1), -- Relentless Gladiator's Pendant of Ascendancy 295(@KORALON25,42046,0,1,1,1,1), -- Relentless Gladiator's Pendant of Deliverance 296(@KORALON25,42043,0,1,1,1,1), -- Relentless Gladiator's Pendant of Dominance 297(@KORALON25,42047,0,1,1,1,1), -- Relentless Gladiator's Pendant of Salvation 298(@KORALON25,42045,0,1,1,1,1), -- Relentless Gladiator's Pendant of Subjugation 299(@KORALON25,46374,0,1,1,1,1), -- Relentless Gladiator's Pendant of Sundering 300(@KORALON25,42041,0,1,1,1,1), -- Relentless Gladiator's Pendant of Triumph 301(@KORALON25,42042,0,1,1,1,1), -- Relentless Gladiator's Pendant of Victory 302(@KORALON25,40810,0,1,1,1,1), -- Relentless Gladiator's Plate Gauntlets 303(@KORALON25,40850,0,1,1,1,1), -- Relentless Gladiator's Plate Legguards 304(@KORALON25,41002,0,1,1,1,1), -- Relentless Gladiator's Ringmail Gauntlets 305(@KORALON25,41028,0,1,1,1,1), -- Relentless Gladiator's Ringmail Leggings 306(@KORALON25,41076,0,1,1,1,1), -- Relentless Gladiator's Sabatons of Dominance 307(@KORALON25,41056,0,1,1,1,1), -- Relentless Gladiator's Sabatons of Salvation 308(@KORALON25,41231,0,1,1,1,1), -- Relentless Gladiator's Sabatons of Triumph 309(@KORALON25,41941,0,1,1,1,1), -- Relentless Gladiator's Satin Gloves 310(@KORALON25,41928,0,1,1,1,1), -- Relentless Gladiator's Satin Leggings 311(@KORALON25,40812,0,1,1,1,1), -- Relentless Gladiator's Scaled Gauntlets 312(@KORALON25,40852,0,1,1,1,1), -- Relentless Gladiator's Scaled Legguards 313(@KORALON25,41972,0,1,1,1,1), -- Relentless Gladiator's Silk Handguards 314(@KORALON25,41960,0,1,1,1,1), -- Relentless Gladiator's Silk Trousers 315(@KORALON25,41904,0,1,1,1,1), -- Relentless Gladiator's Treads of Dominance 316(@KORALON25,41886,0,1,1,1,1), -- Relentless Gladiator's Treads of Salvation 317(@KORALON25,41071,0,1,1,1,1), -- Relentless Gladiator's Waistguard of Dominance 318(@KORALON25,41052,0,1,1,1,1), -- Relentless Gladiator's Waistguard of Salvation 319(@KORALON25,41236,0,1,1,1,1), -- Relentless Gladiator's Waistguard of Triumph 320(@KORALON25,41066,0,1,1,1,1), -- Relentless Gladiator's Wristguards of Dominance 321(@KORALON25,41061,0,1,1,1,1), -- Relentless Gladiator's Wristguards of Salvation 322(@KORALON25,41226,0,1,1,1,1), -- Relentless Gladiator's Wristguards of Triumph 323(@KORALON25,41294,0,1,1,1,1), -- Relentless Gladiator's Wyrmhide Gloves 324(@KORALON25,41305,0,1,1,1,1), -- Relentless Gladiator's Wyrmhide Legguards 325(@KORALON25,48094,0,1,1,1,1), -- Zabra's Pants of Triumph 326(@KORALON25,48064,0,1,1,1,1), -- Zabra's Leggings of Triumph 327(@KORALON25,48096,0,1,1,1,1), -- Zabra's Handwraps of Triumph 328(@KORALON25,48066,0,1,1,1,1), -- Zabra's Gloves of Triumph 329(@KORALON25,48271,0,1,1,1,1), -- Windrunner's Legguards of Triumph 330(@KORALON25,48273,0,1,1,1,1), -- Windrunner's Handguards of Triumph 331(@KORALON25,48362,0,1,1,1,1), -- Thrall's War-Kilt of Triumph 332(@KORALON25,48303,0,1,1,1,1), -- Thrall's Legguards of Triumph 333(@KORALON25,48332,0,1,1,1,1), -- Thrall's Kilt of Triumph 334(@KORALON25,48301,0,1,1,1,1), -- Thrall's Handguards of Triumph 335(@KORALON25,48364,0,1,1,1,1), -- Thrall's Grips of Triumph 336(@KORALON25,48334,0,1,1,1,1), -- Thrall's Gloves of Triumph 337(@KORALON25,47770,0,1,1,1,1), -- Sunstrider's Leggings of Triumph 338(@KORALON25,47772,0,1,1,1,1), -- Sunstrider's Gauntlets of Triumph 339(@KORALON25,48180,0,1,1,1,1), -- Runetotem's Trousers of Triumph 340(@KORALON25,48195,0,1,1,1,1), -- Runetotem's Legguards of Triumph 341(@KORALON25,48150,0,1,1,1,1), -- Runetotem's Leggings of Triumph 342(@KORALON25,48152,0,1,1,1,1), -- Runetotem's Handguards of Triumph 343(@KORALON25,48193,0,1,1,1,1), -- Runetotem's Handgrips of Triumph 344(@KORALON25,48182,0,1,1,1,1), -- Runetotem's Gloves of Triumph 345(@KORALON25,48623,0,1,1,1,1), -- Liadrin's Legplates of Triumph 346(@KORALON25,48660,0,1,1,1,1), -- Liadrin's Legguards of Triumph 347(@KORALON25,48658,0,1,1,1,1), -- Liadrin's Handguards of Triumph 348(@KORALON25,48591,0,1,1,1,1), -- Liadrin's Greaves of Triumph 349(@KORALON25,48593,0,1,1,1,1), -- Liadrin's Gloves of Triumph 350(@KORALON25,48625,0,1,1,1,1), -- Liadrin's Gauntlets of Triumph 351(@KORALON25,48497,0,1,1,1,1), -- Koltira's Legplates of Triumph 352(@KORALON25,48554,0,1,1,1,1), -- Koltira's Legguards of Triumph 353(@KORALON25,48556,0,1,1,1,1), -- Koltira's Handguards of Triumph 354(@KORALON25,48499,0,1,1,1,1), -- Koltira's Gauntlets of Triumph 355(@KORALON25,48394,0,1,1,1,1), -- Hellscream's Legplates of Triumph 356(@KORALON25,48464,0,1,1,1,1), -- Hellscream's Legguards of Triumph 357(@KORALON25,48462,0,1,1,1,1), -- Hellscream's Handguards of Triumph 358(@KORALON25,48392,0,1,1,1,1), -- Hellscream's Gauntlets of Triumph 359(@KORALON25,47805,0,1,1,1,1), -- Gul'dan's Leggings of Triumph 360(@KORALON25,47803,0,1,1,1,1), -- Gul'dan's Gloves of Triumph 361(@KORALON25,48239,0,1,1,1,1), -- Garona's Legplates of Triumph 362(@KORALON25,48241,0,1,1,1,1), -- Garona's Gauntlets of Triumph 363(@KORALON25,48379,0,1,2,1,1), -- Wrynn's Legplates of Triumph 364(@KORALON25,48446,0,1,2,1,1), -- Wrynn's Legguards of Triumph 365(@KORALON25,48452,0,1,2,1,1), -- Wrynn's Handguards of Triumph 366(@KORALON25,48377,0,1,2,1,1), -- Wrynn's Gauntlets of Triumph 367(@KORALON25,48258,0,1,2,1,1), -- Windrunner's Legguards of Triumph 368(@KORALON25,48256,0,1,2,1,1), -- Windrunner's Handguards of Triumph 369(@KORALON25,48079,0,1,2,1,1), -- Velen's Pants of Triumph 370(@KORALON25,48077,0,1,2,1,1), -- Velen's Handwraps of Triumph 371(@KORALON25,47983,0,1,2,1,1), -- Velen's Gloves of Triumph 372(@KORALON25,48226,0,1,2,1,1), -- VanCleef's Legplates of Triumph 373(@KORALON25,48224,0,1,2,1,1), -- VanCleef's Gauntlets of Triumph 374(@KORALON25,48610,0,1,2,1,1), -- Turalyon's Legplates of Triumph 375(@KORALON25,48638,0,1,2,1,1), -- Turalyon's Legguards of Triumph 376(@KORALON25,48640,0,1,2,1,1), -- Turalyon's Handguards of Triumph 377(@KORALON25,48578,0,1,2,1,1), -- Turalyon's Greaves of Triumph 378(@KORALON25,48576,0,1,2,1,1), -- Turalyon's Gloves of Triumph 379(@KORALON25,48608,0,1,2,1,1), -- Turalyon's Gauntlets of Triumph 380(@KORALON25,48484,0,1,2,1,1), -- Thassarian's Legplates of Triumph 381(@KORALON25,48541,0,1,2,1,1), -- Thassarian's Legguards of Triumph 382(@KORALON25,48539,0,1,2,1,1), -- Thassarian's Handguards of Triumph 383(@KORALON25,48482,0,1,2,1,1), -- Thassarian's Gauntlets of Triumph 384(@KORALON25,48349,0,1,2,1,1), -- Nobundo's War-Kilt of Triumph 385(@KORALON25,48288,0,1,2,1,1), -- Nobundo's Legguards of Triumph 386(@KORALON25,48319,0,1,2,1,1), -- Nobundo's Kilt of Triumph 387(@KORALON25,48286,0,1,2,1,1), -- Nobundo's Handguards of Triumph 388(@KORALON25,48347,0,1,2,1,1), -- Nobundo's Grips of Triumph 389(@KORALON25,48317,0,1,2,1,1), -- Nobundo's Gloves of Triumph 390(@KORALON25,48165,0,1,2,1,1), -- Malfurion's Trousers of Triumph 391(@KORALON25,48210,0,1,2,1,1), -- Malfurion's Legguards of Triumph 392(@KORALON25,48135,0,1,2,1,1), -- Malfurion's Leggings of Triumph 393(@KORALON25,48133,0,1,2,1,1), -- Malfurion's Handguards of Triumph 394(@KORALON25,48212,0,1,2,1,1), -- Malfurion's Handgrips of Triumph 395(@KORALON25,48163,0,1,2,1,1), -- Malfurion's Gloves of Triumph 396(@KORALON25,47755,0,1,2,1,1), -- Khadgar's Leggings of Triumph 397(@KORALON25,47753,0,1,2,1,1), -- Khadgar's Gauntlets of Triumph 398(@KORALON25,47780,0,1,2,1,1), -- Kel'Thuzad's Leggings of Triumph 399(@KORALON25,47782,0,1,2,1,1), -- Kel'Thuzad's Gloves of Triumph 400(@KORALON25,47985,0,1,2,1,1); -- Velen's Leggings of Triumph 401-- Merge PVP and PVE items to one ref 402UPDATE `reference_loot_template` SET `entry`=@TORAVON25 WHERE `entry`=34214; -- 25 Toravon 403UPDATE `reference_loot_template` SET `entry`=@TORAVON10 WHERE `entry`=34213; -- 10 Toravon 404UPDATE `reference_loot_template` SET `entry`=@ARCHAVON10 WHERE `entry`=34210; -- 10 Archavon 405UPDATE `reference_loot_template` SET `entry`=@EMALON10 WHERE `entry`=34211; -- 10 Emalon 406UPDATE `reference_loot_template` SET `entry`=@KORALON10 WHERE `entry`=34212; -- 10 Koralon 407-- Assign to cratures 408SET @Tora10 =38433; 409SET @Tora25 =38462; 410SET @Arch10 =31125; 411SET @Arch25 =31722; 412SET @Emal10 =33993; 413SET @Emal25 =33994; 414SET @Kora10 =35013; 415SET @Kora25 =35360; 416DELETE FROM `creature_loot_template` WHERE `entry`IN (@Tora10,@Tora25,@Arch10,@Arch25,@Emal10,@Emal25,@Kora10,@Kora25); 417INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 418-- Update loot template for Toravon 10 419(@Tora10,47241,100,1,0,2,2), -- Emblem of triumph 420(@Tora10,1,100,1,0,-@TORAVON10,2), -- Gear(Relentless PVP,T10 PVE) 421(@Tora10,2,1,1,0,-34203,1), -- Mount 422-- Update loot template for Toravon 25 to drop 3 items 423(@Tora25,49426,100,1,0,2,2), -- Emblem of frost 424(@Tora25,1,100,1,0,-@TORAVON25,3), -- Gear(Wrathful PVP,T10.5 PVE) 425(@Tora25,2,1,1,0,-34203,1), -- Mount 426-- Update loot template for Archavon 10 427(@Arch10,47241,100,1,0,2,2), -- Emblem of triumph 428(@Arch10,1,100,1,0,-@ARCHAVON10,2), -- Gear(Hate PVP,T7 PVE) 429(@Arch10,2,1,1,0,-34203,1), -- Mount 430-- Update loot template for Archavon 25 431(@Arch25,47241,100,1,0,2,2), -- Emblem of triumph 432(@Arch25,1,100,1,0,-@ARCHAVON25,4), -- Gear(Deadly PVP,T7(25) PVE) 433(@Arch25,2,1,1,0,-34203,1), -- Mount 434-- Update loot template for Emalon 10 435(@Emal10,47241,100,1,0,2,2), -- Emblem of triumph 436(@Emal10,1,100,1,0,-@EMALON10,2), -- Gear(Deadly PVP,T8 PVE) 437(@Emal10,2,1,1,0,-34203,1), -- Mount 438-- Update loot template for Emalon 25 439(@Emal25,47241,100,1,0,2,2), -- Emblem of triumph 440(@Emal25,1,100,1,0,-@EMALON25,4), -- Gear(Deadly PVP,T8(25) PVE) 441(@Emal25,2,1,1,0,-34203,1), -- Mount 442-- Update loot template for Koralon 10 443(@Kora10,47241,100,1,0,2,2), -- Emblem of triumph 444(@Kora10,1,100,1,0,-@KORALON10,2), -- Gear(Furious PVP,T9 PVE) 445(@Kora10,2,1,1,0,-34203,1), -- Mount 446-- Update loot template for Koralon 25 447(@Kora25,47241,100,1,0,2,2), -- Emblem of triumph 448(@Kora25,1,100,1,0,-@KORALON25,4), -- Gear(Relentless PVP,T9.5 PVE) 449(@Kora25,2,1,1,0,-34203,1); -- Mount