|
public GetCurrencyCost ( ) : UInt32>.Dictionary |
||
| return | UInt32>.Dictionary | |
public static void ParseVendor(UInt32 entry, UInt32 typeId, UInt32 subTypeId, List <String> content)
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.AppendLine(String.Format("-- Parsing {0} vendor data for entry {1}", Defines.GetStreamName(typeId, subTypeId), entry));
strBuilder.AppendLine(String.Format("DELETE FROM `{0}` WHERE entry = {1};", Defines.GetDBName(typeId, subTypeId), entry));
WowheadSerializer serializer = new WowheadSerializer(content, typeId, subTypeId);
foreach (Dictionary <String, Object> objectInto in serializer.Objects)
{
try
{
WowheadObject wowheadObject = new WowheadObject(objectInto);
UInt32 id = wowheadObject.GetId();
String name = wowheadObject.GetFixedName();
UInt32 extendedCost = ExtendedCosts.GetExtendedCost(wowheadObject.GetCurrencyCost(), wowheadObject.GetItemCost(), 0);
// Needed (NULL cost ?)
if (extendedCost == 2)
{
extendedCost = 0;
}
String str = String.Format("INSERT INTO `{0}` VALUES ( '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}'); -- {8}",
Defines.GetDBName(typeId, subTypeId), entry, 0, id, 0, 0, extendedCost, 1, name);
strBuilder.AppendLine(str);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
strBuilder.AppendLine(String.Format("-- Parsed {0} data for entry {1}", Defines.GetStreamName(typeId, subTypeId), entry));
strBuilder.AppendLine("");
WriteSQL(typeId, entry, strBuilder.ToString());
Console.WriteLine("{0}% - Parsed {1} data for entry {2}", Math.Round(++dataDone / (float)commandList.Count * 100, 2), Defines.GetStreamName(typeId, subTypeId), entry);
}
public static void ParseVendor(UInt32 entry, UInt32 typeId, UInt32 subTypeId, List<String> content)
{
StringBuilder strBuilder = new StringBuilder();
strBuilder.AppendLine(String.Format("-- Parsing {0} vendor data for entry {1}", Defines.GetStreamName(typeId, subTypeId), entry));
strBuilder.AppendLine(String.Format("DELETE FROM `{0}` WHERE entry = {1};", Defines.GetDBName(typeId, subTypeId), entry));
WowheadSerializer serializer = new WowheadSerializer(content, typeId, subTypeId);
foreach (Dictionary<String, Object> objectInto in serializer.Objects)
{
try
{
WowheadObject wowheadObject = new WowheadObject(objectInto);
UInt32 id = wowheadObject.GetId();
String name = wowheadObject.GetFixedName();
UInt32 extendedCost = ExtendedCosts.GetExtendedCost(wowheadObject.GetCurrencyCost(), wowheadObject.GetItemCost(), 0);
// Needed (NULL cost ?)
if (extendedCost == 2)
extendedCost = 0;
String str = String.Format("INSERT INTO `{0}` VALUES ( '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}'); -- {8}",
Defines.GetDBName(typeId, subTypeId), entry, 0, id, 0, 0, extendedCost, 1, name);
strBuilder.AppendLine(str);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
strBuilder.AppendLine(String.Format("-- Parsed {0} data for entry {1}", Defines.GetStreamName(typeId, subTypeId), entry));
strBuilder.AppendLine("");
WriteSQL(typeId, entry, strBuilder.ToString());
Console.WriteLine("{0}% - Parsed {1} data for entry {2}", Math.Round(++dataDone / (float)commandList.Count * 100, 2), Defines.GetStreamName(typeId, subTypeId), entry);
}
