Disallow Dual Login/IP/Account and allow Autotrade for this case

[Tales]

Hi guys!
I use this code to prevent my events to run for "dual player's".
 

.@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;
}

Do you have know some way to check if the .@query_result gets a Autotrade user?

Some ways, my players are using dual account for Merchant and other for Player...can you help me?

Edited August 4, 2015 by Tales

[Emistry]

try

query_sql( "SELECT `login`.`account_id` FROM `login` INNER JOIN `char` ON `char`.`account_id` = `login`.`account_id` WHERE `last_ip` = '"+escape_sql( getcharip() )+"' AND `char`.`online` = 1 AND `login`.`account_id` NOT IN ( SELECT `account_id` FROM `autotrade_merchants` )",.@count );
if ( .@count >= 2 ) {
	mes "You cant dual login from same IP.";
	sleep2 5000;
	atcommand "@kick "+strcharinfo(0);
}
end;

[iraciz]

: DB error - Table 'ragnarok.autotrade_merchants' doesn't exist

	[Debug]: at C:\Users\Mario Zicari\Desktop\rAthena\src\map\script.cpp:16996 - SELECT `login`.`account_id` FROM `login` INNER JOIN `char` ON `char`.`account_id` = `login`.`account_id` WHERE `last_ip` = '127.0.0.1' AND `char`.`online` = 1 AND `login`.`account_id` NOT IN ( SELECT `account_id` FROM `autotrade_merchants` )

	[Debug]: Source (NPC): Only1perIP (invisible/not on a map)

[Emistry]

change 

query_sql( "SELECT `login`.`account_id` FROM `login` INNER JOIN `char` ON `char`.`account_id` = `login`.`account_id` WHERE `last_ip` = '"+escape_sql( getcharip() )+"' AND `char`.`online` = 1 AND `login`.`account_id` NOT IN ( SELECT `account_id` FROM `autotrade_merchants` )",.@count );

to

query_sql( "SELECT `login`.`account_id` FROM `login` INNER JOIN `char` ON `char`.`account_id` = `login`.`account_id` WHERE `last_ip` = '"+escape_sql( getcharip() )+"' AND `char`.`online` = 1 AND `login`.`account_id` NOT IN ( SELECT `account_id` FROM `vendings` )",.@count );

 

[jimboy092032]

I tried this one but I'm using proxy they have all same last login ip how to fix this one even you have ip proxy ? 

[LearningRO]

On 5/23/2023 at 2:14 AM, jimboy092032 said:

I tried this one but I'm using proxy they have all same last login ip how to fix this one even you have ip proxy ? 

use gepard Unique_id if you used gepard

try this method

https://rathena.org/board/topic/117327-utility-mapusers-count-functions-ipgepard/

[jimboy092032]

On 5/25/2023 at 9:44 PM, LearningRO said:

use gepard Unique_id if you used gepard

try this method

https://rathena.org/board/topic/117327-utility-mapusers-count-functions-ipgepard/

Sorry I'm not using gepard

[LearningRO]

On 5/27/2023 at 10:11 AM, jimboy092032 said:

Sorry I'm not using gepard

so use other function base on IP already include on that link

[jimboy092032]

On 5/28/2023 at 8:37 PM, LearningRO said:

so use other function base on IP already include on that link

But I'm using proxy how am I able to do that? my ip are all same using proxy