Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

User Tracking with Admin 1.31 Released


Druide

Recommended Posts

I'm sorry if this has been asked before. I have been reading through the posts on this contribution. I like what I see so far.

 

The problems I'm having is that my admin is being tracked, but I can not see any tracking for my vistors. I just did the install of v1.35 and checked to make sure that tracking vistors is turned on. I also checked to make sure that the change in the footer.php was before the banner, which it is. I have double checked all of the codes and everything seems correct.

 

I have noticed that since the mod to the site, I do not see any vistors in the whos_online.php.

 

Any help would be appreciated.

Link to comment
Share on other sites

  • Replies 570
  • Created
  • Last Reply

Top Posters In This Topic

question about compatibility between this contribution and "who's online with flag"

i have installed the who's online with flag" and country , since it use also the geoip files , is there any trouble with it ?

im under ms1 and testing also a ms2 version

 

thanks

MS2

Link to comment
Share on other sites

Hi group

 

I have installed version 1.35 on a 2.2MS2 everythink works fine but I did not have a "Originating URL:"

 

There will not be shown where the visitors are coming from!

 

Can anyone help me?

Link to comment
Share on other sites

the admin section is working fine and I can see all the IP's etc.

 

But i am getting this error at the bottom of my main page (i.e. catalog)

 

Fatal error: Cannot redeclare tep_update_user_tracking() (previously declared in /home/arabianb/www/www/includes/functions/user_tracking.php:18) in /home/arabianb/www/www/includes/functions/user_tracking.php on line 16

Great Mod!!! :D Just installed and it works great...Well almost. :(

 

I am also using visitors_v1.6a... Is this why I get the below error? I have User Tracking with Admin 1.35 and am wondering if anyone has gotten this same error. Is there a fix?

 

 

 

Fatal error: Cannot redeclare tep_update_user_tracking() (previously declared

in C:\xxx\xxx\catalog\includes\functions\user_tracking.php:18)

in C:\xxx\xxx\catalog\includes\functions\user_tracking.php on line 16

 

Thanks for the help in advance.

Link to comment
Share on other sites

Hi Qwolz,

 

 

Implement the Alverman fix listed in the forum on the 19th Sept.

 

Keep Smiling,

Keith

Well, If I had only looked at this I wouldn't have asked the other queston. It works!!!

 

Thanks

Link to comment
Share on other sites

  • 2 weeks later...

This may not affect everyone, but I have noted a few posts about links to recorded hits not working in the User Tracking page, i.e. the links from hits in the left hand-column go nowhere and the right hand column of the table is blank (no URL).

 

Well, it appears this may be due to IIS servers not recognising the REQUEST_URI environment variable (not sure why, but apparently it works on Apache). Either that, or there is some server configuration tweak I am blithely ignorant of (quite likely).

 

In any case, if are using IIS and experiencing this problem, try the following:

 

In includes/functions/user_tracking.php about line 37, replace

 

    $wo_session_id = tep_session_id();

    $wo_ip_address = getenv('REMOTE_ADDR');

    $wo_last_page_url = addslashes(getenv('REQUEST_URI'));

 

if ($HTTP_GET_VARS['products_id']) {

    $page_desc_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $HTTP_GET_VARS['products_id'] . "' and language_id = '" . $languages_id . "'");

    $page_desc_values = tep_db_fetch_array($page_desc_query);

$page_desc = $page_desc_values['products_name'];

} elseif ($HTTP_GET_VARS['cPath']) {

$cPath = $HTTP_GET_VARS['cPath'];

    $cPath_array = tep_parse_category_path($cPath);

    $cPath = implode('_', $cPath_array);

    $current_category_id = $cPath_array[(sizeof($cPath_array)-1)];

    $page_desc_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $current_category_id . "' and language_id = '" . $languages_id . "'");

    $page_desc_values = tep_db_fetch_array($page_desc_query);

$page_desc = $page_desc_values['categories_name'];

} else {

$page_desc = addslashes(HEADING_TITLE);

}

 

with

 

    $wo_session_id = tep_session_id();

    $wo_ip_address = getenv('REMOTE_ADDR');

    //Original line removed below - works on Apache, not on IIS

    //$wo_last_page_url = addslashes(getenv('REQUEST_URI'));

 

