Jump to content
medvid

Who's Online Enhancement 1.4

Recommended Posts

I installed v3.7, working ok, but i have the same issue more or less with plutomon: flags, country, city aren't shown and googlemap on the bottom of the page doesn't show any location (only when i click on the visitor's ip address, then i can see country, city and location on googlemap in the ipinfodb.com pop up window that comes up.

 

Any help? :-)

Share this post


Link to post
Share on other sites

I installed v3.7, working ok, but i have the same issue more or less with plutomon: flags, country, city aren't shown and googlemap on the bottom of the page doesn't show any location (only when i click on the visitor's ip address, then i can see country, city and location on googlemap in the ipinfodb.com pop up window that comes up.

 

Any help? :-)

 

 

me too.. :(

any help? :-)


OSC V2.2 RC1 FR.. addon: SPPC_Price_Break_v2_0, Anti Robot Registration Validation 2.5,atos-2.7.1,batch-print-center-3.13,Column Product Listing for SPPC and QPBPP v1.4,....

Share this post


Link to post
Share on other sites

After installing 3.7 (there was v1.11 intalled before) when I try to open Admin/Tools/Who's online i am gettin this error

Parse error: syntax error, unexpected T_CLASS in /stor1/minotaur/html/sfaf/catalog/mynewadmin/includes/classes/ipinfodb.class.php on line 2

 

Any idea how to solve this?

Share this post


Link to post
Share on other sites

Hi everyone,

 

I'm using Who's Online 3.6.6 and I've noticed an intermittent problem that has popped up every few weeks or so over the past 4 months.

 

 

 

lines 35-49 of includes/functions/whos_online.php:

function wo_get_host_from_addr($ip_address) {
 //Get hostname from IP address
 if (strstr($ip_address, ',')) {
   //if multiple responses, use first one
   $ips = explode(',', $ip_address);
   $ip_address = $ips[0];
 }
 if ($ip_address == 'unknown') {
   $hostname = $ip_address;
 } else {
   $hostname = gethostbyaddr($ip_address);
 }
 return $hostname;			

}

 

Is this some coding error or could it be some problem with my hosting service? I'm using a shared server for a few more weeks.

 

Thanks

 

Has this been resolved as I am having the same issue.

 

Johan

Share this post


Link to post
Share on other sites

What did you do to adjust it? Can you give me some information about those tweaks please?

 

Thank you in advance

 

nobody find solution?

help please.. :)


OSC V2.2 RC1 FR.. addon: SPPC_Price_Break_v2_0, Anti Robot Registration Validation 2.5,atos-2.7.1,batch-print-center-3.13,Column Product Listing for SPPC and QPBPP v1.4,....

Share this post


Link to post
Share on other sites

Hello everyone,

 

I read a lot on this forum without founding my problem.

 

I have install whosonlineturbov1.1 a long time ago but now I like to change it with Who's Online Enhancement cause I heart only good things about this contribution.

SQL downloaded for whosonlineturbov1.1:

 

ALTER TABLE whos_online ADD http_referer VARCHAR(255) NOT NULL;

ALTER TABLE whos_online ADD user_agent VARCHAR(255) NOT NULL;

 

//////

 

At the start, I have to download the SQL file but I get an error:

Erreur

 

requête SQL:

 

ALTER TABLE whos_online ADD http_referer VARCHAR( 255 ) NOT NULL ;

 

MySQL a répondu:Documentation

#1060 - Duplicate column name 'http_referer'

 

////////

 

I have push up and finish to install all the files. My admin side is working normaly and I can see whos_online but my website is down with an error:

 

1054 - Unknown column 'hostname' in 'field list'

 

insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'd33a478148c4e95a2b3cxxxxxxxxxx', '101.231.216.249', '101.231.216.249', '1303000657', '1303000657', '/catalog/index.php', '', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729; .NET4.0E)')

 

[TEP STOP]

 

I have change a few numbers..., cause I don't know if it is safe to show them!

 

Someone as an idea please?

 

Thanks


osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites

Hello everyone,

 

I read a lot on this forum without founding my problem.

 

I have install whosonlineturbov1.1 a long time ago but now I like to change it with Who's Online Enhancement cause I heart only good things about this contribution.

SQL downloaded for whosonlineturbov1.1:

 

ALTER TABLE whos_online ADD http_referer VARCHAR(255) NOT NULL;

ALTER TABLE whos_online ADD user_agent VARCHAR(255) NOT NULL;

 

