MyBB Community Forums

Heya,

I was wondering if there was a stable IP to flag on postbit plugin.
I couldn't really find any interesting on the internet, all were outdated or takes a load of sources on page request.

I run a gaming community and therefore such plugin will be quite helpful.

So, I hope someone know a stable plugin which doesn't take to many sources on page load.

Thanks,
Tankey

IMO its a waste of resources. You could easily do this with just Custom Profile Fields. However yes I agree that with databases you could make a plugin that speaks the truth about the poster country.

More appropriately, this: http://mods.mybb.com/view/ip2flag

Yea, but those downloads doesn't work anymore, to be honest.. Dead links

You can search the CSV's or db's of IPs. Here is a quick google; http://www.zaigadgets.com/geoip

Hey,

Yea I found an up to date CSV file, but the problem is that the MyBB plugin requires a MySQL database.
However, I found a PHP class which is able to read out CSV files but I have actually no idea how to import it in the existing plugin..

Here is the PHP class file and the CSV database, if you are interested.

http://de77.com/php/how-to-detect-visito...ip-address

I try to edit the source myself, but I doubt it will work..

Tankey

hmm i have CSV

but the plugin need two table

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);

Where can find the sql structure ?

good question.

This plugin is a bit outdated. thats why some ppl purposed to make a new one. Im wondering about the progress tho

BUMP
Anyone planning to do such plugin?