Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sign in to follow this  
dynamoeffects

[Contribution] Visitor Web Stats - Support Thread

Recommended Posts

This is the new support thread for Visitor Web Stats by Ian-San. The version I uploaded is fully compliant (AFAIK) with OSC's rules for contribution submissions.

 

The contribution can be downloaded here:

http://www.oscommerce.com/community/contributions,4067

 

PLEASE NOTE: I'm happy to help people when I can, but I did not write this nor do I know enough about it to support this contribution! I only repackaged Ian-San's work and do not take credit for it any shape or form, so please don't PM/e-mail me asking for help.


Please use the forums for support! I am happy to help you here, but I am unable to offer free technical support over instant messenger or e-mail.

Share this post


Link to post
Share on other sites

I would like to add an additional report to my installation of Visitor Web Stats. I would like to able to view the hits per day for the last 30 days instead of just for the current month. I have no idea where to even begin trying to figure out the code to change. If anyone could help me with this, I would really appreciate it.


Laurel

Share this post


Link to post
Share on other sites

hi there,

 

can anyone give me information about how to use the geoIP.dat" database.

I see there are several links on the "reports->visitors-page": "IPadress" leads to "www.myip.com" --> external service;

"hits today" opens a popup which shows IP-address, host, date and a link-list;

"browser language" shows language in statusbar.

 

So what is the geoip.dat - database for?

 

Thanks in advance.

 

blofeld

Share this post


Link to post
Share on other sites

hy guys , i isntaled version 2.3

 

 

3.i found some mistaken in the french and english language file

for instance

 

4. BUG for the moment it shows

Click Green to include Robots Click Green to only include customers

 

define('TABLE_HEADING_DATE', 'Derniers Clics');

 

should be :

define('TABLE_HEADING_DATE', 'Premier Clics');

define('TABLE_HEADING_LAST', 'Dernier Clics');

 

 

5. missing define of language :

image_empty manquant

STATISTICS_TYPE_REPORT_26

 

6. Hard coded language :

Search: is hard coded

Add more items or [Close Window] is hard coded

 

7. the admin page enlarge more than the widht of the screen, u got to use the horzontal window lift to see some element

 

8. in french language , i got a script erreur saying missing '('

 

9. i don't see where are the flag, is it desactivated somewhere ?

 

10. What do you think of moving to the admin all configuration taht we got to change in the php file for the moment

 

 

Phocea answer :

 

The local mistake I think is because I have removed first and last click I think, it now show time of last click and time on the server.

 

I think the sort for the time on server and click counter are reversed also !!

 

Flag was at my wife request, she likes a bit of color, but I think it tends to slow the things down a bit, so dont abuse it.

 

 

The flags are enable/disable at the top of the visitors.php file, check at the bottom of the install.htm file I think I added some explanations there.

 

For the include/exclude text I dont see what you mean.

In the french language file you should now have the following:

 

define('ROBOT_SWITCH_LIMITED', 'Cliquer sur le rouge pour exclure un robot');

define('ROBOT_SWITCH_FULL', 'Cliquer sur le vert pour inclure un robot');

define('GUEST_SWITCH_FULL', 'Cliquer sur le vert pour n\'inclure que les clients');

define('GUEST_SWITCH_LIMITED', 'Cliquer sur le rouge pour voir toutes les traces');

 

define('VISITOR_ICON_FULL_ACTIVE', 'Robots inclus');

define('VISITOR_ICON_LIMITED', 'Cliquer pour exclure un robot');

define('VISITOR_ICON_FULL', 'Cliquer pour inclure un robot');

define('VISITOR_ICON_LIMITED_ACTIVE', 'Robot exclus');

 

define('VISITOR_ICONG_FULL_ACTIVE', 'Clients inclus uniquement');

define('VISITOR_ICONG_LIMITED', 'Cliquer pour voir toutes les traces');

define('VISITOR_ICONG_FULL', 'Cliquer pour n\'inclure que les clients');

define('VISITOR_ICONG_LIMITED_ACTIVE', 'Toutes les traces sont inclues');

 

in english.php it is

 

define('ROBOT_SWITCH_LIMITED', 'Click Red to exclude Robots');

define('ROBOT_SWITCH_FULL', 'Click Green to include Robots');

define('VISITOR_ICON_FULL_ACTIVE', 'Robots included');

define('VISITOR_ICON_LIMITED', 'Click to exclude Robots');

