void LoadFactionStances(FactionData factionData) { // Read all entries from the table string query = "SELECT * FROM " + "faction_stances" + " where factionID = " + factionData.id; // If there is a row, clear it. if (rows != null) rows.Clear (); // Load data rows = DatabasePack.LoadData (DatabasePack.contentDatabasePrefix, query); //Debug.Log("#Rows:"+rows.Count); // Read all the data if ((rows!=null) && (rows.Count > 0)) { foreach (Dictionary<string,string> data in rows) { FactionStanceEntry entry = new FactionStanceEntry (); entry.id = int.Parse (data ["id"]); entry.factionID = int.Parse (data ["factionID"]); entry.otherFactionID = int.Parse (data ["otherFaction"]); entry.defaultStance = int.Parse (data ["defaultStance"]); factionData.factionStances.Add(entry); } } }
void UpdateStance(FactionStanceEntry entry) { string query = "UPDATE faction_stances"; query += " SET "; query += entry.UpdateList (); query += " WHERE id=?id"; // Setup the register data List<Register> update = new List<Register> (); foreach (string field in entry.fields.Keys) { update.Add (entry.fieldToRegister (field)); } DatabasePack.Update (DatabasePack.contentDatabasePrefix, query, update); }
void InsertStance(FactionStanceEntry entry) { string query = "INSERT INTO faction_stances"; query += " (factionID, otherFaction, defaultStance) "; query += "VALUES "; query += " (" + entry.factionID + "," + entry.otherFactionID + "," + entry.defaultStance + ") "; // Setup the register data List<Register> update = new List<Register> (); foreach (string field in entry.fields.Keys) { update.Add (entry.fieldToRegister (field)); } int itemID = -1; itemID = DatabasePack.Insert (DatabasePack.contentDatabasePrefix, query, update); entry.id = itemID; }