bito

is in the stylesheet.css : class "ball" an "ball1" Cheers

Thank you Dr. Rolex. This is a very useful addon. How can I change or remove the loading image (that appears when the page content is loading)? Cheers

Sorry I understood wrong; in your case you have just to consider categories that have parent_id = 0 -> just make an inner joint clause

Hi Carmelo For me is not a problem to have all extra fields in all products; then, to solve your / my problem I changed the DB query: in: admin/categories.php find: $extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " pef WHERE category_id like '% " . $current_category_id . ",%' OR category_id=" . $current_category_id . " OR category_id='all' OR pef.category_id=(SELECT c.parent_id FROM " . TABLE_CATEGORIES . " as c WHERE c.categories_id = " . $current_category_id . ") ORDER BY products_extra_fields_order"); and change to anything simpler (and wider): $extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " ORDER BY products_extra_fields_order"); Cheers

In product_listing we have in the header that allows the sorting of the products by Name, Manufacturer, Model, ... and Price. With this - great - contribution the header gets a wrong format. Can we add the fields of Extra Field into the list of sorting? Thanks

this is a usefull and a great contribution!! thank you wdepot for new version v1.11 that's good now :lol: wedpot is it possible to show news field in products_new.php and modules/new_products.php ? thanks again regards

Hi all, thanks wdepot for this contribution - version 1.1 after create a new field successfully and try to insert the Extra field values i'm having this error: Warning: Missing argument 2 for tep_build_epf_pulldown(), called in C:\xampp\htdocs\imomontado2\admin\extra_values.php on line 238 and defined in C:\xampp\htdocs\imomontado2\admin\includes\functions\general.php on line 1371 This drop down list of values will look like this: :blink: My admin\includes\functions\general.php (with the changes) look like this: //for Extra Product Fields function tep_get_extra_field_list_value($value_id, $show_chain = false) { $sql = tep_db_query("select epf_value, parent_id from " . TABLE_EPF_VALUES . " where value_id = " . (int)$value_id); $value = tep_db_fetch_array($sql); if ($show_chain && ($value['parent_id'] > 0)) { return tep_get_extra_field_list_value($value['parent_id'], true) . ' | ' . $value['epf_value']; } else { return $value['epf_value']; } } function tep_list_epf_children($parent_id) { $sql = tep_db_query("select value_id from " . TABLE_EPF_VALUES . " where parent_id = " . (int)$parent_id); $list = ''; while ($i = tep_db_fetch_array($sql)) { $list .= ', ' . $i['value_id'] . tep_list_epf_children($i['value_id']); } return $list; } function tep_build_epf_pulldown($epf_id, $languages_id, $value_array = '', $parent_id = 0, $indent = '') { if (!is_array($value_array)) $value_array = array(); $sql = tep_db_query("select epf_value, value_id from " . TABLE_EPF_VALUES . " where epf_id = " . (int)$epf_id . " and languages_id = " . (int)$languages_id . " and parent_id = " . (int)$parent_id . " order by sort_order, epf_value"); while ($v = tep_db_fetch_array($sql)) { $value_array[] = array('id' => $v['value_id'], 'text' => $indent . $v['epf_value']); $value_array = tep_build_epf_pulldown($epf_id, $languages_id, $value_array, $v['value_id'], $indent . '·'); } return $value_array; } function tep_get_product_extra_value($epf_id, $product_id, $language_id) { $epf_query = tep_db_query("select epf_id, epf_uses_value_list from " . TABLE_EPF . " where epf_id = " . (int)$epf_id); $e = tep_db_fetch_array($epf_query); $field = "extra_value" . ($e['epf_uses_value_list'] ? '_id' : '') . $e['epf_id']; $product_query = tep_db_query("select " . $field . " from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'"); $product = tep_db_fetch_array($product_query); return $product[$field]; } ?> Line 1371 is: function tep_build_epf_pulldown($epf_id, $languages_id, $value_array = '', $parent_id = 0, $indent = '') { NOTE: 2 changes in this file

Sorry guys my mistake everything works fine thenks

Hi. I installed this contribution and (almost) everything works fine except the link of the page where customer has to introduce activation code isn't in the email. In the email customer only receives de Activation Code.

Fixed. Sorry guys, but i had run sql code into the wrong database.

Great contribution. I don't know why it happens but when I run in local server (XAMPP) goes fine but when it runs in net server all area in order.php below the tag require(DIR_WS_MODULES . 'standard_order_comments.php'); simply desappeared. :(

Hi timehost I think the problem is not in the file you show Please go to catalog/tell_a_friend.php and find : tep_mail($to_name, $to_email_address, UHE_TEXT_EMAIL_SUBJECT, $email_body, $from_name, $from_email_address); ´ If you find UHE_TEXT_EMAIL_SUBJECT, that's OK! Then go to catalog/includes/languages/-- your language -- /modules/UHtmlEmails/standard/tell_a_friend.php and put the subject you want in: define('UHE_TEXT_EMAIL_SUBJECT', ' --- THE SUBJECT YOU WANT --- '); That's it.

I made some changes... Please go to catalog/includes/languages/modules/UHtmlEmails/Standard/checkout_process.php (not the file you show; this is in catalogue/includes/modules...) Find define('UHE_TEXT_DEAR', ' and insert the code for image logo <a href="http://www.YOURSITE.com"><img src=http://www.YOURSITE.com/images/logo.gif width=240 height=92 border=0></a><br /> It'll look something like this: define('UHE_TEXT_DEAR', '<a href="http://www.YOURSITE.com"><img src=http://www.YOURSITE.com/images/logo.gif width=240 height=92 border=0></a><br />Dear Sir / Mrs.'); Don't forget customize url's and width and height image settings Adelino

Hi Nick I use a logo image with this: In catalog/includes/languages/modules/UHtmlEmails/Standard/"all files you want" : define('UHE_GREET_MR', '<a href="http://www.YOURSITE.com"><img src=http://www.YOURSITE.com/images/logo.gif width=240 height=92 border=0></a><br /> Exmo(a). Sr(a). %s,'); define('UHE_GREET_MS', '<a href="http://www.YOURSITE.com"><img src=http://www.YOURSITE.com/images/logo.gif width=240 height=92 border=0></a><br /> Exmo(a). Sr(a). %s,'); define('UHE_GREET_NONE', '<a href="http://www.YOURSITE.com"><img src=http://www.YOURSITE.com/images/logo.gif width=240 height=92 border=0></a><br /> Exmo(a). Sr(a). %s,'); Don't forget customize url's and width and height image settings :) Adelino

Hi, great work this contribution. I installed and everything goes fine except the subject of "tell_a_friend" -> is empty!! Here the code of my tell_a_friend.php: //--- Beginning of addition: Ultimate HTML Emails ---// if (EMAIL_USE_HTML == 'true') { require(DIR_WS_MODULES . 'UHtmlEmails/'. ULTIMATE_HTML_EMAIL_LAYOUT .'/tell_a_friend.php'); $email_body = $html_email; }else{//Send text email //--- End of addition: Ultimate HTML Emails ---// $email_subject = sprintf(TEXT_EMAIL_SUBJECT, $from_name, STORE_NAME); $email_body = sprintf(TEXT_EMAIL_INTRO, $to_name, $from_name, $product_info['products_name'], STORE_NAME) . "\n\n"; if (tep_not_null($message)) { $email_body .= $message . "\n\n"; } $email_body .= sprintf(TEXT_EMAIL_LINK, tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['products_id'], 'NONSSL', false)) . "\n\n" . sprintf(TEXT_EMAIL_SIGNATURE, STORE_NAME . "\n" . HTTP_SERVER . DIR_WS_CATALOG . "\n"); //--- Beginning of addition: Ultimate HTML Emails ---// } if(ULTIMATE_HTML_EMAIL_DEVELOPMENT_MODE === 'true'){ //Save the contents of the generated html email to the harddrive in .htm file. This can be practical when developing a new layout. $TheFileName = 'Last_mail_from_tell_a_friend.htm'; $TheFileHandle = fopen($TheFileName, 'w') or die("can't open error log file"); fwrite($TheFileHandle, $email_body); fclose($TheFileHandle); } //--- End of addition: Ultimate HTML Emails ---// tep_mail($to_name, $to_email_address, $email_subject, $email_body, $from_name, $from_email_address); $messageStack->add_session('header', sprintf(TEXT_EMAIL_SUCCESSFUL_SENT, $product_info['products_name'], tep_output_string_protected($to_name)), 'success'); tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['products_id'])); } } elseif (tep_session_is_registered('customer_id')) { $account_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$customer_id . "'"); $account = tep_db_fetch_array($account_query); $from_name = $account['customers_firstname'] . ' ' . $account['customers_lastname']; $from_email_address = $account['customers_email_address']; } ========================== Thanks