phpWebLogAnalyzer TODO list
---------------------------

- little bug: multiple IP addresses are not truncated to single IP
  in truncate mode
+ when getting remote_host_id from remote_addr_id split IP adress by commas
  and resolve only the last IP adress; in example, IP adresses like this one
  aren't properly handled: 192.168.0.215, 193.87.12.41, 193.87.96.5
* add support for *.domain.ext remote_host and 1.2.3.* remote_addr logging
- create analyzation table with two columns:
	1. session_timeout
	2. number of all sessions in database
  create graph and discuss/analyse it to find the most best session_timeout
* fix bug when in session key is NULL value
* use of PHP's substr() instead SQL's substring()
+ check if varaibles cannot be get from environment via getenv() function
  instead that silly eval()-ing
  - some are in evironment, some not - improve that stuff not to use eval()
* change query string column from text to [var]char(255) and make index;
  raw accesses table than should have not varchars but pure chars
+ getSessionsCount() and getActiveSessions() result caching
* replace every SQL substring() with PHP substr(); it could increases (not only)
  network performance
* property manipulation methods (get/set value, get array)
* possible bug: SQL clausule substring() called on non-string types
  - N/A: SQL substring() usage was removed
- possible bug: calling getSessionCount() without registerAccess()
  - solution: check if was $_props array already processes and if not, than
    process that array before doing getSessionCount() job
- create utility for converting data from weblog_core_accesses table to 
  weblog_accesses table
  - a good idea could by to convert only closed sessions to avoid some type
    of desynchronization with having two IDs for one session
* add support for weblog_core_accesses table; creating entry for weblog_accesses
  is very difficult for CPU and SQL server
  - table is called weblog_accesses_raw
- source formating PEAR compliancy
  - add also standart header
* class style PEAR compliancy
+ PEAR compliant error handling
- ident stuff: move index column and table name from *_username to *_user
- think about possible table joins:
	weblog_ident_usernames w/ weblog_remote_idents
	weblog_http_hosts w/ weblog_remote_hosts (what if HTTP_HOST is IP address?)
* session_id column
- Perl API functions for register hits
- web interface (frontend) for analyzing and manipulating with statistics

- why this doesn't work?

		$xx = 'HTTP_SERVER_VARS["SCRIPT_NAME"]';
		echo $$xx;