?>
"><?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">
