searches_user_contributions

searches_user_contributions   db   user_id   purpose

Returns empty list if purpose is not "site_admin". Otherwise a triplet including all the searches typed on this site while this user was logged in or was referred in.

Source code:

    if { $purpose != "site_admin" } {
	return [list]
    }
    set selection [ns_db select $db "select query_date, 
decode(subsection, null, search_engine_name, subsection) location, 
decode(n_results, null, '', ' - ' || n_results || ' result(s)') n_results_string, query_string
from query_strings
where user_id = $user_id
order by query_date asc
"]

    set items ""
    while {[ns_db getrow $db $selection]} {
	set_variables_after_query
	append items "<li>$query_date:</a>
<a href=\"/admin/searches/by-word?query_string=[ns_urlencode $query_string]\"><b>$query_string</b></a>
<a href=\"/admin/searches/by-location?location=[ns_urlencode $location]\">($location)</a>
$n_results_string
"
    }
    if [empty_string_p $items] {
	return [list]
    } else {
	return [list 0 "Searches" "<ul>\n\n$items\n\n</ul>"]
    }