Fixed All/Paid/Free pagination issue

[Luxus]

I have noticed that the pagination of the resource manager always takes 'All' add-ons into account.
Go to the resource manager, and scroll down. You will see 71 pages. Go to page 71. All good.

Now make the resource manager display only paid add-ons by clicking at the 'paid' tab. Scroll down and you will see again 71 pages. Go to page 71. Nothing there. Go to page 70. Nothing there. Go to page 69. Nothing there. And so on.

The same applies to all 'free' add-ons as well.

 

[Jon W]

I wonder if this worked before this bug was fixed:
http://xenforo.com/community/thread...f-lots-of-deleted-unapproved-resources.47118/

 

[erich37]

why not just use Prefixes and sort "Paid / Free" via Prefixes ?

 

[Jon W]

Resources don't have prefixes.

This problem is that a cached count is used instead of actually using an extra query to count resources. But only the full count is cached and there is no cached count of the number of paid or free resources. So, either a new cache will need to be added, a new query will need to be added if paid or free is selected, or we have to accept that this is "as designed" and that there will be blank pages if we select paid or free.

 

[Mike]

So, either a new cache will need to be added, a new query will need to be added if paid or free is selected, or we have to accept that this is "as designed" and that there will be blank pages if we select paid or free.

Blue makes sense, but would be too big of a scope for 1.0.
Red is what will happen in the short term.

 

[Mike]

Fixed now.