Cookie not found !
PageNameDefault : products_that_work.html
Page complete name:/products_that_work.html
Page name complete path:/products_that_work.html
URL : http://healthworksclinic.ca/products_that_work.html
pageName : products_that_work.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:644595551=> 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-08'
AND idsite = '6'
AND md5Config = 'e1bfb18e2a443408a8d87df1d11ddc90'
ORDER BY last_visit_time DESC
LIMIT 1
Total time : 0.0490250587463 | Query Time 0.0016 sec
=> We found the MD5CONFIG of visitor so he is known
We know its page ref id=463 and he stayed on it 600 seconds
=>Cookie is init on visitor (idcookie and last_visit_time)
(idvisit = 1144484, 23:23:47 | now : 84827 :: first page last time : 84227)
line : 510 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT `pp`.`idpage` FROM `smttrace_page` `pp`, `smttrace_category` `pc` WHERE `pp`.`name` = 'products_that_work.html' AND `pc`.`name` IS NULL AND `pc`.`idcategory` = `pp`.`idcategory`
Total time : 0.112021923065 | Query Time 0.0624 sec
line : 519 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT idvisit FROM `smttrace_visit` WHERE `exit_idpage`='453' AND `idcookie`='bd1da3ab22f3b473dfcc06a4c05fdf5b'
Total time : 2.20761084557 | Query Time 2.0954 sec
==> This is a new visit, we create datas in the database when necessary
array(10) {
["ip"]=>
string(13) "38.107.191.95"
["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 = 'products_that_work.html'
LIMIT 1
Total time : 2.22351694107 | Query Time 0.0019 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 = '453'
AND md5url = 'd92609eaf89ace81183dd94f6400d389'
LIMIT 1
Total time : 2.22393989563 | 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', 'bd1da3ab22f3b473dfcc06a4c05fdf5b', '0', CURRENT_TIME(),
'2010-09-08', '23:33:49', 'e1bfb18e2a443408a8d87df1d11ddc90',
NULL, 'UNK', 'unk',
'', 'unknown', '32',
'0', '0','0', '0', '0', '0', '0',
'22:56:49','644595551', 'Ip', 'en-us,en;q=0.5', 'US', 'unk',
1, '20', '453', '766', '453', NULL, 'United States', 'District of Columbia', 'Washington', '')
Total time : 2.22457695007 | Query Time 0.0005 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 ('1144499', '453', '463', '600')
Total time : 2.2249019146 | Query Time 0.0002 sec
===> Page info saved (idPage = 453, idLink_vp = 1664600)
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) "bd1da3ab22f3b473dfcc06a4c05fdf5b"
["last_visit_time"]=>
int(84829)
["idvisit"]=>
int(1144499)
["server_time"]=>
int(84829)
["server_date"]=>
string(10) "2010-09-08"
["idpage_ref"]=>
string(3) "453"
}
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.22', CURRENT_DATE(), CURRENT_TIME())
Total time : 2.22557091713 | Query Time 0.0002 sec
IMAGE_HERE