How to check if the character are in Autotrade with mysql

[tmav94 1]

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

[evilpuncker 503]

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 1]

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 36]

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)+")"

Edited August 4, 2015 by mleo1

[tmav94 1]

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