public SerialPosition LoadPositionOfPlayer(string playerName)
{
string playerId = QueryReady(GetPlayerId(playerName));
SerialPosition sPos = null;
using (IDbConnection dbconn = new SqliteConnection(connectionString))
{
dbconn.Open();
using (IDbCommand dbcmd = dbconn.CreateCommand())
{
string sqlQuery = "SELECT PositionX, PositionY, RotationZ FROM CharacterPositions WHERE IdC=" + playerId;
dbcmd.CommandText = sqlQuery;
using (IDataReader reader = dbcmd.ExecuteReader())
{
while (reader.Read())
{
float x = reader.GetFloat(0);
float y = reader.GetFloat(1);
float z = reader.GetFloat(2);
sPos = new SerialPosition(x, y, z);
}
}
}
}
return(sPos);
}
public void CallRpcLoadPositionFromDatabase(SerialPosition spos, string playerName)
{
if (isServer)
{
RpcLoadPositionFromDatabase(spos.posX, spos.posY, spos.rotZ, playerName);
}
}
public void CallCmdSerializePlayerPosition()
{
if (isLocalPlayer)
{
SerialPosition spos = GlobalSerialization.SerializePosition(gameObject);
CmdSerializePlayerPosition(spos.posX, spos.posY, spos.rotZ, GetComponent <PlayerRpg>().playerName);
}
}
public static void DeserializePosition(SerialPosition sPos, GameObject player)
{
player.transform.position = new Vector3(sPos.posX, sPos.posY, player.transform.position.z);
player.transform.rotation = new Quaternion(player.transform.rotation.x, player.transform.rotation.y, sPos.rotZ, player.transform.rotation.w);
}
