[Feature Idea] User Promotion Report Update

@BrokenEagle98: For the next report version roll-out, I was...

2016-08-22T11:14:14-04:00

For the next report version roll-out, I was planning on starting a new thread, just so that the latest version can always be the first post so that it isn't buried in the thread. I'll use this thread to archive any older versions from the new thread.

@user_460797: Well, if rejected ones are not visible, then...

2016-08-22T03:02:54-04:00

Well, if rejected ones are not visible, then that is fine. Because our admins will only then receive a boost in their post changes when they accept a request. So then it is only fine to show only the succesful requests.

@BrokenEagle98: > Provence said: > > Ugh, this came out of...

2016-08-21T13:27:21-04:00

Provence said:

Ugh, this came out of nowhere, but since we already add our Admins in who have such a high post change count due to their approval, I think we also should create a report of users who are requesting these BURs
Like: User 1 made 5 requests of which 5 were accepted.

Already done with that report. I'm waiting on a few things before I post it. Just FYI, there is no way to display the same amount of information for the plain singular Tag Alias or Tag Implication requests. This is because once one of those gets rejected, they are removed completely from visibility. I've already made a note of it in topic #9127/p130. I can still count the approved and pending, but not the rejected ones.

Provence said:

Also: Is is possible to implement who uploaded the most images in the last month?

It's already in the table data. Check out the post changes table (forum #118437). It's just ordered by total post changes, rather than uploads. Unfortunately, DText doesn't allow column orderings to be changed...

@user_460797: Ugh, this came out of nowhere, but since we...

2016-08-21T01:35:38-04:00

Ugh, this came out of nowhere, but since we already add our Admins in who have such a high post change count due to their approval, I think we also should create a report of users who are requesting these BURs
Like: User 1 made 5 requests of which 5 were accepted.

And about the thing with flags: Since this whole idea should help users, I don't think it will help to create such report. Simply because no user is mentioned.
That's why a moderator or better an admin should say something about that report.

Also: Is is possible to implement who uploaded the most images in the last month?

@user_460797: > BrokenEagle98 said: > > The usernames for...

2016-08-20T23:32:41-04:00

BrokenEagle98 said:

The usernames for Appeals are visible to regular users. Anyways, if nothing else, I can compute general statistics for flags and appeals.

Example:

240 total flags for the entire site last month

67% were successful

120 total appeals for the entire site last month

24% were successful

Unbelievable :o.
Well, then the question is why the appeal counter isn't shown on the user's statistics then.
http://danbooru.me/users/23799 I can't see yours^^.
http://danbooru.me/users/460797 Or mine account. I have two appeals.

@BrokenEagle98: > Provence said: > > So it would be possible. ...

2016-08-20T23:30:03-04:00

Provence said:

So it would be possible.
But I guess about that we need a moderator since flags and appeals are not visible to regular users below mod status.

The usernames for Appeals are visible to regular users. Anyways, if nothing else, I can compute general statistics for flags and appeals.

Example:

240 total flags for the entire site last month

67% were successful

120 total appeals for the entire site last month

24% were successful

@user_460797: > BrokenEagle98 said: > > Sure, I hadn't...

2016-08-20T23:20:15-04:00

BrokenEagle98 said:

Sure, I hadn't thought about those objects. I'll tackle those tomorrow and post something up hopefully by early afternoon.

So it would be possible.
But I guess about that we need a moderator since flags and appeals are not visible to regular users below mod status.

@BrokenEagle98: Sure, I hadn't thought about those objects....

2016-08-20T23:18:29-04:00

Sure, I hadn't thought about those objects. I'll tackle those tomorrow and post something up hopefully by early afternoon.

@user_460797: One last thing...forgot it every time. Is it...

2016-08-20T22:59:10-04:00

One last thing...forgot it every time.
Is it possible to create a flag report? since flags and appeals are not visible, I don't think this will come through, but how about a report that says this:
User 1: Flagged posts in 1 month: 40; Success rate: 60%
User 2: Flagged posts in 1 month: 12; Success Rate 12%

Same thing with appeals.

@BrokenEagle98: Thanks for the feedback. I've made the...

2016-08-20T22:38:44-04:00

Thanks for the feedback. I've made the recommended changes from italics to underlines. (forum #118437)

