 |
|
| | | Autor | Mensagem |
|---|
#Nerd
Admin
Mensagens : 123
Reputacao : 10357
Agradescido : 2
Data de inscrição : 07/08/2010
Idade : 28
Localização : Games Trinyon
 |  Assunto: Npcs 3.3.5a  Dom Ago 08, 2010 6:31 am | |
| Encontrei este SQL em um outro fórum na internet.
Está disponível para ArcEmu, MaNGOS e Trinity.
SQL Incluídos:
- Citação :
800000 - Jewelry
800001 - Cloth & Leather Armor
800002 - Plate & Mail Armor
800003 - Cloaks
800004 - Misc & Quest items
Download:
para Arcemu
para MaNGOS
para Trinity
para Trinity (txt) (abra o arquivo de texto e copie tudo para sua db pelo Quice ou Navicat).
Como:
1. baixe
2. abra com o Navicat/Quice
3. execute
4. aproveite!
- Código:
-
Insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800001', "Cloth & Leather Armor Vendor", "", '', '0', '7', '0', '1','31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800001', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800000', "Jewelry Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800000', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800004', "Misc & Quest items Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800004', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800002', "Plate & Mail Armor Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800002', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800003', "Cloaks Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800003', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800004','54653','0'),
('800004','54651','0'),
('800004','53510','0'),
('800004','52563','0'),
('800004','52706','0'),
('800004','54215','0'),
('800004','52276','0'),
('800004','53637','0'),
('800004','52541','0'),
('800004','52566','0'),
('800004','52731','0'),
('800004','52709','0'),
('800004','52565','0'),
('800004','52562','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800003','53115','0'),
('800003','54556','0'),
('800003','53489','0'),
('800003','54583','0'),
('800003','54617','0'),
('800003','53097','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800002','53129','0'),
('800002','54579','0'),
('800002','53121','0'),
('800002','54565','0'),
('800002','53111','0'),
('800002','54564','0'),
('800002','53487','0'),
('800002','54586','0'),
('800002','53112','0'),
('800002','54559','0'),
('800002','53125','0'),
('800002','54578','0'),
('800002','53113','0'),
('800002','54566','0'),
('800002','53488','0'),
('800002','54587','0'),
('800002','53127','0'),
('800002','54577','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800001','53118','0'),
('800001','54562','0'),
('800001','53117','0'),
('800001','54560','0'),
('800001','53114','0'),
('800001','54561','0'),
('800001','53134','0'),
('800001','54584','0'),
('800001','53126','0'),
('800001','54580','0'),
('800001','53486','0'),
('800001','54582','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800000','53103','0'),
('800000','54557','0'),
('800000','53132','0'),
('800000','54581','0'),
('800000','53116','0'),
('800000','54563','0'),
('800000','53110','0'),
('800000','54567','0'),
('800000','53490','0'),
('800000','54585','0'),
('800000','53133','0'),
('800000','54576','0'),
('800000','54572','0'),
('800000','54588','0'),
('800000','54573','0'),
('800000','54589','0'),
('800000','54571','0'),
('800000','54591','0'),
('800000','54569','0'),
('800000','54590','0');
Espero que gostem!
Créditos ~fathir ~ pelo código Hades ~ por postar |
|  | | kakashi
Moderador World of Warcraft
Mensagens : 4
Reputacao : 4
Agradescido : 1
Data de inscrição : 07/08/2010
| | Assunto: Re: Npcs 3.3.5a Dom Ago 08, 2010 2:18 pm | |
| - #Nerd escreveu:
- Encontrei este SQL em um outro fórum na internet.
Está disponível para ArcEmu, MaNGOS e Trinity.
SQL Incluídos:
- Citação :
800000 - Jewelry
800001 - Cloth & Leather Armor
800002 - Plate & Mail Armor
800003 - Cloaks
800004 - Misc & Quest items
Download:
para Arcemu
para MaNGOS
para Trinity
para Trinity (txt) (abra o arquivo de texto e copie tudo para sua db pelo Quice ou Navicat).
Como:
1. baixe
2. abra com o Navicat/Quice
3. execute
4. aproveite!
- Código:
-
Insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800001', "Cloth & Leather Armor Vendor", "", '', '0', '7', '0', '1','31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800001', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800000', "Jewelry Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800000', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800004', "Misc & Quest items Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800004', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800002', "Plate & Mail Armor Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800002', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800003', "Cloaks Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800003', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800004','54653','0'),
('800004','54651','0'),
('800004','53510','0'),
('800004','52563','0'),
('800004','52706','0'),
('800004','54215','0'),
('800004','52276','0'),
('800004','53637','0'),
('800004','52541','0'),
('800004','52566','0'),
('800004','52731','0'),
('800004','52709','0'),
('800004','52565','0'),
('800004','52562','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800003','53115','0'),
('800003','54556','0'),
('800003','53489','0'),
('800003','54583','0'),
('800003','54617','0'),
('800003','53097','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800002','53129','0'),
('800002','54579','0'),
('800002','53121','0'),
('800002','54565','0'),
('800002','53111','0'),
('800002','54564','0'),
('800002','53487','0'),
('800002','54586','0'),
('800002','53112','0'),
('800002','54559','0'),
('800002','53125','0'),
('800002','54578','0'),
('800002','53113','0'),
('800002','54566','0'),
('800002','53488','0'),
('800002','54587','0'),
('800002','53127','0'),
('800002','54577','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800001','53118','0'),
('800001','54562','0'),
('800001','53117','0'),
('800001','54560','0'),
('800001','53114','0'),
('800001','54561','0'),
('800001','53134','0'),
('800001','54584','0'),
('800001','53126','0'),
('800001','54580','0'),
('800001','53486','0'),
('800001','54582','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800000','53103','0'),
('800000','54557','0'),
('800000','53132','0'),
('800000','54581','0'),
('800000','53116','0'),
('800000','54563','0'),
('800000','53110','0'),
('800000','54567','0'),
('800000','53490','0'),
('800000','54585','0'),
('800000','53133','0'),
('800000','54576','0'),
('800000','54572','0'),
('800000','54588','0'),
('800000','54573','0'),
('800000','54589','0'),
('800000','54571','0'),
('800000','54591','0'),
('800000','54569','0'),
('800000','54590','0');
Espero que gostem!
Créditos ~
fathir ~ pelo código
Hades ~ por postar Eu tbm encontrei isso suahsuahs ia postar |
| | | | #Nerd
Admin
Mensagens : 123
Reputacao : 10357
Agradescido : 2
Data de inscrição : 07/08/2010
Idade : 28
Localização : Games Trinyon
| | Assunto: Re: Npcs 3.3.5a Dom Ago 08, 2010 4:48 pm | |
| É eu axei na CCA , eu vi um cara pedindo vo manda o link pra ele. |
| | | | Conteúdo patrocinado
| | Assunto: Re: Npcs 3.3.5a | |
| |
| | | | |
| Página 1 de 1 | |
| | Permissões neste sub-fórum | Não podes responder a tópicos
| |
| |
| |
|
