Like Ra's Naughty Forum

Like Ra's Naughty Forum > Technical section > News > Positive digital karma
Full Version: Positive digital karma
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2

Like Ra

04 Jan 2023, 20:58
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) )

[Image: attachment.php?aid=61511]

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

04 Jan 2023, 20:58
(04 Jan 2023, 20:10 )Anne Wrote: [ -> ]I'm most happy with is my thanks per post ratio
Oh, yeah, and here's this thanks/posts ratio stats.

(19 Mar 2020, 23:15 )Like Ra Wrote: [ -> ]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:

usernamepostnumthanksthanks/postnumratio
@Like Ra22964101190.44067023.9312
@madjack402648831.21292206.6403
@Culmor376329990.79701668.9200
@ltxrob12265890.4804397.8590
@Tinker D26184480.1711382.5388
@TightSlip6535480.8392297.9550
@"RedEmeraldKitsune"4407401.6818275.9322
@Anne4196721.6038258.0825
@essanym6743360.4985224.2218
@Strappado10152360.2325191.4788
@Vacbedbound3064381.4314180.1452
@madboyevil3193371.0564163.8765
@Bound Whore2293901.7031144.2811
@bondagetom13152610.8286142.7344
@helpless851764392.4943125.6325
@vanessa_fetish3011970.6545119.0703
@mysecretpantyhose1942711.3969113.0624
@Cattani2331840.7897102.8106
@latexballet1792351.3128101.6063
@Lancer3231480.4582101.4947
@no smile3351430.4269100.2197
@Zooy3211370.426896.0197
@Vixien6621110.167795.0608
@FagMan1762031.153494.2691
@krinlyc3891140.293188.1630
@spiraltone421931550.803185.9626
@bimboandrea251621450.895176.5147
@jessilongstocking1102232.027373.6637
@Ellie1841160.630471.1467
@Will90MeeG2041060.519669.7548

Like Ra

01 Jan 2024, 20:14
Top 20 thanks/postnum and thanks*postnum/(thanks +postnum) ratios

UsernamePostnumthanksthanks/postnumRatio
@Like Ra25257123000.48708271.7230
@madjack427856851.32892441.0750
@Culmor389232690.83991776.6999
@Tinker D27934970.1779421.9213
@ltxrob12686290.4961420.4386
@PurpleVibes5318151.5348321.5193
@Anne4918341.6986309.0521
@TightSlip6535660.8668303.1977
@essanym7003630.5186239.0405
@Bound Whore3045541.8224196.2890
@Strappado10152410.2374194.7572
@Vacbedbound3094601.4887184.8375
@madboyevil3193471.0878166.2057
@bondagetom13483070.8822163.1084
@helpless851895252.7778138.9706
@vanessa_fetish3442260.6570136.3930
@Zooy3761820.4840122.6380
@Cattani2562140.8359116.5617
@Lancer3721680.4516115.7333
@mysecretpantyhose1942781.4330114.2627

Like Ra

02 Jan 2024, 15:00
Let's praise more users! Here's another interesting statistics: thanks_given*hours_on_the_forum/(thanks_given + hours_on_the_forum):

Usernamethanks givenhours onlineratio
@Like Ra672144395.54895837.29712917
@madjack31441473.17331003.13690339
@Vixien2241578.8672460.03635731
@essanym7641114.9575453.35114285
@Tinker D512832.2689316.99139557
@krinlyc3981211.2053299.56383266
@ltxrob919368.5300263.04557564
@PurpleVibes919278.1142213.50254327
@kvp7206782293.5119213.41124266
@Culmor2551240.0208211.50562283
@GuidoG392417.3306202.13443896
@Anne272444.0494168.67752615
@no smile538232.0150162.10602391
@bondagetom13180165.9111157.68420493
@TightSlip466197.8442138.88106019
@FagMan189476.7681135.34617912
@laris069300241.7269133.86464173
@Kit-Katt445186.7992131.56970372
@sabrina1970482180.7633131.46159765
@MstrChain183447.4406129.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

02 Jan 2024, 15:22
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

