Jump to content

zebraplayer

Members
  • Content count

    47
  • Joined

  • Last visited

1 Follower

About zebraplayer

  • Birthday 06/20/1968

Profile Information

  • Real Name
    Lou
  • Gender
    Male
  • Website
  1. zebraplayer

    Master Products - MS2

    The products I had Master Products installed for do NOT have attributes. This is how the guys is telling me Master Products works. Looking at your image, I see where the Master and Slaves come into play. That does not appear in my instalation. Thanks so much for your help and your images.
  2. zebraplayer

    Master Products - MS2

    Does this contribution have a dedicacated site where I can see screenshots of the admin-side cotrol panel? If not, does anyone have screenshots that they share with me? I am asking because I am paying someone to install this contribution, and I have a feeling they have not done that. I am being told that things are controlled via the Product Attributes page. Does that sound right? Below is the mage of how I am being told the contribution works. Thanks in advance for any clarificaton you can give me on this.
  3. Hello, I have QTPro installed and it works great, except for a big problem. I have my installation set to NOT display the shopping cart after adding a product, so customers never get to product_info.php where the contriution does its magic. Is there anyway to have the QTPro functionality appear on the main catalog page? For example, here index.php?cat=27 I appreciate your help on this. -Lou
  4. zebraplayer

    Does this Contribution exist?

    I just read up on this contribution and I thnk it's the perfect thing for me. Thanks for suggesting it. I would not have been able to find it without your help.
  5. Hello, I have QTPro installed and it works great, except for a big problem. I have my installation set to NOT display the shopping cart after adding a product, so customers never get to product_info.php where the contriution does its magic. Is there anyway to have the QTPro functionality appear on the main catalog page? For example, here index.php?cat=27 I appreciate your help on this. -Lou
  6. I am trying to customize osCommerce to make it into a ticket selling system for a small independent film festival I run. Is there any contribution out there that would allow me to create a product (a movie) and give me the option to tell the system there are two show times for it, for example, (7 & 10 PM), then keep track of the different stock quantities (seats I can sell), and, finally, give the option to the visitor to chose the show time to the screening they want to buy before adding to cart. I know of QTPro, but the problem with it is that I would have to create many, many attributes. Some movies start at 6:50, others at 7, 7:10, etc. Even more show times during the weekend. Is there someting that I could use that would be more efficient than that? I have searched the contributions area, but from reading the desriptions, I cannot find anything that would fit. Even if it's not from this site or I would need to pay for it, can you suggest a solution? Thanks! -Lou
  7. zebraplayer

    PayPal Express Checkout IPN Payment Module

    Just installed PayPal Express Checkout V2.11 put in the Paypal data and everything apears to be working fine. I log into Paypal using a personal account. I get to the "Review Your Information" page and when I press continue I get the following message. I am new at this, so any help would be appreciated. 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_default_address_id from customers where customers_id = [TEP STOP][ Thanks for your time.
  8. zebraplayer

    Missing argument 3 for tep_check_stock()

    Can no one help me with this or point me in the right direction? Any help at all is appreciated.
  9. Hello and thank you for reading. I hope someone can point out what is wrong with the following code. I have searched for others with the same issue and the one guy that had the same problem got no response. Please help! I am getting the following error: Warning: Missing argument 3 for tep_check_stock() in ... /includes/functions/general.php on line 133 Below is the section of code where the error supposedly resides. The uncommented "function" line is line 133. // Check if the required stock is available // If insufficent stock is available return an out of stock message // Yuval - Start - Fix a bug:: check stock per product attribute quantity // function tep_check_stock($products_id, $products_quantity) { function tep_check_stock($products_id,$products_attributes_id, $products_quantity) { $stock_left = tep_get_products_stock($products_id, $products_attributes_id) - $products_quantity; // $stock_left = tep_get_products_stock($products_id) - $products_quantity; // Yuval - End - Fix a bug:: check stock per product attribute quantity Thanks again for your time.
  10. Hello, I was wondering if there exists a credit module that instead of offering a credit of a certain amount, it offer a credit for a certain quantity. For example, instead of giving someone a credit of $20.00, I want to give them a credit to purchase any 5 items. Furthermore, I need to be able to specify which items are elligible for the credit. I know that is kind of specific, but though I'd give the question a try. Thanks in advance for any help you can give me. -zp
  11. Found my own answer. See this post for solution.
  12. Okay. I found the problem. I searched and searched and eventually came to a post from Frost77 which had the answer. In case anyone finds this post before they find that one, here's the culprit: I removed the above-mentioned line and voila! Thanks to everyone for your help. You guys ROCK!!! -zp
  13. The code was not cut-and-pasted. I replaced the original osCommerce file with the one included in the latest contribution's package I downloaded.
  14. The error must be in one of these two additions to the catalog/advanced_search_result.php file. // START: Extra Fields Contribution $from_str = "from (" . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " p2pef on p.products_id=p2pef.products_id) left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c"; // END: Extra Fields Contribution Further down is this: // START: Extra Fields Contribution $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) . "%' or p2pef.products_extra_fields_value like '%" . tep_db_input($keyword) . "%'"; // END: Extra Fields Contribution These are the DB additions required for the contribution: DROP TABLE IF EXISTS products_extra_fields; CREATE TABLE products_extra_fields ( products_extra_fields_id int NOT NULL auto_increment, products_extra_fields_name varchar(64) NOT NULL default '', products_extra_fields_order int(3) NOT NULL default '0', # Change to make the new extra field active by default # products_extra_fields_status tinyint(1) NOT NULL default '0', products_extra_fields_status tinyint(1) NOT NULL default '1', PRIMARY KEY (products_extra_fields_id) ); DROP TABLE IF EXISTS products_to_products_extra_fields; CREATE TABLE products_to_products_extra_fields ( products_id int NOT NULL, products_extra_fields_id int NOT NULL, products_extra_fields_value varchar(64), PRIMARY KEY (products_id,products_extra_fields_id) ); ALTER TABLE `products_extra_fields` ADD `languages_id` INT( 11 ) DEFAULT '0' NOT NULL; Any thoughts?
  15. Yes, I gues something like that is going on. As I've said, I searched the web and one guy had the same error and this is the response he got, which got everything to work: SELECT a.`name`, a.`MT_PK` FROM `tbl_master_items_type` a INNER JOIN `tbl_master_items` b ON a.`MT_PK` = b.`MT_ID` INNER JOIN `tbl_vendor_menu_items` c ON c.`MI_ID` = b.`MI_PK` However, not understanding what the heck this is doing, I cannot translate it to what I need to do. If you know what SQL command I need to run, please pass that info along. As for the possible error with the installation of Products Extra Fields, I've checked and triple checked that baby. The code is as the instructions say it should be. I will quadruple check in case I missed something and post here if I find something, this time. Thank you guys for all your help so far. -zp
×