Code:
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;
}