Cookie not found !
PageNameDefault : coverage_area.html
Page complete name:/coverage_area.html
Page name complete path:/coverage_area.html
URL : http://healthworksclinic.ca/coverage_area.html
pageName : coverage_area.html
pageCategory :
a_vars : array(0) {
}
referer :
flash : 0
director : 0
quicktime : 0
real player : 0
windows media : 0
PDF : 0
java : 0
referer Url :
id site : 6
site Urls : array(1) {
[0]=>
string(31) "http://www.healthworksclinic.ca"
}
site Info : array(5) {
["idsite"]=>
string(1) "6"
["name"]=>
string(11) "HealthWorks"
["logo"]=>
string(9) "pixel.gif"
["params_choice"]=>
string(3) "all"
["params_names"]=>
string(0) ""
}
user Agent : CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
os : UNK
browser :
resolution : unknown
color : 32
Try to recognize the visitor...
=>We can't find the cookie...
ip:644595552=> Ip is not excluded
line : 425 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT idvisit, idcookie, TIME_TO_SEC(last_visit_time),
TIME_TO_SEC(server_time), exit_idpage, ip
FROM smttrace_visit
WHERE server_date = '2010-09-09'
AND idsite = '6'
AND md5Config = '6258f8cc870f904ef15019b753906c7b'
ORDER BY last_visit_time DESC
LIMIT 1
Total time : 0.0555210113525 | Query Time 0.0018 sec
=> We found the MD5CONFIG of visitor so he is known
We know its page ref id=468 and he stayed on it 384 seconds
=>Cookie is init on visitor (idcookie and last_visit_time)
(idvisit = 1145087, 14:1:48 | now : 50892 :: first page last time : 50508)
line : 510 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT `pp`.`idpage` FROM `smttrace_page` `pp`, `smttrace_category` `pc` WHERE `pp`.`name` = 'coverage_area.html' AND `pc`.`name` IS NULL AND `pc`.`idcategory` = `pp`.`idcategory`
Total time : 0.118799209595 | Query Time 0.0627 sec
line : 519 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT idvisit FROM `smttrace_visit` WHERE `exit_idpage`='524' AND `idcookie`='ba81585b0dec52458b9b1129c050ea0c'
Total time : 2.2160141468 | Query Time 2.0970 sec
==> This is a new visit, we create datas in the database when necessary
array(10) {
["ip"]=>
string(13) "38.107.191.96"
["country_code"]=>
string(2) "US"
["country"]=>
string(13) "United States"
["city"]=>
string(10) "Washington"
["latitude"]=>
float(38.9144)
["longitude"]=>
float(-77.0763)
["area_code"]=>
int(202)
["region"]=>
string(20) "District of Columbia"
["dma_code"]=>
float(511)
["countryflag"]=>
string(31) "./images/countries_flags/us.png"
}
line : 461 in file /home/wb/public_html/smarttrace/core/include/Logs.functions.php
SELECT idpage
FROM smttrace_page
WHERE idcategory = '0'
AND name = 'coverage_area.html'
LIMIT 1
Total time : 2.23102521896 | Query Time 0.0021 sec
line : 502 in file /home/wb/public_html/smarttrace/core/include/Logs.functions.php
SELECT idpage_url as id
FROM smttrace_page_md5url
WHERE idpage = '524'
AND md5url = 'bd52c59ea8b4ad02a8c1313e7731133d'
LIMIT 1
Total time : 2.23150205612 | Query Time 0.0003 sec
line : 658 in file /home/wb/public_html/smarttrace/smarttrace.php
INSERT INTO smttrace_visit
(idsite, idcookie, returning, last_visit_time, server_date, server_time, md5config,
referer, os, browser_name, browser_version, resolution, color_depth,
pdf, flash, java, director, quicktime, realplayer, windowsmedia,
local_time, ip, hostname_ext, browser_lang, country, continent,
total_pages, total_time, entry_idpage, entry_idpageurl, exit_idpage, form_submissions, country_name, region, city, lastpage)
VALUES ('6', 'ba81585b0dec52458b9b1129c050ea0c', '0', CURRENT_TIME(),
'2010-09-09', '14:08:14', '6258f8cc870f904ef15019b753906c7b',
NULL, 'UNK', 'unk',
'', 'unknown', '32',
'0', '0','0', '0', '0', '0', '0',
'22:56:55','644595552', 'Ip', 'en-us,en;q=0.5', 'US', 'unk',
1, '20', '524', '1075', '524', NULL, 'United States', 'District of Columbia', 'Washington', '')
Total time : 2.23205208778 | Query Time 0.0004 sec
line : 609 in file /home/wb/public_html/smarttrace/core/include/Logs.functions.php
INSERT INTO smttrace_link_vp (idvisit, idpage, idpage_ref, total_time_page_ref) VALUES ('1145102', '524', '468', '384')
Total time : 2.23236012459 | Query Time 0.0002 sec
===> Page info saved (idPage = 524, idLink_vp = 1665456)
Next cookie should be :array(8) {
["site_urls"]=>
array(1) {
[0]=>
string(31) "http://www.healthworksclinic.ca"
}
["site_info"]=>
array(5) {
["idsite"]=>
string(1) "6"
["name"]=>
string(11) "HealthWorks"
["logo"]=>
string(9) "pixel.gif"
["params_choice"]=>
string(3) "all"
["params_names"]=>
string(0) ""
}
["idcookie"]=>
string(32) "ba81585b0dec52458b9b1129c050ea0c"
["last_visit_time"]=>
int(50894)
["idvisit"]=>
int(1145102)
["server_time"]=>
int(50894)
["server_date"]=>
string(10) "2010-09-09"
["idpage_ref"]=>
string(3) "524"
}
Queries: 7
line : 204 in file /home/wb/public_html/smarttrace/core/include/common.functions.php
INSERT INTO smttrace_query_log (idsite, query, time, date, daytime) VALUES ('6', '7', '2.23', CURRENT_DATE(), CURRENT_TIME())
Total time : 2.23298811913 | Query Time 0.0002 sec
IMAGE_HERE