[Request] - custom script for some istance

Hello.

I have a 8311 trinitycore with more custom patch (some by bloodycore and by other fork) and whit this revision i can play some instance and raid that for know is not possible to play with the last release of trinitycore (10868),

Now my question is. Some one know where i can download custom script for:

  • Trial of Champion

  • Trial of Crusade

  • Ulduar

that works for the last core release ?

In my research i find this one for ulduar:

for Trial of Champion i only find with google cache the script that i post but is not for the last revision and i have problming using sql patch becouse db structure as change.

Some one can help me ?

ToC.zip

The fixes were quite simple. All those files were already in the core, for the most part. Here is a patch, putting your attached files in the core. Will compile with latest. I have not tested these in the game. The sql seems fine. a few duplicate entries so if you have updated the database, might wanna change “insert into” to either “insert ignore into” or “replace into” or just add the delete option, which should be there anyways for proper sql file format.

Trial of the Crusader is already in the repository.

Theres a few patches on the old googlecode issue tracker for Trial of the Champion and Ulduar.

Trial of the Crusader is already in the repository.

You mean the raid is running the latest version of trinity?

because when I did some tests in the game, once initiated the event, the enemy appears but does not enter into combat while remaining behind the front door.

The sql seems fine. a few duplicate entries so if you have updated the database, might wanna change “insert into” to either “insert ignore into” or “replace into” or just add the delete option, which should be there anyways for proper sql file format.

There are two main problems in sql files that should update Trial Of Champions.

1 - Launching the patch disappears sql in the announcer of the tournament game and you can not start the event (but this may be due to the fact that I ran the sql file without first having recompiled the core).

2 - the query is wrong for the inclusion of premiums in enemies. Because the table has changed creature_loot_template and I do not know how to update the query.

[CODE]DELETE FROM creature_loot_template WHERE entry IN (‘12012’,‘35451’);

– HC Loot: The Black Knight

– Link: - The Black Knight - NPC - World of Warcraft

INSERT INTO creature_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount,lootcondition,condition_value1,condition_value2) VALUES

(‘12012’,‘43102’,‘74’,‘1’,‘0’,‘1’,‘1’,‘0’,‘0’,‘0’), – Frozen Orb

(‘12012’,‘43228’,‘2’,‘1’,‘0’,‘4’,‘4’,‘1’,‘57940’,‘0’), – Stone Keeper’s Shard

(‘12012’,‘44990’,‘47’,‘1’,‘0’,‘1’,‘1’,‘0’,‘0’,‘0’), – Champion’s Seal

(‘12012’,‘47241’,‘100’,‘1’,‘0’,‘1’,‘1’,‘0’,‘0’,‘0’), – Emblem of Triumph

