User tracking mod

Also, in User Tracking Config: Under Session Limit where it says:

Quote:

---

User Tracking (Session Limit)
Displaying the latest # sessions of this 24 hour period.
(SET to 999999 for unlimited per 24 hour period)
NOTE:
Watch your space !

---

What is an appropriate number to enter. 50 was the default, which is much too small (if I'm understanding it's use correctly) but if I set it to unlimited or a higher number, will it cause a noticeable drag on my system? Or is it just if you don't purge occasionally?

Thanks again

Tim

Hi,

I installed user tracking properly but I can't set all the permissions for it in the 'Admin Profiles Mod': the configure-menu-item does not appear in the settings.

grmx
zen 1.3.5.

Quote:

---

Originally Posted by MeltDown

I'm still having an issue with the section under the heading "User Shopping Cart". which views the activity within the cart. It always reads just "Session Expired" or "No Cart Recorded" even whan there are sales.
Tim

---

If you have made a sale the cart is cleared, removed, gone... Thats why is says "No Cart Recorded" as the cart no longer exists.

If they have a cart without sale then it shows until the session expires and the cart is then cleared from the system hence "Session Expired"

Quote:

---

Originally Posted by gilby

If you have made a sale the cart is cleared, removed, gone... Thats why is says "No Cart Recorded" as the cart no longer exists.

If they have a cart without sale then it shows until the session expires and the cart is then cleared from the system hence "Session Expired"

---

You're absolutely right. I noticed that myself and meant to repost, but hadn't had the chance. Thanks for the response.

As for my other question, I am still hoping for a reply.

Quote:

---

What is an appropriate number to enter. 50 was the default, which is much too small (if I'm understanding it's use correctly) but if I set it to unlimited or a higher number, will it cause a noticeable drag on my system? Or is it just if you don't purge occasionally?

---

Thanks again

Tim

I'm having a hard time discerning how many actual people visit my shop. The Admin counter on the first page (Where it says "Counter History for last 10 recorded days Session - Total") will indicate for one day, for example, 645 - 2714. I take this to mean that there were 645 visitors and 2714 page views.
User Tracker module, however, will indicate for the same time period "There have been 2512 page views in this 24 hour period. Total number of users: 181"
Google Analytics will then report, for the same time frame: "Visits: 116
Pageviews: 914"

Any idea why the discrepancies? And who is more reliable?

Thanks

Tim

Quote:

---

Originally Posted by MeltDown

Also, when I click on the "View Session" hyperlink, the admin closes and I'm sent to the admin login screen. This occurs each time.

---

Tim,

Can you please tell me how you fixed this. I'm having the same problem with this and another admin mod I installed. Both kick me back to the admin login scree.

Thanks in advance,

Mr. Godiva

Quote:

---

Originally Posted by mrgodiva

Tim,

Can you please tell me how you fixed this. I'm having the same problem with this and another admin mod I installed. Both kick me back to the admin login scree.

Thanks in advance,

Mr. Godiva

---

Unfortunately I've yet to fix that specific quirk. However, it doesn't impede my use of the module (except as an inconvenience) because once it kicks me back to the login and I log in again, I am then able to view sessions normally until the next time I log out. I don't know what causes this glitch but I do know, after reading through the forums on this and other modules, that I am not the only one to experience it and that it isn't unique to this module.

Sorry I couldn't be of more assistance.

Tim

Tim,

Thanks for your reply. With me, I am not able to view them. Once it kicks me out to the login, I re-login and then go back to the view sessions and when I click on it, it sends me to the login screen again. I'm in a continous never-ending loop...:laugh:

I can view all other areas of the admin, just can't view the sessions..:down:


Thanks,

Mr. Godiva

Quote:

---

Originally Posted by mrgodiva

Tim,

Thanks for your reply. With me, I am not able to view them. Once it kicks me out to the login, I re-login and then go back to the view sessions and when I click on it, it sends me to the login screen again. I'm in a continous never-ending loop...:laugh:

I can view all other areas of the admin, just can't view the sessions..:down:


Thanks,

Mr. Godiva

---

I don't know if this plays into it, but in the User Tracker Config I have User Tracking (ADMIN) and User Tracking (HostLookup) both set to false. (Primarily because it speeds response time)
If your settings are different you might want to give this a try.

Good luck!

Tim

Tim,

Mine was still at default (turned on). I tried what you said and I still have the same problem. Everytime I click on "view session" it sends me to the log in screen. I log in and it sends me to the index page of admin. I go back into user tracking and click on view session and back to log in......:no:


Thanks,

Mr. Godiva

Quote:

---

Originally Posted by mrgodiva

Tim,

Mine was still at default (turned on). I tried what you said and I still have the same problem. Everytime I click on "view session" it sends me to the log in screen. I log in and it sends me to the index page of admin. I go back into user tracking and click on view session and back to log in......:no:


Thanks,

Mr. Godiva

---

That is frustrating. You probably have already done this, but the only other thing I can think of is to run back through installation to be certain everything is there and in it's proper place. (keeping in mind the over-ride system)
Most importantly, I would check to be certain that the file modification(s) are in place (From the ReadMe...add the following to the end of /includes/templates/YOUR TEMPLATE/common/tpl_footer.php and/or ...add the following to the end of /admin/includes/footer.php)

I only have the /includes/templates/YOUR TEMPLATE/common/tpl_footer.php installed.

Again, best of luck

Tim

This just thinking out loud,

but I was wondering if we can put a Bookmark this Site so that the zenid is not recorded. I'm not sure if visiters would use it over other habits. The zenid appears to be involved in repeat visiters making the tracking a little hard to figure.

Has someone tried this with any success? and if so, how did you sit it up?

Then again, if the timestamps were also dated it would be better the way it is, that is, seeing a history "and" their recent visit.

Hi Everyone

I have a bit of a problem with UT. I have using it for a long time now with not too many problems, but this morning when I logged, the session times were all wrong eg.

it is 12 midday here now
and
user tracking states that it is
12 am, the start of a new day,

12:00 pm show up as 00:00 am, 01:00am show up as 13.00 pm :wacko:

Anyone have any idea as to what may have caused this and has anyone else had this problem?

BTW My computer states the right time and day!!
TIA

Quote:

---

Originally Posted by heavenlynights

Hi Everyone

I have a bit of a problem with UT. I have using it for a long time now with not too many problems, but this morning when I logged, the session times were all wrong eg.

it is 12 midday here now
and
user tracking states that it is
12 am, the start of a new day,

12:00 pm show up as 00:00 am, 01:00am show up as 13.00 pm :wacko:

Anyone have any idea as to what may have caused this and has anyone else had this problem?

BTW My computer states the right time and day!!
TIA

---

Sounds like it is showing your hosts local time.
In admin what time is shown?
Are you using the "Time zone offset" contrib, if so have you updated your site to 1.3.6 and not reinstalled the time zone offset contrib.
If not then all your time & dates on the orders & emails will be incorrect
The 1.3.6 version is coming real soon.

Quote:

---

Originally Posted by gilby

