$page = 'http://'.$_SERVER['SERVER_NAME'].$_SERVER['REDIRECT_URL']; $ref = $db->getOne('select id from larpro_log_url_list where url=?',array($_SERVER['HTTP_REFERER'])); $url = $db->getOne('select id from larpro_log_url_list where url=?',array($page)); if (!$ref) { if ($_SERVER['HTTP_REFERER']) { $db->query('insert into larpro_log_url_list (url, class) values (?, ?)', array($_SERVER['HTTP_REFERER'], strncmp( CONF_URL_BASE, $_SERVER['HTTP_REFERER'], strlen(CONF_URL_BASE) ) ? 'external' : 'internal') ); $ref = $db->getOne('select LAST_INSERT_ID()'); } else $ref=0; } if (!$url) { $db->query('insert into larpro_log_url_list (url, class) values (?, ?)', array($page, 'internal') ); $url = $db->getOne('select LAST_INSERT_ID()'); } $db->query('insert into larpro_log_url_visit (visitor_id, url, ref) values (?,?,?)', array($visitor_id, $url, $ref) );