Jump to content

Recommended Posts

Posted

PSYCHOSTATS INSTALLATION TUTORIAL FOR 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

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: http://www.yourdomain.com/stats/install/index.php

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

 

Credits:Same (From Linux Tutorial)

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Posts

    • Hi everyone, Since I’m no longer interested in L2 servers, if anyone is willing to continue the project, let me know. I’m currently selling the entire project. DM me for more information if you’re genuinely interested. I can offer limited free support for the first couple of months. It is not cheap. The sale includes the domain, the recently fully redesigned website, the updater, the interface, server files with Lucera ext source, and the database (excluding account passwords, emails, and other private information; character data can remain).   Server for test: https://lineage2.gold/download Server Info: https://lineage2.gold/info Over 110 videos YouTube playlist: https://www.youtube.com/watch?v=HO7BZaxUv2U&list=PLD9WZ0Nj-zstZaYeWxAxTKbX7ia2M_DUu&index=113  
    • You invent yourself a life - bad for you, one of the inner core dev, fernandopm, which worked hard over aCis quests from 2011 to 2016 is argentinian. I teached him back in time to work and make proper quests. My dev team comes from 10+ countries and I'm myself french. "Racist/nationalist" card ? Not working bro.   Not sure why I should thank you to send me questions, and regarding bug reports, so far, I got none of yours in either discord, gitlab, or forums. I'm sorry if you feel "ignored", but that's more a psychanalyst you need to speak with if you put emotions towards someones' appreciation over a forum. I never ignore a bug report, and if so (like skills reports), it's because I got a bigger plan (skills refactor, in that case). In any case, I delivered cookies for the bug report/fix, even if it dated of months, with proper credits over changesets. "Victim card" ? Not really working, but ok, maybe you're "emotional".   I barely make money out of aCis, for the spent time - simply selling my services, or even coding/administrating a minecraft/L2J server would make far more money. Breaking intentionally things would be stupid. If you don't understand I'm not the only one working on that pack, I can't help you. Also, the scale of edits is sometimes extreme - AI L2OFF ? 1800 files added. How do you want everything works in a single shot ? "Exploiting noobz for money" card ? Still not working, or I'm a terrible businessman.   Meanwhile - you shadow advertise your project, L2JOne (since 2017 btw) - you should maybe start by the beginning saying you're a competitor and aCis is actually a spike in your foot. That also explains why you act like that. RusAcis got the exact same strategy, speaking bad of me, saying they got unique fixes (you speak about I break things, they break and recode things 4 times sometimes, btw), but successfully reselling latest revision with poorly executed stuff. "aCis is good, Tryskell is ok, but I solve all issues in extreme low time so I can piss over him" card ? Mmmmhhhh.   Our conversation ends here if you want, I don't force ppl to speak with me if they don't want - hopefully, people would understand I'm not the arrogant one and the one who doesn't want to talk, or even collaborate. :). I understand you got your own project and got no will to improve aCis.   NOTE : I'm extremely happy for your call of ExShowServerPrimitive with getValidGeoLocation, extremely impressive. Arrogant, no. Sarcastic ? Maybe.   Good night everyone.
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock