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 {