コード例 #1
0
 public function process()
 {
     $this->get_value = $this->parsePath($_GET['articles_id']);
     $this->original_get = (int) $_GET['articles_id'];
     $this->cache_name = $this->setCacheString(__FILE__, 'article_info', $this->original_get);
     if (false !== $this->retrieve($this->cache_name)) {
         KissMT::init()->setCanonical($this->checkCanonical('articles_id'));
         return;
     }
     $query_replacements = array(':articles_id' => (int) $this->get_value, ':languages_id' => (int) KissMT::init()->retrieve('languages_id'));
     $query = str_replace(array_keys($query_replacements), array_values($query_replacements), $this->article_query);
     $result = KissMT::init()->query($query);
     $article_details = tep_db_fetch_array($result);
     tep_db_free_result($result);
     $name = trim($article_details['name']);
     $description = trim($article_details['description']);
     $breadcrumb = array_flip(KissMT::init()->retrieve('breadcrumb'));
     if (array_key_exists($name, $breadcrumb)) {
         unset($breadcrumb[$name]);
     }
     $breadcrumb = array_flip($breadcrumb);
     $leading_values = $name . (!empty($breadcrumb) ? '[-separator-]' . implode('[-separator-]', $breadcrumb) : '');
     KissMT::init()->setCanonical($this->checkCanonical('articles_id'));
     $this->parse(KissMT::init()->entities($leading_values, $decode = true), KissMT::init()->entities($description, $decode = true));
 }
コード例 #2
0
ファイル: reviews.php プロジェクト: tapwag/oscommerce_deutsch
 public function process()
 {
     $this->get_value = '';
     $this->original_get = '';
     $this->cache_name = $this->setCacheString(__FILE__, 'listing', 'general');
     if (false !== $this->retrieve($this->cache_name)) {
         KissMT::init()->setCanonical($this->checkCanonical());
         return;
     }
     $query_replacements = array(':languages_id' => (int) KissMT::init()->retrieve('languages_id'));
     $query = str_replace(array_keys($query_replacements), array_values($query_replacements), $this->reviews_query);
     $result = KissMT::init()->query($query);
     $list_array = array();
     while ($reviews_products_results = tep_db_fetch_array($result)) {
         if (tep_not_null($reviews_products_results['products_name'])) {
             $list_array[] = trim($reviews_products_results['products_name']);
         }
     }
     $list_string = implode('[-separator-]', $this->removeArrayDuplicates($list_array));
     tep_db_free_result($result);
     $list_string = tep_not_null($list_string) ? $list_string : false;
     $leading_values = implode('[-separator-]', KissMT::init()->retrieve('breadcrumb'));
     KissMT::init()->setCanonical($this->checkCanonical());
     $this->parse(KissMT::init()->entities(sprintf(KISSMT_REVIEWS_TEXT, $leading_values), $decode = true), KissMT::init()->entities($list_string, $decode = true));
 }
コード例 #3
0
 public function retrieve()
 {
     if (SEO_URLS_ENABLED != 'false') {
         $query = str_replace(':cache_name', $this->cachename, $this->extract_query);
         $result = usu::query($query);
         $row = tep_db_fetch_array($result);
         tep_db_free_result($result);
         if (!empty($row)) {
             $cache_seconds = usu::$cachedays * 24 * 60 * 60;
             if (time() > strtotime($row['cache_date']) + $cache_seconds) {
                 $this->gc();
             } else {
                 usu::$cachefile_size = number_format(strlen($row['cache_data']) / 1024, 2) . ' kb';
                 usu::$performance['time'] = microtime(true);
                 $this->md5check = md5($row['cache_data']);
                 $rawdata = gzinflate(base64_decode($row['cache_data']));
                 usu::$registry = unserialize($rawdata);
                 usu::$performance['time'] = round(microtime(true) - usu::$performance['time'], 4);
                 $this->retrieved = true;
                 return true;
             }
         }
     }
     usu::$registry = Usu_Registry::getInstance();
 }
コード例 #4
0
ファイル: Usu_Products.php プロジェクト: digideskio/oscmax2
 protected function acquire($dependency, $fullpath)
 {
     $this->products_id = (int) $dependency;
     // Bypass the query if already in the registry
     if (false !== isset(usu::$registry->{$this->dependency}[$this->products_id])) {
         usu::$performance['queries_saved']++;
         return true;
     }
     $placeholders = array(':pid', ':languages_id');
     // $values are already type cast
     $values = array($this->products_id, usu::$languages_id);
     $this->query = str_replace($placeholders, $values, $this->base_query);
     $result = usu::query($this->query);
     $this->query = null;
     $row = tep_db_fetch_array($result);
     tep_db_free_result($result);
     if (false === $row) {
         return false;
     }
     $this->link_text = $this->linkText($row['products_name']);
     if (false === isset(usu::$registry->{$this->dependency})) {
         usu::$registry->{$this->dependency} = array();
     }
     usu::$registry->attach($this->dependency, $this->products_id, $this->getProperties());
 }