OrderUsernameKarma
1@Like Ra11200.67949823
2@madjack2943.20712300
3@Culmor1882.66160254
4@Tinker D580.41721616
5@ltxrob552.18102900
6@essanym465.71602298
7@PurpleVibes428.42610460
8@Anne393.39083855
9@TightSlip372.63823313
10@Vixien333.39964676
11@bondagetom1241.95049941
12@krinlyc241.76635213
13@Bound Whore235.09170878
14@Vacbedbound222.35107694
15@Strappado202.85840650
16@vanessa_fetish194.00200239
17@no smile189.29392974
18@madboyevil189.10282179
19@Zooy180.21090468
20@helpless85167.92627655
21@FagMan165.46043133
22@Lancer157.20892998
23@Cattani154.72053340
24@mysecretpantyhose146.85480985
25@spiraltone42139.94464033
26@Will90MeeG134.65995623
27@latexballet116.67943354
28@Kit-Katt111.60303368
29@bimboandrea25111.02884546
30@MIWSTIUS104.45452696
31@GuidoG103.56721948
32@"Oldself"98.63443698
33@christianna98.38977013
34@JackWong2596.46867808
35@jessilongstocking95.76870828
36@Ellie95.67304860
37@shinybambi92.18183128
38@Hazel90.15205737
39@herrpee88.92026984
40@Lycalopex88.4169523

Vixien

02 Jan 2024, 18:38
Need to say that I am surprised with my "score".

Like Ra

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

(02 Jan 2024, 15:22 )Like Ra Wrote: [ -> ](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

04 Jan 2024, 18:31
(04 Jan 2024, 09:23 )Like Ra Wrote: [ -> ]This one should work better:

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


[Image: attachment.php?aid=61511]

And here's the result:

OrderUsernamePostNumReceived_ThanksGiven_ThanksAttachmentsTime_OnlineKarma
1@Like Ra252991233667372378944403.6433242.57576442359303
2@madjack428557093153101761475.3750136.9289479400483
3@Culmor3899328625617481243.3700104.94829911804922
4@Tinker D2794499512148832.373663.14668077615332
5@ltxrob1270630924187368.667252.0433653291179
6@PurpleVibes5348179271022278.776750.30568181977151
7@Anne494840272280445.326948.25381609227802
8@TightSlip6535694661169197.844246.39709613859854
9@helpless85189525732222280.180042.70194010015905
10@essanym7003637641991114.957541.26046014560721
11@Bound Whore305556108579274.565040.00631864767995
12@Strappado101524117248345.374239.58662957224988
13@Vacbedbound30946084441702.408937.104767674490404
14@madboyevil319347138128868.538136.84965557616119
15@Vixien711121224317579.533134.46042047484865
16@bondagetom1348307318044165.911132.432115294360536
17@mysecretpantyhose19427891413229.772529.763099603069147
18@vanessa_fetish34422626563204.558629.486816165666326
19@Zooy37818213449819.529428.492708793012905
20@krinlyc394120398931211.253928.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

04 Jan 2024, 21:31
Added first post for explanations.

Like Ra

04 Jan 2024, 23:52
See the changes during one day:

OrderUsernamePostnumReceived_ThanksGiven_ThanksAttachmentsTime_OnlineKarma
1@Like Ra253021233867382379044404.6650242.59150291739917
2@madjack428557153153101761475.3750136.97275927704916
3@Culmor3899329025617481243.8717104.98644101748172
4@Tinker D2794499512148832.373663.14668077615332
5@ltxrob1270630924187368.667252.0433653291179
6@PurpleVibes5348189271022278.776750.3255563640591
7@Anne495844272280445.610848.34719400753881
8@TightSlip6535694661169197.844246.39709613859854
9@helpless85189525732222280.180042.70194010015905
10@essanym7003637641991114.957541.26046014560721
11@Bound Whore305556108579274.607540.00633981125493
12@Strappado101524117248345.374239.58662957224988
13@Vacbedbound30946084441702.408937.104767674490404
14@madboyevil319347138128868.538136.84965557616119
15@Vixien711121224317579.641134.460915499999665
16@bondagetom1348307318044165.911132.432115294360536
17@mysecretpantyhose19427891413229.772529.763099603069147
18@vanessa_fetish34422626563204.558629.486816165666326
19@Zooy37818213449820.077528.492803705195968
20@krinlyc394120398931211.253928.40833333855983

Pages: 1 2
Like Ra's Naughty Forum > Technical section > News > Positive digital karma