(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
// We enter the detail in the database
if (isset($_POST['id']) == true) {
define('IN_APP', true);
include_once 'mysql.php';
$db = new sql_db();
$db->sql_open('localhost', 'db_user', 'db_password', 'db_name', true, '');
// Escape everything
foreach ($_POST as $key => $value) {
if (is_array($_POST[$key]) == false) {
$_POST[$key] = mysql_real_escape_string($value);
}
}
$data = 0;
// Enter the details in database
for ($i = 0; $i < count($_POST['time']); $i++) {
$db->sql_insert('markers', 'user_id, phone_id, locked, time, lat, lon, acc, spd', "'1', '{$_POST['id']}', '{$_POST['lock']}', '{$_POST['time'][$i]}', '{$_POST['lat'][$i]}', '{$_POST['lon'][$i]}', '{$_POST['acc'][$i]}', '{$_POST['spd'][$i]}'");
$data++;
}
echo 'Data received (' . $data . ') ' . time();
} else {
?>
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
define('IN_APP', true);
include_once 'mysql.php';
$db = new sql_db();
$db->sql_open('localhost', 'db_user', 'db_pass', 'db_name', true, 'db_table_prefix');
if ($_GET['reset'] == 'true') {
$db->sql_truncate('markers');
}
if ($_GET['fullscreen'] == 'true') {
$canvas = 'map_canvas_full';
} else {
$canvas = 'map_canvas';
}
if ($_GET['all'] == 'true') {
$markers = $db->sql_select('markers', '1 ORDER BY TIME DESC');
} else {
$markers = $db->sql_select('markers', '1 ORDER BY time DESC LIMIT 1');
}
if (count($markers) == 0) {
echo 'No data availible to display.';
