public void StartNewGame(string name, string portraitPath)
{
string[,] pgFields = new string[, ] {
{ "PlayerNames", name },
{ "PortraitImages", portraitPath },
{ "Dates", DateTime.Now.ToString() },
{ "LocationName", "Start" },
{ "LocationX", "-2" },
{ "LocationY", "0" },
{ "SkillPointsSpent", "0" }
};
DbCommands.UpdateTableTuple("PlayerGames", "SaveIDs = 0", pgFields);
//Dialogues activated
string[,] delFields = new string[, ] {
{ "SaveIDs", "0" }
};
DbCommands.DeleteTupleInTable("ActivatedDialogues", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("ActivatedDialogues",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { "-1" });
//Quests activated
DbCommands.DeleteTupleInTable("QuestsActivated", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestsActivated",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { "-1" });
//Quests tasks completed
DbCommands.DeleteTupleInTable("QuestTasksActivated", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestTasksActivated",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { "-1" });
//Task parts completed
DbCommands.DeleteTupleInTable("CompletedQuestTaskParts", delFields);
//discovered vocabulary
DbCommands.DeleteTupleInTable("DiscoveredVocab", delFields);
//discovered vocabulary
DbCommands.DeleteTupleInTable("DiscoveredVocabGrammar", delFields);
//acquired vocabulary read proficiencies
DbCommands.DeleteTupleInTable("AcquiredVocabReadSkills", delFields);
//acquired vocabulary write proficiencies
DbCommands.DeleteTupleInTable("AcquiredVocabWriteSkills", delFields);
//acquired grammar proficiencies
DbCommands.DeleteTupleInTable("AcquiredGrammarSkills", delFields);
PlayerPrefsManager.SetSaveGame(0);
sceneLoader.LoadSceneByName("Demo");
}
public void CopyPlayerSaveToCurrentGame(string[] playerGameData)
{
string saveID = playerGameData[0];
if (saveID != "0")
{
//PlayerGames tbl
string[,] pgFields = new string[, ] {
{ "PlayerNames", playerGameData[2] },
{ "PortraitImages", playerGameData[3] },
{ "LocationName", playerGameData[5] }
};
DbCommands.UpdateTableTuple("PlayerGames", "SaveIDs = 0", pgFields);
string[,] delFields = new string[, ] {
{ "SaveIDs", "0" }
};
//Dialogues activated
DbCommands.DeleteTupleInTable("ActivatedDialogues", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("ActivatedDialogues",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//Quests activated
DbCommands.DeleteTupleInTable("QuestsActivated", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestsActivated",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//Quests tasks completed
DbCommands.DeleteTupleInTable("QuestTasksActivated", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestTasksActivated",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//Task parts completed
DbCommands.DeleteTupleInTable("CompletedQuestTaskParts", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("CompletedQuestTaskParts",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//discovered vocab
DbCommands.DeleteTupleInTable("DiscoveredVocab", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocab",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//discovered grammar
DbCommands.DeleteTupleInTable("DiscoveredVocabGrammar", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocabGrammar",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//acquired vocabulary read proficiencies
DbCommands.DeleteTupleInTable("AcquiredVocabReadSkills", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabReadSkills",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//acquired vocabulary write proficiencies
DbCommands.DeleteTupleInTable("AcquiredVocabWriteSkills", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabWriteSkills",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
//acquired grammar proficiencies
DbCommands.DeleteTupleInTable("AcquiredGrammarSkills", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredGrammarSkills",
new string[] { "SaveIDs" },
new string[] { "0" },
new string[] { playerGameData[0] });
}
}
public void CopyCurrentGameToPlayerSave(int saveID)
{
string saveIDstr = saveID.ToString();
//Dialogues activated
string[,] delFields = new string[, ] {
{ "SaveIDs", saveIDstr }
};
DbCommands.DeleteTupleInTable("ActivatedDialogues", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("ActivatedDialogues",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//Quests activated
DbCommands.DeleteTupleInTable("QuestsActivated", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestsActivated",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//Quests tasks completed
DbCommands.DeleteTupleInTable("QuestTasksActivated", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("QuestTasksActivated",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//Task parts completed
DbCommands.DeleteTupleInTable("CompletedQuestTaskParts", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("CompletedQuestTaskParts",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//Discovered vocab
DbCommands.DeleteTupleInTable("DiscoveredVocab", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocab",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//Discovered grammar
DbCommands.DeleteTupleInTable("DiscoveredVocabGrammar", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("DiscoveredVocabGrammar",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//acquired vocabulary read proficiencies
DbCommands.DeleteTupleInTable("AcquiredVocabReadSkills", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabReadSkills",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//acquired vocabulary write proficiencies
DbCommands.DeleteTupleInTable("AcquiredVocabWriteSkills", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredVocabWriteSkills",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
//acquired grammar proficiencies
DbCommands.DeleteTupleInTable("AcquiredGrammarSkills", delFields);
DbCommands.InsertExistingValuesInSameTableWithNewPK("AcquiredGrammarSkills",
new string[] { "SaveIDs" },
new string[] { saveIDstr },
new string[] { "0" });
}
