Jump to content

ecartz

♥Ambassador
  • Content count

    3,571
  • Joined

  • Last visited

  • Days Won

    61

Everything posted by ecartz

  1. ecartz

    Virtual Mall 1.2 Support Thread

    I have installed it both ways, but it is intended to be installed first. You may still have to make some changes after the install. Hth, Matt
  2. Can't you just upload the same products_model with two category paths? I.e. two lines that are identical except for the category paths? Hth, Matt
  3. ecartz

    Virtual Mall 1.2 Support Thread

    No, that's how it is supposed to work when you have a store ID set for the login. I haven't done anything with the specials, products attributes, etc. Hth, Matt
  4. ecartz

    Virtual Mall 1.2 Support Thread

    It may help to know that the original concept that I had for this was an online Art Gallery (a project on which I was actually working at one point). In that case, it is reasonable to use the Manufacturer field to store Artist info. The store then could be a separate seller (dealer, agent, etc.). The same issue arises with, for example, a used book store (manufacturer stores author info). Thus my reluctance to hack up the manufacturers' tables into stores' tables in my version of the contribution. The same issue arose with the Products Attributes - Option Type Feature contribution and the File Upload contribution. The file upload contribution actually includes the entire Option Type Feature contribution, but it is still uploaded separately, as Chandra did not feel that all of the existing users would want the added complexity of the File Upload code. Hth, Matt
  5. ecartz

    Master Products - MS2

    Around lines 170 and 179 of includes/modules/master_listing.php, change code that looks like $lc_text = tep_draw_pull_down_menu('Qty_ProdId_' . $listing['products_id'], $qty_array); to something that looks like $lc_text = tep_draw_checkbox_field('Qty_ProdId_' . $listing['products_id'], '1'); This will change it to a checkbox instead of a pull down menu. Checked means purchasing 1. You could also replace the 20s in the code with 1s and get a drop down menu like you describe. Hth, Matt
  6. ecartz

    Virtual Mall 1.2 Support Thread

    I would consider that to be an alternative version rather than an update. You might want to check with John and see what he thinks. I'll send you an email separately (I don't like posting my email address on web sites; however, my email link does work). Cheers, Matt
  7. ecartz

    BTSv1.2 Support

    Try looking here to see how to turn on error reporting. Hth, Matt
  8. ecartz

    Virtual Mall 1.2 Support Thread

    I would call an update version 1.2a or something like that, since it would be bug fixes rather than new functionality. In terms of shipping, my suggested solution would be to include shipping in the product price or implement the individual shipping contribution. Other solutions are possible but not simple (for example, shipping could conceivably be calculated per store with different methods per store). Hth, Matt
  9. ecartz

    Virtual Mall 1.2 Support Thread

    $store_index = $order->products[$i]['store_id'] needs a ; at the end: $store_index = $order->products[$i]['store_id']; Hth, Matt
  10. ecartz

    Admin Access With Levels

    You have to add the new files to the list as Greg did for invoice.php above. Hth, Matt
  11. I would try changing the function to //// // Return a product ID with attributes function tep_get_uprid($prid, $params) { $uprid = $prid; if ( (is_array($params)) && (!strstr($prid, '{')) ) { while (list($option, $value) = each($params)) { //CLR 030714 Add processing around $value. This is needed for text attributes. $value_str = (tep_not_null(stripslashes(trim($value))) ? htmlspecialchars(stripslashes(trim($value)), ENT_QUOTES) : ''); $uprid = $uprid . '{' . $option . '}' . $value_str; } //CLR 030228 Add else stmt to process product ids passed in by other routines. } else { $uprid = htmlspecialchars(stripslashes($uprid), ENT_QUOTES); } if ( (is_array($params)) && (!strstr($prid, '{')) ) { while (list($option, $value) = each($params)) { $uprid = $uprid . '{' . $option . '}' . $value; } } return $uprid; } Hth, Matt
  12. ecartz

    Master Products - MS2

    Around line 207 of advanced_search_result.php, change $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "; to $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_master, p.products_master_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price "; Around line 223, change $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; to $from_str .= " left join " . TABLE_PRODUCTS . " pm on pm.products_master = p.products_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pdm on pm.products_id = pdm.products_id"; $where_str = " where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; Around line 238, change $where_str .= " and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['categories_id'] . "'"; to $where_str .= " and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pdm.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['categories_id'] . "'"; Around lines 258-9, change $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'"; to $where_str .= "(pdm.products_name like '%" . tep_db_input($keyword) . "%' or pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pdm.products_description like '%" . tep_db_input($keyword) . "%' or pd.products_description like '%" . tep_db_input($keyword) . "%'"; I don't think that I made any other changes except adding an index on products_master to the database. Hth, Matt
  13. ecartz

    Virtual Mall 1.2 Support Thread

    Did you get any errors during the osCommerce install? It's saying that it can't find one of the basic osCommerce tables. I would check that the tables were created properly with something like phpMyAdmin. You would upload the Adminstrators.sql file with phpMyAdmin or similar utility. Copy all the PHP files to the equivalent places in the store's admin area. Hth, Matt
  14. ecartz

    EasyPopulate help

    I would start by reading the instructions. :) They suggest that you download a copy of the default database as a complete text file and then upload it back to make sure that it worked. Oh, and don't forget to read the configuration section. Hth, Matt
  15. ecartz

    Flat and Percentage based module does any one need

    If you just want percentage rate shipping, I think that this contribution: http://www.oscommerce.com/community/contributions,1222 will provide it. You process credit cards using a merchant account and a gateway. Some examples of gateways are Authorize.net, PayFlow Pro, and LinkPoint API. The merchant account provider (a bank) should know which gateways they support. Hth, Matt
  16. ecartz

    Master Products - MS2

    Around lines 1360-4 of admin/categories.php: if (isset($HTTP_GET_VARS['search'])) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_master, p.products_master_status, p.products_listing_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by p.products_master"); } else { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_master, p.products_master_status, p.products_listing_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by p.products_master"); } changing the two order by clauses to order by IF(p.products_master_status, p.products_id, p.products_master), p.products_master_status DESC, p.products_id might work. I haven't tried it. That's where you would need to make the changes though. Hth, Matt
  17. It works just fine for me. Are you using a pop up blocker? That could cause problems in some cases. What browser are you using? Hth, Matt
  18. ecartz

    Easy populate and image upload

    Claire, use a graphical FTP program like WS_FTP and you can upload by dragging the images, just like you would drag from folder to folder to copy to a floppy or simply a new folder. Usually the FTP program will need the same login info as the cPanel. Hth, Matt
  19. Dani, It sounds like you are missing some changes to checkout_process.php or includes/classes/order.php. The relevant changes involve using $attr_value Hth, Matt
  20. ecartz

    Virtual Mall 1.2 Support Thread

    I would try checking the query lines. That's where the restriction is. Also check that the store ID is being set by the login process properly. Hth, Matt
  21. Apparently you are using a version intended to be used with the Master Products contribution. Either switch to a different version, edit out the Master Products info, or install Master Products (if you want to use it). Hth, Matt
  22. ecartz

    Master Products - MS2

    To make the search results return the master rather than the slave product, I made the following changes to advanced_search_results.php. Add before line 223: $from_str .= " left join " . TABLE_PRODUCTS . " pm on pm.products_master = p.products_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pdm on pm.products_id = pdm.products_id"; Change line 223 from $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; to $where_str = " where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pdm.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id "; and around lines 258-9, change $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'"; to $where_str .= "(pdm.products_name like '%" . tep_db_input($keyword) . "%' or pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pdm.products_description like '%" . tep_db_input($keyword) . "%' or pd.products_description like '%" . tep_db_input($keyword) . "%'"; For efficiency, I also added a new index on the products_master column of the products table. Hth, Matt
  23. ecartz

    Orders not showing in admin

    Try enabling Force Cookie Use. If you are not using Force Cookie Use, then you have to make sure that the session ID is passed in some other way. Hth, Matt
  24. That is almost always caused by having a catalog file in the languages directory. Catalog files have require('includes/application_top.php'); in them. Hth, Matt
  25. ecartz

    Paymentech Module error

    http://wiki.oscommerce.com/WarnHeader treecomp.inc.php is the file that probably has the extra spaces (around line 168). Sometimes caused during upload. Make sure that it was uploaded as text or ASCII. Hth, Matt
×