Level 1 Mounts

[duffstone]

I've searched around for two days now (and I guess I'm just not hitting the correct phrase), but I cannot figure out how to make a level 1 mount. I figured out how to make apprentice riding a starting skill, but I can't seem to either grant a mount starting skill (think charger) or get any of the level 20 monuts to be level 1.

I have picked a mount from the "item_template" table, set the item_level and required_levels to 1, 0, -1... 2... No dice, the item in my inventory OR vendor always shows min level of 20.

Further, I've modified all the other stats too, sell price, item quality, etc... and again, nothing changes the actual item in your inventory or vendor from the default.

Am I missing something, or is that just hard coded in the MPQ files and not able to be changed via the emu DB?

if someone could help me out it would be appreciated...

 

[duffstone]

Sorry for replying to my own thread, but I think I found a satisfactory "Reason" and "Solution".

I THINK the reason that I cannot override the level of an existing item is due to the item-sparse.db2 file taking precedent over the mysqlDB data.

I solved the issue by creating a new mount that was an exact copy of an existing mount, with a new "entry" number(key). Again, I hate to be wordy but I figure someone might find this usefull; Here's the SQL to do that:

Will copy the entry 73838 (mountain horse) into entry 300000.  Then just add 300000 to the starting gear.  also make sure to add apprentice riding to the starting spells.

insert into item_template (
select 
300000,
class,
subclass,
SoundOverrideSubclass,
name,
displayid,
Quality,
Flags,
FlagsExtra,
Unk430_1,
Unk430_2,
BuyCount,
BuyPrice,
SellPrice,
InventoryType,
AllowableClass,
AllowableRace,
ItemLevel,
RequiredLevel,
RequiredSkill,
RequiredSkillRank,
requiredspell,
requiredhonorrank,
RequiredCityRank,
RequiredReputationFaction,
RequiredReputationRank,
maxcount,
stackable,
ContainerSlots,
stat_type1,
stat_value1,
stat_unk1_1,
stat_unk2_1,
stat_type2,
stat_value2,
stat_unk1_2,
stat_unk2_2,
stat_type3,
stat_value3,
stat_unk1_3,
stat_unk2_3,
stat_type4,
stat_value4,
stat_unk1_4,
stat_unk2_4,
stat_type5,
stat_value5,
stat_unk1_5,
stat_unk2_5,
stat_type6,
stat_value6,
stat_unk1_6,
stat_unk2_6,
stat_type7,
stat_value7,
stat_unk1_7,
stat_unk2_7,
stat_type8,
stat_value8,
stat_unk1_8,
stat_unk2_8,
stat_type9,
stat_value9,
stat_unk1_9,
stat_unk2_9,
stat_type10,
stat_value10,
stat_unk1_10,
stat_unk2_10,
ScalingStatDistribution,
DamageType,
delay,
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,
itemset,
MaxDurability,
area,
Map,
BagFamily,
TotemCategory,
socketColor_1,
socketContent_1,
socketColor_2,
socketContent_2,
socketColor_3,
socketContent_3,
socketBonus,
GemProperties,
ArmorDamageModifier,
duration,
ItemLimitCategory,
HolidayId,
StatScalingFactor,
CurrencySubstitutionId,
CurrencySubstitutionCount,
flagsCustom,
WDBVerified
from item_template where entry = 73838)

 

[ExO]

Glad you solved your issue, and even on your own! Thanks for sharing the solution.