define('VISITOR_ICON_FULL', 'Click to include Robots');

define('VISITOR_ICON_LIMITED_ACTIVE', 'Robots excluded');

 

define('GUEST_SWITCH_FULL', 'Click Green to only include customers');

define('GUEST_SWITCH_LIMITED', 'Click on Red to see all traces');

define('VISITOR_ICONG_FULL_ACTIVE', 'Customers only');

define('VISITOR_ICONG_LIMITED', 'Click to see all traces');

define('VISITOR_ICONG_FULL', 'Click to only include customers');

define('VISITOR_ICONG_LIMITED_ACTIVE', 'All traces Shown');


MS2

Share this post


Link to post
Share on other sites

define('ROBOT_SWITCH_LIMITED', 'Cliquer sur le rouge pour exclure un robot');
define('ROBOT_SWITCH_FULL', 'Cliquer sur le vert pour inclure un robot');
define('GUEST_SWITCH_FULL', 'Cliquer sur le vert pour n\'inclure que les clients');
define('GUEST_SWITCH_LIMITED', 'Cliquer sur le rouge pour voir toutes les traces');

define('VISITOR_ICON_FULL_ACTIVE', 'Robots inclus');
define('VISITOR_ICON_LIMITED', 'Cliquer pour exclure un robot');
define('VISITOR_ICON_FULL', 'Cliquer pour inclure un robot');
define('VISITOR_ICON_LIMITED_ACTIVE', 'Robot exclus');

define('VISITOR_ICONG_FULL_ACTIVE', 'Clients inclus uniquement');
define('VISITOR_ICONG_LIMITED', 'Cliquer pour voir toutes les traces');
define('VISITOR_ICONG_FULL', 'Cliquer pour n\'inclure que les clients');
define('VISITOR_ICONG_LIMITED_ACTIVE', 'Toutes les traces sont inclues');

in english.php it is

define('ROBOT_SWITCH_LIMITED', 'Click Red to exclude Robots');
define('ROBOT_SWITCH_FULL', 'Click Green to include Robots');
define('VISITOR_ICON_FULL_ACTIVE', 'Robots included');
define('VISITOR_ICON_LIMITED', 'Click to exclude Robots');
define('VISITOR_ICON_FULL', 'Click to include Robots');
define('VISITOR_ICON_LIMITED_ACTIVE', 'Robots excluded');

define('GUEST_SWITCH_FULL', 'Click Green to only include customers');
define('GUEST_SWITCH_LIMITED', 'Click on Red to see all traces');
define('VISITOR_ICONG_FULL_ACTIVE', 'Customers only');
define('VISITOR_ICONG_LIMITED', 'Click to see all traces');
define('VISITOR_ICONG_FULL', 'Click to only include customers');
define('VISITOR_ICONG_LIMITED_ACTIVE', 'All traces Shown');

 

 

Im sorry but that make no sens, i think the english and french transalation both contains mistakes

for instance why :

define('VISITOR_ICONG_LIMITED', 'Click to see all traces');

it make no sens no ?

 

please phocea could you check again !


MS2

Share this post


Link to post
Share on other sites

I've just installed the v3a on osc2.2ms2 with only the multi-admins-with-levels contrib.

I followed all the instructions and added entry to admin_files so I can see the visitor link in admin. Everything looks ok except that it doesn't register anything, the visitor tables stay empty...

 

Anyone got an idea what I could have missed here?

Share this post


Link to post
Share on other sites

Never mind previous post, found the error (missing ; ...), works now. :blush:

 

Great contrib btw :thumbsup:

Share this post


Link to post
Share on other sites
Guest

hello,

 

i have installed 2.2 everything works fine, then i upgrade to Visitor Web Stats 3a i got this error in the admin if guest lamp is green

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND customers_id != '0'' at line 1

 

select count(*) as total from visitors AND customers_id != '0'

 

 

anyone can helpe me with this error ?

 

thans in advance

 

bg

Michael

Share this post


Link to post
Share on other sites

i have installed 2.2 everything works fine, then i upgrade to Visitor Web Stats 3a i got this error in the admin if guest lamp is green

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND customers_id != '0'' at line 1

 

select count(*) as total from visitors AND customers_id != '0'

 

 

anyone can helpe me with this error ?

 

thans in advance

 

 

