Click to open network menu
Join or Log In
Mobafire logo

Join the leading League of Legends community. Create and share Champion Guides and Builds.

Create an MFN Account


's Forum Avatar

MobaFire Guides - Removing 'Stale' guides off...

Creator: Ex Vi July 30, 2012 4:29pm
1 2
Matt's Forum Avatar
Show more awards
Dec 8th, 2009
Permalink | Quote | PM | +Rep August 1, 2012 12:27am | Report
Just wanted expand on what PsiGuard said and fill in a few blanks on exactly how this works. We have a patch database in the back-end. Whenever the game gets a new patch, we add it to the database along with the exact release date. These release dates are what we use to determine freshness.

Ideal is within the last 2 patches, Fresh is within the last 4 patches, Stale is within the last 6 patches, 7 or more patches old is expired. As PsiGuard said, this does not mean 6 months, or 6 weeks, it means 6 patches, whatever time span that might be.

So when running a query for a list of guides, if we want to exclude expired guides, I look up the release date of the 6th most recent patch and filter out guides that were not updated since that date - they are the expired guides.

This used to require manual updates directly in the database, it fell behind a few times over the last year as a result. We recently (few weeks ago) built a tool that all Veterans now have access to, so that we can do a better job of keeping the patch database up-to-the-minute.

So, if you find the release date of the 6th most recent patch, and spot a non-expired guide that has also not been updated since that patch, let me know. This is either a bug, or the patch database has not been updated yet, or the patch database was just updated and the caches haven't cleared yet. Right now with the current state of the patch database, that would be 2012-04-18.
Ex Vi
Ex Vi's Forum Avatar
Show more awards
Nov 3rd, 2011
Permalink | Quote | PM | +Rep August 6, 2012 2:47am | Report
Hello Matt.

Thank you for the in-depth explanation. It is now completely clear to me. I will look out for non-expired guides then, and inform you about it once I noticed one. (If I ever notice one). Thanks again,

Ex Vi.
Did you appreciate my help?, please +Rep me <3
Any questions for me ?, please PM me
1 2

You need to log in before commenting.

League of Legends Champions:

Teamfight Tactics Guide