コード例 #5
0
 public function process()
 {
     $this->cache_name = false;
     if (array_key_exists('tPath', $_GET)) {
         $this->get_value = $this->parsePath($_GET['tPath']);
         $this->original_get = is_numeric(str_replace('_', '', $_GET['tPath'])) ? $_GET['tPath'] : '1';
         $this->cache_name = $this->setCacheString(__FILE__, 'articles_topic', $this->original_get);
         $get_key = 'tPath';
         $query = $this->topics_query;
     } elseif (array_key_exists('authors_id', $_GET)) {
         $this->get_value = $this->parsePath($_GET['authors_id']);
         $this->original_get = (int) $_GET['authors_id'];
         $this->cache_name = $this->setCacheString(__FILE__, 'articles_author', $this->original_get);
         $get_key = 'authors_id';
         $query = $this->authors_query;
     } else {
         $this->get_value = false;
         $this->original_get = false;
         $this->cache_name = $this->setCacheString(__FILE__, 'articles_all', 'general');
         $get_key = false;
         $query = $this->all_topics_query;
     }
     if (false !== ($this->cache_name && $this->retrieve($this->cache_name))) {
         KissMT::init()->setCanonical($this->checkCanonical($get_key));
         return;
     }
     if (false === $this->get_value) {
         $query_replacements = array(':languages_id' => (int) KissMT::init()->retrieve('languages_id'));
         $query = str_replace(array_keys($query_replacements), array_values($query_replacements), $query);
         $result = KissMT::init()->query($query);
         $description = '';
         while ($row = tep_db_fetch_array($result)) {
             if (tep_not_null($row['name'])) {
                 $description .= trim($row['name']) . '[-separator-]';
             }
         }
         $description = tep_not_null($description) ? $description : false;
         $name = defined('HEADING_TITLE') ? HEADING_TITLE : ucfirst(str_replace('_', ' ', substr(KissMT::init()->retrieve('basename'), 0, strlen(KissMT::init()->retrieve('basename')) - 4)));
     } else {
         $query_replacements = array(':' . $get_key => $this->get_value, ':languages_id' => (int) KissMT::init()->retrieve('languages_id'));
         $query = str_replace(array_keys($query_replacements), array_values($query_replacements), $query);
         $result = KissMT::init()->query($query);
         $detail = tep_db_fetch_array($result);
         $name = trim($detail['name']);
         $description = tep_not_null($detail['description']) ? trim($detail['description']) : false;
     }
     tep_db_free_result($result);
     $breadcrumb = array_flip(KissMT::init()->retrieve('breadcrumb'));
     if (array_key_exists($name, $breadcrumb)) {
         unset($breadcrumb[$name]);
     }
     if (array_key_exists($description, $breadcrumb)) {
         unset($breadcrumb[$description]);
     }
     $breadcrumb = array_flip($breadcrumb);
     $leading_values = $name . (!empty($breadcrumb) ? '[-separator-]' . implode('[-separator-]', $breadcrumb) : '');
     KissMT::init()->setCanonical($this->checkCanonical($get_key));
     $this->parse(KissMT::init()->entities($leading_values, $decode = true), KissMT::init()->entities($description, $decode = true));
 }
コード例 #6
0
 public function process()
 {
     $this->get_value = $this->parsePath($_GET['products_id']);
     $this->original_get = (int) $_GET['products_id'];
     $this->cache_name = $this->setCacheString(__FILE__, 'reviews_id', $this->original_get);
     if (false !== $this->retrieve($this->cache_name)) {
         $reviews_string = isset($_GET['reviews_id']) && is_numeric($_GET['reviews_id']) ? '&reviews_id=' . $_GET['reviews_id'] : '';
         KissMT::init()->setCanonical($this->checkCanonical('products_id', $reviews_string));
         return;
     }
     $query_replacements = array(':products_id' => (int) $this->get_value, ':languages_id' => (int) KissMT::init()->retrieve('languages_id'));
     $query = str_replace(array_keys($query_replacements), array_values($query_replacements), $this->products_query);
     $result = KissMT::init()->query($query);
     $reviews_text = '';
     $products_model = '';
     $products_name = '';
     $manufacturers_name = '';
     while ($product_results = tep_db_fetch_array($result)) {
         if (tep_not_null($product_results['products_model'])) {
             $products_model = trim($product_results['products_model']);
         }
         if (tep_not_null($product_results['products_name'])) {
             $products_name = trim($product_results['products_name']);
         }
         if (tep_not_null($product_results['manufacturers_name'])) {
             $manufacturers_name = trim($product_results['manufacturers_name']);
         }
         if (tep_not_null($product_results['reviews_text'])) {
             $reviews_text .= trim(rtrim($product_results['reviews_text'], '.') . '.') . '[-separator-]';
         }
     }
     tep_db_free_result($result);
     $breadcrumb = array_flip(KissMT::init()->retrieve('breadcrumb'));
     if (array_key_exists($products_model, $breadcrumb)) {
         unset($breadcrumb[$products_model]);
     }
     if (array_key_exists($products_name, $breadcrumb)) {
         unset($breadcrumb[$products_name]);
     }
     if (array_key_exists(NAVBAR_TITLE, $breadcrumb)) {
         unset($breadcrumb[NAVBAR_TITLE]);
     }
     $breadcrumb = array_flip($breadcrumb);
     $leading_values = $products_name;
     if (tep_not_null($products_model)) {
         $leading_values .= '[-separator-]' . $products_model;
     }
     $leading_values .= '[-separator-]' . implode('[-separator-]', $breadcrumb);
     if (tep_not_null($manufacturers_name)) {
         $leading_values .= '[-separator-]' . sprintf(KISSMT_BRAND_TEXT, $manufacturers_name);
     }
     $reviews_string = isset($_GET['reviews_id']) && is_numeric($_GET['reviews_id']) ? '&reviews_id=' . $_GET['reviews_id'] : '';
     KissMT::init()->setCanonical($this->checkCanonical('products_id', $reviews_string));
     $this->parse(KissMT::init()->entities(sprintf(KISSMT_PRODUCT_REVIEWS_TEXT, $leading_values), $decode = true), KissMT::init()->entities($reviews_text, $decode = true));
 }
コード例 #7
0
 public function process()
 {
     // Do we have a reviews_id
     if (array_key_exists('reviews_id', $_GET) && tep_not_null($_GET['reviews_id'])) {
         $this->get_value = $this->parsePath($_GET['reviews_id']);
         $this->original_get = (int) $_GET['reviews_id'];
         $this->cache_name = $this->setCacheString(__FILE__, 'ndesk_rev_info', $this->original_get);
         if (false !== $this->retrieve($this->cache_name)) {
             KissMT::init()->setCanonical($this->checkCanonical('newsPath'));
             return;
         }
         $query_replacements = array(':reviews_id' => (int) $this->get_value, ':languages_id' => (int) KissMT::init()->retrieve('languages_id'));
         $query = str_replace(array_keys($query_replacements), array_values($query_replacements), $this->query);
         $result = KissMT::init()->query($query);
         $description = '';
         $name = '';
         $details = tep_db_fetch_array($result);
         $name = trim($details['name']);
         $description .= trim($details['description']);
         $newsdesk_name = trim($details['newsdesk_name']);
         tep_db_free_result($result);
         $description = isset($description) && tep_not_null($description) ? $description : false;
         $name = isset($name) && tep_not_null($name) ? $name : '';
         $newsdesk_name = isset($newsdesk_name) && tep_not_null($newsdesk_name) ? $newsdesk_name : '';
         $breadcrumb = array_flip(KissMT::init()->retrieve('breadcrumb'));
         if (array_key_exists($name, $breadcrumb)) {
             unset($breadcrumb[$name]);
         }
         if (tep_not_null($breadcrumb)) {
             // Is there still something in the breadcrumb array?
             $breadcrumb = array_flip($breadcrumb);
             $leading_values = implode('[-separator-]', $breadcrumb) . (tep_not_null($newsdesk_name) ? '[-separator-]' . $newsdesk_name : '') . (tep_not_null($name) ? '[-separator-]' . $name : '');
         } else {
             // Nothing in the breadcrumb array
             $leading_values = (tep_not_null($newsdesk_name) ? '[-separator-]' . $newsdesk_name : '') . (tep_not_null($name) ? $name : HEADING_TITLE);
         }
     } else {
         // No reviews_id so we'll work with what we have
         $leading_values = implode('[-separator-]', KissMT::init()->retrieve('breadcrumb'));
         $description = false;
     }
     KissMT::init()->setCanonical($this->checkCanonical('reviews_id'));
     $this->parse(KissMT::init()->entities($leading_values, $decode = true), KissMT::init()->entities(trim($description), $decode = true));
 }
コード例 #8
0
 public function gc()
 {
     if (KISSMT_CACHE_RESET !== 'reset') {
         return false;
     }
     foreach (glob(KissMT::init()->retrieve('cache_path') . "*.cache") as $filename) {
         @unlink($filename);
     }
     $query = "SELECT configuration_id FROM " . TABLE_CONFIGURATION . " WHERE configuration_key = 'KISSMT_CACHE_RESET'";
     $result = tep_db_query($query);
     $db_installed = tep_db_fetch_array($result);
     tep_db_free_result($result);
     if (false !== $db_installed) {
         $query = "UPDATE " . TABLE_CONFIGURATION . " SET configuration_value = 'false' WHERE configuration_key = 'KISSMT_CACHE_RESET'";
         tep_db_query($query);
     }
 }
コード例 #9
0
 /**
  * Acquire an array of single or multiple link texts from the query
  * this will be cached for later retrieval.
  * 
  * @see Usu_Main::query()
  * @uses trim()
  * 
  * @access protected
  * @return array array of link test 
  */
 protected function acquireLinkText()
 {
     $result = Usu_Main::i()->query($this->query);
     $text_array = tep_db_fetch_array($result);
     tep_db_free_result($result);
     if (false === $text_array) {
         return false;
     }
     $final_text_array = array();
     foreach ($text_array as $key => $text) {
         if (tep_not_null(trim($text))) {
             $final_text_array[$key] = $text;
         }
     }
     // We will cache this result
     return $final_text_array;
 }
コード例 #10
0
ファイル: edit_orders.php プロジェクト: rrecurse/IntenseCart
     // # important to keep historical pricing / costs for inventory since this can fluctuate with time.
     // # if no cost found in suppliers_products_groups, try the products table for old format
     // # costing from suppliers_products_groups table
     $cost_price_query = tep_db_query("SELECT suppliers_group_price FROM " . TABLE_SUPPLIERS_PRODUCTS_GROUPS . " WHERE products_id = '" . $orders_products['products_id'] . "' AND priority = '0' LIMIT 1");
     $cost_price = tep_db_num_rows($cost_price_query) > 0 ? tep_db_result($cost_price_query, 0) : 0;
     tep_db_free_result($cost_price_query);
     // # costing from products table
     $cost_old_query = tep_db_query("SELECT products_price_myself FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . $orders_products['products_id'] . "'");
     $cost_old = tep_db_num_rows($cost_old_query) > 0 ? tep_db_result($cost_old_query, 0) : 0;
     tep_db_free_result($cost_old_query);
     // # if supplier cost is empty, use old format
     $cost = !empty($cost_price) ? $cost_price : $cost_old;
     // # Retrieve price from products_groups table.
     $pricing_query = tep_db_query("SELECT pg.customers_group_price \n\t\t\t\t\t\t\t\t\t\t   FROM " . TABLE_PRODUCTS_GROUPS . " pg \n\t\t\t\t\t\t\t\t\t\t   LEFT JOIN " . TABLE_CUSTOMERS . " c ON c.customers_group_id = pg.customers_group_id\n\t\t\t\t\t\t\t\t\t\t   LEFT JOIN " . TABLE_ORDERS . " o ON o.customers_id = c.customers_id\n\t\t\t\t\t\t\t\t\t\t   WHERE o.orders_id = '" . $oID . "'\n\t\t\t\t\t\t\t\t\t\t   AND products_id = '" . $orders_products['products_id'] . "'\n\t\t\t\t\t\t\t\t\t\t  ");
     $price = tep_db_num_rows($pricing_query) > 0 ? tep_db_result($pricing_query, 0) : $orders_products['products_price'];
     tep_db_free_result($pricing_query);
     // # populate orders_products_data array
     $order->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => str_replace("'", "'", $orders_products['products_name']), 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => (double) $price, 'cost' => (double) $cost, 'final_price' => $orders_products['final_price'], 'products_id' => $orders_products['products_id'], 'free_shipping' => $orders_products['free_shipping'], 'separate_shipping' => $orders_products['separate_shipping'], 'products_weight' => $orders_products['products_weight'], 'orders_products_id' => $orders_products['orders_products_id'], 'warehouse_id' => $orders_products['warehouse_id']);
     $subindex = 0;
     $attributes_query_string = "select * from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int) $oID . "' and orders_products_id = '" . (int) $orders_products['orders_products_id'] . "'";
     $attributes_query = tep_db_query($attributes_query_string);
     if (tep_db_num_rows($attributes_query)) {
         while ($attributes = tep_db_fetch_array($attributes_query)) {
             $order->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price'], 'orders_products_attributes_id' => $attributes['orders_products_attributes_id']);
             $subindex++;
         }
     }
     $index++;
 }
 // # END while
 ?>
コード例 #11
0
 /**
  * Acquire an array of single or multiple link texts from the query
  * this will be cached for later retrieval.
  * 
  * @see Usu_Main::query()
  * @uses trim()
  * 
  * @access protected
  * @return array array of link test 
  */
 protected function acquireLinkText()
 {
     if (false !== ($final_text_array = Usu_Main::i()->getVar('registry')->retrieve($this->key, $this->keys_index[$this->key]))) {
         if (Usu_Main::monitorPerformance()) {
             Usu_Main::$performance['queries_saved']++;
         }
         return $final_text_array;
     }
     $result = Usu_Main::i()->query($this->query);
     $text_array = tep_db_fetch_array($result);
     tep_db_free_result($result);
     if (false === $text_array) {
         return false;
     }
     $final_text_array = array();
     foreach ($text_array as $key => $text) {
         if (tep_not_null(trim($text))) {
             $final_text_array[$key] = $text;
         }
     }
     // We will cache this result
     Usu_Main::i()->getVar('registry')->attach($this->key, $this->keys_index[$this->key], $final_text_array);
     return $final_text_array;
 }
