Anterior";
}
$qt = 5;
$ini = (($pagina - $qt) > 0 ) ? $pagina - $qt : 1;
$fim = (($pagina + $qt) < $paginas) ? $pagina + $qt : $paginas;
for ($i = $ini; $i <= $fim; $i++) {
if ($i == $pagina)
$nav .= "$i";
else
$nav .= "$i";
}
if ($pagina == $paginas OR $total < $regsperpage){
$nav .= "";
} else {
$next = $pagina + 1;
$nav .="Próxima";
}
$result['consulta'] = $consulta . " LIMIT $start,$regsperpage";
$result['nav'] = $nav;
return $result;
}
return 0;
}
function makePaginacao($module, $consulta, $regsperpage, $pagina=1) {
$query = mysql_query($consulta);
$total = mysql_num_rows($query);
if ($total) {
$paginas = floor($total / $regsperpage);
if ($total % $regsperpage)
$paginas++;
$start = ($pagina * $regsperpage) - $regsperpage;
if ($pagina == 1)
$nav = "";
else {
$prev = $pagina - 1;
$nav = " Anterior";
}
for ($i = 1; $i <= $paginas; $i++) {
if ($i == $pagina)
$nav .= "$i";
else
$nav .= "$i";
}
if ($pagina == $paginas OR $total < $regsperpage)
$nav .= "";
else {
$next = $pagina + 1;
$nav .="Pr�xima ";
}
$result['consulta'] = $consulta . " LIMIT $start,$regsperpage";
$result['nav'] = $nav;
return $result;
}
return 0;
}
function convData($data, $caracter="-") {
$date = explode("-", $data);
return $date[2] . "$caracter" . $date[1] . "$caracter" . $date[0];
}
function autenticar($input_login, $input_senha) {
$cons = mysql_query("SELECT * FROM usuarios WHERE login= '$input_login'");
if (!mysql_num_rows($cons))
return 0;
$res = mysql_fetch_array($cons);
$id = $res['id'];
$login = $res['login'];
$senha = $res['senha'];
if (strcmp(crypt($input_senha, $senha), $senha))
return 0;
$ip = $_SERVER['REMOTE_ADDR'];
$chave = md5($ip . $login);
$_SESSION['usuario'] = array("id" => $id, "login" => $login, "chave" => $chave);
return 1;
}
function logar() {
if (!isset($_SESSION['usuario']))
return 0;
$user = $_SESSION['usuario'];
$ip = $_SERVER['REMOTE_ADDR'];
$x = md5($ip . $user['login']);
if (strcmp($x, $user['chave'])) {
return 0;
}
$_SESSION['usuario'] = $user;
return 1;
}
function tituloPagina($modulo, $CLASSES) {
foreach ($CLASSES as $Key => $valor):
if ($valor == $modulo):
$tit_pagina = $Key;
endif;
endforeach;
return $tit_pagina;
}
?>id = $id;
$this->op = "edita";
$this->loadAll();
} else {
$this->op = "novo";
}
}
function setData($data) {
$tudo = get_object_vars($this);
foreach ($tudo as $var => $valor) {
if (($var != 'op') and ($var != 'id'))
$this->$var = addslashes($data[$var]);
}
}
function loadAll() {
$query = mysql_query("SELECT * FROM " . self::$table . " WHERE (id = '$this->id')") or die(mysql_error());
$res = mysql_fetch_array($query);
$tudo = get_object_vars($this);
foreach ($tudo as $var => $valor) {
if (($var != 'op') and ($var != 'id')){
$this->$var = stripslashes($res[$var]);
}
}
}
function save() {
$tudo = get_object_vars($this);
foreach ($tudo as $var => $valor) {
if (($var != 'op') and ($var != 'id')) {
$campos[] = "$var";
$valores[] = "'$valor'";
}
}
if (!strcmp($this->op, "novo")) {
$cm = implode(', ', $campos);
$vl = implode(', ', $valores);
$insere = "INSERT INTO " . self::$table . " ($cm) VALUES ($vl)";
$query = mysql_query($insere) or die(mysql_error());
$this->id = mysql_insert_id();
} else {
$combina = array_combine($campos, $valores);
$campos = '';
foreach ($combina as $var => $valor) {
if (($var != 'op') and ($var != 'id')){
$campos[] = "`$var` = $valor";
}
}
$td = implode(', ', $campos);
$upd = "UPDATE " . self::$table . " SET $td WHERE id = '$this->id'";
$query = mysql_query($upd) or die(mysql_error());
}
}
function delete() {
$query = mysql_query("DELETE FROM " . self::$table . " WHERE id= '$this->id'") or die(mysql_error());
return 1;
}
function lista_default($modulo, $registros=10, $pagina=1, $ordene="id DESC", $url="") {
$consulta = "SELECT * FROM " . self::$table . " ORDER BY $ordene $tipo";
$data = makePaginacao($modulo . $url, $consulta, $registros, $pagina);
if ($data) {
$query = mysql_query($data["consulta"]) or die(mysql_error());
if (mysql_num_rows($query)) {
$retorno['nav'] = $data['nav'];
while ($x = mysql_fetch_object($query)){
$retorno[] = $x;
}
return $retorno;
} else {
return 0;
}
}
return 0;
}
function getLast($limit=10, $ordem="id DESC", $exclude="") {
if ($exclude){
$ex = " AND (id <> $exclude) ";
}
$query = mysql_query("SELECT *, DATE_FORMAT(data_inicial,'%d/%m/%Y') AS dataNoticia FROM " . self::$table . " WHERE (status = '1') $ex ORDER BY $ordem LIMIT $limit") or die(mysql_error());
if (mysql_num_rows($query)) {
while ($resultado = mysql_fetch_object($query)){
$retorno[] = $resultado;
}
return $retorno;
} else {
return 0;
}
}
function getAll($pagina=1, $limite=10, $ordem="id DESC", $url="") {
$query = "SELECT * FROM " . self::$table . $ord;
$data = Paginacao($query, $limite, $pagina, $url);
if ($data) {
$consulta = mysql_query($data['consulta']);
$retorno['nav'] = $data['nav'];
while ($resultado = mysql_fetch_object($consulta)){
$retorno[] = $resultado;
}
return $retorno;
}
return 0;
}
function getValue($id) {
$query = "SELECT * FROM " . self::$table . " WHERE (id = $id)";
$consulta = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($consulta)) {
$resultado = mysql_fetch_object($consulta);
return $resultado;
} else {
return 0;
}
}
function atualizaStatus($id, $status) {
$query = "UPDATE " . self::$table . " SET status = '$status' WHERE (id = '$id')";
mysql_query($query) or die(mysql_error());
}
}
?>