Exemple #1
0
 public override void UpdateBuilding(string mapName, IBuildingSaveData building)
 {
     ExecuteNonQuery("UPDATE buildings SET " +
                     "parentId=@parentId, " +
                     "entityId=@entityId, " +
                     "currentHp=@currentHp, " +
                     "positionX=@positionX, " +
                     "positionY=@positionY, " +
                     "positionZ=@positionZ, " +
                     "rotationX=@rotationX, " +
                     "rotationY=@rotationY, " +
                     "rotationZ=@rotationZ, " +
                     "isLocked=@isLocked, " +
                     "lockPassword=@lockPassword, " +
                     "creatorId=@creatorId, " +
                     "creatorName=@creatorName " +
                     "WHERE id=@id AND mapName=@mapName",
                     new SqliteParameter("@id", building.Id),
                     new SqliteParameter("@parentId", building.ParentId),
                     new SqliteParameter("@entityId", building.EntityId),
                     new SqliteParameter("@currentHp", building.CurrentHp),
                     new SqliteParameter("@mapName", mapName),
                     new SqliteParameter("@positionX", building.Position.x),
                     new SqliteParameter("@positionY", building.Position.y),
                     new SqliteParameter("@positionZ", building.Position.z),
                     new SqliteParameter("@rotationX", building.Rotation.eulerAngles.x),
                     new SqliteParameter("@rotationY", building.Rotation.eulerAngles.y),
                     new SqliteParameter("@rotationZ", building.Rotation.eulerAngles.z),
                     new SqliteParameter("@isLocked", building.IsLocked),
                     new SqliteParameter("@lockPassword", building.LockPassword),
                     new SqliteParameter("@creatorId", building.CreatorId),
                     new SqliteParameter("@creatorName", building.CreatorName));
 }
Exemple #2
0
        public override void UpdateBuilding(string mapName, IBuildingSaveData building)
        {
            MySqlConnection connection = NewConnection();

            connection.Open();
            ExecuteNonQuery(connection, null, "UPDATE buildings SET " +
                            "parentId=@parentId, " +
                            "dataId=@dataId, " +
                            "currentHp=@currentHp, " +
                            "positionX=@positionX, " +
                            "positionY=@positionY, " +
                            "positionZ=@positionZ, " +
                            "rotationX=@rotationX, " +
                            "rotationY=@rotationY, " +
                            "rotationZ=@rotationZ, " +
                            "creatorId=@creatorId, " +
                            "creatorName=@creatorName " +
                            "WHERE id=@id AND mapName=@mapName",
                            new MySqlParameter("@id", building.Id),
                            new MySqlParameter("@parentId", building.ParentId),
                            new MySqlParameter("@dataId", building.DataId),
                            new MySqlParameter("@currentHp", building.CurrentHp),
                            new MySqlParameter("@mapName", mapName),
                            new MySqlParameter("@positionX", building.Position.x),
                            new MySqlParameter("@positionY", building.Position.y),
                            new MySqlParameter("@positionZ", building.Position.z),
                            new MySqlParameter("@rotationX", building.Rotation.eulerAngles.x),
                            new MySqlParameter("@rotationY", building.Rotation.eulerAngles.y),
                            new MySqlParameter("@rotationZ", building.Rotation.eulerAngles.z),
                            new MySqlParameter("@creatorId", building.CreatorId),
                            new MySqlParameter("@creatorName", building.CreatorName));
            connection.Close();
        }
        private IEnumerator SaveBuildingRoutine(IBuildingSaveData buildingSaveData)
        {
            if (buildingSaveData != null && !savingBuildings.Contains(buildingSaveData.Id))
            {
                savingBuildings.Add(buildingSaveData.Id);
                var job = new UpdateBuildingJob(Database, Assets.onlineScene.SceneName, buildingSaveData);
                job.Start();
                yield return(StartCoroutine(job.WaitFor()));

                savingBuildings.Remove(buildingSaveData.Id);
                Debug.Log("Building [" + buildingSaveData.Id + "] Saved");
            }
        }
 public static T CloneTo <T>(this IBuildingSaveData from, T to) where T : IBuildingSaveData
 {
     to.Id          = from.Id;
     to.ParentId    = from.ParentId;
     to.DataId      = from.DataId;
     to.CurrentHp   = from.CurrentHp;
     to.Position    = from.Position;
     to.Rotation    = from.Rotation;
     to.CreatorId   = from.CreatorId;
     to.CreatorName = from.CreatorName;
     DevExtUtils.InvokeStaticDevExtMethods(ClassType, "CloneTo", from, to);
     return(to);
 }
