[SQL][Download] NPC Trainer Tudo

4 participantes

BGames :: Jogos :: World of Warcraft :: WoW | Server Files :: SQL Querys

[SQL][Download] NPC Trainer TudoSeg 14 Abr 2014 - 15:55

Bom Galera, eu achei um script na net faz um tempo já, se não me engano foi no ac-web, e gostaria de compartilhar com vocês. Seguem as informações abaixo. ( Testei hoje e funcionou )

Para adicionar o npc trainer all digite : escreveu:

Código:
.npc add 90001

Você pode adicionar o npc no seu servidor de duas formas. baixando o arquivo que irei deixar aqui nesse tópico para download ou indo no truice e colocando o seguinte script que deixarei aqui embaixo.

Codigo Para por no Truice.

Código:

-- Reference class to add some missing spells you get from quest and some others.[size=12][/size]
SET @Deathknight :=90001;[size=12][/size]
SET @Druid :=90001; -- Adding missing spell you get from quest.[size=12][/size]
SET @Shaman :=90001; -- Adding missing spell you get from quest.[size=12][/size]
SET @Hunter :=90001; -- Adding missing spell you get from quest.[size=12][/size]
SET @Mage :=90001; -- Adding missing spell you get from quest.[size=12][/size]
SET @Warlock :=90001; -- Adding missing spell you get from quest.[size=12][/size]
SET @Warrior :=90001; -- Adding missing spell you get from quest.[size=12][/size]
SET @GMspells :=90001;[size=12][/size]
SET @Skills :=90001;[size=12][/size]
SET @Trainer :=90001;[size=12][/size]
[size=12][/size]
-- Clean Trainer before inserting new NPC,spells & skills.[size=12][/size]
DELETE FROM `creature` WHERE `id`=@Trainer;[size=12][/size]
DELETE FROM `creature_template` WHERE `entry`=@Trainer;[size=12][/size]
DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;[size=12][/size]
[size=12][/size]
-- Create Trainer NPC[size=12][/size]
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_walk`,`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`,`Armor_mod`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`)VALUES[size=12][/size]
(@Trainer,        -- entry[size=12][/size]
0,                -- difficulty_entry_1[size=12][/size]
0,                -- difficulty_entry_2[size=12][/size]
0,                -- difficulty_entry_3[size=12][/size]
0,                -- KillCredit1[size=12][/size]
0,                -- KillCredit2[size=12][/size]
25541,            -- modelid1[size=12][/size]
0,                -- modelid2[size=12][/size]
0,                -- modelid3[size=12][/size]
0,                -- modelid4[size=12][/size]
'Trainer Master', -- name[size=12][/size]
'',               -- subname[size=12][/size]
'',               -- IconeName[size=12][/size]
0,                -- gossip_menu_id[size=12][/size]
80,               -- minlevel[size=12][/size]
80,               -- maxlevel[size=12][/size]
0,                -- exp[size=12][/size]
35,               -- faction[size=12][/size]
51,               -- npcflag[size=12][/size]
1,                -- speed_walk[size=12][/size]
1,                -- speed_run[size=12][/size]
1,                -- scale[size=12][/size]
0,                -- rank[size=12][/size]
1755,             -- mindmg[size=12][/size]
1755,             -- maxdmg[size=12][/size]
0,                -- dmgschool[size=12][/size]
1504,             -- attackpower[size=12][/size]
1,                -- dmg_multiplier[size=12][/size]
1500,             -- baseattacktime[size=12][/size]
0,                -- rangeattacktime[size=12][/size]
2,                -- unit_class[size=12][/size]
0,                -- unit_flags[size=12][/size]
0,                -- dynamicflags[size=12][/size]
0,                -- family[size=12][/size]
2,                -- trainer_type[size=12][/size]
0,                -- trainer_spell[size=12][/size]
0,                -- trainer_class[size=12][/size]
0,                -- trainer_race[size=12][/size]
0,                -- minrangedmg[size=12][/size]
0,                -- maxrangedmg[size=12][/size]
0,                -- rangedattackpower[size=12][/size]
7,                -- type[size=12][/size]
0,                -- type_flags[size=12][/size]
0,                -- lootid[size=12][/size]
0,                -- pickpocketloot[size=12][/size]
0,                -- skinloot[size=12][/size]
0,                -- resistance1[size=12][/size]
0,                -- resistance2[size=12][/size]
0,                -- resistance3[size=12][/size]
0,                -- resistance4[size=12][/size]
0,                -- resistance5[size=12][/size]
0,                -- resistance6[size=12][/size]
0,                -- spell1[size=12][/size]
0,                -- spell2[size=12][/size]
0,                -- spell3[size=12][/size]
0,                -- spell4[size=12][/size]
0,                -- spell5[size=12][/size]
0,                -- spell6[size=12][/size]
0,                -- spell7[size=12][/size]
0,                -- spell8[size=12][/size]
0,                -- PetSpellDataId[size=12][/size]
0,                -- VehicleId[size=12][/size]
0,                -- mingold[size=12][/size]
0,                -- maxgold[size=12][/size]
'',               -- AIName[size=12][/size]
0,                -- MovementType[size=12][/size]
3,                -- InhabitType[size=12][/size]
1,                -- Health_mod[size=12][/size]
1,                -- Mana_mod[size=12][/size]
1,                -- Armor_mod[size=12][/size]
0,                -- RacialLeader[size=12][/size]
0,                -- questItem1[size=12][/size]
0,                -- questItem2[size=12][/size]
0,                -- questItem3[size=12][/size]
0,                -- questItem4[size=12][/size]
0,                -- questItem5[size=12][/size]
0,                -- questItem6[size=12][/size]
0,                -- movementId[size=12][/size]
1,                -- RegenHealth[size=12][/size]
0,                -- mechanic_immune_mask[size=12][/size]
0,                -- flags_extra[size=12][/size]
'',               -- ScriptName[size=12][/size]
1);               -- WDBVerified[size=12][/size]
[size=12][/size]
-- Make Trainer mounted (Comment this part if you dont want him mounted)[size=12][/size]
DELETE FROM `creature_template_addon` WHERE `entry`=@Trainer;[size=12][/size]
INSERT INTO `creature_template_addon`(`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES [size=12][/size]
(@Trainer,0,24725,0,4096,0,NULL);[size=12][/size]
[size=12][/size]
-- Insert spells to trainer[size=12][/size]
INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES[size=12][/size]
(@Trainer,-200001), -- Warrior-Lowlevel[size=12][/size]
(@Trainer,-200002), -- Warrior-Highlevel[size=12][/size]
(@Trainer,-200003), -- Paladin-Lowlevel[size=12][/size]
(@Trainer,-200004), -- Paladin-Highlevel[size=12][/size]
(@Trainer,-200005), -- Druid-Lowlevel[size=12][/size]
(@Trainer,-200006), -- Druid-Highlevel[size=12][/size]
(@Trainer,-200007), -- Mage-Lowlevel[size=12][/size]
(@Trainer,-200008), -- Mage-Highlevel[size=12][/size]
(@Trainer,-200009), -- Warlock-Lowlevel[size=12][/size]
(@Trainer,-200010), -- Warlock-Highlevel[size=12][/size]
(@Trainer,-200011), -- Priest-Lowlevel[size=12][/size]
(@Trainer,-200012), -- Priest-Highlevel[size=12][/size]
(@Trainer,-200013), -- Hunter-Lowlevel[size=12][/size]
(@Trainer,-200014), -- Hunter-Highlevel[size=12][/size]
(@Trainer,-200015), -- Rogue-Lowlevel[size=12][/size]
(@Trainer,-200016), -- Rogue-Highlevel[size=12][/size]
(@Trainer,-200017), -- Shaman-Lowlevel[size=12][/size]
(@Trainer,-200018); -- Shaman-Highlevel[size=12][/size]
-- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by anyclass)[size=12][/size]
[size=12][/size]
-- DeathKnight Spells[size=12][/size]
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES [size=12][/size]
(@Deathknight,50977,0,0,0,55), -- Death Gate[size=12][/size]
(@Deathknight,53428,0,0,0,55), -- Runeforging[size=12][/size]
(@Deathknight,49998,5600,0,0,56), -- Death Strike Rank 1[size=12][/size]
(@Deathknight,50842,5600,0,0,56), -- Pestilence[size=12][/size]
(@Deathknight,46584,5600,0,0,56), -- Raise Dead[size=12][/size]
(@Deathknight,48263,5700,0,0,57), -- Frost Presence[size=12][/size]
(@Deathknight,47528,5700,0,0,57), -- Mind Freeze[size=12][/size]
(@Deathknight,48721,5800,0,0,58), -- Blood Boil Rank 1[size=12][/size]
(@Deathknight,45524,5800,0,0,58), -- Chains of Ice[size=12][/size]
(@Deathknight,49926,5900,0,0,59), -- Blood Strike Rank 2[size=12][/size]
(@Deathknight,55258,5900,0,0,59), -- Heart Strike Rank 2[size=12][/size]
(@Deathknight,47476,5900,0,0,59), -- Strangulate[size=12][/size]
(@Deathknight,51325,300,0,0,60), -- Corpse Explosion Rank 2[size=12][/size]
(@Deathknight,43265,6000,0,0,60), -- Death and Decay Rank 1[size=12][/size]
-- (@Deathknight,51416,6200,0,0,60), -- Frost Strike Rank 2[size=12][/size]
(@Deathknight,49917,5800,0,0,60), -- Plague Strike Rank 2[size=12][/size]
(@Deathknight,49896,61000,0,0,61), -- Icy Touch Rank 2[size=12][/size]
-- (@Deathknight,49020,61000,0,0,61), -- Obliterate Rank 1[size=12][/size]
-- (@Deathknight,3714,61000,0,0,61), -- Path of Frost[size=12][/size]
(@Deathknight,49892,59000,0,0,62), -- Death Coil Rank 2[size=12][/size]
(@Deathknight,48792,62000,0,0,62), -- Icebound Fortitude[size=12][/size]
(@Deathknight,49999,65000,0,0,63), -- Death Strike Rank 2[size=12][/size]
(@Deathknight,49927,64000,0,0,64), -- Blood Strike Rank3[size=12][/size]
(@Deathknight,45529,64000,0,0,64), -- Blood Tap[size=12][/size]
(@Deathknight,55259,3200,0,0,64), -- Heart Strike Rank 3[size=12][/size]
(@Deathknight,56222,65000,0,0,65), -- Dark Command[size=12][/size]
-- (@Deathknight,51417,3250,0,0,65), -- Frost Strike Rank 3[size=12][/size]
-- (@Deathknight,57330,65000,0,0,65), -- Horn of Winter Rank 1[size=12][/size]
(@Deathknight,49918,65000,0,0,65), -- Plague Strike Rank 3[size=12][/size]
(@Deathknight,49939,66000,0,0,66), -- Blood Boil Rank 2[size=12][/size]
(@Deathknight,48743,66000,0,0,66), -- Death Pact[size=12][/size]
(@Deathknight,49936,68000,0,0,67), -- Death and Decay Rank 2[size=12][/size]
(@Deathknight,49903,67000,0,0,67), -- Icy Touch Rank 3[size=12][/size]
-- (@Deathknight,51423,67000,0,0,67), -- Obliterate Rank 2[size=12][/size]
-- (@Deathknight,56815,67000,0,0,67), -- Rune Strike[size=12][/size]
(@Deathknight,55265,18000,0,0,67), -- Scourge Strike Rank 2[size=12][/size]
(@Deathknight,48707,68000,0,0,68), -- Anti-Magic Shell[size=12][/size]
(@Deathknight,49893,68000,0,0,68), -- Death Coil Rank 3[size=12][/size]
(@Deathknight,49928,69000,0,0,69), -- Blood Strike Rank 4[size=12][/size]
(@Deathknight,55260,3450,0,0,69), -- Heart Strike Rank 4[size=12][/size]
(@Deathknight,51326,18000,0,0,70), -- Corpse Explosion Rank 3[size=12][/size]
(@Deathknight,45463,63000,0,0,70), -- Death Strike Rank 3[size=12][/size]
-- (@Deathknight,51418,18000,0,0,70), -- Frost Strike Rank 4[size=12][/size]
-- (@Deathknight,51409,3350,0,0,70), -- Howling Blast Rank 2[size=12][/size]
(@Deathknight,49919,360000,0,0,70), -- Plague strike Rank 4[size=12][/size]
(@Deathknight,48265,360000,0,0,70), -- Unholy Presence[size=12][/size]
(@Deathknight,49940,360000,0,0,72), -- Blood Boil Rank 3[size=12][/size]
(@Deathknight,61999,360000,0,0,72), -- Raise Ally[size=12][/size]
(@Deathknight,49937,360000,0,0,73), -- Death and Decay Rank 3[size=12][/size]
(@Deathknight,49904,360000,0,0,73), -- Icy Touch Rank 4[size=12][/size]
-- (@Deathknight,51424,360000,0,0,73), -- Obliterate Rank 3[size=12][/size]
(@Deathknight,55270,18000,0,0,73), -- Scourge Strike Rank 3[size=12][/size]
(@Deathknight,49929,360000,0,0,74), -- Blood Strike Rank 5[size=12][/size]
(@Deathknight,55261,18000,0,0,74), -- Heart Strike Rank 5[size=12][/size]
(@Deathknight,51327,18000,0,0,75), -- Corpse Explosion Rank 4[size=12][/size]
(@Deathknight,49923,360000,0,0,75), -- Death Strike Rank 4[size=12][/size]
(@Deathknight,47568,360000,0,0,75), -- Empower Rune Weapon[size=12][/size]
-- (@Deathknight,51419,18000,0,0,75), -- Frost Strike Rank 5[size=12][/size]
-- (@Deathknight,57623,360000,0,0,75), -- Horn of Winter Rank 2[size=12][/size]
-- (@Deathknight,51410,18000,0,0,75), -- Howling Blast Rank 3[size=12][/size]
(@Deathknight,49920,360000,0,0,75), -- Plague Strike Rank 5[size=12][/size]
(@Deathknight,49894,360000,0,0,76), -- Death Coil Rank 4[size=12][/size]
(@Deathknight,49941,360000,0,0,78), -- Blood Boil Rank 4[size=12][/size]
(@Deathknight,49909,360000,0,0,78), -- Icy Touch Rank 5[size=12][/size]
-- (@Deathknight,51425,360000,0,0,79), -- Obliterate Rank 4[size=12][/size]
(@Deathknight,55271,18000,0,0,79), -- Scourge Strike Rank 4[size=12][/size]
(@Deathknight,42650,360000,0,0,80), -- Army of the Dead[size=12][/size]
(@Deathknight,49930,360000,0,0,80), -- Blood Strike Rank 6[size=12][/size]
(@Deathknight,51328,18000,0,0,80), -- Corpse Explosion Rank 5[size=12][/size]
(@Deathknight,49895,360000,0,0,80), -- Death Coil Rank 5[size=12][/size]
(@Deathknight,49924,360000,0,0,80), -- Death Strike Rank 5[size=12][/size]
(@Deathknight,49938,360000,0,0,80), -- Death and Decay Rank 4[size=12][/size]
-- (@Deathknight,55268,18000,0,0,80), -- Frost Strike Rank 6[size=12][/size]
(@Deathknight,55262,18000,0,0,80), -- Heart Strike Rank 6[size=12][/size]
-- (@Deathknight,51411,18000,0,0,80), -- Howling Blast Rank 4[size=12][/size]
(@Deathknight,49921,360000,0,0,80), -- Plague Strike Rank 6[size=12][/size]
-- Rune Forging[size=12][/size]
(@Deathknight,54447,5700,0,0,57), -- Rune of Spellbreaking[size=12][/size]
(@Deathknight,53342,5700,0,0,57), -- Rune of Spellshattering[size=12][/size]
(@Deathknight,53331,6000,0,0,60), -- Rune of Lichbane[size=12][/size]
(@Deathknight,54446,68000,0,0,63), -- Rune of Swordbreaking[size=12][/size]
(@Deathknight,53323,63000,0,0,63), -- Rune of Swordshattering[size=12][/size]
(@Deathknight,53344,360000,0,0,70), -- Rune of the Fallen Crusader[size=12][/size]
(@Deathknight,62158,360000,0,0,72); -- Rune of the Stoneskin Gargoyle[size=12][/size]
[size=12][/size]
-- Missing spells you get from quest.[size=12][/size]
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES [size=12][/size]
(@Druid,5487,0,0,0,10), -- Bear Form[size=12][/size]
(@Shaman,8071,0,0,0,4), -- Stoneskin Totem Rank 1[size=12][/size]
(@Shaman,3599,0,0,0,10), -- Searing Totem Rank 1[size=12][/size]
(@Shaman,5394,0,0,0,20), -- Healing Stream Totem Rank 1[size=12][/size]
(@Hunter,883,0,0,0,10), -- Call Pet[size=12][/size]
(@Hunter,2641,0,0,0,10), -- Dismiss Pet[size=12][/size]
(@Hunter,6991,0,0,0,10), -- Feed Pet[size=12][/size]
(@Hunter,982,0,0,0,10), -- Revive Pet[size=12][/size]
(@Hunter,1515,0,0,0,10), -- Tame Beast[size=12][/size]
(@Mage,61305,0,0,0,60), -- Polymorph (Black Cat)[size=12][/size]
(@Mage,28272,0,0,0,60), -- Polymorph (Pig)[size=12][/size]
(@Mage,61721,0,0,0,60), -- Polymorph (Rabbit)[size=12][/size]
(@Mage,61780,0,0,0,60), -- Polymorph (Turkey)[size=12][/size]
(@Mage,28271,0,0,0,60), -- Polymorph (Turtle)[size=12][/size]
(@Mage,61316,0,0,0,80), -- Dalaran Brillance[size=12][/size]
(@Mage,61024,0,0,0,80), -- Dalaran Intellect[size=12][/size]
(@Warlock,697,0,0,0,10), -- Summon Voidwalker[size=12][/size]
(@Warlock,712,0,0,0,20), -- Summon Succubus[size=12][/size]
(@Warlock,691,0,0,0,30), -- Summon Felhunter[size=12][/size]
(@Warlock,1122,0,0,0,50), -- Inferno[size=12][/size]
(@Warlock,18540,0,0,0,60), -- Ritual of Doom[size=12][/size]
(@Warrior,71,0,0,0,10), -- Defensive Stance[size=12][/size]
(@Warrior,7386,0,0,0,10), -- Sunder Armor[size=12][/size]
(@Warrior,355,0,0,0,10), -- Taunt[size=12][/size]
(@Warrior,2458,0,0,0,30); -- Berserker Stance[size=12][/size]
[size=12][/size]
-- GM Spells (Need to be level 81 to learn)[size=12][/size]
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES [size=12][/size]
(@GMspells,1908,0,0,0,81), -- Uber Heal Over Time[size=12][/size]
(@GMspells,35912,0,0,0,81); -- Master Buff[size=12][/size]
[size=12][/size]
-- Skills[size=12][/size]
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES [size=12][/size]
(@Skills,33388,40000,0,0,20), -- Apprentice Riding[size=12][/size]
(@Skills,33391,500000,33388,0,40), -- Journeyman Riding[size=12][/size]
(@Skills,34090,2500000,33391,0,60), -- Expert Riding[size=12][/size]
(@Skills,34091,50000000,34090,0,70), -- Artisan Riding[size=12][/size]
(@Skills,54197,10000000,34090,0,77), -- Cold Weather Flying[size=12][/size]
(@Skills,196,10000,0,0,1), -- One-Handed Axes[size=12][/size]
(@Skills,197,10000,0,0,1), -- Two-Handed Axes[size=12][/size]
(@Skills,198,10000,0,0,1), -- One-Handed Maces[size=12][/size]
(@Skills,199,10000,0,0,1), -- Two-Handed Maces[size=12][/size]
(@Skills,200,10000,0,0,1), -- Polearms[size=12][/size]
(@Skills,201,10000,0,0,1), -- One-Handed Swords[size=12][/size]
(@Skills,202,10000,0,0,1), -- Two-Handed Swords[size=12][/size]
(@Skills,227,10000,0,0,1), -- Staves[size=12][/size]
(@Skills,264,10000,0,0,1), -- Bows[size=12][/size]
(@Skills,266,10000,0,0,1), -- Guns[size=12][/size]
(@Skills,1180,10000,0,0,1), -- Daggers[size=12][/size]
(@Skills,2567,10000,0,0,1), -- Throwns[size=12][/size]
(@Skills,5011,10000,0,0,1), -- Crossbows[size=12][/size]
(@Skills,15590,10000,0,0,1), -- Fists[size=12][/size]
(@Skills,8737,10000,0,0,40), -- Mail Armor[size=12][/size]
(@Skills,750,10000,0,0,40); -- Plate Armor

Ou baixando o arquivo .sql que deixarie para download aqui ↓

Download

Prints :

Creditos : (não lembro nome do criador)

Última edição por tudoloko em Qui 12 Jun 2014 - 23:29, editado 2 vez(es) (Motivo da edição : Título)

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 1:10

Não pega as skills das classes... apenas as de armas, montarias e gms :/ o que eu faço?!

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 7:43

O código está inconsistente, nem funfa mais nas novas versões da TrinityCore.
E outra, já existe o mesmo tópico aqui no Fórum, mas também está desatualizado, então aqui está um atualizado:

Código:

-- Reference class to add some missing spells you get from quest and some others.
SET @Deathknight :=90001;
SET @Druid :=90001; -- Adding missing spell you get from quest.
SET @Shaman :=90001; -- Adding missing spell you get from quest.
SET @Hunter :=90001; -- Adding missing spell you get from quest.
SET @Mage :=90001; -- Adding missing spell you get from quest.
SET @Warlock :=90001; -- Adding missing spell you get from quest.
SET @Warrior :=90001; -- Adding missing spell you get from quest.
SET @GMspells :=90001;
SET @Skills :=90001;
SET @Trainer :=90001;

-- Clean Trainer before inserting new NPC,spells & skills.
DELETE FROM `creature` WHERE `id`=@Trainer;
DELETE FROM `creature_template` WHERE `entry`=@Trainer;
DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;

-- Create Trainer NPC
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_walk`,`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`,`Armor_mod`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
(@Trainer,        -- entry
0,                -- difficulty_entry_1
0,                -- difficulty_entry_2
0,                -- difficulty_entry_3
0,                -- KillCredit1
0,                -- KillCredit2
25541,            -- modelid1
0,                -- modelid2
0,                -- modelid3
0,                -- modelid4
'Trainer Master', -- name
'',               -- subname
'',               -- IconeName
0,                -- gossip_menu_id
80,               -- minlevel
80,               -- maxlevel
0,                -- exp
35,               -- faction_A
35,               -- faction_h
51,               -- npcflag
1,                -- speed_walk
1,                -- speed_run
1,                -- scale
0,                -- rank
1755,             -- mindmg
1755,             -- maxdmg
0,                -- dmgschool
1504,             -- attackpower
1,                -- dmg_multiplier
1500,             -- baseattacktime
0,                -- rangeattacktime
2,                -- unit_class
0,                -- unit_flags
0,                -- dynamicflags
0,                -- family
2,                -- trainer_type
0,                -- trainer_spell
0,                -- trainer_class
0,                -- trainer_race
0,                -- minrangedmg
0,                -- maxrangedmg
0,                -- rangedattackpower
7,                -- type
0,                -- type_flags
0,                -- lootid
0,                -- pickpocketloot
0,                -- skinloot
0,                -- resistance1
0,                -- resistance2
0,                -- resistance3
0,                -- resistance4
0,                -- resistance5
0,                -- resistance6
0,                -- spell1
0,                -- spell2
0,                -- spell3
0,                -- spell4
0,                -- spell5
0,                -- spell6
0,                -- spell7
0,                -- spell8
0,                -- PetSpellDataId
0,                -- VehicleId
0,                -- mingold
0,                -- maxgold
'',               -- AIName
0,                -- MovementType
3,                -- InhabitType
1,                -- Health_mod
1,                -- Mana_mod
1,                -- Armor_mod
0,                -- RacialLeader
0,                -- questItem1
0,                -- questItem2
0,                -- questItem3
0,                -- questItem4
0,                -- questItem5
0,                -- questItem6
0,                -- movementId
1,                -- RegenHealth
0,                -- mechanic_immune_mask
0,                -- flags_extra
'',               -- ScriptName
1);               -- WDBVerified

-- Make Trainer mounted (Comment this part if you dont want him mounted)
DELETE FROM `creature_template_addon` WHERE `entry`=@Trainer;
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
(@Trainer,0,24725,0,4096,0,NULL);

-- Insert spells to trainer
INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES
(@Trainer,-200001), -- Warrior-Lowlevel
(@Trainer,-200002), -- Warrior-Highlevel
(@Trainer,-200003), -- Paladin-Lowlevel
(@Trainer,-200004), -- Paladin-Highlevel
(@Trainer,-200005), -- Druid-Lowlevel
(@Trainer,-200006), -- Druid-Highlevel
(@Trainer,-200007), -- Mage-Lowlevel
(@Trainer,-200008), -- Mage-Highlevel
(@Trainer,-200009), -- Warlock-Lowlevel
(@Trainer,-200010), -- Warlock-Highlevel
(@Trainer,-200011), -- Priest-Lowlevel
(@Trainer,-200012), -- Priest-Highlevel
(@Trainer,-200013), -- Hunter-Lowlevel
(@Trainer,-200014), -- Hunter-Highlevel
(@Trainer,-200015), -- Rogue-Lowlevel
(@Trainer,-200016), -- Rogue-Highlevel
(@Trainer,-200017), -- Shaman-Lowlevel
(@Trainer,-200018); -- Shaman-Highlevel
-- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by any class)