//////

 

At the start, I have to download the SQL file but I get an error:

Erreur

 

requête SQL:

 

ALTER TABLE whos_online ADD http_referer VARCHAR( 255 ) NOT NULL ;

 

MySQL a répondu:Documentation

#1060 - Duplicate column name 'http_referer'

 

////////

 

I have push up and finish to install all the files. My admin side is working normaly and I can see whos_online but my website is down with an error:

 

1054 - Unknown column 'hostname' in 'field list'

 

insert into whos_online (customer_id, full_name, session_id, ip_address, hostname, time_entry, time_last_click, last_page_url, http_referer, user_agent) values ('0', 'Guest', 'd33a478148c4e95a2b3cxxxxxxxxxx', '101.231.216.249', '101.231.216.249', '1303000657', '1303000657', '/catalog/index.php', '', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729; .NET4.0E)')

 

[TEP STOP]

 

I have change a few numbers..., cause I don't know if it is safe to show them!

 

Someone as an idea please?

 

Thanks

 

 

Last minute...

 

if I keep the original file whos_online.php (from whosonlineturbov1.1) in catalog/includes/fonctions/whos_online.php it seems working fine in ADMIN and Website!

 

But it still don't know if is it ok and I can use it the same way for my main website!

 

Someone knows?

 

Thanks


osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites

Last minute...

 

if I keep the original file whos_online.php (from whosonlineturbov1.1) in catalog/includes/fonctions/whos_online.php it seems working fine in ADMIN and Website!

 

But it still don't know if is it ok and I can use it the same way for my main website!

 

Someone knows?

 

Thanks

 

I forgot...

 

The only thing who is not working is step 5 (even if I use all good files from Who's Online Enhancement).

(5. In the Admin area, go to Configuration -> Store -> Google Maps Key and enter the key from the previous step)

 

I have no Google Maps Key option in my ADMIN. Means I can show the Google Map!

 

An idea?

Thanks

Edited by Eric B

osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites

I forgot...

 

The only thing who is not working is step 5 (even if I use all good files from Who's Online Enhancement).

(5. In the Admin area, go to Configuration -> Store -> Google Maps Key and enter the key from the previous step)

 

I have no Google Maps Key option in my ADMIN. Means I can show the Google Map!

 

An idea?

Thanks

 

Found a way for that and it is working:

 

http://forums.oscommerce.com/topic/124853-whos-online-enhancement-14/page__st__1640__p__1502838#entry1502838


osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites

Since neither dnstuff or showmyip work, is there sn alternative?

 

I am also using 3.5.4 and showmyip has recently stopped working. I searched a few sites until I found an acceptable one that

1) worked with a URL that included the IP address in it

2) provided a decent page of information

 

To implement this I only had to make one minor change to admin/whos_online.php at line 540 in my file.

 

Find
echo '<a href="http://www.showmyip.com/?ip=' . $whos_online['ip_address'] . '&get=nmap" target="_blank">';

replace with

echo '<a href="http://www.ipchecking.com/?ip=' . $whos_online['ip_address'] . '&check=Lookup" target="_blank">';

 

I hope this helps (even though it is 2 years later LOL!).

Share this post


Link to post
Share on other sites

hi, trying to use the whosonline feature and i am getting the following error message on 2 oscommerce sites.

 

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/xxxxxx/public_html/xxxxxx/whos_online.php:184 Stack trace: #0 /home/xxxxxx/public_html/xxxxxx/whos_online.php(184): SimpleXMLElement->__construct('') #1 /home/xxxxxx/public_html/xxxxxx/whos_online.php(221): updateIps() #2 /home/xxxxxx/public_html/xxxxxx/whos_online.php(379): add_geolocation() #3 {main} thrown in /home/xxxxxx/public_html/xxxxxx/whos_online.php on line 184

 

any ideas please ?

regrads

Share this post


Link to post
Share on other sites

hi, trying to use the whosonline feature and i am getting the following error message on 2 oscommerce sites.

 

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/xxxxxx/public_html/xxxxxx/whos_online.php:184 Stack trace: #0 /home/xxxxxx/public_html/xxxxxx/whos_online.php(184): SimpleXMLElement->__construct('') #1 /home/xxxxxx/public_html/xxxxxx/whos_online.php(221): updateIps() #2 /home/xxxxxx/public_html/xxxxxx/whos_online.php(379): add_geolocation() #3 {main} thrown in /home/xxxxxx/public_html/xxxxxx/whos_online.php on line 184

 

