94 replies to this topic

[Sorrows]

Interesting... Thanks for that and gl on whatever you decide on your project!

[thetoothpick]

Gudradain, on 26 June 2015 - 07:03 PM, said:

Yup

In the process of doing a complete rewrite with an insert only database which means that it will keep historical data and even if something fucked up like now, I won't lose data.

Sadly, I'm not home this week end so it might take some times...

I have a lot of experience with PHP, MySQL (/SQL in general), and HTML, so if you want to throw the code up on some repo somewhere (i.e. github / bitbucket) I can help out (assuming you know your way around version control - it's worth learning if you don't).

[Gudradain]

thetoothpick, on 26 June 2015 - 10:54 PM, said:

I have a lot of experience with PHP, MySQL (/SQL in general), and HTML, so if you want to throw the code up on some repo somewhere (i.e. github / bitbucket) I can help out (assuming you know your way around version control - it's worth learning if you don't).

Thx for the offer. Yes, I know and use source control everyday. I'm planning some very specific things for the front end and I would like to keep control on it but I guess we could colaborate for the backend.

The backend is currently a cron job that runs every 5 minutes, compile and calculate everything that is computationally expensive. For example, just retrieving the data about the matches by querying anet api can take 5-10 seconds so it's not acceptable that your page take that much time to load. The other reason to have the back end is to keep historical data.

We could then build a json api to share that information.

[Gudradain]

Aduah, on 26 June 2015 - 12:55 AM, said:

Made you a quick and simple header. If it comes out weird when you download it, I can upload it somewhere else. Also, you dont have to feel pressured to use it at all. It took me all of maybe 5-10 mins to make, so no big deal. xD

I think it's very nice. I already found a place where I will put it and it's always nice to have a logo

[cassy]

Hmmm is anyone here good at BGP?

Gudradain, on 25 June 2015 - 09:20 PM, said:

Pie chart won't cut it I'm afraid but I have something in mind

As long as it isn't line graphs, they are an ugly way to organize information.

Gudradain, on 26 June 2015 - 05:14 PM, said:

So yeah... As expected it crashed for the wvw reset but surprisingly it was EU reset instead of NA reset. I guess I fucked up somewhere. This means that this week data is lost...

If you took a snapshot you should have at least some of the data, and if not, there will be other weeks

[Biff Rangoon]

cassy, on 27 June 2015 - 04:06 PM, said:

As long as it isn't line graphs, they are an ugly way to organize information.

But it would be the best graph to show comparative server strength over time.

Less pretty it may be, but it'd be the graph I'd use for this purpose.

[cassy]

Well, an animated chart would be the clearest but the most time consuming to make.  I think that a stacked area chart could also work, and I think you can get still get excel to just pop it out.
Line graphs with too many data points are just a mess.

[Gudradain]

Hmmm don't think stacked area chart would cut it either to show the ratings. Stacked area would be perfect to show when each server is cumulating score during the day in the same matchup though.

[Gudradain]

Yay, website is back online and problem should be fixed. I had to change the whole DB architecture and rewrite most of the code. I'm not so sure what I was thinking with the first DB architecture... Also, there is already a few new features :

1. You can now see the normal ratings (day long) as well as period ratings.
2. Sorting the ratings is now descending first
3. Database keep historical data (scores and ratings)
4. The rank in each period (when you click on a row to see more details)

Hopefully, this time it will survive reset...

[Gudradain]

Ok, so I want to start working on a graph to make things easier to see on the screen but I'm not really sure what would be the best way to present the information. The best indication of each server strength is the the ratings so I think the graph should be around that information.

So far, I was thinking about creating a dynamic line graph but nothing is set in stone yet. Here is a rough picture of my idea :



Basically, you got a list of server on the left and a graph that show their strength on the right. You can click on each server to show/hide them on the graph.

Good or bad? (What would you do instead if bad)
What would you add/remove?

[Sorrows]

Question: Does your data displayed wipe itself out every time you alter the site? It seems the data has reset throughout the day today.

I like the ability to select server to compare, I would limit it to only 4 or 5 at a time (even 3 really, like pictured) so it doesn't get too cluttered.  

The only issue I have with the site right now is that it's one GIANT table. I get this allows the whole ranking to be altered up/down etc, but it feel like it's a lot of numbers for your eyes to skim. Could you break it out and make it selectable by tier matchup and upon selecting that it brings up your graph etc?

[Gudradain]

No, the data is in the database.

When I update the site, I simply modify the code which doesn't affect the data (unless it's backend stuff). Today, I droped all the old tables from the database and created new ones that fit better. It's probably the only time I do that so it shouldn't be a worry anymore.

[Gudradain]

Also, a general note to everyone.

Pictures help me to understand what you really want when you ask something.

[Gudradain]

Yay, it survived its first reset

[Gudradain]

Hey guys, the new version of the website is up and it features a brand new section!

Check this out : http://coveragewars2....php?world=1010

Also, the website has now a menu and a logo (thx to Aduah)

[Slein Jinn]

No option to select a region?

[Gudradain]

Slein Jinn, on 06 July 2015 - 05:02 AM, said:

No option to select a region?

You don't like UTC time?

[Slein Jinn]

I have an account on an EU server.

[Gudradain]

EU is coming at some point but I want to finish all the feature I'm planning first.

[Aduah]

I like the banner up there in the top. I didn't think about putting it there. But it looks good there.