Otazka kolem itemu

[Warlocke 1]

Prosím vás muže te my někdo poradit jak mám do itemu přidat třeba, nebo spíše kam to mám do codu zařadit :

Increases your spell damage and healing by 35% of your total Intellect.

????

Edited January 15, 2010 by Warlocke

[Angelo 120]

spellid - The spell ID of the spell that the item can cast or trigger.

spelltrigger :

 

ID Trigger Type

 

 

[0] Use

[1] On Equip

[2] Chance on Hit

[4] Soulstone

[5] Use with no delay

[6] Learn Spell ID

Edited January 15, 2010 by Angelo

[Warlocke 1]

jen ještě jedna věc neustále to píše toto

Out of range value for column 'spellcharges_5' at row 1

a tomu sem nějak neporozumel

[pogasta 2]

V te kolonce mas moc vysokou hodnotu...

[Warlocke 1]

no ale problém je v tom že je tam nula

[Wlk Wlezley 5]

no ale problém je v tom že je tam nula

 

"OUT OF RANGE" znamená "MIMO ROZSAH". Takže né jen "horní" hranice, ale i spodní. Chápej: rozsah "od" - "do" nějaký hodnoty.. Je možný, že ta nula je právě ten problém. Neznám sice rozsah pro "spellcharges", ale experimentoval bych s tím. Zkusil bych hodnotu -1 jako neomezenou (viz. u questů MaxLvl), nebo hodnotu 1.

 

Hodně štěstí.

[Warlocke 1]

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, 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, StatsCount)
VALUES (100003, 2, 2, -1, "Magma Thori'dal", 48902, 6, 0, 0, 0, 0, 15, 5, -1, 80, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0,  7, 830,  5, 1000,  4, 520,  3, 620,  1, 0,  38, 13620,  16, 4300,  17, 3200,  28, 360,  29, 360, 31358, 45369, 0, 0, 0, 0, 22312, 0, 0, 0, 0, 0, 0, 1200, 0, 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, 46699, 1, 2, 0, 1, "Weapons of Titans", 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10);

Skuste my stím někdo help prosím co tam mám spatně v spellcharges_5

Edited January 17, 2010 by Warlocke

[patras1111 1]

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, 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, StatsCount)
VALUES (100003, 2, 2, -1, "Magma Thori'dal", 48902, 6, 0, 0, 0, 0, 15, 5, -1, 80, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0,  7, 830,  5, 1000,  4, 520,  3, 620,  1, 0,  38, 13620,  16, 4300,  17, 3200,  28, 360,  29, 360, 31358, 45369, 0, 0, 0, 0, 22312, 0, 0, 0, 0, 0, 0, 1200, 0, 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, 46699, 1, 2, 0, 1, "Weapons of Titans", 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 10);

Skuste my stím někdo help prosím co tam mám spatně v spellcharges_5

 

Nevim jestli to ještě potřebuješ ale i tak tady to je funkční:

 

Jinak chybu jsi měl v hodnotě spellcharges_5 zadával jsi tam 46699.

 

 

INSERT INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `Faction`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `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`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_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`, `Duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) 
VALUES (100003, 2, 2, -1, 'Magma Thori\'dal', 48902, 6, 0, 0, 0, 0, 0, 15, 5, -1, 80, 80, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 10, 7, 830, 5, 1000, 4, 520, 3, 620, 1, 0, 38, 13620, 16, 4300, 17, 3200, 28, 360, 29, 360, 0, 0, 31358, 45369, 0, 0, 0, 0, 22312, 0, 0, 0, 0, 0, 0, 1200, 0, 100, 46699, 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, 1, 'Weapons of Titans', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhanler', 0, 0, 0, 0);

[Moonsheep 0]

to je podle mě ID spellu ale nevím jestli to v této kolonce má být ..