Druide

to fix the option values extra ' , ' on the end of the line (in your output PDF data-sheet) example... Colors: Black, Blue, Green, Red, change in file pdf/pdf_datasheet_functions.php search for if(SHOW_OPTIONS) { find this... $products_options = tep_db_query("select pa.products_options_sort_order, 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_options_sort_order != '0' and pa.products_id = '" . $products_id . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pa.products_options_sort_order, 0+pov.products_options_values_name"); add after this: $count_options_values = tep_db_num_rows($products_options); $count_options = 0; original continues... while ($products_options_values = tep_db_fetch_array($products_options)) { $products_options_array[] = array('id' => $products_options_values['products_options_values_id'], 'text' => $products_options_values['products_options_values_name'], 'price_id' => $products_options_values['products_options_values_id'], 'text2' => $products_options_values['options_values_price']); $w=$this->GetStringWidth($products_options_values['products_options_values_name'])+2; $this->SetFont('times','',10); $this->SetTextColor(0,0,200); $this->Write(5,$products_options_values['products_options_values_name']); replace last line above $this->Write(5,$products_options_values['products_options_values_name']); with this code: if ( $products_options_values['options_values_price'] != ' 0.0000' && SHOW_PRICE == '1') { $count_options++; $add_to = ($count_options_values != $count_options ? ',' : '.' ); $this->Write(5,$products_options_values['products_options_values_name']. ' (' . $products_options_values['price_prefix'] . $currencies->display_price($products_options_values['options_values_price'], tep_get_tax_rate($product_info_values['products_tax_class_id'])) . ')' . $add_to); } else { $count_options++; $add_to = ($count_options_values != $count_options ? ',' : '.' ); $this->Write(5,$products_options_values['products_options_values_name'] . $add_to); } that's it...

if you wan to use ivan's code then dont forget to add in: pdf/pdf_datasheet_config.php define('SHOW_OPTIONS_PRICE',1); ;)

the best way to adding mods is BACKUP, BACKUP, BACKUP, BACKUP & create a dev version on your own machine or so before you do something horrible in your life ;)

yes sorry but i must have missed it about 4 times, went through the whole list several times after eachother. it would be nice if they made some search options there, which i have send an email about last week (to [email protected]) but no reply or so.... patience is a virtue.. thanks anyway for your help much appreciated will check my eyes also...lol

does this contribution have a different name then UPS Order Tracking XML Version 2.3 because i still cant find it in the CONTRIBUTIONS :( anyone has a direct link ?

sorry but i only changed 'that' last piece of code as i wrote above check your TABLE: products_attributes if you have the field: products_options_sort_order this should be field # 7 (in my db)

just start to read at post 1 till the end copy and past ALL changes in a textfile or whatever programm you prefer. Thats the way many ppl did it (like me) and it works like a charm now I dont want to be rude but you have to do something to accomplish something GREATER !!! Good luck

Another question... in catalog/pdf/pdf_datasheet_functions.php line 403-433 approx. if(SHOW_OPTIONS) { if (tep_db_num_rows($products_options_name)) { $this->MultiCell(0,8,TEXT_PRODUCTS_OPTIONS . $print_catalog_array['name'] .' :',0,'L',0); $this->Ln(-5); } while ($products_options_name_values = tep_db_fetch_array($products_options_name)) { $products_options_array = array(); $products_options_name_values['products_options_name']; $this->Ln(6); $this->SetFont('helvetica','b',11); $this->Cell(190,5,$products_options_name_values['products_options_name'],0,0,'L'); $products_options = tep_db_query("select pa.products_options_sort_order, 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 = '" . $products_id . "' and pa.options_id = '" . $products_options_name_values['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'" . " order by pa.products_options_sort_order, 0+pov.products_options_values_name"); while ($products_options_values = tep_db_fetch_array($products_options)) { $products_options_array[] = array('id' => $products_options_values['products_options_values_id'], 'text' => $products_options_values['products_options_values_name']); $w=$this->GetStringWidth($products_options_values['products_options_values_name'])+2; $this->SetFont('times','',10); $this->SetTextColor(0,0,200); $this->Write(5,$products_options_values['products_options_values_name'].' ,'); $this->Cell(3,6,"",0,0,'C'); $this->SetTextColor(0,0,0); if ($products_options_values['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options_values['price_prefix'] . $currencies->display_price($products_options_values['options_values_price'], tep_get_tax_rate($product_info_values['products_tax_class_id'])) .') '; } } } } the last piece of code doesn't do anything this piece if ($products_options_values['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options_values['price_prefix'] . $currencies->display_price($products_options_values['options_values_price'], tep_get_tax_rate($product_info_values['products_tax_class_id'])) .') '; therefor i changed this line 424 approx. $this->Write(5,$products_options_values['products_options_values_name'].' ,'); to $this->Write(5,$products_options_values['products_options_values_name'].' (' . $products_options_values['price_prefix'] . $currencies->display_price($products_options_values['options_values_price'], tep_get_tax_rate($product_info_values['products_tax_class_id'])) . ') ,'); to see what i wanted to see anyone else some idea's why the original is not working ?

that's it, i was not finished yet like i said....lol that's why i wrote ... and etc... Thanks Linda for finishing this easy MOD

i was thinking to use also something like this (not finished yet): if (DOWN_FOR_MAINTENANCE == 'true') { $maintenance_on_at_time = tep_db_query("select last_modified from " . TABLE_CONFIGURATION . " WHERE configuration_key = '" . DOWN_FOR_MAINTENANCE . "'"); define('TEXT_MAINTENANCE_ON_AT_TIME', 'The Admin / Webmaster has enabled maintenance at' . $maintenance_on_at_time['last_modified']); .... } etc... (just came back from eating lots of SUSHI ) :):):) this to output the time when the site is deactivated So if you set a time in ADMIN option 'Down for Maintennance Display Text' like: We expect it to be ready again in 15-30 minutes. then the visitors can see when to look again at the site ;) Anyway this is waiting to be finished when i make some time for it... First lots of other things todo...

FIRST: check your TABLE if Alabama already exists ! put this query in you phpadmin or whatever you use to search your zones table: SELECT `zone_id` , `zone_country_id` , `zone_code` , `zone_name` FROM `zones` WHERE 1 AND `zone_name` LIKE 'Alabama' Second: if it doesn't exist then replace to INSERT INTO zones VALUES ( '', 223, 'AL', 'Alabama' ) replace the 1 by '' BUT it should be there with your fresh installation !!!!

nice one much appreciated for another functional MOD that was on my TODO list.

and another patch, sorry for all this trouble it's not that easy to take out code from extremely modded files...lol NOW everything works 100% :)

updated to version 1.1 http://www.oscommerce.com/community/contributions,1055 There seem to be some BUGS, sorry for that... :( updated the files. thanks to Illicious & Morbantokk & davidturetsky for bug tracking :)

check in your database if you have the user_tracking table :) if not then import this: CREATE TABLE user_tracking ( customer_id int(11) default NULL, click_id int(11) default NULL, full_name varchar(64) NOT NULL default '', session_id varchar(128) NOT NULL default '', ip_address varchar(15) NOT NULL default '', time_entry varchar(14) NOT NULL default '', time_last_click varchar(14) NOT NULL default '', last_page_url varchar(64) NOT NULL default '', page_desc varchar(64) NOT NULL default '' ) TYPE=MyISAM;

go look for the mod: catalog products with images that one is VERY good if you ask me, easy to edit at your own needs too...

I believe that is why they created BUGS....lol As always together we are STRONG ! I have made too many modifications to remember what i did exactly. To all newbee's: be smart and keep records of ALL your modifications !!! BACKUP BACKUP BACKUP

Complete version of this WONDERFULL modification with an integrated ADMIN area to set: - User Tracking on/off - User Tracking (exclude this IP-Address) - User Tracking (Session # Limit per 24 hour) the above was before hardcoded in the files (not very functional but a good start) This is my second modification of an existing modification. I hope you like it [email protected] A life shop / bussiness !!!

To those who installed the modification Big Images Modification v1.23 add this to your admin/includes/functions/general.php find: function tep_remove_product($product_id) { $product_image_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($product_id) . "'"); $product_image = tep_db_fetch_array($product_image_query); $duplicate_image_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " where products_image = '" . tep_db_input($product_image['products_image']) . "'"); $duplicate_image = tep_db_fetch_array($duplicate_image_query); if ($duplicate_image['total'] < 2) { if (file_exists(DIR_FS_CATALOG_IMAGES . $product_image['products_image'])) { @unlink(DIR_FS_CATALOG_IMAGES . $product_image['products_image']); } } add after... $product_bimage_query = tep_db_query("select products_bimage from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($product_id) . "'"); $product_bimage = tep_db_fetch_array($product_bimage_query); $duplicate_bimage_query = tep_db_query("select count(*) as totalb from " . TABLE_PRODUCTS . " where products_bimage = '" . tep_db_input($product_bimage['products_bimage']) . "'"); $duplicate_bimage = tep_db_fetch_array($duplicate_bimage_query); if ($duplicate_bimage['totalb'] < 2) { if (file_exists(DIR_FS_CATALOG_IMAGES . $product_bimage['products_bimage'])) { @unlink(DIR_FS_CATALOG_IMAGES . $product_bimage['products_bimage']); } } this is to keep your space reduced at your Host/Server (it will check if the image is still in use by other products else it will be deleted from the images directory.) I hope i did it right because i have all my images placed in other dirs images/products/ images/products/small/ images/products/additional/ images/products/additional/small/ etc... to keep a better view on my uploaded images. :P ============ still strange nobody else did see this... anyway enjoy Robert H. (a happy user of Osc)

congradulations my daughter is already 8 months old.... MAN the time goes WAY TOO FAST !!!

I am looking for a contribution that will set the actual time for the user/customer to the real time (not the time of the server HOST :) ) This because all variables like 'products.products_date_added' etc. and 'orders_status_history.date_added' are set to my servers 'HOST' time. is there a contribution available for this ? My ADMIN section like in the user tracking contribution etc.. is showing not the same time like mine (i am 3 hours ahead of my HOST) - i need a contribution that i can set all time variables to my actual time - also it would be nice when a logged in customer can set his timezone :) any help is much appreciated Robert My real live project www.ruddlesmills.com THIS IS A REAL COMPANY's WEBSITE !!! so do not place orders to test it out !!!