We currently use Perlbill for our billing needs. There are a few small changes that we need to be made :-
1. The script has a private message function. Currently the administrator is not able to use this. The admin should be able to use this function.
2. We need to setup some flood protection, to prevent multiple tickets from being created accidentally. Whenever an incoming email is received, the database should be checked to see if the user created a ticket with the same subject in the given threshold time (settable in the control panel), if this check succeeds, Flood Protection gets triggered and the ticket is rejected.
3. We would like support tickets that are being actioned already to be locked. When a staff member clicks on respond in a ticket, the ticket should then be locked and other staff members cannot reply for x minutes (settable in the control panel) or until the response has been posted.
4. Explain the following tables and clear out old data – staffread, stafflogin, staffactive, signupvalues
PLEASE RESPECT OUR BUDGET, DO NOT POST IF YOU HAVE LESS THAN 3 RATINGS AND LESS THAN 100% FEEDBACK.