bhbilbao

December 20, 2013

Theres something that don't read well my convert file variables.

Any help?

Regards,

8. Try converting the file codification to UTF-8 without BOM.

December 20, 2013

I already change in Admin the force option to true, but it stays the same. Don't see where I made a wrong turn.

above that option there is a mode to change the path rewrite. Try changing the mode.

December 20, 2013

it uses the wrong conversion. If I change 'Ã¡' => 'a' to 'Ã¡' => 'c' the result of this word

7.Could be a problem with the database engine. I dont know about portugues. Look in languages/portugues.php

define('CHARSET', 'iso-8859-1');

Some new versions of osc uses UTF-8

Compare it with the database engine & collation.

Good luck.

December 14, 2013

1.the files must be in \includes\modules\ultimate_seo_urls5\includes\character_conversion

2. make 1 file per language

3. your file seems to be the spanish version. Rename it as espanol.php

4. if you installed for example 3 languages in your osc, delete the other ones folders. = 1 folder per languaje(default espanol, english, german)

5. It seems to be right but try with this one:

<?php // Spanish
$char_convert = array('á' => 'a', 'é' => 'e', 'í' => 'i', 'ñ' => 'n', 'ã' => 'a', 'Ã¡' => 'a', 'ó' => 'o', 'ú' => 'u', 'ü' => 'u', 'Á' => 'A', 'É' => 'E', 'Í' => 'I', 'Ñ' => 'N', 'Ó' => 'O', 'Ú' => 'U', 'Ü' => 'U', '¿' => '-', '¡' => '-');
?>

6. this is the code that gets the error:

	 $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;
}

Could be that you have some products without any products_name asigned (empty or null). Try to write some name description for all languages. Then RESET cache.

December 10, 2013

probably your conversion file is bad.

Problem with some coma `` or ,

December 9, 2013

Hi again Robert,

some weeks ago I made you a question about USU5.

I need help for a new open source project im working on.

Thanks in advance.

December 9, 2013

Open your eyes.

There is an option down in USU admin panel.

FORCE www.mysite.com/en/ when www.mysite.com/index.php/en

October 27, 2013

1)install languages

2)activate Enable multi language support? true

then:

www.your web .com (default)

www.your web .com/de/...

www.your web .com/es/...

...etc

October 25, 2013

Choose the uri format path_rewrite Choose how your product link text is made up cp

Hi again Robert,

for products (product_info,php) works fine with path_rewrite + cp.

But for articles doesnt add the category because they are topics ( xxx-t-3.html).

Is there a way in the articles contribution to add the topic before??

I want this:

http:// myweb .com/news/this-is-an-article-a-17.html

http:// myweb .com/articles/this-is-an-article-a-18.html

http:// myweb .com/reviews/this-is-an-article-a-19.html

In other way for future releases of your addon it could be interesting to add the category path only for some categories products (selectable).

Thanks in advance.

October 24, 2013

Hi Robert Fisher,

i need sugestion for this. Using the article_info.php contibution the urls goes right. For example:

http:// myweb .com/this-is-an-article-a-17.html

but i need to add a word(not category or topic) between as:

http:// myweb .com/articles/this-is-an-article-a-17.html

How can I get this??

1) In .htaccess

  # 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]

2) In your addon. where to add the "articles/" word???

Thanks in advance.

October 24, 2013

@@RobC1962

try these solutions:

1) remove from general.php and includes it in each archive manually:

 require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ARTICLE_INFO);
include(DIR_WS_FUNCTIONS . '/refund_functions.php');

2)put the doctype at begining of archive. before the includes

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<?php
require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ARTICLE_INFO);
include(DIR_WS_FUNCTIONS . '/refund_functions.php');

or

3)refund_functions.php

at the begining change

<?
to
<?php

January 9, 2012

See the problem:

<?php
// Start - CREDIT CLASS Gift Voucher Contribution
    echo $order_total_modules->credit_selection();
// End - CREDIT CLASS Gift Voucher Contribution
?>

That code must be inserted after

  echo $order_total_modules->sub_credit_selection();

pasting before doesnt work.

January 9, 2012

Hi all, i continue with the same problem described here:

http://forums.oscomm...ost__p__1509926

checkout_payment.php

<?php
// Start - CREDIT CLASS Gift Voucher Contribution
echo $order_total_modules->credit_selection();
// End - CREDIT CLASS Gift Voucher Contribution
?>

