NPC

[ado130 52]

Ahojte!

Nudil som sa tak som vytvoril 1NPC, ktore moze predavat, ktore ked zabijete dostanete G, a ine.

Dam sem SQL a ak by ste nasli chybu mozete dat vediet.

 

NPC:

 

insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('140795', '3975', '3979', '3973', '3977', "Universal", "Univarsal NPC", '100', '255', '500000', '1000000', '100000', '100000', '7777', '7', '7', '14880897', '8.00', '1', '4', '500', '999', '3500', '0', '7', '25', '26', '27', '28', '29', '30', '10001001', '10001001');

 

 

LOOT:

 

INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`) VALUES 
('140795', '950714', '99', '0', '1', '1'); 

 

 

Quest:

 

 INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `Type`, `RequiredRaces`, `SrcItemId`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `RequestItemsText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqCreatureOrGOId1`, `ReqCreatureOrGOId2`, `ReqCreatureOrGOId3`, `ReqCreatureOrGOId4`, `ReqCreatureOrGOCount1`, `ReqCreatureOrGOCount2`, `ReqCreatureOrGOCount3`, `ReqCreatureOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewOrReqMoney`, `PrevQuestId`, `SuggestedPlayers`, `RequiredMinRepFaction`, `RequiredMinRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewSpellCast`, `EndText`, `SkillOrClass`, `RewMoneyMaxLevel`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `CharTitleId`, `RequiredSkillValue`) 
VALUES ('951407', '0', '70', '70', '0', '0', '0', '0', 'Potrebujem platno', 'Ahoj!$BKamarat mi potreboval 100Linen cloth, 100Wool cloth a 100Silk cloth.$BAk mi toto vsetko prinesies dostanes odomna +3talent pointy.', '100Linen cloth, 100Wool cloth, 100Silk cloth', 'Dakujem ti velmi pekne.$BOdomna dostavas 3talent pointy.', 'Uz mas vsetko?', '2589', '2592', '4306', '0', '100', '100', '100', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '', '', '', '', '26', '0');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) 
VALUES ('140795', '951407');
INSERT INTO `creature_questrelation` (`id`, `quest`) 
VALUES ('140795', '951407'); 

 

 

LOOT 2:

 

 INSERT INTO item_template (entry, class, subclass, name, displayid, Quality, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, description, PageText, LanguageID, PageMaterial)
VALUES (950714, 15, 0, "Gratulujem", 1143, 6, 0, 0, 100000000, 0, -1, -1, 100, 1, 0, 0, 0, 0, 0, 0, 1, "Gratulujem", 140957, 0, 7);
INSERT INTO page_text (entry, text, next_page) VALUES
('140957', 'Gratulujem.$BZabil si ma a tym dostavas zasluzene G.$B$B', '0'); 

 

Vendor:

 

 INSERT INTO `npc_vendor` (`entry`,`item`) VALUES 
('140795','5178'), 
('140795','5175'), 
('140795','5176'), 
('140795','5177'), 
('140795','6265'), 
('140795','17056'), 
('140795','17030'), 
('140795','17020'), 
('140795','16583'), 
('140795','17028'), 
('140795','5565'), 
('140795','17031'), 
('140795','17031'), 
('140795','17033'), 
('140795','21177'); 

 

Edited February 18, 2010 by ado130

[Wladass 1216]

Když v lootu používáš groupid=1 tak se nedávají procenta na loot..

[ado130 52]

aha.. a ake tam mam dat teda cislo? ale dik..

edit1: mam otazku.. tomu NPC som nastavil aby bol neutralny no ma to byt nieco ako uvitacie NPC tak da sa to nejako nastavit aby ho slo zabit (pre opacnu frakciu) ale aj pouzit ako normalne NPC? alebo budem muset urobyt 2NPC? zvlast pre H a zvlast pre A? ak to treba urbyt zvlast co musim zmenit? staci faction A a faction H ?

edit2: dik wladass a uz to mam dobre

Edited February 18, 2010 by ado130

[Wladass 1216]

Stačí :

 

INSERT INTO `creature_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`)  
VALUES  (140795, 950714, 99, 0, 1, 1); 

 

Pokud je to jeden item nemusíš ho dělit na groupid, takže stačí 0 a padne podle ChanceOrQuestChance .

Edited February 18, 2010 by Wladass

[ado130 52]

Este by som mal 1otazku.

Dalo by sa dat NPC nejaka vec na seba ako maju hraci?