Jump to content

  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
Followers 0
jakub129

[LOOT] VOA 10 man

By jakub129, in Opravy

Recommended Posts

jakub129    0

jakub129
Posted (edited)

ahoj chtel bych vám tu zveřejnit mnou upravený loot (neni upe moje pace) na VOA 10 man

 

 

-- Koralon
-- Set loot ID
UPDATE `creature_template` SET `lootid`= 35013 WHERE `entry` IN (35013);

-- Delete Previous & Create New Loot
DELETE FROM `creature_loot_template` WHERE `entry` IN (35013);
DELETE FROM `reference_loot_template` WHERE `entry` IN (35013);

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(35013, 45624, 100, 1, 0, 2, 2, 0, 0, 0); -- 2 Emblems of Triumph

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(35013, 1, 100, 1, 0, -35013, 2, 0, 0, 0);

INSERT INTO `reference_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
-- Furious Set
(35013, 41625, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Armwraps of Salvation
(35013, 41630, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Belt of Dominance
(35013, 41617, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Belt of Salvation
(35013, 42071, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Ascendancy
(35013, 42073, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Deliverance
(35013, 42072, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Salvation
(35013, 42070, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Subjugation
(35013, 42036, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Dominance
(35013, 42040, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Salvation
(35013, 42038, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Subjugation
(35013, 46373, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Sundering
(35013, 41055, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Sabatons of Salvation
(35013, 41621, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Boots of Salvation
(35013, 42069, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Dominance
(35013, 41205, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Chain Leggings
(35013, 40848, 0, 1, 1, 1, 1, 0, 0, 0), -- Furiois Gladiator's Dreadplate Legguards
(35013, 42017, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Felweave Handguards
(35013, 42005, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Felweave Trousers
(35013, 41143, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Chain Gauntlets
(35013, 40809, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Dreadplate Gauntlets
(35013, 41767, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Leather Gloves
(35013, 41655, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Leather Legguards
(35013, 40927, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Ornamented Gloves
(35013, 40807, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Plate Gauntlets
(35013, 40847, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Plate Legguards
(35013, 41971, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Silk Handguards
(35013, 41959, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Silk Trousers
(35013, 41893, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cuffs of Salvation
(35013, 42034, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Triumph
(35013, 42035, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Victory
(35013, 40983, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Bracers of Salvation
(35013, 40889, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Bracers of Triumph
(35013, 42075, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Victory
(35013, 41909, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cuffs of Dominance
(35013, 41225, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Wristguards of Triumph
(35013, 41840, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Armwraps of Triumph
(35013, 42117, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Band of Triumph
(35013, 40976, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Girdle of Salvation
(35013, 40882, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Greaves of Triumph
(35013, 41903, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Slippers of Daminance
(35013, 41235, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Waistguard of Truimph
(35013, 41836, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Boots of Triumph
(35013, 42074, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cloak of Triumph
(35013, 41898, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cord of Dominance
(35013, 40881, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Girdle of Triumph
(35013, 41881, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Cord of Salvation
(35013, 40977, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Greaves of Salvation
(35013, 41230, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Sabatons of Triumph
(35013, 41940, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Satin Gloves
(35013, 41885, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Slippers of Salvaion
(35013, 42116, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Band of Dominance
(35013, 41832, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Belt of Triumph
(35013, 41874, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Mooncloth Gloves
(35013, 41864, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Moonclooth Leggings
(35013, 40939, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Ornamented Legplates
(35013, 41927, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Satin Leggings
(35013, 40849, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Scaled Legguards
(35013, 41773, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Gloves
(35013, 41199, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Linked Leggings
(35013, 41007, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Mail Gauntlets
(35013, 42039, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Deliverance
(35013, 40808, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Scaled Guantlets
(35013, 41060, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Wristguards of Salvation
(35013, 41304, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Wyrmhide Legguards
(35013, 41640, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Armwraps of Dominance
(35013, 41667, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Dragonhide Legguards
(35013, 41287, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Kodohide Gloves
(35013, 41298, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Kodohide Legguards
(35013, 41033, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Mail Leggings
(35013, 41001, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Ringmail Gauntlets
(35013, 41027, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Ringmail Leggings
(35013, 41070, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Waistguard of Dominance
(35013, 41051, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Waistguard of Salvation
(35013, 41065, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Wristguard of Dominance
(35013, 41293, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Wyrmhide Gloves
(35013, 41635, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Boots of Dominance
(35013, 41137, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Linked Gauntlets
(35013, 42037, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Pendant of Ascendancy
(35013, 41075, 0, 1, 1, 1, 1, 0, 0, 0), -- Furious Gladiator's Sabatons of Dominance
-- Thrall's
(35013, 48337, 0, 1, 1, 1, 1, 0, 0, 0), -- Thrall's Gloves of Conquest
(35013, 48367, 0, 1, 1, 1, 1, 0, 0, 0), -- Thrall's Grips of Conquest
(35013, 48339, 0, 1, 1, 1, 1, 0, 0, 0), -- Thrall's Kit of Conquest
(35013, 48296, 0, 1, 1, 1, 1, 0, 0, 0), -- Thrall's Handguards of Conquest
(35013, 48298, 0, 1, 1, 1, 1, 0, 0, 0), -- Thrall's Legguards of Conquest
(35013, 48369, 0, 1, 1, 1, 1, 0, 0, 0), -- Thrall's War-Kilt of Conquest
-- Malfurion's
(35013, 48132, 0, 1, 1, 1, 1, 0, 0, 0), -- Malfurion's Handguards of Conquest
(35013, 48162, 0, 1, 1, 1, 1, 0, 0, 0), -- Malfurion's Gloves of Conquest
(35013, 48130, 0, 1, 1, 1, 1, 0, 0, 0), -- Malfurion's Leggings of Conquest
(35013, 48160, 0, 1, 1, 1, 1, 0, 0, 0), -- Malfurion's Trousers of Conquest
(35013, 48215, 0, 1, 1, 1, 1, 0, 0, 0), -- Malfurion's Legguards of Conquest
-- Gul'dan's
(35013, 47802, 0, 1, 1, 1, 1, 0, 0, 0), -- Gul'dan's Gloves of Conquest
(35013, 47800, 0, 1, 1, 1, 1, 0, 0, 0), -- Gul'dan's Leggings of Conquest
-- Turalyon's
(35013, 48603, 0, 1, 1, 1, 1, 0, 0, 0), -- Turalyon's Gauntlets of Conquest
(35013, 48633, 0, 1, 1, 1, 1, 0, 0, 0), -- Turalyon's Handguards of Conquest
(35013, 48635, 0, 1, 1, 1, 1, 0, 0, 0), -- Turalyon's Legguards of Conquest
(35013, 48568, 0, 1, 1, 1, 1, 0, 0, 0), -- Turalyon's Greaves of Conquest
(35013, 48574, 0, 1, 1, 1, 1, 0, 0, 0), -- Turalyon's Gloves of Conquest
-- Kel'Thuzad's
(35013, 47783, 0, 1, 1, 1, 1, 0, 0, 0), -- Kel'Thuzad's Gloves of Conquest
(35013, 47785, 0, 1, 1, 1, 1, 0, 0, 0), -- Kel'Thuzad's Leggings of Conquest
-- Wrynn's
(35013, 48449, 0, 1, 1, 1, 1, 0, 0, 0), -- Wrynn's Handguard of Conquest
(35013, 48445, 0, 1, 1, 1, 1, 0, 0, 0), -- Wrynn's Legguards of Conquest
(35013, 48373, 0, 1, 1, 1, 1, 0, 0, 0), -- Wrynn's Legplates of Conquest
(35013, 48375, 0, 1, 1, 1, 1, 0, 0, 0), -- Wrynn's Gauntlets of Conquest
-- Windrunner's
(35013, 48254, 0, 1, 1, 1, 1, 0, 0, 0), -- Windrunner's Handguards of Conquest
(35013, 48252, 0, 1, 1, 1, 1, 0, 0, 0), -- Windrunner's Legguards of Conquest
(35013, 48278, 0, 1, 1, 1, 1, 0, 0, 0), -- Windrunner's Legguards of Conquest
-- Nobundo's
(35013, 48342, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's Grips of Conquest
(35013, 48284, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's Handguards of Conquest
(35013, 48282, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's Legguars of Conquest
(35013, 48344, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's War-Kit of Conquest
-- Runetotem's
(35013, 48153, 0, 1, 1, 1, 1, 0, 0, 0), -- Runetotem's Handguards of Conquest
(35013, 48155, 0, 1, 1, 1, 1, 0, 0, 0), -- Runetotem's Leggings of Conquest
(35013, 48185, 0, 1, 1, 1, 1, 0, 0, 0), -- Runetotem's Trousers of Conquest
(35013, 48192, 0, 1, 1, 1, 1, 0, 0, 0), -- Runetotem's Gloves of Conquest
(35013, 48190, 0, 1, 1, 1, 1, 0, 0, 0), -- Runetotem's Legguards of Conquest
-- Thassarian's
(35013, 48480, 0, 1, 1, 1, 1, 0, 0, 0), -- Thassarian's Gauntlets of Conquest
(35013, 48537, 0, 1, 1, 1, 1, 0, 0, 0), -- Thassarian's Handguards of Conquest
(35013, 48533, 0, 1, 1, 1, 1, 0, 0, 0), -- Thassarian's Legguards of Conquest
(35013, 48476, 0, 1, 1, 1, 1, 0, 0, 0), -- Thassarian's Legplates of Conquest
-- Liadrin's
(35013, 48630, 0, 1, 1, 1, 1, 0, 0, 0), -- Liadrin's Gauntlets of Conquest
(35013, 48596, 0, 1, 1, 1, 1, 0, 0, 0), -- Liadrin's Greaves of Conquest
(35013, 48598, 0, 1, 1, 1, 1, 0, 0, 0), -- Liadinn's Gloves of Conquest
(35013, 48655, 0, 1, 1, 1, 1, 0, 0, 0), -- Liadrin's Legguards of Conquest
(35013, 48653, 0, 1, 1, 1, 1, 0, 0, 0), -- Liadrin's Hadguards of Conquest
(35013, 48628, 0, 1, 1, 1, 1, 0, 0, 0), -- Liadrin's Legplates of Conquest
-- Koltira's
(35013, 48561, 0, 1, 1, 1, 1, 0, 0, 0), -- Koltira's Legguards of Conquest
(35013, 48504, 0, 1, 1, 1, 1, 0, 0, 0), -- Koltira's Legplates of Conquest
-- Hellscreams's
(35013, 48459, 0, 1, 1, 1, 1, 0, 0, 0), -- Hellscreams's Legguards of Conquest
(35013, 48389, 0, 1, 1, 1, 1, 0, 0, 0), -- Hellscreams's Legplated of Conquest
(35013, 48457, 0, 1, 1, 1, 1, 0, 0, 0), -- Hellscream's Handguard of Conquest
(35013, 48387, 0, 1, 1, 1, 1, 0, 0, 0), -- Hellscream's Gauntlets of Conquest
-- Nobundo's
(35013, 48312, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's Gloves of Conquest
(35013, 48213, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's Handgrips of Conquest
(35013, 48314, 0, 1, 1, 1, 1, 0, 0, 0), -- Nobundo's Kilt of Conquest
-- Zabra's
(35013, 48067, 0, 1, 1, 1, 1, 0, 0, 0), -- Zabra's Gloves of Conquest
(35013, 48069, 0, 1, 1, 1, 1, 0, 0, 0), -- Zabra's Leggins of Conquest
(35013, 48099, 0, 1, 1, 1, 1, 0, 0, 0), -- Zabra's Pants of Conquest
(35013, 48097, 0, 1, 1, 1, 1, 0, 0, 0), -- Zabra's Handwraps of Conquest
-- Velen's
(35013, 48072, 0, 1, 1, 1, 1, 0, 0, 0), -- Velen's Handwraps of Conquest
(35013, 47980, 0, 1, 1, 1, 1, 0, 0, 0), -- Velen's Leggings of Conquest
(35013, 48074, 0, 1, 1, 1, 1, 0, 0, 0), -- Velen's Pants of Conquest
(35013, 47982, 0, 1, 1, 1, 1, 0, 0, 0), -- Velen's Gloves of Conquest
-- Garona's
(35013, 48244, 0, 1, 1, 1, 1, 0, 0, 0), -- Garona's Gauntlets of Conquest
(35013, 48246, 0, 1, 1, 1, 1, 0, 0, 0), -- Garona's Legplates of Conquest
-- Kotlira's
(35013, 48502, 0, 1, 1, 1, 1, 0, 0, 0), -- Kotlira's Gauntlets of Conquest
(35013, 48559, 0, 1, 1, 1, 1, 0, 0, 0), -- Kotlira's Handguards of Conquest
-- Sunstrider's
(35013, 47773, 0, 1, 1, 1, 1, 0, 0, 0), -- Sunstrider's Gauntlets of Conquest
(35013, 47775, 0, 1, 1, 1, 1, 0, 0, 0), -- Sunstrider's Leggings of Conquest
-- Khadgar's
(35013, 47752, 0, 1, 1, 1, 1, 0, 0, 0), -- Khadgar's Gauntlets of Conquest
(35013, 47750, 0, 1, 1, 1, 1, 0, 0, 0), -- Khadgar's Leggings of Conquest
-- VanCleef's
(35013, 48222, 0, 1, 1, 1, 1, 0, 0, 0), -- VanCleef's Gauntlets of Conquest
(35013, 48220, 0, 1, 1, 1, 1, 0, 0, 0), -- Vancleef's Legplates of Conquest
-- Other
(35013, 48276, 0, 1, 1, 1, 1, 0, 0, 0), -- Windrunner's Handguards of Conquest
-- Mammoth
(35013, 44083, 0, 1, 1, 1, 1, 0, 0, 0), -- Reins of the Grand Black War Mammoth
(35013, 43959, 0, 1, 1, 1, 1, 0, 0, 0); -- Reins of the Grand Black War Mammoth

-- Toravon
-- Set loot ID
UPDATE `creature_template` SET `lootid`= 38433 WHERE `entry` IN (38433);

-- Delete Previous & Create New Loot
DELETE FROM `creature_loot_template` WHERE `entry` IN (38433);
DELETE FROM `reference_loot_template` WHERE `entry` IN (38433);

INSERT INTO `creature_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
(38433,45624,100,1,0,2,2,0,0,0); -- 2 Emblems of Triumph

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(38433, 1, 100, 1, 0, -38433, 2, 0, 0, 0);

