New Features
The Voting Power of Witness Proxies ranking feature has been 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 Voting power of Witness Proxies ranking table. You can also access this page directly here if you wish: http://mysteemitfriends.online/witnessproxies.php
You can type your name (if someone has chosen you as a proxy) 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 highlighted.
How did you implement it/them?
witnessproxies.php: A list of Witness Proxies ranked by the total number of vests (own vests + others who have proxied to this person). SQL statements involving many 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_proxy_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 a witness proxy for any other user. 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
Wow! My mind is blown. I knew it would be interesting to see but I didn't realized this would be so awesome!
I'm glad I asked you if you could add this to your site. It didn't even took 24h to implement. I'll keep coming up with some more idea!
I've resteemed.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hi @teamsteem. Thank you very much for your support and ideas. I will keep working on improving this.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That is just awesome Eddie. I love how you keep building up this fantastic tool. Genius! I've introduced you and your steemfriends site to a handful of people so far and they are all using now and love it. Keep up the great work! -Dan
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks Dan. You're so famous now I feel like I'm talking to a celebrity.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I know right. I was walking down the street here in Guayaquil Ecuador the other day and this little girl in Spanish looked up at me and said "Hey! You're the World Travel Pro! Aren't you!" Lol......wait a minute; I think that was a dream I had last night! lol But thanks so much for the compliment and support! Always greatly appreciated!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You’re a pro.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You as well Joy! From one Travel Pro to another!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
lol you never know Dan. Perhaps a few videos would help with that.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Funny you mention. I just started doing videos in my some of adventure posts. I've got to look into this whole D-tube thing now.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great tool, you are the best ^^
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
He is the best! Good to see you here Joy. @magicmonk and I go back quite a ways now! Super cool guy.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
lol you can probably make a better one
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
don't think so lol
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I took a short break from steemit and I missed your upgrades!!!! you are awesome, this tool is so complex, it's perfect!!!
congrats @magicmonk
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks alex! welcome back!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This was good, love what you produce @magicmonk
Re-steemed
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks a lot buddy
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for the contribution. It has been approved.
Great post and thank you for using prepared sql statements.
You can contact us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you helo it was a brilliant suggestion.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you budgets for making a transfer to me for an upvote of 24.64% on this post!
Half of your bid goes to @budgets which funds growth projects for Steem like our top 25 posts on Steem!
The other half helps holders of Steem power earn about 60% APR on a delegation to me!
For help, will you please visit https://jerrybanfield.com/contact/ because I check my discord server daily?
To learn more about Steem, will you please use http://steem.guide/ because this URL forwards to my most recently updated complete Steem tutorial?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow, thank you so much jerry! incredible initiative!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I agree with @teamsteem this is extremely useful and I am going to resteem as well! I found this by the resteem on @teamsteem's profile!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks jerry! good to have some celebrity endorsement.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You are awesome dude keep it up your awesome work.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is awesome!!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congrats for your ideas, Eddie. It is an amazing tool. You are the ebst :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks allesia
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is awesome i love it!
great job!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Like your post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is really wonderful. It's a great initiative indeed. Kudos boss @magicmonk
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
great post..
help me in steemit to have high upvote power, there may be many ways from you, and maybe i can ask one way of you to get high upvote value
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you for introducing something, you are great continue to do new things
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
i like your post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Blockchain is the world's leading software platform for digital assets. Offering the largest production block chain platform in the world, we are using new technology to build a radically better financial system
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Blockchain is the world's leading software platform for digital assets. Offering the largest production block chain platform in the world, we are using new technology to build a radically better financial system
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is program is very important for steemit lover member & thanks a lot to share this content with us.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice post @magicmonk and @utopian-io
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Useful postings
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great tool, you are the best
thank for you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Like your post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank for information @magicmonk
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
A pleasant day @teamsteem, I am @princessjoyesto and I voted you as my witness in the steemit community. i hope it is okay with you, thank you in advance and have a great day ahead.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very good picture and your story
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit