Example #1
0
 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);
     }
 }
Example #2
0
 /////////////////////////////////////////////////////////////////////////////////
 // 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);
     }
 }