function hasPoll()
{
require 'functions/cla-connection.php';
require 'config/dbconfig.php';
// No poll avaliable
$POLL = false;
$conn = new db_connection($hostname, $username, $password, $database);
// Check is has active pool
$result = $conn->select("enq_pergunta", array("id"), "enq_ativa=1");
// Has one active poll
if ($conn->affected_rows() == 1) {
$data = $conn->fetch_array($result);
$poll = $data['id'];
$login = $_SESSION['LOGIN'];
//
$result = $conn->select("enq_voto", array("login"), "enq_id='{$poll}' and login = '******'");
// User has already voted
if ($conn->affected_rows() == 0) {
$POLL = true;
}
}
// Return array of values
//$info[] = array();
$info['POLL'] = $POLL;
print json_encode($info);
}
function hasPool()
{
require 'classes/db_connection.php';
require 'config/dbconfig.php';
require 'functions/fun-net.inc.php';
// Get Remote user IP
$remoteIP = getIp();
$conn = new db_connection($hostname, $username, $password, $database);
$result = $conn->select("user_control", array("username"), "address='{$remoteIP}'");
//
if ($conn->affected_rows() == 1) {
$data = $conn->fetch_array($result);
$login = $data['username'];
$result = $conn->select("tec_users", array("nome"), "login='******'");
$data = $conn->fetch_array($result);
$nome = $data['nome'];
$_SESSION['IP'] = $remoteIP;
$_SESSION['LOGIN'] = $login;
} else {
$nome = "404";
}
// Return array of values
//$info[] = array();
$info['IP'] = $remoteIP;
$info['USER'] = $nome;
$info['LOGIN'] = $login;
print json_encode($info);
}
function buildPoll()
{
require 'functions/cla-connection.php';
require 'config/dbconfig.php';
$conn = new db_connection($hostname, $username, $password, $database);
// Get topic of poll
$rsPergunta = $conn->select("enq_pergunta", array("id,enq_pergunta"), "enq_ativa=1");
//
if ($conn->affected_rows() == 1) {
$dtPergunta = $conn->fetch_array($rsPergunta);
$pergunta = $dtPergunta['enq_pergunta'];
$enq_id = $dtPergunta['id'];
// Get all answer of current poll
$rsResposta = $conn->select("enq_resposta", array("id,enq_resposta"), "enq_id='{$enq_id}'");
$arrayRet[] = array("PERGUNTA" => $pergunta, "ENQID" => $enq_id);
while ($reposta = $conn->fetch_array($rsResposta)) {
$arrayRet[] = array("RESPID" => $reposta['id'], "RESPDES" => $reposta['enq_resposta']);
}
}
print json_encode($arrayRet);
}
