Jump to content
FWR Media

ULTIMATE Seo Urls 5 - by FWR Media

Recommended Posts

hi,

 

i've moved my shop to another hoster, now the categorie-link which contains a umlaut (ä) is not working, the umlaut will be passed to the hyperlink.

in the configuration i set the character conversion "ä=>ae,Ä=>AE,ü=>ue,Ü=>UE,ö=>oe,Ö=>OE,&=>und,ß=>sz", on my old hoster it was working fine but now i have this problem.

i've tried to reset the cache, i deleted the the cache and disabled the caching system but nothing works.

 

any ideas?

 

maybe the file based character conversion is a solution!? --> how can i set up the file based character conversion?

Share this post


Link to post
Share on other sites

this is my htaccsess file for my localhost , im getting internal server error , anyone know why is this happening ?

 

 

# Begin Ultimate SEO V2.2d

Options +FollowSymLinks

RewriteEngine On

 

# RewriteBase instructions

# Change RewriteBase dependent on how your shop is accessed as below.

# http://www.mysite.com = RewriteBase /

# http://www.mysite.com/catalog/ = RewriteBase /catalog/

# http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/

 

# Change the following line using the instructions above

 

RewriteBase http://localhost/osc = RewriteBase /osc/

 

RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}

RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING}

RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING}

RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING}

RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING}

RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING}

RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING}

RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING}

RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING}

# End Ultimate SEO V2.2d

ooth.php?pollid=$2&%{QUERY_STRING}

# End Ultimate SEO V2.2d

Share this post


Link to post
Share on other sites

Hi. Thx for this contrib. Is really nice, and work right.

 

But i have a litle problem whit the sitemap languages.

 

sitemapProducts.xml

 

In this xml the url,s are duplicated.

 

<loc>http://www.divingmania.es/liquidaciones/scubapro/aletas-scubapro-twin-p-2757.html</loc>

<loc>http://www.divingmania.es/liquidaciones/scubapro/aletas-scubapro-twin-p-2757.html</loc>

<loc>http://www.divingmania.es/liquidaciones/scubapro/aletas-scubapro-twin-p-2757.html</loc>

 

I think is because dont get the language, and show only the defaut language.

 

But sitemapCategories.xml and sitemapIndex.xml work right... this last 2 xml show all languages right.

 

I just install the last upgrade Ultimate_Seo_Urls_5_PRO_r205_1 yesterday, and i try to found the solution all morning, and i read all theme with out found the solution.

 

Can you helpme please?

 

Thanks a lot.

Edited by DivingmaniaPalafrugell

Share this post


Link to post
Share on other sites

Hello.

 

I have a question .....

 

ultimate_seo_urls5/includes/usu_general_functions

 

This is the original function

 

  function usu_cleanse( $value ) {
    return preg_replace( '@[^a-z0-9_]@i', '', $value );
 }

 

I need [] because I use query array like gender[]=male&gender[]=female

And also I need "-" character because for example http://www.domain.com/product_info.php?products_id=6770&utm_campain=zz-cc it redirect to

http://www.domain.com/products-name-p-6770.html?utm_campain=zzcc and it removes the - character from the query

 

It is safe to change function to?

 

  function usu_cleanse( $value ) {
   return preg_replace( '@[^a-z0-9_ \%\+\[\]-]@i', '', $value );
 }

 

I added [], -

Share this post


Link to post
Share on other sites

I use ULTIMATE Seo Urls 5 several years now and i want to know if it's somehow possible to exclude/hide the products_id number in the URL? I've noticed that alot of urls found on google are linked to other product pages after updating/uploading products.

Share this post


Link to post
Share on other sites

Just to confirm for other users.

 

There was no bug in USU5 PRO, in this case the users includes/configure.php file was wrong.

 

DIR_FS_CATALOG must contain the full path to the root of the shop installation.

 

Hi,

 

I have error

strpos(): Empty delimiter in /raid0/www/.../catalog/includes/modules/ultimate_seo_urls5/main/bootstrap.php on line 121

 

DIR_FS_CATALOG contain the full path to the root

 

any solutions please

Share this post


Link to post
Share on other sites

I've upgraded ULTIMATE Seo Urls 5 to Ultimate Seo Urls 5 PRO r205 now my website went blank. I've changed all coding back to ULTIMATE Seo Urls 5 and reuploaded the ultimate_seo_urls5 file: still blank: now what to do?

Edited by OSC_FREAK

Share this post


Link to post
Share on other sites

hey there, i am having some issues, i could use some help

 

having issues with getting all my links to rewrite.

could i get some assistance?

 

i have it partially working on my main live site, but the catagories are not rewriting: https://www.irepairworks.com/products.php?cPath=25_29

products are working : https://www.irepairworks.com/iphone-3gs-diagnostic-service-p-94.html

 

here is following .httaccess:

------------------------------------------------

 

Options +FollowSymLinks

 

<IfModule mod_rewrite.c>

 

 

 

RewriteEngine on

 

 

 

RewriteCond %{HTTP_HOST} ^irepairworks\.com [NC]

 

RewriteRule ^(.*)$ http://www.irepairworks.com/$1 [R=301,L]

 

 

 

RewriteCond %{HTTPS} off

 

RewriteRule ^(.*)$ https://%{SERVER_NAME}%{REQUEST_URI} [R=301,L]

 

 

 

 

 

# RewriteBase instructions

 

# Change RewriteBase dependent on how your shop is accessed as below.

 

# http://www.mysite.com = RewriteBase /

 

# http://www.mysite.com/catalog/ = RewriteBase /catalog/

 

# http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/

 

 

 

# Change RewriteBase using the instructions above

 

RewriteBase /

 

RewriteRule ^([a-z0-9/-]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA]

 

RewriteRule ^iPhone-3g-Repair\.html$ /products.php?cPath=25_28 [L]

RewriteRule ^([a-z0-9/-]+)-c-([0-9_]+).html$ index.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-m-([0-9]+).html$ index.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-pi-([0-9]+).html$ popup_image.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-pr-([0-9]+).html$ product_reviews.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-pri-([0-9]+).html$ product_reviews_info.php [NC,L,QSA]

 

# Articles contribution

 

RewriteRule ^([a-z0-9/-]+)-t-([0-9_]+).html$ articles.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-au-([0-9]+).html$ articles.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-a-([0-9]+).html$ article_info.php [NC,L,QSA]

 

# Information pages

 

RewriteRule ^([a-z0-9/-]+)-i-([0-9]+).html$ information.php [NC,L,QSA]

 

# Links contribution

 

RewriteRule ^([a-z0-9/-]+)-links-([0-9_]+).html$ links.php [NC,L,QSA]

 

# Newsdesk contribution

 

RewriteRule ^([a-z0-9/-]+)-n-([0-9]+).html$ newsdesk_info.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-nc-([0-9]+).html$ newsdesk_index.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-nri-([0-9]+).html$ newsdesk_reviews_info.php [NC,L,QSA]

 

RewriteRule ^([a-z0-9/-]+)-nra-([0-9]+).html$ newsdesk_reviews_article.php [NC,L,QSA]

 

</IfModule>

Share this post


Link to post
Share on other sites

Hi

 

Just did a fresh install and added modular SEO header and this contribution.

 

Works fine except on products containing '®' (registered in case it snafus)

 

