143 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering
3
SELECT params
FROM jos_mambots
WHERE element = 'mluserkillersystembot'
AND folder = 'system'
4
SELECT u.id AS userid,a.aro_id AS aroid FROM jos_users AS u
LEFT JOIN jos_core_acl_aro AS a ON a.value = u.id
WHERE (u.usertype NOT IN ('Super Administrator','Administrator','Manager')
AND u.lastvisitDate <> '0000-00-00 00:00:00'
AND DATE_ADD(u.lastvisitDate, INTERVAL 30 DAY) < NOW())
OR (u.usertype NOT IN ('Super Administrator','Administrator','Manager')
AND block = 1
AND DATE_ADD(u.registerDate, INTERVAL 30 DAY) < NOW())
OR(u.usertype NOT IN ('Super Administrator','Administrator','Manager')
AND block = 0
AND u.lastvisitDate = '0000-00-00 00:00:00'
AND DATE_ADD(u.registerDate, INTERVAL 30 DAY) < NOW())
