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 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 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);
}
# Quantas vezes o mesmo ip participou de nossas campanhas?
select tab02_ip ip, count(tab02_ip) votos
from tab02_voto
group by tab02_ip
order by tab02_ip
*/
require_once 'classes/db_connection.php';
require_once 'config/dbconfig.php';
require_once 'functions/fun-net.inc.php';
$ip = getIP();
$voto = $_POST['radio_voto'];
$votou = '';
$conn = new db_connection($hostname, $username, $password, $database);
$result = $conn->select("enq_pergunta", array("id,enq_pergunta,enq_obrigatoria"), "enq_ativa = 1");
// Seleciona a enquete da vez, só pra pegar o ID
$data = $conn->fetch_array($result);
$id = $data['tab01_id'];
$result = $conn->select("enq_voto", array("tab01_id"), "tab01_id = '{$id}' and tab02_ip = '{$ip}'");
$data = $conn->fetch_array($result);
// Se ainda não votou.
if ($data['tab02_ip'] == '') {
// Computa o voto
if ($_POST['radio_voto'] != '') {
$id = $_POST['tab01_id'];
$sql = "insert into tab02_voto VALUES ('{$id}', '{$ip}', now(), {$voto})";
mysql_query($sql) or die(mysql_error());
$sql = "update tab01_enquetes set tab01_perc{$voto} = (tab01_perc{$voto} +1) where tab01_id = '{$id}'";
mysql_query($sql) or die(mysql_error());
$votou = "Seu voto foi computado. Agradecemos a participação.";
}
} else {
