Hey i need help My Source wont make Chars here the CreateChar thing can someone tell me the problem?
public static bool CreateCharacter(string Name, byte Class, uint Model, uint Avatar, Client UClient)
{
try
{
string str = "0";
string agi = "0";
string vit = "0";
string spi = "0";
if (Class == 10)
{
str = (Stats.ReadValue("Trojan", "Strength[1]"));
agi = (Stats.ReadValue("Trojan", "Agility[1]"));
vit = (Stats.ReadValue("Trojan", "Vitality[1]"));
spi = (Stats.ReadValue("Trojan", "Spirit[1]"));
}
if (Class == 20)
{
str = (Stats.ReadValue("Warrior", "Strength[1]"));
agi = (Stats.ReadValue("Warrior", "Agility[1]"));
vit = (Stats.ReadValue("Warrior", "Vitality[1]"));
spi = (Stats.ReadValue("Warrior", "Spirit[1]"));
}
if (Class == 40)
{
str = (Stats.ReadValue("Archer", "Strength[1]"));
agi = (Stats.ReadValue("Archer", "Agility[1]"));
vit = (Stats.ReadValue("Archer", "Vitality[1]"));
spi = (Stats.ReadValue("Archer", "Spirit[1]"));
}
if (Class == 100)
{
str = (Stats.ReadValue("Taoist", "Strength[1]"));
agi = (Stats.ReadValue("Taoist", "Agility[1]"));
vit = (Stats.ReadValue("Taoist", "Vitality[1]"));
spi = (Stats.ReadValue("Taoist", "Spirit[1]"));
}
string hp = Convert.ToString((short.Parse(vit) * 24 + short.Parse(str) * 3 + short.Parse(agi) * 3 + short.Parse(spi) * 3));
ulong uid = (uint)General.Rand.Next(1000001, 19999999);
MySqlCommand Com = new MySqlCommand("SELECT * FROM `characters`;", Connection);
MySqlDataAdapter Adapter = new MySqlDataAdapter(Com);
DataSet DS = new DataSet("Count");
Adapter.Fill(DS, "Count");
uint UID = (uint)DS.Tables["Count"].Rows.Count + 1000001;
if (Name != null)
{
MySqlCommand Command = new MySqlCommand("INSERT INTO characters (CharName,Account,Level,Exp,Strength,Agility,Vital ity,Spirit,Job,Model,Money,CPs,CurrentHP,StatPoint s,UID,Hair,Equipment,Inventory,Skills,Profs,Avatar ,Warehouses,Friends,Enemies,MyGuild,GuildPos,Quest Mob) VALUES ('" + Name +
"','" + UClient.Account +
"',1,0," + str +
"," + agi +
"," + vit +
"," + spi +
"," + Class +
"," + Model +
",50000,0," + hp +
",0," + UID +
",410,'','','',''," + Avatar +
",'','','',0,0,'')", Connection);
Command.ExecuteNonQuery();
return true;
}
else
return false;
}
catch (Exception Exc) { General.WriteLine(Convert.ToString(Exc)); return false; }
}
 |
