Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

Everything posted by Portman

  1. Hi, I'm trying to modify the admin/specials.php page so that i can update multiple different prices for different groups (think SPPC or Wholesale Lite) I am playing around with the update and insert section of the file... tep_db_query("insert into " . TABLE_SPECIALS . " (products_id, specials_new_products_price, specials_date_added, expires_date, status) values ('" . (int)$products_id . "', '" . tep_db_input($specials_price) . "', now(), " . (tep_not_null($expires_date) ? "'" . tep_db_input($expires_date) . "'" : 'null') . ", '1')"); tep_db_query("update " . TABLE_SPECIALS . " set specials_new_products_price = '" . tep_db_input($specials_price) . "', specials_last_modified = now(), expires_date = " . (tep_not_null($expires_date) ? "'" . tep_db_input($expires_date) . "'" : 'null') . " where specials_id = '" . (int)$specials_id . "'"); but I need to make a loop so that I can insert the multiple different prices.... In an attempt to get across what I want to do here is what my thought process is in a broken code kind of way... tep_db_query("insert into " . TABLE_SPECIALS . " (products_id, specials_new_products_price, ... for ($i=1; $i<=xxx; $i++) { insert_new_special_price_ . $i; } ... specials_date_added, expires_date, status) values ('" . (int)$products_id . "', '" . tep_db_input($specials_price) . "', now(), " . (tep_not_null($expires_date) ? "'" . tep_db_input($expires_date) . "'" : 'null') . ", '1')"); I have been trying different things and been looking around for solutions, but for the life of me I cant get it to work. Can anyone give me some help
  2. Ok, so I'm playing around with hiding particular products from particular customers... I have made a variable $hide_product where the value 1 means the product is hidden and 0 means it is visible... I am trying to modify bm_specials.php and bm_whats_new.php so that if $hide_product = 1 that product does not show up in the box and another is selected... Im assuming it is these lines of code I need to modify, but for the life of me I can't figure it out bm_specials.php if ($random_product = tep_random_select("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) { bm_whats_new.php if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) { any help would be appreciated
  3. thanks @multimixer I was trying to plug the variable in there rather than the record from the database...
  4. Portman

    call to new function in addon

    thanks @raiwa... that was what I needed to know! Yes I am modifying one of your addons - or at least trying to - at this stage trying to create the ability to hide products from particular wholesale groups
  5. Hi I am using BS Frozen I have been doing some modifications to an add-on and I have created a new <function> to the code to make the add-on operate in the way I need it to... This has worked fine within the files of the add-on.... Now I want to call that function (located in catalog/includes/module/store/st_addon.php) in catalog/product_info.php... Can I do that? and if so how?
  6. Hi - Quick question (hopefully) I am using BS Frozen. I am looking for the section of code that controls the appearance of the special price when it is displayed in product_info.php... I need to hide the struck through original price if a customer is not logged in - I have done it in the specials box and the specials in product_listing.php but cant find where the full listing instance is kept. Any help would be appreciated.
  7. Ahhhhh, Thanks @Tsimi I didn't think of looking there!
  8. Hi, I Just installed a fresh version of bootstrap 2341 frozen to do some playing around with however, when I go to the admin page all the left hand side navigation boxes are missing.... I'm assuming it has something to do with the config file but I think that is all ok... Ill include it here... any ideas on what could be wrong? <?php define('HTTP_SERVER', 'https://creativeabundance.com.au'); define('HTTPS_SERVER', 'https://creativeabundance.com.au'); define('ENABLE_SSL', true); define('HTTP_COOKIE_DOMAIN', 'creativeabundance.com.au'); define('HTTPS_COOKIE_DOMAIN', 'creativeabundance.com.au'); define('HTTP_COOKIE_PATH', '/sales/admin/'); define('HTTPS_COOKIE_PATH', '/sales/admin/'); define('HTTP_CATALOG_SERVER', 'https://creativeabundance.com.au'); define('HTTPS_CATALOG_SERVER', 'https://creativeabundance.com.au'); define('ENABLE_SSL_CATALOG', 'true'); define('DIR_FS_DOCUMENT_ROOT', '/home/creativ3/public_html/sales/'); define('DIR_WS_ADMIN', '/sales/admin/'); define('DIR_WS_HTTPS_ADMIN', '/sales/admin/'); define('DIR_FS_ADMIN', '/home/creativ3/public_html/sales/admin/'); define('DIR_WS_CATALOG', '/sales/'); define('DIR_WS_HTTPS_CATALOG', '/sales/'); define('DIR_FS_CATALOG', '/home/creativ3/public_html/sales/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', 'xxxxx'); define('DB_SERVER_PASSWORD', 'xxxxxx'); define('DB_DATABASE', 'xxxxxx'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); define('CFG_TIME_ZONE', 'Australia/Melbourne'); ?>
  9. thanks @MrPhil, I have reinstalled using your link.
  10. Hi @Jack_mcs Thanks for that, that did the job!!!! Hi @MrPhil I downloaded it from GitHub using this link in the forum https://forums.oscommerce.com/topic/412924-frozen/ Is there something to suggest I don't have the correct version?
  11. Hi, I cant seem to find a working solution for this anywhere. The problem I am having occurs only when the customer is NOT logged into paypal before selecting paypal express as their payment option. Here is the general flow of the order process; 1. - customer finishes their order and selects EXPRESS SHIPPING 2. - Customer selects paypal extress as payment option 3. - customer is taken to paypal where they log in and see their order including EXPRESS SHIPPING (I think they can change this to standard shipping at this point, but we are assuming they do not). Customer confirms order on Paypal site. 4. Customer is sent back to checkout_confirmation.php - where shipping has reverted to STANDARD SHIPPING (with no option to change back to express shipping). Customer confirms order is forced to pay for standard shipping even if they want express. both standard and express Shipping modules are based on the zone based shipping modules and work for other payment modules fine Any help would be greatly appreciated...
  12. THanks for that @clustersolutions I have not been able to get to the website in the last few days, but I think this will help a heap.
  13. Portman

    Separate Pricing Per Customer for Edge

    Hi @raiwa I have installed your app on a clean install of edge so I can play around with it and make sure it does what I want with it... I have come across a problem that makes me think something has gone wrong with my installation... but maybe I am just reading it wrong... I am trying to add multiple groups the instructions say; but I cannot find any reference to wholesale group numbers in there... here is a screenshot Ill be so grateful if this app can work for my requirements, any help would be appreciated.
  14. Portman

    HTML emails?

    Hi @tgely does a github or other link still exist where I can download this addon? all the links I have tried have not worked.
  15. Ok... here goes, SPPC allows you to create a number of customer groups to allow different prices for different customer groups. The default group is 0, then you have groups 1,2,3 etc which are applied on the admin side of the site. as part of the mod an extra field is added to the ‘customers’ table called ‘customers_group_id’ when a new customer creates an account that is set to 0. What I was hoping to do was to modify your app so that it does not show prices if the customer is not logged in, but it also does not show prices if the customers_group_id is 0 (essentially meaning that they don’t see prices and cannot purchase from my site until I have approved them by setting customer_group_id to something other than 0)
  16. Hey @clustersolutions this addon is great and is really what I need for my B2B website... I am wondering if you could give me a few pointers on how to modify it a bit to work for my store - which is strictly Wholesale only . I don't want non authorised members being able to see prices or generate orders . I am using SPPC on my site and would really like to modify 'display price for login members only' so that it checks if the customer is part of the default SPPC group (customers_group_id = 0) so that if they are part of group 0 they are treated as not being logged in. It is only once their status to another SPPC group has been updated in admin that they can see prices. The 'customers_group_id' field is in the customers table so it should not be to hard to do, but I just can't get my head around it - have you got any thoughts on where I should start?
  17. Hi, I am playing around with the responsive 2.3.4 . The only real modification I have done to the original is to try to add SPPC onto it. As I was testing the add on I noticed that when I use the category links on the left the items do not load onto the page. There are essentially enough place holders for the items in the category but they are all blank and when i click on one it says "D'oh. Product not found" - the items are there and loading properly for example i can see them and access them in the new products section. I've looked through index.php and includes/application_top.php but don't think the problem lies there... is there somewhere else I should be looking? any help would be appreciated !
  18. Thanks Hotclutch, hopefully that is the case!
  19. OK... this is where I am at now... I am using EDGE and was trying to adapt the bootstrap edition of SPPC to suit... I drilled down the problem to the catalog/includes/modules/product_listing.php the original EDGE version of this file is VASTLY different to the SPPC bootstrap version and I struggled to know what needed to be modified... anyway I am at the point now where I simply modified the bootstrap version of the file to work within the edge version (Swapping out DIR_WS_IMAGES etc) and it seems to work. However I am worried that in doing this I will find some other negative effect down the path somewhere.
  20. Yeah I have done that and made some minor alterations - Im just trying to locate where the error could be so i can fix it - what parts of the site control what loads up when you choose a category. I also noticed that if I click on the "Would you like to see which new products are available to purchase?" link I get the same problem
  21. Portman

    Updates to osCommerce

    Hi everyone... this is not a complaint, this is a question. I have been noticing of late that there have not been a lot of updates to the core of oscommerce over the past number of years, and I am wondering if there are things I have to do to keep up to date... I am running v2.3.4 and checking updates says I am up to date, but as I look around the forum there is talk of edge and gold and boot strap and other things that I am not sure what they are. there is also talk of a php upgrade that has me a bit concerned I am not really a programmer but I have been learning along the may through using this using this platform and I have really enjoyed it, but the other side of running my business means I don't have the time to keep up to date with all the changes in the computing world. Can someone tell me if there are things i need to do to keep up to date and secure online?? or am I ok? As I said I really enjoy using osCommerce and don't want to change to another platform (in fact I don't think there is a truly open source platform out there that can do what I have been able to accomplish through osCommerce) but if it is becoming dangerously out of date then maybe that's what I need to do .
  22. never mind @burt... found it.... now to make sense of the whole ting
  23. hey @burt... I am still trying to get my head around the whole github thing, but how do i find the edge project... I followed your tutorial on the read me file but I cant find the project you searched up, am i doing something wrong on has it changed?
  24. Portman

    Updates to osCommerce

    Thanks guys, this helps me a lot... good to know it’s not completely dead!
  25. Hi, is there a way or add on to allow me to have stock quantities on some items only. we are a manufacturer so stock levels are irrelevant for most items we sell, but we do purchase some stock with limited numbers (such as books) and need to keep track of these items.