Sounds like it is showing your hosts local time.
In admin what time is shown?
Are you using the "Time zone offset" contrib, if so have you updated your site to 1.3.6 and not reinstalled the time zone offset contrib.
If not then all your time & dates on the orders & emails will be incorrect
The 1.3.6 version is coming real soon.

---

Hi again Gilby

ok this is the time that is on my admin

Quote:

---

Sat, 04 Nov 2006 21:35:02 +1100GMT which is correct

---

This is what a user session is showing minus a few (not to be published stuff) details. This is the very first session you see when you option UT

Quote:

---

Click Count: 3 Start Time: 23:45:38 Idle Time: -2:-11:00
End Time: 23:46:05 Total Time: 00:00:27

Country: Japan
IP Address: XXXXXXX
Host: XXXXXXX
Originating URL: http://www.heavenlynightslingerie.com.au/

---

Backgound

I have at present 2 sites, one which is not live yet and one which is.

The live site, heavenlynightslingerie.com.au is running 1.3.5 on a US based server, is running the latest UT and does not have the "Time zone offset" contrib installed.

The other site which is not live yet is running on the same server, and does not have the "Time zone offset" contrib installed either, but is upgraded to 1.3.6 UT and is running fine, no time abnomalities.

Time shown in Admin

Quote:

---

Sat, 04 Nov 2006 21:44:57 +1100GMT

---

Session

Quote:

---

Click Count: 4 Start Time: 16:27:52 Idle Time: 00:00:11
End Time: 21:44:46 Total Time: 05:16:54

Country:
IP Address: XXXX
Host: XXXXX
Originating URL: XXXXXXXX

---

Both of these site are pretty identical except one has the zen lightbox mod and is upgraded to 1.3.6. These are the only difference between the two sites and at the moment they are both sitting on the same domain.

Hope this helps, I am considering reinstalling the UT mod to see if that would make a change!!

Hi Again

Ok I just had a look at the who's on-line feature and found a couple of odd sessions, don't know if this has anything to do with my prob or not with UT - sessions are below minus session ids

Quote:

---

22:25:02 0 ¥Guest 24.136.156.12 00:24:45 00:24:45
Time Since Clicked:
22:25:02 ago Session ID: XXXXXXXX
Host: user-0c8h70c.cable.mindspring.com
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
/catalogue/index.php?main_page=product_info&cPath=26&products_id=120

22:25:01 0 ¥Guest 24.136.156.12 00:24:46 00:24:46
Time Since Clicked:
22:25:01 ago Session ID: XXXXXXXX
Host: user-0c8h70c.cable.mindspring.com
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
/catalogue/index.php?main_page=product_info&cPath=26&products_id=120

---

Both session are from the same ip address and both are still open from over 22 hours ago. I would have figured that both of these session should have expired by now.

Below is what my sessions are set to in admin configuration.

Quote:

---

Session Directory my website
Cookie Domain True
Force Cookie Use False
Check SSL Session ID False
Check User Agent False
Check IP Address False
Prevent Spider Sessions True
Recreate Session True
IP to Host Conversion Status

---

Thanks for any thoughts on this.

Sounds like its best to reinstall...

Be aware that UT gets confused with sessions that run over different days. It can't separate clicks between different days with the same session.

Quote:

---

Originally Posted by gilby

Sounds like its best to reinstall...

Be aware that UT gets confused with sessions that run over different days. It can't separate clicks between different days with the same session.

---

Thanks gilby, will give that a try.

Here is one that had me confused for a while.

A customer had just completed a sale.
Checked whosonline, same customer shown with completed transaction.

Checked UT, saw a different customer had that session.
Checked the session details and worked out that 2 people used the same computer and both had logged in, one after the other.

Whosonline correctly showed the most recent logged on customer.
UT incorrectly showed the first person to log on.

Would be helpful in the tracking if we could who see had attempted to log in.

Quote:

---

Originally Posted by gilby

Sounds like its best to reinstall...

Be aware that UT gets confused with sessions that run over different days. It can't separate clicks between different days with the same session.

---

update:

I decided to wait till morning to try the reinstall, but low and behold, went into UT and issue re: time difference had corrected itself. :huh:

Hi,

Thanks for a great mod :thumbsup:

For my ezpages, I'm getting 'page 2' for the title rather than the actual title. Normal product pages and define pages show the correct titles.

Best regards
Alan

