Jump to content

noppie

Members
  • Content count

    306
  • Joined

  • Last visited

Everything posted by noppie

  1. noppie

    ASN Forum for osCommerce

    I am in my shop and have added some topics I go to view them and I get this error Forum Forum 1054 - Unknown column '707_781_782' in 'where clause' SELECT * FROM asnforum_topic WHERE topic_id=707_781_782 [TEP STOP] and the topic id in the database is 192 193 194 I don't know where to looks for this error thank you in advance noppie
  2. noppie

    ### POINTS AND REWARDS MODULE V1.00 ###

    Is anyone using paypal express with this.. and do you know what I need to change or added. noppie
  3. noppie

    ### POINTS AND REWARDS MODULE V1.00 ###

    hello I just installed this contribution. and I get this error. I went over the install directions and can't find an answer.. can anyone help. I uploaded the lastest version Fatal error: Call to undefined function: calculate_price() in /home/hera/public_html/shop/includes/classes/shopping_cart.php on line 272 thank you noppie
  4. noppie

    Enable/Disable categories contribution

    I have this menu contribution and having problems installing the enable-disable. http://addons.oscommerce.com/info/4228 I am not a good coder but below is what I am think needs to be changed. $result = tep_db_query('select c.categories_id, cd.categories_name, c.parent_id from ' . TABLE_CATEGORIES . ' c, ' . TABLE_CATEGORIES_DESCRIPTION . ' cd where c.categories_id = cd.categories_id and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name'); and below has the changes that need to be made. I don't know where to put the "c.categories_status = '1'" in the above code thank you for your help noppie // #################### Added Enable / Disable Categories ############## // $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and c.categories_status = '1' order by sort_order, cd.categories_name"); // #################### End Added Enable / Disable Categories ############## so here is is includes/boxes/dm_categories.php <?php /* $Id: dm_categories.php,v 1.00 2006/05/07 01:13:58 nate_02631 Exp $ Ties the store category menu into the PHP Layers Menu library, allowing display of categories as DTHML drop-down or fly-out menus, collapsable tree-style menus or horizontal/vertical indented plain menus. osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2006 Nate Welch http://www.natewelch.com Released under the GNU General Public License */ // BEGIN Configuration Options // Set the value below corresponding to the type of menu you want to render // 0 = Horizontal Drop-down; 1 = Vertical Flyout; 2 = Tree Menu; // 3 = Plain Horizontal Menu; 4 = Plain Vertical Menu // Include the appropriate stylesheet in your store stylesheet, and if rendering // types '0' or '1', you must also echo (output) the "menu footer" variable // in your store footer as described in the readme (or submenus won't work) $menu_type = 3; // Set to false to display the menu output only. Set to true to display in // a regular box. The former is useful for better integrating the menu with your layout. $show_dmcats_as_box = true; // Set to 'true' to assign TITLE tags to each of the menu's items, 'false' to leave blank $menu_use_titles = true; // Name of the icon file to be used preceding menu items. Leave blank for no icons. // NOTE: Does not apply to plain style menus. Icon should be in the /images directory $menu_icon_file = ''; // Width and height of icons used in menus (does not apply to plain menus). $menu_icon_width = 16; $menu_icon_height = 16; // Set the graphic to be used for the forward arrow and down arrow images used in // drop-down and fly-out menus. Images must reside in your catalog's /images directory $menu_fwdarrowimg = 'forward-arrow.png'; $menu_downarrowimg = 'down-arrow.png'; // Indicates whether or not to render your entire category list or just the root categories // and the currently selected submenu tree. Rendering the full list is useful for dynamic menu // generation where you want the user to have instant access to all categories. The other option // is the default oSC behaviour, when the subcats aren't available until the parent is clicked, // more suitable for plain-style menus $show_full_tree = true; // For tree menus, set to true to have only nodes corresponding to the current category path // expanded. If set to false, the tree menu will retain expanded/collapse nodes the user has // selected (as well as expanding any for categories they've entered) $menu_tree_current_path = true; // Set the three numerical values below to adjust the offset of submenus in // horizontal drop-down and vertical fly-out menus. Values adjust the following (in order) // Top Offset: # of pixels from top border of previous menu the submenu appears // Right Offset: # of pixels from right border of previous menu the submenu appears // Left Offset: # of pixels from left border of previous menu the submenu appears // if the submenu pops to left (i.e. if window border is reached). Negative values are allowed. $menu_layer_offset = array (0,4,4); // Show icons on tree menus? If set to false, only expand/collapse icons and connecting lines are shown $GLOBALS['dm_tree_folder_icons'] = true; // This is the HTML that you would like to appear before/after your categories menu if *not* // displaying in a standard "box". This is useful for reconciling tables or clearing // floats, depending on your layout needs. For example if not including in a box in the // default osC template, you would need opening/closing <tr><td> tags... $before_nobox_html = ''; $after_nobox_html = ''; // END Configuration Options // Misc setting to make folder icon clickable to expand tree menu nodes $GLOBALS['dm_tree_titleclick'] = true; // Initialize HTML and info_box class if displaying inside a box if ($show_dmcats_as_box) { echo '<tr><td>'; $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES); new infoBoxHeading($info_box_contents, true, false); } // Generate the menu data output (uses configuration options above) $categories_string = tep_make_cat_dmlist(); // Include required libraries based on menu type require_once 'includes/functions/dynamenu/lib/PHPLIB.php'; require_once 'includes/functions/dynamenu/lib/layersmenu-common.inc.php'; if ($menu_type < 2) { // Setup for DHTML style menus ?> <script language="JavaScript" type="text/javascript"> <!-- <?php require_once 'includes/functions/dynamenu/libjs/layersmenu-browser_detection.js'; ?> // --> </script> <script language="JavaScript" type="text/javascript" src="includes/functions/dynamenu/libjs/layersmenu-library.js"></script> <script language="JavaScript" type="text/javascript" src="includes/functions/dynamenu/libjs/layersmenu.js"></script> <?php require_once 'includes/functions/dynamenu/lib/layersmenu.inc.php'; $mid = new LayersMenu($menu_layer_offset[0],$menu_layer_offset[1],$menu_layer_offset[2],1); } elseif ($menu_type > 2) { // Setup for plain style menus require_once 'includes/functions/dynamenu/lib/plainmenu.inc.php'; $mid = new PlainMenu(); } else { // Setup for tree style menus ?> <script language="JavaScript" type="text/javascript"> <!-- <?php require_once 'includes/functions/dynamenu/libjs/layersmenu-browser_detection.js'; ?> <?php if ($menu_tree_current_path) { echo "\n".'var menu_tree_current_path = true'; } else { echo "\n".'var menu_tree_current_path = false'; } ?> // --> </script> <script language="JavaScript" type="text/javascript" src="includes/functions/dynamenu/libjs/layerstreemenu-cookies.js"></script> <?php require_once 'includes/functions/dynamenu/lib/treemenu.inc.php'; $mid = new TreeMenu(); } // Set menu config variables $mid->setDirroot('./'); $mid->setLibjsdir('./includes/functions/dynamenu/libjs/'); if ($menu_type !=2) { $mid->setTpldir('./includes/functions/dynamenu/templates/'); } $mid->setImgdir('./images/'); $mid->setImgwww('images/'); $mid->setIcondir('./images/'); $mid->setIconwww('images/'); $mid->setIconsize($menu_icon_width, $menu_icon_height); // Generate menus $mid->setMenuStructureString($categories_string); $mid->parseStructureForMenu('catmenu'); switch ($menu_type) { case 0: // Horizontal drop-down $mid->setDownArrowImg($menu_downarrowimg); $mid->setForwardArrowImg($menu_fwdarrowimg); $mid->setHorizontalMenuTpl('layersmenu-horizontal_menu.ihtml'); $mid->setSubMenuTpl('layersmenu-horiz_sub_menu.ihtml'); $mid->newHorizontalMenu('catmenu'); $mid->printHeader(); $categories_menu = $mid->getMenu('catmenu'); $GLOBALS['dmfooter'] = $mid->getFooter(); break; case 1: // Vertical fly-out $mid->setDownArrowImg($menu_downarrowimg); $mid->setForwardArrowImg($menu_fwdarrowimg); $mid->setVerticalMenuTpl('layersmenu-vertical_menu.ihtml'); $mid->setSubMenuTpl('layersmenu-vert_sub_menu.ihtml'); $mid->newVerticalMenu('catmenu'); $mid->printHeader(); $categories_menu = $mid->getMenu('catmenu'); $GLOBALS['dmfooter'] = $mid->getFooter(); break; case 2: // Tree menu $categories_menu = $mid->newTreeMenu('catmenu'); break; case 3: // Horizontal plain menu $mid->setPlainMenuTpl('layersmenu-horizontal_plain_menu.ihtml'); $categories_menu = $mid->newHorizontalPlainMenu('catmenu'); break; case 4: // Vertical plain menu $mid->setPlainMenuTpl('layersmenu-plain_menu.ihtml'); $categories_menu = $mid->newPlainMenu('catmenu'); break; } // Output list inside a box if specified, otherwise just output unordered list if ($show_dmcats_as_box) { $info_box_contents = array(); $info_box_contents[] = array('text' => $categories_menu); new infoBox($info_box_contents); echo '</td></tr>'; } else { echo $before_nobox_html; echo $categories_menu; echo $after_nobox_html; } // Create the root category list function tep_make_cat_dmlist($rootcatid = 0, $maxlevel = 0){ global $cPath_array, $show_full_tree, $languages_id; global $idname_for_menu, $cPath_array, $show_full_tree, $languages_id; // Modify category query if not fetching all categories (limit to root cats and selected subcat tree) if (!$show_full_tree) { $parent_query = 'AND (c.parent_id = "0"'; if (isset($cPath_array)) { $cPath_array_temp = $cPath_array; foreach($cPath_array_temp AS $key => $value) { $parent_query .= ' OR c.parent_id = "'.$value.'"'; } unset($cPath_array_temp); } $parent_query .= ')'; } else { $parent_query = ''; } [font="Arial Black"][b]$result = tep_db_query('select c.categories_id, cd.categories_name, c.parent_id from ' . TABLE_CATEGORIES . ' c, ' . TABLE_CATEGORIES_DESCRIPTION . ' cd where c.categories_id = cd.categories_id and cd.language_id="' . (int)$languages_id .'" '.$parent_query.'order by sort_order, cd.categories_name'); [/b][/font] while ($row = tep_db_fetch_array($result)) { $table[$row['parent_id']][$row['categories_id']] = $row['categories_name']; } $output .= tep_make_cat_dmbranch($rootcatid, $table, 0, $maxlevel); return $output; } // Create the branches off the category list function tep_make_cat_dmbranch($parcat, $table, $level, $maxlevel) { global $cPath_array, $menu_use_titles, $menu_icon_file; $list = $table[$parcat]; // Build data for menu while(list($key,$val) = each($list)){ if (isset($cPath_array) && in_array($key, $cPath_array)) { $this_expanded = '1'; $this_selected = 'dmselected'; } else { $this_expanded = ''; $this_selected = ''; } if (!$level) { unset($GLOBALS['cPath_set']); $GLOBALS['cPath_set'][0] = $key; $cPath_new = 'cPath=' . $key; } else { $GLOBALS['cPath_set'][$level] = $key; $cPath_new = 'cPath=' . implode("_", array_slice($GLOBALS['cPath_set'], 0, ($level+1))); } if ($menu_use_titles) { $this_title = $val; } else { $this_title = ''; } if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($key); if ($products_in_category > 0) { $val .= ' (' . $products_in_category . ')'; } } // Output for file to be parsed by PHP Layers Menu // Each line (terminated by a newline "\n" is a pipe delimited string with the following fields: // [dots]|[text]|[link]|[title]|[icon]|[target]|[expanded] // dots - number of dots signifies the level of the link '.' root level items, '..' first submenu, etc.... // text - text for link; title - tooltip for link; icon - icon for link; target - "dmselected" CSS class if item is selected // expanded - signifies if the node is expanded or collapsed by default (applies only to tree style menus) $output .= str_repeat(".", $level+1).'|'.$val.'|'.tep_href_link(FILENAME_DEFAULT, $cPath_new).'|'.$this_title.'|'.$menu_icon_file.'|'.$this_selected.'|'.$this_expanded."\n"; if ((isset($table[$key])) AND (($maxlevel > $level + 1) OR ($maxlevel == '0'))) { $output .= tep_make_cat_dmbranch($key,$table,$level + 1,$maxlevel); } } // End while loop return $output; } ?> <?php /* $Id: categories.php,v 1.25 2003/07/09 01:13:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ function tep_show_category($counter) { global $tree, $categories_string, $cPath_array; for ($i=0; $i<$tree[$counter]['level']; $i++) { $categories_string .= " "; } $categories_string .= '<a href="'; if ($tree[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $tree[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">'; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '<b>'; } // display category name $categories_string .= $tree[$counter]['name']; if (isset($cPath_array) && in_array($counter, $cPath_array)) { $categories_string .= '</b>'; } if (tep_has_category_subcategories($counter)) { $categories_string .= '->'; } $categories_string .= '</a>'; if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($counter); if ($products_in_category > 0) { $categories_string .= ' (' . $products_in_category . ')'; } } $categories_string .= '<br>'; if ($tree[$counter]['next_id'] != false) { tep_show_category($tree[$counter]['next_id']); } } ?> <!-- categories //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_CATEGORIES); new infoBoxHeading($info_box_contents, false, false); $categories_string = ''; $tree = array(); // #################### Added Enable / Disable Categories ############## // $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent m _id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and c.categories_status = '1' order by sort_order, cd.categories_name"); // #################### End Added Enable / Disable Categories ############## while ($categories = tep_db_fetch_array($categories_query)) { $tree[$categories['categories_id']] = array('name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $categories['categories_id']; } $parent_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if (tep_not_null($cPath)) { $new_path = ''; reset($cPath_array); while (list($key, $value) = each($cPath_array)) { unset($parent_id); unset($first_id); // #################### Added Enable / Disable Categories ############## // $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' order by sort_order, cd.categories_name"); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$value . "' and c.categories_id = cd.categories_id and cd.language_id='" . (int)$languages_id ."' and c.categories_status = '1' order by sort_order, cd.categories_name"); // #################### End Added Enable / Disable Categories ############## if (tep_db_num_rows($categories_query)) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $tree[$row['categories_id']] = array('name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false); if (isset($parent_id)) { $tree[$parent_id]['next_id'] = $row['categories_id']; } $parent_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $tree[$last_id]['next_id'] = $tree[$value]['next_id']; $tree[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } tep_show_category($first_element); $info_box_contents = array(); $info_box_contents[] = array('text' => $categories_string); new infoBox($info_box_contents); ?> </td> </tr> <!-- categories_eof //-->
  5. noppie

    Prize Draw Competition help

    did you add the style sheet -- then it show show.. I have it working on my site. check my profile for site info noppie
  6. Hello I had added this to my store and I just over wrote the files.. and add info to database I had attributes already there.. and just want to add ones the customer can add input.. but the one I added for customer input does not show up on the customer side of the catalog.. the original attributes show up put the new ones don't any Idea thank you Noppie
  7. i really like this contributiom for here display products and categories every time i add the index page ai lose my display of products on my index page.. so anyone using this and still have prducts show on the index pages can you tell me how? thank you very much noppie
  8. We are building a cart for classes that parents sign up for there students..and in the product area we want to parents to be able to add their child's Name.. and I have no idea how to do that.. we thought the product page would be good in case the parents want to enroll more that one child. can anyone help me please. noppie
  9. Ok I have module working and can get into them but when I go to paypal in enable it I get this error. Forbidden You don't have permission to access /form/xxxxx/modules.php on this server. this is under administration side of the server under modules when I click on checks or money order it lets me enable it with no errors.. I can't figure this out anyone else having these problems.. oh and perssions are right. I uploaded a different Paypal module and the same thing happened. please I really need help Noppie
  10. noppie

    PayPal Express Checkout IPN Payment Module

    Hello all I am getting this error and I don't know how to fix it. Noppie please please help the application is there. Warning: main(includes/application_top.php) [function.main]: failed to open stream: Permission denied in /home/hera/public_html/shop/express_checkout.php on line 10 Warning: main(includes/application_top.php) [function.main]: failed to open stream: Permission denied in /home/hera/public_html/shop/express_checkout.php on line 10 Warning: main(includes/application_top.php) [function.main]: failed to open stream: Permission denied in /home/hera/public_html/shop/express_checkout.php on line 10 Fatal error: main() [function.require]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hera/public_html/shop/express_checkout.php on line 10
  11. noppie

    SPAW2 EDITOR

    Please disregard. :'( I figured it out. I had to much white space above the <php on top of the categories.php :blink: so if anyone else is having the same problems..check your white space at the beginning or end of the file. thank you all. noppie :thumbsup:
  12. noppie

    SPAW2 EDITOR

    I keep getting this error below and I can't figure it out below are the only directions to add spaw2 as html editor. anyone out their please help.. thank you noppie
  13. ok now i tried saving file as tab I use openoffice spread sheet. and I got this error again File uploaded. Temporary filename: /tmp/phpZWpWkN User filename: draw-easy.csv Size: 1041 No products_model field in record. This line was not imported: | Childbooks | by | step pictu | 7460 | 2943
  14. I am using a linux machine.. and having the same problem and unable to use a window machine.. help this is what i get File uploaded. Temporary filename: /tmp/phpsdSMxh User filename: upload-09-15-07.txt Size: 3529 No products_model field in record. This line was not imported: | 1082,"C | 553 | 24950 the red is the products_model field so there is something there, please help I am so close yet so far noppie
  15. Call to undefined function: tep_encrypt_password() in /home2/rick02/public_html/cloth/create_account.php on line 183 how do i fix this.. I ca't figure it out. thank you in advaced
  16. noppie

    Google XML Sitemap w/ Admin support

    Warning: fopen(/home/hera/public_html/shop//sitemapproducts.xml) [function.fopen]: failed to open stream: Permission denied in /home/hera/public_html/shop/sitemap.class.php on line 592 ERROR: Google Product Sitemap Generation FAILED! I went through both sitemap.class.php and sitemap.index.php and couldn't find any extra '/' before the word sitemap so where else to look .. and what other info can I provide to help you thank you noppie
  17. noppie

    affiliate_branding

    hello I have someone I am helping that want to use this.. and I am having problems with the merging files.. affiliate_application_top.php on the admin side. Thank you noppie
  18. I did what you told me and I still got the error. so I just removed the hacks will add one of the extra pictures Thank you for your time. noppie
  19. thank you so much.. I don't know how I did that.. Noppie I got 7a done
  20. Thank you for your help and here is the name of the images comic-book2.jpg comic-books.jpg COMICS3.jpg and below is the code for the product_info.php <?php /* $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $ 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); // BEGIN: Added for Make An Offer require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_MAKE_AN_OFFER); // END: Added for Make An Offer // bof added by jobonline2001@yahoo.com for auction product contribution require(DIR_WS_LANGUAGES . $language . '/' . 'auctions.php'); if (isset($_POST['placebid']) ) { $products_id = $_POST['products_id']; $bid_price = $_POST['bid_price']; $auction_id = $_POST['auction_id']; if ( tep_session_is_registered('customer_id') ) { $customers_id = (int)$customer_id; $sql_auction = 'select auctions_bids_id, bid_price from '.TABLE_AUCTIONS_BIDS ." where auctions_id='". $auction_id."' and customers_id='$customers_id'"; if (!tep_db_num_rows(tep_db_query($sql_auction)) ) { $sql_auction = 'insert into '.TABLE_AUCTIONS_BIDS." (auctions_bids_id, auctions_id, customers_id, bid_price, bid_status, bid_date_added ) values('', '$auction_id', '$customers_id', '$bid_price', '', now()) "; tep_db_query($sql_auction); } else { // auction existed $exist_auction = tep_db_fetch_array(tep_db_query($sql_auction)); if ( ($exist_auction['bid_status']!='won')&& ($exist_auction['bid_price']<$bid_price) ){ $sql_auction = 'update '.TABLE_AUCTIONS_BIDS." set auctions_id='$auction_id',bid_price= '$bid_price', bid_date_added= 'now()' where auctions_id='$auction_id' and customers_id='$customers_id'"; tep_db_query($sql_auction); } else { echo ' New price of bid must be more than your last bidding price!!'; } } // send email notify about higher bid than the other customer's bid who won $sql_customer = 'select customers_lastname, customers_firstname,customers_email_address from '. TABLE_CUSTOMERS." c,". TABLE_AUCTIONS_BIDS." ab where c.customers_id=ab.customers_id and ab.auctions_id= '$auction_id' and ab.bid_price<".(int)$bid_price." and ab.bid_status='won'"; $acustomer_query = tep_db_query($sql_customer); while ($acustomer = tep_db_fetch_array($acustomer_query)) { $acustomer_firstname = $acustomer['customer_firstname']; $acustomer_lastname = $acustomer['customers_lastname']; $acustomer_email = $acustomer['customers_email_address']; $acustomer_name = $customer_firstname .' '.$customer_lastname; $auction_url = tep_href_link(FILENAME_PRODUCT_INFO,'products_id='.$auction_id); $email_text = str_replace('[customer_firstname]',$acustomer_firstname,str_replace('[customer_lastname]',$acustomer_lastname,str_replace('[customer_email]',$acustomer_email,str_replace('[auction_name]',$auction_name,str_replace('[auction_url]',$auction_url,str_replace('[bid_price]',$bid_price,AUCTION_HIGHER_BID_NOTIFY_EMAIL)))))); tep_mail($acustomer_name, $acustomer_email, AUCTION_HIGHER_BID_NOTIFY_EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); } tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO,'products_id='.$products_id)); } else { // $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } } // eof added by jobonline2001@yahoo.com for auction product contribution $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"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } <!-- BOF AUCTIONS CONTRIB function rowOverEffect(object) { if (document.checkout_confirmation.elements[object].parentNode.parentNode.className != 'moduleRowSelected') { document.checkout_confirmation.elements[object].parentNode.parentNode.className = 'moduleRowOver'; } } function rowOutEffect(object) { if (document.checkout_confirmation.elements[object].checked) { document.checkout_confirmation.elements[object].parentNode.parentNode.className = 'moduleRowSelected'; } else { document.checkout_confirmation.elements[object].parentNode.parentNode.className = 'infoBoxContents'; } } function checkboxRowEffect(object) { document.checkout_confirmation.elements[object].checked = !document.checkout_confirmation.elements[object].checked; if(document.checkout_confirmation.elements[object].checked) { document.checkout_confirmation.elements[object].parentNode.parentNode.className = 'moduleRowSelected'; } else { document.checkout_confirmation.elements[object].parentNode.parentNode.className = 'moduleRowOver'; } } function check_agree(TheForm) { if (TheForm.agree.checked) { return true; } else { alert(unescape('<?php echo CONDITION_AGREEMENT_ERROR; ?>')); return false; } } var win = null; function NewWindow(mypage,myname,w,h,scroll){ LeftPosition = (screen.width) ? (screen.width-w)/2 : 0; TopPosition = (screen.height) ? (screen.height-h)/2 : 0; settings = 'height='+h+',width='+w+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',resizable' win = window.open(mypage,myname,settings) } // EOF AUCIONTS CONTRIB --> //--></script> </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_slide_images, p.products_id, pd.products_name, pd.products_description, p.products_model,p.products_make_an_offer, 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 . "'"); // bof added by jobonline2001@yahoo.com for auction product contribution $auction_price = tep_get_products_auction_price($product_info['products_id']); $auction_product = false; if (!$auction_price) { // eof added by jobonline2001@yahoo.com for auction product contribution 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'])); } // bof added by jobonline2001@yahoo.com for auction product contribution } else { $products_price = $currencies->display_price($auction_price, tep_get_tax_rate($product_info['products_tax_class_id'])); $auction_product = true; $sql_auction = 'select auctions_id from '.TABLE_AUCTIONS_PRODUCTS." where products_id='".$product_info['products_id']."'"; $auction_info = tep_db_fetch_array(tep_db_query($sql_auction)); $auction_id = $auction_info['auctions_id']; } // eof added by jobonline2001@yahoo.com for auction product contribution 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> <!-- bof added by jobonline2001@yahoo.com for auction product contribution --> <?php if ($auction_product) { ?> <tr><td class="stockWarning"><?php echo TEXT_AUCTION_PRODUCT_TITLE; ?></td></tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } // end if ?> <!-- eof added by jobonline2001@yahoo.com for auction product contribution --> <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"> //<!-- fancy product images slide show hack START --> <?php $slideFiles = explode(';',$product_info['products_slide_images']); $slideFilesCount = count($slideFiles); $sOut = ''; $cleaned = array(); for($sCount=0;$sCount<$slideFilesCount;$sCount++){ if(trim($slideFiles[$sCount] != '')){ $cleaned[] = $slideFiles[$sCount]; // cleaning if there is a name missing } } $cleanedCount = count($cleaned); $sOut .= 'var slideList = new Array('.$cleanedCount.');'."\n"; $sOut .= 'var slideListOriginal = new Array('.$cleanedCount.');'."\n"; flushOldCachedImages(); for($sCount=0;$sCount<$cleanedCount;$sCount++){ $fileToResize = DIR_FS_CATALOG . DIR_WS_IMAGES . $cleaned[$sCount]; $resizedImageResult = resizeImage($fileToResize,SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); $resizedImage = $resizedImageResult[0]; $resizedImageWidth = $resizedImageResult[1]; $resizedImageHeight = $resizedImageResult[2]; $sOut .= 'slideList['.$sCount.'] = "'.$resizedImage.'";'."\n"; $sOut .= 'slideListOriginal['.$sCount.'] = "'.DIR_WS_IMAGES . $cleaned[$sCount].'";'."\n"; } echo '<script>'.$sOut.'</script>'; $fileToResize = DIR_FS_CATALOG . DIR_WS_IMAGES . $product_info['products_image']; $resizedImageResult = resizeImage($fileToResize,SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); $resizedImage = $resizedImageResult[0]; $resizedImageWidth = $resizedImageResult[1]; $resizedImageHeight = $resizedImageResult[2]; ?> <?php echo '<a href="java script:popupWindow(\''. tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\')"><span id="slidePanel">' . tep_image($resizedImage, addslashes($product_info['products_name']), $resizedImageWidth, $resizedImageHeight, 'hspace="5" vspace="5"') . '</span></a><br />' ?> <script type="text/javascript"> <!-- var slideStation = 0; var headImage = "<?=$resizedImage?>"; var fadeSpeed = 1000; var slideImage = headImage; var slideImageOriginal = "<?=DIR_WS_IMAGES . $product_info['products_image']?>"; setInterval(runSlideShow,3000); function slideFader(){ if(slideStation == slideList.length){ slideStation = -1; slideImage = headImage; slideImageOriginal = "<?=DIR_WS_IMAGES . $product_info['products_image']?>"; }else{ slideImage = slideList[slideStation]; slideImageOriginal = slideListOriginal[slideStation]; } sPanel = document.getElementById("slidePanel"); sPanel.innerHTML = "<img src='"+slideImage+"' hspace='5' vspace='5'/>"; slideStation++; } function runSlideShow(){ setTimeout(slideFader,1000); } function getActiveSlideImage(){ return slideImageOriginal; } --> </script> <?=TEXT_CLICK_TO_ENLARGE;?> <!-- fancy product images slide show hack END --> </noscript> </td> </tr> </table> <?php } ?> <p><?php echo stripslashes($product_info['products_description']); ?></p> <div ALIGN="center"><table border="0" width="75%" cellspacing="0" cellpadding="2"> <?php if ((MAO_ACCEPT_OFFER_DIRECTLY == 'true') && ($product_info['products_make_an_offer'] == true)) { ?> <tr><td align="center" class="maooffer"><?php echo ENTRY_NEW_PRICE; ?><br> <input name='newpriceoffer' type='text' value='<?php echo tep_round($newpriceoffer,$currencies->currencies[$currency]['decimal_places']); ?>' MAXLENGTH='15' SIZE='10'><br><?php echo ' ' . $currency; ?></td></tr> <?php } if (tep_session_is_registered('mao_low_offer')) { echo '<tr><td class="maolowoffer">' . ENTRY_LOW_OFFER_CHECK_ERROR . '</td></tr>'; tep_session_unregister('mao_low_offer'); } ?> </table></div><br> <?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> <!-- //bof moved from bellow by jobonline201@yahoo.com for auction product contribution --> <?php if ($auction_product) { ?> </form> <?php } ?> <!-- eof moved from bellow by jobonline201@yahoo.com for auction product contribution --> <?php //bof added by jobonline2001@yahoo.com for auction product contribution //rewriten by MarcusDesign if ($auction_product) { include_once(DIR_WS_MODULES.'/auction_bids.php'); } else { ?> <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> <?php if ($product_info['products_make_an_offer'] == true) { ?> <td class="main" align="right"> <?php if (MAO_ACCEPT_OFFER_DIRECTLY == 'false') { ?> <?php echo '<a href="' . tep_href_link(FILENAME_MAKE_AN_OFFER, tep_get_all_get_params()) . '">' . tep_image_button('button_make_an_offer.gif', IMAGE_BUTTON_MAKE_AN_OFFER) . '</a>'; ?> <?php } ?> </td> <?php } ?> <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> <?php } //eof added by jobonline2001@yahoo.com for auction product contribution ?> <?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'); ?> <!-- bof changed by jobonline2001@yahoo.com for auction product contribution --> <?php if ($auction_product) { echo tep_draw_hidden_field('products_id', $product_info['products_id']); } else { echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); } ?> <!-- eof changed by jobonline2001@yahoo.com for auction product contribution --> </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 //--> </table> <!-- //bof moved to above by jobonline201@yahoo.com for auction product contribution --> <?php if (!$auction_product) { ?> </form> <?php } ?> <!-- //eof moved to above by jobonline201@yahoo.com for auction product contribution --> </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'); ?>
  21. yes I did.. from beginning to end.. and I just went over it to no avail. any ideas.. before I completely remove the slide show.. it would be cool but I don't know enough about the actual code to know what is going on.. does anyone out there know.. thank you in advance noppie
  22. noppie

    [Contribution] Auction Module

    did you add the database file already.. usually this is because the database files haven't been loaded.. check your database to see if they are there. what where you doing to get this error.. where you in the admin or catalog.. I will try to help you the best I can.. I am not expert.. but I have been through a lot of those errors. noppie
  23. I got it working.. I use the kdiff program and reloaded and it worked. thank you noppie
  24. I installed the contribution.. and it doesn't send out the emails. I don't know what I did wrong.. can anyone help. thank you noppie
  25. Hello, I uploaded this contribution.. and now the first picture I upload won't upload. when I add it directly to the image folder it will show up. please what can I do to fix this what info do you need to help me. I couldn't anything on this forum to help me. Noppie
×