function errorMessage($msg)
{
global $response;
$response["post"] = $_POST;
$response["message"] = $msg;
$response["time"] = getTimer(true);
die(jsValue($response, true));
}
<?php
require_once "../include/includes.php";
setContentType("text", "plain");
session_start();
$db = new SqlManager($fpConfig);
$postJson = getJsonPostData();
$action = reqParam("action");
if (!$action) {
$action = @$postJson["action"];
}
$username = fpCurrentUsername();
$response = array();
switch ($action) {
case "saveForm":
//save form: insert,update,delete user_answers for this user
$user_answers = $postJson["formData"];
$result = saveAnswers($db, $username, $user_answers);
$response = array("answers" => count($user_answers), "result" => $result);
break;
case "form_questions":
default:
$response["questions"] = getFormQuestions($db, $_REQUEST);
if ($username) {
$response["user_answers"] = $db->selectWhere(array("table" => "user_answer", "username" => $username));
}
}
$db->disconnect();
$response["queries"] = $db->getLog();
$response["time"] = getTimer(true);
echo jsValue($response);
<?php
////
// This code retreives the current turn and current team.
require_once "db_connection.php";
require_once "helpers.php";
try {
//// get the current turn time and id
$sql = "SELECT * FROM turntime WHERE idturn = (SELECT max(idturn) FROM turntime)";
$statement = $database->prepare($sql);
$statement->execute();
$query_result = $statement->fetch(PDO::FETCH_ASSOC);
if (empty($query_result)) {
exit("Could not contact server");
}
//$request_update_in = sqlGetTimer($datetime);
$return['seconds_left'] = getTimer();
$return['turnid'] = $query_result['idturn'];
$return['board'] = $query_result['board'];
$return['team'] = $query_result['team'];
$return['lastmoves'] = $query_result['lastmoves'];
echo json_encode($return);
} catch (PDOException $e) {
echo "<p>ERROR: {$e}</p>";
}
//// get the current turn time and id
$sql = "SELECT * FROM turntime WHERE idturn = (SELECT max(idturn) FROM turntime)";
$statement = $database->prepare($sql);
$statement->execute();
$query_result = $statement->fetch(PDO::FETCH_ASSOC);
if (empty($query_result)) {
exit("Could not contact server");
}
$datetime = $query_result['time'];
$turnid = $query_result['idturn'];
$board = $query_result['board'];
$team = $query_result['team'];
$moves = $query_result['lastmoves'];
//$request_update_in = sqlGetTimer($datetime);
//echo "<p>Time left: $request_update_in on turn $turnid until request server update</p>";
$seconds_left = getTimer();
//echo "<p>Player has $seconds_left seconds left to make a choice that will guarantee to be on this turn (not taking into account latency)</p>";
// create checkbox board
for ($i = 0; $i < 8; $i++) {
for ($j = 0; $j < 8; $j++) {
$index = $i * 8 + $j;
$style = 'style="background-color:';
if ($board[$index] === 'B') {
$style .= 'blue; color: blue"';
} else {
if ($board[$index] === 'R') {
$style .= 'red; color: red"';
} else {
if ($board[$index] === 'Q') {
$style .= 'orange; color: orange"';
} else {
function getNow($fmt = "Y-m-d H:i:s")
{
return gmdate($fmt, getTimer());
}
if ($groupValue === "NULL") {
continue;
}
$params[$groupBy] = $groupValue;
$data = demographicPortrait($db, $params, $portraitType);
if (!count($data)) {
continue;
}
setExists($data);
$groupKey = $groupValue;
$groupKey = "group_{$groupValue}";
$groupKey = str_replace(":", "_", $groupKey);
if (@$form_answers[$groupValue]) {
$groupTitles[$groupKey] = $form_answers[$groupValue]["label"];
} else {
if ($interval > 1) {
$groupTitles[$groupKey] = str_replace(":", " to ", $groupValue);
}
}
debugVar("groupTitles", "print_r");
$results[$groupKey] = $data;
}
}
$queries = $db->getLog();
$db->disconnect();
$response = array();
$response["time"] = getTimer(true);
addVarsToArray($response, "params age years users groups groupTitles queries results");
echo jsValue($response, true);
getTimer();