INSERT INTO `reference_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) VALUES
-- Relentless Gladiator's
(38433,42118,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Band of Ascendancy
(38433,41837,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Boots of Triumph
(38433,41774,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Dragonhide Gloves
(38433,40978,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Girdle of Salvation
(38433,41656,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Leather Legguards
(38433,41138,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Linked Gauntlets
(38433,41002,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Ringmail Gauntlets
(38433,41904,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Treads of Dominance
(38433,41894,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cuffs of Salvation
(38433,41668,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Dragonhide Legguards
(38433,40811,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Dreadplate Gauntlets
(38433,40979,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Greaves of Salvation
(38433,41299,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Kodohide Legguards
(38433,41768,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Leather Gloves
(38433,41008,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Mail Gauntlets
(38433,40928,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Ornamented Gloves
(38433,40810,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Plate Gauntlets
(38433,40850,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Plate Legguards
(38433,41231,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Sabatons of Triumph
(38433,40890,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Bracers of Triumph
(38433,41144,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Chain Gauntlets
(38433,41206,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Chain Leggings
(38433,41899,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cord of Dominance
(38433,41910,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cuffs of Dominance
(38433,40883,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Girdle of Triumph
(38433,41288,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Kodohide Gloves
(38433,41200,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Linked Leggings
(38433,41034,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Mail Leggings
(38433,41875,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Mooncloth Gloves
(38433,41865,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Mooncloth Leggings
(38433,41028,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Ringmail Leggings
(38433,40852,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Scaled Legguards
(38433,41960,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Silk Trousers
(38433,41236,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Waistguard of Triumph
(38433,42119,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Band of Victory
(38433,40884,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Greaves of Triumph
(38433,40940,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Ornamented Legplates
(38433,41941,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Satin Gloves
(38433,41928,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Satin Leggings
(38433,40812,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Scaled Gauntlets
(38433,41886,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Treads of Salvation
(38433,41226,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Wristguards of Triumph
(38433,41294,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Wyrmhide Gloves
(38433,41305,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Wyrmhide Legguards
(38433,41841,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Armwraps of Triumph
(38433,40984,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Bracers of Salvation
(38433,42081,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Triumph
(38433,42082,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Victory
(38433,40851,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Dreadplate Legguards
(38433,42006,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Felweave Trousers
(38433,41972,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Silk Handguards
(38433,41833,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Belt of Triumph
(38433,42041,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Triumph
(38433,42042,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Victory
(38433,41618,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Belt of Salvation
(38433,41622,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Boots of Salvation
(38433,41641,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Armwraps of Dominance
(38433,41631,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Belt of Dominance
(38433,41076,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Sabatons of Dominance
(38433,41056,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Sabatons of Salvation
(38433,41071,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Waistguard of Dominance
(38433,41066,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Wristguards of Dominance
(38433,41636,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Boots of Dominance
(38433,42080,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Deliverance
(38433,41052,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Waistguard of Salvation
(38433,41626,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Armwraps of Salvation
(38433,42047,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Salvation
(38433,42045,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Subjugation
(38433,41061,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Wristguards of Salvation
(38433,42078,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Ascendancy
(38433,42076,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Dominance
(38433,42077,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Subjugation
(38433,42044,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Ascendancy
(38433,42046,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Deliverance
(38433,42043,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Dominance
(38433,46374,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Pendant of Sundering
(38433,42079,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cloak of Salvation
(38433,41882,0,1,1,1,1,0,0,0), -- Relentless Gladiator's Cord of Salvation
-- Ymirjar Lord's
(38433,50079,0,1,1,1,1,0,0,0), -- Ymirjar Lord's Gauntlets
(38433,50849,0,1,1,1,1,0,0,0), -- Ymirjar Lord's Handguards
(38433,50847,0,1,1,1,1,0,0,0), -- Ymirjar Lord's Legguards
(38433,50081,0,1,1,1,1,0,0,0), -- Ymirjar Lord's Legplates
-- Crimson Acolyte
(38433,50766,0,1,1,1,1,0,0,0), -- Crimson Acolyte Gloves
(38433,50391,0,1,1,1,1,0,0,0), -- Crimson Acolyte Handwraps
(38433,50769,0,1,1,1,1,0,0,0), -- Crimson Acolyte Leggings
(38433,50393,0,1,1,1,1,0,0,0), -- Crimson Acolyte Pants
-- Scourgelord
(38433,50095,0,1,1,1,1,0,0,0), -- Scourgelord Gauntlets
(38433,50856,0,1,1,1,1,0,0,0), -- Scourgelord Handguards
(38433,50854,0,1,1,1,1,0,0,0), -- Scourgelord Legguards
(38433,50097,0,1,1,1,1,0,0,0), -- Scourgelord Legplates
-- Lightsworn
(38433,50327,0,1,1,1,1,0,0,0), -- Lightsworn Gauntlets
(38433,50866,0,1,1,1,1,0,0,0), -- Lightsworn Greaves
(38433,50861,0,1,1,1,1,0,0,0), -- Lightsworn Legguards
(38433,50325,0,1,1,1,1,0,0,0), -- Lightsworn Legplates
-- Frost Witch's
(38433,50842,0,1,1,1,1,0,0,0), -- Frost Witch's Gloves
(38433,50831,0,1,1,1,1,0,0,0), -- Frost Witch's Grips
(38433,50844,0,1,1,1,1,0,0,0), -- Frost Witch's Kilt
(38433,50838,0,1,1,1,1,0,0,0), -- Frost Witch's Legguards
(38433,50833,0,1,1,1,1,0,0,0), -- Frost Witch's War-Kilt
(38433,50836,0,1,1,1,1,0,0,0), -- Frost Witch's Handguards
-- Lasherweave
(38433,50107,0,1,1,1,1,0,0,0), -- Lasherweave Gauntlets
(38433,50109,0,1,1,1,1,0,0,0), -- Lasherweave Legplates
(38433,50820,0,1,1,1,1,0,0,0), -- Lasherweave Trousers
(38433,50827,0,1,1,1,1,0,0,0), -- Lasherweave Handgrips
(38433,50822,0,1,1,1,1,0,0,0), -- Lasherweave Gloves
(38433,50825,0,1,1,1,1,0,0,0), -- Lasherweave Legguards
-- Dark Coven
(38433,50240,0,1,1,1,1,0,0,0), -- Dark Coven Gloves
(38433,50242,0,1,1,1,1,0,0,0), -- Dark Coven Leggings
-- Shadowblade
(38433,50088,0,1,1,1,1,0,0,0), -- Shadowblade Gauntlets
(38433,50090,0,1,1,1,1,0,0,0), -- Shadowblade Legplates
-- Lightsworn
(38433,50868,0,1,1,1,1,0,0,0), -- Lightsworn Gloves
(38433,50863,0,1,1,1,1,0,0,0), -- Lightsworn Handguards
-- Ahn'Kahar Blood Hunter's
(38433,50116,0,1,1,1,1,0,0,0), -- Ahn'Kahar Blood Hunter's Legguards
(38433,50114,0,1,1,1,1,0,0,0), -- Ahn'Kahar Blood Hunter's Handguards
-- Bloodmage
(38433,50277,0,1,1,1,1,0,0,0), -- Bloodmage Leggings
(38433,50275,0,1,1,1,1,0,0,0), -- Bloodmage Gloves
-- Mammoth
(38433,43959,0,1,1,1,1,0,0,0), -- Reins of the Grand Black War Mammoth
(38433,44083,0,1,1,1,1,0,0,0); -- Reins of the Grand Black War Mammoth

-- Emalon
-- Set Loot ID
UPDATE `creature_template` SET `lootid` = 33993 WHERE `entry` IN (33993);

-- Delete Previous & Create New Loot
DELETE FROM `creature_loot_template` WHERE `entry` IN (33993);
DELETE FROM `reference_loot_template` WHERE `entry` IN (33993);

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(33993,45624,100,1,0,2,2,0,0,0); -- 2 Emblems of Triumph

INSERT INTO `creature_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
(33993, 1, 100, 1, 0, -33993, 2, 0, 0, 0);

