My Steemit Friends Update: Witness Voting Power Ranking for all users feature integrated into website.

in #utopian-io7 years ago (edited)

New Features

  • What feature(s) did you add?

Previously, the Witness Voting Power of Proxies ranking only contained proxies. In other words, if no user has proxied their voting power to you, then you will not appear in the ranking.

In this new edition of My Steemit Friends, the Witness Voting Power of all users ranking has been integrated into My Steemit Friends. If you have any voting power not proxied to others, you will appear in this ranking, including if you are a proxy yourself. You can find a link to the ranking table from the navigation bar of the main page of the My Steemit Friends website here: http://mysteemitfriends.online.

image.png

After you click into the link in the drop down, you will see the Witness Voting Power of All Users ranking table. You can also access this page directly here if you wish: http://mysteemitfriends.online/witnessvoting.php

image.png

You can type your name into the search box to see your ranking, and then click the link to be directed to the page with your name highlighted in the ranking tables.

image.png

image.png

If you have proxied your voting power to others, then you will not appear on this ranking table, so this will be the message when you search for your ranking. It will tell you the name of the user that you have proxied your voting power to.

image.png

From the main My Steemit Friends page, you can also type in your username here and see the ranking directly, without going into the ranking table. Then you can click on the blue link at the bottom to see your name in ranking table page highlighted.

image.png

image.png

  • How did you implement it/them?
    Link to relevant lines in the code on GitHub and explain briefly what you added/changed.

  • witnessvoting.php: A list of all users (who have not proxied their voting power to others) ranked by the total number of vests (own vests + others who have proxied to this person, if there are any). SQL statements involving several inner joins are used to retrieve the ranking data from SteemSQL, and PHP is used to dispaly them. PHP sanitizing function is used on the page number input from the user and prepared SQL statements are used to prevent SQL injection. PHP statements are used to check for highlights.

  • get_voting_rank.php: This PHP file is accessed by using AJAX when users click on Search Ranking button in either the ranking table page or the main My Steemit Friend page. SQL is used to order the users and retrieve the ranking of a particular user. Finally PHP and HTML is used to create the link to the correct page on the ranking table, and an IF statement is used to prevent an error where a userhas proxied their voting power to another user - it will output the name of the proxy instead. PHP Sanitizing function is used on the username input and then prepared SQL statement is used to prevent SQL injection.



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Thank you so much!!

You're welcome.

Ah! I wasn't sure if I was dreaming this or not.

Magicmonk is genius. hahah

lol thanks, I wish

thanks teamsteem! I'm glad you like it!

Hey @magicmonk I am @utopian-io. I have just upvoted you!

Achievements

  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Is there anyway it shows how much curation rewards I have received from a particular user's posts? I think at the moment it shows how much my upvotes have contributed to their posts only

it's coming :) thanks :)

thanks for adding new feature. I like this feature. I m really fan of your tool because this tool help you to decide where u r in steemit and what you have to do for grow more. I also gave a suggestion theough utopian hope you want to see and implement tht. suggestion approved by utopian. I think u like tht feature and implement tht

Very informative post about ranking factor in steemit. Really this post is very helpful for us. We need to know as a steemian these subject matters.

i like your post
visit my blong @nurafni99

Nice information.. thanks

the very useful site for all community .thanks for sharing this

Good posting looked good.
I will follow you.
Let's communicate frequently.