My Steemit Friends Update: Power Down Ranking feature integrated into website.
New Features
The Power Down ranking feature has been integrated into My Steemit Friends. if you are Powering Down, you will be part of this ranking, ordered by how much SP you are powering down each time. 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.
After you click into the link in the drop down, you will see the Power Down Ranking table. You can also access this page directly here if you wish: http://mysteemitfriends.online/powerdown.php
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.
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.
Click on the blue link at the bottom to see your name in the ranking table page highlighted.
If you are not powering down, it will also output that you are currently not powering down.
How did you implement it/them?
powerdown.php: A list of users Powering Down ranked by the amount of SP powered down each time. SQL statements involving an inner join is used to retrieve the ranking data from SteemSQL, including the current SP, dates regarding powering down etc. PHP is used to display the results in a table. 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_powerdown_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 user is not powering down. 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
Thank you for the contribution. It has been approved.
Great use of annotations on your screen captures.
Also, consider adding some description to your github pull request. A link to your Utopian post might be even beneficial to other Github users.
You can contact us on Discord.
[utopian-moderator]
Hey @helo, I just gave you a tip for your hard work on moderation. Upvote this comment to support the utopian moderators and increase your future rewards!
Hi Helo. I've done it. See updated description. Thank you very much for your help again. You're awesome.
You deliver again, your tools are easy to use
Re-steemed
thanks again buddy!
Hey @magicmonk I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
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
Thank you Utopian!!
it 's great to share...sir..
and @xpilar..it's great to see...
thank you
another great feature added. i like this feature and also give you suggestion approved by utopian. i want that u should see my suggestions
Thanks its so useful...I appreciate your hardwork and helping other steemit user.
Thank you very much for contributing to the Steemit community, a very nice and beneficial thing shared with us. This is an unparalleled example of the benefits and benefits of all of us through this post.
thankyou for contribution @magicmonk , i agree with you