Jump to content

dimports

Members
  • Content count

    215
  • Joined

  • Last visited

Posts posted by dimports


  1. Thanks so much. Do all new contributions have to modified to work with the multi-store system (such as adding '.. where stores_id = ' . STORES_ID)? My auctionblox and easypopulate stopped working. I saw my last question in the FAQ :) , but I think this is important to address in there.

     

    Just want to tell you again this is amazing work. I do anticipate with you on osCommerce's template system (if it'll ever come out). But perhaps we can integrate a template system in there in the meantime, such as assigning templates to stores?


  2. I love the whole idea of this contribution. In reality though, it doesn't work 100% correctly.. making it beta of course. Who do we have to pay to get this to work 100%? I am a technology director, but I just dont have time to do it.. time being the keyword. Let me know what we can do about this. Even if we each tackle one problem individually and bring it back to the table. Who's with me?!


  3. I would love to see a 'not' option in the search module. Only 'and' and 'or' and parenthesis. I'm trying to hack the search file to include 'not'. As now, when i search for lion, results of stallion also mixes in my search result. So I want to do 'lion not stallion' to get only lions. This is the section I think the hack takes place in advance_search_result.php:

     

       for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) {
        switch ($search_keywords[$i]) {
          case '(':
          case ')':
          case 'and':
          case 'or':
            $where_str .= " " . $search_keywords[$i] . " ";
            break;
          case 'not':
            $where_str .= " " . $search_keywords[$i] . " ";
            break;
          default:
            $keyword = tep_db_prepare_input($search_keywords[$i]);
            $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) . "%'";
            $where_str .= ")";
            break;
        }
      }
      $where_str .= ")";
    }

     

    If you notice, I copied the 'or' section and just replaced it with 'not'. This is the problem I get:

     

    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 'and (pd.products_name like '%stallion%' or p.products_model lik
    
    select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%lion%' or p.products_model like '%lion%' or m.manufacturers_name like '%lion%') and not and (pd.products_name like '%stallion%' or p.products_model like '%stallion%' or m.manufacturers_name like '%stallion%'))

     

    Why does it automatically put an 'and' before not and after it. It doesn't do that with the 'or'. I know that in the keywords, spaces are converted to 'and', but these ands are out of place. Please help because its driving me nuts! Thanks in advance to all.


  4. I am very suprised that oscommerce didnt come with a 'not' option in the search module. Only 'and' and 'or' and parenthesis. I'm trying to hack the search file to include 'not'. As now, when i search for lion, results of stallion also mixes in my search result. So I want to do 'lion not stallion' to get only lions. This is the section I think the hack takes place in advance_search_result.php:

     

     ? ?for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) {
    ? ? ?switch ($search_keywords[$i]) {
    ? ? ? ?case '(':
    ? ? ? ?case ')':
    ? ? ? ?case 'and':
    ? ? ? ?case 'or':
    ? ? ? ? ?$where_str .= " " . $search_keywords[$i] . " ";
    ? ? ? ? ?break;
    ? ? ? ?case 'not':
    ? ? ? ? ?$where_str .= " " . $search_keywords[$i] . " ";
    ? ? ? ? ?break;
    ? ? ? ?default:
    ? ? ? ? ?$keyword = tep_db_prepare_input($search_keywords[$i]);
    ? ? ? ? ?$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) . "%'";
    ? ? ? ? ?$where_str .= ")";
    ? ? ? ? ?break;
    ? ? ?}
    ? ?}
    ? ?$where_str .= ")";
    ?}

     

    If you notice, I copied the 'or' section and just replaced it with 'not'. This is the problem I get:

     

    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 'and (pd.products_name like '%stallion%' or p.products_model lik
    
    select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%lion%' or p.products_model like '%lion%' or m.manufacturers_name like '%lion%') and not and (pd.products_name like '%stallion%' or p.products_model like '%stallion%' or m.manufacturers_name like '%stallion%'))

     

    Why does it automatically put an 'and' before not and after it. It doesn't do that with the 'or'. I know that in the keywords, spaces are converted to 'and', but these ands are out of place. Please help because its driving me nuts! Thanks in advance to all.


  5. I love this contribution, but there are quite a few bugs especially regarding categories being added and removed from stores. I just cannot get it to work properly. Some cateogries will add ok, others will not. Some can be removed from a store, other cannot. I wish it was a consistent bug so I can pinpoint it, but random bugs are the worst.

     

    Zilla, you are the man. I'd say this is probably on the top 5 best contributions for osCommerce by far. I'm really looking forward to v1.7. Will this version be easy to update from v1.4, or will this require complete uninstall and reinstall of v1.7 due to different framework in place? I'm hoping it will be an easy update so I can begin using 1.7 soon after its release. If you need help devising an installation, please let the board know and I'm sure someone will help. You can PM me too if you'd like. Thanks again for your contribution and further successing the business of us all. :)


  6. I don't like using instant payment with credit cards in case something isn't in stock or shipping calculations isn't provided. So I review all orders before charging the card, then log into Authorize.net and manually enter everything to be charged. I see it beneficial if there was a button while viewing pending credit card orders that would charge the card from the admin side. Of course, it would be a one-time use so multiple charging doesn't occur. Anyone know if this is possible?


  7. I just finished installing this contribution and it seems great. I just can't get it to work properly. When I assign a category to a store, it's viewed under that store fine. But if it so happens that a category has subcategories, the store says theres no products in that subcategory. I tried checking the box for enableing products for all subcategories and products under the admin category screen. But no success. Anyone experience this or have an idea what this is from?


  8. Great contribution! Can someone advise as to how to make pages for these auctions? It take a bunch of time to load all 200 auctions on the same page. I've been trying to take the snippet of code from the prodct listing file. Perhaps someone may tackle it with more success?

     

     
    $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');
    
     if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
    ?>
    ...
    ...
     if ($listing_split->number_of_rows > 0) {
    
    $row = 0;
    $col = 0;
    ...
    ...
       $col ++;
         if ($col > PRODUCT_LIST_COL_NUM-1) {
           $col = 0;
           $row ++;
         }
       }


  9. Here's a suggestion I'm brain storming for:

     

    Each affiliate can assign what price bracket their customer's will see. So all people who go to www.yoursite.com?ref=1, will see prices their referrer set. This will of course would probably effect his commision rate.

     

    Let me know if anyone has any ideas on this..


  10. Hey all. I am trying to pass custom pricing and shipping for certain items. Does anyone know of a contribution or have any suggestions as to how I would pass a price and shipping cost into the shoppping cart for a certain item. This of course would entail the shopping cart to ignore the products SQL table's references to the particular product's prices and would also have the shopping cart ignore the shipping modules and just pass a constant number for the shipping. I'd assume that there has to be a new class created for the shopping cart. Please help!!


  11. Also is there a way to make it so that anyone who makes a purchase in the future from the affiliate, gets credit for it? In this case, cookies would not be sufficient in tracking this. I would like to make it so that any time a customer registers an account, he can put down the referrer and this referrer is stored under the customers database. So anytime the customer places an order, it is credited to that referrer. Is this possible? A good solution?

×