Jump to content

InfoHaven

Members
  • Content count

    14
  • Joined

  • Last visited

Profile Information

  • Real Name
    James Stoffel
  1. InfoHaven

    [contribution] Super Download Store

    I am having the same problem, except my file is 28MB but only arriving at 17MB to maybe 23MB - differs each time. I've increased the settings in my PHP.ini file and have incorporate the above header code change to my download.php, but still get a corrupted download. I've looked at the entire thread, found reference to readfile_chunk, however, this code is not in the SDS v1.1 download.php file. Was it taken out as not needed? Or is the code different based on file sizes being downloaded? Any help in getting a 28MB file downloaded in its entirety is greatly appreciated! Thanks in advance!!!
  2. InfoHaven

    ebay auction lister

    Hello Dave, I stumbled across this package a few months ago and have been trying to get it working on US Ebay site(s). Currently have integrated the code into an already heavily modded osC site. I had translated a bit of the code, fields, etc.do don't know if you need any feedback on this module, but would love to help. Regards, James.
  3. InfoHaven

    ebay auction lister

    Hello, was wondering if anybody has gotten this to work with their osC site talking to eBay (not eBay.de)? Thanks for any info. James.
  4. InfoHaven

    Attribute Sets Plus

    I'm assuming you imported the SQL tables, and if so, did you double check your tables to ensure they are there and there wasn't any errors on import?
  5. InfoHaven

    Attribute Sets Plus

    Do you have your original catagories.php that you backed up? You should compare the original against the "modified" catagories provided by the contrib. This will help point out what line might have been deleted as I suspect its "original osC" code that was deleted. As I've mentioned before in this support thread, "Beyond Compare" is a good file compare application. Let us know what you find. J.
  6. InfoHaven

    Attribute Sets Plus

    James, is this a "live" site or test? And when you make invisible, I'm assuming you mean you're in the admin area and clicking on the "red" dot. What error are you getting when making the product status green to red? And after a "red" status, does the product still show up in the following link (which it shouldn't): http://yourdomain/index.php?cPath=00 Did you double check your code entries? J.
  7. InfoHaven

    Attribute Sets Plus

    To those who install this contrib for the first time and get an error, please read the support thread from the very beginning as Chris has pointed out. You'll more than likely find the solution as others have installed this contrib - with and without errors - and have noted their solution if not suggested alterations. Now, if you don't see the solution, then go back and double check your code to ensure you've inserted "every" piece of code verbatim. I suggest using a file compare program such as "Beyond Compare", especially if you're installing this contrib on top of an already modified osC. For example, our "base" shop that we install for our customers has well over fifteen contrib - all working together - including this one. However, it took a bit of extra time to ensure the lines of code from Chris' contrib did not overwrite or conflict with another contrib. Here's a suggested Check List: 1. Backup, backup, backup the affected osC pages 2. Have a "test environment" instead of using a "live" site 3. Read the "readme" thoroughly for the contrib - if not twice 4. Compare each orig page - side by side (again suggesting using Beyond Compare) - with the "new contrib" page and make the necessary code change(s) 5. Insert the provided SQL statement 6. Test as needed in "test environment" 7. If any errors: ?????a. Read the contrib "readme" again to ensure you didn't forget anything ?????b. Read this support thread from the very beginning to the end ?????c. Do a "search" in the osC forum as well, as the error you received may be caused by an accidental omission in the orig osC code, and more than likely, someone has already seen it and provided a solution ?????d. Cross-check your lines of edited code ?????e. Make sure you added the new SQL code correctly - make sure the new tables are there ?????f. And if it is still not working, restore from your backups and start fresh, with a pad of paper and pencil to check off each step Bottom line: Take your time and have patience, and in the end, you'll have an enhanced working store for which your customers will appreciate. Jim.
  8. InfoHaven

    Attribute Sets Plus

    Hello Jason, Look to the product_info.php file (forget what line number...different based on contrib anyways) and look to the the following lines to edit how you'll sort your options or option values: $products_options_name_query = tep_db_query(" select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_id"); Hope this helps. Jim.
  9. InfoHaven

    Attribute Sets Plus

    Hello Mattz0rr, Here is an example of creating the product option all the way to the attribute set. From this example, you should be able to create your own INSERT statement for adding the attri set to the specific product(s). J. # First create the option INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 5, 1 , 'Personalize' , 1 , 15 , 'Enter Moms Maiden Name' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 5, 2 , '' , 1 , 15 , '' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 5, 3 , '' , 1 , 15 , '' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 6, 1 , 'Personalize' , 1 , 15 , 'Enter Child Name' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 6, 2 , '' , 1 , 15 , '' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 6, 3 , '' , 1 , 15 , '' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 7, 1 , 'Personalize' , 1 , 15 , 'Enter Child Birth Month' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 7, 2 , '' , 1 , 15 , '' ); INSERT into products_options (products_options_id , language_id , products_options_name , products_options_type , products_options_length , products_options_comment) VALUES( 7, 3 , '' , 1 , 15 , '' ); # Second - Create the option VALUES for the newly created option # No values to enter as option is a text field # INSERT INTO products_options_VALUES (products_options_VALUES_id , language_id , products_options_VALUES_name) VALUES ( 97 , 1 , 'A' ); # Third - Tie the option value to its respective product option # Since no values to enter as option is a text field, there is no tying the two together # INSERT INTO products_options_VALUES_to_products_options (products_options_VALUES_to_products_options_id, products_options_id, products_options_VALUES_id) VALUES ( 291 , 18 , 97 ); # Fourth - Create the Attribute Set INSERT INTO products_attributes_sets ( products_attributes_sets_id , products_attributes_sets_name , products_options_id, attribute_set_sort ) VALUES ( 14 , 'Personalize Rocks' , 6 , 0 ); INSERT INTO products_attributes_sets ( products_attributes_sets_id , products_attributes_sets_name , products_options_id, attribute_set_sort ) VALUES ( 15 , 'Personalize Circa Birth Month' , 7 , 0 ); INSERT INTO products_attributes_sets ( products_attributes_sets_id , products_attributes_sets_name , products_options_id, attribute_set_sort ) VALUES ( 16 , 'Personalize Circa Birth Year' , 8 , 0 ); # Lastly - Tie the option VALUES (id) to the appropriate Attribute Set's Elements INSERT INTO products_attributes_sets_elements (products_attributes_sets_elements_id, products_attributes_sets_id, options_VALUES_id, options_VALUES_price, price_prefix, sort_order) VALUES ( 27 , 14 , 22 , 0.0000 , '' , 1 ); INSERT INTO products_attributes_sets_elements (products_attributes_sets_elements_id, products_attributes_sets_id, options_VALUES_id, options_VALUES_price, price_prefix, sort_order) VALUES ( 28 , 15 , 22 , 0.0000 , '' , 1 ); INSERT INTO products_attributes_sets_elements (products_attributes_sets_elements_id, products_attributes_sets_id, options_VALUES_id, options_VALUES_price, price_prefix, sort_order) VALUES ( 29 , 16 , 22 , 0.0000 , '' , 1 ); # Import into your SQL DB and then use Admin Panel to tie Attribute Sets to specific Products # or create additional INSERT Statements for tying AS to products. # - Info Haven Productions, Inc. - # Created: Feb 3, 2006
  10. InfoHaven

    Attribute Sets Plus

    With respect to the following lines: $products_options_name_query = tep_db_query(" select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_id"); How do you want to sort you 'options'? I sort by product_options via id key, but you can sort any other way by indicating such in your PHP code. Or you could cheat, by going into the DB and changing the prod option ID...just make sure it is changed to the associated option values and attribute sets. As to assigning to 200 products, I find making a "notepad" DB insert file for applying attrib sets to multiple products easier than one at a time. Simply make the file and then load into DB. Just the way I do it...hope it helps. Jim.
  11. InfoHaven

    Attribute Sets Plus

    Hello Chris, I've been using your contrib for months now (which install without a problem the first time) and my version of osC which I use for all our customers is very, very heavily modded, and I already had the "Options Type" contrib installed prior to adding yours. If I may, I would like to comment that for those looking at this contrib (as well as others) please use a good "file compare" application (such as Beyond Compare) then there should be no problems installing any contribs...provided of course you understand how osC works to begin with (that helps too ;-). ===== On another note, curious if there's a way to "set the order" of how the "sets" appear when tied to a product? I edited the following line: ORDER BY pas.products_attributes_sets_id,pase.sort_order"); however it doesn't sort by sets like I assumed...if someone could comment and/or suggest, it would be appreciated. Thanks again for a great contrib! Jim Stoffel
  12. InfoHaven

    Attribute Sets Plus

    Hello Chris, Just used your contrib - and mind you my client's store is heavily modded - and it worked like a charm! Also, with respect to Options Types contrib - already had it installed and installed you contrib on top with no problem; I would just recommend to any other developer to use a "good" file-compare application to avoid any problems. ========= Now with a question for Chris or anybody else out there ;-) Is there a way to create "an option" - one option with some values, and create different "attribute sets" off the one option in such a way so that when tied to a product, they appear independantly? For example, I create an option called message (set as "select") with say five different values (hello, cool, etc). Then I create the A.S. Now the tricky part is that the product can have more than one message - now if I create the diff A.S. called Message 1, 2, etc, the product will only display "one" option and the "select" drop-down will show all the variables repeated. Did I explain it OK? ========= Thanks again for a great contrib! Jim.
×