[typo in title I can't change :( ]

Hi,

Anyone used User Track Module with Admin Profiles Module ?

This, because I cannot set the admin-permissions for the user tracking module:sleepy:


grmx

Zen 1.35

Hi,

Is it just me, or are other people also getting 'Page 2' for the title for EZPages, rather than the actual title.

Thanks
Alan

Quote:

---

Originally Posted by firehorse

Hi,

Is it just me, or are other people also getting 'Page 2' for the title for EZPages, rather than the actual title.

Thanks
Alan

---

No not just U, I have this problem also and have had it for a long time, since the beginning. Don't know how to fix though!! :lamo:

Hi,

Quote:

---

Originally Posted by heavenlynights

No not just U, I have this problem also and have had it for a long time, since the beginning. Don't know how to fix though!! :lamo:

---

I tracked down this

\includes\functions\extra_functions\user_tracking.php
Line 90

Code:

---

                else
                        {
                                $page_desc = addslashes(HEADING_TITLE);
                                if ($page_desc == "HEADING_TITLE")
                                        $page_desc = addslashes(NAVBAR_TITLE);
                        }

---

The code 'looks' fine as HEADING_TITLE gets defined all the time but I'm no expert :laugh:

I remember I used "Page 2" as an experiment and although there are no links to it anymore, it was still set on option 1, under Configuration/Define Page Status. I've changed it to option 3. I will report back if this make a difference.

Heavenlynights, is your Page 2 set to option 1?

Best regards
Alan

Hi,

Nope, that doesn't seem to work. Just had someone on my site and there was a Page 2. I believe this is the code that needs looking at

\includes\functions\extra_functions\user_tracking. php - Line 73

Code:

---

                        if (($_GET['products_id'] || $_GET['cPath']))
                        {
                                if ($_GET['cPath'])
                                {
                                        $cPath = $_GET['cPath'];
                                        $cPath_array = zen_parse_category_path($cPath);
                                        $cPath = implode('_', $cPath_array);
                                        $current_category_id = $cPath_array[(sizeof($cPath_array)-1)];
                                        $page_desc_values = $db->Execute("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $current_category_id . "'");
                                        $page_desc = addslashes($page_desc_values->fields['categories_name']) . ' ';
                                }
                                if ($_GET['products_id'])
                                {
                                        $page_desc_values = $db->Execute("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $_GET['products_id'] . "' and language_id = '" . $_SESSION['languages_id'] . "'");
                                        $page_desc .= addslashes($page_desc_values->fields['products_name']);
                                }
                        }
                        else
                        {
                                $page_desc = addslashes(HEADING_TITLE);
                                if ($page_desc == "HEADING_TITLE")
                                        $page_desc = addslashes(NAVBAR_TITLE);
                        }

---

So PSEUDO CODE
Change

Code:

---

if (($_GET['products_id'] || $_GET['cPath']))

---

to

Code:

---

if (($_GET['products_id'] || $_GET['cPath'] || $_GET['id'] ))

---

because ezpages use 'id'. I don't know if you need to check for chapter as well.

then add

Code:

---

        if ($_GET['id'])
        {
                $page_desc_values = $db->Execute("GET EZPAGE TITLE";
                $page_desc .= addslashes($page_desc_values);
        }

---

Or something like that :P

Can anyone help?

Best regards
Alan

Quote:

---

Originally Posted by Pinghead

To all the users of the usertracking mod!

I'm in the process of upgrading to 1.3.0.1 from 1.2.6, and translating the english files to swedish (8815 lines of code...) and fixing the other mods I've installed.

Please bear with me, this will take a while.

In the meantime, post problems and solutions to the usertracking mod in this thread.

---

still need a logo?

Quote:

---

Originally Posted by mrtorrez

Anyone used User Track Module with Admin Profiles Module ?
This, because I cannot set the admin-permissions for the user tracking module

---

Beginning with Admin Profiles 1.04 Kuroi provided both a box file and a sql patch to workaround the User Tracking menu issues (a brief mention is in the Admin Profiles readme).

I just installed both Admin Profiles 1.06 and most recent User Tracking (08-30-06) on Zen Cart 1.36. The box file and sql patch seemed to fix it so 'User Tracking Config' shows up in the "Tools" menu. But now being a little more observant I see the 'User Tracking Config' menu entry disappears when I select another menu other than the "Tools" menu. However when I select another item from the "Tools" menu then 'User Tracking Config' reappears on the Tools menu. Now you see it. Now you don't.

I had the impression that 'User Tracking Config' was suppose to appear in the "Configuration" menu? On previous Zen Cart versions it did.

The mystery continues...

Woody

Woody!
1. Run this sql-patch:

Code:

---

UPDATE configuration_group SET visible = '1' WHERE configuration_group_id =999 LIMIT 1 ;

---

2. Remove user_tracking_config.php from user_tracking_tools_dhtml.php box (for admin_profile):

Code:

---

$options = array( array('box' => BOX_TOOLS_USER_TRACKING, 'page' => FILENAME_USER_TRACKING),
                                );

---

3. Remove user_tracking_config.php file from admin directory.

Firehorse:

The problem with user tracking not listing the correct page name for ez pages is due to a line missing in the ez pages support code.

To correct the problem, edit includes/modules/pages/page/header_php.php

Locate the line which says:

Code:

---

define('NAVBAR_TITLE', $var_pageDetails->fields[pages_title]);

---

and directly under this line add:

Code:

---

define('HEADING_TITLE', $var_pageDetails->fields[pages_title]);    // JTD:10/03/06 - for user tracking

---

I believe you will find then that the correct page names are displayed.

Hope this helps!

Jeff

Also if anyone is interested...

Over the years we have updated the user_tracking.php tool and made a few bug fixes. One feature we added was changing the script into a form and adding a popup date selection menu so you can select a specific date to begin the listing. This has proven invaluable since we actually keep several months worth of logs and it was difficult to page though using the previous page at a time GET method.

In any case, I have not previously read this thread so there could be a newer version out with other features or bug fixes. Perhaps who ever is maintaining the code (Pinghead) these days could merge this version with any fixes and updates previously done and make a new release. For now though, if you want to give the version we use a try, it is available here:

user_tracking.zip.

BTW, this is just the single admin/user_tracking.php file and assumes you already have a working installation.

Respectfully,
Jeff

Hi,

Quote:

---

Originally Posted by JeffD

Firehorse:

The problem with user tracking not listing the correct page name for ez pages is due to a line missing in the ez pages support code.

To correct the problem, edit includes/modules/pages/page/header_php.php

Locate the line which says:

Code:

---

define('NAVBAR_TITLE', $var_pageDetails->fields[pages_title]);

---

and directly under this line add:

Code:

---

define('HEADING_TITLE', $var_pageDetails->fields[pages_title]);    // JTD:10/03/06 - for user tracking

---

I believe you will find then that the correct page names are displayed.

Hope this helps!

Jeff

---

Many thanks :thumbsup:

Just trying it now.

Best regards
Alan

You're welcome...

Let me know if that takes care of the problem and feedback on the updated version posted if you choose to try it?

Thanks,
Jeff

Quote:

---

Originally Posted by gilby

Here is one that had me confused for a while.

A customer had just completed a sale.
Checked whosonline, same customer shown with completed transaction.

Checked UT, saw a different customer had that session.
Checked the session details and worked out that 2 people used the same computer and both had logged in, one after the other.

Whosonline correctly showed the most recent logged on customer.
UT incorrectly showed the first person to log on.

Would be helpful in the tracking if we could who see had attempted to log in.

---

I too just observed the same behavior when testing the most recent UT mod on a fresh ZC 1.36 install. I don't remember observing this behavior previously when running UT on ZC v. 1.302 or 1.27. I was not able to test on 1.35.

I logged in to a customer account. Then logged out. Then naviagated the catalog as a guest.

User Tracking shows all my clicks listed under the logged in user session including my clicks after logging out and naviagating as a guest .

Although this is not a major issue for my situation I can see it would be for those tracking admin usage in a mult-user office environment or those who expect different customer logins using the same IP address.

Quote:

---

Originally Posted by JeffD

Over the years we have updated the user_tracking.php tool and made a few bug fixes. One feature we added was changing the script into a form and adding a popup date selection menu so you can select a specific date to begin the listing. This has proven invaluable since we actually keep several months worth of logs and it was difficult to page though using the previous page at a time GET method.

In any case, I have not previously read this thread so there could be a newer version out with other features or bug fixes. Perhaps who ever is maintaining the code (Pinghead) these days could merge this version with any fixes and updates previously done and make a new release. For now though, if you want to give the version we use a try, it is available here:

user_tracking.zip.

BTW, this is just the single admin/user_tracking.php file and assumes you already have a working installation.

---

Hi Jeff,

Petter stated previously in this thread that he will not be able to continue work on the User Tracking mod:
http://www.zen-cart.com/forum/showpo...2&postcount=79

Can you integrate your UT code updates into a new version and upload to the ZC download area? Maybe we could "beta" test your updates here before uploading a new version?

BTW I just installed your updated /admin/user_tracking.php file. And I like.

I do note the content associated with the ENTRY_START_DATE and ENTRY_START_DATE_TEXT defines do not display. Is there another file we are suppose to upload or patch or icon images which need uploaded? The snippet below is where the defines are called in /admin/user_tracking.php

Quote:

---

<tr>
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
<td class="main"><?php echo ENTRY_START_DATE; ?></td>
<td class="main">
<?php
echo zen_draw_pull_down_menu('sdate_month', $date_month, $start_date_month_val);
echo zen_draw_pull_down_menu('sdate_day', $date_day, $start_date_day_val);
echo zen_draw_pull_down_menu('sdate_year', $date_year, $start_date_year_val);
echo zen_not_null(ENTRY_START_DATE_TEXT) ? '<span class="inputRequirement">' . ENTRY_START_DATE_TEXT . '</span>': '';
?>
</td>
<td class="main" align="left"><?php echo zen_image_submit('button_report.gif', 'Update Report'); ?></td>

</tr>

---

Woody

Quote:

---

Originally Posted by a_berezin

Woody!
1. Run this sql-patch:

Code:

---

UPDATE configuration_group SET visible = '1' WHERE configuration_group_id =999 LIMIT 1 ;

---

2. Remove user_tracking_config.php from user_tracking_tools_dhtml.php box (for admin_profile):

Code:

---

$options = array( array('box' => BOX_TOOLS_USER_TRACKING, 'page' => FILENAME_USER_TRACKING),
                                );

---

3. Remove user_tracking_config.php file from admin directory.

---

Thanks Andrew! That did it.

One thing in step number two above. Looks like maybe an extra comma? So should it be:

Code:

---

$options = array( array('box' => BOX_TOOLS_USER_TRACKING, 'page' => FILENAME_USER_TRACKING) );

---

Above is how I did it and it worked. Or maybe the comma doesn't matter? Thanks again.

Woody

Woody:

Yes I forgot to send the updated language file, sorry!

For now add these to: includes/languages/english/user_tracking.php

Code:

---

define('ENTRY_START_DATE', 'Start:');
define('ENTRY_START_DATE_TEXT', '*');

---

I will try to put an updated archive which contains the latest code, GEO_IP data and country flags and upload it to the contrib area early next week. For now the above should get you through.

Thanks for the feedback,
Jeff

Quote:

---

Originally Posted by JeffD

For now add these to: includes/languages/english/user_tracking.php

Code:

---

define('ENTRY_START_DATE', 'Start:');
define('ENTRY_START_DATE_TEXT', '*');

---

---

I assume you meant to add to:
admin/includes/languages/english/user_tracking.php

;-)

Quote:

---

Originally Posted by JeffD

I will try to put an updated archive which contains the latest code, GEO_IP data and country flags and upload it to the contrib area early next week. For now the above should get you through.

---

Very good! Happy Turkey Day!

Woody

Quote:

---

Originally Posted by Woodymon

I too just observed the same behavior when testing the most recent UT mod on a fresh ZC 1.36 install. I don't remember observing this behavior previously when running UT on ZC v. 1.302 or 1.27. I was not able to test on 1.35.

I logged in to a customer account. Then logged out. Then naviagated the catalog as a guest.

User Tracking shows all my clicks listed under the logged in user session including my clicks after logging out and navigating as a guest .

---

I change Config > Sessions > Recreate Session
to False.

Continue to observe same negative behavior in User Tracking.

If it is relevant my configure.php files show:
define('STORE_SESSIONS', 'db');

Anyone with clues on this?

Wood

This is really not a bug in User Tracking but instead an artifact of the way PHP and Zencart use and maintain sessions. Even though you logout of a customers account and zen_session_destroy() is called, the browser session id remains the same and therefore each UT table write thereafter continues to log based on that session id. The user is tracked as Guest after logoff but because the session was associated previously with the account the tracking report continues to use the name of the last account that used that session.

It is possible this behaved differently in 1.2x Zencart as there were changes made to the logoff and the session handling since that version but at least for now I don't see an easy way to change this behavior. :no:

Jeff

Hi all:

I have uploaded a new version of the user tracking tool to the Zencart downloads area. Until it is released I updated the user tracking archive posted previously in (post 131) above to include the full fileset with all recent changes.

Taken from the readme, here are a list of the changes:

Modified the user_tracking.sql by extending the size of the last_page_url field from 64 characters to 128 characters as this was previously too short and would often truncate URL link data.

Truncated the session_id field from 128 characters to 32 characters as this was wasted space.

Changed the script itself into a form and added a popup date selection menu so you can select a specific date to begin the listing.

Fixed the functions to work with sql 5.x and for longer last_page_url field writes.

Added a missing country flag or two.

Included the latest GeoIP.dat file.

Updated language defines for the popup additions.

Installation is simple, just replace all current files with those in the archive and execute the sql provided in the readme.

Please let me know if you find any issues?

Jeff

Quote:

---

Originally Posted by JeffD

It is possible this behaved differently in 1.2x Zencart as there were changes made to the logoff and the session handling since that version but at least for now I don't see an easy way to change this behavior.

---

Yes I don't see this same behavior in a 1.27 shop yet to be upgraded.

Firefox2 provides an ability to manually clear "authenticated sessions" from private data. When I do this and then log back in to the customer account, User Tracking running on the 1.3x shop, indeed shows a new session was created.

Pity the changes from 1.2x to 1.3x decreased the usefulness of the User Tracking mod.

Thanks for the info.

Woody

Quote:

---

Originally Posted by JeffD

Modified the user_tracking.sql by extending the size of the last_page_url field from 64 characters to 128 characters as this was previously too short and would often truncate URL link data.

---

Hi Jeff-

My assumption is the sql below is for those updating from the previous version of User Tracking (08/31/2006 - Version: 20060805 by PingHead)?

Quote:

---

Below is the commands necessary for the sql patch tool to alter the table to the new format described in the user_tracking.sql and described above:

ALTER TABLE `user_tracking` CHANGE `session_id` `session_id` VARCHAR(32);
ALTER TABLE `user_tracking` CHANGE `last_page_url` `last_page_url` VARCHAR(128);

---

Thanks for the update,
Woody

Yes, if you want to keep current table data intact just execute those two commands or if you don't care and want to drop the table and create a fresh one execute the user_tracking.sql contents.

Jeff

Regarding Jeff's new update...

Using previous version I implemented the following solution provided by Andrew (a_berezin) in post #129 of this thread, to make User Tracking work correctly with Admin Profiles installed (solves issue with User Tracking Config incorrectly displaying twice in the admin menus, so instead of also showng up in the Tools menu, it now only displays on the Configuration menu).

Quote:

---

21st November 2006, 01:51 PM

1. Run this sql-patch:

UPDATE configuration_group SET visible = '1' WHERE configuration_group_id =999 LIMIT 1 ;

2. Remove user_tracking_config.php from user_tracking_tools_dhtml.php box (for admin_profile):

$options = array( array('box' => BOX_TOOLS_USER_TRACKING, 'page' => FILENAME_USER_TRACKING) );

3. Remove user_tracking_config.php file from admin directory.

---

Following step 3 above should I not upload /admin/user_tracking_config.php for the new version?

Thanks,
Woody

I've just installed this for the first time & am getting the following error when I try to access User Tracking Configuration in admin:

Fatal error: Cannot use object of type queryFactoryResult as array in /home/blubrix/public_html/admin/user_tracking_config.php on line 107

The main User Tracking page in admin seems to be working just fine, it's just the configuration that's not pulling through here. I'm using 1.3.6...no previous installs of this mod & no Admin Profiles installs either.

Woody:

Yes, if you can somehow force the session id to change once you logoff as the customer (by any means available) then the user tracking data should display as "Guest" for the balance of the browser session.

The problem is simply when you logoff as a customer the session id remains the same (even though the session has been destroyed) so the session tracking continues to record (as Guest) but under the existing (same) session id and since the session id was previously associated with the customer account, continues to display this way. I am not aware of any PHP call that could be made at this point to aquire a different session id.

Jeff

Comparing the contents of /admin/images/flags in the new version of User Tracking with he previous version.

I observe two new flag image files
ps.gif
sv.gif

The flags directory for the new version contains 170 flag images.

I observe the following files are no longer provided:
kw.gif (Kuwait)
.gif
0.gif

Any thoughts why the flag for Kuwait was deleted from /admin/images/flags and which countries PS & SV represent?

And what did 0.gif and .gif. I know they both were the same image but could not identify the flag.

I observe the 'countries' table for Zen Cart 1.36 contains 240 records. Any ideas on how to round up additional 70 missing flag images?

In the 'countries' table I observe no reference to any country with PS or SV in the countries_iso_code_2 field.

Anyone know of a quick method to confirm the number of countries listed in the GeoIP.dat database?

Anyone know if the ISO is the authoritative source for the actual number of countries "in existence" at a particular time.

Woody

irischant:

I'm sorry there were errors and ommisions in the sql of the archive.

Please execute the following in the sql patch too and it should get you fixed up:

Code:

---

DROP TABLE IF EXISTS user_tracking;
CREATE TABLE user_tracking (
  `customer_id` int(11) default NULL,
  `click_id` int(11) default NULL,
  `full_name` varchar(64) NOT NULL default '',
  `session_id` varchar(32) NOT NULL default '',
  `ip_address` varchar(15) NOT NULL default '',
  `time_entry` varchar(14) NOT NULL default '',
  `time_last_click` varchar(14) NOT NULL default '',
  `last_page_url` varchar(128) NOT NULL default '',
  `referer_url` varchar(254) NOT NULL default '',
  `page_desc` varchar(64) NOT NULL default ''
) TYPE=MyISAM;




DELETE FROM configuration where configuration_group_id = '999';
INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);
INSERT INTO configuration VALUES ('', 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', 999, 2, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', 999, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period.<br>(SET to 999999 for unlimited per 24 hour period)<br>NOTE:<BR>Watch you space !', 999, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automaticly after this url)', 999, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', 999, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

---

I will correct the archive sql and re-upload in a few minutes.

Jeff

Hi Jeff

I just applied that patch, cleared my browser cache & am still getting the same error.

Woody:

If you have additional flags that you've added (like Kuwait) send them to me and I'll include them in the archive. The ones I've added were simply a result of finding missing image indicators in the output and figuring out what country it was, locating a flag for said country and scaling it to size. The ps.gif is Palestine Occupied Territory, it was the last I added so I remember it. Don't remember what sv.gif is now.

I don't believe the 0.gif and .gif are needed any more as I fixed the code to display a US flag if GEO_IP doesn't return a valid reference...

I don't have answers for the balance of your questions, sorry!

Jeff

Woody:

Open the file admin/includes/geoip.inc to see the possible GEO_IP country return codes. Hope this helps!

Jeff

Quote:

---

Originally Posted by JeffD

The problem is simply when you logoff as a customer the session id remains the same (even though the session has been destroyed) so the session tracking continues to record (as Guest) but under the existing (same) session id and since the session id was previously associated with the customer account, continues to display this way.

---

Thanks for the info Jeff,

Is this not by Zen Cart design? So that the guest shopping cart contents remains known when the guest creates/logs into an account (when the cart for the guest and newly logged in user are merged).

And also the same if logged in user logs out, and then later logs back in?

So is the session_id IP based or browser based? That is if I moved to another PC using the same IP, or fired up a different browser on the same PC, would we see the same effect? I hope I am being clear. Time for some research on my part. ;-)

I suspect the ZC Dev team has been dealing with this issue since day one.

Woody

Jeff...I think I've tracked it down here

in user_tracking_config.php starting with line 106 I've changed the following from:

Code:

---

    if (((!$HTTP_GET_VARS['cID']) || (@$HTTP_GET_VARS['cID'] == $configuration->fields['configuration_id'])) && (!$cInfo) && (substr($HTTP_GET_VARS['action'], 0, 3) != 'new')) {
      $cfg_extra = $db->Execute("select configuration_key, configuration_description, date_added, last_modified, use_function, set_function from " . TABLE_CONFIGURATION . " where configuration_id = '" . $configuration['configuration_id'] . "'");

      $cInfo_array = array_merge($configuration, $cfg_extra);
      $cInfo = new objectInfo($cInfo_array);
    }

---

to:

Code:

---

    if (((!$HTTP_GET_VARS['cID']) || (@$HTTP_GET_VARS['cID'] == $configuration->fields['configuration_id'])) && (!$cInfo) && (substr($HTTP_GET_VARS['action'], 0, 3) != 'new')) {
      $cfg_extra = $db->Execute("select configuration_key, configuration_description, date_added, last_modified, use_function, set_function from " . TABLE_CONFIGURATION . " where configuration_id = '" . (int)$configuration->fields['configuration_id'] . "'");

      $cInfo_array = array_merge($configuration->fields, $cfg_extra->fields);
      $cInfo = new objectInfo($cInfo_array);
    }

---

Seems to work peachy now ;c)

irischant:

Thanks for updating the code and posting your fix. You may have some more restrictive PHP settings regarding arrays than some as I have not had an issue here but your fixes make sense so I will include them in the next update. Again thank you!


Woody:

No, not by Zencart design but rather by PHP design since the session id is actually generated from within the PHP engine not within Zencart code.

The session is used in Zencart to track the user so yes in that case when he creates an account, has his cart merged etc., the session id is used as the reference.

The session id is neither IP based nor browser based. As I said it is generated by the PHP server to track a specific HTTP connection. If the same user logs out and back in without closing the browser he will likely get the same session id, unless the session has expired in which case he may get a different session id.

Different machines will get different sessions always but multiple connections on the same machine with the same browser will share the same session. Try opening several Firefox browser instances connecting to your store and several through I.E. and you will likely see two different sessions between browsers (unless you log in as the same customer in which case your sessions will be merged). If you play around like this while watching your user tracking session id's I think it will become clearer how it all works.


Hope this helps!
Jeff

Quote:

---

Originally Posted by JeffD

Open the file admin/includes/geoip.inc to see the possible GEO_IP country return codes. Hope this helps!

---

Good eye. From the include file I calculated the latest version of GeoIP.dat supports 243 countries.

So the countries' table Zen Cart 1.36' is missing 3 countries. Or maybe not. I see GeoIP includes EU which is not a country per se.

I found an ISO list at:
http://www.iso.org/iso/en/prods-serv.../list-en1.html

ISO site currently shows 244 official short names and code elements.

I see a good source of medium and larger sized flags at https://www.cia.gov/cia/publications...ftheworld.html

What is the generally acceptable source for those tiny flag gif files? I think the same are used by AWStats.

So my tally is:
Zen Cart = 240
ISO = 244
GeoIP = 243
CIA = 237
UT flags = 170

I never know when a potential customer from the ÅLAND ISLANDS may visit my shop and then submit a huge order. Need to be ready for that day ;-)

