Positive digital karma

[Like Ra]

We need encouragement, appreciation, gratitude, acknowledgement, rewards. Some need competition. Hence the idea of the positive karma, which can only decrease if posts, thanks or attachments are deleted. In all other cases it always becomes more positive. So far, we have the following statistics:

- amount of posts
- amount of attachments
- amount of received "thanks"
- amount of given "thanks"
- time, spent online on the forum

Generally, we want all these to increase. The current formula is:

sqrt(postnum + 2 * received_thanks + 1/4 * attachments + 1/2 * (timeonline * given_thanks)/(timeonline + given_thanks) )



The square root here is to add non-linearity to resrict the grow.
The weights are to shift the priorities:
- One "thanked once" posts gives sqrt(3) times more points than one "unthanked" post.
- Spread across several poss attachments will bring more, than all in one (good for page loading time)
- "Karma" increases even if you do not post, but simply read, watch and "thank"
- Removing own posts (especally with "thanks") and attachments decreases the "karma"

There is no user-visible implementation yet  - it's only a concept.

Any ideas?

[Like Ra]

I'm most happy with is my thanks per post ratio

Oh, yeah, and here's this thanks/posts ratio stats.

However, the amount of posts is not accounted for, only the ratio. This one should look better:

Code:

SELECT username, postnum, tyl_unumrcvtyls, tyl_unumrcvtyls/postnum, (postnum*tyl_unumrcvtyls)/(tyl_unumrcvtyls+postnum) AS ratio
FROM mybb_users
ORDER by ratio DESC
LIMIT 20

Result:

username	postnum	thanks	thanks/postnum	ratio
@Like Ra	22964	10119	0.4406	7023.9312
@madjack	4026	4883	1.2129	2206.6403
@Culmor	3763	2999	0.7970	1668.9200
@ltxrob	1226	589	0.4804	397.8590
@Tinker D	2618	448	0.1711	382.5388
@TightSlip	653	548	0.8392	297.9550
@"RedEmeraldKitsune"	440	740	1.6818	275.9322
@Anne	419	672	1.6038	258.0825
@essanym	674	336	0.4985	224.2218
@Strappado	1015	236	0.2325	191.4788
@Vacbedbound	306	438	1.4314	180.1452
@madboyevil	319	337	1.0564	163.8765
@Bound Whore	229	390	1.7031	144.2811
@bondagetom1	315	261	0.8286	142.7344
@helpless85	176	439	2.4943	125.6325
@vanessa_fetish	301	197	0.6545	119.0703
@mysecretpantyhose	194	271	1.3969	113.0624
@Cattani	233	184	0.7897	102.8106
@latexballet	179	235	1.3128	101.6063
@Lancer	323	148	0.4582	101.4947
@no smile	335	143	0.4269	100.2197
@Zooy	321	137	0.4268	96.0197
@Vixien	662	111	0.1677	95.0608
@FagMan	176	203	1.1534	94.2691
@krinlyc	389	114	0.2931	88.1630
@spiraltone42	193	155	0.8031	85.9626
@bimboandrea25	162	145	0.8951	76.5147
@jessilongstocking	110	223	2.0273	73.6637
@Ellie	184	116	0.6304	71.1467
@Will90MeeG	204	106	0.5196	69.7548

[Like Ra]

Top 20 thanks/postnum and thanks*postnum/(thanks +postnum) ratios

Username	Postnum	thanks	thanks/postnum	Ratio
@Like Ra	25257	12300	0.4870	8271.7230
@madjack	4278	5685	1.3289	2441.0750
@Culmor	3892	3269	0.8399	1776.6999
@Tinker D	2793	497	0.1779	421.9213
@ltxrob	1268	629	0.4961	420.4386
@PurpleVibes	531	815	1.5348	321.5193
@Anne	491	834	1.6986	309.0521
@TightSlip	653	566	0.8668	303.1977
@essanym	700	363	0.5186	239.0405
@Bound Whore	304	554	1.8224	196.2890
@Strappado	1015	241	0.2374	194.7572
@Vacbedbound	309	460	1.4887	184.8375
@madboyevil	319	347	1.0878	166.2057
@bondagetom1	348	307	0.8822	163.1084
@helpless85	189	525	2.7778	138.9706
@vanessa_fetish	344	226	0.6570	136.3930
@Zooy	376	182	0.4840	122.6380
@Cattani	256	214	0.8359	116.5617
@Lancer	372	168	0.4516	115.7333
@mysecretpantyhose	194	278	1.4330	114.2627