Exemple #5
0
 public override void CreateBuilding(string mapName, IBuildingSaveData saveData)
 {
     ExecuteNonQuery("INSERT INTO buildings (id, parentId, entityId, currentHp, mapName, positionX, positionY, positionZ, rotationX, rotationY, rotationZ, creatorId, creatorName) VALUES (@id, @parentId, @entityId, @currentHp, @mapName, @positionX, @positionY, @positionZ, @rotationX, @rotationY, @rotationZ, @creatorId, @creatorName)",
                     new SqliteParameter("@id", saveData.Id),
                     new SqliteParameter("@parentId", saveData.ParentId),
                     new SqliteParameter("@entityId", saveData.EntityId),
                     new SqliteParameter("@currentHp", saveData.CurrentHp),
                     new SqliteParameter("@mapName", mapName),
                     new SqliteParameter("@positionX", saveData.Position.x),
                     new SqliteParameter("@positionY", saveData.Position.y),
                     new SqliteParameter("@positionZ", saveData.Position.z),
                     new SqliteParameter("@rotationX", saveData.Rotation.eulerAngles.x),
                     new SqliteParameter("@rotationY", saveData.Rotation.eulerAngles.y),
                     new SqliteParameter("@rotationZ", saveData.Rotation.eulerAngles.z),
                     new SqliteParameter("@creatorId", saveData.CreatorId),
                     new SqliteParameter("@creatorName", saveData.CreatorName));
 }
Exemple #6
0
        public override void UpdateBuilding(string mapName, IBuildingSaveData building)
        {
            MySqlConnection connection = NewConnection();

            OpenConnectionSync(connection);
            ExecuteNonQuerySync(connection, null, "UPDATE buildings SET " +
                                "parentId=@parentId, " +
                                "entityId=@entityId, " +
                                "currentHp=@currentHp, " +
                                "remainsLifeTime=@remainsLifeTime, " +
                                "isLocked=@isLocked, " +
                                "lockPassword=@lockPassword, " +
                                "creatorId=@creatorId, " +
                                "creatorName=@creatorName, " +
                                "extraData=@extraData, " +
                                "positionX=@positionX, " +
                                "positionY=@positionY, " +
                                "positionZ=@positionZ, " +
                                "rotationX=@rotationX, " +
                                "rotationY=@rotationY, " +
                                "rotationZ=@rotationZ " +
                                "WHERE id=@id AND mapName=@mapName",
                                new MySqlParameter("@id", building.Id),
                                new MySqlParameter("@parentId", building.ParentId),
                                new MySqlParameter("@entityId", building.EntityId),
                                new MySqlParameter("@currentHp", building.CurrentHp),
                                new MySqlParameter("@remainsLifeTime", building.RemainsLifeTime),
                                new MySqlParameter("@mapName", mapName),
                                new MySqlParameter("@isLocked", building.IsLocked),
                                new MySqlParameter("@lockPassword", building.LockPassword),
                                new MySqlParameter("@creatorId", building.CreatorId),
                                new MySqlParameter("@creatorName", building.CreatorName),
                                new MySqlParameter("@extraData", building.ExtraData),
                                new MySqlParameter("@positionX", building.Position.x),
                                new MySqlParameter("@positionY", building.Position.y),
                                new MySqlParameter("@positionZ", building.Position.z),
                                new MySqlParameter("@rotationX", building.Rotation.eulerAngles.x),
                                new MySqlParameter("@rotationY", building.Rotation.eulerAngles.y),
                                new MySqlParameter("@rotationZ", building.Rotation.eulerAngles.z));
            connection.Close();
        }
        public override void CreateBuilding(string mapName, IBuildingSaveData saveData)
        {
            MySqlConnection connection = NewConnection();

            connection.Open();
            ExecuteNonQuery(connection, null, "INSERT INTO buildings (id, parentId, dataId, currentHp, mapName, positionX, positionY, positionZ, rotationX, rotationY, rotationZ, creatorId, creatorName) VALUES (@id, @parentId, @dataId, @currentHp, @mapName, @positionX, @positionY, @positionZ, @rotationX, @rotationY, @rotationZ, @creatorId, @creatorName)",
                            new MySqlParameter("@id", saveData.Id),
                            new MySqlParameter("@parentId", saveData.ParentId),
                            new MySqlParameter("@dataId", saveData.DataId),
                            new MySqlParameter("@currentHp", saveData.CurrentHp),
                            new MySqlParameter("@mapName", mapName),
                            new MySqlParameter("@positionX", saveData.Position.x),
                            new MySqlParameter("@positionY", saveData.Position.y),
                            new MySqlParameter("@positionZ", saveData.Position.z),
                            new MySqlParameter("@rotationX", saveData.Rotation.eulerAngles.x),
                            new MySqlParameter("@rotationY", saveData.Rotation.eulerAngles.y),
                            new MySqlParameter("@rotationZ", saveData.Rotation.eulerAngles.z),
                            new MySqlParameter("@creatorId", saveData.CreatorId),
                            new MySqlParameter("@creatorName", saveData.CreatorName));
            connection.Close();
        }
