Steem "Downvote" Explorer

in #steem3 years ago (edited)



Visit https://flags.dpoll.xyz to see it live

Backstory


HF21 increased the overall downvote ratio in the network. However, we don't have the right tools to track the downvotes. Originally, @transisto asked a similar interface and I thought it should be considerably easy with Hivemind.

Even though Hivemind doesn't store the negative rshares in a straight forward column in the posts table, there is something we can use for ordering: flag_weight

# take negative rshares, divide by 2, truncate 10 digits (plus neg sign),
#   and count digits. creates a cheap log10, stake-based flag weight.
#   result: 1 = approx $400 of downvoting stake; 2 = $4,000; etc
#  flag_weight = max((len(str(neg_rshares / 2)) - 11, 0))

Seems like it's used by Condenser in the past but it also lets you order the posts by negative rshares in an indirect way.

So a simple query like this:

"SELECT * FROM hive_posts_cache WHERE is_paidout=False and total_votes != up_votes and created_at > now() - interval '1 week' ORDER BY flag_weight DESC LIMIT 500;")

gets the all active posts, and orders by its flag weight and limits the result set to 500 rows. From that point, it's possible to traverse the "votes" field of the post table (CSV string) and calculate the rshares for each post.

Anyways, let me know if the interface is helpful in any way. I'll open source it once I settle things up. It's basically a single page Flask-app built in two hours, atm. Feel free to shoot in the comments for potential feature ideas. (Result set is limited to 500 rows to keep the page generation time fast.)

Sort:  

Hi @emrebeyler,

Thank you for thinking about making this software open-source.

I have been waiting for the right software so that I could create @downvote.xyz on Downvote.xyz.

My original idea was to make an inverse of Steemit in some ways, or at least a downvote trail to combat spam and bidbots.

If you like the name 'Downvote XYZ' meaning to downvote 'something' we can work together on it, but if you aren't interested in helping me, I can still set you as a beneficiary based on your open-source contributions.


P.S. The big task I'll be doing this month is setting up a Steem-based DAPP for the Philippines on Steem.ph, @nathansenn already agreed to develop it for us 😀

You got a 13.58% upvote from @minnowvotes courtesy of @steemium!

This post has been included in the latest edition of The Steem News - a compilation of the key news stories on the Steem blockchain.

Actually this is depressing!

lol, kidding it is quite informative.

Just dont type your username to the search bar, then it becomes less depressing :)

add the option "-username" in the search bar, so it will be excluded.
Happy brwosing!
:)
!BEER

View or trade BEER at steem-engine.



Hey @emrebeyler, here is a bit BEER for you. Enjoy it!

It's good work. I am glad you made it.

A !BEER helps when you get downvoted hard

Posted using Partiko Android

!BEER

Hmm.. Not sure..

No !BEER Explorer?

View or trade BEER at steem-engine.



Hey @emrebeyler, here is a bit BEER for you. Enjoy it!

29.75$ has been spent to promote this content using Steemium thanks to @transisto
Learn more here!

Thank you! 🙏🏻

I was looking for something like that. 👍

This post has received a 100.0 % upvote from @boomerang.

Let's try downvote party !BEER again

Posted using Partiko Android

Command accepted!

We didn't party hard enough!
!BEER

Command accepted!

View or trade BEER at steem-engine.



Hey @bluerobo, here is a bit BEER for you. Enjoy it!

View or trade BEER at steem-engine.



Hey @emrebeyler, here is a bit BEER for you. Enjoy it!

What is this?
!BEER paying your bills?

Command accepted!

View or trade BEER at steem-engine.



Hey @emrebeyler, here is a bit BEER for you. Enjoy it!

!trdovoter 100

Sorry @trendo.marketing, this post is older than 3 days, therefore, this post can't reward TRDO!

"Call TRDO, Your Comment Worth Something!"

To view or trade TRDO go to steem-engine.com
Join TRDO Discord Channel or Join TRDO Web Site

Sorry @trendo.marketing, this post already got an upvote from @trendovoter curation bot!


Support @trendotoken projects by delegating : 100SP , 200SP , 500SP , 1000SP , 2000SP

Coin Marketplace

STEEM 0.18
TRX 0.05
JST 0.022
BTC 17047.10
ETH 1287.28
USDT 1.00
SBD 2.14