flag all tickets as already read

Started by lamaresh, September 13, 2015, 07:36:18 AM

Previous topic - Next topic

lamaresh

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

SleePy

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
Jeremy D — Spare-Developer