Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, March 29, 2024

File: [Platon] / phpWebLogAnalyzer / Attic / TODO (download)

Revision 1.17, Thu Mar 28 21:49:57 2002 UTC (22 years ago) by jombik9

Changes since 1.16: +8 -4 lines

 * 28/03/2002 - web server variable remote_host is used if it is set
 *            - support for resolving hostnames from IP address fields
 *              containing commas
 *            - truncating hostnames and IP addresses implementation

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;


Platon Group <platon@platon.org> http://platon.org/
Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top