public static void DbSqlMobSkills <TKey>(DbDebugItem <TKey> debug, AbstractDb <TKey> db)
{
DbSqlWriter writer = new DbSqlWriter();
writer.Init(debug);
DbWriterMethods.DbUniqueWriter(debug, db);
if (debug.DestinationServer == ServerType.RAthena)
{
writer.AppendHeader(RAthenaMobSkillDbSqlHeader);
}
else if (debug.DestinationServer == ServerType.Hercules)
{
writer.AppendHeader(HerculesMobSkillDbSqlHeader, writer.TableName.Replace("_re", ""));
writer.TableName = "mob_skill_db";
}
foreach (string line in writer.Read())
{
string[] elements = TextFileHelper.ExcludeBrackets(line.Trim('\t'));
if (!_getMobSkill(writer.IsHercules, writer.TableName, writer.Builder, elements))
{
writer.Line(writer.IsHercules ? line.ReplaceFirst("//", "-- ") : line.ReplaceFirst("//", "#"));
}
}
writer.Write();
}
public static void DbSqlItems <TKey>(DbDebugItem <TKey> debug, AbstractDb <TKey> db)
{
DbSqlWriter writer = new DbSqlWriter();
writer.Init(debug);
if (debug.DestinationServer == ServerType.RAthena)
{
DbWriterMethods.DbItemsCommaWriter(debug, db);
writer.AppendHeader(writer.IsRenewal ? RAthenaItemDbSqlHeaderRenewal : RAthenaItemDbSqlHeader);
foreach (string line in writer.Read())
{
string[] elements = TextFileHelper.ExcludeBrackets(line.Trim('\t'));
if (!_getItems(writer.IsRenewal, writer.TableName, writer.Builder, elements))
{
writer.Line(line.ReplaceFirst("//", "#"));
}
}
}
else
{
var table = db.Table;
writer.AppendHeader(HerculesItemDbSqlHeader, writer.TableName.Replace("_re", ""));
foreach (var tuple in table.FastItems.OrderBy(p => p.GetKey <TKey>()))
{
_getItemsHercules(writer.TableName, writer.Builder, tuple);
}
}
writer.Write();
}