Servers Monitoring

[V3ct0r 2,117]

Servers Monitoring

 

Hello friends!
Today, I want to represent servers monitoring service by PkoDev.NET community.

 

servers.pkodev.net

 

For the idea and its realization I'd like to thank @Duduf!

 

 

Features

1. Real-time mapping of operable & registered servers. Servers that do not respond for a certain amount of time will be automatically deleted;
2. Displaying of every server's features - version, language, rates,...;
3. Displaying of every server's statistics - number of: accounts, characters, guilds;
4. You can check how many players do play a server in real-time;
5. Filters using which players could find the most attractive servers in their opinion;
6. Widgets for your website.

 

In this way servers' administrators are provided with an opportunity to attract the players on a server, and for the players - to find the most suitable server to play in the shortest duration of time.

 

 

How it works

A special PKODevStat service is started on your server which automatically requests statistics and data from the SQL server every 90 seconds and then sends it to PkoDev.NET; The service itself is an executable that you start together with your: GameServer.exe, AccountServer.exe, GroupServer.exe and GateServer.exe;

 

On the basis of the data our website creates a list of currently operable server with basic information.
You can also install a special widget on your website that should display the same information of any page of your website. 

If server hasn't retrieved data for 24 hours, it gets automatically deleted.

In the top of the list our service stores servers with the highest number of online players (if it retrieved data during the previous hour), otherwise ranking is carried out by the last reference to the PkoDev.
Servers with 0 online are placed at bottom of the list by the default.

 

 

Important
PKODevStat.exe service does not send any extra data (for instance, logins or passwords of your server players). Also, server does not do any edits in the SQL server. Moreover PKODevStat is an open source and you can easily find it out on your own. We are not interested in breaking any server!

 

 

How to get your server being monitored?
That's quite simple. Head to "For servers admins" section  on the service's website and click "Download". PKODevStat will be downloaded on your PC which which later has to be configured and opened manually.
 
You would have to edit config.json file which consists of 3 sections:
 
1) Server section - basic information about your server:

name - name of the server. From 5 and up to 55 symbols are allowed, do not use any special symbols;
url - server address, should start with either "http://" or "https://";
lang - server language. Use the two-letter ISO code in lowercase: ru, en, br, etc;
timezone - timezone of the server. Example: UTC +4 or Europe/Moscow;
version - server version, strictly in double type: 1.3, 1.39, 2.0, etc;
since - date and time when your server was first open publically (launched). Format: YYY-MM-DD HH:mm;
rates - server rates:
    exp - solo rates;
    drop - drop rates;
    pet - pet rates;
    ship - ship rates;
    party - team rates;
    resource - resource rates;
	
lvls - max levels in game:
    char - max character level;
    pet - max pet level;
    ship - max ship level;

2) db section - configurations required to establish SQL server connection:

server - SQL server hostname;
port - SQL port;
user - DB username;
password - DB user's password;

3) tbl section - names of tables in AccountServer and GameDB databases. Edit them only if your table names are different from original.

 

If that you've edited the config, save it and run the program (PKODevStat.exe). Run only one copy of .exe file and make sure you see a label: 

Runing PKODev service...

If there are no errors & mistakes in configuration, there will be no extra notices after the label and you should be able to see your server at servers.pkodev.net.

Otherwise, fix the errors and restart the application. If you do any edits in config.json, you should always restart the program.

 

 

If you have any suggestions, notes or questions regarding the work of the monitoring system, then you leave a comment and we will certainly review it!

 

Thanks to @qwerty for news translation!

[Home 50]

Nice work @V3ct0r and @Duduf , my server will be there soon...

[Danny 31]

Awesome tool, good job @V3ct0r & @Duduf should be a must have for any server.

[Jap 189]

I applaud for you @V3ct0r and @Duduf for making this idea a reallity, really good job in order to make tales of pirates a great game again.

 

Peep this out @Shako.

 

Current online:

Online

Characters: 194

Accounts: 201

 

I don't quite get this, how can there be 194 chars online and 201 accounts online, some kind of bug?  shouldnt it be equal number like 194 194

Edited November 13, 2016 by Jap

[V3ct0r 2,117]

2 часа назад, Jap сказал:

I don't quite get this, how can there be 194 chars online and 201 accounts online, some kind of bug?  shouldnt it be equal number like 194 194

 

It's ok. 201 players are logged in, but only 194 of them have selected character and entered to game (map).

[Shako 97]

18 hours ago, Jap said:

I don't quite get this, how can there be 194 chars online and 201 accounts online, some kind of bug?  shouldnt it be equal number like 194 194

 

16 hours ago, V3ct0r said:

It's ok. 201 players are logged in, but only 194 of them have selected character and entered to game (map).

 

The two types of login, character and game have different memory addresses. That's why.

Edited November 14, 2016 by Shako

[Faller 93]

Hey guys! Firsly, I'd like to thank V3ct0r again
And secondly, I'm having a small problem with the SQL connection:

 

 

Any helps? Thanks!

[Danny 31]

2 hours ago, Faller said:

Hey guys! Firsly, I'd like to thank V3ct0r again
And secondly, I'm having a small problem with the SQL connection:

 

 

Any helps? Thanks!

 

"The thing about collations is that although database have it's own collation, every table, and every column can have it's own collation. If not specified it takes the default of it's parent object, but can be different.

 

When you change collation of database, it will be new default for all new tables and columns, but it doesn't change the collation of existing objects inside database. You have to go and change manually the collation of every table and column."

 

Taken from http://stackoverflow.com/questions/17616620/cannot-resolve-the-collation-conflict-between check there for the solution if it works on your case not sure why your database has two different collations.

 

 

[Home 50]

@V3ct0r can you put a banner or a link for this in the forum main menu?

[V3ct0r 2,117]

13 часа назад, Home сказал:

@V3ct0r can you put a banner or a link for this in the forum main menu?

Ok, I will do

[V3ct0r 2,117]

В 23.11.2016 в 01:30, Home сказал:

@V3ct0r can you put a banner or a link for this in the forum main menu?

Done

[Shako 97]

I would like to recommend a view counter (per day, week, month) on the page servers.pkodev.net and click counter for each link to see the impact

Edited November 26, 2016 by Shako

[Home 50]

my server Go Pirate King, will soon be there!

[V3ct0r 2,117]

Update: Total players online and link to the forum.

[Blanquitoh 50]

On 11/28/2016 at 0:07 PM, V3ct0r said:

Update: Total players online and link to the forum.

Just an error:

Spoiler