Ragefeu lvl 80 (3.3.5)

Bonjour , je partage mon premier patch : Ragefeu 80 .

Citation :UPDATE `creature_template` SET modelid_1='2007', modelid_2='0', modelid_3='0', modelid_4='0', name='Bazzalan', subname='', minlevel='81', maxlevel='81', minhealth='600000', maxhealth='600000', minmana='0', maxmana='0', armor='10000', faction_A='554', faction_H='554', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='1000', maxdmg='3000', dmgschool='0', attackpower='1000', baseattacktime='2500', family='0', type='7', type_flags='4', lootid='11519', resistance1='0', resistance2='200', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='14873', spell2='5277', spell3='0', spell4='0', mingold='3000084', maxgold='5000084', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11519';

DELETE FROM `npc_vendor` WHERE entry='11519';

DELETE FROM `creature_loot_template` WHERE entry='11519';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11519, 37179, 23, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11519, 37634, 35, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11519, 37220, 14, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11519, 37291, 49, 1, 1);

UPDATE `creature_template` SET modelid_1='11429', modelid_2='0', modelid_3='0', modelid_4='0', name='Jergosh the Invoker', subname='', minlevel='83', maxlevel='83', minhealth='900000', maxhealth='900000', minmana='60000', maxmana='60000', armor='15000', faction_A='554', faction_H='554', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='2500', maxdmg='5000', dmgschool='5', attackpower='150', baseattacktime='2300', family='0', type='7', type_flags='4', lootid='11518', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='200', resistance6='0', spell1='5484', spell2='27243', spell3='689', spell4='50796', mingold='10000083', maxgold='15000083', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11518';

DELETE FROM `npc_vendor` WHERE entry='11518';

DELETE FROM `creature_loot_template` WHERE entry='11518';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11518, 39242, 100, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11518, 39397, 50, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11518, 37653, 100, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (11518, 40700, 15, 1, 1);

UPDATE `creature_template` SET modelid_1='11611', modelid_2='0', modelid_3='0', modelid_4='0', name='Oggleflint', subname='Ragefire Chieftain', minlevel='80', maxlevel='80', minhealth='350000', maxhealth='3500000', minmana='0', maxmana='0', armor='30000', faction_A='14', faction_H='14', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='1500', maxdmg='3000', dmgschool='0', attackpower='8000', baseattacktime='2000', family='0', type='7', type_flags='4', lootid='4', resistance1='50', resistance2='50', resistance3='50', resistance4='50', resistance5='50', resistance6='50', spell1='40505', spell2='772', spell3='1680', spell4='20230', mingold='2000084', maxgold='2000084', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11517';

DELETE FROM `npc_vendor` WHERE entry='11517';