check if the error is the same in all the admin language ! and tell us , i got this eror only in french :-(


MS2

Share this post


Link to post
Share on other sites
Guest
i have installed 2.2 everything works fine, then i upgrade to Visitor Web Stats 3a i got this error in the admin if guest lamp is green

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND customers_id != '0'' at line 1

 

select count(*) as total from visitors AND customers_id != '0'

anyone can helpe me with this error ?

 

thans in advance

check if the error is the same in all the admin language ! and tell us , i got this eror only in french :-(

 

Not language, I get same error using EUC - Ian-san confirmed code for 3a has error.

Share this post


Link to post
Share on other sites

Hello,

 

I've just updated my "Visitors Web Stats" to the latest v3.1 by azer. There are no Country Flags and there is just Search Engine Keywords for past 90 Days table and under the table the message:

Sorry, I am unable to draw the other Charts as imagecreate() is not available in your version of php (check to see if you have gd support) or you switched off chart display
I do have a GD support enabled on my server. Please advise on what might be wrong?

 

Thanks in advance,

Irina.

Edited by Irin

Share this post


Link to post
Share on other sites
Hello,

 

I've just updated my "Visitors Web Stats" to the latest v3.1 by azer. There are no Country Flags and there is just Search Engine Keywords for past 90 Days table and under the table the message:

I do have a GD support enabled on my server. Please advise on what might be wrong?

 

Thanks in advance,

Irina.

Please disregard my previous post, everything is fixed already. I went back to the previous settings:

$gd_support = '1'; // Set Switch from '1' to '0' if GD Support or imagecreate() is not available or to simply switch off displaying Charts

$use_cookie = '1'; // Set to 0 to disable use of cookie

 

$default_report = '2'; // Initial Chart to show

$trace_days = '30'; // Time in days for Visitors Trace Data to be available

$show_visitorhost = 'false'; // Set from true to false depending if you want to display the hostname under the visitor ip. Geo library is required for this to work

 

$show_countryflag = 'true'; // Set from true to false depending if you want to dsiplay the visitor Ip country of origin. This require to have GEOIP library installed

And then around line 255:
if ( ($gd_support != '1') || (!function_exists('imagecreate')) ) { $show_charts = false; }
Now my Chart is showing all the settings.

And regarding the Country Flags, I just changed false to true in the line below:

$show_countryflag = 'true';

Regards.

Share this post


Link to post
Share on other sites

Plse do all read the install.htm UP TO THE END since every single configuration variables are explained :)

Share this post


Link to post
Share on other sites
Plse do all read the install.htm UP TO THE END since every single configuration variables are explained

 

yes u should check on the sql file the new configuration taht we added in he admin :-)


MS2

Share this post


Link to post
Share on other sites

I have tried to install this contribution on my test-shop, but I get this error massge: Parse error: parse error, unexpected $ in /opt/lampp/htdocs/catalog/admin/includes/boxes/reports.php on line 33

 

I read the install instruction a couple of times and also search the forums with no luck

 

It's probably someting with this note in the install doc., but I dont know where I should change in the reports.php

 

Note: In some versions of osCommerce, you may need to use this style of code instead:

 

tep_admin_files_boxes(FILENAME_XXXXXXX, BOX_REPORTS_XXXXXXX) .

tep_admin_files_boxes(FILENAME_VISITORS, BOX_VISITORS));

Share this post


Link to post
Share on other sites
Guest
Not language, I get same error using EUC - Ian-san confirmed code for 3a has error.

 

 

---------------------------------------------------------------------------

 

Has this problem been solved? I got the same error at initial view, it disappeared when clicking refresh table.

Share this post


Link to post
Share on other sites

i have a little prob with this contrib

 

Fatal error: error traversing database - perhaps it is corrupt? in /var/www/***/catalog/admin/includes/geoip.inc on line 220

 

line 220 in geoip.inc

 

trigger_error("error traversing database - perhaps it is corrupt?", E_USER_ERROR);

Share this post


Link to post
Share on other sites
hello,

 

i have installed 2.2 everything works fine, then i upgrade to Visitor Web Stats 3a i got this error in the admin if guest lamp is green

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND customers_id != '0'' at line 1

 

select count(*) as total from visitors AND customers_id != '0'

anyone can helpe me with this error ?

 

thans in advance

 

bg

Michael

 

Hi Michael,

 

did you found a solution for that problem yet?

I got the same error.

But just when I activate 'yearly' AND 'guest included' :angry:

 

If I deactivate guests everything works fine :(

 

Thanks for your support

 

Stefan

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
Sign in to follow this  

×