Cookie not found !
PageNameDefault : leasing.html
Page complete name:/leasing.html
Page name complete path:/leasing.html
URL : http://www.sunrisebrokerage.ca/leasing.html
pageName : leasing.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 : 11
site Urls : array(1) {
[0]=>
string(30) "http://www.sunrisebrokerage.ca"
}
site Info : array(5) {
["idsite"]=>
string(2) "11"
["name"]=>
string(19) "sunrisebrokerage.ca"
["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-03'
AND idsite = '11'
AND md5Config = '9dc8ff7efd64c4ab4b96d53e2e2b4eb7'
ORDER BY last_visit_time DESC
LIMIT 1
Total time : 0.0479869842529 | Query Time 0.0012 sec
=> We found the MD5CONFIG of visitor so he is known
We know its page ref id=720 and he stayed on it 43 seconds
=>Cookie is init on visitor (idcookie and last_visit_time)
(idvisit = 1137222, 4:3:46 | now : 14669 :: first page last time : 14626)
line : 510 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT `pp`.`idpage` FROM `smttrace_page` `pp`, `smttrace_category` `pc` WHERE `pp`.`name` = 'leasing.html' AND `pc`.`name` IS NULL AND `pc`.`idcategory` = `pp`.`idcategory`
Total time : 0.110249996185 | Query Time 0.0617 sec
line : 519 in file /home/wb/public_html/smarttrace/smarttrace.php
SELECT idvisit FROM `smttrace_visit` WHERE `exit_idpage`='918' AND `idcookie`='4b51e380412bb5f22e5f9611146d5d73'
Total time : 2.11710095406 | Query Time 2.0067 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 = 'leasing.html'
LIMIT 1
Total time : 2.13467288017 | Query Time 0.0039 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 = '918'
AND md5url = '2c02968f1e67034f865a06beb77b095b'
LIMIT 1
Total time : 2.13498497009 | 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 ('11', '4b51e380412bb5f22e5f9611146d5d73', '0', CURRENT_TIME(),
'2010-09-03', '04:04:31', '9dc8ff7efd64c4ab4b96d53e2e2b4eb7',
NULL, 'UNK', 'unk',
'', 'unknown', '32',
'0', '0','0', '0', '0', '0', '0',
'02:12:52','644595555', 'Ip', 'en-us,en;q=0.5', 'US', 'unk',
1, '20', '918', '1485', '918', NULL, 'United States', 'District of Columbia', 'Washington', '')
Total time : 2.13556480408 | 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 ('1137227', '918', '720', '43')
Total time : 2.13577485085 | Query Time 0.0001 sec
===> Page info saved (idPage = 918, idLink_vp = 1654420)
Next cookie should be :array(8) {
["site_urls"]=>
array(1) {
[0]=>
string(30) "http://www.sunrisebrokerage.ca"
}
["site_info"]=>
array(5) {
["idsite"]=>
string(2) "11"
["name"]=>
string(19) "sunrisebrokerage.ca"
["logo"]=>
string(9) "pixel.gif"
["params_choice"]=>
string(3) "all"
["params_names"]=>
string(0) ""
}
["idcookie"]=>
string(32) "4b51e380412bb5f22e5f9611146d5d73"
["last_visit_time"]=>
int(14671)
["idvisit"]=>
int(1137227)
["server_time"]=>
int(14671)
["server_date"]=>
string(10) "2010-09-03"
["idpage_ref"]=>
string(3) "918"
}
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 ('11', '7', '2.13', CURRENT_DATE(), CURRENT_TIME())
Total time : 2.13633680344 | Query Time 0.0001 sec
IMAGE_HERE