OpenAuction Pro - 20140221 1.5.6.1 2.4.1 www.opencartcooladdons.com    Note Option selection is not applicable in Auctions, please write in the Product Description instead e.g. color, size, etc.
'; $_['text_auction_add_label'] = 'Auction This Product'; $_['text_auction_del_label'] = 'Delete This Auction'; $_['text_auction_new_auction'] = 'New Auction'; $_['text_auction_getstarted'] = 'Getting started...'; $_['text_auction_goinggoing'] = 'Going... Going...'; $_['text_auction_bid'] = 'bid'; $_['text_auction_bids'] = 'bids'; $_['text_auction_starting_in'] = 'Starting in'; $_['text_auction_left'] = 'left'; ]]> * Auction:
Give it a name!'; $_['entry_auction_quantity'] = '* Reserved Quantity:
Quantity auto-deducts from Data > Quantity (if Subtract = Yes)'; $_['entry_auction_starting'] = '* Start Date/Time:
Auction becomes available for bidding from this time onwards'; $_['entry_auction_ending'] = '* End Date/Time:
Original end time'; $_['entry_auction_startprice'] = '* Starting Price:
Base price on the total reserved quantity'; $_['entry_auction_resrvprice'] = 'Reserve Price:
Minimum acceptable amount to be considered as won'; $_['entry_auction_buyprice'] = 'Buyout Price:
Immediate sale price if this amount is reached'; $_['entry_auction_mincrement'] = '* Minimum Increment per Bid:
Minimum increment from the last highest bid'; $_['entry_auction_autobid'] = '(Pro only) Allow Auto-Bidding:
Allow customers to set auto-bidding on with a limit while away from keyboard, works very well with Auto-Extension'; ]]> Cannot delete product: Product is attached to %s auction(s) with live bids!'; $_['error_auction_prod_enable'] = '    Error Unable to save Auction(s): Data > Status is not enabled!
'; $_['error_auction_stock_minus'] = '    Error Unable to save Auction(s): Data > Quantity must not be negative!
'; $_['error_auction_deletefail'] = '    Error Unable to delete Auction: Auction has already started!
'; $_['error_auction_updatefail'] = '    Error Unable to update Auction: Auction has already started!
'; $_['error_auction_name'] = 'Auction Name must be greater than %s and lesser than %s characters!'; $_['error_auction_quantity'] = 'Reserved Quantity must be more than zero!'; $_['error_auction_starting'] = 'Start Date/Time must be a valid date/time and not earlier than now or later than %s to %s hour(s)!'; $_['error_auction_ending'] = 'End Date/Time must be a valid date/time and between %s and %s hour(s) later than the Start Date/Time!'; $_['error_auction_startprice'] = 'Starting Price must be more than zero and not more than %s!'; $_['error_auction_rsrvprice'] = 'Reserve Price must not be lesser than the Starting Price and not more than %s!'; $_['error_auction_buyprice'] = 'Buyout Price must not be lesser than the Starting Price or Reserve Price and not more than %s!'; $_['error_auction_mincrement'] = 'Minimum Increment per Bid must be more than zero and not more than %s!'; $_['modal_auction_confirm'] = 'Confirmation'; $_['modal_auction_warning'] = 'Warning'; $_['modal_auction_add_confirm'] = 'Creating an auction will temporarily disable normal sales on the product until this auction is over! (stacks with other Auctions)

Confirm proceed with auction creation?'; $_['modal_auction_del_confirm'] = 'Auction is starting soon! Are you sure you want to delete it?'; $_['modal_auction_add_prd_chk'] = 'Cannot create new auction: Product is not enabled!

Product status = /%s/ (must be enabled!)

Check Data > Status'; $_['modal_auction_add_stk_chk'] = 'Cannot create new auction: Product is out of stock!

Product stock = /%s/ (minimum 1 required!)

Check Data > Quantity'; $_['modal_auction_chstock_chk'] = 'Product stock is not sufficient! Lower reserved quantity or

Check Data > Quantity

Reverting to previous reserved quantity...'; $_['modal_auction_chstock_min'] = 'Reserved quantity cannot be lesser than 1!

Reverting to previous reserved quantity...'; ]]> ]]> ]]> ]]> ]]> ]]> $auction) { ?>
]]> &filter_auction_name=' + encodeURIComponent(request.term), dataType: 'json', success: function(json) { response($.map(json, function(item) { return { label: item.auction_name, value: item.product_id } })); } }); }, select: function(event, ui) { $('input[name=\'filter_auction_name\']').val(ui.item.label); return false; }, focus: function(event, ui) { return false; } }); ]]> ]]> ]]> ]]>
 <?php echo $text_auction_add_label; ?>
