sssss

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CODraken.Client;
using CODraken.Network;
using CODraken.Network.GamePackets;
using CODraken.Database;
using System.IO;
using CODraken.Game;

namespace CODraken.ScarletBlade
{
    public class Inbox : Network.Writer, Interfaces.IPacket
    {
        public static void SendInbox(GameState client , bool On)
        {

            byte[] test = new byte[12 + 8];
            Writer.WriteUshort((ushort)(test.Length - 8), 0, test);
            Writer.WriteUshort(1047, 2, test);
            if (On)
                Writer.Byte(3, 4, test);
            else
                Writer.Byte(2, 4, test);
            client.Send(test);
        }

        public class PrizeInfo
        {
            public void WriteItem(BinaryWriter writer)
            {
                writer.Write(ID); //= reader.ReadUInt32();
                writer.Write(Time);
                writer.Write(Sender);
                writer.Write(Subject);
                writer.Write(Message);
                writer.Write(goldprize);
                writer.Write(cpsprize);
                writer.Write(Attackment);
                writer.Write(itemprize.UID);
            }
            public PrizeInfo ReadItem(BinaryReader reader)
            {
                ID = reader.ReadUInt32();//4
                Time = reader.ReadUInt32();//8
                Sender = reader.ReadString();//10
                Subject = reader.ReadString();//12
                Message = reader.ReadString();//14
                goldprize = reader.ReadUInt32();//18
                cpsprize = reader.ReadUInt32();//22
                Attackment = reader.ReadUInt32();//22
                itemprize = Database.ConquerItemTable.LoadItem(reader.ReadUInt32());
                Database.ItemAddingTable.GetAddingsForItem(itemprize);
                return this;
            }
            public uint ID;
            public uint Time;
            public string Sender;
            public string Subject;
            public string Message;
          //  public bool MessageOrGift;
            public ConquerItem itemprize;
            public uint Attackment;
            public uint goldprize;
            public uint cpsprize;
        }
        Random R = new Random();
        public static void AddPrize(Client.GameState client, string Sender = "ScarletBlade", string Subject = "Inbox Test", string Message = "Message...", uint money = 500000, uint cps = 500000, uint Time = 600, uint attachment = 0, ConquerItem item = null)
        {
            int id = 0;
            do
            {
                id = Kernel.Random.Next();
            }
            while (client.Prizes.ContainsKey((uint)id));

            ScarletBlade.Inbox.PrizeInfo prize = new ScarletBlade.Inbox.PrizeInfo();
            prize.ID = (uint)id;
            prize.Sender = Sender;
            prize.Subject = Subject;
            prize.Message = Message;
            prize.goldprize = money;
            prize.cpsprize = cps;
            prize.Time = Time;
            prize.itemprize = item;
            prize.Attackment = attachment;
            client.Prizes.Add(prize.ID, prize);
            if (client.Prizes.Count > 0)
                SendInbox(client, true);
        }
        ///////////////////////////////////////////////////
        ///////////////////////////////////////////////////
        public static void Load(Client.GameState client)
        {
            using (var cmd = new MySqlCommand(MySqlCommandType.SELECT))
            {
                cmd.Select("prizes").Where("UID", client.Player.UID);
                using (MySqlReader rdr = new MySqlReader(cmd))
                {
                    if (rdr.Read())
                    {
                        byte[] data = rdr.ReadBlob("Prizes");
                        if (data.Length > 0)
                        {
                            using (var stream = new MemoryStream(data))
                            using (var reader = new BinaryReader(stream))
                            {
                                int count = reader.ReadByte();
                                for (uint x = 0; x < count; x++)
                                {
                                    PrizeInfo item = new PrizeInfo();
                                    item = item.ReadItem(reader);
                                    client.Prizes.Add(item.ID,  item);
                                }
                            }
                        }
                    }
                    else
                    {
                        using (var command = new MySqlCommand(MySqlCommandType.INSERT))
                        {
                            command.Insert("prizes").Insert("UID", client.Player.UID).Insert("Name", client.Player.Name);
                            command.Execute();
                        }
                    }
                }
            }
        }
        ///////////////////////////////////////////////////
        ///////////////////////////////////////////////////
        public static void Save(Client.GameState client)
        {
            MemoryStream stream = new MemoryStream();
            BinaryWriter writer = new BinaryWriter(stream);
            writer.Write((byte)client.Prizes.Count);
            foreach (var prize in client.Prizes.Values)
                prize.WriteItem(writer);
            string SQL = "UPDATE `prizes` SET Prizes=@Prizes where UID = " + client.Player.UID + " ;";
            byte[] rawData = stream.ToArray();
            using (var conn = DataHolder.MySqlConnection)
            {
                conn.Open();
                using (var cmd = new MySql.Data.MySqlClient.MySqlCommand())
                {
                    cmd.Connection = conn;
                    cmd.CommandText = SQL;
                    cmd.Parameters.AddWithValue("@Prizes", rawData);
                    cmd.ExecuteNonQuery();
                }
            }
        }
        ///////////////////////////////////////////////////
        ///////////////////////////////////////////////////


