Hello guys, i'm trying to automate a process in my community.
So, i basically need to reply the ticket trough an UPDATE or an INSERT via MySQL. I need a query or somehow
As i know, there is some discussions about this topic but nobody figured out how to do it.
Someone haves a idea on how to start? I really need to do this. i attend more than 400 tickets daily
Tyvm
Create a reply through SQL
- Edited
- Best Answerset by KevinTheJedi
Since this would be custom work you'd be on your own. It's definitely do-able, it would just be time consuming (if you don't know the database structure) and would require you to write your own script(s) and SQL statements. With this being said, we have Database ERDs available on the documentation site that show the various object relationships. Good luck!
Cheers.
- Edited
Is crazy to think this do the work? Or i should do more inserts per reply?
USE osticket;
INSERT INTO ost_thread_entry (
thread_id,
staff_id,
user_id,
type,
flags,
poster,
editor,
editor_type,
source,
title,
body,
format,
ip_address,
recipients,
created,
updated
)
VALUES (
11464, -- Thread ID
18, -- ID of the responding staff
0, -- User ID (0 if none)
'R', -- Entry type ('R' for response)
576, -- Flags for the record
'xxxxxxxxxxx', -- Name of the poster
NULL, -- Editor (NULL if not applicable)
NULL, -- Editor type (NULL if not applicable)
NULL, -- Source (NULL if not applicable)
NULL, -- Title (NULL if not applicable)
'<p>30 > 60</p>', -- Message body (HTML format)
'html', -- Body format
'192.168.225.26', -- IP address from which it was sent
'{"to":{"153":"xxxxxxx<mxxxxx>"}}', -- Recipients in JSON format
NOW(), -- Current creation timestamp
NOW() -- Current update timestamp
);