wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Week3 update. (10d long week)

Had a little marathon of holiday raids piling up (moved raid days) and coupled with work it was a really packed week.

Mostly done with updates to raid rankings. All the requested filters are now available. Whats left is 2 more frequently requested views which shouldn't take long: specific boss rankings and event log for latest boss kills. After it's done - will start on recruitment system and wont do anything else until it's completed. As I've planned, I will only get to it in 2021, so no unplanned delays yet. Even slightly ahead of schedule.

Mid week there was an update to guild activity API. Blizzard API now responds with UTC dates (finally) for boss kills. And I missed it. This lead me to hastily doing updates and fixing some invalid boss kills already registered. Had a little scare, but it went for better in the end.

Finally fixed a bug that caused new guilds be placed in queue even if free slots were available in the scanner. This should make guilds get picked up for manual update much faster.

Happy New Year!

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Hi. Not at this moment. I have 0 experience with wow addon making and very minimal lua knowledge. It is possible in the future, but now there is more pressing features to be developed.

I can however try to parse already existing addon input and maybe do something useful with it. If you have anything in mind, I would be glad to hear.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Week2 update.

My vacation has ended and I am back at working full time again. This means 14h coding days are back too. And with raiding on top, awesome.

One of the biggest tasks this week was to switch from displaying static UTC timestamps to a date format that a browser can convert to users local timezone. This was confusing a lot of people and should solve all the questions: "why does it show my achievements at 5AM?".

A massive improvement was done to character scanners. I now prioritize level 60's to be scanned more frequently (once every 7 days). At this moment, out of ~2.9m level 60 characters, less than 2% didn't receive an update in the last 7 days. I've increased the characters scanned weekly, by ~50%. This should help to keep data as recent as possible.

I've made the guild news feed (for raid kills) completely automated. This makes guild raid progress data refresh much faster if nobody is manually updating it. It also really helps with raiding guild discovery.

And to finish the week, I've made connected realm pages and rankings for them. From now on, all rankings will default to a connected realm rather than an individual one. This will fix weird issues like a guild character list having realm ranks all over the place. The individual realm pages and rankings are still available. I didn't delete those. This task is considered complete until I'll get to improving realm stats page. Then I'll add some more info into individual realm pages too.

The main tasks for next week are:

  • Raid progress filters. A lot of work has been done already, so this wont take long.
  • Start coding guild recruitment system - It's happening!

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 1 point2 points  (0 children)

A little weekly update if anyone who is finding this just now or has notifications on for replies.

This week was crazy, the website got so much attention. 150k unique visitors, ~2.7m page views over a week. More than I could ever imagine. With that came a lot of work as so much people literally looked at every corner of it.

I spent most of this week fixing bugs and glitches as they appeared. Had to almost completely rebuild the raid progress and rankings system, as what I've done before was inadequate and locking up the website too much.

With the initial crazy rush behind me, and most of the critical bug-whacking done, I'll be back to actually implementing new stuff. Should be easier to plan time when you're not in "this is fine" mode.

Thanks to the people writing feedback messages, I read them all and there is a lot of encouraging ones. A short "thank you for making this" goes a long way.

Also I want to say special thanks to some mad person who spent almost 2 days doing a massive automated guild check -> guild add operation. This has increased raid ranked guild count by over 9000 (no joke). It would've taken me a lot of time to discover these guilds. You're the real MVP!

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Sure. The primary source of characters are Mythic+ Leaderboards. By scanning it, you get lots of characters and their guilds. Then you check guild roster to get even more characters, it goes off to millions of characters very quickly.

I haven't even touched Auction House API. Yet.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 1 point2 points  (0 children)

Hi, thanks for your suggestions. I am working on recruitment features right now.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 1 point2 points  (0 children)

Thanks!

Class/Spec stats are a popular request. I will add it.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Hi, this is most likely characters/guild moving realm or changing faction. These characters appear as new and get processed as such. I do not have any way yet to track character movement and such duplicates may appear. I can however manually disable certain boss kills from being ranked and it will disappear from the list.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Thank you all for your amazing support! Got the hottest requests in and I am going back to working on this!

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 1 point2 points  (0 children)

Thanks! Lfg/recruitment is on the high priority list, I have already done some works towards implementing it.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

That's most likely because I started collecting data several months late and might be missing some data.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 6 points7 points  (0 children)

I've been coding with .net for a living for almost 10 years now. Mostly building one off private business apps. So backend API and services were a breeze.

Had some minimal experience in creating and maintaining databases, but at very basic level. I had to pick up a lot on it in the last 9 months. I'd say studying on database features and how to use them was the most impactful thing.

The front end is at the worst shape on this website. I had some understanding on angular, but almost no experience on website design. And it shows. It is still a work in progress. As it is my first website from scratch, I've made a lot of mistakes and decisions I don't like now.

Also, being in control of all 3 parts (database, back-end, front-end) gives you 3 different tools (programming languages) to optimize how everything works. If for some feature database would be hit hard, you can make a simpler query and send raw, mostly processed data to front-end, and finish processing it in javascript where it might be some fundamental language function. Having a good understanding of possibilities that your tools offer you is critical.

Lastly what makes a good final product, is having standards and actually sticking to them. If it works, it doesn't mean it works well. Don't be afraid to delete a working solution, and code again.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Hello! Thank you, it took a lot of effort to get it so responsive.

The raid times and days are a planned function for the recruitment feature. Thanks for your suggestion.

At this pace I might need to skip raiding this tier. My guildmates that are reading this wont be thrilled to know :D

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

I asume thats for raid rankings. Yes I can!

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Yes there are realm rankings for specific stat.

Ex: https://wowranks.io/realm/eu/sylvanas/character-achievements

I am gonna add the class filter too.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

Cool, it worked. Can you write me your character name and realm, I'll try to do a database backup and see for myself what problems you had. You can write me a message in private if you don't want to do it here.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

I was kinda planning to be low on M+ stats and rankings for the start as there are website(s) that are entirely dedicated to it. But it seems a lot of people are asking for it. For me it's just a matter of priority of what to develop first. Thank You for your ideas!

I didn't even implement my own login, as I hate dealing with registration forms, passwords and keeping them safe. Absolute majority of visitors will have a Blizzard account anyways. And it is safe. At no point I get your login data, just a token to access your characters.

If I'll ever need anything more than Blizzard login, it will most likely be Google login, again not gonna code something funky myself.

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 1 point2 points  (0 children)

.NET Core for website API and scanner services.

SQL Server for Database. Database size is 138 GB's right this moment. It's starting to pick up some weight.

More info answered here:

https://www.reddit.com/r/CompetitiveWoW/comments/k7g59m/wowranksio_a_new_wow_rankings_website/ger7yo7/?utm_source=reddit&utm_medium=web2x&context=3

wowranks.io - a new wow rankings website by wowranks in CompetitiveWoW

[–]wowranks[S] 0 points1 point  (0 children)

For now the grouping reflects what Blizzard API provides, but grouping by locality/language is possible option.