[problem]stats

[coreymills]

stats wont load for me

i made a new file called 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;
        }
    }
}

database.cs

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>();

in public static void StartServer()
i added

Database.Database.GetStats();

in DataLoader.cs i added

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

and the stats still will not load can anyone help me.

[CptSky]

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(); 
        }

Why you have the HairStyle, xCord, yCord... You use a Client for getting all the stats? Check your function...

[coreymills]

no i copyed savechar and just edited that for the get stats and guess i never got them all

EDIT:: still not workin

[CptSky]

Originally Posted by coreymills

no i copyed savechar and just edited that for the get stats and guess i never got them all

You don't understand the MySQL Function, I think... You can't get all the stats with a structure for update...

I have rapidly checked the CoEmu source, check for a load function like GetServerSkills(). The structure will work if you know how to adapt.

[coreymills]

#request close

[tanelipe]

#Closed