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

  • KevinTheJedi replied to this.
  • Kaiser

    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.

    Kaiser

    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.

    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 &gt; 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
    );
      Write a Reply...