1 Topic by hikki

  • hikki
  • hikki
  • Member
  • Offline

Topic: TBT: mod with statistics

Dear community!
I strongly need your opinion.
Recently I had the idea to develop script to collect statistics from teeworlds-games.
I'm already release client-based script on Lua with n-client. Иut it is bad, because it works only when I am in game. And i have to pass all results to web-part.
Results you can see at http://bigtee.tk/ (it works bad because of free heroku hosting big_smile)

Next part was to move this script to server side. It's complete. In real time script writes all data to DB.

But i has a big problem - size of the DB. Now script stores player' games, frags, deaths and PvP - a number how many each player kills each other.

You can understand, that storing PvP needs a huge DB size (for example, if server had 1000 players it will be around 1000000 lines in PvP table).

So, i have a few questions:
- will be useful to you do this service?
- whether there will be interest in statistics on PvP?

P.S.: i want to release server-side stats on 20th January with web-part
P.P.S.: serach for TBT in teeworlds - i need more players to test my servers wink
P.P.P.S.: sorry for my english. I'm from russian-speaking country...

2 Reply by Ioannisjanni

  • Ioannisjanni
  • Ioannisjanni
  • Donor
  • Offline

Re: TBT: mod with statistics

So something like teeworlds statistics , but with specific games ?

Teeworlds!!!!

3 Reply by hikki

  • hikki
  • hikki
  • Member
  • Offline

Re: TBT: mod with statistics

Now it's only collecting of stat. But we have some ideas to improve teeworlds. Especially clan-subsystem, new gametypes, ect.

4 Reply by TeecTac

  • TeecTac
  • Member
  • Offline

Re: TBT: mod with statistics

Hi hikki,

Did you consider using a NoSQL database ?
Looks like they do what you need.

I currently have ~ 100 000 tee names in my database.
Hopefully, it does not mean you need 10^10 lines since every tees only kills a small subset of all players.

Moreover, in a NoSQL database, it would only take 100 000 lines since it is capable of storing JSON.
You would have lines like { 'player'=>'hikki', 'Teectac'=>10, 'Mr. Pinky'=>20 } with all the tees you killed.

That kind of statistics would be interesting in matches of limited time.
For instance you could have a website where teams could challenge each other and display their success.
This display would show every game they participated to and details of their kills.

Developper of teeworlds-stats.info

5 Reply by hikki

  • hikki
  • hikki
  • Member
  • Offline

Re: TBT: mod with statistics

Hi TeecTac,

Firstly - i respect you for developing your service!) It's very usefull.

About NoSQL... I'm afraid using it without certain reason now big_smile But planning to use NoSQL in future.

Thanks for your opinion.