Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ce7

Members
  • Posts

    644
  • Joined

  • Last visited

  • Days Won

    2

ce7 last won the day on August 16 2022

ce7 had the most liked content!

6 Followers

Profile Information

  • Real Name
    lyn

Recent Profile Visitors

20,398 profile views

ce7's Achievements

  1. Melhor

    Hi Ce7,

    I saw your addon, just what I was looking for but got instant problem.
    1.1 catalog/admin/customers.php that's ok
    1.2 catalog/admin/includes/classes/order.php this files does not excist in this map!

    I use Phoenix 1.0.7.10

    thanks for your support and time

  2. @auzStar hi, thank you for this great addon. It is working great! i also install theme switcher and with few clicks, you can change the theme easily. right now i am setting dark background and that make the search result hard to read, which file should I check to change the color setting for search result text color, and is there a way it can auto change depending on UI setting? also i like to type a hint in the search blank area to let users know please at least type min 3 letters, which files should I change? many thanks! Lynn
  3. @raiwahi Rainer, Thank you very much for reply. Yes I have resolve the problem, not sure why, I did not add two tax on same product, but i have seperated tax rate, each product can choose 10% or 7% or no tax, not able to choose 2 tax rate at the same time... The default of my installation seems just add 2 tax rate as 17%, but when I go to renew the 5 default products and change the tax rate, refresh, then it works as it should be 10% or 7% as I set up.... Thanks! Lyn
  4. @raiwa hi again, Quick update, after I post here, I quickly installed another specials addon to do the test, and found out that the tax rate did work, but it did have problem to show the right rate at first, so there are few default special products, need to get into categories, and refresh the tax rate, then it will show up the correct one, if no refresh, it will stay as 17% instead of 10% or 7% or tax free... Thanks you!
  5. the file with customers_group_price, customers_group_id is actually @ admin/includes/functions/general.php Find: $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by products_name"); while ($products = tep_db_fetch_array($products_query)) { if (!in_array($products['products_id'], $exclude)) { $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $currencies->format($products['products_price']) . ')</option>'; } } Replaced with: //BOF 0716 Separate Pricing Per Customer if (!in_array($products['products_id'], $exclude)) { $price_query=tep_db_query("select customers_group_price, customers_group_id from products_groups where products_id = " . $products['products_id']); $product_prices=array(); while($prices_array=tep_db_fetch_array($price_query)){ $product_prices[$prices_array['customers_group_id']]=$prices_array['customers_group_price']; } reset($all_groups); $price_string=""; $sde=0; while(list($sdek,$sdev)=each($all_groups)){ if (!in_array((int)$products['products_id'].":".(int)$sdek, $exclude)) { if($sde) $price_string.=", "; $price_string.=$sdev.": ".$currencies->format(isset($product_prices[$sdek]) ? $product_prices[$sdek]:$products['products_price']); $sde=1; } } $select_string .= '<option value="' . $products['products_id'] . '">' . $products['products_name'] . ' (' . $price_string . ')</option>\n'; } // EOF Separate Pricing Per Customer } // end while ($products = tep_db_fetch_array($products_query)) //EOF 0716 Separate Pricing Per Customer I tried to use unmodified specials.php but it is showing up the same error, and go back to check on the installation and found out the code is modified @ general.php, not sure how to fix it in order to get rid of this 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select customers_group_price, customers_group_id from products_groups where products_id =
  6. hi @Dan Cole @greasemonkey Thank you for reply. I downloaded from addons.oscommerce.com/info/0716 (20151005) BOOTSTRAP - SPPC 2.3.4 BS GOLD - v1.1b version. it said: Line 33 [41 in edited file] **AFTER** add the mentioned code. I am not programmer, know a bit only SQL so no idea how to fix this....just follow the installation instruction... I know it is not a good idea to mix the addons in different version, but few 2.2 version still working perfect with 234.1Edge (BS), so I gave this a try, not sure if the complete add one working or not, but with the admin, assign customer group or attribute group, it seems working, admin/specials.php is the only file so far have the error message.... Thanks! Lyn
  7. @greasemonkey @Dan Cole hi I have 234.1 Edge (BS) with SPPC addons. in admin/catagories/special i can view and edit the special lists, but when i try to insert the new specials, i got this error: Product: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select customers_group_price, customers_group_id from products_groups where products_id = and this is the code related in admin/special.php $price_query = tep_db_query("select customers_group_price from products_groups WHERE products_id = ".(int)$products_id . " AND customers_group_id = ".(int)$customers_group); and this is related SQL DROP TABLE IF EXISTS products_groups; CREATE TABLE `products_groups` ( `customers_group_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `customers_group_price` decimal(15,4) NOT NULL DEFAULT '0.0000', `products_id` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; the error mentioned the MySQL version error, but dont know what how to write the right version for the ENGINE=.... part, can someone please help? Thanks! Lyn
  8. hi, come back again for more question, found cid= with strange string, instead of product ID, so redo everything, and make sure it is all ok...new 234.1Edge (BS) now with the button working, however keep have error message (after enable SEO related modules) and also have this errors after add new catagories. Warning: imagesy() expects parameter 1 to be resource, boolean given in /home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 383 Warning: Division by zero in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 385 Warning: imagecreatetruecolor(): Invalid image dimensions in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 393 Warning: imagealphablending() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 394 Warning: imagesavealpha() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 395 Warning: imagefilledrectangle() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 397 Warning: imagecopyresampled() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 398 Warning: imagesx() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 400 Warning: imagesy() expects parameter 1 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 401 Warning: imagecopy() expects parameter 2 to be resource, boolean given in /home/home/catalog/includes/modules/kiss_image_thumbnailer/classes/Image.php on line 424 Not sure why this warning happened...can someone please help? Thanks! Lyn
  9. @raiwa hi Raiwa, Thank you for our reply again. I have qtpro_functions.php in admin/includes/functions, however it is still showing up, so what I did is to include('includes/functions/qtpro_functions.php'); however it works sometimes and sometimes then show redirect error.... SEO error is similar situation, I make sure there are all those seo functions in admin/includes/functions/general.php, but it still showing the error, and if i include again the genearl.php then it straight away show up redirect error, so i end up need to disable all SEO related modules. I think I just focus on QTPro now, deal with SEO later and will post in a proper post, sorry to mention it here as the situation is similar... Thank you! Lyn
  10. @raiwa hi I have QTPro BS on 234.1Ege, it was ok before, but after enable SEO and QTPro (not sure QT Pro Stock Table or Product Lisiting QTPro) now i getting this error: Fatal error: Call to undefined function qtpro_doctor_investigate_product() /categories.php on line 34 ---> $qtpro_sick_count = qtpro_sick_product_count(); Fatal error: Call to undefined function tep_get_products_seo_title() in /home/catalog/admin/categories.php on line 744 ---> <td class="main"><?php echo tep_image(tep_catalog_href_link('includes/languages/' . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], '', 'SSL'), $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('products_seo_title[' . $languages[$i]['id'] . ']', (empty($pInfo->products_id) ? '' : tep_get_products_seo_title($pInfo->products_id, $languages[$i]['id'])), 'style="width: 500px;"'); ?></td> Fatal error: Call to undefined function tep_get_products_seo_keywords() in /home/catalog/admin/categories.php on line 1004---> echo tep_draw_input_field('products_seo_keywords[' . $languages[$i]['id'] . ']', tep_get_products_seo_keywords($pInfo->products_id, $languages[$i]['id']), 'placeholder="' . PLACEHOLDER_COMMA_SEPARATION . '" style="width: 300px;"'); Fatal error: Call to undefined function tep_get_category_seo_title() in /home/catalog/admin/categories.php on line 1363---> $category_seo_title_string .= '<br />' . tep_image(tep_catalog_href_link('includes/languages/' . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], '', 'SSL'), $languages[$i]['name']) . '&nbsp;' . tep_draw_input_field('categories_seo_title[' . $languages[$i]['id'] . ']', tep_get_category_seo_title($cInfo->categories_id, $languages[$i]['id'])); can someone please advise how to fix this as now i can not modify add or modify product in the admin, thanks! Lyn
  11. @raiwa Thank you! Sorry did not read the instruction carefully, just trying to find the code....and about the button, finally fix it, use dreamweaver to past the code, not working, but use ultraedit, it is working....not sure why... thank you very much for the add on and all the issue helps! Lyn
  12. @raiwa Hi Raiwa, Thank you for the reply. Will try to check the button later on. I have one more question about the thumbnail. I have the thumbnail on product_info.php with the newest kiss_gallery, which is working great. However is there a way to have the thumbnail but no the watermark on the image? do i go to delete the ((KISSIT_MAIN_PRODUCT_WATERMARK_SIZE > 0) or need to do something with the configuration setting? Thanks! Lyn
  13. @raiwa Thanks for reply. And continue question, sorry lots of questions 😂 After install KissIT, I found the button of add to cart is changed to grey, and the button of review became just text with link. How can I change it back to original one? image on the top: before KissIT has green add to cart button and reviews button Image on the top: after KissIT, somehow the Add to Cart and Reviews is different... not sure if i did something wrong.... Thanks! Lyn
  14. @Tsimi Thank you! It works perfectly! I just wonder if later on i installed what your add horizontal categories menu that Raiwa (Rainer) mentioned, do i need to change this code or just leave it as it is? Once again, thank you!
  15. @raiwa Thank you.I will install the horizontal categories menu later.... this is really helpful information. Back to the kiss thumbnail for image, i had installed it, however it is now showing two images at the same time, and it change the position from left top cornor to right bottom cornor. do i need to delete the original cm_pi_gallery.php and keep only cm_pi_gallery_kissit.php? which part is the code to change the image location? Thanks! Lyn
×
×
  • Create New...