private static void ExportToXml()
{
var con = new MySQLWrapper("dbc_406", false);
var areatable = con.ExecuteGetDataTable("select * from areatable");
var areatableList = new List<AreaTable>();
foreach (System.Data.DataRow row in areatable.Rows)
{
areatableList.Add(new AreaTable()
{
Id = int.Parse(row[0].ToString()),
MapId = int.Parse(row[1].ToString()),
ZoneId = int.Parse(row[2].ToString()),
Name = row[11].ToString()
});
}
using (var sw = new System.IO.StreamWriter("AreaTable.xml"))
{
sw.Write(areatableList.ToXml());
}
var map = con.ExecuteGetDataTable("select * from map");
var mapList = new List<Map>();
foreach (System.Data.DataRow row in map.Rows)
{
mapList.Add(new Map()
{
Id = int.Parse(row[0].ToString()),
Name = row[1].ToString(),
LongName = row[6].ToString()
});
}
using (var sw = new System.IO.StreamWriter("Map.xml"))
{
sw.Write(mapList.ToXml());
}
var gameobjectdisplayinfo = con.ExecuteGetDataTable("select * from gameobjectdisplayinfo");
var gameobjectdisplayinfoList = new List<GameObjectDisplayInfo>();
foreach (System.Data.DataRow row in gameobjectdisplayinfo.Rows)
{
gameobjectdisplayinfoList.Add(new GameObjectDisplayInfo()
{
Id = int.Parse(row[0].ToString()),
FileName = row[1].ToString(),
});
}
using (var sw = new System.IO.StreamWriter("GameObjectDisplayInfo.xml"))
{
sw.Write(gameobjectdisplayinfoList.ToXml());
}
}
private static void ExportToSQLite()
{
var con = new MySQLWrapper("dbc_406", false);
// Basic connection
using (var consql = new SQLiteConnection())
{
var filename = "maximusradar.db";
if (System.IO.File.Exists(filename)) System.IO.File.Delete(filename);
consql.ConnectionString = "Data Source=" + filename;
consql.Open();
//create tables
using (var command = new SQLiteCommand(consql))
{
command.CommandText = "CREATE TABLE IF NOT EXISTS AreaTable ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, MapId INTEGER NOT NULL, ZoneId INTEGER NOT NULL, Name VARCHAR(100) NOT NULL);";
command.ExecuteNonQuery();
command.CommandText = "CREATE TABLE IF NOT EXISTS Map ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Name VARCHAR(100) NOT NULL, LongName VARCHAR(100) NOT NULL);";
command.ExecuteNonQuery();
command.CommandText = "CREATE TABLE IF NOT EXISTS GameObjectDisplayInfo ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FileName VARCHAR(100) NOT NULL);";
command.ExecuteNonQuery();
}
//AreaTable
using (var trans = consql.BeginTransaction())
{
using (var command = consql.CreateCommand())
{
command.CommandText = "insert into AreaTable (id, MapId, ZoneId, Name) VALUES (?,?,?,?);";
var id = command.CreateParameter();
id.DbType = System.Data.DbType.Int32;
command.Parameters.Add(id);
var MapId = command.CreateParameter();
MapId.DbType = System.Data.DbType.Int32;
command.Parameters.Add(MapId);
var ZoneId = command.CreateParameter();
ZoneId.DbType = System.Data.DbType.Int32;
command.Parameters.Add(ZoneId);
var Name = command.CreateParameter();
Name.DbType = System.Data.DbType.String;
command.Parameters.Add(Name);
var table = con.ExecuteGetDataTable("select * from areatable");
foreach (System.Data.DataRow row in table.Rows)
{
try
{
id.Value = int.Parse(row[0].ToString());
MapId.Value = int.Parse(row[1].ToString());
ZoneId.Value = int.Parse(row[2].ToString());
Name.Value = row[11].ToSQLite();
if (command.ExecuteNonQuery() <= 0)
{
throw new Exception("record not inserted?");
}
}
catch (Exception exc)
{
Console.WriteLine("Error: {0}", exc.Message);
}
}
}
trans.Commit();
}
//Map
using (var trans = consql.BeginTransaction())
{
using (var command = consql.CreateCommand())
{
command.CommandText = "insert into Map (id, Name, LongName) VALUES (?,?,?)";
var id = command.CreateParameter();
id.DbType = System.Data.DbType.Int32;
command.Parameters.Add(id);
var Name = command.CreateParameter();
Name.DbType = System.Data.DbType.String;
command.Parameters.Add(Name);
var LongName = command.CreateParameter();
LongName.DbType = System.Data.DbType.String;
command.Parameters.Add(LongName);
var table = con.ExecuteGetDataTable("select * from map");
foreach (System.Data.DataRow row in table.Rows)
{
try
{
id.Value = int.Parse(row[0].ToString());
Name.Value = row[1].ToSQLite();
LongName.Value = row[2].ToSQLite();
if (command.ExecuteNonQuery() <= 0)
{
throw new Exception("record not inserted?");
}
}
catch (Exception exc)
{
Console.WriteLine("Error: {0}", exc.Message);
}
}
}
trans.Commit();
}
//GameObjectDisplayInfo
using (var trans = consql.BeginTransaction())
{
using (var command = consql.CreateCommand())
{
command.CommandText = "insert into GameObjectDisplayInfo (id, FileName) VALUES (?,?)";
var id = command.CreateParameter();
id.DbType = System.Data.DbType.Int32;
command.Parameters.Add(id);
var FileName = command.CreateParameter();
FileName.DbType = System.Data.DbType.String;
command.Parameters.Add(FileName);
var table = con.ExecuteGetDataTable("select * from gameobjectdisplayinfo");
foreach (System.Data.DataRow row in table.Rows)
{
try
{
id.Value = int.Parse(row[0].ToString());
FileName.Value = row[1].ToSQLite();
if (command.ExecuteNonQuery() <= 0)
{
throw new Exception("record not inserted?");
}
}
catch (Exception exc)
{
Console.WriteLine("Error: {0}", exc.Message);
}
}
}
trans.Commit();
}
}
}
