[quark]

qServerinfo [MYSQL]
v 0.6 by quark

-> Description

This plugin will insert into a MYSQL Database server information as hostname, map, players/maxplayers and ip.


-> Changelog

< Plugin >
*0.1 - First release.
*0.2 - Fixed bug when change map.
*0.3 - Added server IP Saving.
- Removed Ignore HLTV/BOTS.
- Fixed Player Count. ( I guess. )
* 0.4 - Removed Server ID.
- Set Server IP as Primary key.
- Changed way to get Server IP.
- Added maxplayers.
- Fixed Player count. ( Testing. )
* 0.5 - Added log to amx.
- Fixed server IP.
* 0.6 - Fixed Player count. (Finnaly )

< Php Script >
*0.1 - First release.
*0.2 - Added auto-refresh.
*0.3 - Added "connect" button. (steam).
- Fixed split servers by id.
- Removed auto-refresh.
- Removed unnecessary code (style).
*0.4 - Added IP/MaxPlayers.
- Edited button style.
*0.5 - Changed from mysql to mysqli.
- Added Total Servers.
- Small change in style.


-> Cvars

PHP Code:

    /* SQL CONFIGURATION */

qSi_host "localhost" // Host
qSi_user "user" // db username
qSi_pass "password" // db password
qSi_db "db" // db name
qSi_sid "1" // Server ID 


-> Configuration

You can insert the cvars in amxx.cfg or just edit it in plugin.

PHP Code:

//#define IGNORE 


If you uncomment that line, the player counting will ignore HLTV / BOTS.


-> Requirements

PHP Code:

#include <amxmodx>
#include <sqlx> 


-> PHP Script

>>>> Live Preview <<<<

To make it work, you have to edit the following lines:

PHP Code:

$host="localhost"; // Host
$username="user"; // Mysql username
$password="password"; // Mysql password
$db_name="db"; // Database name
$tbl_name="qserverinfo"; // Table name 


Download qserverinfo.zip in attachments.


-> To-Do

• Waiting for suggestions.

-> Contacts

* Steam: CANDY
* Mail: [email protected]
* Website: www.joserodrigues.in

[sami_spt]

cool. will test now.


EDIT1: qSi_sid "1" // Server ID

what is that?


EDIT2: When you add a php page, i ill test.

[quark]

Originally Posted by sami_spt EDIT1: qSi_sid "1" // Server ID

If you want to add like 10 servers. You make like serverid 1 , serverid 2 , serverid 3, =D

[ConnorMcLeod]

You don't need any addon on server to query server information from website...

[quark]

Originally Posted by ConnorMcLeod You don't need any addon on server to query server information from website...

Yeah , but some hosts doesn't allow queries.

[ConnorMcLeod]

Please give1 IP example.

[quark]

Originally Posted by ConnorMcLeod Please give1 IP example.

i don't get it

UPDATED Php script.

[ConnorMcLeod]

I mean, you can query any servers, else you wouldn't be able to collect IPs in steam browser, or you wouldn't able to see servers in HLSW.

[quark]

Originally Posted by ConnorMcLeod I mean, you can query any servers, else you wouldn't be able to collect IPs in steam browser, or you wouldn't able to see servers in HLSW.

What i mean is, in my VPS the query script working fine, but in my website, it doesn't.

That's why i made this.

UPDATED Live Preview Link.

[^SmileY]

Originally Posted by ConnorMcLeod I mean, you can query any servers, else you wouldn't be able to collect IPs in steam browser, or you wouldn't able to see servers in HLSW.

He is talking about socket protocol used to query the servers, in same hosts is not allowed to send packets using php sockets like gamequery or other scripts.

Nice idea, is a alternative solution to do this.