Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Who's Online Enhancement 1.4


Guest

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? :-)

Link to comment
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? :-)

Link to comment
Share on other sites

  • 1 month later...

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?

Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
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!

Link to comment
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!

Link to comment
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!

Link to comment
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://www.oscommerce.com/forums/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!

Link to comment
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!).

Link to comment
Share on other sites

  • 2 weeks later...

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

Link to comment
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.

Link to comment
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:

Link to comment
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."

Link to comment
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.

Link to comment
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
Link to comment
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

Link to comment
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.

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...