RE-Assign all tickets?

stedmund

Hi there,

I have opened a thread in another section (General Discussion) but thought this might be a better place to submit.

I am trying to re-assign all tickets in OSTicket to the last person who closed the ticket. Similar to the "Auto-assign reopened tickets to last respondent 'available'. ( 3 months limit)" feature which assigns a ticket to the last person to close when a client reply's.

If anyone can point me in the right direction, or better yet, give a SQL query, it would be greatly appreciated.

James

stedmund

I have found this code in class.ticket.php

if(db_query($sql) && ($msgid=db_insert_id())) {

$this->setLastMsgId($msgid);

$this->onMessage();

if(!$newticket){

//Success and the message is being appended to previously opened ticket.

//Alerts for new tickets are sent on create.

$dept =$this->getDept();

//Reopen if the status is closed...

if(!$this->isOpen()) {

$this->reopen();

//If enabled..auto-assign the ticket to last respondent...if they still have access to the Dept.

if($cfg->autoAssignReopenedTickets() && ($lastrep=$this->getLastRespondent())) {

//3 months elapsed time limit on auto-assign. Must be available and have access to Dept.

if($lastrep->isAvailable() && $lastrep->canAccessDept($this->getDeptId())

&& (time()-strtotime($this->getLastResponseDate()))<=90*24*3600) {

$this->setStaffId($lastrep->getId()); //Direct Re-assign!!!!????

}

//TODO: Worry about availability...may be lastlogin also? send an alert??

}

Now, me being the windows-only guy I am, can I mod this so it does what I need it to do, and how?