create account

支持一下Ecency的开发维护提案 & 如何查询 by oflyhigh

View this thread on: hive.blogpeakd.comecency.com
· @oflyhigh ·
$60.92
支持一下Ecency的开发维护提案 & 如何查询
看到西总在微信群以及HIVE上为Ecency的提案拉票,Ecency是HIVE上最好用的客户端应用之一,据我所知有很多CN区的小伙伴使用Ecency发帖。


![1700129234999.png](https://images.hive.blog/DQmUBgKQGFmmfjG8JDf6m27ivm7xX9UqDp3qWL255msLKC9/1700129234999.png)
(图源 :[pixabay](https://pixabay.com/photos/vote-word-letters-scrabble-1804596/))

# 关于Ecency提案
Ecency提案的资金用于以下产品和服务的开发和维护:
* Ecency网站
* Ecency客户端
* Hivesearcher (一款HIVE搜索引擎)
* Hivesigner
* Hivexplorer
* 图床服务
* 其它内容

可见团队确实在用心做事,为HIVE的发展壮大,不断地添砖加瓦,所以值得我们投出手中的宝贵一票。

Ecency的每期提案我都投了支持票,比如当前正在生效的这一期:
![1700125104816.png](https://images.hive.blog/DQmW2qJPDUyV8EVAKs3YpPra4nHHGssksZuJn1fnxG8gJoJ/1700125104816.png)

目前上一轮提案已经接近尾期啦,即将生效的一期代码为284:
![1700125612206.png](https://images.hive.blog/DQmfNMTVj1zpzj8J6H3Veg9sa16Vknu51PvkBZuYadGTZQ1/1700125612206.png)

# 如何支持提案

大家可以通过如下途径投票:
>* https://wallet.hive.blog/proposals
>* https://ecency.com/proposals
>* https://peakd.com/proposals

或者你能使用命令行钱包的话,也可以通过如下指令投票:
>`update_proposal_votes YOURACCOUNT [283] true true`

其中`YOURACCOUNT`替换为你自己的账户;`283`为我们要更新的提案ID,此处可以一并处理多个提案,ID以逗号分隔;第一个`true`表示我们投支持票(`false`为反对票);第二个`true`为将操作广播到网络上。

无论使用哪种方式投票,其实都是在网络上广播了`update_proposal_votes`这项操作:
![image.png](https://images.hive.blog/DQmNyYQVCKZZfEkD6bXucAifYXbKMpyGGFssp9bnh8XpyU4/image.png)

以我的操作为例,会在hiveblocks.com上查到类似如下内容:
![image.png](https://images.hive.blog/DQmZ7PPFt234NC7FVgMyEjsth4vkNWrFtvHxwQJLTLfyYg8/image.png)

这就代表我已经支持成功啦。

# 如何查看是否已经支持提案

大家可能会注意到我列出的两期Ecency提案上右侧的小箭头,原则上,我登录后,有小箭头的就代表我投了支持票;小箭头为灰色的则代表我尚未投票(或者投了反对票——等效未投)。但是实际使用中发现,这个箭头并不总如我想象的那样工作。

其它投票途径也都提供了各自的查询方法,但是我这用起来总不灵验。

那么有没有更好用的查询方法呢?直接看hiveblocks.com的transaction肯定是准的,但是若投票发生的比较久远,翻起来岂不是累死?

最终我发现可以通过HiveSQL查询我们的`update_proposal_votes`transaction:
```
SELECT *
FROM TxProposalVoteUpdates
WHERE proposal_ids LIKE '%283%'
  AND voter = 'oflyhigh'
```

以上指令将会返回如下内容:
![image.png](https://images.hive.blog/DQmdxxNq2nQ13SJFa4mkZ8idEFpHbWgc9oYLJGUSnYJfzhK/image.png)
这表示我们成功地支持了ID为283的这项提案。

同时我发现HiveSQL中有***ProposalsApprovals***这个视图,查询起来会更加方便:
```
SELECT * 
FROM ProposalsApprovals 
WHERE voter='oflyhigh' and proposal_id=283
```
以上指令将会返回:
![image.png](https://images.hive.blog/DQmWTePurZoBXeabruSkQtc8WgKPzygzcXn8JtmuF7C7KFx/image.png)

这表示我们已经成功地支持了ID为283的这项提案。如果返回内容为空,则表示我们尚未就此项提案投票或者显式地投了反对票(等效于未投)。

好了,现在小伙伴们把投票搞起来吧。

# 见证人代理

顺便说一句,如果你觉得给提案投票很麻烦,不想操心,又想支持一些优秀提案,那么可以考虑把我:***[设置成你的见证人代理](https://hivesigner.com/sign/account-witness-proxy?proxy=oflyhigh&approve=1)***哦!

那么我支持哪个见证人或者支持哪项提案,就相当于你也支持啦,省心又省力,快快行动起来吧。

# 相关链接
* https://hive.blog/hive-139531/@ecency/ecency-development-and-maintenance-4
* https://wallet.hive.blog/proposals
* https://ecency.com/proposals
* https://peakd.com/proposals
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 172 others
properties (23)
authoroflyhigh
permlinkecency-and
categoryhive-105017
json_metadata{"tags":["cn","life","blog","proposals","ecency","dhf"],"image":["https://images.hive.blog/DQmUBgKQGFmmfjG8JDf6m27ivm7xX9UqDp3qWL255msLKC9/1700129234999.png","https://images.hive.blog/DQmW2qJPDUyV8EVAKs3YpPra4nHHGssksZuJn1fnxG8gJoJ/1700125104816.png","https://images.hive.blog/DQmfNMTVj1zpzj8J6H3Veg9sa16Vknu51PvkBZuYadGTZQ1/1700125612206.png","https://images.hive.blog/DQmNyYQVCKZZfEkD6bXucAifYXbKMpyGGFssp9bnh8XpyU4/image.png","https://images.hive.blog/DQmZ7PPFt234NC7FVgMyEjsth4vkNWrFtvHxwQJLTLfyYg8/image.png","https://images.hive.blog/DQmdxxNq2nQ13SJFa4mkZ8idEFpHbWgc9oYLJGUSnYJfzhK/image.png","https://images.hive.blog/DQmWTePurZoBXeabruSkQtc8WgKPzygzcXn8JtmuF7C7KFx/image.png"],"links":["https://pixabay.com/photos/vote-word-letters-scrabble-1804596/"],"app":"hiveblog/0.1","format":"markdown"}
created2023-11-16 10:09:09
last_update2023-11-16 10:09:09
depth0
children6
last_payout2023-11-23 10:09:09
cashout_time1969-12-31 23:59:59
total_payout_value30.478 HBD
curator_payout_value30.439 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2,613
author_reputation6,293,711,694,782,071
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,908,118
net_rshares134,112,130,359,896
author_curate_reward""
vote details (236)
@deanliu ·
O哥也來搞個提案吧?看看能做啥...😍
properties (22)
authordeanliu
permlinkre-oflyhigh-s47pyn
categoryhive-105017
json_metadata{"tags":["hive-105017"],"app":"peakd/2023.10.1"}
created2023-11-16 10:47:12
last_update2023-11-16 10:47:12
depth1
children0
last_payout2023-11-23 10:47:12
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length19
author_reputation3,088,576,810,035,728
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,908,892
net_rshares0
@love5200 ·
支持,支持,必须支持,我来HIVE用得第一个APP就是Ecency.
properties (22)
authorlove5200
permlinkre-oflyhigh-20231116t182759153z
categoryhive-105017
json_metadata{"tags":["cn","life","blog","proposals","ecency","dhf"],"app":"ecency/3.0.37-vision","format":"markdown+html"}
created2023-11-16 10:28:00
last_update2023-11-16 10:28:00
depth1
children0
last_payout2023-11-23 10:28:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length34
author_reputation537,682,510,888,672
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,908,476
net_rshares0
@lovelingling ·
明白了,原来见证人代理是这么回事,太省心了。Ecency,刚来HIVE的时候,就一直在那儿写,天天挣积分,挺好玩的。
properties (22)
authorlovelingling
permlinkre-oflyhigh-20231117t53724392z
categoryhive-105017
json_metadata{"tags":["hive-105017","cn","life","blog","proposals","ecency","dhf"],"app":"ecency/3.0.19-mobile","format":"markdown+html"}
created2023-11-16 21:37:27
last_update2023-11-16 21:37:27
depth1
children0
last_payout2023-11-23 21:37:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length58
author_reputation720,021,170,543,432
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,923,071
net_rshares0
@marygong77777 ·
👍👍
properties (22)
authormarygong77777
permlinkparama-1700130580429
categoryhive-105017
json_metadata""
created2023-11-16 10:29:42
last_update2023-11-16 10:29:42
depth1
children0
last_payout2023-11-23 10:29:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length2
author_reputation402,490,730,829,858
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,908,511
net_rshares0
@renovatio ·
I used to , ahem, use Ecency back in the day, not sure if it is something nowadays...
properties (22)
authorrenovatio
permlinks48whc
categoryhive-105017
json_metadata{"app":"hiveblog/0.1"}
created2023-11-17 02:05:36
last_update2023-11-17 02:05:36
depth1
children0
last_payout2023-11-24 02:05:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length85
author_reputation8,560,661,823,895
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,927,128
net_rshares0
@xiaoyaodidi ·
😁 O哥我也是ecency提案的支持者  
properties (22)
authorxiaoyaodidi
permlinkre-oflyhigh-20231116t1129232z
categoryhive-105017
json_metadata{"type":"comment","tags":["hive-105017","cn","life","blog","proposals","ecency","dhf"],"app":"ecency/3.0.44-mobile","format":"markdown+html"}
created2023-11-16 10:29:00
last_update2023-11-16 10:29:00
depth1
children0
last_payout2023-11-23 10:29:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 HBD
curator_payout_value0.000 HBD
pending_payout_value0.000 HBD
promoted0.000 HBD
body_length21
author_reputation420,068,217,197,428
root_title"支持一下Ecency的开发维护提案 & 如何查询"
beneficiaries[]
max_accepted_payout1,000,000.000 HBD
percent_hbd10,000
post_id128,908,496
net_rshares0