//Method to delete character from player's account
public static void DeleteCharacter(int serverid, Session MySession)
{
//Opens new Sql connection using connection parameters
var connectionString = ConfigurationManager.ConnectionStrings["DevLocal"].ConnectionString;
//Set connection property from connection string and open connection
using MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
//Creates var to store a MySQlcommand with the query and connection parameters.
using var cmd = new MySqlCommand("DeleteCharacter", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("cServerID", serverid);
//Executes a reader on the previous var.
using MySqlDataReader rdr = cmd.ExecuteReader();
//Log which character serverid was deleted
Logger.Info($"Deleted Character with ServerID: {serverid}");
//Create a new list of characters after deletion
List <Character> MyCharacterList = new List <Character>();
MyCharacterList = SQLOperations.AccountCharacters(MySession);
//Send Fresh Character Listing
ProcessOpcode.CreateCharacterList(MyCharacterList, MySession);
}
//Method to create new character for player's account
public static void CreateCharacter(Session MySession, Character charCreation)
{
//Instantiate new list of Characters to return new character listing
//Local variables to get string values to store in the DB from dictionary keys received from client
string humType = charCreation.HumTypeDict[charCreation.HumTypeNum];
string classType = charCreation.CharClassDict[charCreation.StartingClass];
string raceType = charCreation.CharRaceDict[charCreation.Race];
string sexType = charCreation.CharSexDict[charCreation.Gender];
//Calculate total TP used among all stats for DB storage
int UsedTP = charCreation.AddStrength + charCreation.AddStamina + charCreation.AddAgility + charCreation.AddDexterity + charCreation.AddWisdom + charCreation.AddIntelligence
+ charCreation.AddCharisma;
//Create and Open new Sql connection using connection parameters
var connectionString = ConfigurationManager.ConnectionStrings["DevLocal"].ConnectionString;
//Set connection property from connection string and open connection
using MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
//Assign query string and connection to commands
using var cmd = new MySqlCommand("GetCharModel", con);
cmd.CommandType = CommandType.StoredProcedure;
//Add parameter values for parameterized string.
cmd.Parameters.AddWithValue("@RaceType", raceType);
cmd.Parameters.AddWithValue("@ClassType", classType);
cmd.Parameters.AddWithValue("@HumType", humType);
cmd.Parameters.AddWithValue("@SexType", sexType);
//Execute reader on SQL command
using MySqlDataReader rdr = cmd.ExecuteReader();
//Iterate through default character values for class and race and assign to new character
while (rdr.Read())
{
charCreation.Tunar = rdr.GetInt32(5);
charCreation.UnusedTP = rdr.GetInt32(7);
charCreation.TotalAssignableTP = rdr.GetInt32(8);
charCreation.XCoord = rdr.GetFloat(9);
charCreation.YCoord = rdr.GetFloat(10);
charCreation.ZCoord = rdr.GetFloat(11);
charCreation.Facing = rdr.GetFloat(12);
charCreation.DefaultStrength = rdr.GetInt32(14);
charCreation.DefaultStamina = rdr.GetInt32(15);
charCreation.DefaultAgility = rdr.GetInt32(16);
charCreation.DefaultDexterity = rdr.GetInt32(17);
charCreation.DefaultWisdom = rdr.GetInt32(18);
charCreation.DefaultIntelligence = rdr.GetInt32(19);
charCreation.DefaultCharisma = rdr.GetInt32(20);
charCreation.ModelID = rdr.GetInt32(21);
}
rdr.Close();
con.Close();
//Calculate Unused TP still available to character upon entering world.
charCreation.UnusedTP = charCreation.UnusedTP - UsedTP;
//Add total strength from default plus added TP to each category. Not sure this is correct, may need to still add the TP from client
charCreation.Strength = charCreation.DefaultStrength + charCreation.AddStrength;
charCreation.Stamina = charCreation.DefaultStamina + charCreation.AddStamina;
charCreation.Agility = charCreation.DefaultAgility + charCreation.AddAgility;
charCreation.Dexterity = charCreation.DefaultDexterity + charCreation.AddDexterity;
charCreation.Wisdom = charCreation.DefaultWisdom + charCreation.AddWisdom;
charCreation.Intelligence = charCreation.DefaultIntelligence + charCreation.AddIntelligence;
charCreation.Charisma = charCreation.DefaultCharisma + charCreation.AddCharisma;
//Open second connection using query string params
//Set connection property from connection string and open connection
using MySqlConnection SecondCon = new MySqlConnection(connectionString);
SecondCon.Open();
//Create second command using second connection and char insert query string
using var SecondCmd = new MySqlCommand("CreateCharacter", SecondCon);
SecondCmd.CommandType = CommandType.StoredProcedure;
//Add all character attributes for new character creation to parameterized values
SecondCmd.Parameters.AddWithValue("@charName", charCreation.CharName);
//Needs to be MySession.AccountID once CharacterSelect shows characters off true AccountID.
SecondCmd.Parameters.AddWithValue("AccountID", MySession.AccountID);
SecondCmd.Parameters.AddWithValue("ModelID", charCreation.ModelID);
SecondCmd.Parameters.AddWithValue("TClass", charCreation.StartingClass);
SecondCmd.Parameters.AddWithValue("Race", charCreation.Race);
SecondCmd.Parameters.AddWithValue("HumType", humType);
SecondCmd.Parameters.AddWithValue("Level", charCreation.Level);
SecondCmd.Parameters.AddWithValue("HairColor", charCreation.HairColor);
SecondCmd.Parameters.AddWithValue("HairLength", charCreation.HairLength);
SecondCmd.Parameters.AddWithValue("HairStyle", charCreation.HairStyle);
SecondCmd.Parameters.AddWithValue("FaceOption", charCreation.FaceOption);
SecondCmd.Parameters.AddWithValue("classIcon", charCreation.StartingClass);
//May need other default values but these hard set values are placeholders for now
SecondCmd.Parameters.AddWithValue("TotalXP", 0);
SecondCmd.Parameters.AddWithValue("Debt", 0);
SecondCmd.Parameters.AddWithValue("Breath", 255);
SecondCmd.Parameters.AddWithValue("Tunar", charCreation.Tunar);
SecondCmd.Parameters.AddWithValue("BankTunar", charCreation.BankTunar);
SecondCmd.Parameters.AddWithValue("UnusedTP", charCreation.UnusedTP);
SecondCmd.Parameters.AddWithValue("TotalTP", 350);
SecondCmd.Parameters.AddWithValue("X", charCreation.XCoord);
SecondCmd.Parameters.AddWithValue("Y", charCreation.YCoord);
SecondCmd.Parameters.AddWithValue("Z", charCreation.ZCoord);
SecondCmd.Parameters.AddWithValue("Facing", charCreation.Facing);
SecondCmd.Parameters.AddWithValue("Strength", charCreation.Strength);
SecondCmd.Parameters.AddWithValue("Stamina", charCreation.Stamina);
SecondCmd.Parameters.AddWithValue("Agility", charCreation.Agility);
SecondCmd.Parameters.AddWithValue("Dexterity", charCreation.Dexterity);
SecondCmd.Parameters.AddWithValue("Wisdom", charCreation.Wisdom);
SecondCmd.Parameters.AddWithValue("Intelligence", charCreation.Intelligence);
SecondCmd.Parameters.AddWithValue("Charisma", charCreation.Charisma);
//May need other default or calculated values but these hard set values are placeholders for now
SecondCmd.Parameters.AddWithValue("CurrentHP", 1000);
SecondCmd.Parameters.AddWithValue("MaxHP", 1000);
SecondCmd.Parameters.AddWithValue("CurrentPower", 500);
SecondCmd.Parameters.AddWithValue("MaxPower", 500);
SecondCmd.Parameters.AddWithValue("Healot", 20);
SecondCmd.Parameters.AddWithValue("Powerot", 10);
SecondCmd.Parameters.AddWithValue("Ac", 0);
SecondCmd.Parameters.AddWithValue("PoisonR", 10);
SecondCmd.Parameters.AddWithValue("DiseaseR", 10);
SecondCmd.Parameters.AddWithValue("FireR", 10);
SecondCmd.Parameters.AddWithValue("ColdR", 10);
SecondCmd.Parameters.AddWithValue("LightningR", 10);
SecondCmd.Parameters.AddWithValue("ArcaneR", 10);
SecondCmd.Parameters.AddWithValue("Fishing", 0);
SecondCmd.Parameters.AddWithValue("Base_Strength", charCreation.DefaultStrength);
SecondCmd.Parameters.AddWithValue("Base_Stamina", charCreation.DefaultStamina);
SecondCmd.Parameters.AddWithValue("Base_Agility", charCreation.DefaultAgility);
SecondCmd.Parameters.AddWithValue("Base_Dexterity", charCreation.DefaultDexterity);
SecondCmd.Parameters.AddWithValue("Base_Wisdom", charCreation.DefaultWisdom);
SecondCmd.Parameters.AddWithValue("Base_Intelligence", charCreation.DefaultIntelligence);
SecondCmd.Parameters.AddWithValue("Base_Charisma", charCreation.DefaultCharisma);
//See above comments regarding hard set values
SecondCmd.Parameters.AddWithValue("CurrentHP2", 1000);
SecondCmd.Parameters.AddWithValue("BaseHP", 1000);
SecondCmd.Parameters.AddWithValue("CurrentPower2", 500);
SecondCmd.Parameters.AddWithValue("BasePower", 500);
SecondCmd.Parameters.AddWithValue("Healot2", 20);
SecondCmd.Parameters.AddWithValue("Powerot2", 10);
//Execute parameterized statement entering it into the DB
//using MySqlDataReader SecondRdr = SecondCmd.ExecuteReader();
SecondCmd.ExecuteNonQuery();
SecondCon.Close();
///Close DB connection
SecondCon.Close();
//Log which character serverid was created
Console.WriteLine($"Created Character with Name: {charCreation.CharName}");
List <Character> MyCharacterList = new List <Character>();
MyCharacterList = SQLOperations.AccountCharacters(MySession);
//Send Fresh Character Listing
ProcessOpcode.CreateCharacterList(MyCharacterList, MySession);
}
