Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- stock GetPlayerCountry(PlayerIP[])
- {
- new
- iQuery[256],
- iData[4][40];
- if(sscanf(PlayerIP, "p<.>s[10]s[10]s[10]s[10]", iData[0], iData[1], iData[2], iData[3])) iQuery = "Invalid IP";
- else
- {
- format(iQuery, sizeof(iQuery), "SELECT `Country` FROM `countrydetected` WHERE `Ip_From` <= ((16777216*%d) + (65536*%d) + (256*%d) + %d) \
- AND `Ip_to` >= ((16777216*%d) + (65536*%d) + (256*%d) + %d) LIMIT 1",
- strval(iData[0]), strval(iData[1]), strval(iData[2]), strval(iData[3]),
- strval(iData[0]), strval(iData[1]), strval(iData[2]), strval(iData[3]));
- mysql_query(iQuery);
- mysql_store_result();
- if(mysql_num_rows() > 0) mysql_fetch_row(iQuery);
- else iQuery = "Unknown";
- mysql_free_result();
- }
- return iQuery;
- }
Add Comment
Please, Sign In to add comment