OnCheck:
deletearray .@acc[0], getarraysize(.@acc); deletearray .@char[0], getarraysize(.@char);
for(set .@i,0; .@i<=25; set .@i,.@i+1){
query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = '"+.@guild+"'", .@acc, .@char);
}
for(set .@j,0; .@j<getarraysize(.@acc); set .@j,.@j+1){
if (isloggedin(.@acc[.@j],.@char[.@j])) {
query_sql("SELECT last_ip FROM `guild_member` WHERE account_id = '"+.@acc[.@j]+"'",.@ip1);
query_sql("SELECT last_ip FROM `guild_package` WHERE account_id = '"+.@acc[.@j]+"'",.@ip2);
if(.@ip1 == .@ip2){
message rid2name(.@acc[.@j]),"Sorry but you can't cheat on this system.";
}
set .@members,.@members+1;
}
}
sleep 2;
return;
here is the code.. I just want a limit on the query... the query must detect only 1 last_ip.
Example: I got 2 players in one shop.. number 1 and number 2 both of them has a same last_ip and same guild..what I want is if number 1 is the first listed on the query then number 2 can not be listed to the query because number 1 is already listed.. I hope some will share..
Question
nasagnilac
here is the code.. I just want a limit on the query... the query must detect only 1 last_ip.
Example: I got 2 players in one shop.. number 1 and number 2 both of them has a same last_ip and same guild..what I want is if number 1 is the first listed on the query then number 2 can not be listed to the query because number 1 is already listed.. I hope some will share..
Link to comment
Share on other sites
1 answer 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.