Emangos 4.3.4 Crear Set Custom facil y rapido!

Remamakiller

ULTRA VIP
Desde
23 Oct 2019
Mensajes
796
Reacciones
518
Honor
82
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%";

 
Última edición:

Crea una cuenta o inicia sesión para comentar

Debes ser usuario para poder dejar un comentario.

¡Regístrate!

Crea una cuenta en nuestra comunidad. ¡Es fácil!

Acceder

¿Ya tienes una cuenta? Accede aquí

3,921Temas
25,688Mensajes
15,726Usuarios
HuguicheÚltimo usuario
Top