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