コード例 #12
0
ファイル: sitemap.php プロジェクト: CristianCCIT/shop4office
 function GenerateSpecialsSitemap($languages_id)
 {
     global $languages_id;
     $products_query = tep_db_query("SELECT p.products_id as pID, s.specials_date_added as date_added, s.specials_last_modified as last_mod, p.products_ordered\n                FROM " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id left join " . TABLE_SPECIALS . " s on pd.products_id = s.products_id\n            where p.products_status = '1' and s.status = '1' and pd.language_id = " . (int) $languages_id . " order by s.specials_date_added desc ");
     if (tep_db_num_rows($products_query) > 0) {
         $this->debug['QUERY']['SPECIALS']['STATUS'] = 'success';
         $this->debug['QUERY']['SPECIALS']['NUM_ROWS'] = tep_db_num_rows($products_query);
         $container = array();
         $number = 0;
         $top = 0;
         while ($result = tep_db_fetch_array($products_query)) {
             $top = max($top, $result['products_ordered']);
             $location = $this->hrefLink(FILENAME_PRODUCT_INFO, 'products_id=' . $result['pID'], 'NONSSL');
             $lastmod = $this->NotNull($result['last_mod']) ? $result['last_mod'] : $result['date_added'];
             $changefreq = GOOGLE_SITEMAP_SPECIALS_CHANGE_FREQ;
             $ratio = $top > 0 ? $result['products_ordered'] / $top : 0;
             $priority = $ratio < 0.1 ? 0.1 : number_format($ratio, 1, '.', '');
             $container[] = array('loc' => htmlspecialchars(utf8_encode($location)), 'lastmod' => date("Y-m-d", strtotime($lastmod)), 'changefreq' => $changefreq, 'priority' => $priority);
             if (sizeof($container) >= 50000) {
                 $type = $number == 0 ? 'specials' : 'specials' . $number;
                 $this->GenerateSitemap($container, $type);
                 $container = array();
                 $number++;
             }
         }
         tep_db_free_result($products_query);
         if (sizeof($container) > 0) {
             $type = $number == 0 ? 'specials' : 'specials' . $number;
             return $this->GenerateSitemap($container, $type);
         }
     } else {
         $this->debug['QUERY']['SPECIALS']['STATUS'] = 'false';
         $this->debug['QUERY']['SPECIALS']['NUM_ROWS'] = '0';
         return $this->GenerateSitemap(array(), 'specials');
     }
 }
コード例 #13
0
/**
 *  * Building the $categories array
 *
 * @param $filepath - Full path to cache
 * @param $order_by sort setting chosed in oscommerce admin
 * @param $languages_id
 * @return Returns the fully built $categories array as well as javascript
 * Copyright for SuckerTree Vertical Menu 1.1
 * @copyright Dynamic Drive: http://www.dynamicdrive.com/style/
 */
function buildCategoriesCache($filepath, $order_by, $languages_id)
{
    $result = categoriesFullScan($order_by, $languages_id);
    $javamenustring = '';
    /**
     * Loop through each row
     * creating the raw $categories array
     */
    while ($row = tep_db_fetch_array($result)) {
        $categories[$row['categories_id']] = array('id' => $row['categories_id'], 'parent' => $row['parent_id'], 'sort' => $row['sort_order'], 'path' => '', 'name' => htmlentities($row['categories_name']));
    }
    tep_db_free_result($result);
    // Housekeeping
    /**
     * Loop through the raw $categories array
     * This time we are adding the following:
     * $categories[<cat_id>]['children'] which is a comma seperated list of this categories children
     * $categories[<cat_id>]['path'] which is the cPath but only for parent categories
     * @param $javamenustring a comma seperated string which is later passed to $categories['menuid_string'] 
     */
    foreach ($categories as $cat_id => $key) {
        if ($key['parent'] != '0') {
            isset($categories[$key['parent']]['children']) && $categories[$key['parent']]['children'] !== NULL ? NULL : ($categories[$key['parent']]['children'] = '');
            $categories[$key['parent']]['children'] .= $key['id'] . ',';
        } else {
            $javamenustring .= '"menu_' . $key['id'] . '",';
            $categories[$key['id']]['path'] .= $key['id'];
        }
    }
    // added version 1.1.2
    /**
     * Loop through the $categories array yet again
     * $categories[<cat_id>]['path'] is created for all categories EXCEPT parent categories
     * Calls on function setCpath to generate muli layer cPaths
     * 
     */
    foreach ($categories as $cat_id => $key) {
        $fullcatpath = '';
        if ($key['parent'] != '0') {
            $fullcatpath = setCpath($categories, $key['id']);
            $categories[$key['id']]['path'] = $fullcatpath;
        }
    }
    $javamenustring = rtrim($javamenustring, ',');
    $categories['menuid_string'] = $javamenustring;
    $categories['menuid_js'] = <<<JSSCRIPT
<script language="javascript" type="text/javascript">
function get_menu_ids() {
var menuids=[{$javamenustring}] //Enter id(s) of SuckerTree UL menus, separated by commas
return menuids;
}
</script>
<script src="includes/javascript/suckertree.js" type="text/javascript"></script>
JSSCRIPT;
    // Serialize and save the $categories array
    $serialized = serialize($categories);
    if (defined('FWR_MENU_RESET') && FWR_MENU_RESET == 'true' || defined('FWR_SUCKERTREE_MENU_ON') && 'true' === FWR_SUCKERTREE_MENU_ON && !file_exists($filepath . $languages_id . "_categories.ser")) {
        /**
         * We are deleting the old cache files so we will delete all files
         * on the relevant directory path with a  .ser filename
         */
        foreach (glob($filepath . "*.ser") as $filename) {
            unlink($filename);
        }
        // Write the new cache
        saveSerializedFile($filepath, $serialized, $languages_id, "_categories.ser");
        // FWR DOM XML - uncomment the line below to activate
        //if( class_exists('DOMDocument') ) sitemapXML($filepath, $categories);
        $sql = "\r\nUPDATE " . TABLE_CONFIGURATION . "\r\nSET `configuration_value` = 'false'\r\nWHERE `configuration_key` = 'FWR_MENU_RESET'";
        //Reset the FWR Menu reset back to false
        tep_db_query($sql) or die('Update failed ' . mysql_error());
    }
    return $categories;
}
コード例 #14
0
ファイル: elmar.inc.php プロジェクト: severnaya99/Sg-2010
function sk_set_language()
{
    global $languages_id, $language_code;
    $language_query = tep_db_query('select languages_id, code from ' . TABLE_LANGUAGES);
    if (tep_db_num_rows($language_query) == 1 && ($language_row = tep_db_fetch_array($language_query))) {
        // Wenn nur eine Sprache definiert ist, benutzen wir diese.
        $languages_id = $language_row['languages_id'];
        $language_code = $language_row['code'];
    } else {
        if (!defined('PROD_DEFAULT_LANGUAGE_ID')) {
            trigger_error('Bitte setzen Sie in der Datei elmar_config.inc.php die Konstante PROD_DEFAULT_LANGUAGE_ID auf die in Ihrem Shop verwendete Sprach-ID.', E_USER_ERROR);
        } else {
            if (!defined('PROD_DEFAULT_LANGUAGE')) {
                trigger_error('Bitte setzen Sie in der Datei elmar_config.inc.php die Konstante PROD_DEFAULT_LANGUAGE auf den in Ihrem Shop verwendeten Sprachcode.', E_USER_ERROR);
            } else {
                $languages_id = PROD_DEFAULT_LANGUAGE_ID;
                $language_code = PROD_DEFAULT_LANGUAGE;
            }
        }
    }
    tep_db_free_result($language_query);
}
コード例 #15
0
function _get_attribute_values_list($products_id)
{
    $res = tep_db_query("SELECT po.products_options_name, pov.products_options_values_name\n        FROM " . TABLE_PRODUCTS_ATTRIBUTES . " pa\n        INNER JOIN " . TABLE_PRODUCTS_OPTIONS . " po\n        ON (pa.options_id = po.products_options_id\n        AND po.language_id = {$GLOBALS['languages_id']})\n        INNER JOIN " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov\n        ON (pa.options_values_id = pov.products_options_values_id\n        AND pov.language_id = {$GLOBALS['languages_id']})\n        WHERE pa.products_id = {$products_id} ");
    $values = array();
    while ($row = tep_db_fetch_array($res)) {
        $values[$row['products_options_name']][] = $row['products_options_values_name'];
    }
    reset($values);
    while (list($id, $value) = each($values)) {
        $result[$id] = implode(",", array_unique($value));
    }
    tep_db_free_result($res);
    return $result;
}
コード例 #16
0
ファイル: Usu_Categories.php プロジェクト: digideskio/oscmax2
 private function get_parents(&$categories, $categories_id)
 {
     $query = "SELECT parent_id \r\n     FROM " . TABLE_CATEGORIES . " \r\n     WHERE categories_id='" . (int) $categories_id . "'";
     $parent_category_query = usu::query($query);
     $parent_category = tep_db_fetch_array($parent_category_query);
     tep_db_free_result($parent_category_query);
     if ($parent_category['parent_id'] == 0) {
         return;
         // We are at the top level so return ending the loop
     }
     $categories[count($categories)] = $parent_category['parent_id'];
     if ($parent_category['parent_id'] != $categories_id) {
         $this->get_parents($categories, $parent_category['parent_id']);
     }
 }
コード例 #17
0
ファイル: feedmachine.php プロジェクト: digideskio/oscmax2
                             $options[$i]['options_values_price'][$products_options_id . $option_value_seperator . $products_options_values['products_options_values_id']] = $products_options_values['options_values_price'];
                         }
                         ++$i;
                     }
                     $combinations = combinations($options, $options_seperator);
                     foreach ($combinations as $combination_id => $combination) {
                         $combination['combination_id'] = $combination_id;
                         $i_rows[$language_id][$products_id][] = array_merge($combination, $products[$language_id][$products_id]);
                     }
                 }
             }
         }
     }
     echo 'products attributes array built' . "\n";
     ob_flush();
     tep_db_free_result($products_attributes_query);
 }
 //
 echo 'feed generation in process...' . "\n";
 ob_flush();
 foreach ($feeds as $cur_feed_id => $cur_feed) {
     foreach ($products[$cur_feed['language_id']] as $row) {
         $rows = array();
         if (isset($i_rows[$cur_feed['language_id']][$row['products_id']]) && $cur_feed['attributes_handling'] == 2) {
             $rows =& $i_rows[$cur_feed['language_id']][$row['products_id']];
         } else {
             $rows[] =& $row;
         }
         foreach ($rows as $product) {
             if (!empty($cur_feed['include_record_function'])) {
                 $include_record = call_user_func_array($cur_feed['include_record_function'], array(&$product));
コード例 #18
0
ファイル: index-menu.php プロジェクト: rrecurse/IntenseCart
 function customers_returning()
 {
     $customers_returning_query = tep_db_query("SELECT COUNT(0)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \t   FROM (\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t   \tSELECT NULL\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM orders\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE date_purchased >= ADDDATE(CURDATE(), INTERVAL 1 - DAYOFWEEK(CURDATE())DAY)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND customers_id !=0\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY customers_id\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tHAVING COUNT(*) > 1\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) AS cnt");
     $customers_returning = tep_db_num_rows($customers_new_query) > 0 ? tep_db_result($customers_returning_query, 0) : 0;
     tep_db_free_result($customers_returning_query);
     return $customers_returning;
 }
コード例 #19
0
ファイル: usu5.php プロジェクト: tapwag/oscommerce_deutsch
 /**
  * Factory to extract data from the various cache strategies
  * 
  * @see Usu_Main::getVar()
  * @see Data_Registry::load()
  * @uses microtime()
  * @uses str_replace()
  * @uses number_format()
  * @uses strlen()
  * @uses gzinflate()
  * @uses base64_decode()
  * @uses unserialize()
  * @uses is_readable()
  * @uses file_get_contents()
  * @param string $cache_name - cache name to extract
  * @param string $cache_type - e.g. mysql, file etc.
  * @param object $object  iCache_System
  * 
  * @access public
  * @return bool
  */
 public function extractCacheData($cache_name, $cache_type, iCache_System $object)
 {
     $cache_seconds = (int) USU5_CACHE_DAYS * 24 * 60 * 60;
     $timestart = microtime(true);
     switch (true) {
         case $cache_type == 'mysql':
             $query = str_replace(':cache_name', $cache_name, $object->extract_query);
             $result = $this->query($query);
             $row = tep_db_fetch_array($result);
             tep_db_free_result($result);
             if (false === $row) {
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 // return insert = true as there is nothing in the database
                 return true;
             }
             if (time() > strtotime($row['cache_date']) + $cache_seconds) {
                 // If the cache has expired
                 $object->gc();
                 // Clear the cache
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 // return insert = true as there is nothing in the database
                 return true;
             } else {
                 // the cache hasn't expired so we retrieve it and set the registry
                 $cache_file_size = number_format(strlen($row['cache_data']) / 1024, 2) . ' kb';
                 $rawdata = gzinflate(base64_decode($row['cache_data']));
                 $this->getVar('registry')->load(unserialize($rawdata));
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 self::$performance['cache_loaded'] = 'true';
                 // return insert = false as we have extracted data from the database
                 return false;
             }
             break;
         case $cache_type == 'file':
             if (is_readable($this->getVar('cache_system_path') . 'cache/' . $cache_name . '.cache')) {
                 $this->getVar('registry')->load(unserialize(gzinflate(file_get_contents($this->getVar('cache_system_path') . 'cache/' . $cache_name . '.cache'))));
                 self::$performance['cache_loaded'] = 'true';
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 return false;
             } else {
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 return true;
             }
             break;
         case $cache_type == 'memcache':
             if (false === ($rawdata = $object->get($cache_name))) {
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 // return insert = true as there is nothing in the database
                 return true;
             }
             $rawdata = gzinflate(base64_decode($rawdata));
             $this->getVar('registry')->load(unserialize($rawdata));
             self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
             self::$performance['cache_loaded'] = 'true';
             // return insert = false as we have extracted data from the database
             return false;
             break;
         case $cache_type == 'sqlite':
             $query = str_replace(':cache_name', $cache_name, $object->extract_query);
             $result = $object->getDb()->query($query);
             $row = $result->fetch();
             if (empty($row)) {
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 // return insert = true as there is nothing in the database
                 return true;
             }
             if (time() > strtotime($row['cache_date']) + $cache_seconds) {
                 // If the cache has expired
                 $object->gc();
                 // Clear the cache
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 // return insert = true as there is nothing in the database
                 return true;
             } else {
                 // the cache hasn't expired so we retrieve it and set the registry
                 $cache_file_size = number_format(strlen($row['cache_data']) / 1024, 2) . ' kb';
                 $rawdata = gzinflate(base64_decode($row['cache_data']));
                 $this->getVar('registry')->load(unserialize($rawdata));
                 self::$performance['time_extracting_cache'] = number_format(microtime(true) - $timestart, 4);
                 self::$performance['cache_loaded'] = 'true';
                 // return insert = false as we have extracted data from the database
                 return false;
             }
             break;
         default:
             trigger_error(__CLASS__ . '::' . __FUNCTION__ . ' unknown type passed as: ' . $type, E_USER_WARNING);
             break;
     }
 }
コード例 #20
0
ファイル: cache.class.php プロジェクト: digideskio/oscmax2
 function is_cached($name, &$is_cached, &$is_expired)
 {
     // NOTE: $is_cached and $is_expired is passed by reference !!
     # query for the expiration date
     $this->cache_query = tep_db_query("SELECT cache_expires FROM cache WHERE cache_id='" . md5($name) . "' AND cache_language_id='" . (int) $this->lang_id . "' LIMIT 1");
     # check to see if there were any rows returned
     $is_cached = tep_db_num_rows($this->cache_query) ? true : false;
     if ($is_cached) {
         // there were rows returned
         # fetch the array
         $check = tep_db_fetch_array($this->cache_query);
         # check to see if it is expired
         $is_expired = $check['cache_expires'] <= date("Y-m-d h:i:s") ? true : false;
         # unset $check...clean as we go
         unset($check);
     }
     # free the result...clean as we go
     tep_db_free_result($this->cache_query);
 }
コード例 #21
0
                } else {
                    sk_generate_line();
                }
            }
        } else {
            $kategorie = sk_generate_category_path($products_id);
            //--> nur bestimmte Produktkategorien
            #if ($productfiletype!='pangora' || preg_match('/^hardware\|grafikkarten$|software|action/i', $kategorie))
            //<--
            sk_generate_line();
        }
    }
    if (!$output_compression) {
        flush();
    }
    tep_db_free_result($rs);
    $limit_from += DB_STEP;
} while (!$db_part && $count == DB_STEP && $bytes < $to_bytes);
if ($fh) {
    flock($fh, LOCK_UN);
    // release the lock
    fclose($fh);
}
if ($output_compression) {
    ob_end_flush();
}
productLog(TRUE);
exit;
###########################################################################
// Erzeugt eine Zeile der Produktdatei
function sk_generate_line($category_text = '', $category_id = '')
コード例 #22
0
ファイル: backup.php プロジェクト: rabbit-source/setbook.ru
 function backup()
 {
     global $HTTP_POST_VARS;
     $this->SET['comp_method'] = tep_not_null($HTTP_POST_VARS['compress']) && $HTTP_POST_VARS['compress'] != '0' ? intval($HTTP_POST_VARS['compress']) : '';
     $this->SET['comp_level'] = 5;
     $tables = array();
     $result = tep_db_query("SHOW TABLES");
     $all = 0;
     while ($row = tep_db_fetch_row($result)) {
         $tables[] = $row[0];
     }
     $tabs = count($tables);
     // Определение размеров таблиц
     $result = tep_db_query("SHOW TABLE STATUS");
     $tabinfo = array();
     $tab_charset = array();
     $tab_type = array();
     $tabinfo[0] = 0;
     $info = '';
     while ($item = tep_db_fetch_array($result)) {
         if (in_array($item['Name'], $tables)) {
             $item['Rows'] = empty($item['Rows']) ? 0 : $item['Rows'];
             $tabinfo[0] += $item['Rows'];
             $tabinfo[$item['Name']] = $item['Rows'];
             $tabsize[$item['Name']] = 1 + round(LIMIT * 1048576 / ($item['Avg_row_length'] + 1));
             if ($item['Rows']) {
                 $info .= "|" . $item['Rows'];
             }
             if (!empty($item['Collation']) && preg_match("/^([a-z0-9]+)_/i", $item['Collation'], $m)) {
                 $tab_charset[$item['Name']] = $m[1];
             }
             $tab_type[$item['Name']] = isset($item['Engine']) ? $item['Engine'] : $item['Type'];
         }
     }
     $show = 10 + $tabinfo[0] / 50;
     $info = $tabinfo[0] . $info;
     $this->backup_file = DIR_FS_BACKUP . 'db_' . DB_DATABASE . '-' . date("YmdHis") . '.sql';
     $fp = $this->fn_open($this->backup_file, "w");
     $this->fn_write($fp, '#SKD101|{' . DB_DATABASE . '|' . $tabs . '|' . date("Y.m.d H:i:s") . '|' . $info . "\n\n");
     $t = 0;
     $result = tep_db_query("SET SQL_QUOTE_SHOW_CREATE = 1");
     // Кодировка соединения по умолчанию
     if ($this->mysql_version > 40101 && DB_CHARSET != 'auto') {
         tep_db_query("SET NAMES '" . DB_CHARSET . "'");
         $last_charset = DB_CHARSET;
     } else {
         $last_charset = '';
     }
     if (!is_array($tables)) {
         $tables = array();
     }
     reset($tables);
     while (list(, $table) = each($tables)) {
         // Выставляем кодировку соединения соответствующую кодировке таблицы
         if ($this->mysql_version > 40101 && $tab_charset[$table] != $last_charset) {
             if (DB_CHARSET == 'auto') {
                 tep_db_query("SET NAMES '" . $tab_charset[$table] . "'");
                 $last_charset = $tab_charset[$table];
             }
         }
         // Создание таблицы
         $result = tep_db_query("SHOW CREATE TABLE `{$table}`");
         $tab = tep_db_fetch_row($result);
         $tab = preg_replace('/(default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP|DEFAULT CHARSET=\\w+|COLLATE=\\w+|character set \\w+|collate \\w+)/i', '/*!40101 \\1 */', $tab);
         $this->fn_write($fp, "DROP TABLE IF EXISTS `{$table}`;\n{$tab[1]};\n\n");
         // Проверяем нужно ли дампить данные
         if (in_array($tab_type[$table], $this->only_create)) {
             continue;
         }
         // Опредеделяем типы столбцов
         $NumericColumn = array();
         $result = tep_db_query("SHOW COLUMNS FROM `{$table}`");
         $field = 0;
         while ($col = tep_db_fetch_row($result)) {
             $NumericColumn[$field++] = preg_match("/^(\\w*int|year)/", $col[1]) ? 1 : 0;
         }
         $fields = $field;
         $from = 0;
         $limit = $tabsize[$table];
         $limit2 = round($limit / 3);
         $i = 0;
         while (($result = tep_db_query("SELECT * FROM `{$table}` LIMIT {$from}, {$limit}")) && ($total = tep_db_num_rows($result))) {
             if ($i == 0) {
                 $this->fn_write($fp, "INSERT INTO `{$table}` VALUES");
             }
             while ($row = tep_db_fetch_row($result)) {
                 $i++;
                 $t++;
                 for ($k = 0; $k < $fields; $k++) {
                     if ($NumericColumn[$k]) {
                         $row[$k] = isset($row[$k]) ? $row[$k] : "NULL";
                     } else {
                         $row[$k] = isset($row[$k]) ? "'" . mysql_escape_string($row[$k]) . "'" : "NULL";
                     }
                     $row[$k] = str_replace(array('\\\\"', '\\"', "\\\\'"), array('"', '"', "\\'"), $row[$k]);
                 }
                 $this->fn_write($fp, ($i == 1 ? "" : ",") . "\n(" . implode(", ", $row) . ")");
             }
             tep_db_free_result($result);
             if ($total < $limit) {
                 break;
             }
             $from += $limit;
         }
         if ($total > 0) {
             $this->fn_write($fp, ";\n\n");
         }
     }
     $this->fn_close($fp);
 }