INSERT INTO `reference_loot_template`(`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `lootcondition`, `condition_value1`, `condition_value2`) VALUES
-- Valorous set
(33993, 45419, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Deathbringer Gloves
(33993, 45420, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Deathbringer Leggings
(33993, 46131, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Kirin Tor Gauntlets
(33993, 45367, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Kirin Tor Leggings
(33993, 45360, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Scourgestalker Handguards
(33993, 45362, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Scourgestalker Legguards
(33993, 45397, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Terrorblade Gauntlets
(33993, 45399, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Terrorblade Legplates
(33993, 45337, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Darkruned Handguards
(33993, 45403, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Worldbreaker Legguards
(33993, 45341, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Darkruned Gauntlets
(33993, 45338, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Darkruned Legguards
(33993, 45343, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Darkruned Legplates
(33993, 45387, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Gloves of Sanctification
(33993, 45392, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Handwraps of Sanctification
(33993, 45388, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Leggings of Sanctification
(33993, 45345, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Nightsong Handguards
(33993, 45394, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Pants of Sanctification
(33993, 45430, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Siegebreaker Gauntlets
(33993, 45432, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Siegebreaker Legplates
(33993, 45426, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Siegebreaker Handguards
(33993, 45427, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Siegebreaker Legguards
(33993, 45376, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Aegis Gauntlets
(33993, 45371, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Aegis Greaves
(33993, 45357, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Nightsong Legguards
(33993, 45401, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Worldbreaker Handguards
(33993, 45384, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Aegis Legguards
(33993, 45379, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Aegis Legplates
(33993, 45351, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Nightsong Gloves
(33993, 45409, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Worldbreaker Kilt
(33993, 45416, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Worldbreaker War-Kilt
(33993, 45370, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Aegis Gloves
(33993, 45383, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Aegis Handguards
(33993, 45355, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Nightsong Handgrips
(33993, 45347, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Nightsong Leggings
(33993, 45353, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Nightsong Trousers
(33993, 45406, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Worldbreaker Gloves
(33993, 45414, 0, 1, 1, 1, 1, 0, 0, 0), -- Valorous Worldbreaker Grips
-- Deadly Gladiator' set
(33993, 41204, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Chain Leggings
(33993, 40806, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Dreadplate Gauntlets
(33993, 40845, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Dreadplate Legguards
(33993, 42016, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Felweave Handguards
(33993, 41766, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Leather Gloves
(33993, 41142, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Chain Gauntlets
(33993, 42004, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Felweave Trousers
(33993, 41654, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Leather Legguards
(33993, 40804, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Plate Gauntlets
(33993, 40844, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Plate Legguards
(33993, 41970, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Silk Handguards
(33993, 41958, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Silk Trousers
(33993, 40880, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Greaves of Triumph
(33993, 42114, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Band of Ascendancy
(33993, 42115, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Band of Victory
(33993, 41835, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Boots of Triumph
(33993, 42067, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Triumph
(33993, 41897, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cord of Dominance
(33993, 41880, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cord of Salvation
(33993, 40974, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Girdle of Salvation
(33993, 40879, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Girdle of Triumph
(33993, 41902, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Treads of Dominance
(33993, 41884, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Treads of Salvation
(33993, 41234, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Waistguard of Triumph
(33993, 41831, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Belt of Triumph
(33993, 40982, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Bracers of Salvation
(33993, 40975, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Greaves of Salvation
(33993, 42028, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Pendant of Victory
(33993, 41229, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Sabatons of Triumph
(33993, 41224, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Wristguards of Triumph
(33993, 41839, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Armwraps of Triumph
(33993, 40888, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Bracers of Triumph
(33993, 42068, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Victory
(33993, 41908, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cuffs of Dominance
(33993, 41892, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cuffs of Salvation
(33993, 41939, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Satin Gloves
(33993, 40805, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Scaled Gauntlets
(33993, 41873, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Mooncloth Gloves
(33993, 41926, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Satin Leggings
(33993, 41863, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Mooncloth Leggings 
(33993, 40926, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Ornamented Gloves
(33993, 40938, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Ornamented Legplates
(33993, 40846, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Scaled Legguards
(33993, 41198, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Linked Leggings
(33993, 41006, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Mail Gauntlets
(33993, 41032, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Mail Leggings
(33993, 41629, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Belt of Dominance
(33993, 41772, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Dragonhide Gloves
(33993, 41666, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Dragonhide Legguards
(33993, 41286, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Kodohide Gloves
(33993, 41136, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Linked Gauntlets
(33993, 41000, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Ringmail Gauntlets
(33993, 41026, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Ringmail Leggings
(33993, 41054, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Sabatons of Salvation
(33993, 41069, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Waistguard of Dominance
(33993, 41064, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Wristguards of Dominance
(33993, 41292, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Wyrmhide Gloves
(33993, 41303, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Wyrmhide Legguards
(33993, 41639, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Armwraps of Dominance
(33993, 41624, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Armwraps of Salvation
(33993, 41616, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Belt of Salvation
(33993, 41634, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Boots of Dominance
(33993, 41620, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Boots of Salvation
(33993, 41297, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Kodohide Legguards
(33993, 42029, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Pendant of Dominance
(33993, 41074, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Sabatons of Dominance
(33993, 41048, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Waistguard of Salvation
(33993, 41059, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Wristguards of Salvation
(33993, 42062, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Dominance
(33993, 42065, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Salvation
(33993, 42030, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Pendant of Ascendancy
(33993, 42031, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Pendant of Subjugation
(33993, 42033, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Pendant of Salvation 
(33993, 42064, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Ascendancy
(33993, 42066, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Deliverance
(33993, 42063, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Cloak of Subjugation
(33993, 42032, 0, 1, 1, 1, 1, 0, 0, 0), -- Deadly Gladiator's Pendant of Deliverance
-- Mammoth
(33993, 44083, 0, 1, 1, 1, 1, 0, 0, 0), -- Reins of the Grand Black War Mammoth
(33993, 43959, 0, 1, 1, 1, 1, 0, 0, 0); -- Reins of the Grand Black War Mammoth

 

 

 

doufám ze se vam bude hodit TESTOVÁNO na 3.3.3a

Edited by Aristo
Spoiler
  • Upvote 1

Share this post

Link to post
Share on other sites

ado130    52

ado130
Posted (edited)

wladass- ako si povedal v kazdej lepsi db... takych este neni vela a myslis ze sa to hodi

jakub129- ak je to aspon z casti tvoja praca tak GJ

 

edit- ako citam dole tak dobre ze som repku este nedal... ak sa to da vazne len skopirovat

Edited by ado130

Share this post

Link to post
Share on other sites

Keany    38

Keany
Posted

Ostatně, SQL standardy ti níc neříkají, jako spatlat pár věcí není problém, ale kdo to pak má číst? Snaha se má cenit ale repku nedám.

Share this post

Link to post
Share on other sites

Wladass    1216

Wladass
Posted

navíc existujou takový upravy jako je spoiler nebo pastebin.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing Opravy
×