From c4a98cb04129f70e1aaf5c80a7eeb0f16569e5b9 Mon Sep 17 00:00:00 2001 From: Nay Date: Sat, 19 May 2012 22:01:49 +0100 Subject: SQLS: Correct recent sqls file names --- sql/updates/world/2012_02_19_03_world_version.sql | 1 - .../world/2012_02_19_04_creature_loot_template.sql | 1 - .../2012_02_19_05_gameobject_loot_template.sql | 93 ---------------------- sql/updates/world/2012_05_19_03_world_version.sql | 1 + .../world/2012_05_19_04_creature_loot_template.sql | 1 + .../2012_05_19_05_gameobject_loot_template.sql | 93 ++++++++++++++++++++++ 6 files changed, 95 insertions(+), 95 deletions(-) delete mode 100644 sql/updates/world/2012_02_19_03_world_version.sql delete mode 100644 sql/updates/world/2012_02_19_04_creature_loot_template.sql delete mode 100644 sql/updates/world/2012_02_19_05_gameobject_loot_template.sql create mode 100644 sql/updates/world/2012_05_19_03_world_version.sql create mode 100644 sql/updates/world/2012_05_19_04_creature_loot_template.sql create mode 100644 sql/updates/world/2012_05_19_05_gameobject_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_02_19_03_world_version.sql b/sql/updates/world/2012_02_19_03_world_version.sql deleted file mode 100644 index 53c6821be69..00000000000 --- a/sql/updates/world/2012_02_19_03_world_version.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `version` SET `db_version`='TDB 335.11.47' LIMIT 1; diff --git a/sql/updates/world/2012_02_19_04_creature_loot_template.sql b/sql/updates/world/2012_02_19_04_creature_loot_template.sql deleted file mode 100644 index ae996e01956..00000000000 --- a/sql/updates/world/2012_02_19_04_creature_loot_template.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `creature_loot_template` WHERE `entry`=31813 AND `item`=36912; -- Saronite Ore diff --git a/sql/updates/world/2012_02_19_05_gameobject_loot_template.sql b/sql/updates/world/2012_02_19_05_gameobject_loot_template.sql deleted file mode 100644 index f95cb45efe4..00000000000 --- a/sql/updates/world/2012_02_19_05_gameobject_loot_template.sql +++ /dev/null @@ -1,93 +0,0 @@ --- Set Variables -SET @Gunship10N := 28057; -- Data1 for 201872 & 202177 -SET @Gunship10H := 28045; -- Data1 for 201873 & 202178 -SET @Gunship25N := 28072; -- Data1 for 201874 & 202179 -SET @Gunship25H := 28090; -- Data1 for 201875 & 202180 -SET @emblem := 49426; -- Emblem of Frost -SET @SfShard := 50274; -- Shadowfrost Shard -SET @PriSar := 49908; -- Primordial Saronite --- Dug up the old references i created for UP34: -SET @Ref10J := 34329; -SET @Ref25J := 34251; -SET @RefJ10H := 34263; -SET @RefJ25H := 34275; --- Gunship_Armory10N_reference -DELETE FROM `reference_loot_template` WHERE `entry` IN (@Ref10J,@Ref25J,@RefJ10H,@RefJ25H); -INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES -(@Ref10J,50791,0,1,1,1,1), -- Saronite Gargoyle Cloak -(@Ref10J,50795,0,1,1,1,1), -- Cord of Dark Suffering -(@Ref10J,50794,0,1,1,1,1), -- Neverending Winter -(@Ref10J,50787,0,1,1,1,1), -- Frost Giant's Cleaver -(@Ref10J,50793,0,1,1,1,1), -- Midnight Sun -(@Ref10J,50788,0,1,1,1,1), -- Bone Drake's Enameled Boots -(@Ref10J,50792,0,1,1,1,1), -- Pauldrons of Lost Hope -(@Ref10J,50340,0,1,1,1,1), -- Muradin's Spyglass -(@Ref10J,50797,0,1,1,1,1), -- Ice-Reinforced Vrykul Helm -(@Ref10J,50790,0,1,1,1,1), -- Abomination's Bloody Ring -(@Ref10J,50789,0,1,1,1,1), -- Icecrown Rampart Bracers -(@Ref10J,50796,0,1,1,1,1), -- Bracers of Pale Illumination --- Gunship_Armory25N_reference -(@Ref25J,50011,0,1,1,1,1), -- Gunship Captain's Mittens -(@Ref25J,50002,0,1,1,1,1), -- Polar Bear Claw Bracers -(@Ref25J,50006,0,1,1,1,1), -- Corp'rethar Ceremonial Crown -(@Ref25J,50010,0,1,1,1,1), -- Waistband of Righteous Fury -(@Ref25J,50003,0,1,1,1,1), -- Boneguard Commander's Pauldrons -(@Ref25J,50000,0,1,1,1,1), -- Scourge Hunter's Vambraces -(@Ref25J,50359,0,1,1,1,1), -- Althor's Abacus -(@Ref25J,50352,0,1,1,1,1), -- Corpse Tongue Coin -(@Ref25J,49999,0,1,1,1,1), -- Skeleton Lord's Circle -(@Ref25J,50009,0,1,1,1,1), -- Boots of Unnatural Growth -(@Ref25J,50008,0,1,1,1,1), -- Ring of Rapid Ascent -(@Ref25J,49998,0,1,1,1,1), -- Shadowvault Slayer's Cloak -(@Ref25J,50005,0,1,1,1,1), -- Amulet of the Silent Eulogy -(@Ref25J,50411,0,1,1,1,1), -- Scourgeborne Waraxe -(@Ref25J,50001,0,1,1,1,1), -- Ikfirus's Sack of Wonder --- Gunship_Armory10H_reference -(@RefJ10H,51912,0,1,1,1,1), -- Saronite Gargoyle Cloak (heroic) -(@RefJ10H,51908,0,1,1,1,1), -- Cord of Dark Suffering (heroic) -(@RefJ10H,51909,0,1,1,1,1), -- Neverending Winter (heroic) -(@RefJ10H,51916,0,1,1,1,1), -- Frost Giant's Cleaver (heroic) -(@RefJ10H,51910,0,1,1,1,1), -- Midnight Sun (heroic) -(@RefJ10H,51915,0,1,1,1,1), -- Bone Drake's Enameled Boots (heroic) -(@RefJ10H,51911,0,1,1,1,1), -- Pauldrons of Lost Hope (heroic) -(@RefJ10H,50345,0,1,1,1,1), -- Muradin's Spyglass (heroic) -(@RefJ10H,51906,0,1,1,1,1), -- Ice-Reinforced Vrykul Helm (heroic) -(@RefJ10H,51913,0,1,1,1,1), -- Abomination's Bloody Ring (heroic) -(@RefJ10H,51914,0,1,1,1,1), -- Icecrown Rampart Bracers (heroic) -(@RefJ10H,51907,0,1,1,1,1), -- Bracers of Pale Illumination (heroic) --- Gunship_Armory25H_reference -(@RefJ25H,50663,0,1,1,1,1), -- Gunship Captain's Mittens (heroic) -(@RefJ25H,50659,0,1,1,1,1), -- Polar Bear Claw Bracers (heroic) -(@RefJ25H,50661,0,1,1,1,1), -- Corp'rethar Ceremonial Crown (heroic) -(@RefJ25H,50667,0,1,1,1,1), -- Waistband of Righteous Fury (heroic) -(@RefJ25H,50660,0,1,1,1,1), -- Boneguard Commander's Pauldrons (heroic) -(@RefJ25H,50655,0,1,1,1,1), -- Scourge Hunter's Vambraces (heroic) -(@RefJ25H,50366,0,1,1,1,1), -- Althor's Abacus (heroic) -(@RefJ25H,50349,0,1,1,1,1), -- Corpse Tongue Coin (heroic) -(@RefJ25H,50657,0,1,1,1,1), -- Skeleton Lord's Circle (heroic) -(@RefJ25H,50665,0,1,1,1,1), -- Boots of Unnatural Growth (heroic) -(@RefJ25H,50664,0,1,1,1,1), -- Ring of Rapid Ascent (heroic) -(@RefJ25H,50653,0,1,1,1,1), -- Shadowvault Slayer's Cloak (heroic) -(@RefJ25H,50658,0,1,1,1,1), -- Amulet of the Silent Eulogy (heroic) -(@RefJ25H,50654,0,1,1,1,1), -- Scourgeborne Waraxe (heroic) -(@RefJ25H,50656,0,1,1,1,1); -- Ikfirus's Sack of Wonder (heroic) --- Bind the refs to the objects -DELETE FROM `gameobject_loot_template` WHERE `entry` IN (@Gunship10N,@Gunship10H,@Gunship25N,@Gunship25H); -INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES --- Gunship10N -(@Gunship10N,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 10N -(@Gunship10N,1,100,1,0,-@Ref10J,2), -- 2 from reference 10Normal --- Gunship25N -(@Gunship25N,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 25N -(@Gunship25N,1,100,1,0,-@Ref25J,2), -- 3 from reference 25Normal -(@Gunship25N,@SfShard,-35,1,0,1,1), -- Shadowfrost Shard @ 38% chance -(@Gunship25N,@PriSar,38,1,0,1,1), -- Primordial Saronite @ 10% chance --- Gunship10H -(@Gunship10H,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 10H -(@Gunship10H,1,100,1,0,-@RefJ10H,2), -- 2 from reference 10Heroic -(@Gunship10H,@PriSar,38,1,0,1,1), -- Primordial Saronite @ 38% chance --- Gunship25H -(@Gunship25H,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 25H -(@Gunship25H,1,100,1,0,-@RefJ25H,2), -- 3 from reference 25Heroic -(@Gunship25H,@SfShard,-75,1,0,1,1), -- Shadowfrost Shard @ 75% chance -(@Gunship25H,@PriSar,50,1,0,1,1); -- Primordial Saronite @ 50% chance diff --git a/sql/updates/world/2012_05_19_03_world_version.sql b/sql/updates/world/2012_05_19_03_world_version.sql new file mode 100644 index 00000000000..53c6821be69 --- /dev/null +++ b/sql/updates/world/2012_05_19_03_world_version.sql @@ -0,0 +1 @@ +UPDATE `version` SET `db_version`='TDB 335.11.47' LIMIT 1; diff --git a/sql/updates/world/2012_05_19_04_creature_loot_template.sql b/sql/updates/world/2012_05_19_04_creature_loot_template.sql new file mode 100644 index 00000000000..ae996e01956 --- /dev/null +++ b/sql/updates/world/2012_05_19_04_creature_loot_template.sql @@ -0,0 +1 @@ +DELETE FROM `creature_loot_template` WHERE `entry`=31813 AND `item`=36912; -- Saronite Ore diff --git a/sql/updates/world/2012_05_19_05_gameobject_loot_template.sql b/sql/updates/world/2012_05_19_05_gameobject_loot_template.sql new file mode 100644 index 00000000000..f95cb45efe4 --- /dev/null +++ b/sql/updates/world/2012_05_19_05_gameobject_loot_template.sql @@ -0,0 +1,93 @@ +-- Set Variables +SET @Gunship10N := 28057; -- Data1 for 201872 & 202177 +SET @Gunship10H := 28045; -- Data1 for 201873 & 202178 +SET @Gunship25N := 28072; -- Data1 for 201874 & 202179 +SET @Gunship25H := 28090; -- Data1 for 201875 & 202180 +SET @emblem := 49426; -- Emblem of Frost +SET @SfShard := 50274; -- Shadowfrost Shard +SET @PriSar := 49908; -- Primordial Saronite +-- Dug up the old references i created for UP34: +SET @Ref10J := 34329; +SET @Ref25J := 34251; +SET @RefJ10H := 34263; +SET @RefJ25H := 34275; +-- Gunship_Armory10N_reference +DELETE FROM `reference_loot_template` WHERE `entry` IN (@Ref10J,@Ref25J,@RefJ10H,@RefJ25H); +INSERT INTO `reference_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +(@Ref10J,50791,0,1,1,1,1), -- Saronite Gargoyle Cloak +(@Ref10J,50795,0,1,1,1,1), -- Cord of Dark Suffering +(@Ref10J,50794,0,1,1,1,1), -- Neverending Winter +(@Ref10J,50787,0,1,1,1,1), -- Frost Giant's Cleaver +(@Ref10J,50793,0,1,1,1,1), -- Midnight Sun +(@Ref10J,50788,0,1,1,1,1), -- Bone Drake's Enameled Boots +(@Ref10J,50792,0,1,1,1,1), -- Pauldrons of Lost Hope +(@Ref10J,50340,0,1,1,1,1), -- Muradin's Spyglass +(@Ref10J,50797,0,1,1,1,1), -- Ice-Reinforced Vrykul Helm +(@Ref10J,50790,0,1,1,1,1), -- Abomination's Bloody Ring +(@Ref10J,50789,0,1,1,1,1), -- Icecrown Rampart Bracers +(@Ref10J,50796,0,1,1,1,1), -- Bracers of Pale Illumination +-- Gunship_Armory25N_reference +(@Ref25J,50011,0,1,1,1,1), -- Gunship Captain's Mittens +(@Ref25J,50002,0,1,1,1,1), -- Polar Bear Claw Bracers +(@Ref25J,50006,0,1,1,1,1), -- Corp'rethar Ceremonial Crown +(@Ref25J,50010,0,1,1,1,1), -- Waistband of Righteous Fury +(@Ref25J,50003,0,1,1,1,1), -- Boneguard Commander's Pauldrons +(@Ref25J,50000,0,1,1,1,1), -- Scourge Hunter's Vambraces +(@Ref25J,50359,0,1,1,1,1), -- Althor's Abacus +(@Ref25J,50352,0,1,1,1,1), -- Corpse Tongue Coin +(@Ref25J,49999,0,1,1,1,1), -- Skeleton Lord's Circle +(@Ref25J,50009,0,1,1,1,1), -- Boots of Unnatural Growth +(@Ref25J,50008,0,1,1,1,1), -- Ring of Rapid Ascent +(@Ref25J,49998,0,1,1,1,1), -- Shadowvault Slayer's Cloak +(@Ref25J,50005,0,1,1,1,1), -- Amulet of the Silent Eulogy +(@Ref25J,50411,0,1,1,1,1), -- Scourgeborne Waraxe +(@Ref25J,50001,0,1,1,1,1), -- Ikfirus's Sack of Wonder +-- Gunship_Armory10H_reference +(@RefJ10H,51912,0,1,1,1,1), -- Saronite Gargoyle Cloak (heroic) +(@RefJ10H,51908,0,1,1,1,1), -- Cord of Dark Suffering (heroic) +(@RefJ10H,51909,0,1,1,1,1), -- Neverending Winter (heroic) +(@RefJ10H,51916,0,1,1,1,1), -- Frost Giant's Cleaver (heroic) +(@RefJ10H,51910,0,1,1,1,1), -- Midnight Sun (heroic) +(@RefJ10H,51915,0,1,1,1,1), -- Bone Drake's Enameled Boots (heroic) +(@RefJ10H,51911,0,1,1,1,1), -- Pauldrons of Lost Hope (heroic) +(@RefJ10H,50345,0,1,1,1,1), -- Muradin's Spyglass (heroic) +(@RefJ10H,51906,0,1,1,1,1), -- Ice-Reinforced Vrykul Helm (heroic) +(@RefJ10H,51913,0,1,1,1,1), -- Abomination's Bloody Ring (heroic) +(@RefJ10H,51914,0,1,1,1,1), -- Icecrown Rampart Bracers (heroic) +(@RefJ10H,51907,0,1,1,1,1), -- Bracers of Pale Illumination (heroic) +-- Gunship_Armory25H_reference +(@RefJ25H,50663,0,1,1,1,1), -- Gunship Captain's Mittens (heroic) +(@RefJ25H,50659,0,1,1,1,1), -- Polar Bear Claw Bracers (heroic) +(@RefJ25H,50661,0,1,1,1,1), -- Corp'rethar Ceremonial Crown (heroic) +(@RefJ25H,50667,0,1,1,1,1), -- Waistband of Righteous Fury (heroic) +(@RefJ25H,50660,0,1,1,1,1), -- Boneguard Commander's Pauldrons (heroic) +(@RefJ25H,50655,0,1,1,1,1), -- Scourge Hunter's Vambraces (heroic) +(@RefJ25H,50366,0,1,1,1,1), -- Althor's Abacus (heroic) +(@RefJ25H,50349,0,1,1,1,1), -- Corpse Tongue Coin (heroic) +(@RefJ25H,50657,0,1,1,1,1), -- Skeleton Lord's Circle (heroic) +(@RefJ25H,50665,0,1,1,1,1), -- Boots of Unnatural Growth (heroic) +(@RefJ25H,50664,0,1,1,1,1), -- Ring of Rapid Ascent (heroic) +(@RefJ25H,50653,0,1,1,1,1), -- Shadowvault Slayer's Cloak (heroic) +(@RefJ25H,50658,0,1,1,1,1), -- Amulet of the Silent Eulogy (heroic) +(@RefJ25H,50654,0,1,1,1,1), -- Scourgeborne Waraxe (heroic) +(@RefJ25H,50656,0,1,1,1,1); -- Ikfirus's Sack of Wonder (heroic) +-- Bind the refs to the objects +DELETE FROM `gameobject_loot_template` WHERE `entry` IN (@Gunship10N,@Gunship10H,@Gunship25N,@Gunship25H); +INSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +-- Gunship10N +(@Gunship10N,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 10N +(@Gunship10N,1,100,1,0,-@Ref10J,2), -- 2 from reference 10Normal +-- Gunship25N +(@Gunship25N,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 25N +(@Gunship25N,1,100,1,0,-@Ref25J,2), -- 3 from reference 25Normal +(@Gunship25N,@SfShard,-35,1,0,1,1), -- Shadowfrost Shard @ 38% chance +(@Gunship25N,@PriSar,38,1,0,1,1), -- Primordial Saronite @ 10% chance +-- Gunship10H +(@Gunship10H,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 10H +(@Gunship10H,1,100,1,0,-@RefJ10H,2), -- 2 from reference 10Heroic +(@Gunship10H,@PriSar,38,1,0,1,1), -- Primordial Saronite @ 38% chance +-- Gunship25H +(@Gunship25H,@emblem,100,1,0,2,2), -- Gunship Armory 2xemblems 25H +(@Gunship25H,1,100,1,0,-@RefJ25H,2), -- 3 from reference 25Heroic +(@Gunship25H,@SfShard,-75,1,0,1,1), -- Shadowfrost Shard @ 75% chance +(@Gunship25H,@PriSar,50,1,0,1,1); -- Primordial Saronite @ 50% chance -- cgit v1.2.3