protected void SavePlayerPosition() { //Wrap our function inside a catcher try { //Update database if (!FileDB.CheckCave(Character.Position.xSec, Character.Position.ySec)) { DB.query("update character set xsect='" + Character.Position.xSec + "', ysect='" + Character.Position.ySec + "', xpos='" + Formule.packetx(Character.Position.x, Character.Position.xSec) + "', ypos='" + Formule.packety(Character.Position.y, Character.Position.ySec) + "', zpos='" + Math.Round(Character.Position.z) + "' where id='" + Character.Information.CharacterID + "'"); } else { DB.query("update character set xsect='" + Character.Position.xSec + "', ysect='" + Character.Position.ySec + "', xpos='" + Formule.cavepacketx(Character.Position.x) + "', ypos='" + Formule.cavepackety(Character.Position.y) + "', zpos='" + Math.Round(Character.Position.z) + "' where id='" + Character.Information.CharacterID + "'"); } } catch (Exception ex) { Log.Exception(ex); } }
///////////////////////////////////////////////////////////////////////////////// // Cave movement teleport ///////////////////////////////////////////////////////////////////////////////// public void Movement_CaveTeleport()// This was changed due to going in and out of caves to change the movment patten { try { // if our destination is caveteleport foreach (ObjData.CaveTeleports r in ObjData.Manager.CaveTeleports) { if (!FileDB.CheckCave(Character.Position.xSec, Character.Position.ySec)) { if (Formule.gamedistance(Formule.packetx(Character.Position.x, Character.Position.xSec), Formule.packety(Character.Position.y, Character.Position.ySec), (float)r.x, (float)r.y) <= 10) { foreach (ObjData.cavepoint p in ObjData.Manager.cavePointBase) { if (p != null) { if (p.Name == r.name) { TeleportCave(p.Number); break; } } } break; } } else { if (Formule.gamedistance(Formule.cavepacketx(Character.Position.x), Formule.cavepackety(Character.Position.y), (float)r.x, (float)r.y) <= 10) { foreach (ObjData.cavepoint p in ObjData.Manager.cavePointBase) { if (p != null) { if (p.Name == r.name) { TeleportCave(p.Number); break; } } } break; } } } } catch (Exception ex) { Log.Exception(ex); } }