For example

 

Fat Grabbers® (180 caps) NEW SIZE!

 

URL generated ends

 

/catalog/product_info.php/fat-grabbers®-180-caps-new-size-p-158

 

and get this error message

 

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

 

Replace non alpa numerics is set to true.

 

If I add a char conversion I get

 

/catalog/product_info.php/fat-grabbersÂr-180-caps-new-size-p-158

 

Any thought on what can be causeing this?

 

(and how to resolve it too!!)

 

Thanks

 

G


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Hello.

To improve my RC2A site SEO ranking I've recently upgraded from old chemo's v21da_1_2 to the new USU5 r205 , but some function is (still) not working:

  1. When I manually enter a url for an item that is not active anymore it still displays the "product not found" page (with a normal HTTP/1.1 200 OK instead of a 404 error. Is this normal? Should I want a 404 page here? If yes: how can I make this to work?
  2. Im using the Multi Language system now so my default language (Dutch) is normal / url and the English is /en/ , but google still has many ?language=en urls in its system, is it smart to to 301 the ?language=en to the /en/ urls? If so: how can I make this to work?

Share this post


Link to post
Share on other sites

Hello All!

 

I updated my OSC2.1.3 in encoding UTF8 (strpos-> mb_strpos, substr-> mb_substr, mb_strlen -> mb_mb_strlen etc..)

 

It works but I have this message in the forehead frontoffice and backoffice, I cannot write any more on the cache:

 

Warning: SQLiteDatabase::query() [sqlitedatabase.query]: attempt to write a readonly database in /home/mysite.com/public_html/catalog/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 161

 

I put well CHMOD 755 and 777 on directory:

 

catalog/includes/ultimate_seo_urls5/cache_system/cache/

catalog/includes/ultimate_seo_urls5/cache_system/sqlite/

 

but it changes nothing there, I can use functions: mb_strpos, mb_substr, mb_strlen???

 

Thank you ! ^_^

Edited by mamegaga

Share this post


Link to post
Share on other sites

I think I already managed to answer my 2) question, by adding to the .htaccess directly below rewritebase:

RewriteCond %{QUERY_STRING} language=en
RewriteRule ^(.*)$ /en/$1? [NC,R=301]

Now remains the 404 issue, would be glad if anyone could help.

Edited by consolepro

Share this post


Link to post
Share on other sites

Hello again,

 

I have another error message in my frontoffice:

 

Warning: SQLiteDatabase::query()

[sqlitedatabase.query]: attempt to write a readonly database in /home/mysite.com/public_html/catalog/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 130


The line 130 is:

self::$db->query( $query );

 

:wacko: thank you

Edited by mamegaga

Share this post


Link to post
Share on other sites

I think I already managed to answer my 2) question, by adding to the .htaccess directly below rewritebase:

RewriteCond %{QUERY_STRING} language=en
RewriteRule ^(.*)$ /en/$1? [NC,R=301]

Now remains the 404 issue, would be glad if anyone could help.

 

Thank you for your help, I tried but, it does not work, I always have my message of error:

 

 

In front Office:

 

Warning: SQLiteDatabase::query()

[sqlitedatabase.query]: attempt to write a readonly database in /home/mysite.com/public_html/catalog/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 130

Line 130:
self::$db->query( $query );

 

In Backoffice:

Warning: SQLiteDatabase::query()

[sqlitedatabase.query]: attempt to write a readonly database in /home/mysite.com/public_html/catalog/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 161

Line 161 :
self::$db->query( 'DELETE FROM usu_cache' );

 

It is a problem of writing. :unsure:

Share this post


Link to post
Share on other sites

Thank you for your help, I tried but, it does not work

 

I was not helping you. I was unable to edit my post so I answered my own question, this solution you quote has nothing to do with your question.

Share this post


Link to post
Share on other sites

Hi

 

Just did a fresh install and added modular SEO header and this contribution.

 

Works fine except on products containing '®' (registered in case it snafus)

 

For example

 

Fat Grabbers® (180 caps) NEW SIZE!

 

URL generated ends

 

/catalog/product_info.php/fat-grabbers®-180-caps-new-size-p-158

 

and get this error message

 

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

 

Replace non alpa numerics is set to true.

 

If I add a char conversion I get

 

/catalog/product_info.php/fat-grabbersÂr-180-caps-new-size-p-158

 

Any thought on what can be causeing this?

 

(and how to resolve it too!!)

 

Thanks

 

G

 

SOLUTION

 

Put this in character_conversion.php

 

$char_convert = array( '®' => 'R', 'Â' => 'R');

 

HTH

 

G


Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Share this post


Link to post
Share on other sites

Hello again,

 

I found!!!!

 

It was necessary to put the directory:

 

catalog/includes/ultimate_seo_urls5/cache_system/sqlite/

 

in CHMOD 777

 

I had of the put it in 755 :'( Sorry :blush: :blush: :blush: :blush:

Edited by mamegaga

Share this post


Link to post
Share on other sites

Hi, I am also having a problem with Ultimate SEO and oscommerce 2.3

 

I have used the old chemo seo on 2.2 and it works fine, the problem I am having is that I get error 500 messages, when trying to open catalog/index

 

If I use a clean applications_top the error ( and of course SEO ) vanishes.

 

Anyoone else had this problem.

Share this post


Link to post
Share on other sites

Hello,

 

For those with multilingual shops and google sitemap installed, you'll have duplicate products on sitemapProducts.xml:

In usu5_sitemaps/index.php:

 

Change (line 206)

	  usu5_create_sitemap_set( $languages['directory'], $languages['code'] );

to:

	  usu5_create_sitemap_set( $languages['directory'], $languages['code'], $languages['languages_id'] );

 

Also in line 165 change:

	$query = "SELECT p.products_id, p.products_date_added, p.products_last_modified FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd INNER JOIN " . TABLE_PRODUCTS . " p ON p.products_id = pd.products_id WHERE p.products_status = '1' ORDER BY p.products_last_modified DESC, p.products_date_added DESC";

to:

	$query = "SELECT p.products_id, p.products_date_added, p.products_last_modified FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd INNER JOIN " . TABLE_PRODUCTS . " p ON p.products_id = pd.products_id WHERE p.products_status = '1' AND pd.language_id = " . $languages_id  . " ORDER BY p.products_last_modified DESC, p.products_date_added DESC";

 

This way the product page will not be added for each language installed. Hope it's useful for you.

Edited by piernas

Share this post


Link to post
Share on other sites

Small but vital add to piernas solution above:

