Re: [phpOpenTracker-User] DB schema question
Sebastian Bergmann <[email protected]>
| Newsgroups | gmane.comp.web.phpopentracker.general |
|---|---|
| Organization | www.sebastian-bergmann.de |
| Message-ID | <[email protected]> |
Jean-Christian Imbeault wrote: > Is there always at least *one* pot_visitors entry for each > pot_hostnames entry? No, see below. > But ... why are these being logged into the pot_hostname table? > I would have thought that since my lock.ini file excludes these > host there should be nothing associated with them in the DB, no? Request to which a locking rule applies have no rows in the pot_accesslog and pot_visitors tables, but unfortunetly in the other tables. > Is my database corrupt? I doubt that. > Does this query give me the number of unique visitors? > > # select count(distinct(host_id)) from pot_visitors ; > count > ------- > 667 No. > I am hoping that using 'track_returning_visitors = On', it is > possible to identify unique visitors? No, this allows you to retrieve information on how often a unique visitor returned to your site. > Can someone explain to me what the number 10464 really means? :) It is the number of visits, or sessions, tracked by phpOpenTracker. -- Sebastian Bergmann http://sebastian-bergmann.de/ http://phpOpenTracker.de/ Das Buch zu PHP 5: http://professionelle-softwareentwicklung-mit-php5.de/ ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps