Sackgesicht VIP
Total posts: 1,636
15 Май 2013 01:38

on top of the Audit log screen, you can see the SQL query.

SELECT al.*,r.title, IF(r.id,1,0) as isrecord,u.username FROM jos_js_res_audit_log al LEFT JOIN jos_js_res_record AS r ON r.id = al.record_id LEFT JOIN jos_users AS u ON u.id = al.user_id WHERE al.type_id IN (1,2,3,0) AND al.section_id IN (1,2,3,0) ORDER BY al.ctime desc

Последние изменения: 02 Март 2014


pepperstreet VIP
Total posts: 3,837
15 Май 2013 05:08

Just wanted to create the same topic ;-) So, you got at least my vote.


Sergey
Total posts: 13,748
15 Май 2013 07:18

Fixed. Thank you.:)

Работает на Cobalt