vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Display Enhancements - Country Display for Who's Online (https://vborg.vbsupport.ru/showthread.php?t=151600)

Triky 07-10-2007 09:29 AM

Another great one! Thanks!

fpattberg 07-10-2007 12:24 PM

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 07-10-2007 12:28 PM

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 07-10-2007 01:08 PM

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. :mad:

Fabian

mfyvie 07-10-2007 01:15 PM

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 07-10-2007 01:22 PM

Quote:

Originally Posted by mfyvie (Post 1287570)
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 07-10-2007 01:28 PM

Quote:

Originally Posted by fpattberg (Post 1287574)
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 07-10-2007 01:32 PM

Okay thanks mfyvie.

Great mod anyway. :)

Logician 07-10-2007 05:27 PM

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:

Quote:

$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:


Quote:

// 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 07-11-2007 05:10 AM

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 !


All times are GMT. The time now is 02:23 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01162 seconds
  • Memory Usage 1,751KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete