RE: Leeching Arseholes!

avatar

You are viewing a single comment's thread:

How cool is that! And by that I mean your script, not the shitposts 😂

I've been looking at the same issue, but I'm lacking the skills 😂
I asked the question in the HiveSQL discord to see if someone could help me with this.

image.png


It would be good to show everyone the amount of rewards that is being given away to low quality, low effort posts.

python
0
0
0.000
5 comments
avatar

Did you get any answers? I rarely ask as there's general no response!

There are only a select few that know how to do all this.

My script is written in Python but I do use a single call to HIVE-SQL for one function, the rest are resolved using the Condenser API and just one I think BEEM... as I can't figure it out any other way.

Chat is useful to some degree, but as HIVE is hardly popular it fails to get a lot of routines and if it does.. doesn't do it very well. I have used it, but need to tinker with the code to get it to work.

0
0
0.000
Reply
avatar

Did you get any answers? I rarely ask as there's general no response!

Unfortunately not until now. But I've been helped before in their chat, so I still have hope.

0
0
0.000
Reply
avatar

Here's an old query I used to use, you can tinker with the values to change things. It gets all posts pending rewards, that are undervalued with long content, low rep, filters out non English (or tries)! and does not include anything flagged with @spaminator.

SELECT
    author, A.reputation_ui,'https://peakd.com'+ url, 
    left(body,500),
    pending_payout_value, 
    C.created, 
    LEN(body) as CharacterCount
FROM 
    Comments C
INNER JOIN Accounts A on C.author=A.name
WHERE
(
    NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"cn"%') 
    AND NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"ru"%')
    AND NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"kr"%') 
AND NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"es"%')
)
AND NOT category IN ('hive','porn')
AND depth = 0
AND NOT author IN ('slobberchops')
AND NOT active_votes LIKE('%"spaminator"%')
AND datediff(minute, C.created, GETDATE()) < 60*4
AND A.reputation_ui BETWEEN 25 AND 65
AND pending_payout_value > 0.0100
AND pending_payout_value < 3.0000 
AND LEN(body) > 4000
ORDER BY created desc
0
0
0.000
Reply
avatar

Interesting data you're after. I'm glad someone is keeping an eye out.

0
0
0.000
Reply