public static void SaveHouseMap(MySql database, string mapID, HouseMap map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false)
{
database.BeginTransaction();
localTransaction = true;
}
SaveMapDump(database, mapID, map);
// Save extra data associated with instanced maps
database.UpdateOrInsert("map_house_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Owner", map.Owner),
database.CreateColumn(false, "Room", map.Room.ToString()),
database.CreateColumn(false, "StartX", map.StartX.ToString()),
database.CreateColumn(false, "StartY", map.StartY.ToString())
});
if (localTransaction)
{
database.EndTransaction();
}
}
public static void SaveRDungeonMap(MySql database, string mapID, RDungeonMap map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false)
{
database.BeginTransaction();
localTransaction = true;
}
SaveMapDump(database, mapID, map);
// Save extra data associated with instanced maps
database.UpdateOrInsert("map_rdungeon_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "RDungeonIndex", map.RDungeonIndex.ToString()),
database.CreateColumn(false, "RDungeonFloor", map.RDungeonFloor.ToString()),
database.CreateColumn(false, "StartX", map.StartX.ToString()),
database.CreateColumn(false, "StartY", map.StartY.ToString())
});
if (localTransaction)
{
database.EndTransaction();
}
}
public static void CreateNewAccount(MySql database, string accountName, string encryptedPassword, string email)
{
database.AddRow("accounts", new IDataColumn[] {
database.CreateColumn(false, "AccountName", accountName),
database.CreateColumn(false, "Password", encryptedPassword),
database.CreateColumn(false, "Email", email)
});
}
public static void AddMissionEnemyData(MySql database, int difficulty, int index, MissionEnemyData data)
{
database.AddRow("mission_enemy", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "EnemyIndex", index.ToString()),
database.CreateColumn(false, "NpcNum", data.NpcNum.ToString())
});
}
public static void AddMissionEnemyData(MySql database, int difficulty, int index, MissionEnemyData data)
{
database.AddRow("mission_enemy", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "EnemyIndex", index.ToString()),
database.CreateColumn(false, "NpcNum", data.NpcNum.ToString())
});
}
public static void AddGuildMember(MySql database, string guildName, string charID)
{
database.UpdateOrInsert("guild", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "GuildName", guildName),
database.CreateColumn(false, "GuildAccess", "1")
});
}
public static void AddMissionClientData(MySql database, int difficulty, int index, MissionClientData data)
{
database.AddRow("mission_client", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "ClientIndex", index.ToString()),
database.CreateColumn(false, "DexNum", data.DexNum.ToString()),
database.CreateColumn(false, "FormNum", data.FormNum.ToString())
});
}
public static void AddMissionClientData(MySql database, int difficulty, int index, MissionClientData data)
{
database.AddRow("mission_client", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "ClientIndex", index.ToString()),
database.CreateColumn(false, "DexNum", data.DexNum.ToString()),
database.CreateColumn(false, "FormNum", data.FormNum.ToString())
});
}
public static void AddMissionRewardData(MySql database, int difficulty, int index, MissionRewardData data)
{
database.AddRow("mission_reward", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "RewardIndex", index.ToString()),
database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()),
database.CreateColumn(false, "ItemAmount", data.ItemAmount.ToString()),
database.CreateColumn(false, "ItemTag", data.ItemTag)
});
}
public static void AddMissionRewardData(MySql database, int difficulty, int index, MissionRewardData data)
{
database.AddRow("mission_reward", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "RewardIndex", index.ToString()),
database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()),
database.CreateColumn(false, "ItemAmount", data.ItemAmount.ToString()),
database.CreateColumn(false, "ItemTag", data.ItemTag)
});
}
public static void SaveShop(int shopNum)
{
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM shop WHERE num = \'" + shopNum + "\'");
database.ExecuteNonQuery("DELETE FROM shop_trade WHERE num = \'" + shopNum + "\'");
database.UpdateOrInsert("shop", new IDataColumn[] {
database.CreateColumn(false, "num", shopNum.ToString()),
database.CreateColumn(false, "name", shops[shopNum].Name),
database.CreateColumn(false, "greeting", shops[shopNum].JoinSay),
database.CreateColumn(false, "farewell", shops[shopNum].LeaveSay)
});
for (int i = 0; i < Constants.MAX_TRADES; i++)
{
database.UpdateOrInsert("shop_trade", new IDataColumn[] {
database.CreateColumn(false, "num", shopNum.ToString()),
database.CreateColumn(false, "trade_num", i.ToString()),
database.CreateColumn(false, "item", shops[shopNum].Items[i].GetItem.ToString()),
database.CreateColumn(false, "cost_num", shops[shopNum].Items[i].GiveItem.ToString()),
database.CreateColumn(false, "cost_val", shops[shopNum].Items[i].GiveValue.ToString())
});
}
database.EndTransaction();
}
}
public static void SaveParty(MySql database, PartyData partyData)
{
database.ExecuteNonQuery("DELETE FROM parties WHERE PartyID = \'" + partyData.PartyID + "\'");
//database.DeleteRow("friends", "CharID = \'" + playerData.CharID + "\'");
for (int i = 0; i < partyData.Members.Count; i++)
{
database.UpdateOrInsert("parties", new IDataColumn[] {
database.CreateColumn(false, "PartyID", partyData.PartyID),
database.CreateColumn(false, "PartySlot", i.ToString()),
database.CreateColumn(false, "CharID", partyData.Members[i])
});
}
}
public static void CreateNewCharacter(MySql database, string accountName, int charNum, PlayerData playerData)
{
// Add the character to the 'characters' table
database.AddRow("characters", new IDataColumn[] {
database.CreateColumn(false, "AccountName", accountName),
database.CreateColumn(false, "Slot", charNum.ToString()),
database.CreateColumn(false, "CharID", playerData.CharID)
});
SavePlayerCharacteristics(database, playerData);
// SavePlayerExpKit(database, playerData);
SavePlayerLocation(database, playerData);
SavePlayerTeam(database, playerData);
SavePlayerItemGenerals(database, playerData);
}
/// <summary>
/// Adds a new friend. Return codes are as follows:
/// <list type="table">
/// <item>
/// 0 - Success
/// </item>
/// <item>
/// 1 - Friend is already on list
/// </item>
/// </list>
/// </summary>
/// <param name="name"></param>
public int AddFriend(MySql database, string name)
{
int error = 0;
if (friends.Contains(name) == false)
{
QuickAdd(name);
if (UpdateOnDemand && database != null)
{
database.UpdateOrInsert("friends", new IDataColumn[] {
database.CreateColumn(false, "CharID", ownerCharID),
database.CreateColumn(false, "FriendListSlot", (friends.Count - 1).ToString()),
database.CreateColumn(false, "FriendName", name)
});
}
}
else
{
error = 1;
}
return(error);
}
public static void SaveInstancedMap(MySql database, string mapID, InstancedMap map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false)
{
database.BeginTransaction();
localTransaction = true;
}
SaveMapDump(database, mapID, map);
// Save extra data associated with instanced maps
database.UpdateOrInsert("map_instanced_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "MapBase", map.MapBase.ToString())
});
if (localTransaction)
{
database.EndTransaction();
}
}
public static void SaveStandardMap(MySql database, string mapID, Map map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false)
{
database.BeginTransaction();
localTransaction = true;
}
// Save the raw map
SaveRawMap(database, mapID, map);
// Save extra data associated with standard maps
database.UpdateOrInsert("map_standard_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Instanced", map.Instanced.ToIntString())
});
if (localTransaction)
{
database.EndTransaction();
}
}
public static void SaveMissionPool(DatabaseConnection dbConnection, int difficulty)
{
MySql database = dbConnection.Database;
database.ExecuteNonQuery("DELETE FROM mission_client WHERE Rank = \'" + difficulty + "\'");
for (int i = 0; i < missionPools.MissionPools[difficulty].MissionClients.Count; i++)
{
MissionClientData data = missionPools.MissionPools[difficulty].MissionClients[i];
}
database.ExecuteNonQuery("DELETE FROM mission_enemy WHERE Rank = \'" + difficulty + "\'");
for (int i = 0; i < missionPools.MissionPools[difficulty].Enemies.Count; i++)
{
MissionEnemyData data = missionPools.MissionPools[difficulty].Enemies[i];
database.AddRow("mission_enemy", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "EnemyIndex", i.ToString()),
database.CreateColumn(false, "NpcNum", data.NpcNum.ToString())
});
}
database.ExecuteNonQuery("DELETE FROM mission_reward WHERE Rank = \'" + difficulty + "\'");
for (int i = 0; i < missionPools.MissionPools[difficulty].Rewards.Count; i++)
{
MissionRewardData data = missionPools.MissionPools[difficulty].Rewards[i];
database.AddRow("mission_reward", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "RewardIndex", i.ToString()),
database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()),
database.CreateColumn(false, "ItemAmount", data.Amount.ToString()),
database.CreateColumn(false, "ItemTag", data.Tag)
});
}
}
public static void SaveHouseMap(MySql database, string mapID, HouseMap map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false) {
database.BeginTransaction();
localTransaction = true;
}
SaveMapDump(database, mapID, map);
// Save extra data associated with instanced maps
database.UpdateOrInsert("map_house_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Owner", map.Owner),
database.CreateColumn(false, "Room", map.Room.ToString()),
database.CreateColumn(false, "StartX", map.StartX.ToString()),
database.CreateColumn(false, "StartY", map.StartY.ToString())
});
if (localTransaction) {
database.EndTransaction();
}
}
public static void SavePlayerStoryChapters(MySql database, PlayerData playerData)
{
for (int i = 0; i < playerData.StoryChapters.Count; i++) {
database.UpdateOrInsert("story_chapters", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "Chapter", playerData.StoryChapters.KeyByIndex(i).ToString()),
database.CreateColumn(false, "Complete", playerData.StoryChapters.ValueByIndex(i).ToIntString())
});
}
}
public static void SavePlayerRecruitListStatus(MySql database, string characterID, int pokemonID, byte status)
{
database.UpdateOrInsert("recruit_list", new IDataColumn[] {
database.CreateColumn(false, "CharID", characterID),
database.CreateColumn(false, "PokemonID", pokemonID.ToString()),
database.CreateColumn(false, "Status", status.ToString())
});
}
public static void SaveEvo(int evoNum)
{
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM evolution WHERE num = \'" + evoNum + "\'");
database.ExecuteNonQuery("DELETE FROM evolution_branch WHERE num = \'" + evoNum + "\'");
database.UpdateOrInsert("evolution", new IDataColumn[] {
database.CreateColumn(false, "num", evoNum.ToString()),
database.CreateColumn(false, "name", evolution[evoNum].Name),
database.CreateColumn(false, "species", evolution[evoNum].Species.ToString())
});
for (int i = 0; i < evolution[evoNum].Branches.Count; i++)
{
database.UpdateOrInsert("evolution_branch", new IDataColumn[] {
database.CreateColumn(false, "num", evoNum.ToString()),
database.CreateColumn(false, "branch", i.ToString()),
database.CreateColumn(false, "name", evolution[evoNum].Branches[i].Name),
database.CreateColumn(false, "species", evolution[evoNum].Branches[i].NewSpecies.ToString()),
database.CreateColumn(false, "req_script", evolution[evoNum].Branches[i].ReqScript.ToString()),
database.CreateColumn(false, "data1", evolution[evoNum].Branches[i].Data1.ToString()),
database.CreateColumn(false, "data2", evolution[evoNum].Branches[i].Data2.ToString()),
database.CreateColumn(false, "data3", evolution[evoNum].Branches[i].Data3.ToString())
});
}
database.EndTransaction();
}
}
public static void SaveRawMap(MySql database, string mapID, RawMap rawMap)
{
bool localTransaction = false;
if (database.IsTransactionActive == false)
{
database.BeginTransaction();
localTransaction = true;
}
// Delete old map, if it exists
DeleteMap(database, mapID);
// Save map general information
database.UpdateOrInsert("map_general", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Revision", rawMap.Revision.ToString()),
database.CreateColumn(false, "MaxX", rawMap.MaxX.ToString()),
database.CreateColumn(false, "MaxY", rawMap.MaxY.ToString())
});
// Save map data
database.UpdateOrInsert("map_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Name", rawMap.Name),
database.CreateColumn(false, "Moral", rawMap.Moral.ToString()),
database.CreateColumn(false, "Music", rawMap.Music),
database.CreateColumn(false, "Indoors", rawMap.Indoors.ToIntString()),
database.CreateColumn(false, "Weather", rawMap.Weather.ToString()),
database.CreateColumn(false, "Darkness", rawMap.Darkness.ToString()),
database.CreateColumn(false, "HungerEnabled", rawMap.HungerEnabled.ToIntString()),
database.CreateColumn(false, "RecruitmentEnabled", rawMap.RecruitEnabled.ToIntString()),
database.CreateColumn(false, "ExpEnabled", rawMap.ExpEnabled.ToIntString()),
database.CreateColumn(false, "TimeLimit", rawMap.TimeLimit.ToString()),
database.CreateColumn(false, "MinNpcs", rawMap.MinNpcs.ToString()),
database.CreateColumn(false, "MaxNpcs", rawMap.MaxNpcs.ToString()),
database.CreateColumn(false, "NpcSpawnTime", rawMap.NpcSpawnTime.ToString())
});
// Save map switchovers
database.UpdateOrInsert("map_switchovers", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "UpMap", rawMap.Up.ToString()),
database.CreateColumn(false, "DownMap", rawMap.Down.ToString()),
database.CreateColumn(false, "LeftMap", rawMap.Left.ToString()),
database.CreateColumn(false, "RightMap", rawMap.Right.ToString())
});
// Save map npc presets
MultiRowInsert multiRowInsert = new MultiRowInsert(database, "map_npcs", "MapID", "Slot", "Number", "SpawnX",
"SpawnY", "MinLevel", "MaxLevel", "AppearanceRate", "StartStatus", "StartStatusCounter", "StartStatusChance");
if (rawMap.Npc.Count > 0)
{
for (int i = 0; i < rawMap.Npc.Count; i++)
{
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, rawMap.Npc[i].NpcNum, rawMap.Npc[i].SpawnX, rawMap.Npc[i].SpawnY, rawMap.Npc[i].MinLevel,
rawMap.Npc[i].MaxLevel, rawMap.Npc[i].AppearanceRate, rawMap.Npc[i].StartStatus, rawMap.Npc[i].StartStatusCounter,
rawMap.Npc[i].StartStatusChance);
multiRowInsert.AddRowClosing();
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
}
// Save map tiles
multiRowInsert.UpdateParameters("map_tiles", new string[] { "MapID", "X", "Y", "Ground", "GroundAnim", "Mask",
"MaskAnim", "Mask2", "Mask2Anim", "Fringe", "FringeAnim", "Fringe2", "Fringe2Anim", "Type", "Data1", "Data2", "Data3", "String1",
"String2", "String3", "Light", "GroundTileset", "GroundAnimTileset", "MaskTileset", "MaskAnimTileset",
"Mask2Tileset", "Mask2AnimTileset", "FringeTileset", "FringeAnimTileset", "Fringe2Tileset", "Fringe2AnimTileset" });
for (int x = 0; x <= rawMap.MaxX; x++)
{
for (int y = 0; y <= rawMap.MaxY; y++)
{
if (rawMap.Tile[x, y] == null)
{
rawMap.Tile[x, y] = new Tile();
}
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(x, y);
Tile tile = rawMap.Tile[x, y];
multiRowInsert.AddColumnData(tile.Ground, tile.GroundAnim, tile.Mask, tile.Anim, tile.Mask2, tile.M2Anim,
tile.Fringe, tile.FAnim, tile.Fringe2, tile.F2Anim, tile.Type, tile.Data1, tile.Data2, tile.Data3);
multiRowInsert.AddColumnData(tile.String1, tile.String2, tile.String3);
multiRowInsert.AddColumnData(tile.RDungeonMapValue, tile.GroundSet, tile.GroundAnimSet, tile.MaskSet, tile.AnimSet,
tile.Mask2Set, tile.M2AnimSet, tile.FringeSet, tile.FAnimSet, tile.Fringe2Set, tile.F2AnimSet);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
if (localTransaction)
{
database.EndTransaction();
}
}
public static void SaveRawMap(MySql database, string mapID, RawMap rawMap)
{
bool localTransaction = false;
if (database.IsTransactionActive == false) {
database.BeginTransaction();
localTransaction = true;
}
// Delete old map, if it exists
DeleteMap(database, mapID);
// Save map general information
database.UpdateOrInsert("map_general", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Revision", rawMap.Revision.ToString()),
database.CreateColumn(false, "MaxX", rawMap.MaxX.ToString()),
database.CreateColumn(false, "MaxY", rawMap.MaxY.ToString())
});
// Save map data
database.UpdateOrInsert("map_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Name", rawMap.Name),
database.CreateColumn(false, "Moral", rawMap.Moral.ToString()),
database.CreateColumn(false, "Music", rawMap.Music),
database.CreateColumn(false, "Indoors", rawMap.Indoors.ToIntString()),
database.CreateColumn(false, "Weather", rawMap.Weather.ToString()),
database.CreateColumn(false, "Darkness", rawMap.Darkness.ToString()),
database.CreateColumn(false, "HungerEnabled", rawMap.HungerEnabled.ToIntString()),
database.CreateColumn(false, "RecruitmentEnabled", rawMap.RecruitEnabled.ToIntString()),
database.CreateColumn(false, "ExpEnabled", rawMap.ExpEnabled.ToIntString()),
database.CreateColumn(false, "TimeLimit", rawMap.TimeLimit.ToString()),
database.CreateColumn(false, "MinNpcs", rawMap.MinNpcs.ToString()),
database.CreateColumn(false, "MaxNpcs", rawMap.MaxNpcs.ToString()),
database.CreateColumn(false, "NpcSpawnTime", rawMap.NpcSpawnTime.ToString())
});
// Save map switchovers
database.UpdateOrInsert("map_switchovers", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "UpMap", rawMap.Up.ToString()),
database.CreateColumn(false, "DownMap", rawMap.Down.ToString()),
database.CreateColumn(false, "LeftMap", rawMap.Left.ToString()),
database.CreateColumn(false, "RightMap", rawMap.Right.ToString())
});
// Save map npc presets
MultiRowInsert multiRowInsert = new MultiRowInsert(database, "map_npcs", "MapID", "Slot", "Number", "SpawnX",
"SpawnY", "MinLevel", "MaxLevel", "AppearanceRate", "StartStatus", "StartStatusCounter", "StartStatusChance");
if (rawMap.Npc.Count > 0) {
for (int i = 0; i < rawMap.Npc.Count; i++) {
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(i, rawMap.Npc[i].NpcNum, rawMap.Npc[i].SpawnX, rawMap.Npc[i].SpawnY, rawMap.Npc[i].MinLevel,
rawMap.Npc[i].MaxLevel, rawMap.Npc[i].AppearanceRate, rawMap.Npc[i].StartStatus, rawMap.Npc[i].StartStatusCounter,
rawMap.Npc[i].StartStatusChance);
multiRowInsert.AddRowClosing();
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
}
// Save map tiles
multiRowInsert.UpdateParameters("map_tiles", new string[] {"MapID", "X", "Y", "Ground", "GroundAnim", "Mask",
"MaskAnim", "Mask2", "Mask2Anim", "Fringe", "FringeAnim", "Fringe2", "Fringe2Anim", "Type", "Data1", "Data2", "Data3", "String1",
"String2", "String3", "Light", "GroundTileset", "GroundAnimTileset", "MaskTileset", "MaskAnimTileset",
"Mask2Tileset", "Mask2AnimTileset", "FringeTileset", "FringeAnimTileset", "Fringe2Tileset", "Fringe2AnimTileset" });
for (int x = 0; x <= rawMap.MaxX; x++) {
for (int y = 0; y <= rawMap.MaxY; y++) {
if (rawMap.Tile[x, y] == null) {
rawMap.Tile[x, y] = new Tile();
}
multiRowInsert.AddRowOpening();
multiRowInsert.AddColumnData(mapID);
multiRowInsert.AddColumnData(x, y);
Tile tile = rawMap.Tile[x, y];
multiRowInsert.AddColumnData(tile.Ground, tile.GroundAnim, tile.Mask, tile.Anim, tile.Mask2, tile.M2Anim,
tile.Fringe, tile.FAnim, tile.Fringe2, tile.F2Anim, tile.Type, tile.Data1, tile.Data2, tile.Data3);
multiRowInsert.AddColumnData(tile.String1, tile.String2, tile.String3);
multiRowInsert.AddColumnData(tile.RDungeonMapValue, tile.GroundSet, tile.GroundAnimSet, tile.MaskSet, tile.AnimSet,
tile.Mask2Set, tile.M2AnimSet, tile.FringeSet, tile.FAnimSet, tile.Fringe2Set, tile.F2AnimSet);
multiRowInsert.AddRowClosing();
}
}
database.ExecuteNonQuery(multiRowInsert.GetSqlQuery());
if (localTransaction) {
database.EndTransaction();
}
}
public static void SaveStandardMap(MySql database, string mapID, Map map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false) {
database.BeginTransaction();
localTransaction = true;
}
// Save the raw map
SaveRawMap(database, mapID, map);
// Save extra data associated with standard maps
database.UpdateOrInsert("map_standard_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "Instanced", map.Instanced.ToIntString())
});
if (localTransaction) {
database.EndTransaction();
}
}
public static void SavePlayerRecruit(MySql database, string charID, int recruitIndex, RecruitData recruitData)
{
database.UpdateOrInsert("recruit_data", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "RecruitIndex", recruitIndex.ToString()),
database.CreateColumn(false, "UsingTempStats", recruitData.UsingTempStats.ToIntString()),
database.CreateColumn(false, "Name", recruitData.Name),
database.CreateColumn(false, "Nickname", recruitData.Nickname.ToIntString()),
database.CreateColumn(false, "NpcBase", recruitData.NpcBase.ToString()),
database.CreateColumn(false, "Species", recruitData.Species.ToString()),
database.CreateColumn(false, "Sex", recruitData.Sex.ToString()),
database.CreateColumn(false, "Shiny", recruitData.Shiny.ToString()),
database.CreateColumn(false, "Form", recruitData.Form.ToString()),
database.CreateColumn(false, "HeldItemSlot", recruitData.HeldItemSlot.ToString()),
database.CreateColumn(false, "Level", recruitData.Level.ToString()),
database.CreateColumn(false, "Experience", recruitData.Exp.ToString()),
database.CreateColumn(false, "HP", recruitData.HP.ToString()),
database.CreateColumn(false, "StatusAilment", recruitData.StatusAilment.ToString()),
database.CreateColumn(false, "StatusAilmentCounter", recruitData.StatusAilmentCounter.ToString()),
database.CreateColumn(false, "IQ", recruitData.IQ.ToString()),
database.CreateColumn(false, "Belly", recruitData.Belly.ToString()),
database.CreateColumn(false, "MaxBelly", recruitData.MaxBelly.ToString()),
database.CreateColumn(false, "AttackBonus", recruitData.AtkBonus.ToString()),
database.CreateColumn(false, "DefenseBonus", recruitData.DefBonus.ToString()),
database.CreateColumn(false, "SpeedBonus", recruitData.SpeedBonus.ToString()),
database.CreateColumn(false, "SpecialAttackBonus", recruitData.SpclAtkBonus.ToString()),
database.CreateColumn(false, "SpecialDefenseBonus", recruitData.SpclDefBonus.ToString())
});
for (int i = 0; i < recruitData.Moves.Length; i++) {
database.UpdateOrInsert("recruit_moves", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "RecruitIndex", recruitIndex.ToString()),
database.CreateColumn(false, "UsingTempStats", recruitData.UsingTempStats.ToIntString()),
database.CreateColumn(false, "MoveSlot", i.ToString()),
database.CreateColumn(false, "MoveNum", recruitData.Moves[i].MoveNum.ToString()),
database.CreateColumn(false, "CurrentPP", recruitData.Moves[i].CurrentPP.ToString()),
database.CreateColumn(false, "MaxPP", recruitData.Moves[i].MaxPP.ToString()),
//database.CreateColumn(false, "Sealed", recruitData.Moves[i].Sealed.ToIntString()),
});
}
// Delete extra statuses
database.ExecuteNonQuery("DELETE FROM recruit_volatile_status WHERE CharID = \'" + charID + "\' " +
"AND RecruitIndex = \'" + recruitIndex + "\' " +
"AND StatusNum > " + (recruitData.VolatileStatus.Count - 1));
// Update statuses
for (int i = 0; i < recruitData.VolatileStatus.Count; i++) {
database.UpdateOrInsert("recruit_volatile_status", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "RecruitIndex", recruitIndex.ToString()),
database.CreateColumn(false, "UsingTempStats", recruitData.UsingTempStats.ToIntString()),
database.CreateColumn(false, "StatusNum", i.ToString()),
database.CreateColumn(false, "Name", recruitData.VolatileStatus[i].Name),
database.CreateColumn(false, "Emoticon", recruitData.VolatileStatus[i].Emoticon.ToString()),
database.CreateColumn(false, "Counter", recruitData.VolatileStatus[i].Counter.ToString()),
database.CreateColumn(false, "Tag", recruitData.VolatileStatus[i].Tag),
});
}
}
public static void ChangePassword(MySql database, string accountName, string currentPassword, string newPassword)
{
database.UpdateRow("accounts", new IDataColumn[] {
database.CreateColumn(false, "Password", newPassword)
}, "accounts.AccountName = \'" + database.VerifyValueString(accountName) + "\' AND accounts.Password = \'" + database.VerifyValueString(currentPassword) + "\'");
}
public static void SavePlayerTeam(MySql database, PlayerData playerData)
{
for (int i = 0; i < playerData.TeamMembers.Length; i++) {
database.UpdateOrInsert("team", new IDataColumn[]
{
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "Slot", i.ToString()),
database.CreateColumn(false, "RecruitIndex", playerData.TeamMembers[i].RecruitIndex.ToString()),
database.CreateColumn(false, "UsingTempStats", playerData.TeamMembers[i].UsingTempStats.ToIntString())
});
}
}
public static void SavePlayerTriggerEvents(MySql database, PlayerData playerData)
{
for (int i = 0; i < playerData.TriggerEvents.Count; i++) {
PlayerDataTriggerEvent triggerEvent = playerData.TriggerEvents[i];
database.UpdateOrInsert("trigger_events", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "ID", triggerEvent.Items.GetValue("ID")),
database.CreateColumn(false, "Type", triggerEvent.Items.GetValue("Type")),
database.CreateColumn(false, "Action", triggerEvent.Items.GetValue("Action")),
database.CreateColumn(false, "TriggerCommand", triggerEvent.Items.GetValue("TriggerCommand")),
database.CreateColumn(false, "AutoRemove", triggerEvent.Items.GetValue("AutoRemove"))
});
switch (triggerEvent.Items.GetValue("Type")) {
case "1": {
database.UpdateOrInsert("map_load_trigger_event", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "ID", triggerEvent.Items.GetValue("ID")),
database.CreateColumn(false, "MapID", triggerEvent.Items.GetValue("MapID"))
});
}
break;
case "2": {
database.UpdateOrInsert("stepped_on_tile_trigger_event", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "ID", triggerEvent.Items.GetValue("ID")),
database.CreateColumn(false, "MapID", triggerEvent.Items.GetValue("MapID")),
database.CreateColumn(false, "X", triggerEvent.Items.GetValue("X")),
database.CreateColumn(false, "Y", triggerEvent.Items.GetValue("Y"))
});
}
break;
case "3": {
database.UpdateOrInsert("step_counter_trigger_event", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "ID", triggerEvent.Items.GetValue("ID")),
database.CreateColumn(false, "Steps", triggerEvent.Items.GetValue("Steps")),
database.CreateColumn(false, "StepsCounted", triggerEvent.Items.GetValue("StepsCounted")),
});
}
break;
}
}
}
public static void SavePlayerStoryHelperStateSettings(MySql database, PlayerData playerData)
{
for (int i = 0; i < playerData.StoryHelperStateSettings.Count; i++) {
database.UpdateOrInsert("story_helper_state_settings", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "SettingKey", playerData.StoryHelperStateSettings.KeyByIndex(i)),
database.CreateColumn(false, "Value", playerData.StoryHelperStateSettings.ValueByIndex(i))
});
}
}
public static void SavePlayerStoryGenerals(MySql database, PlayerData playerData)
{
database.UpdateOrInsert("story", new IDataColumn[]
{
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "CurrentChapter", playerData.CurrentChapter),
database.CreateColumn(false, "CurrentSegment", playerData.CurrentSegment.ToString())
});
}
public static void SavePlayerStoryChapterState(MySql database, string characterID, int chapter, bool value)
{
database.UpdateOrInsert("story_chapters", new IDataColumn[] {
database.CreateColumn(false, "CharID", characterID),
database.CreateColumn(false, "Chapter", chapter.ToString()),
database.CreateColumn(false, "Complete", value.ToIntString())
});
}
public static void SaveInstancedMap(MySql database, string mapID, InstancedMap map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false) {
database.BeginTransaction();
localTransaction = true;
}
SaveMapDump(database, mapID, map);
// Save extra data associated with instanced maps
database.UpdateOrInsert("map_instanced_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "MapBase", map.MapBase.ToString())
});
if (localTransaction) {
database.EndTransaction();
}
}
public static void ChangePlayerEmail(MySql database, string accountName, string currentEmail, string newEmail)
{
database.UpdateRow("accounts", new IDataColumn[] {
database.CreateColumn(false, "Email", newEmail)
}, "accounts.AccountName = \'" + database.VerifyValueString(accountName) + "\' AND accounts.Email = \'" + database.VerifyValueString(currentEmail) + "\'");
}
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 SavePlayerMissionGenerals(MySql database, PlayerData playerData)
{
database.UpdateOrInsert("missions", new IDataColumn[]
{
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "MissionExp", playerData.MissionExp.ToString()),
database.CreateColumn(false, "LastGenTime", playerData.LastGenTime.ToString()),
database.CreateColumn(false, "Completions", playerData.MissionCompletions.ToString())
});
}
public static void SaveRDungeonMap(MySql database, string mapID, RDungeonMap map)
{
bool localTransaction = false;
if (database.IsTransactionActive == false) {
database.BeginTransaction();
localTransaction = true;
}
SaveMapDump(database, mapID, map);
// Save extra data associated with instanced maps
database.UpdateOrInsert("map_rdungeon_data", new IDataColumn[] {
database.CreateColumn(false, "MapID", mapID),
database.CreateColumn(false, "RDungeonIndex", map.RDungeonIndex.ToString()),
database.CreateColumn(false, "RDungeonFloor", map.RDungeonFloor.ToString()),
database.CreateColumn(false, "StartX", map.StartX.ToString()),
database.CreateColumn(false, "StartY", map.StartY.ToString())
});
if (localTransaction) {
database.EndTransaction();
}
}
public static void SavePlayerStatistics(MySql database, PlayerData playerData)
{
database.UpdateOrInsert("character_statistics", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "TotalPlayTime", playerData.TotalPlayTime.ToString()),
database.CreateColumn(false, "LastIPAddressUsed", playerData.LastIPAddressUsed),
database.CreateColumn(false, "LastMacAddressUsed", playerData.LastMacAddressUsed),
database.CreateColumn(false, "LastLogin", playerData.LastLogin.ToString("yyyy:MM:dd HH:mm:ss")),
database.CreateColumn(false, "LastLogout", playerData.LastLogout.ToString("yyyy:MM:dd HH:mm:ss")),
database.CreateColumn(false, "LastPlayTime", playerData.LastPlayTime.ToString()),
database.CreateColumn(false, "LastOS", playerData.LastOS),
database.CreateColumn(false, "LastDotNetVersion", playerData.LastDotNetVersion)
});
}
public static void SavePlayerLocation(MySql database, PlayerData playerData)
{
database.UpdateOrInsert("location", new IDataColumn[]
{
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "Map", playerData.Map),
database.CreateColumn(false, "X", playerData.X.ToString()),
database.CreateColumn(false, "Y", playerData.Y.ToString()),
database.CreateColumn(false, "Direction", playerData.Direction.ToString())
});
}
public static void SaveStory(int storyNum)
{
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM story WHERE num = \'" + storyNum + "\'");
database.ExecuteNonQuery("DELETE FROM story_segment WHERE num = \'" + storyNum + "\'");
database.ExecuteNonQuery("DELETE FROM story_param WHERE num = \'" + storyNum + "\'");
database.UpdateOrInsert("story", new IDataColumn[] {
database.CreateColumn(false, "num", storyNum.ToString()),
database.CreateColumn(false, "revision", stories[storyNum].Revision.ToString()),
database.CreateColumn(false, "name", stories[storyNum].Name),
database.CreateColumn(false, "story_start", stories[storyNum].StoryStart.ToString())
});
for (int i = 0; i < stories[storyNum].Segments.Count; i++)
{
bool isCheckPoint = false;
for (int j = 0; j < stories[storyNum].ExitAndContinue.Count; j++)
{
if (stories[storyNum].ExitAndContinue[j] == i)
{
isCheckPoint = true;
break;
}
}
database.UpdateOrInsert("story_segment", new IDataColumn[] {
database.CreateColumn(false, "num", storyNum.ToString()),
database.CreateColumn(false, "segment", i.ToString()),
database.CreateColumn(false, "action", ((int)stories[storyNum].Segments[i].Action).ToString()),
database.CreateColumn(false, "checkpoint", isCheckPoint.ToIntString())
});
for (int j = 0; j < stories[storyNum].Segments[i].Parameters.Count; j++)
{
database.UpdateOrInsert("story_param", new IDataColumn[] {
database.CreateColumn(false, "num", storyNum.ToString()),
database.CreateColumn(false, "segment", i.ToString()),
database.CreateColumn(false, "param_key", stories[storyNum].Segments[i].Parameters.KeyByIndex(j)),
database.CreateColumn(false, "param_val", stories[storyNum].Segments[i].Parameters.ValueByIndex(j))
});
}
}
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 SaveMove(int moveNum)
{
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM move WHERE num = \'" + moveNum + "\'");
database.UpdateOrInsert("move", new IDataColumn[] {
database.CreateColumn(false, "num", moveNum.ToString()),
database.CreateColumn(false, "name", moves[moveNum].Name),
database.CreateColumn(false, "max_pp", moves[moveNum].MaxPP.ToString()),
database.CreateColumn(false, "effect_type", ((int)moves[moveNum].EffectType).ToString()),
database.CreateColumn(false, "element", ((int)moves[moveNum].Element).ToString()),
database.CreateColumn(false, "category", ((int)moves[moveNum].MoveCategory).ToString()),
database.CreateColumn(false, "range_type", ((int)moves[moveNum].RangeType).ToString()),
database.CreateColumn(false, "range_dist", moves[moveNum].Range.ToString()),
database.CreateColumn(false, "target", ((int)moves[moveNum].TargetType).ToString()),
database.CreateColumn(false, "data1", moves[moveNum].Data1.ToString()),
database.CreateColumn(false, "data2", moves[moveNum].Data2.ToString()),
database.CreateColumn(false, "data3", moves[moveNum].Data3.ToString()),
database.CreateColumn(false, "effect_data1", moves[moveNum].AdditionalEffectData1.ToString()),
database.CreateColumn(false, "effect_data2", moves[moveNum].AdditionalEffectData2.ToString()),
database.CreateColumn(false, "effect_data3", moves[moveNum].AdditionalEffectData3.ToString()),
database.CreateColumn(false, "accuracy", moves[moveNum].Accuracy.ToString()),
database.CreateColumn(false, "hit_time", moves[moveNum].HitTime.ToString()),
database.CreateColumn(false, "hit_freeze", moves[moveNum].HitFreeze.ToIntString()),
database.CreateColumn(false, "per_player", moves[moveNum].PerPlayer.ToIntString()),
database.CreateColumn(false, "key_effect", moves[moveNum].KeyItem.ToString()),
database.CreateColumn(false, "sound", moves[moveNum].Sound.ToString()),
database.CreateColumn(false, "attack_anim_type", ((int)moves[moveNum].AttackerAnim.AnimationType).ToString()),
database.CreateColumn(false, "attack_anim_index", moves[moveNum].AttackerAnim.AnimationIndex.ToString()),
database.CreateColumn(false, "attack_anim_speed", moves[moveNum].AttackerAnim.FrameSpeed.ToString()),
database.CreateColumn(false, "attack_anim_cycle", moves[moveNum].AttackerAnim.Repetitions.ToString()),
database.CreateColumn(false, "travel_anim_type", ((int)moves[moveNum].TravelingAnim.AnimationType).ToString()),
database.CreateColumn(false, "travel_anim_index", moves[moveNum].TravelingAnim.AnimationIndex.ToString()),
database.CreateColumn(false, "travel_anim_speed", moves[moveNum].TravelingAnim.FrameSpeed.ToString()),
database.CreateColumn(false, "travel_anim_cycle", moves[moveNum].TravelingAnim.Repetitions.ToString()),
database.CreateColumn(false, "landed_anim_type", ((int)moves[moveNum].DefenderAnim.AnimationType).ToString()),
database.CreateColumn(false, "landed_anim_index", moves[moveNum].DefenderAnim.AnimationIndex.ToString()),
database.CreateColumn(false, "landed_anim_speed", moves[moveNum].DefenderAnim.FrameSpeed.ToString()),
database.CreateColumn(false, "landed_anim_cycle", moves[moveNum].DefenderAnim.Repetitions.ToString()),
});
database.EndTransaction();
}
}
/*
public static void SavePlayerMissionBoardGenerals(MySql database, PlayerData playerData) {
database.UpdateOrInsert("mission_board", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "LastGenerationDate", playerData.MissionBoardLastGenerationDate.Ticks.ToString())
});
}
*/
public static void SavePlayerMissionBoardMissions(MySql database, PlayerData playerData)
{
database.ExecuteNonQuery("DELETE FROM mission_board_missions WHERE CharID = \'" + playerData.CharID + "\'");
for (int i = 0; i < playerData.MissionBoardMissions.Count; i++) {
database.UpdateOrInsert("mission_board_missions", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "Slot", i.ToString()),
database.CreateColumn(false, "ClientIndex", playerData.MissionBoardMissions[i].MissionClientIndex.ToString()),
database.CreateColumn(false, "TargetIndex", playerData.MissionBoardMissions[i].TargetIndex.ToString()),
database.CreateColumn(false, "RewardIndex", playerData.MissionBoardMissions[i].RewardIndex.ToString()),
database.CreateColumn(false, "MissionType", playerData.MissionBoardMissions[i].MissionType.ToString()),
database.CreateColumn(false, "Data1", playerData.MissionBoardMissions[i].Data1.ToString()),
database.CreateColumn(false, "Data2", playerData.MissionBoardMissions[i].Data2.ToString()),
database.CreateColumn(false, "DungeonIndex", playerData.MissionBoardMissions[i].DungeonIndex.ToString()),
database.CreateColumn(false, "Goal", playerData.MissionBoardMissions[i].GoalMapIndex.ToString()),
database.CreateColumn(false, "RDungeon", playerData.MissionBoardMissions[i].RDungeon.ToIntString()),
database.CreateColumn(false, "StartScript", playerData.MissionBoardMissions[i].StartStoryScript.ToString()),
database.CreateColumn(false, "WinScript", playerData.MissionBoardMissions[i].WinStoryScript.ToString()),
database.CreateColumn(false, "LoseScript", playerData.MissionBoardMissions[i].LoseStoryScript.ToString())
});
}
}
/// <summary>
/// Will mark a recruit slot as deleted, allowing it to be overwritten. If inTempMode is true, the entry will be deleted instead.
/// </summary>
/// <param name="database">The database.</param>
/// <param name="charID">The char ID.</param>
/// <param name="recruitIndex">Index of the recruit.</param>
/// <param name="inTempMode">if set to <c>true</c>, the temporary recruit will be deleted. Otherwise, the main recruit will be deleted.</param>
public static void DeletePlayerRecruit(MySql database, string charID, int recruitIndex, bool inTempMode)
{
if (inTempMode == false) {
// Mark recruit slot as deleted
database.UpdateOrInsert("recruit_data", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "RecruitIndex", recruitIndex.ToString()),
database.CreateColumn(false, "UsingTempStats", inTempMode.ToIntString()),
database.CreateColumn(false, "Name", "#DELETED#"),
database.CreateColumn(false, "Level", "-1"),
database.CreateColumn(false, "IQ", "-1")
});
} else {
// This recruit is in temp stat mode, so just delete it's temp stat mode copy
database.ExecuteNonQuery("DELETE FROM recruit_data WHERE CharID = \'" + charID + "\' " +
"AND RecruitIndex = \'" + recruitIndex + "\' " +
"AND UsingTempStats = \'" + inTempMode.ToIntString() + "\'");
}
// Delete moves
database.ExecuteNonQuery("DELETE FROM recruit_moves WHERE CharID = \'" + charID + "\' " +
"AND RecruitIndex = \'" + recruitIndex + "\' " +
"AND UsingTempStats = \'" + inTempMode.ToIntString() + "\'");
// Delete extra statuses
database.ExecuteNonQuery("DELETE FROM recruit_volatile_status WHERE CharID = \'" + charID + "\' " +
"AND RecruitIndex = \'" + recruitIndex + "\' " +
"AND UsingTempStats = \'" + inTempMode.ToIntString() + "\'");
}
public static void SavePlayerAvailableExpKitModules(MySql database, PlayerData playerData)
{
database.UpdateOrInsert("expkit", new IDataColumn[]
{
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "AvailableModules", playerData.AvailableModules.ToString())
});
}
public static void SavePlayerBankItem(MySql database, string charID, int slot, Characters.InventoryItem item)
{
database.UpdateOrInsert("bank", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "ItemSlot", slot.ToString()),
database.CreateColumn(false, "ItemNum", item.Num.ToString()),
database.CreateColumn(false, "Amount", item.Amount.ToString()),
database.CreateColumn(false, "Sticky", item.Sticky.ToIntString()),
database.CreateColumn(false, "Tag", item.Tag)
});
}
public static void SaveNpc(int npcNum)
{
if (npcs.Npcs.ContainsKey(npcNum) == false)
{
npcs.Npcs.Add(npcNum, new Npc());
}
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM npc WHERE num = \'" + npcNum + "\'");
database.ExecuteNonQuery("DELETE FROM npc_drop WHERE npc_num = \'" + npcNum + "\'");
database.UpdateOrInsert("npc", new IDataColumn[] {
database.CreateColumn(false, "num", npcNum.ToString()),
database.CreateColumn(false, "name", npcs[npcNum].Name),
database.CreateColumn(false, "attack_say", npcs[npcNum].AttackSay),
database.CreateColumn(false, "species", npcs[npcNum].Species.ToString()),
database.CreateColumn(false, "form", npcs[npcNum].Form.ToString()),
database.CreateColumn(false, "behavior", ((int)npcs[npcNum].Behavior).ToString()),
database.CreateColumn(false, "shiny_chance", npcs[npcNum].ShinyChance.ToString()),
database.CreateColumn(false, "dawn_spawn", npcs[npcNum].SpawnsAtDawn.ToIntString()),
database.CreateColumn(false, "day_spawn", npcs[npcNum].SpawnsAtDay.ToIntString()),
database.CreateColumn(false, "dusk_spawn", npcs[npcNum].SpawnsAtDusk.ToIntString()),
database.CreateColumn(false, "night_spawn", npcs[npcNum].SpawnsAtNight.ToIntString()),
database.CreateColumn(false, "ai_script", npcs[npcNum].AIScript),
database.CreateColumn(false, "recruit_rate", npcs[npcNum].RecruitRate.ToString()),
database.CreateColumn(false, "move1", npcs[npcNum].Moves[0].ToString()),
database.CreateColumn(false, "move2", npcs[npcNum].Moves[1].ToString()),
database.CreateColumn(false, "move3", npcs[npcNum].Moves[2].ToString()),
database.CreateColumn(false, "move4", npcs[npcNum].Moves[3].ToString()),
});
for (int i = 0; i < npcs[npcNum].Drops.Length; i++)
{
database.UpdateOrInsert("npc_drop", new IDataColumn[] {
database.CreateColumn(false, "npc_num", npcNum.ToString()),
database.CreateColumn(false, "drop_num", i.ToString()),
database.CreateColumn(false, "item_num", npcs[npcNum].Drops[i].ItemNum.ToString()),
database.CreateColumn(false, "item_val", npcs[npcNum].Drops[i].ItemValue.ToString()),
database.CreateColumn(false, "tag", npcs[npcNum].Drops[i].Tag),
database.CreateColumn(false, "chance", npcs[npcNum].Drops[i].Chance.ToString()),
});
}
database.EndTransaction();
}
}
public static void SaveDungeon(int dungeonNum)
{
if (dungeons.Dungeons.ContainsKey(dungeonNum) == false)
{
dungeons.Dungeons.Add(dungeonNum, new Dungeon());
}
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM dungeon WHERE num = \'" + dungeonNum + "\'");
database.ExecuteNonQuery("DELETE FROM dungeon_smap WHERE num = \'" + dungeonNum + "\'");
database.ExecuteNonQuery("DELETE FROM dungeon_rmap WHERE num = \'" + dungeonNum + "\'");
database.ExecuteNonQuery("DELETE FROM dungeon_script WHERE num = \'" + dungeonNum + "\'");
database.UpdateOrInsert("dungeon", new IDataColumn[] {
database.CreateColumn(false, "num", dungeonNum.ToString()),
database.CreateColumn(false, "name", dungeons[dungeonNum].Name),
database.CreateColumn(false, "rescue", dungeons[dungeonNum].AllowsRescue.ToIntString())
});
for (int i = 0; i < dungeons[dungeonNum].StandardMaps.Count; i++)
{
database.UpdateOrInsert("dungeon_smap", new IDataColumn[] {
database.CreateColumn(false, "num", dungeonNum.ToString()),
database.CreateColumn(false, "map_id", dungeons[dungeonNum].StandardMaps[i].MapNum.ToString()),
database.CreateColumn(false, "difficulty", ((int)dungeons[dungeonNum].StandardMaps[i].Difficulty).ToString()),
database.CreateColumn(false, "boss_map", dungeons[dungeonNum].StandardMaps[i].IsBadGoalMap.ToIntString())
});
}
for (int i = 0; i < dungeons[dungeonNum].RandomMaps.Count; i++)
{
database.UpdateOrInsert("dungeon_rmap", new IDataColumn[] {
database.CreateColumn(false, "num", dungeonNum.ToString()),
database.CreateColumn(false, "rdungeon_num", dungeons[dungeonNum].RandomMaps[i].RDungeonIndex.ToString()),
database.CreateColumn(false, "rdungeon_floor", dungeons[dungeonNum].RandomMaps[i].RDungeonFloor.ToString()),
database.CreateColumn(false, "difficulty", ((int)dungeons[dungeonNum].RandomMaps[i].Difficulty).ToString()),
database.CreateColumn(false, "boss_map", dungeons[dungeonNum].RandomMaps[i].IsBadGoalMap.ToIntString())
});
}
for (int i = 0; i < dungeons[dungeonNum].ScriptList.Count; i++)
{
database.UpdateOrInsert("dungeon_script", new IDataColumn[] {
database.CreateColumn(false, "num", dungeonNum.ToString()),
database.CreateColumn(false, "script_key", dungeons[dungeonNum].ScriptList.KeyByIndex(i).ToString()),
database.CreateColumn(false, "script_args", dungeons[dungeonNum].ScriptList.ValueByIndex(i).ToString())
});
}
database.EndTransaction();
}
}
public static void SaveItem(int itemNum)
{
using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data))
{
MySql database = dbConnection.Database;
database.BeginTransaction();
database.ExecuteNonQuery("DELETE FROM item WHERE num = \'" + itemNum + "\'");
database.UpdateOrInsert("item", new IDataColumn[] {
database.CreateColumn(false, "num", itemNum.ToString()),
database.CreateColumn(false, "name", items[itemNum].Name),
database.CreateColumn(false, "info", items[itemNum].Desc),
database.CreateColumn(false, "pic", items[itemNum].Pic.ToString()),
database.CreateColumn(false, "item_type", ((int)items[itemNum].Type).ToString()),
database.CreateColumn(false, "data1", items[itemNum].Data1.ToString()),
database.CreateColumn(false, "data2", items[itemNum].Data2.ToString()),
database.CreateColumn(false, "data3", items[itemNum].Data3.ToString()),
database.CreateColumn(false, "price", items[itemNum].Price.ToString()),
database.CreateColumn(false, "stack_cap", items[itemNum].StackCap.ToString()),
database.CreateColumn(false, "bound", items[itemNum].Bound.ToIntString()),
database.CreateColumn(false, "loseable", items[itemNum].Loseable.ToIntString()),
database.CreateColumn(false, "rarity", items[itemNum].Rarity.ToString()),
database.CreateColumn(false, "req_data1", items[itemNum].ReqData1.ToString()),
database.CreateColumn(false, "req_data2", items[itemNum].ReqData2.ToString()),
database.CreateColumn(false, "req_data3", items[itemNum].ReqData3.ToString()),
database.CreateColumn(false, "req_data4", items[itemNum].ReqData4.ToString()),
database.CreateColumn(false, "req_data5", items[itemNum].ReqData5.ToString()),
database.CreateColumn(false, "scripted_req", items[itemNum].ScriptedReq.ToString()),
database.CreateColumn(false, "add_hp", items[itemNum].AddHP.ToString()),
database.CreateColumn(false, "add_pp", items[itemNum].AddPP.ToString()),
database.CreateColumn(false, "add_atk", items[itemNum].AddAttack.ToString()),
database.CreateColumn(false, "add_def", items[itemNum].AddDefense.ToString()),
database.CreateColumn(false, "add_spatk", items[itemNum].AddSpAtk.ToString()),
database.CreateColumn(false, "add_spdef", items[itemNum].AddSpDef.ToString()),
database.CreateColumn(false, "add_speed", items[itemNum].AddSpeed.ToString()),
database.CreateColumn(false, "add_exp", items[itemNum].AddEXP.ToString()),
database.CreateColumn(false, "attack_speed", items[itemNum].AttackSpeed.ToString()),
database.CreateColumn(false, "recruit_bonus", items[itemNum].RecruitBonus.ToString())
});
database.EndTransaction();
}
}
public static void SavePlayerRecruitList(MySql database, PlayerData playerData)
{
for (int i = 0; i < playerData.StoryHelperStateSettings.Count; i++) {
database.UpdateOrInsert("recruit_list", new IDataColumn[] {
database.CreateColumn(false, "CharID", playerData.CharID),
database.CreateColumn(false, "PokemonID", playerData.RecruitList.KeyByIndex(i).ToString()),
database.CreateColumn(false, "Status", playerData.RecruitList.ValueByIndex(i).ToString())
});
}
}