[SQL]NPC Class Trainers - TrinityCore 3.3.5a

wallan

Laron

WoWCore

7 participantes

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

[SQL]NPC Class Trainers - TrinityCore 3.3.5aSeg 20 Ago 2012 - 2:22

Class Trainers 100%.

IDs
Death Knight Trainer - 350000
Druid Trainer - 350001
Hunter Trainer - 350002
Mage Trainer - 350003
Paladin Trainer - 350004
Priest Trainer - 350005
Rogue Trainer - 350006
Shaman Trainer - 350007
Warlock Trainer - 350008
Warrior Trainer - 350009

Código:


/* Creatures */
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`, `HoverHeight`, `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('350009','0','0','0','0','0','24036','0','0','0','|CFFC79C6EWarrior Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','1','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','0');
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`, `HoverHeight`, `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('350008','0','0','0','0','0','24035','0','0','0','|CFF9482C9Warlock Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','9','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','0');
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`, `HoverHeight`, `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('350007','0','0','0','0','0','24034','0','0','0','|CFF0070DEShaman Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','7','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','3','1','1','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','0');
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`, `HoverHeight`, `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('350006','0','0','0','0','0','23777','0','0','0','|CFFFFF569Rogue Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','4','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','0');
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`, `HoverHeight`, `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('350005','0','0','0','0','0','24033','0','0','0','|CFFFFFFFFPriest Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','5','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','0');
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`, `HoverHeight`, `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('350004','0','0','0','0','0','24032','0','0','0','|CFFF58CBAPaladin Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','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','3','1','1','1','1','0','0','0','0','0','0','0','0','1','0','0','0','0','0');
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`, `HoverHeight`, `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('350003','0','0','0','0','0','24031','0','0','0','|CFF69CCF0Mage Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','8','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','0');
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`, `HoverHeight`, `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('350002','0','0','0','0','0','24030','0','0','0','|CFFABD473Hunter Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','3','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','0');
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`, `HoverHeight`, `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('350001','0','0','0','0','0','24029','0','0','0','|CFFFF7D0ADruid Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','11','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','0');
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`, `HoverHeight`, `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('350000','0','0','0','0','0','28516','0','0','0','|CFFC41F3BDeath Knight Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','6','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','0');


/* Trainer ID */
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
('300000','-200019','0','0','0','0'),
('300001','-200006','0','0','0','0'),
('300001','-200005','0','0','0','0'),
('300001','5487','1700','0','0','10'),
('300002','-200014','0','0','0','0'),
('300002','-200013','0','0','0','0'),
('300003','-200008','0','0','0','0'),
('300003','-200007','0','0','0','0'),
('300004','-200004','0','0','0','0'),
('300004','-200003','0','0','0','0'),
('300005','-200012','0','0','0','0'),
('300005','-200011','0','0','0','0'),
('300006','-200016','0','0','0','0'),
('300006','-200015','0','0','0','0'),
('300007','-200018','0','0','0','0'),
('300007','-200017','0','0','0','0'),
('300008','-200010','0','0','0','0'),
('300008','-200009','0','0','0','0'),
('300009','-200002','0','0','0','0'),
('300009','-200001','0','0','0','0');

Se curtiu clique no +rep, só assim terei mais um motivo para continuar postando.

Até!

Última edição por mthsena em Qui 4 Out 2012 - 13:54, editado 2 vez(es)

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSeg 20 Ago 2012 - 9:03

+ rep cara

gostei muito!

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aDom 9 Set 2012 - 22:42

cara os npc nao tem as spell pra treinar!!!!!!!!

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSex 28 Set 2012 - 23:15

Olá,
Eu adicionei ele no meu servidor, porem só vem os NPC, não tem skill nenhuma para treinar nos NPC =)

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSex 28 Set 2012 - 23:35

A ultima parte n seria assim?

Código:

/* Trainer ID */
INSERT INTO `npc_trainer` (`entry`,`spell`,`spellcost`,`reqskill`,`reqskillvalue`,`reqlevel`) VALUES 
('350000','-200019','0','0','0','0'),
('350001','-200006','0','0','0','0'),
('350001','-200005','0','0','0','0'),
('350001','5487','1700','0','0','10'),
('350002','-200014','0','0','0','0'),
('350002','-200013','0','0','0','0'),
('350003','-200008','0','0','0','0'),
('350003','-200007','0','0','0','0'),
('350004','-200004','0','0','0','0'),
('350004','-200003','0','0','0','0'),
('350005','-200012','0','0','0','0'),
('350005','-200011','0','0','0','0'),
('350006','-200016','0','0','0','0'),
('350006','-200015','0','0','0','0'),
('350007','-200018','0','0','0','0'),
('350007','-200017','0','0','0','0'),
('350008','-200010','0','0','0','0'),
('350008','-200009','0','0','0','0'),
('350009','-200002','0','0','0','0'),
('350009','-200001','0','0','0','0');

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSáb 29 Set 2012 - 0:52

É isso, é só dar dump na sql completa. não está aparecendo as spells porque vocês estão esquecendo do `npc_trainer` no final da query.

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSáb 26 Out 2013 - 16:46

SQL Error: Unknown column 'equipment_id' in 'field list'

Isso e facil Resolver !!Sáb 26 Out 2013 - 19:24

WDBVerified pra traz ate chegar em equipment_id vao dar 5 casinhas !!
awe vc conta tbem do final do parenteses para traz 5 casinhas !!

quando chegar vc vai deletar assim= `equipment_id`, com virgula no final
e numero que tiver do final do parenteses para traz 5 casinhas vc deleta assim= '0',

Entao vai ficar assim !!

Código:

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`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`,  `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES('350009','0','0','0','0','0','24036','0','0','0','|CFFC79C6EWarrior Trainer','aurorawow.servegame.com',NULL,'0','80','80','0','35','35','49','1','1.14286','1','3','500','5000','0','0','1','0','0','1','0','0','0','0','0','1','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');

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5a

Tópicos semelhantes

[SQL]GM Vendor - TrinityCore 3.3.5a
[TrinityCore]NPC Reagents
[SQL]SeasonTier 10 - TrinityCore 3.3.5a
Patch Transmogrification TrinityCore
TrinityCore * * Anticheat**

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]NPC Class Trainers - TrinityCore 3.3.5a

description[SQL]NPC Class Trainers - TrinityCore 3.3.5aSeg 20 Ago 2012 - 2:22

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSeg 20 Ago 2012 - 9:03

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5aDom 9 Set 2012 - 22:42

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSex 28 Set 2012 - 23:15

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSex 28 Set 2012 - 23:35

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSáb 29 Set 2012 - 0:52

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSáb 26 Out 2013 - 16:46

descriptionIsso e facil Resolver !!Sáb 26 Out 2013 - 19:24

descriptionRe: [SQL]NPC Class Trainers - TrinityCore 3.3.5a

[SQL]NPC Class Trainers - TrinityCore 3.3.5aSeg 20 Ago 2012 - 2:22

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSeg 20 Ago 2012 - 9:03

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aDom 9 Set 2012 - 22:42

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSex 28 Set 2012 - 23:15

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSex 28 Set 2012 - 23:35

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSáb 29 Set 2012 - 0:52

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5aSáb 26 Out 2013 - 16:46

Isso e facil Resolver !!Sáb 26 Out 2013 - 19:24

Re: [SQL]NPC Class Trainers - TrinityCore 3.3.5a