?> "><?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 }
$faqs_contact_name = $_POST['faqs_contact_name']; $faqs_contact_mail = $_POST['faqs_contact_mail']; $faqs_description = $_POST['faqs_description']; $faqs_answer = $_POST['faqs_answer']; $faqs_url = $_POST['faqs_url']; } else { $faqs = $db->Execute("select p.faqs_id, pd.language_id, pd.faqs_name, pd.faqs_contact_name, pd.faqs_contact_mail,\n pd.faqs_description, pd.faqs_answer, pd.faqs_url, p.faqs_image, p.faqs_date_added, p.faqs_last_modified,\n p.faqs_status, p.faqs_sort_order\n from " . TABLE_FAQS . " p, " . TABLE_FAQS_DESCRIPTION . " pd\n where p.faqs_id = pd.faqs_id\n and p.faqs_id = '" . (int) $_GET['pID'] . "'"); $pInfo = new objectInfo($faq->fields); $faqs_image_name = $pInfo->faqs_image; } $form_action = isset($_GET['pID']) ? 'update_faq' : 'insert_faq'; echo zen_draw_form($form_action, $type_faq_admin_handler, 'fcPath=' . $fcPath . (isset($_GET['faq_type']) ? '&faq_type=' . $_GET['faq_type'] : '') . (isset($_GET['pID']) ? '&pID=' . $_GET['pID'] : '') . '&action=' . $form_action . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'post', 'enctype="multipart/form-data"'); $languages = zen_get_languages(); for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { if (isset($_GET['read']) && $_GET['read'] == 'only') { $pInfo->faqs_name = zen_get_faqs_name($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_contact_name = zen_get_faqs_contact_name($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_contact_mail = zen_get_faqs_contact_mail($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_description = zen_get_faqs_description($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_answer = zen_get_faqs_answer($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_url = zen_get_faqs_url($pInfo->faqs_id, $languages[$i]['id']); } else { $pInfo->faqs_name = zen_db_prepare_input($faqs_name[$languages[$i]['id']]); $pInfo->faqs_contact_name = zen_get_faqs_contact_name($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_contact_mail = zen_get_faqs_contact_mail($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_description = zen_db_prepare_input($faqs_description[$languages[$i]['id']]); $pInfo->faqs_answer = zen_get_faqs_answer($pInfo->faqs_id, $languages[$i]['id']); $pInfo->faqs_url = zen_db_prepare_input($faqs_url[$languages[$i]['id']]); } ?> <table border="0" width="100%" cellspacing="0" cellpadding="2">
function zen_copy_faqs_attributes($faqs_id_from, $faqs_id_to) { global $db; global $messageStack; global $copy_attributes_delete_first, $copy_attributes_duplicates_skipped, $copy_attributes_duplicates_overwrite, $copy_attributes_include_downloads, $copy_attributes_include_filename; // Check for errors in copy request if (!zen_has_faq_attributes($faqs_id_from, 'false') or !zen_faqs_id_valid($faqs_id_to) or $faqs_id_to == $faqs_id_from) { if ($faqs_id_to == $faqs_id_from) { // same faqs_id $messageStack->add_session('<b>WARNING: Cannot copy from Product ID #' . $faqs_id_from . ' to Product ID # ' . $faqs_id_to . ' ... No copy was made' . '</b>', 'caution'); } else { if (!zen_has_faq_attributes($faqs_id_from, 'false')) { // no attributes found to copy $messageStack->add_session('<b>WARNING: No Attributes to copy from Product ID #' . $faqs_id_from . ' for: ' . zen_get_faqs_name($faqs_id_from) . ' ... No copy was made' . '</b>', 'caution'); } else { // invalid faqs_id $messageStack->add_session('<b>WARNING: There is no Product ID #' . $faqs_id_to . ' ... No copy was made' . '</b>', 'caution'); } } } else { // FIX HERE - remove once working // get attributes to copy from // die('UPDATE/IGNORE - Checking Copying from ' . $faqs_id_from . ' to ' . $faqs_id_to . ' Do I delete first? ' . ($copy_attributes_delete_first == '1' ? 'Yes' : 'No') . ' Do I add? ' . ($add_attribute == true ? 'Yes' : 'No') . ' Do I Update? ' . ($update_attribute == true ? 'Yes' : 'No') . ' Do I skip it? ' . ($copy_attributes_duplicates_skipped=='1' ? 'Yes' : 'No') . ' Found attributes in From: ' . $check_duplicate->RecordCount()); if ($copy_attributes_duplicates_skipped == '1' and $check_duplicate->RecordCount() != 0) { // skip it $messageStack->add_session(TEXT_ATTRIBUTE_COPY_SKIPPING . $faqs_copy_from->fields['faqs_attributes_id'] . ' for Products ID#' . $faqs_id_to, 'caution'); } else { if ($add_attribute == true) { } if ($update_attribute == true) { $messageStack->add_session(TEXT_ATTRIBUTE_COPY_UPDATING . $faqs_copy_from->fields['faqs_attributes_id'] . ' for Products ID#' . $faqs_id_to, 'caution'); } $faqs_copy_from->MoveNext(); } // end of faqs attributes while loop } // end of no attributes or other errors }
echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?> </td> </tr> <?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?> <tr> <td class="main"><?php if ($i == 0) { echo TEXT_FAQS_NAME; } ?> </td> <td class="main"><?php echo zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . ' ' . zen_draw_input_field('faqs_name[' . $languages[$i]['id'] . ']', isset($faqs_name[$languages[$i]['id']]) ? stripslashes($faqs_name[$languages[$i]['id']]) : zen_get_faqs_name($pInfo->faqs_id, $languages[$i]['id']), zen_set_field_length(TABLE_FAQS_DESCRIPTION, 'faqs_name')); ?> </td> </tr> <?php } ?> <tr> <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?> </td> </tr> <tr> <td colspan="2"><?php
$new_faqs_query = "select distinct p.faqs_id, p.faqs_image, p.faqs_date_added\n from " . TABLE_FAQS . " p, " . 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_status = '1' " . $display_limit; } $new_faqs = $db->ExecuteRandomMulti($new_faqs_query, MAX_DISPLAY_NEW_FAQS); $row = 0; $col = 0; $list_box_contents = ''; $num_faqs_count = $new_faqs->RecordCount(); // show only when 1 or more if ($num_faqs_count > 0) { if ($num_faqs_count < SHOW_FAQ_INFO_COLUMNS_NEW_FAQS) { $col_width = 100 / $num_faqs_count; } else { $col_width = 100 / SHOW_FAQ_INFO_COLUMNS_NEW_FAQS; } while (!$new_faqs->EOF) { $new_faqs->fields['faqs_name'] = zen_get_faqs_name($new_faqs->fields['faqs_id']); $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($new_faqs->fields['faqs_id']), 'faqs_id=' . $new_faqs->fields['faqs_id']) . '">' . zen_image(DIR_WS_IMAGES . $new_faqs->fields['faqs_image'], $new_faqs->fields['faqs_name'], IMAGE_FAQ_NEW_WIDTH, IMAGE_FAQ_NEW_HEIGHT) . '</a><br /><a href="' . zen_href_link(zen_get_info_faq_page($new_faqs->fields['faqs_id']), 'faqs_id=' . $new_faqs->fields['faqs_id']) . '">' . $new_faqs->fields['faqs_name'] . '</a>'); $col++; if ($col > SHOW_FAQ_INFO_COLUMNS_NEW_FAQS - 1) { $col = 0; $row++; } $new_faqs->MoveNextRandom(); } if ($new_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 = sprintf(TABLE_HEADING_NEW_FAQS, strftime('%B')) . ($faq_category_title != '' ? ' - ' . $faq_category_title : ''); } else { $title = sprintf(TABLE_HEADING_NEW_FAQS, strftime('%B')); }
function zen_get_faqs_image($faq_id, $width = SMALL_IMAGE_WIDTH, $height = SMALL_IMAGE_HEIGHT) { global $db; $sql = "select p.faqs_image from " . TABLE_FAQS . " p where faqs_id='" . $faq_id . "'"; $look_up = $db->Execute($sql); return zen_image(DIR_WS_IMAGES . $look_up->fields['faqs_image'], zen_get_faqs_name($faq_id), $width, $height, 'hspace="5" vspace="5"'); }
$reviews_text = $db->Execute("select r.reviews_read, r.customers_name,\n length(rd.reviews_text) as reviews_text_size\n from " . TABLE_FAQ_REVIEWS . " r, " . TABLE_FAQ_REVIEWS_DESCRIPTION . " rd\n where r.reviews_id = '" . (int) $reviews->fields['reviews_id'] . "'\n and r.reviews_id = rd.reviews_id"); $faqs_image = $db->Execute("select faqs_image\n from " . TABLE_FAQS . "\n where faqs_id = '" . (int) $reviews->fields['faqs_id'] . "'"); $faqs_name = $db->Execute("select faqs_name\n from " . TABLE_FAQS_DESCRIPTION . "\n where faqs_id = '" . (int) $reviews->fields['faqs_id'] . "'\n and language_id = '" . (int) $_SESSION['languages_id'] . "'"); $reviews_average = $db->Execute("select (avg(reviews_rating) / 5 * 100) as average_rating\n from " . TABLE_FAQ_REVIEWS . "\n where faqs_id = '" . (int) $reviews->fields['faqs_id'] . "'"); $review_info = array_merge($reviews_text->fields, $reviews_average->fields, $faqs_name->fields); $rInfo_array = array_merge($reviews->fields, $review_info, $faqs_image->fields); $rInfo = new objectInfo($rInfo_array); } if (isset($rInfo) && is_object($rInfo) && $reviews->fields['reviews_id'] == $rInfo->reviews_id) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_FAQ_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=preview') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_FAQ_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews->fields['reviews_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="' . zen_href_link(FILENAME_FAQ_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews->fields['reviews_id'] . '&action=preview') . '">' . zen_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . zen_get_faqs_name($reviews->fields['faqs_id']); ?> </td> <td class="dataTableContent"><?php echo $reviews->fields['customers_name']; ?> </td> <td class="dataTableContent" align="right"><?php echo zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $reviews->fields['reviews_rating'] . '.gif'); ?> </td> <td class="dataTableContent" align="right"><?php echo zen_date_short($reviews->fields['date_added']); ?> </td> <td class="dataTableContent" align="center">