In /includes/modules/order_total/ot_gv.php

		$image_submit = '<input type="image" name="submit_redeem" onClick="submitFunction()" src="' . DIR_WS_LANGUAGES . $language . '/images/buttons/button_redeem.gif" border="0" alt="' . IMAGE_REDEEM_VOUCHER . '" title = "' . IMAGE_REDEEM_VOUCHER . '">';

In /includes/modules/order_total/ot_couponphp



 $selection_string .= TEXT_ENTER_GV_CODE . tep_draw_input_field('gv_redeem_code', 'redeem code') ;
 $selection_string .= ' ';
 $selection_string .= tep_image_submit('button_redeem.gif', IMAGE_REDEEM_VOUCHER, 'onclick="return submitFunction()"');

I insert the code GIFT20 on the box, but clicking button_redeem.gif nothing happens!!!! Cannot redeem!

I dont know how to fix it.

January 7, 2012

For other people asked. There is no need to use with CCGV contrib. They are diferent contribs(but they works in same manner).

The CCGV has additional advantages but its hard to install.

CCGV tables:

#
# Table structure for table 'coupon_email_track'
#

#
# Table structure for table 'coupon_gv_customer'
#

#
# Table structure for table 'coupon_gv_queue'
#

#
# Table structure for table 'coupon_redeem_track'
#


#
# Table structure for table 'coupons'
#

#
# Table structure for table 'coupons_description'
#

Account balance tables:

CREATE TABLE customers_balance_history

I will try to modify them and only use 1 table for them, in this case coupon_gv_customer

amount=customers_account_balance

January 7, 2012

Rosemaryann,

same problem here(the same problem as CCGV contrib).

Im thinking to notify to customer when this happens.

For other people with problems, try deleting:

ot_account_balance_org.php

use only ot_account_balance.php

and activate it on modules with the highest order number.

In my case there is problems in the instalation instructions:

First:

In file catalog\admin\orders.php

Find:

case 'deleteconfirm':
$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
tep_remove_order($oID, $HTTP_POST_VARS['restock']);
tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));
break;

REPLACE with:

// Account Balance Modif
case 'deleteconfirm':
$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
tep_remove_order($oID, $HTTP_POST_VARS['restock']);

tep_add_customer_balance($oID, $HTTP_POST_VARS['account_balance'], $cID);

tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));
break;
// End Account Balance Modif

then:

In file catalog\admin\orders.php

Find:

		if ($order_updated == true) {
			 $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
		} else {
			  $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
		}

		tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));
		break;



Add after:

// Account Balance Modif
case 'deleteconfirm':
	$oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
	$ab = tep_db_prepare_input($HTTP_POST_VARS['account_balance']);


if ($ab == true) {
... bla bla bla

case deleteconfirm appears twice, 2 times!!

In the original code the first part is deleted.

In other case I think there is need to place some code in checkout_confirmation.php

In estimate_shipping is right, and the email order confirmation also right. But checkout_confirmation bad.

Also, with admin/order_edit.php needs to modify, all quantities to 0€.

Other issue is on customers_balance_history.php

Adding credit from customers_edit page works fine, it adds a line to customers_balance_history table.

The problem here is after finishing the order, when a customer checks out, the account balance is reduced right but it doesnt add any line to customers_balance_history table (suposed a new line with Order #)

January 7, 2012

I continue here:

http://forums.oscomm...ate-redemption/

January 7, 2012

Here is the original german forum:

Ref:

At the installation is no change been made so far.

was the only catalog \ includes \ modules \ order_total \ ot_account_balance.php

changed.

And adds the lang in German.

Warranty is not Accepted.

For more information, go to:

http://forums.oscomm...ndpost&p=257065

On the balance indicator in the customer account, I'm still working.

January 7, 2012

sathenzar

try site root/modules/order_total

to

site root/includes/modules/order_total

My question is about the install instructions, I think they were wrong:

First:

In file catalog\admin\orders.php

Find:

case 'deleteconfirm':
   $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
   tep_remove_order($oID, $HTTP_POST_VARS['restock']);
   tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));
break;

REPLACE with:

// Account Balance Modif
case 'deleteconfirm':
   $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
   tep_remove_order($oID, $HTTP_POST_VARS['restock']);

   tep_add_customer_balance($oID, $HTTP_POST_VARS['account_balance'], $cID);

   tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action'))));
break;
// End Account Balance Modif

