Guest User

Untitled

a guest
May 21st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. stock GetPlayerCountry(PlayerIP[])
  2. {
  3. new
  4. iQuery[256],
  5. iData[4][40];
  6.  
  7. if(sscanf(PlayerIP, "p<.>s[10]s[10]s[10]s[10]", iData[0], iData[1], iData[2], iData[3])) iQuery = "Invalid IP";
  8. else
  9. {
  10. format(iQuery, sizeof(iQuery), "SELECT `Country` FROM `countrydetected` WHERE `Ip_From` <= ((16777216*%d) + (65536*%d) + (256*%d) + %d) \
  11. AND `Ip_to` >= ((16777216*%d) + (65536*%d) + (256*%d) + %d) LIMIT 1",
  12.  
  13. strval(iData[0]), strval(iData[1]), strval(iData[2]), strval(iData[3]),
  14. strval(iData[0]), strval(iData[1]), strval(iData[2]), strval(iData[3]));
  15.  
  16. mysql_query(iQuery);
  17. mysql_store_result();
  18.  
  19. if(mysql_num_rows() > 0) mysql_fetch_row(iQuery);
  20. else iQuery = "Unknown";
  21.  
  22. mysql_free_result();
  23. }
  24. return iQuery;
  25. }
Add Comment
Please, Sign In to add comment