Esempio n. 1
0
        public static void DetainItem(Interfaces.IConquerItem item, Client.GameState owner, Client.GameState gainer)
        {
            DetainedItem Item = new DetainedItem(true);
            Item.ItemUID = item.UID;
            Item.Item = item;
            Item.UID = Item.ItemUID - 1;
            Item.ConquerPointsCost = CalculateCost(item);
            Item.OwnerUID = owner.Entity.UID;
            Item.OwnerName = owner.Entity.Name;
            Item.GainerUID = gainer.Entity.UID;
            Item.GainerName = gainer.Entity.Name;
            Item.Date = DateTime.Now;
            Item.DaysLeft = 0;
            owner.DeatinedItem.Add(Item.UID, Item);
            owner.Send(Item);

            DetainedItem Item2 = new DetainedItem(true);
            Item2.ItemUID = item.UID;
            Item2.UID = Item2.ItemUID - 1;
            Item2.Item = item;
            Item2.Page = (byte)DetainedItem.ClaimPage;
            Item2.ConquerPointsCost = CalculateCost(item);
            Item2.OwnerUID = gainer.Entity.UID;
            Item2.GainerName = gainer.Entity.Name;
            Item2.GainerUID = owner.Entity.UID;
            Item2.OwnerName = owner.Entity.Name;
            Item2.Date = Item.Date;
            Item2.DaysLeft = 0;
            gainer.ClaimableItem.Add(Item2.UID, Item2);
            gainer.Send(Item2);
            MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT)
                .Insert("detaineditems")
                .Insert("ItemUID", item.UID)
                .Insert("ConquerPointsCost", Item.ConquerPointsCost)
                .Insert("Date", Item.Date.Ticks)
                .Insert("OwnerUID", owner.Entity.UID)
                .Insert("OwnerName", owner.Entity.Name)
                .Insert("GainerUID", gainer.Entity.UID)
                .Insert("GainerName", gainer.Entity.Name);
            //.Where("ItemUID", item.UID);
            cmd.Execute();
        }
Esempio n. 2
0
 public static void LoadClaimableItems(Client.GameState client)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.SELECT);
     cmd.Select("detaineditems").Where("GainerUID", client.Entity.UID);
     MySqlReader r = new MySqlReader(cmd);
     while (r.Read())
     {
         DetainedItem item = new DetainedItem(true);
         item.ItemUID = r.ReadUInt32("ItemUID");
         item.UID = item.ItemUID - 1;
         item.Page = (byte)DetainedItem.ClaimPage;
         item.Item = ConquerItemTable.LoadItem(item.ItemUID);
         item.ConquerPointsCost = r.ReadUInt32("ConquerPointsCost");
         item.OwnerUID = r.ReadUInt32("GainerUID");
         item.GainerName = r.ReadString("GainerName");
         item.GainerUID = r.ReadUInt32("OwnerUID");
         item.OwnerName = r.ReadString("OwnerName");
         item.Date = DateTime.FromBinary(r.ReadInt64("Date"));
         item.DaysLeft = (uint)(TimeSpan.FromTicks(DateTime.Now.Ticks).Days - TimeSpan.FromTicks(item.Date.Ticks).Days);
         if (item.GainerUID == 500)
         {
             item.MakeItReadyToClaim();
             item.GainerUID = r.ReadUInt32("GainerUID");
             item.OwnerUID = r.ReadUInt32("OwnerUID");
         }
         client.ClaimableItem.Add(item.UID, item);
     }
     r.Close();
 }
Esempio n. 3
0
 public static void Claim(DetainedItem item, Client.GameState owner)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.DELETE).Delete("detaineditems", "ItemUID", item.Item.UID).And("GainerUID", owner.Entity.UID);
     cmd.Execute();
 }
Esempio n. 4
0
 public static void Redeem(DetainedItem item, Client.GameState owner)
 {
     MySqlCommand cmd = new MySqlCommand(MySqlCommandType.UPDATE)
         .Update("detaineditems").Set("OwnerUID", 500).Where("ItemUID", item.Item.UID).And("OwnerUID", owner.Entity.UID);
     cmd.Execute();
 }