2008/9/13 21:25
ghia
Community Support Member
Posts: 4953
Since: 2008/7/3 1
2008/9/14 4:12
atisolution
Not too shy to talk
Posts: 147
Since: 2008/7/28
2008/9/14 8:20
2008/9/15 0:48
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
2008/9/15 7:41
2008/9/15 9:35
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
2008/9/15 12:57
2008/9/15 13:35
2008/9/16 20:01
2008/9/17 4:31
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
Advanced Search
303 user(s) are online (250 user(s) are browsing Support Forums)
Members: 0
Guests: 303