Jump to content

custom connection

Members
  • Content count

    64
  • Joined

  • Last visited

  1. custom connection

    alignment issues with left column

    Thanks!! I knew it was prob somthing simple that I had over looked.......I had been tring to fix it for weeks. Thanks for the help!!!
  2. custom connection

    alignment issues with left column

    I just installed a new template and now on certain pages the catagories box is shifted down. I really dont know why I have tried a few things but nothing seems to work. THE HOME PAGE IS FINE but THIS PAGE IS PAGE IS NOT and THIS PAGE IS REALLY BAD If anyone could look at it for me that would be great!!!!!
  3. custom connection

    Column Banner Advertisement

    I am having the same problems It always moves to the top of the right column no matter where I place it in the includes\column_right.php file and I am getting a white box with the red x too... it cant find the sample pics Anybody know what is up with this problem we seem to have????? It seams as though it wont work with php5. Is this true?
  4. custom connection

    help with printable price list

    Ok here is my new version of the code making it printable but still the same prob....It lists every product in every language and currrency. I only want english and us dollars to appear. Does any one know how to change the code so only english and usd is included in the price list??? <?php // Begin configuration define('TITLE_PRICE_LIST', 'Price List'); // This is the title for your price page define('DATE_PRICE_LIST', '- M jS, Y'); // date format (empty - none, M - month, jS - day of month, Y - year; see www.php.net/date) define('PRINT_VIEW', 'Printable Version'); // text for link to printable view define('FULL_VIEW', 'Normal Version'); // text for link to normal view define('TAX_INCREASE', 0); // 0 - No increase, 1 - Add 1%, 5 - Add 5%, Any number - add number% define('NO_PRICE', 'Call'); // show when product has no price or zero price (blank - , or e.g. Call for Price) define('SHOW_QUANTITY',false); // true - show, false - hide quantity define('QUANTITY_TEXT', 'Qty.'); // This is the heading for quantity column define('SHOW_MARKED_OUT_STOCK',true); // show marked out of stock (true - show, false - hide) define('SHOW_MODEL',false); // true - show model, false - hide model define('WIDTH_PRICE_LIST', '750'); // width of price list in pixels (0 - tight, 1000 - loose) define('INDENT_PRICE_LIST', '30'); // width of identation subcategories in pixels (0 - none, 30 - wide) define('INDENT_PRICE_LIST_COLOR', 'b6b7cb'); // colour of the indentation // End configuration require('includes/application_top.php'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); $breadcrumb->add(TITLE_PRICE_LIST, tep_href_link("price_list.php", '', 'SSL')); ?> <!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"> <style type="text/css"> <!-- td.priceListWidth{ width:<?php echo WIDTH_PRICE_LIST; ?>px; } td.priceListIndent { background-color:<?php echo INDENT_PRICE_LIST_COLOR; ?>; width:<?php echo INDENT_PRICE_LIST; ?>; } --></style> </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> <?php // print function and edit remove by willross if ($print=="yes"){?> <!-- column_left disabled for print //--> <?php } else {?> <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> <?php }?> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="pageHeading"><?php echo TITLE_PRICE_LIST ?> <?php echo date(DATE_PRICE_LIST); ?><sup> <?php // print function and edit remove by willross if ($print=="yes"){?> <font style="font-size:10px"><a href="price_list.php">[<?php echo FULL_VIEW ?>]</a></font> <?php } else {?> <font style="font-size:10px"><a href="price_list.php?print=yes">[<?php echo PRINT_VIEW ?>]</a></font> <?php }?></sup> </td> </tr> <tr> <td> <? // groups have products? function check_products($id_group){ $products_price_query = tep_db_query("select products_to_categories.products_id FROM products_to_categories where products_to_categories.categories_id = ".$id_group." LIMIT 0,1"); if($products_price = tep_db_fetch_array($products_price_query)){ return true; } return false; } // list products determined group function get_products($id_group){ global $currencies; $query = ""; if(!SHOW_MARKED_OUT_STOCK){ $query = " and products.products_status = 1"; } $products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_quantity <> 0".$query." and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group." ORDER BY products_description.products_name"); $x=0; while ($products_price = tep_db_fetch_array($products_price_query)){ $cell = tep_get_products_special_price($products_price['products_id']); if($cell == 0) $cell = $products_price['products_price']; if($x==1) { $col = "#F8F8F9"; $x = 0; }else{ $col = "#FFFFFF"; $x++; } $quantity = ""; $model = ""; if(SHOW_QUANTITY) $quantity = "<td align=\"right\" class=\"productListing-data\"> (".$products_price['products_quantity'].")</td>"; if(SHOW_MODEL) $model = "<td align=\"LEFT\" class=\"productListing-data\">".$products_price['products_model']."</td>"; print "<tr bgcolor=\"".$col."\"><td class=\"productListing-data\"><table align=\"LEFT\" cellpadding=\"1\" cellspacing=\"0\" ><tr><td class=\"priceListIndent\" ></td><td class=\"productListing-data\" > </td></tr></table></td>".$model."<td class=\"productListing-data\" ><a href=" . tep_href_link( FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "> ".$products_price['products_name']."</td><td align=\"right\" class=\"productListing-data\"> " . (($products_price['products_price'] > 0) ? $currencies->display_price($cell,TAX_INCREASE) : NO_PRICE ) ."</td>".$quantity."</tr>"; } } // get all groups function get_group($id_parent,$position){ $qty_text = ""; if(SHOW_QUANTITY) { $qty_text = "".QUANTITY_TEXT.""; }else{ $qty_text = " "; } $groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent." ORDER BY categories_description.categories_name"); while ($groups_price = tep_db_fetch_array($groups_price_query)){ $str = ""; for($i = 0; $i < $position; $i++){ $str = $str . "<table align=\"LEFT\" cellpadding=\"0\" cellspacing=\"0\" ><tr><td class=\"priceListIndent\" ></td><td class=\"productListing-heading\" > </td></tr></table>"; } $class = "productListing-heading"; if($position == 0) { $class = "headerNavigation"; print "<tr><td colspan=\"5\" class=\"priceListWidth\"><table align=\"right\" cellpadding=\"0\" cellspacing=\"0\" ><tr><td class=\"productListing-data\">".$qty_text."</td></tr></table></td></tr>"; // dónnr? nndîer } if(check_products($groups_price['categories_id']) || $position == 0){ print "<tr><td colspan=\"5\" class=\"".$class."\"><strong><font color=\"#FFFFFF\">".$str.$groups_price['categories_name']."</font></strong></td></tr>"; get_products($groups_price['categories_id']); } get_group($groups_price['categories_id'],$position+1); // nëläótur? adóddr } } ?> <table width="100%" border="0" cellspacing="1" cellpadding="0"> <? get_group(0,0); ?> <tr> <?php // print function and edit remove by willross if ($print=="yes"){?> <!-- column_right disabled for print //--> <?php } else {?> <td colspan="5"><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> </table> </td> </tr> </table></td> <!-- body_text //--> <!-- 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 //--> <?php }?> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  5. custom connection

    help with printable price list

    does anyone know how to modify this code? Thanks in advance!!!!
  6. custom connection

    help with printable price list

    Thanks for responding but I still am unsure on how to change it. Sorry. I am sure I dont need to say this (you have prob figured it out) but I am not a pro with php
  7. custom connection

    help with printable price list

    So are all the changes in the sql or is there something in this file I need to change too (above in the orig. post)
  8. custom connection

    help with printable price list

    I have added the following file to create a printable price list. The problem is each product displays 3 prices in each language making the price list really long. I would like to know how to make this list display only english and only usd <?php define('TITLE_PRICE', 'Price List'); //define('TITLE_PRICE', 'Price List'); require('includes/application_top.php'); // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); $breadcrumb->add(TITLE_PRICE, tep_href_link("price.php", '', 'SSL')); ?> <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"> </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 valign="top"> <table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="pageHeading"><? echo TITLE_PRICE ?></td> </tr> <tr> <td> <? // åñòü ó ãðóïïû ïðîäóêòû? // groups have products? function check_products($id_group){ $products_price_query = tep_db_query("select products_to_categories.products_id FROM products_to_categories where products_to_categories.categories_id = ".$id_group." LIMIT 0,1"); if($products_price = tep_db_fetch_array($products_price_query)){ return true; } return false; } // âûâîäèì ñïèñîê ïðîäóêòîâ îïðåäåëåííîé ãðóïïû $id_group // list products determined group function get_products($id_group){ $currencies = new currencies(); $products_price_query = tep_db_query("select products_description.products_name, products.products_price, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group); $x=0; while ($products_price = tep_db_fetch_array($products_price_query)){ $cell = tep_get_products_special_price($products_price['products_id']); if($cell == 0) $cell = $products_price['products_price']; if($x==1) { $col = "#F8F8F9"; $x = 0; }else{ $col = "#FFFFFF"; $x++; } print "<tr bgcolor=\"".$col."\"><td class=\"productListing-data\"> <a href=\"" . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $products_price['products_id']) . "\"<a>".$products_price['products_name']."</td><td align=\"right\" class=\"productListing-data\">".$currencies->display_price($cell,1)."</td></tr>"; } } // ðåêóðñèâíàÿ ôóíêöèÿ, ïîëó÷àåò ãðóïïû ïî ïîðÿäêó // get all groups function get_group($id_parent,$position){ $groups_price_query = tep_db_query("select categories.categories_id, categories_description.categories_name from categories, categories_description where categories.categories_id = categories_description.categories_id and categories.parent_id = ".$id_parent); while ($groups_price = tep_db_fetch_array($groups_price_query)){ $str = ""; for($i = 0; $i < $position; $i++){ $str = $str . " "; } $class = "productListing-heading"; if($position == 0) { $class = "headerNavigation"; print "<tr><td colspan=\"2\" width=\"1000\" class=\"productListing-data\"> </td></tr>"; // ïóñòàÿ ñòðîêà } if(check_products($groups_price['categories_id']) || $position == 0){ print "<tr><td colspan=\"2\" width=\"1000\" class=\"".$class."\"><strong><font color=\"#FFFFFF\">".$str.$groups_price['categories_name']."</font></strong></td></tr>"; get_products($groups_price['categories_id']); } get_group($groups_price['categories_id'],$position+1); // ñëåäóþùàÿ ãðóïïà } } ?> <table width="100%" border="0" cellspacing="1" cellpadding="0"> <? get_group(0,0); ?> </table> </td> </tr> </table> </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 //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  9. custom connection

    attribute calculator

    Can anyone help me along with this install??? Please
  10. custom connection

    attribute calculator

    I think that http://addons.oscommerce.com/info/1385 will work for me just fine and I have read the install instructions but I still cant get it to work. I guess I dont have the "creative javascripting" mentioned in the instructions lol Just incase you couldnt tell, I am not a pro at this hahaha ??????????????????????????
  11. custom connection

    attribute calculator

    I am not exactly sure on how to do this.
  12. custom connection

    attribute calculator

    Thanks that is exactly what I was looking for. I am not sure of what files to change though?????????
  13. custom connection

    attribute calculator

    I have several products that all work together as one "kit" I have put some of these "kits" together but some customers want to change the individual prouducts that make up the "kit" I was wanting to make a product named "Custom Kit" with the price set at $0.00 and add attributes for each individual part There would be several drop down lists such as "compressor" "tank" "valve" etc (all the individual parts that make the kit) with the price increase for each attribute pre set but the problem is you have to check out before you can see what the subtotal will be. I was wondering if anyone knew how to add a calculator button to the end of the drop down lists that would give the customer a subtotal before they checkout? It might even be good to have a reset button so if the price doesnt satisfy the customer they could click reset and the price would go back to $0.00 and they could start over. The main thing would be the calculator button, the reset option would just be an added bonus. Does anyone know how to do this?
  14. custom connection

    cvv2 error

    I am lost right now can someone help please, my site is offline untill i fix it
  15. custom connection

    cvv2 error

    yeah, in the order table I added this line: cc_cvv2 VARCHAR(4),
×