-- DeathKnight Spells
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Deathknight,50977,0,0,0,55), -- Death Gate
(@Deathknight,53428,0,0,0,55), -- Runeforging
(@Deathknight,49998,5600,0,0,56), -- Death Strike Rank 1
(@Deathknight,50842,5600,0,0,56), -- Pestilence
(@Deathknight,46584,5600,0,0,56), -- Raise Dead
(@Deathknight,48263,5700,0,0,57), -- Frost Presence
(@Deathknight,47528,5700,0,0,57), -- Mind Freeze
(@Deathknight,48721,5800,0,0,58), -- Blood Boil Rank 1
(@Deathknight,45524,5800,0,0,58), -- Chains of Ice
(@Deathknight,49926,5900,0,0,59), -- Blood Strike Rank 2
(@Deathknight,55258,5900,0,0,59), -- Heart Strike Rank 2
(@Deathknight,47476,5900,0,0,59), -- Strangulate
(@Deathknight,51325,300,0,0,60), -- Corpse Explosion Rank 2
(@Deathknight,43265,6000,0,0,60), -- Death and Decay Rank 1
-- (@Deathknight,51416,6200,0,0,60), -- Frost Strike Rank 2
(@Deathknight,49917,5800,0,0,60), -- Plague Strike Rank 2
(@Deathknight,49896,61000,0,0,61), -- Icy Touch Rank 2
-- (@Deathknight,49020,61000,0,0,61), -- Obliterate Rank 1
-- (@Deathknight,3714,61000,0,0,61), -- Path of Frost
(@Deathknight,49892,59000,0,0,62), -- Death Coil Rank 2
(@Deathknight,48792,62000,0,0,62), -- Icebound Fortitude
(@Deathknight,49999,65000,0,0,63), -- Death Strike Rank 2
(@Deathknight,49927,64000,0,0,64), -- Blood Strike Rank3
(@Deathknight,45529,64000,0,0,64), -- Blood Tap
(@Deathknight,55259,3200,0,0,64), -- Heart Strike Rank 3
(@Deathknight,56222,65000,0,0,65), -- Dark Command
-- (@Deathknight,51417,3250,0,0,65), -- Frost Strike Rank 3
-- (@Deathknight,57330,65000,0,0,65), -- Horn of Winter Rank 1
(@Deathknight,49918,65000,0,0,65), -- Plague Strike Rank 3
(@Deathknight,49939,66000,0,0,66), -- Blood Boil Rank 2
(@Deathknight,48743,66000,0,0,66), -- Death Pact
(@Deathknight,49936,68000,0,0,67), -- Death and Decay Rank 2
(@Deathknight,49903,67000,0,0,67), -- Icy Touch Rank 3
-- (@Deathknight,51423,67000,0,0,67), -- Obliterate Rank 2
-- (@Deathknight,56815,67000,0,0,67), -- Rune Strike
(@Deathknight,55265,18000,0,0,67), -- Scourge Strike Rank 2
(@Deathknight,48707,68000,0,0,68), -- Anti-Magic Shell
(@Deathknight,49893,68000,0,0,68), -- Death Coil Rank 3
(@Deathknight,49928,69000,0,0,69), -- Blood Strike Rank 4
(@Deathknight,55260,3450,0,0,69), -- Heart Strike Rank 4
(@Deathknight,51326,18000,0,0,70), -- Corpse Explosion Rank 3
(@Deathknight,45463,63000,0,0,70), -- Death Strike Rank 3
-- (@Deathknight,51418,18000,0,0,70), -- Frost Strike Rank 4
-- (@Deathknight,51409,3350,0,0,70), -- Howling Blast Rank 2
(@Deathknight,49919,360000,0,0,70), -- Plague strike Rank 4
(@Deathknight,48265,360000,0,0,70), -- Unholy Presence
(@Deathknight,49940,360000,0,0,72), -- Blood Boil Rank 3
(@Deathknight,61999,360000,0,0,72), -- Raise Ally
(@Deathknight,49937,360000,0,0,73), -- Death and Decay Rank 3
(@Deathknight,49904,360000,0,0,73), -- Icy Touch Rank 4
-- (@Deathknight,51424,360000,0,0,73), -- Obliterate Rank 3
(@Deathknight,55270,18000,0,0,73), -- Scourge Strike Rank 3
(@Deathknight,49929,360000,0,0,74), -- Blood Strike Rank 5
(@Deathknight,55261,18000,0,0,74), -- Heart Strike Rank 5
(@Deathknight,51327,18000,0,0,75), -- Corpse Explosion Rank 4
(@Deathknight,49923,360000,0,0,75), -- Death Strike Rank 4
(@Deathknight,47568,360000,0,0,75), -- Empower Rune Weapon
-- (@Deathknight,51419,18000,0,0,75), -- Frost Strike Rank 5
-- (@Deathknight,57623,360000,0,0,75), -- Horn of Winter Rank 2
-- (@Deathknight,51410,18000,0,0,75), -- Howling Blast Rank 3
(@Deathknight,49920,360000,0,0,75), -- Plague Strike Rank 5
(@Deathknight,49894,360000,0,0,76), -- Death Coil Rank 4
(@Deathknight,49941,360000,0,0,78), -- Blood Boil Rank 4
(@Deathknight,49909,360000,0,0,78), -- Icy Touch Rank 5
-- (@Deathknight,51425,360000,0,0,79), -- Obliterate Rank 4
(@Deathknight,55271,18000,0,0,79), -- Scourge Strike Rank 4
(@Deathknight,42650,360000,0,0,80), -- Army of the Dead
(@Deathknight,49930,360000,0,0,80), -- Blood Strike Rank 6
(@Deathknight,51328,18000,0,0,80), -- Corpse Explosion Rank 5
(@Deathknight,49895,360000,0,0,80), -- Death Coil Rank 5
(@Deathknight,49924,360000,0,0,80), -- Death Strike Rank 5
(@Deathknight,49938,360000,0,0,80), -- Death and Decay Rank 4
-- (@Deathknight,55268,18000,0,0,80), -- Frost Strike Rank 6
(@Deathknight,55262,18000,0,0,80), -- Heart Strike Rank 6
-- (@Deathknight,51411,18000,0,0,80), -- Howling Blast Rank 4
(@Deathknight,49921,360000,0,0,80), -- Plague Strike Rank 6
-- Rune Forging
(@Deathknight,54447,5700,0,0,57), -- Rune of Spellbreaking
(@Deathknight,53342,5700,0,0,57), -- Rune of Spellshattering
(@Deathknight,53331,6000,0,0,60), -- Rune of Lichbane
(@Deathknight,54446,68000,0,0,63), -- Rune of Swordbreaking
(@Deathknight,53323,63000,0,0,63), -- Rune of Swordshattering
(@Deathknight,53344,360000,0,0,70), -- Rune of the Fallen Crusader
(@Deathknight,62158,360000,0,0,72); -- Rune of the Stoneskin Gargoyle

