Jump to content

sputnikinternet

Members
  • Content count

    41
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Andy
  1. sputnikinternet

    message card option

    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
  2. sputnikinternet

    uk switch and debit card updates

    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?
  3. 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 .= ', '; }
  4. 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
  5. 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
  6. sputnikinternet

    adult website, description not appearing

    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
  7. 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
  8. 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
  9. sputnikinternet

    gift wrapping error?

    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?
  10. sputnikinternet

    gift wrapping error?

    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
  11. sputnikinternet

    missing info in billing

    damn, i'm a fool! needed to activate it in Modules-->Orders_Total Sorry.
  12. sputnikinternet

    gift wrapping error?

    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
  13. sputnikinternet

    missing info in billing

    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?
×