In line 138 change:

 function usu5_create_sitemap_set( $language_directory, $code ) {

to:

 function usu5_create_sitemap_set( $language_directory, $code, $languages_id ) {

Edited by consolepro

Share this post


Link to post
Share on other sites

The 2 posts above are not enough to get the sitemaps functionality 100% ok when using a multi language setup, the urls generated are always for the default language.

To fix this you need to change 2 files (thanks tho user "pages" for pointing this out)

In /includes/modules/ultimate_seo_urls5/page_modules/ apply this change to both files product_info.php and index.php

replace:

   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 );

with

  protected function acquireLinkText() {
 // BOF fixes sitemaps multi language url
 if (!($_SERVER['REQUEST_URI'] == "/usu5_sitemaps/" || $_SERVER['REQUEST_URI'] == "/usu5_sitemaps/index.php")) {
	  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;
	  }
 }
 // EOF fixes sitemaps multi language url
	  $result = Usu_Main::i()->query( $this->query );

Share this post


Link to post
Share on other sites

Thanks all for this contribution and support; I was having problems with Ultimate_SEO_URLSv22d_11 so I decided to try this new one.

 

So far everything seems to work except iam missing all the graphics & Images will not display, upon further investigation found that the path look like

 

 

http://mysite.comdir_ws_catalog/images/spi****.jpg

 

should be

http://mysite.com/catalog/images/spi****.jpg

 

I am new to all this, can some one help, not sure if I have to add a line to .htaccess or make changes to my configure.php

 

Thanks in advance

Share this post


Link to post
Share on other sites

Heyy, just installed ect ect ect, i go to load my site so have a look and it doesnt load any of the images :/ ... Any ideas how to fix???

 

Thanks!!!!!!

 

Ohh it says this :)...

 

Warning: call_user_func(tep_reset_cache_data_usu5) [function.call-user-func]: First argument is expected to be a valid callback in *****************/catalog/ADMIN/includes/functions/general.php on line 1277

Share this post


Link to post
Share on other sites

Hi,

 

First off thank you for the addon.

 

I installed all well except for the

6) catalog/includes/modules/product_listing.php.

 

I have a modified product listing and the code is not in there that it says to find. Can you please help me in setting up this code?

 

Here is my current code:

------------------------------------------

 

<?php
/*
 $Id: product_listing.php, v 2.2 2009/11/25 22:49:59 hpdl Exp $
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
 Copyright (c) 2003 osCommerce
 Released under the GNU General Public License
*/

$graphic_bord = 'no'; //  set to 'yes' if you have older 'graphic borders' and not 'easy graphic borders'.
$cat_path = false; // set to true to include category paths in urls
$no_drop = true; // set to true to remove resuls/page & sort order drop downs
$set_width = true; // set to false to allow columns to find their own widths in list mode
$sale = false; // set to true to show sale prices if you have SaleMaker installed.
$show_ratings = false; // set to true to show the products average review rating
$checkbox =  true; // set to true to show a checkbox field in place of other quantity boxes, will only show for multi add to cart.
$max_rows = intval($specials ? MAX_DISPLAY_SPECIAL_PRODUCTS : ($new_page ? MAX_DISPLAY_PRODUCTS_NEW : ($new_mode ? MAX_DISPLAY_NEW_PRODUCTS : MAX_DISPLAY_SEARCH_RESULTS)));
if (tep_not_null($HTTP_GET_VARS['sort'])) $_GET['sort'] = $HTTP_GET_VARS['sort'];
$max_results = (tep_not_null($_GET['max']) ? $_GET['max'] : $max_rows);
if (PRODUCTS_PER_ROW == 'PRODUCTS_PER_ROW' || PRODUCTS_PER_ROW == 0 || LISTING_SWITCH == 'LISTING_SWITCH') { $to = 'Setup Error!\nPlease ensure you have run the\nInstall SQL File.' ; print "<script>alert('$to');</script>"; }
// sort order array
if ($_GET['sort'] == '0d') $sort_array[] = array('id' => 0 . 'd', 'text' => DATE_ORDER);
for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
  switch ($column_list[$i]) {
    case 'PRODUCT_LIST_MODEL':
   $sort_array[] = array('id' => $i+1 . 'a', 'text' => TABLE_HEADING_MODEL . APHA_ORDER);
   $sort_array[] = array('id' => $i+1 . 'd', 'text' => TABLE_HEADING_MODEL . REVERSE_ALPHA_ORDER);
	  break;
    case 'PRODUCT_LIST_NAME':
	  $sort_array[] = array('id' => $i+1 . 'a', 'text' => TABLE_HEADING_PRODUCTS . APHA_ORDER);
 $sort_array[] = array('id' => $i+1 . 'd', 'text' => TABLE_HEADING_PRODUCTS . REVERSE_ALPHA_ORDER);
	  break;
    case 'PRODUCT_LIST_MANUFACTURER':
	  $sort_array[] = array('id' => $i+1 . 'a', 'text' => TABLE_HEADING_MANUFACTURER . APHA_ORDER);
 $sort_array[] = array('id' => $i+1 . 'd', 'text' => TABLE_HEADING_MANUFACTURER . REVERSE_ALPHA_ORDER);
	  break;
    case 'PRODUCT_LIST_QUANTITY':
	  $sort_array[] = array('id' => $i+1 . 'a', 'text' => TABLE_HEADING_QUANTITY . NUM_ORDER);
 $sort_array[] = array('id' => $i+1 . 'd', 'text' => TABLE_HEADING_QUANTITY . REVERSE_NUM_ORDER);
	  break;
    case 'PRODUCT_LIST_WEIGHT':
	  $sort_array[] = array('id' => $i+1 . 'a', 'text' => TABLE_HEADING_WEIGHT . NUM_ORDER);
 $sort_array[] = array('id' => $i+1 . 'd', 'text' => TABLE_HEADING_WEIGHT . REVERSE_NUM_ORDER);
	  break;
   case 'PRODUCT_LIST_PRICE':
  $sort_array[] = array('id' => $i+1 . 'a', 'text' => TABLE_HEADING_PRICE . NUM_ORDER);
 $sort_array[] = array('id' => $i+1 . 'd', 'text' => TABLE_HEADING_PRICE . REVERSE_NUM_ORDER);
	  break;
  }
   }
// Max Results Array 
for ($i=1; $i<10; $i++) { 
 $max_display[] = array('id' => $max_rows * $i, 'text' => $max_rows * $i);
 }
 $max_display[] = array('id' => 1000000, 'text' => 'Show All');
// store GET vars 
$get_vars = '';
   reset($_GET);
   while (list($key, $value) = each($_GET)) {
  if ( ($key != 'sort') && ($key != 'max') && ($key != tep_session_name()) && ($key != 'x') && ($key != 'y') ) {
    $get_vars .= tep_draw_hidden_field($key, $value);
  }
   }
$top_nav = ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'));
$base_nav = ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')); 
$listing_split = new splitPageResults($listing_sql, $max_results, 'p.products_id');
$data_ok = ($listing_split->number_of_rows > 0);
$list_mode = isset($_GET['list']) ? $_GET['list'] : PRODUCT_THUMBNAIL_VIEW;
$thumbnail_view = strstr($list_mode, 'thumbnails');
$global_add = PRODUCT_LIST_MULTI_BUY;
$multi_add = ($global_add != 'false' && !$new_mode);
if ($new_mode) $no_drop = true;
if (LISTING_SWITCH != 'false' && $data_ok && !$new_mode) $switch = '<br /><span class="smallText"><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('list')). 'list='.($thumbnail_view ? 'manufacturer' : 'thumbnails')) . '">' . ($thumbnail_view ? LIST_VIEW : THUMB_VIEW).'</a></span><br />';
if (LISTING_SWITCH != 'bottom') echo $switch;
$gbutton = ($data_ok ? tep_image_submit('button_multi_in_cart.gif', MULTI_ADD_ALT) : '') . '</div>';
$page_nav = '<table border="0" width="100%" cellspacing="0" cellpadding="2"><tr><td class="smallText">' .  $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS) . '</td><td class="smallText" align="right">' . TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))) . '</td></tr></table>';
$drop = $no_drop ? '' : '<table border="0" width="100%" cellspacing="0" cellpadding="2" class="drop"><tr><td class="smallText">Results/Page: '. tep_draw_form('maxdisplay', tep_href_link(basename($PHP_SELF), '', $request_type, false), 'get') . $get_vars . (isset($_GET['sort']) ? tep_draw_hidden_field('sort', $_GET['sort']) : '') .  tep_draw_pull_down_menu('max', $max_display, $_GET['max'], 'onChange="this.form.submit();"') . tep_hide_session_id().'</form></td><td class="smallText" align="right">Sort Order: ' . tep_draw_form('sorting', tep_href_link(basename($PHP_SELF), '', $request_type, false), 'get') . $get_vars . (isset($_GET['max']) ? tep_draw_hidden_field('max', $_GET['max']) : '') . tep_draw_pull_down_menu('sort', $sort_array, $_GET['sort'], 'onChange="this.form.submit();"') . tep_hide_session_id().'</form></td></tr></table>';
if ( ($listing_split->number_of_rows > (int)$max_results) && $top_nav ) echo $page_nav;
if ($top_nav && $data_ok) echo '<div id="drop1">' . $drop . '</div>';
if ($multi_add) { echo tep_draw_form('cart_quantity', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action','products_id')) . 'action=add_multi')); if ($global_add != 'bottom') echo '<div class="multi_buy_now" id="gbutton1">' . $gbutton; }
if (($show_ratings || PRODUCT_LIST_DESCRIPTION ) && $data_ok) {
 $listing_query = tep_db_query($listing_split->sql_query);
 while ($products = tep_db_fetch_array($listing_query)) $id_array[] = $products['products_id']; 
 $pid_string = implode(',', array_unique($id_array));
 }
if (PRODUCT_LIST_DESCRIPTION && $data_ok) {
   $product_query = tep_db_query("select products_id, products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id in (" . $pid_string . ") and language_id = '" . (int)$languages_id . "'");
 while ($products = tep_db_fetch_array($product_query)) {   
   $t_desc[$products['products_id']] = substr(strip_tags($products['products_description']), 0, PRODUCT_LIST_DESCRIPTION_MAX_LENGTH); 
  }
}
if ($show_ratings && $data_ok) {
   $rating_query = tep_db_query("select count(*) as count, products_id, sum(reviews_rating) as total from " . TABLE_REVIEWS . " where products_id in (" . $pid_string . ") group by products_id");
 while ($rating = tep_db_fetch_array($rating_query)) {   
   $review[$rating['products_id']] = ceil($rating['total'] / $rating['count']); 
  }
}
function tep_get_category_name($category_id, $language_id) {
   $category_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id . "'");
 $category = tep_db_fetch_array($category_query);

  return $category['categories_name'];
 }
function tep_get_manufacturer_name($manufacturer_id) {
   $manufacturers_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$manufacturer_id . "'");
 $manufacturer = tep_db_fetch_array($manufacturers_query);

  return $manufacturer['manufacturers_name'];
 }

function extra_fields($products_id) {
 global $languages_id;
   $extra_fields_text = '';
  if (tep_not_null(TABLE_PRODUCTS_EXTRA_FIELDS) && LISTING_EXTRA_FIELDS == 'true') {
  $extra_fields_query = tep_db_query("SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM ". TABLE_PRODUCTS_EXTRA_FIELDS ." pef, ". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ." ptf WHERE ptf.products_extra_fields_id=pef.products_extra_fields_id and ptf.products_id=". (int) $products_id ." and (pef.languages_id = '0' or pef.languages_id = '".(int)$languages_id."') and ptf.products_extra_fields_value <> '' and pef.products_extra_fields_status ORDER BY pef.products_extra_fields_order");
  while ($extra_fields = tep_db_fetch_array($extra_fields_query)) {
  $extra_fields_text .= '<tr><td class="smallText"><span class="xtra-field-name">' . $extra_fields['name'] . ': </span><span class="xtra-field-value">' . $extra_fields['value'] . '</span></td></tr>';
  } 
 }
 return $extra_fields_text;
}
function product_description($product_id,$link,$thumb=false) {
   global $head_title, $t_desc, $review;
 if ($review[$product_id]) $rating = '<span class="smallText"><br />' . sprintf(TEXT_AVERAGE_REVIEW, tep_image(DIR_WS_IMAGES . 'stars_' . $review[$product_id] . '.gif',sprintf(TEXT_AVERAGE_REVIEW,$review[$product_id]))) . '</span>';
  if (PRODUCT_LIST_DESCRIPTION) {
 return ($head_title || $thumb ? '' : '<br />') . '<span class="productListing-short">' . $t_desc[$product_id] . $link . '<b>...' . MORE . '</b></a></span>' . $rating;
 } else {
 return $rating;
 }
 }
function product_price ($listing,$last=false) {
   global $sale;
 $currencies = new currencies();
 $p_price = $listing['products_price'];
 $price = (function_exists(display_short_price)) ? $currencies->display_short_price($p_price, tep_get_tax_rate($listing['products_tax_class_id'])) : $currencies->display_price($p_price, tep_get_tax_rate($listing['products_tax_class_id']));
	 if ($sale && $new_price = tep_get_products_special_price($listing['products_id'])) {
	  $price = '<s>' .  $price . '</s>' . ($last ? '<br />' : '  ') . '<span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
 } elseif (tep_not_null($listing['specials_new_products_price'])) {
		  $price = '<s>' .  $price . '</s>' . ($last ? '<br />' : '  ') . '<span class="productSpecialPrice">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
	  }
 $price = ($p_price > 0 ? '' . $price . '' : '' . TEXT_POA);
 if (function_exists(tep_get_att_price)) $price .= (tep_get_att_price($listing['products_id']) > 0 ? '+' : '') ;
 return '<span class="productListing-list-price">' . $price . '</span>'; 
 }  


function list_row ($listing, $column_list) {
  global $rows, $gborders, $list_box_contents, $cPath, $cat_path, $head_title, $man_id;
  $list_box_contents[][] = array('text' =>  '<br />');
  if (!$rows && $gborders) $list_box_contents = array();  
  $rows++;
  $link = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id'] . ($man_id ? '&manufacturers_id='.$man_id : ($cPath && $cat_path ? '&cPath=' . $cPath : '')) ) . '"' . ($man_id || ($cat_path && $cat_path) ? ' rel="nofollow"' : '') . '>';
    if ($head_title) {
	  if (in_array('PRODUCT_LIST_PRICE',$column_list)) $price = '<p style="float: right">' . product_price ($listing) . '</p>';
    $list_box_contents[][] = array('align' => 'left',
									   'params' => 'colspan="'.sizeof($column_list).'" class="productListing-title"',
									   'text' =>  '<div style="clear: both; width:100%;"><p style="float: left">' . $link . '<b>' . $listing['products_name'] . '</b></a></p>' . $price . '</div>');
 }
  $list_box_contents[] = list_box_data($listing, $column_list, $link);
  $list_box_contents[][] = array('align' => 'center',
									   'params' => 'class="separator" colspan="'.sizeof($column_list).'"',
									   'text' =>  '<br />');
  return true;				  
  } 
