Example #1
0
        public static DbRow UpdateDbWithBasicInfo(uint id, NerZul.Core.Utils.BasicBotInfo nfo)
        {
            //#if PUBLIC_BUILD
            if (!Globals.IsValid())
                return null;
            //#endif

            var Database=Globals.Database;
            lock (Globals.DBLocker)
            {
                Database.Reset();
                Database.Where("id",id);
                Database.Update("bots",
                                "citizen_id",nfo.CitizenID,
                                "experience",nfo.Experience,
                                "wellness",nfo.Wellness,
                                "country",nfo.Country,
                                "gold",nfo.Gold,
                                "nat_occur",nfo.Nat_occur);
                var DbRow=Database.Select("bots")[0];
                Database.Reset();
                return DbRow;
            }
        }
Example #2
0
        public static DbRow UpdateDbWithStorageInfo(uint id, NerZul.Core.Utils.StorageBotInfo nfo)
        {
            //#if PUBLIC_BUILD
            if (!Globals.IsValid())
                return null;
            //#endif

            var Database = Globals.Database;
            lock (Globals.DBLocker)
            {
                Database.Reset();
                Database.Where("id", id);
                Database.Update("bots",
                                "food_qty", nfo.foodQty,
                                "items_qty", nfo.itemsQty);
                var DbRow = Database.Select("bots")[0];
                Database.Reset();
                return DbRow;
            }
        }