13 replies to this topic

[SickBoy]

The script that runs nightly to re-rank items (as well as store the previous value so that we can show rank "movement") has been changed to be a bit more consistent, sensical, and, in terms of what would be considered a popular WoW-V item, more accurate in its ordering.

The previous script simply ordered by the total points, from highest to lowest. The new script orders by:


1. Total points (highest to lowest)
This gives total points (from votes and badges) the top priority. Since this is the same as before, the items in the top positions haven't changed much.

2. Then by ((plus votes + total badges) - downvotes) (highest to lowest)
This gives items with more overall plus votes and badges the next priority. This begins what the remaining two priorities finish in terms of "fine tuning" the ranks.

3. Then by (total votes + total badges) (highest to lowest)
This gives items with the most overall votes and badges the next priority, a kind of "who has had the most activity" indication.

4. Then by date (oldest to newest)
This gives older items the final priority (they were there first, after all), assuming ALL the other priorities are the exact same.


This should stop some of the drastic movement of items that have a common amount of points (such as none). Decent older items should remain in the same general spot now, except when new items actually get more points, plus votes, or badges than them (giving a proper indication that the item is considered "better").

Sounds confusing, even to me when I re-read it, but the overall theme here is: stuff should make more sense in regards to rank movement and rank placement, and that rank is going to be much more important, in preparation for the v4 release.


Tonight's script has been run twice: once without badges being taken into consideration, which I decided against after considering it, and once with the proper script as described above. This means the "movement" (the red/green up and down arrows + numbers) of ranks won't be accurate until tomorrow night's cycle.

[SickBoy]

This change, expressed in pseudo SQL would be:

ORDER BY total_points DESC, ((plus_votes + badges_blizz + badges_fun + badges_humor + badges_unique) - down_votes) DESC, (plus_votes + down_votes + badges_blizz + badges_fun + badges_humor + badges_unique) DESC, date ASC

Unfortunately, for v3 users, this means browsing and ordering by total points on an item may cause the ranks to skip around (since it's more than points that impacts rank now).

For v4 users, this change has been implemented in the Browse page, and the link on the author profile has been adjusted, but there are still a few features that will need to be changed later on. Those features impact v3, so for now I won't be adjusting them.

[Watchy]

Very nice admin... you just made it perfect thumbs up!

[Thetruecrow]

Quote

Very nice admin... you just made it perfect thumbs up!

Admin is Owner and has a name, Its something along the lines of Mother fuckin Sickboy.

[SickBoy]

Quote

Quote

Very nice admin... you just made it perfect thumbs up!

Admin is Owner and has a name, Its something along the lines of Mother fuckin Sickboy.

Was that really necessary? Calling me an admin is perfectly valid. Granted my role is very different from other admins (since I'm the only developer and designer), but it's close enough. I understand what you're trying to say, and I appreciate it, but it comes off as being overly harsh towards other members.

[Nightbane]

Quote

Quote

Quote

Very nice admin... you just made it perfect thumbs up!

Admin is Owner and has a name, Its something along the lines of Mother fuckin Sickboy.

Was that really necessary? Calling me an admin is perfectly valid. Granted my role is very different from other admins (since I'm the only developer and designer), but it's close enough. I understand what you're trying to say, and I appreciate it, but it comes off as being overly harsh towards other members.

Doesn't Shadowclaimer sort of.. parttake the developer role in some way? (Retrieving alot of the icons, etc?)

Or is that just called SickBoy's bitch? Woah, I somehow switched my screen to the right instead of the left, the fuck?

[SickBoy]

That's not development, it's data extraction. Yes, it's a very important role, but it isn't the same.

[BlackBoy0]

God... DAMN these electric sex updates

[Död]

Quote

God... DAMN these electric sex updates

I c what u did thar, but I dun get 50% of it.

[Eldrak]

Not loving it. It just made way more sense before, now it just seems like things are being over-complicated >.<

[Nightbane]

Quote

Not loving it. It just made way more sense before, now it just seems like things are being over-complicated >.<

Yeah.. I liked the simple way

[SickBoy]

No, things are being made more *fair*. The only time this changes ANYTHING about the old ranking system is when items have the same amount of points. In the old version, those items had no rhyme or reason for the order they were put in.

The new version lets those items be sorted intelligently so that they can be fairly ranked, instead of just arbitrarily shoved into one of the slots items with the same amount of points inhabit.

It's more complicated, yes, but with good reason.

[Eldrak]

OH, so this only effects items with the same amount of points?

Ok, now I'm liking it.

[SickBoy]

Did you guys even read the post? It explained all this pretty thoroughly...