-- Missing spells you get from quest.
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Druid,5487,0,0,0,10), -- Bear Form
(@Shaman,8071,0,0,0,4), -- Stoneskin Totem Rank 1
(@Shaman,3599,0,0,0,10), -- Searing Totem Rank 1
(@Shaman,5394,0,0,0,20), -- Healing Stream Totem Rank 1
(@Hunter,883,0,0,0,10), -- Call Pet
(@Hunter,2641,0,0,0,10), -- Dismiss Pet
(@Hunter,6991,0,0,0,10), -- Feed Pet
(@Hunter,982,0,0,0,10), -- Revive Pet
(@Hunter,1515,0,0,0,10), -- Tame Beast
(@Mage,61305,0,0,0,60), -- Polymorph (Black Cat)
(@Mage,28272,0,0,0,60), -- Polymorph (Pig)
(@Mage,61721,0,0,0,60), -- Polymorph (Rabbit)
(@Mage,61780,0,0,0,60), -- Polymorph (Turkey)
(@Mage,28271,0,0,0,60), -- Polymorph (Turtle)
(@Mage,61316,0,0,0,80), -- Dalaran Brillance
(@Mage,61024,0,0,0,80), -- Dalaran Intellect
(@Warlock,697,0,0,0,10), -- Summon Voidwalker
(@Warlock,712,0,0,0,20), -- Summon Succubus
(@Warlock,691,0,0,0,30), -- Summon Felhunter
(@Warlock,1122,0,0,0,50), -- Inferno
(@Warlock,18540,0,0,0,60), -- Ritual of Doom
(@Warrior,71,0,0,0,10), -- Defensive Stance
(@Warrior,7386,0,0,0,10), -- Sunder Armor
(@Warrior,355,0,0,0,10), -- Taunt
(@Warrior,2458,0,0,0,30); -- Berserker Stance

