I've changed ticket ownership a time or two by editing by hand in phpMyAdmin, but now I've got one where I need to change ownership about 50 tickets, and I'd like to do them all in one fell swoop. As a prerequisite, I want to change ownership of the ticket, and the first reply on the ticket, but all of the other replies on the tickets should remain as if they were entered by the old user.
This way the new user will own the tickets, but will see the replies on the tickets made by the old user.
Old user = John Smith, userid = 23
New user = Fred Johnson, userid = 219
First, update the replies...
update smf_helpdesk_ticket_replies set id_member = 219, poster_name = 'Fred Johnson', poster_email = 'email@example.com' where id_msg in (select id_first_msg as id_msg from smf_helpdesk_tickets WHERE id_member_started = 23)
...Then update the tickets...
update smf_helpdesk_tickets set id_member_started = 219 WHERE id_member_started = 23
If you want to try this you'll need access to phpMyAdmin, and a stout heart. Make sure to back it up first! Edit the two SQL queries above, substituting your user id, name and email. Do not attempt this if you're unsure... as it's for advanced users. If you want help, just say the magic word.