(‘12012’,‘47527’,‘15’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Embrace of Madness

(‘12012’,‘47529’,‘14’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Mask of Distant Memory

(‘12012’,‘47560’,‘14’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Boots of the Crackling Flame

(‘12012’,‘47561’,‘14’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Gloves of the Dark Exile

(‘12012’,‘47562’,‘15’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Symbol of Redemption

(‘12012’,‘47563’,‘14’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Girdle of the Dauntless Conqueror

(‘12012’,‘47564’,‘13’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Gaze of the Unknown

(‘12012’,‘47565’,‘13’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Vambraces of Unholy Command

(‘12012’,‘47566’,‘13’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – The Warlord’s Depravity

(‘12012’,‘47567’,‘13’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Gauntlets of Revelation

(‘12012’,‘47568’,‘13’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – True-aim Long Rifle

(‘12012’,‘47569’,‘13’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Spectral Kris

(‘12012’,‘48418’,‘-100’,‘1’,‘0’,‘1’,‘1’,‘0’,‘0’,‘0’), – Fragment of the Black Knight’s Soul

(‘12012’,‘49682’,‘13’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Black Knight’s Rondel

(‘12012’,‘34057’,‘0.3’,‘1’,‘0’,‘1’,‘1’,‘0’,‘0’,‘0’); – Abyss Crystal

– Normal Loot: The Black Knight

– Link: The Black Knight - NPC - World of Warcraft

INSERT INTO creature_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount,lootcondition,condition_value1,condition_value2) VALUES

(‘35451’,‘43228’,‘28’,‘1’,‘0’,‘3’,‘3’,‘1’,‘57940’,‘0’), – Stone Keeper’s Shard

(‘35451’,‘47215’,‘16’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Tears of the Vanquished

(‘35451’,‘47216’,‘16’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – The Black Heart

(‘35451’,‘47220’,‘16’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Helm of the Violent Fray

(‘35451’,‘47221’,‘17’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Shoulderpads of the Infamous Knave

(‘35451’,‘47222’,‘16’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Uruka’s Band of Zeal

(‘35451’,‘47226’,‘16’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Mantle of Inconsolable Fear

(‘35451’,‘47227’,‘16’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Girdle of the Pallid Knight

(‘35451’,‘47228’,‘16’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Leggings of the Bloodless Knight

(‘35451’,‘47229’,‘16’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’), – Girdle of Arrogant Downfall

(‘35451’,‘47230’,‘16’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Handwraps of Surrendered Hope

(‘35451’,‘47231’,‘16’,‘1’,‘1’,‘1’,‘1’,‘0’,‘0’,‘0’), – Belt of Merciless Cruelty

(‘35451’,‘47232’,‘16’,‘1’,‘2’,‘1’,‘1’,‘0’,‘0’,‘0’); – Drape of the Undefeated[/CODE]

I, however, whether the drop in the latest version of the TDB is present and correct.

this file fix some bug during compilation of custom script for boss black knight,

The error that fix is:

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp: In member function ‘virtual void boss_black_knight::boss_black_knightAI::Reset()’:/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:153: error: ‘class Creature’ has no member named ‘clearUnitState’

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp: In member function ‘virtual void boss_black_knight::boss_black_knightAI::UpdateAI(uint32)’:

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:239: error: ‘class Creature’ has no member named ‘clearUnitState’

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:270: error: ‘class Creature’ has no member named ‘addUnitState’

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:278: error: ‘class Creature’ has no member named ‘clearUnitState’

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:352: error: ‘class Creature’ has no member named ‘hasUnitState’

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp: In member function ‘virtual void boss_black_knight::boss_black_knightAI::DamageTaken(Unit*, uint32&)’:

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:379: error: ‘class Creature’ has no member named ‘addUnitState’

make[2]: *** [src/server/scripts/CMakeFiles/scripts.dir/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp.o] Error 1

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp: In member function ‘virtual void boss_black_knight::boss_black_knightAI::DamageTaken(Unit*, uint32&)’:

/home/server/trinity_335/trinitycore/src/server/scripts/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp:379: error: ‘class Creature’ has no member named ‘addUnitState’

make[2]: *** [src/server/scripts/CMakeFiles/scripts.dir/Northrend/CrusadersColiseum/TrialOfTheChampion/boss_black_knight.cpp.o] Error 1

Now compile well

boss_black_knight.cpp.zip

try this

toc.patch

Here is you sql file:

[CODE]-- Griphon of black Knight
DELETE FROM creature_template WHERE entry=35491;
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName) VALUES (35491, 0, 0, 0, 0, 0, 29842, 0, 0, 0, ‘Black Knight's Skeletal Gryphon’, ‘’, ‘’, 0, 80, 80, 2, 35, 35, 0, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 1, 33554432, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 1048576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 486, 0, 0, ‘’, 0, 4, 15, 1, 0, 0, 0, 0, 0, 0, 0, 164, 1, 0, 0, 0, ‘npc_black_knight_skeletal_gryphon’);
DELETE FROM script_waypoint WHERE entry=35491;
– waypoint script of Griphon of black Knight
INSERT INTO script_waypoint VALUES
(35491,1,781.513062, 657.989624, 466.821472,0,‘’),
(35491,2,759.004639, 665.142029, 462.540771,0,‘’),
(35491,3,732.936646, 657.163879, 452.678284,0,‘’),
(35491,4,717.490967, 646.008545, 440.136902,0,‘’),
(35491,5,707.570129, 628.978455, 431.128632,0,‘’),
(35491,6,705.164063, 603.628418, 422.956635,0,‘’),
(35491,7,716.350891, 588.489746, 420.801666,0,‘’),
(35491,8,741.702881, 580.167725, 420.523010,0,‘’),
(35491,9,761.634033, 586.382690, 422.206207,0,‘’),
(35491,10,775.982666, 601.991943, 423.606079,0,‘’),
(35491,11,769.051025, 624.686157, 420.035126,0,‘’),
(35491,12,756.582214, 631.692322, 412.529785,0,‘’),
(35491,13,744.841,634.505,411.575,0,‘’);

– Griphon of black Knight before battle start
DELETE FROM creature_template WHERE entry=35492;
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName) VALUES (35492, 0, 0, 0, 0, 0, 29842, 0, 0, 0, ‘Black Knight's Skeletal Gryphon’, ‘’, ‘’, 0, 80, 80, 2, 35, 35, 0, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 1, 33554432, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 1048576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 486, 0, 0, ‘’, 0, 3, 15, 1, 0, 0, 0, 0, 0, 0, 0, 164, 1, 0, 0, 0, ‘npc_gr’);
– waypoint script of Griphon of black Knight before battle start
DELETE FROM script_waypoint WHERE entry=35492;
INSERT INTO script_waypoint VALUES
(35492,1,741.067078, 634.471558, 411.569366,0,‘’),
(35492,2,735.726196, 639.247498, 414.725555,0,‘’),
(35492,3,730.187256, 653.250977, 418.913269,0,‘’),
(35492,4,734.517700, 666.071350, 426.259247,0,‘’),
(35492,5,739.638489, 675.339417, 438.226776,0,‘’),
(35492,6,741.833740, 698.797302, 456.986328,0,‘’),
(35492,7,734.647339, 711.084778, 467.165314,0,‘’),
(35492,8,715.388489, 723.820862, 470.333588,0,‘’),
(35492,9,687.178711, 730.140503, 470.569336,0,‘’);

– Spectators (main character of each faction)
Thrall - NPC - World of Warcraft Thrall
Garrosh Hellscream - NPC - World of Warcraft Garrosh Hellscream
King Varian Wrynn - NPC - World of Warcraft King Varian Wrynn
Lady Jaina Proudmoore - NPC - World of Warcraft Lady Jaina Proudmoore
Highlord Tirion Fordring - NPC - World of Warcraft Highlord Tirion Fordring
DELETE FROM creature_template WHERE entry in (34994,34995,34990,34992,34996);
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName) VALUES
(34994, 0, 0, 0, 0, 0, 29591, 0, 29591, 0, ‘Thrall’, ‘Warchief’, ‘’, 0, 83, 83, 2, 35, 35, 0, 1, 1, 3, 1, 1, 0, 1, 2, 2000, 2000, 2, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 568.343, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, ‘’),
(34995, 0, 0, 0, 0, 0, 29592, 0, 29592, 0, ‘Garrosh Hellscream’, ‘Overlord of the Warsong Offensive’, ‘’, 0, 83, 83, 2, 35, 35, 0, 1, 1, 3, 1, 1, 0, 1, 2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, ‘’),
(34990, 0, 0, 0, 0, 0, 29589, 0, 29589, 0, ‘King Varian Wrynn’, ‘King of Stormwind’, ‘’, 0, 83, 83, 2, 35, 35, 0, 1, 1, 3, 1, 1, 0, 1, 2, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 600, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, ‘’),
(34992, 0, 0, 0, 0, 0, 30866, 0, 30866, 0, ‘Lady Jaina Proudmoore’, ‘Ruler of Theramore’, ‘’, 0, 75, 75, 2, 35, 35, 0, 1, 1, 3, 1, 1, 0, 1, 2, 2000, 2000, 8, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 7, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 529.505, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, ‘’),
(34996, 0, 0, 0, 0, 0, 29588, 0, 29588, 0, ‘Highlord Tirion Fordring’, ‘’, ‘’, 0, 83, 83, 2, 35, 35, 0, 1, 1, 1, 435, 653, 0, 163, 2.2, 2000, 2000, 2, 0, 0, 0, 0, 0, 0, 0, 348, 522, 130, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 1000, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘’);

– Announcer for start event
DELETE FROM creature_template WHERE entry in (35589,35604);
INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName) VALUES
(35589, 0, 0, 0, 0, 0, 29894, 0, 0, 0, ‘Jaeren Sunsworn’, ‘’, ‘’, 0, 75, 75, 2, 14, 14, 0, 1, 1, 0, 0, 0, 0, 0, 1, 2000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘npc_anstart’),
(35604, 0, 0, 0, 0, 0, 29893, 0, 0, 0, ‘Arelas Brightstar’, ‘’, ‘’, 0, 75, 75, 2, 14, 14, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘’, 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘npc_anstart’);

– Spawn Announcer in normal/heroic Jaeren Sunsworn - NPC - World of Warcraft
DELETE FROM creature WHERE id IN (35004, 35005);
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,DeathState,MovementType) VALUES
(130961, 35004, 650, 3, 64, 0, 0, 746.626, 618.54, 411.09, 4.63158, 300, 0, 0, 10635, 0, 0, 0),
(130956, 35005, 650, 3, 128, 0, 0, 746.626, 618.54, 411.09, 4.63158, 300, 0, 0, 10635, 0, 0, 0);

/******************************************************* DROP NORMAL & HERO MODE *********************************************************************/
– Trial Of The Champion - The Black Knight Loot [ Normal and Hc ]
– Hc Loot The Black Knight
– link The Black Knight - NPC - World of Warcraft
– Database: CTDB_r63_0.0.7_7815
– by Dantewow1

DELETE FROM creature_loot_template WHERE entry IN (‘12012’,‘35451’);
– HC Loot: The Black Knight
– Link: - The Black Knight - NPC - World of Warcraft
INSERT INTO creature_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES
(‘12012’,‘43102’,‘74’,‘1’,‘0’,‘1’,‘1’), – Frozen Orb
(‘12012’,‘43228’,‘2’,‘1’,‘0’,‘4’,‘4’), – Stone Keeper’s Shard
(‘12012’,‘44990’,‘47’,‘1’,‘0’,‘1’,‘1’), – Champion’s Seal
(‘12012’,‘47241’,‘100’,‘1’,‘0’,‘1’,‘1’), – Emblem of Triumph
(‘12012’,‘47527’,‘15’,‘1’,‘1’,‘1’,‘1’), – Embrace of Madness
(‘12012’,‘47529’,‘14’,‘1’,‘1’,‘1’,‘1’), – Mask of Distant Memory
(‘12012’,‘47560’,‘14’,‘1’,‘2’,‘1’,‘1’), – Boots of the Crackling Flame
(‘12012’,‘47561’,‘14’,‘1’,‘1’,‘1’,‘1’), – Gloves of the Dark Exile
(‘12012’,‘47562’,‘15’,‘1’,‘1’,‘1’,‘1’), – Symbol of Redemption
(‘12012’,‘47563’,‘14’,‘1’,‘1’,‘1’,‘1’), – Girdle of the Dauntless Conqueror
(‘12012’,‘47564’,‘13’,‘1’,‘2’,‘1’,‘1’), – Gaze of the Unknown
(‘12012’,‘47565’,‘13’,‘1’,‘2’,‘1’,‘1’), – Vambraces of Unholy Command
(‘12012’,‘47566’,‘13’,‘1’,‘1’,‘1’,‘1’), – The Warlord’s Depravity
(‘12012’,‘47567’,‘13’,‘1’,‘2’,‘1’,‘1’), – Gauntlets of Revelation
(‘12012’,‘47568’,‘13’,‘1’,‘2’,‘1’,‘1’), – True-aim Long Rifle
(‘12012’,‘47569’,‘13’,‘1’,‘2’,‘1’,‘1’), – Spectral Kris
(‘12012’,‘48418’,‘-100’,‘1’,‘0’,‘1’,‘1’), – Fragment of the Black Knight’s Soul
(‘12012’,‘49682’,‘13’,‘1’,‘2’,‘1’,‘1’), – Black Knight’s Rondel
(‘12012’,‘34057’,‘0.3’,‘1’,‘0’,‘1’,‘1’); – Abyss Crystal

– Normal Loot: The Black Knight
– Link: The Black Knight - NPC - World of Warcraft
INSERT INTO creature_loot_template (entry,item,ChanceOrQuestChance,lootmode,groupid,mincountOrRef,maxcount) VALUES
(‘35451’,‘43228’,‘28’,‘1’,‘0’,‘3’,‘3’), – Stone Keeper’s Shard
(‘35451’,‘47215’,‘16’,‘1’,‘2’,‘1’,‘1’), – Tears of the Vanquished
(‘35451’,‘47216’,‘16’,‘1’,‘2’,‘1’,‘1’), – The Black Heart
(‘35451’,‘47220’,‘16’,‘1’,‘1’,‘1’,‘1’), – Helm of the Violent Fray
(‘35451’,‘47221’,‘17’,‘1’,‘1’,‘1’,‘1’), – Shoulderpads of the Infamous Knave
(‘35451’,‘47222’,‘16’,‘1’,‘1’,‘1’,‘1’), – Uruka’s Band of Zeal
(‘35451’,‘47226’,‘16’,‘1’,‘2’,‘1’,‘1’), – Mantle of Inconsolable Fear
(‘35451’,‘47227’,‘16’,‘1’,‘2’,‘1’,‘1’), – Girdle of the Pallid Knight
(‘35451’,‘47228’,‘16’,‘1’,‘1’,‘1’,‘1’), – Leggings of the Bloodless Knight
(‘35451’,‘47229’,‘16’,‘1’,‘2’,‘1’,‘1’), – Girdle of Arrogant Downfall
(‘35451’,‘47230’,‘16’,‘1’,‘1’,‘1’,‘1’), – Handwraps of Surrendered Hope
(‘35451’,‘47231’,‘16’,‘1’,‘1’,‘1’,‘1’), – Belt of Merciless Cruelty
(‘35451’,‘47232’,‘16’,‘1’,‘2’,‘1’,‘1’); – Drape of the Undefeated[/sql][/CODE]
…with a minor changes to work with you latest db. Was very simple. In the future just take a look to db structure, to see where and when dev. team made changes…becouse if you do that, your work will be very easy. Have fun ! /emoticons/default_smile.png

I dindnt test your file in game, becouse i dont use it.

Best Regards

I tried to compile using the old script that I modified with your sql file, but still does not work.

the patch posted by zabustak can not be installed the last core of trinity I’m using and trying to manually-sticky, I realized that the code is basically the same.

Thank you for your help that you are offering me but I just can not run trial of Champion.

Does anyone have the script and a patch SQL that allows the use of trial champion, even if not 100% Blizzard in version 3.3.5?