My Steemit Friends Update: 30-Day Top Author By SBD Past Payout Ranking integrated into website.
New Features
The 30-Day Top Author By SBD Past Payout Ranking integrated into the My Steemit Friends website. 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 30-Day Top Author By SBD Past Payout ranking table. You can also access this page directly here if you wish: http://mysteemitfriends.online/past_payout.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 ranking table page.
- How did you implement it/them?
-past_payout.php: A list of Steemit Users ranked by the 30-Day SBD Past Payout value. SQL is used to retrieve the ranking data, 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 and assist with appending dates.
-get_pastpay_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 does not have any past payout sin the last 30 days. 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
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 so much utopian!
I think I saw the update before you even announced it. Awesome! This is awesome! mysteemitfriends.online is now in the top 5 most useful Steemtool there is. I'll try to mention it in my next post.
Thank you so much teamsteem for your inspiration and support. You are the best.
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
thank you vladimir!!!
Dude! This tool has gotten so damn good the last few updates. It's now incredible and I'm using it all the time to ensure I'm paying my friends as much as they're paying me.
The ability to check the funds upvoted per user is just incredible... and I'd love to be able to rank my friends by their total contributions if possible.
I'm on holidays at the moment, but would you mind if I created a tutorial on your tool when I get back home in a week? I'd love to share this with everyone I know. ..
hey mate, thanks for making a tutorial :) look forward to seeing it :)
Thanks dude! I get back home in a week or so... and will work on it then... but I'm super pumped to share your amazing tool with everyone.
wow such a good sharing very informative for newbies like me, @magicmonk keep posting :]
This tool is good, enables one to track relevant details! Nice awareness
http://mysteemitfriends.online/, this site is very helpful. We can see friends earning by this site in which we will be more interested to steemit. And we know details of a succeeded friends by this site in which we follow that friends. I think this is the great idea.
Hey Magic Monk. Thanks for the update.
BTW: I love the conversation feature.
Everyday this gets better!
I like you tool. Can i mention it in my next topic?