Jump to content
Sign in to follow this  
kit

Customers extra fields

Recommended Posts

Hi guys,

 

It looks a very good contrib and it did work fine until I found out that all fields who are fill up by customers are blank in my ADMIN (they are ok in the file that the customer can see when he login)!

I read a lot all along this post but I couldn't found the right way to change it.

 

Could someone help me on it please?

 

Thanks


osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites

Hi everyone,

 

I have just install the last update (Customer Extra Fields EXTENDED 1.3 matta 16 Jun 2009) full package. Very good contribution, thanks!

 

But when I go in my ADMIN/Customers/XXX (detail) I have a Warning:

 

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\catalog\xxxx\includes\functions\general.php on line 1446

 

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\catalog\xxxx\includes\functions\general.php on line 1446

 

 

This is the second argument:

 

											{
											$item = trim($item);
						  $extra_fields_string .= tep_draw_selection_field('fields_' . $extra_fields['fields_id'] . '_' . ($cnt++), 'checkbox', $item, ((in_array($item, $value_list))?(true):(false))).$item. (($extra_fields['fields_required_status']==1) ? '<span class="inputRequirement">*</span>': '').'<br>';
						  $extra_fields['fields_required_status']  = 0;
										}

 

Do you know what to do please???

 

Thanks


osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites

Ok I have found this problem and those who need it :

 

It was missing a @ in the code:

 

											{
											$item = trim($item);
						  $extra_fields_string .= tep_draw_selection_field('fields_' . $extra_fields['fields_id'] . '_' . ($cnt++), 'checkbox', $item, ((@in_array($item, $value_list))?(true):(false))).$item. (($extra_fields['fields_required_status']==1) ? '<span class="inputRequirement">*</span>': '').'<br>';
						  $extra_fields['fields_required_status']  = 0;
										}

 

I still have a problem, the data are still not showing in my ADMIN but they are in the customer's detail

 

If someone knows what to do cause I have tried a few things from here but still the same?!

 

Thanks

 

 

 

 

 

Hi everyone,

 

I have just install the last update (Customer Extra Fields EXTENDED 1.3 matta 16 Jun 2009) full package. Very good contribution, thanks!

 

But when I go in my ADMIN/Customers/XXX (detail) I have a Warning:

 

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\catalog\xxxx\includes\functions\general.php on line 1446

 

Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:\wamp\www\catalog\xxxx\includes\functions\general.php on line 1446

 

 

This is the second argument:

 

											{
											$item = trim($item);
						  $extra_fields_string .= tep_draw_selection_field('fields_' . $extra_fields['fields_id'] . '_' . ($cnt++), 'checkbox', $item, ((in_array($item, $value_list))?(true):(false))).$item. (($extra_fields['fields_required_status']==1) ? '<span class="inputRequirement">*</span>': '').'<br>';
						  $extra_fields['fields_required_status']  = 0;
										}

 

Do you know what to do please???

 

Thanks


osCommerce Online Merchant v2.2 RC1 W3C Valid FR avec : colissimo_v1.9 // CGV // GoogleXML_sitemap - Update -> googlexml_sitemap_seo_v_1.5 // Ultimate SEO URLs 2.1d - Update -> v22d_12 // AntiRobotRegistrationValidation-3.1 // TinyMCE WYSIWYG HTML EDITOR // HEader Tag SEO 3.1.4 // PDF Invoice 1.5 // Specials_enhanced_v1_3_1 // quick_stock_update_v3.5_FRENCH // xmembers_v2.2 // contact_us_form_in_db_with_amin_v1.1 // photo_display_1 // previous_next_with_details // infoBox Admin v.2.25 // whosonlineturbov1.1fr // customer_discount_v1.3 // flash_bannersv2 // Horizontal_menu_V3 // Loginbox_Best_1 // CCGV // XSell_v2_7_2 // Printable Catalog XSS Flaw Fixed // all_specials_slideshow // Birthdays_v1.4 // Search_price_range_pulldown_menu_1.1 // contrib-categories // Reviews_in_Product_Display_v2.3 // Easy Graphical Borders // Simple Multiple Images (Unlimited) with Fancy Popups V1.3.5 // Guestbook V3.0 // Blacklist_IP_v.3 // Quicker Product Edit v2.1 // Chronopost_2010 // Easy Center // Size Shop with Layers // Safari-Chrome_fix // Protection to Configuration v1.3a // Page_Cache_v1.6... Thanks to everyone!

Share this post


