<?php
$query = "SELECT
r.revision_id,
r.content_id,
r.user_id,
r.entry_name,
r.entry_description,
r.date_added,
r.date_modified
FROM modules_acls_entries_content_revisions r
INNER JOIN modules_acls_entries_content c ON (c.content_id = r.content_id)
WHERE r.revision_id = ?;";
if(preg_match_all("/((FROM|JOIN|,) ([_\w]*) )/", $query, $matches)) {
$tables = array_unique($matches[3]);
print_r($tables);
}
- Output for 5.6.38, 7.0.0 - 7.0.32, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.7
- Array
(
[0] => modules_acls_entries_content_revisions
[1] => modules_acls_entries_content
)
preferences:
171.36 ms | 404 KiB | 243 Q