So let's say I want to change a ticket from "Test1 User" who has a userid of 129, to "Test2 User" who has a userid of 130.
I have just such a ticket here. Ticket ID 1767, created by Test1 User.
in helpdesk_tickets
id_ticket = 1767
id_member_started = 129
id_first_msg = 12777
in helpdesk_ticket_replies
id_msg = 12777
id_member = 129
poster_name = Test1 User
poster_email = [email protected]
modified_member = 0
modified_name =
It's easy enough to change all of that via phpMyAdmin. I like that better than moving ALL of the replies to the new user, because it looks just fine in the ticket to have the older messages attributed to the older user, and I don't really see any other ramifications.
Ideas for the UI of something that could do this automatically...
On Admin/Helpdesk/Maintenance, I'd envision a type of wizard interface.
[Reattribute Individual Ticket]
Enter the ticket number that you wish to reattribute...
Enter-> TICKET_NUMBER [NEXT]
After you enter the ticket number and press NEXT a dialog says...
Ticket 1767 was created by...
Username: Test1 User
UserID: 129
Reattribute this ticket to ->> USERNAME [NEXT]
There's also [n] additional replies on this ticket by Test1 User. Do you also want to reattribute those [n] replies to Test2 User? Yes/No (Checkboxes) [NEXT]
Reattribute Ticket 1767 (and n attached replies) from [Test1 User] to [Test2 User]? YES/CANCEL
I have just such a ticket here. Ticket ID 1767, created by Test1 User.
in helpdesk_tickets
id_ticket = 1767
id_member_started = 129
id_first_msg = 12777
in helpdesk_ticket_replies
id_msg = 12777
id_member = 129
poster_name = Test1 User
poster_email = [email protected]
modified_member = 0
modified_name =
It's easy enough to change all of that via phpMyAdmin. I like that better than moving ALL of the replies to the new user, because it looks just fine in the ticket to have the older messages attributed to the older user, and I don't really see any other ramifications.
Ideas for the UI of something that could do this automatically...
On Admin/Helpdesk/Maintenance, I'd envision a type of wizard interface.
[Reattribute Individual Ticket]
Enter the ticket number that you wish to reattribute...
Enter-> TICKET_NUMBER [NEXT]
After you enter the ticket number and press NEXT a dialog says...
Ticket 1767 was created by...
Username: Test1 User
UserID: 129
Reattribute this ticket to ->> USERNAME [NEXT]
There's also [n] additional replies on this ticket by Test1 User. Do you also want to reattribute those [n] replies to Test2 User? Yes/No (Checkboxes) [NEXT]
Reattribute Ticket 1767 (and n attached replies) from [Test1 User] to [Test2 User]? YES/CANCEL