Use tags to duplicate images?

Support
1

Hi guys, thank you for any help you can give me.

Is there a way to have a tag or other means to repost a image into a separate thread?

As a example, on our community we would like to run a “reptile of the month” competition, where if a user thinks a picture of another users animal is worthy of entry they can reply to that image “+ROTM”. (using + instead of # so I don’t create that tag here).

From there I would like that specific image to be automatically posted/quoted into a separate “Reptile of the month” topic, where the winner will be decided by a poll on that topic at the end of the month and receive a winners badge.

Or is the simplest route to just have users quote that image themselves into that topic?
Thanks again for any help.

2

Wait… what? Why not just have people press the like button under the post with the image, then count the number of likes? The image posts with the most likes win.

I’m not following why it has to be so complicated?

1 Like
3

Sorry, im struggling to word it easier.
Basically these images could come from any other topic in any of the categories not from the actual competition topic.

Say on a random topic someone post a picture of there snake, if another user thinks that snake could win the competition then they could add a tag that would automatically post that image into the competitions thread

They won’t all be posted in the same place, but I would like them to be.

Does that make any more sense? :blush:

4

Simplest low friction way of achieving this is to quote the image and post it as a reply in your “centralized” topic. Automation here, though feasible with webhooks and so on is complex.

3 Likes
5

To make @codinghorror approach easier you can use this data explorer query:

SELECT
  posts.id AS post_id,
  posts.topic_id,
  COUNT(post_actions.id) as likes
FROM
  posts
INNER JOIN
  post_actions ON post_actions.post_id = posts.id
  AND post_actions.post_action_type_id = 2
WHERE
  posts.created_at BETWEEN '2020-01-01' and '2020-01-30'
  AND posts.raw LIKE '%upload://%'
  AND (posts.raw LIKE '%png%' OR posts.raw LIKE '%jpg%')
GROUP BY 1, 2
ORDER BY 3 DESC

Posts from January with image uploads sorted by likes.

3 Likes