Jump to content

darkjedig

New Members
  • Posts

    9
  • Joined

  • Last visited

    Never

Everything posted by darkjedig

  1. Here is my product_info.php file which I cannot get to display more than one product image: <?php /* $Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <script type="text/javascript" src="iepngfix_tilebg.js"></script> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <!-- BOF SUHY --> <script> // Script Source: CodeLifter.com // Copyright 2003 // Do not remove this notice. // SETUPS: // =============================== // Set the horizontal and vertical position for the popup PositionX = 100; PositionY = 100; // Set these value approximately 20 pixels greater than the // size of the largest image to be used (needed for Netscape) defaultWidth = 750; defaultHeight = 750; // Set autoclose true to have the window close automatically // Set autoclose false to allow multiple popup windows var AutoClose = true; // Do not edit below this line... // ================================ if (parseInt(navigator.appVersion.charAt(0))>=4){ var isNN=(navigator.appName=="Netscape")?1:0; var isIE=(navigator.appName.indexOf("Microsoft")!=-1)?1:0;} var optNN='scrollbars=no,width='+defaultWidth+',height='+defaultHeight+',left='+PositionX+',top='+PositionY; var optIE='scrollbars=no,width=150,height=100,left='+PositionX+',top='+PositionY; function popImage(imageURL,imageTitle){ if (isNN){imgWin=window.open('about:blank','',optNN);} if (isIE){imgWin=window.open('about:blank','',optIE);} with (imgWin.document){ writeln('<html><head><title>Loading...</title><style>body{margin:0px;}</style>');writeln('<sc'+'ript>'); writeln('var isNN,isIE;');writeln('if (parseInt(navigator.appVersion.charAt(0))>=4){'); writeln('isNN=(navigator.appName=="Netscape")?1:0;');writeln('isIE=(navigator.appName.indexOf("Microsoft")!=-1)?1:0;}'); writeln('function reSizeToImage(){');writeln('if (isIE){');writeln('window.resizeTo(300,300);'); writeln('width=300-(document.body.clientWidth-document.images[0].width);'); writeln('height=300-(document.body.clientHeight-document.images[0].height);'); writeln('window.resizeTo(width,height);}');writeln('if (isNN){'); writeln('window.innerWidth=document.images["George"].width;');writeln('window.innerHeight=document.images["George"].height;}}'); writeln('function doTitle(){document.title="'+imageTitle+'";}');writeln('</sc'+'ript>'); if (!AutoClose) writeln('</head><body bgcolor=000000 scroll="no" onload="reSizeToImage();doTitle();self.focus()">') else writeln('</head><body bgcolor=000000 scroll="no" onload="reSizeToImage();doTitle();self.focus()" onblur="self.close()">'); writeln('<img name="George" src='+imageURL+' style="display:block"></body></html>'); close(); }} </script> <link rel="stylesheet" href="thumbnailviewer2.css" type="text/css"> <!-- EOF SUHY --> <style type="text/css"> .ie6_png {behavior: url("iepngfix.htc") } .ie6_png img {behavior: url("iepngfix.htc") } .ie6_png input {behavior: url("iepngfix.htc") } </style> <!--[if IE]> <script type="text/javascript" src="ie_png.js"></script> <script type="text/javascript"> ie_png.fix('.png'); </script> <![endif]--> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150') } //--></script> </head> <body> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0"> <tr> <td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?> <?php if ($product_check['total'] < 1) { ?> <?php echo tep_draw_top();?> <?php echo tep_draw_title_top();?> <?php echo TEXT_PRODUCT_NOT_FOUND; ?> <?php echo tep_draw_title_bottom();?> <?php echo tep_draw1_top();?> <?php echo tep_draw_infoBox2_top();?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr><td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td></tr> </table> <?php echo tep_draw_infoBox2_bottom();?> <?php echo tep_draw1_bottom();?> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price2 = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price2 = '<span class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>'; } if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = '<span class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>'; } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br> <span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <?php echo tep_draw_top();?> <?php echo tep_draw_title_top();?> <div class=" in_prod_info"><?php echo $breadcrumb->trail(' » ')?> » <?php echo $products_name; ?></div> <?php echo tep_draw_title_bottom();?> <?php echo tep_draw1_top();?> <?php /* echo tep_draw2_top(); */ ?> <?php /* echo tep_pixel_trans(); */?> <?php if (tep_not_null($product_info['products_image'])) { ?> <div class="inmain" style="float:left;padding:1px 1px 1px 1px;margin:0px 20px 0px 0px; text-align:center; width:<?php echo (SMALL_IMAGE_WIDTH +14);?>px;"> <table><tr><td> <?php echo tep_draw_prod_pic_top();?> <!-- BOF SUHY --> <?php $PicCount = 0; echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail1" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo '</div></td>'; $PicCount = $PicCount + 1; if ($product_info['product_image_2'] != "") { echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail2" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['product_image_2']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['product_image_2']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['product_image_2'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['product_image_2']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo '</div><td>'; $PicCount = $PicCount + 1; } if ($product_info['product_image_3'] != "") { echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail3" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['product_image_3']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['product_image_3']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['product_image_3'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['product_image_3']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo "</div></td>"; $PicCount = $PicCount + 1; } if ($product_info['product_image_4'] != "") { echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail4" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['product_image_4']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['product_image_4']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['product_image_4'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['product_image_4']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo "</div></td>"; $PicCount = $PicCount + 1; } ?> <!-- EOF SUHY --> <!-- this is a support for showing 4 images in a row as I needed for my page. If you need more images just continue the code or make your own table and use the appropriate links in table cells .. Just replace product_image_4 to 5 and 6 accordingly in all instances --> </td></tr></table> </div> <div class="inmain"><div class=""><?php echo stripslashes($product_info['products_description']); ?></div><br><?php echo $products_price?></div> <div style="clear:both;"></div> <?php } ?> <?php echo tep_pixel_trans();?> <?php /* echo tep_draw2_bottom(); */ ?> <div class="cart_line_x padd_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div> <?php echo tep_draw2_top();?> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <?php echo tep_pixel_trans();?> <table border="0" cellspacing="4" cellpadding="2"> <tr> <td class="inmain" colspan="2"><strong class="strong"><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select 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 = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="inmain"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="inmain"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> </tr> <?php } ?> </table> <?php } ?> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="inmain"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> </table> <?php } if (tep_not_null($product_info['products_url'])) { ?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="inmain"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> </table> <?php echo tep_pixel_trans();?> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <?php echo tep_pixel_trans();?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> </table> <?php } else { ?> <?php echo tep_pixel_trans();?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> </table> <?php } ?> <?php echo tep_draw2_bottom();?> <?php echo tep_pixel_trans();?> <div class="cart_line_x padd_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div> <?php echo tep_draw2_top();?> <?php echo tep_pixel_trans();?> <?php /* echo tep_draw_infoBox2_top(); */ ?> <table cellpadding="0" cellspacing="0" border="0" class="button_block" style="width:40%;"> <tr> <td class="button_block_td"> <table cellpadding="0" cellspacing="0" border="0" style="width:auto; margin-left:14px;"> <tr> <td style="text-align:left;"> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?><br> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?> </td> </tr> </table> </td> </tr> </table> <?php /* echo tep_draw_infoBox2_bottom(); */ ?> <?php echo tep_draw2_bottom();?> <?php echo tep_draw1_bottom();?> <?php echo tep_draw_bottom();?> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </form></td> <!-- body_text_eof //--> <td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  2. Hello everyone! I am in urgent need of some help from the PHP gurus out there. I am not a programmer by any standard but I have tried for 14 straight hours to sort out a contribution I need for my friend's website. I am trying to implement this: http://addons.oscommerce.com/info/5930 to allow me to have multiple product images with a rollover popup. I have installed the contribution successfully, however since my design is a template the product_info.php file is drastically different than the original OScommerce file which is in order to incorporate the template's styles. My problem is that I cannot get it to display more than one image on the product info page. I have pasted the contributions prpduct_info.php file over my own to test it, and I get the multiple images I need, but it makes the site go haywire due to the styling being overwritten. If anyone out there could please help me I would be extremely grateful as I am losing sleep over this!!! Help! Regards, Ry. the contributions product_info.php: <?php /* $Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_check = tep_db_fetch_array($product_check_query); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <!-- BOF SUHY --> <script> // Script Source: CodeLifter.com // Copyright 2003 // Do not remove this notice. // SETUPS: // =============================== // Set the horizontal and vertical position for the popup PositionX = 100; PositionY = 100; // Set these value approximately 20 pixels greater than the // size of the largest image to be used (needed for Netscape) defaultWidth = 750; defaultHeight = 750; // Set autoclose true to have the window close automatically // Set autoclose false to allow multiple popup windows var AutoClose = true; // Do not edit below this line... // ================================ if (parseInt(navigator.appVersion.charAt(0))>=4){ var isNN=(navigator.appName=="Netscape")?1:0; var isIE=(navigator.appName.indexOf("Microsoft")!=-1)?1:0;} var optNN='scrollbars=no,width='+defaultWidth+',height='+defaultHeight+',left='+PositionX+',top='+PositionY; var optIE='scrollbars=no,width=150,height=100,left='+PositionX+',top='+PositionY; function popImage(imageURL,imageTitle){ if (isNN){imgWin=window.open('about:blank','',optNN);} if (isIE){imgWin=window.open('about:blank','',optIE);} with (imgWin.document){ writeln('<html><head><title>Loading...</title><style>body{margin:0px;}</style>');writeln('<sc'+'ript>'); writeln('var isNN,isIE;');writeln('if (parseInt(navigator.appVersion.charAt(0))>=4){'); writeln('isNN=(navigator.appName=="Netscape")?1:0;');writeln('isIE=(navigator.appName.indexOf("Microsoft")!=-1)?1:0;}'); writeln('function reSizeToImage(){');writeln('if (isIE){');writeln('window.resizeTo(300,300);'); writeln('width=300-(document.body.clientWidth-document.images[0].width);'); writeln('height=300-(document.body.clientHeight-document.images[0].height);'); writeln('window.resizeTo(width,height);}');writeln('if (isNN){'); writeln('window.innerWidth=document.images["George"].width;');writeln('window.innerHeight=document.images["George"].height;}}'); writeln('function doTitle(){document.title="'+imageTitle+'";}');writeln('</sc'+'ript>'); if (!AutoClose) writeln('</head><body bgcolor=000000 scroll="no" onload="reSizeToImage();doTitle();self.focus()">') else writeln('</head><body bgcolor=000000 scroll="no" onload="reSizeToImage();doTitle();self.focus()" onblur="self.close()">'); writeln('<img name="George" src='+imageURL+' style="display:block"></body></html>'); close(); }} </script> <link rel="stylesheet" href="thumbnailviewer2.css" type="text/css"> <!-- EOF SUHY --> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <?php if ($product_check['total'] < 1) { ?> <tr> <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.product_image_2, p.product_image_3, p.product_image_4, p.product_image_5, p.product_image_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading" valign="top"><?php echo $products_name; ?></td> <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"> <?php if (tep_not_null($product_info['products_image'])) { ?> <table border="0" cellspacing="0" cellpadding="2" align="right"> <tr> <td align="center" class="smallText"> <!-- BOF SUHY --> <?php $PicCount = 0; echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail1" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo '</div></td>'; $PicCount = $PicCount + 1; if ($product_info['product_image_2'] != "") { echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail2" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['product_image_2']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['product_image_2']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['product_image_2'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['product_image_2']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo '</div><td>'; $PicCount = $PicCount + 1; } if ($product_info['product_image_3'] != "") { echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail3" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['product_image_3']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['product_image_3']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['product_image_3'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['product_image_3']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo "</div></td>"; $PicCount = $PicCount + 1; } if ($product_info['product_image_4'] != "") { echo '<td>'; echo '<div style="text-align:center;">'; echo '<a class="thumbnail4" href=" '. tep_href_link(DIR_WS_IMAGES . $product_info['product_image_4']) .' ">'.'<span><img src="' . tep_href_link(DIR_WS_IMAGES . $product_info['product_image_4']) . '" /><br>' . TEXT_IMAGE_MOUSOVER .'</span>' . tep_image(DIR_WS_IMAGES . $product_info['product_image_4'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '</a>'; echo '<br>'; ?> <a href="javascript:popImage('<?php echo tep_href_link(DIR_WS_IMAGES . $product_info['product_image_4']) ;?>','<?php echo TEXT_IMAGE_POPUP ?>')"><?php echo TEXT_CLICK_TO_ENLARGE ?></a> <?php echo "</div></td>"; $PicCount = $PicCount + 1; } ?> <!-- EOF SUHY --> <!-- this is a support for showing 4 images in a row as I needed for my page. If you need more images just continue the code or make your own table and use the appropriate links in table cells .. Just replace product_image_4 to 5 and 6 accordingly in all instances --> </td> </tr> </table> <?php } ?> <p><?php echo stripslashes($product_info['products_description']); ?></p> <?php $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { $products_options_array = array(); $products_options_query = tep_db_query("select 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 = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td> </tr> <?php } ?> </table> <?php } ?> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <tr> <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (tep_not_null($product_info['products_url'])) { ?> <tr> <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> <?php } else { ?> <tr> <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> <?php } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> </td> </tr> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  3. You must have a username and password from your host to access your mysql database. The address of your database, the username, and password are what you need to input. What is this database for, is it an E-commerce system or CMS? Most tools nowadays have an install script where you fill in the relevant fields with your hosts provided database details. For example, if using a system like the online shop OScommerce, the install script asks you for the database server (eg. mysql12.yourhost.com or IP of host) the database username (eg. name1) the database password and the database name (eg. myshop). All these will be provided by your host when you set up a database with them. I am by no means an expert on these things but I use Mysql for the E-commerce online shops I design. This is how I usually do it, although with your database you might have to edit things manually rather than with an install script. Regards, -Jedi
  4. Wow thanks it works! You have no idea how much heartache and trouble you've just saved me. I cannot believe that it actually works now, do you know what the problem was? My only issue now is to get this to work with the www.freecontactform.com script, as the other form is not too secure as I'm sure you know. Would I just add the (ini_set) function to this? Your help is greatly appreciated thanks again
  5. Hi again, you need to look at: Access denied for user 'root'@'localhost' (using password: YES) you need to use the database settings from your hosting company. 'root'@'localhost' is your local PC. regards, -jedi
  6. Hi there, it usually just shows you the text of the MYSQL database which you can copy, however at the bottom of PHPMYADMIN, there is a check(tick) box that says "export as file" just tick that, leave options as default and try it again. It should download to your pc from there... regards, -jedi.
  7. Hi everyone I really need someones help here, I will be eternally grateful if I can get his problem solved. Basically, I have several of my clients websites hosted on streamline.net. I have a contact form on my clients site at http://www.ctsafetybarriers.co.uk/contact.html. However, the contact form will not send anything to my inbox although it says "message sent successfully". I know the form works, as I have tried it on my site, uploaded the whole ctsafety site to a subdomain on my account (with streamline also) and it works!. I have used FormToEmail.php, and this worked on my other accounts also but not on the ctsafety site. Below, is their reply as well as the code I made from their suggestions. (remember, I also used FormToEmail.php so if anyone knows a mod to make this work with streamline I will be ever grateful) BTW. They now say they can do nothing, as their test script (below) sends an email to my inbox. Why does this work and out of six contact forms I have tried, 0 have worked!!!!! > Test Script (works): <?php$res = mail("[email protected]", "Test php mailer for ctsafetybarriers.co.uk", "Hi,this message proves that php email scripts are working on the domain ctsafetybarriers.co.uk,Kind regards,StreamlineNet ", "From: [email protected]", "[email protected]"); if($res == 1){echo "email sent successfully, check email to make sure it was recieved."; } ?> Their Reply: Thank you for your query To prevent spam being sent through our webservers, there are certain conditions that must be met before our SMTP servers will send the email. 1) Email must be sent to, or from, an email address hosted by Streamline.net. An email address hosted by Streamline.net is not the same as a domain name hosted by Streamline.net. If your domain's MX record points to another email provider, it will not count as being hosted by Streamline.net. 2) To stop misuse of your form by third parties the sendmail_from variable should be set to your Streamline.net hosted email address. While access to the php.ini file is restricted on our shared environment, you can set this variable using the ini_set() command, shown below. 3) A fifth parameter -f should be added to the sendmail function. This will set the name of the from email address. In its basic form, a simple sendmail script will look like this: ini_set("sendmail_from", " [email protected] "); mail($email_to, $email_subject, $email_message, $headers, '[email protected]'); ?> Provided that you set the sendmail variable, before attempting to send the email. Specify the from address as a fifth parameter in the sendmail function, and the email is either to, or from, a Streamline.net hosted email address you should have no problems. My Script (this, and formtoemail.php do not work but respond as successfully sent) <?php /*\ The below (ini_set) is what they told me to put in to make it work, it was not in the script originally \*/ ini_set("sendmail_from", "[email protected]" ,"[email protected]"); $email_to = "[email protected]"; $name =$_POST['name']; $email_from =$_POST['email']; $email_subject = "Feedback from website"; $comments = $_POST['comments']; $headers = "From: $email_from .\n"; "Reply-To: $email_from .\n"; $message= "Name: ". $name . "\nComments: " . $comments; $sent = mail($email_to, $email_subject, $message, $headers, '-f .$email_from'); if ($sent) { header( "Location: http://www.ctsafetybarriers.co.uk/success.html" ); } else { echo 'There has been an error sending your comments. Please try later.'; } ?> Any help would be fantastic thankyou, Ryan[/]
  8. Hi there, I have registered just to give you some information. I, and thousands of other people are having the same problem with the contact forms and streamline. I have called them, created support tickets and tried six unique contact form scripts, including two based from their suggestions. Everytime i have not received anything in my inbox, and they refuse to help. The latest message I got was "I'm sorry, but we do not support, or provide help with scripts". What is so frustrating is the script I used was the one you posted above. (I got the same E-mail reply). So, the script they wrote and suggested does not work either, Im at the end of my tether with them . All I can say for sure, is that it seems to be malfunctioning on websites hosted on their newly updated servers. My older websites contact forms all work fine, yet the exact same form refuses to work on newly added domains. I believe that they have a problem with PHP5 and the (MAIL) function on their servers but they do not want to do anything about it. For me, my website says "mail sent successfully" with: if ($sent) { header( "Location: http://www.ctsafetybarriers.co.uk/success.html" ); } else { echo 'There has been an error sending your comments. Please try later.'; } however nothing is being received. My script is: <?php ini_set("sendmail_from", " [email protected] "); $email_to = "[email protected],[email protected]"; $name =$_POST['name']; $email_from =$_POST['email']; $email_subject = "Feedback from website"; $comments = $_POST['comments']; $headers = "From: $email_from .\n"; "Reply-To: $email_from .\n"; $message= "Name: ". $name . "\nComments: " . $comments; $sent = mail($email_to, $email_subject, $message, $headers, '-f .$email_from'); if ($sent) { header( "Location: http://www.ctsafetybarriers.co.uk/success.html" ); } else { echo 'There has been an error sending your comments. Please try later.'; } ?> Not RECEIVING ANYTHING! I know this is not much help but I wanted you to know its nothing to do with you or your script. Regards, -Jedi
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.