Link to post
Share on other sites
Ok I have found this problem and those who need it :

 

It was missing a @ in the code:

 

											{
											$item = trim($item);
						  $extra_fields_string .= tep_draw_selection_field('fields_' . $extra_fields['fields_id'] . '_' . ($cnt++), 'checkbox', $item, ((@in_array($item, $value_list))?(true):(false))).$item. (($extra_fields['fields_required_status']==1) ? '<span class="inputRequirement">*</span>': '').'<br>';
						  $extra_fields['fields_required_status']  = 0;
										}

 

I still have a problem, the data are still not showing in my ADMIN but they are in the customer's detail

 

If someone knows what to do cause I have tried a few things from here but still the same?!

 

Thanks

 

Hi, I'm having the same problem. Thanks for finding the problem, what exactly does the '@' symbol do for the in_array function? I also seem to not understand why the extra field values would not show up, they show up perfectly in all the other situations where I've used tep_get_extra_fields.

 

Do you think this could be related to how the data is being updated differently between account_edit.php file and customers.php file?

Edited by tmoney2656

Share this post


Link to post
Share on other sites

Installed latest version (1.6) and like some others it all appraes to work except there is no output in the email confirmation or on the orders page. Can anyone answer:

 

1) is this an error installing or not a feature in the contrib?

 

2) if it's a feature than can anyone explain in 'Plain English' what the proble could be. I have reviewed posted from previous years and there is refernce to a sectin but none of it makes any sense.

 

Thanks,

Nav

Share this post


Link to post
Share on other sites
Installed latest version (1.6) and like some others it all appraes to work except there is no output in the email confirmation or on the orders page. Can anyone answer:

 

1) is this an error installing or not a feature in the contrib?

 

2) if it's a feature than can anyone explain in 'Plain English' what the proble could be. I have reviewed posted from previous years and there is refernce to a sectin but none of it makes any sense.

 

Thanks,

Nav

 

 

Does this work with 'Purchase Without Account'? I see this question was asked several pages ago but no one answered. I have installed/reinstalled more than a few times and there is nothing out of the ordinary as per the instructions, so I figure this may be the problem. I do not get any error messages from the store side or the admin side, however I do not get any data recorded on the order.

 

If no one has an answer maybe you have another solution I can try.

 

Nav

Share this post


Link to post
Share on other sites

Has anybody else had problems with sppc and this contrib??

 

It doesn't store the info when entered via create_account.php but if i manually add it via admin.. it goes in.. same for account edit after loggin ing.. it stores it even then...

 

I saw that the code after

	$customer_id = tep_db_insert_id();

is the problem..

 

original was

