Please check my script. Thank you!

[Aya]

- script Dont_allow_2_clients -1,{

end;


OnPCLoginEvent:
query_sql "SELECT last_ip FROM login WHERE account_id = "+getcharid(3)+"",@RIDIP;
query_sql "INSERT INTO On_ip_table ("+@RIDIP+")";
query_sql "UPDATE On_ip_table SET ips_online = ips_online + 1 WHERE last_ip = "+@RIDIP+"";
query_sql "SELECT ips_online FROM on_ip_table WHERE last_ip = "+@RIDIP+"",@TIMESON;
if(@TIMESON >= 2) {
dispbotton "[staff]";
dispbotton strcharinfo(0)+" you can't log with two windows opened";
dispbotton "I need kick you now";
sleep2 5000; // Just to the player read.
atcommand "@kick "+strcharinfo(0);
}
end;

OnPCLogoutEvent:
query_sql "SELECT last_ip FROM login WHERE account_id = "+getcharid(3)+"",@RIDIP;
query_sql "UPDATE on_ip_table SET ips_online = 0 WHERE last_ip = "+@RIDIP+"";
end;

OnInit:
CREATE TABLE IF NOT EXISTS on_ip_table (last_ip varchar(100) NOT NULL default '',ips_online int(11) NOT NULL DEFAULT '0',PRIMARY KEY  (`last_ip`)) ENGINE=MyISAM AUTO_INCREMENT=2000000;// SET THE ENGINE MAKE THE TABLE BE ACESSED FASTER

}

Please check my script. This script SHOULD not allow players to log in using the same IP. Thank you! I made this script to prevent sandbox users. Thank you

Edited December 21, 2012 by Aya

[Mootie]

("SELECT name, char.account_id, last_ip FROM `char` LEFT JOIN `login` ON login.account_id = char.account_id where name = '" + escape_sql(.@frnd$) + "'",.@chname$, .@account_id, .@flastip$);

btw instead using this just disable dual clients in diff

[llchrisll]

Just saying, but you know that an IP contains "." right? Those are not numeric so you need "$" at the end of "@RIDIP" > "@RIDIP$"

Also

query_sql "INSERT INTO On_ip_table ("+@RIDIP+")"; 

is wrong, well as far as I know.

Correct format:

query_sql "INSERT INTO `On_ip_table` (`last_ip`) VALUES ('"+@RIDIP$+"')";

Note: " ` " is an habit of mine to use them always, official format. :I

Yours is the faster way , but well.

I noticed also that "dispbotton" is false written > "dispbottom"

Here is my version:

- script Dont_allow_2_clients -1,{

end;


OnPCLoginEvent:
query_sql "SELECT last_ip FROM login WHERE account_id = "+getcharid(3)+"",@RIDIP$;
// Checking if the IP isn't inserted into the On_ip_table
if(query_sql("SELECT `last_ip` FROM `On_ip_table` WHERE `last_ip` = '"+@RIDIP$+"'",.@ip_check$) == "")
// If not inserted yet, do it.....
query_sql "INSERT INTO On_ip_table (`last_ip` ) VALUES ('"+@RIDIP$+"')";
query_sql "UPDATE On_ip_table SET ips_online = ips_online + 1 WHERE last_ip = "+@RIDIP$+"";
query_sql "SELECT ips_online FROM on_ip_table WHERE last_ip = "+@RIDIP$+"",@TIMESON;
if(@TIMESON >= 2) {
dispbottom "[staff]";
dispbottom strcharinfo(0)+" you can't log with two windows opened";
dispbottom "I need kick you now";
sleep2 5000; // Just to the player read.
atcommand "@kick "+strcharinfo(0);
}
end;

OnPCLogoutEvent:
// No need for this line since the variable "@RIDIP$" will be cleared on logout or when you overwrite it,
// and I don't believe that the IP changes while being ingame 
//query_sql "SELECT last_ip FROM login WHERE account_id = "+getcharid(3)+"",@RIDIP$;
query_sql "UPDATE on_ip_table SET ips_online = 0 WHERE last_ip = "+@RIDIP$+"";
end;

OnInit:
CREATE TABLE IF NOT EXISTS on_ip_table (last_ip varchar(100) NOT NULL default '',ips_online int(11) NOT NULL DEFAULT '0',PRIMARY KEY  (`last_ip`)) ENGINE=MyISAM AUTO_INCREMENT=2000000;// SET THE ENGINE MAKE THE TABLE BE ACESSED FASTER

}

