[TUT] [HLStatsX:CE] No SSH - Easy Installation

[Description]

This is a system that tracks players stats in real time and works with specified gametypes[GoldSource Games such as Cs1.6,Cs Source]and much more that you can see in admin panel of HLStatsX:CE after installation.

[About Me]

I Will not help anybody other than installation,my guide has a propose to make your server work with the installation of HLStatsX:CE on linux via Cpanel from any webhost without using vps and ssh command line as a result of making the set up of hlstatsx very defficult.So,dont ask me how to install it on windows or how to install it in your computer!

[Requirements Needed Or Else Do Not Begin Installation!]

The hosting provider must provide these services and no limited to:
1) Cpanel.
2) Cron Jobs.
3) Ability to install perl scripts or else ask your support to do so.
4) Reffering to (4) (Perl scripts needed for installation for  HLStatsX:CE 1.6.9 2019  [ AnyEvent::DBI::MySQL , DBD::mysql , DBI , Geo::IP::PurePerl , GeoIP2)
& (6) Perl scripts needed for installation for installation for HLStatsX:CE 1.7.0 2022 [ MaxMind::DB::Reader , Syntax::Keyword::Try, DBI , AnyEvent::DBI::MySQL , DBD::mysql  , GeoIP2::Database::Reader]
5)The ability to unblock your gameserver's port for incoming and outgoing connections and port 27500 that a script named daemon must run on.
6)Php 5.6 or higher for older version of HLStatsX:CE 1.6.9 2019 or Php 7.2 or higher for HLStatsX:CE 1.7.0 2022(Newest Version).
7)Mysql  5.7 for older version of HLStatsX:CE 1.6.9 2019 or Mysqli(MariaDB) for HLStatsX:CE 1.7.0 2022(Newest Version).

[IMPORTANT NOTE FOR EVERYBODY [UPDATE 29/07/2023]: If you are about to install DBD::MYSQL Perl module on linux try this: yum install perl-DBD-mysql on shell or ask the hosting provider to do it so for you,because cpanel updates have changed a lot things regarding perl packages.
[Instalation]

Step1

Download from the file list the file sized: 40.6 mbs.
Link to download:
bitbucket.org/Maverick_of_UC/hlstatsx-community-edition/downloads.
Then decompress the file to your desktop and upload scripts and web folders to your site via filezilla in most cases your site is located in public_html or htdocs folder,so you should upload them in there.Now you need to check if the site part is installed correctly please navigate to your
www.mysite.com/web and see if the hlstatsx are loaded and follow a quick instruction given about deleting the instalation directory.
UPDATE:29/09/2019 DUE TO PHP CHANGES: IN CASE THE HLSTATSX:CE WEBSITE PART IS NOT LOADED PLEASE DOWNLOAD THE .RAR FROM THE LINK BELOW AND REPLACE THE FILES AS INSTRUCTED BY THE README.TXT. LOOK INTO YOUR WEB FOLDER TO FIND THOSE FILES THAT NEED REPLACEMENT.
Download Link Below:
files.fm/u/mmvv4caa
Also if the above files do not work for you,you can visit this link to download the latest HLStatsX:CE here:
Update 2022:Download HLStatsX-CE 1.7 (My Website)

OR(Original Source)

HLStatsX:CE 1.7

Step2

We need to setup a mysql database for hlstatsx to run and this can be done very easily by login in cpanel and navigate to My Sql database wizzard , follow the instructions given to setup the database , database name , database user and database password can be whichever but dont forget to give full permissions to database.

Step3

Now from the decompressed files located in your desktop you need to upload the install.sql file located in sql folder to your database.This can be done very easily again , login to cpanel and navigate to PHP My Admin then you should see on the left column the database you created in step2.So click to that database and from the center bar that is above the tables listing search for import , and import the install.sql file.IF errors come up that means php my admin is not updated from your host or they are dealing with problems related to that , just request them to fix it just in case.Usually 95% of the install.sql file imports are successfull.

Step4

Open the web folder you uploaded to filezilla and search for config.php and open it with a text editor and fill out the data needed in quotes:


// DB_NAME - The name of the database
define("DB_NAME", "hlstatsx");

// DB_USER - The username to connect to the database as
define("DB_USER", "hlxuser");

// DB_PASS - The password for DB_USER
define("DB_PASS", "hlxpassword");

// DB_ADDR - The address of the database server, in host:port format.
//           (You might also try setting this to e.g. ":/tmp/mysql.sock" to
//           use a Unix domain socket, if your mysqld is on the same box as
//           your web server.)
define("DB_ADDR", "localhost");

Note! For localhost is the primary domain from url after login to cpanel.
For Example: If the url is this:
host1.hoster.com:2083/cpsess2113314089/frontend/paper_lantern/index.html?login=1&post_login=4965068622285
The localhost is this:
host1.hoster.com
(If with this way the script is unable to connect to localhost just dont change this value leave it as it by default)

Step5

Now open scripts folder you uploaded from filezilla and search for hlstats.conf and edit the following data in quotes with a text editor as you did in step4:.

# DBHost - Database server "address" or "address:port". Address can be an IP or
#          a hostname. The default MySQL port is 3306 (tcp).
DBHost ""

# DBUsername - User to connect to the database as.
DBUsername ""

# DBPassword - Password for the database user.
DBPassword ""

# DBName - Name of the database to use.
DBName ""

##
## UDP Socket Settings (should match "logaddress ip port" on the game servers)
##

# BindIP - IP address to bind to (leave empty to use all interfaces).
BindIP ""


# BindIP - IP address is the domain name of your main webshared hosting plan or just the IP(Shared IP Address) number at Server Information located at cpanel.
Example:
BindIP "193.70.102.134"
or
BindIP "my-site.com"

Step6

Now we need to find the perl modules file path.This again can be done very easily with cpanel to do it so login to cpanel and navigate to Perl Modules , then you should see with bold letters:
Module Include Path
[For Example Path: /home/hoster/perl] so this path will be used to edit these files:
hlstats-awards.pl
hlstats-resolve.pl
hlstats.pl
[These files are located in scripts folder that you uploaded in step1]
Then as you found these files open each of them and replace the lines that are in bold letters with your module include path:




Step7

Now you need to change files permissions for these files that are located in scripts folders too!

So as you found these 6 files in filezilla edit their permissions from 644 to 777.
To do it so just press right click on each one and select the option file permissions and change the number you see to 777 and apply , ok. 





Step8

Now we need to place some files from scripts folders to the right place.
1)So, login to cpanel and navigate to file manager from the folder list at right column you must! see a folder named perl and inside that folder you should see a folder named usr too!
Skip the below if you have the perl and usr folders.
[In Case you dont see these take into granted that it that they are very important for scripts modules to run if they dont exist in your root listing you must create them and change their file permissions to 755 with same way as you did in step7.Note![This how the modules find the way to run correctly using the {Module Include Path:/home/hoster/perl/}].
2)Now,move all the files that are inside scripts folder to perl folder!
3)Then,move these files to usr folder:





