PsychoStats Tutorial (Windows)

Introduction PsychoStats version 3.x is very easy and quick to install on any system. It includes an online installation wizard that you run through your browser. Follow these simple steps and you'll be up and running in no time. This documentation is for VERSION 3.x. All documentation for version 2.x is gone. Upgrade to v3 as support for v2 is depreciated. People are often very confused about how PsychoStats actually works. PsychoStats is software that relies on other technologies such as a WebServer like Apache and a database server like MySQL. You must be familar with these types of servers in order to use PsychoStats. And you must have access to a web and mysql server.

There are 2 parts to PsychoStats:
- Backend Perl Scripts
The backend takes care of the actual log parsing and updates. This is where the primary 'stats.pl' perl script is run to fetch, parse and record log data from the game server(s) into the database.
Note: The system that runs these updates (Windows or Linux) is what defines which archive you should download a nd install.
- Frontend PHP Website
The frontend takes care of the interface that the user actually see's and interacts with. This is a set of PHP pages that interact with the same database as the backend so users can view the stats online.

Minimum Requirements
- PHP v4.3 (or 5.0+)
- MySQL v4.1.11 (or v5.0+)
- Perl v5.8 (Windows users: ActivePerl 5.8+)
Required Perl modules
- DBI
- DBD::mysql
Optional Perl modules
- Net::SFTP - This is only required if you need to download logs via an SFTP server. Note: This module has a lot of extra dependencies. Too many to list here.

These requirements are the bare minimum that ensure PsychoStats will work. If you attempt to use older versions you run the risk of stats updates crashing or invalid statistics from being recorded. Users having problems with the software that are running older versions of these requirements can not be supported.

Download Psychostats > [Doar administratorii au dreptul sa vada acest link]
Download the current release from the PsychoStats Downloads. Be sure to download the Windows archive.

Installation
Unzip the archive somewhere on your system. It does not matter where you do this. It's not required (nor desirable) to put this directory inside your web server directory root. Having the full unzipped archive in your web server's document tree means that users could potentially view your stats.cfg and get your database information.

Before you can run the Installation Wizard to finalize your installation you need to copy the frontend web files to your web server. This should be the only manual part of the installation you have to perform.

Most users running web servers on Windows tend to use the IIS web server from Microsoft. The document root for IIS is usually something like: c:\wwwroot. Thats the directory where you want to copy the PsychoStats web directory into.
Browse to the PsychoStats directory from the archive you unzipped.
Right click on the upload directory and select 'Copy'.
Browse to the document root of your website (ie: c:\wwwroot).
Right click somewhere in the window of that directory and select 'Paste'. The files should copy over in a few seconds.

You should now have the upload directory copied into your web server document root. You probably don't want that directory to stay with the name of upload. So rename it to something more meaningful like stats. You can right click on the directory and select 'Rename' to change the name of it.

So in the end you should have a directory of something like: c:\wwwroot\stats and in that directory will be all the PHP files and sub-directories that make up the PsychoStats frontend website.

For example, to start the installation use a URL like this: [Doar administratorii au dreptul sa vada acest link]
Be sure to use a proper domain name in the URL to where your website is actually hosted.

Edit the stats.cfg with the proper database settings so PsychoStats can connect to your database.

All Done! Now you just need to run the stats.pl to update your stats. If you have shell access on your server then just run:

./stats.pl -v