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
);
