function listConfigurations()
{
global $toC_Json, $osC_Database;
$Qcfg = $osC_Database->query('select configuration_id, configuration_key, configuration_title, configuration_description, configuration_value, use_function, set_function from :table_configuration where configuration_group_id = :configuration_group_id order by sort_order');
$Qcfg->bindTable(':table_configuration', TABLE_CONFIGURATION);
$Qcfg->bindInt(':configuration_group_id', $_REQUEST['gID']);
$Qcfg->execute();
$keys = array();
while ($Qcfg->next()) {
$cfgValue = $Qcfg->value('configuration_value');
if (!osc_empty($Qcfg->value('use_function'))) {
$cfgValue = osc_call_user_func($Qcfg->value('use_function'), $Qcfg->value('configuration_value'));
}
$control = array();
if (!osc_empty($Qcfg->value('set_function'))) {
$control = osc_call_user_func($Qcfg->value('set_function'), $Qcfg->value('configuration_value'), $Qcfg->value('configuration_key'));
} else {
$control['type'] = 'textfield';
$control['name'] = $Qcfg->value('configuration_key');
}
$control['id'] = $Qcfg->value('configuration_id');
$control['title'] = $Qcfg->value('configuration_title');
$control['value'] = $cfgValue;
$keys[] = $control;
}
echo $toC_Json->encode($keys);
}
function getConfigurationOptions()
{
global $osC_Language, $osC_Database, $toC_Json;
include '../includes/modules/' . $_REQUEST['set'] . '/' . $_REQUEST['code'] . '.php';
$module = 'osC_' . ucfirst($_REQUEST['set']) . '_' . $_REQUEST['code'];
$module = new $module();
$keys = array();
foreach ($module->getKeys() as $key) {
$Qkey = $osC_Database->query('select configuration_id, configuration_key, configuration_title, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_key = :configuration_key');
$Qkey->bindTable(':table_configuration', TABLE_CONFIGURATION);
$Qkey->bindValue(':configuration_key', $key);
$Qkey->execute();
$control = array();
if (!osc_empty($Qkey->value('set_function'))) {
$control = osc_call_user_func($Qkey->value('set_function'), $Qkey->value('configuration_value'), $key);
$field['title'] = $Qkey->value('configuration_title');
} else {
$control['type'] = 'textfield';
$control['name'] = 'configuration[' . $key . ']';
}
$control['id'] = $Qkey->value('configuration_id');
$control['title'] = $Qkey->value('configuration_title');
$control['value'] = $Qkey->value('configuration_value');
$control['description'] = $Qkey->value('configuration_description');
$keys[] = $control;
}
echo $toC_Json->encode($keys);
}
function initialize()
{
global $osC_Database, $osC_Language, $osC_Currencies;
$Qupcoming = $osC_Database->query('select p.products_id, p.products_price, p.products_tax_class_id, p.products_date_available as date_expected, pd.products_name, pd.products_keyword, s.specials_new_products_price, i.image from :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag) left join :table_specials s on (p.products_id = s.products_id and s.status = 1), :table_products_description pd where to_days(p.products_date_available) >= to_days(now()) and p.products_status = :products_status and p.products_id = pd.products_id and pd.language_id = :language_id order by p.products_date_available limit :max_display_upcoming_products');
$Qupcoming->bindTable(':table_products', TABLE_PRODUCTS);
$Qupcoming->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qupcoming->bindTable(':table_specials', TABLE_SPECIALS);
$Qupcoming->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qupcoming->bindInt(':default_flag', 1);
$Qupcoming->bindInt(':products_status', 1);
$Qupcoming->bindInt(':language_id', $osC_Language->getID());
$Qupcoming->bindInt(':max_display_upcoming_products', MODULE_CONTENT_UPCOMING_PRODUCTS_MAX_DISPLAY);
if (MODULE_CONTENT_UPCOMING_PRODUCTS_CACHE > 0) {
$Qupcoming->setCache('upcoming_products-' . $osC_Language->getCode() . '-' . $osC_Currencies->getCode(), MODULE_CONTENT_UPCOMING_PRODUCTS_CACHE);
}
$Qupcoming->execute();
if ($Qupcoming->numberOfRows() > 0) {
$this->_content = '<ol style="list-style: none;">';
while ($Qupcoming->next()) {
$this->_content .= '<li>' . osC_DateTime::getLong($Qupcoming->value('date_expected')) . ': ' . osc_link_object(osc_href_link(FILENAME_PRODUCTS, $Qupcoming->value('products_id')), $Qupcoming->value('products_name')) . ' ';
if (osc_empty($Qupcoming->value('specials_new_products_price'))) {
$this->_content .= '(' . $osC_Currencies->displayPrice($Qupcoming->value('products_price'), $Qupcoming->valueInt('products_tax_class_id')) . ')';
} else {
$this->_content .= '(<s>' . $osC_Currencies->displayPrice($Qupcoming->value('products_price'), $Qupcoming->valueInt('products_tax_class_id')) . '</s> <span class="productSpecialPrice">' . $osC_Currencies->displayPrice($Qupcoming->value('specials_new_products_price'), $Qupcoming->valueInt('products_tax_class_id')) . '</span>)';
}
$this->_content .= '</li>';
}
$this->_content .= '</ol>';
}
$Qupcoming->freeResult();
}
function initialize()
{
global $osC_Database, $osC_Language, $osC_Product, $osC_Image;
if (isset($osC_Product)) {
$Qorders = $osC_Database->query('select p.products_id, pd.products_name, pd.products_keyword, i.image from :table_orders_products opa, :table_orders_products opb, :table_orders o, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.default_flag = :default_flag), :table_products_description pd where opa.products_id = :products_id and opa.orders_id = opb.orders_id and opb.products_id != :products_id and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id group by p.products_id order by o.date_purchased desc limit :limit');
$Qorders->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS);
$Qorders->bindTable(':table_orders_products', TABLE_ORDERS_PRODUCTS);
$Qorders->bindTable(':table_orders', TABLE_ORDERS);
$Qorders->bindTable(':table_products', TABLE_PRODUCTS);
$Qorders->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES);
$Qorders->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
$Qorders->bindInt(':default_flag', 1);
$Qorders->bindInt(':products_id', $osC_Product->getID());
$Qorders->bindInt(':products_id', $osC_Product->getID());
$Qorders->bindInt(':language_id', $osC_Language->getID());
$Qorders->bindInt(':limit', MODULE_CONTENT_ALSO_PURCHASED_MAX_DISPLAY);
if (MODULE_CONTENT_ALSO_PURCHASED_PRODUCTS_CACHE > 0) {
$Qorders->setCache('also_purchased-' . $osC_Product->getID(), MODULE_CONTENT_ALSO_PURCHASED_PRODUCTS_CACHE);
}
$Qorders->execute();
if ($Qorders->numberOfRows() >= MODULE_CONTENT_ALSO_PURCHASED_MIN_DISPLAY) {
$this->_content = '<div style="overflow: auto;">';
while ($Qorders->next()) {
$this->_content .= '<span style="width: 33%; float: left; text-align: center;">';
if (osc_empty($Qorders->value('image')) === false) {
$this->_content .= osc_link_object(osc_href_link(FILENAME_PRODUCTS, $Qorders->value('products_id')), $osC_Image->show($Qorders->value('image'), $Qorders->value('products_name'))) . '<br />';
}
$this->_content .= osc_link_object(osc_href_link(FILENAME_PRODUCTS, $Qorders->value('products_id')), $Qorders->value('products_name')) . '</span>';
}
$this->_content .= '</div>';
}
$Qorders->freeResult();
}
}
function initialize()
{
global $osC_Database, $osC_Language, $osC_Product;
if (isset($osC_Product) && is_a($osC_Product, 'osC_Product')) {
$Qmanufacturer = $osC_Database->query('select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from :table_manufacturers m left join :table_manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id), :table_products p where p.products_id = :products_id and p.manufacturers_id = m.manufacturers_id');
$Qmanufacturer->bindTable(':table_manufacturers', TABLE_MANUFACTURERS);
$Qmanufacturer->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qmanufacturer->bindTable(':table_products', TABLE_PRODUCTS);
$Qmanufacturer->bindInt(':languages_id', $osC_Language->getID());
$Qmanufacturer->bindInt(':products_id', $osC_Product->getID());
$Qmanufacturer->execute();
if ($Qmanufacturer->numberOfRows()) {
$this->_content = '';
if (!osc_empty($Qmanufacturer->value('manufacturers_image'))) {
$this->_content .= '<div style="text-align: center;">' . osc_link_object(osc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $Qmanufacturer->valueInt('manufacturers_id')), osc_image(DIR_WS_IMAGES . 'manufacturers/' . $Qmanufacturer->value('manufacturers_image'), $Qmanufacturer->value('manufacturers_name'))) . '</div>';
}
$this->_content .= '<ol style="list-style: none; margin: 0; padding: 0;">';
if (!osc_empty($Qmanufacturer->value('manufacturers_url'))) {
$this->_content .= '<li>' . osc_link_object(osc_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers_id=' . $Qmanufacturer->valueInt('manufacturers_id')), sprintf($osC_Language->get('box_manufacturer_info_website'), $Qmanufacturer->value('manufacturers_name')), 'target="_blank"') . '</li>';
}
$this->_content .= '<li>' . osc_link_object(osc_href_link(FILENAME_DEFAULT, 'manufacturers=' . $Qmanufacturer->valueInt('manufacturers_id')), $osC_Language->get('box_manufacturer_info_products')) . '</li>';
$this->_content .= '</ol>';
}
}
}
function getJavascriptBlock()
{
global $osC_Language, $osC_CreditCard;
$osC_CreditCard = new osC_CreditCard();
$js = ' if (payment_value == "' . $this->_code . '") {' . "\n" . ' var saferpay_cc_owner = document.checkout_payment.saferpay_cc_owner.value;' . "\n" . ' var saferpay_cc_number = document.checkout_payment.saferpay_cc_number.value;' . "\n" . ' saferpay_cc_number = saferpay_cc_number.replace(/[^\\d]/gi, "");' . "\n";
if (MODULE_PAYMENT_SAFERPAY_CC_VERIFY_WITH_CVC == '1') {
$js .= ' var saferpay_cc_cvc = document.checkout_payment.saferpay_cc_cvc.value;' . "\n";
}
if (CFG_CREDIT_CARDS_VERIFY_WITH_JS == '1') {
$js .= ' var saferpay_cc_type_match = false;' . "\n";
}
$js .= ' if (saferpay_cc_owner == "" || saferpay_cc_owner.length < ' . (int) CC_OWNER_MIN_LENGTH . ') {' . "\n" . ' error_message = error_message + "' . sprintf($osC_Language->get('payment_saferpay_cc_js_credit_card_owner'), (int) CC_OWNER_MIN_LENGTH) . '\\n";' . "\n" . ' error = 1;' . "\n" . ' }' . "\n";
$has_type_patterns = false;
if (CFG_CREDIT_CARDS_VERIFY_WITH_JS == '1' && osc_empty(MODULE_PAYMENT_SAFERPAY_CC_ACCEPTED_TYPES) === false) {
foreach (explode(',', MODULE_PAYMENT_SAFERPAY_CC_ACCEPTED_TYPES) as $type_id) {
if ($osC_CreditCard->typeExists($type_id)) {
$has_type_patterns = true;
$js .= ' if ( (saferpay_cc_type_match == false) && (saferpay_cc_number.match(' . $osC_CreditCard->getTypePattern($type_id) . ') != null) ) { ' . "\n" . ' saferpay_cc_type_match = true;' . "\n" . ' }' . "\n";
}
}
}
if ($has_type_patterns === true) {
$js .= ' if ((saferpay_cc_type_match == false) || (mod10(saferpay_cc_number) == false)) {' . "\n" . ' error_message = error_message + "' . $osC_Language->get('payment_saferpay_cc_js_credit_card_not_accepted') . '\\n";' . "\n" . ' error = 1;' . "\n" . ' }' . "\n";
} else {
$js .= ' if (saferpay_cc_number == "" || saferpay_cc_number.length < ' . CC_NUMBER_MIN_LENGTH . ') {' . "\n" . ' error_message = error_message + "' . sprintf($osC_Language->get('payment_saferpay_cc_js_credit_card_number'), CC_NUMBER_MIN_LENGTH) . '\\n";' . "\n" . ' error = 1;' . "\n" . ' }' . "\n";
}
if (MODULE_PAYMENT_SAFERPAY_CC_VERIFY_WITH_CVC == '1') {
$js .= ' if (saferpay_cc_cvc == "" || saferpay_cc_cvc.length < 3) {' . "\n" . ' error_message = error_message + "' . sprintf($osC_Language->get('payment_saferpay_cc_js_credit_card_cvc'), 3) . '\\n";' . "\n" . ' error = 1;' . "\n" . ' }' . "\n";
}
$js .= ' }' . "\n";
return $js;
}
function resize($image, $group_id)
{
if (osc_empty(CFG_APP_IMAGEMAGICK_CONVERT) || !file_exists(CFG_APP_IMAGEMAGICK_CONVERT)) {
return $this->resizeWithGD($image, $group_id);
}
if (!file_exists(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/' . $this->_groups[$group_id]['code'])) {
mkdir(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/' . $this->_groups[$group_id]['code']);
@chmod(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/' . $this->_groups[$group_id]['code'], 0777);
}
exec(escapeshellarg(CFG_APP_IMAGEMAGICK_CONVERT) . ' -resize ' . (int) $this->_groups[$group_id]['size_width'] . 'x' . (int) $this->_groups[$group_id]['size_height'] . ($this->_groups[$group_id]['force_size'] == '1' ? '!' : '') . ' ' . escapeshellarg(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/' . $this->_groups[1]['code'] . '/' . $image) . ' ' . escapeshellarg(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/' . $this->_groups[$group_id]['code'] . '/' . $image));
@chmod(DIR_FS_CATALOG . DIR_WS_IMAGES . 'products/' . $this->_groups[$group_id]['code'] . '/' . $image, 0777);
}
function load()
{
global $osC_Language;
if (defined('MODULE_DEFAULT_GEOIP') && !osc_empty(MODULE_DEFAULT_GEOIP) && file_exists('includes/modules/geoip/' . MODULE_DEFAULT_GEOIP . '.php')) {
$osC_Language->loadIniFile('modules/geoip/' . MODULE_DEFAULT_GEOIP . '.php');
include 'includes/modules/geoip/' . MODULE_DEFAULT_GEOIP . '.php';
$module = 'osC_GeoIP_' . MODULE_DEFAULT_GEOIP;
return new $module();
} else {
return new osC_GeoIP_Admin();
}
}
function simpleQuery($query, $debug = false)
{
global $osC_MessageStack, $osC_Services;
if ($this->isConnected()) {
$this->number_of_queries++;
if ($debug === false && $this->debug === true) {
$debug = true;
}
if (isset($osC_Services) && $osC_Services->isStarted('debug')) {
if ($debug === false && SERVICE_DEBUG_OUTPUT_DB_QUERIES == '1') {
$debug = true;
}
if (!osc_empty(SERVICE_DEBUG_EXECUTION_TIME_LOG) && SERVICE_DEBUG_LOG_DB_QUERIES == '1') {
@error_log('QUERY ' . $query . "\n", 3, SERVICE_DEBUG_EXECUTION_TIME_LOG);
}
} elseif ($debug === true) {
$debug = false;
}
if ($debug === true) {
$time_start = $this->getMicroTime();
}
$resource = @mysqli_query($this->link, $query);
if ($debug === true) {
$time_end = $this->getMicroTime();
$query_time = number_format($time_end - $time_start, 5);
if ($this->debug === true) {
$this->time_of_queries += $query_time;
}
echo '<div style="font-family: Verdana, Arial, sans-serif; font-size: 7px; font-weight: bold;">[<a href="#query' . $this->number_of_queries . '">#' . $this->number_of_queries . '</a>]</div>';
$osC_MessageStack->add('debug', '<a name=\'query' . $this->number_of_queries . '\'></a>[#' . $this->number_of_queries . ' - ' . $query_time . 's] ' . $query, 'warning');
}
if ($resource !== false) {
$this->error = false;
$this->error_number = null;
$this->error_query = null;
if (mysqli_warning_count($this->link) > 0) {
$warning_query = @mysqli_query($this->link, 'show warnings');
while ($warning = mysqli_fetch_row($warning_query)) {
trigger_error(sprintf('[MYSQL] %s (%d): %s [QUERY] ' . $query, $warning[0], $warning[1], $warning[2]), E_USER_WARNING);
}
mysqli_free_result($warning_query);
}
return $resource;
} else {
$this->setError(mysqli_error($this->link), mysqli_errno($this->link), $query);
return false;
}
} else {
return false;
}
}
function osC_Account_Login()
{
global $osC_Language, $osC_Services, $breadcrumb;
// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
if (osc_empty(session_id())) {
osc_redirect(osc_href_link(FILENAME_INFO, 'cookie', 'AUTO'));
}
$this->_page_title = $osC_Language->get('sign_in_heading');
if ($osC_Services->isStarted('breadcrumb')) {
$breadcrumb->add($osC_Language->get('breadcrumb_sign_in'), osc_href_link(FILENAME_ACCOUNT, $this->_module, 'SSL'));
}
if ($_GET[$this->_module] == 'process') {
$this->_process();
}
}
public static function getValue($value)
{
global $osC_Database, $osC_Language;
$string = '';
$Qstatus = $osC_Database->query('select title, css_key from :table_shipping_availability where id = :id and languages_id = :languages_id');
$Qstatus->bindTable(':table_shipping_availability', TABLE_SHIPPING_AVAILABILITY);
$Qstatus->bindInt(':id', $value);
$Qstatus->bindInt(':languages_id', $osC_Language->getID());
$Qstatus->execute();
if ($Qstatus->numberOfRows() === 1) {
$string = $Qstatus->value('title');
if (!osc_empty($Qstatus->value('css_key'))) {
$string = '<span class="' . $Qstatus->value('css_key') . '">' . $string . '</span>';
}
}
return $string;
}
function execute()
{
global $osC_Session, $toC_Wishlist, $osC_Product;
$id = false;
foreach ($_GET as $key => $value) {
if ((ereg('^[0-9]+(_?([0-9]+:?[0-9]+)+(;?([0-9]+:?[0-9]+)+)*)*$', $key) || ereg('^[a-zA-Z0-9 -_]*$', $key)) && $key != $osC_Session->getName()) {
$id = $key;
}
break;
}
//change the variants in the product info page, then attach the wid param to represent the variant product
if (isset($_GET['wid']) && preg_match('/^[0-9]+(_?([0-9]+:?[0-9]+)+(;?([0-9]+:?[0-9]+)+)*)*$/', $_GET['wid'])) {
$id = $_GET['wid'];
}
if (strpos($id, '_') !== false) {
$id = str_replace('_', '#', $id);
}
if ($id !== false && osC_Product::checkEntry($id)) {
$osC_Product = new osC_Product($id);
}
if (isset($osC_Product)) {
$variants = null;
if (isset($_POST['variants']) && is_array($_POST['variants'])) {
$variants = $_POST['variants'];
} else {
if (isset($_GET['variants']) && !empty($_GET['variants'])) {
$variants = osc_parse_variants_string($_GET['variants']);
} else {
if (strpos($id, '#') !== false) {
$variants = osc_parse_variants_from_id_string($id);
}
}
}
if (!osc_empty($variants)) {
$toC_Wishlist->add($osC_Product->getID(), $variants);
} else {
$toC_Wishlist->add($osC_Product->getID());
}
}
osc_redirect(osc_href_link(FILENAME_ACCOUNT, 'wishlist'));
}
/**
* Generate an internal URL address for the administration side
*
* @param string $page The page to link to
* @param string $parameters The parameters to pass to the page (in the GET scope)
* @access public
*/
function osc_href_link_admin($page = null, $parameters = null)
{
if (ENABLE_SSL === true) {
$link = HTTPS_SERVER . DIR_WS_HTTPS_CATALOG . 'admin/';
} else {
$link = HTTP_SERVER . DIR_WS_HTTP_CATALOG . 'admin/';
}
$link .= $page;
if (empty($parameters) && !osc_empty(SID)) {
$link .= '?' . SID;
} else {
$link .= '?' . $parameters;
if (!osc_empty(SID)) {
$link .= '&' . SID;
}
}
while (substr($link, -1) == '&' || substr($link, -1) == '?') {
$link = substr($link, 0, -1);
}
return $link;
}
function stop()
{
global $osC_MessageStack, $osC_Template;
$time_start = explode(' ', PAGE_PARSE_START_TIME);
$time_end = explode(' ', microtime());
$parse_time = number_format($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0]), 3);
if (!osc_empty(SERVICE_DEBUG_EXECUTION_TIME_LOG)) {
if (!@error_log(strftime('%c') . ' - ' . $_SERVER['REQUEST_URI'] . ' (' . $parse_time . 's)' . "\n", 3, SERVICE_DEBUG_EXECUTION_TIME_LOG)) {
if (!file_exists(SERVICE_DEBUG_EXECUTION_TIME_LOG) || !is_writable(SERVICE_DEBUG_EXECUTION_TIME_LOG)) {
$osC_MessageStack->add('debug', 'Error: Execution time log file not writeable: ' . SERVICE_DEBUG_EXECUTION_TIME_LOG . ' [' . __CLASS__ . ']', 'error');
}
}
}
if (SERVICE_DEBUG_EXECUTION_DISPLAY == '1') {
$osC_MessageStack->add('debug', 'Execution Time: ' . $parse_time . 's [' . __CLASS__ . ']', 'warning');
}
if ($osC_Template->showDebugMessages() && $osC_MessageStack->size('debug') > 0) {
echo $osC_MessageStack->get('debug');
}
return true;
}
public static function stop()
{
$OSCOM_MessageStack = Registry::get('MessageStack');
$OSCOM_Template = Registry::get('Template');
$time_start = explode(' ', PAGE_PARSE_START_TIME);
$time_end = explode(' ', microtime());
$parse_time = number_format($time_end[1] + $time_end[0] - ($time_start[1] + $time_start[0]), 3);
if (!osc_empty(SERVICE_DEBUG_EXECUTION_TIME_LOG)) {
if (!@error_log(strftime('%c') . ' - ' . $_SERVER['REQUEST_URI'] . ' (' . $parse_time . 's)' . "\n", 3, SERVICE_DEBUG_EXECUTION_TIME_LOG)) {
if (!file_exists(SERVICE_DEBUG_EXECUTION_TIME_LOG) || !is_writable(SERVICE_DEBUG_EXECUTION_TIME_LOG)) {
$OSCOM_MessageStack->add('debug', 'Error: Execution time log file not writeable: ' . SERVICE_DEBUG_EXECUTION_TIME_LOG, 'error');
}
}
}
if (SERVICE_DEBUG_EXECUTION_DISPLAY == '1') {
$OSCOM_MessageStack->add('debug', 'Execution Time: ' . $parse_time . 's', 'warning');
}
if ($OSCOM_Template->showDebugMessages() && $OSCOM_MessageStack->exists('debug')) {
echo $OSCOM_MessageStack->get('debug');
}
return true;
}
public static function find($search)
{
global $osC_Database;
$in_group = array();
foreach (osc_toObjectInfo(self::getAllGroups())->get('entries') as $group) {
$in_group[] = $group['configuration_group_id'];
}
$result = array('entries' => array());
$Qcfg = $osC_Database->query('select * from :table_configuration where (configuration_key like :configuration_key or configuration_value like :configuration_value) and configuration_group_id in (:configuration_group_id) order by configuration_key');
$Qcfg->bindTable(':table_configuration', TABLE_CONFIGURATION);
$Qcfg->bindValue(':configuration_key', '%' . $search . '%');
$Qcfg->bindValue(':configuration_value', '%' . $search . '%');
$Qcfg->bindRaw(':configuration_group_id', implode(',', $in_group));
$Qcfg->execute();
while ($Qcfg->next()) {
$result['entries'][] = $Qcfg->toArray();
if (!osc_empty($Qcfg->value('use_function'))) {
$result['entries'][sizeof($result['entries']) - 1]['configuration_value'] = osc_call_user_func($Qcfg->value('use_function'), $Qcfg->value('configuration_value'));
}
}
$result['total'] = $Qcfg->numberOfRows();
$Qcfg->freeResult();
return $result;
}
function process_button()
{
global $osC_Customer, $osC_Currencies, $osC_ShoppingCart;
if (MODULE_PAYMENT_CHRONOPAY_CURRENCY == 'Selected Currency') {
$currency = $osC_Currencies->getCode();
} else {
$currency = MODULE_PAYMENT_CHRONOPAY_CURRENCY;
}
switch ($osC_ShoppingCart->getBillingAddress('country_iso_code_3')) {
case 'USA':
case 'CAN':
$state_code = $osC_ShoppingCart->getBillingAddress('state_code');
break;
default:
$state_code = 'XX';
break;
}
$total_price = $osC_Currencies->formatRaw($osC_ShoppingCart->getTotal(), $currency);
$process_button_string = osc_draw_hidden_field('product_id', MODULE_PAYMENT_CHRONOPAY_PRODUCT_ID) . osc_draw_hidden_field('product_name', STORE_NAME) . osc_draw_hidden_field('product_price', $total_price) . osc_draw_hidden_field('product_price_currency', $currency) . osc_draw_hidden_field('cb_url', urlencode(osc_href_link(FILENAME_CHECKOUT, 'callback&module=' . $this->_code, 'SSL', null, null, true))) . osc_draw_hidden_field('cb_type', 'P') . osc_draw_hidden_field('decline_url', urlencode(osc_href_link(FILENAME_CHECKOUT, 'payment', 'SSL', null, null, true))) . osc_draw_hidden_field('language', 'EN') . osc_draw_hidden_field('f_name', $osC_ShoppingCart->getBillingAddress('firstname')) . osc_draw_hidden_field('s_name', $osC_ShoppingCart->getBillingAddress('lastname')) . osc_draw_hidden_field('street', $osC_ShoppingCart->getBillingAddress('street_address')) . osc_draw_hidden_field('city', $osC_ShoppingCart->getBillingAddress('city')) . osc_draw_hidden_field('state', $state_code) . osc_draw_hidden_field('zip', $osC_ShoppingCart->getBillingAddress('postcode')) . osc_draw_hidden_field('country', $osC_ShoppingCart->getBillingAddress('country_iso_code_3')) . osc_draw_hidden_field('phone', $osC_ShoppingCart->getBillingAddress('telephone_number')) . osc_draw_hidden_field('email', $osC_Customer->getEmailAddress()) . osc_draw_hidden_field('cs1', $osC_Customer->getID()) . osc_draw_hidden_field('cs2', $this->_order_id) . osc_draw_hidden_field('cs3', md5(MODULE_PAYMENT_CHRONOPAY_PRODUCT_ID . $this->_order_id . $osC_Customer->getID() . $total_price . MODULE_PAYMENT_CHRONOPAY_MD5_HASH));
if (!osc_empty(MODULE_PAYMENT_CHRONOPAY_MD5_HASH)) {
$process_button_string .= osc_draw_hidden_field('sign', md5(MODULE_PAYMENT_CHRONOPAY_PRODUCT_ID . '-' . $total_price . '-' . MODULE_PAYMENT_CHRONOPAY_MD5_HASH));
}
return $process_button_string;
}
public function initialize()
{
$OSCOM_Product = Registry::exists('Product') ? Registry::get('Product') : null;
$OSCOM_Database = Registry::get('Database');
$OSCOM_Language = Registry::get('Language');
if (isset($OSCOM_Product) && $OSCOM_Product instanceof \osCommerce\OM\Site\Shop\Product && $OSCOM_Product->isValid()) {
$Qmanufacturer = $OSCOM_Database->query('select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, mi.manufacturers_url from :table_manufacturers m left join :table_manufacturers_info mi on (m.manufacturers_id = mi.manufacturers_id and mi.languages_id = :languages_id), :table_products p where p.products_id = :products_id and p.manufacturers_id = m.manufacturers_id');
$Qmanufacturer->bindInt(':languages_id', $OSCOM_Language->getID());
$Qmanufacturer->bindInt(':products_id', $OSCOM_Product->getID());
$Qmanufacturer->execute();
if ($Qmanufacturer->numberOfRows()) {
$this->_content = '';
if (!osc_empty($Qmanufacturer->value('manufacturers_image'))) {
$this->_content .= '<div style="text-align: center;">' . osc_link_object(OSCOM::getLink(null, 'Index', 'Manufacturers=' . $Qmanufacturer->valueInt('manufacturers_id')), osc_image(DIR_WS_IMAGES . 'manufacturers/' . $Qmanufacturer->value('manufacturers_image'), $Qmanufacturer->value('manufacturers_name'))) . '</div>';
}
$this->_content .= '<ol style="list-style: none; margin: 0; padding: 0;">';
if (!osc_empty($Qmanufacturer->value('manufacturers_url'))) {
$this->_content .= '<li>' . osc_link_object(OSCOM::getLink(null, 'Redirct', 'Manufacturer=' . $Qmanufacturer->valueInt('manufacturers_id')), sprintf(OSCOM::getDef('box_manufacturer_info_website'), $Qmanufacturer->value('manufacturers_name')), 'target="_blank"') . '</li>';
}
$this->_content .= '<li>' . osc_link_object(OSCOM::getLink(null, 'Index', 'Manufacturers=' . $Qmanufacturer->valueInt('manufacturers_id')), OSCOM::getDef('box_manufacturer_info_products')) . '</li>';
$this->_content .= '</ol>';
}
}
}
<h1><?php
echo $osC_Template->getPageTitle();
?>
</h1>
<link href="templates/<?php
echo $osC_Template->getCode();
?>
/javascript/milkbox/milkbox.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="templates/<?php
echo $osC_Template->getCode();
?>
/javascript/milkbox/milkbox.js"></script>
<?php
if (!osc_empty($Qarticle->value('articles_image'))) {
echo '<p style="float: right; padding: 0px 5px 5px 5px">' . $osC_Image->show($Qarticle->value('articles_image'), $Qarticle->value('articles_name'), '', 'product_info', 'articles') . '</p>';
}
?>
<p><?php
echo $Qarticle->value('articles_description');
?>
</p>
<div class="submitFormButtons" style="text-align: right;">
<?php
echo osc_link_object(osc_href_link(FILENAME_DEFAULT), osc_draw_image_button('button_continue.gif', $osC_Language->get('button_continue')));
?>
</div>
" method="post">
<p><?php
echo $osC_Language->get('introduction_edit_shipping_module');
?>
</p>
<?php
$keys = '';
foreach ($module->getKeys() as $key) {
$Qkey = $osC_Database->query('select configuration_title, configuration_value, configuration_description, use_function, set_function from :table_configuration where configuration_key = :configuration_key');
$Qkey->bindTable(':table_configuration', TABLE_CONFIGURATION);
$Qkey->bindValue(':configuration_key', $key);
$Qkey->execute();
$keys .= '<b>' . $Qkey->value('configuration_title') . '</b><br />' . $Qkey->value('configuration_description') . '<br />';
if (!osc_empty($Qkey->value('set_function'))) {
$keys .= osc_call_user_func($Qkey->value('set_function'), $Qkey->value('configuration_value'), $key);
} else {
$keys .= osc_draw_input_field('configuration[' . $key . ']', $Qkey->value('configuration_value'));
}
$keys .= '<br /><br />';
}
$keys = substr($keys, 0, strrpos($keys, '<br /><br />'));
?>
<p><?php
echo $keys;
?>
</p>
<p align="center"><?php
function add($products_id, $variants = array())
{
global $osC_Database, $osC_Services, $osC_Customer, $osC_Product;
//if wishlist empty, create a new wishlist
if (!$this->hasWishlistID()) {
$token = $this->generateToken();
$Qnew = $osC_Database->query('insert into :table_wishlists (customers_id, wishlists_token) values (:customers_id, :wishlists_token)');
$Qnew->bindTable(':table_wishlists', TABLE_WISHLISTS);
$Qnew->bindInt(':customers_id', $osC_Customer->getID());
$Qnew->bindValue(':wishlists_token', $token);
$Qnew->execute();
$this->_wishlists_id = $osC_Database->nextID();
$this->_token = $token;
$Qnew->freeResult();
}
if (!isset($osC_Product)) {
$osC_Product = new osC_Product($products_id);
}
if ($osC_Product->getID() > 0) {
if (!$this->exists($products_id)) {
$product_price = $osC_Product->getPrice();
$product_name = $osC_Product->getTitle();
$product_image = $osC_Product->getImage();
if ($osC_Services->isStarted('specials')) {
global $osC_Specials;
if ($new_price = $osC_Specials->getPrice($products_id)) {
$price = $new_price;
}
}
//if the product has variants, set the image, price etc according to the variants
if ($osC_Product->hasVariants()) {
$products_variants = $osC_Product->getVariants();
if (is_array($variants) && !osc_empty($variants)) {
$product_id_string = osc_get_product_id_string($products_id, $variants);
$products_variant = $products_variants[$product_id_string];
} else {
$products_variant = $osC_Product->getDefaultVariant();
}
$variants_groups_id = $products_variant['groups_id'];
$variants_groups_name = $products_variant['groups_name'];
if (!osc_empty($variants_groups_name)) {
$product_name .= '<br />';
foreach ($variants_groups_name as $group_name => $value_name) {
$product_name .= '<em>' . $group_name . ': ' . $value_name . '</em>' . '<br />';
}
}
$product_price = $products_variant['price'];
$product_image = $products_variant['image'];
}
$this->_contents[$products_id] = array('products_id' => $products_id, 'name' => $product_name, 'image' => $product_image, 'price' => $product_price, 'date_added' => osC_DateTime::getShort(osC_DateTime::getNow()), 'variants' => $variants, 'comments' => '');
//insert into wishlist products
$Qnew = $osC_Database->query('insert into :table_wishlist_products (wishlists_id, products_id, date_added, comments) values (:wishlists_id, :products_id, now(), :comments)');
$Qnew->bindTable(':table_wishlist_products', TABLE_WISHLISTS_PRODUCTS);
$Qnew->bindInt(':wishlists_id', $this->_wishlists_id);
$Qnew->bindInt(':products_id', $products_id);
$Qnew->bindValue(':comments', '');
$Qnew->execute();
$wishlists_products_id = $osC_Database->nextID();
$Qnew->freeResult();
//if the wishlists products has variants
$products_variants_groups_id = array();
$products_variants_groups_name = array();
if (isset($variants_groups_id) && isset($variants_groups_name)) {
foreach ($variants_groups_id as $groups_id => $values_id) {
$products_variants_groups_id[] = array('groups_id' => $groups_id, 'values_id' => $values_id);
}
foreach ($variants_groups_name as $groups_name => $values_name) {
$products_variants_groups_name[] = array('groups_name' => $groups_name, 'values_name' => $values_name);
}
}
if (!osc_empty($products_variants_groups_id)) {
foreach ($products_variants_groups_id as $key => $groups_id) {
$Qinsert = $osC_Database->query('insert into :table_wishlists_products_variants (wishlists_id, wishlists_products_id, products_variants_groups_id, products_variants_groups, products_variants_values_id, products_variants_values) values (:wishlists_id, :wishlists_products_id, :products_variants_groups_id, :products_variants_groups, :products_variants_values_id, :products_variants_values)');
$Qinsert->bindTable(':table_wishlists_products_variants', TABLE_WISHLISTS_PRODUCTS_VARIANTS);
$Qinsert->bindInt(':wishlists_id', $this->_wishlists_id);
$Qinsert->bindInt(':wishlists_products_id', $wishlists_products_id);
$Qinsert->bindInt(':products_variants_groups_id', $groups_id['groups_id']);
$Qinsert->bindInt(':products_variants_values_id', $groups_id['values_id']);
$Qinsert->bindValue(':products_variants_groups', $products_variants_groups_name[$key]['groups_name']);
$Qinsert->bindValue(':products_variants_values', $products_variants_groups_name[$key]['values_name']);
$Qinsert->execute();
}
}
}
}
}
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License v2 (1991)
as published by the Free Software Foundation.
*/
?>
<h1><?php
echo $osC_Template->getPageTitle();
?>
</h1>
<?php
if (osC_Order::numberOfEntries() > 0) {
$Qhistory = osC_Order::getListing(MAX_DISPLAY_ORDER_HISTORY);
while ($Qhistory->next()) {
if (!osc_empty($Qhistory->value('delivery_name'))) {
$order_type = $osC_Language->get('order_shipped_to');
$order_name = $Qhistory->value('delivery_name');
} else {
$order_type = $osC_Language->get('order_billed_to');
$order_name = $Qhistory->value('billing_name');
}
?>
<div class="moduleBox">
<h6><span style="float: left;"><?php
echo $osC_Language->get('order_status') . ' ' . osC_Order::getLastPublicStatus($Qhistory->value('orders_id'));
?>
</span><?php
echo $osC_Language->get('order_number') . ' ' . $Qhistory->valueInt('orders_id');
<div class="content">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
while ($Qstatus->next()) {
?>
<tr>
<td valign="top" width="70"><?php
echo osC_DateTime::getShort($Qstatus->value('date_added'));
?>
</td>
<td valign="top" width="200"><?php
echo $Qstatus->value('orders_status_name');
?>
</td>
<td valign="top"><?php
echo !osc_empty($Qstatus->valueProtected('comments')) ? nl2br($Qstatus->valueProtected('comments')) : ' ';
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
</div>
<?php
}
?>
<div class="submitFormButtons">
<a href="<?php
function listLog()
{
global $toC_Json, $osC_Database;
$start = empty($_REQUEST['start']) ? 0 : $_REQUEST['start'];
$limit = empty($_REQUEST['limit']) ? MAX_DISPLAY_SEARCH_RESULTS : $_REQUEST['limit'];
$Qlog = $osC_Database->query('select email_address, date_sent from :table_newsletters_log where newsletters_id = :newsletters_id order by date_sent desc');
$Qlog->bindTable(':table_newsletters_log', TABLE_NEWSLETTERS_LOG);
$Qlog->bindInt(':newsletters_id', $_REQUEST['newsletters_id']);
$Qlog->setExtBatchLimit($start, $limit);
$Qlog->execute();
$records = array();
while ($Qlog->next()) {
$records[] = array('email_address' => $Qlog->valueProtected('email_address'), 'sent' => osc_icon(!osc_empty($Qlog->value('date_sent')) ? 'checkbox_ticked.gif' : 'checkbox_crossed.gif', null, null), 'date_sent' => osC_DateTime::getShort($Qlog->value('date_sent'), true));
}
$Qlog->freeResult();
$response = array(EXT_JSON_READER_TOTAL => $Qlog->getBatchSize(), EXT_JSON_READER_ROOT => $records);
echo $toC_Json->encode($response);
}
action: 'back_backup'
},
layoutConfig: { labelSeparator: ''},
autoHeight: true,
defaults: {anchor: '97%'},
labelWidth: 160,
items: [
{
border: false,
html: '<?php
$compression_array = array(array("id" => "none", "text" => $osC_Language->get("field_compression_none")));
if (!osc_empty(CFG_APP_GZIP) && file_exists(CFG_APP_GZIP)) {
$compression_array[] = array("id" => "gzip", "text" => $osC_Language->get("field_compression_gzip"));
}
if (!osc_empty(CFG_APP_ZIP) && file_exists(CFG_APP_ZIP)) {
$compression_array[] = array("id" => "zip", "text" => $osC_Language->get("field_compression_zip"));
}
echo '<p class="form-info">' . $osC_Language->get("introduction_new_backup") . '</p>';
echo '<p>' . osc_draw_radio_field("compression", $compression_array, "none", null, "<br />") . '</p>';
?>
'
}
]
});
return this.frmBackup;
},
submitForm: function () {
this.frmBackup.form.submit({
function process_button()
{
global $order, $osC_Currencies, $osC_Language;
switch (MODULE_PAYMENT_IPAYMENT_CURRENCY) {
case 'Always EUR':
$trx_currency = 'EUR';
break;
case 'Always USD':
$trx_currency = 'USD';
break;
case 'Either EUR or USD, else EUR':
if ($_SESSION['currency'] == 'EUR' || $_SESSION['currency'] == 'USD') {
$trx_currency = $_SESSION['currency'];
} else {
$trx_currency = 'EUR';
}
break;
case 'Either EUR or USD, else USD':
if ($_SESSION['currency'] == 'EUR' || $_SESSION['currency'] == 'USD') {
$trx_currency = $_SESSION['currency'];
} else {
$trx_currency = 'USD';
}
break;
}
$payment_error_return = 'ipayment_cc_owner=' . urlencode($_POST['ipayment_cc_owner']) . '&ipayment_cc_expires_month=' . urlencode($_POST['ipayment_cc_expires_month']) . '&ipayment_cc_expires_year=' . urlencode($_POST['ipayment_cc_expires_year']) . '&ipayment_cc_checkcode=' . urlencode($_POST['ipayment_cc_checkcode']);
$process_button_string = osc_draw_hidden_field('trxuser_id', MODULE_PAYMENT_IPAYMENT_USER_ID) . osc_draw_hidden_field('trxpassword', MODULE_PAYMENT_IPAYMENT_PASSWORD) . osc_draw_hidden_field('trx_amount', number_format($order->info['total'] * 100 * $osC_Currencies->value($trx_currency), 0, '', '')) . osc_draw_hidden_field('trx_currency', $trx_currency) . osc_draw_hidden_field('trx_paymenttyp', 'cc') . osc_draw_hidden_field('addr_name', $this->cc_card_owner) . osc_draw_hidden_field('addr_street', $order->billing['street_address']) . osc_draw_hidden_field('addr_city', $order->billing['city']) . osc_draw_hidden_field('addr_zip', $order->billing['postcode']) . osc_draw_hidden_field('addr_country', $order->billing['country']['iso_code_2']) . osc_draw_hidden_field('addr_telefon', $order->customer['telephone']) . osc_draw_hidden_field('addr_email', $order->customer['email_address']) . osc_draw_hidden_field('error_lang', $osC_Language->getCode() == 'en' ? 'en' : 'de') . osc_draw_hidden_field('silent', '1') . osc_draw_hidden_field('silent_error_url', osc_href_link(FILENAME_CHECKOUT, 'payment&payment_error=' . $this->_code . '&' . $payment_error_return, 'SSL')) . osc_draw_hidden_field('redirect_url', osc_href_link(FILENAME_CHECKOUT, 'process', 'SSL')) . osc_draw_hidden_field('cc_number', $this->cc_card_number) . osc_draw_hidden_field('cc_expdate_month', $this->cc_expiry_month) . osc_draw_hidden_field('cc_expdate_year', $this->cc_expiry_year);
if (!empty($this->cc_checkcode)) {
$process_button_string .= osc_draw_hidden_field('cc_checkcode', $this->cc_checkcode);
}
if (!osc_empty(MODULE_PAYMENT_IPAYMENT_SECURITY_KEY)) {
$process_button_string .= osc_draw_hidden_field('trx_securityhash', md5(MODULE_PAYMENT_IPAYMENT_USER_ID . number_format($order->info['total'] * 100 * $osC_Currencies->value($trx_currency), 0, '', '') . $trx_currency . MODULE_PAYMENT_IPAYMENT_PASSWORD . MODULE_PAYMENT_IPAYMENT_SECURITY_KEY));
}
return $process_button_string;
}
function getImage($variants = null)
{
$default_image = null;
$default_variant_image = null;
$current_variants = null;
if (isset($this->_data['images']) && is_array($this->_data['images'])) {
foreach ($this->_data['images'] as $image) {
//get variant default image
if ($this->hasVariants()) {
if (!osc_empty($this->_current_variants)) {
$current_variants = $this->_current_variants;
} else {
if ($variants !== null) {
$current_variants = $variants;
}
}
if ($current_variants !== null) {
$product_id_string = osc_get_product_id_string($this->getID(), $current_variants);
$product_variant = $this->_data['variants'][$product_id_string];
$default_variant_image = $product_variant['image'];
break;
} else {
if (is_array($this->_data['default_variant']) && !empty($this->_data['default_variant'])) {
if ($image['id'] == $this->_data['default_variant']['image']) {
$default_variant_image = $image['image'];
}
}
}
}
//get default image
if ($image['default_flag'] == '1') {
$default_image = $image['image'];
}
}
}
if ($default_variant_image != null) {
return $default_variant_image;
}
return $default_image;
}
/**
* Update the product information according to the variants
*
* @access private
* @param string product id string with variants
* @param object product
* @param string original product name
* @param boolean flag to represent the new variant is adding into the wishlist
* @return string the new product name
*/
function _updateProduct($products_id_string, $osC_Product, $product_name, $add = true)
{
$variant_product = array();
if (preg_match('/^[0-9]+(#?([0-9]+:?[0-9]+)+(;?([0-9]+:?[0-9]+)+)*)*$/', $products_id_string)) {
$variants = osc_parse_variants_from_id_string($products_id_string);
}
$variants_groups = $osC_Product->getData('variants_groups');
$products_variants = $osC_Product->getVariants();
if (is_array($variants) && !osc_empty($variants)) {
$products_variant = $products_variants[$products_id_string];
} else {
if ($add) {
$products_variant = $osC_Product->getDefaultVariant();
$default_variants_string = $products_variant['product_id_string'];
$variants = osc_parse_variants_from_id_string($default_variants_string);
}
}
$variants_groups_name = $products_variant['groups_name'];
//process products name
if (!osc_empty($variants_groups_name)) {
$product_name .= '<br />';
foreach ($variants_groups_name as $group_name => $value_name) {
$product_name .= '<em class="label label-info">' . $group_name . ': ' . $value_name . '</em>' . '<br />';
}
}
$variant_product['name'] = $product_name;
// process product price and image according to the variants
$variant_product['price'] = $osC_Product->getPrice($variants);
$variant_product['image'] = $osC_Product->getImage($variants);
return $variant_product;
}
$Qstatus = $order->getStatusListing();
if ($Qstatus->numberOfRows() > 0) {
?>
<div class="moduleBox">
<h6><?php
echo $osC_Language->get('order_history_heading');
?>
</h6>
<div class="content">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<?php
while ($Qstatus->next()) {
echo ' <tr>' . "\n" . ' <td valign="top" width="70">' . osC_DateTime::getShort($Qstatus->value('date_added')) . '</td>' . "\n" . ' <td valign="top" width="200">' . $Qstatus->value('orders_status_name') . '</td>' . "\n" . ' <td valign="top">' . (!osc_empty($Qstatus->valueProtected('comments')) ? nl2br($Qstatus->valueProtected('comments')) : ' ') . '</td>' . "\n" . ' </tr>' . "\n";
}
?>
</table>
</div>
</div>
<?php
}
?>
<div class="submitFormButtons">
<?php
echo osc_link_object(osc_href_link(FILENAME_ACCOUNT, 'orders' . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'SSL'), osc_draw_image_button('button_back.gif', $osC_Language->get('button_back')));
?>
</div>
$Qmanufacturer->bindInt(':manufacturers_id', $_GET['manufacturers_id']);
$Qmanufacturer->bindInt(':languages_id', $osC_Language->getID());
$Qmanufacturer->execute();
if ($Qmanufacturer->numberOfRows() && !osc_empty($Qmanufacturer->value('manufacturers_url'))) {
$Qupdate = $osC_Database->query('update :table_manufacturers_info set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = :manufacturers_id and languages_id = :languages_id');
$Qupdate->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qupdate->bindInt(':manufacturers_id', $_GET['manufacturers_id']);
$Qupdate->bindInt(':languages_id', $osC_Language->getID());
$Qupdate->execute();
osc_redirect($Qmanufacturer->value('manufacturers_url'));
} else {
// no url exists for the selected language, lets use the default language then
$Qmanufacturer = $osC_Database->query('select mi.languages_id, mi.manufacturers_url from :table_manufacturers_info mi, :table_languages l where mi.manufacturers_id = :manufacturers_id and mi.languages_id = l.languages_id and l.code = :code');
$Qmanufacturer->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qmanufacturer->bindTable(':table_languages', TABLE_LANGUAGES);
$Qmanufacturer->bindInt(':manufacturers_id', $_GET['manufacturers_id']);
$Qmanufacturer->bindValue(':code', DEFAULT_LANGUAGE);
$Qmanufacturer->execute();
if ($Qmanufacturer->numberOfRows() && !osc_empty($Qmanufacturer->value('manufacturers_url'))) {
$Qupdate = $osC_Database->query('update :table_manufacturers_info set url_clicked = url_clicked+1, date_last_click = now() where manufacturers_id = :manufacturers_id and languages_id = :languages_id');
$Qupdate->bindTable(':table_manufacturers_info', TABLE_MANUFACTURERS_INFO);
$Qupdate->bindInt(':manufacturers_id', $_GET['manufacturers_id']);
$Qupdate->bindInt(':languages_id', $Qmanufacturer->valueInt('languages_id'));
$Qupdate->execute();
osc_redirect($Qmanufacturer->value('manufacturers_url'));
}
}
}
break;
}
osc_redirect(osc_href_link(FILENAME_DEFAULT));