if ($HTTP_GET_VARS['products_id']) {

    $page_desc_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $HTTP_GET_VARS['products_id'] . "' and language_id = '" . $languages_id . "'");

    $page_desc_values = tep_db_fetch_array($page_desc_query);

  $page_desc = $page_desc_values['products_name'];

    // Fix for IIS server not supporting REQUEST_URI - if query string

    $wo_last_page_url = addslashes('http://' . getenv('HTTP_HOST') . getenv('PATH_INFO') . '?' . getenv('QUERY_STRING'));

} elseif ($HTTP_GET_VARS['cPath']) {

$cPath = $HTTP_GET_VARS['cPath'];

    $cPath_array = tep_parse_category_path($cPath);

    $cPath = implode('_', $cPath_array);

    $current_category_id = $cPath_array[(sizeof($cPath_array)-1)];

    $page_desc_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $current_category_id . "' and language_id = '" . $languages_id . "'");

    $page_desc_values = tep_db_fetch_array($page_desc_query);

  $page_desc = $page_desc_values['categories_name'];

    // Fix for IIS server not supporting REQUEST_URI - if query string

    $wo_last_page_url = addslashes('http://' . getenv('HTTP_HOST') . getenv('PATH_INFO') . '?' . getenv('QUERY_STRING'));

} else {

$page_desc = addslashes(HEADING_TITLE);

  // Fix for IIS server not supporting REQUEST_URI - if no query string

  $wo_last_page_url = addslashes('http://' . getenv('HTTP_HOST') . getenv('PATH_INFO'));

}

 

Worked for me!

 

Cheers, Rob

 

P.S. This fix has nothing to do with Originating URLs/Referer URLs (that one is an entirely different fix - see Alverman 19th Sep 03)

 

P.P.S. It almost goes without saying, but this is an awesome mod! Many thanks Robert et al ;-)

Link to comment
Share on other sites

Great Contrib but....

 

I've got the admin tracking to work just fine, no problems there. However, when I add the code for the footer in \includes\footer.php I recieve the following..

 

1146 - Table 'catalog.TABLE_USER_TRACKING' doesn't exist

 

insert into TABLE_USER_TRACKING (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '6308a5ec010d805e817d6517166b3083', '192.168.100.7', '1066962717', '1066962717', '/', 'What\'s New Here?')

 

Trying to figure out why the user section doesn't work but the admin does. Is there anything else dependant on NOT having a catalog folder? I have everything in the htdocs folder of my server. Any help would be greatly appreciated.

 

thanks,

sparks

www.starwarscans.com

Edited by sparks
Link to comment
Share on other sites

I've got the same problem.........

Any help out there :rolleyes: this is the error:

?

1146 - Table 'hempster_osc4.TABLE_USER_TRACKING' doesn't exist

 

insert into TABLE_USER_TRACKING (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('', 'Guest', '83942d920242fe898734410908bc951f', '80.111.162.117', '1067098199', '1067098199', '/headshop/', '

Velkommen til CropShop')

 

I get this message in both catalog and admin section, everything else is fine.

Please help us, i've searched the forum, but i cant find any answers...

 

:wacko:

Link to comment
Share on other sites

Problem solved :D , but now i have these errors: in admin section configure usertracking it look like this:

 

Screen02.JPG

 

Any help will be great....

Edited by Frodster
Link to comment
Share on other sites

Sorry, the late answer but this is what i did:

Just replace the tekst marked red whit your table_name.

 

I changed TABLE_USER_TRACKING to user_tracking

 

 

in catalog/includes/functions/user_tracking.php at the bottom

 

$current_time = time();

if ($skip_tracking[$wo_ip_address] != 1)

tep_db_query("insert into " . TABLE_USER_TRACKING . " (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, page_desc) values ('" . $wo_customer_id . "', '" . $wo_full_name . "', '" . $wo_session_id . "', '" . $wo_ip_address . "', '" . $current_time . "', '" . $current_time . "', '" . $wo_last_page_url . "', '" . $page_desc . "')");

}

 

 

in admin/user_tracking.php

from line 62 -->

 

 

<?php

if ($purge == '72')

{

tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " where time_last_click < '" . (time() - ($purge * 3600))."'");

echo "<font color=red>" . TEXT_HAS_BEEN_PURGED . '</font><p>';

}

