MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page. by magicmonk

View this thread on: hive.blog | peakd.com | ecency.com

utopian-io · @magicmonk · Feb 26 '18 (edited)

$76.57

MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page.

- <a href="http://mysteemitfriends.online">My Steemit Friends Tool website.</a><br> 
- <a href="http://github.com/Bulletproofmonk/MySteemitFriends">Github repository.</a> 
- <a href="https://github.com/Bulletproofmonk/MySteemitFriends/commit/27ffbd06452924db7b387f43c86f715b2b377a59">Commit for this update</a><br><br>

### New Features
- What feature(s) did you add?

The Contributors Ranking table on My Steemit Friends has a new feature - a new Article Count column, for you to see how many articles your contributors have voted on. Please test this feature out by going to http://mysteemitfriends.online/contributors.php, enter your username and click "Show Contributors. You will then see not only the amount contributed by each user towards your earnings, but also how many times they have voted you on the right hand side column. 

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519532673/gvtxmtlvhh5ehwlwxljb.png)

If you click on any of the "article counts", you will also be taken to the "Contribution Calculator" built previously, where it will list all the articles which this user has voted on, as well as show you this voter's ranking in comparison with other voters for each of the articles.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519532815/if9autrtu0ff7zmfgpiu.png)

You can also see an "Exclude Comments" checkbox is currently ticked by default (new feature added to contribution calculator). If you untick this checkbox and click "Calculate" again, you will see that comments will be included in the contribution calculator.

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1519532908/q8pctntg2zdmallvwjlj.png)

- How did you implement it/them?

<a href="https://github.com/Bulletproofmonk/MySteemitFriends/commit/27ffbd06452924db7b387f43c86f715b2b377a59">Relevant commit</a><br>

contributors.php: New "article count" column in Contributor's ranking: I made another SQL query called "votecounting (on lines 205-219) which counts how many votes each voter has given the user. Then I joined the result from this table to the previous query result and added one more column to the select query. I also made the result from this query link to the contribution calculator using a combination of Javascript and PHP.

upvotelist.php: I added a checkbox to retrieve the parameter from the URL for whether comments are to be included, and then when the form is resubmitted I also make sure the checkbox value determines which query is submitted. I have also modified the original SQL query to bind variables to the prepared statement in order to reduce the likelihood of an SQL injection.

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@magicmonk/mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>

👍 utopian-io, teamsteem, ausbitbank, joythewanderer, magicmonk, justyy, pnc, mrsquiggle, mrs.agsexplorer, centerlink, travelgirl, world-travel-pro, catwomanteresa, berkah, jacobts, greenstar, lydiachan, thecrytotrader, webcoop, shreetbn, helo, juicy-shark, wanderwithtwo, ratticus, bitcoiner, steemulator, steemitstats, mumofmany, marketstack, teamaustralia, gohba.handcrafts, dailystats, jaycobbell, liangfengyouren, shengjian, superbing, grateful, cnsteem, bmj, cryptwo, reedracer, dailyfortune, jjay, st3llar, fisnikk, yazanovakatya, trevorpetrie, planetka, laobvakla, steemsquad, mikepedro, cha0s0000, rechellomataro, lakemountain, dailychina, cryptonewsly, foodielifestyle, happyukgo, lilypang22, sandan, moobear, nathankaye, ivysrono, hd12, and 12 others

properties (23)vote details (76)

voter	rshares	pct
berkah	20,584,834,063	25%
mrs.agsexplorer	45,853,812,410	10%
pnc	81,861,497,027	25%
teamsteem	1,862,001,192,354	25%
reedracer	710,190,997	7%
ausbitbank	552,720,926,248	10%
jaycobbell	1,119,670,771	8%
bitcoiner	2,213,267,746	25%
joythewanderer	179,562,841,179	41%
magicmonk	173,571,056,395	100%
jacobts	13,273,925,408	10%
justyy	111,419,964,337	15%
steemsquad	377,886,766	4%
happyukgo	184,980,648	10%
lydiachan	12,326,612,117	40%
grateful	917,795,471	15%
greenstar	12,944,792,009	25%
mikepedro	364,201,162	5%
world-travel-pro	22,872,346,892	30%
gohba.handcrafts	1,436,142,308	2.5%
helo	8,939,589,974	100%
thecrytotrader	11,006,660,510	25%
teamaustralia	1,663,734,280	3%
mumofmany	2,018,354,859	10%
bmj	771,580,614	3%
centerlink	44,816,835,605	10%
st3llar	619,183,249	3%
travelgirl	38,047,398,092	30%
fisnikk	612,079,259	100%
ratticus	5,226,736,883	13.5%
steemulator	2,130,680,945	10%
catwomanteresa	22,142,845,475	20%
wanderwithtwo	7,030,457,154	30%
sandan	170,166,971	100%
rainyapril	52,447,993	10%
liangfengyouren	1,091,591,538	50%
shengjian	1,031,281,380	5%
geass	52,320,542	10%
mrsquiggle	52,915,701,658	15%
webcoop	10,835,566,557	5%
trevorpetrie	553,657,632	5%
superbing	943,748,262	10%
dailyfortune	658,332,947	10%
dailystats	1,281,533,810	10%
ivysrono	109,128,383	10%
juicy-shark	7,899,236,165	50%
utopian-io	14,078,623,432,012	9.56%
shreetbn	9,550,265,552	50%
anxin	50,969,237	10%
cnsteem	881,003,600	1%
cryptwo	741,193,789	9%
steemitstats	2,063,366,150	5%
cryptonewsly	197,223,608	100%
moobear	168,114,539	10%
jjay	646,943,807	100%
yazanovakatya	566,349,185	100%
planetka	551,472,456	100%
prch	88,906,052	10%
foodielifestyle	191,669,503	10%
laobvakla	532,349,690	100%
woolfe19861008	78,814,038	10%
dailychina	222,249,175	2%
serenazz	79,852,814	10%
cha0s0000	333,031,707	10%
marketstack	1,848,743,530	10%
shentrading	58,278,542	10%
nathankaye	145,271,919	5%
deepthinking	52,242,183	10%
khayziljoy	52,131,016	100%
lilypang22	182,453,138	10%
hd12	89,149,418	79.39%
rechellomataro	331,076,513	100%
ashi0	55,174,418	10%
steemitvip	52,117,380	10%
lakemountain	229,725,320	10%
regals	52,227,354	10%

@helo · Feb 26 '18

$0.43

Thank you for the contribution. It has been approved.

Good job, I can see as well that you took the time to refactor the code and take care of fixing the prepared statements.   

