require "proteger.php"; extract(recupera($_GET)); $var_pagina = $meio; $_SESSION['retorno'][$var_pagina] = $_SERVER['REQUEST_URI']; if(!libera($var_pagina, "list")) die(reload(ROOT."/?meio=aviso", 0)); $titulo_pagina = "Administradores"; $qquery = !empty($q) ? "&& u.nome LIKE '%".url_query($q)."%'" : ""; $qnivel = !empty($nivel) ? "&& u.nivel = '$nivel'" : ""; $ativo = !isset($ativo) ? "1" : $ativo; if($ativo == "0") $qativo = "&& u.ativo = '0'"; elseif($ativo == "1") $qativo = "&& u.ativo = '1'"; if(!$libera) $quid = "&& u.id = '$var_usuario_id'"; else $quid = "&& u.id != '1'"; $select = " SELECT u.*, n.nivel FROM {$db_table_admin} u LEFT JOIN {$db_table_admin_niveis} n ON u.nivel = n.id WHERE 1 = 1 $quid $qquery $qnivel $qativo ORDER BY u.nivel ASC, u.nome ASC"; // para a paginação $pg = empty($_GET['pagina']) ? 1 : $_GET['pagina']; $limit = 20; $limit_inicial = $limit * ($pg - 1); $total_geral = $ttl = count(getDadosList($select)); $total_exibido = $limit * $pg; $total_paginas = ceil($total_geral / $limit); $querystring = preg_replace("[&pagina=[0-9]+]", "", $_SERVER['QUERY_STRING']); $navegacao = navegacao($querystring, array( "pagina_atual" => $pg, "total_geral" => $total_geral, "total_exibido" => $total_exibido, "total_paginas" => $total_paginas )); // $sql = getDadosList("{$select} LIMIT $limit_inicial, $limit"); $niveis = getDadosList("SELECT * FROM {$db_table_admin_niveis} ORDER BY nivel ASC"); ?>