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();