User tracking mod

Quote:

---

Originally Posted by BlessIsaacola

Thank you so much for taking the time to thorough engage with me on this. I really appreciate it! I downloaded the 1.4.2 again and there's no uninstall instruction. This is simply so you know. I can drop the table from the database manually (but others may not be comfortable with that). The page registration stuff is still new to me which is why I went looking for the uninstall instruction. Have a great weekend!

---

I did the same, and from reviewing the install sql (Fresh install) developed the following SQL statements to remove information related to this mod from the mySQL database:

Code:

---

DELETE FROM admin_pages WHERE page_key = 'UserTracking';
DELETE FROM admin_pages WHERE page_key = 'UserTrackingConfig';
DROP TABLE IF EXISTS user_tracking;
DELETE FROM configuration WHERE configuration_group_id = '999';
DELETE FROM configuration_group WHERE `configuration_group_id` = 999 AND `configuration_group_title` = 'User Tracking Config' AND `configuration_group_description` = 'User Tracking' AND `sort_order` = 31 AND `visible` = 1;

---

I haven't tested the code and am only worried about the 2nd to last line, though it is the same line included in the install package. Concern is if the value 999 is unique enough (ie. not used by other packages) that other information in the configuration table with the configuration_group_id of 999 won't exist to be affected.

But, I think that if you paste the above into your admin panel where you have the ability to perform SQL functions, then it will undo database actions previously performed. It is expected that by running this that you will lose all of the tracked data that might exist. Please report the success and I will incorporate into the my next changes (I have mods on another plugin that I have currently placed priority to implement before returning to this one). But it looks like those will work for an uninstall.

I forgot to mention, please backup your database before running that code. (Will not affect the files showing your site, but will affect the data that is shown.) Don't want something else to be affected, and if it is, want to be able to restore it.

Quote:

---

Originally Posted by mc12345678

I forgot to mention, please backup your database before running that code. (Will not affect the files showing your site, but will affect the data that is shown.) Don't want something else to be affected, and if it is, want to be able to restore it.

---

I already took care of it manually via phpmyadmin. Sorry I wasn't able to test your code for you. Thanks!

Quote:

---

Originally Posted by BlessIsaacola

I already took care of it manually via phpmyadmin. Sorry I wasn't able to test your code for you. Thanks!

---

You're welcome. Technically you would be in the ideal situation now to test that code, by at least running the Sql to install, and then the above SQL to remove. :P

That said, a small description of what the above does is this,
The first line removes the admin menu option to see the list of tracked users.
The second line removes the admin menu option to see the admin settings for user tracking.
The third line removes the user tracking table from the database if it is present.
The fourth line removes all occurrences of the configuration_group_id that equal 999 from the configuration table and
the last line removes what is expected to be only the one entry from the configuration_group table that meets all of the criteria that were set in the install.

Hi, I have installed the latest version on 1.3.8 and have everyting installed where it should be but I do not see user tracking under tools in the admin. Can't figure out why? Anybody got any ideas?
Thanks.
A.

Quote:

---

Originally Posted by corseter

Hi, I have installed the latest version on 1.3.8 and have everyting installed where it should be but I do not see user tracking under tools in the admin. Can't figure out why? Anybody got any ideas?
Thanks.
A.

---

Forgive me for going back to the basics, but you also "ran" the install SQL?

Does this version show correctly what is currently in a customers cart if they have a current session?
Sort of like is shown in who's online.

I had used this some years ago,
It seemed there was a bug in earlier versions that would show the same items for multiple current sessions.

Quote:

---

Originally Posted by gilby

Does this version show correctly what is currently in a customers cart if they have a current session?
Sort of like is shown in who's online.

I had used this some years ago,
It seemed there was a bug in earlier versions that would show the same items for multiple current sessions.

---

I think that issue is currently still present. I hadn't yet made any changes to that part, and I think I have seen the effects of what you describe. I plan on making more changes, I'll definitely consider that as one of the factors to try to correct.

Quote:

---

Originally Posted by mc12345678

I think that issue is currently still present. I hadn't yet made any changes to that part, and I think I have seen the effects of what you describe. I plan on making more changes, I'll definitely consider that as one of the factors to try to correct.

---

Thank you for that.
I remember the error came in about zen 138a and newer.
May have had something to do with session handling in the admin.
Prior to those versions of zen there was an admin\includes\classes\sessions.php that was removed in zen v138 and newer.
This file may have had an influence on it.

Quote:

---

Originally Posted by gilby

Thank you for that.
I remember the error came in about zen 138a and newer.
May have had something to do with session handling in the admin.
Prior to those versions of zen there was an admin\includes\classes\sessions.php that was removed in zen v138 and newer.
This file may have had an influence on it.

---

Welcome!

The thing I saw was when I was looking at the user tracking log, someone/something added a large number of items, when I refreshed the logs every entry showed the same thing in the cart rather than just the entry that had something in their cart, but I think it was identical to what was shown on the who's online screen.

So, I'm not sure if that is the same that you observed years ago, but it did appear as the who's online shows (a single "window" with all cart information shown including which session had the item(s).)