/> /> /> /> /> />
/> <?php echo $language['name']; ?>
onfocus="trackAuctionRsvQty(this.value);" onchange="changeAuctionRsvQty(this, this.value);" />
class="datetime" />
class="datetime" />
/>
/>
/>
/>
/> /> /> />
]]> '); ]]> ]]> ]]> request->get['filter_price'])) { ]]> request->get['filter_auction_name'])) { $url .= '&filter_auction_name=' . urlencode(html_entity_decode($this->request->get['filter_auction_name'], ENT_QUOTES, 'UTF-8')); } ]]> request->get['filter_price'])) { ]]> request->get['filter_auction_name'])) { $filter_auction_name = $this->request->get['filter_auction_name']; } else { $filter_auction_name = null; } ]]> $filter_price, ]]> $filter_auction_name, ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } ]]> model_catalog_product->getTotalProducts($data); ]]> data['auction_ids'] = array(); ]]> data['products'][] = array( ]]> model_catalog_product->getProductAuctions($result['product_id'], $auction_status_ids); foreach ($product_auctions as $product_auction) { $auctions[] = array( 'auction_id' => (int)$product_auction['auction_id'], 'auction_name' => strlen(stripslashes($product_auction['auction_name'])) > 20 ? substr(stripslashes($product_auction['auction_name']), 0, 20) . ' ...' : stripslashes($product_auction['auction_name']), 'reserved_quantity' => (int)$product_auction['reserved_quantity'], 'starting_time' => (int)$product_auction['starting_time'], 'total_no_of_bid' => (int)$product_auction['total_no_of_bid'], 'real_ending_time' => (int)$product_auction['real_ending_time'], 'auction_status_id' => (int)$product_auction['auction_status_id'] ); $this->data['auction_ids'][] = (int)$product_auction['auction_id']; } ]]> $result['price'], ]]> $auctions, ]]> data['column_action'] = $this->language->get('column_action'); ]]> data['column_auctions'] = $this->language->get('column_auctions'); $this->data['text_day'] = $this->language->get('text_day'); $this->data['text_hour'] = $this->language->get('text_hour'); $this->data['text_minute'] = $this->language->get('text_minute'); $this->data['text_second'] = $this->language->get('text_second'); $this->data['text_auction_no_active'] = $this->language->get('text_auction_no_active'); $this->load->model('localisation/auction_status'); $auction_statuses = $this->model_localisation_auction_status->getAuctionStatuses(); $this->data['text_auction_statuses'] = array(); $this->data['auction_status_ids'] = array(); foreach ($auction_status_ids as $key => $value) { foreach ($auction_statuses as $auction_status) { if ($auction_status['auction_status_id'] == $value) { $this->data['text_auction_statuses'][$key] = $auction_status['name']; $this->data['auction_status_ids'][$key] = $value; } } } $this->data['text_auction_getstarted'] = $this->language->get('text_auction_getstarted'); $this->data['text_auction_goinggoing'] = $this->language->get('text_auction_goinggoing'); $this->data['text_auction_bid'] = $this->language->get('text_auction_bid'); $this->data['text_auction_bids'] = $this->language->get('text_auction_bids'); $this->data['text_auction_starting_in'] = $this->language->get('text_auction_starting_in'); $this->data['text_auction_left'] = $this->language->get('text_auction_left'); ]]> data['sort_price'] = $this->url->link('catalog/product', 'token=' . $this->session->data['token'] . '&sort=p.price' . $url, 'SSL'); ]]> data['sort_total_auctions'] = $this->url->link('catalog/product', 'token=' . $this->session->data['token'] . '&sort=total_auctions' . $url, 'SSL'); ]]> data['filter_price'] = $filter_price; ]]> data['filter_auction_name'] = $filter_auction_name; ]]> request->get['filter_name']) || isset($this->request->get['filter_model']) || isset($this->request->get['filter_category_id'])) { ]]> request->get['filter_name']) || isset($this->request->get['filter_model']) || isset($this->request->get['filter_category_id']) || isset($this->request->get['filter_auction_name'])) { ]]> request->get['limit'])) { ]]> request->get['filter_auction_name'])) { $filter_auction_name = $this->request->get['filter_auction_name']; } else { $filter_auction_name = ''; } ]]> $limit ]]> $filter_auction_name, ]]> $option_data, ]]> strip_tags(html_entity_decode($auction_name, ENT_QUOTES, 'UTF-8')), ]]> session->data['success'])) { ]]> error['product_delete'])) { $this->data['error_product_deletefail'] = $this->error['product_delete']; } else { $this->data['error_product_deletefail'] = array(); } ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if (isset($this->request->post['selected'])) { foreach ($this->request->post['selected'] as $product_id) { $total_auctions = (int)$this->model_catalog_product->getTotalProductBiddedAuctions($product_id, $auction_status_ids); if ($total_auctions) { $this->error['product_delete'][$product_id] = sprintf($this->language->get('error_product_deletefail'), $total_auctions); } } } ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } ]]> data['tab_design'] = $this->language->get('tab_design'); ]]> data['tab_auction'] = $this->language->get('tab_auction'); $this->data['text_day'] = $this->language->get('text_day'); $this->data['text_hour'] = $this->language->get('text_hour'); $this->data['text_minute'] = $this->language->get('text_minute'); $this->data['text_second'] = $this->language->get('text_second'); $this->data['text_ok'] = $this->language->get('text_ok'); $this->load->model('localisation/auction_status'); $auction_statuses = $this->model_localisation_auction_status->getAuctionStatuses(); $this->data['text_auction_statuses'] = array(); $this->data['auction_status_ids'] = array(); foreach ($auction_status_ids as $key => $value) { foreach ($auction_statuses as $auction_status) { if ($auction_status['auction_status_id'] == $value) { $this->data['text_auction_statuses'][$key] = $auction_status['name']; $this->data['auction_status_ids'][$key] = $value; } } } if (!is_null($this->config->get('config_auction_auto_bidding'))) { $this->data['auto_bidding'] = (int)$this->config->get('config_auction_auto_bidding'); } else { $this->data['auto_bidding'] = 1; } if (!is_null($this->config->get('config_auction_normal_sales'))) { $this->data['normal_sales'] = (int)$this->config->get('config_auction_normal_sales'); } else { $this->data['normal_sales'] = 0; } $this->data['text_auction_getstarted'] = $this->language->get('text_auction_getstarted'); $this->data['text_auction_goinggoing'] = $this->language->get('text_auction_goinggoing'); $this->data['text_auction_bid'] = $this->language->get('text_auction_bid'); $this->data['text_auction_bids'] = $this->language->get('text_auction_bids'); $this->data['text_auction_starting_in'] = $this->language->get('text_auction_starting_in'); $this->data['text_auction_left'] = $this->language->get('text_auction_left'); $this->data['text_auction_notes'] = $this->language->get('text_auction_notes'); $this->data['text_auction_add_label'] = $this->language->get('text_auction_add_label'); $this->data['text_auction_del_label'] = $this->language->get('text_auction_del_label'); $this->data['text_auction_new_auction'] = $this->language->get('text_auction_new_auction'); $this->data['entry_auction_name'] = $this->language->get('entry_auction_name'); $this->data['entry_auction_quantity'] = $this->language->get('entry_auction_quantity'); $this->data['entry_auction_starting'] = $this->language->get('entry_auction_starting'); $this->data['entry_auction_ending'] = $this->language->get('entry_auction_ending'); $this->data['entry_auction_startprice'] = $this->language->get('entry_auction_startprice'); $this->data['entry_auction_resrvprice'] = $this->language->get('entry_auction_resrvprice'); $this->data['entry_auction_buyprice'] = $this->language->get('entry_auction_buyprice'); $this->data['entry_auction_mincrement'] = $this->language->get('entry_auction_mincrement'); $this->data['entry_auction_autobid'] = $this->language->get('entry_auction_autobid'); $this->data['modal_auction_confirm'] = $this->language->get('modal_auction_confirm'); $this->data['modal_auction_warning'] = $this->language->get('modal_auction_warning'); $this->data['modal_auction_add_confirm'] = $this->language->get('modal_auction_add_confirm'); $this->data['modal_auction_del_confirm'] = $this->language->get('modal_auction_del_confirm'); $this->data['modal_auction_add_prd_chk'] = $this->language->get('modal_auction_add_prd_chk'); $this->data['modal_auction_add_stk_chk'] = $this->language->get('modal_auction_add_stk_chk'); $this->data['modal_auction_chstock_chk'] = $this->language->get('modal_auction_chstock_chk'); $this->data['modal_auction_chstock_min'] = $this->language->get('modal_auction_chstock_min'); ]]> error['date_available'])) { ]]> error['auction_error'])) { $this->data['error_auction_array'] = $this->error['auction_error']; } else { $this->data['error_auction_array'] = array(); } if (isset($this->error['product_status'])) { $this->data['error_auction_prod_enable'] = $this->error['product_status']; } else { $this->data['error_auction_prod_enable'] = ''; } if (isset($this->error['product_stock'])) { $this->data['error_auction_stock_minus'] = $this->error['product_stock']; } else { $this->data['error_auction_stock_minus'] = ''; } if (isset($this->error['auction_delete'])) { $this->data['error_auction_deletefail'] = $this->error['auction_delete']; } else { $this->data['error_auction_deletefail'] = array(); } if (isset($this->error['auction_update'])) { $this->data['error_auction_updatefail'] = $this->error['auction_update']; } else { $this->data['error_auction_updatefail'] = array(); } if (isset($this->error['auction_name'])) { $this->data['error_auction_name'] = $this->error['auction_name']; } else { $this->data['error_auction_name'] = array(); } if (isset($this->error['reserved_quantity'])) { $this->data['error_auction_quantity'] = $this->error['reserved_quantity']; } else { $this->data['error_auction_quantity'] = array(); } if (isset($this->error['starting_time'])) { $this->data['error_auction_starting'] = $this->error['starting_time']; } else { $this->data['error_auction_starting'] = array(); } if (isset($this->error['ending_time'])) { $this->data['error_auction_ending'] = $this->error['ending_time']; } else { $this->data['error_auction_ending'] = array(); } if (isset($this->error['starting_price'])) { $this->data['error_auction_startprice'] = $this->error['starting_price']; } else { $this->data['error_auction_startprice'] = array(); } if (isset($this->error['reserve_price'])) { $this->data['error_auction_rsrvprice'] = $this->error['reserve_price']; } else { $this->data['error_auction_rsrvprice'] = array(); } if (isset($this->error['buyout_price'])) { $this->data['error_auction_buyprice'] = $this->error['buyout_price']; } else { $this->data['error_auction_buyprice'] = array(); } if (isset($this->error['min_increment'])) { $this->data['error_auction_mincrement'] = $this->error['min_increment']; } else { $this->data['error_auction_mincrement'] = array(); } ]]> template = 'catalog/product_form.tpl'; ]]> request->get['product_id'])) { $auction_row = (int)$this->model_catalog_product->getTotalProductAuctions($this->request->get['product_id'], $auction_status_ids) - 1; } else { $auction_row = 0; } $this->data['product_auctions'] = array(); $this->data['product_auction_ids'] = array(); // for newly submitted auctions (for sorting reasons, this array is separated from below) if (isset($this->request->post['product_auction'])) { $product_auctions = $this->request->post['product_auction']; rsort($product_auctions); foreach ($product_auctions as $product_auction) { if (!$product_auction['auction_id'] && isset($product_auction['auction_row'])) { $this->data['product_auctions'][] = $product_auction; } } } // for editable auctions that are not started yet if (isset($this->request->post['product_auction'])) { $product_auctions = $this->request->post['product_auction']; foreach ($product_auctions as $product_auction) { if ($product_auction['auction_id']) { $auction_status_id = (int)$this->model_catalog_product->getProductAuctionStatus($product_auction['auction_id']); if ($auction_status_id == $auction_status_ids['starting'] || $auction_status_id == $auction_status_ids['relisting']) { $this->data['product_auctions'][] = $product_auction; $this->data['product_auction_ids'][] = $product_auction['auction_id']; $auction_row--; } } } } // for active auctions only if (isset($this->request->get['product_id'])) { $product_auctions = $this->model_catalog_product->getProductAuctions($this->request->get['product_id'], $auction_status_ids); foreach ($product_auctions as $product_auction) { if (!isset($this->request->post['product_auction']) || $product_auction['auction_status_id'] == $auction_status_ids['inprogress'] || $product_auction['auction_status_id'] == $auction_status_ids['extended']) { if ($product_auction['auction_status_id'] == $auction_status_ids['starting'] || $product_auction['auction_status_id'] == $auction_status_ids['relisting']) { $auction_disabled = ''; } else { $auction_disabled = ' disabled'; } $auction_names = $this->model_catalog_product->getProductAuctionDescriptions($product_auction['product_auction_id']); $this->data['product_auctions'][] = array( 'product_auction_id' => (int)$product_auction['product_auction_id'], 'auction_id' => (int)$product_auction['auction_id'], 'auction_row' => (int)$auction_row, 'auction_name' => $auction_names, 'reserved_quantity' => (int)$product_auction['reserved_quantity'], 'starting_time' => date('Y-m-d H:i', (int)$product_auction['starting_time']), 'ending_time' => date('Y-m-d H:i', (int)$product_auction['ending_time']), 'starting_price' => (string)$product_auction['starting_price'], 'reserve_price' => (string)$product_auction['reserve_price'], 'buyout_price' => (string)$product_auction['buyout_price'], 'min_increment' => (string)$product_auction['min_increment'], 'allow_auto_bid' => (int)$product_auction['allow_auto_bid'], 'total_no_of_bid' => (int)$product_auction['total_no_of_bid'], 'real_ending_time' => (int)$product_auction['real_ending_time'], 'auction_status_id' => (int)$product_auction['auction_status_id'], 'auction_disabled' => $auction_disabled ); $this->data['product_auction_ids'][] = $product_auction['auction_id']; $auction_row--; } } } ]]> error && !isset($this->error['warning'])) { ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if ($this->config->get('config_auction_parameters') && is_array($this->config->get('config_auction_parameters'))) { $auction_parameters = $this->config->get('config_auction_parameters'); } else { $auction_parameters = array('min_starttime' => 0, 'max_starttime' => 72, 'min_endtime' => 1, 'max_endtime' => 72, 'max_startprice' => 999999.99, 'max_rsrvprice' => 999999.99, 'max_buyprice' => 999999.99, 'max_increment' => 999.99); } // product not enabled if (isset($this->request->get['product_id']) && (int)$this->request->post['status'] < 1 && (int)$this->model_catalog_product->getTotalProductAuctions($this->request->get['product_id'], $auction_status_ids)) { $this->error['product_status'] = $this->language->get('error_auction_prod_enable'); $this->error['auction_error'] = true; } if (isset($this->request->post['product_auction'])) { // product not enabled if ((int)$this->request->post['status'] < 1) { $this->error['product_status'] = $this->language->get('error_auction_prod_enable'); $this->error['auction_error'] = true; } // product out of stock if ((int)$this->request->post['quantity'] < 0) { $this->error['product_stock'] = $this->language->get('error_auction_stock_minus'); $this->error['auction_error'] = true; } foreach ($this->request->post['product_auction'] as $auction_row => $auction) { // already have product related error if (isset($this->error['auction_error']) && !is_array($this->error['auction_error'])) { break; } // auction already active, unable to delete if (!empty($auction['delete']) && $auction['product_auction_id'] && $auction['auction_id']) { $total_auctions = (int)$this->model_catalog_product->getTotalProductStartedAuctions($auction['auction_id'], $auction_status_ids); if ($total_auctions) { $this->error['auction_delete'][$auction_row] = $this->language->get('error_auction_deletefail'); $this->error['auction_error'][$auction_row] = true; continue; } } // auction already active, unable to update if ($auction['product_auction_id'] && $auction['auction_id']) { $total_auctions = (int)$this->model_catalog_product->getTotalProductStartedAuctions($auction['auction_id'], $auction_status_ids); if ($total_auctions) { $this->error['auction_update'][$auction_row] = $this->language->get('error_auction_updatefail'); $this->error['auction_error'][$auction_row] = true; continue; } } // auction names error foreach ($auction['auction_name'] as $language_id => $value) { if (utf8_strlen($value) < 3 || utf8_strlen($value) > 64) { $this->error['auction_name'][$auction_row][$language_id] = sprintf($this->language->get('error_auction_name'), '3', '64'); $this->error['auction_error'][$auction_row] = true; } } // reserved quantity error if ((int)$auction['reserved_quantity'] < 1) { $this->error['reserved_quantity'][$auction_row] = $this->language->get('error_auction_quantity'); $this->error['auction_error'][$auction_row] = true; } // starting time error if (strtotime($auction['starting_time']) === false || strtotime($auction['starting_time']) < time() || strtotime($auction['starting_time']) < (time() + ((int)$auction_parameters['min_starttime'] * 60 * 60)) || strtotime($auction['starting_time']) > (time() + ((int)$auction_parameters['max_starttime'] * 60 * 60))) { $this->error['starting_time'][$auction_row] = sprintf($this->language->get('error_auction_starting'), (string)$auction_parameters['min_starttime'], (string)$auction_parameters['max_starttime']); $this->error['auction_error'][$auction_row] = true; } // ending time error if (strtotime($auction['ending_time']) === false || strtotime($auction['ending_time']) < (strtotime($auction['starting_time']) + ((int)$auction_parameters['min_endtime'] * 60 * 60)) || strtotime($auction['ending_time']) > (strtotime($auction['starting_time']) + ((int)$auction_parameters['max_endtime'] * 60 * 60))) { $this->error['ending_time'][$auction_row] = sprintf($this->language->get('error_auction_ending'), (string)$auction_parameters['min_endtime'], (string)$auction_parameters['max_endtime']); $this->error['auction_error'][$auction_row] = true; } // starting price error if ((float)$auction['starting_price'] < 0.01 || (float)$auction['starting_price'] > (float)$auction_parameters['max_startprice']) { $this->error['starting_price'][$auction_row] = sprintf($this->language->get('error_auction_startprice'), (string)$auction_parameters['max_startprice']); $this->error['auction_error'][$auction_row] = true; } // reserve price error if ((float)$auction['reserve_price'] > 0 && ((float)$auction['reserve_price'] < (float)$auction['starting_price'] || (float)$auction['reserve_price'] > (float)$auction_parameters['max_rsrvprice'])) { $this->error['reserve_price'][$auction_row] = sprintf($this->language->get('error_auction_rsrvprice'), (string)$auction_parameters['max_rsrvprice']); $this->error['auction_error'][$auction_row] = true; } // buyout price error if ((float)$auction['buyout_price'] > 0 && ((float)$auction['buyout_price'] < (float)$auction['starting_price'] || (float)$auction['buyout_price'] < (float)$auction['reserve_price'] || (float)$auction['buyout_price'] > (float)$auction_parameters['max_buyprice'])) { $this->error['buyout_price'][$auction_row] = sprintf($this->language->get('error_auction_buyprice'), (string)$auction_parameters['max_buyprice']); $this->error['auction_error'][$auction_row] = true; } // minimum increment error if ((float)$auction['min_increment'] < 0.01 || (float)$auction['min_increment'] > (float)$auction_parameters['max_increment']) { $this->error['min_increment'][$auction_row] = sprintf($this->language->get('error_auction_mincrement'), (string)$auction_parameters['max_increment']); $this->error['auction_error'][$auction_row] = true; } } } ]]> db->query("DELETE FROM " . DB_PREFIX . "review WHERE product_id = '" . (int)$product_id . "'"); ]]> db->query("DELETE pa, a, pad, abs, ua FROM " . DB_PREFIX . "product_auction pa INNER JOIN " . DB_PREFIX . "auction a ON (pa.product_auction_id = a.product_auction_id) LEFT JOIN " . DB_PREFIX . "product_auction_description pad ON (pa.product_auction_id = pad.product_auction_id) LEFT JOIN " . DB_PREFIX . "auction_bid_setting abs ON (a.auction_id = abs.auction_id) LEFT JOIN " . DB_PREFIX . "url_alias ua ON (ua.query = CONCAT('auction_id=', a.auction_id)) WHERE pa.product_id = '" . (int)$product_id . "'"); ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if (isset($data['product_auction'])) { $this->setProductAuctions($product_id, $data['product_auction'], $auction_status_ids); } ]]> getProductAuctionStatus($product_auction['auction_id']); } else { $real_auction_status_id = 0; } if (!is_null($this->config->get('config_auction_auto_bidding'))) { $auto_bidding = (int)$this->config->get('config_auction_auto_bidding'); } else { $auto_bidding = 1; } if (!is_null($this->config->get('config_auction_fast_auto_bids'))) { $fast_auto_bids = (int)$this->config->get('config_auction_fast_auto_bids'); } else { $fast_auto_bids = 1; } if (!is_null($this->config->get('config_auction_auto_extension'))) { $auto_extension = (int)$this->config->get('config_auction_auto_extension'); } else { $auto_extension = 1; } if ($this->config->get('config_auction_ext_duration')) { $ext_duration = (int)$this->config->get('config_auction_ext_duration'); } else { $ext_duration = 15; } if ($this->config->get('config_auction_ext_window')) { $ext_window = (int)$this->config->get('config_auction_ext_window'); } else { $ext_window = 60; } // deciding which SQL statement to use for db query with given parameters if (!empty($product_auction['delete']) && $product_auction['product_auction_id'] && $product_auction['auction_id']) { // for deleting auction parameters $sql_statement_start = "DELETE FROM "; $sql_set_applicable = ""; $sql_product_auction_id = "product_auction_id = '" . (int)$product_auction['product_auction_id'] . "'"; $sql_product_id = "product_id = '" . (int)$product_id . "'"; $sql_auction_id = "auction_id = '" . (int)$product_auction['auction_id'] . "'"; $sql_auction_status_id = "'" . $real_auction_status_id . "' IN ('" . (int)$auction_status_ids['starting'] . "', '" . (int)$auction_status_ids['relisting'] . "')"; $sql_statement_end1 = " WHERE " . $sql_product_auction_id; $sql_statement_end2 = " AND " . $sql_product_id; $sql_statement_end3 = " AND " . $sql_auction_id; $sql_statement_end4 = " AND " . $sql_auction_status_id; $sql_db_query_type = 3; } elseif ($product_auction['product_auction_id'] && $product_auction['auction_id']) { // for updating auction parameters $sql_statement_start = "UPDATE "; $sql_set_applicable = " SET "; $sql_product_auction_id = "product_auction_id = '" . (int)$product_auction['product_auction_id'] . "'"; $sql_product_id = "product_id = '" . (int)$product_id . "'"; $sql_auction_id = "auction_id = '" . (int)$product_auction['auction_id'] . "'"; $sql_auction_status_id = "'" . $real_auction_status_id . "' IN ('" . (int)$auction_status_ids['starting'] . "', '" . (int)$auction_status_ids['relisting'] . "')"; $sql_real_ending_time = "real_ending_time = real_ending_time"; $sql_date_added = "date_added = date_added"; $sql_date_modified = "date_modified = '" . date('Y-m-d H:i:s') . "'"; $sql_statement_end1 = " WHERE " . $sql_product_auction_id; $sql_statement_end2 = " AND " . $sql_product_id; $sql_statement_end3 = " AND " . $sql_auction_id; $sql_statement_end4 = " AND " . $sql_auction_status_id; $sql_db_query_type = 2; } else { // for inserting auction parameters $sql_statement_start = "INSERT INTO "; $sql_set_applicable = " SET "; $sql_product_auction_id = "product_auction_id = product_auction_id"; $sql_product_id = "product_id = '" . (int)$product_id . "'"; $sql_auction_id = "auction_id = auction_id"; $sql_auction_status_id = "auction_status_id = '" . (int)$auction_status_ids['starting'] . "'"; $sql_real_ending_time = "real_ending_time = '" . strtotime($product_auction['ending_time']) . "'"; $sql_date_added = "date_added = '" . date('Y-m-d H:i:s') . "'"; $sql_date_modified = "date_modified = date_modified"; $sql_statement_end1 = ""; $sql_statement_end2 = ""; $sql_statement_end3 = ""; $sql_statement_end4 = ""; $sql_db_query_type = 1; } // preparing SQL statement for DB_product_auction insert or update or delete $sql = $sql_statement_start . DB_PREFIX . "product_auction"; if ($sql_db_query_type < 3) { // for inserting or updating auction only $sql .= $sql_set_applicable; $sql .= $sql_product_auction_id . ", "; $sql .= $sql_product_id . ", "; $sql .= "reserved_quantity = '" . (int)$product_auction['reserved_quantity'] . "', "; $sql .= "starting_time = '" . strtotime($product_auction['starting_time']) . "', "; $sql .= "ending_time = '" . strtotime($product_auction['ending_time']) . "', "; $sql .= "starting_price = '" . (float)$product_auction['starting_price'] . "', "; $sql .= "reserve_price = '" . (float)$product_auction['reserve_price'] . "', "; $sql .= "buyout_price = '" . (float)$product_auction['buyout_price'] . "', "; $sql .= "min_increment = '" . (float)$product_auction['min_increment'] . "', "; $sql .= "allow_auto_bid = '" . (int)((int)$product_auction['allow_auto_bid'] * $auto_bidding) . "', "; $sql .= "fast_fwd_auto_bids = '" . (int)((int)$product_auction['allow_auto_bid'] * $auto_bidding * $fast_auto_bids) . "', "; $sql .= "allow_auto_extend = '" . $auto_extension . "', "; $sql .= "extension_duration = '" . $ext_duration . "', "; $sql .= "extension_window = '" . $ext_window . "'"; } $sql .= $sql_statement_end1; $sql .= $sql_statement_end2; $sql .= $sql_statement_end4; $this->db->query($sql); // preparing SQL statement for DB_auction insert or update or delete if ($sql_db_query_type == 1) { $product_auction['product_auction_id'] = $this->db->getLastId(); $sql_product_auction_id = "product_auction_id = '" . (int)$product_auction['product_auction_id'] . "'"; } // updating multi-language auction names directly into DB_product_auction_description if ($sql_db_query_type < 3) { $this->db->query("DELETE FROM " . DB_PREFIX . "product_auction_description WHERE product_auction_id = '" . (int)$product_auction['product_auction_id'] . "'"); foreach ($product_auction['auction_name'] as $language_id => $value) { $this->db->query("INSERT INTO " . DB_PREFIX . "product_auction_description SET product_auction_id = '" . (int)$product_auction['product_auction_id'] . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value) . "'"); } } $sql = $sql_statement_start . DB_PREFIX . "auction"; if ($sql_db_query_type < 3) { // for inserting or updating auction only $sql .= $sql_set_applicable; $sql .= $sql_auction_id . ", "; $sql .= $sql_product_auction_id . ", "; $sql .= $sql_real_ending_time . ", "; if ($sql_db_query_type == 1) { $sql .= $sql_auction_status_id . ", "; } $sql .= $sql_date_added . ", "; $sql .= $sql_date_modified; } $sql .= $sql_statement_end1; $sql .= $sql_statement_end3; $sql .= $sql_statement_end4; $this->db->query($sql); // auto-defining URL alias with SEO rewrite keywords for auction if ($sql_db_query_type == 1) { $product_auction['auction_id'] = $this->db->getLastId(); } $this->db->query("DELETE FROM " . DB_PREFIX . "url_alias WHERE query = 'auction_id=" . (int)$product_auction['auction_id'] . "'"); if ($sql_db_query_type < 3) { if (!empty($product_auction['auction_name'][$this->config->get('config_language_id')])) { $auction_name = $product_auction['auction_name'][$this->config->get('config_language_id')]; } else { $auction_name = $this->config->get('config_name') . ' Product Auction'; } $keyword = 'auction-' . (int)$product_auction['auction_id'] . '-' . preg_replace('/\s+/', '_', preg_replace("/[^a-z0-9 ]/", '', html_entity_decode(strtolower($auction_name), ENT_QUOTES, 'UTF-8'))); $this->db->query("INSERT INTO " . DB_PREFIX . "url_alias SET query = 'auction_id=" . (int)$product_auction['auction_id'] . "', keyword = '" . $this->db->escape($keyword) . "'"); } } } ]]> db->query("SELECT pa.*, a.*, pad.name AS auction_name FROM " . DB_PREFIX . "product_auction pa INNER JOIN " . DB_PREFIX . "auction a ON (pa.product_auction_id = a.product_auction_id) LEFT JOIN " . DB_PREFIX . "product_auction_description pad ON (pa.product_auction_id = pad.product_auction_id) WHERE pa.product_id = '" . (int)$product_id . "' AND a.auction_status_id IN ('" . (int)$auction_status_ids['starting'] . "', '" . (int)$auction_status_ids['relisting'] . "', '" . (int)$auction_status_ids['inprogress'] . "', '" . (int)$auction_status_ids['extended'] . "') AND pad.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY a.real_ending_time ASC, pa.starting_time DESC"); return $query->rows; } public function getProductAuctionDescriptions($product_auction_id) { $product_auction_description_data = array(); $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_auction_description WHERE product_auction_id = '" . (int)$product_auction_id . "'"); foreach ($query->rows as $result) { $product_auction_description_data[$result['language_id']] = stripslashes($result['name']); } return $product_auction_description_data; } public function getTotalProductAuctions($product_id, $auction_status_ids) { $query = $this->db->query("SELECT COUNT(*) AS total_auctions FROM " . DB_PREFIX . "product_auction pa INNER JOIN " . DB_PREFIX . "auction a ON (pa.product_auction_id = a.product_auction_id) LEFT JOIN " . DB_PREFIX . "product_auction_description pad ON (pa.product_auction_id = pad.product_auction_id) WHERE pa.product_id = '" . (int)$product_id . "' AND a.auction_status_id IN ('" . (int)$auction_status_ids['starting'] . "', '" . (int)$auction_status_ids['relisting'] . "', '" . (int)$auction_status_ids['inprogress'] . "', '" . (int)$auction_status_ids['extended'] . "') AND pad.language_id = '" . (int)$this->config->get('config_language_id') . "'"); return $query->row['total_auctions']; } public function getProductAuctionStatus($auction_id) { $query = $this->db->query("SELECT MAX(auction_status_id) AS auction_status_id FROM " . DB_PREFIX . "auction WHERE auction_id = '" . (int)$auction_id . "'"); return $query->row['auction_status_id']; } public function getTotalProductStartedAuctions($auction_id, $auction_status_ids) { $query = $this->db->query("SELECT COUNT(*) AS total_auctions FROM " . DB_PREFIX . "product_auction pa INNER JOIN " . DB_PREFIX . "auction a ON (pa.product_auction_id = a.product_auction_id) WHERE a.auction_id = '" . (int)$auction_id . "' AND a.auction_status_id IN ('" . (int)$auction_status_ids['inprogress'] . "', '" . (int)$auction_status_ids['extended'] . "', '" . (int)$auction_status_ids['won'] . "', '" . (int)$auction_status_ids['expired'] . "', '" . (int)$auction_status_ids['sold'] . "', '" . (int)$auction_status_ids['voided'] . "')"); return $query->row['total_auctions']; } public function getTotalProductBiddedAuctions($product_id, $auction_status_ids) { $query = $this->db->query("SELECT COUNT(*) AS total_auctions FROM " . DB_PREFIX . "product_auction pa INNER JOIN " . DB_PREFIX . "auction a ON (pa.product_auction_id = a.product_auction_id) WHERE pa.product_id = '" . (int)$product_id . "' AND a.auction_status_id IN ('" . (int)$auction_status_ids['inprogress'] . "', '" . (int)$auction_status_ids['extended'] . "', '" . (int)$auction_status_ids['won'] . "', '" . (int)$auction_status_ids['expired'] . "', '" . (int)$auction_status_ids['sold'] . "', '" . (int)$auction_status_ids['voided'] . "') AND a.highest_bid_id > '0'"); return $query->row['total_auctions']; } public function getTotalProductAuctionsByAuctionStatusId($auction_status_id) { $query = $this->db->query("SELECT COUNT(*) AS total_auctions FROM " . DB_PREFIX . "auction WHERE auction_status_id = '" . (int)$auction_status_id . "'"); return $query->row['total_auctions']; } public function getTotalProductAuctionBidsByAuctionBidStatusId($auction_bid_status_id) { $query = $this->db->query("SELECT COUNT(*) AS total_bids FROM " . DB_PREFIX . "auction_bid WHERE auction_bid_status_id = '" . (int)$auction_bid_status_id . "'"); return $query->row['total_bids']; } ]]> config->get('config_language_id') . "'"; ]]> db->escape(utf8_strtolower($data['filter_auction_name'])) . "%' AND pad.language_id = '" . (int)$this->config->get('config_language_id') . "'"; } ]]> ]]>
  -    ]]> ]]>
  -    ]]> <?php echo $button_remove; ?> ]]>   <?php echo $button_remove; ?> ]]> ]]>   -   
]]> data['column_product'] = $this->language->get('column_product'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); ]]> load->model('sale/auction'); $auction = $this->model_sale_auction->getOrderAuction($this->request->get['order_id'], $product['order_product_id']); if ($auction) { $auction_id = (int)$auction['auction_id']; } else { $auction_id = 0; } ]]> load->model('sale/auction'); if (isset($this->request->get['order_id'])) { $auction = $this->model_sale_auction->getOrderAuction($this->request->get['order_id'], $order_product['order_product_id']); if ($auction) { $auction_id = (int)$auction['auction_id']; } else { $auction_id = 0; } } else { $auction_id = 0; } ]]> $option_data, ]]> $auction_id, ]]> $option_data, ]]> $auction_id, ]]> $order_option, ]]> $auction_id, ]]> data['products'][] = array( ]]> url->link('sale/auction/info', 'token=' . $this->session->data['token'] . '&auction_id=' . $auction_id, 'SSL'); } else { $href = $this->url->link('catalog/product/update', 'token=' . $this->session->data['token'] . '&product_id=' . $product['product_id'], 'SSL'); } ]]> $this->url->link('catalog/product/update', 'token=' . $this->session->data['token'] . '&product_id=' . $product['product_id'], 'SSL') ]]> $href ]]> ]]>
  -    ]]> data['column_submission_id'] = $this->language->get('column_submission_id'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); ]]> data['products'][] = array( ]]> load->model('sale/auction'); $order_auction = $this->model_sale_auction->getOrderAuction($order_id, $product['order_product_id']); if ($order_auction) { $auction_id = (int)$order_auction['auction_id']; } else { $auction_id = 0; } ]]> $product_options, ]]> $auction_id, ]]> ]]> ]]> ]]>
]]> ]]> ]]> data['text_stock_status'] = $this->language->get('text_stock_status'); ]]> data['text_auction'] = $this->language->get('text_auction'); $this->data['text_auction_status'] = $this->language->get('text_auction_status'); $this->data['text_auction_bid_status'] = $this->language->get('text_auction_bid_status'); ]]> data['stock_status'] = $this->url->link('localisation/stock_status', 'token=' . $this->session->data['token'], 'SSL'); ]]> data['auction'] = $this->url->link('sale/auction', 'token=' . $this->session->data['token'], 'SSL'); $this->data['auction_status'] = $this->url->link('localisation/auction_status', 'token=' . $this->session->data['token'], 'SSL'); $this->data['auction_bid_status'] = $this->url->link('localisation/auction_bid_status', 'token=' . $this->session->data['token'], 'SSL'); $this->data['report_sale_auction'] = $this->url->link('report/sale_auction', 'token=' . $this->session->data['token'], 'SSL'); ]]> ]]> ]]> data['text_total_order'] = $this->language->get('text_total_order'); ]]> data['text_total_auction'] = $this->language->get('text_total_auction'); ]]> load->model('sale/order'); ]]> load->model('sale/auction'); $this->data['total_auction'] = $this->model_sale_auction->getTotalAuctions(); ]]> Set the default minimum and maximum limits allowed when creating or editing auctions.
For Time = number of hours
For Prices = currency amount'; $_['entry_auction_min_starttime'] = 'Min Start Time
(from now)'; $_['entry_auction_max_starttime'] = 'Max Start Time
(from now)'; $_['entry_auction_min_endtime'] = 'Min End Time
(from start)'; $_['entry_auction_max_endtime'] = 'Max End Time
(from start)'; $_['entry_auction_max_startprice'] = 'Max Starting Price'; $_['entry_auction_max_rsrvprice'] = 'Max Reserve Price'; $_['entry_auction_max_buyprice'] = 'Max Buyout Price'; $_['entry_auction_max_increment'] = 'Max Increment/Bid'; $_['entry_auction_normal_sales'] = 'Allow Normal Sales:
Enable/Disable Add-to-Cart and normal sales activities if product has at least 1 live auction.'; $_['entry_auction_payment_period'] = 'Payment Period:
Set the maximum number of day(s) for won-auctions to be paid before they are voided and released back to the stock.'; $_['entry_auction_quick_bidding'] = '(Pro only) Allow Quick-Bidding:
Allow customers to make instant bid on auctions from the home page or other layouts (module panels), live listing and mini listing within each product catalog page.'; $_['entry_auction_auto_bidding'] = '(Pro only) Allow Auto-Bidding:
Allow customers to set auto-bidding on with a limit while away from keyboard, works very well with Auto-Extension.
Changes do NOT affect in-progress or extended auctions.
Can also be disabled per auction.'; $_['entry_auction_fast_auto_bids'] = 'Fast-Forward Auto-Bids

