MTA Community "bug"?

[12p]

Well, see, MTA, I've uploaded THIS resource long time ago. It has 4.2 as rating, and has exactly 10 votes. Why it doesn't is between the first 20 resources? It has better rating than "kwktotaldestruction" (4.1).

[dzek (varez)]

i voted "5" and it's now 4.3 and visible on best 10.

probably somebody set query like that:

SELECT * FROM resources WHERE [b]votes>10[/b] ORDER BY avg DESC LIMIT 10 

but it should be

SELECT * FROM resources WHERE [b]votes>=10[/b] ORDER BY avg DESC LIMIT 10 

community have some more bugs.. probably somebody is still working on it.. (i think)..

ps. the query is generally incorrect, as votes are (should be) saved in separate table, so the real query is much more different. just wanted to point out the "bug"

[12p]

Ok, thanks, varez.

[Blokker_1999]

nobody is working on the current community. A major rewrite is in the works. I'm hosting it but i don't dare to touch it.

[dzek (varez)]

i can rewrite the community (will take about 2 weeks) - you can give me sources + db dump + files already uploaded (so users and files will stay untouched) and ill take care of it. also you can list all features needed. layout will stay unchanged as im not graphic designer but programmer.