view last executed query

[alocin]

How can view last executed query? I mean, I would like to see somewhere in the report or in a log file the sql used for the report.
Thank you!

Nicola

[HighAley]

Hello, Nicola.

To save last SQL query you could make next changes in the handler.php file.

Find

Code: Select all

$query = base64_decode($query);

line in the sti_client_event_handler() function.

Add next line after this one:

Code: Select all

file_put_contents("last_query.txt", $query);

The last_query.txt will content the last SQL query.

Thank you.