?>  
<script type="text/javascript" language="javascript">
<!--
function changeValue(inObject,delta)
{  var myVal = parseInt(inObject.value);
 isNaN(myVal) ? myVal = delta : myVal = myVal + delta;
 inObject.value = Math.max(myVal,0);
 return; }

// -->
</script>
<?php
function quantity ($products_id,$p_price) {
global $multi_add, $checkbox, $thumbnail_view, $bx;
  if (PRODUCT_LIST_QUANTITY_BOX != 'false' && strstr(LISTING_BUTTON, 'buy now')) {
 if (tep_has_product_attributes($products_id) && PRODUCT_LIST_OPTIONS != 'true' && $multi_add) return '<br />';
 $pstock = min(tep_get_products_stock($products_id),MAX_QTY_IN_CART); $qbox = ($pstock && $p_price != 0);
 if ($checkbox && $multi_add) {
    if ($qbox) { $bx++; return 'Select ' . tep_draw_checkbox_field('cart_quantity['.$bx.']',1) . tep_draw_hidden_field('products_id['.$bx.']', $products_id); 
    } else { return '<br />'; }	   
 }
 if (PRODUCT_LIST_QUANTITY_BOX == 'true')
 return ($qbox ? '<table  cellspacing="0" cellpadding="2"><tr><td class="quantity" >' . QUANTITY . tep_draw_input_field('cart_quantity' . ($multi_add ? '[]' : '') , ($multi_add ? '0' : '1') , 'maxlength="5" size="2" id="qid'.$products_id.'"') . ($multi_add ? tep_draw_hidden_field('products_id[]', $products_id) : '') . '</td><td><a href="javascript:changeValue(document.getElementById(\'qid'.$products_id.'\'),1);">' . tep_image_button('btn_up.gif',MORE) . '</a><br><a href="javascript:changeValue(document.getElementById(\'qid'.$products_id.'\'),-1);">' . tep_image_button('btn_down.gif',LESS) . '</a></td></tr></table>' : '<br /><br />');
 else
   $qty_array = array();
   for ($i=0; $i<=$pstock; $i++) { $qty_array[]=array('id' => $i, 'text' => $i); }
   return ($qbox ? '<div class="quantity" align="' . ($thumbnail_view ? 'center' : 'right' ) .'">' . QUANTITY . tep_draw_pull_down_menu('cart_quantity'.($multi_add ? '[]' : ''),$qty_array,($multi_add ? 0 : 1)) . '<br />' . ($multi_add ? tep_draw_hidden_field('products_id[]', $products_id) : '') . '</div>' : '<br />');
 } else { return false; }
  }					 