then:

In file catalog\admin\orders.php

Find:

    if ($order_updated == true) {
	 $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success');
    } else {
	  $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning');
    }

    tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));
    break;



Add after:

// Account Balance Modif
   case 'deleteconfirm':
       $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']);
       $ab = tep_db_prepare_input($HTTP_POST_VARS['account_balance']);


   if ($ab == true) {
... bla bla bla

case deleteconfirm appears twice, 2 times!!

In the original code the first part is deleted.

January 7, 2012

I also need help for Individual Item Status v 1.00

http://addons.oscommerce.com/info/5644

All works fine except for orders.php

After changing the item status in editors page it goes to orders list page (exiting the order editor page). I want to stay in the editors page and not to redirect to other page, because for example changing the status for 10 items of an order i must to enter and exit 10 times to edit that order.

I think this is the code orders.php:

tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit'));

I tried to replace with this one(no luck):

tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array ('oID', 'action=edit')) . 'oID=' . $orders['orders_id']));

November 11, 2011

Fillally get to work with account_notifications ans newsletters_products modlule.

My question now,

how to get working with this contribution:

Send email to customers with an attachment included

http://addons.oscommerce.com/info/4583

Especially here:

And replace with:
   $from = tep_db_prepare_input($HTTP_POST_VARS['from']);
   $subject = tep_db_prepare_input($HTTP_POST_VARS['subject']);
   $message = tep_db_prepare_input($HTTP_POST_VARS['message']);

   //Let's build a message object using the email class
   $mimemessage = new email(array('X-Mailer: osCommerce'));

   if ($_FILES['userfile']['size'] > 0) { 

	  $attachment_name   = $HTTP_POST_FILES['userfile']['name'];
	  $attachment_type   = $HTTP_POST_FILES['userfile']['type'];
     //$attachment_size = $HTTP_POST_FILES['userfile']['size']; //Just in case you want to check and limit the size
	  new upload('userfile', DIR_FS_DOWNLOAD);
	  $attachment_file   = DIR_FS_DOWNLOAD . $attachment_name;
	  $attachments	   = $mimemessage->get_file($attachment_file);
         $mimemessage->add_attachment($attachments, $attachment_name, $attachment_type);
  }

   // Build the text version
   $text = strip_tags($message);
   if (EMAIL_USE_HTML == 'true') {
  $mimemessage->add_html($message, $text);
   } else {
  $mimemessage->add_text($message);
   }

   $mimemessage->build_message();
   while ($mail = tep_db_fetch_array($mail_query)) {
  $mimemessage->send($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], '', $from, $subject);
   }

   tep_redirect(tep_href_link(FILENAME_MAIL, 'mail_sent_to=' . urlencode($mail_sent_to)));

November 7, 2011

After installing it the Mail Manager account_notifications.php stopped to work.

Im thinking is related to this contribution.

After unmark the products and press CONTINUE (to delete them from the database). It goes to the account page and says "OK. Product notification deleted", but after returning to account_notifications.php the products remains there (didnt delete!).

November 6, 2011

Hi again Jan,

I have a problem in products_info.php

here:


<?php
//added for cross xsell
   if ((USE_CACHE == 'true') && empty($SID)) {

   echo tep_cache_also_purchased(3600);
   echo tep_cache_xsell_products(3600);
//  echo tep_cache_products_sets(3600);

   } else {

//  include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
//  include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
//  include(DIR_WS_MODULES . FILENAME_PRODUCT_SETS);
//  include(DIR_WS_MODULES . 'product_sets.php');
 }

The problem is when caching xsell_products

In this case working:

echo tep_cache_also_purchased(3600);

// echo tep_cache_xsell_products(3600); //added for Xsell

// echo tep_cache_products_sets(3600);

I think the bad code is in catalog/includes/functions/cache.php

// Cache the also Xell module
 function tep_cache_xsell_products($auto_expire = false, $refresh = false) {
global $HTTP_GET_VARS, $language, $languages_id;

$cache_output = '';

if (isset($HTTP_GET_VARS['products_id']) && is_numeric($HTTP_GET_VARS['products_id'])) {
  if (($refresh == true) || !read_cache($cache_output, 'xsell_products-' . $language . '.cache' . $HTTP_GET_VARS['products_id'], $auto_expire)) {
	ob_start();
	include(DIR_WS_MODULES . FILENAME_XSELL_PRODUCTS);
	$cache_output = ob_get_contents();
	ob_end_clean();
	write_cache($cache_output, 'xsell_products-' . $language . '.cache' . $HTTP_GET_VARS['products_id']);
  }
}

return $cache_output;
 }

