gameserver List

[24play1]

I will drop him a text and see if he pops on

 

best I can do

[abhi147]

Hey GameConnector's, Could you send me a copy too?

 

serveradmin@v-street.net

 

Thanks .

[Jesse]

I too would like a copy <3

 

jessegreen-test@hotmail.com

 

Thanks!

[Todd Holley]

Lol, I guess no one will ever get a copy. He could make some money selling copies!

[cyberwolfie]

Hi Guys,

 

We have written our own statistics asp.net application that uses the tcadmin database to get ip, port, qport and run these against qstat to return server name online/offline, players, map and a link for details to show the players.

 

It also shows total servers online, offline, and players in a summary page.

 

It works 100% for all the games we sell, so should work for other too. We would be willing when it's finished to licence the software to other companies so that our development costs are covered, but are not looking to be silly on prices.

 

We have a little bit more work to do and need some input from you. There needs to be a mapping table for what you name your game servers to map to the qstat query. For example, we may have Call of duty 4 in our tcadmin, but you may call it COD4. Where should this table be stored? In the tcadmin database? in a seperate mysql? in a flat file?

 

Also, because the query of live game servers could be quite a large list, we are thinking of coding in a schedule every 15 minutes and storing the results in a table as it would be very resouce intensive if a few customers all clicked it at the same time.

[ECF]

I would suggest against creating any new tables in the TCAdmin database, as the software goes to version 2 the database structure will change and your table may be deleted.

[cyberwolfie]

Thanks ECF,

 

I did think about that, it's only a static table and we could include a create table script, but it is better outside of the database, I agree with you there. My thinking was the database already exists and we don't know if people have the ability to make an extra databases.

 

Appreciate the information.

[ECF]

Version 2 will have the ability to use a number of database types as well. So some people may not choose to use MYSql.

 

Just figured I would warn you before you put all the time and effort into it and we come in behind you and break it

[adamnp]

ECF your such a tease.....especially with those hotpants on!

 

v2! v2! v2!

[ECF]

I do hate to give information out on v2 really, as it is a tease. But in this case I had to in order to save this person from coding something and then having it broken later down the line.

[cyberwolfie]

Hehe, it's all good.

 

We had a good chat about this today and are going to provide a connection string manager that supports Access, MSSQL, MySQL, etc.

 

For the amount of data we need to hold, a rolled out mdb or msde database would be fine.

[cyberwolfie]

Hi Guys,

 

Thought I would give you an update.

 

It's just about finished.

 

Supports the following games so far.

 

Armed Assault

Aliens Vs Predator 2

Americas Army

Battlefield 2

Call Of Duty

Call Of Duty United Offensive

Call Of Duty 2

Call Of Duty 4: Modern Warfare

Counter-Strike 1.6

Counter-Strike Source

Day Of Defeat Source

Enemy Territory Quake Wars

Enemy Territory

Far Cry

F.E.A.R

Garry's Mod

Half Life 2 : Death Match

Halo

Jedi Knight 3 Jedi Academy

Medal Of Honor Allied Assault

Medal Of Honor Spearhead

Medal Of Honor Breakthrough

Quake4 and older

Soldier Of Fortune 2

S.T.A.L.K.E.R

Tactical Ops

Team Fortress 2

Unreal Tournament Various

 

Any others games people need added?

 

We have kept it completly seperate from tcadmin, it currently does not need to do anything other than read from your tcadmin services table to get your list of ip/port/query ports. We assume most people will do like what we do and run this locally on your tcadmin box. But we can support remote db login's if people want that.

 

This is not currently running from our live tcadmin, we took a copy of the schema and just added some servers in to show it working.

[swish]

Now that looks sharp. When is this going to be available?

[cyberwolfie]

Thanks Swish

 

Around a week or two at the most.

[swish]

Awsome. I am lookin forward ot this one.

 

Be sure to have "Totals" available

 

ie: Total Players Online, Total Servers Online. I know this is a biggy for alot of people.

[cyberwolfie]

Yeah, thats what it started with for us. The summary is displayed at the top of the page.

 

[adamnp]

nice work cyber, very impressive

[DougK94]

Looks very good

[ECF]

Now add a graph!

 

[swish]

GREAT SUGGESTION! Transparent graph so it could go on anyone site and you have it locked down!

[cyberwolfie]

To add a graphs, it's going to have to keep a history of your visitors, we haven't included this as the data will get quite big. We did start doing this so we could have a kind of top fragger being the person spent the most time on the servers.

 

We could just keep a count of the servers / players, which would be a much smaller list and graph that.

[ECF]

Just add a graph that show the current numbers from the last polling. No need to store huge amounts of data for it.

[swish]

Exactly. Only need to log maybe the last 10-20 players online points. They could be cleared after that.

[cyberwolfie]

What we are going to do is this.

 

We will create a non web application that you can run on your admin server. This will include in it a database that will allow you to change the logo, colour scheme etc. That way, the local database in our application can be used to cache summary statistics.

 

We wont store players, I really dont think anyone cares that much about them. Our graph could then show the peak players for each day in a month. A bit like how Serverspy does it now.

 

We are adapting it a bit to make it more generic so other people can use it, becuase of this, like I said previously, it will be chargeable, but this isn't something our business focuses on, so are just looking to recoup some of our development costs.

[swish]

Any word on pricing yet?