public static void changeMembers(int owner, Clan newclan) { string admins = ","; string members = ","; admins += string.Join(",", newclan.admins); admins += ","; members += string.Join(",", newclan.members); members += ","; if (newclan.admins.Count == 0) admins = ""; if (newclan.members.Count == 0) members = ""; int result = db.Query("UPDATE Clans SET admins=@0,members=@1 WHERE owner=@2;", admins, members, owner); if (result != 1) TShock.Log.Error($"Database error: Failed to update players where owner = {owner}."); }
public static void changeOwner(int oldowner, Clan newclan) { string admins = ","; string members = ","; admins += string.Join(",", newclan.admins); admins += ","; members += string.Join(",", newclan.members); members += ","; if (newclan.admins.Count == 0) admins = ""; if (newclan.members.Count == 0) members = ""; int result = db.Query("UPDATE Clans SET owner=@0,admins=@1,members=@2 WHERE owner=@3;", newclan.owner, admins, members, oldowner); if (result != 1) TShock.Log.Error($"Database error: Failed to change owner where oldowner = {oldowner} and newowner = {newclan.owner}."); }