Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mighty Mike

Archived
  • Posts

    332
  • Joined

  • Last visited

Posts posted by Mighty Mike

  1. Hi expert,

     

    Just curious as how you are doing with the XML Import? I have also started doing this and have got a working PHP Parser to put the values into an array. But, I am not sure on how to implement the inserting/updating of the database.

     

    Any ideas on how i would go about this?

     

    Thanks

     

    Mike

  2. Hi,

     

    Can anybody help me with a change i need to do?

     

    if ($authorised === true) {

    tep_redirect(tep_href_link(FILENAME_CHECKOUT_PROCESS, 'protx_id='.$protx_id, 'SSL'));

    } else {

    tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error=protx_direct&error=' . urlencode($error_detail), 'SSL', true, false));

    }

     

    I need to change this statement so that the redirect goes to a certain page dependent upon the products category..

     

    Ie. "if $authorised === true 'and' $categories_id = 'xxx' goto FILENAME_CHECKOUT_PROCESS_XXX else FILENAME_CHECKOUT_PROCESS"

     

    Is there an easy way to do this? is the $categories_id available to use?

     

    Thanks to anyone who can shed any light on how to do this...

  3. Hi

     

    Hope someone can help me out here. What i am trying to do is remove a category from the all products page.

     

    With my old page i had the following sql

    $products_query = tep_db_query("SELECT p.products_id, pd.products_short, pd.products_name, pc.categories_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where pc.categories_id <> '87' AND p.products_id = pd.products_id AND p.products_id = pc.products_id AND p.products_status = 1 AND pd.language_id = " . $languages_id . " " . $where . " order by pd.products_name");

     

    As you can see i have

    TABLE_PRODUCTS_TO_CATEGORIES . " pc where pc.categories_id <> '87'
    in there which removes that category.

     

    I am having some difficulty in adding that statement into the new query

    $listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name";

     

    Can anybody point me in the right direction, i have been attempting to do it for hours now but no luck :(

     

    Thanks

  4. Hi Mike,

     

    Yeah like yours but yours looks even better.

     

    Is this standard for all products or can you apply it to single products?

     

    Any chance of sharing the code?

     

    Thanks

     

    Mark

     

    Mark,

     

    ill be on msn from 6ish tonight, ill explain then and show you my code. I have it so it shows on all product pages, not sure if it can be done for a single product tho, maybe with an if statement (display this else display that). ill speak to you l8r m8

     

    cheers

     

    mike

  5. Hi,

     

    has anyone successfully integrated this into a heavily modifies product_info file as I am really struggling to get this sorted.

     

    If you can help me then please let me know and I will either post the code or pm it to you.

     

    Thanks

     

    Mark

     

     

    Mark,

     

    What does this contrib do? anything like what my product pages look like?

     

    Mike

  6. Hi

     

    Replace

    $plain .= "Description='" . STORE_NAME . "'&";

     

    With

    for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
    $products_ordered = $order->products[$i]['qty'] . ' x ' . $order->products[$i]['name'] . ' = ' . $currencies->display_price($order->products[$i]['final_price'], $order->products[$i]['tax'], $order->products[$i]['qty']) . $products_ordered_attributes . "\n";
    	 }
         $plain .= "Description='" . $products_ordered . " from " . STORE_NAME . "'&";

     

    I think that should work a bit better for ya

     

    cheers

  7. I would recommend that you upgrade all the way to the latest v2.1c

     

    Once you do go to the admin control panel and de-activate the redirect script.

     

    Then, leave the "old" redirect code in place from the v1.4 install you have now.  This will effectively keep what works on your store working (the redirects) and get the benefits of the new code base (which are verified to be compatible).

     

    If you don't have the old redirect script in place then there is nothing that should be stopping you from upgrading.

     

    With respect to this "Bobby" character...it is a shame but I'm sure he will miss the community and look beyond the political bullshit (and forgive the ones that trashed him after he was gone) and find some way of helping the ones that matter...the store owners...even if that means he has to sneak around.  Of course, I don't know the man but know his kind.  Words like integrity, dedication, duty, loyalty and honor actually still mean something.

     

    BeTheWater

     

     

    Cheers BeTheWater (What film is that out of?) :blink:

     

    Did the upgrade to 2.0b and all is working fine now :D All my indexed pages are with the SEO urls and also the site is not live yet so i dont need the redirect script.

    I will upgrade it again soon.

     

    Would i need to resubmit my pages to google again? or what we are doing is just telling google to use these pages for links/crawl.?

     

    Thanks for your help

     

    Cheers

     

    Mike :thumbsup:

  8. Dennis,

     

    One very handy feature would be for the store owner to have the ability to see all of the items in the customers wishlist.

     

    As the wishlist (to some degree) effects stock in hand, the store owner would get a good idea of what items he may need to stock up on. You could have a case where 50 customers have the same item in their wishlist and within a week it gets purchased.

     

    Maybe some kind of report? I know you could just do this in excel and pull in the info from the db but i think it would be a handy feature to have it in the admin section.

     

    What you think?

  9. I've just tried to install this contrib. Putting all the manual changes in the file was obviously not a big problem, but when I tried to load the down_for_maintenance_v1.1_english.sql file via phpMyAdmin, I get the following error:

    Error
    
    SQL-query :  
    
    INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) 
    VALUES (
    '16', 'Site Maintenance', 'Site Maintenance Options', '16', '1'
    ) 
    
    MySQL said: 
    #1062 - Duplicate entry '16' for key 1

     

    I'm open for any suggestion how to solve this.

     

    Thanks,

     

     

    It may be because you already have someting in your configuration table with "16" change the "16" to something else like "55" or just look in your config table and see which is the next available number

  10. Panda,

     

    I also had an issue when i turned register globals off with the wishlist contrib where no product id was being passed to the db. Have you tried the "HANDY HINT FOR FINDING REGISTER GLOBALS PROBLEMS AND SOME BUG-HUNTING TIPS" on page 4 this might be a good place to start.

×
×
  • Create New...