Danbooru

[Feature Idea] User Promotion Report Update

Posted under General

tapnek said:

Also, is it feasible to have a Ruby interpretation of what BrokenEagle did to get those stats and incorporate it into the Danbooru website since it runs on Ruby?

That's the idea, although I don't know Ruby that well myself to give a good opinion on how hard/easy it would be. The above is just an interim thing until/unless a server-side Danbooru report ever gets implemented.

So if I'm interpreting this correctly, the promotion lists are meant to encourage people to do more of whatever they're doing so they get a promotion? I suppose that could work, though I suspect most people who are heading for a promotion will continue to do whatever they're doing and get said promotion, while those who aren't even close won't care enough to check the lists. If it encourages a little more positive activity, though, then no harm in implementing it. It may always serve as a way of curating information on board member stats, of course.

Regarding
9. The top N tags added or removed can be calculated per user as well. Is that something that should be shown, and if so, what should N be?

It would have to be at least 20 if it's to give any useful information, I reckon, as many people would probably be able to guess their top few (eg. my top added would probably include greyscale, solo, solo focus, quaver, comic, neck ribbon, red ribbon, ribbon, multiple views...)

These reports have existed for years actually, they're on a page called the mod dashboard. I think its limited to mods because of performance reasons. It's configurable with options like how far back to count changes and what levels of users to include.

It's missing pool changes and artist commentary changes though. Probably not hard to add but performance should be tested.

Toks said:

These reports have existed for years actually, they're on a page called the mod dashboard. I think its limited to mods because of performance reasons. It's configurable with options like how far back to count changes and what levels of users to include.

Could a report that is only updated like once a week (or month) be made available to regular users?

BrokenEagle98 said:

Could a report that is only updated like once a week (or month) be made available to regular users?

Exactly my thoughts, since users who are good translators can better evaluate the work of users below Builder rank and give report to moderators if they should get promoted or give feedback, poitive, neutral or negative.
And a larger amount of users who can see that is always better if the performance can keep up^^.

BrokenEagle98 said:

Could a report that is only updated like once a week (or month) be made available to regular users?

Yes, even if updated daily, it shouldn't be much of a strain on the server. It wouldn't be configurable though, dates would have to be fixed.

Awesome, that sounds great! Before starting anything server-side though, I'd like for us to spend a few cycles in spiral development going over the look and feel like we have been, so that the Danbooru coders can tailor what you have to what we want, as long as it's not too difficult to implement.

I'll be throwing up some new versions of the reports based upon the feedback received so far later this afternoon/evening...

Provence said:

For the remaining categories, I've no clear opinion, so maybe calling the top users on each list here, so that they can give a good benchmark if they approve of this. And as I said: The mark should be different for every category.
[...]
Artist Changes: @RaisingK @tapnek

tapnek said:

I just do a lot of artist changes because I find myself uploading art from a lot of new artists and finding new information on artists frequently. Having good Google-fu helps. As for a benchmark, I'm the wrong guy to ask for that.

A lot of my edits are automated, so I'm even worse for judging benchmarks.

Update Ver 2.0

Contrast and compare with forum #118371 and forum #118382

First off, you'll note the addition of two new categories: forum posts and comments. Forum posts gives an indicator on those very active on the forums, either answering questions, asking questions, or otherwise helping with the running of Danbooru. Comments gives us an indicator of those very active at participating in the more social aspects of this site, an important aspect IMO.

Second, I changed the cutoffs, but I purposefully left some of them low to give a good idea on what different cutoffs would do to the size of the tables. The cutoffs are: {pool:25, note:200, artist_commentary:25, artist:25, wiki_page:25, post:500, comment:100, forum_post:25}

Third, I combined both tables into one table for each category. I highlight the Platinum- users by italicizing their names.

Fourth, I didn't highlight it last time, but the hyperlinks in the first column lead to each user's page.

Fifth, I added hyperlinks to the second column, which lead to the search pages for each user/category combination.

