Flag Rewards Dev Post - SFR Ranks - Top 20 Flaggers - Dynamic Discord Updates and RShare Tracking
As part of work on the SteemFlagRewards database, reward shares were gatherered and all database rows have been updated. Believe me it wasn't an easy feat. What was the reason you may ask?
Those blasted follow on flags!
A follow on flag is when an SFR user flags a post after another SFR user has already commented. It's an optional feature and, if the user has their own meaningful comment to add, by all means, comment at the top level so the user caught up in abuse may see it more readily.
Otherwise, the user may add a follow on flag mention as a reply to the original flagger mention or SFR bot reply if they don't plan on adding any additional substance to their comment ie a simple "follow on flag for spam @steemflagrewards." comment.
The challenge was knowing the post to query for downvotes on each follow on flag because it varies. The general rule of thumb is for users to reply to the SFR bot. In that case, I know exactly where to look. The parent to the parent to the parent comment.
Yes, it can be confusing as sometimes the flags end up another level up. For example, we had one follow flag that I noticed was a reply to a reply of the SFR bot. That means I needed to query the parent of the parent of the parent of the parent. If I'm not mistaken, it was the great great grandparent comment that had the flag. I had to create a "one off" query to update.
MFW I'm trying to figure this all out.
After a number of passes, I finally managed to update ALL rows with flag_rshares data. Now, we're cooking with fire 🔥!
>>> sql = cursor.execute('SELECT count(*) FROM steemflagrewards WHERE flag_rshares IS NULL')
>>> for q in sql.fetchall():
... q
...
(0,)
The above query was used to determine there were no rows without flag_rshares.
I realized with this data. We can do a lot of cool things such as...
Have you ever wondered the total current dollar amount of all SFR flags?
Well, here it is!
With the rshare data, I was able to perform a query to get the total count of flags and the sum. Using Beem, we could then get the SBD amount. I expected more but we did start out small afterall. We will be able to up this number in no time!
Note, this obviously does not include pre-database flags, prior to @flugschwein's update, that our bot has approved and upvoted. In other words, we've done more than the above number would indidcate.
Now, without further ado...
I present to you the Top 20 Steem Flag Rewards Leaderboard!
| Downvoter | Total Flags | sbd_amount | Rank | Image |
|---|---|---|---|---|
| @themarkymark | 1159 | 123.7261678 | F10 1 Quad |  |
| @mids106 | 224 | 92.23802169 | F10 1 Quad |  |
| @slobberchops | 510 | 54.90603446 | F10 1 Quad | |
| @steevc | 295 | 17.20588206 | F8 10 Tril |  |
| @ipromote | 189 | 15.21638773 | F8 10 Tril |  |
| @admiralbot | 650 | 12.08253117 | F8 10 Tril | |
| @kalif | 250 | 11.85104474 | F8 10 Tril | |
| @enforcer48 | 492 | 8.616002872 | F8 10 Tril | |
| @rabbitbot | 334 | 7.159122054 | F8 10 Tril | |
| @freebornangel | 242 | 6.810231887 | F8 10 Tril | |
| @noblebot | 633 | 6.545799485 | F8 10 Tril | |
| @badcontent | 374 | 5.675132055 | F8 10 Tril | |
| @revisesociology | 38 | 4.627696777 | F7 1 Tril |  |
| @steemseph | 402 | 4.618156624 | F7 1 Tril |  |
| @anthonyadavisii | 197 | 4.601233771 | F7 1 Tril | |
| @zaku | 25 | 4.569293829 | F7 1 Tril | |
| @lovenfreedom | 206 | 3.927161313 | F7 1 Tril | |
| @crokkon | 103 | 3.666082461 | F7 1 Tril | |
| @jacobtothe | 71 | 3.494709893 | F7 1 Tril | |
| @bestofph | 277 | 3.36920761 | F7 1 Tril | |
Congratulations to @themarkymark for being the top flagger! Shout out to @mids106 and @slobberchops for 2nd and 3rd place, respectively. Kudos to all!
Click the below image to see the commit on the Github Repo for the flag leaderboard code..
In addition to these advancements, it was recommended we try and add a dynamic channel description for #general on our discord and, with a bit of help from @mids106, we were able to get it done.
Click the image below to see the commit on Github. Note, that the general channel ID should be added to the config and will do so on the next update among a number of things recommended by @themarkymark. Improvements are continuous as I said before.
This whole things has been an catalyst for my professional growth. I am thankful for the opportunity to serve and sharpen the ol' sword so to speak. I've seen it written that iron sharpens iron. I've learned by personal experience that it is true. ⚔️ 😉
I also got the database table ready for the healing functionality I discussed in my last report. The next step will be populating said table with all @steemflagrewards / @sfr-mod-fund comments and posts.
The SFR flag mentions are easy as they are already stored. We may want to give thought to protecting user main posts and comments. Either way, we are getting closer to the goal.
My Social Media Links
Also, I guess I should start doing that dropping links in my post thing so I can pretend to be one of those "social media influencer" types.
Twitter
Imgur
IG
YouTube
Minds
Trybe
On a serious note, appreciate any that help support me on these other platforms so we can work together to promote Steem!
Related Project Promotion
Would you like to delegate to the Steem Flag Rewards project and promote decentralized moderation? It's much more fashionable than self-voting. Here are some handy delegation links!
SmartMeme
Don't forget to follow @smartmeme for OG meme curation and Kekistani Cleanup Meme Rank Results! As time permits, the meme ranks will be a thing!
If you want to earn the prestigous content cop rank, stay tuned for updates.
SFR Moderator Fund
@sfr-mod-fund is the account used to rewards our Discord mods for reviewing and approving blockchain flags daily which supports the fighting of abuse. Follow the fanbase on SteemAuto to support the mission automagically!
Hi Anthony,
Thanks for another great update on SteemFlagRewards.
Creating fighter leagues is one way of positive reinforcement for the anti-abuse community. You have mentioned "gamification" of fighting abuse on previous posts and this is the realization of it. It took considerable effort and I want to congratulate you for pushing through.
Flagging is really not a lucrative business. It's a risky business with no financial return. The only consolation is the opportunity to encourage a healthier platform.
I hope this new feature encourages our fellow Steemians in joining anti-abuse efforts. Seeing statistics of our efforts is a constant reminder that the $396-worth of flags are nothing compared to the thousands already gained through abuse.
Note that I didn't count the text on your contribution starting from the social media part. :) I hope you understand.
Kudos to everyone! Go flag more abuse!
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Chat with us on Discord.
[utopian-moderator]
Thank you for your review, @lovenfreedom! Keep up the good work!
ǝɹǝɥ sɐʍ ɹoʇɐɹnƆ pɐW ǝɥ┴
“Penny Fighter 402” is my middle name.
Posted using Partiko iOS
Not 420?
Oh you’re too kind. I’m flattered.
Posted using Partiko iOS
Once my vote power recovers a bit more, I'll get back to trying to climb those rankings!
Hi, @anthonyadavisii!
You just got a 11.8% upvote from SteemPlus!
To get higher upvotes, earn more SteemPlus Points (SPP). On your Steemit wallet, check your SPP balance and click on "How to earn SPP?" to find out all the ways to earn.
If you're not using SteemPlus yet, please check our last posts in here to see the many ways in which SteemPlus can improve your Steem experience on Steemit and Busy.
Hi @anthonyadavisii!
Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your UA account score is currently 4.643 which ranks you at #1674 across all Steem accounts.
Your rank has not changed in the last three days.
In our last Algorithmic Curation Round, consisting of 209 contributions, your post is ranked at #14.
Evaluation of your UA score:
Feel free to join our @steem-ua Discord server
Hey, @anthonyadavisii!
Thanks for contributing on Utopian.
Congratulations! Your contribution was Staff Picked to receive a maximum vote for the anti-abuse category on Utopian for being of significant value to the project and the open source community.
We’re already looking forward to your next contribution!
Get higher incentives and support Utopian.io!
Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via SteemPlus or Steeditor).
Want to chat? Join us on Discord https://discord.gg/h52nFrV.
Vote for Utopian Witness!
Congratulations @anthonyadavisii! You have completed the following achievement on the Steem blockchain and have been rewarded with new badge(s) :
Click here to view your Board
If you no longer want to receive notifications, reply to this comment with the word
STOP