Emangos 4.3.4 Crear Set Custom facil y rapido!

[Remamakiller]

Buenas yo de nuevo, hoy con un script sql para crear un set custom fácil y rápido!
Les dejare una pequeña guía para que entiendan que están metiendo en su base de datos.
Cerciorarse de no tener items creados con entrys > 200000 les puede generar problemas.
Este archivo es copiado y mejorado del post del amigo , Nekro : https://wowcreador.com/threads/trinitycore3-3-5a-crear-set-custom-facil-y-rapido.117/
Yo lo modifiqué para Emangos 4.3.4 , pero para el , va todos los agradecimientos


INSERT INTO item_template
SELECT entry+200000, class, subclass, unk0, name, displayid, Quality, Flags, Flags2, Unknown, Unknown1, Unknown2, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_unk1_1, stat_unk2_1, stat_type2, stat_value2, stat_unk1_2, stat_unk2_2, stat_type3, stat_value3, stat_unk1_3, stat_unk2_3, stat_type4, stat_value4, stat_unk1_4, stat_unk2_4, stat_type5, stat_value5, stat_unk1_5, stat_unk2_5, stat_type6, stat_value6, stat_unk1_6, stat_unk2_6, stat_type7, stat_value7, stat_unk1_7, stat_unk2_7, stat_type8, stat_value8, stat_unk1_8, stat_unk2_8, stat_type9, stat_value9, stat_unk1_9, stat_unk2_9, stat_type10, stat_value10, stat_unk1_10, stat_unk2_10, ScalingStatDistribution, DamageType, delay, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, itemset, MaxDurability, area, Map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, Duration, ItemLimitCategory, HolidayId, ScriptName, DisenchantID, FoodType, StatScalingFactor, Unknown400_1, Unknown400_2, minMoneyLoot, maxMoneyLoot, ExtraFlags
FROM item_template
WHERE NAME LIKE "%Wrathful Gladiator's%";

-- Cambiamos el nombre Wrathful Gladiator's por Elite Gladiator's
UPDATE item_template
SET NAME = REPLACE(NAME, 'Wrathful', 'Elite')
WHERE entry > 200000;

-- Aumentamos los stats un 25% solo al conjunto Elite Gladiator's
UPDATE item_template SET stat_value1 = (stat_value1 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value2 = (stat_value2 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value3 = (stat_value3 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value4 = (stat_value4 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value5 = (stat_value5 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value6 = (stat_value6 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value7 = (stat_value7 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value8 = (stat_value8 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value9 = (stat_value9 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET stat_value10 = (stat_value10 * 1.25) WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET Quality = 6 WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET RequiredLevel = 85 WHERE NAME LIKE "Elite Gladiator's%";
UPDATE item_template SET ItemLevel = 418 WHERE NAME LIKE "Elite Gladiator's%";

SET @NPC := 910000;
INSERT INTO creature_template (entry, modelid_1, name, subname, minlevel, maxlevel, faction_A, faction_H, npcflag) VALUES
(@NPC, 30790, 'Elite Weapons', 'OldCata', 85, 85, 35, 35, 4224),
(@NPC+1, 30790, 'Elite Set', 'OldCata', 85, 85, 35, 35, 4224),
(@NPC+2, 30790, 'Elite accessories', 'OldCata', 85, 85, 35, 35, 4224);

DELETE FROM npc_vendor WHERE (entry= @NPC);
INSERT INTO npc_vendor SELECT @NPC,entry,0,0,0,0
FROM item_template WHERE InventoryType IN (13, 14, 15, 17, 21, 22, 25, 26) AND name LIKE "Elite Gladiator's%";

DELETE FROM npc_vendor WHERE (entry= @NPC+1);
INSERT INTO npc_vendor SELECT @NPC+1,entry,0,0,0,0
FROM item_template WHERE InventoryType IN (1, 3, 4, 5, 7, 10) AND name LIKE "Elite Gladiator's%";

DELETE FROM npc_vendor WHERE (entry= @NPC+2);
INSERT INTO npc_vendor SELECT @NPC+2,entry,0,0,0,0
FROM item_template WHERE InventoryType IN (2, 6, 8, 9, 11, 12, 16, 23, 28) AND name LIKE "Elite Gladiator's%";

 

[edwinelp]

n