Tdi123 Posted May 2 Share Posted May 2 (edited) ss Edited May 5 by Tdi123 Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted May 4 Share Posted May 4 may try this - script Sample -1,{ end; OnInit: // 1= if you have gepard 0=if you do not use gepard [email protected]_gepard = 1; setarray .map$, "quiz_00" , "prt_are_in" , "bat_c01" , "guild_vs2" , "ordeal_1-2" , "coliseum" , "ama_test" , "quiz_02" , "safari" , "niflheim" , "que_qsch01" , "[email protected]" , "[email protected]" , "p_track01" , "pvp_n_2-1"; [email protected]_size = getarraysize(.map$); for ([email protected] = 0; [email protected] < [email protected]_size; [email protected]++) setmapflag .map$[[email protected]], MF_LOADEVENT; .sql_field$ = ([email protected]_gepard ? "last_unique_id" : "last_ip"); end; OnPCLoadMapEvent: [email protected]$ = strcharinfo(3); if (inarray(.map$, [email protected]$) == -1) end; [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE `group_id` < 99"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` AND `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` AND `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; [email protected] = query_sql([email protected]$, [email protected]); [email protected]_aid = getcharid(3); if ([email protected]) { for ([email protected] = 0; [email protected] < [email protected]; [email protected]++) { if (attachrid([email protected][[email protected]])) { if (strcharinfo(3) == [email protected]$) { attachrid [email protected]_aid; dispbottom "[ BrasilRO ] Me desculpe, mas para evitar abusos, Double Clients não são permitidos nesse mapa."; atcommand "@kick " + strcharinfo(0); end; } } } } end; } Quote Link to comment Share on other sites More sharing options...
0 Tdi123 Posted May 4 Author Share Posted May 4 2 hours ago, Emistry said: may try this - script Sample -1,{ end; OnInit: // 1= if you have gepard 0=if you do not use gepard [email protected]_gepard = 1; setarray .map$, "quiz_00" , "prt_are_in" , "bat_c01" , "guild_vs2" , "ordeal_1-2" , "coliseum" , "ama_test" , "quiz_02" , "safari" , "niflheim" , "que_qsch01" , "[email protected]" , "[email protected]" , "p_track01" , "pvp_n_2-1"; [email protected]_size = getarraysize(.map$); for ([email protected] = 0; [email protected] < [email protected]_size; [email protected]++) setmapflag .map$[[email protected]], MF_LOADEVENT; .sql_field$ = ([email protected]_gepard ? "last_unique_id" : "last_ip"); end; OnPCLoadMapEvent: [email protected]$ = strcharinfo(3); if (inarray(.map$, [email protected]$) == -1) end; [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE `group_id` < 99"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` AND `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` AND `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; [email protected] = query_sql([email protected]$, [email protected]); [email protected]_aid = getcharid(3); if ([email protected]) { for ([email protected] = 0; [email protected] < [email protected]; [email protected]++) { if (attachrid([email protected][[email protected]])) { if (strcharinfo(3) == [email protected]$) { attachrid [email protected]_aid; dispbottom "[ BrasilRO ] Me desculpe, mas para evitar abusos, Double Clients não são permitidos nesse mapa."; atcommand "@kick " + strcharinfo(0); end; } } } } end; } Did not work Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted May 4 Share Posted May 4 - script Sample -1,{ OnInit: // 1= if you have gepard 0=if you do not use gepard [email protected]_gepard = 1; setarray .map$, "quiz_00" , "prt_are_in" , "bat_c01" , "guild_vs2" , "ordeal_1-2" , "coliseum" , "ama_test" , "quiz_02" , "safari" , "niflheim" , "que_qsch01" , "[email protected]" , "[email protected]" , "p_track01" , "pvp_n_2-1"; [email protected]_size = getarraysize(.map$); for ([email protected] = 0; [email protected] < [email protected]_size; [email protected]++) setmapflag .map$[[email protected]], MF_LOADEVENT; .sql_field$ = ([email protected]_gepard ? "last_unique_id" : "last_ip"); end; OnPCLoadMapEvent: [email protected]$ = strcharinfo(3); if (inarray(.map$, [email protected]$) == -1) end; [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE 1=1"; [email protected]$ = [email protected]$ + " AND `group_id` < 99"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; debugmes [email protected]$; [email protected] = query_sql([email protected]$, [email protected]); [email protected]_aid = getcharid(3); if ([email protected]) { for ([email protected] = 0; [email protected] < [email protected]; [email protected]++) { if (attachrid([email protected][[email protected]])) { if (strcharinfo(3) == [email protected]$) { attachrid [email protected]_aid; dispbottom "[ BrasilRO ] Me desculpe, mas para evitar abusos, Double Clients não são permitidos nesse mapa."; sleep2 2000; atcommand "@kick " + strcharinfo(0); end; } } } } end; } please at least try to tell "what" is not working next time, thank you. Quote Link to comment Share on other sites More sharing options...
0 Tdi123 Posted May 4 Author Share Posted May 4 2 hours ago, Emistry said: - script Sample -1,{ OnInit: // 1= if you have gepard 0=if you do not use gepard [email protected]_gepard = 1; setarray .map$, "quiz_00" , "prt_are_in" , "bat_c01" , "guild_vs2" , "ordeal_1-2" , "coliseum" , "ama_test" , "quiz_02" , "safari" , "niflheim" , "que_qsch01" , "[email protected]" , "[email protected]" , "p_track01" , "pvp_n_2-1"; [email protected]_size = getarraysize(.map$); for ([email protected] = 0; [email protected] < [email protected]_size; [email protected]++) setmapflag .map$[[email protected]], MF_LOADEVENT; .sql_field$ = ([email protected]_gepard ? "last_unique_id" : "last_ip"); end; OnPCLoadMapEvent: [email protected]$ = strcharinfo(3); if (inarray(.map$, [email protected]$) == -1) end; [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE 1=1"; [email protected]$ = [email protected]$ + " AND `group_id` < 99"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; debugmes [email protected]$; [email protected] = query_sql([email protected]$, [email protected]); [email protected]_aid = getcharid(3); if ([email protected]) { for ([email protected] = 0; [email protected] < [email protected]; [email protected]++) { if (attachrid([email protected][[email protected]])) { if (strcharinfo(3) == [email protected]$) { attachrid [email protected]_aid; dispbottom "[ BrasilRO ] Me desculpe, mas para evitar abusos, Double Clients não são permitidos nesse mapa."; sleep2 2000; atcommand "@kick " + strcharinfo(0); end; } } } } end; } please at least try to tell "what" is not working next time, thank you. I tested OffLine by IP and it presents this error, with unique_id, nothing happens when entering maps that cannot dual acc with or without group_id 99, same error happens tested in the following ways: 1° [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE 1=1"; [email protected]$ = [email protected]$ + " AND `group_id` < 100"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; 2° [email protected]$ = strcharinfo(3); if (inarray(.map$, [email protected]$) == -1) end; [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE 1=1"; [email protected]$ = [email protected]$ + " AND `group_id` < 99"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; 3° [email protected]$ = strcharinfo(3); if (inarray(.map$, [email protected]$) == -1) end; [email protected]$ = "SELECT `account_id` FROM `login`"; [email protected]$ = [email protected]$ + " WHERE 1=1"; [email protected]$ = [email protected]$ + " AND `account_id` <> "+getcharid(3); [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `vendings` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `account_id` NOT IN (SELECT `account_id` FROM `buyingstores` WHERE `autotrade` > 0)"; [email protected]$ = [email protected]$ + " AND `"+.sql_field$+"` IN (SELECT `"+.sql_field$+"` FROM `login` WHERE `account_id` = "+getcharid(3)+")"; 4° [email protected]_gepard = 0; and [email protected]_gepard = 1; Did not work Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted May 4 Share Posted May 4 your script suppose to kick the second or next character who have same IP or unique id. But you tested with only one char, which is also an Admin character. Test it with 2 normal character instead. remove the debug message, since its meant for debug purpose debugmes [email protected]$; Quote Link to comment Share on other sites More sharing options...
0 Tdi123 Posted May 4 Author Share Posted May 4 On 5/5/2022 at 12:45 AM, Emistry said: your script suppose to kick the second or next character who have same IP or unique id. But you tested with only one char, which is also an Admin character. Test it with 2 normal character instead. remove the debug message, since its meant for debug purpose debugmes [email protected]$; I tested with admin account, and with groud_id 0 player account Did not work Quote Link to comment Share on other sites More sharing options...
0 Tdi123 Posted May 5 Author Share Posted May 5 (edited) I wanted players who were selling with @at to not get into the dual account check script: https://pastebin.pl/view/5677c94c Edited May 5 by Tdi123 Quote Link to comment Share on other sites More sharing options...
ss
Edited by Tdi123Link to comment
Share on other sites