<?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++) {