OSC-Sevilla

Solved the issues - I see two tables -"who´s online and sessions"..... Nevermind - thanks all

My store is havily modified, The addon is insatalled and working, however. The addon tells me i have 72 tables for backup. My SQL Server says 74. Hence when i restore form backup im missing things. How to edit the addon to catch all...? IE. the backups are not backing everything up. Any ideas??

After some successful head scrathing the issue is solved. For reason only known to OSC the copied site, identical contained an issue. This issue was the "Aministation table" in the SQL SERVER. I simply updated this table and all went back to normal!

I have two web stores that are identical, both use the smae exact code. For some reason on one of the stores the "NEW DIRECTORY " button has stopped showing.... What would be the cause of this. Everything else is working just fine. Just a pointer would help. Thank you.

I am modding order editor to incoporate my lead time addon that shows if the product carries a lead time and how many days, during editing the order the operatoer can change these the specs: this piece of code refers to a checkbox that shows which product(s) have lead times <td class="dataTableContent" valign="top"><input type="checkbox" title="Lead time Active: <?php echo $order->products[$i]['lead_time_days']; ?> DAYS" name="<?php echo "update_products[" . $orders_products_id . "][lead_time]"; ?>" <?php if (ORDER_EDITOR_USE_AJAX == 'true') { ?>onClick="updateProductsField('update', '<?php echo $orders_products_id; ?>', 'products_lead_time', this.checked, this)"<?php } ?> <?php if($order->products[$i]['lead_time']=='1'){ echo "checked=\"true\""; }?>"></td> The problem i am having is the data form the check box enters mySQL as " true " or " false" - is all well and good but i would like it to go in as "1" or "0" If i deactivate AJAX, it goes in as "on".... My db is currently VARCHAR (5). I have googled searched high and low but not found a straight forward solution. All this is carried out on edit_orders.php: // Update orders_products Table $Query = "UPDATE " . TABLE_ORDERS_PRODUCTS . " SET products_model = '" . $products_details['model'] . "', products_name = '" . oe_html_quotes($products_details['name']) . "', products_price = '" . $products_details['price'] . "', final_price = '" . $products_details['final_price'] . "', products_tax = '" . $products_details['tax'] . "', products_quantity = '" . $products_details['qty'] . "', products_lead_time = '" . $products_details['lead_time'] . "', products_lead_time_days = '" . $products_details['lead_time_days'] . "' WHERE orders_id = '" . (int)$oID . "' AND orders_products_id = '$orders_products_id';"; tep_db_query($Query); Any ideas folks??

BINGO!!!!!! Boom we are back in the game! NIce one!

Any Idea how to add UHTML to Admin MAIL.php???

You Sir are "The Man"!!

Does anyone have this working ok with QT-PRO installed?????????????? admin side working ok, storing suffix, showing OK on shopping_cart.php, but not on roder, inovices packing slips, checkout_confirmation.php was working before QT-PRO....

I have the exact same issue!

I use both english and spanish: the defualt is spanish, so when pages loads its in spanish - when i change languages from the drop down to say english, i get index.php?language=en now whilst thats in the browser url i clcik special, and see. specials.php/en resulting in "No input file specified.".... for everything else its fine. Whats going on here, tralled trought about 150 pages... you guys are the pros whats the score?????

FIXED - it was an jquery upgrade error, went from 1.4 to 1.7 and it didnt like it

Having a slight problem - Moved severs, all working fine except: When browsing images on the server to add photos I can see all the first tier subdirectories but when i click on the subdirectory i just see whats in the products folder and not the subdirectory. image attached

FIXED! -

IS it just me or the product_reviews.php - in modules is not compatable with multi languages???? (TAB section corresponding to reviews) can anyone confirm this? working fine in english but not on any other.

http://www.oscommerce.com/forums/topic/357940-qtpro-multiple-dropdowns-please-select-option/

Quality!!! Thank you