@user_460797: > BrokenEagle98 said: > > We've already gotten...

2016-08-20T22:02:06-04:00

BrokenEagle98 said:

We've already gotten the attention of one of the coders, Type-kun. If you feel like the last version I posted is good enough, a feature request can be submitted on GitHub. However, I'm of the opinion to wait a while, let's say a week, to chew on the format of the report like we have been doing. Next weekend, I'll submit the feature request if nobody else has done it. This will also include your ideas for modifying the top title bar.

Great. And yeah, I think this is great from the structure, but instead of making the name cursive, I would underline them. This is better to distinguish Builders from Non-Builders. Well, at least it helps me more^^. Doesnt't matter which group, but they should be visually different^^.
And since you have done those statistics, I think you should go ahead and post it there^^.

@BrokenEagle98: We've already gotten the attention of one of...

2016-08-20T21:53:54-04:00

We've already gotten the attention of one of the coders, Type-kun. If you feel like the last version I posted is good enough, a feature request can be submitted on GitHub. However, I'm of the opinion to wait a while, let's say a week, to chew on the format of the report like we have been doing. Next weekend, I'll submit the feature request if nobody else has done it. This will also include your ideas for modifying the top title bar.

@user_460797: So we are using this topic now for these...

2016-08-20T20:36:50-04:00

So we are using this topic now for these reports and don't add them to that bar above?

@BrokenEagle98: Heh, it was tiring, but fun! ^__^ I enjoy...

2016-08-20T20:27:54-04:00

Heh, it was tiring, but fun! ^__^

I enjoy tackling coding challenges...

@Kikimaru: @BrokenEagle98 Very nice work!

2016-08-20T20:23:34-04:00

@BrokenEagle98
Very nice work!

@BrokenEagle98: Update Ver 3.1> Contrast and compare with Ver...

2016-08-20T17:31:53-04:00

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

Rank	Username	Total	Uploads	Adds	Removes	Parent	Rating	Source	Other
1	Hillside_Moose	38631	27	38559	8147	0	2	2	12
2	Provence	37988	1394	36460	461	6	19	1	10
3	Nitrogen09	14640	461	14115	151	2	26	0	0
4	RaisingK	9045	72	8493	1689	178	20	1	4
5	kuuderes_shadow	8682	34	7964	926	0	1	0	28
6	zeparoh	6064	705	4261	1264	0	21	0	11
7	EB	5297	155	5131	205	14	36	0	3
8	BrokenEagle98	4217	183	3451	640	0	3	0	4
9	Type-kun	2561	32	2526	906	0	0	0	0
10	henmere	2173	49	2114	1907	23	11	0	1
11	Sacriven	2107	1365	708	474	1	7	1	0
12	OOZ662	2104	1	1096	1023	1	3	0	0
13	Zettamorose	2082	525	1485	500	5	2	0	2
14	Insanity_Demon	1991	6	1932	110	0	3	0	13
15	NWF_Renim	1642	1	520	1348	0	0	0	169
16	mock	1572	108	1457	324	0	15	7	0
17	gary25566	1374	1259	110	16	0	2	0	2
18	bad_mongo	1293	71	1206	27	1	1	0	2
19	Dinglecockles	1178	5	1119	228	0	0	1	1
20	Vid-szhite	1166	143	1008	139	0	5	0	4
21	Benit149	1104	218	878	116	0	0	0	4
22	Kikimaru	1076	255	773	171	17	12	2	4
23	Yawn_Sven	1052	0	1052	8	0	0	0	0
24	BlindSargent	1051	450	590	119	3	5	0	2
25	Blue_Trident	962	38	346	720	3	2	0	2
26	D'Eye	947	1	945	260	0	9	7	0
27	Doragonn	939	740	187	42	0	11	0	2
28	CharleyDodger	899	132	763	40	3	0	0	1
29	Manatsu-92	892	33	858	842	0	0	0	0
30	Jarlath	885	665	205	47	0	3	0	1
31	tapnek	868	578	279	147	0	10	0	2
32	Lannihan	790	628	154	26	2	0	0	0
33	zaregoto	755	611	124	42	0	5	1	5
34	keonas	733	501	231	49	0	4	0	0
35	bunkhead	727	0	171	590	0	0	0	3
36	Rignak	709	657	48	26	0	1	0	0
37	dereyoruk	701	604	95	13	0	0	0	0
38	Shallie	640	534	103	35	0	8	0	0
39	Randeel	615	345	211	119	1	4	0	0
40	nanami	583	480	89	32	0	1	0	3
41	reiyasona	576	1	566	68	0	0	0	7
42	Rastamepas	567	196	366	24	0	0	0	1
43	Blue_Stuff	556	313	221	115	4	3	0	1
44	CyberWire	550	0	544	84	0	3	0	0
45	Fenen	542	331	168	72	0	1	0	0
46	Qpax	540	467	67	28	0	0	0	0
47	CodeKyuubi	525	263	255	145	3	2	0	1
48	RiderFan	518	1	489	73	0	0	1	3
49	Unbreakable	517	0	501	65	0	0	0	1

