Forum Display Enhancements - Country Display for Who's Online

*** Staff note: The author of this modification has passed away in a diving accident. We wish his family all strength in dealing with this traggic issue. ***

Country Display for Who's Online

What does this do?

It adds another column to your Who's Online display, with the country where the user is logging on from. You can choose either the name, the flag or both. You can also decide which users can see this information.

How about a quick summary of features?

Country display can be admin/moderator only, or available for everyone to see
You can display the country name, a flag, or both. You can use alternative flag sets if you want
Adds minimal overhead, no additional queries
Works on 3.6.6, 3.6.7 and should work for future versions as well. Will not work on versions prior to this. There is a manual file hack for previous versions here (unsupported).
Country information is provided by the GLA (Geographic Location Awareness) mod. Therefore updates to GLA will automatically provide improvements to any mod using GLA.

How do I install?

1. Install GLA first. You can find it here. It's easy and takes a minute.
2. Download and install the enclosed .xml file via adminCP -> Plugins & Products -> Manage Products -> Add/Import Product -> Import.

How do I configure it?

By default it will display only the country name to admin, super moderators and moderators. You can change this under vBulletin Options -> Who's Online Options. Be sure to check these options and click "save", even if you haven't changed anything. See attached screenshots.

Before posting on this thread:

If your issue concerns questions about country detection, the accuracy of the database, etc - please post your question on the GLA thread instead. Please only post issues here concerning the Who's Online display itself.

Please click install. Support requests from people who have not clicked install may not be answered.

Version history:
V1.0 - (07.07.07) Initial release

[Triky]

Another great one! Thanks!

[fpattberg]

Hi.

I really like this mod and installed it. It worked for 2 hours after installation and then suddenly the complete Country category doesnt show up anymore.

The previous installation went without a problem.

Just to be sure, I reinstalled followed all the steps in the correct order but still nothing. My Whois online doesnt show anything other then the normal stuff.

Really strange.

I am using custom style and this mod from Dream for the whois online: https://vborg.vbsupport.ru/showthread.php?t=123158

But this shouldnt really be a problem right? it worked before.

Can anyone help me with this?

Thanks.

[mfyvie]

Sounds very strange. I would go through the various steps that people have used for troubleshooting for both this mod and GLA. Remember that this mod relies on GLA - if something isn't working there, then this mod won't work either. Have a scan through both this thread and the GLA thread and you should be able to narrow down where the problem lies. But as a first step I would double check your settings in the admincp, and click save, even if the settings appear to be the way you want them (there is a bug in vbulletin which can sometimes show you different settings than there really are)

[fpattberg]

Hi mfyvie.

Thanks for the heads up. I have looked through all the threads but nothing.

I have tried everything I can think of. It just doesnt work. As if I did not install anything.

I guess there is no other way other then to uninstall altough I hate to give up.

Fabian

[mfyvie]

Fabian,

If you've followed all the steps in this and the other thread then you'd have a pretty good idea about WHICH part isn't working. For example - is GLA functioning correctly? Were you able to get any information showing after a manual template edit, is the session table populated?

You say you've tried everything that you can think of - "but it just doesn't work". The question is, which parts worked, and which parts didn't - or are you saying that GLA has completely failed and NONE of it is working? I'd find that a bit difficult to understand.

[fpattberg]

Originally Posted by mfyvie

Fabian,

If you've followed all the steps in this and the other thread then you'd have a pretty good idea about WHICH part isn't working. For example - is GLA functioning correctly? Were you able to get any information showing after a manual template edit, is the session table populated?

How can I check that the GLA worked? That might be the problem.

[mfyvie]

Originally Posted by fpattberg

How can I check that the GLA worked? That might be the problem.

I thought you'd said you'd gone through both threads? If you visit the GLA thread, you'll find information about troubleshooting GLA (but you already said you did this?) Anyway, if you have a specific question about GLA troubleshooting, best to pick it up on the GLA thread rather than this one.

[fpattberg]

Okay thanks mfyvie.

Great mod anyway.

[Logician]

Great hack, thanks for sharing!

For people who have 3.6.x version (3.6.0 to 3.6.6) which is not compatible with this pluggin and who don't mind hacking .php code here is how you can install this hack:

Edit online.php, find:

$allusers = $db->query_read_slave("
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM " . TABLE_PREFIX . "session AS session
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
WHERE session.lastactivity > $datecut
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ."
ORDER BY $sqlsort $sortorder
");

REPLACE IT AS:

// Logician modified Hack : Country display for who's online
$hook_query_fields = $hook_query_joins = $hook_query_where = '';
$hook_query_fields = ', session.country, session.country_iso2, session.country_iso3';
$allusers = $db->query_read_slave("
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
$hook_query_fields
FROM " . TABLE_PREFIX . "session AS session
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
$hook_query_joins
WHERE session.lastactivity > $datecut
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ."
$hook_query_where
ORDER BY $sqlsort $sortorder
");
// Logician modified Hack : Country display for who's online

Upload online.php hack to server and then import the ATTACHED product.

I've tested with vb 3.6.2 and it is working fine if installed as described here. Yet I don't have time to give support for this, sorry about it if it does not work for you. If you have 3.6.7 or above, please dont apply my instructions, use original hack instead!

[winpro19]

Hey

First of all I must say great support here, keep up the good work mfyvie - we really appreciate your efforts! And a great plug-in too, very informative (at least for me).

However, I'm having a little problem...I've installed the plug in and GLA and verified that ip2country table exists in my database, and my session table has "country" and I believe "country_is1" and "country_is2" ( I may be mistaken a bit about the country_is1 and is2, it's something like that you probably know).

However there is no table in who's online for "Country/flag". Do you know what the issue could be? Here are screenshots:

http://img249.imageshack.us/img249/6687/img1hn9.gif
http://img529.imageshack.us/img529/6413/img1pz7.gif

To clarify, there has been user activity after the plug-in was installed.

Interestingly enough, when I enable "Resolve IP Address" option then I do see a new table created which resolves their IP.

Thanks !