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>'; }