Visitor Stats 1.3

Tuesday, October 07 2003 @ 01:29 PM EDT

Contributed by: tomw

Here goes -- I am releasing the updated Visitor Stats Plugin. Here is a summary of the changes:

-- Added indexes to speed up queries (on sites with large databases or slow server you may get a time out here -- if that happens use the update.sql to complete the update).

-- Modified index page to limit number of months displayed $_ST_months controls the number of months -- Modified day page to limit number of days displayed $_ST_days controls the number of days

-- Modified so that a Geeklog install in a subdirectory works correctly $_ST_sub should be set to the sub-directory -- Made page by request that shows most popular pages and most active users per day and month. Note: it is not accessible through any link you must access it directly stats/popular.php.

-- Added preliminary referer page which summarizes refers by host so that e.g. all the google.com are seen together. From here you can drill down to see the detail.

-- Fixed permissions

-- Fixed user totals

-- Updated WhosOnline block to respect user perference for showing name.

-- Added several configuration variables to control display of Who's Online block -- see config.php for details.

-- Added page ignore like ip and user ignore list.

-- Added the ability to put in a partial ip and have stats ignore all that match that partial. e.g. You can enter '192.168.' and it will ignore all ips that begin with these two numbers.

-- Included several sql files to perform maintenance tasks. (These sql commands take to long on a busy site to be handled by php and thus must be executed manually by the admin using the source command). All the sql files have gl_ hardcoded as the table prefix. If yours is different then you must change this.

---- bot.sql can be used to clean you database of common bot accesses.

---- ignore.sql inserts these bot ips into your ignore list. Together these two can get rid of google, et all from you database. note: It would be good for the community to add to this list by posting new ips as they are found.

---- jan.sql thru dec.sql simply deletes that particular month from you database when it begins to get too big.

---- stats.sql and upgrade.sql are the sql to create the database or upgrade it.

-- Added caching of the queries to further speed things up. This is controlled by the $_ST_cache variable. It requires that the cache subdirectory in the public_html/stats directory be writable by the webserver.

You can get it from Sourceforge. Hope it works well for you.

TomW

5 comments



http://gplugs.pigstye.net/article.php/20031007132901155