Viewing a response to: @abh12345/6fhokz-the-curation-and-engagement-leagues-steem-prizes-and-steem-bounty-available
Ok, so I've got to figure out what I changed this week, that sent me down on the list. I thought that I increased my number of comments, comment length etc. but went down. I'm thinking probably reply rate, more comments but the number of replies to the comments was down. I guess Friday is too late in the week to start commenting. lol
| post_id | 61,425,822 |
|---|---|
| author | coinsandchains |
| permlink | re-abh12345-6fhokz-the-curation-and-engagement-leagues-steem-prizes-and-steem-bounty-available-20180903t033310132z |
| category | engagement |
| json_metadata | {"tags":["engagement"],"app":"steemit\/0.1"} |
| created | 2018-09-03 03:33:12 |
| last_update | 2018-09-03 03:33:12 |
| depth | 1 |
| children | 7 |
| net_rshares | 24,875,245,607 |
| last_payout | 2018-09-10 03:33:12 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.022 SBD |
| curator_payout_value | 0.007 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 339 |
| author_reputation | 3,066,667,330,713 |
| root_title | "The Curation and Engagement Leagues 🏆 - STEEM prizes & steem-bounty available! 🎁" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| abh12345 | 0 | 24,875,245,607 | 4% |
I had to take some points off for the folks that this week I spotted using fast reply and partiko. This message is over 200 characters long:  My only method this week was to work out the length of the additional text that partiko, ulogs, fast reply add to the message, and multiply that by the number of messages. None of this took place last week. This is going to be very troublesome for me, especially as people switch around and use multiple access points. I hope that helps.
| post_id | 61,427,038 |
|---|---|
| author | abh12345 |
| permlink | re-coinsandchains-re-abh12345-6fhokz-the-curation-and-engagement-leagues-steem-prizes-and-steem-bounty-available-20180903t035421543z |
| category | engagement |
| json_metadata | {"tags":["engagement"],"image":["https:\/\/cdn.steemitimages.com\/DQmdmoVRW87Rrn3JnjgjK5W8mZb23KsabKxS3Um6taCq1b4\/IMG_0423.PNG"],"app":"steemit\/0.1"} |
| created | 2018-09-03 03:54:24 |
| last_update | 2018-09-03 03:54:24 |
| depth | 2 |
| children | 6 |
| net_rshares | 0 |
| last_payout | 2018-09-10 03:54:24 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 SBD |
| curator_payout_value | 0.000 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 595 |
| author_reputation | 590,352,098,179,351 |
| root_title | "The Curation and Engagement Leagues 🏆 - STEEM prizes & steem-bounty available! 🎁" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
lol, you would pick that message... I guess the emojis take up Quite a few characters too. I probably used fast-reply for 80% of my replies, it stops working once the replies get to 10 deep. That could be problematic, depending on the scripts you are using. I'm just starting to poke around on the dev and data side, but I think I saw that an app was recorded with the comments. (I'm just guessing SQL based and on the field names as well...) ~~~ SUM( CASE WHEN app = 'fast-reply' THEN char_count = CHAR_LENGTH(comment_text)- 150 WHEN app = 'partiko' THEN char_count = CHAR_LENGTH(comment_text)- 100 ELSE char_count = CHAR_LENGTH(comment_text) END ) ~~~ It might take a bit to get setup capturing the char count for each tag. It looks like it counts the markdown for the link in character count as well... It would probably work faster as part of a subquery in the from statement. The emoji's might be another issue altogether, they are at least 10 char each but would depend on what encoding the system is using. You might could count occurrences of either U+ or &# and multiply that by 10 and subtract it from the total. Sorry, decided to let the nerd come out a bit, I rather enjoy complex problems like that.
| post_id | 61,432,472 |
|---|---|
| author | coinsandchains |
| permlink | re-abh12345-re-coinsandchains-re-abh12345-6fhokz-the-curation-and-engagement-leagues-steem-prizes-and-steem-bounty-available-20180903t053744844z |
| category | engagement |
| json_metadata | {"app":"steemit\/0.1","tags":["engagement"]} |
| created | 2018-09-03 05:37:48 |
| last_update | 2018-09-03 05:37:48 |
| depth | 3 |
| children | 5 |
| net_rshares | 28,428,852,122 |
| last_payout | 2018-09-10 05:37:48 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.026 SBD |
| curator_payout_value | 0.008 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 1,238 |
| author_reputation | 3,066,667,330,713 |
| root_title | "The Curation and Engagement Leagues 🏆 - STEEM prizes & steem-bounty available! 🎁" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| abh12345 | 0 | 28,428,852,122 | 4% |
Thanks :D Yes this will have to come into play programmatically next week. Oh the joys! arcange and his database are unlikely to appreciate the extra load here, but I do need to make things as fair as possible. More work, boo hoo!
| post_id | 61,436,619 |
|---|---|
| author | abh12345 |
| permlink | re-coinsandchains-re-abh12345-re-coinsandchains-re-abh12345-6fhokz-the-curation-and-engagement-leagues-steem-prizes-and-steem-bounty-available-20180903t065125511z |
| category | engagement |
| json_metadata | {"tags":["engagement"],"app":"steemit\/0.1"} |
| created | 2018-09-03 06:51:24 |
| last_update | 2018-09-03 06:51:24 |
| depth | 4 |
| children | 4 |
| net_rshares | 0 |
| last_payout | 2018-09-10 06:51:24 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 SBD |
| curator_payout_value | 0.000 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 234 |
| author_reputation | 590,352,098,179,351 |
| root_title | "The Curation and Engagement Leagues 🏆 - STEEM prizes & steem-bounty available! 🎁" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |