Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

RWork

Members
  • Posts

    6
  • Joined

  • Last visited

Profile Information

  • Real Name
    werkman

Recent Profile Visitors

7,279 profile views

RWork's Achievements

  1. @@Gergely the error is fixed now thank you very much for your help
  2. @ gergely for testing i did a fresh install of the 2.3.3.2 and installed ultimate seo urls 5 on it, wich gives the same errors. u can initiate the error by changing eg: samsung-galaxy-tab-p-28.html to samsung-galaxy-tab-p-280.html (wich must give an 404 error message) i post my /home/xxxxxxx/public_html/includes/modules/ultimate_seo_urls5/page_modules/product_info.php here: <?php /** * * ULTIMATE Seo Urls 5 PRO ( version 1.1 ) * * * @package USU5_PRO * @@licensed2kill http://www.opensource.org/licenses/gpl-2.0.php GNU Public License * @@Link http://www.fwrmedia.co.uk * @@copyright Copyright 2008-2009 FWR Media * @@copyright Portions Copyright 2005 ( rewrite uri concept ) Bobby Easland * @@author Robert Fisher, FWR Media, http://www.fwrmedia.co.uk * @lastdev $Author:: Rob $: Author of last commit * @lastmod $Date:: 2011-01-26 15:27:34 +0000 (Wed, 26 Jan 2011) $: Date of last commit * @version $Rev:: 199 $: Revision of last commit * @Id $Id:: product_info.php 199 2011-01-26 15:27:34Z Rob $: Full Details */ /** * Page module for product_info * * @package USU5_PRO */ class Product_Info_Page_Module extends aPage_Modules { private static $_singleton = null; /** * Array of _GET key dependencies for this page * - marker is the seo url replacement for the _GET key ( e.g. -c-1 replaces cPath=1 ) * - query is the query used to extract the link text from the database * - to_replace is an array of texts that are to be replace with real values in the query * * @var array $dependencies */ protected $dependencies = array( 'products_id' => array( 'marker' => '-p-', 'query' => "SELECT pd.products_name, m.manufacturers_name, cd.categories_name, p.products_model, p2c.categories_id FROM :TABLE_PRODUCTS_DESCRIPTION pd INNER JOIN :TABLE_PRODUCTS_TO_CATEGORIES p2c ON p2c.products_id = pd.products_id INNER JOIN :TABLE_PRODUCTS p ON pd.products_id = p.products_id LEFT JOIN :TABLE_MANUFACTURERS m ON m.manufacturers_id = p.manufacturers_id INNER JOIN :TABLE_CATEGORIES_DESCRIPTION cd ON p2c.categories_id = cd.categories_id AND cd.language_id=':languages_id' WHERE pd.products_id=':pid' AND pd.language_id=':languages_id' LIMIT 1", 'to_replace' => array( ':TABLE_PRODUCTS_DESCRIPTION', ':TABLE_PRODUCTS_TO_CATEGORIES', ':TABLE_PRODUCTS', ':TABLE_MANUFACTURERS', ':TABLE_CATEGORIES_DESCRIPTION', ':languages_id', ':pid' ) ) ); /** * The current dependency key extracted from the incoming parameters * * @var string $key - dependency key */ protected $key = null; /** * extracts the key => value pairs from the querystring in order to build a unique cache name for the loaded page * * @var array $cache_name_builder */ protected $cache_name_builder = array( 'products_id' => 1, 'page' => 1 ); /** * Class constructor * @access private */ private function __construct() { } // end constructor /** * Returns a singleton instance of this object * * @access public * @return Product_Info_Page_Module */ public static function i() { if ( !self::$_singleton instanceof self ) { self::$_singleton = new self; } return self::$_singleton; } // end method /** * Retrieve the dependencies array for this page module * * @access public * @return array $dependencies */ public function retrieveDependencies() { return $this->dependencies; } /** * 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; } /** * The main method of this class that receives input needed to build a link * then finally returns a fully built seo link if it has not previousluy returned false. * * @see Usu_Main::getVar() * @see Usu_Main::setVar() * @see aPage_Modules::stripPathToLastNumber() * @see aPage_Modules::setQuery() * @see aPage_Modules::unsetProperties() * @see aPage_Modules::getDependencyKey() * @see aPage_Modules::setAllParams() * @see aPage_Modules::validRequest() * @see aPage_Modules::returnFinalLink() * @param string $page - valid osCommerce page name * @param string $parameters - querystring parameters * @param bool $add_session_id - true / false * @param string $connection - NONSSL / SSL * @param array $extract - array of _GET keys to remove from the querystring or bool false to do nothing * @uses trigger_error() * @throws - triggers an error of type E_USER_WARNING for an incorrect or inexistant dependency key * @access public * @return bool false - forces the system to return the standard osCommerce link wrapper * @return string - fully built seo url */ public function buildLink( $page, $parameters, $add_session_id, $connection ) { $extract = ( defined( 'USU5_ADD_CPATH_TO_PRODUCT_URLS' ) && ( USU5_ADD_CPATH_TO_PRODUCT_URLS == 'false' ) ) ? array( 'cPath', 'manufacturers_id' ) : array( 'manufacturers_id' ); $this->setAllParams( $page, $parameters, $add_session_id, $connection, $extract ); if ( false === $this->validRequest() ) { return false; } $this->key = $this->getDependencyKey(); /** * If the shop has issues it may pass in null values, in this case return false to force the standard osCommerce link wrapper */ if ( !array_key_exists( $this->key, $this->keys_index ) || !tep_not_null( $this->keys_index[$this->key] ) ) { return false; } // Switch statement where the correct query and query marker replacements to use are selected via the _GET key detected switch ( true ) { case $this->key == 'products_id': // This array contains replacements for the to_replace array $this->setQuery( array( TABLE_PRODUCTS_DESCRIPTION, TABLE_PRODUCTS_TO_CATEGORIES, TABLE_PRODUCTS, TABLE_MANUFACTURERS, TABLE_CATEGORIES_DESCRIPTION, Usu_Main::i()->getVar( 'languages_id' ), $this->keys_index[$this->key] ) ); break; default: trigger_error( __CLASS__ . '::' . __FUNCTION__ . ' Incorrect or inexistant dependency key.', E_USER_WARNING ); break; } // end switch $link_text = $this->acquireLinkText(); // If the query returned no results then we return false forcing the use of the standard osCommerce link wrapper Usu_Main::i()->setVar( 'page_not_found', false ); if ( false === $link_text ) { Usu_Main::i()->setVar( 'page_not_found', true ); $this->unsetProperties(); return; } return $this->returnFinalLink( Usu_Main::i() ->getVar( 'uri_modules', USU5_URLS_TYPE ) ->createLinkString( $this->page, Usu_Main::i() ->getVar( 'uri_modules', USU5_URLS_TYPE ) ->separateUriText( $this->linktext( $this->linkTextOrder( $link_text ) ) ), $this->dependencies[$this->key]['marker'], $this->keys_index[$this->key] ) ); } // end method /** * Like text options offered by b,c,m,p * * Builds the link text based on the settings chosen in admin .. products name must be present or the script adds it regardless. * * @uses array_key_exists() * @uses stripos() * @uses str_split() * @uses array_flip() * @uses array_intersect_key() * @uses count() * @param array $details - link text key=>value pairs * * @access private * @return array $to_seperate - array of link text options in the correct order */ private function linkTextOrder( array $details = array() ) { $text_types = array( 'p' => $details['products_name'], 'c' => $details['categories_name'], 'm' => $details['products_model'] ); // manufacturers_name is gained through a left join and may not exist array_key_exists( 'manufacturers_name', $details ) ? $text_types['b'] = $details['manufacturers_name'] : null; // Products name MUST be present, if not we force it to the end if ( false === stripos( USU5_PRODUCTS_LINK_TEXT_ORDER, 'p' ) ) { $admin_order = str_split( USU5_PRODUCTS_LINK_TEXT_ORDER . 'p' ); } else $admin_order = str_split( USU5_PRODUCTS_LINK_TEXT_ORDER ); // Split the string value entered in admin ( like mcp etc ) to an array $text_order = array_flip( $admin_order ); // Flip key => value to value => key $text_to_format = array_intersect_key( $text_types, $text_order ); // return only those key => value pairs that match the admin selection $link_text_count = count( $admin_order ); $ordered_array = array(); for ( $i=0; $i<$link_text_count; $i++ ) { if ( ( array_key_exists( $admin_order[$i], $text_to_format ) && tep_not_null( $text_to_format[$admin_order[$i]] ) ) ) { // If a value is empty then we don't want to add it to the link text $to_seperate[] = $text_to_format[$admin_order[$i]]; // Create an array where the link text is in the same order as the admin selection } } return $to_seperate; } // End method } // end class
  3. More issues with Ultimate Seo Urls 5 pro since updating from version 2.3.3.1 to version 2.3.3.2 cache to mysql gave errors and also 404 redirect messages (from removed product) are giving an error: Warning: Invalid argument supplied for foreach() in /home/xxxxxxx/public_html/includes/modules/ultimate_seo_urls5/page_modules/product_info.php on line 102 Catchable fatal error: Argument 1 passed to aPage_Modules::linkText() must be an array, null given, called in /home/xxxxxxx/public_html/includes/modules/ultimate_seo_urls5/page_modules/product_info.php on line 170 and defined in /home/xxxxxxx/public_html/includes/modules/ultimate_seo_urls5/abstracts/page_modules.php on line 338. Maybe there are more issues with this contribution not noticed yet. Any solutions??
×
×
  • Create New...