15-01-2012, 1:54
Bonjour , je voudrais avoir un plugin qui mette un drapeaux à coté de l'ip comme cette image :
http://community.mybb.com/attachment.php?aid=13837
Merci
http://community.mybb.com/attachment.php?aid=13837
Merci
FIELD
DATA TYPE FIELD DESCRIPTION
IP_FROM NUMERICAL (DOUBLE) Beginning of IP address range.
IP_TO NUMERICAL (DOUBLE) Ending of IP address range.
COUNTRY_CODE2 CHAR(2) Two-character country code based on ISO 3166.
COUNTRY_CODE3 CHAR(3) Three-character country code based on ISO 3166.
COUNTRY_NAME VARCHAR(50) Country name based on ISO 3166
function getdb_fromdb($ip) {
global $db;
$sql = "SELECT `country_code2`, `country_name`
FROM `mybb_iptocountry`
WHERE ip_from<=inet_aton('$ip')
AND IP_TO>=inet_aton('$ip')";
$row = $db->query("$sql");
$data = $db->fetch_array($row);
return $data;
}
function ip2c_getdb_fromcache ($ip) {
global $db;
$sql = "SELECT `country_code2`, `country_name`
FROM `mybb_iptocountry_cache`
WHERE ip = inet_aton('$ip')";
$row = $db->query("$sql");
return $db->fetch_array($row);`
Ip to Flag Setting
Will display where : foobar