Tales Posted August 4, 2015 Group: Members Topic Count: 163 Topics Per Day: 0.03 Content Count: 319 Reputation: 8 Joined: 02/05/12 Last Seen: January 11, 2016 Share Posted August 4, 2015 How? How to check if the character are in Autotrade with mysql Quote Link to comment Share on other sites More sharing options...
rayn Posted August 5, 2015 Group: Members Topic Count: 22 Topics Per Day: 0.00 Content Count: 164 Reputation: 55 Joined: 11/25/11 Last Seen: May 3, 2020 Share Posted August 5, 2015 Check if the character ID has 'autotrade' = 1 in table 'vendings' Quote Link to comment Share on other sites More sharing options...
Tales Posted August 5, 2015 Group: Members Topic Count: 163 Topics Per Day: 0.03 Content Count: 319 Reputation: 8 Joined: 02/05/12 Last Seen: January 11, 2016 Author Share Posted August 5, 2015 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Tales Posted August 10, 2015 Group: Members Topic Count: 163 Topics Per Day: 0.03 Content Count: 319 Reputation: 8 Joined: 02/05/12 Last Seen: January 11, 2016 Author Share Posted August 10, 2015 Bump? Quote Link to comment Share on other sites More sharing options...
Question
Tales
How? How to check if the character are in Autotrade with mysql
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.