In my forum a converted a huge board in tickets but now I have tons of ticket all flagged as "new". It would impossible opening all of them manually.
Is there a way to set all unread tickets as read? Or better, all new ticket as old?
Thank you
Something like this would work, but would have to be setup to run for your user id and database prefix. You would run this on your database.
INSERT INTO {db_prefix}helpdesk_log_read (id_ticket, id_member, id_msg)
SELECT id_ticket, {YOURMEMBERID} AS id_member, id_last_msg AS id_msg
FROM {db_prefix}helpdesk_tickets