Release:UltimateCo

UPDATED just a code wrong sorry.. go to database.cs search for

Quote:

public static void GetCharInfo(Character Charr, string UserName)

and replace for this,

Quote:

public static void GetCharInfo(Character Charr, string UserName)
{
MySqlDataAdapter DataAdapter = null;
DataSet DSet = new DataSet();
try
{
DataAdapter = new MySqlDataAdapter("SELECT * FROM `Characters` WHERE `Account` = '" + UserName + "'", ExternalDatabase.Connection);
DataAdapter.Fill(DSet, "Character");
if (DSet != null && DSet.Tables["Character"].Rows.Count > 0)
{
DataRow DR = DSet.Tables["Character"].Rows[0];

Charr.UID = (uint)DR["UID"];
Charr.Name = (string)DR["CharName"];
Charr.Job = Convert.ToByte((uint)DR["Job"]);
Charr.Level = Convert.ToByte((uint)DR["Level"]);
Charr.Exp = (uint)DR["Exp"];
Charr.Model = Convert.ToUInt16((uint)DR["Model"]);
Charr.Avatar = Convert.ToUInt16((uint)DR["Avatar"]);
Charr.Hair = Convert.ToUInt16((uint)DR["Hair"]);
Charr.LocX = Convert.ToUInt16((uint)DR["LocationX"]);
Charr.LocY = Convert.ToUInt16((uint)DR["LocationY"]);
Charr.LocMap = Convert.ToUInt16((uint)DR["LocationMap"]);
Charr.Str = Convert.ToUInt16((uint)DR["Strength"]);
Charr.Agi = Convert.ToUInt16((uint)DR["Agility"]);
Charr.Vit = Convert.ToUInt16((uint)DR["Vitality"]);
Charr.Spi = Convert.ToUInt16((uint)DR["Spirit"]);
Charr.Silvers = (uint)DR["Money"];
Charr.CPs = (uint)DR["CPs"];
Charr.CurHP = Convert.ToUInt16((uint)DR["CurrentHP"]);
Charr.PKPoints = Convert.ToUInt16((uint)DR["PKPoints"]);
Charr.RBCount = Convert.ToByte((uint)DR["RBCount"]);
Charr.PackedInventory = (string)DR["Inventory"];
Charr.PackedEquips = (string)DR["Equipment"];
Charr.PackedSkills = (string)DR["Skills"];
Charr.PackedProfs = (string)DR["Profs"];
Charr.WHSilvers = (uint)DR["WHMoney"];
Charr.QuestKO = (uint)DR["QuestKO"];
Charr.KO = Convert.ToUInt16((uint)DR["KO"]);
Charr.OldKO = Convert.ToUInt16((uint)DR["OldKO"]);
Charr.PackedWHs = (string)DR["Warehouses"];
Charr.PackedFriends = (string)DR["Friends"];
Charr.PackedEnemies = (string)DR["Enemies"];
Charr.QuestMob = (string)DR["QuestMob"];
Charr.VP = (uint)DR["VP"];
Charr.GuildDonation = (uint)DR["GuildDonation"];
Charr.StatP = Convert.ToUInt16((uint)DR["StatPoints"]);
Charr.GuildID = Convert.ToUInt16((uint)DR["MyGuild"]);
Charr.GuildPosition = Convert.ToByte((uint)DR["GuildPos"]);
Charr.PrevMap = Convert.ToUInt16((uint)DR["PrevMap"]);
if (Guilds.AllGuilds.Contains(Charr.GuildID))
Charr.MyGuild = (Guild)Guilds.AllGuilds[Charr.GuildID];
Charr.MinAtk = Charr.Str;
Charr.MaxAtk = Charr.Str;
Charr.Potency = Charr.Level;
Charr.RealModel = Charr.Model;
Charr.RealAvatar = Charr.Avatar;
Charr.MaxHP = Charr.BaseMaxHP();
Charr.RealAgi = Charr.Agi;
Charr.dexptime = (uint)DR["dexptime"];
Charr.dexp = Convert.ToByte(DR["dexp"]);
}
else
General.WriteLine("Char not found.");
}
catch (Exception Exc) { General.WriteLine(Convert.ToString(Exc)); }
}