コード例 #23
0
ファイル: sales_report.php プロジェクト: rrecurse/IntenseCart
 function export($filter = '', $dateMode = '', $date_from = '', $date_to = '', $channel = '')
 {
     $filename = SITE_DOMAIN . '_sales_stats_' . $this->date_from->format('m-d-Y') . '_to_' . $this->date_to->format('m-d-Y') . '.csv';
     $filename = str_replace('www.', '', $filename);
     header('Content-Type: text/csv');
     header('Content-Disposition: attachment; filename=' . $filename);
     $header[] = 'Date, No. of Orders, No. of Items, Avg. Order Amount, Total Amount';
     print implode(',', $header) . "\r\n";
     if ($this->dateMode == 'H') {
         $datemode = '%H:00:00';
     } elseif ($this->dateMode == 'Y') {
         $datemode = '%Y';
     } elseif ($this->dateMode == 'd') {
         $datemode = '%m/%d/%Y';
     } elseif ($this->dateMode == 'w') {
         $datemode = 'week %v %x';
     } elseif ($this->dateMode == 'm') {
         $datemode = '%b - %Y';
     }
     $export_query1 = "SELECT DATE_FORMAT(o.date_purchased, '" . $datemode . "') AS 'Date',\n\t\t\t\t\t\t \t\t COUNT(ot.value) AS 'No. of Orders',\n\t\t\t\t\t\t\t\t SUM(theitems) AS 'No. of Items',\n\t\t\t\t\t\t \t\t CONCAT('\$', FORMAT(AVG(ot.value), 2)) AS 'Avg. Order Amount',\n\t\t\t\t\t\t\t\t CONCAT('\$', FORMAT(SUM(ot.value), 2)) AS 'Total Amount'\n\t\t\t\t\t  \t  FROM " . TABLE_ORDERS . " o\n\t\t\t\t\t  \t  LEFT JOIN " . TABLE_ORDERS_TOTAL . " ot ON ot.orders_id = o.orders_id\n\t\t\t\t\t\t  LEFT JOIN (SELECT orders_id, SUM(products_quantity) AS theitems FROM orders_products GROUP BY orders_id\n\t\t\t\t\t\t\t\t\t) op ON o.orders_id = op.orders_id\n\t\t\t\t\t\t  WHERE ot.class = 'ot_total' \n\t\t\t\t\t \t  " . $this->filter_sql . $this->channel;
     for ($i = 0; $i < $this->size; $i++) {
         $export_query = tep_db_query($export_query1 . " AND o.date_purchased >= '" . $this->dates_from[$i]->format('Y-m-d 00:00:01') . "' AND o.date_purchased <= '" . $this->dates_to[$i]->format('Y-m-d 23:59:59') . "'");
         $row = tep_db_fetch_array($export_query);
         tep_db_free_result($export_query);
         foreach ($row as $value) {
             $values[] = '"' . str_replace('"', '""', html_entity_decode(strip_tags($value))) . '"';
         }
         print implode(',', $values) . "\r\n";
         unset($values);
     }
     exit;
 }
