User tracking mod

[JeffD]

With regard to the behavior changes that cause the tracking data to fail to change session id when the admin, logged in as a user, logs off...

I have found a way to support this with some stipulations:

1) This probably won't work with a shared certificate
2) It assumes you are using SESSION_RECREATE == 'True'

To implement this change, edit the file includes/modules/pages/logoff/header_php.php

Locate the line that says:

  zen_session_destroy();

and just before this line add:

  if (SESSION_RECREATE == 'True') {
    zen_session_recreate();
  }

This will force the session_id to change at logoff and subsequently allow the user tracking data to show this in the report.

Hope this helps!

Jeff

[Woodymon]

This will force the session_id to change at logoff and subsequently allow the user tracking data to show this in the report.

Before I try this out would you be aware of any negative side effects that might be encountered? Any other Zen Cart functionality that might be impacted? Thanks,

Woody

[thebeveragegourmet]

First off, thanks for updating!

Okay, I am a real novice at these things. This is my first install of the user tracking. I added the files and went to upload the sql and got the following errors:

Error: Cannot create table zen_user_tracking because it already exists
Error: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!

They are listed 3 times each in a row


Anyone know what I need to do? Should I have uploaded the sql first instead of last?

[Woodymon]

First off, thanks for updating!

Okay, I am a real novice at these things. This is my first install of the user tracking. I added the files and went to upload the sql and got the following errors:

Error: Cannot create table zen_user_tracking because it already exists
Error: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!

They are listed 3 times each in a row

Anyone know what I need to do? Should I have uploaded the sql first instead of last?

Little birdie says hold off on updating UT. New version of UT coming very soon.

Sounds if you possibly ran the UT sql patch previously or at least more than once during your current install attempt (or UT was installed previously)?

It appears you do not have a prefix appended to your zen cart DB tables.

If you want to proceed installing the current version of UT it is easiest to re-run the patch via phpmyadmin. Depending on the verison of phpmyadmin you have installed the steps are as fiollows:

1. back-up your DB ;-)
2. open the UT sql patch file in a text editor and copy the entire file contents to your clipboard;
3. launch phpmyadmin;
4. select the shop database;
5. click the SQL tab;
6. click in the "run sql query" edit box and choose paste from the browser menu;
7. click go.

If you see a success message then you are good. If you see errors post back to this thread. You will likely again see "Error: Cannot create table zen_user_tracking because it already exists" again which is no big deal. If you want, just drop the zen_user_tracking table using phpmyadmin and run the query again.

If using phpmyadmin you will not need to edit the sql patch file to add zen_ prefix to each table entry in the sql file (the sql patch tool built in to Zen Cart requires proper prefix appended to your named db tables).

Look for the following define in both of your configure files.
define('DB_PREFIX', '');

If you see it empty as above that indicates no prefix is assigned.

Woody

[JeffD]

thebeveragegourmet:

The latest version has the sql errors corrected, sorry about that! I think from your email you got the problems straightened out, but if not post problems here, tks.

Woody:

As far as I know there should be no problems with the proposed changes so long as the version of PHP you are using does not have issues with the recreate sessions code in ZC. I refined mine a bit referencing the post by dwno in the code suggestions forum http://www.zen-cart.com/forum/showthread.php?t=51744 but I doubt these changes have impact. I tested it here quite a bit under PHP 5.x and had no problems. All I can say is try it on a test store first.

The only caveat I saw was the admin logout from the user account is recorded under the admin session rather than the user session but this would be very difficult to fix so it will have to do.

I just now updated the archive at the previously posted link and uploaded the latest version to the ZC downloads area so it should be available there shortly or at the above link now.

Please let me know if you find any issues?

Thanks,
Jeff

[Woodymon]

The only caveat I saw was the admin logout from the user account is recorded under the admin session rather than the user session...

Thanks for the info and the update Jeff. Yes will test on test store (always) running PHP 4.4.

Can you explain the statement above? My head is still a little fogged up and not sure if I understand.

Woody

[JeffD]

When you as an admin, login as a user and then log out, the logout event is recored under the admin session that has just begun rather than under the user session that just ended. Does this make sense?

If you try a session or two I believe you will see clearly what I am indicating...

Jeff

[Woodymon]

When you as an admin, login as a user and then log out, the logout event is recored under the admin session that has just begun rather than under the user session that just ended. Does this make sense?

If you try a session or two I believe you will see clearly what I am indicating...

Hey Jeff-

Sorry if I was unclear and I don't mean to be a pest and none of these 'issues' I observe are hugely significant. I submitted my previous inquiry since the user tracking logging behavior which I understood was suppose to happen following the upgrade to the latest version of UT was not the behavior I was observing. Let me provide more detail...

Scenario: Running Firefox2, I am logged in as admin in one window with the user tracking page open.

In another window I am browsing the shop catalog as a guest. Then I log in to the shop with customer account and browse the catalog some more, and then log off from customer account, so I am back to the guest account. Then I navigate the catalog some more.

When I refresh user tracking in admin I observe that my admin menu navigations clicks display in their own single session under my admin account name which is good!

However both my guest clicks and logged in customer account navigation clicks show up together in another session listing (under the customer account login name). Even my clicks which occur after I logged out of the customer account (so I should be a guest) display under the logged in customer account name session.

Is this the behavior to be expected after the upgrade?

On another note the User Tracking log is not displaying the name of product pages. Instead UT shows a blank entry for the page name and the URL /shop/index.php?main_page=product_info&cPath=2&products_id=2 (for example). Is not the product name suppose to appear in UT for the page name?

And clicks on admin configuration menu entries shows HEADING_TITLE within user tracking. For example the URL /shop/admin/configuration.php?gID=10 shows with HEADING_TITLE as the page name. So in this instance unless I memorize the gID orders of the config menus I am out of luck with being able to quickly identify which config menu was navigated.

Also "User Tracking" displays as the page name within User Tracking when visiting some other admin pages. For example Tools > Email Welcome, shows "User Tracking" and the URL /shop/admin/user_tracking.php?time=1164873600&viewsession=5315f5f1f5e47
f398c863adf3b6f2993.

However most other admin pages are identified in User Tracking correctly. I am pretty sure the page names were displaying correctly with the previous User Tracking version (pinghead).

Again not major issues of the day. Just trying to provide some end-user/store-owner feedback which may assist in future mod development. And at the same time I'm attempting to find out if I have something misconfigured somewhere. "Operator error" is my middle name.

Woody

[JeffD]

Woody:

First let me clarify something... the newest version of the UT tool is no different than any previous version in they way which it logs. It simply writes out followed links to a db table based on session and since nothing in that area has ever changed there is no difference between the way the new version of the tool and any previous version logs clicks as I made no changes to the user_logging functions themselves.

That being said, any loging behavior changes are due to changes in Zencart code, not it UT code. Some minor changes were made in the way logout/timeout and handled and I suspect this is what you are seeing with regard to UT tracking. If in doubt here, revert to a previous version and see for yourself.

As far as product pages and names, the version of the code that I started with was probably not the latest version Pinghead uploaded but rather one about a year old so if these were features added in the last year this version would need to be merged with any newer version to gain these benefits as this version has never displayed this info. If you want to send me a version with that support as soon as I have time I will see about merging the two.

Thanks,
Jeff

[m8trixdg]

Hi 2 questions.
First: Has anyone ever used the Admin Control Mod with the User Tracking Mod?

When I enable aadmin access for an Admin User_Tracking_Control Edit Page has no name under Admin Control so when I check it off it does not stay checked.

Second: When I goto User Tracking it does not list any info except how many clicks there were in that period of time. No details... What am I missing?

Thanks