[phpOpenTracker-User] DB schema question

Sorry for all the questions but I am trying to get a better 
understanding of phpOpenTracker :) (And I promise that if I can 
understand it well enough I will contribute to the documentation!)

#1 What is the relationship between the pot_visitors and pot_hostnames 
tables? Is there always at least *one* pot_visitors entry for each 
pot_hostnames entry? I ask because I have the following which shows that 
I have some pot_hostnames entries that are not in pot_visitors:

# select count(distinct(host_id)) from pot_visitors ;
  count
-------
    667

# select count(*) from pot_hostnames ;
  count
-------
    681

The missing rows are:

# select string from pot_hostnames where not exists (select host_id from 
pot_visitors where host_id=data_id);
      string
-----------------
  192.168.255.117
  192.168.255.102
  192.168.255.127
  192.168.255.113
  192.168.255.103
  192.168.255.147
  192.168.255.174
  192.168.255.142
  192.168.255.114
  192.168.255.159
  st.bbexcite.jp
  netcraft.com
  192.168.255.141
  192.168.255.180
  192.168.255.146

All the 192.* entries are from my LAN and perhaps it makes sense that 
they are excluded from pot_visitors since I have this in my lock.ini:

host /192.168/

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?

And what about the other two host names (st.bbexcite.jp and 
netcraft.com) that show up in pot_hostnames but not in pot_visitors? Why 
are these two not in the visitors table?

Is my database corrupt?


#2 Is there a way to find out the number of unique visitors to my site? 
Does this query give me the number of unique visitors?

# select count(distinct(host_id)) from pot_visitors ;
  count
-------
    667

I am hoping that using 'track_returning_visitors = On', it is possible 
to identify unique visitors? (Of course if a visitor were to delete his 
cookies he would be counted more than once though ...)

#3 This query gives me the number of visitors to my site:

phpOpenTracker=# select count(*) from pot_visitors ;
  count
-------
  10464

The query I gave in #2 shows that I have had 667 unique hosts (IP 
addresses) visited my site. I understand that this means that 667 *or 
more* people/machines visited my site. But I can't understand the 
relationship between that number (667) and the number of visitors 
reported by phpOpenTracker for my site (10464).

Can someone explain to me what the number 10464 really means? :)

Thanks!

Jean-Christian Imbeault



-------------------------------------------------------
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