SteemIt Outgoing/Incoming Voting Report 高级点赞查询工具

in cn •  7 years ago  (edited)

Incoming Voting Report

This tool allows you to specify a date range (two dates) and group and count the voters that vote for you the most. The incoming voting report allows you to identify a list of Most-Valuable-Players. The API is handy and can be used on fair-use policy.

Tool URL: https://helloacm.com/tools/steemit/incoming/

Outgoing Voting Report

This tool allows you to specify a date range (two dates) and group and count the authors that benefit from a given Steem User. The voting report allows you to identify a list of authors that may be likely get more upvotes from the given Steemian. The API is handy and can be used on fair-use policy.

Tool URL: https://helloacm.com/tools/steemit/outgoing/


Image Credit: Pixabay.com

撸了两个工具,可以指定日期,这样一来,比如可以用在 @nationalpark报告中。也可以看看你的 自我点赞比例

Steemit Incoming 点赞查询报告

这个工具帮助你查看在一段时间内接受的STEEMIT点赞金主报告。我们也提供一个好用的API可以方便的返回所有金主名单和投票的比重。你也可以通过这个工具来查看自我投票的比重 (Self Voting)。

工具地址https://helloacm.com/tools/steemit/list-of-incoming/

Steemit Outgoing 点赞查询报告

这个工具帮助你查看在一段时间内STEEMIT大鲸的投票情况,比如我们可以看出哪些是大鱼的小号或者马甲,又或者哪些用户是有联系的(同一利益集团)。我们也提供一个好用的API可以方便的返回所有点赞情况的名单和投票的比重。你也可以通过这个工具来查看自我投票的比重 (Self Voting)。

工具地址https://helloacm.com/tools/steemit/list-of-outgoing/

@justyyhttps://justyy.com 的博主,在大哥 @tumutanzi 的介绍下加入 STEEMIT,写些帖子挣些小钱养家糊口。


@justyy 也是CN 区的点赞机器人,对优质内容点赞,只要代理给 @justyy 每天收利息(年化率14.6%)并能获得一次至少2倍(VP 200%+)的点赞,大鱼 @htliao 都加入了这个计划(530 SP)表示支持。

  1. cn区最低保障系统 上线了!
  2. cn区低保计划(鼓励新人)真的适合你么?

Steemit 在线工具和API接口
SteemIt Tools and APIs

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

very nice post.
thank you for share.

  ·  7 years ago (edited)

这个工具很不错,能具体指定日期,强。我将我的文章中推荐链接更新加上了你的这个工具。

  ·  7 years ago 

多些大哥肯定。^^

@royrodgers has voted on behalf of @minnowpond. If you would like to recieve upvotes from minnowponds team on all your posts, simply FOLLOW @minnowpond.

        To receive an upvote send 0.25 SBD to @minnowpond with your posts url as the memo
        To receive an reSteem send 0.75 SBD to @minnowpond with your posts url as the memo
        To receive an upvote and a reSteem send 1.00SBD to @minnowpond with your posts url as the memo
  ·  7 years ago 

没事就能撸工具出来的人,牛的不行。

  ·  7 years ago 

已经撸得灰飞烟灭了 ^_^

厉害!

很实用。yy 要坚持多yy一些。:)

  ·  7 years ago 

快坚持不动了 :(

yy加油

Hi @justyy sorry for commenting off topic here but I found some of your SteemSQL tutorials and they have been extremely helpful to me as a beginner with SQL trying to query steemsql db. If you have the time to help me I would really love some help writing a specific sql query.

So what I am trying to accomplish is - query that returns URL of all new posts (posts only, not comments) that meet these requirements: post age between 1 and 24 hours old; post not flagged; post author reputation between 27 and 52; current pending post payout less than $1; post word count more than 500 (this may have to be specified in characters if I am reading the DB right, in which case post character count more than 3000). Here is what I have so far:

SELECT
    url,
    sum(pending_payout_value) as pending_payout_value
FROM 
    Comments (NOLOCK)
WHERE
   dirty = 'False' and
   parent_author = '' and
   datediff(hour, created, GETDATE()) between 1 and 24 and
   pending_payout_value < 1 and
   body_length >=3000 and
   author_reputation between 27 and 52
group by 
   url 
order by 
   pending_payout_value asc

I am obviously doing something wrong, as the query returns 0 results - my problem may be with the author rep and body length arguments. I have asked for help on the steemchat steemsql help channel but no reply - I am not entirely sure comments/body_length is the post length in characters but I believe so...

A million thanks in advance! I am @carlgnash on steemit.chat and @gnashster on Discord chat if you want to respond in DM there rather than answer in the comments here. Thank you so much for your awesome tutorials! Cheers - Carl