Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

paq1200

Archived
  • Posts

    97
  • Joined

  • Last visited

Everything posted by paq1200

  1. Thanks for all your help JanZ. The only products that are showing up twice is the ones that are in more than one category. I did what you said and reverted to backup and products are only shown once. I inserted the code in products_new as instructed and products are shown twice. reverted back and only inserted the $products_new_query_raw line and products are shown twice. I am thinking the problem is in this line: $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by p.products_date_added DESC, pd.products_name"; can someone tell me how to go about breaking this line down to find out what is causing the products to show up twice. Mike
  2. Sorry about the way the question was asked. What I was refering to when I said "this has been asked several times with no answer" was that in the contributions forum that question was asked several times and no one answered it in the forum. That is why I put it as a new topic. I am still learning php and I do not know what I should do here. you can see what I am talking about HERE. signon:[email protected] password:trial when you go to All Products then change the sort by and you will be logged off. and the session will not be in the address bar. Thanks Mike
  3. This has been asked several times with no answer. how do I keep the session from one page to the next? I have added a contribution which allows you to sort the products by dropdown but when you go to the next page the session is dropped. this is the code on the index.php: echo '<td align="center" class="dynamicMain">' . tep_draw_form('sort', FILENAME_DEFAULT, 'get') . '<b>Sort by:</b> '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); } else { echo tep_draw_hidden_field('cPath', $cPath); } $sort_list = array('6d' => 'Best Sellers', '2a' => 'Products Name A to Z', '2d' => 'Products Name Z to A', '3a' => 'Price Low to High', '3d' => 'Price High to Low'); foreach($sort_list as $id=>$text) { $sort_range[] = array('id' => $id, 'text' => $text); } echo tep_draw_pull_down_menu('sort', $sort_range, (isset($HTTP_GET_VARS['sort']) ? $HTTP_GET_VARS['sort'] : ''), 'onchange="this.form.submit()"'); echo tep_draw_hidden_field('filter_id', (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : '')); echo '</form></td>' . "\n"; // End Additional Products Sort Any help is appreciated Mike
  4. Did anyone get this problem fixed. I have the same problem. Mike
  5. When I installed the sppc hide contribution now the new products are showing up twice. I am not sure where to start looking to fix this. Thanks Mike
  6. I thought I had seen this question before but I can not find it after several searches. How do I make it so when a customer creates an account they are automaticly set up in a different customer group. Thanks
  7. I am having the same problem. Can you tell me if you got it fixed and if so can you tell me how you did it? Mike
  8. I am getting this on the new products page Text_Price_Instead Text_Price_Savings Text_Price_Now I did not see where to add this anywhere Can someone help Mike
  9. I have just added SPPC to my site and now I am getting this error during checkout and I am not sure how to fix it: PHP Fatal error: Call to undefined method: shoppingcart->count_contents_virtual() in /usr/home/mickna/www/htdocs/checkout_payment.php on line 75 Here is what is on line 75: $total_count = $cart->count_contents_virtual(); // CCGV I have looked at checkout_payment.php but I am not sure what I should be looking for. When I reverted back to site without sppc, everything works fine. Can someone tell me where I should be looking? Thanks
  10. can someone tell me how to change the font color on the margin_report.php. I want the header font to be white. Thanks
  11. everything works great except i had the ot_modules setup to show the discounts with a minus sign and the font in red. since the install the font is black again and there is no minus sign. It looks right in the checkout process but in the order history info and in admin/edit_orders it is not red anymore. can you point me in the direction on where to look. Thanks Mike
  12. I found the problem had to add: function checkout_initialization_method() { $initialize_array = array(); if (is_array($this->modules)) { reset($this->modules); while (list(, $value) = each($this->modules)) { $class = substr($value, 0, strrpos($value, '.')); if ($GLOBALS[$class]->enabled && method_exists($GLOBALS[$class], 'checkout_initialization_method')) { $initialize_array[] = $GLOBALS[$class]->checkout_initialization_method(); } } } return $initialize_array; } to catalog/includes/classes/payment all is working now.....at least on the coupon side
  13. I just installed the latest version of ccgv(trad) and now I get this error: Fatal error: Call to undefined function: checkout_initialization_method() in c:\apache\htdocs\shopping_cart.php on line 210 I noticed earlier that someone else was getting this error but no solution was given on how to correct it. any help is apprecitated Mike
  14. I have installed the easy discount and easy coupon contributions but I am getting the error: Fatal error: Call to undefined function: clear() in c:\apache\htdocs\includes\modules\easy_coupons_code.php on line 72 Not sure where to look. Can anyone help me Thanks Mike
  15. I have been through the install instructions for several different versions and i cant find for the life of me what is going on. Will the function be in admin/includes/functions? or admin/coupons? Thanks
  16. when i try to add a coupon i get this in the admin --> Fatal error: Call to undefined function: ctype_graph() in c:\apache\htdocs\admin\coupons.php on line 37 can someone tell me what this means. I can add the coupon going through phpmyadmin but not through the admin. the only other problem i am having is that the total is not right. where might i look for the total not being right. Thanks
  17. I have the sppc installed and i have the categories dropdown installed is there a way to get the two to work together? below is the inludes/boxes/categories: <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2001 osCommerce Released under the GNU General Public License */ ?> <!-- categories //--> <tr> <td> <?php function tep_get_paths($categories_array = '', $parent_id = '0', $indent = '', $path='') { global $languages_id; if (!is_array($categories_array)) $categories_array = array(); $categories_query = tep_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where parent_id = '" . (int)$parent_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { if ($parent_id=='0'){ $categories_array[] = array('id' => $categories['categories_id'], 'text' => $indent . $categories['categories_name']); } else{ $categories_array[] = array('id' => $path . $parent_id . '_' .$categories['categories_id'], 'text' => $indent . $categories['categories_name']); } if ($categories['categories_id'] != $parent_id) { $this_path=$path; if ($parent_id != '0') $this_path = $path . $parent_id . '_'; $categories_array = tep_get_paths($categories_array, $categories['categories_id'], $indent . ' ', $this_path); } } return $categories_array; } $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => BOX_HEADING_CATEGORIES ); new infoBoxHeading($info_box_contents, true, false); $info_box_contents = array(); $info_box_contents[] = array('form' => '<form action="' . tep_href_link(FILENAME_DEFAULT) . '" method="get">' . tep_hide_session_id(), 'align' => 'left', 'text' => tep_draw_pull_down_menu('cPath', tep_get_paths(array(array('id' => '', 'text' => PULL_DOWN_DEFAULT))), $cPath, 'onchange="this.form.submit();"') ); new infoBox($info_box_contents); ?> </td> </tr> <!-- categories_eof //--> Any help is appreciated Mike
  18. Thanks for all the help JanZ. I figured it out. I went back and was checking the database and I noticed that the default value for products_hide_from_groups was not set. I set it to @ and now everything works like it should. I guess I should have checked it earlier. I am new to php and databases and I would have never thought that would keep it from working. Sorry I wasted your time Mike :blush:
  19. Thanks for the suggestion. I did what you said and I got the following error: 1054 - Unknown column 'products_hide_from_groups_nonsense' in 'field list' update products set products_quantity = '90', products_model = 'trial', products_price = '12.0000', products_date_available = null, products_weight = '0.00', products_status = '1', products_tax_class_id = '1', products_hide_from_groups_nonsense = '@,0', manufacturers_id = '', products_last_modified = now() where products_id = '2613' [TEP STOP] Is that what should have happened? Thanks Mike
  20. when I did what you said in first code I got this: Hide from these groups is now: @,0 Then I compared the code as you said in second suggestion and got this: // BOF Separate Price Per Customer, hide for these groups modification 'products_hide_from_groups' => $hide_from_these_groups, // EOF Separate Price Per Customer, hide for these groups modification Then I tried to find the code in the third suggestion and I found this: case 'update_product': if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) { $action = 'new_product'; } else { if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); $products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']); // BOF Separate Pricing Per Customer, hide products and categories from groups $hide_from_these_groups = '@,'; if ( $HTTP_POST_VARS['hide'] ) { // if any of the checkboxes are checked foreach($HTTP_POST_VARS['hide'] as $val) { $hide_from_these_groups .= tep_db_prepare_input($val).','; } // end foreach $hide_from_these_groups = substr($hide_from_these_groups,0,strlen($hide_from_these_groups)-1); // remove last comma } // EOF Separate Pricing Per Customer, hide products and categories from groups Not sure if third suggestion is what you were talking about but it is the only one I could find that had to do with products and not categories Thanks Mike
  21. I can not get the admin/categories to block a single product. I can get it to block categories. when you check the retail box in admin/categories then preview then update is says: Hidden from groups: none I am not sure where to check to get this to work. Can someone help please Thanks Mike
  22. My Mistake I had to go in and delete all the products_group 4 by: DELETE FROM `products_groups` WHERE `customers_group_id` = 4; then ran the code again and all is fine now. Thanks for all your help. Your php script runs great. Mike
  23. at the bottom of the insert_group_prices.php page I have the following: (4, '10.4025', 2784), (4, '10.4025', 2785), (4, '10.4025', 2786), (4, '13.775', 2787), (4, '12.635', 2788); when I looked at the script it looks like it should say "Done" . No changes are being made to the products_groups table in the database. I think it is not finishing the script. I checked the error logs and no errors are shown in the log file. Thanks Mike
  24. when I try to run this I get a error 1064 - You have an error in your SQL syntax near '; ' at line 1247 Thanks
×
×
  • Create New...