public static async Task DoFullInitialize(ClassicGuildBankDbContext bankDb)
{
var conn = bankDb.Database.GetDbConnection();
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
bankDb.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Item ON;");
var deserializer = new XmlSerializer(typeof(Wowhead));
int itemCnt = 0;
int skipped = 0;
int maxId = bankDb.Items.Any() ? bankDb.Items.Where(i => i.Id < 100000).Max(i => i.Id) : 0;
for (var itemId = maxId; itemId < 35949; itemId++)
{
if (await DoItemImport(bankDb, deserializer, itemId))
{
if (++itemCnt % 1000 == 0)
{
Console.WriteLine($"Saved {bankDb.SaveChangesAsync().Result} Records");
}
}
else
{
skipped++;
}
}
// Chronoboon Displacer and Supercharged Chronoboon Displacer
await DoItemImport(bankDb, deserializer, 184937);
await DoItemImport(bankDb, deserializer, 184938);
var recordsSaved = await bankDb.SaveChangesAsync();
conn.Close();
Console.WriteLine(recordsSaved);
Console.WriteLine($"Skipped {skipped} Records");
Console.ReadLine();
}
public static async Task DoMaNGOSUpdate(ClassicGuildBankDbContext bankDb, MangosDbContext mangosDb)
{
var itemCnt = bankDb.Items.Count();
var batchCnt = (itemCnt / 1000) + 1;
var deserializer = new XmlSerializer(typeof(Wowhead));
for (int i = 0; i < batchCnt; i++)
{
foreach (var item in bankDb.Items.Skip(i * 1000).Take(1000).ToList())
{
var result = await httpClient.GetAsync($"https://classic.wowhead.com/item={item.Id}?xml");
var xmlStream = await result.Content.ReadAsStreamAsync();
var str = await result.Content.ReadAsStringAsync();
var wItem = (Wowhead)deserializer.Deserialize(xmlStream);
if (wItem.Item == null)
{
Console.WriteLine($"Failed to locate item {item.Id} - {item.Name}");
continue;
}
Console.WriteLine($"Updating Item {item.Id} - {item.Name}");
bankDb.Items.Attach(item);
item.Class = Convert.ToInt32(wItem.Item.Class.Id);
item.Subclass = Convert.ToInt32(wItem.Item.Subclass.Id);
}
await bankDb.SaveChangesAsync();
}
Console.WriteLine("Finished Updating Items from MaNGOS");
Console.ReadLine();
}
public static async Task DoFullInitialize(ClassicGuildBankDbContext bankDb, MangosDbContext mangosDb)
{
var conn = bankDb.Database.GetDbConnection();
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
bankDb.Database.ExecuteSqlCommand("SET IDENTITY_INSERT Item ON;");
var deserializer = new XmlSerializer(typeof(Wowhead));
int itemCnt = 0;
int skipped = 0;
int maxId = bankDb.Items.Max(i => i.Id);
foreach (var item in mangosDb.ItemTemplates.Where(i => i.entry > maxId))
{
var content = httpClient.GetAsync($"https://classic.wowhead.com/item={item.entry}?xml").Result.Content;
var xmlStream = content.ReadAsStreamAsync().Result;
var str = content.ReadAsStringAsync().Result;
var wItem = (Wowhead)deserializer.Deserialize(xmlStream);
if (wItem.Item == null)
{
Console.WriteLine($"Failed to locate item {item.entry} - {item.name}");
skipped++;
continue;
}
Console.WriteLine($"Converting Item {item.entry} - {wItem.Item.Name}");
var dbItem = bankDb.Items.FirstOrDefault(i => i.Id == Convert.ToInt32(wItem.Item.Id));
if (dbItem != null)
{
continue;
}
dbItem = new CGB.Item();
dbItem.Id = Convert.ToInt32(wItem.Item.Id);
dbItem.Name = wItem.Item.Name;
dbItem.Quality = wItem.Item.Quality.Text;
dbItem.Icon = wItem.Item.Icon.Text;
dbItem.Class = Convert.ToInt32(wItem.Item.Class.Id);
dbItem.Subclass = Convert.ToInt32(wItem.Item.Subclass.Id);
bankDb.Items.Add(dbItem);
itemCnt++;
if (itemCnt % 1000 == 0)
{
Console.WriteLine($"Saved {bankDb.SaveChangesAsync().Result} Records");
}
}
var recordsSaved = await bankDb.SaveChangesAsync();
conn.Close();
Console.WriteLine(recordsSaved);
Console.WriteLine($"Skipped {skipped} Records");
Console.ReadLine();
}
public static async Task DoLanguageUpdate(ClassicGuildBankDbContext bankDb)
{
var minId = bankDb.Items.Where(i => String.IsNullOrEmpty(i.PtName)).Min(i => i.Id);
var itemCnt = bankDb.Items.Where(i => i.Id >= minId).Count();
var batchCnt = (itemCnt / 1000) + 1;
var deserializer = new XmlSerializer(typeof(Wowhead));
var languages = new[] { /*"ru", "de", "fr", "it", "es", "cn",*/ "ko", "pt" };
for (int i = 0; i < batchCnt; i++)
{
foreach (var item in bankDb.Items.Where(item => item.Id >= minId).Skip(i * 1000).Take(1000).ToList())
{
bankDb.Items.Attach(item);
foreach (var lan in languages)
{
var result = await httpClient.GetAsync($"https://{lan}.classic.wowhead.com/item={item.Id}?xml");
var byteArray = await result.Content.ReadAsByteArrayAsync();
var str = Encoding.UTF8.GetString(byteArray, 0, byteArray.Length);
var reader = new StringReader(str);
//var str = await result.Content.ReadAsStringAsync();
string localeName = String.Empty;
try
{
var wItem = (Wowhead)deserializer.Deserialize(reader);
localeName = wItem.Item.Name;
}
catch (Exception ex)
{
var j = str.IndexOf("<name><![CDATA[") + 15;
var k = str.IndexOf("]]></name>", i);
if (j > 0 && k > 0)
{
localeName = str.Substring(j, k - j);
}
}
if (string.IsNullOrEmpty(localeName))
{
Console.WriteLine($"Failed to locate item {item.Id} - {item.Name}");
continue;
}
Console.WriteLine($"Updating Item {item.Id} - {item.Name} for Locale: {lan}");
switch (lan)
{
case "ru":
item.RuName = localeName;
break;
case "de":
item.DeName = localeName;
break;
case "fr":
item.FrName = localeName;
break;
case "it":
item.ItName = localeName;
break;
case "cn":
item.CnName = localeName;
break;
case "es":
item.EsName = localeName;
break;
case "ko":
item.KoName = localeName;
break;
case "pt":
item.PtName = localeName;
break;
}
}
}
await bankDb.SaveChangesAsync();
}
Console.WriteLine("Finished Updating Item Locale Names");
Console.ReadLine();
}