It should be modified??

In other hand, you said with hide products sppc to use also_purchased_products_hide_products.php

what it should done??

a. modify the define in filenames.php to also_purchased_products_hide_products.php, or

b. modify the archive also_purchased_products.php

November 6, 2011

Also a white page with a modified products_new.php file:

index.php

<?php  
// needed for the new products module shown below
   $new_products_category_id = $current_category_id;
?>
<tr>
  <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>
</tr>

includes/modules/products_new.php

<?php
 $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

//  new contentBoxHeading($info_box_contents);

 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {

  $new_products_query = tep_db_query("select p.products_id, p.products_quantity, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.latest_product='1' and p.products_status = '1' and p.products_id = pd.products_id and quotes_email_address NOT LIKE '%@%' and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id " . $new_products_where . " order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);


 } else {
  $new_products_query = tep_db_query("select distinct p.products_id, p.products_quantity, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id" . $new_products_where . " and c.parent_id = '" . (int)$new_products_category_id . "' and p.latest_product='1' and p.products_status = '1' and quotes_email_address NOT LIKE '%@%' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

 }

 $row = 0;
 $col = 0;
 $info_box_contents = array();
 while ($new_products = tep_db_fetch_array($new_products_query)) {
   $new_products['products_name'] = tep_get_products_name($new_products['products_id']);

$sql = 'SELECT `products_short` FROM `products_description.............

Only works in product_listings pages. Im thinking on unistalling it and install Optimize Category Box as says Jan.

The contribution works great with a vanilla 2.2rca2 install, but not in a high modified case like me. Too much problems.

November 6, 2011

Sorry, doesnt work. In admin panel after saving a white page, and then in catalog stops to work.

November 6, 2011

I get a white page on products listings with sppc.

I edited the admin/includes/configuration_cache.php

and modified the

tep_function count_products_in_category

to

function count_products_in_category

example:

<?php
/*
$Id: configuration_cache.php,v 1.32 2004/04/06 20:24:09 daemonj Exp $
*/
$rQuery  = tep_db_query('SELECT `categories_id` FROM `categories`');
$aResult = array();
while ($r = tep_db_fetch_array($rQuery)) {
  $aResult[] = $r['categories_id'];
}

// Return the number of products in a category
// TABLES: products, products_to_categories, categories
 function count_products_in_category($category_id, $include_inactive = false) {

 // Unless Customer logged in show products
 // BOF Separate Pricing Per Customer, hide products and categories for groups
	 global $sppc_customer_group_id;
	 if(!tep_session_is_registered('sppc_customer_group_id')) {
	 $customer_group_id = '0';
	 } else {
	  $customer_group_id = $sppc_customer_group_id;
	 }
	$products_count = 0;
	if ($include_inactive == true) {
	  $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$category_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0");
	} else {
	  $products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '" . (int)$category_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0");
	}
			$products = tep_db_fetch_array($products_query);
	$products_count += $products['total'];
// no need to find child categories that are hidden from this customer or have a higher level category that is hidden
	$child_categories_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$category_id . "' and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0");
// EOF Separate Pricing Per Customer, hide products and categories for groups
	if (tep_db_num_rows($child_categories_query)) {
	  while ($child_categories = tep_db_fetch_array($child_categories_query)) {
			$products_count += tep_count_products_in_category($child_categories['categories_id'], $include_inactive);
	  }
	}

	return $products_count;
 }


function count_has_category_subcategories($category_id) {

For the moment seems to work.

bhbilbao

Posts

Joined

Last visited

Days Won

Content Type

Profiles

Forums

Posts posted by bhbilbao

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

Ultimate Seo Urls 5 Pro

RMA Returns error for 2.2 MS2

Credit Class/Gift Vouchers/Discount Coupons 5.10

Credit Class/Gift Vouchers/Discount Coupons 5.10

Account Balance (gift certificate redemption)

Account Balance (gift certificate redemption)

Account Balance V4

Account Balance V4

Account Balance V4

looking for support thread for individual item status

Mail Manager

Mail Manager

[Contribution] Optimize Categories Box

Faster Page Loads

Faster Page Loads

Faster Page Loads

Browse

Activity