[problem]stats

/*
 * Created by SharpDevelop.
 * User: sams
 * Date: 3/18/2009
 * Time: 7:31 PM
 * 
 * To change this template use Tools | Options | Coding | Edit Standard Headers.
 */
using System;

namespace CoEmu_v2_GameServer.Structs
{
    /// <summary>
    /// Contains a struct for stats
    /// </summary>
    public partial class Struct
    {
        public class stats
        {
            public int Profession;
            public int Level;
            public int Strength;
            public int Vitality;
            public int Dexterity;
            public int Spirit;
        }
    }
}

public static void GetStats(Character Client)
        {
            MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `stats` WHERE `Profession` = " + (int)Client.Class + ", `level` = " + Client.Level + ", `strength` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class +", `Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose(); 
        }

public static Dictionary<int, Struct.stats> Stats = new Dictionary<int, Struct.stats>();

Database.Database.GetStats();

public static void LoadStats()
        {
            Database.Database.GetStats();
        }

public static void GetStats(Character Client)
        {
            MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `stats` WHERE `Profession` = " + (int)Client.Class + ", `level` = " + Client.Level + ", `strength` = " + Client.PkPoints + ", `xCord` = " + Client.X + ", `yCord` = " + Client.Y + ", `Map` = " + (int)Client.Map + ", `HairStyle` = " + Client.Hair + ", `Class` = " + (int)Client.Class +", `Str` = " + Client.Strength + ",`Vit` = " + Client.Vitality + ", `Spi` = " + Client.Spirit + ", `Dex` = " + Client.Dexterity + " WHERE `CharID` = " + Client.ID, DatabaseConnection.NewConnection());
            Cmd.ExecuteNonQuery();
            Cmd.Connection.Close();
            Cmd.Connection.Dispose();
            Cmd.Dispose(); 
        }