[Release] CoEmuv2 .. Stuff

First Plz release all you can for coemu such as any items npcs skills what ever if it is not alredy released release it plz it will save us all lots of time.. and becaz no one seem no no how to dye armor black and stuff from a npc im Releaseign how and plz if someone can release to me the npc for socing items dont remember his name and Magic Artisan and the guy for upgrading item level and quality with mets a db's.. plz^^.. any way.

edit your database.cs update item code to this

Code:

		public static void UpdateItem(Struct.ItemInfo Item)
		{
            MySqlCommand Cmd = new MySqlCommand("UPDATE `items` SET `ItemID` = " + Item.ItemID + ", `Position` = " + Item.Position + ", `Minus` = " + Item.Bless + ", `Plus` = " + Item.Plus + ", `Progress` = " + Item.Progress + ", `Enchant` = " + Item.Enchant + ", `Soc1` = " + Item.Soc1 + ", `Soc2` = " + Item.Soc2 + ", `Dura` = " + Item.Dura + ", `MaxDura` = " + Item.MaxDura + ", `Color` = " + Item.Color + " WHERE `ItemUID` = \"" + Item.UID + "\"", DatabaseConnection.NewConnection());
			Cmd.ExecuteNonQuery();
			Cmd.Connection.Close();
			Cmd.Connection.Dispose();
			Cmd.Dispose();
		}

and now black tolip

Code:

                case 723584://BlackTulip
                    {
                        if (CSocket.Client.Equipment.ContainsKey(3))
                        {
                            Struct.ItemInfo itm = CSocket.Client.Equipment[3];
                            itm.Color = 2;
                            CSocket.Send(ConquerPacket.ItemInfo(itm.UID, itm.ItemID, itm.Plus, itm.Progress, itm.Bless, itm.Enchant, itm.Soc1, itm.Soc2, itm.Dura, itm.MaxDura, itm.Position, itm.Color));
                            CSocket.Send(ConquerPacket.Chat(0, "SYSTEM", CSocket.Client.Name, "Your Armor is now black!", Struct.ChatType.Top));
                            Database.Database.UpdateItem(itm);
                        }
                        else
                        {
                            Delete = false;
                            CSocket.Send(ConquerPacket.Chat(0, "SYSTEM", CSocket.Client.Name, "You Have no armor on dont wast the item", Struct.ChatType.Top));
                        }
                        break;
                    }

ok and now so you can see item color on the groud in DropItem.cs edit
the code below

Code:

					CSocket.Send(ConquerPacket.ItemUsage(UID, 255, Struct.ItemUsage.RemoveItem));

Code:

					ConquerPacket.ToLocal(ConquerPacket.DropItem(IG.UID, IG.ItemID, IG.X, IG.Y, IG.Color), IG.X, IG.Y, IG.Map, 0, 0);

ok now in Item.cs edit CopyItem to this

Code:

			public void CopyItem(ItemInfo Item)
			{
				Bless = Item.Bless;
				Dura = Item.Dura;
				Enchant = Item.Enchant;
				ItemID = Item.ItemID;
				MaxDura = Item.MaxDura;
				Plus = Item.Plus;
				Position = Item.Position;
				Soc1 = Item.Soc1;
				Soc2 = Item.Soc2;
                Color = Item.Color;
				UID = Item.UID;
			}

and edit Public class ItemInfo to this

Code:

		public class ItemInfo
		{
			public int UID;
			public int ItemID;
			public int Plus;
            public int Progress;
			public int Bless;
			public int Enchant;
			public int Soc1;
			public int Soc2;
			public int Dura;
			public int MaxDura;
			public int Position;
			public int Color = 4;
		}

------------
to upgrade item quality do something like this.

Code:

                                    if (Calculation.CanUpgrade(Convert.ToString(Item.ItemID)))
                                    {

                                        CSocket.Send(ConquerPacket.ItemUsage(Item.UID, 255, Struct.ItemUsage.RemoveItem));
                                        if (Calculation.Quality(Convert.ToString(Item.ItemID)) == 3 || Calculation.Quality(Convert.ToString(Item.ItemID)) == 4)
                                            Item.ItemID += 6 - Calculation.Quality(Convert.ToString(Item.ItemID));
                                        else
                                        {
                                            Item.ItemID += 1;
                                        }
                                        Database.Database.UpdateItem(Item);
                                        CSocket.Send(ConquerPacket.ItemInfo(Item.UID, Item.ItemID, Item.Plus, Item.Progress, Item.Bless, Item.Enchant, Item.Soc1, Item.Soc2, Item.Dura, Item.MaxDura, Item.Position, Item.Color));

and to upgrade item level do something like this

Code:

                                    if (Calculation.CanUpgrade(Convert.ToString(Item.ItemID)))
                                    {
                                        Struct.ItemData item = Nano.Items[Item.ItemID];
                                        if (item.Level < 130)
                                        {
                                            if (CSocket.Client.Level <= Calculation.NextEquipLevel(Item.ItemID))
                                            {
                                                CSocket.Send(ConquerPacket.ItemUsage(Item.UID, 255, Struct.ItemUsage.RemoveItem));
                                                Item.ItemID = Calculation.NextEquipLevel(Item.ItemID);
                                                Database.Database.UpdateItem(Item);
                                                CSocket.Send(ConquerPacket.ItemInfo(Item.UID, Item.ItemID, Item.Plus, Item.Progress, Item.Bless, Item.Enchant, Item.Soc1, Item.Soc2, Item.Dura, Item.MaxDura, Item.Position, Item.Color));

ok i thank thats all i did .. plz note i have waxing oven so if you dont have it you will get some earrors