PoracleWeb/actions/set_location.php at 75f8684678ea4e7d9401c586cabe155fe718210e · bbdoc/PoracleWeb · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?php

include_once "../config.php";
include_once "../include/db_connect.php";
include_once "../include/functions.php";


if ( isset($_GET['action']) && $_GET['action'] == "delete" ) {

  $lat = "0.0000000000";
  $lon = "0.0000000000";

  $sql = "UPDATE monsters set distance = 0 WHERE id = '" . $_SESSION['id'] . "' AND profile_no = '".$_SESSION['profile']."'";
  $result = $conn->query($sql);
  $sql = "UPDATE raid set distance = 0 WHERE id = '" . $_SESSION['id'] . "' AND profile_no = '".$_SESSION['profile']."'";
  $result = $conn->query($sql);
  $sql = "UPDATE egg set distance = 0 WHERE id = '" . $_SESSION['id'] . "' AND profile_no = '".$_SESSION['profile']."'";
  $result = $conn->query($sql);
  $sql = "UPDATE quest set distance = 0 WHERE id = '" . $_SESSION['id'] . "' AND profile_no = '".$_SESSION['profile']."'";
  $result = $conn->query($sql);
  $sql = "UPDATE invasion set distance = 0 WHERE id = '" . $_SESSION['id'] . "' AND profile_no = '".$_SESSION['profile']."'";
  $result = $conn->query($sql);

} else if ( isset($_GET['lat']) &&  isset($_GET['lon']) ) {

   $lat = $_GET['lat'];
   $lon = $_GET['lon'];

} else {

   $address = urlencode($_POST['street'] . ' ' . $_POST['city']);
   $filepath=$_SESSION['providerURL']."/search?addressdetails=1&q=$address&format=json&limit=1";

   if ( strlen($_SESSION['staticKey']) == 32  ) {
	   $filepath.="&key=".$_SESSION['staticKey'];
   }

   $request = file_get_contents($filepath);

   if ( $request == "[]" ) {
      header("Location: $redirect_url?type=display&page=area&return=error_update_location");
      exit();
   }

   $json = json_decode($request, true);

   foreach ($json as $key => $value) {
      foreach ($value as $key => $value2) {
         if ($key == "lat") { $lat = $value2; }
         if ($key == "lon") { $lon = $value2; }
      }
   }

}

// Update Lat and Lon from Humans if current profile is active

$stmt = $conn->prepare("UPDATE humans set latitude = ?, longitude = ? WHERE id = ? AND current_profile_no = ?");
if (false === $stmt) {
  header("Location: $redirect_url?type=display&page=area&return=sql_error&phase=ESLH1&sql=$stmt->error");
  exit();
}
$rs = $stmt->bind_param("sssi", $lat, $lon, $_SESSION['id'], $_SESSION['profile']);
if (false === $rs) {
  header("Location: $redirect_url?type=display&page=area&return=sql_error&phase=ESLH2&sql=$stmt->error");
  exit();
}
$rs = $stmt->execute();
if (false === $rs) {
  header("Location: $redirect_url?type=display&page=area&return=sql_error&phase=ESLH3&sql=$stmt->error");
  exit();
}

// Update Lat and Lon from Profile if exist

$stmt = $conn->prepare("UPDATE profiles set latitude = ?, longitude = ? WHERE id = ? AND profile_no = ?");
if (false === $stmt) {
  header("Location: $redirect_url?type=display&page=area&return=sql_error&phase=ESLP1&sql=$stmt->error");
  exit();
}
$rs = $stmt->bind_param("sssi", $lat, $lon, $_SESSION['id'], $_SESSION['profile']);
if (false === $rs) {
  header("Location: $redirect_url?type=display&page=area&return=sql_error&phase=ESLP2&sql=$stmt->error");
  exit();
}
$rs = $stmt->execute();
if (false === $rs) {
  header("Location: $redirect_url?type=display&page=area&return=sql_error&phase=ESLP3&sql=$stmt->error");
  exit();
}


if ( isset($_POST['delete']) ) {
    header("Location: $redirect_url?type=display&page=area&return=success_delete_location");
    exit();
} else {
    header("Location: $redirect_url?type=display&page=area&return=success_update_location");
    exit();
}


?>