PDA

Просмотр полной версии : alchemy trainer problems


telsamat
29.09.2011, 17:13
ytdb 608
core TC from date 29.9.2011

there are no alchemy trainer which are teaching us grandmaster alchemy

fix for this

DELETE FROM `npc_trainer` where spell=51303;
INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES
(26903, 51303, 350000, 171, 350, 65),
(26951, 51303, 350000, 171, 350, 65),
(26975, 51303, 350000, 171, 350, 65),
(26987, 51303, 350000, 171, 350, 65),
(28703, 51303, 350000, 171, 350, 65),
(33588, 51303, 350000, 171, 350, 65);

YuruY
29.09.2011, 19:02
33 trainer's?
http://www.wowhead.com/spell=51304#taught-by-npc

telsamat
29.09.2011, 19:40
I dont know if all 33 because these are datas from cataclysm wowhead, with these which I put here I am sure

NeatElves
29.09.2011, 20:04
Learn spell - http://ru.wowhead.com/spell=51303

Effect 0: Id 36 (SPELL_EFFECT_LEARN_SPELL)
BasePoints = 1
Targets (0, 0) (NO_TARGET, NO_TARGET)
Trigger spell (51304) Алхимия (Великий мастер). Chance = 101
Description: Обучение алхимика приготовлению исключительных зелий по рецептам, рассчитанным на навык вплоть до 450.

Effect 1: Id 44 (SPELL_EFFECT_SKILL_STEP)
BasePoints = 6
Targets (0, 0) (NO_TARGET, NO_TARGET)
EffectMiscValueA = 171

up 608
...
UPDATE `npc_trainer` SET `spell` = 65281 WHERE `spell` = 51304;
...
DELETE FROM `npc_trainer` WHERE `spell` = 51303;
UPDATE `npc_trainer` SET `spell` = 51303 WHERE `spell` = 65281;
...

You do understand the principle of trainer?

telsamat
29.09.2011, 22:29
you can delete it