<?php
if ($messageStack->size('review_text') > 0) {
?>
<tr>
<td class="main" colspan="2"><?php
echo $messageStack->output('review_text');
?>
</td>
</tr>
<?php
}
?>
<tr>
<td align="left" class="smallText">
<?php
echo '<a href="' . zen_href_link(zen_get_info_faq_page($_GET['faqs_id']), zen_get_all_get_params()) . '">' . TEXT_FAQ_INFO . '</a>' . '<br /><br />' . SUB_TITLE_FROM, zen_output_string_protected($customer->fields['customers_firstname'] . ' ' . $customer->fields['customers_lastname']) . '<br />' . SUB_TITLE_REVIEW;
?>
</td>
<td align="center" valign="top" class="smallText">
<?php
if (zen_not_null($faqs_image)) {
require DIR_WS_MODULES . 'pages/' . $current_page_base . '/main_template_vars_images.php';
}
?>
</td>
</tr>
<tr>
<td class="main" colspan="2"><?php
echo zen_draw_textarea_field('review_text', 'soft', 60, 15);
?>
</td>
<?php
if ($_GET['faqs_id']) {
?>
<tr class="centerboxheading">
<td colspan="2" class="centerboxheading">
<?php
$display_faqs_name = '<a href="' . zen_href_link(zen_get_info_faq_page($listing->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $_GET['faqs_id']) . '"> ' . $current_faq_name . '</a>';
echo $display_faqs_name;
?>
</td>
</tr>
<tr>
<td colspan="2" class="plainbox-description">
<?php
$display_faqs_description = stripslashes(zen_trunc_string($current_faq_description, 150, '<a href="' . zen_href_link(zen_get_info_faq_page($listing->fields['faqs_id']), 'faqs_id=' . $_GET['faqs_id']) . '"> ' . MORE_INFO_TEXT . '</a>'));
echo $display_faqs_description;
?>
</td>
</tr>
<?php
}
if ($listing_split->number_of_rows > 0 && (PREV_NEXT_FAQ_BAR_LOCATION == '2' || PREV_NEXT_FAQ_BAR_LOCATION == '3')) {
?>
<tr>
<td class="pageresults"><?php
echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_FAQS);
?>
</td>
<td class="pageresults" align="right"><?php
echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'x', 'y')));
?>
<tr>
<td class="pageresults"><?php
echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS);
?>
</td>
<td align="right" class="pageresults"><?php
echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'main_page')));
?>
</td>
</tr>
<?php
}
?>
<tr>
<td class="main" colspan="2"><?php
echo zen_draw_separator(DIR_WS_TEMPLATE_IMAGES . OTHER_IMAGE_SILVER_SEPARATOR, '100%', '1');
?>
</td>
</tr>
<tr>
<td class="main"><?php
echo '<a href="' . zen_href_link(zen_get_info_faq_page($_GET['faqs_id']), zen_get_all_get_params()) . '">' . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>';
?>
</td>
<td class="main" align="right"><?php
echo '<a href="' . zen_href_link(FILENAME_FAQ_REVIEWS_WRITE, zen_get_all_get_params()) . '">' . zen_image_button(BUTTON_IMAGE_WRITE_REVIEW, BUTTON_WRITE_REVIEW_ALT) . '</a>';
?>
</td>
</tr>
</table>
?>
"><?php
echo substr(zen_get_faqs_name($previous, $_SESSION['languages_id']), 0, 15) . '...';
?>
</a></li>
<?php
}
?>
<?php
if ($position + 1 == $counter) {
?>
<li class="fr"><?php
echo TEXT_NO_NEXT_PAGE;
?>
</li>
<?php
} else {
?>
<li class="fr"><a class="u" href="<?php
echo zen_href_link(zen_get_info_faq_page($next_item), 'fcPath=' . $fcPath . '&faqs_id=' . $next_item);
?>
"> <?php
echo substr(zen_get_faqs_name($next_item, $_SESSION['languages_id']), 0, 15) . '...';
?>
</a></li>
<?php
}
?>
</ul>
<?php
}
// $Id: faq_manager.php 001 2005-03-27 dave@open-operations.com
//
if (isset($_GET['faqs_id'])) {
$_GET['faqs_id'] = ereg_replace('[^0-9a-f:]', '', $_GET['faqs_id']);
}
if (isset($_GET['fcPath'])) {
$_GET['fcPath'] = ereg_replace('[^0-9_]', '', $_GET['fcPath']);
}
while (list($key, $value) = each($_GET)) {
$_GET[$key] = ereg_replace('[<>]', '', $value);
}
// validate faqs_id for search engines and bookmarks, etc.
if (isset($_GET['faqs_id']) and $_SESSION['check_valid'] != 'false') {
$check_valid = zen_faqs_id_valid($_GET['faqs_id']);
if (!$check_valid) {
$_GET['main_page'] = zen_get_info_faq_page($_GET['faqs_id']);
// do not recheck redirect
$_SESSION['check_valid'] = 'false';
zen_redirect(zen_href_link($_GET['main_page'], 'faqs_id=' . $_GET['faqs_id']));
}
} else {
$_SESSION['check_valid'] = 'true';
}
// calculate faq_category path
if (isset($_GET['fcPath'])) {
$fcPath = $_GET['fcPath'];
} elseif (isset($_GET['faqs_id']) && !zen_check_url_get_terms()) {
$fcPath = zen_get_faq_path($_GET['faqs_id']);
} else {
if (SHOW_FAQ_CATEGORIES_ALWAYS == '1' && !zen_check_url_get_terms()) {
$show_welcome = 'true';
$featured_faqs_query = "select distinct p.faqs_id, p.faqs_image, pd.faqs_name\n from " . TABLE_FAQS . " p\n left join " . TABLE_FEATURED . " f on p.faqs_id = f.faqs_id\n left join " . TABLE_FAQS_DESCRIPTION . " pd on p.faqs_id = pd.faqs_id, " . TABLE_FAQS_TO_FAQ_CATEGORIES . " p2c, " . TABLE_FAQ_CATEGORIES . " c\n where p.faqs_id = p2c.faqs_id\n and p2c.faq_categories_id = c.faq_categories_id\n and c.parent_id = '" . (int) $new_faqs_faq_category_id . "'\n and p.faqs_id = f.faqs_id and p.faqs_id = pd.faqs_id and p.faqs_status = '1' and f.status = '1' and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
}
$featured_faqs = $db->ExecuteRandomMulti($featured_faqs_query, MAX_DISPLAY_SEARCH_RESULTS_FEATURED);
$row = 0;
$col = 0;
$list_box_contents = '';
$num_faqs_count = $featured_faqs->RecordCount();
// show only when 1 or more
if ($num_faqs_count > 0) {
if ($num_faqs_count < SHOW_FAQ_INFO_COLUMNS_FEATURED_FAQS) {
$col_width = 100 / $num_faqs_count;
} else {
$col_width = 100 / SHOW_FAQ_INFO_COLUMNS_FEATURED_FAQS;
}
while (!$featured_faqs->EOF) {
$list_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="' . $col_width . '%" valign="top"', 'text' => '<a href="' . zen_href_link(zen_get_info_faq_page($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '">' . zen_image(DIR_WS_IMAGES . $featured_faqs->fields['faqs_image'], $featured_faqs->fields['faqs_name'], IMAGE_FEATURED_FAQS_LISTING_WIDTH, IMAGE_FEATURED_FAQS_LISTING_HEIGHT) . '</a><br /><a href="' . zen_href_link(zen_get_info_faq_page($featured_faqs->fields['faqs_id']), 'faqs_id=' . $featured_faqs->fields['faqs_id']) . '">' . $featured_faqs->fields['faqs_name'] . '</a>');
$col++;
if ($col > SHOW_FAQ_INFO_COLUMNS_FEATURED_FAQS - 1) {
$col = 0;
$row++;
}
$featured_faqs->MoveNextRandom();
}
if ($featured_faqs->RecordCount() > 0) {
if (isset($new_faqs_faq_category_id)) {
$faq_category_title = zen_get_faq_categories_name((int) $new_faqs_faq_category_id);
$title = $title . ($faq_category_title != '' ? ' - ' . $faq_category_title : '');
} else {
$title = TABLE_HEADING_FEATURED_FAQS;
}
require $template->get_template_dir('tpl_modules_featured_faqs.php', DIR_WS_TEMPLATE, $current_page_base, 'templates') . '/tpl_modules_featured_faqs.php';
$category_displayed = $faqs_all->fields['faq_categories_name'];
echo '<h3>' . $category_displayed . '</h3>';
}
echo '<div class="margin_t">';
if (FAQ_ALL_LIST_NAME != '0') {
$display_faqs_name = '<a class="u" href="' . zen_href_link(zen_get_info_faq_page($faqs_all->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_all->fields['faqs_id']) . '">' . $faqs_all->fields['faqs_name'] . '</a>' . str_repeat('<br clear="all" />', substr(FAQ_ALL_LIST_NAME, 3, 1));
} else {
$display_faqs_name = '';
}
$link = '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_all->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_all->fields['faqs_id']) . '">' . MORE_INFO_TEXT . '</a>';
$the_button = $link;
$faqs_link = '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_all->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_all->fields['faqs_id']) . '">' . MORE_INFO_TEXT . '</a>';
if (FAQ_ALL_LIST_DESCRIPTION != '0') {
$disp_text = zen_get_faqs_description($faqs_all->fields['faqs_id']);
$disp_text = zen_clean_html($disp_text);
$display_faqs_description = stripslashes(zen_trunc_string($disp_text, 150, '<a href="' . zen_href_link(zen_get_info_faq_page($faqs_all->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faqs_all->fields['faqs_id']) . '"> ' . MORE_INFO_TEXT . '</a>'));
} else {
$display_faqs_description = '';
}
echo '<h4 class="margin_t bg_help">' . $display_faqs_name . '</h4>';
if (FAQ_ALL_LIST_DESCRIPTION != 0 && $current_faq_category_id != 0) {
echo '<ul>' . $display_faqs_description . '</ul>';
}
echo '</div>';
$faqs_all->MoveNext();
}
} else {
echo '<div class="error_box">' . TEXT_NO_ALL_FAQS . '</div>';
}
?>
?>
</td>
</tr>
<tr>
<td class="main" colspan="2"><?php
echo zen_draw_separator(DIR_WS_TEMPLATE_IMAGES . OTHER_IMAGE_SILVER_SEPARATOR, '100%', '1');
?>
</td>
</tr>
<tr>
<td colspan="2" align="left" class="smallText">
<?php
// later make link only show when more than 1
?>
<?php
echo '<a href="' . zen_href_link(zen_get_info_faq_page($_GET['faqs_id']), zen_get_all_get_params()) . '">' . TEXT_FAQ_INFO . '</a>';
echo $reviews_counter > 1 ? ' | ' . '<a href="' . zen_href_link(FILENAME_FAQ_REVIEWS, zen_get_all_get_params()) . '">' . TEXT_REVIEW_ADDITIONAL . '</a>' : '';
?>
</td>
</tr>
<tr>
<td class="main"><span class="greetUser"><?php
echo sprintf(TEXT_REVIEW_BY, zen_output_string_protected($review_info->fields['customers_name']));
?>
</span></td>
<td class="smallText" align="right"><?php
echo sprintf(TEXT_REVIEW_DATE_ADDED, zen_date_short($review_info->fields['date_added']));
?>
</td>
</tr>
<tr>
$email_body .= '';
$html_msg['EMAIL_MESSAGE_HTML'] = '';
}
$email_body .= sprintf(EMAIL_TEXT_LINK, zen_href_link(zen_get_info_faq_page($_GET['faqs_id']), 'faqs_id=' . $_GET['faqs_id']), '', false) . "\n\n" . sprintf(EMAIL_TEXT_SIGNATURE, STORE_NAME . "\n" . HTTP_SERVER . DIR_WS_CATALOG . "\n");
$html_msg['EMAIL_TEXT_HEADER'] = EMAIL_TEXT_HEADER;
$html_msg['EMAIL_FAQ_LINK'] = sprintf(str_replace('\\n\\n', '<br />', EMAIL_TEXT_LINK), '<a href="' . zen_href_link(FILENAME_FAQ_INFO, 'faqs_id=' . $_GET['faqs_id']) . '">' . $faq_info->fields['faqs_name'] . '</a>', '', false);
$html_msg['EMAIL_TEXT_SIGNATURE'] = sprintf(str_replace('\\n', '', EMAIL_TEXT_SIGNATURE), '');
// include disclaimer
$email_body .= "\n\n" . EMAIL_ADVISORY . "\n\n";
//send the email
zen_mail($to_name, $to_email_address, $email_subject, $email_body, $from_name, $from_email_address, $html_msg, 'tell_a_friend');
// send additional emails
if (SEND_EXTRA_TELL_A_FRIEND_EMAILS_TO_STATUS == '1' and SEND_EXTRA_TELL_A_FRIEND_EMAILS_TO != '') {
if ($_SESSION['customer_id']) {
$account_query = "select customers_firstname, customers_lastname, customers_email_address\n from " . TABLE_CUSTOMERS . "\n where customers_id = '" . (int) $_SESSION['customer_id'] . "'";
$account = $db->Execute($account_query);
}
$extra_info = email_collect_extra_info($from_name, $from_email_address, $account->fields['customers_firstname'] . ' ' . $account->fields['customers_lastname'], $account->fields['customers_email_address']);
$html_msg['EXTRA_INFO'] = $extra_info['HTML'];
zen_mail('', SEND_EXTRA_TELL_A_FRIEND_EMAILS_TO, SEND_EXTRA_TELL_A_FRIEND_EMAILS_TO_SUBJECT . ' ' . $email_subject, $email_body . $extra_info['TEXT'], STORE_NAME, EMAIL_FROM, $html_msg, 'tell_a_friend_extra');
}
$messageStack->add_session('header', sprintf(TEXT_EMAIL_SUCCESSFUL_SENT, $faq_info->fields['faqs_name'], zen_output_string_protected($to_name)), 'success');
zen_redirect(zen_href_link(zen_get_info_faq_page($_GET['faqs_id']), 'faqs_id=' . $_GET['faqs_id']));
}
} elseif ($_SESSION['customer_id']) {
$account_query = "select customers_firstname, customers_lastname, customers_email_address\n from " . TABLE_CUSTOMERS . "\n where customers_id = '" . (int) $_SESSION['customer_id'] . "'";
$account = $db->Execute($account_query);
$from_name = $account->fields['customers_firstname'] . ' ' . $account->fields['customers_lastname'];
$from_email_address = $account->fields['customers_email_address'];
}
$breadcrumb->add(NAVBAR_TITLE);
</tr>
<tr>
<td class="plainBoxHeading" colspan="2"><?php
echo FORM_TITLE_FRIEND_MESSAGE;
?>
</td>
</tr>
<tr>
<td class="main" colspan="2"><?php
echo zen_draw_textarea_field('message', 'soft', 40, 8);
?>
</td>
</tr>
<tr>
<td class="main"><?php
echo '<a href="' . zen_href_link(zen_get_info_faq_page($_GET['faqs_id']), 'faqs_id=' . $_GET['faqs_id']) . '">' . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_ADD_ADDRESS_ALT) . '</a>';
?>
</td>
<td align="right"><?php
echo zen_image_submit(BUTTON_IMAGE_SEND, BUTTON_SEND_ALT);
?>
</td>
</tr>
<tr>
<td colspan="2" class="main" height="10px"></td>
</tr>
<tr>
<td colspan="2" class="main"><?php
echo EMAIL_ADVISORY_INCLUDED_WARNING . str_replace('-----', '', EMAIL_ADVISORY);
?>
</td>
function zen_get_faq_in_category($cat_id)
{
global $db, $fcPath, $_GET;
$faq_in_category_String = '';
$faq_in_category_sql = "SELECT f.`faqs_id`, fd.`faqs_name` FROM faqs f, faqs_description fd, faqs_to_faq_categories ft WHERE fd.faqs_id=f.faqs_id AND ft.faqs_id=f.faqs_id AND f.`faqs_status` = 1 AND fd.language_id = " . (int) $_SESSION['languages_id'] . " AND faq_categories_id = " . $cat_id;
$faq_in_category = $db->Execute($faq_in_category_sql);
if ($faq_in_category->RecordCount() > 0) {
while (!$faq_in_category->EOF) {
if (isset($_GET['faqs_id'])) {
if ($faq_in_category->fields['faqs_id'] == $_GET['faqs_id']) {
$class = ' class="red"';
} else {
$class = '';
}
}
$faq_in_category_String .= '<li><a ' . $class . ' href="' . zen_href_link(zen_get_info_faq_page($faq_in_category->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $faq_in_category->fields['faqs_id']) . '" >' . $faq_in_category->fields['faqs_name'] . '</a></li>';
$faq_in_category->MoveNext();
}
}
return $faq_in_category_String;
}
$tworow = $db->Execute($tworow_query);
if ($tworow->RecordCount() > 0) {
while (!$tworow->EOF) {
$rowcontent_query = "SELECT fd.`faqs_name`, f.`faqs_id` \n\t\t FROM faqs f, faqs_to_faq_categories ft, faqs_description fd\n WHERE ft.faqs_id=f.faqs_id \n\t\t\t\t\t\t\t and fd.language_id = " . (int) $_SESSION['languages_id'] . " ";
if (isset($_GET['q'])) {
$rowcontent_query .= "AND fd.`faqs_name` LIKE '%{$_GET['q']}%' ";
}
$rowcontent_query .= "AND f.`faqs_status` =1 \n AND fd.faqs_id=f.faqs_id \n AND ft.faq_categories_id = '" . $tworow->fields['faq_categories_id'] . "' LIMIT 5";
$rowcontent = $db->Execute($rowcontent_query);
echo '<ul class="chapter_nav line_120 fl bg_box_gray allborder margin_t">';
echo '<h3 class="in_1em line_30px">' . $tworow->fields['faq_categories_name'] . '</h3>';
echo '<div class="pad_10px">';
echo '<ul class="red_arrow_list">';
if ($rowcontent->RecordCount() > 0) {
while (!$rowcontent->EOF) {
echo '<li><a href="' . zen_href_link(zen_get_info_faq_page($rowcontent->fields['faqs_id']), 'faqs_id=' . $rowcontent->fields['faqs_id']) . '">' . $rowcontent->fields['faqs_name'] . '</a></li>';
$rowcontent->MoveNext();
}
} else {
echo '<div class="caution_box">' . (isset($_GET['q']) ? TEXT_NO_SEARCH_RESULT : TEXT_NO_ALL_FAQS) . '</div>';
}
echo '</ul><a title="" href="' . zen_href_link(FILENAME_FAQS_ALL, 'fcPath=' . $tworow->fields['faq_categories_id']) . '" class="fr u" style="margin-bottom:5px;">More >></a></div></ul>';
$tworow->MoveNext();
}
} else {
echo '<div class="caution_box">' . TEXT_NO_ALL_FAQS . '</div>';
}
?>
</div>
<br class="clear"/>
}
?>
</ul>
</div>
<?php
}
if ($latestArticles->RecordCount() > 0) {
?>
<h2 class="border_b margin_t clear"><?php
echo TEXT_LATEST_ARTICLES;
?>
</h2>
<ul class="red_arrow_list pad_10px">
<?php
while (!$latestArticles->EOF) {
echo '<li><a href="' . zen_href_link(zen_get_info_faq_page($latestArticles->fields['faqs_id']), 'fcPath=' . $fcPath . '&faqs_id=' . $latestArticles->fields['faqs_id']) . '">' . $latestArticles->fields['faqs_name'] . '</a></li>';
$latestArticles->MoveNext();
}
?>
</ul>
<?php
}
?>
</div>
</div>
<script language="javascript" type="text/javascript"><!--
function hs(tab) {
var tabs = tab.parentNode.getElementsByTagName('li');
for (var i = 0; i < tabs.length; i++) {
