How to check if the character are in Autotrade with mysql

[tmav94]

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

 

[evilpuncker]

not possible I guess, but if you try to explain what exactly you are trying to do we may think of another way of achieving it

 

[tmav94]

This is my security code to prevent player to enter in a Game Event with two accounts in the same ip
 

.@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", .@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; } 
But, some players are using autotrade...I won't count the Autotraders.

 

[mleo1]

Add this to your sql, not tested
 

....online=1 AND login.account_id NOT IN (SELECT account_id FROM autotrade_merchants WHERE account_id="+getcharid(3)+")"

 

[tmav94]

Its returns "-1" always... Any ideias?