You can contact us on [Discord](https://discord.gg/uTyJkNm).
**[[utopian-moderator]](https://utopian.io/moderators)**

👍 magicmonk

`author`	helo
`permlink`	re-magicmonk-mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page-20180226t123017127z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
`created`	2018-02-26 12:30:21
`last_update`	2018-02-26 12:30:21
`depth`	1
`children`	1
`last_payout`	2018-03-05 12:30:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.324 HBD
`curator_payout_value`	0.105 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	297
`author_reputation`	121,547,934,535,311
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,589,256
`net_rshares`	75,957,722,544
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
magicmonk	0 B		75,957,722,544	40%

@magicmonk · Feb 26 '18

thank you so much helo. You have helped me grow as a developer.

properties (22)

`author`	magicmonk
`permlink`	re-helo-re-magicmonk-mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page-20180226t130527239z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-02-26 13:05:27
`last_update`	2018-02-26 13:05:27
`depth`	2
`children`	0
`last_payout`	2018-03-05 13:05:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	63
`author_reputation`	1,098,626,896,588,924
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,596,602
`net_rshares`	0

@steemitstats · Feb 25 '18

@magicmonk, I always try to support who contribute to open source project, upvote you.

properties (22)

`author`	steemitstats
`permlink`	20180225t044606225z-post
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"]}
`created`	2018-02-25 04:46:06
`last_update`	2018-02-25 04:46:06
`depth`	1
`children`	0
`last_payout`	2018-03-04 04:46:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	86
`author_reputation`	351,882,871,185
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,250,987
`net_rshares`	0

@thecrytotrader · Feb 25 '18

$0.02

Thanks for adding this because that's the feature that i was talking about few days ago in your comments,thanks man great development

👍 magicmonk

`author`	thecrytotrader
`permlink`	re-magicmonk-mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page-20180225t050911324z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-02-25 05:09:12
`last_update`	2018-02-25 05:09:12
`depth`	1
`children`	0
`last_payout`	2018-03-04 05:09:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.018 HBD
`curator_payout_value`	0.003 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	133
`author_reputation`	120,415,125,606,468
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,254,314
`net_rshares`	4,394,203,959
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
magicmonk	0 B		4,394,203,959	2%

@utopian-io · Feb 26 '18

$0.37

### 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. <a href="https://discord.gg/zTrEMqB">Participate on Discord</a>. Lets GROW TOGETHER!
- <a href="https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1">Vote for my Witness With SteemConnect</a>
- <a href="https://v2.steemconnect.com/sign/account-witness-proxy?proxy=utopian-io&approve=1">Proxy vote to Utopian Witness with SteemConnect</a>
- Or vote/proxy on <a href="https://steemit.com/~witnesses">Steemit Witnesses</a>

[![mooncryption-utopian-witness-gif](https://steemitimages.com/DQmYPUuQRptAqNBCQRwQjKWAqWU3zJkL3RXVUtEKVury8up/mooncryption-s-utopian-io-witness-gif.gif)](https://steemit.com/~witnesses)

**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**

👍 magicmonk

`author`	utopian-io
`permlink`	re-magicmonk-mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page-20180226t142830933z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
`created`	2018-02-26 14:28:30
`last_update`	2018-02-26 14:28:30
`depth`	1
`children`	0
`last_payout`	2018-03-05 14:28:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.281 HBD
`curator_payout_value`	0.091 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,007
`author_reputation`	152,955,367,999,756
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,614,681
`net_rshares`	66,050,193,516
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
magicmonk	0 B		66,050,193,516	40%

@villani · Feb 25 '18

upvoted ![DQmTM45HLPzvkV9hTjpXPYCe3VFwrmjTZKrB1nBGd5LSarN_640x480.png](https://steemitimages.com/DQmdbKa8c6BcEuFsYHMdwBUStPrzL33ZVAcRA3Qw5PRUzKV/DQmTM45HLPzvkV9hTjpXPYCe3VFwrmjTZKrB1nBGd5LSarN_640x480.png)

properties (22)

`author`	villani
`permlink`	re-magicmonk-mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page-20180225t051402812z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"image":["https://steemitimages.com/DQmdbKa8c6BcEuFsYHMdwBUStPrzL33ZVAcRA3Qw5PRUzKV/DQmTM45HLPzvkV9hTjpXPYCe3VFwrmjTZKrB1nBGd5LSarN_640x480.png"],"app":"steemit/0.1"}
`created`	2018-02-25 05:14:12
`last_update`	2018-02-25 05:14:12
`depth`	1
`children`	0
`last_payout`	2018-03-04 05:14:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	205
`author_reputation`	1,420,794,928,099
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,254,991
`net_rshares`	0

@world-travel-pro · Feb 25 '18

$0.03

You're really taking it to a new level well done!

👍 magicmonk

`author`	world-travel-pro
`permlink`	re-magicmonk-mysteemitfriends-online-new-feature-article-count-included-in-contributors-ranking-integration-with-contribution-calculator-page-20180225t173845529z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-02-25 17:38:45
`last_update`	2018-02-25 17:38:45
`depth`	1
`children`	0
`last_payout`	2018-03-04 17:38:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.023 HBD
`curator_payout_value`	0.006 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	49
`author_reputation`	-405,874,411,594,630
`root_title`	"MySteemitFriends.Online new feature: Article count included in Contributors ranking, integration with Contribution calculator page."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	40,386,244
`net_rshares`	5,492,754,949
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
magicmonk	0 B		5,492,754,949	3%