public static void UpdateUserImage(UserImageData userImageData)
{
string query = string.Format("UPDATE userimages SET b64str = '{1}', scale = {2} WHERE login = '******'", userImageData.login, userImageData.b64str, userImageData.scale);
Console.WriteLine(query);
try {
MySqlCommand cmd = new MySqlCommand(query, sqlConnection);
sqlConnection.Open();
cmd.ExecuteNonQuery();
sqlConnection.Close();
} catch (System.Exception ex) {
Console.WriteLine(ex);
}
}
public void Start()
{
Console.WriteLine("QuickPlay session started: " + roomName);
UserImageData _image = JsonConvert.DeserializeObject <UserImageData>(SqlConnection.GetUserImage(player_2.login));
QuickPlaySessionInfo _temp = new QuickPlaySessionInfo
{
roomName = roomName,
roomId = roomId,
firstPlayer = true,
opponentName = player_2.login,
opponentRating = player_2.rating,
myCharNames = new string[] { player_1.mainTeamNames[0], player_1.mainTeamNames[1], player_1.mainTeamNames[2] },
myCharIds = new string[] { player_1.mainTeam[0].id, player_1.mainTeam[1].id, player_1.mainTeam[2].id },
opponentCharNames = new string[] { player_2.mainTeamNames[0], player_2.mainTeamNames[1], player_2.mainTeamNames[2] },
opponentCharIds = new string[] { player_2.mainTeam[0].id, player_2.mainTeam[1].id, player_2.mainTeam[2].id },
enemyImage = _image.b64str,
enemyImageScale = _image.scale
};
ServerTCP.Send_QuickPlaySessionInfo(ServerTCP.OnlineClients[player_1.login], JsonConvert.SerializeObject(_temp));
_image = JsonConvert.DeserializeObject <UserImageData>(SqlConnection.GetUserImage(player_1.login));
_temp.firstPlayer = false;
_temp.opponentName = player_1.login;
_temp.opponentRating = player_1.rating;
_temp.opponentCharNames = new string[] { player_1.mainTeamNames[0], player_1.mainTeamNames[1], player_1.mainTeamNames[2] };
_temp.opponentCharIds = new string[] { player_1.mainTeam[0].id, player_1.mainTeam[1].id, player_1.mainTeam[2].id };
_temp.myCharNames = new string[] { player_2.mainTeamNames[0], player_2.mainTeamNames[1], player_2.mainTeamNames[2] };
_temp.myCharIds = new string[] { player_2.mainTeam[0].id, player_2.mainTeam[1].id, player_2.mainTeam[2].id };
_temp.enemyImage = _image.b64str;
_temp.enemyImageScale = _image.scale;
ServerTCP.Send_QuickPlaySessionInfo(ServerTCP.OnlineClients[player_2.login], JsonConvert.SerializeObject(_temp));
plyer_1_chars = new string[] { player_1.mainTeam[0].id, player_1.mainTeam[1].id, player_1.mainTeam[2].id };
plyer_2_chars = new string[] { player_2.mainTeam[0].id, player_2.mainTeam[1].id, player_2.mainTeam[2].id };
foreach (KeyValuePair <string, UserChar> playerChar in PlayerChars)
{
playerChar.Value.SetBaseValues();
playerChar.Value.turnmeter = playerChar.Value.speed / 10;
}
CalculateTurns();
}
private static void Handle_ImageUpdate(int index, byte[] data)
{
PacketBuffer buffer = new PacketBuffer();
buffer.WriteBytes(data);
int packetNum = buffer.ReadInteger();
string msg = buffer.ReadString();
buffer.Dispose();
//Json parse
UserImageData imageData = JsonConvert.DeserializeObject <UserImageData>(msg);
SqlConnection.UpdateUserImage(imageData);
//add your code you want to execute here;
}
// json
public static string GetUserImage(string login)
{
string query = string.Format("SELECT * FROM userimages WHERE login = '******'", login);
Console.WriteLine(query);
try {
MySqlCommand cmd = new MySqlCommand(query, sqlConnection);
sqlConnection.Open();
MySqlDataReader reader = cmd.ExecuteReader();
UserImageData userImageData = new UserImageData();
while (reader.Read())
{
userImageData.b64str = (string)reader["b64str"];
userImageData.login = (string)reader["login"];
userImageData.scale = (int)reader["scale"];
break;
}
sqlConnection.Close();
return(JsonConvert.SerializeObject(userImageData));
} catch (System.Exception ex) {
Console.WriteLine(ex);
return(null);
}
}
