Npc

[dextrs 0]

Zdravim potreboval bych udelat NPC z kereho by padali penize a itemy nejak mi to nefici stacilo by mi kdyby mi to tu nekdo jen dal ja bych si to pak uz skopiroval staci-NPC aby padli goldy a dva itemy.Dmg,HP,manu atd bych si uz nastavil prosim vas pekne predem dik

[sabath 110]

Zdravim potreboval bych udelat NPC z kereho by padali penize a itemy nejak mi to nefici stacilo by mi kdyby mi to tu nekdo jen dal ja bych si to pak uz skopiroval staci-NPC aby padli goldy a dva itemy.Dmg,HP,manu atd bych si uz nastavil prosim vas pekne predem dik

Dej mi icq

 

[dextrs 0]

poslal sem ti ho

Edited July 4, 2008 by dextrs

[TommyAnders 52]

NPC:

DELETE FROM `creature_template` WHERE `entry` = 700000;
INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`) VALUES (700000, 146, 0, 146, 0, 'JMÉNO', 'POD-JMÉNO', "", level, level, HP, HP, 0, 0, 1000000, 35, 35, 1, 2, 1, 3, 10000, 10000, 0, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 10000, 3000, 6, 1, 0, 0, 0, 0, 10000, 10000, 10000, 10000, 10000, 10000, 0, 0, 0, 0, minimalne goldu, max goldu, '', 0, 3, 0, 1, 0, 0, '');

2 itemy:

INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration)
VALUES (700000,12,12,-1,"JMÉNO ITEMU",displayID,6,2048,0,0000,0000,1,-1,-1,0,99,0,0,0,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,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,0,"",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,"internalitemhanler",0,0,0,0,0);

INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration)
VALUES (700001,12,12,-1,"JMÉNO ITEMU",displayID,6,2048,0,0000,0000,1,-1,-1,0,99,0,0,0,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,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,0,"",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,"internalitemhanler",0,0,0,0,0);

 

Trochu jsem ti to upravil, ale jak říkáš upravíš si to sám Jinak doporučuju Quice. Link kde to stáhneš je na google nebo aspoň 10x tu na fóru Enjoy!

[dextrs 0]

Quice mi nejak nejde ale pokud mi pujde tohle diky moc

[dextrs 0]

Ok to je je jen sem chtel aby ta prisera mela aby sni padli dva itemy a ne vyrobit dva itemy nebo to

INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID, FoodType, minMoneyLoot, maxMoneyLoot, Duration)

VALUES (700000,12,12,-1,"JMÉNO ITEMU",displayID,6,2048,0,0000,0000,1,-1,-1,0,99,0,0,0,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,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,0,"",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,"internalitemhanler",0,0,0,0,0);

tesce nechapu je to na vytvoreni itemu ne a jeste neco a by creature padal loot tak

`lootid`

toto je na nastaveni ale tam prece muzu dat jen jedno ID jak to mam udelat aby sni padalo treba 6veci

[Woraft 1]

V creature_loot_template nastavíš loot a použiješ stejné ID jako sis dal do lootid.

[dextrs 0]

jo ale ja do lootID potrebuu dat vic ID jak to mam pak anastavit aby to stoho padalo jen nejakou ukazku nedal by mi tu nekdo

[dextrs 0]

DELETE FROM `creature_loot_template` WHERE (`entry`=25840);

INSERT INTO `creature_loot_template` VALUES

(25840, 29434, 100, 1, 1, 1, 1, 0, 0);

Takhle myslis ?? ale jak to zas dam pise mi to chybu

[dextrs 0]

uz asi vim do toho lootID dam ID kere je volne a potom dam v ctreature loot template to lootID a za to nastavim vsechny parametry nemel by tu nekdo SQL abych nemuse l stourat v navicate

DELETE FROM `creature_loot_template` WHERE (`entry`=25840);

INSERT INTO `creature_loot_template` VALUES

(25840, 29434, 100, 1, 1, 1, 1, 0, 0);

toto mi nejde

[Woraft 1]

(25840, 90001, 100, 0, -90001, 3, 1, 0, 0),

(25840, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(25840, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(25840, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(25840, ID itemu, 0, 1, 1, 1, 1, 0, 0);

 

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

(90001, ID itemu, 0, 1, 1, 1, 1, 0, 0),

 

Třeba takto.

[dextrs 0]

ok dik

[dextrs 0]

Jak mam nastavi aby mi tady sotohdle bossse

INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `civilian`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `ScriptName`) VALUES (700003, 1072, 0, 1072, 0, 'Josef', 'Parta Hic', "", 100, 100, 3000000, 3000000, 0, 0, 1000000, 1, 1, 0, 2, 4, 4, 7000, 10000, 0, 3000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 10000, 3000, 6, 1, 0, 900000, 0, 0, 10000, 10000, 10000, 10000, 10000, 10000, 0, 0, 0, 0, 100000, 150000, '', 0, 3, 0, 1, 0, 0, '');

padal item s ID 900000?? takhle mi to nejde

[Woraft 1]

Podívej se na loot kde to funguje a podle toho si to nastav jak potřebuješ. Nevim co máš za DB, ale není tak težké se nad tím chvilku zamyslet a snad přijdeš na to jak to funguje nebo jestli se najde někdo kdo by měl s tebou trpělivost, což docela pochybuju.

[TommyAnders 52]

Musíš nastavit jeho ID u itemu.