sputnikinternet
Archived-
Posts
41 -
Joined
-
Last visited
Everything posted by sputnikinternet
-
I've searched forums and contributions to see if there is a way to have an option to charge for a personal message to be delivered with the purchase. I can't find it anywhere. does anyone know of one? Cheers Andy
-
I would be interested to find the latest version as well. I thought i had th latest, but my own switch number is not accepted (it starts 675940). It's strange cos when i look at the code, it look like it should be accepting it. Any suggestions?
-
[Contribution] Description in Product Listing MS2 v.2.3
sputnikinternet replied to a topic in General Add-Ons Support
Hmmm I seem to have fixed the SELECT blah blah problem. For those that suffer the same gremlin, i took this code in index.php, and removed the bit in red cos it seemed to be putting too many commas in. Hopefully this won't bring up problems elsewhere. for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) { continue; } if (tep_not_null($select_column_list)) { $select_column_list .= ', '; } switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model'; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name'; break; // Products Description Hack begins case 'PRODUCT_LIST_DESCRIPTION': $select_column_list .= 'pd.products_description'; break; // Products Description Hack ends case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name'; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity'; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image'; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight'; break; } } if (tep_not_null($select_column_list)) { $select_column_list .= ', '; } -
[Contribution] Description in Product Listing MS2 v.2.3
sputnikinternet replied to a topic in General Add-Ons Support
It seems to be something to do with the if (tep_not_null($select_column_list)) { $select_column_list .= ', '; } bits if i change it to if (tep_not_null($select_column_list)) { $select_column_list .= ', 555'; } i get 1064 - You have an error in your SQL syntax near ' 555pd.products_name, , 555, 555, 555pd.products_description, p.products_id, p.' at line 1 select p.products_image, , 555pd.products_name, , 555, 555, 555pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.products_name limit 0, 20 -
[Contribution] Description in Product Listing MS2 v.2.3
sputnikinternet replied to a topic in General Add-Ons Support
I see a few people have had this problem... 1064 - You have an error in your SQL syntax near ' pd.products_name, , , , pd.products_description, p.products_id, p.manufacturer' at line 1 select p.products_image, , pd.products_name, , , , pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.products_name limit 0, 20 ...but i've replaced my general.php and index.php files and it's not worked. I know I shouldn't have the extra commas, but they're put in dynamically by the code. Does anyone know the fix? Is the bug brought in from one of the other includes? A -
adult website, description not appearing
sputnikinternet replied to sputnikinternet's topic in General Add-Ons Support
I've been fiddling and put all files back the way the mod specifies. The advanced_search works (I know the page appears at the bottom, that's next on the list to fix, i know what the prob is there) - but the simple product_listing doesn't display the description, and is probably responsible for the jagged table display. Any clues will be throughly investigated. A -
Hi All WARNING: This site is not for the faint hearted, for others who can help, read on.... My truncated description is not appearing on the page http://www.musthavetoys.com/index.php?cPath=2 I have copied the product_listing.php page directly from the mod. I was having problems with formatting, so i took out // Products Description Hack begins if (PRODUCT_LIST_DESCRIPTION > 0) { $lc_params = 'rowspan="2" '; } // Products Description Hack ends from product_listing.php Don't know if it's related? Any ideas? Cheers Andy
-
[Contribution] Description in Product Listing MS2 v.2.3
sputnikinternet replied to a topic in General Add-Ons Support
Hi All WARNING: This site os not for the faint hearted, for others who can help, read on.... My truncated description is not appearing in http://www.musthavetoys.com/index.php?cPath=2 I was having problems with formatting, so i took out // Products Description Hack begins if (PRODUCT_LIST_DESCRIPTION > 0) { $lc_params = 'rowspan="2" '; } // Products Description Hack ends Don't know if it's related? Any ideas? Cheers Andy -
seeing as it seems to be a problem (and i could be wrong) with the Nogift bit, i notice that in the module for nogift, i don't get the zones drop down like i do in the gift module. instead i get a text box with no description about what it is. is this what other people get?
-
just noticed that my problem seems to be something to do with $quotes1. at this stage $quotes1_size = sizeof($quotes1); if ($quotes1_size > 1) { $quotes1_size turns out to be 1. It doesn't seem to be reading my "No Gift Wrap" option. Could be wrong, but if this helps someone help me... Andy
-
missing info in billing
sputnikinternet replied to sputnikinternet's topic in General Add-Ons Support
damn, i'm a fool! needed to activate it in Modules-->Orders_Total Sorry. -
Hi Mark I'm getting the same error now. Seemed to happen for no reason. Aslo, I've lost my radio button to deselect gift wrapping. Did you find a solution? Andy
-
this is what i get if i add the giftwrap facliity Sub-Total: ?57.00 Flat Rate (Best Way): ?0.01 Total: ?62.01 No idea why it isn't listing. I've had a rummage, but it SEEMS ok. Any suggestions?