| Autor |
Mesaj |
Raulkiller
Website Team

Data inscrierii: 03/Ian/2008 Mesaje: 95 Localitate: Alba Iulia |
|
UpDate By RauLkiller |
|
Npc: Illidan Legendary
Npc ID; 800001
Have Fun
 |
 |
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (800001, 100, 100, 814, 999999, 999999, 999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
VALUES (800001,"Illidan Legendary","The Twin Blades of Azzinoth",0,7,0,0,0,NULL,21322,21322,1, 1,1,NULL, '');
INSERT INTO vendors (entry, item, amount)
VALUES (800001,32838,0);
INSERT INTO vendors (entry, item, amount)
VALUES (800001,32837,0);
|
Npc: Ragnaros
Npc ID; 800002
 |
 |
INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (800002, 100, 100, 814, 999999, 999999, 999999, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
INSERT INTO creature_names (entry, `name`, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, male_displayid, female_displayid, unknown_float1, unknown_float2, Civilian, Leader, info_str)
VALUES (800002,"Ragnaros","Vendor",0,7,0,0,0,NULL,11121,11121,1, 1,1,NULL, '');
INSERT INTO vendors (entry, item, amount)
VALUES (800002,17204,0);
INSERT INTO vendors (entry, item, amount)
VALUES (800002,17182,0); |
Ultima modificare efectuata Raulkiller la 01/06/2008 02:17, modificat de 4 ori in total |
|
| 27/05/2008 14:09 |
|
 |
Raulkiller
Website Team

Data inscrierii: 03/Ian/2008 Mesaje: 95 Localitate: Alba Iulia |
|
Trainer for Classspells |
|
Trainer for Classspells
Npc Id: 900013
Npc Name: Zulech Knochenfaust
 |
 |
INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('Zulech Knochenfaust', 'Klassentrainer', '', '7', '0', '0', '4385', '0', '0', NULL, '900013');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('60', '60', '1812', '50000', '50000', '100', '1', '16400', '1500', '1500', '7000', '0', '0', '0', '1', '0', '0', '0', '0', '36000', '0', '0', '0', '900013');
INSERT INTO `trainer_defs` VALUES ('900013', '0', '0', '0', '0', 'Seit gegrüst $N', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '2458', '10000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '2457', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '71', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '355', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '1178', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '499', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '10322', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '32447', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '23160', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '23215', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '0', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '136', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '883', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '982', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '1494', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '1513', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '1515', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '1539', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '691', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '18960', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '712', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '688', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '697', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '12040', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '13908', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '6346', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '1066', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '33943', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '6653', '50000', '0', '0', '0', '0', '0', '0');
INSERT INTO `trainer_spells` VALUES ('900013', '0', '9634', '50000', '0', '0', '0', '0', '0', '0'); |
Va mai repara sv cu 1% 
|
|
| 27/05/2008 14:10 |
|
 |
Raulkiller
Website Team

Data inscrierii: 03/Ian/2008 Mesaje: 95 Localitate: Alba Iulia |
|
|
|
Asa Bagi Iteme in NPC
 |
 |
INSERT INTO vendors (entry, item, amount)
VALUES (NPC Id, Intem Id,0);
|
_________________ <b>
Top 1 http://allr3sp3ct.tk/ </br>
Top 2 http://raul.8.ro/forum/ </br>
Top 3 http://allr3sp3ct.myforum.ro/ </br>
</b> |
|
| 31/05/2008 16:40 |
|
 |
|
|
Nu puteti crea un subiect nou in acest forum Nu puteti raspunde in subiectele acestui forum Nu puteti modifica mesajele proprii din acest forum Nu puteti sterge mesajele proprii din acest forum Nu puteti vota in chestionarele din acest forum
|
|
|