(Skip concurrent auto-bid fights to the highest amount directly. If Auto-Extension is allowed,
enabling this shall also multiply the extension time by the number of auto-bids skipped.)'; $_['entry_auction_auto_extension'] = '(Pro only) Allow Auto-Extension:
Extend auction time when receiving last minute bid, resembles going.. going.. gone! traditional auction feature.
Changes do NOT affect in-progress or extended auctions.'; $_['entry_auction_ext_duration'] = 'Extend for '; $_['entry_auction_ext_window'] = 'when new bid is placed within the last '; $_['entry_auction_auto_relisting'] = '(Pro only) Allow Auto-Relisting:
Relist auction automatically after expiry if it ends without a winner or won-but-not-paid within the payment period.'; $_['entry_auction_relist_window'] = 'Relist within '; $_['entry_auction_relist_max'] = 'of auction expiry and for a maximum of '; $_['entry_auction_notifications'] = '(Pro only) Auction Notifications:
Trigger auction notifications automatically (by email) for each stage of an auction when processed throughout different progress or by a customer. Notify once per auction unless specified.'; $_['entry_auction_notify_1stbid'] = 'Notify customers when making 1st bid in a new auction'; $_['entry_auction_notify_outbid'] = 'Notify customers when outbid 1st time in a new auction'; $_['entry_auction_notify_overrun'] = 'Notify customers when their auto-bids have been overrun'; $_['entry_auction_notify_ending'] = 'Notify customers when their bid-auctions ending in 5min'; $_['entry_auction_notify_extended'] = 'Notify customers when their bid-auctions have extended'; $_['entry_auction_notify_won'] = 'Notify customers when their bid-auctions have been won'; $_['entry_auction_notify_lost'] = 'Notify customers when their bid-auctions have been lost'; $_['entry_auction_notify_expired'] = 'Notify customers when their bid-auctions have expired'; $_['entry_auction_notify_voided'] = 'Notify customers when their bid-auctions have voided'; $_['entry_auction_notify_payment'] = 'Remind customers everyday to pay for their won-auctions'; $_['entry_auction_statuses'] = 'Auction Statuses:
Set the default auction statuses for each stage of an auction when processed throughout different progress.'; $_['entry_auction_starting'] = 'Starting'; $_['entry_auction_relisting'] = 'Relisting'; $_['entry_auction_inprogress'] = 'In-Progress'; $_['entry_auction_extended'] = 'Extended'; $_['entry_auction_won'] = 'Won'; $_['entry_auction_expired'] = 'Expired'; $_['entry_auction_sold'] = 'Sold'; $_['entry_auction_voided'] = 'Voided'; $_['entry_auction_bid_statuses'] = 'Auction Bid Statuses:
Set the default auction bid statuses for each stage of an auction bid when processed by a customer.'; $_['entry_auction_bid_winning'] = 'Winning'; $_['entry_auction_bid_outbid'] = 'Outbid'; $_['entry_auction_bid_buyout'] = 'Buyout'; $_['entry_auction_bid_voided'] = 'Voided'; ]]> ]]>
: :
: :
: :
: :






