function output_story($db, $article_id, $preview_only = FALSE) { if (empty($article_id)) { return; } $sql = 'SELECT name, is_published, title, article_text, UNIX_TIMESTAMP(submit_date) as submit_date, UNIX_TIMESTAMP(publish_date) as publish_date FROM cms_articles a JOIN cms_users u ON a.user_id = u.user_id WHERE article_id = ' . $article_id; $result = mysql_query($sql, $db) or die(mysql_error($db)); if ($row = mysql_fetch_assoc($result)) { extract($row); echo '<h2>' . htmlspecialchars($title) . '</h2>'; echo '<p>By: ' . htmlspecialchars($name) . '</p>'; echo '<p>'; if ($is_published) { echo date('F j, Y', $publish_date); } else { echo 'Article is not yet published.'; } echo '</p>'; if ($preview_only) { echo '<p>' . nl2br(htmlspecialchars(trim_body($article_text))) . '</p>'; echo '<p><a href="view_article.php?article_id=' . $article_id . '">Read Full Story</a></p>'; } else { echo '<p>' . nl2br(htmlspecialchars($article_text)) . '</p>'; } } mysql_free_result($result); }
$logic_options = tmpl_draw_select_opt("AND\nOR", "AND\nOR", $search_logic, '', ''); $sort_options = tmpl_draw_select_opt("DESC\nASC", "Descending Order\nAscending Order", $sort_order, '', ''); $TITLE_EXTRA = ': Search For ' . htmlspecialchars($srch); ses_update_status($usr->sid, 'Searching posts'); $page_pager = ''; if ($srch) { if (!($c =& fetch_search_cache($srch, $start, $ppg, $search_logic, $field, $sort_order, $forum_limiter, $total))) { $search_data = '<br /> <table border="0" cellspacing="1" cellpadding="2" class="ContentTable"> <tr class="RowStyleA"><th colspan=2 width="100%" align="center">No Results</th></tr> </table>'; } else { $i = 0; $search_data = ''; while ($r = db_rowobj($c)) { $body = trim_body(read_msg_body($r->foff, $r->length, $r->file_id)); $poster_info = !empty($r->poster_id) ? '<a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=usrinfo&id=' . $r->poster_id . '&' . _rsid . '">' . $r->alias . '</a>' : '' . $GLOBALS['ANON_NICK']; ++$i; $search_data .= '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td class="GenText" width="100%">' . $i . '. <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=' . d_thread_view . '&goto=' . $r->id . '&' . _rsid . '">' . $r->subject . '</a><br />' . $body . '</td><td class="GenText" nowrap><a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=' . t_thread_view . '&frm_id=' . $r->forum_id . '&' . _rsid . '">' . $r->forum_name . '</a></td><td class="GenText" nowrap><font class="DateText">' . strftime("%a, %d %B %Y %H:%M", $r->post_stamp) . '</font> By: ' . $poster_info . '</td></tr>'; } un_register_fps(); $search_data = '<br /> <table border="0" cellspacing="1" cellpadding="2" class="ContentTable"> <tr><th width="100%">Subject</th><th>Forum</th><th nowrap>Posted On</th></tr> ' . $search_data . ' </table>'; $page_pager = tmpl_create_pager($start, $ppg, $total, '/egroupware/fudforum/3814588639/index.php?t=search&srch=' . urlencode($srch) . '&field=' . $field . '&' . _rsid . '&search_logic=' . $search_logic . '&sort_order=' . $sort_order . '&forum_limiter=' . $forum_limiter); } } else { $search_data = ''; }