1, 'text' => TEXT_PENDING_APPROVAL); $status_list[] = array('id' => 2, 'text' => TEXT_APPROVED); if (zen_not_null($action)) { switch ($action) { case 'setflag': zen_set_tags_status($_GET['ID'], $_GET['flag']); zen_redirect(zen_href_link(FILENAME_ADMIN_TAGS, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'ID=' . $_GET['ID'], 'NONSSL')); break; case 'update': $id = zen_db_prepare_input($_GET['rID']); $reviews_rating = zen_db_prepare_input($_POST['reviews_rating']); $reviews_text = zen_db_prepare_input($_POST['reviews_text']); $db->Execute("update " . TABLE_REVIEWS . " set reviews_rating = '" . zen_db_input($reviews_rating) . "', last_modified = now() where id = '" . (int)$id . "'"); $db->Execute("update " . TABLE_REVIEWS_DESCRIPTION . " set reviews_text = '" . zen_db_input($reviews_text) . "' where id = '" . (int)$id . "'"); zen_redirect(zen_href_link(FILENAME_ADMIN_TAGS, 'page=' . $_GET['page'] . '&rID=' . $id)); break; case 'deleteconfirm': // demo active test if (zen_admin_demo()) { $_GET['action']= ''; $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution'); zen_redirect(zen_href_link(FILENAME_ADMIN_TAGS, 'page=' . $_GET['page'])); } $id = zen_db_prepare_input($_GET['ID']); $db->Execute("delete from product_tag where id = '" . (int)$id . "'"); zen_redirect(zen_href_link(FILENAME_ADMIN_TAGS, 'page=' . $_GET['page'])); break; } } ?> >

id; } ?> tags ' . zen_image_button('button_reset.gif', IMAGE_RESET) . '  '; } echo HEADING_TITLE_SEARCH_DETAIL . ' ' . zen_draw_input_field('search') . zen_hide_session_id(); if (isset($_GET['search']) && zen_not_null($_GET['search'])) { $keywords = zen_db_input(zen_db_prepare_input($_GET['search'])); echo ' ' . TEXT_INFO_SEARCH_DETAIL_FILTER . $keywords; } ?> products_name; ?> customers_name; ?> date_added); ?> products_image, $rInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"'); ?> reviews_text, 15))); ?>  reviews_rating . '.gif', sprintf(TEXT_OF_5_STARS, $rInfo->reviews_rating)); ?> [reviews_rating); ?>] id . '&action=edit') . '">' . zen_image_button('button_back.gif', IMAGE_BACK) . ' ' . zen_image_submit('button_update.gif', IMAGE_UPDATE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''; ?> ' . zen_image_button('button_back.gif', IMAGE_BACK) . ''; ?> 'Delete'); $contents = array('form' => zen_draw_form('reviews', FILENAME_ADMIN_TAGS, 'page=' . $_GET['page'] . '&ID=' . $rInfo->id . '&action=deleteconfirm')); $contents[] = array('text' => ' ' . $rInfo->products_name . ''); $contents[] = array('text' => ' Tags:' . $rInfo->products_tag . ''); $contents[] = array('align' => 'center', 'text' => ' ' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; default: if (isset($rInfo) && is_object($rInfo)) { $heading[] = array('text' => '' . $rInfo->products_name . ''); $contents[] = array('align' => 'center', 'text' => '' . zen_image_button('button_delete.gif', IMAGE_DELETE) . ''); $contents[] = array('text' => ' Tags:'. $rInfo->products_tag); } break; } if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) { echo ' ' . "\n"; } ?> Execute($sql); while (!$reviews->EOF) { if ((!isset($_GET['ID']) || (isset($_GET['ID']) && ($_GET['ID'] == $reviews->fields['id']))) && !isset($rInfo)) { $products_name = $db->Execute("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$reviews->fields['products_id'] . "' and language_id = '" . (int)$_SESSION['languages_id'] . "'"); $review_info = array_merge($products_name->fields); $rInfo_array = array_merge($reviews->fields,$review_info); $rInfo = new objectInfo($rInfo_array); } if (isset($rInfo) && is_object($rInfo) && ($reviews->fields['id'] == $rInfo->id) ) { echo ' ' . "\n"; } else { echo ' ' . "\n"; } ?> MoveNext(); } ?> Products Name tags stats   fields['id'] . '&action=preview') . '">' . zen_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . ' ' . zen_get_products_name($reviews->fields['products_id']); ?> fields['products_tag']; ?> fields['tag_status'] == '1') { echo '' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . ''; } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . ''; } ?> fields['id'] == $rInfo->id) ) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?>  display_count($reviews_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?> display_links($reviews_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?> ' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo '