[Contribution] Visitor Web Stats - Support Thread

[dynamoeffects 3]

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.

[laurelsstitchery 0]

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.

[Guest]

About this, I find two:

 

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

 

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

 

 

Looking the same. Please what is the difference?

 

 

Akiko

[wheeloftime 0]

About this, I find two:

 

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

 

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

Looking the same. Please what is the difference?

Akiko

Look at the date and you will know. Also reading what is written with the old one helps.

[blofeld 0]

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

[blofeld 0]

hi,

 

problem solved!

 

It's used in the statistics-section!

 

blofeld

[azer 0]

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');

[azer 0]

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 !

[cv_coco 0]

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?

[cv_coco 0]

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

 

Great contrib btw :thumbsup:

[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

[azer 0]

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

[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.

[Irin 3]

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 March 19, 2006 by Irin

[Irin 3]

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.

[Phocea 0]

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

[azer 0]

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

[jfk071 0]

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));

[jfk071 0]

Solved my problem, ddn't copy the right text.

[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.

[adauktion 0]

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);

[adauktion 0]

stupid mistake.... don?t unzip the file.... :(

[adauktion 0]

running very nice but i missing a refer-list

 

(from wich search-engine, price comparison company, partners etc.)

[stefanhome 0]

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

[adauktion 0]

sure....see your PM ^^

 

change your cookiepath