コード例 #24
0
 protected function acquire($base_path, $full_path)
 {
     $this->dependency_value = $full_path;
     // Full path perhaps with underscores
     /**
      * About placeholders
      *  
      * The placeholders (items with a colon :) must match those in the query ( $this->base_query in the constructor )
      */
     $placeholders = array(':info_id', ':languages_id');
     // Do the below values need to be typecast?
     $values = array((int) $base_path, (int) usu::$languages_id);
     // xxx These values will replace the placeholders above in $this->base_query
     $this->query = str_replace($placeholders, $values, $this->base_query);
     // Replace the placeholders with actual values
     $result = usu::query($this->query);
     // Action the query
     $this->query = null;
     // Unset the query for future usage
     $row = tep_db_fetch_array($result);
     // Return the array of data ( or false if there are no results )
     tep_db_free_result($result);
     // Housekeeping
     if (false === $row) {
         return false;
         // No results for the query so abort
     }
     /**
      *  Values obtained from the query, these properties will populate the registry via the method getProperties()
      * Method $this->linkText() should be used here to convert the text into seo url format e.g.
      * my great product .. may become .. my-great-product
      * You may have more than one of these like ..
      * $this->parentname, $this->catname dependent on how many results you retrieve from your query
      */
     $this->information_title = $this->linkText($row['information_title']);
     // If the registry item doesn't exist as a key then set a blank array
     if (false === isset(usu::$registry->{self::DEPENDENCY})) {
         usu::$registry->{self::DEPENDENCY} = array();
     }
     /**
      * Populate the registry with the properties we have set in this class
      */
     usu::$registry->attach(self::DEPENDENCY, $this->dependency_value, $this->getProperties());
 }