$value) { ?>
: :
: :
: :
: :
: :
: :
]]> data['entry_voucher_min'] = $this->language->get('entry_voucher_min'); ]]> data['text_auction'] = $this->language->get('text_auction'); $this->data['text_seconds'] = $this->language->get('text_seconds'); $this->data['text_hours'] = $this->language->get('text_hours'); $this->data['text_times'] = $this->language->get('text_times'); $this->data['entry_auction_parameters'] = $this->language->get('entry_auction_parameters'); $this->data['entry_auction_min_starttime'] = $this->language->get('entry_auction_min_starttime'); $this->data['entry_auction_max_starttime'] = $this->language->get('entry_auction_max_starttime'); $this->data['entry_auction_min_endtime'] = $this->language->get('entry_auction_min_endtime'); $this->data['entry_auction_max_endtime'] = $this->language->get('entry_auction_max_endtime'); $this->data['entry_auction_max_startprice'] = $this->language->get('entry_auction_max_startprice'); $this->data['entry_auction_max_rsrvprice'] = $this->language->get('entry_auction_max_rsrvprice'); $this->data['entry_auction_max_buyprice'] = $this->language->get('entry_auction_max_buyprice'); $this->data['entry_auction_max_increment'] = $this->language->get('entry_auction_max_increment'); $this->data['entry_auction_normal_sales'] = $this->language->get('entry_auction_normal_sales'); $this->data['entry_auction_payment_period'] = $this->language->get('entry_auction_payment_period'); $this->data['entry_auction_quick_bidding'] = $this->language->get('entry_auction_quick_bidding'); $this->data['entry_auction_auto_bidding'] = $this->language->get('entry_auction_auto_bidding'); $this->data['entry_auction_fast_auto_bids'] = $this->language->get('entry_auction_fast_auto_bids'); $this->data['entry_auction_auto_extension'] = $this->language->get('entry_auction_auto_extension'); $this->data['entry_auction_ext_duration'] = $this->language->get('entry_auction_ext_duration'); $this->data['entry_auction_ext_window'] = $this->language->get('entry_auction_ext_window'); $this->data['entry_auction_auto_relisting'] = $this->language->get('entry_auction_auto_relisting'); $this->data['entry_auction_relist_window'] = $this->language->get('entry_auction_relist_window'); $this->data['entry_auction_relist_max'] = $this->language->get('entry_auction_relist_max'); $this->data['entry_auction_notifications'] = $this->language->get('entry_auction_notifications'); $this->data['entry_auction_notifications_all'] = array( '1stbid' => $this->language->get('entry_auction_notify_1stbid'), 'outbid' => $this->language->get('entry_auction_notify_outbid'), 'overrun' => $this->language->get('entry_auction_notify_overrun'), 'ending' => $this->language->get('entry_auction_notify_ending'), 'extended' => $this->language->get('entry_auction_notify_extended'), 'won' => $this->language->get('entry_auction_notify_won'), 'lost' => $this->language->get('entry_auction_notify_lost'), 'expired' => $this->language->get('entry_auction_notify_expired'), 'voided' => $this->language->get('entry_auction_notify_voided'), 'payment' => $this->language->get('entry_auction_notify_payment') ); $this->data['entry_auction_statuses'] = $this->language->get('entry_auction_statuses'); $this->data['entry_auction_starting'] = $this->language->get('entry_auction_starting'); $this->data['entry_auction_relisting'] = $this->language->get('entry_auction_relisting'); $this->data['entry_auction_inprogress'] = $this->language->get('entry_auction_inprogress'); $this->data['entry_auction_extended'] = $this->language->get('entry_auction_extended'); $this->data['entry_auction_won'] = $this->language->get('entry_auction_won'); $this->data['entry_auction_expired'] = $this->language->get('entry_auction_expired'); $this->data['entry_auction_sold'] = $this->language->get('entry_auction_sold'); $this->data['entry_auction_voided'] = $this->language->get('entry_auction_voided'); $this->data['entry_auction_bid_statuses'] = $this->language->get('entry_auction_bid_statuses'); $this->data['entry_auction_bid_winning'] = $this->language->get('entry_auction_bid_winning'); $this->data['entry_auction_bid_outbid'] = $this->language->get('entry_auction_bid_outbid'); $this->data['entry_auction_bid_buyout'] = $this->language->get('entry_auction_bid_buyout'); $this->data['entry_auction_bid_voided'] = $this->language->get('entry_auction_bid_voided'); ]]> error['voucher_min'])) { ]]> error['auction_statuses'])) { $this->data['error_auction_statuses'] = $this->error['auction_statuses']; } else { $this->data['error_auction_statuses'] = ''; } if (isset($this->error['auction_bid_statuses'])) { $this->data['error_auction_bid_statuses'] = $this->error['auction_bid_statuses']; } else { $this->data['error_auction_bid_statuses'] = ''; } ]]> request->post['config_voucher_min'])) { ]]> request->post['config_auction_parameters'])) { $this->data['config_auction_parameters'] = $this->request->post['config_auction_parameters']; } elseif ($this->config->get('config_auction_parameters')) { $this->data['config_auction_parameters'] = $this->config->get('config_auction_parameters'); } else { $this->data['config_auction_parameters'] = array('min_starttime' => 0, 'max_starttime' => 72, 'min_endtime' => 1, 'max_endtime' => 72, 'max_startprice' => 999999.99, 'max_rsrvprice' => 999999.99, 'max_buyprice' => 999999.99, 'max_increment' => 999.99); } if (isset($this->request->post['config_auction_normal_sales'])) { $this->data['config_auction_normal_sales'] = $this->request->post['config_auction_normal_sales']; } elseif (!is_null($this->config->get('config_auction_normal_sales'))) { $this->data['config_auction_normal_sales'] = $this->config->get('config_auction_normal_sales'); } else { $this->data['config_auction_normal_sales'] = 0; } if (isset($this->request->post['config_auction_payment_period'])) { $this->data['config_auction_payment_period'] = $this->request->post['config_auction_payment_period']; } elseif ($this->config->get('config_auction_payment_period')) { $this->data['config_auction_payment_period'] = $this->config->get('config_auction_payment_period'); } else { $this->data['config_auction_payment_period'] = 21; } if (isset($this->request->post['config_auction_quick_bidding'])) { $this->data['config_auction_quick_bidding'] = $this->request->post['config_auction_quick_bidding']; } elseif (!is_null($this->config->get('config_auction_quick_bidding'))) { $this->data['config_auction_quick_bidding'] = $this->config->get('config_auction_quick_bidding'); } else { $this->data['config_auction_quick_bidding'] = 1; } if (isset($this->request->post['config_auction_auto_bidding'])) { $this->data['config_auction_auto_bidding'] = $this->request->post['config_auction_auto_bidding']; } elseif (!is_null($this->config->get('config_auction_auto_bidding'))) { $this->data['config_auction_auto_bidding'] = $this->config->get('config_auction_auto_bidding'); } else { $this->data['config_auction_auto_bidding'] = 1; } if (isset($this->request->post['config_auction_fast_auto_bids'])) { $this->data['config_auction_fast_auto_bids'] = $this->request->post['config_auction_fast_auto_bids']; } elseif (!is_null($this->config->get('config_auction_fast_auto_bids'))) { $this->data['config_auction_fast_auto_bids'] = $this->config->get('config_auction_fast_auto_bids'); } else { $this->data['config_auction_fast_auto_bids'] = 1; } if (isset($this->request->post['config_auction_auto_extension'])) { $this->data['config_auction_auto_extension'] = $this->request->post['config_auction_auto_extension']; } elseif (!is_null($this->config->get('config_auction_auto_extension'))) { $this->data['config_auction_auto_extension'] = $this->config->get('config_auction_auto_extension'); } else { $this->data['config_auction_auto_extension'] = 1; } if (isset($this->request->post['config_auction_ext_duration'])) { $this->data['config_auction_ext_duration'] = $this->request->post['config_auction_ext_duration']; } elseif ($this->config->get('config_auction_ext_duration')) { $this->data['config_auction_ext_duration'] = $this->config->get('config_auction_ext_duration'); } else { $this->data['config_auction_ext_duration'] = 15; } if (isset($this->request->post['config_auction_ext_window'])) { $this->data['config_auction_ext_window'] = $this->request->post['config_auction_ext_window']; } elseif ($this->config->get('config_auction_ext_window')) { $this->data['config_auction_ext_window'] = $this->config->get('config_auction_ext_window'); } else { $this->data['config_auction_ext_window'] = 60; } if (isset($this->request->post['config_auction_auto_relisting'])) { $this->data['config_auction_auto_relisting'] = $this->request->post['config_auction_auto_relisting']; } elseif (!is_null($this->config->get('config_auction_auto_relisting'))) { $this->data['config_auction_auto_relisting'] = $this->config->get('config_auction_auto_relisting'); } else { $this->data['config_auction_auto_relisting'] = 1; } if (isset($this->request->post['config_auction_relist_window'])) { $this->data['config_auction_relist_window'] = $this->request->post['config_auction_relist_window']; } elseif ($this->config->get('config_auction_relist_window')) { $this->data['config_auction_relist_window'] = $this->config->get('config_auction_relist_window'); } else { $this->data['config_auction_relist_window'] = 1; } if (isset($this->request->post['config_auction_relist_max'])) { $this->data['config_auction_relist_max'] = $this->request->post['config_auction_relist_max']; } elseif ($this->config->get('config_auction_relist_max')) { $this->data['config_auction_relist_max'] = $this->config->get('config_auction_relist_max'); } else { $this->data['config_auction_relist_max'] = 3; } if (isset($this->request->post['config_auction_notifications'])) { $this->data['config_auction_notifications'] = $this->request->post['config_auction_notifications']; } elseif ($this->config->get('config_auction_notifications')) { $this->data['config_auction_notifications'] = $this->config->get('config_auction_notifications'); } else { $this->data['config_auction_notifications'] = array('1stbid', 'outbid', 'overrun', 'ending', 'extended', 'won', 'lost', 'expired', 'voided', 'payment'); } if (isset($this->request->post['config_auction_status_id'])) { $this->data['config_auction_status_id'] = $this->request->post['config_auction_status_id']; } elseif ($this->config->get('config_auction_status_id')) { $this->data['config_auction_status_id'] = $this->config->get('config_auction_status_id'); } else { $this->data['config_auction_status_id'] = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if (isset($this->request->post['config_auction_bid_status_id'])) { $this->data['config_auction_bid_status_id'] = $this->request->post['config_auction_bid_status_id']; } elseif ($this->config->get('config_auction_bid_status_id')) { $this->data['config_auction_bid_status_id'] = $this->config->get('config_auction_bid_status_id'); } else { $this->data['config_auction_bid_status_id'] = array('winning' => 1, 'outbid' => 2, 'buyout' => 3, 'voided' => 4); } $this->load->model('localisation/auction_status'); $this->load->model('localisation/auction_bid_status'); $this->data['auction_statuses'] = $this->model_localisation_auction_status->getAuctionStatuses(); $this->data['auction_bid_statuses'] = $this->model_localisation_auction_bid_status->getAuctionBidStatuses(); ]]> request->post['config_voucher_min']) { ]]> request->post['config_auction_status_id']) && is_array($this->request->post['config_auction_status_id']) && count($this->request->post['config_auction_status_id']) !== count(array_unique($this->request->post['config_auction_status_id']))) { $this->error['auction_statuses'] = $this->language->get('error_auction_statuses'); } if (isset($this->request->post['config_auction_bid_status_id']) && is_array($this->request->post['config_auction_bid_status_id']) && count($this->request->post['config_auction_bid_status_id']) !== count(array_unique($this->request->post['config_auction_bid_status_id']))) { $this->error['auction_bid_statuses'] = $this->language->get('error_auction_bid_statuses'); } ]]> ]]> style="display: none;"> ]]> ]]> style="display: none;"> ]]> ]]> style="display: none;"> ]]> ]]> style="display: none;"> ]]> ]]> style="display: none;"> ]]> ]]>
]]> ]]>
]]> ]]> ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } $this->load->model('catalog/auction'); if (isset($this->request->get['auction_id'])) { $this->data['auction_id'] = (int)$this->request->get['auction_id']; $this->data['auction_valid'] = (int)$this->model_catalog_auction->getAuctionValidity($product_id, $this->request->get['auction_id'], $auction_status_ids); } else { $this->data['auction_id'] = 0; $this->data['auction_valid'] = 0; } $this->data['total_auctions'] = (int)$this->model_catalog_auction->getTotalLiveAuctionsByProductId($product_id, $auction_status_ids); ]]> ]]> -
]]> ]" value="" size="1" /> ]]> ]" value="" size="1" disabled /> ]]> catalog/view/image/minus.png'> ]]> ]]> catalog/view/image/plus.png'> ]]> ]]> " src="catalog/view/image/close.png" /> ]]> ]]> data['column_image'] = $this->language->get('column_image'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); $this->data['text_auction_removal'] = sprintf($this->language->get('text_auction_removal'), $this->config->get('config_auction_payment_period') ? (string)$this->config->get('config_auction_payment_period') : '21'); ]]> data['products'][] = array( ]]> $option_data, ]]> $product['auction_id'], ]]> $this->url->link('product/product', 'product_id=' . $product['product_id']), ]]> $this->url->link('product/product', 'product_id=' . $product['product_id'] . $href_auction), ]]> model_catalog_product->getProductOptions($this->request->post['product_id']); ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if (!is_null($this->config->get('config_auction_normal_sales'))) { $normal_sales = (int)$this->config->get('config_auction_normal_sales'); } else { $normal_sales = 0; } $this->load->model('catalog/auction'); $total_auctions = (int)$this->model_catalog_auction->getTotalLiveAuctionsByProductId($product_id, $auction_status_ids); if (!$normal_sales && $total_auctions) { $json['total_auctions'] = $total_auctions; } ]]> ]]> -
]]> <?php echo $button_remove; ?> ]]> <?php echo $text_auction_removal; ?> <?php echo $button_remove; ?> ]]> data['text_empty'] = $this->language->get('text_empty'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); $this->data['text_auction_removal'] = sprintf($this->language->get('text_auction_removal'), $this->config->get('config_auction_payment_period') ? (string)$this->config->get('config_auction_payment_period') : '21'); ]]> data['products'][] = array( ]]> $option_data, ]]> $product['auction_id'], ]]> $this->url->link('product/product', 'product_id=' . $product['product_id'])]]> $this->url->link('product/product', 'product_id=' . $product['product_id'] . $href_auction)]]> data[$key] = array( ]]> row['minimum']; $subtract = $product_query->row['subtract']; // Product Auction if ($this->config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if ($auction_id) { $product_auction_query = $this->db->query("SELECT a.highest_bid_amount FROM " . DB_PREFIX . "auction a INNER JOIN " . DB_PREFIX . "product_auction pa ON (a.product_auction_id = pa.product_auction_id) WHERE pa.product_id = '" . (int)$product_id . "' AND a.auction_id = '" . (int)$auction_id . "' AND auction_status_id = '" . $auction_status_ids['won'] . "'"); if ($product_auction_query->num_rows) { $price = (float)(string)((float)$product_auction_query->row['highest_bid_amount'] / (int)$quantity); $total = (float)$product_auction_query->row['highest_bid_amount']; $stock = true; // auctions already deducted reserved quantity from stock, therefore stock check is not required $minimum = 0; // auctions already deducted reserved quantity from stock, therefore mininum is not applicable $subtract = 0; // auctions already deducted reserved quantity from stock, therefore subtract is not required } } ]]> $option_data, ]]> $auction_id, ]]> ($price + $option_price),]]> $price,]]> ($price + $option_price) * $quantity,]]> $total,]]> $product_query->row['minimum'],]]> $minimum,]]> $product_query->row['subtract'],]]> $subtract,]]> session->data['cart'][$key])) { ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if (!is_null($this->config->get('config_auction_normal_sales'))) { $normal_sales = (int)$this->config->get('config_auction_normal_sales'); } else { $normal_sales = 0; } $auction_query = $this->db->query("SELECT a.auction_id FROM " . DB_PREFIX . "auction a INNER JOIN " . DB_PREFIX . "product_auction pa ON (a.product_auction_id = pa.product_auction_id) WHERE pa.product_id = '" . (int)$product_id . "' AND a.auction_status_id IN ('" . (int)$auction_status_ids['inprogress'] . "', '" . (int)$auction_status_ids['extended'] . "')"); if (!empty($option) && is_int($option) && !is_array($option)) { $this->session->data['cart'][$key] = (int)$qty; // option is an auction_id, this key is a won-auction } elseif (!$normal_sales && $auction_query->num_rows) { $this->remove($key); // add-to-cart not allowed if live auction exists } elseif (!isset($this->session->data['cart'][$key])) { ]]> db->query("UPDATE " . DB_PREFIX . "customer SET cart = ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if ($customer_query->row['cart'] && is_string($customer_query->row['cart'])) { $cart = unserialize($customer_query->row['cart']); foreach ($cart as $key => $value) { $product = explode(':', $key); if (!empty($product[1]) && is_int(unserialize(base64_decode($product[1]))) && !is_array(unserialize(base64_decode($product[1])))) { $auction_query = $this->db->query("SELECT auction_id FROM " . DB_PREFIX . "auction WHERE auction_id = '" . (int)unserialize(base64_decode($product[1])) . "' AND auction_status_id = '" . (int)$auction_status_ids['won'] . "'"); if ($auction_query->num_rows) { $this->session->data['cart'][$key] = $value; // persistent inclusion of won-auctions in customer cart } } } } ]]> session->data['cart'])) { ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } $product = explode(':', $key); if (!empty($product[1]) && is_int(unserialize(base64_decode($product[1]))) && !is_array(unserialize(base64_decode($product[1])))) { $auction_query = $this->db->query("SELECT auction_id FROM " . DB_PREFIX . "auction WHERE auction_id = '" . (int)unserialize(base64_decode($product[1])) . "' AND auction_status_id = '" . (int)$auction_status_ids['won'] . "'"); if ($auction_query->num_rows) { $this->session->data['cart'][$key] = $value; // option is an auction_id, this key is a won-auction } } elseif (!array_key_exists($key, $this->session->data['cart'])) { ]]> ]]>
  -   <?php echo $text_auction_removal; ?> ]]> data['column_name'] = $this->language->get('column_name'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); $this->data['text_auction_removal'] = sprintf($this->language->get('text_auction_removal'), $this->config->get('config_auction_payment_period') ? (string)$this->config->get('config_auction_payment_period') : '21'); ]]> data['products'][] = array( ]]> $option_data, ]]> $product['auction_id'], ]]> empty( $product_info['status'] ) ? 'javascript:void(0);' : $this->url->link('product/product', 'product_id=' . $product['product_id'])]]> empty( $product_info['status'] ) ? 'javascript:void(0);' : $this->url->link('product/product', 'product_id=' . $product['product_id'] . $href_auction)]]> $this->language->get('text_auction_id'), 'value' => '#' . $product['auction_id'] ); } ]]> ]]>
  -   <?php echo $text_auction_removal; ?> ]]> data['column_name'] = $this->language->get('column_name'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); $this->data['text_auction_removal'] = sprintf($this->language->get('text_auction_removal'), $this->config->get('config_auction_payment_period') ? (string)$this->config->get('config_auction_payment_period') : '21'); ]]> $option_data, ]]> $product['auction_id'], ]]> ]]>
  -   <?php echo $text_auction_removal; ?> ]]> data['column_name'] = $this->language->get('column_name'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); $this->data['text_auction_removal'] = sprintf($this->language->get('text_auction_removal'), $this->config->get('config_auction_payment_period') ? (string)$this->config->get('config_auction_payment_period') : '21'); ]]> $option_data, ]]> $product['auction_id'], ]]> ]]>
  -    ]]> db->query("INSERT INTO " . DB_PREFIX . "order_auction SET order_id = '" . (int)$order_id . "', order_product_id = '" . (int)$order_product_id . "', product_id = '" . (int)$product['product_id'] . "', auction_id = '" . (int)$product['auction_id'] . "'"); } ]]> db->query("UPDATE " . DB_PREFIX . "product SET quantity = (quantity - " . (int)$order_product['quantity'] . ") WHERE product_id = '" . (int)$order_product['product_id'] . "' AND subtract = '1'"); ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } $order_auction_query = $this->db->query("SELECT order_auction_id, auction_id FROM " . DB_PREFIX . "order_auction WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$order_product['order_product_id'] . "'"); if ($order_auction_query->num_rows) { $this->db->query("UPDATE " . DB_PREFIX . "auction SET auction_status_id = '" . $auction_status_ids['sold'] . "', order_auction_id = '" . (int)$order_auction_query->row['order_auction_id'] . "', date_modified = '" . date('Y-m-d H:i:s') . "' WHERE auction_id = '" . (int)$order_auction_query->row['auction_id'] . "' AND auction_status_id = '" . $auction_status_ids['won'] . "'"); } else { $this->db->query("UPDATE " . DB_PREFIX . "product SET quantity = (quantity - " . (int)$order_product['quantity'] . ") WHERE product_id = '" . (int)$order_product['product_id'] . "' AND subtract = '1'"); } ]]> data['text_powered'] = $language->get('text_new_powered'); ]]> data['text_auction_won'] = $language->get('text_auction_won'); if (isset($this->request->server['HTTPS']) && ($this->request->server['HTTPS'] == 'on' || $this->request->server['HTTPS'] == '1')) { $template->data['image_url'] = HTTPS_SERVER; } else { $template->data['image_url'] = HTTP_SERVER; } ]]> data['products'][] = array( ]]> db->query("SELECT auction_id FROM " . DB_PREFIX . "order_auction WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'"); if ($order_auction_query->num_rows) { $auction_id = (int)$order_auction_query->row['auction_id']; } else { $auction_id = 0; } ]]> $option_data, ]]> $auction_id, ]]> db->query("SELECT auction_id FROM " . DB_PREFIX . "order_auction WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'"); if ($order_auction_query->num_rows) { $text .= chr(9) . '-' . $language->get('text_auction_won') . "\n"; } ]]> ]]>
  -    ]]> cart->add($order_product['product_id'], $order_product['quantity'], $option_data); ]]> config->get('config_auction_status_id') && is_array($this->config->get('config_auction_status_id'))) { $auction_status_ids = $this->config->get('config_auction_status_id'); } else { $auction_status_ids = array('starting' => 1, 'relisting' => 2, 'inprogress' => 3, 'extended' => 4, 'won' => 5, 'expired' => 6, 'sold' => 7, 'voided' => 8); } if (!is_null($this->config->get('config_auction_normal_sales'))) { $normal_sales = (int)$this->config->get('config_auction_normal_sales'); } else { $normal_sales = 0; } $this->load->model('catalog/auction'); $total_auctions = (int)$this->model_catalog_auction->getTotalLiveAuctionsByProductId($order_product['product_id'], $auction_status_ids); if (!$normal_sales && $total_auctions) { continue; } ]]> data['column_name'] = $this->language->get('column_name'); ]]> data['text_auction_won'] = $this->language->get('text_auction_won'); ]]> data['products'][] = array( ]]> load->model('account/auction'); $order_auction = $this->model_account_auction->getOrderAuction($this->request->get['order_id'], $product['order_product_id']); if ($order_auction) { $auction_id = (int)$order_auction['auction_id']; } else { $auction_id = 0; } ]]> $option_data, ]]> $auction_id, ]]> ]]> ]]> data['text_order'] = $this->language->get('text_order'); ]]> data['text_auction'] = $this->language->get('text_auction'); ]]> data['order'] = $this->url->link('account/order', '', 'SSL'); ]]> data['auction'] = $this->url->link('account/auction', '', 'SSL'); ]]> ]]> ]]> data['text_order'] = $this->language->get('text_order'); ]]> data['text_auction'] = $this->language->get('text_auction'); ]]> data['order'] = $this->url->link('account/order', '', 'SSL'); ]]> data['auction'] = $this->url->link('account/auction', '', 'SSL'); ]]> ]]> ]]> data['home'] = $this->url->link('common/home'); ]]> data['text_live_auction'] = $this->language->get('text_live_auction'); $this->data['live_auctions'] = $this->url->link('product/auction'); ]]> request->get['auction_id'] = $url[1]; } ]]> db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "'"); if ($query->num_rows) { $url .= '/' . $query->row['keyword']; unset($data[$key]); } ]]> db->query("SELECT * FROM " . DB_PREFIX . "product_auction_description WHERE language_id = '" . (int)$this->config->get('config_language_id') . "'"); foreach ($query->rows as $product_auction_description) { $this->db->query("INSERT INTO " . DB_PREFIX . "product_auction_description SET product_auction_id = '" . (int)$product_auction_description['product_auction_id'] . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($product_auction_description['name']) . "'"); } // Auction Status $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "auction_status WHERE language_id = '" . (int)$this->config->get('config_language_id') . "'"); foreach ($query->rows as $auction_status) { $this->db->query("INSERT INTO " . DB_PREFIX . "auction_status SET auction_status_id = '" . (int)$auction_status['auction_status_id'] . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($auction_status['name']) . "'"); } // Auction Bid Status $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "auction_bid_status WHERE language_id = '" . (int)$this->config->get('config_language_id') . "'"); foreach ($query->rows as $auction_bid_status) { $this->db->query("INSERT INTO " . DB_PREFIX . "auction_bid_status SET auction_bid_status_id = '" . (int)$auction_bid_status['auction_bid_status_id'] . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($auction_bid_status['name']) . "'"); } ]]> db->query("DELETE FROM " . DB_PREFIX . "product_attribute WHERE language_id = '" . (int)$language_id . "'"); ]]> db->query("DELETE FROM " . DB_PREFIX . "product_auction_description WHERE language_id = '" . (int)$language_id . "'"); $this->db->query("DELETE FROM " . DB_PREFIX . "auction_status WHERE language_id = '" . (int)$language_id . "'"); $this->db->query("DELETE FROM " . DB_PREFIX . "auction_bid_status WHERE language_id = '" . (int)$language_id . "'"); ]]>