using System;
using SnowLight.Specialized;
using SnowLight.Game.Sessions;
using SnowLight.Game.Rooms;
using SnowLight.Storage;

namespace SnowLight.Communication.Outgoing
{
    public static class BattleBaldosaEventComposer
    {
        public static string color;
        public static ServerMessage Compose(uint ItemID, uint ID)
        {
            using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
            {
                color = MySqlClient.ReadString("SELECT bb_Color FROM `characters` WHERE id='" + ID.ToString() + "'");
                ServerMessage Message = new ServerMessage(OpcodesOut.ROOM_FLOOR_ITEM_UPDATE_FLAGS);
                string ti = MySqlClient.ReadString("SELECT tile FROM `items` WHERE id='" + ItemID + "'");
                if (ti != "11")
                {
                    if (ti != "8")
                    {
                        if (ti != "5")
                        {
                            if (ti != "14")
                            {
                                if (color == "b")
                                {
                                    if (ti == "0")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("9");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 9 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "9")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("10");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 10 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "10")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("11");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 11 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("9");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 9 WHERE id LIKE '" + ItemID + "'");
                                    }

                                    return Message;
                                }
                                else  if (color == "g")
                                {
                                    if (ti == "0")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("6");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 6 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "6")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("7");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 7 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "7")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("8");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 8 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("6");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 6 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    return Message;
                                }
                                else  if (color == "r")
                                {
                                    if (ti == "0")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("3");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 3 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "3")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("4");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 4 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "4")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("5");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 5 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("3");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 3 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    return Message;
                                }
                                else  if (color == "y")
                                {
                                    if (ti == "0")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("12");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 12 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "12")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("13");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 13 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else if (ti == "13")
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("14");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 14 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    else
                                    {
                                        Message.AppendStringWithBreak(ItemID.ToString());
                                        Message.AppendStringWithBreak("12");
                                        MySqlClient.ExecuteNonQuery("UPDATE items SET tile = 12 WHERE id LIKE '" + ItemID + "'");
                                    }
                                    return Message;
                                }
                                else
                                {
                                    Message.AppendStringWithBreak(ID.ToString());
                                    Message.AppendStringWithBreak("0");
                                    return Message;
                                }
                            }
                            else
                            {
                                if (ti == "11")
                                {
                                    Message.AppendStringWithBreak(ItemID.ToString());
                                    Message.AppendStringWithBreak("11");
                                }
                                else if (ti == "8")
                                {
                                    Message.AppendStringWithBreak(ItemID.ToString());
                                    Message.AppendStringWithBreak("8");
                                }
                                else if (ti == "5")
                                {
                                    Message.AppendStringWithBreak(ItemID.ToString());
                                    Message.AppendStringWithBreak("5");
                                }
                                else  if (ti == "14")
                                {
                                    Message.AppendStringWithBreak(ItemID.ToString());
                                    Message.AppendStringWithBreak("14");
                                }
                                return Message;
                            }
                        }
                        else
                        {
                            if (ti == "11")
                            {
                                Message.AppendStringWithBreak(ItemID.ToString());
                                Message.AppendStringWithBreak("11");
                            }
                            else if (ti == "8")
                            {
                                Message.AppendStringWithBreak(ItemID.ToString());
                                Message.AppendStringWithBreak("8");
                            }
                            else if (ti == "5")
                            {
                                Message.AppendStringWithBreak(ItemID.ToString());
                                Message.AppendStringWithBreak("5");
                            }
                            else  if (ti == "14")
                            {
                                Message.AppendStringWithBreak(ItemID.ToString());
                                Message.AppendStringWithBreak("14");
                            }
                            return Message;
                        }
                    }
                    else
                    {
                        if (ti == "11")
                        {
                            Message.AppendStringWithBreak(ItemID.ToString());
                            Message.AppendStringWithBreak("11");
                        }
                        else  if (ti == "8")
                        {
                            Message.AppendStringWithBreak(ItemID.ToString());
                            Message.AppendStringWithBreak("8");
                        }
                        else if (ti == "5")
                        {
                            Message.AppendStringWithBreak(ItemID.ToString());
                            Message.AppendStringWithBreak("5");
                        }
                        else if (ti == "14")
                        {
                            Message.AppendStringWithBreak(ItemID.ToString());
                            Message.AppendStringWithBreak("14");
                        }
                        return Message;
                    }
                }
                else
                {
                    if (ti == "11")
                    {
                        Message.AppendStringWithBreak(ItemID.ToString());
                        Message.AppendStringWithBreak("11");
                    }
                    else if (ti == "8")
                    {
                        Message.AppendStringWithBreak(ItemID.ToString());
                        Message.AppendStringWithBreak("8");
                    }
                    else if (ti == "5")
                    {
                        Message.AppendStringWithBreak(ItemID.ToString());
                        Message.AppendStringWithBreak("5");
                    }
                    else  if (ti == "14")
                    {
                        Message.AppendStringWithBreak(ItemID.ToString());
                        Message.AppendStringWithBreak("14");
                    }
                    return Message;
                }


            }
        }
    }
}