function list_box_head($column_list) {
 global $set_width, $head_title;
 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
if ($head_title && $column_list[$col] == 'PRODUCT_LIST_PRICE') continue;
   switch ($column_list[$col]) {
  case 'PRODUCT_LIST_MODEL':
    $lc_text = TABLE_HEADING_MODEL;
    $lc_align = 'center';
    break;
  case 'PRODUCT_LIST_NAME':
    $lc_text = TABLE_HEADING_PRODUCTS;
    $lc_align = '';
    break;
  case 'PRODUCT_LIST_MANUFACTURER':
    $lc_text = TABLE_HEADING_MANUFACTURER;
    $lc_align = 'center';
    break;
  case 'PRODUCT_LIST_PRICE':
    $lc_text = TABLE_HEADING_PRICE;
    $lc_align = 'right';
    break;
  case 'PRODUCT_LIST_QUANTITY':
    $lc_text = TABLE_HEADING_QUANTITY;
    $lc_align = 'right';
    break;
  case 'PRODUCT_LIST_WEIGHT':
    $lc_text = TABLE_HEADING_WEIGHT;
    $lc_align = 'right';
    break;
  case 'PRODUCT_LIST_IMAGE':
    $lc_text = TABLE_HEADING_IMAGE;
    $lc_align = 'center';
    break;
  case 'PRODUCT_LIST_BUY_NOW':
    $lc_text = (PRODUCT_LIST_OPTIONS == 'true'  ? 'Product Options</td><td align="center" class="productListing-heading">' : '') . (strstr(LISTING_BUTTON, 'buy now')? TABLE_HEADING_BUY_NOW : TABLE_HEADING_DETAIL);
    $lc_align = 'center';
    break;
   }
   if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {
  $lc_text = tep_create_sort_heading($_GET['sort'], $col+1, $lc_text);
   }
  $list_box_contents[] = array('align' => $lc_align,'params' => 'class="productListing-heading" ' . ($set_width ? 'width="'.(int)(100/sizeof($column_list)) . '%"' : ''),'text' => ' ' . $lc_text . ' ');
 }
 return ($list_box_contents);
}
// function list_head end
function list_box_data($listing, $column_list, $link) {
    global $PHP_SELF, $ttip, $head_title, $rows, $set_width, $multi_add;
   $alt_text = $listing['products_name'];
   $image = (file_exists(DIR_WS_IMAGES . $listing['products_image']) ? $listing['products_image'] : 'no-image.jpg');	   
  $image = '<span class="ttip">' . $link . tep_image(DIR_WS_IMAGES . $image, $alt_text, PRODUCT_IMAGE_WIDTH, PRODUCT_IMAGE_HEIGHT) . ($ttip ? tep_image(DIR_WS_IMAGES . $image, $alt_text, IMAGE_TTIP_WIDTH, '', 'class="large"') : '' ) . '</a></span>';
   $name = (!$head_title ? $link . '<span class="productListing-name">' . $listing['products_name'] . '</span></a>' : '');
   if (LISTING_BUTTON != 'none' && PRODUCT_LIST_BUY_NOW) {
    $buypic = (LISTING_BUTTON == 'buy now' ? 'button_in_cart.gif' : 'button_buy_now.gif');
   $p_price = $listing['products_price'];
   $quantity_box = quantity ($listing['products_id'], $p_price);
   $form = ($multi_add ? '' : tep_draw_form('cart_quantity_' . $rows, tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action','products_id')) . 'action=add_product')));
   $buytable = '<table class="buytable" border="0" width="100%" cellspacing="0" cellpadding="2"><tr><td valign="bottom" class="productListing-data">';
   $buytableend = '</td></tr></table>'. ($multi_add ? '' : '</form>');
   $detail = $link . tep_image_button((strstr(LISTING_BUTTON, '&') || (strstr(LISTING_BUTTON, 'small')) ? 'button_details_small.gif' : 'button_details.gif'), IMAGE_BUTTON_DETAILS, 'class="thm_buy_now"') . '</a> ';
   $add_cart = ($multi_add ? ($quantity_box ? '' : $detail) : tep_draw_hidden_field('products_id', $listing['products_id']) . tep_image_submit($buypic, IMAGE_BUTTON_BUY_NOW, 'class="thm_buy_now"'));
   $button = (LISTING_BUTTON == 'buy now & details' ? ($add_cart == $detail ? $add_cart : $add_cart . ' <span class="buy_now">|</span> ' . $detail ) : (strstr(LISTING_BUTTON, 'buy now') ? $add_cart : $detail ));
   if ($p_price == 0 || (isset($listing['products_quantity']) && !$listing['products_quantity'])) { $button = $detail; $quantity_box = '';}//'<span class="buy_now"> </span>'.
   }
   $list_box_temp =  array('params' => 'class="list-block"');
   if (!strstr(PRODUCT_THUMBNAIL_VIEW, 'block')) { 
   for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
   if ($head_title && $column_list[$col] == 'PRODUCT_LIST_PRICE') continue;
    $lc_align = '';
   $params = 'class="productListing-data" ' . ($set_width ? 'width="'.(int)(100/sizeof($column_list)) . '%"' : '') . ' valign="top" '; 
    switch ($column_list[$col]) {
	  case 'PRODUCT_LIST_MODEL':
	    $lc_align = 'center';
	    $lc_text = ' ' . $listing['products_model'] . ' ';
	    break;
	  case 'PRODUCT_LIST_NAME':
	    $lc_align = '';
	    $lc_text = $name . ($listing['short_desc'] && (PRODUCT_SHORT_DESC == 'true') ? '<br /><span class="short">' . $listing['short_desc'] . '</span>' : '') . product_description($listing['products_id'],$link);
  $extra_fields_text = extra_fields($listing['products_id']);
  if ($extra_fields_text) $lc_text .= '<br /><table>' . $extra_fields_text . '</table>';
	   break;
	  case 'PRODUCT_LIST_MANUFACTURER':
	    $lc_align = 'center';
	    $lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';
	    break;
	  case 'PRODUCT_LIST_PRICE':
   if(!$head_title) {
		 $lc_align = 'right';
   $lc_text = product_price ($listing);
  }
	    break;
	  case 'PRODUCT_LIST_QUANTITY':
	    $lc_align = 'right';
	    $lc_text = ' ' . $listing['products_quantity'] . ' ';
	    break;
	  case 'PRODUCT_LIST_WEIGHT':
	    $lc_align = 'right';
	    $lc_text = ' ' . $listing['products_weight'] . ' ';
	    break;
	  case 'PRODUCT_LIST_IMAGE':
	    $lc_align = 'center';
	    $lc_text = $image;
	    break;
	  case 'PRODUCT_LIST_BUY_NOW':
   if (PRODUCT_LIST_OPTIONS == 'true' ) $params = 'class="productListing-data" width="'.(int)((100/sizeof($column_list))*2).'%" colspan="2"';
   $lc_align = 'center';
  $button = $quantity_box . $button;
	    $lc_text = $form . $buytable . (PRODUCT_LIST_OPTIONS == 'true'  ? attribute_drop($listing['products_id'],$listing['products_tax_class_id']) . '</td><td align="center" class="productListing-data">' . $button : $button) . $buytableend;
	   break;
    }
   $list_box_temp[] = array('align' => $lc_align,
							 'params' => $params,
							 'text'  => $lc_text);
  }
 } else { 
 if (PRODUCT_LIST_IMAGE) { $list_box_temp[] = array('align' => 'center',
								   'params' => 'class="productListing-data" ',
								   'text'  => $image);   }
   $display ='';$text = '';
 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
 if ($head_title && $column_list[$col] == 'PRODUCT_LIST_PRICE') continue;
  $last = (($col + BLOCK_LAST_SIZE + 1) > $n);
   $text .= ($text ? '<br />' : ''); 
   switch ($column_list[$col]) {
	  case 'PRODUCT_LIST_MODEL':
   $text .= $listing['products_model'];
  if (!$last) {$display .= $text . '<br />'; $text = '';}
	    break;
	  case 'PRODUCT_LIST_NAME':
	    $text .= $name . ($listing['short_desc'] && (PRODUCT_SHORT_DESC == 'true') ? '<br /><span class="short">' . $listing['short_desc'] . '</span>' : '') . product_description($listing['products_id'],$link);
  $extra_fields_text = extra_fields($listing['products_id']);
  if ($extra_fields_text) $text .= '<br /><table>' . $extra_fields_text . '</table>';
  if (!$last) {$display .= $text . '<br />'; $text = '';}
	   break;
	  case 'PRODUCT_LIST_MANUFACTURER':
	    $text .= '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a>';
  if (!$last) {$display .= $text . '<br />'; $text = '';}
	    break;
	  case 'PRODUCT_LIST_PRICE':
   $text .= ($last ? '' : '<br />Price: ') . product_price ($listing, $last) . ($last ? '' : '<br />');
  if (!$last) {$display .= $text . '<br />'; $text = '';}
	    break;
	  case 'PRODUCT_LIST_QUANTITY':
	    $text .= ($listing['products_quantity'] ? 'Stock = ' . $listing['products_quantity'] : 'Out of Stock');
  if (!$last) {$display .= $text . '<br />'; $text = '';}
	    break;
	  case 'PRODUCT_LIST_WEIGHT':
	    $text .= 'Weight = ' . $listing['products_weight'].WEIGHT_ABRV . ($last ? '' : '<br />');
  if (!$last) {$display .= $text . '<br />'; $text = '';}
	    break;
 case 'PRODUCT_LIST_BUY_NOW':
   $button = '<div align="right" width="100%">' . $quantity_box . '</div>' . ($last ? '' : '  ') . $button;
	    $text .= $form . $buytable . (PRODUCT_LIST_OPTIONS == 'true' ? '<div ' . ($last ? 'align="right"' : 'align="left"' ) . ' width="100%">' . attribute_drop($listing['products_id'],$listing['products_tax_class_id']) . '</div>' . $button : $button) . $buytableend; //'<br />' .

  if (!$last) {$display .= $text . '<br />'; $text = '';}
	    break;
   }
  }
 $display .= '';

$list_box_temp[] = array('align' => 'left',
						 'params' => 'class="main" valign="top" ',
						 'text'  => $display);
$list_box_temp[] = array('align' => 'right',
						 'params' => 'class="productListing-data" valign="top" ',
						 'text'  => $text);
 }
 return  ($list_box_temp);
   }
// function list_box_data end
function attribute_drop($products_id,$tax_class_id) {
global $languages_id, $multi_add;
$currencies = new currencies();
$atrib_drop = '';  
 $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . (int)$products_id . "'");
   $products_attributes = tep_db_fetch_array($products_attributes_query);
   if ($products_attributes['total'] > 0) {

 $atrib_drop = '<table border="0" cellspacing="0" cellpadding="2" class="attributes">';

 $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$products_id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
  while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
    $products_options_array = array();
    $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
    while ($products_options = tep_db_fetch_array($products_options_query)) {
	  $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
	  if ($products_options['options_values_price'] != '0') {
	    $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($tax_class_id)) .') ';
	  }
    }
$atrib_drop .= '<tr><td class="attributes" >' . $products_options_name['products_options_name'] . ':' . '</td><td align="left">' . tep_draw_pull_down_menu('id' . ($multi_add ? '['. $products_id .']' : '') . '[' . $products_options_name['products_options_id'] . ']', $products_options_array) . '</td></tr>';
  }
  $atrib_drop .= '</table>';
   }
 return $atrib_drop;
}
// function attribute_drop end

// set initial values

