Skip to content
Snippets Groups Projects

Jsalyers blacklist v2

Merged Jason Salyers requested to merge jsalyers-blacklist-v2 into develop
@@ -10,7 +10,7 @@ DECLARE
BEGIN
__post_id = find_comment_id( _author, _permlink, True );
__hive_tag = ARRAY_APPEND( __hive_tag, find_tag_id( _tag, True ));
__observer_id = find_account_id(_observer, False);
__observer_id = find_account_id(_observer, True);
RETURN QUERY SELECT
hp.id,
hp.author,
@@ -88,7 +88,7 @@ BEGIN
SELECT hp.sc_hot INTO __hot_limit FROM hive_posts hp WHERE hp.id = __post_id;
END IF;
__hive_tag = ARRAY_APPEND( __hive_tag, find_tag_id( _tag, True ));
__observer_id = find_account_id(_observer, False);
__observer_id = find_account_id(_observer, True);
RETURN QUERY SELECT
hp.id,
hp.author,
@@ -244,7 +244,7 @@ BEGIN
SELECT ( hp.payout + hp.pending_payout ) INTO __payout_limit FROM hive_posts hp WHERE hp.id = __post_id;
END IF;
__hive_category = find_category_id( _category, True );
__observer_id = find_account_id(_observer, False);
__observer_id = find_account_id(_observer, True);
RETURN QUERY SELECT
hp.id,
hp.author,
@@ -324,7 +324,7 @@ BEGIN
END IF;
__hive_category = find_category_id( _category, True );
__head_block_time = head_block_time();
__observer_id = find_account_id(_observer, False);
__observer_id = find_account_id(_observer, True);
RETURN QUERY SELECT
hp.id,
hp.author,
@@ -403,7 +403,7 @@ BEGIN
SELECT hp.promoted INTO __promoted_limit FROM hive_posts hp WHERE hp.id = __post_id;
END IF;
__hive_tag = ARRAY_APPEND( __hive_tag, find_tag_id( _tag, True ) );
__observer_id = find_account_id(_observer, False);
__observer_id = find_account_id(_observer, True);
RETURN QUERY SELECT
hp.id,
hp.author,
@@ -481,7 +481,7 @@ BEGIN
SELECT hp.sc_trend INTO __trending_limit FROM hive_posts hp WHERE hp.id = __post_id;
END IF;
__hive_tag = ARRAY_APPEND( __hive_tag, find_tag_id( _tag, True ));
__observer_id = find_account_id(_observer, False);
__observer_id = find_account_id(_observer, True);
RETURN QUERY SELECT
hp.id,
hp.author,
Loading