PHP Decode

<?php 
require_once 'init.php'; 
require 'check.php'; 
if ($permissao == "1" || $permissao == "2") { 
    $pagina = "usu&aacute;rios"; 
    $banco  = "user"; 
    $olink  = "usuarios"; 
    if ($acao == "insert") { 
        if ($senha != "") { 
            $password = $senha; 
            $pass1    = "Password,"; 
            $pass2    = ":password,"; 
        } 
        if ($apermissao == "2") { 
            if ($paginas != "") { 
                $paginas2 = implode("|", $paginas); 
            } else { 
                $paginas2 = ""; 
            } 
            if ($categorias != "") { 
                if (in_array(1, $categorias)) { 
                    $categorias2 = implode("|", $categorias); 
                } else { 
                    $categorias2 = implode("|", $categorias); 
                    $categorias2 .= "|1"; 
                } 
            } else { 
                $categorias2 = "1"; 
            } 
            if ($destinos != "") { 
                if (in_array(1, $destinos)) { 
                    $destinos2 = implode("|", $destinos); 
                } else { 
                    $destinos2 = implode("|", $destinos); 
                    $destinos2 .= "|1"; 
                } 
            } else { 
                $destinos2 = "1"; 
            } 
            if ($colunas != "") { 
                $colunas2 = implode("|", $colunas); 
            } else { 
                $colunas2 = ""; 
            } 
            if ($anuncios != "") { 
                $anuncios2 = implode("|", $anuncios); 
            } else { 
                $anuncios2 = ""; 
            } 
        } 
        $permissao = $apermissao; 
        $stmt      = $conecta->prepare("INSERT INTO $banco (name, email, $pass1 cidade, estado, site, telefone, observacoes, permissao, paginas, categorias, destinos, colunas, anuncios) VALUES (:name, :email, $pass2 :cidade, :estado, :site, :telefone, :observacoes, :permissao, :paginas2, :categorias2, :destinos2, :colunas2, :anuncios2)"); 
        $stmt->bindParam(':name', $name); 
        $stmt->bindParam(':email', $email); 
        $stmt->bindParam(':password', $password); 
        $stmt->bindParam(':cidade', $cidade); 
        $stmt->bindParam(':estado', $estado); 
        $stmt->bindParam(':site', $site); 
        $stmt->bindParam(':telefone', $telefone); 
        $stmt->bindParam(':observacoes', $observacoes); 
        $stmt->bindParam(':permissao', $permissao); 
        $stmt->bindParam(':paginas2', $paginas2); 
        $stmt->bindParam(':categorias2', $categorias2); 
        $stmt->bindParam(':destinos2', $destinos2); 
        $stmt->bindParam(':colunas2', $colunas2); 
        $stmt->bindParam(':anuncios2', $anuncios2); 
        $stmt->execute(); 
        if ($_FILES['foto']['tmp_name'] != "") { 
            $id_recuperado = $conecta->lastInsert_id_(); 
            $uploaddir     = "../img/"; 
            $extensao      = explode('.', $_FILES['foto']['name']); 
            $extensao      = $extensao[1]; 
            $nomeimg       = rand() . ".$extensao"; 
            include '../admin/classupload.php'; 
            $upload         = new UploadImagem(); 
            $upload->width  = 400; 
            $upload->height = 400; 
            $upload->aimg   = "$nomeimg"; 
            echo $upload->salvar("$uploaddir", $_FILES['foto']); 
            $foto1 = "$nomeimg"; 
            $stmt  = $conecta->prepare("UPDATE $banco SET foto=:foto1 WHERE _id_=$id_recuperado"); 
            $stmt->bindParam(':foto1', $foto1); 
            $stmt->execute(); 
        } 
        $informacao = '<div class="cadastrado">Informa&ccedil;&otilde;es cadastradas com sucesso!</div>'; 
    } 
    if ($acao == "update") { 
        $uploaddir = "../img/"; 
        if ($_FILES['foto']['tmp_name'] != "") { 
            $nova_foto = "S"; 
        } 
        if ($nova_foto == "S") { 
            if ($_FILES['foto']['tmp_name'] != "") { 
                $extensao = explode('.', $_FILES['foto']['name']); 
                $extensao = $extensao[1]; 
                $nomeimg  = rand() . ".$extensao"; 
                include '../admin/classupload.php'; 
                $upload         = new UploadImagem(); 
                $upload->width  = 400; 
                $upload->height = 400; 
                $upload->aimg   = "$nomeimg"; 
                echo $upload->salvar("$uploaddir", $_FILES['foto']); 
                $foto1 = "$nomeimg"; 
            } 
            $url = "../img/$foto_antiga"; 
            unlink("$url"); 
        } else { 
            $foto1 = "$foto_antiga"; 
        } 
        if ($paginas != "") { 
            $paginas2 = implode("|", $paginas); 
        } else { 
            $paginas2 = ""; 
        } 
        if ($categorias != "") { 
            if (in_array(1, $categorias)) { 
                $categorias2 = implode("|", $categorias); 
            } else { 
                $categorias2 = implode("|", $categorias); 
                $categorias2 .= "|1"; 
            } 
        } else { 
            $categorias2 = "1"; 
        } 
        if ($destinos != "") { 
            if (in_array(1, $destinos)) { 
                $destinos2 = implode("|", $destinos); 
            } else { 
                $destinos2 = implode("|", $destinos); 
                $destinos2 .= "|1"; 
            } 
        } else { 
            $destinos2 = "1"; 
        } 
        if ($colunas != "") { 
            $colunas2 = implode("|", $colunas); 
        } else { 
            $colunas2 = ""; 
        } 
        if ($anuncios != "") { 
            $anuncios2 = implode("|", $anuncios); 
        } else { 
            $anuncios2 = ""; 
        } 
        $permissao = $apermissao; 
        if ($password != "") { 
            $asenha = ", Password=:password"; 
        } 
        $birthday = $dia . '-' . $mes . '-' . $ano; 
         
        $stmt = $conecta->prepare("UPDATE $banco SET Gender=:gender, NickName=:nickname, E_Mail=:email, Country=:country, Pergunta=:pergunta, Resposta=:resposta, nome=:nome, birthday=:birthday, permissao=:permissao, foto=:foto1, paginas=:paginas2, categorias=:categorias2, destinos=:destinos2, colunas=:colunas2, anuncios=:anuncios2 $asenha WHERE _id_=$_GET[id]"); 
        $stmt->bindParam(':gender', $gender); 
        $stmt->bindParam(':nickname', $nickname); 
        $stmt->bindParam(':email', $email); 
        $stmt->bindParam(':country', $country); 
        $stmt->bindParam(':pergunta', $pergunta); 
        $stmt->bindParam(':resposta', $resposta); 
        $stmt->bindParam(':nome', $nome); 
        $stmt->bindParam(':birthday', $birthday); 
        $stmt->bindParam(':permissao', $permissao); 
        $stmt->bindParam(':foto1', $foto1); 
        $stmt->bindParam(':paginas2', $paginas2); 
        $stmt->bindParam(':categorias2', $categorias2); 
        $stmt->bindParam(':destinos2', $destinos2); 
        $stmt->bindParam(':colunas2', $colunas2); 
        $stmt->bindParam(':anuncios2', $anuncios2); 
        if ($password != "") { 
            $stmt->bindParam(':password', $password); 
        } 
        $stmt->execute(); 
        $banco1 = 'gunwcuser'; 
        $stmt1  = $conecta->prepare("UPDATE $banco1 SET Gender=:gender, NickName=:nickname, E_Mail=:email, Country=:country, Pergunta=:pergunta, Resposta=:resposta, nome=:nome, birthday=:birthday, permissao=:permissao, foto=:foto1, paginas=:paginas2, categorias=:categorias2, destinos=:destinos2, colunas=:colunas2, anuncios=:anuncios2 $asenha WHERE _id_=$_GET[id]"); 
        $stmt1->bindParam(':gender', $gender); 
        $stmt1->bindParam(':nickname', $nickname); 
        $stmt1->bindParam(':email', $email); 
        $stmt1->bindParam(':country', $country); 
        $stmt1->bindParam(':pergunta', $pergunta); 
        $stmt1->bindParam(':resposta', $resposta); 
        $stmt1->bindParam(':nome', $nome); 
        $stmt1->bindParam(':birthday', $birthday); 
        $stmt1->bindParam(':permissao', $permissao); 
        $stmt1->bindParam(':foto1', $foto1); 
        $stmt1->bindParam(':paginas2', $paginas2); 
        $stmt1->bindParam(':categorias2', $categorias2); 
        $stmt1->bindParam(':destinos2', $destinos2); 
        $stmt1->bindParam(':colunas2', $colunas2); 
        $stmt1->bindParam(':anuncios2', $anuncios2); 
        if ($password != "") { 
            $stmt1->bindParam(':password', $password); 
        } 
        $stmt1->execute(); 
        $banco2 = 'game'; 
        $stmt2  = $conecta->prepare("UPDATE $banco2 SET NickName=:nickname WHERE Id='$user'"); 
        $stmt2->bindParam(':nickname', $nickname); 
        $stmt2->execute(); 
        $informacao = '<div class="alterado">Informa&ccedil;&otilde;es alteradas com sucesso!</div>'; 
    } 
     
    if ($_GET[acao] == "status") { 
        if ($_GET[status] == "desativar") { 
            $ostatus   = "N"; 
            $authority = "1"; 
			$permiss = "0"; 
        } 
        if ($_GET[status] == "ativar") { 
            $ostatus   = "S"; 
            $authority = "99"; 
			$permiss = "2"; 
        } 
        $stmt = $conecta->prepare("UPDATE $banco SET Authority=:authority, Authority2=:authority, Status=:status, permissao=:permiss WHERE _id_=$_GET[id]"); 
        $stmt->bindParam(':status', $ostatus); 
        $stmt->bindParam(':authority', $authority); 
        $stmt->bindParam(':permiss', $permiss); 
        $stmt->execute(); 
        $stmt2 = $conecta->prepare("UPDATE gunwcuser SET Authority=:authority, Authority2=:authority, Status=:status, permissao=:permiss WHERE _id_=$_GET[id]"); 
        $stmt2->bindParam(':status', $ostatus); 
        $stmt2->bindParam(':authority', $authority); 
        $stmt2->bindParam(':permiss', $permiss); 
        $stmt2->execute(); 
        $informacao = '<div class="alterado">Informa&ccedil;&otilde;es alteradas com sucesso!</div>'; 
    } 
    if ($_GET[acao] == "remover") { 
        $registrado = $conecta->query("SELECT * FROM $banco WHERE _id_='$_GET[ident]'"); 
        $registrado = $registrado->fetch(PDO::FETCH_OBJ); 
        if ($registrado->foto != "") { 
            unlink("../img/" . $registrado->foto . ""); 
        } 
        $stmt = $conecta->prepare("DELETE FROM $banco WHERE _id_=:id"); 
        $stmt->bindParam(':id', $_GET[ident]); 
        $stmt->execute();		 
 
        $stmt0 = $conecta->prepare("DELETE FROM gunwcuser WHERE Id='$registrado->user'"); 
        $stmt0->execute();  
		 
        $stmt1 = $conecta->prepare("DELETE FROM game WHERE Id='$registrado->user'"); 
        $stmt1->execute(); 
		 
        $stmt2 = $conecta->prepare("DELETE FROM cash WHERE ID='$registrado->user'"); 
        $stmt2->execute();		 
		 
        $stmt3 = $conecta->prepare("DELETE FROM gp_buzinas WHERE ID='$registrado->user'"); 
        $stmt3->execute();	 
 
        $stmt4 = $conecta->prepare("DELETE FROM chest WHERE Owner='$registrado->user'"); 
        $stmt4->execute();		 
 
        $stmt5 = $conecta->prepare("DELETE FROM buddylist WHERE Id='$registrado->user' OR Buddy='$registrado->user'"); 
        $stmt5->execute();			 
		 
        $stmt6 = $conecta->prepare("DELETE FROM collection WHERE User='$registrado->user'"); 
        $stmt6->execute();	 
		 
        $stmt7 = $conecta->prepare("DELETE FROM eventlog WHERE Id='$registrado->user'"); 
        $stmt7->execute();	 
		 
        $stmt8 = $conecta->prepare("DELETE FROM gp_estabilizador WHERE ID='$registrado->user'"); 
        $stmt8->execute();	 
 
        $informacao = '<div class="removido">Informa&ccedil;&otilde;es removidas com sucesso!</div>'; 
    } 
	 
	   if ($permissao == "2") { 
		$userperm = "AND `permissao` != 1"; 
	    } 
		 
	$dados = $conecta->query("SELECT * FROM $banco WHERE _id_='$_GET[id]'$userperm");	 
    //$dados = $conecta->query("SELECT * FROM $banco WHERE _id_='$_GET[id]'"); 
    $dados = $dados->fetch(PDO::FETCH_OBJ); 
    if ($dados->_id_ != $_GET[id] AND $_GET[acao] != "remover") { 
        $informacao = '<div class="removido">O item que est&aacute; tentando editar n&atilde;o existe!</div>'; 
        echo "<meta http-equiv='refresh' content='5;URL=" . $uportal . "admin/" . $olink . "'>"; 
    } 
 
    echo '<script language="Javascript"> 
function confirmacao(ident) { 
var resposta = confirm("Deseja remover esse registro?"); 
if (resposta == true) { 
window.location.href = "'; 
    echo $uportal; 
    echo 'admin/remover/'; 
    echo $olink; 
    echo '/"+ident; 
} 
} 
</script> 
<div class="titulo-pagina">'; 
    if (empty($_GET[id])) { 
        echo "Cadastrar"; 
    } else { 
        echo "Alterar"; 
    } 
    echo ' '.$pagina.'</div> 
'.$informacao.' 
<form action="'; 
    if ($_GET[id] != "") { 
        $linkform = "" . $uportal . "admin/editar/" . $olink . "/" . $_GET[id] . ""; 
    } else { 
        $linkform = "" . $uportal . "admin/" . $olink . ""; 
    } 
    echo $linkform; 
    echo '" method="post" enctype="multipart/form-data" name="FORMULARIO"> 
<input name="acao" type="hidden" value="'; 
    if (empty($_GET[id])) { 
        echo "insert"; 
    } else { 
        echo "update"; 
    } 
    echo '"> 
<input name="foto_antiga" type="hidden" value="'; 
    echo $dados->foto; 
    echo '"> 
 
<div class="pos-sessao"> 
<div class="tt-sessao"><b>Informa&ccedil;&otilde;es</b></div> 
<div class="pos-sessao2"> 
 
<div class="sessao-item"> 
<span><b>Nome:</b></span> 
<p><input name="nome" type="text" value="'; 
    echo $dados->nome; 
 
    echo '" class="o-text" required></p> 
</div> 
 
<div class="sessao-item" style="width: 45%;"> 
<span><b>Login:</b></span> 
<p><input name="user" type="text" value="'; 
    echo $dados->user; 
 
    echo '" class="o-text" required readonly></p> 
</div> 
 
<div class="sessao-item" style="width: 50%;margin-left: 5%;"> 
<span><b>NickName:</b></span> 
<p><input name="nickname" type="text" value="'; 
    echo $dados->NickName; 
 
    echo '" class="o-text" required></p> 
</div> 
 
<div class="sessao-item"> 
<span><b>Senha:</b></span> 
<p><input name="password" type="password" value="'; 
    echo $dados->Password; 
 
    echo '" class="o-text" required></p> 
</div> 
 
 
<div class="sessao-item"> 
<span><b>E-mail:</b></span> 
<p><input name="email" type="text" value="'; 
    echo $dados->E_Mail; 
 
    echo '" class="o-text" required></p> 
</div> 
 
<div class="sessao-item"  style="width: 18%;"> 
<span><b>Gnero:</b></span> 
<p><select name="gender" class="select"> 
'; 
    $gender = array( 
        0 => 'Masculino', 
        1 => 'Feminino' 
    ); 
    foreach ($gender as $key => $value) { 
        echo '<option value="' . $key . '" '; 
        if ($key == $dados->Gender) { 
            echo "selected"; 
        } 
        echo '>' . $value . '</option>'; //close your tags!! 
    } 
    echo ' 
</select></p> 
</div> 
 
<div class="sessao-item"  style="width: 35%;"> 
<span><b>Pas:</b></span> 
<p><select name="country" class="select"> 
'; 
    $country = array( 
        1 => 'Afghanistan', 
        2 => 'Albania', 
        3 => 'Algeria', 
        4 => 'Andorra', 
        5 => 'Angola', 
        6 => 'Anguilla', 
        7 => 'Antarctica', 
        8 => 'Antigua and Barbuda', 
        9 => 'Argentina', 
        10 => 'Armenia', 
        11 => 'Aruba', 
        12 => 'Australia', 
        13 => 'Austria', 
        14 => 'Azerbaijan', 
        15 => 'Bahamas', 
        16 => 'Bahrain', 
        17 => 'Bangladesh', 
        18 => 'Barbados', 
        19 => 'Belgium', 
        20 => 'Belize', 
        21 => 'Belarus', 
        22 => 'Benin', 
        23 => 'Bermuda', 
        24 => 'Bhutan', 
        25 => 'Bolivia', 
        26 => 'Bosnia and Herzegovina', 
        27 => 'Botswana', 
        28 => 'Brasil', 
        29 => 'Brunei', 
        30 => 'Bulgaria', 
        31 => 'Burkina Faso', 
        32 => 'Burundi', 
        33 => 'Cambodia', 
        34 => 'Cameroon', 
        35 => 'Canada', 
        36 => 'Cape Verde', 
        37 => 'Cayman Islands', 
        38 => 'Central African Republic', 
        39 => 'Chile', 
        40 => "People's Rep. of China", 
        41 => 'Christmas Island', 
        42 => 'Colombia', 
        43 => 'Comoros', 
        44 => 'Congo', 
        45 => 'Democratic Republic of the Congo', 
        46 => 'Cook Islands', 
        47 => 'Costa Rica', 
        48 => "Cote D'Ivoire", 
        49 => 'Croatia', 
        50 => 'Cuba', 
        51 => 'Cyprus', 
        52 => 'Czech Republic', 
        53 => 'Denmark', 
        54 => 'Djibouti', 
        55 => 'Dominica', 
        56 => 'Dominican Republic', 
        57 => 'Equador', 
        58 => 'Egypt', 
        59 => 'El Salvador', 
        60 => 'Equatorial Guinea', 
        61 => 'Eritrea', 
        62 => 'Estonia', 
        63 => 'Ethiopia', 
        64 => 'Falkland Islands', 
        65 => 'Fiji', 
        66 => 'Finland', 
        67 => 'France', 
        68 => 'French Guiana', 
        69 => 'French Polynesia', 
        70 => 'Gabon', 
        71 => 'Gambia', 
        72 => 'Germany', 
        73 => 'Georgia', 
        74 => 'S. Georgia and the S. Sandwich Is.', 
        75 => 'Ghana', 
        76 => 'Greece', 
        77 => 'Greenland', 
        78 => 'Grenada', 
        79 => 'Guadeloupe', 
        80 => 'Guam', 
        81 => 'Guatemala', 
        82 => 'Guinea', 
        83 => 'Guinea-Bissau', 
        84 => 'Guyana', 
        85 => 'Haiti', 
        86 => 'Honduras', 
        87 => 'Hong Kong', 
        88 => 'Hungary', 
        89 => 'Iceland', 
        90 => 'India', 
        91 => 'Indonesia', 
        92 => 'Iran', 
        93 => 'Iraq', 
        94 => 'Ireland', 
        95 => 'Israel', 
        96 => 'Italy', 
        97 => 'Jamaica', 
        98 => 'Japan', 
        99 => 'Jordan', 
        100 => 'Kazakhstan', 
        101 => 'Kenya', 
        102 => 'Kiribati', 
        103 => 'Kitts and Nevis', 
        104 => 'North Korea', 
        105 => 'South Korea', 
        106 => 'Kyrgyzstan', 
        107 => 'Kuwait', 
        108 => 'Laos', 
        109 => 'Latvia', 
        110 => 'Lebanon', 
        111 => 'Lesotho', 
        112 => 'Liberia', 
        113 => 'Libya', 
        114 => 'Liechtenstein', 
        115 => 'Lithuania', 
        116 => 'Luxembourg', 
        117 => 'Macau', 
        118 => 'Macedonia', 
        119 => 'Madagascar', 
        120 => 'Malaysia', 
        121 => 'Maldives', 
        122 => 'Mali', 
        123 => 'Marshall Islands', 
        124 => 'Malta', 
        125 => 'Northern Mariana Islands', 
        126 => 'Malawi', 
        127 => 'Martinique', 
        128 => 'Mauritania', 
        129 => 'Mauritius', 
        130 => 'Mayotte', 
        131 => 'Mexico', 
        132 => 'Micronesia', 
        133 => 'Moldova', 
        134 => 'Mongolia', 
        135 => 'Montserrat', 
        136 => 'Morocco', 
        137 => 'Mozambique', 
        138 => 'Myanmar', 
        139 => 'Namibia', 
        140 => 'Nauru', 
        141 => 'Nepal', 
        142 => 'Netherlands', 
        143 => 'Netherlands Antilles', 
        144 => 'New Caledonia', 
        145 => 'New Zealand', 
        146 => 'Nicaragua', 
        147 => 'Niger', 
        148 => 'Nigeria', 
        149 => 'Niue', 
        150 => 'Norway', 
        151 => 'Oman', 
        152 => 'Pakistan', 
        153 => 'Palau', 
        154 => 'Panama', 
        155 => 'Papua New Guinea', 
        156 => 'Paraguay', 
        157 => 'Peru', 
        158 => 'Philippines', 
        159 => 'Pitcairn Island', 
        160 => 'Poland', 
        161 => 'Portugal', 
        162 => 'Puerto Rico', 
        163 => 'Qatar', 
        164 => 'Reunion', 
        165 => 'Romania', 
        166 => 'Russia', 
        167 => 'Rwanda', 
        168 => 'Saint Lucia', 
        169 => 'Saint Vincent and the Grenadines', 
        170 => 'Samoa-American', 
        171 => 'Samoa-Western', 
        172 => 'San Marino', 
        173 => 'Sao Tome and Principe', 
        174 => 'Saudi Arabia', 
        175 => 'Senegal', 
        176 => 'Seychelles', 
        177 => 'Sierra Leone', 
        178 => 'Singapore', 
        179 => 'Slovakia', 
        180 => 'Slovenia', 
        181 => 'Solomon Islands', 
        182 => 'Somalia', 
        183 => 'South Africa', 
        184 => 'Spain', 
        185 => 'Sri Lanka', 
        186 => 'Sudan', 
        187 => 'Suriname', 
        188 => 'Swaziland', 
        189 => 'Sweden', 
        190 => 'Switzerland', 
        191 => 'Syria', 
        192 => 'Taiwan', 
        193 => 'Tajikistan', 
        194 => 'Tanzania', 
        195 => 'Thailand', 
        196 => 'Togo', 
        197 => 'Tonga', 
        198 => 'Trinidad and Tobago', 
        199 => 'Tunisia', 
        200 => 'Turkey', 
        201 => 'Turkmenistan', 
        202 => 'Tuvalu', 
        203 => 'Uganda', 
        204 => 'Ukraine', 
        205 => 'United Arab Emirates', 
        206 => 'United Kingdom', 
        207 => 'USA', 
        208 => 'Uruguay', 
        209 => 'Uzbekistan', 
        210 => 'Vanuatu', 
        211 => 'Vatican City', 
        212 => 'Venezuela', 
        213 => 'Virgin Islands', 
        214 => 'Vietnam', 
        215 => 'Western Sahara', 
        216 => 'Yemen', 
        217 => 'Yugoslavia', 
        218 => 'Zambia', 
        219 => 'Zimbabwe', 
        220 => 'APO', 
        221 => 'FPO', 
        222 => 'Other', 
        223 => 'Bouvet Island', 
        224 => 'British Indian Ocean Territory', 
        225 => 'Chad', 
        226 => 'Cocos(Keeling) Islands', 
        227 => 'East Timor', 
        228 => 'Faroe Islands', 
        229 => 'French Southern Territories', 
        230 => 'Gibraltar', 
        231 => 'Heard and McDonald Islands', 
        232 => 'Monaco', 
        233 => 'Norfolk Island', 
        234 => 'Saint Helena', 
        235 => 'Saint Pierre and Miquelon', 
        236 => 'Svalbard and Jan Mayen Islands', 
        237 => 'Tokelau', 
        238 => 'Turks and Caicos Islands', 
        239 => 'United States Minor Outlying Islands', 
        240 => 'Wallis and Futuna', 
        241 => 'British Virgin Islands' 
    ); 
    foreach ($country as $key1 => $value1) { 
        echo '<option value="' . $key1 . '" '; 
        if ($key1 == $dados->Country) { 
            echo "selected"; 
        } 
        echo '>' . $value1 . '</option>'; //close your tags!! 
    } 
    echo ' 
</select></p> 
</div> 
 
<div class="sessao-item" style="width: 47%;"> 
<span><b>Data de Nascimento:</b></span> 
<p><input name="dia" type="text" value="'; 
    echo substr($dados->birthday, 0, 2); 
 
    echo '" class="o-text" style="width: 10%;" required>-<input name="mes" type="text" value="'; 
    echo substr($dados->birthday, 3, 2); 
 
    echo '" class="o-text" style="width: 10%;" required>-<input name="ano" type="text" value="'; 
    echo substr($dados->birthday, 6, 4); 
 
    echo '" class="o-text" style="width: 15%;" required></p> 
</div> 
 
<div class="sessao-item"  style="width: 36%;"> 
<span><b>Pergunta Secreta:</b></span> 
<p><select name="pergunta" class="select"> 
'; 
    $pergunta = array( 
        0 => 'Por favor, escolha uma pergunta.', 
        1 => 'Qual cidade voc nasceu?', 
        2 => 'Quais so os nomes de seus pais?', 
        3 => 'Qual  o nome de seu primeiro colgio?', 
        4 => 'Nome de seu animal de estimao?', 
        5 => 'Qual  o nome de seus avs?', 
        6 => 'Qual  seu mascote do colgio?' 
    ); 
    foreach ($pergunta as $key2 => $value2) { 
        echo '<option value="' . $key2 . '" '; 
        if ($key2 == $dados->Pergunta) { 
            echo "selected"; 
        } 
        echo '>' . $value2 . '</option>'; //close your tags!! 
    } 
    echo ' 
</select></p> 
</div> 
 
<div class="sessao-item" style="width: 63%; margin-left: 1%;"> 
<span><b>Resposta Secreta:</b></span> 
<p><input name="resposta" type="text" value="'; 
    echo $dados->Resposta; 
 
    echo '" class="o-text" required></p> 
</div> 
 
 
</div> 
</div> 
 
<div class="pos-sessao"> 
<div class="tt-sessao"><b>Foto</b></div> 
<div class="pos-sessao2"> 
<div class="pos-img" style="width: 150px; height: 85px;"> 
<img src="'; 
    if ($dados->foto != "") { 
        $logo = "" . $uportal . "img/" . $dados->foto . ""; 
    } else { 
        $logo = "" . $uportal . "img/sem-foto.jpg"; 
    } 
    echo $logo; 
 
    echo '" class="img-logo" style="width: 85px;height: 85px;background: #000000;" /> 
</div> 
'; 
    if (empty($dados->foto)) { 
     
        echo '<div class="trocar-img"> 
<p style="margin-top: 25px;"><input name="foto" id="foto" type="file" /></p> 
</div> 
'; 
    } else { 
     
        echo '<div class="trocar-img"> 
<p style="margin-bottom: 5px; font-size: 15px;"><b>Trocar foto?</b></p> 
<p><input type="radio" name="nova_foto" id="N" value="N" onclick="javascript:DesabilitarFoto3()" checked/> 
<label for="N"> 
<span>N&Atilde;O</span> 
</label> 
<input type="radio" name="nova_foto" id="S" value="S" onclick="javascript: HabilitarFoto3();"/> 
<label for="S"> 
<span>SIM</span> 
</label></p> 
<p><input name="foto" id="foto" type="file" disabled="disabled" /></p> 
</div> 
'; 
    } 
 
    echo '</div> 
</div>'; 
 
if ($permissao == "1") { 
	echo' 
<div class="pos-sessao"> 
<div class="tt-sessao"><b>Permiss&otilde;es</b></div> 
<div class="pos-sessao2"> 
 
<div class="env" style="margin: 10px 0;"> 
<p style="margin-bottom: 5px;"><b>Tipo de usu&aacute;rio e permiss&otilde;es:</b></p> 
<p><input type="radio" name="apermissao" onclick="javascript: Permissoeson();" value="1" id="1" '; 
    if ($dados->permissao == "1") { 
        echo "checked"; 
    } 
 
    echo '/> 
<label for="1"> 
<span>ADMINISTRADOR</span> 
</label> 
 
<input type="radio" name="apermissao" onclick="javascript:Permissoesoff()" value="2" id="2" '; 
    if (!$_GET[id]) { 
        echo "checked"; 
    } 
    if ($dados->permissao == "2") { 
        echo "checked"; 
    } 
 
    echo '/> 
<label for="2"> 
<span>USU&Aacute;RIO AVAN&Ccedil;ADO</span> 
</label></p> 
</div> 
 
<div id="permissoes" class="'; 
    if ($dados->permissao == "1") { 
        echo "administrador"; 
    } else { 
        echo "avancado"; 
    } 
 
    echo '"> 
 
<div class="sessao-item" style="width: 96%; padding: 2%; background: #f5f5f5;"> 
<span style="margin-bottom: 5px;"><b>P&aacute;ginas dinamicas:</b></span> 
<div class="env"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
'; 
    $opc     = $conecta->query("SELECT * FROM menu_admin WHERE status='S' AND tipo='D' ORDER by posicao"); 
    $total   = $opc->rowCount(); 
    $colunas = "3"; 
    if ($total > 0) { 
        for ($i = 0; $i < $total; $i++) { 
            if (($i % $colunas) == 0) { 
                $colspan = $colunas + $colunas + $colunas; 
             
                echo '<tr> 
'; 
            } 
            $dados2 = $opc->fetch(PDO::FETCH_OBJ); 
         
            echo '<td align="left" valign="top" style="float: left; background: #E0E0E0; width: 29%; margin: 1%; padding: 1%;">'; 
            $op = explode("|", $dados->paginas); 
         
            echo '<div class="float: left; width: 100%; background: #fff;"> 
<p><b>'; 
            echo $dados2->nome; 
         
            echo '</b></p> 
'; 
            $sqlsub = $conecta->query("SELECT * FROM menu_admin WHERE status='S' AND sub='$dados2->id' ORDER BY posicao"); 
            while ($dadossub = $sqlsub->fetch(PDO::FETCH_OBJ)) { 
             
                echo '<p><input name=\'paginas[]\' type=\'checkbox\' value=\''; 
                echo $dadossub->id; 
             
                echo '|'; 
                echo $dados2->id; 
             
                echo '\' '; 
                echo in_array($dadossub->id, $op) ? 'checked' : ''; 
             
                echo '> '; 
                echo $dadossub->nome; 
             
                echo '</p> 
'; 
            } 
         
            echo '</div> 
</td> 
'; 
        } 
    } 
 
    echo '</tr> 
</table> 
</div> 
</div> 
 
<div class="sessao-item" style="width: 96%; padding: 2%; background: #f5f5f5;"> 
<span style="margin-bottom: 5px;"><b>P&aacute;ginas estaticas:</b></span> 
<div class="env"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
'; 
    $opc     = $conecta->query("SELECT * FROM menu_admin WHERE NOT id='45' AND status='S' AND tipo='S' AND submenu='N' ORDER by posicao"); 
    $total   = $opc->rowCount(); 
    $colunas = "3"; 
    if ($total > 0) { 
        for ($i = 0; $i < $total; $i++) { 
            if (($i % $colunas) == 0) { 
                $colspan = $colunas + $colunas + $colunas; 
             
                echo '<tr> 
'; 
            } 
            $dados2 = $opc->fetch(PDO::FETCH_OBJ); 
         
            echo '<td align="left" valign="top">'; 
            $op = explode("|", $dados->paginas); 
         
            echo '<input name=\'paginas[]\' type=\'checkbox\' value=\''; 
            echo $dados2->id; 
         
            echo '\' '; 
            echo in_array($dados2->id, $op) ? 'checked' : ''; 
         
            echo '> 
'; 
            echo $dados2->nome; 
         
            echo '<br /></td> 
'; 
        } 
    } 
 
    echo '</tr> 
</table> 
</div> 
</div> 
 
<div class="sessao-item" style="width: 96%; padding: 2%; background: #f0f0f0;"> 
<span style="margin-bottom: 5px;"><b>Categorias de noticias:</b></span> 
<div class="env"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
'; 
    $opc1     = $conecta->query("SELECT * FROM noticias_cat WHERE status='S' ORDER by nome"); 
    $total1   = $opc1->rowCount(); 
    $colunas1 = "3"; 
    if ($total1 > 0) { 
        for ($i = 0; $i < $total1; $i++) { 
            if (($i % $colunas1) == 0) { 
                $colspan1 = $colunas1 + $colunas1 + $colunas1; 
             
                echo '<tr> 
'; 
            } 
            $dados1 = $opc1->fetch(PDO::FETCH_OBJ); 
         
            echo '<td align="left" valign="top">'; 
            $op1 = explode("|", $dados->categorias); 
         
            echo '<input name=\'categorias[]\' type=\'checkbox\' value=\''; 
            echo $dados1->id; 
         
            echo '\' '; 
            echo in_array($dados1->id, $op1) ? 'checked' : ''; 
         
            echo '> 
'; 
            echo $dados1->nome; 
         
            echo '<br /></td> 
'; 
        } 
    } 
 
    echo '</tr> 
</table> 
</div> 
</div> 
 
<div class="sessao-item" style="width: 96%; padding: 2%; background: #ebebeb;"> 
<span style="margin-bottom: 5px;"><b>Destaques de noticias:</b></span> 
<div class="env"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
'; 
    $opc2     = $conecta->query("SELECT * FROM destino_cat WHERE status='S' ORDER by nome"); 
    $total2   = $opc2->rowCount(); 
    $colunas2 = "3"; 
    if ($total2 > 0) { 
        for ($i = 0; $i < $total2; $i++) { 
            if (($i % $colunas2) == 0) { 
                $colspan2 = $colunas2 + $colunas2 + $colunas2; 
             
                echo '<tr> 
'; 
            } 
            $dados3 = $opc2->fetch(PDO::FETCH_OBJ); 
         
            echo '<td align="left" valign="top">'; 
            $op2 = explode("|", $dados->destinos); 
         
            echo '<input name=\'destinos[]\' type=\'checkbox\' value=\''; 
            echo $dados3->id; 
         
            echo '\' '; 
            echo in_array($dados3->id, $op2) ? 'checked' : ''; 
         
            echo '> 
'; 
            echo $dados3->nome; 
         
            echo '<br /></td> 
'; 
        } 
    } 
 
    echo '</tr> 
</table> 
</div> 
</div> 
 
<div class="sessao-item" style="width: 96%; padding: 2%; background: #ebebeb;"> 
<span style="margin-bottom: 5px;"><b>Blogs e colunas:</b></span> 
<div class="env"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
'; 
    $opc2     = $conecta->query("SELECT * FROM colunas WHERE status='S' ORDER by nome"); 
    $total2   = $opc2->rowCount(); 
    $colunas2 = "3"; 
    if ($total2 > 0) { 
        for ($i = 0; $i < $total2; $i++) { 
            if (($i % $colunas2) == 0) { 
                $colspan2 = $colunas2 + $colunas2 + $colunas2; 
             
                echo '<tr> 
'; 
            } 
            $dados3 = $opc2->fetch(PDO::FETCH_OBJ); 
         
            echo '<td align="left" valign="top">'; 
            $op2 = explode("|", $dados->colunas); 
         
            echo '<input name=\'colunas[]\' type=\'checkbox\' value=\''; 
            echo $dados3->id; 
         
            echo '\' '; 
            echo in_array($dados3->id, $op2) ? 'checked' : ''; 
         
            echo '> 
'; 
            echo $dados3->nome; 
         
            echo '<br /></td> 
'; 
        } 
    } 
 
    echo '</tr> 
</table> 
</div> 
</div> 
 
<div class="sessao-item" style="width: 96%; padding: 2%; background: #d9d9d9;"> 
<span style="margin-bottom: 5px;"><b>Locais de anuncios:</b></span> 
<div class="env"> 
<table width="100%" border="0" cellpadding="2" cellspacing="0"> 
'; 
    $opc3     = $conecta->query("SELECT * FROM anuncios_locais WHERE status='S' ORDER by nome"); 
    $total3   = $opc3->rowCount(); 
    $colunas3 = "3"; 
    if ($total3 > 0) { 
        for ($i = 0; $i < $total3; $i++) { 
            if (($i % $colunas3) == 0) { 
                $colspan3 = $colunas3 + $colunas3 + $colunas3; 
             
                echo '<tr> 
'; 
            } 
            $dados4 = $opc3->fetch(PDO::FETCH_OBJ); 
         
            echo '<td align="left" valign="top">'; 
            $op3 = explode("|", $dados->anuncios); 
         
            echo '<input name=\'anuncios[]\' type=\'checkbox\' value=\''; 
            echo $dados4->id; 
         
            echo '\' '; 
            echo in_array($dados4->id, $op3) ? 'checked' : ''; 
         
            echo '> 
'; 
            echo $dados4->nome; 
         
            echo '<br /></td> 
'; 
        } 
    } 
 
    echo '</tr> 
</table> 
</div> 
</div> 
 
</div> 
 
</div> 
</div>'; } echo' 
<div style="float: left; width: 100%;"> 
<input type="submit" value="'; 
    if ($_GET[id] != "") { 
        echo "Alterar"; 
    } else { 
        echo "Cadastrar"; 
    } 
 
    echo '" /> 
</div> 
</form> 
 
<div class="box-pesq"> 
<span>Filtrar resultados</span> 
<form id="busca" name="busca" method="get" action="'; 
    echo $uportal; 
 
    echo 'admin/index.php#condicao" cept-charset="UTF-8"> 
<input type="hidden" name="pg" value="'; 
    echo $olink; 
 
    echo '"> 
<input name="condicao" type="search" id="condicao" placeholder=" Digite o nome..." class="pesquisa-box" value="'; 
    echo $_GET[condicao]; 
 
    echo '"> 
<input id="pesquisafsm-botao" type="submit" value="Buscar" /> 
</form> 
</div> 
'; 
    $condicao = str_replace("
", "", $_GET[condicao]); 
    $condicao = iconv('UTF-8', 'ISO-8859-1//TRANSLIT', $_GET[condicao]); 
    if ($_GET[condicao] != "") { 
	   if ($permissao == "2") { 
		$perm = ", `permissao` != 1"; 
	    }	 
        $coluna = "WHERE name LIKE '%$_GET[condicao]%' $perm"; 
    } elseif ($permissao == "2") { 
		$coluna = "WHERE `permissao` != '1'"; 
	} 
	 
 
 
	 
    $busca     = "SELECT * FROM $banco $coluna order by _id_ asc"; 
    $total_reg = "20"; 
    $page      = "$_GET[page]"; 
    if (!$page) { 
        $page = "1"; 
    } 
    $inicio = $page - 1; 
    $inicio = $inicio * $total_reg; 
    $select = $conecta->query("$busca LIMIT $inicio,$total_reg"); 
    $tr     = $conecta->query("$busca"); 
    $tr     = $tr->rowCount(); 
    $tp     = ceil($tr / $total_reg); 
 
    echo '<a name="condicao"></a> 
<div class="titulo-pagina" style="margin: 20px 0; font-size: 15px;">Foram encontrados <b>'; 
    echo $tr; 
 
    echo '</b> registros.</div> 
<table width="100%" class="bordasimples"> 
 
<tr> 
<td width="8%" align="left" style="background: #999999; color: #ffffff; font-size: 16px; padding: 10px; font-family: Lato;"><b>ID</b></td> 
<td width="20%" align="left" style="background: #999999; color: #ffffff; font-size: 16px; padding: 10px; font-family: Lato;"><b>LOGIN</b></td> 
<td width="20%" align="left" style="background: #999999; color: #ffffff; font-size: 16px; padding: 10px; font-family: Lato;"><b>NICKNAME</b></td> 
<td width="40%" align="left" style="background: #999999; color: #ffffff; font-size: 16px; padding: 10px; font-family: Lato;"><b>EMAIL</b></td> 
<td align="left" style="background: #999999; color: #ffffff; font-size: 16px; padding: 10px; font-family: Lato;"><b>A&Ccedil;&Otilde;ES</b></td> 
</tr> 
'; 
    $i = 0; 
    while ($dados = $select->fetch(PDO::FETCH_OBJ)) { 
        if (($i % 2) == 0) { 
            $bgcolor = "#FFFFFF"; 
        } else { 
            $bgcolor = "#e5e5e5"; 
        } 
        echo '<tr> 
<td bgcolor="'.$bgcolor.'">'.$dados->_id_.'</td> 
<td bgcolor="'.$bgcolor.'"><b>'.$dados->user.'</b></td> 
<td bgcolor="'.$bgcolor.'"><b>'.$dados->NickName.'</b></td> 
<td bgcolor="'.$bgcolor.'"><b>'.$dados->E_Mail.'</b></td> 
<td align="center" bgcolor="'.$bgcolor.'">'; 
    if ($permissao == "1") { 
        if ($dados->Status == "S") { 
            echo '<a href="'.$uportal.'admin/status/'.$olink.'/'.$dados->_id_.'/desativar#condicao" title="Clique para desativar este item"><span class="icon-onoff ic-on"></span></a>'; 
        } else { 
            echo '<a href="'.$uportal.'admin/status/'.$olink.'/'.$dados->_id_.'/ativar#condicao" title="Clique para ativar este item"><span class="icon-onoff ic-off"></span></a>'; 
        } 
    } 
        echo '<a href="'.$uportal.'admin/editar/'.$olink.'/'.$dados->_id_.'" title="Clique para editar este item"><span class="icon-edit"></span></a> 
<a href="javascript:func()"onclick="confirmacao(\''.$dados->_id_.'\')" title="Clique para remover este item"><span class="icon-remove"></span></a> 
</td> 
</tr>'; 
        $i++; 
    } 
    echo '</table> 
 
<div class="env" style="margin: 20px 0;"> 
<div class="paginacao"> 
'; 
    if ($page > 1) { 
        $anterior = $page - 1; 
        if ($_GET[condicao] != "") { 
            $url = "" . $uportal . "admin/index.php?pg=" . $olink . "&condicao=" . $_GET[condicao] . "&page=" . $anterior . "#condicao"; 
        } else { 
            $url = "" . $uportal . "admin/index.php?pg=" . $olink . "&page=" . $anterior . "#condicao"; 
        } 
        echo "<a href='$url' class='opc'><span class='tx-pg'>&laquo; Anterior</span></a>"; 
    } else { 
        echo "<span class='tx-pg fim-pg' style='cursor: not-allowed;'>&laquo; Anterior</span>"; 
    } 
    for ($i = 1; $i < $page; $i++) 
        if ($i >= $page - 3) 
            if ($_GET[condicao] != "") { 
                echo "<a href='" . $uportal . "admin/index.php?pg=" . $olink . "&condicao=" . $_GET[condicao] . "&page=" . $i . "#condicao' class='opc'><span class='pg-px'>$i</span></a>"; 
            } else { 
                echo "<a href='" . $uportal . "admin/index.php?pg=" . $olink . "&page=" . $i . "#condicao' class='opc'><span class='pg-px'>$i</span></a>"; 
            } 
    echo "<span class='pg-at'>$page</span>"; 
    for ($i = $page + 1; $i <= $tp; $i++) 
        if ($i <= $page + 3) 
            if ($_GET[condicao] != "") { 
                echo "<a href='" . $uportal . "admin/index.php?pg=" . $olink . "&condicao=" . $_GET[condicao] . "&page=" . $i . "#condicao' class='opc'><span class='pg-px'>$i</span></a>"; 
            } else { 
                echo "<a href='" . $uportal . "admin/index.php?pg=" . $olink . "&page=" . $i . "#condicao' class='opc'><span class='pg-px'>$i</span></a>"; 
            } 
    if ($tp > $page) { 
        $proxima = $page + 1; 
        if ($_GET[condicao] != "") { 
            $url = "" . $uportal . "admin/index.php?pg=" . $olink . "&condicao=" . $_GET[condicao] . "&page=" . $proxima . "#condicao"; 
        } else { 
            $url = "" . $uportal . "admin/index.php?pg=" . $olink . "&page=" . $proxima . "#condicao"; 
        } 
        echo "<a href='$url' class='opc'><span class='tx-pg'>Pr&oacute;xima &raquo;</span></a>"; 
    } else { 
        echo "<span class='tx-pg fim-pg' style='cursor: not-allowed;'>Pr&oacute;xima &raquo;</font>"; 
    } 
 
    echo '</div> 
</div> 
</div>'; 
} 
?>