-- GM Spells (Need to be level 81 to learn)
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@GMspells,1908,0,0,0,81), -- Uber Heal Over Time
(@GMspells,35912,0,0,0,81); -- Master Buff

-- Skills
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Skills,33388,40000,0,0,20), -- Apprentice Riding
(@Skills,33391,500000,33388,0,40), -- Journeyman Riding
(@Skills,34090,2500000,33391,0,60), -- Expert Riding
(@Skills,34091,50000000,34090,0,70), -- Artisan Riding
(@Skills,54197,10000000,34090,0,77), -- Cold Weather Flying
(@Skills,196,10000,0,0,1), -- One-Handed Axes
(@Skills,197,10000,0,0,1), -- Two-Handed Axes
(@Skills,198,10000,0,0,1), -- One-Handed Maces
(@Skills,199,10000,0,0,1), -- Two-Handed Maces
(@Skills,200,10000,0,0,1), -- Polearms
(@Skills,201,10000,0,0,1), -- One-Handed Swords
(@Skills,202,10000,0,0,1), -- Two-Handed Swords
(@Skills,227,10000,0,0,1), -- Staves
(@Skills,264,10000,0,0,1), -- Bows
(@Skills,266,10000,0,0,1), -- Guns
(@Skills,1180,10000,0,0,1), -- Daggers
(@Skills,2567,10000,0,0,1), -- Throwns
(@Skills,5011,10000,0,0,1), -- Crossbows
(@Skills,15590,10000,0,0,1), -- Fists
(@Skills,8737,10000,0,0,40), -- Mail Armor
(@Skills,750,10000,0,0,40); -- Plate Armor

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 10:07

Boa Erik. Vou testar e logo te aviso os resultados...
ontem mesmo eu vi as inconsistencias e tentei dar o dump removendo por ex a tabela Equipment_ID porém continuou no erro.

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 21:20

Compilei um Core hoje e a Trinity já fez atualizações, hoje de manhã o Script que eu postei acima funfava, agora já não funfa mais.
Segue abaixo um Script Atualizado

O que mudou?
Antes você tinha que definir o faction_A e faction_h.
Agora, ao invés de 2, é apenas um, o "faction" sem A nem h.

Código:

-- Reference class to add some missing spells you get from quest and some others.
SET @Deathknight :=90001;
SET @Druid :=90001; -- Adding missing spell you get from quest.
SET @Shaman :=90001; -- Adding missing spell you get from quest.
SET @Hunter :=90001; -- Adding missing spell you get from quest.
SET @Mage :=90001; -- Adding missing spell you get from quest.
SET @Warlock :=90001; -- Adding missing spell you get from quest.
SET @Warrior :=90001; -- Adding missing spell you get from quest.
SET @GMspells :=90001;
SET @Skills :=90001;
SET @Trainer :=90001;

-- Clean Trainer before inserting new NPC,spells & skills.
DELETE FROM `creature` WHERE `id`=@Trainer;
DELETE FROM `creature_template` WHERE `entry`=@Trainer;
DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;

