osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Display Currently Open Tickets In A PHP Table
We use osTicket at my college and I've been working on a PHP app to display currently open tickets alongside when they were opened and who they are assigned to on a monitor in the IT room so we can see at a glance who has what to do.
Unfortunately, my SQL isn't good enough to build a query that works reliably. I've had it working but every time I do something stops working. For example, I can pull all open tickets but unassigned tickets now don't get added to the list.