V3ct0r 2,117 Report post Posted November 12, 2016 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 Real-time mapping of operable & registered servers. Servers that do not respond for a certain amount of time will be automatically deleted; Displaying of every server's features - version, language, rates,...; Displaying of every server's statistics - number of: accounts, characters, guilds; You can check how many players do play a server in real-time; Filters using which players could find the most attractive servers in their opinion; 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! 11 Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
Home 50 Report post Posted November 12, 2016 Nice work @V3ct0r and @Duduf , my server will be there soon... Quote Share this post Link to post Share on other sites
Danny 31 Report post Posted November 12, 2016 Awesome tool, good job @V3ct0r & @Duduf should be a must have for any server. Quote Share this post Link to post Share on other sites
Jap 189 Report post Posted November 13, 2016 (edited) 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 1 Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 13, 2016 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). 1 Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
Shako 97 Report post Posted November 14, 2016 (edited) 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 Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Faller 93 Report post Posted November 15, 2016 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! Quote Share this post Link to post Share on other sites
Danny 31 Report post Posted November 16, 2016 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. Quote Share this post Link to post Share on other sites
Home 50 Report post Posted November 22, 2016 @V3ct0r can you put a banner or a link for this in the forum main menu? Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 23, 2016 13 часа назад, Home сказал: @V3ct0r can you put a banner or a link for this in the forum main menu? Ok, I will do Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 26, 2016 В 23.11.2016 в 01:30, Home сказал: @V3ct0r can you put a banner or a link for this in the forum main menu? Done Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
Shako 97 Report post Posted November 26, 2016 (edited) 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 Quote Sunny Go! Online pko.host Share this post Link to post Share on other sites
Home 50 Report post Posted November 26, 2016 my server Go Pirate King, will soon be there! 2 Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted November 28, 2016 Update: Total players online and link to the forum. Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
Blanquitoh 50 Report post Posted January 13, 2017 On 11/28/2016 at 0:07 PM, V3ct0r said: Update: Total players online and link to the forum. Just an error: Spoiler Quote Share this post Link to post Share on other sites