function report_customsql_prepare_sql($report, $timenow) { global $USER; $sql = $report->querysql; if ($report->runable != 'manual') { list($end, $start) = report_customsql_get_starts($report, $timenow); $sql = report_customsql_substitute_time_tokens($sql, $start, $end); } $sql = report_customsql_substitute_user_token($sql, $USER->id); return $sql; }
public function test_report_customsql_substitute_user_token() { $this->assertEquals('SELECT COUNT(*) FROM oh_quiz_attempts WHERE user = 123', report_customsql_substitute_user_token('SELECT COUNT(*) FROM oh_quiz_attempts ' . 'WHERE user = %%USERID%%', 123)); }