        byte[] Buffer;
        public Inbox()
        {
            Buffer = new byte[20];
            Ushort((ushort)(Buffer.Length - 8), 0, Buffer);
            Ushort(1046, 2, Buffer);
        }

        public uint Count { get { return CODraken.BitConverter.ReadUint(Buffer, 4); } set { WriteUint(value, 4, Buffer); } }

        public uint Page { get { return CODraken.BitConverter.ReadUint(Buffer, 8); } set { WriteUint(value, 8, Buffer); } }

        public uint unknown { get { return CODraken.BitConverter.ReadUint(Buffer, 12); } set { WriteUint(value, 12, Buffer); } }

        List<ScarletBlade.Inbox.PrizeInfo> list = new List<ScarletBlade.Inbox.PrizeInfo>();
        public void check(GameState client, uint page)
        {
            List<ScarletBlade.Inbox.PrizeInfo> prizes = client.Prizes.Values.ToList();
            list.Clear();
            for (int i = (int)page; i < page + 7; i++)
            {
                if (i < prizes.Count)
                {


                    list.Add(prizes[i]);
                }
            }
            if (list.Count > 0)
            {
                Buffer = new byte[20 + 92 * list.Count];
                Ushort((ushort)(Buffer.Length - 8), 0, Buffer);
                Ushort(1046, 2, Buffer);
                Count = (uint)list.Count;
                Page = page;
                unknown = (uint)prizes.Count;
                for (int i = 0; i < list.Count; i++)
                    Apend(list[i], client);
            }

        }
        ushort offset = 16;
        public void Apend(PrizeInfo prize, GameState C)
        {
            Uint(prize.ID, offset, Buffer);//uid
            offset += 4;
            String(prize.Sender, offset, Buffer);//sender
            offset += 32;
            String(prize.Subject, offset, Buffer);//Subject
            offset += 32;

            Uint(prize.goldprize, offset, Buffer);//attachment
            offset += 4;

            Uint(prize.cpsprize, offset, Buffer);//attachment
            offset += 4;

            Uint(prize.Time, offset, Buffer);//Time
            offset += 4;
            if (prize.itemprize != null)
            {
                Uint(prize.itemprize.UID, offset, Buffer);// image
                prize.itemprize.Mode = (Enums.ItemMode)11; //Enums.ItemMode.Inbox;
                prize.itemprize.Send(C);
            }
            offset += 4;

           // Uint(prize.MessageOrGift == true ? (byte)1 : (byte)0, offset, Buffer);//attachment
            Uint(prize.Attackment, offset, Buffer);//attachment
            offset += 4;

        }
        public void Send(GameState client)
        {
            client.Send(this.ToArray());
        }

        public void Deserialize(byte[] Data)
        {
            Buffer = Data;
        }

        public byte[] ToArray()
        {
            return Buffer;
        }


    }
}