Note: Cutoff was 500 Total Post changes

Note Changes - Updated at Sat Aug 20 19:20:11Z 2016

Rank	Username	Total	Creates	Body Edits	Moves	Resizes	Deletes	Undeletes	Other
1	Paracite	2720	2151	535	199	187	19	0	4
2	Stan_Miller	1516	1483	23	7	0	6	0	0
3	Moonspeaker	1359	1014	327	46	57	4	0	0
4	hatachinatachi	1241	1208	30	1	2	1	0	1
5	yunashiku	1149	1052	72	36	38	17	1	2
6	OMGkillitwithfire	1118	1092	25	11	7	1	0	0
7	Nassan035	713	696	11	0	0	6	0	0
8	Izkael	709	695	14	0	0	0	0	0
9	Vid-szhite	566	519	35	8	6	9	0	0
10	Nil8r93	446	441	4	1	1	0	0	0
11	BrokenEagle98	434	396	34	1	2	2	1	1
12	Nagumo	415	399	15	4	2	0	0	0
13	Evangeline_A.K._McDowell	380	376	4	0	1	0	0	0
14	RaisingK	380	366	0	2	2	11	0	1
15	Elf_song	378	374	4	0	0	0	0	0
16	akiored	357	290	47	28	28	7	0	0
17	Bansho	332	42	49	246	276	1	0	0
18	CGrascal	327	323	3	0	0	1	0	0
19	Rice_22	321	197	122	31	11	1	0	0
20	Tetrominon	314	272	42	12	8	0	0	0
21	JuanValdezJr	297	292	5	1	3	0	0	0
22	enneuni	295	293	2	0	0	0	0	0
23	_dk	269	258	11	0	0	0	0	0
24	kittey	265	6	98	236	243	0	0	1

Note: Cutoff was 250 Total Note changes

Artist Commentary Changes - Updated at Sat Aug 20 21:21:37Z 2016

Rank	Username	Total	Creates	Orig Title	Orig Descr	Trans Title	Trans Descr	Other
1	Sacriven	1155	1153	0	2	2	2	0
2	dereyoruk	338	338	0	0	0	0	0
3	Jarlath	323	323	0	0	0	0	0
4	andalus	295	294	0	0	1	0	0
5	Moonspeaker	145	9	1	33	103	113	10
6	RaisingK	134	6	3	126	5	4	0
7	Kikimaru	133	129	0	3	3	2	0
8	Vid-szhite	123	32	0	0	64	74	2
9	Sythini	95	67	0	26	25	26	0
10	Brightlight	91	49	2	11	25	19	2
11	BlindSargent	84	83	0	0	1	0	0
12	Stun-99	81	81	0	0	0	0	0
13	Krugger	80	79	0	1	0	0	0
14	Hoppo	74	70	0	3	3	2	0
15	windmaker190	60	60	0	0	0	0	0
16	albert	59	59	0	0	0	0	0
17	Timmaine	53	50	0	0	3	3	0
18	henmere	52	17	2	7	14	24	0
19	BrokenEagle98	52	14	3	7	25	21	9
20	Stan_Miller	51	35	5	5	12	7	2

Note: Cutoff was 50 Total Artist Commentary changes

Pool Changes - Updated at Sat Aug 20 03:58:55Z 2016

