function LogUsuario($pUserid, $pOrigem, $pLogado)
{
$gi = geoip_open($_SERVER['DOCUMENT_ROOT'] . "/geoip/GeoLiteCity.dat", GEOIP_STANDARD);
$geoip = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);
$db = new BD();
$sql = sprintf("select count(*) qtde from log_usuario\n where\n ip = '%s'\n and sessionid = '%s'", $_SERVER['REMOTE_ADDR'], session_id());
$db->Query($sql);
$db->Next();
if ($db->getValue("qtde") == 0) {
$sql = sprintf("insert into log_usuario\n\t\t\t\t\t(userid,datahora,origem,logado,ip,sessionid,cidade,estado,pais)\n\t\t\t\t\tvalues (%d,now(),'%s','%s','%s','%s','%s','%s','%s')", $pUserid, $pOrigem, $pLogado, $_SERVER['REMOTE_ADDR'], session_id(), $geoip->city, RetornaEstado($geoip->country_code, $geoip->region), $geoip->country_name);
} else {
$sql = sprintf("update log_usuario\n\t\t\t\t\t\t\tset userid = %d,\n\t\t\t\t\t\t\t\torigem = '%s',\n\t\t\t\t\t\t\t\tlogado = '%s',\n\t\t\t\t\t\t\t\tqtde = qtde + 1\n\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\tip = '%s'\n\t\t\t\t\t\t\t\tand sessionid = '%s'", $pUserid, $pOrigem, $pLogado, $_SERVER['REMOTE_ADDR'], session_id());
}
$db->Exec($sql);
$db->Close();
geoip_close($gi);
}
function RegistraVoto($opc)
{
//Registra o voto na opção informada
$db = new BD();
$sql = sprintf("insert into cad_enquete_votos\n\t (numero,opcao,ip,datahora,userid)\n\t\t\t\t\t\tvalues (%d,%d,'%s',date_add(now(),interval 1 hour),%d)", $this->getCodigo(), $opc, $_SERVER['REMOTE_ADDR'], $_SESSION['userid']);
$db->Exec($sql);
$db->Close();
}
<?php
include "sessao.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.bd.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.usuario.php";
$userid = $_GET['usr'];
$id = trim($_GET['id']);
$usr = new Usuario($userid);
$cnf = md5(trim(trim($usr->getUsername()) . "lstmailexc" . trim($usr->getEMail())));
if ($id == $cnf) {
$db = new BD();
$sql = sprintf("update cad_usuario\n\t\t\t\t\t\t\t\tset recmail = 'N'\n\t\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\t\tuserid = %d", $userid);
$db->Exec($sql);
$db->Close();
}
echo "<script> window.location = 'index.php'; </script>";
function Exclui()
{
//Exclui a reuniao
if ($this->Existe == 'N') {
return;
}
$db = new BD();
$sql = sprintf("delete from smsserver_out where id = %d", $this->getID());
$db->Exec($sql);
$db->Close();
}
function Exclui()
{
//Exclui o evento
if ($this->Existe == 'N') {
return;
}
$db = new BD();
$sql = sprintf("delete from cad_eventos where id = %d", $this->getID());
$db->Exec($sql);
$db->Close();
$pasta = sprintf("./eventos/%06d/", $this->getID());
if (is_dir($pasta) == true) {
rmdir($pasta) or die("erro excluindo diretorio");
}
}
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "/sessao.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/classes/class.bd.php";
include $_SERVER['DOCUMENT_ROOT'] . "/geoipcity.inc";
$gi = geoip_open($_SERVER['DOCUMENT_ROOT'] . "/geoip/GeoLiteCity.dat", GEOIP_STANDARD);
$db = new BD();
$db2 = new BD();
$sql = sprintf("select sequencia,ip,datahora,cidade from log_usuario where cidade is null\nand datahora >= '2008-01-01 00:00' and ip is not null order by sequencia");
$db->Query($sql);
// $db->Next();
while ($db->Next()) {
echo $db->getValue("sequencia") . " " . $db->getValue("ip") . " " . $db->getValue("cidade");
$geoip = geoip_record_by_addr($gi, $db->getValue("ip"));
$sql = sprintf("update log_usuario\n\t\t\t \t\t\t\tset cidade='%s',\n\t\t\t\t\t\t\t\testado='%s',\n\t\t\t\t\t\t\t\tpais='%s'\n\t\t\t\t\t\t\twhere\n\t\t\t\t\t\t\tsequencia=%d", $geoip->city, RetornaEstado($geoip->country_code, $geoip->region), $geoip->country_name, $db->getValue("sequencia"));
$db2->Exec($sql);
}
$db->Close();
$db2->Close();
geoip_close($gi);
function RetornaEstado($pais, $regiao)
{
require_once $_SERVER['DOCUMENT_ROOT'] . "/geoipregionvars.php";
return $GEOIP_REGION_NAME[$pais][$regiao];
}
function Exclui()
{
//Exclui a reuniao
if ($this->Existe == 'N') {
return;
}
$db = new BD();
$sql = sprintf("delete from tb_calendario where idcalendario = %d", $this->getID());
$db->Exec($sql);
$db->Close();
}
