Conquer_V2 ini to MySql item Database Command

[taylor2846]

[EDIT]
`[EDIT]
i do not want to spam the from with stuff so i am posting a ? here.
in item the database item data what is
Weight,
Unknown1,
Unknown2,
Unknown3,

what is the purpose of them?

and are there any items that require spi... and vit...?


this is for Conquer_V2.
Here is my code to Convert the ini item database to MySql if anyone needs it note it will take some editing to your source to use this.

 Spoiler

                    case "/item":
                        {
                            for (uint nxtitm = 111002; nxtitm <= 2100095; nxtitm++)
                            {
                                if (File.Exists(ServerDatabase.Path + "\\Items\\" + nxtitm + ".ini"))
                                {
                                    Console.ForegroundColor = ConsoleColor.Green;
                                    Console.WriteLine("Loading_Item = " + nxtitm);
                                    StanderdItemStats item = new StanderdItemStats(nxtitm);
                                    MySqlCommand Cmd = new MySqlCommand("INSERT INTO items(ItemID, ItemName, ReqJob, ReqProfLvl, ReqLvl, ReqSex, ReqStr, ReqAgi, ReqVit, ReqSpi, Tradability, Weight, ShopBuyPrice, Action, MaxPhysAtk, MinPhysAtk, PhysDefence, Dexerity, Dodge, PotAddHP, PotAddMP, Durability, Arrows, Identity, Gem1, Gem2, Magic1, Magic2, Magic3, MAttack, MDefence, Range, Frequency, Unknown1, Unknown2, Unknown3, ShopCPPrice) VALUES(" + item.ItemID + ",'" + item.Name + "'," + item.ReqJob + "," + item.ReqProfLvl + "," + item.ReqLvl + "," + item.ReqSex + "," + item.ReqStr + "," + item.ReqAgi + "," + item.ReqVit + "," + item.ReqSpi + "," + item.Tradability + "," + item.Weight + "," + item.MoneyPrice + "," + item.Action + "," + item.MaxAttack + "," + item.MinAttack + "," + item.PhysicalDefence + "," + item.Dexerity + "," + item.Dodge + "," + item.HP + "," + item.MP + "," + item.Durability + "," + item.Arrows + "," + item.Identity + "," + item.Gem1 + "," + item.Gem2 + "," + item.Magic1 + "," + item.Magic2 + "," + item.Magic3 + "," + item.MAttack + "," + item.MDefence + "," + item.AttackRange + "," + item.Frequency + "," + item.Unknown1 + "," + item.Unknown2 + "," + item.Unknown3 + "," + item.ConquerPointsPrice + ")", DatabaseConnection.NewConnection());
                                    Cmd.ExecuteNonQuery();
                                    Cmd.Connection.Close();
                                    Cmd.Connection.Dispose();
                                    Cmd.Dispose();
                                    Console.Clear();
                                }
                                else
                                {
                                    Console.ForegroundColor = ConsoleColor.DarkGreen;
                                    Console.WriteLine("Discarding_Item = " + nxtitm);
                                }
                            }
                            break;
                        }

[andrewxxx]

changing font to make this readable

this is for Conquer_V2.
Here is my code to Convert the ini item database to MySql if anyone needs it note it will take some editing to your source to use this.

[Kiyono]

Unknown1 = fray_mode
Unknown2 = repair_mode
Unknown3 = type_mask

These are values from the itemtype.dat but are not used in the source nor do I know what they are used for, your best bet would be asking TQ (lol) or someone that knows a lot about the client but as far as I know; these values have never been used in any public source.