Cookie not found !
PageNameDefault : learning_vacations.html
Page complete name:/learning_vacations.html
Page name complete path:/learning_vacations.html
URL : http://www.eveningsail.ca/learning_vacations.html
pageName : learning_vacations.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 : 7
site Urls : array(1) {
[0]=>
string(25) "http://www.eveningsail.ca"
}
site Info : array(5) {
["idsite"]=>
string(1) "7"
["name"]=>
string(11) "EveningSail"
["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-09-08'
AND idsite = '7'
AND md5Config = '9dc8ff7efd64c4ab4b96d53e2e2b4eb7'
ORDER BY last_visit_time DESC
LIMIT 1
Total time : 0.0495920181274 | Query Time 0.0013 sec
=> We found the MD5CONFIG of visitor so he is known
We know its page ref id=599 and he stayed on it 336 seconds
=>Cookie is init on visitor (idcookie and last_visit_time)
(idvisit = 1144495, 23:31:12 | now : 85008 :: first page last time : 84672)
line : 510 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT `pp`.`idpage` FROM `smttrace_page` `pp`, `smttrace_category` `pc` WHERE `pp`.`name` = 'learning_vacations.html' AND `pc`.`name` IS NULL AND `pc`.`idcategory` = `pp`.`idcategory`
Total time : 0.11698102951 | Query Time 0.0668 sec
line : 519 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT idvisit FROM `smttrace_visit` WHERE `exit_idpage`='7779' AND `idcookie`='250a80459e299a02f948968cdc8e1002'
Total time : 2.21929311752 | Query Time 2.1021 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 = 'learning_vacations.html'
LIMIT 1
Total time : 2.27281498909 | Query Time 0.0394 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 = '7779'
AND md5url = '3fb6a878dc30b9d66342c242d50211c6'
LIMIT 1
Total time : 2.27995491028 | Query Time 0.0070 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 ('7', '250a80459e299a02f948968cdc8e1002', '0', CURRENT_TIME(),
'2010-09-08', '23:36:51', '9dc8ff7efd64c4ab4b96d53e2e2b4eb7',
NULL, 'UNK', 'unk',
'', 'unknown', '32',
'0', '0','0', '0', '0', '0', '0',
'12:34:59','644595555', 'Ip', 'en-us,en;q=0.5', 'US', 'unk',
1, '20', '7779', '8881', '7779', NULL, 'United States', 'District of Columbia', 'Washington', '')
Total time : 2.28051590919 | 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 ('1144510', '7779', '599', '336')
Total time : 2.28072690964 | Query Time 0.0001 sec
===> Page info saved (idPage = 7779, idLink_vp = 1664611)
Next cookie should be :array(8) {
["site_urls"]=>
array(1) {
[0]=>
string(25) "http://www.eveningsail.ca"
}
["site_info"]=>
array(5) {
["idsite"]=>
string(1) "7"
["name"]=>
string(11) "EveningSail"
["logo"]=>
string(9) "pixel.gif"
["params_choice"]=>
string(3) "all"
["params_names"]=>
string(0) ""
}
["idcookie"]=>
string(32) "250a80459e299a02f948968cdc8e1002"
["last_visit_time"]=>
int(85011)
["idvisit"]=>
int(1144510)
["server_time"]=>
int(85011)
["server_date"]=>
string(10) "2010-09-08"
["idpage_ref"]=>
string(4) "7779"
}
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 ('7', '7', '2.28', CURRENT_DATE(), CURRENT_TIME())
Total time : 2.2812769413 | Query Time 0.0001 sec
IMAGE_HERE