protected void SavePlayerPosition()
{
//Wrap our function inside a catcher
try
{
//Update database
if (!File.FileLoad.CheckCave(Character.Position.xSec, Character.Position.ySec))
{
MsSQL.UpdateData("update character set xsect='" + Character.Position.xSec +
"', ysect='" + Character.Position.ySec +
"', xpos='" + Math.Round(Formule.packetx(Character.Position.x, Character.Position.xSec)) +
"', ypos='" + Math.Round(Formule.packety(Character.Position.y, Character.Position.ySec)) +
"', zpos='" + Math.Round(Character.Position.z) +
"' where id='" + Character.Information.CharacterID + "'");
}
else
{
MsSQL.UpdateData("update character set xsect='" + Character.Position.xSec +
"', ysect='" + Character.Position.ySec +
"', xpos='" + Math.Round(Formule.cavepacketx(Character.Position.x)) +
"', ypos='" + Math.Round(Formule.cavepackety(Character.Position.y)) +
"', zpos='" + Math.Round(Character.Position.z) +
"' where id='" + Character.Information.CharacterID + "'");
}
}
catch (Exception ex)
{
Console.WriteLine("Save position error {0}", ex);
Systems.Debugger.Write(ex);
}
}