Hey there, great updates.

A small note:

if ($articlesonly==2) {
    $result = $this->db->prepare($sql);
    $sql.= "AND (permlink NOT LIKE 're-%')";
}

This may create false positives since we have lots of dapps creating content in the blockchain and not everyone of them follows the "re-$parent_permlink" pattern.

Not sure about SteemSQL's database schema, but should not be possible to check the parent_author exists or not? If it exists, that means it's a comment.

Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, click here.

Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]