How to check if the character are in Autotrade with mysql

[Tales]

How? How to check if the character are in Autotrade with mysql

[rayn]

Check if the character ID has 'autotrade' = 1 in table 'vendings'

[Tales]

It's not working...
This script aways show my Online Character and my Autotrade character.

dali,133,80,5 script TesteAutoTr 677,{




  .@query_result = query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE login.last_ip=(SELECT last_ip FROM login WHERE account_id="+getcharid(3)+") AND `char`.online=1 AND login.account_id NOT IN (SELECT account_id FROM vendings WHERE account_id="+getcharid(3)+")", .@account_id);
    
    if ( .@query_result > 1 && compare( $whiteList$,getcharid(3) +"" ) == 0 ) {
        mes "[AVISO]";
        mes "Você não poderá acessar as funções deste npc enquanto houverem mais de 1 conta conectada no mesmo IP. Foram encontrados "+ .@query_result +" registros.";
        end;
    }
    else {
     mes "Funcinou?";
     close;
    }




}

Edited August 5, 2015 by Tales

[Tales]

Bump?