コード例 #25
0
 /**
  * Set the sort order of our configuration group id
  * @uses str_replace()
  * 
  * @access public
  * @return Installer_Class - chaining 
  */
 public function getMaxSort()
 {
     $to_replace = array(':TABLE_CONFIGURATION_GROUP');
     $replacements = array(TABLE_CONFIGURATION_GROUP);
     $result = tep_db_query(str_replace($to_replace, $replacements, $this->max_sort_query));
     $row = tep_db_fetch_array($result);
     tep_db_free_result($result);
     $this->sort_order = $row['current_max'] + 1;
     return $this;
 }
コード例 #26
0
ファイル: index.php プロジェクト: tapwag/oscommerce_deutsch
 private function descriptionsExtension($type = false)
 {
     if (false === (defined('KISSMT_DESCRIPTIONS_EXTENSION_ENABLE') && KISSMT_DESCRIPTIONS_EXTENSION_ENABLE == 'true')) {
         return false;
     }
     if ($type == 'category') {
         $query = "SELECT kissmt_categories_description FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = " . (int) $this->get_value . " AND language_id = " . (int) KissMT::init()->retrieve('languages_id') . "";
         $result = tep_db_query($query);
         $row = tep_db_fetch_array($result);
         tep_db_free_result($result);
         if (false !== (false !== $row && tep_not_null($row['kissmt_categories_description']))) {
             $this->descriptions_extension = true;
             $this->description = array('kissmt_categories_description' => $row['kissmt_categories_description']);
             return;
         }
     } elseif ($type == 'manufacturer') {
         $query = "SELECT m.manufacturers_name, mi.kissmt_manufacturers_description FROM " . TABLE_MANUFACTURERS . " m INNER JOIN " . TABLE_MANUFACTURERS_INFO . " mi ON mi.manufacturers_id = m.manufacturers_id AND mi.languages_id = " . (int) KissMT::init()->retrieve('languages_id') . " WHERE m.manufacturers_id = " . (int) $this->get_value . "";
         $result = tep_db_query($query);
         $row = tep_db_fetch_array($result);
         tep_db_free_result($result);
         if (false !== (false !== $row && tep_not_null($row['kissmt_manufacturers_description']))) {
             $this->descriptions_extension = true;
             $this->description = array('manufacturers_name' => $row['manufacturers_name'], 'kissmt_manufacturers_description' => $row['kissmt_manufacturers_description']);
             return;
         }
     }
     $this->descriptions_extension = false;
     $this->description = false;
 }
