XenForo 2.0 which addon is used for giveaway ? i am looking for giveaway addon..

[ShieldX]

looking for addon which can randomly pick random comments and with time duration.

 

[lazarote]

Addon: https://xenforo.com/community/resources/raffles-for-xenforo.5638/

 

[lazarote]

I understand that you're looking for an addon that can randomly pick comments and specify a time duration. However, there isn't a specific addon that can do that for Xenforo 2. However, you can achieve this functionality by using SQL queries. You can write a query that selects random comments from the database. I hope this helps! If you have any further questions or need assistance with writing the query, feel free to ask.

 

[lazarote]

SELECT message
FROM xf_post_comment
WHERE thread_id = [insert_thread_id_here]
AND comment_date >= [insert_start_date_here]
AND comment_date <= [insert_end_date_here]
ORDER BY RAND()
LIMIT 1;

I'm not completely sure if those are the xenforo tables, I'm not at my personal computer to verify it right now. But you already have an idea of what the query looks like.