-- Create Trainer NPC
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_walk`,`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`,`Armor_mod`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
(@Trainer,        -- entry
0,                -- difficulty_entry_1
0,                -- difficulty_entry_2
0,                -- difficulty_entry_3
0,                -- KillCredit1
0,                -- KillCredit2
25541,            -- modelid1
0,                -- modelid2
0,                -- modelid3
0,                -- modelid4
'Trainer Master', -- name
'',               -- subname
'',               -- IconeName
0,                -- gossip_menu_id
80,               -- minlevel
80,               -- maxlevel
0,                -- exp
35,               -- faction
51,               -- npcflag
1,                -- speed_walk
1,                -- speed_run
1,                -- scale
0,                -- rank
1755,             -- mindmg
1755,             -- maxdmg
0,                -- dmgschool
1504,             -- attackpower
1,                -- dmg_multiplier
1500,             -- baseattacktime
0,                -- rangeattacktime
2,                -- unit_class
0,                -- unit_flags
0,                -- dynamicflags
0,                -- family
2,                -- trainer_type
0,                -- trainer_spell
0,                -- trainer_class
0,                -- trainer_race
0,                -- minrangedmg
0,                -- maxrangedmg
0,                -- rangedattackpower
7,                -- type
0,                -- type_flags
0,                -- lootid
0,                -- pickpocketloot
0,                -- skinloot
0,                -- resistance1
0,                -- resistance2
0,                -- resistance3
0,                -- resistance4
0,                -- resistance5
0,                -- resistance6
0,                -- spell1
0,                -- spell2
0,                -- spell3
0,                -- spell4
0,                -- spell5
0,                -- spell6
0,                -- spell7
0,                -- spell8
0,                -- PetSpellDataId
0,                -- VehicleId
0,                -- mingold
0,                -- maxgold
'',               -- AIName
0,                -- MovementType
3,                -- InhabitType
1,                -- Health_mod
1,                -- Mana_mod
1,                -- Armor_mod
0,                -- RacialLeader
0,                -- questItem1
0,                -- questItem2
0,                -- questItem3
0,                -- questItem4
0,                -- questItem5
0,                -- questItem6
0,                -- movementId
1,                -- RegenHealth
0,                -- mechanic_immune_mask
0,                -- flags_extra
'',               -- ScriptName
1);               -- WDBVerified

-- Make Trainer mounted (Comment this part if you dont want him mounted)
DELETE FROM `creature_template_addon` WHERE `entry`=@Trainer;
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
(@Trainer,0,24725,0,4096,0,NULL);

-- Insert spells to trainer
INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES
(@Trainer,-200001), -- Warrior-Lowlevel
(@Trainer,-200002), -- Warrior-Highlevel
(@Trainer,-200003), -- Paladin-Lowlevel
(@Trainer,-200004), -- Paladin-Highlevel
(@Trainer,-200005), -- Druid-Lowlevel
(@Trainer,-200006), -- Druid-Highlevel
(@Trainer,-200007), -- Mage-Lowlevel
(@Trainer,-200008), -- Mage-Highlevel
(@Trainer,-200009), -- Warlock-Lowlevel
(@Trainer,-200010), -- Warlock-Highlevel
(@Trainer,-200011), -- Priest-Lowlevel
(@Trainer,-200012), -- Priest-Highlevel
(@Trainer,-200013), -- Hunter-Lowlevel
(@Trainer,-200014), -- Hunter-Highlevel
(@Trainer,-200015), -- Rogue-Lowlevel
(@Trainer,-200016), -- Rogue-Highlevel
(@Trainer,-200017), -- Shaman-Lowlevel
(@Trainer,-200018); -- Shaman-Highlevel
-- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by any class)

-- DeathKnight Spells
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Deathknight,50977,0,0,0,55), -- Death Gate
(@Deathknight,53428,0,0,0,55), -- Runeforging
(@Deathknight,49998,5600,0,0,56), -- Death Strike Rank 1
(@Deathknight,50842,5600,0,0,56), -- Pestilence
(@Deathknight,46584,5600,0,0,56), -- Raise Dead
(@Deathknight,48263,5700,0,0,57), -- Frost Presence
(@Deathknight,47528,5700,0,0,57), -- Mind Freeze
(@Deathknight,48721,5800,0,0,58), -- Blood Boil Rank 1
(@Deathknight,45524,5800,0,0,58), -- Chains of Ice
(@Deathknight,49926,5900,0,0,59), -- Blood Strike Rank 2
(@Deathknight,55258,5900,0,0,59), -- Heart Strike Rank 2
(@Deathknight,47476,5900,0,0,59), -- Strangulate
(@Deathknight,51325,300,0,0,60), -- Corpse Explosion Rank 2
(@Deathknight,43265,6000,0,0,60), -- Death and Decay Rank 1
-- (@Deathknight,51416,6200,0,0,60), -- Frost Strike Rank 2
(@Deathknight,49917,5800,0,0,60), -- Plague Strike Rank 2
(@Deathknight,49896,61000,0,0,61), -- Icy Touch Rank 2
-- (@Deathknight,49020,61000,0,0,61), -- Obliterate Rank 1
-- (@Deathknight,3714,61000,0,0,61), -- Path of Frost
(@Deathknight,49892,59000,0,0,62), -- Death Coil Rank 2
(@Deathknight,48792,62000,0,0,62), -- Icebound Fortitude
(@Deathknight,49999,65000,0,0,63), -- Death Strike Rank 2
(@Deathknight,49927,64000,0,0,64), -- Blood Strike Rank3
(@Deathknight,45529,64000,0,0,64), -- Blood Tap
(@Deathknight,55259,3200,0,0,64), -- Heart Strike Rank 3
(@Deathknight,56222,65000,0,0,65), -- Dark Command
-- (@Deathknight,51417,3250,0,0,65), -- Frost Strike Rank 3
-- (@Deathknight,57330,65000,0,0,65), -- Horn of Winter Rank 1
(@Deathknight,49918,65000,0,0,65), -- Plague Strike Rank 3
(@Deathknight,49939,66000,0,0,66), -- Blood Boil Rank 2
(@Deathknight,48743,66000,0,0,66), -- Death Pact
(@Deathknight,49936,68000,0,0,67), -- Death and Decay Rank 2
(@Deathknight,49903,67000,0,0,67), -- Icy Touch Rank 3
-- (@Deathknight,51423,67000,0,0,67), -- Obliterate Rank 2
-- (@Deathknight,56815,67000,0,0,67), -- Rune Strike
(@Deathknight,55265,18000,0,0,67), -- Scourge Strike Rank 2
(@Deathknight,48707,68000,0,0,68), -- Anti-Magic Shell
(@Deathknight,49893,68000,0,0,68), -- Death Coil Rank 3
(@Deathknight,49928,69000,0,0,69), -- Blood Strike Rank 4
(@Deathknight,55260,3450,0,0,69), -- Heart Strike Rank 4
(@Deathknight,51326,18000,0,0,70), -- Corpse Explosion Rank 3
(@Deathknight,45463,63000,0,0,70), -- Death Strike Rank 3
-- (@Deathknight,51418,18000,0,0,70), -- Frost Strike Rank 4
-- (@Deathknight,51409,3350,0,0,70), -- Howling Blast Rank 2
(@Deathknight,49919,360000,0,0,70), -- Plague strike Rank 4
(@Deathknight,48265,360000,0,0,70), -- Unholy Presence
(@Deathknight,49940,360000,0,0,72), -- Blood Boil Rank 3
(@Deathknight,61999,360000,0,0,72), -- Raise Ally
(@Deathknight,49937,360000,0,0,73), -- Death and Decay Rank 3
(@Deathknight,49904,360000,0,0,73), -- Icy Touch Rank 4
-- (@Deathknight,51424,360000,0,0,73), -- Obliterate Rank 3
(@Deathknight,55270,18000,0,0,73), -- Scourge Strike Rank 3
(@Deathknight,49929,360000,0,0,74), -- Blood Strike Rank 5
(@Deathknight,55261,18000,0,0,74), -- Heart Strike Rank 5
(@Deathknight,51327,18000,0,0,75), -- Corpse Explosion Rank 4
(@Deathknight,49923,360000,0,0,75), -- Death Strike Rank 4
(@Deathknight,47568,360000,0,0,75), -- Empower Rune Weapon
-- (@Deathknight,51419,18000,0,0,75), -- Frost Strike Rank 5
-- (@Deathknight,57623,360000,0,0,75), -- Horn of Winter Rank 2
-- (@Deathknight,51410,18000,0,0,75), -- Howling Blast Rank 3
(@Deathknight,49920,360000,0,0,75), -- Plague Strike Rank 5
(@Deathknight,49894,360000,0,0,76), -- Death Coil Rank 4
(@Deathknight,49941,360000,0,0,78), -- Blood Boil Rank 4
(@Deathknight,49909,360000,0,0,78), -- Icy Touch Rank 5
-- (@Deathknight,51425,360000,0,0,79), -- Obliterate Rank 4
(@Deathknight,55271,18000,0,0,79), -- Scourge Strike Rank 4
(@Deathknight,42650,360000,0,0,80), -- Army of the Dead
(@Deathknight,49930,360000,0,0,80), -- Blood Strike Rank 6
(@Deathknight,51328,18000,0,0,80), -- Corpse Explosion Rank 5
(@Deathknight,49895,360000,0,0,80), -- Death Coil Rank 5
(@Deathknight,49924,360000,0,0,80), -- Death Strike Rank 5
(@Deathknight,49938,360000,0,0,80), -- Death and Decay Rank 4
-- (@Deathknight,55268,18000,0,0,80), -- Frost Strike Rank 6
(@Deathknight,55262,18000,0,0,80), -- Heart Strike Rank 6
-- (@Deathknight,51411,18000,0,0,80), -- Howling Blast Rank 4
(@Deathknight,49921,360000,0,0,80), -- Plague Strike Rank 6
-- Rune Forging
(@Deathknight,54447,5700,0,0,57), -- Rune of Spellbreaking
(@Deathknight,53342,5700,0,0,57), -- Rune of Spellshattering
(@Deathknight,53331,6000,0,0,60), -- Rune of Lichbane
(@Deathknight,54446,68000,0,0,63), -- Rune of Swordbreaking
(@Deathknight,53323,63000,0,0,63), -- Rune of Swordshattering
(@Deathknight,53344,360000,0,0,70), -- Rune of the Fallen Crusader
(@Deathknight,62158,360000,0,0,72); -- Rune of the Stoneskin Gargoyle

-- Missing spells you get from quest.
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Druid,5487,0,0,0,10), -- Bear Form
(@Shaman,8071,0,0,0,4), -- Stoneskin Totem Rank 1
(@Shaman,3599,0,0,0,10), -- Searing Totem Rank 1
(@Shaman,5394,0,0,0,20), -- Healing Stream Totem Rank 1
(@Hunter,883,0,0,0,10), -- Call Pet
(@Hunter,2641,0,0,0,10), -- Dismiss Pet
(@Hunter,6991,0,0,0,10), -- Feed Pet
(@Hunter,982,0,0,0,10), -- Revive Pet
(@Hunter,1515,0,0,0,10), -- Tame Beast
(@Mage,61305,0,0,0,60), -- Polymorph (Black Cat)
(@Mage,28272,0,0,0,60), -- Polymorph (Pig)
(@Mage,61721,0,0,0,60), -- Polymorph (Rabbit)
(@Mage,61780,0,0,0,60), -- Polymorph (Turkey)
(@Mage,28271,0,0,0,60), -- Polymorph (Turtle)
(@Mage,61316,0,0,0,80), -- Dalaran Brillance
(@Mage,61024,0,0,0,80), -- Dalaran Intellect
(@Warlock,697,0,0,0,10), -- Summon Voidwalker
(@Warlock,712,0,0,0,20), -- Summon Succubus
(@Warlock,691,0,0,0,30), -- Summon Felhunter
(@Warlock,1122,0,0,0,50), -- Inferno
(@Warlock,18540,0,0,0,60), -- Ritual of Doom
(@Warrior,71,0,0,0,10), -- Defensive Stance
(@Warrior,7386,0,0,0,10), -- Sunder Armor
(@Warrior,355,0,0,0,10), -- Taunt
(@Warrior,2458,0,0,0,30); -- Berserker Stance

-- GM Spells (Need to be level 81 to learn)
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@GMspells,1908,0,0,0,81), -- Uber Heal Over Time
(@GMspells,35912,0,0,0,81); -- Master Buff

-- Skills
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Skills,33388,40000,0,0,20), -- Apprentice Riding
(@Skills,33391,500000,33388,0,40), -- Journeyman Riding
(@Skills,34090,2500000,33391,0,60), -- Expert Riding
(@Skills,34091,50000000,34090,0,70), -- Artisan Riding
(@Skills,54197,10000000,34090,0,77), -- Cold Weather Flying
(@Skills,196,10000,0,0,1), -- One-Handed Axes
(@Skills,197,10000,0,0,1), -- Two-Handed Axes
(@Skills,198,10000,0,0,1), -- One-Handed Maces
(@Skills,199,10000,0,0,1), -- Two-Handed Maces
(@Skills,200,10000,0,0,1), -- Polearms
(@Skills,201,10000,0,0,1), -- One-Handed Swords
(@Skills,202,10000,0,0,1), -- Two-Handed Swords
(@Skills,227,10000,0,0,1), -- Staves
(@Skills,264,10000,0,0,1), -- Bows
(@Skills,266,10000,0,0,1), -- Guns
(@Skills,1180,10000,0,0,1), -- Daggers
(@Skills,2567,10000,0,0,1), -- Throwns
(@Skills,5011,10000,0,0,1), -- Crossbows
(@Skills,15590,10000,0,0,1), -- Fists
(@Skills,8737,10000,0,0,40), -- Mail Armor
(@Skills,750,10000,0,0,40); -- Plate Armor

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 22:13

o erro ainda está presente :/

1 queries executed, 0 success, 1 errors, 0 warnings

Query: INSERT INTO `creature_template` (`entry`,`difficulty_entry_1`,`difficulty_entry_2`,`difficulty_entry_3`,`KillCredit1`,`KillCredi...

Error Code: 1136
Column count doesn't match value count at row 1

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 22:38

Acabei de testar aqui e funfou certinho.

Código:

-- Reference class to add some missing spells you get from quest and some others.
SET @Deathknight :=90001;
SET @Druid :=90001; -- Adding missing spell you get from quest.
SET @Shaman :=90001; -- Adding missing spell you get from quest.
SET @Hunter :=90001; -- Adding missing spell you get from quest.
SET @Mage :=90001; -- Adding missing spell you get from quest.
SET @Warlock :=90001; -- Adding missing spell you get from quest.
SET @Warrior :=90001; -- Adding missing spell you get from quest.
SET @GMspells :=90001;
SET @Skills :=90001;
SET @Trainer :=90001;

-- Clean Trainer before inserting new NPC,spells & skills.
DELETE FROM `creature` WHERE `id`=@Trainer;
DELETE FROM `creature_template` WHERE `entry`=@Trainer;
DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;

-- Create Trainer NPC
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_walk`,`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`,`Armor_mod`,`RacialLeader`,`questItem1`,`questItem2`,`questItem3`,`questItem4`,`questItem5`,`questItem6`,`movementId`,`RegenHealth`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
(@Trainer,        -- entry
0,                -- difficulty_entry_1
0,                -- difficulty_entry_2
0,                -- difficulty_entry_3
0,                -- KillCredit1
0,                -- KillCredit2
25541,            -- modelid1
0,                -- modelid2
0,                -- modelid3
0,                -- modelid4
'Trainer Master', -- name
'',               -- subname
'',               -- IconeName
0,                -- gossip_menu_id
80,               -- minlevel
80,               -- maxlevel
0,                -- exp
35,               -- faction
51,               -- npcflag
1,                -- speed_walk
1,                -- speed_run
1,                -- scale
0,                -- rank
1755,             -- mindmg
1755,             -- maxdmg
0,                -- dmgschool
1504,             -- attackpower
1,                -- dmg_multiplier
1500,             -- baseattacktime
0,                -- rangeattacktime
2,                -- unit_class
0,                -- unit_flags
0,                -- dynamicflags
0,                -- family
2,                -- trainer_type
0,                -- trainer_spell
0,                -- trainer_class
0,                -- trainer_race
0,                -- minrangedmg
0,                -- maxrangedmg
0,                -- rangedattackpower
7,                -- type
0,                -- type_flags
0,                -- lootid
0,                -- pickpocketloot
0,                -- skinloot
0,                -- resistance1
0,                -- resistance2
0,                -- resistance3
0,                -- resistance4
0,                -- resistance5
0,                -- resistance6
0,                -- spell1
0,                -- spell2
0,                -- spell3
0,                -- spell4
0,                -- spell5
0,                -- spell6
0,                -- spell7
0,                -- spell8
0,                -- PetSpellDataId
0,                -- VehicleId
0,                -- mingold
0,                -- maxgold
'',               -- AIName
0,                -- MovementType
3,                -- InhabitType
1,                -- Health_mod
1,                -- Mana_mod
1,                -- Armor_mod
0,                -- RacialLeader
0,                -- questItem1
0,                -- questItem2
0,                -- questItem3
0,                -- questItem4
0,                -- questItem5
0,                -- questItem6
0,                -- movementId
1,                -- RegenHealth
0,                -- mechanic_immune_mask
0,                -- flags_extra
'',               -- ScriptName
1);               -- WDBVerified

-- Make Trainer mounted (Comment this part if you dont want him mounted)
DELETE FROM `creature_template_addon` WHERE `entry`=@Trainer;
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
(@Trainer,0,24725,0,4096,0,NULL);

-- Insert spells to trainer
INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES
(@Trainer,-200001), -- Warrior-Lowlevel
(@Trainer,-200002), -- Warrior-Highlevel
(@Trainer,-200003), -- Paladin-Lowlevel
(@Trainer,-200004), -- Paladin-Highlevel
(@Trainer,-200005), -- Druid-Lowlevel
(@Trainer,-200006), -- Druid-Highlevel
(@Trainer,-200007), -- Mage-Lowlevel
(@Trainer,-200008), -- Mage-Highlevel
(@Trainer,-200009), -- Warlock-Lowlevel
(@Trainer,-200010), -- Warlock-Highlevel
(@Trainer,-200011), -- Priest-Lowlevel
(@Trainer,-200012), -- Priest-Highlevel
(@Trainer,-200013), -- Hunter-Lowlevel
(@Trainer,-200014), -- Hunter-Highlevel
(@Trainer,-200015), -- Rogue-Lowlevel
(@Trainer,-200016), -- Rogue-Highlevel
(@Trainer,-200017), -- Shaman-Lowlevel
(@Trainer,-200018); -- Shaman-Highlevel
-- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by any class)

-- DeathKnight Spells
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Deathknight,50977,0,0,0,55), -- Death Gate
(@Deathknight,53428,0,0,0,55), -- Runeforging
(@Deathknight,49998,5600,0,0,56), -- Death Strike Rank 1
(@Deathknight,50842,5600,0,0,56), -- Pestilence
(@Deathknight,46584,5600,0,0,56), -- Raise Dead
(@Deathknight,48263,5700,0,0,57), -- Frost Presence
(@Deathknight,47528,5700,0,0,57), -- Mind Freeze
(@Deathknight,48721,5800,0,0,58), -- Blood Boil Rank 1
(@Deathknight,45524,5800,0,0,58), -- Chains of Ice
(@Deathknight,49926,5900,0,0,59), -- Blood Strike Rank 2
(@Deathknight,55258,5900,0,0,59), -- Heart Strike Rank 2
(@Deathknight,47476,5900,0,0,59), -- Strangulate
(@Deathknight,51325,300,0,0,60), -- Corpse Explosion Rank 2
(@Deathknight,43265,6000,0,0,60), -- Death and Decay Rank 1
-- (@Deathknight,51416,6200,0,0,60), -- Frost Strike Rank 2
(@Deathknight,49917,5800,0,0,60), -- Plague Strike Rank 2
(@Deathknight,49896,61000,0,0,61), -- Icy Touch Rank 2
-- (@Deathknight,49020,61000,0,0,61), -- Obliterate Rank 1
-- (@Deathknight,3714,61000,0,0,61), -- Path of Frost
(@Deathknight,49892,59000,0,0,62), -- Death Coil Rank 2
(@Deathknight,48792,62000,0,0,62), -- Icebound Fortitude
(@Deathknight,49999,65000,0,0,63), -- Death Strike Rank 2
(@Deathknight,49927,64000,0,0,64), -- Blood Strike Rank3
(@Deathknight,45529,64000,0,0,64), -- Blood Tap
(@Deathknight,55259,3200,0,0,64), -- Heart Strike Rank 3
(@Deathknight,56222,65000,0,0,65), -- Dark Command
-- (@Deathknight,51417,3250,0,0,65), -- Frost Strike Rank 3
-- (@Deathknight,57330,65000,0,0,65), -- Horn of Winter Rank 1
(@Deathknight,49918,65000,0,0,65), -- Plague Strike Rank 3
(@Deathknight,49939,66000,0,0,66), -- Blood Boil Rank 2
(@Deathknight,48743,66000,0,0,66), -- Death Pact
(@Deathknight,49936,68000,0,0,67), -- Death and Decay Rank 2
(@Deathknight,49903,67000,0,0,67), -- Icy Touch Rank 3
-- (@Deathknight,51423,67000,0,0,67), -- Obliterate Rank 2
-- (@Deathknight,56815,67000,0,0,67), -- Rune Strike
(@Deathknight,55265,18000,0,0,67), -- Scourge Strike Rank 2
(@Deathknight,48707,68000,0,0,68), -- Anti-Magic Shell
(@Deathknight,49893,68000,0,0,68), -- Death Coil Rank 3
(@Deathknight,49928,69000,0,0,69), -- Blood Strike Rank 4
(@Deathknight,55260,3450,0,0,69), -- Heart Strike Rank 4
(@Deathknight,51326,18000,0,0,70), -- Corpse Explosion Rank 3
(@Deathknight,45463,63000,0,0,70), -- Death Strike Rank 3
-- (@Deathknight,51418,18000,0,0,70), -- Frost Strike Rank 4
-- (@Deathknight,51409,3350,0,0,70), -- Howling Blast Rank 2
(@Deathknight,49919,360000,0,0,70), -- Plague strike Rank 4
(@Deathknight,48265,360000,0,0,70), -- Unholy Presence
(@Deathknight,49940,360000,0,0,72), -- Blood Boil Rank 3
(@Deathknight,61999,360000,0,0,72), -- Raise Ally
(@Deathknight,49937,360000,0,0,73), -- Death and Decay Rank 3
(@Deathknight,49904,360000,0,0,73), -- Icy Touch Rank 4
-- (@Deathknight,51424,360000,0,0,73), -- Obliterate Rank 3
(@Deathknight,55270,18000,0,0,73), -- Scourge Strike Rank 3
(@Deathknight,49929,360000,0,0,74), -- Blood Strike Rank 5
(@Deathknight,55261,18000,0,0,74), -- Heart Strike Rank 5
(@Deathknight,51327,18000,0,0,75), -- Corpse Explosion Rank 4
(@Deathknight,49923,360000,0,0,75), -- Death Strike Rank 4
(@Deathknight,47568,360000,0,0,75), -- Empower Rune Weapon
-- (@Deathknight,51419,18000,0,0,75), -- Frost Strike Rank 5
-- (@Deathknight,57623,360000,0,0,75), -- Horn of Winter Rank 2
-- (@Deathknight,51410,18000,0,0,75), -- Howling Blast Rank 3
(@Deathknight,49920,360000,0,0,75), -- Plague Strike Rank 5
(@Deathknight,49894,360000,0,0,76), -- Death Coil Rank 4
(@Deathknight,49941,360000,0,0,78), -- Blood Boil Rank 4
(@Deathknight,49909,360000,0,0,78), -- Icy Touch Rank 5
-- (@Deathknight,51425,360000,0,0,79), -- Obliterate Rank 4
(@Deathknight,55271,18000,0,0,79), -- Scourge Strike Rank 4
(@Deathknight,42650,360000,0,0,80), -- Army of the Dead
(@Deathknight,49930,360000,0,0,80), -- Blood Strike Rank 6
(@Deathknight,51328,18000,0,0,80), -- Corpse Explosion Rank 5
(@Deathknight,49895,360000,0,0,80), -- Death Coil Rank 5
(@Deathknight,49924,360000,0,0,80), -- Death Strike Rank 5
(@Deathknight,49938,360000,0,0,80), -- Death and Decay Rank 4
-- (@Deathknight,55268,18000,0,0,80), -- Frost Strike Rank 6
(@Deathknight,55262,18000,0,0,80), -- Heart Strike Rank 6
-- (@Deathknight,51411,18000,0,0,80), -- Howling Blast Rank 4
(@Deathknight,49921,360000,0,0,80), -- Plague Strike Rank 6
-- Rune Forging
(@Deathknight,54447,5700,0,0,57), -- Rune of Spellbreaking
(@Deathknight,53342,5700,0,0,57), -- Rune of Spellshattering
(@Deathknight,53331,6000,0,0,60), -- Rune of Lichbane
(@Deathknight,54446,68000,0,0,63), -- Rune of Swordbreaking
(@Deathknight,53323,63000,0,0,63), -- Rune of Swordshattering
(@Deathknight,53344,360000,0,0,70), -- Rune of the Fallen Crusader
(@Deathknight,62158,360000,0,0,72); -- Rune of the Stoneskin Gargoyle

-- Missing spells you get from quest.
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Druid,5487,0,0,0,10), -- Bear Form
(@Shaman,8071,0,0,0,4), -- Stoneskin Totem Rank 1
(@Shaman,3599,0,0,0,10), -- Searing Totem Rank 1
(@Shaman,5394,0,0,0,20), -- Healing Stream Totem Rank 1
(@Hunter,883,0,0,0,10), -- Call Pet
(@Hunter,2641,0,0,0,10), -- Dismiss Pet
(@Hunter,6991,0,0,0,10), -- Feed Pet
(@Hunter,982,0,0,0,10), -- Revive Pet
(@Hunter,1515,0,0,0,10), -- Tame Beast
(@Mage,61305,0,0,0,60), -- Polymorph (Black Cat)
(@Mage,28272,0,0,0,60), -- Polymorph (Pig)
(@Mage,61721,0,0,0,60), -- Polymorph (Rabbit)
(@Mage,61780,0,0,0,60), -- Polymorph (Turkey)
(@Mage,28271,0,0,0,60), -- Polymorph (Turtle)
(@Mage,61316,0,0,0,80), -- Dalaran Brillance
(@Mage,61024,0,0,0,80), -- Dalaran Intellect
(@Warlock,697,0,0,0,10), -- Summon Voidwalker
(@Warlock,712,0,0,0,20), -- Summon Succubus
(@Warlock,691,0,0,0,30), -- Summon Felhunter
(@Warlock,1122,0,0,0,50), -- Inferno
(@Warlock,18540,0,0,0,60), -- Ritual of Doom
(@Warrior,71,0,0,0,10), -- Defensive Stance
(@Warrior,7386,0,0,0,10), -- Sunder Armor
(@Warrior,355,0,0,0,10), -- Taunt
(@Warrior,2458,0,0,0,30); -- Berserker Stance

-- GM Spells (Need to be level 81 to learn)
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@GMspells,1908,0,0,0,81), -- Uber Heal Over Time
(@GMspells,35912,0,0,0,81); -- Master Buff

-- Skills
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Skills,33388,40000,0,0,20), -- Apprentice Riding
(@Skills,33391,500000,33388,0,40), -- Journeyman Riding
(@Skills,34090,2500000,33391,0,60), -- Expert Riding
(@Skills,34091,50000000,34090,0,70), -- Artisan Riding
(@Skills,54197,10000000,34090,0,77), -- Cold Weather Flying
(@Skills,196,10000,0,0,1), -- One-Handed Axes
(@Skills,197,10000,0,0,1), -- Two-Handed Axes
(@Skills,198,10000,0,0,1), -- One-Handed Maces
(@Skills,199,10000,0,0,1), -- Two-Handed Maces
(@Skills,200,10000,0,0,1), -- Polearms
(@Skills,201,10000,0,0,1), -- One-Handed Swords
(@Skills,202,10000,0,0,1), -- Two-Handed Swords
(@Skills,227,10000,0,0,1), -- Staves
(@Skills,264,10000,0,0,1), -- Bows
(@Skills,266,10000,0,0,1), -- Guns
(@Skills,1180,10000,0,0,1), -- Daggers
(@Skills,2567,10000,0,0,1), -- Throwns
(@Skills,5011,10000,0,0,1), -- Crossbows
(@Skills,15590,10000,0,0,1), -- Fists
(@Skills,8737,10000,0,0,40), -- Mail Armor
(@Skills,750,10000,0,0,40); -- Plate Armor

Re: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 23:55

Basta copiar esse codigo e executar no sqlyog?!
eu executo todos os querys e ao adicionar o npc ele só treina skills, montarias e gm spells... nada de all classes :'(

Re: [SQL][Download] NPC Trainer TudoQui 12 Jun 2014 - 23:30

Valeu eric, Atualizei o tópico, valeu [SQL][Download] NPC Trainer Tudo 3666372071

Re: [SQL][Download] NPC Trainer TudoTer 29 Jul 2014 - 16:40

Tomei liberdade para editar o script e adicionar e fixar algumas coisas [SQL][Download] NPC Trainer Tudo 3666372071

ID: NPC 95000
Adicionei Galinha Instant & Vassoura Instant
Caso alguém queira adicionar algo fale comigo [SQL][Download] NPC Trainer Tudo 3666372071

Código:

-- Reference class to add some missing spells you get from quest and some others.
SET @Deathknight :=95000;
SET @Druid :=95000; -- Adding missing spell you get from quest.
SET @Shaman :=95000; -- Adding missing spell you get from quest.
SET @Hunter :=95000; -- Adding missing spell you get from quest.
SET @Mage :=95000; -- Adding missing spell you get from quest.
SET @Warlock :=95000; -- Adding missing spell you get from quest.
SET @Warrior :=95000; -- Adding missing spell you get from quest.
SET @GMspells :=95000;
SET @Skills :=95000;
SET @Trainer :=95000;

-- Clean Trainer before inserting new NPC,spells & skills.
DELETE FROM `creature` WHERE `id`=@Trainer;
DELETE FROM `creature_template` WHERE `entry`=@Trainer;
DELETE FROM `npc_trainer` WHERE `entry`=@Trainer;

-- Create Trainer NPC
REPLACE 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_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `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`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (@Trainer, 0, 0, 0, 0, 0, 28194, 0, 0, 0, 'Trainer Master', 'WOW-Survival (Pvp/Pve)', '', 0, 80, 80, 0, 35, 35, 81, 1, 1.14286, 1.5, 3, 500, 5000, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 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, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);

-- Insert spells to trainer
INSERT INTO `npc_trainer` (`entry`,`spell`) VALUES
(@Trainer,-200001), -- Warrior-Lowlevel
(@Trainer,-200002), -- Warrior-Highlevel
(@Trainer,-200003), -- Paladin-Lowlevel
(@Trainer,-200004), -- Paladin-Highlevel
(@Trainer,-200005), -- Druid-Lowlevel
(@Trainer,-200006), -- Druid-Highlevel
(@Trainer,-200007), -- Mage-Lowlevel
(@Trainer,-200008), -- Mage-Highlevel
(@Trainer,-200009), -- Warlock-Lowlevel
(@Trainer,-200010), -- Warlock-Highlevel
(@Trainer,-200011), -- Priest-Lowlevel
(@Trainer,-200012), -- Priest-Highlevel
(@Trainer,-200013), -- Hunter-Lowlevel
(@Trainer,-200014), -- Hunter-Highlevel
(@Trainer,-200015), -- Rogue-Lowlevel
(@Trainer,-200016), -- Rogue-Highlevel
(@Trainer,-200017), -- Shaman-Lowlevel
(@Trainer,-200018); -- Shaman-Highlevel
-- (@Trainer,-200019); -- Death Knights-Alllevel (Disable because alot of frost spell available to any class. Remade the DK spells and will remove the one trainable by anyclass)

-- DeathKnight Spells
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Deathknight,50977,0,0,0,55), -- Death Gate
(@Deathknight,53428,0,0,0,55), -- Runeforging
(@Deathknight,49998,5600,0,0,56), -- Death Strike Rank 1
(@Deathknight,50842,5600,0,0,56), -- Pestilence
(@Deathknight,46584,5600,0,0,56), -- Raise Dead
(@Deathknight,48263,5700,0,0,57), -- Frost Presence
(@Deathknight,47528,5700,0,0,57), -- Mind Freeze
(@Deathknight,48721,5800,0,0,58), -- Blood Boil Rank 1
(@Deathknight,45524,5800,0,0,58), -- Chains of Ice
(@Deathknight,49926,5900,0,0,59), -- Blood Strike Rank 2
(@Deathknight,55258,5900,0,0,59), -- Heart Strike Rank 2
(@Deathknight,47476,5900,0,0,59), -- Strangulate
(@Deathknight,51325,300,0,0,60), -- Corpse Explosion Rank 2
(@Deathknight,43265,6000,0,0,60), -- Death and Decay Rank 1
-- (@Deathknight,51416,6200,0,0,60), -- Frost Strike Rank 2
(@Deathknight,49917,5800,0,0,60), -- Plague Strike Rank 2
(@Deathknight,49896,61000,0,0,61), -- Icy Touch Rank 2
-- (@Deathknight,49020,61000,0,0,61), -- Obliterate Rank 1
-- (@Deathknight,3714,61000,0,0,61), -- Path of Frost
(@Deathknight,49892,59000,0,0,62), -- Death Coil Rank 2
(@Deathknight,48792,62000,0,0,62), -- Icebound Fortitude
(@Deathknight,49999,65000,0,0,63), -- Death Strike Rank 2
(@Deathknight,49927,64000,0,0,64), -- Blood Strike Rank3
(@Deathknight,45529,64000,0,0,64), -- Blood Tap
(@Deathknight,55259,3200,0,0,64), -- Heart Strike Rank 3
(@Deathknight,56222,65000,0,0,65), -- Dark Command
-- (@Deathknight,51417,3250,0,0,65), -- Frost Strike Rank 3
-- (@Deathknight,57330,65000,0,0,65), -- Horn of Winter Rank 1
(@Deathknight,49918,65000,0,0,65), -- Plague Strike Rank 3
(@Deathknight,49939,66000,0,0,66), -- Blood Boil Rank 2
(@Deathknight,48743,66000,0,0,66), -- Death Pact
(@Deathknight,49936,68000,0,0,67), -- Death and Decay Rank 2
(@Deathknight,49903,67000,0,0,67), -- Icy Touch Rank 3
-- (@Deathknight,51423,67000,0,0,67), -- Obliterate Rank 2
-- (@Deathknight,56815,67000,0,0,67), -- Rune Strike
(@Deathknight,55265,18000,0,0,67), -- Scourge Strike Rank 2
(@Deathknight,48707,68000,0,0,68), -- Anti-Magic Shell
(@Deathknight,49893,68000,0,0,68), -- Death Coil Rank 3
(@Deathknight,49928,69000,0,0,69), -- Blood Strike Rank 4
(@Deathknight,55260,3450,0,0,69), -- Heart Strike Rank 4
(@Deathknight,51326,18000,0,0,70), -- Corpse Explosion Rank 3
(@Deathknight,45463,63000,0,0,70), -- Death Strike Rank 3
-- (@Deathknight,51418,18000,0,0,70), -- Frost Strike Rank 4
-- (@Deathknight,51409,3350,0,0,70), -- Howling Blast Rank 2
(@Deathknight,49919,360000,0,0,70), -- Plague strike Rank 4
(@Deathknight,48265,360000,0,0,70), -- Unholy Presence
(@Deathknight,49940,360000,0,0,72), -- Blood Boil Rank 3
(@Deathknight,61999,360000,0,0,72), -- Raise Ally
(@Deathknight,49937,360000,0,0,73), -- Death and Decay Rank 3
(@Deathknight,49904,360000,0,0,73), -- Icy Touch Rank 4
-- (@Deathknight,51424,360000,0,0,73), -- Obliterate Rank 3
(@Deathknight,55270,18000,0,0,73), -- Scourge Strike Rank 3
(@Deathknight,49929,360000,0,0,74), -- Blood Strike Rank 5
(@Deathknight,55261,18000,0,0,74), -- Heart Strike Rank 5
(@Deathknight,51327,18000,0,0,75), -- Corpse Explosion Rank 4
(@Deathknight,49923,360000,0,0,75), -- Death Strike Rank 4
(@Deathknight,47568,360000,0,0,75), -- Empower Rune Weapon
-- (@Deathknight,51419,18000,0,0,75), -- Frost Strike Rank 5
-- (@Deathknight,57623,360000,0,0,75), -- Horn of Winter Rank 2
-- (@Deathknight,51410,18000,0,0,75), -- Howling Blast Rank 3
(@Deathknight,49920,360000,0,0,75), -- Plague Strike Rank 5
(@Deathknight,49894,360000,0,0,76), -- Death Coil Rank 4
(@Deathknight,49941,360000,0,0,78), -- Blood Boil Rank 4
(@Deathknight,49909,360000,0,0,78), -- Icy Touch Rank 5
-- (@Deathknight,51425,360000,0,0,79), -- Obliterate Rank 4
(@Deathknight,55271,18000,0,0,79), -- Scourge Strike Rank 4
(@Deathknight,42650,360000,0,0,80), -- Army of the Dead
(@Deathknight,49930,360000,0,0,80), -- Blood Strike Rank 6
(@Deathknight,51328,18000,0,0,80), -- Corpse Explosion Rank 5
(@Deathknight,49895,360000,0,0,80), -- Death Coil Rank 5
(@Deathknight,49924,360000,0,0,80), -- Death Strike Rank 5
(@Deathknight,49938,360000,0,0,80), -- Death and Decay Rank 4
-- (@Deathknight,55268,18000,0,0,80), -- Frost Strike Rank 6
(@Deathknight,55262,18000,0,0,80), -- Heart Strike Rank 6
-- (@Deathknight,51411,18000,0,0,80), -- Howling Blast Rank 4
(@Deathknight,49921,360000,0,0,80), -- Plague Strike Rank 6
-- Rune Forging
(@Deathknight,54447,5700,0,0,57), -- Rune of Spellbreaking
(@Deathknight,53342,5700,0,0,57), -- Rune of Spellshattering
(@Deathknight,53331,6000,0,0,60), -- Rune of Lichbane
(@Deathknight,54446,68000,0,0,63), -- Rune of Swordbreaking
(@Deathknight,53323,63000,0,0,63), -- Rune of Swordshattering
(@Deathknight,53344,360000,0,0,70), -- Rune of the Fallen Crusader
(@Deathknight,62158,360000,0,0,72); -- Rune of the Stoneskin Gargoyle

-- Missing spells you get from quest.
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Druid,5487,0,0,0,10), -- Bear Form
(@Shaman,8071,0,0,0,4), -- Stoneskin Totem Rank 1
(@Shaman,3599,0,0,0,10), -- Searing Totem Rank 1
(@Shaman,5394,0,0,0,20), -- Healing Stream Totem Rank 1
(@Hunter,883,0,0,0,10), -- Call Pet
(@Hunter,2641,0,0,0,10), -- Dismiss Pet
(@Hunter,6991,0,0,0,10), -- Feed Pet
(@Hunter,982,0,0,0,10), -- Revive Pet
(@Hunter,1515,0,0,0,10), -- Tame Beast
(@Mage,61305,0,0,0,60), -- Polymorph (Black Cat)
(@Mage,28272,0,0,0,60), -- Polymorph (Pig)
(@Mage,61721,0,0,0,60), -- Polymorph (Rabbit)
(@Mage,61780,0,0,0,60), -- Polymorph (Turkey)
(@Mage,28271,0,0,0,60), -- Polymorph (Turtle)
(@Mage,61316,0,0,0,80), -- Dalaran Brillance
(@Mage,61024,0,0,0,80), -- Dalaran Intellect
(@Warlock,697,0,0,0,10), -- Summon Voidwalker
(@Warlock,712,0,0,0,20), -- Summon Succubus
(@Warlock,691,0,0,0,30), -- Summon Felhunter
(@Warlock,1122,0,0,0,50), -- Inferno
(@Warlock,18540,0,0,0,60), -- Ritual of Doom
(@Warrior,71,0,0,0,10), -- Defensive Stance
(@Warrior,7386,0,0,0,10), -- Sunder Armor
(@Warrior,355,0,0,0,10), -- Taunt
(@Warrior,2458,0,0,0,30); -- Berserker Stance

-- GM Spells (Need to be level 81 to learn)
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@GMspells,1908,0,0,0,81), -- Uber Heal Over Time
(@GMspells,35912,0,0,0,81); -- Master Buff

-- Skills
INSERT INTO `npc_trainer`(`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
(@Skills,33388,40000,0,0,20), -- Apprentice Riding
(@Skills,33391,500000,33388,0,40), -- Journeyman Riding
(@Skills,34090,2500000,33391,0,60), -- Expert Riding
(@Skills,34091,50000000,34090,0,70), -- Artisan Riding
(@Skills,54197,10000000,34090,0,77), -- Cold Weather Flying
(@Skills,196,10000,0,0,1), -- One-Handed Axes
(@Skills,197,10000,0,0,1), -- Two-Handed Axes
(@Skills,198,10000,0,0,1), -- One-Handed Maces
(@Skills,199,10000,0,0,1), -- Two-Handed Maces
(@Skills,200,10000,0,0,1), -- Polearms
(@Skills,201,10000,0,0,1), -- One-Handed Swords
(@Skills,202,10000,0,0,1), -- Two-Handed Swords
(@Skills,227,10000,0,0,1), -- Staves
(@Skills,264,10000,0,0,1), -- Bows
(@Skills,266,10000,0,0,1), -- Guns
(@Skills,1180,10000,0,0,1), -- Daggers
(@Skills,2567,10000,0,0,1), -- Throwns
(@Skills,5011,10000,0,0,1), -- Crossbows
(@Skills,15590,10000,0,0,1), -- Fists
(@Skills,8737,10000,0,0,40), -- Mail Armor
(@Skills,750,10000,0,0,40); -- Plate Armor
(@Skills,66122,10000,0,0,40); -- Galinha Instant
(@Skills,42683,10000,0,0,40); -- Vassoura Instant

Tópicos semelhantes

NPC Master Trainer
npc trainer prof
Preciso de Trainer's
[Download] Trainer Master
[Resolvido] [Duvida] Script Lich King Controler

Ir para:

Permissões neste sub-fórum

Não podes responder a tópicos

Inicie sessão para responder

Fórum de Desenvolvimento de Jogos e Programação

[SQL][Download] NPC Trainer Tudo

description[SQL][Download] NPC Trainer TudoSeg 14 Abr 2014 - 15:55

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 1:10

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 7:43

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 10:07

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 21:20

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 22:13

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 22:38

descriptionRe: [SQL][Download] NPC Trainer TudoSeg 28 Abr 2014 - 23:55

descriptionRe: [SQL][Download] NPC Trainer TudoQui 12 Jun 2014 - 23:30

descriptionRe: [SQL][Download] NPC Trainer TudoTer 29 Jul 2014 - 16:40