("SELECT name, char.account_id, last_ip FROM `char` LEFT JOIN `login` ON login.account_id = char.account_id where name = '" + escape_sql(.@frnd$) + "'",.@chname$, .@account_id, .@flastip$);

btw instead using this just disable dual clients in diff

That SQL code is in my opinion for people who have a better knowledge of MySQL.

The Diff is against Dual Clients, but what about when someone has 2 Computers?

Regards,

Chris

Edited December 21, 2012 by llchrisll

[Mootie]

Just saying, but you know that an IP contains "." right? Those are not numeric so you need "$" at the end of "@RIDIP" > "@RIDIP$"

Also

query_sql "INSERT INTO On_ip_table ("+@RIDIP+")"; 

is wrong, well as far as I know.

Correct format:

query_sql "INSERT INTO `On_ip_table` (`last_ip`) VALUES ('"+@RIDIP$+"')";

Note: " ` " is an habit of mine to use them always, official format. :I

Yours is the faster way , but well.

I noticed also that "dispbotton" is false written > "dispbottom"

Here is my version:

- script Dont_allow_2_clients -1,{

end;


OnPCLoginEvent:
query_sql "SELECT last_ip FROM login WHERE account_id = "+getcharid(3)+"",@RIDIP$;
// Checking if the IP isn't inserted into the On_ip_table
if(query_sql("SELECT `last_ip` FROM `On_ip_table` WHERE `last_ip` = '"+@RIDIP$+"'",.@ip_check$) == "")
// If not inserted yet, do it.....
query_sql "INSERT INTO On_ip_table (`last_ip` ) VALUES ('"+@RIDIP$+"')";
query_sql "UPDATE On_ip_table SET ips_online = ips_online + 1 WHERE last_ip = "+@RIDIP$+"";
query_sql "SELECT ips_online FROM on_ip_table WHERE last_ip = "+@RIDIP$+"",@TIMESON;
if(@TIMESON >= 2) {
dispbottom "[staff]";
dispbottom strcharinfo(0)+" you can't log with two windows opened";
dispbottom "I need kick you now";
sleep2 5000; // Just to the player read.
atcommand "@kick "+strcharinfo(0);
}
end;

OnPCLogoutEvent:
// No need for this line since the variable "@RIDIP$" will be cleared on logout or when you overwrite it,
// and I don't believe that the IP changes while being ingame 
//query_sql "SELECT last_ip FROM login WHERE account_id = "+getcharid(3)+"",@RIDIP$;
query_sql "UPDATE on_ip_table SET ips_online = 0 WHERE last_ip = "+@RIDIP$+"";
end;

OnInit:
CREATE TABLE IF NOT EXISTS on_ip_table (last_ip varchar(100) NOT NULL default '',ips_online int(11) NOT NULL DEFAULT '0',PRIMARY KEY  (`last_ip`)) ENGINE=MyISAM AUTO_INCREMENT=2000000;// SET THE ENGINE MAKE THE TABLE BE ACESSED FASTER

}

("SELECT name, char.account_id, last_ip FROM `char` LEFT JOIN `login` ON login.account_id = char.account_id where name = '" + escape_sql(.@frnd$) + "'",.@chname$, .@account_id, .@flastip$);

btw instead using this just disable dual clients in diff

That SQL code is in my opinion for people who have a better knowledge of MySQL.

The Diff is against Dual Clients, but what about when someone has 2 Computers?

Regards,

Chris

computer cafe/internet shops yeah o.o

[Aya]

Well basically what I want to happen is to allow players who play in different computer sharing the same IP as far as concern for those who are in a Computer Shop. What I do not want is that when, someone is going to login using the SAME IP he is using, meaning this guy is using SandBoxie (A software that allows dual client even the diff is DISABLED MULTIPLE CLIENTS.)

[AnnieRuru]

I believe your request means your server needs to equip Harmony ...

rathena doesn't have this feature

http://rathena.org/board/topic/74823-limit-chars-per-ip-or-mac-but-no-limit-on-autotrade-merchants/#entry159618

[Aya]

O okay! I just can't affor Harmony that's why I am making custom defenses for my server Thank you!