DELETE FROM `creature_loot_template` WHERE entry='4';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (4, 39379, 13, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (4, 37734, 23, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (4, 37872, 14, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (4, 37723, 100, 1, 1);

UPDATE `creature_template` SET modelid_1='7970', modelid_2='0', modelid_3='0', modelid_4='0', name='Taragaman the Hungerer', subname='', minlevel='83', maxlevel='83', minhealth='850000', maxhealth='850000', minmana='0', maxmana='0', armor='35000', faction_A='554', faction_H='554', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='1500', maxdmg='5000', dmgschool='0', attackpower='6000', baseattacktime='3000', family='0', type='7', type_flags='4', lootid='2', resistance1='0', resistance2='200', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='11970', spell2='18072', spell3='2136', spell4='642', mingold='15000084', maxgold='16777215', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11520';

DELETE FROM `npc_vendor` WHERE entry='11520';

DELETE FROM `creature_loot_template` WHERE entry='2';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (2, 37685, 20, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (2, 37232, 100, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (2, 37397, 15, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (2, 39295, 50, 1, 1);

UPDATE `creature_template` SET modelid_1='11610', modelid_2='0', modelid_3='0', modelid_4='0', name='Ragefire Shaman', subname='', minlevel='80', maxlevel='80', minhealth='62000', maxhealth='62000', minmana='23000', maxmana='23000', armor='12800', faction_A='14', faction_H='14', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='100', maxdmg='1500', dmgschool='0', attackpower='3000', baseattacktime='3000', family='0', type='7', type_flags='0', lootid='1', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='9532', spell2='11986', spell3='0', spell4='0', mingold='200049', maxgold='1000049', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11319';

DELETE FROM `npc_vendor` WHERE entry='11319';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

UPDATE `creature_template` SET modelid_1='11438', modelid_2='11440', modelid_3='11439', modelid_4='11441', name='Searing Blade Warlock', subname='', minlevel='78', maxlevel='80', minhealth='50000', maxhealth='50000', minmana='20000', maxmana='20000', armor='5000', faction_A='554', faction_H='554', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='500', maxdmg='2500', dmgschool='0', attackpower='200', baseattacktime='2000', family='0', type='7', type_flags='0', lootid='1', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='12746', spell2='20791', spell3='0', spell4='0', mingold='500049', maxgold='1500049', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11324';

DELETE FROM `npc_vendor` WHERE entry='11324';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

UPDATE `creature_template` SET modelid_1='2075', modelid_2='0', modelid_3='0', modelid_4='0', name='Molten Elemental', subname='', minlevel='78', maxlevel='80', minhealth='50000', maxhealth='100000', minmana='0', maxmana='0', armor='20000', faction_A='834', faction_H='834', npcflag='0', speed_walk='1.55556', speed_run='1.14286', scale='1', rank='1', mindmg='500', maxdmg='2500', dmgschool='0', attackpower='1000', baseattacktime='2000', family='0', type='4', type_flags='0', lootid='1', resistance1='0', resistance2='75', resistance3='75', resistance4='75', resistance5='75', resistance6='75', spell1='0', spell2='0', spell3='0', spell4='0', mingold='500000', maxgold='1500000', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11321';

DELETE FROM `npc_vendor` WHERE entry='11321';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

UPDATE `creature_template` SET modelid_1='11010', modelid_2='0', modelid_3='0', modelid_4='0', name='Earthborer', subname='', minlevel='78', maxlevel='80', minhealth='40000', maxhealth='90000', minmana='0', maxmana='0', armor='6000', faction_A='14', faction_H='14', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='200', maxdmg='1500', dmgschool='0', attackpower='2000', baseattacktime='2000', family='42', type='1', type_flags='8191', lootid='1', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='1978', spell2='0', spell3='0', spell4='0', mingold='500000', maxgold='1500000', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11320';

DELETE FROM `npc_vendor` WHERE entry='11320';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

UPDATE `creature_template` SET modelid_1='11430', modelid_2='11432', modelid_3='11431', modelid_4='11433', name='Searing Blade Enforcer', subname='', minlevel='78', maxlevel='80', minhealth='50000', maxhealth='75000', minmana='0', maxmana='0', armor='30000', faction_A='554', faction_H='554', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='300', maxdmg='1500', dmgschool='0', attackpower='3000', baseattacktime='2000', family='0', type='7', type_flags='0', lootid='1', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='8242', spell2='46968', spell3='12809', spell4='0', mingold='500049', maxgold='1500049', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11323';

DELETE FROM `npc_vendor` WHERE entry='11323';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

UPDATE `creature_template` SET modelid_1='11609', modelid_2='0', modelid_3='0', modelid_4='0', name='Ragefire Trogg', subname='', minlevel='78', maxlevel='80', minhealth='35000', maxhealth='55000', minmana='0', maxmana='0', armor='20000', faction_A='14', faction_H='14', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='200', maxdmg='1500', dmgschool='0', attackpower='6000', baseattacktime='2000', family='0', type='7', type_flags='0', lootid='1', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='0', resistance6='0', spell1='11976', spell2='0', spell3='0', spell4='0', mingold='200049', maxgold='1500049', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11318';

DELETE FROM `npc_vendor` WHERE entry='11318';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

UPDATE `creature_template` SET modelid_1='11434', modelid_2='11436', modelid_3='11435', modelid_4='11437', name='Searing Blade Cultist', subname='', minlevel='78', maxlevel='80', minhealth='35000', maxhealth='60000', minmana='30000', maxmana='45000', armor='660', faction_A='554', faction_H='554', npcflag='0', speed_walk='1', speed_run='1.14286', scale='1', rank='1', mindmg='300', maxdmg='2500', dmgschool='5', attackpower='6', baseattacktime='2000', family='0', type='7', type_flags='0', lootid='1', resistance1='0', resistance2='0', resistance3='0', resistance4='0', resistance5='200', resistance6='0', spell1='18266', spell2='69211', spell3='0', spell4='0', mingold='200049', maxgold='1000049', MovementType='1', InhabitType='3', flags_extra='0' WHERE entry='11322';

DELETE FROM `npc_vendor` WHERE entry='11322';

DELETE FROM `creature_loot_template` WHERE entry='1';

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33447, 5, 1, 1);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 33470, 100, 1, 10);

INSERT INTO creature_loot_template (`entry`, `item`, `ChanceOrQuestChance`, `mincountOrRef`, `maxcount`) VALUES (1, 37771, 1, 1, 1);

je ne prend pas mais merci comme même du partage

Bonjour,

Possible d'éditer et d'utiliser les balises :
[code =sql]
[/code]
(Sans l'espace)

Histoire que ton post soit rétrécit ?
Merci du partage en tout cas.