function generate_rows($q)
{
global $db;
$rows = array();
$USERURL = new URL('userview');
for ($row = 0; $row < $q->rows(); $row++) {
$email = $q->field($row, 'email');
$criteria = $q->field($row, 'criteria');
$SEARCHENGINE = new SEARCHENGINE($criteria);
$r = $db->query("SELECT user_id,firstname,lastname FROM users WHERE email = '" . mysql_escape_string($email) . "'");
if ($r->rows() > 0) {
$user_id = $r->field(0, 'user_id');
$USERURL->insert(array('u' => $user_id));
$name = '<a href="' . $USERURL->generate() . '">' . $r->field(0, 'firstname') . ' ' . $r->field(0, 'lastname') . '</a>';
} else {
$name = $email;
}
$created = $q->field($row, 'created');
if ($created == '0000-00-00 00:00:00') {
$created = ' ';
}
$rows[] = array($name, $SEARCHENGINE->query_description_long(), $created);
}
return $rows;
}
private function get_sidebar_links()
{
global $DATA, $SEARCHENGINE, $this_page;
$links = array();
$links['rss'] = $DATA->page_metadata($this_page, 'rss');
if ($SEARCHENGINE) {
$links['email'] = '/alert/?' . ($this->searchstring ? 'alertsearch=' . urlencode($this->searchstring) : '');
$links['email_desc'] = $SEARCHENGINE->query_description_long();
}
$filter_ss = $this->searchstring;
$section = get_http_var('section');
if (preg_match('#\\s*section:([a-z]*)#', $filter_ss, $m)) {
$section = $m[1];
$filter_ss = preg_replace("#\\s*section:{$section}#", '', $filter_ss);
}
if ($section && $filter_ss) {
$search_engine = new \SEARCHENGINE($filter_ss);
$links['email_section'] = $links['email'];
$links['email_desc_section'] = $links['email_desc'];
$links['email'] = '/alert/?' . ($filter_ss ? 'alertsearch=' . urlencode($filter_ss) : '');
$links['email_desc'] = $search_engine->query_description_long();
}
return $links;
}
# XXX global $searchstring is horrible
global $SEARCHENGINE, $searchstring;
if ($SEARCHENGINE) {
$email_link = '/alert/?' . ($searchstring ? 'alertsearch=' . urlencode($searchstring) : '');
$email_text = $SEARCHENGINE->query_description_long();
}
$filter_ss = $searchstring;
$section = get_http_var('section');
if (preg_match('#\\s*section:([a-z]*)#', $filter_ss, $m)) {
$section = $m[1];
$filter_ss = preg_replace("#\\s*section:{$section}#", '', $filter_ss);
}
if ($section) {
$search_engine = new SEARCHENGINE($filter_ss);
$email_link_anywhere = '/alert/?' . ($filter_ss ? 'alertsearch=' . urlencode($filter_ss) : '');
$email_text_anywhere = $search_engine->query_description_long();
}
if ($email_text || $rss) {
$this->block_start(array('title' => "Being alerted to new search results"));
echo '<ul id="search_links">';
if ($email_text) {
if ($email_text_anywhere) {
echo '<li id="search_links_email"><a href="', $email_link_anywhere, '">Subscribe to an email alert</a> for ', $email_text_anywhere;
echo ' <br><small>(or just <a href="', $email_link, '">subscribe</a> for ', $email_text, ')</small></li>';
} else {
echo '<li id="search_links_email"><a href="', $email_link, '">Subscribe to an email alert</a> for ', $email_text, '</li>';
}
}
if ($rss) {
echo '<li id="search_links_rss">Or <a href="/', $rss, '">get an RSS feed</a></li>';
}