any ideas please ?

regrads

 

 

Same problem to me.

Share this post


Link to post
Share on other sites

This error is due to the IP lookup database site being offline at present.

 

hi thanks for the reply, i guess that puts this one to bed :thumbsup:

Share this post


Link to post
Share on other sites

How can I easily disable the IP lookup feature and make Who's Online work again? I rarely use it anyway.

Share this post


Link to post
Share on other sites

The quickest way would be to backup and copy to local folder your 'enhanced whois online' whois_online.php file and then simply replace it with the standard copy from your osCommerce source files.

 

The problem with ipinfodb should only be temporary and they have posted on Twitter and FaceBook the following:

 

"Sorry everyone for the inconvenience. Our data center is having some technical issues at the moment and they are working as fast as they can to get our servers up again. In the meantime, please be patient and we will update everyone again as soon as there is any progress."

Share this post


Link to post
Share on other sites

Ok, worked out the fix. To disable the IP Lookup feature (but not disable the link to the lookup) Comment out the following lines in admin/whos_online.php:

 

Around line 106 add "//" to this line (as shown):

 

//  require('includes/classes/ipinfodb.class.php');

 

Around line 161, add:

 

/*

 

BEFORE this line:

 

//Function to get IP address geolocation data from IPInfoDB and update whos_online table

 

and around line 214, add:

 

*/

 

BEFORE this line:

 

// Determines status and cart of visitor and displays appropriate icon.

 

Around 372, add "//" to this line (as shown):

 

//  add_geolocation();

 

That's it! Hopefully it doesn't break anything else, but at least it gets Who's Online working again until ipinfodb.com is running again.

Share this post


Link to post
Share on other sites

well, you just need to change the ip locator api

edit /admin/whos_online.php and change to this (line 160):

 

//Function to get IP address geolocation data from IPInfoDB and update whos_online table
function updateIps($ips){
//Old,incesure  method
//$d = file_get_contents("http://ipinfodb.com/ip_query2.php?ip=$ips");     

//Initialize the Curl session
$ch = curl_init();
$URL = ("http://api.hostip.info/?ip=$ips");
//Set curl to return the data instead of printing it to the browser.
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
//Set the URL, then execute, then close
curl_setopt($ch, CURLOPT_URL, $URL);
$d = curl_exec($ch);
curl_close($ch);



//Use backup server if cannot make a connection
if (!$d){
	//$backup = file_get_contents("http://backup.ipinfodb.com/ip_query2.php?ip=$ips");
	$ch = curl_init();
	$URL = ("http://api.hostip.info/?ip=$ips");

Edited by SambaMambo

Share this post


Link to post
Share on other sites

well, you just need to change the ip locator api

edit /admin/whos_online.php and change to this (line 160):

 

Make sure you add another end tag:

 

  }  

 

to the section, just before:

 

//Add IP address geolocation to whos_online table

Share this post


Link to post
Share on other sites

BTW, not having the IP Lookup enabled REALLY speeds up Who's Online - a lot!

 

I may never put it back (especially since the links should still work once the database is running again).

Share this post


Link to post
Share on other sites

Should a completely ancillary function from a third-party website really be allowed to break the entire application when their server has a hiccup, however rare?

 

The next version of this really should have a test for the presence of a working lookup site and should also allow the user to disable that function as part of it's settings (especially considering the speed improvements). I'm not a good enough programmer to make those changes, but I think it would be a welcome addition if anybody wants to do it.

Share this post


Link to post
Share on other sites

I am posting a solution to a problem with the pins on the map - my map had no pins :S

First make sure you have uploaded visitors_georss.php to your catalog directory.

Then in admin/whos_online.php find the line:

geoXml = new GGeoXml("<?php echo HTTP_CATALOG_SERVER . "/visitors_georss.php";?>");

or

geoXml = new GGeoXml("<?php echo HTTP_CATALOG_SERVER . DIR_WS_CATALOG . "visitors_georss.php";?>");

 

Basically the problem was with this line.

I had both these lines but the first one was commented out -- but that was the correct line for me!

 

You can take the php part in the line, e.g.

<?php echo HTTP_CATALOG_SERVER . DIR_WS_CATALOG . "visitors_georss.php";?>

and paste it somewhere on your website to see the URL it generates, for example it may say:

www.yoursite.com//visitors_georss.php

or something else

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×