Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '18fcd3e8f17b1e327428f71162caeec6'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xhelp'
SELECT * FROM xoops_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '806e1ae26fe00d760da27eba33d31688'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xhelp'
SELECT * FROM xoops_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner

SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '91fe3bbe258ef06a3eb34b379bd50a35'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'xhelp'
SELECT * FROM xoops_config WHERE (conf_modid = '31') ORDER BY conf_order ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_xhelp_status ORDER BY description ASC
SELECT COUNT(*) FROM xoops_xhelp_tickets WHERE status = '3'
SELECT COUNT(*) FROM xoops_xhelp_tickets WHERE status = '2'
SELECT COUNT(*) FROM xoops_xhelp_tickets WHERE status = '1'
SELECT u.uid, u.uname, u.name, (s.responseTime / s.ticketsResponded) as AvgResponseTime FROM xoops_users u INNER JOIN xoops_xhelp_staff s ON u.uid = s.uid WHERE ticketsResponded > 0 ORDER BY AvgResponseTime LIMIT 0, 5
SELECT SUM(callsClosed) FROM xoops_xhelp_staff
SELECT t.*, (UNIX_TIMESTAMP() - t.posted) as elapsed, (UNIX_TIMESTAMP() - t.lastUpdated) as lastUpdate FROM xoops_xhelp_tickets t INNER JOIN xoops_xhelp_status s ON t.status = s.id WHERE s.state <> '2' ORDER BY priority ASC LIMIT 0, 10