Ir para conteúdo
Fórum Script Brasil

Umberto Colombini

Membros
  • Total de itens

    3
  • Registro em

  • Última visita

Posts postados por Umberto Colombini

  1. VALEU... MAS MUDOU O PROBLEMA...RSRS

    TA DIFICIL ISSSO AQUI

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/overtilt/public_html/login.php on line 27

    LOGIN.PHP

    <?
    function checklogin($array) {
        
        $usuario = $array["0"];
        $senha = $array["1"];
        $acao = $array["2"];
        include ("include/var.php");
        if ($acao == "logon") {
        
            if (isset($usuario) && isset($senha)) {
                $usuario = strtoupper($usuario);
                $senha = strtoupper($senha);
                $senha = encode($senha);
                $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("morto1");
                $data = mysql_select_db($dbdata);
                if (CalculaCPF($usuario)) {
                    $tb = "pessoa_fisica";
                }
                elseif(CalculaCNPJ($usuario)) {
                    $tb = "pessoa_juridica";
                }
                else {
                    $tb = "funcionario";
                }
                $query= "SELECT * FROM $tb WHERE login = "$usuario" AND senha = "$senha"";
                $query = mysql_query($query);
                $rows = mysql_num_rows($query);
                mysql_close($conn);
    
                if ($rows == 1) {
                    setcookie("user", "$usuario");
                    setcookie("nextthing", "$senha");
                    return "1";
                }
                if ($rows == 0) {
                    return "0";
                }
            }
        }
        if ($acao == "check") {
            if (isset($usuario) && isset($senha)) {
                $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("morto2");
                $data = mysql_select_db($dbdata);
                if (CalculaCPF($usuario)) {
                    $tb = "pessoa_fisica";
                }
                elseif(CalculaCNPJ($usuario)) {
                    $tb = "pessoa_juridica";
                }
                else {
                    $tb = "funcionario";
                }
                $query= "SELECT * FROM $tb WHERE login=$usuario AND senha=$senha";
                $query = mysql_query($query);
                $rows = mysql_num_rows($query);
                mysql_close($conn);
    
                if (($rows == 1) && ($tb == "funcionario")) {
                    $array = array();
                    $array['usuario'] = $usuario;
                    $array['senha'] = $senha;
                    $array['id_funcionario'] = mysql_result($query, 0, "id_funcionario");
                    $array['id_departamento'] = mysql_result($query, 0, "id_departamento");
                    $array['resp_departamento'] = mysql_result($query, 0, "resp_departamento");
                    $array['nome'] = getnome($query, 0);
                    $array['email'] = mysql_result($query, 0, "email");
                    $array['status'] = mysql_result($query, 0, "status");
                    $array['login'] = "1";
                    return $array;
                }
                else {
                    $array = array();
                    $array['usuario'] = $usuario;
                    $array['senha'] = $senha;
                    $array['tabela'] = $tb;
                    $array['id_tabela'] = mysql_result($query, 0, "id_$tb");
                    $array['nome'] = mysql_result($query, 0, "nome");
                    $array['email'] = mysql_result($query, 0, "email");
                    $array['status'] = "CLIENTE";
                    $array['login'] = "1";
                    return $array;
                }
                if ($rows == 0) {
                    setcookie("user", "");
                    setcookie("nextthing", "");
                }
            }
            else {
                setcookie("user", "");
                setcookie("nextthing", "");
            }
        }
    }
    ?>
    
    
    LOGAR.PHP
    <?
    include ("include/var.php");
    include ("include/functions.php");
    include ("include/class.php");
    include ("login.php");
    $acao = $_POST["acao"];
    $usuario = $_POST["usuario"];
    $senha = $_POST["senha"];
    
    if (isset($acao)) {
        if ($acao == "login") {
            if (isset($usuario) && isset($senha)) {
                $array = array($usuario,$senha,"logon");
                $login = checklogin($array);
            }
    
            if (isset($login)) {
                if ($login == "1") {
                    //Aqui entra a rotina de sucesso no login e envia a pessoa à uma nova página..
                    $usuario = strtoupper($usuario);
                    $senha = strtoupper($senha);
                    $senha = encode($senha);
                    $array = array($usuario,$senha,"check");
                    $globais = checklogin($array);
                    
                    $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("morto1");
                    $data = mysql_select_db($dbdata);
                    
                    //agora vai checar se existe manutenção preventiva pronta pra virar OS
                    
                    $os_preventiva = new os_preventiva();
                    $cincodias = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d")+5, date("Y")));
                    $listaop = $os_preventiva->getlista("datahora <= '".$cincodias."' AND idos = '0'");
                    
                    
                    if(sizeof($listaop) > 0){
                        foreach ($listaop as $linha){
                            $os = new os();
                            
                            $preventiva = new preventiva();
                            $preventiva->getdadosfromid($linha->getidpreventiva());
                            
                            $os->dt_prazo = $linha->getdatahora();
                            $os->from_tabela = $preventiva->gettabela();
                            $os->from_id_tabela = $preventiva->getid_tabela();
                            $os->id_prioridade = 6;
                            $os->to_id_departamento = 6;
                            $os->assunto = "Manutenção Preventiva";
                            $os->descricao = $preventiva->getdescricao();
                            $os->atendimento = "online";
                            $os->status = "nova";
                            
                            $os->contrato = new contrato();
                            $os->contrato->id_contrato = $preventiva->getid_contrato();
                            $os->insereos();
                            $os->inserelogos('', "OS <b>#".$os->id_os."</b> ABERTA COM O ASSUNTO: \"$os->assunto\"");
                            
                            $linha->setidos($os->id_os);
                            $linha->altera();
                        }
                    }
                    
                    
                    /////////////////////////////////////////////////////////////////////
                    
                    header("Location: principal.php");
                }
                else {
                    header("Location: index.php");
                }
            }
        }
        if ($acao != "login") {
            header ("Location: index.php");
        }
    }
    if (!isset($acao)) {
        $usuario = decode($HTTP_COOKIE_VARS["user"]);
        $senha = decode($HTTP_COOKIE_VARS["nextthing"]);
        $array = array($usuario,$senha,"check");
        $globais = checklogin($array);
    }
    ?>

  2. já FIZ DE TUDO E O ERRO CONTINUA!!! N SEI MAIS O Q FAZER... AGUARDO AJUDA!!!

    SITE: WWW.OVERTILT.INFO

    Parse error: syntax error, unexpected T_VARIABLE in /home/overtilt/public_html/login.php on line 25

    LOGIN.PHP

    <?
    function checklogin($array) {
        
        $usuario = $array["0"];
        $senha = $array["1"];
        $acao = $array["2"];
        include ("include/var.php");
        if ($acao == "logon") {
        
            if (isset($usuario) && isset($senha)) {
                $usuario = strtoupper($usuario);
                $senha = strtoupper($senha);
                $senha = encode($senha);
                $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("morto1");
                $data = mysql_select_db($dbdata);
                if (CalculaCPF($usuario)) {
                    $tb = "pessoa_fisica";
                }
                elseif(CalculaCNPJ($usuario)) {
                    $tb = "pessoa_juridica";
                }
                else {
                    $tb = "funcionario";
                }
                $query= "SELECT * FROM $tb WHERE login = "$usuario" AND senha = "$senha"";
                $query = mysql_query($query);
                $rows = mysql_num_rows($query);
                mysql_close($conn);
    
                if ($rows == 1) {
                    setcookie("user", "$usuario");
                    setcookie("nextthing", "$senha");
                    return "1";
                }
                if ($rows == 0) {
                    return "0";
                }
            }
        }
        if ($acao == "check") {
            if (isset($usuario) && isset($senha)) {
                $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("morto2");
                $data = mysql_select_db($dbdata);
                if (CalculaCPF($usuario)) {
                    $tb = "pessoa_fisica";
                }
                elseif(CalculaCNPJ($usuario)) {
                    $tb = "pessoa_juridica";
                }
                else {
                    $tb = "funcionario";
                }
                $query= "SELECT * FROM $tb WHERE login=$usuario AND senha=$senha";
                $query = mysql_query($query);
                $rows = mysql_num_rows($query);
                mysql_close($conn);
    
                if (($rows == 1) && ($tb == "funcionario")) {
                    $array = array();
                    $array['usuario'] = $usuario;
                    $array['senha'] = $senha;
                    $array['id_funcionario'] = mysql_result($query, 0, "id_funcionario");
                    $array['id_departamento'] = mysql_result($query, 0, "id_departamento");
                    $array['resp_departamento'] = mysql_result($query, 0, "resp_departamento");
                    $array['nome'] = getnome($query, 0);
                    $array['email'] = mysql_result($query, 0, "email");
                    $array['status'] = mysql_result($query, 0, "status");
                    $array['login'] = "1";
                    return $array;
                }
                else {
                    $array = array();
                    $array['usuario'] = $usuario;
                    $array['senha'] = $senha;
                    $array['tabela'] = $tb;
                    $array['id_tabela'] = mysql_result($query, 0, "id_$tb");
                    $array['nome'] = mysql_result($query, 0, "nome");
                    $array['email'] = mysql_result($query, 0, "email");
                    $array['status'] = "CLIENTE";
                    $array['login'] = "1";
                    return $array;
                }
                if ($rows == 0) {
                    setcookie("user", "");
                    setcookie("nextthing", "");
                }
            }
            else {
                setcookie("user", "");
                setcookie("nextthing", "");
            }
        }
    }
    ?>

×
×
  • Criar Novo...