File: [Platon] / phpWebLogAnalyzer / Attic / TODO (download)
Revision 1.19, Fri Apr 26 16:59:06 2002 UTC (21 years, 11 months ago) by jombik9
Changes since 1.18: +2 -0
lines
* 26/04/2002 - getInactiveSessions() method implemented
* - setPropertyValue() bugfix
* - DB write part of registerAccess() is now in writeValues()
* - getAccessesOfSession(), readIntoValues() and deleteSession()
* methods added
* - with usage of methods above convert() method for conversion
* from raw log into normal implemented
|
phpWebLogAnalyzer TODO list
---------------------------
- improve readIntoValues()
- improve getSessions() method
- use timestamp column instead of datetime
- 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;
Platon Group <platon@platon.org> http://platon.org/
|