public static function getProduct($product_id)
{
$wpdb = rev_db_class::rev_db_instance();
$sql = "SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM " . DB_PREFIX . "product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM " . DB_PREFIX . "product_special ps WHERE ps.product_id = p.product_id AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM " . DB_PREFIX . "product_reward pr WHERE pr.product_id = p.product_id) AS reward, (SELECT ss.name FROM " . DB_PREFIX . "stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '" . (int) sdsconfig::get_current_lang_id() . "') AS stock_status, (SELECT wcd.unit FROM " . DB_PREFIX . "weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '" . (int) sdsconfig::get_current_lang_id() . "') AS weight_class, (SELECT lcd.unit FROM " . DB_PREFIX . "length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '" . (int) sdsconfig::get_current_lang_id() . "') AS length_class, (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM " . DB_PREFIX . "review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN " . DB_PREFIX . "manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '" . (int) $product_id . "' AND pd.language_id = '" . (int) sdsconfig::get_current_lang_id() . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int) sdsconfig::get_current_store() . "'";
$query = $wpdb->get_results($sql);
if (isset($query) && !empty($query)) {
$query = $query[0];
}
if (isset($query) && !empty($query)) {
$get_mainsite_url = get_mainsite_url();
$img_path = $get_mainsite_url . 'image/';
$lnk = new Url($get_mainsite_url);
return array('product_id' => $query['product_id'], 'link' => $lnk->link('product/product', 'product_id=' . $query['product_id']), 'id_product' => $query['product_id'], 'name' => $query['name'], 'description' => $query['description'], 'meta_description' => $query['meta_description'], 'meta_keyword' => $query['meta_keyword'], 'tag' => $query['tag'], 'model' => $query['model'], 'sku' => $query['sku'], 'upc' => $query['upc'], 'ean' => $query['ean'], 'jan' => $query['jan'], 'isbn' => $query['isbn'], 'mpn' => $query['mpn'], 'location' => $query['location'], 'quantity' => $query['quantity'], 'stock_status' => $query['stock_status'], 'image' => $img_path . $query['image'], 'manufacturer_id' => $query['manufacturer_id'], 'manufacturer' => $query['manufacturer'], 'price' => $query['discount'] ? $query['discount'] : $query['price'], 'special' => $query['special'], 'reward' => $query['reward'], 'points' => $query['points'], 'tax_class_id' => $query['tax_class_id'], 'date_available' => $query['date_available'], 'weight' => $query['weight'], 'weight_class_id' => $query['weight_class_id'], 'length' => $query['length'], 'width' => $query['width'], 'height' => $query['height'], 'length_class_id' => $query['length_class_id'], 'subtract' => $query['subtract'], 'rating' => round($query['rating']), 'reviews' => $query['reviews'] ? $query['reviews'] : 0, 'minimum' => $query['minimum'], 'sort_order' => $query['sort_order'], 'status' => $query['status'], 'date_added' => $query['date_added'], 'date_modified' => $query['date_modified'], 'viewed' => $query['viewed']);
} else {
return false;
}
}
<?php
$layouts = sdsconfig::getLayouts();
$allslides = sdsconfig::getrevslide();
$store_id = (int) sdsconfig::get_current_store();
$pos_modules = sdsconfig::getval('revslideropencart_module', $store_id, 'revslideropencart');
$modules_data = unserialize($pos_modules);
$getpositions = array();
require_once dirname(__FILE__) . '/../../position/position.php';
?>
<div class="title_line">
<div class="view_title">
<?php
echo ControllerModulerevslideropencart::$lang_var['Setup_Slider_Position'];
?>
</div>
</div>
<div class="postbox">
<form action="<?php
//echo $action;
?>
" method="post" enctype="multipart/form-data" id="sds_rev_mod_form">
<table id="module" class="list">
<thead>
<tr>
<td class="left"><?php
echo ControllerModulerevslideropencart::$lang_var['SLIDER'];
?>
</td>
