<?php
error_reporting(E_STRICT);
include_once "cls_connection.php";
$db = new ConnectMySql();
$aValues = json_decode(file_get_contents("php://input"), true);
$aData = array();
$aData["records"] = array();
$aData["message_list"] = array();
if (isset($aValues)) {
$sTriviaText = $aValues["text"];
$iCorrect = (bool) $aValues["correct"];
$aUser = $aValues["user"];
if ($iCorrect) {
$aUser["user_lifetime_score"] = $aUser["user_lifetime_score"] + 1;
$aUser["user_game_score"] = $aUser["user_game_score"] + 1;
$sUpdateUserProfile = "UPDATE wds_users SET user_lifetime_score = {$aUser["user_lifetime_score"]}, user_game_score = {$aUser["user_game_score"]} " . " WHERE user_active = TRUE AND user_id = {$aUser["user_id"]}";
$cmd = $db->command($sUpdateUserProfile);
if ($db->NumRowsAffected() > 0) {
array_push($aData["records"], $aUser);
} else {
array_push($aData["message_list"], "An error occurred and we were not able to update you profile, please try again. Error: " . $db->GetError());
}
}
} else {
array_push($aData["message_list"], "Page is allowed only by ajax requests.");
}
echo json_encode($aData);
$aValues["first_answer_correct"] = isset($aValues["first_answer_correct"]) ? 1 : 0;
$aValues["second_answer_correct"] = isset($aValues["second_answer_correct"]) ? 1 : 0;
$aValues["second_answer"] = str_replace("\"", "\"", str_replace("'", "\\'", htmlentities($aValues["second_answer"])));
$aValues["second_answer"] = str_replace("\"", "\"", str_replace("'", "\\'", htmlentities($aValues["second_answer"])));
$sInsertFirstAnswer = "INSERT INTO wds_answer (ans_answer, ans_correct, ans_created_by, ans_updated_by, ans_created_at, ans_updated_at, ans_active) VALUES ('{$aValues["first_answer"]}', {$aValues["first_answer_correct"]}, 1, 1, now(), now(), 1)";
$cmdInsertFirstAnswers = $db->command($sInsertFirstAnswer, true);
$iFirstAnswerID = $db->GetInsertedID();
$sInsertSecondAnswer = "INSERT INTO wds_answer (ans_answer, ans_correct, ans_created_by, ans_updated_by, ans_created_at, ans_updated_at, ans_active) VALUES ('{$aValues["second_answer"]}', {$aValues["second_answer_correct"]}, 1, 1, now(), now(), 1)";
$cmdInsertSecondAnswers = $db->command($sInsertSecondAnswer, true);
$iSecondAnswerID = $db->GetInsertedID();
$sInsertQuestion = "INSERT INTO wds_questions (qes_question, qes_created_by, qes_updated_by, qes_created_at, qes_updated_at, qes_active) VALUES ('{$aValues["question"]}', 1, 1, now(), now(), 1)";
$cmdInsert = $db->command($sInsertQuestion, true);
$iQuestionID = $db->GetInsertedID();
$sInsertAnsQues = "INSERT INTO wds_answers_question (anqe_first_answer_id, anqe_second_answerd_id, anqe_question_id, anqe_created_by, anqe_updated_by, anqe_created_at, anqe_updated_at, anqe_active) VALUES ({$iFirstAnswerID[0]}, {$iSecondAnswerID[0]}, {$iQuestionID[0]}, 1, 1, now(), now(), 1)";
$cmdInsertAnsQues = $db->command($sInsertAnsQues, true);
$iSetAnswerQuestionID = $db->GetInsertedID();
$sSelectTrivia .= " AND trivia.anqe_id = {$iSetAnswerQuestionID[0]}";
$cmdSavedTrivia = $db->command($sSelectTrivia);
if ($db->NumRowsAffected() > 0) {
$aData["success"] = "Trivia {$aValues["question"]} created successfully";
$aData["records"] = $db->fetch_array($cmdSavedTrivia);
} else {
array_push($aData["message_list"], "Trivia was unable to be inserted. This is the error: " . $db->GetError());
}
}
} else {
$sSelectTrivia .= isset($aValues["random"]) ? " ORDER BY RAND() LIMIT 10" : "";
$cmdGetTrivias = $db->command($sSelectTrivia);
$aData["records"] = $db->fetch_array($cmdGetTrivias);
}
echo json_encode($aData);
<?php
error_reporting(E_STRICT);
include_once "ConnectMySql.class.php";
include_once "Carrito.class.php";
$db = new ConnectMySql();
$oCarrito = new Carrito();
$aValues["productos"] = $oCarrito->get_content();
$aValuesUser = $_POST["user"];
$aData = array();
$aData["message_list"] = array();
if ($aValues["productos"] !== "") {
if (is_array($aValues["productos"])) {
$aValues["productos"] = json_encode($aValues["productos"]);
}
$cmdInsert = $db->command("INSERT INTO flo_pagos (\n\t\t\tpag_productos,\n\t\t\tpag_usuario_nombre,\n\t\t\tpag_usuario_apellido,\n\t\t\tpag_usuario_telefono,\n\t\t\tpag_usuario_email,\n\t\t\tpag_usuario_localidad,\n\t\t\tpag_usuario_numero_tarjeta,\n\t\t\tpag_usuario_direccion,\n\t\t\tpag_updated_at,\n\t\t\tpag_active)\n\t\tVALUES (\n\t\t\t'{$aValues["productos"]}',\n\t\t\t'{$aValuesUser["nombre"]}',\n\t\t\t'{$aValuesUser["apellido"]}',\n\t\t\t'{$aValuesUser["telefono"]}',\n\t\t\t'{$aValuesUser["email"]}',\n\t\t\t'{$aValuesUser["localidad"]}',\n\t\t\t'{$aValuesUser["numero_tarjeta"]}',\n\t\t\t'{$aValuesUser["direccion"]}',\n\t\t\tnow(),\n\t\t\t1)");
if ($db->NumRowsAffected() > 0) {
$aData["success"] = "Pago creado exitosamente.";
$aData["id"] = $db->GetLastID();
} else {
array_push($aData["message_list"], "Pago no fue guardado. Este es el error: " . $db->GetError());
}
} else {
array_push($aData["message_list"], "Por favor hacer una compra primero.");
}
echo json_encode($aData);