-Woody

Woody:

AFAIK they are simply 18px wide by 12px high gif images.

BTW, I think you just volunteered to be the official user_tracking country flag provider! When you have them all ready... send them to me and I'll update the archive. :laugh:

Thanks!
Jeff

Woody:

Here is another list of small flags for your examination:

http://www.kidlink.org/icons/flagdir.html

Thanks!
Jeff

Quote:

---

Originally Posted by JeffD

Different machines will get different sessions always but multiple connections on the same machine with the same browser will share the same session. Try opening several Firefox browser instances connecting to your store and several through I.E. and you will likely see two different sessions between browsers (unless you log in as the same customer in which case your sessions will be merged). If you play around like this while watching your user tracking session id's I think it will become clearer how it all works.

Hope this helps!

---

Yes that was very helpful. When I stated "browser based" what you descibe above is what I was referring to. Different browsers on the same machine will not share the same session. But if multiple connections made from different windows/tabs in the same browser they would share the same session. Because the connections from each window refers to the same browser client side authenticated sessions table.

So if this is an inherent structural feature in the PHP-Apache platform, wondering how carts developed on other development platforms/languages deal with this issue? Or do they?

Time for me to take a PHP/LAMP programing class.

Woody

Woody:

Every language that supports HTTP protocol has the concept of a session object and accessors to add and remove session parameters, check for session expiration, etc. This would include JAVA, C++, PERL, and the list goes on and on. They all pretty much do the same thing as PHP so if you learn one you learn them all. :yes:

Jeff

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:

Code:

---

  zen_session_destroy();

---

and just before this line add:

Code:

---

  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

Quote:

---

Originally Posted by JeffD

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

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?

Quote:

---

Originally Posted by 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?

---

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

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

Quote:

---

Originally Posted by JeffD

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

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

Quote:

---

Originally Posted by 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...

---

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

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

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

This post may help with your first question: http://www.zen-cart.com/forum/showpo...&postcount=129

You have to click the "View Session" link to see the actual session data.

Hope this helps!
Jeff

Quote:

---

Originally Posted by 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.

---

See a_berezin's post previously in this thread (a week ago or so). His three step solution workaround repairs the admin menu issues when Admin Profiles and User Tracking are both installed.

Quote:

---

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?

---

Can you provide a screenshot? Should show much more that that. Sounds like some files were not uploaded. And you are certain you patched the database and followed the part in the readme where it says:

Code:

---

File Modifications: 2

add the following to the end of /includes/templates/ YOUR TEMPLATE /common/tpl_footer.php

<?php if (ZEN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?>

add if you want to track admin pages viewed add the following to the end of /admin/includes/footer.php

<?php if (ADMIN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?>

---

And in admin see Configuration > User Tracking Config to ensure settings are to your liking.

Quote:

---

Originally Posted by JeffD

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.

---

Yes I reverted back to pinghead's latest version (released 08-31-06) which is available via the downloads area.

Woody

http://www.shivashade.com/images/userdata.jpg


This what I get. It just lists the number of page visits, but I cant get anything else. I see all the DB entries and it seems fine.

I fixed the admin_profile issue by going into the database and adding the page to my admins profile automatically.

I just got the user mod installed yesterday and go to see who was looking this morning. On the admin home page, the hit counter showed about 400 more hits than it did last evening. But when I go into tools/user tracking, it says that there have been 0 page views in the last 24 hours. Huh? I checked the config to make sure I had it set up correctly and it looks okay. Anyone know what I might need to do?

Thanks so much

You didn't by chance forget this step from the readme did you?

Code:

---

File Modifications: 2

add the following to the end of /includes/templates/ YOUR TEMPLATE /common/tpl_footer.php

<?php if (ZEN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?>

add if you want to track admin pages viewed add the following to the end of /admin/includes/footer.php

<?php if (ADMIN_CONFIG_USER_TRACKING == 'true') { zen_update_user_tracking(); } ?>

---

Or perhaps you modified the wrong footer file(s)...

That's about the only thing I can think of that would keep the logging from occuring. Let me know?

Jeff

I bet that's it! THANKS

There is an updated version of User Tracking found here:


user_tracking.zip

This version now properly displays the product name when tracking a product page (as per Woody's report) and also now properly tracks page names on the admin side in all instances.

As these were minor changes I will probably wait until more major changes are added before uploading this version to the downloads area but you can access for now from the above link.

Please let me know if you find any issues?

Thanks,
Jeff

Quote:

---

Originally Posted by JeffD

There is an updated version of User Tracking found here:


user_tracking.zip

---

Jeff-

Is your latest version based on the last version of pinghead's UT release as is available in the downloads area?m His last version was released Aug. 05, 2006 with a sql patch update released on Aug 31, 2006.

Quote:

---

Author: PingHead
Version: 20060805
Zen Cart Version: v1.3.0
Update added on 08/31/2006

---

The reason I'm asking is because I'm wondering if all the functionality and improvements included pinghead's last few releases are also included in your most recent version. I see a few posts back you stated your current release was based on a previous Use Tracking mod version from a year ago. (But I am not sure why).

Thanks for the update.

Woody

Quote:

---

Originally Posted by JeffD

There is an updated version of User Tracking found here:


user_tracking.zip

---

Hi Jeff-

Just now installing your latest update for testing. When posting future UT "beta" or "micro" updates is it possible you could report which files are changed from previous version and if sql patch is required? Also including a version number in the zip archive filename, even if just appending b04 (for beta 04) would be helpful in not getting these updates mixed up. Pinghead was appending the date to his previous versions so that might be a good naming nomenclature to maintain (e.g. user_tracking_120106.zip or user_tracking_061201). Just some suggestions. ;-)

Woody

Woody:

The version uploaded is based on the original code contributed by Dave Kennelly at open-operations.com since that is the code both myself and Pinghead started with over a year ago.

The reason it is not based on the PingHead version of the code is because that version did not exist a year ago when we began making additions and improvements to the original contribution. We have, over the last year or so improved and added new features independently of the version of the code Pinghead had been working with.

I did difference the two versions recently when I was told of that version's existance and although they are very different (our version is form based, uses POST to specify a selectable date range rather than just using a fixed GET date, improved database schema, etc.) I could detect very few distinguishable feature improvements between the two because as it turns out we both probably made many of the same bug fixes and feature improvements during that time period.

As I've said previously though, if there is something I missed in the previous version that is important and doesn't exist in this version I'll try to add it, just let me know?

Jeff

Thanks for repairing your UT so those heading titles show up. Much better. Wondering if you could remove the category title from the product page titles.

So instead of:

"TestCategory 1 TestProduct 1"

would be better if we should see:

"TestProduct 1".

Just my opinion but easier to digest the UT info at a glance if just the product name was displayed. (Hint: That's how it is in the latest pinghead version).

Another questions although this is not really just a UT question.

The default heading_title define for the index page is " Congratulations! You have successfully installed your Zen Cart...".

So that does not display I've edited and removed from /includes/languages/english/index.php

Code:

---

Line #51 : define('HEADING_TITLE', 'Congratulations! You have successfully installed your Zen Cart™ E-Commerce Solution.');

Line #55 : define('HEADING_TITLE', 'Congratulations! You have successfully installed your Zen Cart™ E-Commerce Solution.');

---

So instead I have:

define('HEADING_TITLE', '');

In this case do you have any suggestions on how to make it so the UT log displays "index" or something relevant instead of a completely blank field when logging clicks on the home page?

If URL =
/shop/index.php
-or-
/shop/index.php?main_page=index
then heading_title = "index"

or something like that.

Woody

Jeff:

BTW it appears that your UT version runs quite a bit faster than previous versions. It may have something to do with running your UT on v.1.36 versus running older UT on a v.1.27 shop. But running on the same server right now I am noticing a larger performance diff. A more honest comparison will have to wait for the new shop to go love and for the UT table to fill up to appx same number of entries as the current shop. Thought you would want to know. Good work!

Woody

Need help here.
I have admin_profile installed on zc 1.36 and just installed this user_track MOD. Somehow I do not see any thing under User tracking config. I have been read through all 19 pages and seems can't find answer. Any clue?

Quote:

---

Originally Posted by john95051

Need help here.
I have admin_profile installed on zc 1.36 and just installed this user_track MOD. Somehow I do not see any thing under User tracking config. I have been read through all 19 pages and seems can't find answer. Any clue?

---

Which admin menu are you seeing "User tracking Config"? Configuration or Tools?

Look in an optional folder bundled with Admin Profiles. Apply that fix. Then follow a_berezin's workaround in his last post in this thread. That fixed it for me.

Woody

Woody:

I have made the category output optional via a configuration switch now in the archive version posted previously in this thread. To edit an existing version to add this switch, follow the below instructions:

In the file includes/functions/extra_functions/user_tracking.php

Locate the line which says:

Code:

---

                if ($_GET['cPath']) {

---

And replace this line with:

Code:

---

                if ($_GET['cPath'] && ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY == 'true') {  // JTD:12/04/06 - Woody feature request

---

Then execute the following in the patch tool:

Code:

---

INSERT INTO configuration VALUES ('', 'User Tracking (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', 999, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

---

The category name is still 'On' by default but now you can turn it 'Off' in the User Tracking Config settings.


As for what I would suggest on the home page, try this:

In the file includes/templates/YOUR_TEMPLATE/templates/tpl_index_default.php

Find:

Code:

---

<h1 id="indexDefaultHeading"><?php echo HEADING_TITLE; ?></h1>

---

Replace with:

Code:

---

<h1 id="indexDefaultHeading"></h1>

---

Then in the file includes/languages/english/YOUR_TEMPLATE/index.php

Code:

---

define('HEADING_TITLE','Home Page');

---

or whatever you want the listing output to indicate.

The reason this version runs much faster than previous versions is that we have eliminated the call to gethostbyaddress() that was made for each ip address during the report listing. This produced extreme overhead since this call is effectively a DNS server query for each and every address and instead added the resolved host name to the record itself, since we already have that for each connection.

Hope this helps!
Jeff

Quote:

---

Originally Posted by JeffD

As for what I would suggest on the home page, try this:

In the file includes/templates/YOUR_TEMPLATE/templates/tpl_index_default.php

Find:

Code:

---

<h1 id="indexDefaultHeading"><?php echo HEADING_TITLE; ?></h1>

---

Replace with:

Code:

---

<h1 id="indexDefaultHeading"></h1>

---

Then in the file includes/languages/english/YOUR_TEMPLATE/index.php

Code:

---

define('HEADING_TITLE','Home Page');

---

or whatever you want the listing output to indicate.

---

I'm just "testing" the UT mod update on fresh 1.36 install. For some reason the default ZC 1.36 HEADING_TITLE below was not appearing in User Tracking log when the home page was navigated to. As reported would kust show up blank.

Quote:

---

define('HEADING_TITLE', 'Congratulations! You have successfully installed your Zen Cart&trade; E-Commerce Solution.');

---

So I just edited the define to something short and it now shows up fine in the UT log. Go figure.

I do appreciate the alternative recommends.

Woody

Jeff-

Couple items for the UT wishlist:

1. Although there is plenty of white space before the right edge of the table/grid, the URL's in the UT log are prematurely wrapping to a second line. For example:

Quote:

---

/mytestshopcart/index.php?main_page=inde
x&cPath=1

---

2. Thanks for the new option in configuration to disable displaying the category title for product pages. However that fix causes blank titles to display when navigating the top level category and subcategory product listing pages.

Maybe test to see if URL is a product_info page. If so then don't display the category title. But if not a product_info page then display the category title.

Or something like that ;-)

Thanks,
Woody

Quote:

---

Originally Posted by Woodymon

1. Although there is plenty of white space before the right edge of the table/grid, the URL's in the UT log are prematurely wrapping to a second line. For example:

---

Discovered 40 characters are allowed per line before a break tag is inserted.

In /admin/user_tracking.php
On line appx line 371

Change the 40 to 50 or whatever number of characters you prefer ...

Code:

---

<td class="dataTableContent" width=100&#37; align="left"><a href="<?php echo $pu['value']; ?>" target="_new"><?php echo chunk_split($pu['value'],40,"<br>"); ?></a></td>

---

But I then tried removing the break:

Code:

---

<td class="dataTableContent" width=100% align="left"><a href="<?php echo $pu['value']; ?>" target="_new"><?php echo $pu['value']; ?></a></td>

---

Removing the hard break allows each log entry to display on one line. I do like this better.

But if your URL's are very long (e.g. if you have many levels of product subcategories, or if you are tracking admin logins w/ session id's, or are using SEO URL's) then you will likely often see a horizontal scrollbar at the bottom of your browser window, if you make this change. Your choice.

-Woody

1.3.6.1
I just tried to install and am getting an sql error. I dropped the table several times and tried to install the patch via both Myphp and the Zen tool with the same result.

Get the same error on 2 sites. Both are 1.3.6 zen and 1.3.6.1 of the mod.

I will also assume this is the reason there is no options under cinfig for this mod.
--------------------------------
SQL query:

INSERT INTO configuration_group( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )
VALUES ( 999, 'User Tracking Config', 'User Tracking', 31, 1 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '999' for key 1
----------------------------------------

Im a database dummy and need a little guidance as to whether its an error in the supplied sql or if its me.

Quote:

---

Originally Posted by inksale

1.3.6.1
I just tried to install and am getting an sql error. I dropped the table several times and tried to install the patch via both Myphp and the Zen tool with the same result.

Get the same error on 2 sites. Both are 1.3.6 zen and 1.3.6.1 of the mod.

I will also assume this is the reason there is no options under cinfig for this mod.
--------------------------------
SQL query:

INSERT INTO configuration_group( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )
VALUES ( 999, 'User Tracking Config', 'User Tracking', 31, 1 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '999' for key 1
----------------------------------------

Im a database dummy and need a little guidance as to whether its an error in the supplied sql or if its me.

---

I'm in the same club as you when it comes to databases :D but I vaguely remember coming across this issue somewhere in the old archives.

I think another mod you have installed is already using 999. Possibly the old Admin Levels? I know there are issues between those two if you are using the olds version.

It had something to do with the way the original User Tracking Code was written.

Please don't quote me on this! As nobody else has replied yet I thought I may as well post as it gives you something to go on.

Use this sql-path to install user tracking

Code:

---

DROP TABLE IF EXISTS user_tracking;
CREATE TABLE user_tracking (
  customer_id int(11) default NULL,
  click_id int(11) default NULL,
  full_name varchar(64) NOT NULL default '',
  session_id varchar(128) NOT NULL default '',
  ip_address varchar(15) NOT NULL default '',
  time_entry varchar(14) NOT NULL default '',
  time_last_click varchar(14) NOT NULL default '',
  last_page_url varchar(254) NOT NULL default '',
  referer_url varchar(254) NOT NULL default '',
  page_desc varchar(64) NOT NULL default '',
  KEY session_id (session_id),
  KEY time_entry (time_entry)
) TYPE=MyISAM;

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'User Tracking Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES (NULL, 'User Tracking Configuration', 'Set User Tracking Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'User Tracking';

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour? (each click will be recorded)', @t4, 1, now(), now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour? (each click will be recorded)', @t4, 2, now(), now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'User Tracking (exclude IP-Addresses)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IPs', 'Do NOT record these IP Addresses<br />(like webmaster/owners/company IPs)<br /><br />Examples:<br />192.168.1.1<br />192.168.1.0/255.255.255.0<br />192.168.1.0/24<br /><br />Or any combination of these separated with a comma:<br />192.168.1.1<b>,</b>192.168.2.0/255.255.255.0<b>,</b>192.168.3.0/24<b>,</b>192.168.1.2<br /><br />', @t4, 10, now(), now(), NULL, NULL),
(NULL, 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period.<br />(SET to 999999 for unlimited per 24 hour period)<br />NOTE:<br />Watch your space !', @t4, 15, now(), now(), NULL, NULL),
(NULL, 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Enter your favorite WHOIS tracking site<br />(the IP will follow automatically after this url)', @t4, 50, now(), now(), NULL, NULL),
(NULL, 'User Tracking (HostLookup)', 'CONFIG_USER_TRACKING_HOST_LOOKUP', 'true', 'Check the hostname of each IP address? (may cause slower display of UT data)', @t4, 20, now(), now(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

---

The sql is written to be used in the patch tool only. You would need to edit the sql and add the table prefix you are using to execute in PHPMyAdmin. The error you are seeing is probably okay as this would happen if the configuration group already exists which indicates you execute the sql twice.

You should see the config options under the Configuration menu. You didn't say if everything else is working so I'll assume it is working okay for you? Let us know if not and we will try to help?

Happy holidays!
Jeff

I used the SQL listed above and did not get any installation errors, however, it is still not working.

With the original SQL as well as this new one the configuration tool has no options to choose from.

On the user tracking page I am now getting this message.

1054 Unknown column 'customers_host_address' in 'field list'
in:
[select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, session_id, referer_url, customers_host_address from user_tracking where time_entry > 1166936400 and time_entry < 1167022800 order by time_last_click desc]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It appears that you have an older version of the user_tracking table and a newer version of the user tracking code installed. Please download the user tracking contrib again and execute the SQL for creating the user_tracking table which looks like:

Code:

---

DROP TABLE IF EXISTS user_tracking;
CREATE TABLE user_tracking (
  `customer_id` int(11) default NULL,
  `click_id` int(11) default NULL,
  `full_name` varchar(64) NOT NULL default '',
  `session_id` varchar(32) NOT NULL default '',
  `ip_address` varchar(15) NOT NULL default '',
  `time_entry` varchar(14) NOT NULL default '',
  `time_last_click` varchar(14) NOT NULL default '',
  `last_page_url` varchar(128) NOT NULL default '',
  `referer_url` varchar(254) NOT NULL default '',
  `page_desc` varchar(64) NOT NULL default '',
  `customers_host_address` varchar(64) NOT NULL default ''
) TYPE=MyISAM;

---

This should correct the problem. Let us know if not?

Good Luck!
Jeff

Just to keep this straight,
I dropped the table I had installed,
DL the contribution
Re-installed all the files by over righting them.
Installed the SQL included with the contribution.

The included SQL still gave me the original errors and there are no options in the config.

I dropped the table and reinstalled using the SQL listed above By Jeff.

The tracking now works but there are still no options in the configuration tool.

That is very odd that you would get the same SQL error (I assume you mean duplicate key 999) since the SQL if executed properly deletes this key?

Code:

---

DELETE FROM configuration where configuration_group_id = '999';

---

Can you clarify this?

Also, when you say:

Quote:

---

still no options in the configuration tool

---

Are you saying the Configuration->User Tracking Config menu choice is missing?

-or-

Do you mean when you select Configuration->User Tracking Config there are not six configuration switches listed?

Let me know and I will help?

Jeff

If you'd like a more "collision proof" approach, you could use:

Quote:

---

DELETE FROM configuration where configuration_group_id = '999';
DELETE FROM configuration_group where configuration_group_id = '999';
DELETE FROM configuration_group where configuration_group_title like '&#37;User Tracking%';
DELETE FROM configuration where configuration_title like '%User Tracking%';
INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES ('', 'User Tracking Config', 'User Tracking', 31, 1);

SELECT @gid := configuration_group_id
FROM configuration_group where configuration_group_title LIKE '%User Tracking%';

INSERT INTO configuration VALUES ('', 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', @gid, 2, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', @gid, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period.<br>(SET to 999999 for unlimited per 24 hour period)<br>NOTE:<BR>Watch you space !', @gid, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automaticly after this url)', @gid, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', @gid, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

---

That will actually let the database decide on the next Configuration Group ID number, then copy that number to a variable "gid" and use that in place of hardcoding 999.

Cancel that. It looks like UserTracking code uses a hardcoded 999 for the user_tracking_config.php file. You would need to change a lot of the hardcoding in the php code to set this variable properly.

@inksale: I had the same/similar issues as you report (I reported my solutions previously in the thread).

Originally the mod was designed to display "User Tracking Configuration" under Configuration menu. However during the later development history for the mod, the SQL was revised to display BOTH "User Tracking" and "User Tracking Configuration" under the Tools menus, which I think is the cause of many issues, with those who have installed a previous version and with thosw who have installed Admin Profiles mod.

Note that the Admin Profiles mod (from Kuroi) plays funny with User Tracking (or vice versa). In Kuroi's latest versions of Admin Profiles he provides some patch code and instructions to install to help if you have Admin Profiles installed. But I found that workaround did not solve my issue completely.

Then DrByte posted to this thread some work-arounds for the User Tracking Configuration menu issue, but that too was not a complete solution for me as I still had some issues of the User Tracking Configuration menu item sometimes not displaying, depending on which admin menu page I was viewing (dynamic disappearing ghost menus).

After all that my solution was to install the SQL patch from Andrew (a_berezin). The result of that is "User Tracking Configuration" correctly displays under the "Configuration" menu, just as the original User Tracking mod was designed to do. And most importantly all the menu items correctly show up fine on the User Tracking Configuration page.

Also be sure to edit your Admin Profiles "permissions" to allow display of the "User Tracking Configuration" menu items for whichever admin user you want the menu displayed.

P.S. You might want to also check out the Admin Profiles support thread. I believe there was some discussion of this issue there also.

Woody