コード例 #1
0
ファイル: DB.cs プロジェクト: loohney/Clans3
 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}.");
 }
コード例 #2
0
ファイル: DB.cs プロジェクト: loohney/Clans3
        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}.");
        }