[Like Ra]

Let's praise more users! Here's another interesting statistics: thanks_given*hours_on_the_forum/(thanks_given + hours_on_the_forum):

Username	thanks given	hours online	ratio
@Like Ra	6721	44395.5489	5837.29712917
@madjack	3144	1473.1733	1003.13690339
@Vixien	2241	578.8672	460.03635731
@essanym	764	1114.9575	453.35114285
@Tinker D	512	832.2689	316.99139557
@krinlyc	398	1211.2053	299.56383266
@ltxrob	919	368.5300	263.04557564
@PurpleVibes	919	278.1142	213.50254327
@kvp7206	782	293.5119	213.41124266
@Culmor	255	1240.0208	211.50562283
@GuidoG	392	417.3306	202.13443896
@Anne	272	444.0494	168.67752615
@no smile	538	232.0150	162.10602391
@bondagetom1	3180	165.9111	157.68420493
@TightSlip	466	197.8442	138.88106019
@FagMan	189	476.7681	135.34617912
@laris069	300	241.7269	133.86464173
@Kit-Katt	445	186.7992	131.56970372
@sabrina1970	482	180.7633	131.46159765
@MstrChain	183	447.4406	129.88000367

The idea behind it (yes, another step towards the positive digital karma) is the more time you spend on the forum the better for the community, and the more time you spend here, the more opportunity to thank the posters, even if no posts are made.

[Like Ra]

And now, if we sum up both https://www.likera.com/forum/mybb/Thread...5#pid71375 and https://www.likera.com/forum/mybb/Thread...2#pid71352, apply the factor 1/2 to the first, we get the first iteration of the forum digital karma:

(postnum * received_thanks)/(postnum + received_thanks) + 1/2 * (timeonline * given_thanks)/(timeonline + given_thanks)

Code:

SELECT ROW_NUMBER() OVER (), username, (postnum*tyl_unumrcvtyls)/(tyl_unumrcvtyls+postnum) + (tyl_unumtyls*timeonline/7200)/(tyl_unumtyls+timeonline/3600) AS karma
FROM mybb_users
ORDER by karma DESC
LIMIT 40

Order	Username	Karma
1	@Like Ra	11200.67949823
2	@madjack	2943.20712300
3	@Culmor	1882.66160254
4	@Tinker D	580.41721616
5	@ltxrob	552.18102900
6	@essanym	465.71602298
7	@PurpleVibes	428.42610460
8	@Anne	393.39083855
9	@TightSlip	372.63823313
10	@Vixien	333.39964676
11	@bondagetom1	241.95049941
12	@krinlyc	241.76635213
13	@Bound Whore	235.09170878
14	@Vacbedbound	222.35107694
15	@Strappado	202.85840650
16	@vanessa_fetish	194.00200239
17	@no smile	189.29392974
18	@madboyevil	189.10282179
19	@Zooy	180.21090468
20	@helpless85	167.92627655
21	@FagMan	165.46043133
22	@Lancer	157.20892998
23	@Cattani	154.72053340
24	@mysecretpantyhose	146.85480985
25	@spiraltone42	139.94464033
26	@Will90MeeG	134.65995623
27	@latexballet	116.67943354
28	@Kit-Katt	111.60303368
29	@bimboandrea25	111.02884546
30	@MIWSTIUS	104.45452696
31	@GuidoG	103.56721948
32	@Oldself	98.63443698
33	@christianna	98.38977013
34	@JackWong25	96.46867808
35	@jessilongstocking	95.76870828
36	@Ellie	95.67304860
37	@shinybambi	92.18183128
38	@Hazel	90.15205737
39	@herrpee	88.92026984
40	@Lycalopex	88.4169523

[Vixien]

Need to say that I am surprised with my "score".

[Like Ra]

This one does not work, because the first part will be zeroed out if there are no thanks:

(postnum * received_thanks)/(postnum + received_thanks) + 1/2 * (timeonline * given_thanks)/(timeonline + given_thanks)

This one should work better:

sqrt(postnum + 2 * received_thanks + 1/4 * attachments + 1/2 * (timeonline * given_thanks)/(timeonline + given_thanks) )

[Like Ra]

This one should work better:

sqrt(postnum + 2 * received_thanks + 1/4 * attachments + 1/2 * (timeonline * given_thanks)/(timeonline + given_thanks) )