When adding attributes: lets say we have three options, each with three options. How can we force the option box to read "Select Option" instead of having the first option in that tree displayed as default????

This thread has saved my life! Awsome!

ok check this: create account.php tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array); $address_id = tep_db_insert_id(); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_default_address_id = '" . (int)$address_id . "' where customers_id = '" . (int)$customer_id . "'"); tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())"); if (SESSION_RECREATE == 'True') { tep_session_recreate(); } $customer_first_name = $firstname; $customer_default_address_id = $address_id; $customer_country_id = $country; $customer_zone_id = $zone_id; tep_session_register('customer_id'); tep_session_register('customer_first_name'); tep_session_register('customer_default_address_id'); tep_session_register('customer_country_id'); tep_session_register('customer_zone_id'); // reset session token $sessiontoken = md5(tep_rand() . tep_rand() . tep_rand() . tep_rand()); // restore cart contents $cart->restore_contents(); // build the message content //--- Beginning of addition: Ultimate HTML Emails ---// if (EMAIL_USE_HTML == 'true') { require(DIR_WS_MODULES . 'UHtmlEmails/'. ULTIMATE_HTML_EMAIL_LAYOUT .'/create_account.php'); $email_text = $html_email; }else{ //--- End of addition: Ultimate HTML Emails ---// $name = $firstname . ' ' . $lastname; if (ACCOUNT_GENDER == 'true') { if ($gender == 'm') { $email_text = sprintf(EMAIL_GREET_MR, $lastname); } else { $email_text = sprintf(EMAIL_GREET_MS, $lastname); } } else { $email_text = sprintf(EMAIL_GREET_NONE, $firstname); } $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING; //--- 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_create_account.php.htm'; $TheFileHandle = fopen($TheFileName, 'w') or die("can't open error log file"); fwrite($TheFileHandle, $email_text); fclose($TheFileHandle); } //--- End of addition: Ultimate HTML Emails ---// tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL')); } } $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CREATE_ACCOUNT, '', 'SSL')); require(DIR_WS_INCLUDES . 'template_top.php'); require('includes/form_check.js.php'); ?>

Thanks, thats what i tend to do, but one get carried away picking at it! many thanks

most of my pages i validate through http://validator.w3.org/ im not that offay with many, which one do you recommend? I actually have the orgional code but for the time being have referenced it as another case. also, re validation, xhtm transitional and html5 ui references (not sure), such as role="button" umongst others... what validation measures do you undertake? what is your take on it, im wondering about best practises...? some page of mine are 100% (no errors), others are not. Thank you.

html_output.php HTML VALIDATION ERROR ON: case ($link_data['count'] != '' && $link_data['count'] < 1 && SPECIFICATIONS_FILTER_NO_RESULT == 'grey'): $field .= '<optgroup class="no_results" label="'; $field .= tep_output_string ($link_data['text'] ); if (SPECIFICATIONS_FILTER_SHOW_COUNT == 'True' && $link_data['count'] != '') { $field .= ' (' . $link_data['count'] . ')'; } $field .= '"></optgroup>'; break; CHNAGED TO: case ($link_data['count'] != '' && $link_data['count'] < 1 && SPECIFICATIONS_FILTER_NO_RESULT == 'grey'): $field .= '<option disabled="disabled" class="no_results" >'; $field .= tep_output_string ($link_data['text'] ); if (SPECIFICATIONS_FILTER_SHOW_COUNT == 'True' && $link_data['count'] != '') { $field .= ' (' . $link_data['count'] . ')'; } $field .= '</option>'; break;

I would like to validate as much code as possible. I assume this is a common ask although i have found very little information online on how to sure it. IN HTML VALIDATOR: Line 433, Column 1110: ID "tdb1" already defined…product_info.php?products_id=234" id="tdb1" class="ui-button ui-widget ui-stat… there are many instances ofID "tdb1" , is there are workaround or solution for this???

Cahe is set to FALSE