Exemple #8
0
        private IEnumerator SaveBuildingRoutine(IBuildingSaveData buildingSaveData)
        {
            if (buildingSaveData != null && !savingBuildings.Contains(buildingSaveData.Id))
            {
                savingBuildings.Add(buildingSaveData.Id);
                UpdateBuildingJob job = new UpdateBuildingJob(Database, Assets.onlineScene.SceneName, buildingSaveData);
                job.Start();
                yield return(StartCoroutine(job.WaitFor()));

                StorageId storageId = new StorageId(StorageType.Building, buildingSaveData.Id);
                if (storageItems.ContainsKey(storageId))
                {
                    UpdateStorageItemsJob updateStorageItemsJob = new UpdateStorageItemsJob(Database, storageId.storageType, storageId.storageOwnerId, storageItems[storageId]);
                    updateStorageItemsJob.Start();
                    yield return(StartCoroutine(updateStorageItemsJob.WaitFor()));
                }
                savingBuildings.Remove(buildingSaveData.Id);
                if (LogInfo)
                {
                    Debug.Log("Building [" + buildingSaveData.Id + "] Saved");
                }
            }
        }
Exemple #9
0
        public override async UniTask CreateBuilding(string mapName, IBuildingSaveData saveData)
        {
            MySqlConnection connection = NewConnection();

            await OpenConnection(connection);
            await ExecuteNonQuery(connection, null, "INSERT INTO buildings (id, parentId, entityId, currentHp, remainsLifeTime, mapName, positionX, positionY, positionZ, rotationX, rotationY, rotationZ, creatorId, creatorName) VALUES (@id, @parentId, @entityId, @currentHp, @remainsLifeTime, @mapName, @positionX, @positionY, @positionZ, @rotationX, @rotationY, @rotationZ, @creatorId, @creatorName)",
                                  new MySqlParameter("@id", saveData.Id),
                                  new MySqlParameter("@parentId", saveData.ParentId),
                                  new MySqlParameter("@entityId", saveData.EntityId),
                                  new MySqlParameter("@currentHp", saveData.CurrentHp),
                                  new MySqlParameter("@remainsLifeTime", saveData.RemainsLifeTime),
                                  new MySqlParameter("@mapName", mapName),
                                  new MySqlParameter("@positionX", saveData.Position.x),
                                  new MySqlParameter("@positionY", saveData.Position.y),
                                  new MySqlParameter("@positionZ", saveData.Position.z),
                                  new MySqlParameter("@rotationX", saveData.Rotation.eulerAngles.x),
                                  new MySqlParameter("@rotationY", saveData.Rotation.eulerAngles.y),
                                  new MySqlParameter("@rotationZ", saveData.Rotation.eulerAngles.z),
                                  new MySqlParameter("@creatorId", saveData.CreatorId),
                                  new MySqlParameter("@creatorName", saveData.CreatorName));

            await connection.CloseAsync();
        }
Exemple #10
0
 public UpdateBuildingJob(BaseDatabase database, string sceneName, IBuildingSaveData saveData, Action onFinished = null) : base(database, onFinished)
 {
     this.sceneName = sceneName;
     this.saveData  = saveData;
 }
 public abstract void UpdateBuilding(string mapName, IBuildingSaveData building);
 public abstract void CreateBuilding(string mapName, IBuildingSaveData saveData);
Exemple #13
0
 public abstract UniTask UpdateBuilding(string mapName, IBuildingSaveData building);
Exemple #14
0
 public abstract UniTask CreateBuilding(string mapName, IBuildingSaveData saveData);