/// <summary>
/// </summary>
/// <returns>
/// </returns>
private static List <NanoFormula> ReadNanoFormulas()
{
var np = new NewParser();
List <NanoFormula> rawNanoList = new List <NanoFormula>();
int counter = 0;
foreach (int recnum in extractor.GetRecordInstances(Extractor.RecordType.Nano))
{
if (counter == 0)
{
counter = recnum;
}
byte[] data = extractor.GetRecordData(Extractor.RecordType.Nano, recnum);
NanoFormula nano = np.ParseNano(recnum, data, "temp.sql");
rawNanoList.Add(nano);
if ((counter % 2000) == 0)
{
Console.Write("\rNano ID: " + recnum.ToString().PadLeft(9));
}
counter++;
}
Console.Write("\rNano ID: " + rawNanoList[rawNanoList.Count - 1].ID.ToString().PadLeft(9));
File.Delete("temp.sql");
return(rawNanoList);
}
/// <summary>
/// </summary>
/// <param name="itemNamesSqls">
/// </param>
/// <returns>
/// </returns>
private static List <ItemTemplate> ExtractItemTemplates(List <string> itemNamesSqls)
{
var np = new NewParser();
int[] instances = extractor.GetRecordInstances(Extractor.RecordType.Item);
List <ItemTemplate> rawItemList = new List <ItemTemplate>(instances.Length);
rawItemDictionary = new Dictionary <int, ItemTemplate>(instances.Length);
int counter = 0;
foreach (int recnum in instances)
{
byte[] data = extractor.GetRecordData(Extractor.RecordType.Item, recnum);
ItemTemplate xt = np.ParseItem(Extractor.RecordType.Item, recnum, data, itemNamesSqls);
rawItemList.Add(xt);
rawItemDictionary.Add(recnum, xt);
if ((counter % 7500) == 0)
{
Console.Write("\rItem ID: " + recnum.ToString().PadLeft(9));
}
counter++;
}
Console.Write("\rItem ID: " + rawItemList[rawItemList.Count - 1].ID.ToString().PadLeft(9));
Console.WriteLine();
return(rawItemList);
}
/// <summary>
/// </summary>
/// <param name="ItemNamesSql">
/// </param>
/// <returns>
/// </returns>
private static List <ItemTemplate> ExtractItemTemplates(List <string> ItemNamesSql)
{
var np = new NewParser();
List <ItemTemplate> rawItemList = new List <ItemTemplate>(extractor.GetRecordInstanceCount(0xF4254));
rawItemDictionary = new Dictionary <int, ItemTemplate>(extractor.GetRecordInstanceCount(0xF4254));
int counter = 0;
foreach (int recnum in extractor.GetRecordInstances(0xF4254))
{
ItemTemplate xt = np.ParseItem(0xF4254, recnum, extractor.GetRecordData(0xF4254, recnum), ItemNamesSql);
rawItemList.Add(xt);
rawItemDictionary.Add(recnum, xt);
if ((counter % 7500) == 0)
{
Console.Write("\rItem ID: " + recnum.ToString().PadLeft(9));
}
counter++;
}
Console.Write("\rItem ID: " + rawItemList[rawItemList.Count - 1].ID.ToString().PadLeft(9));
Console.WriteLine();
return(rawItemList);
}
/// <summary>
/// </summary>
/// <returns>
/// </returns>
private static List<NanoFormula> ReadNanoFormulas()
{
var np = new NewParser();
List<NanoFormula> rawNanoList = new List<NanoFormula>();
int counter = 0;
foreach (int recnum in extractor.GetRecordInstances(Extractor.RecordType.Nano))
{
if (counter == 0)
{
counter = recnum;
}
byte[] data = extractor.GetRecordData(Extractor.RecordType.Nano, recnum);
NanoFormula nano = np.ParseNano(recnum, data, "temp.sql");
rawNanoList.Add(nano);
if ((counter % 2000) == 0)
{
Console.Write("\rNano ID: " + recnum.ToString().PadLeft(9));
}
counter++;
}
Console.Write("\rNano ID: " + rawNanoList[rawNanoList.Count - 1].ID.ToString().PadLeft(9));
File.Delete("temp.sql");
return rawNanoList;
}
/// <summary>
/// </summary>
/// <param name="itemNamesSqls">
/// </param>
/// <returns>
/// </returns>
private static List<ItemTemplate> ExtractItemTemplates(List<string> itemNamesSqls)
{
var np = new NewParser();
int[] instances = extractor.GetRecordInstances(Extractor.RecordType.Item);
List<ItemTemplate> rawItemList = new List<ItemTemplate>(instances.Length);
rawItemDictionary = new Dictionary<int, ItemTemplate>(instances.Length);
int counter = 0;
foreach (int recnum in instances)
{
byte[] data = extractor.GetRecordData(Extractor.RecordType.Item, recnum);
ItemTemplate xt = np.ParseItem(Extractor.RecordType.Item, recnum, data, itemNamesSqls);
rawItemList.Add(xt);
rawItemDictionary.Add(recnum, xt);
if ((counter % 7500) == 0)
{
Console.Write("\rItem ID: " + recnum.ToString().PadLeft(9));
}
counter++;
}
Console.Write("\rItem ID: " + rawItemList[rawItemList.Count - 1].ID.ToString().PadLeft(9));
Console.WriteLine();
return rawItemList;
}
/// <summary>
/// The main.
/// </summary>
/// <param name="args">
/// The args.
/// </param>
private static void Main(string[] args)
{
Console.WriteLine("**********************************************************************");
Console.WriteLine("** **");
Console.WriteLine("** AO Item and Nano Extractor/Serializer v0.85beta **");
Console.WriteLine("** **");
Console.WriteLine("**********************************************************************");
Console.WriteLine();
string AOPath = string.Empty;
bool foundAO = false;
Console.WriteLine("Enter exit to close program");
while (!foundAO)
{
if (File.Exists("config.txt"))
{
TextReader tr = new StreamReader("config.txt");
AOPath = tr.ReadLine();
tr.Close();
}
foundAO = false;
Console.Write("Please enter your AO Install Path [" + AOPath + "]:");
string temp = Console.ReadLine();
if (temp != string.Empty)
{
AOPath = temp;
}
if (temp.ToLower() == "exit")
{
return;
}
if (!Directory.Exists(AOPath))
{
continue;
}
try
{
extractor = new Extractor(AOPath);
TextWriter tw2 = new StreamWriter("config.txt", false, Encoding.GetEncoding("windows-1252"));
tw2.WriteLine(AOPath);
tw2.Close();
foundAO = true;
Console.WriteLine("Found AO Database on " + AOPath);
}
catch (Exception)
{
foundAO = false;
}
// Try to add cd_image\data\db
if (!foundAO)
{
try
{
AOPath = Path.Combine(AOPath, "cd_image\\data\\db");
extractor = new Extractor(AOPath);
TextWriter tw2 = new StreamWriter("config.txt", false, Encoding.GetEncoding("windows-1252"));
tw2.WriteLine(AOPath);
tw2.Close();
foundAO = true;
Console.WriteLine("Found AO Database on " + AOPath);
}
catch (Exception)
{
foundAO = false;
}
}
}
TextWriter tw = new StreamWriter("itemnames.sql", false, Encoding.GetEncoding("windows-1252"));
tw.WriteLine("DROP TABLE IF EXISTS `itemnames`;");
tw.WriteLine("CREATE TABLE `itemnames` (");
tw.WriteLine(" `AOID` int(10) NOT NULL,");
tw.WriteLine(" `Name` varchar(250) NOT NULL,");
tw.WriteLine(" PRIMARY KEY (`AOID`)");
tw.WriteLine(") ENGINE=MyIsam DEFAULT CHARSET=latin1;");
tw.WriteLine();
tw.Close();
Console.WriteLine("Number of Items to extract: " + extractor.GetRecordInstances(0xF4254).Length);
// ITEM RECORD TYPE
Console.WriteLine("Number of Nanos to extract: " + extractor.GetRecordInstances(0xFDE85).Length);
// NANO RECORD TYPE
// Console.WriteLine(extractor.GetRecordInstances(0xF4241).Length); // Playfields
// Console.WriteLine(extractor.GetRecordInstances(0xF4266).Length); // Nano Strains
// Console.WriteLine(extractor.GetRecordInstances(0xF4264).Length); // Perks
// GetData(@"D:\c#\extractor serializer\data\items\",0xf4254);
// GetData(@"D:\c#\extractor serializer\data\nanos\",0xfde85);
// GetData(@"D:\c#\extractor serializer\data\playfields\",0xf4241);
// GetData(@"D:\c#\extractor serializer\data\nanostrains\",0xf4266);
// GetData(@"D:\c#\extractor serializer\data\perks\",0xf4264);
var np = new NewParser();
var rawItemList = new List <AOItem>();
var rawNanoList = new List <AONanos>();
foreach (int recnum in extractor.GetRecordInstances(0xFDE85))
{
rawNanoList.Add(np.ParseNano(0xFDE85, recnum, extractor.GetRecordData(0xFDE85, recnum), "temp.sql"));
}
File.Delete("temp.sql");
Console.WriteLine();
Console.WriteLine("Nanos extracted: " + rawNanoList.Count);
List <string> ItemNamesSql = new List <string>();
foreach (int recnum in extractor.GetRecordInstances(0xF4254))
{
rawItemList.Add(np.ParseItem(0xF4254, recnum, extractor.GetRecordData(0xF4254, recnum), ItemNamesSql));
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Compacting itemnames.sql");
TextWriter itnsql = new StreamWriter("itemnames.sql", true, Encoding.GetEncoding("windows-1252"));
while (ItemNamesSql.Count > 0)
{
int count = 0;
string toWrite = string.Empty;
while ((count < 20) && (ItemNamesSql.Count > 0))
{
if (toWrite.Length > 0)
{
toWrite += ",";
}
toWrite += ItemNamesSql[0];
ItemNamesSql.RemoveAt(0);
count++;
}
if (toWrite != string.Empty)
{
itnsql.WriteLine("INSERT INTO itemnames VALUES " + toWrite + ";");
}
}
itnsql.Close();
// SerializationContext.Default.Serializers.Register(new AOFunctionArgumentsSerializer());
Console.WriteLine();
Console.WriteLine("Items extracted: " + rawItemList.Count);
Console.WriteLine();
Console.WriteLine("Creating serialized nano data file - please wait");
Stream sf = new FileStream("nanos.dat", FileMode.Create);
var ds = new ZOutputStream(sf, zlibConst.Z_BEST_COMPRESSION);
var sm = new MemoryStream();
MessagePackSerializer <List <AONanos> > bf = MessagePackSerializer.Create <List <AONanos> >();
var nanoList2 = new List <AONanos>();
int maxnum = 5000;
byte[] buffer = BitConverter.GetBytes(maxnum);
sm.Write(buffer, 0, buffer.Length);
foreach (AONanos nanos in rawNanoList)
{
nanoList2.Add(nanos);
if (nanoList2.Count == maxnum)
{
bf.Pack(sm, nanoList2);
sm.Flush();
nanoList2.Clear();
}
}
bf.Pack(sm, nanoList2);
sm.Seek(0, SeekOrigin.Begin);
CopyStream(sm, ds);
sm.Close();
ds.Close();
Console.WriteLine();
Console.WriteLine("Checking Nanos...");
Console.WriteLine();
NanoHandler.CacheAllNanos("nanos.dat");
Console.WriteLine();
Console.WriteLine("Nanos: " + NanoHandler.NanoList.Count + " successfully converted");
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Creating serialized item data file - please wait");
sf = new FileStream("items.dat", FileMode.Create);
ds = new ZOutputStream(sf, zlibConst.Z_BEST_COMPRESSION);
sm = new MemoryStream();
MessagePackSerializer <List <AOItem> > bf2 = MessagePackSerializer.Create <List <AOItem> >();
List <AOItem> items = new List <AOItem>();
maxnum = 5000;
buffer = BitConverter.GetBytes(maxnum);
sm.Write(buffer, 0, buffer.Length);
foreach (AOItem it in rawItemList)
{
items.Add(it);
if (items.Count == maxnum)
{
bf2.Pack(sm, items);
sm.Flush();
items.Clear();
}
}
bf2.Pack(sm, items);
sm.Seek(0, SeekOrigin.Begin);
CopyStream(sm, ds);
sm.Close();
ds.Close();
Console.WriteLine();
Console.WriteLine("Checking Items...");
Console.WriteLine();
ItemHandler.CacheAllItems("items.dat");
Console.WriteLine("Items: " + ItemHandler.ItemList.Count + " successfully converted");
Console.WriteLine();
Console.WriteLine("Further Instructions:");
Console.WriteLine("- Copy items.dat and nanos.dat into your CellAO folder and overwrite.");
Console.WriteLine("- Apply itemnames.sql to your database");
Console.WriteLine("Press Enter to exit and have fun with CellAO");
Console.ReadLine();
}
/// <summary>
/// The main.
/// </summary>
/// <param name="args">
/// The args.
/// </param>
private static void Main(string[] args)
{
Console.WriteLine("**********************************************************************");
Console.WriteLine("** **");
Console.WriteLine("** AO Item and Nano Extractor/Serializer v0.85beta **");
Console.WriteLine("** **");
Console.WriteLine("**********************************************************************");
Console.WriteLine();
string AOPath = string.Empty;
bool foundAO = false;
Console.WriteLine("Enter exit to close program");
while (!foundAO)
{
if (File.Exists("config.txt"))
{
TextReader tr = new StreamReader("config.txt");
AOPath = tr.ReadLine();
tr.Close();
}
foundAO = false;
Console.Write("Please enter your AO Install Path [" + AOPath + "]:");
string temp = Console.ReadLine();
if (temp != string.Empty)
{
AOPath = temp;
}
if (temp.ToLower() == "exit")
{
return;
}
if (!Directory.Exists(AOPath))
{
continue;
}
try
{
extractor = new Extractor(AOPath);
TextWriter tw2 = new StreamWriter("config.txt", false, Encoding.GetEncoding("windows-1252"));
tw2.WriteLine(AOPath);
tw2.Close();
foundAO = true;
Console.WriteLine("Found AO Database on " + AOPath);
}
catch (Exception)
{
foundAO = false;
}
// Try to add cd_image\data\db
if (!foundAO)
{
try
{
AOPath = Path.Combine(AOPath, "cd_image\\data\\db");
extractor = new Extractor(AOPath);
TextWriter tw2 = new StreamWriter("config.txt", false, Encoding.GetEncoding("windows-1252"));
tw2.WriteLine(AOPath);
tw2.Close();
foundAO = true;
Console.WriteLine("Found AO Database on " + AOPath);
}
catch (Exception)
{
foundAO = false;
}
}
}
TextWriter tw = new StreamWriter("itemnames.sql", false, Encoding.GetEncoding("windows-1252"));
tw.WriteLine("DROP TABLE IF EXISTS `itemnames`;");
tw.WriteLine("CREATE TABLE `itemnames` (");
tw.WriteLine(" `AOID` int(10) NOT NULL,");
tw.WriteLine(" `Name` varchar(250) NOT NULL,");
tw.WriteLine(" PRIMARY KEY (`AOID`)");
tw.WriteLine(") ENGINE=MyIsam DEFAULT CHARSET=latin1;");
tw.WriteLine();
tw.Close();
Console.WriteLine("Number of Items to extract: " + extractor.GetRecordInstances(0xF4254).Length);
// ITEM RECORD TYPE
Console.WriteLine("Number of Nanos to extract: " + extractor.GetRecordInstances(0xFDE85).Length);
// NANO RECORD TYPE
// Console.WriteLine(extractor.GetRecordInstances(0xF4241).Length); // Playfields
// Console.WriteLine(extractor.GetRecordInstances(0xF4266).Length); // Nano Strains
// Console.WriteLine(extractor.GetRecordInstances(0xF4264).Length); // Perks
// GetData(@"D:\c#\extractor serializer\data\items\",0xf4254);
// GetData(@"D:\c#\extractor serializer\data\nanos\",0xfde85);
// GetData(@"D:\c#\extractor serializer\data\playfields\",0xf4241);
// GetData(@"D:\c#\extractor serializer\data\nanostrains\",0xf4266);
// GetData(@"D:\c#\extractor serializer\data\perks\",0xf4264);
var np = new NewParser();
var rawItemList = new List<AOItem>();
var rawNanoList = new List<AONanos>();
foreach (int recnum in extractor.GetRecordInstances(0xFDE85))
{
rawNanoList.Add(np.ParseNano(0xFDE85, recnum, extractor.GetRecordData(0xFDE85, recnum), "temp.sql"));
}
File.Delete("temp.sql");
Console.WriteLine();
Console.WriteLine("Nanos extracted: " + rawNanoList.Count);
List<string> ItemNamesSql = new List<string>();
foreach (int recnum in extractor.GetRecordInstances(0xF4254))
{
rawItemList.Add(np.ParseItem(0xF4254, recnum, extractor.GetRecordData(0xF4254, recnum), ItemNamesSql));
}
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Compacting itemnames.sql");
TextWriter itnsql = new StreamWriter("itemnames.sql", true, Encoding.GetEncoding("windows-1252"));
while (ItemNamesSql.Count > 0)
{
int count = 0;
string toWrite = string.Empty;
while ((count < 20) && (ItemNamesSql.Count > 0))
{
if (toWrite.Length > 0)
{
toWrite += ",";
}
toWrite += ItemNamesSql[0];
ItemNamesSql.RemoveAt(0);
count++;
}
if (toWrite != string.Empty)
{
itnsql.WriteLine("INSERT INTO itemnames VALUES " + toWrite + ";");
}
}
itnsql.Close();
// SerializationContext.Default.Serializers.Register(new AOFunctionArgumentsSerializer());
Console.WriteLine();
Console.WriteLine("Items extracted: " + rawItemList.Count);
Console.WriteLine();
Console.WriteLine("Creating serialized nano data file - please wait");
Stream sf = new FileStream("nanos.dat", FileMode.Create);
var ds = new ZOutputStream(sf, zlibConst.Z_BEST_COMPRESSION);
var sm = new MemoryStream();
MessagePackSerializer<List<AONanos>> bf = MessagePackSerializer.Create<List<AONanos>>();
var nanoList2 = new List<AONanos>();
int maxnum = 5000;
byte[] buffer = BitConverter.GetBytes(maxnum);
sm.Write(buffer, 0, buffer.Length);
foreach (AONanos nanos in rawNanoList)
{
nanoList2.Add(nanos);
if (nanoList2.Count == maxnum)
{
bf.Pack(sm, nanoList2);
sm.Flush();
nanoList2.Clear();
}
}
bf.Pack(sm, nanoList2);
sm.Seek(0, SeekOrigin.Begin);
CopyStream(sm, ds);
sm.Close();
ds.Close();
Console.WriteLine();
Console.WriteLine("Checking Nanos...");
Console.WriteLine();
NanoHandler.CacheAllNanos("nanos.dat");
Console.WriteLine();
Console.WriteLine("Nanos: " + NanoHandler.NanoList.Count + " successfully converted");
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("Creating serialized item data file - please wait");
sf = new FileStream("items.dat", FileMode.Create);
ds = new ZOutputStream(sf, zlibConst.Z_BEST_COMPRESSION);
sm = new MemoryStream();
MessagePackSerializer<List<AOItem>> bf2 = MessagePackSerializer.Create<List<AOItem>>();
List<AOItem> items = new List<AOItem>();
maxnum = 5000;
buffer = BitConverter.GetBytes(maxnum);
sm.Write(buffer, 0, buffer.Length);
foreach (AOItem it in rawItemList)
{
items.Add(it);
if (items.Count == maxnum)
{
bf2.Pack(sm, items);
sm.Flush();
items.Clear();
}
}
bf2.Pack(sm, items);
sm.Seek(0, SeekOrigin.Begin);
CopyStream(sm, ds);
sm.Close();
ds.Close();
Console.WriteLine();
Console.WriteLine("Checking Items...");
Console.WriteLine();
ItemHandler.CacheAllItems("items.dat");
Console.WriteLine("Items: " + ItemHandler.ItemList.Count + " successfully converted");
Console.WriteLine();
Console.WriteLine("Further Instructions:");
Console.WriteLine("- Copy items.dat and nanos.dat into your CellAO folder and overwrite.");
Console.WriteLine("- Apply itemnames.sql to your database");
Console.WriteLine("Press Enter to exit and have fun with CellAO");
Console.ReadLine();
}
/// <summary>
/// </summary>
/// <param name="ItemNamesSql">
/// </param>
/// <returns>
/// </returns>
private static List<ItemTemplate> ExtractItemTemplates(List<string> ItemNamesSql)
{
var np = new NewParser();
List<ItemTemplate> rawItemList = new List<ItemTemplate>(extractor.GetRecordInstanceCount(0xF4254));
rawItemDictionary = new Dictionary<int, ItemTemplate>(extractor.GetRecordInstanceCount(0xF4254));
int counter = 0;
foreach (int recnum in extractor.GetRecordInstances(0xF4254))
{
ItemTemplate xt = np.ParseItem(0xF4254, recnum, extractor.GetRecordData(0xF4254, recnum), ItemNamesSql);
rawItemList.Add(xt);
rawItemDictionary.Add(recnum, xt);
if ((counter % 7500) == 0)
{
Console.Write("\rItem ID: " + recnum.ToString().PadLeft(9));
}
counter++;
}
Console.Write("\rItem ID: " + rawItemList[rawItemList.Count - 1].ID.ToString().PadLeft(9));
Console.WriteLine();
return rawItemList;
}