And here's the result:

Order	Username	PostNum	Received_Thanks	Given_Thanks	Attachments	Time_Online	Karma
1	@Like Ra	25299	12336	6737	23789	44403.6433	242.57576442359303
2	@madjack	4285	5709	3153	10176	1475.3750	136.9289479400483
3	@Culmor	3899	3286	256	1748	1243.3700	104.94829911804922
4	@Tinker D	2794	499	512	148	832.3736	63.14668077615332
5	@ltxrob	1270	630	924	187	368.6672	52.0433653291179
6	@PurpleVibes	534	817	927	1022	278.7767	50.30568181977151
7	@Anne	494	840	272	280	445.3269	48.25381609227802
8	@TightSlip	653	569	466	1169	197.8442	46.39709613859854
9	@helpless85	189	525	73	2222	280.1800	42.70194010015905
10	@essanym	700	363	764	199	1114.9575	41.26046014560721
11	@Bound Whore	305	556	108	579	274.5650	40.00631864767995
12	@Strappado	1015	241	17	248	345.3742	39.58662957224988
13	@Vacbedbound	309	460	84	441	702.4089	37.104767674490404
14	@madboyevil	319	347	138	1288	68.5381	36.84965557616119
15	@Vixien	711	121	2243	17	579.5331	34.46042047484865
16	@bondagetom1	348	307	3180	44	165.9111	32.432115294360536
17	@mysecretpantyhose	194	278	91	413	229.7725	29.763099603069147
18	@vanessa_fetish	344	226	265	63	204.5586	29.486816165666326
19	@Zooy	378	182	134	49	819.5294	28.492708793012905
20	@krinlyc	394	120	398	93	1211.2539	28.40833333855983

Code:

WITH t AS (
SELECT u.username, u.postnum, u.tyl_unumrcvtyls, u.tyl_unumtyls, u.timeonline, COUNT(a.uid) AS cnt
FROM mybb_attachments AS a
JOIN mybb_users AS u
ON u.uid = a.uid
GROUP BY a.uid)
SELECT ROW_NUMBER() OVER (), t.username, t.postnum, t.tyl_unumrcvtyls, t.tyl_unumtyls, t.cnt, t.timeonline/3600, sqrt(t.postnum + 2* t.tyl_unumrcvtyls + t.cnt/4 + (t.tyl_unumtyls*t.timeonline/7200)/(t.tyl_unumtyls+t.timeonline/3600)) AS karma
FROM t
ORDER by karma DESC
LIMIT 20

ChatGPT chokes on more data..

What do you think? What about the weights?

[Like Ra]

Added first post for explanations.

[Like Ra]

See the changes during one day:

Order	Username	Postnum	Received_Thanks	Given_Thanks	Attachments	Time_Online	Karma
1	@Like Ra	25302	12338	6738	23790	44404.6650	242.59150291739917
2	@madjack	4285	5715	3153	10176	1475.3750	136.97275927704916
3	@Culmor	3899	3290	256	1748	1243.8717	104.98644101748172
4	@Tinker D	2794	499	512	148	832.3736	63.14668077615332
5	@ltxrob	1270	630	924	187	368.6672	52.0433653291179
6	@PurpleVibes	534	818	927	1022	278.7767	50.3255563640591
7	@Anne	495	844	272	280	445.6108	48.34719400753881
8	@TightSlip	653	569	466	1169	197.8442	46.39709613859854
9	@helpless85	189	525	73	2222	280.1800	42.70194010015905
10	@essanym	700	363	764	199	1114.9575	41.26046014560721
11	@Bound Whore	305	556	108	579	274.6075	40.00633981125493
12	@Strappado	1015	241	17	248	345.3742	39.58662957224988
13	@Vacbedbound	309	460	84	441	702.4089	37.104767674490404
14	@madboyevil	319	347	138	1288	68.5381	36.84965557616119
15	@Vixien	711	121	2243	17	579.6411	34.460915499999665
16	@bondagetom1	348	307	3180	44	165.9111	32.432115294360536
17	@mysecretpantyhose	194	278	91	413	229.7725	29.763099603069147
18	@vanessa_fetish	344	226	265	63	204.5586	29.486816165666326
19	@Zooy	378	182	134	49	820.0775	28.492803705195968
20	@krinlyc	394	120	398	93	1211.2539	28.40833333855983