Note: Some of the data changed for the Post Changes table (forum #118371). I was unfortunately working with incomplete data for the prior showing. The current table in this post contains the complete data.

Data

Post Changes
Note Changes
Commentary Changes
Artist Changes
Pool Changes
Wiki Changes
Forum Posts
Comments

Final Thoughts

Take a good look at the overall presentation of the tables. Also compare the size for each category. Please comment if you have any ideas to make it look better or be more useful. Any feedback will help the Danbooru coders out for when the server version gets implemented. Thanks.

I'd call that useful data, or at least more so than a plain-Jane uploads report.

I didn't realize some of the people on there were quite that active, although Paracite does a lot of translations.... And it shows.

Great work @BrokenEagle98. Looks exactly how I wanted it to look when I created this topic.
Now thev last thing is to implement this and let it actualize itself for every month^^.
And since it should be easy to access, this Reports should be shown somewhere. Like I said, that bar would be good if it is possible to edit.

Update Ver 3.1

Contrast and compare with Ver 1.0 (forum #118371 and forum #118382) and Ver 2.0 (forum #118420)

Added a lot more data to each of the categories with versions (i.e. not comments or forum posts). Also adjusted some of the cutoff levels for some of the categories.

Certain stats are similar between all version categories.

  • Total: The total number of versions created by each user.
  • Create/Upload: The total number of new instances by each user.
  • Other: The total number of versions created with no changes, e.g. pools do not track description changes.

Besides the above, each category has unique stats for the various kinds of edits. Multiple types of edits can exist for a single single version change, e.g. adding and removing tags on a single edit. So basically, sum(edit events) != sizeofunion(edit events).

Also worth noting, Create events, Other events and union(edit events) are mutually exclusive. Therefore, to figure out the size of union(edit events), aka Post/Pool/Note/etc. Editing, subtract the Create and Other events from the Total events.

Example:
Post Edits = Total Post Changes (third column) - Upload/Creates (fourth column) - Other Changes (last column)

Below the tables are the implementation details client-side using psuedocode to help out the Danbooru coders. There's probably an easier way to do things server-side, but it's being included just in case.

Data

Post Changes - Updated at Sat Aug 20 02:29:17Z 2016
RankUsernameTotalUploadsAddsRemovesParentRatingSourceOther
1Hillside_Moose386312738559814702212
2Provence37988139436460461619110
3Nitrogen09146404611411515122600
4RaisingK904572849316891782014
5kuuderes_shadow868234796492601028
6zeparoh606470542611264021011
7EB52971555131205143603
8BrokenEagle98421718334516400304
9Type-kun25613225269060000
10henmere21734921141907231101
11Sacriven210713657084741710
12OOZ66221041109610231300
13Zettamorose208252514855005202
14Insanity_Demon19916193211003013
15NWF_Renim164215201348000169
16mock1572108145732401570
17gary2556613741259110160202
18bad_mongo1293711206271102
19Dinglecockles1178511192280011
20Vid-szhite116614310081390504
21Benit14911042188781160004
22Kikimaru1076255773171171224
23Yawn_Sven10520105280000
24BlindSargent10514505901193502
25Blue_Trident962383467203202
26D'Eye94719452600970
27Doragonn9397401874201102
28CharleyDodger899132763403001
29Manatsu-92892338588420000
30Jarlath885665205470301
31tapnek86857827914701002
32Lannihan790628154262000
33zaregoto755611124420515
34keonas733501231490400
35bunkhead72701715900003
36Rignak70965748260100
37dereyoruk70160495130000
38Shallie640534103350800
39Randeel6153452111191400
40nanami58348089320103
41reiyasona5761566680007
42Rastamepas567196366240001
43Blue_Stuff5563132211154301
44CyberWire5500544840300
45Fenen542331168720100
46Qpax54046767280000
47CodeKyuubi5252632551453201
48RiderFan5181489730013
49Unbreakable5170501650001

Note: Cutoff was 500 Total Post changes

Note Changes - Updated at Sat Aug 20 19:20:11Z 2016
RankUsernameTotalCreatesBody EditsMovesResizesDeletesUndeletesOther
1Paracite272021515351991871904
2Stan_Miller151614832370600
3Moonspeaker135910143274657400
4hatachinatachi124112083012101
5yunashiku114910527236381712
6OMGkillitwithfire1118109225117100
7Nassan0357136961100600
8Izkael7096951400000
9Vid-szhite5665193586900
10Nil8r93446441411000
11BrokenEagle984343963412211
12Nagumo4153991542000
13Evangeline_A.K._McDowell380376401000
14RaisingK3803660221101
15Elf_song378374400000
16akiored357290472828700
17Bansho3324249246276100
18CGrascal327323300100
19Rice_223211971223111100
20Tetrominon31427242128000
21JuanValdezJr297292513000
22enneuni295293200000
23_dk2692581100000
24kittey265698236243001

Note: Cutoff was 250 Total Note changes

Artist Commentary Changes - Updated at Sat Aug 20 21:21:37Z 2016
RankUsernameTotalCreatesOrig TitleOrig DescrTrans TitleTrans DescrOther
1Sacriven1155115302220
2dereyoruk33833800000
3Jarlath32332300000
4andalus29529400100
5Moonspeaker145913310311310
6RaisingK13463126540
7Kikimaru13312903320
8Vid-szhite123320064742
9Sythini956702625260
10Brightlight914921125192
11BlindSargent848300100
12Stun-99818100000
13Krugger807901000
14Hoppo747003320
15windmaker190606000000
16albert595900000
17Timmaine535000330
18henmere52172714240
19BrokenEagle9852143725219
20Stan_Miller5135551272

Note: Cutoff was 50 Total Artist Commentary changes

Pool Changes - Updated at Sat Aug 20 03:58:55Z 2016
RankUsernameTotalCreatesAddsRemovesOrdersOther
1Jarlath17931672914
2Claverhouse1010101000
3Stan_Miller93191001
4Sythini85280703
5andalus74074010
6BrokenEagle9866749155
7Stratfield54054000
8Zettamorose48046002
9Provence47442600
10DGKelly46143101
11Tsuki_no_Sakura46045200
12Lannihan43439000
13Hoppo40235602

Note: Cutoff was 40 Total Pool changes

Artist Changes - Updated at Sat Aug 20 20:09:03Z 2016
RankUsernameTotalCreatesNameOther NamesURLGroupDeletesUndeletesOther
1RaisingK98115009660000
2henmere566116166357435129103
3tapnek129771030492000
4chodorov1062409822000
5Kikimaru10257719423000
6Cristianlush93880050000
7Type-kun910901901001
8Zettamorose895018390000
9Nitrogen09743715293510000
10Shallie67570193000
11keonas674137250000
12Qpax41330472000
13andalus411903212001

Note: Cutoff was 40 Total Artist changes

Wiki Page Changes - Updated at Sat Aug 20 20:41:21Z 2016
RankUsernameTotalCreatesTitleOther NamesBody EditsOther
1henmere509249561082250
2Zettamorose8536112400
3Benit1498445113350
4keonas63482990
5zeparoh55520300
6bad_mongo523423150
7EB493311160
8Sausageroll39260850
9Kikimaru392218110
10Fenen38607310
11CharleyDodger371504190
12BlindSargent376010240
13Chucu28170480
14Blue_Trident27104240

Note: Cutoff was 25 Total Wiki Page changes

Forum Posts Created - Updated at Fri Aug 19 21:26:18Z 2016
Comments Created - Updated at Fri Aug 19 21:59:43Z 2016

Implementation Details

Show

Posts

  • Total: total versions/user
  • Uploads: (length of unchanged_tags == 0) and (length of added_tags > 0)
  • Tag adds: (length of unchanged_tags > 0) and (length of added_tags > 0) and (count of rating/source/parent metatags) < (count of added_tags)
  • Tag removes: (length of unchanged_tags > 0) and (length of removed_tags > 0) and (count of rating/source/parent metatags) < (count of removed_tags)
  • Rating: ("rating:" in added_tags) and ("rating:" in removed_tags)
  • Parent: ("parent:" in added_tags) or ("parent:" in removed_tags)
  • Source: ("source:" in added_tags) or ("source:" in removed_tags)
  • Other: (length of added_tags == 0) and (length of removed_tags == 0)
    • could also be done by checking if none of the conditions above are true

Pools

  • Total: total versions/user
  • Creates: no prior version
  • Order: remove all posts not in intersection(priorver,currver); compare order
  • Adds: currver has posts not in intersection(priorver,currver)
  • Removes: priorver has posts not in intersection(priorver,currver)
  • Other: currver == priorver
    • could also be done by checking if none of the conditions above are true

Notes

  • Total: total versions/user
  • Creates: no prior version
  • Edits: body changed
  • Moves: x,y changes
  • Resizes: width,height changes
  • Deletes: isactive "True" -> "False"
  • Undeletes: isactive "True" -> "False"
  • Other: no changes, i.e. none of the conditions above are true

Commentary

  • Total: total versions/user
  • Creates: no prior version
  • Orig Title: Original Title changed
  • Orig Descr: Original Body changed
  • Trans Title: Translated Title changed
  • Trans Descr: Translated Body changed
  • Other: no changes, i.e. none of the conditions above are true

Artist

  • Total: total versions/user
  • Creates: no prior version
  • Name: name changed
  • Other Name: other names changed
  • Url: url string changed
  • Group: group name changed
  • Deletes: isactive "True" -> "False"
  • Undeletes: isactive "True" -> "False"
  • Other: no changes, i.e. none of the conditions above are true

Wiki Page

  • Total: total versions/user
  • Creates: no prior version
  • Title: title changed
  • Other Name: other names changed
  • Body Edits: body changed
  • Other: no changes, i.e. none of the conditions above are true

Final Thoughts

Like before, any comments on the look or feel of the tables above will be helpful. This includes column order, column name, table order, cutoff values, italicising vs underlining, columns to add (if possible) or remove, etc...

Edit:

3.0->3.1: Changed usage of italics for Platinum- group to underlines. (ref forum #118448)

Updated

1 2 3