Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

yoyoman

Pioneers
  • Posts

    75
  • Joined

  • Last visited

Everything posted by yoyoman

  1. Ok i will add somthing to the above i thought the problem was in mobile_product_info.php as that was the page that displayed all wrong but it does display very nicely if i go from the basket back to the product page any ideas would be great as i like this contribution a lot and would love ot get it working properly thanks in advance
  2. really like this idea and it works well untill you get to the product page and then it display the page with no images .. any ideas where the problem lies heres the mobi site www.yoyoz.co.uk/catalog/mobile_index.php
  3. I have trawled just about eveywhere and not found the answer so i am hoping someone has figured this out and can point me in the right direction.. yes i know there is a contribution but its old and dosnt work on my site, i really would like to intergrate the latest version of shadowbox, i have used it on other sites i have built for friends and it works great in simple sites its really versatile and i would love to get it working in os store so i can open video in the layer i have been using lightbox for a couple of years and its great for opening the image in product info pages but seems a little limited in as much as it will only handle images this is the code i have tried droping in to product_info.php <link rel="stylesheet" type="text/css" href="stylesheet.css"> <link rel="stylesheet" type="text/css" href="shadowbox.css"> <script type="text/javascript" src="prototype.js"></script> <script type="text/javascript" src="shadowbox.js"></script> <script type="text/javascript"> Shadowbox.init({ players: ["img" "iframe" "html" "flv"] }); </script> and then i am adding the rel="shadowbox" into this line. pretty much the same as the lightbox setup <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank" rel="shadowbox">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH*2, SMALL_IMAGE_HEIGHT*2, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?> this dosnt break the store but the shadowbox is not loading, the image just opens in a _blank the same happens if i try linking to a html/iframe page it just opens in a new window any help would be great i thankyou in advance
  4. This has bugged me for a while. i have been using the featured products contribution for a while and it works really well for me. my problem is that at the moment it only displays the image and the name of the product. i would like it to also display the price and buy it now button heres the page http://www.yoyoz.co.uk/catalog/ and here is my includes/modules/featured <?php /* osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2002 osCommerce Released under the GNU General Public License Featured Products V1.1 Displays a list of featured products, selected from admin For use as an Infobox instead of the "New Products" Infobox */ ?> <!-- featured_products //--> <?php if(FEATURED_PRODUCTS_DISPLAY == 'true') { $featured_products_category_id = $new_products_category_id; $cat_name_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . $featured_products_category_id . "' limit 1"); $cat_name_fetch = tep_db_fetch_array($cat_name_query); $cat_name = $cat_name_fetch['categories_name']; $info_box_contents = array(); if ( (!isset($featured_products_category_id)) || ($featured_products_category_id == '0') ) { $info_box_contents[] = array('align' => 'left', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); list($usec, $sec) = explode(' ', microtime()); srand( (float) $sec + ((float) $usec * 100000) ); $mtm= rand(); $featured_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id left join " . TABLE_FEATURED . " f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand($mtm) DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } else { $cats[] = $new_products_category_id; // current catID as starting value // put cat-IDs of all cats nested in current branch into $cats array, go through all subbranches for($i=0;$i<count($cats);$i++) { $categorie_query = tep_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$cats[$i] . "'"); while ($categorie = tep_db_fetch_array($categorie_query)) { $cats[] = $categorie['categories_id']; } $cats=array_unique($cats); // sort out doubles } $info_box_contents[] = array('align' => 'center', 'text' => '<a class="headerNavigation" href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS) . '">' . TABLE_HEADING_FEATURED_PRODUCTS . '</a>'); $featured_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where c.parent_id in (".implode(', ', $cats).") and p.products_status = '1' and f.status = '1' order by rand() DESC limit " . MAX_DISPLAY_FEATURED_PRODUCTS); } $row = 0; $col = 0; $num = 0; while ($featured_products = tep_db_fetch_array($featured_products_query)) { $num ++; if ($num == 1) { new contentBoxHeading($info_box_contents); } $featured_products['products_name'] = tep_get_products_name($featured_products['products_id']); if($featured_products['specstat']) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="25%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH*1.6, SMALL_IMAGE_HEIGHT*1.6) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a>'); } else { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="25%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $featured_products['products_image'], $featured_products['products_name'], SMALL_IMAGE_WIDTH*1.6, SMALL_IMAGE_HEIGHT*1.6) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products['products_id']) . '">' . $featured_products['products_name'] . '</a>'); } $col ++; if ($col > 2) { $col = 0; $row ++; } } if($num) { new contentBox($info_box_contents); } } else // If it's disabled, then include the original New Products box { // include (DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); // disable for dont show if desactive the feature module } ?> <!-- featured_products_eof //--> any ideas would be very helpful, i have searched for the solution with no luck, many thanks in advance
  5. I am getting a very similar issue so any advice would be really helpful at this point i have had 3 customers this weekend getting the same error and not just through Paypal Express but also via Nochex it only seem to be on customers fron abroad .. we are UK based ERROR: TIMESTAMP: 2008-11-15T10:21:43Z ACK: FAILURE SHORTMESSAGE: SHIPPING ADDRESS INVALID CITY STATE POSTAL CODE LONGMESSAGE: A MATCH OF THE SHIPPING ADDRESS CITY, STATE, AND POSTAL CODE FAILED. ERRORCODE: 10736
  6. i have recently switched from the standard paypal ipn to pay pal express which works fine in GBP but if a customer pays in either USD of Euros then paypal leaves off the shipping Any ideas
  7. I just tried installing IP Trapped and i am getting similar errors .. i guess i have the username wrong question is which username does this reffer to and where can i find it i have tried various options but nothing is working so far any help many thanks in advance
  8. I looks like dbtools is messing around i tried it as you suggeted and it did the same so i made a new query in dbtools and that worked . thankyou for your help it always makes me smile that people on this forum are so helpful.. thanks agian R
  9. i have installed the nochex apc contribution and all is working fine apart from when i try to apply the mysql file i get this error .. any help would b wonderful as i dont really understand mysql .. it actually scares me a little :blush: MySQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';CREATE TABLE `nochex_apc_transactions` ( `transaction_id` int(11) unsigned NOT' at line 1 QUERY: /*Nochex APC Payment Module (v0.1.1) for osCommerceFile generated by SQLyog Enterprise v4.07**********************************************************************//*Table structure for table `nochex_apc_transactions` */drop table if exists `nochex_apc_transactions`;CREATE TABLE `nochex_apc_transactions` ( `transaction_id` int(11) unsigned NOT NULL auto_increment, `nc_transaction_id` varchar(30) default '0', `nc_to_email` varchar(255) default '0', `nc_from_email` varchar(255) default '0', `nc_transaction_date` varchar(100) default '0', `nc_order_id` int(11) unsigned default '0', `nc_amount` decimal(15,2) default '0.00', `nc_security_key` varchar(255) default '0', `nc_status` varchar(15) default '0', `nochex_response` varchar(255) default '0', `record_updated` varchar(100) default '0', PRIMARY KEY (`transaction_id`));/******************************************************************** DO NOT APPLY THE FOLLOWING TWO INSTRUCTIONS IF YOU ALREADY HAVE THIS MODULE OR THE NOCHEX_APC COMMUNITY MODULE INSTALLED. YOU WILL END UP WITH TWO LOTS OF EACH ORDER STATUS. ********************************************************************//*Table data for table `orders_status` */INSERT INTO `orders_status` VALUES (50000, 1, 'Nochex Processing');INSERT INTO `orders_status` VALUES (50001, 1, 'Nochex Authorised')
  10. awsome thanks ever so .. that worked perfectly
  11. i guess from the look of that code it is in the mysql database .. not sure im ready to tackle fiddling in there quite yet ..hehe
  12. i have basicly followed the instruction on the first page of this thread to manually change the date format in catalog and admin and the address format in catalog files edited were catalog/includes/languages/english.php catalog/admin/includes/languages/english.php catalog/includes/modules/address_book_details.php catalog/create_account.php as i say it all seems fine and all is working except the post code still comes before the county in the address in admin any other files i should be looking at ?
  13. i have been converting dates and adress formats to UK format and all works well in catalog .. my problem is in admin when i look at the address format on orders it always has the post code before the county/state now that has not been a problem until i tried to print address labels where of course the format is wrong for the uk anybody know which files relate to the address format in admin ?? thanks in advance
  14. Heya im looking for somthing similar as the weight option seems not to work for me
×
×
  • Create New...