$empty_list=false;//$man_id = (tep_not_null($_GET['manufacturers_id']) ? $_GET['manufacturers_id'] : '');
if ($man_id = (tep_not_null($_GET['manufacturers_id']) ? $_GET['manufacturers_id'] : '')) {
$title_name = tep_get_manufacturer_name($_GET['manufacturers_id']);
} else {
$title_name =  ($specials ? $specials : ($new_page ? '' : ($new_mode ? $new_mode : (!$category['categories_name'] && tep_not_null($_GET['cPath']) ? tep_get_category_name(substr($_GET['cPath'], strpos($_GET['cPath'],'_')+1),$languages_id) : ''))));
}
$grid = strstr(PRODUCT_THUMBNAIL_VIEW, 'grid');
$gborders = function_exists(mws_boxHeader);//$gborders = false;
$Tborder = (!$gborders ? '<div class="infoBoxList" style="width:100%;">' : mws_boxHeader('<big>'.$title_name.'</big>'));
$Tborderend = (!$gborders ? '</div>' : mws_boxFooter ());
$border2 = (!$gborders ? '<div class="infoBoxList" style="width:100%;">' : ($graphic_bord == 'yes' ? mws_boxHeader('<big>'.$title_name.'</big>') : '')); 
$border2end = (!$gborders ? '</div>' : ($graphic_bord == 'yes' ? mws_boxFooter() : ''));
$list_box_empty[] = array(array('params' => 'class="productListing-data"','text' => TEXT_NO_PRODUCTS));
$ttip = (IMAGE_TTIP == 'true');
$head_title = (PRODUCT_LIST_HEAD_TITLE == 'true');
$man_desc = (MANU_DESCRIPTION == 'true');

