game queries.

[realchamp]

Hello.

I need some queries for my game servers.
Counter-Strike: Source, Team Fortress 2, Day of Defeat: Source, Left 4 Dead and GarrysMod.

However I found some on google, but they DO NOT work!

I was wondering if any of you had some? Or knows anywhere I can create my own? And what do I need to know to make my own?

I need them in PHP.

- realchamp.

[PeejAvery]

What do you mean by "game queries?"

[realchamp]

I mean like getting the actual amount of players on the server.
And then what map the server is running on. Plus more stuff. And the servers name.

[PeejAvery]

First off, you would have to know the database type, connection, and structure. After that, it would be a simple script to write using the correct database methods.

[realchamp]

First off, you would have to know the database type, connection, and structure. After that, it would be a simple script to write using the correct database methods.

What sort of database do you mean?

The games database itself?

[PeejAvery]

Do you know of any other database?

[realchamp]

MySQL?

[PeejAvery]

That's what I'm saying. You will have to know the database type: MySQL, MSSQL, Oracle, etc. From there, you can then use the correct APIs from within PHP.

[realchamp]

Ahh okay. I will jump right into it.

Do you have any experience or any advice to give me?

[PeejAvery]

Not with game servers. I never got into the gaming realm. Even when I was a teen, computers were always for work or more important things.

But, with programming, um, yes. Here are the various PHP libraries you will need to access the various databases.

http://us.php.net/manual/en/refs.database.vendors.php

[realchamp]

Okay. Thank you!

[socialite]

if you own these servers there are many programs out there that allow you to do this sort of stuff

[realchamp]

if you own these servers there are many programs out there that allow you to do this sort of stuff

I own them. The problem is that I'd like to control them through my web browser.

There is like HLSW, but requires me to install the program ALL the time, pissing me off!