Cookie not found !
PageNameDefault : hand_works_workshop.html
Page complete name:/hand_works_workshop.html
Page name complete path:/hand_works_workshop.html
URL : http://healthworksclinic.ca/hand_works_workshop.html
pageName : hand_works_workshop.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:644595555=> 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-07-31'
AND idsite = '6'
AND md5Config = '9dc8ff7efd64c4ab4b96d53e2e2b4eb7'
ORDER BY last_visit_time DESC
LIMIT 1
Total time : 0.048103094101 | Query Time 0.0008 sec
=> We found the MD5CONFIG of visitor so he is known
We know its page ref id=516 and he stayed on it 206 seconds
=>Cookie is init on visitor (idcookie and last_visit_time)
(idvisit = 1080719, 11:14:41 | now : 40687 :: first page last time : 40481)
line : 510 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT `pp`.`idpage` FROM `smttrace_page` `pp`, `smttrace_category` `pc` WHERE `pp`.`name` = 'hand_works_workshop.html' AND `pc`.`name` IS NULL AND `pc`.`idcategory` = `pp`.`idcategory`
Total time : 0.109133005142 | Query Time 0.0604 sec
line : 519 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT idvisit FROM `smttrace_visit` WHERE `exit_idpage`='455' AND `idcookie`='73c1da54ef73eb93b7e7a917bd653611'
Total time : 2.03525304794 | Query Time 1.9260 sec
==> This is a new visit, we create datas in the database when necessary
array(10) {
["ip"]=>
string(13) "38.107.191.99"
["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 = 'hand_works_workshop.html'
LIMIT 1
Total time : 2.09416794777 | Query Time 0.0018 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 = '455'
AND md5url = '4c738dc4724f0984aab281b8220e2bc5'
LIMIT 1
Total time : 2.09450101852 | Query Time 0.0002 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', '73c1da54ef73eb93b7e7a917bd653611', '0', CURRENT_TIME(),
'2010-07-31', '11:18:09', '9dc8ff7efd64c4ab4b96d53e2e2b4eb7',
NULL, 'UNK', 'unk',
'', 'unknown', '32',
'0', '0','0', '0', '0', '0', '0',
'22:55:34','644595555', 'Ip', 'en-us,en;q=0.5', 'US', 'unk',
1, '20', '455', '851', '455', NULL, 'United States', 'District of Columbia', 'Washington', '')
Total time : 2.09503912926 | 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 ('1080732', '455', '516', '206')
Total time : 2.09526896477 | Query Time 0.0001 sec
===> Page info saved (idPage = 455, idLink_vp = 1571770)
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) "73c1da54ef73eb93b7e7a917bd653611"
["last_visit_time"]=>
int(40689)
["idvisit"]=>
int(1080732)
["server_time"]=>
int(40689)
["server_date"]=>
string(10) "2010-07-31"
["idpage_ref"]=>
string(3) "455"
}
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.09', CURRENT_DATE(), CURRENT_TIME())
Total time : 2.0958070755 | Query Time 0.0001 sec
IMAGE_HERE