War2.ru Slogan
News: There's a new version of War2Observe that fixes the crash issue,
download from the downloads page today!


Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
Welcome to the forums! We're glad to have you here! :) You can register your account here, then feel free to introduce yourself in the Server.War2.ru board & let us know who you are on the server.

War2 Analytics Ver2 110  3

Grunt Posts: 50 Karma: +0/-0 ***

AHB

  • Grunt
  • ***
  • Posts: 50
    • View Profile
*

AHB

War2 Analytics Ver2
« on: May 17, 2018, 08:28:25 PM »
Those of you who remember I made analytics.war2.co a while back

It was a PHP site with the backend powered by Python scrapers, and I started rewriting it to be Python/Flask with VueJS javascript front end a year ago but I never finished it...

If anyone is interested in this project let me know.

I have 30,000+ games neatly parsed, an entire year of data, you can literally find out anything you want. You can ask questions like

“how many times did playerA beat playerB when the game lasted longer than 10 minutes, playerA was orc, playerB finished with less than 3,000 gold, on a Friday night in April”

For those of you who know a bit about databases and SQL, you can check it out yourself!

https://war2.info/addy.php
username: public
password: public
Critter Posts: 2 Karma: +0/-0 *

Lafleurz

  • Critter
  • *
  • Posts: 2
    • View Profile
Re: War2 Analytics Ver2
« Reply #1 on: May 31, 2018, 06:21:54 AM »
I would like to know about the content that you have a source of knowledge that can guide me?
Grunt Posts: 50 Karma: +0/-0 ***

AHB

  • Grunt
  • ***
  • Posts: 50
    • View Profile
*

AHB

Re: War2 Analytics Ver2
« Reply #2 on: May 31, 2018, 12:54:05 PM »
Sorry I dont have any documentation but if you have a specific question I can answer for you here
Grunt Posts: 50 Karma: +0/-0 ***

AHB

  • Grunt
  • ***
  • Posts: 50
    • View Profile
*

AHB

Re: War2 Analytics Ver2
« Reply #3 on: May 31, 2018, 01:01:08 PM »
Maybe I can provide some examples if I get time

Like this one - get game reports for user "wretcher" where he won

select * from user_game_score inner join game on user_game_score.game_id = game.report_id where user_name = "wretcher" and outcome = "WIN"