コード例 #27
0
ファイル: index.php プロジェクト: rrecurse/IntenseCart
    <td width="90%" >
<a href="/admin/" class="logo"></a>
</td>
    <td style="text-align:right; padding:15px 10px 5px 0;"><div style="background-color:#FFFFDF; width:380px; height:37px; border:1px solid #CCC; padding:4px 10px 5px 0;"><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="35" valign="top"><div style="position:relative;"><div style="position:absolute; top:-9px; left:-9px;"><img src="images/admin_user.png" alt="" width="36" height="48"></div></div></td><td>

<?php 
$query = tep_db_query("SELECT * FROM `admin_sessions` \r\n\t\t\t\t\t\t   WHERE admin_user NOT LIKE 'dbfeed_%'\r\n\t\t\t\t\t\t   ORDER BY `admin_sessions`.`access_time` DESC \r\n\t\t\t\t\t\t   LIMIT 1, 1\r\n\t\t\t\t\t\t  ");
echo '<table border="0" cellspacing="0" cellpadding="1" align="right"><tr><td nowrap>
			<b style="color:#7395C3; font:bold 11px arial;">Domain:&nbsp; </b><b style="font:bold 11px arial;">' . preg_replace('/^www\\./', '', SITE_DOMAIN) . '</b></td>';
echo '<td rowspan ="2" style="text-align:right; line-height:17px; padding-left:17px;" nowrap><b style="color:#7395C3; font:bold 11px arial;">Last login:&nbsp;</b> <b style="font:bold 11px arial;">';
if (tep_db_num_rows($query) > 0) {
    while ($user = tep_db_fetch_array($query)) {
        echo date('n/j/Y g:ia', strtotime($user['access_time']) - 18000);
        echo '</b><br><b style="color:#7395C3">by:&nbsp;</b> <b style="font:bold 11px arial;">' . ($user['admin_user'] == '.intensecart' ? 'Admin' : $user['admin_user']) . '</b>';
    }
    tep_db_free_result($query);
} else {
    echo 'No users found!';
}
echo '</td></tr><td nowrap>';
$logged_in_query = tep_db_query("SELECT admin_user FROM admin_sessions WHERE admin_sessid = '" . $_COOKIE['admin_sessid'] . "'");
$logged_in = tep_db_num_rows($logged_in_query) > 0 ? tep_db_result($logged_in_query, 0) : '';
echo '<b style="color:#7395C3; font:bold 11px arial;">Logged in as:</b> &nbsp;<b style="font:bold 11px arial; text-transform: capitalize;">' . ($logged_in == '.intensecart' ? 'Admin' : $logged_in) . '</b>';
echo '</td>';
echo '</tr></table>';
?>

</td></tr></table></div></td>
  </tr>
  <tr>
    <td colspan="2" valign="top">