// BOF Customers extra fields  
$extra_fields_query = tep_db_query("select ce.fields_id from " . TABLE_EXTRA_FIELDS . " ce where ce.fields_status=1 ");
  while($extra_fields = tep_db_fetch_array($extra_fields_query)){
		$sql_data_array = array('customers_id' => $customer_id,
						  'fields_id' => $extra_fields['fields_id'],
						  'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]);
   tep_db_perform(TABLE_CUSTOMERS_TO_EXTRA_FIELDS, $sql_data_array);
  }
// EOF Customers extra fields

 

and the one in the latest version is

 

// BOF Customers extra fields
  	  $extra_fields_query = tep_db_query("select ce.fields_id from " . TABLE_EXTRA_FIELDS . " ce where ce.fields_status=1 ");
	  while($extra_fields = tep_db_fetch_array($extra_fields_query))
			{
			  if(isset($HTTP_POST_VARS['fields_' . $extra_fields['fields_id']])){
		$sql_data_array = array('customers_id' => (int)$customers_id,
						  'fields_id' => $extra_fields['fields_id'],
						  'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]);
   		}
   		else
				{
				  $sql_data_array = array('customers_id' => (int)$customers_id,
						  'fields_id' => $extra_fields['fields_id'],
						  'value' => '');
					$is_add = false;
					for($i = 1; $i <= $HTTP_POST_VARS['fields_' . $extra_fields['fields_id'] . '_total']; $i++)
					{
						if(isset($HTTP_POST_VARS['fields_' . $extra_fields['fields_id'] . '_' . $i]))
						{
						  if($is_add)
						  {
			  $sql_data_array['value'] .= "\n";
							}
							else
							{
			  $is_add = true;
						  }
			  $sql_data_array['value'] .= $HTTP_POST_VARS['fields_' . $extra_fields['fields_id'] . '_' . $i];
						}
					}
				}

				tep_db_perform(TABLE_CUSTOMERS_TO_EXTRA_FIELDS, $sql_data_array);
	  }
// EOF Customers extra fields

 

Any ideas why it isn't storing in DB when using the new code? The old code works, but only for input fields.. It doesn't store radio button values..

 

Someone help please...


Converge

Share this post


Link to post
Share on other sites

Hi,

 

first of all, thanks for the contribution! Working great so far. But one problem I do have - more a cosmetical problem. In the customer details, the headline of the whole extra-block is titled CATEGORY_EXTRA_FIELDS, which looks rather bad. How can I change this? I searched various files for it but could not find what I was looking for.

 

bild1ksl.png

 

Best regards

Chris

Share this post


Link to post
Share on other sites
In the customer details, the headline of the whole extra-block is titled CATEGORY_EXTRA_FIELDS, which looks rather bad. How can I change this?

It's a define which hasn't been added to a language file. Could be that the contribution instructed you to add this to english.php where in your case it should have been german.php?

Share this post


Link to post
Share on other sites

Jan, thanks for the fast reply! I`m almost ashamed how simple the solution is ;) I just added the line

 

define('CATEGORY_EXTRA_FIELDS', 'Bankverbindung');

to the includes/german.php, and now it displays "Bankverbindung" instead. Thanks again!

 

Chris

Share this post


Link to post
Share on other sites

Nevermind.. I figured out my solution.. To all of those who're facing problems with create_account not saving the data.. Download the bugfix..

 

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

 

basically change

 

			$sql_data_array = array('customers_id' => (int)$customers_id,
						  'fields_id' => $extra_fields['fields_id'],
						  'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]);
   		}
   		else
				{
				  $sql_data_array = array('customers_id' => (int)$customers_id,

 

into

 

			$sql_data_array = array('customers_id' => (int)$customer_id,
						  'fields_id' => $extra_fields['fields_id'],
						  'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]);
   		}
   		else
				{
				  $sql_data_array = array('customers_id' => (int)$customer_id,

 

That's it.. $customers_id was preventing it from storing in the database.. Now it works like a charm..

 

 

Cheers..

Edited by jackanderson

Converge

Share this post


Link to post
Share on other sites

well after trying to read all 11 previous pages of this thread, my brain is now so confused with all this

 

 

my questions if anyone can give me some answers i would be grateful..

i have installed and am using Customer_Extra_Fields_EXTENDED_v1_3 contribution

 

1) where can i alter the size of the input fields, on my create account page and on my account edit page

2) do these fields get put onto the invoice and emails already or not, if not, can this be done and if so where is the correct full code for it

 

 

 

 

thanks


If it don't fit - Get a bigger hammer

Share this post


Link to post
Share on other sites

Greetings all -

 

This is a great contribution, and I was to say thanks first.

 

Apparently, I fat-fingered something, and I just can't track it down.

I've gone through all of the pages in this thread, though perhaps

I missed it, but I'm getting the following error now upon attempting

to create a new account:

 

Your First Name must contain a minimum of 2 characters.

Error Your Last Name must contain a minimum of 2 characters.

Error Your E-Mail Address must contain a minimum of 6 characters.

Error Your Street Address must contain a minimum of 5 characters.

Error Your Post Code must contain a minimum of 4 characters.

Error Your City must contain a minimum of 3 characters.

Error Your State must contain a minimum of 2 characters.

Error Your Telephone Number must contain a minimum of 3 characters.

Error Your Password must contain a minimum of 5 characters.

 

 

I've looked at the javascript file and attempted several things, but

apparently that's not the issue.

 

Any suggestions?

 

TIA,

 

AD7

Share this post


Link to post
Share on other sites

Hi everyone,

 

I just read your all posts about this contribution.

Installed, step by step, but i can't captcha the fields into email.

I used PWA, no login, etc.

I just want to customer can fill some extra fileds in create account, not required, and these fields show in customer e-mail.

In Extra Fields Manager, every field are checked with "Send Field In Emails", but not working.

I see the fields, but what they complete not shown in e-mail.

 

Please a solution, about this great contribution.

 

Edmond

Share this post


Link to post
Share on other sites

HI!

First,sorry my bad english.

I dont know english so good.

 

I have installed Customer-Extra-Fields-EXTENDED.v1.3.1.

And i think all is working good, but i have a small problem,

I have put a extrafield in product_info.php, it work and i can type in the field.

But i need to make the field text to come along with order email, so i know what to type in product that the coustemer has bouth.

 

I understand that i have to put this code in product_info.php :

//START Customers Extra Field

 

 

tep_db_query("delete from " . TABLE_CUSTOMERS_TO_EXTRA_FIELDS . " where customers_id=" . $customer_id);

$extra_fields_query = tep_db_query("select ce.fields_id from " . TABLE_EXTRA_FIELDS . " ce where ce.fields_status=1 ");

while($extra_fields = tep_db_fetch_array($extra_fields_query)){

$sql_data_array = array('customers_id' => $customer_id,

'fields_id' => $extra_fields['fields_id'],

'value' => $HTTP_POST_VARS['fields_' . $extra_fields['fields_id']]);

tep_db_perform(TABLE_CUSTOMERS_TO_EXTRA_FIELDS, $sql_data_array);

}

 

//END Customers Extra Field

 

Does anybody know where i could put in???

Here is my product_info.php:

 

<?php

/*

$Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

 

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_check = tep_db_fetch_array($product_check_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<?php

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<?php include(DIR_WS_INCLUDES . 'easy_meta_tags.php'); ?>

<?php

}

?>

<META HTTP-EQUIV="Content-Type" content="text/html; charset=iso-8859-1">

<META HTTP-EQUIV="Cache-Control" content="cache">

<META HTTP-EQUIV="Expires" content="0">

<META NAME="Rating" content="General">

<META NAME="Robots" content="index,follow">

<META NAME="Abstract" content="LNB">

<META NAME="Author" content="LNB http://balochfest.se">

<META NAME="Copyright" content="LNB">

<META NAME="Designer" content="LNB http://balochfest.se">

<META NAME="revisit-after" content="7">

<META NAME="MSSmartTagsPreventParsing" content="TRUE"><base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript">

function popupWindow(url) {

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')

}

<!--//--></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">

<?php

if ($product_check['total'] < 1) {

?>

<!-- START Customers Extra Field -->

<?php echo tep_get_extra_fields($customer_id, $languages_id)?>

<!-- END Customers Extra Field -->

<tr>

<td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<?php

} else {

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_info = tep_db_fetch_array($product_info_query);

 

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

 

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

$products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

} else {

$products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));

}

 

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

$products_name = $product_info['products_name'];

}

$mopics_image_width = (MOPICS_RESTRICT_IMAGE_SIZE=='true'?SMALL_IMAGE_WIDTH:'');

$mopics_image_height = (MOPICS_RESTRICT_IMAGE_SIZE=='true'?SMALL_IMAGE_HEIGHT:'');

 

if (MOPICS_SHOW_ALL_ON_PRODUCT_INFO=='true') {

 

$mopics_output = '';

$mo_row = 1;

$mo_col = 1;

 

$mopics_images = array();

if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'true') { $mopics_images[] = $product_info['products_image']; }

for ( $mo_item=1; $mo_item<7; $mo_item++ ) {

if (tep_not_null($product_info['products_subimage'.$mo_item])) { $mopics_images[] = $product_info['products_subimage'.$mo_item]; }

}

$mopics_count = sizeof($mopics_images);

 

if ($mopics_count > 0) {

 

$mopics_output .= '<table border="0" cellspacing="0" cellpadding="6" align="'.MOPICS_TABLE_ALIGNMENT.'">';

 

for ( $mo_item=0; $mo_item<$mopics_count; $mo_item++ ) {

 

if ($mo_row<(MOPICS_NUMBER_OF_ROWS+1)) {

if ($mo_col==1) {$mopics_output.='<tr>'."\n";}

 

$mopics_output .= ' <td align="center" class="smallText"><script language="javascript"><!--

document.write(\'<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id'].'&invis='.(MOPICS_GROUP_WITH_PARENT=='true'?$mo_item:($mo_item+1))).'\\\')">' . tep_image(DIR_WS_IMAGES . $mopics_images[$mo_item], addslashes($product_info['products_name']), (MOPICS_RESTRICT_PARENT=='false'&&$mo_item==0&&MOPICS_GROUP_WITH_PARENT=='true'?'':$mopics_image_width), (MOPICS_RESTRICT_PARENT=='false'&&$mo_item==0&&MOPICS_GROUP_WITH_PARENT=='true'?'':$mopics_image_height), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>\');

//--></script><noscript>

<a href="' . tep_href_link(DIR_WS_IMAGES . $mopics_images[$mo_item]) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $mopics_images[$mo_item], $product_info['products_name'], $mopics_image_width, $mopics_image_height, 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>

</noscript></td>'."\n";

 

if ($mo_col==MOPICS_NUMBER_OF_COLS) { $mo_col=1; $mo_row++; $mopics_output.='</tr>'."\n"; } else { $mo_col++; }

}

 

}

 

if ($mo_col!=1){ while (($mo_col++)<(MOPICS_NUMBER_OF_COLS+1)) { $mopics_output.='<td> </td>'; } $mopics_output.='</tr>'."\n"; }

 

$mopics_output .= '</table>'."\n";

 

}

 

}

?>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td valign="top"><h1><?php echo $products_name; ?></h1></td>

<td align="right" valign="top"><h1><?php echo $products_price; ?></h1></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main">

<?php

// if (tep_not_null($product_info['products_image'])) {

if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'false') {

/*//++++ QT Pro: Begin Changed code

?>

<table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="smallText">

<?php*/

//++++ QT Pro: End Changed Code

?>

<table border="0" cellspacing="0" cellpadding="2" align="right">

<tr>

<td align="center" class="smallText">

<script language="javascript"><!--

document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>'; ?>');

//--></script>

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_WIDTH), (MOPICS_RESTRICT_PARENT=='false'?'':SMALL_IMAGE_HEIGHT), 'hspace="5" vspace="5"') . '<br><img border=0 src=images/zoom.gif></a>'; ?>

</noscript>

</td>

</tr>

</table>

<?php

}

if (MOPICS_TABLE_LOCATION=='above' && !empty($mopics_output)) {

echo ' <table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td align="center" class="smallText">'.$mopics_output.'</td>

</tr>

</table>

 <br>'."\n";

} else if (MOPICS_TABLE_LOCATION=='sides' && !empty($mopics_output)) {

echo $mopics_output;

}

?>

<p><?php echo stripslashes($product_info['products_description']); ?></p>

<?php

//++++ QT Pro: Begin Changed code

if (tep_not_null($product_info['products_image'])) {/*

?>

</td>

</tr>

</table>

<?php*/

}

//++++ QT Pro: End Changed Code

 

$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

//++++ QT Pro: Begin Changed code

$products_id=(preg_match("/^\d{1,10}(\{\d{1,10}\}\d{1,10})*$/",$HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : (int)$HTTP_GET_VARS['products_id']);

require(DIR_WS_CLASSES . 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN . '.php');

$class = 'pad_' . PRODINFO_ATTRIBUTE_PLUGIN;

$pad = new $class($products_id);

echo $pad->draw();

}

 

//Display a table with which attributecombinations is on stock to the customer?

if(PRODINFO_ATTRIBUTE_DISPLAY_STOCK_LIST == 'True'): require(DIR_WS_MODULES . "qtpro_stock_table.php"); endif;

 

//++++ QT Pro: End Changed Code

/*

?>

<table border="0" cellspacing="0" cellpadding="2">

<tr>

<td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>

</tr>

<?php

$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)$HTTP_GET_VARS['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)$HTTP_GET_VARS['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($product_info['products_tax_class_id'])) .') ';

}

}

 

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {

$selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];

} else {

$selected_attribute = false;

}

?>

<tr>

<td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>

<td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>

</tr>

<?php

}

?>

</table>

<?php

}*/

 

if (MOPICS_TABLE_LOCATION=='below' && !empty($mopics_output)) {

echo ' <br>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td align="center" class="smallText">'.$mopics_output.'</td>

</tr>

</table>'."\n";

}

?>

<!-- START Customers Extra Field -->

<?php echo tep_get_extra_fields($customer_id, $languages_id)?>

<!-- END Customers Extra Field -->

 

</td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

if ($reviews['count'] > 0) {

?>

<tr>

<td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

 

if (tep_not_null($product_info['products_url'])) {

?>

<tr>

<td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<?php

}

 

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

<tr>

<td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>

</tr>

<?php

} else {

?>

<tr>

<td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>

</tr>

<?php

}

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>

<td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td>

<?php

if ((USE_CACHE == 'true') && empty($SID)) {

echo tep_cache_also_purchased(3600);

} else {

include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

}

}

?>

</td>

</tr>

</table></form></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

 

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

 

Very thankfull for help in this case

 

Lasse

You can email me to:

Lasseboy@bkc.nu

Share this post


Link to post
Share on other sites

Hello

 

I installed "Customers extra fields" and i have this message in admin/customers.php when i want to update an account :

 

Warning: in_array() [function.in-array]: Wrong datatype for second argument in ....oscommerce\admin\includes\functions\general.php on line 1356

 

This is the line 1356 in general.php :

$extra_fields_string .= tep_draw_selection_field('fields_' . $extra_fields['fields_id'] . '_' . ($cnt++), 'checkbox', $item, ((in_array($item, $value_list))?(true):(false))).$item. (($extra_fields['fields_required_status']==1) ? '<span class="inputRequirement">*</span>': '').'<br>';

 

Thank's

Share this post


Link to post
Share on other sites

Hello,

 

I have just installed this contribution, the install was very smooth with no reported errors of any sort.

 

However, as I also use Products Extra Fields V1.2, the Extra Fields Manager in my tools section of the admin panel refers to product fields and not the customer ones.

 

How can I move the admin of customer extra fields to the customer section of the admin panel instead?

Share this post


Link to post
Share on other sites

After creating a new account the 'account_success' page is displayed.

Before installing the contribution, the "continue" button on 'account_success' linked either to "your account information" if the account wasn't created during the checkout process or to "checkout_shipping" if it was created when checking out the content of the cart.

After installing the contribution, the "continue" button on 'account_success' always takes you back to the index page.

Does anyone know a way to fix this?

Share this post


Link to post
Share on other sites

I have installed this contribution and so far it has been easy and simple to understand, however, as soon as I get to point 13 of the install I hit a problem.

 

When I enter the code:

 

<!-- // BOF Customers extra fields -->
     <?php echo tep_get_extra_fields($customer_id,$languages_id);?>
<!-- // EOF Customers extra fields -->

 

It wipes the remainder of the screeen from the point of entry! I.e. If I install the code after the CATEGORY_OPTIONS snippet, then everything below this is wiped. The same applies if it is entered at another point on the page.

 

I have installed it twice now and the error still crops up at the same point in the installation process?? The options show up in my Admin Area and Customer Edit area and update fine if they are changed....???

 

Please help

Share this post


Link to post
Share on other sites

Hello,

 

I like very much your addon and will help me a lot with my on-line web shop. But I have a problem. I have successfully installed the add-on, also I got the menu page for adding new field "Extra fields manager" in admin panel, but I have a problem when proceeding over the registration form on the webshop site.

 

When registering and having enabled your add-on with two extra field I get these error:

 

Warning: Cannot modify header information - headers already sent by (output started at /var/www/web57/html/includes/languages/english.php:657) in /var/www/web57/html/includes/functions/general.php  on line 33

 

Also another issue I have.

 

One field I enabled "Required Status: true ; Input Type: Multi checkbox" but on the registration page if I don't tick the checkbox I can normally proceed the registration.

 

Thank you a lot for your help and I appreciate it very much.

Share this post


Link to post
Share on other sites

hi,

 

I have installed Extra customer field and my admin is ok but i can't use create_account. I have this error:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'champs ce, Informations cei where ce.fields_status=1 and cei.fields_id=ce.fields' at line 1

select ce.fields_id, ce.fields_input_type, ce.fields_input_value, ce.fields_required_status, cei.fields_name, ce.fields_status, ce.fields_input_type from Ajouet un champs ce, Informations cei where ce.fields_status=1 and cei.fields_id=ce.fields_id and cei.languages_id =1

 

This error is in this:

 

// BOF Customers extra fields
       $extra_fields_query = tep_db_query("select ce.fields_id, ce.fields_input_type, ce.fields_required_status, cei.fields_name, ce.fields_status, ce.fields_input_type, ce.fields_size from " . TABLE_EXTRA_FIELDS . " ce, " . TABLE_EXTRA_FIELDS_INFO . " cei where ce.fields_status=1 and ce.fields_required_status=1 and cei.fields_id=ce.fields_id and cei.languages_id =" . $languages_id);
  while($extra_fields = tep_db_fetch_array($extra_fields_query)){
   if(strlen($HTTP_POST_VARS['fields_' . $extra_fields['fields_id']])<$extra_fields['fields_size']){
     $error = true;
     $string_error=sprintf(ENTRY_EXTRA_FIELDS_ERROR,$extra_fields['fields_name'],$extra_fields['fields_size']);
     $messageStack->add('create_account', $string_error);
   }
 }
// EOF Customers extra fields

 

can you help me?

 

thinks a lot

 

florian

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
Sign in to follow this  

×