if ($delip == '1')

{

tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE ip_address = '" . CONFIG_USER_TRACKING_EXCLUDED . "'");

echo CONFIG_USER_TRACKING_EXCLUDED . ' has been deleted. <p>';

$delip='0';

}

if ($delsession)

{

tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE session_id = '" . $delsession . "'");

echo $delsession . ' has been deleted. <p>';

}

 

echo EXPLAINATION, "<p>";

 

// some time routines

$time_frame = time();

if ($HTTP_GET_VARS['time'])

{

$time_frame = $HTTP_GET_VARS['time'];

}

 

echo '<b>' . TEXT_SELECT_VIEW .': </b>';

echo '<a href="' . FILENAME_USER_TRACKING . '?time=' ;

echo $time_frame - 86400 . '">' . TEXT_BACK_TO . ' ' . date("M d, Y", $time_frame - 86400) . '</a> ';

 

echo "<p>" . TEXT_DISPLAY_START . $LIMIT_DISPLAY_SESSIONS . TEXT_DISPLAY_END;

echo TEXT_PURGE_START . ' <a href="' . FILENAME_USER_TRACKING . '?purge=72">'. TEXT_PURGE_RECORDS. '</a> ' . TEXT_PURGE_END. '</font><p>';

 

echo TEXT_DELETE_IP . CONFIG_USER_TRACKING_EXCLUDED . ' <a href="' . FILENAME_USER_TRACKING . '?delip=1">'. TEXT_PURGE_RECORDS. '</a> </font><p>';

 

if (time() > $time_frame + 86400)

{

echo '| <a href="' . FILENAME_USER_TRACKING . '?time=' ;

echo $time_frame + 86400 . '">' . TEXT_FORWARD_TO . date("M d, Y", $time_frame + 86400) . '</a>';

}

// we need to slurp all the customer tracking information out of the database

 

$whos_online_query =

tep_db_query("select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc," .

" session_id from " . TABLE_USER_TRACKING .

" where time_entry > " . ($time_frame - 86400) .

" and time_entry < " . $time_frame .

" order by time_last_click desc");

 

Hope this can help you.... Worked for me :D

Link to comment
Share on other sites

  • 3 weeks later...

Ok... I have a question. Ok.. 2 questions:

 

1. Is there an english translation of the Add Delete individal IP Adress (is this a ban btw?)

2. Is this contribution supposed to show up as a box on my shop page as well as in my admin? I have it working in admin, but I don't see anything about "who's online" on my shop page.

 

Just curious :-)

 

Khim~

Do not meddle in the affairs of Dragons, for you are crunchy and good with ketchup :-)

Link to comment
Share on other sites

Hi Khim, regarding question 2:

2. Is this contribution supposed to show up as a box on my shop page as well as in my admin? I have it working in admin, but I don't see anything about "who's online" on my shop page.

This contribution is Admin only, so no box will appear in your shop page. However, I've seen a couple of separate contributions that do display who is online.

 

Try Number of visitors online or Whos Online (maybe a bit old).

 

I haven't tried any of them so I can't vouch for them.

 

Regards, Rob

Link to comment
Share on other sites

The install works it just has multiple listings in the config panel

Where exactly is this config panel located? I finally figured out how to turn it on, but no details like this anywhere that I could find.

 

Any hints would be greatly appreciated.

 

Thanks.

Link to comment
Share on other sites

Is it normal to see guest for myself when i look at my session in the user traking and that i can read all the pages i passed trough in the admin part ...

it should as the user in part catalog show something like : Admin name of the admin no ?

MS2

Link to comment
Share on other sites

i ve got also a wierd problem :

 

im in the admin part , i just log in , i see that i m referenced as a certain customer that is currently surfing on my shop so the contrib is showing to different person with 2 different IP at the same time on the shop as the same person but with 2 different sessions ...

 

i link a screeenshot :

 

usertpbe.jpg

 

i tried to log in the catalog part with a customer name , and then i can see a third session has been added in user tracking still same ip but with the customer name i entered in the catalog part !

Edited by azer

MS2

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...