[MOD] See who has the ticket locked

Tony

I did a search and could not find a mod for this, so I just created one and figured I would share. This mod changes the locked message from "This ticket is currently locked by another staff member" to "This ticket is currently locked by USERNAME". You'll need to add code to 2 files:

in \include\class.lock.php, add the following at about line 106

function getLockName() {

$sql='SELECT username FROM ost_staff WHERE staff_id='.db_input($this->getStaffId());

$result = db_query($sql);

$cursor = mysql_fetch_row($result);

$username = $cursor;

return $username;

}

in \include\staff\viewticket.inc.php comment out line 21 and add the following

// $errors='This ticket is currently locked by another staff member!';

$errors='This ticket is currently locked by '.$lock->getLockName().'!';

That's it! Happy ticketing!

anavmon

Hello!

If you want that this MOD helps everyone, then you need to make a little change:

function getLockName() {

<STRONG><s>**</s>$sql='SELECT username FROM '.STAFF_TABLE.' WHERE staff_id='.db_input($this->getStaffId());<e>**</e></STRONG>

$result = db_query($sql);

$cursor = mysql_fetch_row($result);

$username = $cursor;

return $username;

}

Thanks for your MOD! :)