update.php

<?php
require_once "../config.php";

use \Tsugi\Core\LTIX;
use \Tsugi\Util\U;
use \Tsugi\UI\Output;

// Sanity checks
$LAUNCH = LTIX::requireData();
Output::headerJson();

$p = $CFG->dbprefix;
$lat = U::get($_POST, 'lat');
$lng = U::get($_POST, 'lng');
if ( $lat !== null && $lng !== null ) {
    $lat = $lat+0;
    $lng = $lng+0;
    if ( abs($lat) > 85 || abs($lng) > 180 || ($lat == 0 && $lng == 0) ) {
        echo(json_encode(array('status'=> 'failure', 'lat' => $lat, 'lng' =>  $lng)));
        return;
    }
    $sql = "INSERT INTO {$p}context_map
        (context_id, user_id, lat, lng, updated_at)
        VALUES ( :CID, :UID, :LAT, :LNG, NOW() )
        ON DUPLICATE KEY
        UPDATE lat = :LAT, lng = :LNG, updated_at = NOW()";
    $PDOX->queryDie($sql, array(
        ':CID' => $CONTEXT->id,
        ':UID' => $USER->id,
        ':LAT' => $lat,
        ':LNG' => $lng));
    echo(json_encode(array('status'=> 'success', 'lat' => $lat, 'lng' =>  $lng)));
    return;
}

$allow_name = U::get($_POST, 'allow_name');
$allow_email = U::get($_POST, 'allow_email');
$allow_first = U::get($_POST, 'allow_first');
if ( $allow_name !== null && $allow_email !== null && $allow_first !== null ) {
    $sql = "INSERT INTO {$p}context_map
        (context_id, user_id, name, email, first, updated_at)
        VALUES ( :CID, :UID, :NAME, :EMAIL, :FIRST, NOW() )
        ON DUPLICATE KEY
        UPDATE name = :NAME, email = :EMAIL, first = :FIRST, updated_at = NOW()";
    $PDOX->queryDie($sql, array(
        ':CID' => $CONTEXT->id,
        ':UID' => $USER->id,
        ':NAME' => $allow_name+0,
        ':FIRST' => $allow_first+0,
        ':EMAIL' => $allow_email+0));
    echo(json_encode(array('status'=> 'success', 'email' =>  $allow_email,
        'name' => $allow_name, 'first' => $allow_first)));
    return;
}
echo(json_encode(array('status'=> 'failure')));