public static void SaveMapDump(MySql database, string mapID, MapDump mapDump)
{
mapID = database.VerifyValueString(mapID);
bool localTransaction = false;
if (database.IsTransactionActive == false)
{
database.BeginTransaction();
localTransaction = true;
}
SaveRawMap(database, mapID, mapDump);
// Save map state data
database.UpdateOrInsert("mapstate_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "ActivationTime", mapDump.ActivationTime.ToString()),
database.CreateColumn(false, "ProcessingPaused", mapDump.ProcessingPaused.ToIntString()),
database.CreateColumn(false, "SpawnMarker", mapDump.SpawnMarker.ToString()),
database.CreateColumn(false, "NpcSpawnWait", mapDump.NpcSpawnWait.ToString()),
database.CreateColumn(false, "TempChange", mapDump.TempChange.ToIntString()),
database.CreateColumn(false, "CurrentWeather", mapDump.CurrentWeather.ToString())
});
// Save active item data
MultiRowInsert multiRowInsert = new MultiRowInsert(database, "mapstate_activeitem", "MapID", "Slot", "Number", "Value",
"Sticky", "Tag", "Hidden", "X", "Y", "TimeRemaining", "ItemOwner");
for (int i = 0; i < mapDump.ActiveItem.Length; i++)
{
if (mapDump.ActiveItem[i].Num > 0)
{
MapItem item = mapDump.ActiveItem[i];
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, item.Num, item.Value);
multiRowInsert.AddColumnData(item.Sticky.ToIntString(), item.Tag, item.Hidden.ToIntString());
multiRowInsert.AddColumnData(item.X, item.Y, item.TimeRemaining);
multiRowInsert.AddColumnData(item.PlayerFor);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npcs
multiRowInsert.UpdateParameters("mapstate_activenpc_data", new string[] { "MapID", "MapNpcSlot", "Name", "Shiny", "Form", "Level",
"NpcNumber", "Sex",
"AttackTimer", "PauseTimer", "StatusAilment", "StatusAilmentCounter", "HPStepCounter",
"Target" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++)
{
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(npc.Name, npc.Shiny.ToString());
multiRowInsert.AddColumnData(npc.Form, npc.Level, npc.Num, (int)npc.Sex);
multiRowInsert.AddColumnData(npc.AttackTimer, npc.PauseTimer, (int)npc.StatusAilment, npc.StatusAilmentCounter,
npc.HPStepCounter);
multiRowInsert.AddColumnData(npc.Target);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc held items
multiRowInsert.UpdateParameters("mapstate_activenpc_helditem", new string[] { "MapID", "MapNpcSlot",
"ItemNumber", "Amount", "Sticky", "Tag" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++)
{
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0 && mapDump.ActiveNpc[i].HeldItem.Num > 0)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
//multiRowInsert.AddColumnData(npc.ItemActive.ToIntString());
//if (npc.HeldItem != null) {
// The npc is holding an item - save the held item information
multiRowInsert.AddColumnData(npc.HeldItem.Num, npc.HeldItem.Amount);
multiRowInsert.AddColumnData(npc.HeldItem.Sticky.ToIntString(), npc.HeldItem.Tag);
//} else {
// The npc is not holding an item! Save default information
// multiRowInsert.AddColumnData(-1, 0, 0);
// multiRowInsert.AddColumnData("");
//}
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc locations
multiRowInsert.UpdateParameters("mapstate_activenpc_location", new string[] { "MapID", "MapNpcSlot", "X", "Y", "Direction" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++)
{
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(npc.X, npc.Y, (int)npc.Direction);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc stats
multiRowInsert.UpdateParameters("mapstate_activenpc_stats", new string[] { "MapID", "MapNpcSlot", "IQ", "HP", "HPRemainder",
"MaxHPBonus", "AtkBonus", "DefBonus",
"SpdBonus", "SpclAtkBonus", "SpclDefBonus",
"AttackBuff", "DefenseBuff", "SpAtkBuff", "SpDefBuff", "SpeedBuff", "AccuracyBuff", "EvasionBuff" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++)
{
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(npc.IQ, npc.HP, npc.HPRemainder,
npc.MaxHPBonus, npc.AtkBonus, npc.DefBonus,
npc.SpdBonus, npc.SpclAtkBonus, npc.SpclDefBonus,
npc.AttackBuff, npc.DefenseBuff, npc.SpAtkBuff, npc.SpDefBuff,
npc.SpeedBuff, npc.AccuracyBuff, npc.EvasionBuff);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc moves
multiRowInsert.UpdateParameters("mapstate_activenpc_moves", new string[] { "MapID", "MapNpcSlot", "MoveSlot", "CurrentPP", "MaxPP", "MoveNum" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++)
{
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0)
{
for (int n = 0; n < npc.Moves.Length; n++)
{
if (npc.Moves[n].MoveNum > 0)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, n);
multiRowInsert.AddColumnData(npc.Moves[n].CurrentPP, npc.Moves[n].MaxPP, npc.Moves[n].MoveNum);
//multiRowInsert.AddColumnData(npc.Moves[n].Sealed.ToIntString());
multiRowInsert.AddRowClosing();
}
}
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc mobility
//multiRowInsert.UpdateParameters("mapstate_activenpc_mobility", new string[] { "MapID", "MapNpcSlot", "MobilitySlot", "Mobile" });
//for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
// MapNpc npc = mapDump.ActiveNpc[i];
// for (int n = 0; n < npc.Mobility.Length; n++) {
// multiRowInsert.AddRowOpening();
// multiRowInsert.AddColumnData(mapID);
// multiRowInsert.AddColumnData(i, n);
// multiRowInsert.AddColumnData(npc.Mobility[n].ToIntString());
// multiRowInsert.AddRowClosing();
// }
//}
//database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc volatile status
multiRowInsert.UpdateParameters("mapstate_activenpc_volatilestatus", new string[] { "MapID", "MapNpcSlot", "StatusIndex", "Name", "Emoticon", "Counter", "Tag" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++)
{
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0)
{
for (int n = 0; n < npc.VolatileStatus.Count; n++)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, n);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Name);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Emoticon);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Counter);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Tag);
multiRowInsert.AddRowClosing();
}
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save map status
multiRowInsert.UpdateParameters("mapstate_mapstatus", new string[] { "MapID", "StatusIndex", "Name", "Tag", "GraphicEffect", "Counter" });
for (int i = 0; i < mapDump.TempStatus.Count; i++)
{
MapStatus status = mapDump.TempStatus[i];
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(status.Name);
multiRowInsert.AddColumnData(status.Tag);
multiRowInsert.AddColumnData(status.GraphicEffect);
multiRowInsert.AddColumnData(status.Counter);
multiRowInsert.AddRowClosing();
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
if (localTransaction)
{
database.EndTransaction();
}
}
public static void SaveMapDump(MySql database, string mapID, MapDump mapDump)
{
mapID = database.VerifyValueString(mapID);
bool localTransaction = false;
if (database.IsTransactionActive == false) {
database.BeginTransaction();
localTransaction = true;
}
SaveRawMap(database, mapID, mapDump);
// Save map state data
database.UpdateOrInsert("mapstate_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "ActivationTime", mapDump.ActivationTime.ToString()),
database.CreateColumn(false, "ProcessingPaused", mapDump.ProcessingPaused.ToIntString()),
database.CreateColumn(false, "SpawnMarker", mapDump.SpawnMarker.ToString()),
database.CreateColumn(false, "NpcSpawnWait", mapDump.NpcSpawnWait.ToString()),
database.CreateColumn(false, "TempChange", mapDump.TempChange.ToIntString()),
database.CreateColumn(false, "CurrentWeather", mapDump.CurrentWeather.ToString())
});
// Save active item data
MultiRowInsert multiRowInsert = new MultiRowInsert(database, "mapstate_activeitem", "MapID", "Slot", "Number", "Value",
"Sticky", "Tag", "Hidden", "X", "Y", "TimeRemaining", "ItemOwner");
for (int i = 0; i < mapDump.ActiveItem.Length; i++) {
if (mapDump.ActiveItem[i].Num > 0) {
MapItem item = mapDump.ActiveItem[i];
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, item.Num, item.Value);
multiRowInsert.AddColumnData(item.Sticky.ToIntString(), item.Tag, item.Hidden.ToIntString());
multiRowInsert.AddColumnData(item.X, item.Y, item.TimeRemaining);
multiRowInsert.AddColumnData(item.PlayerFor);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npcs
multiRowInsert.UpdateParameters("mapstate_activenpc_data", new string[] {"MapID", "MapNpcSlot", "Name", "Shiny", "Form", "Level",
"NpcNumber", "Sex",
"AttackTimer", "PauseTimer", "StatusAilment", "StatusAilmentCounter", "HPStepCounter",
"Target" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(npc.Name, npc.Shiny.ToString());
multiRowInsert.AddColumnData(npc.Form, npc.Level, npc.Num, (int)npc.Sex);
multiRowInsert.AddColumnData(npc.AttackTimer, npc.PauseTimer, (int)npc.StatusAilment, npc.StatusAilmentCounter,
npc.HPStepCounter);
multiRowInsert.AddColumnData(npc.Target);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc held items
multiRowInsert.UpdateParameters("mapstate_activenpc_helditem", new string[] {"MapID", "MapNpcSlot",
"ItemNumber", "Amount", "Sticky", "Tag" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0 && mapDump.ActiveNpc[i].HeldItem.Num > 0) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
//multiRowInsert.AddColumnData(npc.ItemActive.ToIntString());
//if (npc.HeldItem != null) {
// The npc is holding an item - save the held item information
multiRowInsert.AddColumnData(npc.HeldItem.Num, npc.HeldItem.Amount);
multiRowInsert.AddColumnData(npc.HeldItem.Sticky.ToIntString(), npc.HeldItem.Tag);
//} else {
// The npc is not holding an item! Save default information
// multiRowInsert.AddColumnData(-1, 0, 0);
// multiRowInsert.AddColumnData("");
//}
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc locations
multiRowInsert.UpdateParameters("mapstate_activenpc_location", new string[] { "MapID", "MapNpcSlot", "X", "Y", "Direction" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(npc.X, npc.Y, (int)npc.Direction);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc stats
multiRowInsert.UpdateParameters("mapstate_activenpc_stats", new string[] { "MapID", "MapNpcSlot", "IQ", "HP", "HPRemainder",
"MaxHPBonus", "AtkBonus", "DefBonus",
"SpdBonus", "SpclAtkBonus", "SpclDefBonus",
"AttackBuff", "DefenseBuff", "SpAtkBuff", "SpDefBuff", "SpeedBuff", "AccuracyBuff", "EvasionBuff" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(npc.IQ, npc.HP, npc.HPRemainder,
npc.MaxHPBonus, npc.AtkBonus, npc.DefBonus,
npc.SpdBonus, npc.SpclAtkBonus, npc.SpclDefBonus,
npc.AttackBuff, npc.DefenseBuff, npc.SpAtkBuff, npc.SpDefBuff,
npc.SpeedBuff, npc.AccuracyBuff, npc.EvasionBuff);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc moves
multiRowInsert.UpdateParameters("mapstate_activenpc_moves", new string[] { "MapID", "MapNpcSlot", "MoveSlot", "CurrentPP", "MaxPP", "MoveNum" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0) {
for (int n = 0; n < npc.Moves.Length; n++) {
if (npc.Moves[n].MoveNum > 0) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, n);
multiRowInsert.AddColumnData(npc.Moves[n].CurrentPP, npc.Moves[n].MaxPP, npc.Moves[n].MoveNum);
//multiRowInsert.AddColumnData(npc.Moves[n].Sealed.ToIntString());
multiRowInsert.AddRowClosing();
}
}
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc mobility
//multiRowInsert.UpdateParameters("mapstate_activenpc_mobility", new string[] { "MapID", "MapNpcSlot", "MobilitySlot", "Mobile" });
//for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
// MapNpc npc = mapDump.ActiveNpc[i];
// for (int n = 0; n < npc.Mobility.Length; n++) {
// multiRowInsert.AddRowOpening();
// multiRowInsert.AddColumnData(mapID);
// multiRowInsert.AddColumnData(i, n);
// multiRowInsert.AddColumnData(npc.Mobility[n].ToIntString());
// multiRowInsert.AddRowClosing();
// }
//}
//database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save active npc volatile status
multiRowInsert.UpdateParameters("mapstate_activenpc_volatilestatus", new string[] { "MapID", "MapNpcSlot", "StatusIndex", "Name", "Emoticon", "Counter", "Tag" });
for (int i = 0; i < mapDump.ActiveNpc.Length; i++) {
MapNpc npc = mapDump.ActiveNpc[i];
if (mapDump.ActiveNpc[i].Num > 0) {
for (int n = 0; n < npc.VolatileStatus.Count; n++) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, n);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Name);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Emoticon);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Counter);
multiRowInsert.AddColumnData(npc.VolatileStatus[n].Tag);
multiRowInsert.AddRowClosing();
}
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
// Save map status
multiRowInsert.UpdateParameters("mapstate_mapstatus", new string[] { "MapID", "StatusIndex", "Name", "Tag", "GraphicEffect", "Counter" });
for (int i = 0; i < mapDump.TempStatus.Count; i++) {
MapStatus status = mapDump.TempStatus[i];
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i);
multiRowInsert.AddColumnData(status.Name);
multiRowInsert.AddColumnData(status.Tag);
multiRowInsert.AddColumnData(status.GraphicEffect);
multiRowInsert.AddColumnData(status.Counter);
multiRowInsert.AddRowClosing();
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
if (localTransaction) {
database.EndTransaction();
}
}
public static void LoadMapDump(MySql database, string mapID, MapDump mapDump)
{
// First, load the raw map data
LoadRawMap(database, mapID, mapDump);
mapID = database.VerifyValueString(mapID);
// Load map state data
string query = "SELECT mapstate_data.ActivationTime, mapstate_data.ProcessingPaused, mapstate_data.SpawnMarker, " +
"mapstate_data.NpcSpawnWait, mapstate_data.TempChange, mapstate_data.CurrentWeather " +
"FROM mapstate_data WHERE mapstate_data.MapID = \'" + mapID + "\'";;
{
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
int counter = 0;
mapDump.ActivationTime = Convert.ToInt32(row[counter++].Value);
mapDump.ProcessingPaused = row[counter++].ValueString.ToBool();
mapDump.SpawnMarker = Convert.ToInt32(row[counter++].Value);
mapDump.NpcSpawnWait = Convert.ToInt32(row[counter++].Value);
mapDump.TempChange = row[counter++].ValueString.ToBool();
mapDump.CurrentWeather = Convert.ToByte(row[counter++].Value);
}
else
{
throw new Exception("Map state data not found");
}
}
{ // Load map active items
query = "SELECT mapstate_activeitem.Slot, mapstate_activeitem.Number, mapstate_activeitem.Value, mapstate_activeitem.Sticky, " +
"mapstate_activeitem.Tag, mapstate_activeitem.Hidden, mapstate_activeitem.X, mapstate_activeitem.Y, " +
"mapstate_activeitem.TimeRemaining, mapstate_activeitem.ItemOwner " +
"FROM mapstate_activeitem WHERE mapstate_activeitem.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query))
{
MapItem mapItem = new MapItem();
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
mapItem.Num = Convert.ToInt32(row[counter++].Value);
mapItem.Value = Convert.ToInt32(row[counter++].Value);
mapItem.Sticky = row[counter++].ValueString.ToBool();
mapItem.Tag = row[counter++].ValueString;
mapItem.Hidden = row[counter++].ValueString.ToBool();
mapItem.X = Convert.ToInt32(row[counter++].Value);
mapItem.Y = Convert.ToInt32(row[counter++].Value);
mapItem.TimeRemaining = Convert.ToInt32(row[counter++].Value);
mapItem.PlayerFor = row[counter++].ValueString;
mapDump.ActiveItem[slot] = mapItem;
}
}
{ // Load map active npcs
query = "SELECT mapstate_activenpc_data.MapNpcSlot, mapstate_activenpc_data.Name, mapstate_activenpc_data.Shiny, mapstate_activenpc_data.Form, " +
"mapstate_activenpc_data.Level, mapstate_activenpc_data.NpcNumber, mapstate_activenpc_data.Sex, " +
"mapstate_activenpc_data.AttackTimer, mapstate_activenpc_data.PauseTimer, mapstate_activenpc_data.StatusAilment, " +
"mapstate_activenpc_data.StatusAilmentCounter, mapstate_activenpc_data.HPStepCounter, " +
"mapstate_activenpc_data.Target, " +
"mapstate_activenpc_location.X, mapstate_activenpc_location.Y, mapstate_activenpc_location.Direction, " +
"mapstate_activenpc_stats.IQ, mapstate_activenpc_stats.HP, mapstate_activenpc_stats.HPRemainder, " +
"mapstate_activenpc_stats.MaxHPBonus, mapstate_activenpc_stats.AtkBonus, mapstate_activenpc_stats.DefBonus, " +
"mapstate_activenpc_stats.SpdBonus, mapstate_activenpc_stats.SpclAtkBonus, mapstate_activenpc_stats.SpclDefBonus, " +
"mapstate_activenpc_stats.AttackBuff, " +
"mapstate_activenpc_stats.DefenseBuff, mapstate_activenpc_stats.SpAtkBuff, mapstate_activenpc_stats.SpDefBuff, mapstate_activenpc_stats.SpeedBuff, " +
"mapstate_activenpc_stats.AccuracyBuff, mapstate_activenpc_stats.EvasionBuff " +
"FROM mapstate_activenpc_data " +
"LEFT OUTER JOIN mapstate_activenpc_location ON mapstate_activenpc_data.MapID = mapstate_activenpc_location.MapID AND mapstate_activenpc_data.MapNpcSlot = mapstate_activenpc_location.MapNpcSlot " +
"JOIN mapstate_activenpc_stats ON mapstate_activenpc_data.MapID = mapstate_activenpc_stats.MapID AND mapstate_activenpc_data.MapNpcSlot = mapstate_activenpc_stats.MapNpcSlot " +
"WHERE mapstate_activenpc_data.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query))
{
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
MapNpc npc = new MapNpc(slot);
npc.Name = row[counter++].ValueString;
npc.Shiny = Convert.ToByte(row[counter++].Value);
npc.Form = Convert.ToInt32(row[counter++].Value);
npc.Level = Convert.ToInt32(row[counter++].Value);
npc.Num = Convert.ToInt32(row[counter++].Value);
//npc.Sprite = Convert.ToInt32(row[counter++].Value);
npc.Sex = Convert.ToByte(row[counter++].Value);
//npc.Type1 = Convert.ToByte(row[counter++].Value);
//npc.Type2 = Convert.ToByte(row[counter++].Value);
//npc.Ability1 = row[counter++].ValueString;
//npc.Ability2 = row[counter++].ValueString;
//npc.Ability3 = row[counter++].ValueString;
//npc.TimeMultiplier = Convert.ToInt32(row[counter++].Value);
npc.AttackTimer = Convert.ToInt32(row[counter++].Value);
npc.PauseTimer = Convert.ToInt32(row[counter++].Value);
npc.StatusAilment = Convert.ToByte(row[counter++].Value);
npc.StatusAilmentCounter = Convert.ToInt32(row[counter++].Value);
npc.HPStepCounter = Convert.ToInt32(row[counter++].Value);
//npc.ConfusionStepCounter = Convert.ToInt32(row[counter++].Value);
//npc.SpeedLimit = Convert.ToByte(row[counter++].Value);
npc.Target = row[counter++].ValueString;
//npc.ItemActive = row[counter++].ValueString.ToBool();
// Load location data
npc.X = Convert.ToInt32(row[counter++].Value);
npc.Y = Convert.ToInt32(row[counter++].Value);
npc.Direction = Convert.ToByte(row[counter++].Value);
// Load stat data
npc.IQ = Convert.ToInt32(row[counter++].Value);
npc.HP = Convert.ToInt32(row[counter++].Value);
npc.HPRemainder = Convert.ToInt32(row[counter++].Value);
//npc.BaseMaxHP = Convert.ToInt32(row[counter++].Value);
//npc.BaseAtk = Convert.ToInt32(row[counter++].Value);
//npc.BaseDef = Convert.ToInt32(row[counter++].Value);
//npc.BaseSpd = Convert.ToInt32(row[counter++].Value);
//npc.BaseSpclAtk = Convert.ToInt32(row[counter++].Value);
//npc.BaseSpclDef = Convert.ToInt32(row[counter++].Value);
//npc.MaxHPBonus = Convert.ToInt32(row[counter++].Value);
npc.AtkBonus = Convert.ToInt32(row[counter++].Value);
npc.DefBonus = Convert.ToInt32(row[counter++].Value);
npc.SpdBonus = Convert.ToInt32(row[counter++].Value);
npc.SpclAtkBonus = Convert.ToInt32(row[counter++].Value);
npc.SpclDefBonus = Convert.ToInt32(row[counter++].Value);
//npc.MaxHPBoost = Convert.ToInt32(row[counter++].Value);
//npc.AtkBoost = Convert.ToInt32(row[counter++].Value);
//npc.DefBoost = Convert.ToInt32(row[counter++].Value);
//npc.SpdBoost = Convert.ToInt32(row[counter++].Value);
//npc.SpclAtkBoost = Convert.ToInt32(row[counter++].Value);
//npc.SpclDefBoost = Convert.ToInt32(row[counter++].Value);
npc.AttackBuff = Convert.ToInt32(row[counter++].Value);
npc.DefenseBuff = Convert.ToInt32(row[counter++].Value);
npc.SpAtkBuff = Convert.ToInt32(row[counter++].Value);
npc.SpDefBuff = Convert.ToInt32(row[counter++].Value);
npc.SpeedBuff = Convert.ToInt32(row[counter++].Value);
npc.AccuracyBuff = Convert.ToInt32(row[counter++].Value);
npc.EvasionBuff = Convert.ToInt32(row[counter++].Value);
mapDump.ActiveNpc[slot] = npc;
}
query = "SELECT mapstate_activenpc_helditem.MapNpcSlot, mapstate_activenpc_helditem.ItemNumber, mapstate_activenpc_helditem.Amount, " +
"mapstate_activenpc_helditem.Sticky, mapstate_activenpc_helditem.Tag " +
"FROM mapstate_activenpc_helditem " +
"WHERE mapstate_activenpc_helditem.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query))
{
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
MapNpc npc = new MapNpc(slot);
// Load held item
{
int heldItemNum = Convert.ToInt32(row[counter++].Value);
if (heldItemNum > 0)
{
// The npc has a held item! Continue loading it
npc.HeldItem = new Characters.InventoryItem();
npc.HeldItem.Num = heldItemNum;
npc.HeldItem.Amount = Convert.ToInt32(row[counter++].Value);
npc.HeldItem.Sticky = row[counter++].ValueString.ToBool();
npc.HeldItem.Tag = row[counter++].ValueString;
}
else
{
// No held item - skip loading the other values
npc.HeldItem = new Characters.InventoryItem();
counter += 3;
}
}
mapDump.ActiveNpc[slot] = npc;
}
query = "SELECT mapstate_activenpc_moves.MapNpcSlot, mapstate_activenpc_moves.MoveSlot, mapstate_activenpc_moves.CurrentPP, " +
"mapstate_activenpc_moves.MaxPP, mapstate_activenpc_moves.MoveNum " +
"FROM mapstate_activenpc_moves WHERE mapstate_activenpc_moves.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query))
{
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
int moveSlot = Convert.ToInt32(row[counter++].Value);
Characters.Move move = new Characters.Move();
move.CurrentPP = Convert.ToInt32(row[counter++].Value);
move.MaxPP = Convert.ToInt32(row[counter++].Value);
move.MoveNum = Convert.ToInt32(row[counter++].Value);
//move.Sealed = row[counter++].ValueString.ToBool();
mapDump.ActiveNpc[slot].Moves[moveSlot] = move;
}
//query = "SELECT mapstate_activenpc_mobility.MapNpcSlot, mapstate_activenpc_mobility.MobilitySlot, mapstate_activenpc_mobility.Mobile " +
// "FROM mapstate_activenpc_mobility WHERE mapstate_activenpc_mobility.MapID = \'" + mapID + "\'";
//foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
// int counter = 0;
// int slot = Convert.ToInt32(row[counter++].Value);
// int mobilitySlot = Convert.ToInt32(row[counter++].Value);
// mapDump.ActiveNpc[slot].Mobility[mobilitySlot] = row[counter++].ValueString.ToBool();
//}
query = "SELECT mapstate_activenpc_volatilestatus.MapNpcSlot, mapstate_activenpc_volatilestatus.Name, " +
"mapstate_activenpc_volatilestatus.Emoticon, mapstate_activenpc_volatilestatus.Counter, mapstate_activenpc_volatilestatus.Tag " +
"FROM mapstate_activenpc_volatilestatus WHERE mapstate_activenpc_volatilestatus.MapID = \'" + mapID + "\' ORDER BY mapstate_activenpc_volatilestatus.StatusIndex";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query))
{
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
Characters.VolatileStatus status = new Characters.VolatileStatus();
status.Name = row[counter++].ValueString;
status.Emoticon = Convert.ToInt32(row[counter++].Value);
status.Counter = Convert.ToInt32(row[counter++].ValueString);
status.Tag = row[counter++].ValueString;
mapDump.ActiveNpc[slot].VolatileStatus.Add(status);
}
}
// Load map status
query = "SELECT mapstate_mapstatus.StatusIndex, mapstate_mapstatus.Name, mapstate_mapstatus.Tag, mapstate_mapstatus.GraphicEffect, mapstate_mapstatus.Tag, mapstate_mapstatus.Counter " +
"FROM mapstate_mapstatus WHERE mapstate_mapstatus.MapID = \'" + mapID + "\' ORDER BY mapstate_mapstatus.StatusIndex";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query))
{
MapStatus status = new MapStatus();
int counter = 1;
status.Name = row[counter++].ValueString;
status.Tag = row[counter++].ValueString;
status.GraphicEffect = Convert.ToInt32(row[counter++].ValueString);
status.Counter = Convert.ToInt32(row.FindByName("Counter").Value);
mapDump.TempStatus.Add(status);
}
}
public static void LoadMapDump(MySql database, string mapID, MapDump mapDump)
{
// First, load the raw map data
LoadRawMap(database, mapID, mapDump);
mapID = database.VerifyValueString(mapID);
// Load map state data
string query = "SELECT mapstate_data.ActivationTime, mapstate_data.ProcessingPaused, mapstate_data.SpawnMarker, " +
"mapstate_data.NpcSpawnWait, mapstate_data.TempChange, mapstate_data.CurrentWeather " +
"FROM mapstate_data WHERE mapstate_data.MapID = \'" + mapID + "\'"; ;
{
DataColumnCollection row = database.RetrieveRow(query);
if (row != null) {
int counter = 0;
mapDump.ActivationTime = Convert.ToInt32(row[counter++].Value);
mapDump.ProcessingPaused = row[counter++].ValueString.ToBool();
mapDump.SpawnMarker = Convert.ToInt32(row[counter++].Value);
mapDump.NpcSpawnWait = Convert.ToInt32(row[counter++].Value);
mapDump.TempChange = row[counter++].ValueString.ToBool();
mapDump.CurrentWeather = Convert.ToByte(row[counter++].Value);
} else {
throw new Exception("Map state data not found");
}
}
{ // Load map active items
query = "SELECT mapstate_activeitem.Slot, mapstate_activeitem.Number, mapstate_activeitem.Value, mapstate_activeitem.Sticky, " +
"mapstate_activeitem.Tag, mapstate_activeitem.Hidden, mapstate_activeitem.X, mapstate_activeitem.Y, " +
"mapstate_activeitem.TimeRemaining, mapstate_activeitem.ItemOwner " +
"FROM mapstate_activeitem WHERE mapstate_activeitem.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
MapItem mapItem = new MapItem();
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
mapItem.Num = Convert.ToInt32(row[counter++].Value);
mapItem.Value = Convert.ToInt32(row[counter++].Value);
mapItem.Sticky = row[counter++].ValueString.ToBool();
mapItem.Tag = row[counter++].ValueString;
mapItem.Hidden = row[counter++].ValueString.ToBool();
mapItem.X = Convert.ToInt32(row[counter++].Value);
mapItem.Y = Convert.ToInt32(row[counter++].Value);
mapItem.TimeRemaining = Convert.ToInt32(row[counter++].Value);
mapItem.PlayerFor = row[counter++].ValueString;
mapDump.ActiveItem[slot] = mapItem;
}
}
{ // Load map active npcs
query = "SELECT mapstate_activenpc_data.MapNpcSlot, mapstate_activenpc_data.Name, mapstate_activenpc_data.Shiny, mapstate_activenpc_data.Form, " +
"mapstate_activenpc_data.Level, mapstate_activenpc_data.NpcNumber, mapstate_activenpc_data.Sex, " +
"mapstate_activenpc_data.AttackTimer, mapstate_activenpc_data.PauseTimer, mapstate_activenpc_data.StatusAilment, " +
"mapstate_activenpc_data.StatusAilmentCounter, mapstate_activenpc_data.HPStepCounter, " +
"mapstate_activenpc_data.Target, " +
"mapstate_activenpc_location.X, mapstate_activenpc_location.Y, mapstate_activenpc_location.Direction, " +
"mapstate_activenpc_stats.IQ, mapstate_activenpc_stats.HP, mapstate_activenpc_stats.HPRemainder, " +
"mapstate_activenpc_stats.MaxHPBonus, mapstate_activenpc_stats.AtkBonus, mapstate_activenpc_stats.DefBonus, " +
"mapstate_activenpc_stats.SpdBonus, mapstate_activenpc_stats.SpclAtkBonus, mapstate_activenpc_stats.SpclDefBonus, " +
"mapstate_activenpc_stats.AttackBuff, " +
"mapstate_activenpc_stats.DefenseBuff, mapstate_activenpc_stats.SpAtkBuff, mapstate_activenpc_stats.SpDefBuff, mapstate_activenpc_stats.SpeedBuff, " +
"mapstate_activenpc_stats.AccuracyBuff, mapstate_activenpc_stats.EvasionBuff " +
"FROM mapstate_activenpc_data " +
"LEFT OUTER JOIN mapstate_activenpc_location ON mapstate_activenpc_data.MapID = mapstate_activenpc_location.MapID AND mapstate_activenpc_data.MapNpcSlot = mapstate_activenpc_location.MapNpcSlot " +
"JOIN mapstate_activenpc_stats ON mapstate_activenpc_data.MapID = mapstate_activenpc_stats.MapID AND mapstate_activenpc_data.MapNpcSlot = mapstate_activenpc_stats.MapNpcSlot " +
"WHERE mapstate_activenpc_data.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
MapNpc npc = new MapNpc(slot);
npc.Name = row[counter++].ValueString;
npc.Shiny = Convert.ToByte(row[counter++].Value);
npc.Form = Convert.ToInt32(row[counter++].Value);
npc.Level = Convert.ToInt32(row[counter++].Value);
npc.Num = Convert.ToInt32(row[counter++].Value);
//npc.Sprite = Convert.ToInt32(row[counter++].Value);
npc.Sex = Convert.ToByte(row[counter++].Value);
//npc.Type1 = Convert.ToByte(row[counter++].Value);
//npc.Type2 = Convert.ToByte(row[counter++].Value);
//npc.Ability1 = row[counter++].ValueString;
//npc.Ability2 = row[counter++].ValueString;
//npc.Ability3 = row[counter++].ValueString;
//npc.TimeMultiplier = Convert.ToInt32(row[counter++].Value);
npc.AttackTimer = Convert.ToInt32(row[counter++].Value);
npc.PauseTimer = Convert.ToInt32(row[counter++].Value);
npc.StatusAilment = Convert.ToByte(row[counter++].Value);
npc.StatusAilmentCounter = Convert.ToInt32(row[counter++].Value);
npc.HPStepCounter = Convert.ToInt32(row[counter++].Value);
//npc.ConfusionStepCounter = Convert.ToInt32(row[counter++].Value);
//npc.SpeedLimit = Convert.ToByte(row[counter++].Value);
npc.Target = row[counter++].ValueString;
//npc.ItemActive = row[counter++].ValueString.ToBool();
// Load location data
npc.X = Convert.ToInt32(row[counter++].Value);
npc.Y = Convert.ToInt32(row[counter++].Value);
npc.Direction = Convert.ToByte(row[counter++].Value);
// Load stat data
npc.IQ = Convert.ToInt32(row[counter++].Value);
npc.HP = Convert.ToInt32(row[counter++].Value);
npc.HPRemainder = Convert.ToInt32(row[counter++].Value);
//npc.BaseMaxHP = Convert.ToInt32(row[counter++].Value);
//npc.BaseAtk = Convert.ToInt32(row[counter++].Value);
//npc.BaseDef = Convert.ToInt32(row[counter++].Value);
//npc.BaseSpd = Convert.ToInt32(row[counter++].Value);
//npc.BaseSpclAtk = Convert.ToInt32(row[counter++].Value);
//npc.BaseSpclDef = Convert.ToInt32(row[counter++].Value);
//npc.MaxHPBonus = Convert.ToInt32(row[counter++].Value);
npc.AtkBonus = Convert.ToInt32(row[counter++].Value);
npc.DefBonus = Convert.ToInt32(row[counter++].Value);
npc.SpdBonus = Convert.ToInt32(row[counter++].Value);
npc.SpclAtkBonus = Convert.ToInt32(row[counter++].Value);
npc.SpclDefBonus = Convert.ToInt32(row[counter++].Value);
//npc.MaxHPBoost = Convert.ToInt32(row[counter++].Value);
//npc.AtkBoost = Convert.ToInt32(row[counter++].Value);
//npc.DefBoost = Convert.ToInt32(row[counter++].Value);
//npc.SpdBoost = Convert.ToInt32(row[counter++].Value);
//npc.SpclAtkBoost = Convert.ToInt32(row[counter++].Value);
//npc.SpclDefBoost = Convert.ToInt32(row[counter++].Value);
npc.AttackBuff = Convert.ToInt32(row[counter++].Value);
npc.DefenseBuff = Convert.ToInt32(row[counter++].Value);
npc.SpAtkBuff = Convert.ToInt32(row[counter++].Value);
npc.SpDefBuff = Convert.ToInt32(row[counter++].Value);
npc.SpeedBuff = Convert.ToInt32(row[counter++].Value);
npc.AccuracyBuff = Convert.ToInt32(row[counter++].Value);
npc.EvasionBuff = Convert.ToInt32(row[counter++].Value);
mapDump.ActiveNpc[slot] = npc;
}
query = "SELECT mapstate_activenpc_helditem.MapNpcSlot, mapstate_activenpc_helditem.ItemNumber, mapstate_activenpc_helditem.Amount, " +
"mapstate_activenpc_helditem.Sticky, mapstate_activenpc_helditem.Tag " +
"FROM mapstate_activenpc_helditem " +
"WHERE mapstate_activenpc_helditem.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
MapNpc npc = new MapNpc(slot);
// Load held item
{
int heldItemNum = Convert.ToInt32(row[counter++].Value);
if (heldItemNum > 0) {
// The npc has a held item! Continue loading it
npc.HeldItem = new Characters.InventoryItem();
npc.HeldItem.Num = heldItemNum;
npc.HeldItem.Amount = Convert.ToInt32(row[counter++].Value);
npc.HeldItem.Sticky = row[counter++].ValueString.ToBool();
npc.HeldItem.Tag = row[counter++].ValueString;
} else {
// No held item - skip loading the other values
npc.HeldItem = new Characters.InventoryItem();
counter += 3;
}
}
mapDump.ActiveNpc[slot] = npc;
}
query = "SELECT mapstate_activenpc_moves.MapNpcSlot, mapstate_activenpc_moves.MoveSlot, mapstate_activenpc_moves.CurrentPP, " +
"mapstate_activenpc_moves.MaxPP, mapstate_activenpc_moves.MoveNum " +
"FROM mapstate_activenpc_moves WHERE mapstate_activenpc_moves.MapID = \'" + mapID + "\'";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
int moveSlot = Convert.ToInt32(row[counter++].Value);
Characters.Move move = new Characters.Move();
move.CurrentPP = Convert.ToInt32(row[counter++].Value);
move.MaxPP = Convert.ToInt32(row[counter++].Value);
move.MoveNum = Convert.ToInt32(row[counter++].Value);
//move.Sealed = row[counter++].ValueString.ToBool();
mapDump.ActiveNpc[slot].Moves[moveSlot] = move;
}
//query = "SELECT mapstate_activenpc_mobility.MapNpcSlot, mapstate_activenpc_mobility.MobilitySlot, mapstate_activenpc_mobility.Mobile " +
// "FROM mapstate_activenpc_mobility WHERE mapstate_activenpc_mobility.MapID = \'" + mapID + "\'";
//foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
// int counter = 0;
// int slot = Convert.ToInt32(row[counter++].Value);
// int mobilitySlot = Convert.ToInt32(row[counter++].Value);
// mapDump.ActiveNpc[slot].Mobility[mobilitySlot] = row[counter++].ValueString.ToBool();
//}
query = "SELECT mapstate_activenpc_volatilestatus.MapNpcSlot, mapstate_activenpc_volatilestatus.Name, " +
"mapstate_activenpc_volatilestatus.Emoticon, mapstate_activenpc_volatilestatus.Counter, mapstate_activenpc_volatilestatus.Tag " +
"FROM mapstate_activenpc_volatilestatus WHERE mapstate_activenpc_volatilestatus.MapID = \'" + mapID + "\' ORDER BY mapstate_activenpc_volatilestatus.StatusIndex";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
int counter = 0;
int slot = Convert.ToInt32(row[counter++].Value);
Characters.VolatileStatus status = new Characters.VolatileStatus();
status.Name = row[counter++].ValueString;
status.Emoticon = Convert.ToInt32(row[counter++].Value);
status.Counter = Convert.ToInt32(row[counter++].ValueString);
status.Tag = row[counter++].ValueString;
mapDump.ActiveNpc[slot].VolatileStatus.Add(status);
}
}
// Load map status
query = "SELECT mapstate_mapstatus.StatusIndex, mapstate_mapstatus.Name, mapstate_mapstatus.Tag, mapstate_mapstatus.GraphicEffect, mapstate_mapstatus.Tag, mapstate_mapstatus.Counter " +
"FROM mapstate_mapstatus WHERE mapstate_mapstatus.MapID = \'" + mapID + "\' ORDER BY mapstate_mapstatus.StatusIndex";
foreach (DataColumnCollection row in database.RetrieveRowsEnumerable(query)) {
MapStatus status = new MapStatus();
int counter = 1;
status.Name = row[counter++].ValueString;
status.Tag = row[counter++].ValueString;
status.GraphicEffect = Convert.ToInt32(row[counter++].ValueString);
status.Counter = Convert.ToInt32(row.FindByName("Counter").Value);
mapDump.TempStatus.Add(status);
}
}