Step9

Cron jobs Tasks:

Now we need to set up some tasks and run some scripts.

The scripts that must be running are these:

run_hlstats [For HlstatsX:CE to run]
hlstats-awards.pl [For Daily and Global Awards To Run]
install_binary.sh [For Country Flags To Run In Server Status And Players Stats]

To do it so login to cpanel and navigate to cronjobs and add a new cronjob for each of the files with the settings i provide below:

For run_hlstats in common settings choose every 5 minutes and in command line write:
cd /home/hoster/perl/usr && ./run_hlstats start
For hlstats-awards.pl in common settings choose twice a day and in command line write: 
cd /home/hoster/perl/usr && ./hlstats-awards.pl
For install_binary.sh in common setting choose twice an hour and in command line write: 
cd /home/hoster/perl/GeoLiteCity && ./install_binary.sh

Note! Dont forget to replace the bold letters with your correct module include path.

To receive logs and check if the tasks run correctly in the email box shown at cronjobs type your email.As a result of that everytime a task runs you will see each's log.

Step10

Servers:

For Gold Scr Games such as  cs 1.6 , hl1mp ,  tf , classic , dod.
Open up server.cfg
and paste inside:





The element that is in bold letters can be found as instructed in step4.

For Cs source/CsGo server.cfg:


NOTE! Create an autoexec.cfg file and copy & paste the above vars too.

Another Configuration for server.cfg

Adding server to your www.mysite.com/web that hlstatsx run on:

1)Open server.cfg and setup a rcon password:
Copy and paste the elements below to server.cfg and change the bold letters with your custom rcon password:



Step11

Site and HLStatsX:CE:

1)Then go to your www.mysite.com/web and at the very down of your screen you will see and an option [Admin]
click there and login with these information:
Username: admin
Password: 123456

2)Navigate from menu listing to Games:
Then,uncheck your game so it cannot be hidden.

3)Go back to the main menu again and try to find the Game Settings,then click add server and put all the info required no need to fill up Public Address just dont forget to select the appropriate mod (SourceMod,AMX,etc.) too!

4)Click add server and you are done with site part for now,also you could have a look to the whole menu and try to understand it.

Step12 and this is the final step:

Gameserver and HLStatsX:CE:

1)Now go to the file you downloaded in step1 and try to locate the appropriate mod for your game server and install it as usual (This is not related to tutorial on how to install plugins or mods for your game server).

2)Restart your server and you are finally done!

​[JUST A NOTE IN CASE YOU FORGOT LOGIN CREDENTIALS AT HLSTATSX:CE WEBPAGE!

Webpage Password reset for admin access at HLStatsX:CE page:
Find at mysql databases the HLStatsX:CE database and just run the below code:   

UPDATE hlstats_Users SET password = 'e10adc3949ba59abbe56e057f20f883e' WHERE hlstats_Users.username = 'yourUsername';
or

Find the database table of users and add the above code without "UPDATE" Then the password will be reset at default:123456.