Bgames
Olá visitante! Seja bem vindo ao nosso fórum!

Para você ter total acesso ao nosso fórum é preciso que você se cadastre.

Cadastre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!

npc treiner todas raças e treina mont . treina tudo

Ver o tópico anterior Ver o tópico seguinte Ir em baixo

npc treiner todas raças e treina mont . treina tudo

Mensagem por carlos antonio em Sab 15 Out 2011 - 12:38

-- 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`,`equipment_id`,`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
22931, -- modelid1
0, -- modelid2
0, -- modelid3
0, -- modelid4
'Deckard Cain', -- name
'Trainer Master', -- 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, -- equipment_id
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

carlos antonio


Mensagens : 60
Pontos : 188

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por carlos antonio em Sab 15 Out 2011 - 12:39

pasei dificuldade pra achar masi achei ta ae quem quiser ver o id e 90001

carlos antonio


Mensagens : 60
Pontos : 188

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por xljonathanlx em Sab 15 Out 2011 - 12:58

vc pode me esplicar como eu coloco isso no server?

xljonathanlx


Mensagens : 26
Pontos : 94

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por carlos antonio em Sab 15 Out 2011 - 13:01

vc que me encino cara

carlos antonio


Mensagens : 60
Pontos : 188

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por carlos antonio em Sab 15 Out 2011 - 13:02

do mesmo modo que coloco no npc de teleport

carlos antonio


Mensagens : 60
Pontos : 188

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por xljonathanlx em Sab 15 Out 2011 - 13:07

hmm
entao eu tenho ki coloca isso dentro dum bloco de notas e dps faser

o dump do arquivo ne ?

mais qual e a numeraçao do npc vc sabe ?

xljonathanlx


Mensagens : 26
Pontos : 94

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por carlos antonio em Sab 15 Out 2011 - 13:18

sim n 90001

carlos antonio


Mensagens : 60
Pontos : 188

Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por carlos antonio em Dom 16 Out 2011 - 15:04

minha primeira ++++++++ neh

carlos antonio


Mensagens : 60
Pontos : 188

Ver perfil do usuário

Voltar ao Topo Ir em baixo

O autor desta mensagem foi removido do fórum - Ver a mensagem

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por BackStap em Qui 15 Dez 2011 - 15:00

Tópico postado na área Incorreta.

Movido de:
:: MMORPG :: World of Warcraft :: WOW [ Servidores ] :: Repacks e Instaladores ::
Para:
:: MMORPG :: World of Warcraft :: WOW [ Servidores ] :: Script's

Sempre postem os tópicos na área correta
-Backstap

BackStap


Mensagens : 1929
Pontos : 5948
Evolução : 4


Ver perfil do usuário http://Hamachi bgames.com.br, senha:123321

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por kaskato em Sab 16 Jun 2012 - 10:26

vou tentar adicionar este npc no meu ele funciona em trinity ? :??:

kaskato


Mensagens : 14
Pontos : 28

Ver perfil do usuário http://www.gkhosting.com.br

Voltar ao Topo Ir em baixo

Re: npc treiner todas raças e treina mont . treina tudo

Mensagem por Conteúdo patrocinado Hoje à(s) 11:12


Conteúdo patrocinado


Voltar ao Topo Ir em baixo

Ver o tópico anterior Ver o tópico seguinte Voltar ao Topo


 
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum