if ($_GET['page'] > 1) { $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS; } $products_query_raw = "select p.products_id, p.products_ordered, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . SESSION_LANGUAGE_ID . "' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name"; $products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows); $products_query = olc_db_query($products_query_raw); while ($products = olc_db_fetch_array($products_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } ?> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="javascript:<?php echo olc_onclick_link(FILENAME_CATEGORIES, 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . FILENAME_STATS_PRODUCTS_PURCHASED . '?page=' . $_GET['page'], NONSSL); ?> "> <td class="dataTableContent"><?php echo $rows; ?> .</td> <td class="dataTableContent"><?php echo $products['products_name'] . HTML_A_END; ?> </td> <td class="dataTableContent" align="center"><?php echo $products['products_ordered']; ?> </td> </tr>
} elseif (is_numeric($_GET['status'])) { $status = olc_db_prepare_input($_GET['status']); $payments_query_raw = "select p.* , s.affiliate_payment_status_name from " . TABLE_AFFILIATE_PAYMENT . " p , " . TABLE_AFFILIATE_PAYMENT_STATUS . " s where s.affiliate_payment_status_id = '" . olc_db_input($status) . "' and p.affiliate_payment_status = s.affiliate_payment_status_id and s.affiliate_language_id = '" . SESSION_LANGUAGE_ID . "' order by p.affiliate_payment_id DESC"; } else { $payments_query_raw = "select p.* , s.affiliate_payment_status_name from " . TABLE_AFFILIATE_PAYMENT . " p , " . TABLE_AFFILIATE_PAYMENT_STATUS . " s where p.affiliate_payment_status = s.affiliate_payment_status_id and s.affiliate_language_id = '" . SESSION_LANGUAGE_ID . "' order by p.affiliate_payment_id DESC"; } $payments_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $payments_query_raw, $payments_query_numrows); $payments_query = olc_db_query($payments_query_raw); while ($payments = olc_db_fetch_array($payments_query)) { if ((!$_GET['pID'] || $_GET['pID'] == $payments['affiliate_payment_id']) && !$pInfo) { $pInfo = new objectInfo($payments); } if (is_object($pInfo) && $payments['affiliate_payment_id'] == $pInfo->affiliate_payment_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('pID', 'action')) . 'pID=' . $pInfo->affiliate_payment_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('pID')) . 'pID=' . $payments['affiliate_payment_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo HTML_A_START . olc_href_link(FILENAME_AFFILIATE_PAYMENT, olc_get_all_get_params(array('pID', 'action')) . 'pID=' . $pInfo->affiliate_payment_id . '&action=edit') . '">' . olc_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $payments['affiliate_firstname'] . BLANK . $payments['affiliate_lastname']; ?> </td> <td class="dataTableContent" align="right"><?php echo $currencies->format(strip_tags($payments['affiliate_payment'])); ?> </td> <td class="dataTableContent" align="right"><?php echo $currencies->format(strip_tags($payments['affiliate_payment'] + $payments['affiliate_payment_tax'])); ?> </td> <td class="dataTableContent" align="center"><?php
echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $classes_query_raw = "select tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from " . TABLE_TAX_CLASS . " order by tax_class_title"; $classes_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $classes_query_raw, $classes_query_numrows); $classes_query = olc_db_query($classes_query_raw); while ($classes = olc_db_fetch_array($classes_query)) { if ((!$_GET['tID'] || @$_GET['tID'] == $classes['tax_class_id']) && !$tcInfo && substr($_GET['action'], 0, 3) != 'new') { $tcInfo = new objectInfo($classes); } if (is_object($tcInfo) && $classes['tax_class_id'] == $tcInfo->tax_class_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $classes['tax_class_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo $classes['tax_class_title']; ?> </td> <td class="dataTableContent" align="right"><?php if (is_object($tcInfo) && $classes['tax_class_id'] == $tcInfo->tax_class_id) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo HTML_A_START . olc_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $classes['tax_class_id']) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td> </tr>
</tr> <?php $blacklist_query_raw = "select blacklist_id, blacklist_card_number, date_added, last_modified from " . TABLE_BLACKLIST . " order by blacklist_id"; $blacklist_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $blacklist_query_raw, $blacklist_query_numrows); $blacklist_query = olc_db_query($blacklist_query_raw); while ($blacklist = olc_db_fetch_array($blacklist_query)) { if ((!$_GET['bID'] || @$_GET['bID'] == $blacklist['blacklist_id']) && !$bInfo && substr($_GET['action'], 0, 3) != 'new') { $blacklist_numbers_query = olc_db_query("select count(*) as blacklist_count from " . TABLE_BLACKLIST . " where blacklist_id = '" . $blacklist['blacklist_id'] . APOS); $blacklist_numbers = olc_db_fetch_array($blacklist_numbers_query); $bInfo_array = olc_array_merge($blacklist, $blacklist_numbers); $bInfo = new objectInfo($bInfo_array); } if (is_object($bInfo) && $blacklist['blacklist_id'] == $bInfo->blacklist_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_BLACKLIST, 'page=' . $_GET['page'] . '&bID=' . $blacklist['blacklist_id'] . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_BLACKLIST, 'page=' . $_GET['page'] . '&bID=' . $blacklist['blacklist_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo $blacklist['blacklist_card_number']; ?> </td> <td class="dataTableContent" align="right"><?php if (is_object($bInfo) && $blacklist['blacklist_id'] == $bInfo->blacklist_id) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo HTML_A_START . olc_href_link(FILENAME_BLACKLIST, 'page=' . $_GET['page'] . '&bID=' . $blacklist['blacklist_id']) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td> </tr>
$cc_query_raw = "select coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,coupon_expire_date,uses_per_user,uses_per_coupon,restrict_to_products, restrict_to_categories, date_created,date_modified from " . TABLE_COUPONS . " where coupon_type != 'G'"; } $cc_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_query_raw, $cc_query_numrows); $cc_query = olc_db_query($cc_query_raw); while ($cc_list = olc_db_fetch_array($cc_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } if ((!$_GET['cid'] || @$_GET['cid'] == $cc_list['coupon_id']) && !$cInfo) { $cInfo = new objectInfo($cc_list); } if (is_object($cInfo) && $cc_list['coupon_id'] == $cInfo->coupon_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link('coupon_admin.php', olc_get_all_get_params(array('cid', 'action')) . 'cid=' . $cInfo->coupon_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link('coupon_admin.php', olc_get_all_get_params(array('cid', 'action')) . 'cid=' . $cc_list['coupon_id']) . '">' . NEW_LINE; } $coupon_description_query = olc_db_query("select coupon_name from " . TABLE_COUPONS_DESCRIPTION . " where coupon_id = '" . $cc_list['coupon_id'] . "' and language_id = '" . SESSION_LANGUAGE_ID . APOS); $coupon_desc = olc_db_fetch_array($coupon_description_query); ?> <td class="dataTableContent"><?php echo $coupon_desc['coupon_name']; ?> </td> <td class="dataTableContent" align="center"> <?php if ($cc_list['coupon_type'] == 'P') { echo $cc_list['coupon_amount'] . '%'; } elseif ($cc_list['coupon_type'] == 'S') { echo TEXT_FREE_SHIPPING; } else {
<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LAST_PAGE_URL; ?> </td> </tr> <?php $whos_online_query = olc_db_query("select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id from " . TABLE_WHOS_ONLINE); while ($whos_online = olc_db_fetch_array($whos_online_query)) { $time_online = time() - $whos_online['time_entry']; if ((!$_GET['info'] || @$_GET['info'] == $whos_online['session_id']) && !$info) { $info = $whos_online['session_id']; } if ($whos_online['session_id'] == $info) { echo ' <tr class="dataTableRowSelected">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_WHOS_ONLINE, olc_get_all_get_params(array('info', 'action')) . 'info=' . $whos_online['session_id'], NONSSL) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo gmdate('H:i:s', $time_online); ?> </td> <td class="dataTableContent" align="center"><?php echo $whos_online['customer_id']; ?> </td> <td class="dataTableContent"><?php echo $whos_online['full_name']; ?> </td> <td class="dataTableContent" align="center"><?php
} } $module_parameters_class = $module_parameters0 . $class; if ($is_object_mInfo_and_same_class) { if ($module->check() > 0) { $main_content .= ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_MODULES, $module_parameters_class . $action_text . 'edit') . '"> '; } else { $main_content .= ' <tr class="dataTableRowSelected"> '; } } else { $main_content .= ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_MODULES, $module_parameters_class) . '"> '; } $s = $module->sort_order; $s = is_numeric($s) ? $module->sort_order : EMPTY_STRING; $main_content .= ' <td class="dataTableContent">' . $module->title . '</td> <td class="dataTableContent">' . str_replace(PHP, EMPTY_STRING, $file) . '</td> <td class="dataTableContent" align="right">' . $s . HTML_NBSP . '</td> <td class="dataTableContent" align="center"> '; if ($is_object_mInfo_and_same_class) { $main_content .= $icon_arrow; } else { $main_content .= HTML_A_START . olc_href_link(FILENAME_MODULES, $module_parameters_class) . '">' . $icon_info . HTML_A_END; }
echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $countries_query_raw = "select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from " . TABLE_COUNTRIES . " order by countries_name"; $countries_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $countries_query_raw, $countries_query_numrows); $countries_query = olc_db_query($countries_query_raw); while ($countries = olc_db_fetch_array($countries_query)) { if ((!$_GET['cID'] || @$_GET['cID'] == $countries['countries_id']) && !$cInfo && substr($_GET['action'], 0, 3) != 'new') { $cInfo = new objectInfo($countries); } if (is_object($cInfo) && $countries['countries_id'] == $cInfo->countries_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_COUNTRIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->countries_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_COUNTRIES, 'page=' . $_GET['page'] . '&cID=' . $countries['countries_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo $countries['countries_name']; ?> </td> <td class="dataTableContent" align="center" width="40"><?php echo $countries['countries_iso_code_2']; ?> </td> <td class="dataTableContent" align="center" width="40"><?php echo $countries['countries_iso_code_3']; ?> </td> <td class="dataTableContent" align="right"><?php
$zones_query = olc_db_query($zones_query_raw); while ($zones = olc_db_fetch_array($zones_query)) { if ((!$_GET['zID'] || @$_GET['zID'] == $zones['geo_zone_id']) && !$zInfo && substr($_GET['action'], 0, 3) != 'new') { $num_zones_query = olc_db_query("select count(*) as num_zones from " . TABLE_ZONES_TO_GEO_ZONES . " where geo_zone_id = '" . $zones['geo_zone_id'] . "' group by geo_zone_id"); if (olc_db_num_rows($num_zones_query) > 0) { $num_zones = olc_db_fetch_array($num_zones_query); $zones['num_zones'] = $num_zones['num_zones']; } else { $zones['num_zones'] = 0; } $zInfo = new objectInfo($zones); } if (is_object($zInfo) && $zones['geo_zone_id'] == $zInfo->geo_zone_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $zInfo->geo_zone_id . '&action=list') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $zones['geo_zone_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo HTML_A_START . olc_href_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $zones['geo_zone_id'] . '&action=list') . '">' . olc_image(DIR_WS_ICONS . 'folder.gif', ICON_FOLDER) . '</a> ' . $zones['geo_zone_name']; ?> </td> <td class="dataTableContent" align="right"><?php if (is_object($zInfo) && $zones['geo_zone_id'] == $zInfo->geo_zone_id) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo HTML_A_START . olc_href_link(FILENAME_GEO_ZONES, 'zpage=' . $_GET['zpage'] . '&zID=' . $zones['geo_zone_id']) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td> </tr>
$keys_extra[$module_keys[$j]]['description'] = constant($constant_name . '_DESC'); } $keys_extra[$module_keys[$j]]['use_function'] = $key_value['use_function']; $keys_extra[$module_keys[$j]]['set_function'] = $key_value['set_function']; } $module_info['keys'] = $keys_extra; $mInfo = new objectInfo($module_info); } if (is_object($mInfo) && $class == $mInfo->code) { if ($module->check() > 0) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=' . $class . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRowSelected">' . NEW_LINE; } } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=' . $class) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo $module->title; ?> </td> <td class="dataTableContent" align="right"><?php if (is_object($mInfo) && $class == $mInfo->code) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo HTML_A_START . olc_href_link(FILENAME_MODULE_EXPORT, 'set=' . $_GET['set'] . '&module=' . $class) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td> </tr>
<td class="dataTableContent" onclick="javascript:<?php olc_onclick_link(FILENAME_BACKUP, $onclick_link); ?> "><?php echo HTML_A_START . olc_href_link(FILENAME_BACKUP, 'action=download&file=' . $entry) . '">' . olc_image(DIR_WS_ICONS . 'file_download.gif', ICON_FILE_DOWNLOAD) . '</a> ' . $entry; ?> </td> <td class="dataTableContent" align="center" onclick="javascript:<?php echo olc_onclick_link(FILENAME_BACKUP, $onclick_link); ?> "><?php echo date(PHP_DATE_TIME_FORMAT, filemtime(DIR_FS_BACKUP . $entry)); ?> </td> <td class="dataTableContent" align="right" onclick="javascript:<?php echo olc_onclick_link(FILENAME_BACKUP, $onclick_link); ?> "><?php echo number_format(filesize(DIR_FS_BACKUP . $entry)); ?> bytes</td> <td class="dataTableContent" align="right"><?php if (is_object($buInfo) && $entry == $buInfo->file) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo HTML_A_START . olc_href_link(FILENAME_BACKUP, 'file=' . $entry) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td> </tr> <?php
echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $products_vpe_query_raw = "select products_vpe_id, products_vpe_name from " . TABLE_PRODUCTS_VPE . " where language_id = '" . SESSION_LANGUAGE_ID . "' order by products_vpe_id"; $products_vpe_split = new splitPageResults($_GET['page'], '20', $products_vpe_query_raw, $products_vpe_query_numrows); $products_vpe_query = olc_db_query($products_vpe_query_raw); while ($products_vpe = olc_db_fetch_array($products_vpe_query)) { if ((!$oID || $oID == $products_vpe['products_vpe_id']) && !$oInfo && substr($action, 0, 3) != 'new') { $oInfo = new objectInfo($products_vpe); } if (is_object($oInfo) && $products_vpe['products_vpe_id'] == $oInfo->products_vpe_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_PRODUCTS_VPE, 'page=' . $_GET['page'] . '&oID=' . $oInfo->products_vpe_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_PRODUCTS_VPE, 'page=' . $_GET['page'] . '&oID=' . $products_vpe['products_vpe_id']) . '">' . NEW_LINE; } if ($default_products_vpe_id == $products_vpe['products_vpe_id']) { echo ' <td class="dataTableContent"><b>' . $products_vpe['products_vpe_name'] . LPAREN . TEXT_DEFAULT . ')</b></td>' . NEW_LINE; } else { echo ' <td class="dataTableContent">' . $products_vpe['products_vpe_name'] . '</td>' . NEW_LINE; } ?> <td class="dataTableContent" align="right"><?php if (is_object($oInfo) && $products_vpe['products_vpe_id'] == $oInfo->products_vpe_id) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', EMPTY_STRING); } else { echo HTML_A_START . olc_href_link(FILENAME_PRODUCTS_VPE, 'page=' . $_GET['page'] . '&oID=' . $products_vpe['products_vpe_id']) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td>
</tr> <?php $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_SPECIALS . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . SESSION_LANGUAGE_ID . "' and p.products_id = s.products_id order by pd.products_name"; $specials_split = new splitPageResults($page, MAX_DISPLAY_SEARCH_RESULTS, $specials_query_raw, $specials_query_numrows); $specials_query = olc_db_query($specials_query_raw); while ($specials = olc_db_fetch_array($specials_query)) { if ((!$sID || $sID == $specials['specials_id']) && !$sInfo) { $products_query = olc_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . $specials['products_id'] . APOS); $products = olc_db_fetch_array($products_query); $sInfo_array = olc_array_merge($specials, $products); $sInfo = new objectInfo($sInfo_array); } if (is_object($sInfo) && $specials['specials_id'] == $sInfo->specials_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_SPECIALS, 'page=' . $page . '&sID=' . $sInfo->specials_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_SPECIALS, 'page=' . $page . '&sID=' . $specials['specials_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo $specials['products_name']; ?> </td> <td class="dataTableContent" align="right"><span class="oldPrice"> <?php echo olc_format_price($specials[$products_price_text], 1, 1); ?> </span> <span class="specialPrice"> <?php echo olc_format_price($specials['specials_new_products_price'], 1, 1); ?>
$customer_info = olc_array_merge($country, $info, $reviews); $cInfo_array = olc_array_merge($customers, $customer_info); $cInfo = new objectInfo($cInfo_array); } $tr_classname = 'dataTableRow'; $td_classname = 'dataTableContent'; if (is_object($cInfo) && $customers['customers_id'] == $cInfo->customers_id) { $params = $cInfo->customers_id . '&action=edit'; $tr_classname .= 'Selected'; $td_classname .= 'Selected'; $linktext = olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', EMPTY_STRING); } else { $params = $customers['customers_id']; $linktext = HTML_A_START . olc_href_link(FILENAME_CUSTOMERS, olc_get_all_get_params(array('cID')) . 'cID=' . $customers['customers_id']) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } $display_text = '<tr class="' . $tr_classname . '" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_CUSTOMERS, olc_get_all_get_params(array('cID', 'action')) . 'cID=' . $params) . '">' . NEW_LINE; $COL_START = '<td class="' . $td_classname . '">'; $COL_END = '</td>'; $display_text = $display_text . $COL_START; if ($customers['account_type'] == 1) { $display_text .= TEXT_GUEST; } else { $display_text .= TEXT_ACCOUNT; } $display_text .= $COL_START . $customers['customers_lastname'] . $COL_END . $COL_START . $customers['customers_firstname'] . $COL_END . $COL_START . $customers_statuses_array[$customers['customers_status']]['text'] . LPAREN . $customers['customers_status'] . RPAREN . $COL_END . $COL_START . olc_date_short($info['date_account_created']) . $COL_END . '<td class="' . $td_classname . '" align="right">' . $linktext . ' </td>'; echo $display_text; ?> </tr> <?php } ?>
} $orders_query_raw = str_replace(HASH, $orders_query_raw, $orders_query_raw0); $page = $_GET['page']; $orders_split = new splitPageResults($page, MAX_DISPLAY_SEARCH_RESULTS, $orders_query_raw, $orders_query_numrows); $orders_query = olc_db_query($orders_query_raw); while ($orders = olc_db_fetch_array($orders_query)) { if ((!$oID || $oID == $orders['orders_id']) && !$oInfo) { $oInfo = new objectInfo($orders); } if (is_object($oInfo) && $orders['orders_id'] == $oInfo->orders_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_ORDERS, olc_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . NEW_LINE; $selected = 'Selected"'; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_ORDERS, olc_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . NEW_LINE; $selected = '"'; } if (is_object($oInfo) && $orders['orders_id'] == $oInfo->orders_id) { $link = olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', EMPTY_STRING); } else { $link = HTML_A_START . olc_href_link(FILENAME_ORDERS, olc_get_all_get_params(array('oID')) . 'oID=' . $orders['orders_id']) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } $selected_right = $selected . ' align="right">'; $selected_center = $selected . ' align="center">'; $col_end = '</td>'; echo ' <td class="dataTableContent' . $selected . '><a href="' . olc_href_link(FILENAME_ORDERS, olc_get_all_get_params(array('oID', 'action')) . 'oID=' . $orders['orders_id'] . '&action=edit') . '">' . olc_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . $orders['customers_name'] . '</td> <td class="dataTableContent' . $selected_right . $orders['orders_id'] . $col_end . ' <td class="dataTableContent' . $selected_right . strip_tags($orders['order_total']) . $col_end . ' <td class="dataTableContent' . $selected . $selected_center . olc_datetime_short($orders['date_purchased']) . $col_end . '
$banners_query_raw = "select banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from " . TABLE_BANNERS . " order by banners_title, banners_group"; $banners_split = new splitPageResults($page, MAX_DISPLAY_SEARCH_RESULTS, $banners_query_raw, $banners_query_numrows); $banners_query = olc_db_query($banners_query_raw); while ($banners = olc_db_fetch_array($banners_query)) { $info_query = olc_db_query("select sum(banners_shown) as banners_shown, sum(banners_clicked) as banners_clicked from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . $banners['banners_id'] . APOS); $info = olc_db_fetch_array($info_query); if ((!$bID || $bID == $banners['banners_id']) && !$bInfo && substr($action, 0, 3) != 'new') { $bInfo_array = olc_array_merge($banners, $info); $bInfo = new objectInfo($bInfo_array); } $banners_shown = $info['banners_shown'] != EMPTY_STRING ? $info['banners_shown'] : '0'; $banners_clicked = $info['banners_clicked'] != EMPTY_STRING ? $info['banners_clicked'] : '0'; if (is_object($bInfo) && $banners['banners_id'] == $bInfo->banners_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_BANNER_STATISTICS, $page_parameter . '&bID=' . $bInfo->banners_id) . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_BANNER_MANAGER, $page_parameter . '&bID=' . $banners['banners_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo '<a href="javascript:popupImageWindow(\'' . FILENAME_POPUP_IMAGE . '?banner=' . $banners['banners_id'] . '\')">' . olc_image(DIR_WS_IMAGES . 'icon_popup.gif', 'View Banner') . '</a> ' . $banners['banners_title']; ?> </td> <td class="dataTableContent" align="right"><?php echo $banners['banners_group']; ?> </td> <td class="dataTableContent" align="right"><?php echo $banners_shown . ' / ' . $banners_clicked; ?> </td> <td class="dataTableContent" align="right">
echo TABLE_HEADING_ACTION; ?> </td> </tr> <?php $shipping_status_query_raw = "select shipping_status_id, shipping_status_name,shipping_status_image from " . TABLE_SHIPPING_STATUS . " where language_id = '" . SESSION_LANGUAGE_ID . "' order by shipping_status_id"; $shipping_status_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $shipping_status_query_raw, $shipping_status_query_numrows); $shipping_status_query = olc_db_query($shipping_status_query_raw); while ($shipping_status = olc_db_fetch_array($shipping_status_query)) { if ((!$_GET['oID'] || $_GET['oID'] == $shipping_status['shipping_status_id']) && !$oInfo && substr($_GET['action'], 0, 3) != 'new') { $oInfo = new objectInfo($shipping_status); } if (is_object($oInfo) && $shipping_status['shipping_status_id'] == $oInfo->shipping_status_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $oInfo->shipping_status_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_SHIPPING_STATUS, 'page=' . $_GET['page'] . '&oID=' . $shipping_status['shipping_status_id']) . '">' . NEW_LINE; } if (DEFAULT_SHIPPING_STATUS_ID == $shipping_status['shipping_status_id']) { echo '<td class="dataTableContent" align="left">'; if ($shipping_status['shipping_status_image'] != '') { echo olc_image(DIR_WS_ICONS . $shipping_status['shipping_status_image'], IMAGE_ICON_INFO); } echo '</td>'; echo ' <td class="dataTableContent"><b>' . $shipping_status['shipping_status_name'] . LPAREN . TEXT_DEFAULT . ')</b></td>' . NEW_LINE; } else { echo '<td class="dataTableContent" align="left">'; if ($shipping_status['shipping_status_image'] != '') { echo olc_image(DIR_WS_ICONS . $shipping_status['shipping_status_image'], IMAGE_ICON_INFO); } echo '</td>'; echo ' <td class="dataTableContent">' . $shipping_status['shipping_status_name'] . '</td>' . NEW_LINE;
$manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name"; $manufacturers_split = new splitPageResults($page, MAX_DISPLAY_SEARCH_RESULTS, $manufacturers_query_raw, $manufacturers_query_numrows); $manufacturers_query = olc_db_query($manufacturers_query_raw); $not_is_new = substr($action, 0, 3) != 'new'; while ($manufacturers = olc_db_fetch_array($manufacturers_query)) { $manufacturers_id = $manufacturers['manufacturers_id']; if ((!$mID || $mID == $manufacturers_id) && !$mInfo && $not_is_new) { $manufacturer_products_query = olc_db_query("select count(*) as products_count from " . TABLE_PRODUCTS . " where manufacturers_id = '" . $manufacturers_id . APOS); $manufacturer_products = olc_db_fetch_array($manufacturer_products_query); $mInfo_array = olc_array_merge($manufacturers, $manufacturer_products); $mInfo = new objectInfo($mInfo_array); } if (is_object($mInfo) && $manufacturers_id == $mInfo->manufacturers_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_MANUFACTURERS, $page_parameter . '&mID=' . $manufacturers_id . '&action=edit') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_MANUFACTURERS, $page_parameter . '&mID=' . $manufacturers_id) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo $manufacturers['manufacturers_name']; ?> </td> <td class="dataTableContent" align="right"><?php if (is_object($mInfo) && $manufacturers_id == $mInfo->manufacturers_id) { echo olc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif'); } else { echo HTML_A_START . olc_href_link(FILENAME_MANUFACTURERS, $page_parameter . '&mID=' . $manufacturers_id) . '">' . olc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . HTML_A_END; } ?> </td> </tr>
$cPath = $products['categories_id']; } if ((!$pID && !$cID || @$pID == $products['products_id']) && !$pInfo && !$cInfo && $not_is_new) { // find out the rating average from customer reviews $reviews_query = olc_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = " . $products['products_id']); $reviews = olc_db_fetch_array($reviews_query); $pInfo_array = olc_array_merge($products, $reviews); $pInfo = new objectInfo($pInfo_array); } $is_selected = is_object($pInfo) && $products['products_id'] == $pInfo->products_id; $params = 'cPath=' . $cPath . '&pID=' . $products['products_id']; if ($is_selected) { $selected = 'Selected'; //echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" >' . NEW_LINE; echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_CATEGORIES, $params . '&action=new_product') . '">' . NEW_LINE; } else { $selected = EMPTY_STRING; echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" >' . NEW_LINE; } $td_start = '<td class="dataTableContent' . $selected . '" '; $products_name = stripslashes($products['products_name']); $products_name = str_replace('\\', EMPTY_STRING, $products_name); echo $td_start . 'width="1">' . $products['products_sort'] . '</td>' . $td_start . '><a href="' . olc_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products['products_id']) . '">' . olc_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . ' </a><a href="' . olc_href_link(FILENAME_CATEGORIES, $params) . '">' . $products_name . '</a> </td>'; // check Produkt and attributes stock if ($cPath != EMPTY_STRING) { echo check_stock($products['products_id']);
<table border="0" cellspacing="1" cellpadding="2" bgcolor="#999999"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" width="75">Product id</td> <td class="dataTableHeadingContent">Quickfind code</td> <td class="dataTableHeadingContent">Product Name</td> <td class="dataTableHeadingContent" nowrap="nowrap">Current Cross-Sells</td> <td class="dataTableHeadingContent" colspan=2 nowrap="nowrap" align=center>Update cross-sells</td> </tr> <?php $num_of_products = sizeof($PRODUCTS_id); for ($i = 0; $i < $num_of_products; $i++) { /* now we will query the DB for existing related items */ $query = "select b.products_name, a.xsell_id, c.products_model from " . TABLE_PRODUCTS_XSELL . " a," . TABLE_PRODUCTS_DESCRIPTION . " b," . TABLE_PRODUCTS . " c WHERE b.products_id = a.xsell_id and a.products_id ='" . $PRODUCTS_id[$i] . "' and b.products_id = c.products_id ORDER BY sort_order"; list($related_items, $xsell_ids, $product_models) = general_db_conct($query); echo "\n\t<tr onmouseover=\"cOn(this); this.style.cursor='pointer'; this.style.cursor='hand';\" onmouseout=\"cOut(this);\" onclick=\"javascript:" . olc_onclick_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i] . '&categories_id=' . $CATEGORIES_id . '&manufacturers_id=' . $MANUFACTURES_id, NONSSL) . "\">"; $td = "<td class=\"dataTableContent\" valign=\"top\"> "; $td_end = " </td>\n"; echo $td . $PRODUCTS_id[$i] . $td_end; echo $td . $PRODUCTS_model[$i] . $td_end; echo $td . $PRODUCTS_name[$i] . $td_end; if ($related_items) { echo "<td class=\"dataTableContent\"><ol>"; for ($j = 0; $j < count($related_items); $j++) { echo '<li><strong>' . $product_models[$j] . '</strong> ' . $related_items[$j] . '</li>'; } echo "</ol></td>\n"; } else { echo "<td class=\"dataTableContent\">--</td>\n"; } echo '<td class="dataTableContent" valign="top"> <a href="' . olc_href_link(FILENAME_XSELL_PRODUCTS, 'add_related_product_ID=' . $PRODUCTS_id[$i] . '&categories_id=' . $CATEGORIES_id . '&manufacturers_id=' . $MANUFACTURES_id, NONSSL) . '">Edit</a> </td>';
if ((!$lID || @$lID == $languages_id) && !$lInfo && $not_is_new) { $lInfo = new objectInfo($languages); } $lang_name = $languages['name']; $is_delete = true; $is_default_language = DEFAULT_LANGUAGE == $languages['code']; if (is_object($lInfo) && $languages_id == $lInfo->languages_id) { $content = ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_LANGUAGES, $l_params . '&action=edit'); $params = $l_params; } else { $content = ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_LANGUAGES, $l_params); } $content .= '">' . NEW_LINE; if ($is_default_language) { $content .= ' <td class="dataTableContent"><b>' . $lang_name . LPAREN . TEXT_DEFAULT . RPAREN . HTML_B_END; } else { $content .= ' <td class="dataTableContent">' . $lang_name; } echo $content . '</td>' . NEW_LINE; ?> <td class="dataTableContent"><?php echo $languages['code']; ?> </td> <td class="dataTableContent" align="right"> <?php
$customers_status_show_price_tax_array = array(array('id' => '0', 'text' => ENTRY_NO), array('id' => '1', 'text' => ENTRY_YES)); $customers_status_discount_attributes_array = array(array('id' => '0', 'text' => ENTRY_NO), array('id' => '1', 'text' => ENTRY_YES)); $customers_status_add_tax_ot_array = array(array('id' => '0', 'text' => ENTRY_NO), array('id' => '1', 'text' => ENTRY_YES)); $customers_fsk18_array = array(array('id' => '0', 'text' => ENTRY_NO), array('id' => '1', 'text' => ENTRY_YES)); $customers_fsk18_display_array = array(array('id' => '0', 'text' => ENTRY_NO), array('id' => '1', 'text' => ENTRY_YES)); $customers_status_query_raw = "select * from " . TABLE_CUSTOMERS_STATUS . " where language_id = '" . SESSION_LANGUAGE_ID . "' order by customers_status_id"; $customers_status_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_status_query_raw, $customers_status_query_numrows); $customers_status_query = olc_db_query($customers_status_query_raw); while ($customers_status = olc_db_fetch_array($customers_status_query)) { if ((!$_GET['cID'] || $_GET['cID'] == $customers_status['customers_status_id']) && !$cInfo && substr($_GET['action'], 0, 3) != 'new') { $cInfo = new objectInfo($customers_status); } if (is_object($cInfo) && $customers_status['customers_status_id'] == $cInfo->customers_status_id) { echo '<tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_CUSTOMERS_STATUS, 'page=' . $_GET['page'] . '&cID=' . $cInfo->customers_status_id . '&action=edit') . '">' . NEW_LINE; } else { echo '<tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_CUSTOMERS_STATUS, 'page=' . $_GET['page'] . '&cID=' . $customers_status['customers_status_id']) . '">' . NEW_LINE; } echo '<td class="dataTableContent" align="left">'; if ($customers_status['customers_status_image'] != '') { echo olc_image(DIR_WS_ICONS . $customers_status['customers_status_image'], IMAGE_ICON_INFO); } echo '</td>'; echo '<td class="dataTableContent" align="left">'; echo olc_get_status_users($customers_status['customers_status_id']); echo '</td>'; if ($customers_status['customers_status_id'] == DEFAULT_CUSTOMERS_STATUS_ID) { echo '<td class="dataTableContent" align="left"><b>' . $customers_status['customers_status_name']; echo LPAREN . TEXT_DEFAULT . RPAREN; } else { echo '<td class="dataTableContent" align="left">' . $customers_status['customers_status_name']; }
$Pos1 = strpos($RequestURI, AMP, $Pos + strlen(PRODUCTS_MODEL)); //Find parameter terminator if ($Pos1 == false) { $Pos1 = strlen($RequestURI); } $ProductsModelString = substr($RequestURI, $Pos, $Pos1 - $Pos); $_Server['REQUEST_URI'] = str_replace($ProductsModelString, PRODUCTS_ID . EQUAL . $products_id, $RequestURI); } $chCounter_visible = 0; $chCounter_page_title = PRODUCTS_PAGE . $products_name; include FILENAME_CHCOUNTER; } //} } // W. Kaiser chCounter inclusion $pdf_link = olc_onclick_link(FILENAME_PRINT_PRODUCT_INFO, 'pop_up=true&' . $par_prod_id); if (INCLUDE_PDF_INVOICE) { $pdf_link = str_replace(strtolower(HTTPS), strtolower(HTTP), $pdf_link); } $products_print_link = 'javascript:ShowInfo(\'' . $pdf_link . '\', \'\')"'; $products_print = olc_image(DIR_WS_ICONS . 'print.gif', PRINT_DATASHEET, 16, 16, $style . $products_print_link); $info_smarty->assign('PRODUCTS_PRINT', $products_print); $info_smarty->assign('PRODUCTS_PRINT_LINK', $products_print_link); $info_smarty->assign('PRODUCTS_PRINT_PDF', $pdf_print); /* $info_smarty->assign('PRODUCTS_CHEAPLY', HTML_A_START. olc_href_link(FILENAME_CHEAPLY_SEE, 'pID='.$products_id).'">'.TEXT_PRODUCTS_CHEAPLY.HTML_A_END); // $info_smarty->assign('ASK_PRODUCT_QUESTION', '<img src="templates/'.CURRENT_TEMPLATE.'/buttons/'.$_SESSION['language'].'/ask_a_question.gif" style="cursor:hand" onclick="javascript:window.open(\''.olc_href_link('ask_a_question.php?products_id='.$product->data['products_id']).'\', \'popup\', \'toolbar=0, width=630, height=550\')" alt="" />'); $info_smarty->assign('ASK_PRODUCT_QUESTION_LINK', '"#" onclick="javascript:window.open(\''.olc_href_link(FILENAME_ASK_PRODUCT_QUESTION, 'products_id='.$product->data['products_id']).'\', \'popup\', \'toolbar=0, width=630, height=550\'); return false";'); */
$reviews_text_query = olc_db_query("select r.reviews_read, r.customers_name, length(rd.reviews_text) as reviews_text_size from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.reviews_id = '" . $reviews['reviews_id'] . "' and r.reviews_id = rd.reviews_id"); $reviews_text = olc_db_fetch_array($reviews_text_query); $products_image_query = olc_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . $reviews['products_id'] . APOS); $products_image = olc_db_fetch_array($products_image_query); $products_name_query = olc_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $reviews['products_id'] . "' and language_id = '" . SESSION_LANGUAGE_ID . APOS); $products_name = olc_db_fetch_array($products_name_query); $reviews_average_query = olc_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . $reviews['products_id'] . APOS); $reviews_average = olc_db_fetch_array($reviews_average_query); $review_info = olc_array_merge($reviews_text, $reviews_average, $products_name); $rInfo_array = olc_array_merge($reviews, $review_info, $products_image); $rInfo = new objectInfo($rInfo_array); } if (is_object($rInfo) && $reviews['reviews_id'] == $rInfo->reviews_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=preview') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo HTML_A_START . olc_href_link(FILENAME_REVIEWS, 'page=' . $_GET['page'] . '&rID=' . $reviews['reviews_id'] . '&action=preview') . '">' . olc_image(DIR_WS_ICONS . 'preview.gif', ICON_PREVIEW) . '</a> ' . olc_get_products_name($reviews['products_id']); ?> </td> <td class="dataTableContent" align="right"><?php echo olc_image(DIR_WS_CATALOG_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif'); ?> </td> <td class="dataTableContent" align="right"><?php echo olc_date_short($reviews['date_added']); ?> </td> <td class="dataTableContent" align="right"><?php
define('PRODUCTS_MODEL', 'products_model'); $cPath = 'cPath'; $equal = '='; // save current session data $old_session = $_SESSION; $index_php = 'index.php'; $get_info = $_GET['info']; $date_format = 'H:i:s'; $SQLSelect_Category = SELECT . "categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '#' and language_id='" . SESSION_LANGUAGE_ID . APOS; $SQLWhere = " where categories_id = '#' and language_id='" . SESSION_LANGUAGE_ID . APOS; $sessions_in_db = STORE_SESSIONS == 'mysql'; $session_path = olc_session_save_path() . '/sess_'; $whos_online_row0 = ' onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_WHOS_ONLINE, olc_get_all_get_params(array('info', 'action')) . 'info=#', NONSSL); $whos_online_row1 = ' <tr id="#" style="display:inline;" class="dataTableRow"'; $selected = false; $new_visitors = EMPTY_STRING; $cart_total = 0; while ($whos_online = olc_db_fetch_array($whos_online_query)) { $session_id = $whos_online['session_id']; $time_online = $current_time - $whos_online['time_entry']; if ($is_periodic) { $info = $session_id; } else { if (!$get_info || !$info && $get_info == $session_id) { $info = $session_id; } $selected = $session_id == $info;
$affiliate_banners_query_raw = "select * from " . TABLE_AFFILIATE_BANNERS . " order by affiliate_banners_title, affiliate_banners_group"; $affiliate_banners_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $affiliate_banners_query_raw, $affiliate_banners_query_numrows); $affiliate_banners_query = olc_db_query($affiliate_banners_query_raw); while ($affiliate_banners = olc_db_fetch_array($affiliate_banners_query)) { $info_query = olc_db_query("select sum(affiliate_banners_shown) as affiliate_banners_shown, sum(affiliate_banners_clicks) as affiliate_banners_clicks from " . TABLE_AFFILIATE_BANNERS_HISTORY . " where affiliate_banners_id = '" . $affiliate_banners['affiliate_banners_id'] . APOS); $info = olc_db_fetch_array($info_query); if ((!$_GET['abID'] || $_GET['abID'] == $affiliate_banners['affiliate_banners_id']) && !$abInfo && substr($_GET['action'], 0, 3) != 'new') { $abInfo_array = array_merge($affiliate_banners, $info); $abInfo = new objectInfo($abInfo_array); } $affiliate_banners_shown = $info['affiliate_banners_shown'] != '' ? $info['affiliate_banners_shown'] : '0'; $affiliate_banners_clicked = $info['affiliate_banners_clicks'] != '' ? $info['affiliate_banners_clicks'] : '0'; if (is_object($abInfo) && $affiliate_banners['affiliate_banners_id'] == $abInfo->affiliate_banners_id) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_AFFILIATE_BANNERS, 'abID=' . $abInfo->affiliate_banners_id . '&action=new') . '">' . NEW_LINE; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_AFFILIATE_BANNERS, 'abID=' . $affiliate_banners['affiliate_banners_id']) . '">' . NEW_LINE; } ?> <td class="dataTableContent"><?php echo '<a href="javascript:popupImageWindow(\'' . FILENAME_AFFILIATE_POPUP_IMAGE . '?banner=' . $affiliate_banners['affiliate_banners_id'] . '\')">' . olc_image(DIR_WS_IMAGES . 'icon_popup.gif', ICON_PREVIEW) . '</a> ' . $affiliate_banners['affiliate_banners_title']; ?> </td> <td class="dataTableContent" align="right"><?php if ($affiliate_banners['affiliate_products_id'] > 0) { echo $affiliate_banners['affiliate_products_id']; } else { echo HTML_NBSP; } ?> </td> <td class="dataTableContent" align="right"><?php
} $customers_query_raw = "select c.customers_firstname, c.customers_lastname, sum(op.final_price) as ordersum from " . TABLE_CUSTOMERS . " c, " . TABLE_ORDERS_PRODUCTS . " op, " . TABLE_ORDERS . " o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC"; $customers_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_query_raw, $customers_query_numrows); // fix counted customers $customers_query_numrows = olc_db_query("select customers_id from " . TABLE_ORDERS . " group by customers_id"); $customers_query_numrows = olc_db_num_rows($customers_query_numrows); $customers_query = olc_db_query($customers_query_raw); while ($customers = olc_db_fetch_array($customers_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } ?> <tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="javascript:<?php echo olc_onclick_link(FILENAME_CUSTOMERS, 'search=' . $customers['customers_lastname'], NONSSL); ?> "> <td class="dataTableContent"><?php echo $rows; ?> .</td> <td class="dataTableContent"><?php echo HTML_A_START . olc_href_link(FILENAME_CUSTOMERS, 'search=' . $customers['customers_lastname'], NONSSL) . '">' . $customers['customers_firstname'] . BLANK . $customers['customers_lastname'] . HTML_A_END; ?> </td> <td class="dataTableContent" align="right"><?php echo $currencies->format($customers['ordersum']); ?> </td> </tr>