Author Topic: War2 Analytics Ver2  (Read 2657 times)

Offline AHB

  • Grunt
  • ***
  • Posts: 50
    • View Profile
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

Offline 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?

Offline AHB

  • Grunt
  • ***
  • Posts: 50
    • View Profile
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

Offline AHB

  • Grunt
  • ***
  • Posts: 50
    • View Profile
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"