Rank	Username	Total	Creates	Adds	Removes	Orders	Other
1	Jarlath	179	3	167	29	1	4
2	Claverhouse	101	0	101	0	0	0
3	Stan_Miller	93	1	91	0	0	1
4	Sythini	85	2	80	7	0	3
5	andalus	74	0	74	0	1	0
6	BrokenEagle98	66	7	49	1	5	5
7	Stratfield	54	0	54	0	0	0
8	Zettamorose	48	0	46	0	0	2
9	Provence	47	4	42	6	0	0
10	DGKelly	46	1	43	1	0	1
11	Tsuki_no_Sakura	46	0	45	2	0	0
12	Lannihan	43	4	39	0	0	0
13	Hoppo	40	2	35	6	0	2

Note: Cutoff was 40 Total Pool changes

Artist Changes - Updated at Sat Aug 20 20:09:03Z 2016

Rank	Username	Total	Creates	Name	Other Names	URL	Group	Deletes	Other
1	RaisingK	981	15	0	0	966	0	0	0
2	henmere	566	116	166	357	435	129	1	3
3	tapnek	129	77	10	30	49	2	0	0
4	chodorov	106	24	0	9	82	2	0	0
5	Kikimaru	102	57	7	19	42	3	0	0
6	Cristianlush	93	88	0	0	5	0	0	0
7	Type-kun	91	0	90	1	90	1	0	1
8	Zettamorose	89	50	1	8	39	0	0	0
9	Nitrogen09	74	37	15	29	35	10	0	0
10	Shallie	67	57	0	1	9	3	0	0
11	keonas	67	41	3	7	25	0	0	0
12	Qpax	41	33	0	4	7	2	0	0
13	andalus	41	19	0	3	21	2	0	1

Note: Cutoff was 40 Total Artist changes

Wiki Page Changes - Updated at Sat Aug 20 20:41:21Z 2016

Rank	Username	Total	Creates	Title	Other Names	Body Edits
1	henmere	509	249	56	108	225
2	Zettamorose	85	36	1	12	40
3	Benit149	84	45	1	13	35
4	keonas	63	48	2	9	9
5	zeparoh	55	52	0	3	0
6	bad_mongo	52	34	2	3	15
7	EB	49	33	1	11	6
8	Sausageroll	39	26	0	8	5
9	Kikimaru	39	22	1	8	11
10	Fenen	38	6	0	7	31
11	CharleyDodger	37	15	0	4	19
12	BlindSargent	37	6	0	10	24
13	Chucu	28	17	0	4	8
14	Blue_Trident	27	1	0	4	24

Note: Cutoff was 25 Total Wiki Page changes

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

Rank	Username	Changes
1	Provence	129
2	tapnek	66
3	BrokenEagle98	66
4	Sacriven	45
5	Hillside_Moose	44
6	chodorov	40
7	reiyasona	33
8	Jarlath	28
9	Kikimaru	26
10	kuuderes_shadow	25

Note: Cutoff was 25 Total Forum Posts

Comments Created - Updated at Fri Aug 19 21:59:43Z 2016

Rank	Username	Changes
1	Jarlath	357
2	OMGkillitwithfire	220
3	Provence	210
4	T34/38	171
5	ithekro	157
6	Krugger	148
7	NegativeSoul	145
8	RaisingK	142
9	79248cm/s	126
10	OOZ662	120
11	bunkhead	109
12	laisy	108
13	Koucchan	107
14	Demundo	104
15	aceofspudz	101
16	zgryphon	101

Note: Cutoff was 100 Total Comments

Implementation Details

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)

@CodeKyuubi: All these people doing something useful, and...

2016-08-20T04:44:25-04:00

All these people doing something useful, and here I am only uploading images.

The only reason I'm on the post changes list is because of my uploads, since I rarely add tags to others' posts >.>

@BrokenEagle98: > Kikimaru said: > > There are only 13 people...

2016-08-19T22:39:15-04:00

Kikimaru said:

There are only 13 people actively editing wikis?

25 edits was the cutoff, but if you check forum #118382, you'll see that there were at least 180 users that edited the wiki at least once.

@Jarlath: > Kikimaru said: > > There are only 13 people...

2016-08-19T19:30:30-04:00

Kikimaru said:

There are only 13 people actively editing wikis?

In the last few months, anyways. I haven't had to fix one in a bit.

@Kikimaru: There are only 13 people actively editing wikis?

2016-08-19T19:24:26-04:00

There are only 13 people actively editing wikis?