PDA

View Full Version : Server Status Plugin


Mr.Freeman
07-03-2016, 21:35
Hey Guys,

I was wondering if anyone could write a quick MYSQL plugin for me if possible. Things I need are as follow

Fetch IP of the gameserver and that remains the same however if a player joins the server it updates the table structure of the server_state to 1 and if there are no clients in the server then it sets server_state to 0 with the correct server.

Table Structure

CREATE TABLE server_states (
id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
server_ip VARCHAR(50) NOT NULL,
server_state INT(1) NOT NULL,
time_stamp TIMESTAMP NOT NULL
)


If you are able to do this for free that would be awesome, if not I can pay what you need.

Hope to hear from someone soon,
Mr. Freeman

Grey83
07-04-2016, 04:50
Game(s)?

HSFighter
07-04-2016, 05:43
Hi Mr.Freeman,

i wrote exacly this plugin some time ago for our Community.

Feel free to use it.

Edit Line 13 to change your Database similar to entry in "databases.cfg".