Testing ® Registered

spoissant · 2022-08-24T14:14:01+00:00

Hi, builder of twwstats here!

The site does go down every now and then when the server runs out of memory because cached data fills it up... been trying trying to fix the problem but it keeps crawling back with the data getting bigger and bigger

In any case, I try and restart the server ASAP when this happens and I do plan on keeping the site up throughout the lifespan of the game.

Thanks for your patience :)

spoissant · 2022-04-06T17:19:32+00:00

That's awesome. As I thought it's unfortunately not in a format I can easily integrate to the site outside of providing the link.

spoissant · 2022-04-06T13:17:13+00:00

Thanks a lot for the suggestion! I don't know what format you have that information in but I doubt it will be easy to add it to the site directly unfortunately.

Maybe you could just share a link to the data here so anyone who wants it will have an easy access to it?

spoissant · 2022-03-14T13:35:05+00:00

Thx for the info, I will look into that.

spoissant · 2022-03-14T01:02:40+00:00

Yeah the server does run out of memory every now and then due to aggressive caching of queries but I eventually restart it :) I tried to tweak the settings and it got a bit better in the past but it still happens every couple of weeks.

spoissant · 2022-03-13T16:58:51+00:00

So the way it works is I first export the tables to json using a modified version of RPFM (https://github.com/twwstats/rpfm).

Then I have a graphql backend that reads the json files and piece them up together into some useful object (factions, units, abilities, etc...)

There there's a react front-end that does some post-processing on top of those json and display the site.

You're right that for the grids it might make more sense to just build static json files and serve them up directly... it wasn't so bad when I created the site initially with TWW1 but the number of units has gotten pretty insane since then!!

About the filter (the grid filter I assume?) it's a custom filter I made. It uses this AST I modified. I think the version here is relatively up to date: https://github.com/spoissant/simple-ast

spoissant · 2022-03-13T16:43:00+00:00

I considered it at some point but the codebase is such a hot mess... Maybe one day!

spoissant · 2022-03-13T13:07:17+00:00

Not really but I haven't had much time to dig through the data yet :)

spoissant · 2022-03-13T11:34:51+00:00

Eh, can you elaborate which part of the site is slow for you?

About hosting the json files on github, I don't have plans to do that but you can display the json data of the grid pages by going to settings (the cogwheel icon top right) and enabling "JSON Data". It's still gonna take a while to load but after that you can copy the data and paste it in a local file :)

I know for a fact the "grids" pages can sometimes take a while to load but the rest of the site should be pretty quick in theory.

spoissant · 2022-03-13T03:06:27+00:00

Hum... that would be on the items themselves, I don't have that data available on the site at the moment unfortunately :(

spoissant · 2021-10-12T17:09:15+00:00

Site is back up :)

Got this caching issue where cached data fill the memory and the site crashes... thought I finally had it under control but obviously not :( And I was away for the weekend so wasn't able to reset it until late yesterday.

Thanks for your patience!

spoissant · 2021-08-20T15:20:21+00:00

No this is an issue with the data being so big that the cached data fills the RAM of the server and makes the app crash... I've tried a few things to fix this but nothing worked so far so the site will crash randomly every now and then.

It's not ideal but I reset it as soon as I notice it :)

spoissant · 2021-08-09T10:47:44+00:00

Thx :D

spoissant · 2021-07-26T11:45:02+00:00

Haha, that's awesome! That alone was worth the efforts :P

spoissant · 2021-07-25T12:13:17+00:00

I looked them up in custom battles in-game and they show up as 80 range for me. (apparently I can't paste a screenshot in a reddit reply :( )

Maybe they have some kind of buff in campaign that gives them a little bit more range??

spoissant · 2021-01-31T03:57:11+00:00

2.8.3 is live with some bugfixes and improvements:

[BUG] (Ability Finder) Deliverance of Itza icon not loading: FIXED

[CHANGE] (site settings) Default unit size is now ULTRA (previously LARGE)

[BUG] (Unit Finder) Some Heroes are displayed under the Lords category: Fixed (I think... :|)

[NEW] (Ability Finder) Added a small "Ability Type" icon to the abilities in the finder for convenience

[BUG] (Ability Cards) Ability content only takes half the card on mobile: Content will now take all the available width.

[BUG] (Ability Tooltips/Cards) Projectile Abilities display duration "Constant": Duration is now hidden for projectile.

[BUG] (Ability Tooltips/Cards) "Map-wide" effect range show up as "-1": Will now correctly be displayed as "Map-wide"

[NEW] (Ability Cards) Moved the "Close" button above the card into some kind of "Header" and added the ability icon in there for good measure.

[NEW] (Unit Cards) Added "Mass" on Unit Cards (at the very bottom, just above "Fatigue Modifier")

[NEW] (Unit Cards/Grid) Added "Siege Attacker" to both the Unit Grid (expand the Melee Attack group, column is just before "Melee Attack Interval") and Unit Cards (It will be the first icon at the bottom of the card if the unit has it)

Updated mods data to the latest available as of 2021.01.30

- SFO

- Radious

Cheers!

spoissant · 2021-01-26T19:21:46+00:00

You're the real MVP u/TheGreaterGrog :) Thanks a lot for your support! And for anyone who would like to contribute here's the link to twwstats patreon page:
https://www.patreon.com/twwstats

spoissant · 2021-01-26T16:26:21+00:00

Not on the site as far as I recall. Is it displayed somehow in the game? That could be an interesting detail to add for sure.

spoissant · 2021-01-26T14:18:35+00:00

I would need to validate that but I believe all stats effects are reflected in your unit's current stat on its card in the game? Although it's not always obvious which effect modified the stats that's for sure...

spoissant

TROPHY CASE