public Field_Map GetFieldMap(string aName)
{
var xMap = new Field_Map();
xMap.TypeName = aName;
var xRows = mConnection.Query <FIELD_MAPPING>(new SQLinq <FIELD_MAPPING>().Where(i => i.TYPE_NAME == aName));
foreach (var xFieldName in xRows)
{
xMap.FieldNames.Add(xFieldName.FIELD_NAME);
}
return(xMap);
}
private Field_Map DoGetFieldMap(string aName)
{
var xMap = new Field_Map();
xMap.TypeName = aName;
var xRows = mConnection.GetList <FIELD_MAPPING>(Predicates.Field <FIELD_MAPPING>(q => q.TYPE_NAME, Operator.Eq, aName));
foreach (var xFieldName in xRows)
{
xMap.FieldNames.Add(xFieldName.FIELD_NAME);
}
return(xMap);
}
public void ReadFieldMappingList(List <Field_Map> aSymbols)
{
var xMap = new Field_Map();
foreach (var xRow in mConnection.GetList <FIELD_MAPPING>())
{
string xTypeName = xRow.TYPE_NAME;
if (xTypeName != xMap.TypeName)
{
if (xMap.FieldNames.Count > 0)
{
aSymbols.Add(xMap);
}
xMap = new Field_Map();
xMap.TypeName = xTypeName;
}
xMap.FieldNames.Add(xRow.FIELD_NAME);
}
aSymbols.Add(xMap);
}
public bool SaveNewTemplateAsXML(string filename, bool replace)
{
string path = "templates";
Directory.CreateDirectory(path);
if (File.Exists($"{path}\\{filename}.xml") && !replace)
{
return(false);
}
if (File.Exists($"{path}\\{filename}.xml") && replace)
{
File.Delete($"{filename}.xml");
}
XDocument doc = new XDocument
(
new XElement("table_data", new XAttribute("name", "item_template"),
new XElement("row",
new XElement("field", Field_entry.ToString()),
new XElement("field", Field_class.ToString()),
new XElement("field", Field_subclass.ToString()),
new XElement("field", Field_SoundOverrideSubclass.ToString()),
new XElement("field", Field_name),
new XElement("field", Field_displayid.ToString()),
new XElement("field", Field_Quality.ToString()),
new XElement("field", Field_Flags.ToString()),
new XElement("field", Field_FlagsExtra.ToString()),
new XElement("field", Field_BuyCount.ToString()),
new XElement("field", Field_BuyPrice.ToString()),
new XElement("field", Field_SellPrice.ToString()),
new XElement("field", Field_InventoryType.ToString()),
new XElement("field", Field_AllowableClass == 0 ? "-1" : Field_AllowableClass.ToString()), // temp fix
new XElement("field", Field_AllowableRace == 0 ? "-1" : Field_AllowableRace.ToString()), // temp fix
new XElement("field", Field_ItemLevel.ToString()),
new XElement("field", Field_RequiredLevel.ToString()),
new XElement("field", Field_RequiredSkill.ToString()),
new XElement("field", Field_RequiredSkillRank.ToString()),
new XElement("field", Field_requiredspell.ToString()),
new XElement("field", Field_requiredhonorrank.ToString()),
new XElement("field", Field_RequiredCityRank.ToString()),
new XElement("field", Field_RequiredReputationFaction.ToString()),
new XElement("field", Field_RequiredReputationRank.ToString()),
new XElement("field", Field_maxcount.ToString()),
new XElement("field", Field_stackable.ToString()),
new XElement("field", Field_ContainerSlots.ToString()),
new XElement("field", Field_StatsCount.ToString()),
new XElement("field", Field_stat_type1.ToString()),
new XElement("field", Field_stat_value1.ToString()),
new XElement("field", Field_stat_type2.ToString()),
new XElement("field", Field_stat_value2.ToString()),
new XElement("field", Field_stat_type3.ToString()),
new XElement("field", Field_stat_value3.ToString()),
new XElement("field", Field_stat_type4.ToString()),
new XElement("field", Field_stat_value4.ToString()),
new XElement("field", Field_stat_type5.ToString()),
new XElement("field", Field_stat_value5.ToString()),
new XElement("field", Field_stat_type6.ToString()),
new XElement("field", Field_stat_value6.ToString()),
new XElement("field", Field_stat_type7.ToString()),
new XElement("field", Field_stat_value7.ToString()),
new XElement("field", Field_stat_type8.ToString()),
new XElement("field", Field_stat_value8.ToString()),
new XElement("field", Field_stat_type9.ToString()),
new XElement("field", Field_stat_value9.ToString()),
new XElement("field", Field_stat_type10.ToString()),
new XElement("field", Field_stat_value10.ToString()),
new XElement("field", Field_ScalingStatDistribution.ToString()),
new XElement("field", Field_ScalingStatValue.ToString()),
new XElement("field", Field_dmg_min1.ToString()),
new XElement("field", Field_dmg_max1.ToString()),
new XElement("field", Field_dmg_type1.ToString()),
new XElement("field", Field_dmg_min2.ToString()),
new XElement("field", Field_dmg_max2.ToString()),
new XElement("field", Field_dmg_type2.ToString()),
new XElement("field", Field_armor.ToString()),
new XElement("field", Field_holy_res.ToString()),
new XElement("field", Field_fire_res.ToString()),
new XElement("field", Field_nature_res.ToString()),
new XElement("field", Field_frost_res.ToString()),
new XElement("field", Field_shadow_res.ToString()),
new XElement("field", Field_arcane_res.ToString()),
new XElement("field", Field_delay.ToString()),
new XElement("field", Field_ammo_type.ToString()),
new XElement("field", Field_RangedModRange.ToString()),
new XElement("field", Field_spellid_1.ToString()),
new XElement("field", Field_spelltrigger_1.ToString()),
new XElement("field", Field_spellcharges_1.ToString()),
new XElement("field", Field_spellppmRate_1.ToString()),
new XElement("field", Field_spellcooldown_1.ToString()),
new XElement("field", Field_spellcategory_1.ToString()),
new XElement("field", Field_spellcategorycooldown_1.ToString()),
new XElement("field", Field_spellid_2.ToString()),
new XElement("field", Field_spelltrigger_2.ToString()),
new XElement("field", Field_spellcharges_2.ToString()),
new XElement("field", Field_spellppmRate_2.ToString()),
new XElement("field", Field_spellcooldown_2.ToString()),
new XElement("field", Field_spellcategory_2.ToString()),
new XElement("field", Field_spellcategorycooldown_2.ToString()),
new XElement("field", Field_spellid_3.ToString()),
new XElement("field", Field_spelltrigger_3.ToString()),
new XElement("field", Field_spellcharges_3.ToString()),
new XElement("field", Field_spellppmRate_3.ToString()),
new XElement("field", Field_spellcooldown_3.ToString()),
new XElement("field", Field_spellcategory_3.ToString()),
new XElement("field", Field_spellcategorycooldown_3.ToString()),
new XElement("field", Field_spellid_4.ToString()),
new XElement("field", Field_spelltrigger_4.ToString()),
new XElement("field", Field_spellcharges_4.ToString()),
new XElement("field", Field_spellppmRate_4.ToString()),
new XElement("field", Field_spellcooldown_4.ToString()),
new XElement("field", Field_spellcategory_4.ToString()),
new XElement("field", Field_spellcategorycooldown_4.ToString()),
new XElement("field", Field_spellid_5.ToString()),
new XElement("field", Field_spelltrigger_5.ToString()),
new XElement("field", Field_spellcharges_5.ToString()),
new XElement("field", Field_spellppmRate_5.ToString()),
new XElement("field", Field_spellcooldown_5.ToString()),
new XElement("field", Field_spellcategory_5.ToString()),
new XElement("field", Field_spellcategorycooldown_5.ToString()),
new XElement("field", Field_bonding.ToString()),
new XElement("field", Field_description),
new XElement("field", Field_PageText.ToString()),
new XElement("field", Field_LanguageID.ToString()),
new XElement("field", Field_PageMaterial.ToString()),
new XElement("field", Field_startquest.ToString()),
new XElement("field", Field_lockid.ToString()),
new XElement("field", Field_Material.ToString()),
new XElement("field", Field_sheath.ToString()),
new XElement("field", Field_RandomProperty.ToString()),
new XElement("field", Field_RandomSuffix.ToString()),
new XElement("field", Field_block.ToString()),
new XElement("field", Field_itemset.ToString()),
new XElement("field", Field_MaxDurability.ToString()),
new XElement("field", Field_area.ToString()),
new XElement("field", Field_Map.ToString()),
new XElement("field", Field_BagFamily.ToString()),
new XElement("field", Field_TotemCategory.ToString()),
new XElement("field", Field_socketColor_1.ToString()),
new XElement("field", Field_socketContent_1.ToString()),
new XElement("field", Field_socketColor_2.ToString()),
new XElement("field", Field_socketContent_2.ToString()),
new XElement("field", Field_socketColor_3.ToString()),
new XElement("field", Field_socketContent_3.ToString()),
new XElement("field", Field_socketBonus.ToString()),
new XElement("field", Field_GemProperties.ToString()),
new XElement("field", Field_RequiredDisenchantSkill.ToString()),
new XElement("field", Field_ArmorDamageModifier.ToString()),
new XElement("field", Field_duration.ToString()),
new XElement("field", Field_ItemLimitCategory.ToString()),
new XElement("field", Field_HolidayId.ToString()),
new XElement("field", Field_ScriptName),
new XElement("field", Field_DisenchantID.ToString()),
new XElement("field", Field_FoodType.ToString()),
new XElement("field", Field_minMoneyLoot.ToString()),
new XElement("field", Field_maxMoneyLoot.ToString()),
new XElement("field", Field_flagsCustom.ToString()),
new XElement("field", Field_VerifiedBuild.ToString())
) // /row
) // /table_data
);
doc.Save($"templates\\{filename}.xml");
MessageBox.Show($"Template {filename} saved");
return(true);
}