if (tep_not_null($_GET['categories_id']) && $current_category_id == 0) $current_category_id = $_GET['categories_id'];
// output selected display
if ($thumbnail_view) {  //thumbnail
 $row = 0;
 $col = 0;
$border = (!$grid ? '<div class="infoBoxProducts" style=" width:'.PRODUCT_LIST_WIDTH.'px; height:'.PRODUCT_LIST_HEIGHT.'px;" >' : '<br />');
$borderend = (!$grid ? '</div>' : '');
$style = (!$grid ? 'class="smallText"' : 'class="infoBoxGrid"');
$info_box_contents = array();
if ($data_ok) {   $listing_query = tep_db_query($listing_split->sql_query);} else {
    $listing_query = tep_db_query($listing_sql); }
if (tep_db_num_rows($listing_query)) {   
while ($products = tep_db_fetch_array($listing_query)) {
  if ($row == 0) {
   if (!$gborders && !$grid)
   $info_box_contents[$row][$col] = array('align' => 'center',
									   'params' => 'class="smallText" width="'.(PRODUCTS_PER_ROW ? (int)(100/PRODUCTS_PER_ROW) : '').'%" valign="top"',
									   'text' =>  ' '); 
   echo $Tborder;$row ++;
   if (!$gborders && $grid && $title_name) {
  $info_box_heading[0] = array('text' => '<big>'.$title_name.'</big>');
  new infoBoxHeading($info_box_heading, false, false);
   }				   
  }

  // build thumb
 $link = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id'] . ($man_id ? '&manufacturers_id='.$man_id : ($cPath && $cat_path ? '&cPath=' . $cPath : ''))) . '"' . ($man_id  || ($cat_path && $cat_path) ? ' rel="nofollow"' : '') . '>';
 $p_price = $products['products_price'];
 $quantity_box = quantity ($products['products_id'],$p_price);
 $image = (file_exists(DIR_WS_IMAGES . $products['products_image']) ? $products['products_image'] : 'no-image.jpg');
 $addimages = (file_exists(DIR_WS_CLASSES . 'displayimages.php')); // Additional Images Present
 if ($addimages) { 
 $image_query = tep_db_query( "SELECT ai.medium_images, ai.images_description, ai.popup_images, p.products_image_med, p.products_image_description  FROM " .  TABLE_ADDITIONAL_IMAGES . " ai, " . TABLE_PRODUCTS . " p WHERE ai.products_id=p.products_id and ai.products_id = '".(int)$products['products_id']."'");
   $selected_image = tep_db_fetch_array($image_query);
 $image = ($selected_image['medium_images'] ? $selected_image['medium_images'] : ($selected_image['products_image_med'] ? $selected_image['products_image_med'] : ($selected_image['popup_images'] ? $selected_image['popup_images'] : $products['products_image'])));
	    }
 $alt_text = ($addimages ? (tep_not_null($selected_image['images_description']) ? $selected_image['images_description'] : (tep_not_null($selected_image['products_image_description']) ? $selected_image['products_image_description'] : $products['products_name'])) : $products['products_name']);		
   $image = (!$grid && $column_list[0] == 'PRODUCT_LIST_IMAGE' ? '<br />' : '') . ' <span class="ttip">' . $link . tep_image(DIR_WS_IMAGES . $image, $alt_text, PRODUCT_IMAGE_WIDTH, PRODUCT_IMAGE_HEIGHT)  . ($ttip ? tep_image(DIR_WS_IMAGES . $image, $alt_text, IMAGE_TTIP_WIDTH, '', 'class="large"') : '' ) . '</a></span>' . '<br />';
 if (LISTING_BUTTON != 'none' && PRODUCT_LIST_BUY_NOW) {
 $buypic = (LISTING_BUTTON == 'buy now' ? 'button_in_cart.gif' : 'button_buy_now.gif');
 $detail = $link . tep_image_button((strstr(LISTING_BUTTON, '&') || (strstr(LISTING_BUTTON, 'small')) ? 'button_details_small.gif' : 'button_details.gif'), IMAGE_BUTTON_DETAILS, 'class="thm_buy_now"') . '</a>';
 $add_cart = ($multi_add ? ($quantity_box ? '' : $detail) : tep_draw_hidden_field('products_id', $products['products_id']) . tep_image_submit($buypic, IMAGE_BUTTON_BUY_NOW, 'class="thm_buy_now"'));
 $button = (LISTING_BUTTON == 'buy now & details' ? '<br />' . $quantity_box . ($add_cart == $detail ? $add_cart : $add_cart . ' <span class="buy_now">|</span> ' . $detail . '<br /><br />') : (strstr(LISTING_BUTTON, 'buy now') ? '<br />' . $quantity_box . $add_cart . '<br /><br />' : '<br />'. $detail . '<br /><br />' ));
 if ($p_price == 0  || (isset($products['products_quantity']) && !$products['products_quantity'])) { $button = $quantity_box . '<br /><span class="buy_now"> </span>'. $detail . '<br />';$quantity_box = ''; }
 }
 $name = '<div class="productListing-name">' . $link . $products['products_name'] . '</a></div>'. ($products['short_desc'] && (PRODUCT_SHORT_DESC == 'true') ? '' . $products['short_desc'] . '<br />' : '') . product_description($products['products_id'],$link, true); 
 $show_price = '<br />' . product_price($products) . '<br />';
 $quantity = ($products['products_quantity'] ? 'Stock = '.$products['products_quantity'] : 'Out of Stock').'<br />';
 $weight = 'Weight = '.$products['products_weight'].WEIGHT_ABRV.'<br />';
   $model = $products['products_model'] . '<br />';
 $manfact = '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $products['manufacturers_id']) . '">' . $products['manufacturers_name'] . '</a><br />';
 $display = $border;
 for ($disp=0, $n=sizeof($column_list); $disp<$n; $disp++) {
    switch ($column_list[$disp]) {
	  case 'PRODUCT_LIST_IMAGE':
   $display .= '<table summary="" width="100%" ><tr><td style="text-align:center;" valign="top" height="'.PRODUCT_IMAGE_VSPACE.'" >'.$image.'</td></tr></table>';
	    break;
 case 'PRODUCT_LIST_NAME':
	    $display .= '<table summary="" width="100%" ><tr><td class="thumbcontent" height="'.PRODUCT_NAME_VSPACE.'" >'.$name.'</td></tr>' . extra_fields($products['products_id']) . '</table>';
	    break;
    case 'PRODUCT_LIST_MODEL':
	    $display .= $model;
	    break;
 case 'PRODUCT_LIST_MANUFACTURER':
	    $display .= $manfact;
	    break;
 case 'PRODUCT_LIST_PRICE':  
	    $display .= $show_price;
	    break; 
 case 'PRODUCT_LIST_QUANTITY':
	    $display .= $quantity;
	    break;
 case 'PRODUCT_LIST_WEIGHT':
	    $display .= $weight;
	    break;
 }
 }
 $form = ($multi_add ? '' : tep_draw_form('cart_quantity_' . $col . $row, tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action','products_id')) . 'action=add_product')));
 $display .= $borderend . $form . '' . (PRODUCT_LIST_OPTIONS == 'true' ? attribute_drop($products['products_id'],$products['products_tax_class_id']) . $button : $button) . ($multi_add ? '' : '</form>');
   // thumb built   


  $info_box_contents[$row][$col] = array('align' => 'center',
									   'params' => $style . ' width="'.(PRODUCTS_PER_ROW ? (int)(100/PRODUCTS_PER_ROW) : '').'%" valign="top"',
									   'text' => $display );
 $col ++;
   if ($col > PRODUCTS_PER_ROW-1) {
  $col = 0;
  $row ++;
   }
}  // prod loop
} else {$empty_list=true; }// no products!!
// got display
if ($row) {
$i = 0 ; $nbx = class_exists(noborderBox);
 if ($col > 0 && $row > 1 && $nbx && !$grid) {
   for ($i=0, $n=$col; $i < $n; $i++) { $last_row[0][$i] =  $info_box_contents[$row][$i]; unset($info_box_contents[$row][$i]);
   }
 }
if (!$i) {$col = 0;$row ++;$info_box_contents[$row][$col] = array('align' => 'center',
									   'params' => 'class="smallText" width="'.(PRODUCTS_PER_ROW ? (int)(100/PRODUCTS_PER_ROW) : '').'%" ',
									   'text' =>  ' '); }
if ($nbx) new noborderBox($info_box_contents); else new contentBox($info_box_contents);
if($i) new noborderBox($last_row);
echo ($gborders ? '' : '') . $Tborderend;
	   } else {$empty_list=true; }
} elseif (strstr($list_mode, 'manufacturer') && !$new_mode) {  //manufacturer
$row = 0;$col = 0;
if ($man_id) {
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name" . ($man_desc ? ", mi.manufacturers_description" : "") . " from " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$man_id . "' and mi.languages_id = '" . (int)$languages_id . "'");
 }else{
$filterlist_sql= tep_db_query("select distinct m.manufacturers_id, m.manufacturers_name" . ($man_desc ? ", mi.manufacturers_description" : "") . " from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' and mi.languages_id = '" . (int)$languages_id . "' order by m.manufacturers_name");
}
if (tep_db_num_rows($filterlist_sql)) { $rows = 0;
 while ($manufacturer = tep_db_fetch_array($filterlist_sql)) {
 $info_box_heading = array(); if ($rows) echo tep_draw_separator('pixel_trans.gif', '100%', '4');
 echo $border2;
 $info_box_heading[0] = array('text' => '<big>'.$manufacturer['manufacturers_name'].'</big><br />'.($man_desc ? $manufacturer['manufacturers_description'].'<br />' : ''));
 new infoBoxHeading($info_box_heading, false, false);
  $list_box_contents = array();
   $list_box_contents[0] = (LISTING_HEADINGS == 'true' && !strstr(PRODUCT_THUMBNAIL_VIEW, 'block') ? list_box_head($column_list) : '');
   if ($data_ok) { $rows = 0;  $listing_query = tep_db_query($listing_split->sql_query);} else {
  $rows = 0;  $listing_query = tep_db_query($listing_sql); }
   while ($listing = tep_db_fetch_array($listing_query)) {
 if ($listing['manufacturers_id'] != $manufacturer['manufacturers_id']) continue;
 list_row ($listing, $column_list);
  }
 $list_box_contents[sizeof($list_box_contents)-1] = array(array('text' =>  '<br />'));
  if (!$rows && $man_id) {
   $rows++;  $list_box_contents = $list_box_empty; $empty_list=true;}
  if ($rows) new productListingBox($list_box_contents);
   echo $border2end;
 //echo '<div class="multi_buy_now" id="gbutton2">' . $gbutton;
}   // man loop;
} else {$empty_list=true; }  // no manufacturers!!
}
if ((!$thumbnail_view && !strstr($list_mode, 'manufacturer')) || $empty_list  || ($new_mode && !$thumbnail_view)) {   //default listing

 if ($man_desc && $man_id) {
$manufacturer_query = tep_db_query("select manufacturers_description from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)($man_id) . "' and languages_id = '" . (int)$languages_id . "'");
   $manufacturer = tep_db_fetch_array($manufacturer_query); }
  $info_box_heading[0] = array('text' => '<big>'.$title_name.'</big>'.($manufacturer['manufacturers_description'] ? '<br />' . $manufacturer['manufacturers_description'] : ''));
 $list_box_contents = array();
  $list_box_contents[0] = (LISTING_HEADINGS == 'true' && !strstr(PRODUCT_THUMBNAIL_VIEW, 'block') ? list_box_head($column_list) : '');
  if ($listing_split->number_of_rows > 0) {  $rows = 0; $listing_query = tep_db_query($listing_split->sql_query);
   while ($listing = tep_db_fetch_array($listing_query)) {
 list_row ($listing, $column_list);
   }
 $list_box_contents[sizeof($list_box_contents)-1] = array(array('text' =>  '<br />'));
  $empty_list = false;
 echo $border2;
 if ($title_name) new infoBoxHeading($info_box_heading, false, false);
   new productListingBox($list_box_contents);
 echo $border2end;
 } else {
   new productListingBox($list_box_empty); $empty_list=true;
 }
 }
if ($multi_add) { if ($global_add != 'top') echo '<div class="multi_buy_now" id="gbutton2">' . $gbutton; echo '</form>'; }
if ($base_nav && !$empty_list) echo $drop;
if (($listing_split->number_of_rows > (int)$max_results) && $base_nav) echo $page_nav;
if (LISTING_SWITCH != 'top') echo $switch . '<br />';
  //echo '<hr>' . $listing_sql . '<hr>' . $listing_split->number_of_rows . ' records.';
?>

Share this post


Link to post
Share on other sites

This module rocks!

I use every aspect of the module! thanks a lot!

 

I am trying to adjust the URL when clicking on the category.

Now when i click it says: http://domainname.com/alfa-romeo-c-1.html

I want to change it into http://domainname.coml/alfa-romeo-tuning.html

 

I tried it in the .htacces by adding this: RewriteRule ^([a-z0-9/-]+)-tuning.html$ index.php [NC,L,QSA]

But that won't work.

 

Does anyone know how you change it?

 

Thanks in advance!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×